reports
Data license: ODbL · Data source: West Midlands Police
- id
- {'label': 'ID'}
- source_file
- {'label': 'Source PDF'}
- source_page
- {'label': 'Page'}
- source_row
- {'label': 'Row'}
- month
- {'label': 'Month'}
- reporter_transport_mode
- {'label': 'Reporter'}
- vehicle_make
- {'label': 'Make'}
- vehicle_model
- {'label': 'Model'}
- vehicle_colour
- {'label': 'Colour'}
- offence
- {'label': 'Offence'}
- second_offence
- {'label': 'Second offence'}
- offence_location_raw
- {'label': 'Location (raw)'}
- offence_location
- {'label': 'Location'}
- council_area_raw
- {'label': 'Council (raw)'}
- council_area
- {'label': 'Council area'}
- disposal
- {'label': 'Outcome'}
- nfa_rationale
- {'label': 'NFA reason'}
- witness_contacted
- {'label': 'Witness contacted'}
- latitude
- {'label': 'Lat'}
- longitude
- {'label': 'Lng'}
215 rows where disposal = "Fixed Penalty" and month = "2025-06" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 27
offence 20
- Using a Mobile Phone Whilst Driving 76
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 36
- Driving without Due Care and Attention 31
- Contravening a Red Traffic Light 16
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 14
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 10
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 7
- Stop a vehicle within pelican pedestrian crossing limits 7
- No Insurance 4
- Driving without Reasonable Consideration 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Stop a vehicle on pedestrian crossing 2
- Cause vehicle to be left in a dangerous position 1
- Contravene Lane Closure Red X 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Driving a vehicle wholly or partly on a footpath 1
- Keeping a vehicle with registration marks obscured 1
- Misc - Non Traffic Offences 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- Use vehicle on a road without valid test certificate 1
council_area 10
- Birmingham 148
- Solihull 13
- Coventry 12
- Dudley 11
- Sandwell 10
- Sutton Coldfield 6
- Walsall 5
- Wolverhampton 5
- Halesowen 3
- Metropolitan Borough 2
reporter_transport_mode 6
- Car 91
- Pedal Bike 55
- Pedestrian 53
- Other 11
- Motorbike 3
- Lorry 2
month 1
- 2025-06 · 215 ✖
disposal 1
- Fixed Penalty · 215 ✖
| id | source_file | source_page | source_row | month ▲ | reporter_transport_mode | vehicle_make | vehicle_model | vehicle_colour | offence | second_offence | offence_location_raw | offence_location | council_area_raw | council_area | disposal | nfa_rationale | witness_contacted | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14071 | op-snap---monthly-publication-june-2025.pdf | 0 | 2025-06 | Pedestrian | Dodge | Blue | Cause vehicle to be left in a dangerous position | None | Heath Green Road | Heath Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4873353 | -1.9407986 | |||
| 14073 | op-snap---monthly-publication-june-2025.pdf | 2 | 2025-06 | Pedal Bike | Toyota | Corolla | Black | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4591339 | -1.9601054 | ||
| 14077 | op-snap---monthly-publication-june-2025.pdf | 6 | 2025-06 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4428606 | -1.812114 | ||
| 14079 | op-snap---monthly-publication-june-2025.pdf | 8 | 2025-06 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Broadway | Broadway | Walsall | Walsall | Fixed Penalty | N/A | 52.5719937 | -1.9639882 | ||
| 14091 | op-snap---monthly-publication-june-2025.pdf | 20 | 2025-06 | Pedestrian | BMW | X1 | White | Using a Mobile Phone Whilst Driving | None | alcester Road | alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 14092 | op-snap---monthly-publication-june-2025.pdf | 21 | 2025-06 | Pedestrian | Toyota | HIACE | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | BOWDEN ROAD | Bowden Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14096 | op-snap---monthly-publication-june-2025.pdf | 25 | 2025-06 | Car | Renault | CLIO | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | ALBANY ROAD | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4006218 | -1.5284125 | ||
| 14104 | op-snap---monthly-publication-june-2025.pdf | 33 | 2025-06 | Pedal Bike | Nissan | QASHQUI | Grey | Using a Mobile Phone Whilst Driving | None | ALCESTER ROAD | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 14110 | op-snap---monthly-publication-june-2025.pdf | 39 | 2025-06 | Pedal Bike | Ford | Kuga | Silver | Using a Mobile Phone Whilst Driving | None | Oxford Road | Oxford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4456323 | -1.8858352 | ||
| 14111 | op-snap---monthly-publication-june-2025.pdf | 40 | 2025-06 | Car | BMW | M | Grey | Driving without Due Care and Attention | None | CAKMORE ROAD | Cakmore Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 14116 | op-snap---monthly-publication-june-2025.pdf | 45 | 2025-06 | Pedal Bike | Ford | kUGA | Black | Using a Mobile Phone Whilst Driving | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 14118 | op-snap---monthly-publication-june-2025.pdf | 47 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14121 | op-snap---monthly-publication-june-2025.pdf | 50 | 2025-06 | Pedal Bike | Kia | Sportage | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Road | Shenley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4373076 | -1.9543847 | ||
| 14143 | op-snap---monthly-publication-june-2025.pdf | 72 | 2025-06 | Car | Hyundai | Bayon | Black | Driving without Due Care and Attention | None | Farnborough Road | Farnborough Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5148331 | -1.79231 | ||
| 14159 | op-snap---monthly-publication-june-2025.pdf | 88 | 2025-06 | Pedal Bike | Volkswagen | UP | Blue | Using a Mobile Phone Whilst Driving | None | HIGHFIELD ROAD | Highfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4216321 | -1.855984 | ||
| 14160 | op-snap---monthly-publication-june-2025.pdf | 89 | 2025-06 | Pedestrian | Fiat | 500 | Blue | Driving without Due Care and Attention | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5390972 | -1.9319478 | ||
| 14162 | op-snap---monthly-publication-june-2025.pdf | 91 | 2025-06 | Car | Toyota | Corolla | White | Using a Mobile Phone Whilst Driving | None | Newtoen Road | Newtoen Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 14180 | op-snap---monthly-publication-june-2025.pdf | 109 | 2025-06 | Other | Renault | Megane | Black | Use vehicle on a road without valid test certificate | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5390972 | -1.9319478 | ||
| 14181 | op-snap---monthly-publication-june-2025.pdf | 110 | 2025-06 | Car | Jaguar | XF.. | Black | No Insurance | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4929304 | -1.8229092 | ||
| 14198 | op-snap---monthly-publication-june-2025.pdf | 127 | 2025-06 | Car | Honda | CRV | White | Contravening a Red Traffic Light | None | a38 | A38 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14213 | op-snap---monthly-publication-june-2025.pdf | 142 | 2025-06 | Car | Audi | s3 | Grey | Driving without Due Care and Attention | None | M6 J7 to 6 | M6 J7 to 6 | Birmingham | Birmingham | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 14234 | op-snap---monthly-publication-june-2025.pdf | 163 | 2025-06 | Other | BMW | 530 | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 14235 | op-snap---monthly-publication-june-2025.pdf | 164 | 2025-06 | Other | Audi | Q7 | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 14239 | op-snap---monthly-publication-june-2025.pdf | 168 | 2025-06 | Pedal Bike | Audi | A3 | Black | Using a Mobile Phone Whilst Driving | None | Pebble Mill Road | Pebble Mill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4512925 | -1.9124618 | ||
| 14240 | op-snap---monthly-publication-june-2025.pdf | 169 | 2025-06 | Pedal Bike | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4167654 | -1.9411244 | ||
| 14242 | op-snap---monthly-publication-june-2025.pdf | 171 | 2025-06 | Pedal Bike | Volkswagen | Tiguan | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Newhall Street | Newhall Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830482 | -1.905069 | ||
| 14243 | op-snap---monthly-publication-june-2025.pdf | 172 | 2025-06 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | Brighton Road | Brighton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543156 | -1.8840717 | ||
| 14254 | op-snap---monthly-publication-june-2025.pdf | 183 | 2025-06 | Pedestrian | Mercedes-Benz | A180 | Brown | Using a Mobile Phone Whilst Driving | None | Islington Row | Islington Row | Birmingham | Birmingham | Fixed Penalty | N/A | 52.472238 | -1.9127983 | ||
| 14255 | op-snap---monthly-publication-june-2025.pdf | 184 | 2025-06 | Pedestrian | Hyundai | I10 | Red | Contravening a Red Traffic Light | None | Coombs Road | Coombs Road | Halesowen | Halesowen | Fixed Penalty | N/A | 52.4596073 | -2.0500011 | ||
| 14256 | op-snap---monthly-publication-june-2025.pdf | 185 | 2025-06 | Motorbike | Mini | Cooper | Green | Using a Mobile Phone Whilst Driving | None | Lincoln St | Lincoln Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459298 | -1.8933648 | ||
| 14264 | op-snap---monthly-publication-june-2025.pdf | 193 | 2025-06 | Car | Toyota | Prius | Red | Driving without Due Care and Attention | None | St Michaels Rd | Street Michaels Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14272 | op-snap---monthly-publication-june-2025.pdf | 201 | 2025-06 | Car | Volkswagen | Polo | Black | Contravening a Red Traffic Light | None | Winson Green Road | Winson Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4870332 | -1.9373713 | ||
| 14273 | op-snap---monthly-publication-june-2025.pdf | 202 | 2025-06 | Pedestrian | Mercedes-Benz | A180. | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | No Insurance | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 14281 | op-snap---monthly-publication-june-2025.pdf | 210 | 2025-06 | Pedal Bike | BMW | X1 | Grey | Driving without Due Care and Attention | No Insurance | Holders Lane | Holders Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4446701 | -1.9056872 | ||
| 14283 | op-snap---monthly-publication-june-2025.pdf | 212 | 2025-06 | Pedal Bike | Nissan | Note | Black | Using a Mobile Phone Whilst Driving | None | Cateswell Road | Cateswell Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4387009 | -1.8454267 | ||
| 14285 | op-snap---monthly-publication-june-2025.pdf | 214 | 2025-06 | Pedal Bike | Audi | A1 | Black | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 14292 | op-snap---monthly-publication-june-2025.pdf | 221 | 2025-06 | Car | Porsche | Cayenne | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14294 | op-snap---monthly-publication-june-2025.pdf | 223 | 2025-06 | Pedal Bike | Mazda | 3 | Silver | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard, Selly Oak | Aston Webb Boulevard, Selly Oak | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4443904 | -1.9419231 | ||
| 14296 | op-snap---monthly-publication-june-2025.pdf | 225 | 2025-06 | Car | Peugeot | 208 | Grey | Driving without Due Care and Attention | None | KINGSTON ROAD | Kingston Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4747333 | -1.8728345 | ||
| 14309 | op-snap---monthly-publication-june-2025.pdf | 238 | 2025-06 | Car | Nissan | Juke | Silver | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4668753 | -1.8996143 | ||
| 14310 | op-snap---monthly-publication-june-2025.pdf | 239 | 2025-06 | Pedestrian | Vauxhall | Mokka | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place | Regent Place | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4860376 | -1.9095854 | ||
| 14318 | op-snap---monthly-publication-june-2025.pdf | 247 | 2025-06 | Pedestrian | Mercedes-Benz | C220 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 14322 | op-snap---monthly-publication-june-2025.pdf | 251 | 2025-06 | Pedestrian | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood Leisure Centre | Ladywood Leisure Centre | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4790242 | -1.9274592 | ||
| 14323 | op-snap---monthly-publication-june-2025.pdf | 252 | 2025-06 | Pedestrian | Audi | A6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monument Road | Monument Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4731312 | -1.930947 | ||
| 14339 | op-snap---monthly-publication-june-2025.pdf | 268 | 2025-06 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4668753 | -1.8996143 | ||
| 14355 | op-snap---monthly-publication-june-2025.pdf | 284 | 2025-06 | Pedestrian | Audi | A3 | Grey | Using a Mobile Phone Whilst Driving | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5899123 | -1.8057069 | ||
| 14362 | op-snap---monthly-publication-june-2025.pdf | 291 | 2025-06 | Car | Mini | Cooper | Red | Driving without Reasonable Consideration | None | Stratford Road | Stratford Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4191184 | -1.8326637 | ||
| 14369 | op-snap---monthly-publication-june-2025.pdf | 298 | 2025-06 | Pedal Bike | Mini | Cooper | Black | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 14372 | op-snap---monthly-publication-june-2025.pdf | 301 | 2025-06 | Pedal Bike | Peugeot | 208 | Black | Misc - Non Traffic Offences | No Insurance | TAUNTON ROAD | Taunton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4531128 | -1.875763 | ||
| 14376 | op-snap---monthly-publication-june-2025.pdf | 305 | 2025-06 | Pedal Bike | Audi | A1 | White | Using a Mobile Phone Whilst Driving | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 14377 | op-snap---monthly-publication-june-2025.pdf | 306 | 2025-06 | Pedal Bike | Volvo | XC40 | Black | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4943878 | -1.8504211 | ||
| 14412 | op-snap---monthly-publication-june-2025.pdf | 341 | 2025-06 | Car | BMW | 218I | Black | Driving without Due Care and Attention | None | Olton Road | Olton Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4193964 | -1.8252207 | ||
| 14416 | op-snap---monthly-publication-june-2025.pdf | 345 | 2025-06 | Pedal Bike | Vauxhall | Corsa | White | Using a Mobile Phone Whilst Driving | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4760986 | -1.9018641 | ||
| 14455 | op-snap---monthly-publication-june-2025.pdf | 384 | 2025-06 | Car | Ford | Mondeo | Silver | No Insurance | None | Norris Way | Norris Way | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5626811 | -1.8151467 | ||
| 14457 | op-snap---monthly-publication-june-2025.pdf | 386 | 2025-06 | Pedal Bike | Mercedes-Benz | C180 | Silver | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4591339 | -1.9601054 | ||
| 14460 | op-snap---monthly-publication-june-2025.pdf | 389 | 2025-06 | Car | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 14461 | op-snap---monthly-publication-june-2025.pdf | 390 | 2025-06 | Car | Land Rover | Vogue | Black | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5083238 | -1.8332287 | ||
| 14464 | op-snap---monthly-publication-june-2025.pdf | 393 | 2025-06 | Car | Land Rover | Range Rover | Grey | Driving without Due Care and Attention | None | Stratford Road Shirley | Stratford Road Shirley | Solihull | Solihull | Fixed Penalty | N/A | 52.4171404 | -1.830877 | ||
| 14492 | op-snap---monthly-publication-june-2025.pdf | 421 | 2025-06 | Car | Skoda | Octivia | Silver | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5531351 | -1.8852761 | ||
| 14497 | op-snap---monthly-publication-june-2025.pdf | 426 | 2025-06 | Lorry | Vauxhall | Vivaro | Silver | No Insurance | None | Stafford Road, Darlaston | Stafford Road, Darlaston | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 14500 | op-snap---monthly-publication-june-2025.pdf | 429 | 2025-06 | Car | Land Rover | Defender | Blue | Using a Mobile Phone Whilst Driving | None | M42 NB J6 | M42 Northbound J6 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14505 | op-snap---monthly-publication-june-2025.pdf | 434 | 2025-06 | Other | Renault | Truck | White | Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway | None | M42 N towards J 6 | M42 N towards J 6 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14509 | op-snap---monthly-publication-june-2025.pdf | 438 | 2025-06 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Bridgenorth Road | Bridgenorth Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 14524 | op-snap---monthly-publication-june-2025.pdf | 453 | 2025-06 | Motorbike | Audi | A1 | Black | Driving without Due Care and Attention | None | College Road | College Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5151832 | -1.9361664 | ||
| 14569 | op-snap---monthly-publication-june-2025.pdf | 498 | 2025-06 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14570 | op-snap---monthly-publication-june-2025.pdf | 499 | 2025-06 | Pedestrian | Land Rover | Defednder | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14571 | op-snap---monthly-publication-june-2025.pdf | 500 | 2025-06 | Car | Toyota | Corolla | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | darwin St | darwin Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.468128 | -1.8848315 | ||
| 14591 | op-snap---monthly-publication-june-2025.pdf | 520 | 2025-06 | Pedestrian | Mercedes-Benz | A180 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4027335 | -1.876125 | ||
| 14600 | op-snap---monthly-publication-june-2025.pdf | 529 | 2025-06 | Car | Volkswagen | Tiguan | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane, Erdington | Holly Lane, Erdington | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5214354 | -1.8218582 | ||
| 14602 | op-snap---monthly-publication-june-2025.pdf | 531 | 2025-06 | Car | Volkswagen | Touran | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane, Erdington | Holly Lane, Erdington | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5214354 | -1.8218582 | ||
| 14604 | op-snap---monthly-publication-june-2025.pdf | 533 | 2025-06 | Car | Renault | Clio | Black | No Insurance | None | Holly Lane, Erdington | Holly Lane, Erdington | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5214354 | -1.8218582 | ||
| 14616 | op-snap---monthly-publication-june-2025.pdf | 545 | 2025-06 | Pedestrian | BMW | I4 | White | Stop a vehicle within pelican pedestrian crossing limits | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 14619 | op-snap---monthly-publication-june-2025.pdf | 548 | 2025-06 | Pedestrian | Seat | Alto | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.436035 | -1.891685 | ||
| 14622 | op-snap---monthly-publication-june-2025.pdf | 551 | 2025-06 | Pedestrian | Toyota | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Great Charles Street | Great Charles Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4837518 | -1.901874 | |||
| 14624 | op-snap---monthly-publication-june-2025.pdf | 553 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.417344 | -1.5264979 | ||
| 14625 | op-snap---monthly-publication-june-2025.pdf | 554 | 2025-06 | Pedestrian | Land Rover | Range Rover | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14633 | op-snap---monthly-publication-june-2025.pdf | 562 | 2025-06 | Pedestrian | Iveco | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avenue Road, Kings Heath | Avenue Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4328354 | -1.8999608 | |||
| 14634 | op-snap---monthly-publication-june-2025.pdf | 563 | 2025-06 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | New Street, Frankley | New Street, Frankley | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4041101 | -2.0086912 | ||
| 14635 | op-snap---monthly-publication-june-2025.pdf | 564 | 2025-06 | Pedestrian | Porsche | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Rd | Howard Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5154198 | -1.9135452 | |||
| 14673 | op-snap---monthly-publication-june-2025.pdf | 602 | 2025-06 | Pedal Bike | Audi | Q4.. | Blue | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 14676 | op-snap---monthly-publication-june-2025.pdf | 605 | 2025-06 | Car | BMW | X1 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Dudley St | Dudley Street | Dudley | Dudley | Fixed Penalty | N/A | 52.540391 | -2.1211076 | ||
| 14695 | op-snap---monthly-publication-june-2025.pdf | 624 | 2025-06 | Car | Volvo | S90... | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fallwofield Road | Fallwofield Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 14703 | op-snap---monthly-publication-june-2025.pdf | 632 | 2025-06 | Car | Audi | A1 | Grey | Using a Mobile Phone Whilst Driving | None | New Hampton Road East | New Hampton Road East | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | 52.5920541 | -2.1374052 | ||
| 14717 | op-snap---monthly-publication-june-2025.pdf | 646 | 2025-06 | Pedal Bike | Fiat | Punto | Blue | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Toad | Stoney Stanton Toad | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 14729 | op-snap---monthly-publication-june-2025.pdf | 658 | 2025-06 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4428606 | -1.812114 | ||
| 14730 | op-snap---monthly-publication-june-2025.pdf | 659 | 2025-06 | Pedal Bike | Ford | Fiesta | Blue | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 14731 | op-snap---monthly-publication-june-2025.pdf | 660 | 2025-06 | Pedal Bike | Skoda | KAROQ | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 14733 | op-snap---monthly-publication-june-2025.pdf | 662 | 2025-06 | Pedal Bike | Tesla | Model 3 | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14734 | op-snap---monthly-publication-june-2025.pdf | 663 | 2025-06 | Car | Tesla | Model 3 | White | Using a Mobile Phone Whilst Driving | None | Manor Way | Manor Way | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5203602 | -1.824434 | ||
| 14765 | op-snap---monthly-publication-june-2025.pdf | 694 | 2025-06 | Car | Vauxhall | Vivaro | Silver | Contravene Lane Closure Red X | None | Gospel End Road (Sedgley) | Gospel End Road (Sedgley) | Dudley | Dudley | Fixed Penalty | N/A | 52.5392439 | -2.1282642 | ||
| 14771 | op-snap---monthly-publication-june-2025.pdf | 700 | 2025-06 | Pedal Bike | Vauxhall | Corsa | Silver | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 14776 | op-snap---monthly-publication-june-2025.pdf | 705 | 2025-06 | Pedal Bike | BMW | 420 | Black | Using a Mobile Phone Whilst Driving | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4749336 | -1.9003475 | ||
| 14778 | op-snap---monthly-publication-june-2025.pdf | 707 | 2025-06 | Pedal Bike | Peugeot | 2008.. | Orange | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 14780 | op-snap---monthly-publication-june-2025.pdf | 709 | 2025-06 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 14783 | op-snap---monthly-publication-june-2025.pdf | 712 | 2025-06 | Car | Audi | A1 | Grey | Using a Mobile Phone Whilst Driving | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Fixed Penalty | N/A | 52.5002997 | -2.1081386 | ||
| 14812 | op-snap---monthly-publication-june-2025.pdf | 741 | 2025-06 | Car | Seat | Leon | Silver | Contravening a Red Traffic Light | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4929304 | -1.8229092 | ||
| 14815 | op-snap---monthly-publication-june-2025.pdf | 744 | 2025-06 | Car | Kia | Sportage | Black | Using a Mobile Phone Whilst Driving | None | Longdon Road | Longdon Road | Solihull | Solihull | Fixed Penalty | N/A | 52.389832 | -1.7492294 | ||
| 14821 | op-snap---monthly-publication-june-2025.pdf | 750 | 2025-06 | Car | Peugeot | Partner | White | Using a Mobile Phone Whilst Driving | None | School Road | School Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4161736 | -1.8619692 | ||
| 14824 | op-snap---monthly-publication-june-2025.pdf | 753 | 2025-06 | Car | Seat | Ateca | Grey | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 14831 | op-snap---monthly-publication-june-2025.pdf | 760 | 2025-06 | Other | Renault | Traffic | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | none | Noorwood Road | Noorwood Road | Dudley | Dudley | Fixed Penalty | N/A |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE reports (
id INTEGER PRIMARY KEY AUTOINCREMENT,
source_file TEXT NOT NULL,
source_page INTEGER,
source_row INTEGER,
month TEXT NOT NULL,
reporter_transport_mode TEXT,
vehicle_make TEXT,
vehicle_model TEXT,
vehicle_colour TEXT,
offence TEXT,
second_offence TEXT,
offence_location_raw TEXT,
offence_location TEXT,
council_area_raw TEXT,
council_area TEXT,
disposal TEXT,
nfa_rationale TEXT,
witness_contacted TEXT
, latitude REAL, longitude REAL);
CREATE INDEX idx_month ON reports(month);
CREATE INDEX idx_council_area ON reports(council_area);
CREATE INDEX idx_offence ON reports(offence);
CREATE INDEX idx_disposal ON reports(disposal);
CREATE INDEX idx_location ON reports(offence_location);