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'}
327 rows where disposal = "Fixed Penalty", month = "2025-03" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 29
offence 22
- Driving without Due Care and Attention 82
- Contravening a Red Traffic Light 78
- Stop a vehicle within pelican pedestrian crossing limits 44
- Stop a vehicle on pedestrian crossing 29
- Using a Mobile Phone Whilst Driving 22
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 20
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 15
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 9
- Cause vehicle to be left in a dangerous position 4
- Drive on hard shoulder 3
- Driving without Reasonable Consideration 3
- No Insurance 3
- VRM fails to conform to Regulations 3
- Motor vehicle fail to accord precedence at a pelican crossing 2
- No Seat Belt 2
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 2
- Contravene Lane Closure Red X 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with solid white line road markings 1
- Prohibited vehicle in offside lane of motorway 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use vehicle on a road without valid test certificate 1
council_area 12
- Birmingham 201
- Coventry 36
- Sandwell 19
- Dudley 17
- Sutton Coldfield 16
- Wolverhampton 12
- Solihull 11
- Walsall 11
- Dbirmingham 1
- Halesowen 1
- Idseudtt Obny Cprol)Dfield 1
- Metropolitan Borough Of Dudley 1
reporter_transport_mode 1
- Car · 327 ✖
month 1
- 2025-03 · 327 ✖
disposal 1
- Fixed Penalty · 327 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16250 | op-snap---monthly-publication-march-2025.pdf | 7 | 2025-03 | Car | Kia | Ceed | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Robert Street from Jews Lane | Robert Street from Jews Lane | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Fixed Penalty | N/A | Yes - Via Email | |||
| 16265 | op-snap---monthly-publication-march-2025.pdf | 22 | 2025-03 | Car | Peugeot | 508 | Grey | Contravening a Red Traffic Light | None | Lawley Middleway | Lawley Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4801772 | -1.8769185 | |
| 16269 | op-snap---monthly-publication-march-2025.pdf | 26 | 2025-03 | Car | Yamaha | Lex moto | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 16275 | op-snap---monthly-publication-march-2025.pdf | 32 | 2025-03 | Car | Mercedes-Benz | X350 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 16286 | op-snap---monthly-publication-march-2025.pdf | 43 | 2025-03 | Car | Land Rover | Sport | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16288 | op-snap---monthly-publication-march-2025.pdf | 45 | 2025-03 | Car | Vauxhall | Corsa | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Lower Essex Street | Lower Essex Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4716178 | -1.8954045 | |
| 16294 | op-snap---monthly-publication-march-2025.pdf | 51 | 2025-03 | Car | Volkswagen | crafter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4762784 | -1.9678366 | |
| 16304 | op-snap---monthly-publication-march-2025.pdf | 61 | 2025-03 | Car | Ford | Focus | White | Using a Mobile Phone Whilst Driving | None | Bunbury Road, Northfield | Bunbury Road, Northfield | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4142089 | -1.9587147 | |
| 16317 | op-snap---monthly-publication-march-2025.pdf | 74 | 2025-03 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Tippity Green Oldbury | Tippity Green Oldbury | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4839613 | -2.0496171 | |
| 16319 | op-snap---monthly-publication-march-2025.pdf | 76 | 2025-03 | Car | Volkswagen | Passat | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16320 | op-snap---monthly-publication-march-2025.pdf | 77 | 2025-03 | Car | Vauxhall | Astra | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16326 | op-snap---monthly-publication-march-2025.pdf | 83 | 2025-03 | Car | Audi | Q2 | White | Driving without Due Care and Attention | None | Lawrence Saunders Road | Lawrence Saunders Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4190356 | -1.5238966 | |
| 16365 | op-snap---monthly-publication-march-2025.pdf | 122 | 2025-03 | Car | Hyundai | I30 | White | Driving without Due Care and Attention | None | Dartmouth Circus | Dartmouth Circus | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4926487 | -1.8879638 | |
| 16389 | op-snap---monthly-publication-march-2025.pdf | 146 | 2025-03 | Car | Volkswagen | TRoc | Black | Driving without Due Care and Attention | None | Ringway Highway | Ringway Highway | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | |||
| 16395 | op-snap---monthly-publication-march-2025.pdf | 152 | 2025-03 | Car | Nissan | Juke | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4321165 | -1.8902667 | |
| 16396 | op-snap---monthly-publication-march-2025.pdf | 153 | 2025-03 | Car | Ford | Fiesta | Red | Contravening a Red Traffic Light | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.513857 | -1.9367367 | |
| 16397 | op-snap---monthly-publication-march-2025.pdf | 154 | 2025-03 | Car | BMW | 116 | Grey | Contravening a Red Traffic Light | None | Hall Street | Hall Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5409774 | -2.1235921 | |
| 16441 | op-snap---monthly-publication-march-2025.pdf | 198 | 2025-03 | Car | Fiat | 500 | White | Contravening a Red Traffic Light | None | Bilston Street | Bilston Street | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | Yes - Via Email | 52.5838892 | -2.1231759 | |
| 16444 | op-snap---monthly-publication-march-2025.pdf | 201 | 2025-03 | Car | Volkswagen | Polo | Black | VRM fails to conform to Regulations | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 16449 | op-snap---monthly-publication-march-2025.pdf | 206 | 2025-03 | Car | Vauxhall | Corsa | Silver | No Seat Belt | None | Cromwell Street | Cromwell Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4943048 | -1.8749703 | |
| 16452 | op-snap---monthly-publication-march-2025.pdf | 209 | 2025-03 | Car | Audi | A4 | White | Drive on hard shoulder | None | M5 SB J1 | M5 Southbound J1 | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | |||
| 16479 | op-snap---monthly-publication-march-2025.pdf | 236 | 2025-03 | Car | Vauxhall | Astra | White | Using a Mobile Phone Whilst Driving | None | Warwick Road, Birmingham | Warwick Road, Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.551985 | -1.860445 | |
| 16495 | op-snap---monthly-publication-march-2025.pdf | 252 | 2025-03 | Car | Lexus | ES | Grey | Driving without Due Care and Attention | None | Whittemere Street | Whittemere Street | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16502 | op-snap---monthly-publication-march-2025.pdf | 259 | 2025-03 | Car | Ford | Transit | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16511 | op-snap---monthly-publication-march-2025.pdf | 268 | 2025-03 | Car | Ford | cmax | Silver | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5723244 | -1.9607214 | |
| 16529 | op-snap---monthly-publication-march-2025.pdf | 286 | 2025-03 | Car | Citroen | Birlingo | White | Driving without Due Care and Attention | None | Castle Hill | Castle Hill | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5140573 | -2.0798069 | |
| 16537 | op-snap---monthly-publication-march-2025.pdf | 294 | 2025-03 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4726661 | -1.8769032 | |
| 16539 | op-snap---monthly-publication-march-2025.pdf | 296 | 2025-03 | Car | Yamaha | 125 | Blue | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4726661 | -1.8769032 | |
| 16541 | op-snap---monthly-publication-march-2025.pdf | 298 | 2025-03 | Car | TGE | Silver | Contravening a Red Traffic Light | None | Toll Bar End Roundabout | Toll Bar End Roundabout | Coventry | Coventry | Fixed Penalty | n/a | Yes - Via Email | ||||
| 16549 | op-snap---monthly-publication-march-2025.pdf | 306 | 2025-03 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Broadway North | Broadway North | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5886007 | -1.9741222 | |
| 16550 | op-snap---monthly-publication-march-2025.pdf | 307 | 2025-03 | Car | Mercedes-Benz | AMG A35 | Grey | VRM fails to conform to Regulations | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 16567 | op-snap---monthly-publication-march-2025.pdf | 324 | 2025-03 | Car | Seat | ALHAMBRA | Silver | Contravening a Red Traffic Light | None | NEWPORT ROAD | Newport Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5027779 | -1.7982159 | |
| 16571 | op-snap---monthly-publication-march-2025.pdf | 328 | 2025-03 | Car | Kia | SPORTAGE | White | Contravening a Red Traffic Light | None | NEWPORT ROAD | Newport Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5027779 | -1.7982159 | |
| 16577 | op-snap---monthly-publication-march-2025.pdf | 334 | 2025-03 | Car | Toyota | Avensis | Grey | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4726661 | -1.8769032 | |
| 16578 | op-snap---monthly-publication-march-2025.pdf | 335 | 2025-03 | Car | Citroen | Berlingo | White | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Solihull | Solihull | Fixed Penalty | N/A | Yes - Via Email | 52.4191184 | -1.8326637 | |
| 16582 | op-snap---monthly-publication-march-2025.pdf | 339 | 2025-03 | Car | BMW | 520d | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16584 | op-snap---monthly-publication-march-2025.pdf | 341 | 2025-03 | Car | Mercedes-Benz | Vito | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16586 | op-snap---monthly-publication-march-2025.pdf | 343 | 2025-03 | Car | Volkswagen | Passat | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washood Heath Road | Washood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 16587 | op-snap---monthly-publication-march-2025.pdf | 344 | 2025-03 | Car | Mercedes-Benz | E350 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16588 | op-snap---monthly-publication-march-2025.pdf | 345 | 2025-03 | Car | Vauxhall | Corsa | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16595 | op-snap---monthly-publication-march-2025.pdf | 352 | 2025-03 | Car | BMW | 116 D | Black | Driving without Due Care and Attention | None | COLE HALL LANE | Cole Hall Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4877244 | -1.787883 | |
| 16600 | op-snap---monthly-publication-march-2025.pdf | 357 | 2025-03 | Car | Mercedes-Benz | GLA | White | Contravening a Red Traffic Light | None | A41 Warwick Road | Warwick Road | Solihull | Solihull | Fixed Penalty | N/A | Yes - Via Email | 52.4428606 | -1.812114 | |
| 16602 | op-snap---monthly-publication-march-2025.pdf | 359 | 2025-03 | Car | Volkswagen | POLO | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | BROMFORD ROAD | Bromford Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.503036 | -1.8289972 | |
| 16606 | op-snap---monthly-publication-march-2025.pdf | 363 | 2025-03 | Car | BMW | 320I | Orange | Driving without Due Care and Attention | None | Greaves Avenue | Greaves Avenue | Walsall | Walsall | Fixed Penalty | N/A | 52.5773135 | -1.9525262 | ||
| 16607 | op-snap---monthly-publication-march-2025.pdf | 364 | 2025-03 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4198291 | -1.9241732 | |
| 16612 | op-snap---monthly-publication-march-2025.pdf | 369 | 2025-03 | Car | Audi | A4 | White | Driving without Due Care and Attention | None | School Road | School Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4161736 | -1.8619692 | |
| 16613 | op-snap---monthly-publication-march-2025.pdf | 370 | 2025-03 | Car | Audi | A4 | White | Driving without Due Care and Attention | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4709298 | -1.8722585 | |
| 16620 | op-snap---monthly-publication-march-2025.pdf | 377 | 2025-03 | Car | BMW | 435d | Black | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 16625 | op-snap---monthly-publication-march-2025.pdf | 382 | 2025-03 | Car | BMW | 320D | Grey | VRM fails to conform to Regulations | No Insurance | A4040 | A4040 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 16631 | op-snap---monthly-publication-march-2025.pdf | 388 | 2025-03 | Car | Mercedes-Benz | C220 | Silver | Driving without Due Care and Attention | None | Harrier Way Birmingham | Harrier Way Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 16654 | op-snap---monthly-publication-march-2025.pdf | 411 | 2025-03 | Car | Land Rover | Green | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Fixed Penalty | N/A | Yes - Via Email | ||||
| 16662 | op-snap---monthly-publication-march-2025.pdf | 419 | 2025-03 | Car | Renault | Trafic | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16665 | op-snap---monthly-publication-march-2025.pdf | 422 | 2025-03 | Car | Audi | A4 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16667 | op-snap---monthly-publication-march-2025.pdf | 424 | 2025-03 | Car | Nissan | Juke | Black | Driving without Due Care and Attention | None | Heaton Street | Heaton Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4940041 | -1.9162925 | |
| 16670 | op-snap---monthly-publication-march-2025.pdf | 427 | 2025-03 | Car | Tesla | Model3 | White | Contravening a Red Traffic Light | None | Highfield Rd, Edgbaston | Highfield Road, Edgbaston | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4712241 | -1.9259851 | |
| 16677 | op-snap---monthly-publication-march-2025.pdf | 434 | 2025-03 | Car | Audi | Q7 | White | Stop a vehicle within pelican pedestrian crossing limits | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | Yes - Via Email | 52.5980906 | -2.168057 | |
| 16679 | op-snap---monthly-publication-march-2025.pdf | 436 | 2025-03 | Car | Audi | RSQ8 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | High Street, Kingswinford | High Street, Kingswinford | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4975687 | -2.1672039 | |
| 16709 | op-snap---monthly-publication-march-2025.pdf | 466 | 2025-03 | Car | Mercedes-Benz | Sprinter | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Alcester Street | Alcester Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4696096 | -1.8871873 | |
| 16722 | op-snap---monthly-publication-march-2025.pdf | 479 | 2025-03 | Car | Mg | 3 | Silver | Using a Mobile Phone Whilst Driving | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4555288 | -1.8613929 | |
| 16725 | op-snap---monthly-publication-march-2025.pdf | 482 | 2025-03 | Car | Mercedes-Benz | Sprinter | White | Motor vehicle fail to accord precedence at a pelican crossing | None | Rolfe Street | Rolfe Street | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4972172 | -1.9607539 | |
| 16727 | op-snap---monthly-publication-march-2025.pdf | 484 | 2025-03 | Car | Volkswagen | Transporter | Blue | Using a Mobile Phone Whilst Driving | None | Milton Street Walsall | Milton Street Walsall | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5718856 | -1.9899635 | |
| 16735 | op-snap---monthly-publication-march-2025.pdf | 492 | 2025-03 | Car | Audi | A4 | Blue | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16736 | op-snap---monthly-publication-march-2025.pdf | 493 | 2025-03 | Car | Vauxhall | Insignia | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16744 | op-snap---monthly-publication-march-2025.pdf | 501 | 2025-03 | Car | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Stonebridge Highway | Stonebridge Highway | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3782187 | -1.478696 | |
| 16760 | op-snap---monthly-publication-march-2025.pdf | 517 | 2025-03 | Car | Volkswagen | Golf | Black | Using a Mobile Phone Whilst Driving | None | Walsall Rd jct 7 | Walsall Road jct 7 | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16763 | op-snap---monthly-publication-march-2025.pdf | 520 | 2025-03 | Car | Peugeot | 2008 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.470423 | -1.9304786 | |
| 16765 | op-snap---monthly-publication-march-2025.pdf | 522 | 2025-03 | Car | Mercedes-Benz | C-Class | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.470423 | -1.9304786 | |
| 16773 | op-snap---monthly-publication-march-2025.pdf | 530 | 2025-03 | Car | Volkswagen | Polo | Silver | Contravening a Red Traffic Light | None | Holyhead Road, Handsworth | Holyhead Road, Handsworth | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.505233 | -1.9446276 | |
| 16781 | op-snap---monthly-publication-march-2025.pdf | 538 | 2025-03 | Car | Audi | Q7 | Grey | Driving without Due Care and Attention | No Insurance | ROTTEN PARK ROAD | Rotten Park Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 16784 | op-snap---monthly-publication-march-2025.pdf | 541 | 2025-03 | Car | Kia | Ceed | Silver | Driving without Due Care and Attention | None | Green Street, Coseley | Green Street, Coseley | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | Yes - Via Email | |||
| 16788 | op-snap---monthly-publication-march-2025.pdf | 545 | 2025-03 | Car | Mercedes-Benz | A250 | Grey | Driving without Due Care and Attention | None | A491 Stream Road/High Street | Stream Road/High Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4871725 | -2.1623764 | |
| 16790 | op-snap---monthly-publication-march-2025.pdf | 547 | 2025-03 | Car | Audi | A4 | White | Driving without Due Care and Attention | No vehicle excise licence | SCHOOL ROAD | School Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4161736 | -1.8619692 | |
| 16806 | op-snap---monthly-publication-march-2025.pdf | 563 | 2025-03 | Car | Toyota | Prius | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Tower Street | Tower Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 16808 | op-snap---monthly-publication-march-2025.pdf | 565 | 2025-03 | Car | BMW | 120D | Grey | Driving without Due Care and Attention | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5002997 | -2.1081386 | |
| 16820 | op-snap---monthly-publication-march-2025.pdf | 577 | 2025-03 | Car | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | M5 South junction 1 to junction 2 | M5 South junction 1 to junction 2 | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | |||
| 16825 | op-snap---monthly-publication-march-2025.pdf | 582 | 2025-03 | Car | Honda | Accord | Silver | Driving without Due Care and Attention | None | Hobs moat road | Hobs moat road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4515649 | -1.7820482 | |
| 16827 | op-snap---monthly-publication-march-2025.pdf | 584 | 2025-03 | Car | Toyota | Yaris | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Wolseley Road, West Brom | Wolseley Road, West Brom | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | |||
| 16830 | op-snap---monthly-publication-march-2025.pdf | 587 | 2025-03 | Car | Audi | RS3 | Blue | Contravening a Red Traffic Light | None | Selly Oak Road at junction with Northfield Roa | Selly Oak Road at junction with Northfield Roa | dBirmingham | Dbirmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4263875 | -1.9397954 | |
| 16832 | op-snap---monthly-publication-march-2025.pdf | 589 | 2025-03 | Car | Renault | Captur | Orange | Contravening a Red Traffic Light | None | Dudley Road East | Dudley Road East | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.5111988 | -2.0318469 | |
| 16835 | op-snap---monthly-publication-march-2025.pdf | 592 | 2025-03 | Car | BMW | 118 | White | Stop a vehicle within pelican pedestrian crossing limits | None | Audley Road | Audley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4876917 | -1.7963729 | |
| 16837 | op-snap---monthly-publication-march-2025.pdf | 594 | 2025-03 | Car | Ford | Galaxy | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16839 | op-snap---monthly-publication-march-2025.pdf | 596 | 2025-03 | Car | Mg | HS.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16845 | op-snap---monthly-publication-march-2025.pdf | 602 | 2025-03 | Car | Mini | Cooper | Green | Driving without Due Care and Attention | None | M42, Birmingham | M42, Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4796992 | -1.9026911 | |
| 16869 | op-snap---monthly-publication-march-2025.pdf | 626 | 2025-03 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16892 | op-snap---monthly-publication-march-2025.pdf | 649 | 2025-03 | Car | Mercedes-Benz | Citan van | White | Using a Mobile Phone Whilst Driving | None | Waterford Road at junction with Moss Grove | Waterford Road at junction with Moss Grove | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5003679 | -2.1689311 | |
| 16893 | op-snap---monthly-publication-march-2025.pdf | 650 | 2025-03 | Car | Vauxhall | Astra | Blue | Using a Mobile Phone Whilst Driving | None | Stream Road, Kingswinford | Stream Road, Kingswinford | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4928417 | -2.1667409 | |
| 16900 | op-snap---monthly-publication-march-2025.pdf | 657 | 2025-03 | Car | Nissan | Juke | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bromford Road | Bromford Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.503036 | -1.8289972 | |
| 16919 | op-snap---monthly-publication-march-2025.pdf | 676 | 2025-03 | Car | Renault | Kangoo | White | Stop a vehicle within pelican pedestrian crossing limits | None | High Street Kings Heath | High Street Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4375456 | -1.8926849 | |
| 16925 | op-snap---monthly-publication-march-2025.pdf | 682 | 2025-03 | Car | Peugeot | Expert | Red | Using a Mobile Phone Whilst Driving | None | Daventry Road | Daventry Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3930931 | -1.4976428 | |
| 16937 | op-snap---monthly-publication-march-2025.pdf | 694 | 2025-03 | Car | Fiat | 500 E | Gold | Driving without Due Care and Attention | None | Himley Road, Dudley | Himley Road, Dudley | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5142667 | -2.1304764 | |
| 16944 | op-snap---monthly-publication-march-2025.pdf | 701 | 2025-03 | Car | Vauxhall | Corsa | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Whittington Oval | Whittington Oval | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4800782 | -1.7942034 | |
| 16954 | op-snap---monthly-publication-march-2025.pdf | 711 | 2025-03 | Car | Vauxhall | Vivaro | Grey | Contravening a Red Traffic Light | None | Worcester Lane | Worcester Lane | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4336498 | -2.1403487 | |
| 16963 | op-snap---monthly-publication-march-2025.pdf | 720 | 2025-03 | Car | Audi | A5 | Silver | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 16970 | op-snap---monthly-publication-march-2025.pdf | 727 | 2025-03 | Car | Volkswagen | Crafter | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | High Street Kingswinford | High Street Kingswinford | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4975687 | -2.1672039 | |
| 16972 | op-snap---monthly-publication-march-2025.pdf | 729 | 2025-03 | Car | Volkswagen | Transporter | White | Drive on hard shoulder | None | M6 Jn6 | M6 Jn6 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 16979 | op-snap---monthly-publication-march-2025.pdf | 736 | 2025-03 | Car | Peugeot | 207 | Grey | Using a Mobile Phone Whilst Driving | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5867763 | -2.0104342 | |
| 16985 | op-snap---monthly-publication-march-2025.pdf | 742 | 2025-03 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4606652 | -1.8791145 | |
| 16988 | op-snap---monthly-publication-march-2025.pdf | 745 | 2025-03 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue, Coventry | Moseley Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4141818 | -1.5315277 | |
| 16989 | op-snap---monthly-publication-march-2025.pdf | 746 | 2025-03 | Car | Toyota | Yaris | Grey | Contravening a Red Traffic Light | None | Manor Lane | Manor Lane | Halesowen | Halesowen | Fixed Penalty | N/A | Yes - Via Email | 52.4500678 | -2.0276115 | |
| 16990 | op-snap---monthly-publication-march-2025.pdf | 747 | 2025-03 | Car | Toyota | N/P | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue, Coventry | Moseley Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4141818 | -1.5315277 |
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);