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'}
148 rows where council_area = "Birmingham", disposal = "Fixed Penalty" and month = "2025-06" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence
vehicle_make 26
offence 18
- Using a Mobile Phone Whilst Driving 59
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 26
- Driving without Due Care and Attention 19
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 12
- Contravening a Red Traffic Light 11
- Stop a vehicle within pelican pedestrian crossing limits 5
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- No Insurance 2
- Cause vehicle to be left in a dangerous position 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Driving without Reasonable Consideration 1
- Keeping a vehicle with registration marks obscured 1
- Misc - Non Traffic Offences 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Stop a vehicle on pedestrian crossing 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
reporter_transport_mode 5
- Car 52
- Pedal Bike 48
- Pedestrian 40
- Other 5
- Motorbike 3
month 1
- 2025-06 · 148 ✖
disposal 1
- Fixed Penalty · 148 ✖
council_area 1
- Birmingham · 148 ✖
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 14853 | op-snap---monthly-publication-june-2025.pdf | 782 | 2025-06 | Other | Citroen | C1 | Red | Using a Mobile Phone Whilst Driving | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4726661 | -1.8769032 | ||
| 14867 | op-snap---monthly-publication-june-2025.pdf | 796 | 2025-06 | Car | Land Rover | Range Rover | Grey | Contravening a Red Traffic Light | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14884 | op-snap---monthly-publication-june-2025.pdf | 813 | 2025-06 | Car | BMW | M235 | White | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5517052 | -1.7825505 | ||
| 14907 | op-snap---monthly-publication-june-2025.pdf | 836 | 2025-06 | Car | Volvo | HGC | White | Driving without Due Care and Attention | None | M6 North, Jct 10/10a | M6 North, Junction 10/10a | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14911 | op-snap---monthly-publication-june-2025.pdf | 840 | 2025-06 | Motorbike | Audi | Q3 | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4656414 | -1.9852276 | ||
| 14932 | op-snap---monthly-publication-june-2025.pdf | 861 | 2025-06 | Pedal Bike | BMW | 320d | Black | Using a Mobile Phone Whilst Driving | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.430111 | -1.9753703 | ||
| 14939 | op-snap---monthly-publication-june-2025.pdf | 868 | 2025-06 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bishopsgte Street | Bishopsgte Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14948 | op-snap---monthly-publication-june-2025.pdf | 877 | 2025-06 | Car | BMW | X5 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5170745 | -1.9012542 | ||
| 14950 | op-snap---monthly-publication-june-2025.pdf | 879 | 2025-06 | Car | Hyundai | I10 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5170745 | -1.9012542 | ||
| 14951 | op-snap---monthly-publication-june-2025.pdf | 880 | 2025-06 | Car | Toyota | Aygo | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5170745 | -1.9012542 | ||
| 14956 | op-snap---monthly-publication-june-2025.pdf | 885 | 2025-06 | Pedestrian | Toyota | Aygo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brandwood park Road | Brandwood park Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4138206 | -1.9041686 | ||
| 14972 | op-snap---monthly-publication-june-2025.pdf | 901 | 2025-06 | Pedestrian | Mercedes-Benz | E220 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heeley Road | Heeley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4401847 | -1.9331572 | ||
| 14976 | op-snap---monthly-publication-june-2025.pdf | 905 | 2025-06 | Pedestrian | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Kings heath high st at Institute Road | Kings heath high st at Institute Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4391028 | -1.893289 | ||
| 14995 | op-snap---monthly-publication-june-2025.pdf | 924 | 2025-06 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle on pedestrian crossing | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4437078 | -1.8783408 | ||
| 14998 | op-snap---monthly-publication-june-2025.pdf | 927 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5206297 | -1.9208426 | ||
| 15020 | op-snap---monthly-publication-june-2025.pdf | 949 | 2025-06 | Car | Hyundai | I30 | White | Driving without Due Care and Attention | None | CROCKETTS ROAD | Crocketts Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5056698 | -1.9492736 | ||
| 15063 | op-snap---monthly-publication-june-2025.pdf | 992 | 2025-06 | Car | Honda | Insight | Silver | Using a Mobile Phone Whilst Driving | None | Islingon Row | Islingon Row | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 15088 | op-snap---monthly-publication-june-2025.pdf | 1017 | 2025-06 | Pedal Bike | Vauxhall | Astra | Black | Using a Mobile Phone Whilst Driving | None | Olton BLVD | Olton BLVD | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4480704 | -1.8441465 | ||
| 15108 | op-snap---monthly-publication-june-2025.pdf | 1037 | 2025-06 | Pedal Bike | Chevrolet | Captiva | Blue | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 15123 | op-snap---monthly-publication-june-2025.pdf | 1052 | 2025-06 | Pedestrian | Volkswagen | transporter | Yellow | Using a Mobile Phone Whilst Driving | None | Gooch Street | Gooch Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4686609 | -1.8945007 | ||
| 15141 | op-snap---monthly-publication-june-2025.pdf | 1070 | 2025-06 | Car | Toyota | Rav 4 | black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Showell Green Lane | Showell Green Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4474637 | -1.8691688 | ||
| 15154 | op-snap---monthly-publication-june-2025.pdf | 1083 | 2025-06 | Pedal Bike | BMW | 328i | Black | Using a Mobile Phone Whilst Driving | None | Olton Boulevard | Olton Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.443439 | -1.8180486 | ||
| 15187 | op-snap---monthly-publication-june-2025.pdf | 1116 | 2025-06 | Pedal Bike | Ford | Focus | Blue | Driving without Due Care and Attention | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4668753 | -1.8996143 | ||
| 15199 | op-snap---monthly-publication-june-2025.pdf | 1128 | 2025-06 | Pedal Bike | Audi | A3 | Black | Using a Mobile Phone Whilst Driving | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 15202 | op-snap---monthly-publication-june-2025.pdf | 1131 | 2025-06 | Car | Audi | A4 | Blue | Driving without Due Care and Attention | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.443439 | -1.8180486 | ||
| 15222 | op-snap---monthly-publication-june-2025.pdf | 1151 | 2025-06 | Car | BMW | X5 | Black | Driving without Due Care and Attention | No Insurance | Flaxley Road | Flaxley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.487709 | -1.8077323 | ||
| 15227 | op-snap---monthly-publication-june-2025.pdf | 1156 | 2025-06 | Car | Toyota | Aygo | Black | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 15229 | op-snap---monthly-publication-june-2025.pdf | 1158 | 2025-06 | Other | Jaguar | XE | Red | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Springfield Crescent | Springfield Crescent | Birmingham | Birmingham | Fixed Penalty | N/A | 52.557106 | -1.7918522 | ||
| 15232 | op-snap---monthly-publication-june-2025.pdf | 1161 | 2025-06 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 15234 | op-snap---monthly-publication-june-2025.pdf | 1163 | 2025-06 | Car | Volkswagen | GOLF | Silver | Driving without Due Care and Attention | No vehicle excise licence | STRATFORD ROAD | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 15247 | op-snap---monthly-publication-june-2025.pdf | 1176 | 2025-06 | Car | Mercedes-Benz | V220 | Black | Driving without Due Care and Attention | None | Short Heath Road | Short Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5302344 | -1.8505439 | ||
| 15255 | op-snap---monthly-publication-june-2025.pdf | 1184 | 2025-06 | Car | Nissan | Juke | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Barrow Road | Barrow Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5580639 | -1.8827646 |
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);