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'}
121 rows where disposal = "NFA" and offence = "Stop a vehicle on pedestrian crossing" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, council_area_raw, nfa_rationale
vehicle_make 24
month 11
council_area 9
reporter_transport_mode 5
- Car 84
- Pedestrian 29
- Pedal Bike 6
- Bus 1
- car 1
offence 1
- Stop a vehicle on pedestrian crossing · 121 ✖
disposal 1
- NFA · 121 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7406 | op-snap---monthly-publication-february-2026.pdf | 153 | 2026-02 | Pedestrian | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 7512 | op-snap---monthly-publication-february-2026.pdf | 259 | 2026-02 | Pedestrian | Kia | Niro | White | Stop a vehicle on pedestrian crossing | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4111289 | -1.5094345 | ||
| 8164 | op-snap---monthly-publication-february-2026.pdf | 911 | 2026-02 | Car | Ford | Fiesta | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Offence | 52.502683 | -1.9033516 | ||
| 11297 | op-snap---monthly-publication-january-2026.pdf | 758 | 2026-01 | Pedestrian | Audi | A5 | Black | Stop a vehicle on pedestrian crossing | None | Oxford Street | Oxford Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4769326 | -1.8875782 | ||
| 5003 | op-snap---monthly-publication-december-2025.pdf | 1131 | 2025-12 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath | Washwood Heath | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4957234 | -1.8538937 | ||
| 5082 | op-snap---monthly-publication-december-2025.pdf | 1210 | 2025-12 | Car | Ford | Fiesta | Silver | Stop a vehicle on pedestrian crossing | None | UK | Uk | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | 52.5019896 | -2.0209184 | ||
| 21173 | op-snap---monthly-publication-november-2025.pdf | 715 | 2025-11 | Pedestrian | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21174 | op-snap---monthly-publication-november-2025.pdf | 716 | 2025-11 | Pedestrian | Seat | Leon | Blue | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21175 | op-snap---monthly-publication-november-2025.pdf | 717 | 2025-11 | Pedestrian | Honda | Civic | Blue | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21191 | op-snap---monthly-publication-november-2025.pdf | 733 | 2025-11 | Car | Daf | LF190 | White | Stop a vehicle on pedestrian crossing | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 21192 | op-snap---monthly-publication-november-2025.pdf | 734 | 2025-11 | Car | Iveco | 180E | White | Stop a vehicle on pedestrian crossing | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 3049 | op-snap---monthly-publication-august-2025.pdf | 1024 | 2025-08 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | High Street | High Street | Wolverhampton | Wolverhampton | NFA | No VRM | 52.5635963 | -2.0827567 | ||
| 14596 | op-snap---monthly-publication-june-2025.pdf | 525 | 2025-06 | Car | Volvo | XC90 | Blue | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Offence | 52.4929304 | -1.8229092 | ||
| 15307 | op-snap---monthly-publication-june-2025.pdf | 1236 | 2025-06 | Bus | Peugeot | 208 | Blue | Stop a vehicle on pedestrian crossing | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4679402 | -1.881408 | ||
| 15319 | op-snap---monthly-publication-june-2025.pdf | 1248 | 2025-06 | Pedestrian | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Roses Lane | Roses Lane | Birmingham | Birmingham | NFA | No Offence | ||||
| 15829 | op-snap---monthly-publication-june-2025.pdf | 1758 | 2025-06 | Car | Mercedes-Benz | Atego | White | Stop a vehicle on pedestrian crossing | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 15962 | op-snap---monthly-publication-june-2025.pdf | 1891 | 2025-06 | Car | BMW | 118i | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4929304 | -1.8229092 | ||
| 16042 | op-snap---monthly-publication-june-2025.pdf | 1971 | 2025-06 | Pedestrian | BMW | X1 | Grey | Stop a vehicle on pedestrian crossing | None | Green Lane | Green Lane | Solihull | Solihull | NFA | No Independent Evidence Available | 52.5069826 | -1.7643766 | ||
| 18750 | op-snap---monthly-publication-may-2025.pdf | 112 | 2025-05 | Car | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Charford Road Bromsgrove | Charford Road Bromsgrove | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18839 | op-snap---monthly-publication-may-2025.pdf | 201 | 2025-05 | Car | Mercedes-Benz | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | 52.4929304 | -1.8229092 | |||
| 19119 | op-snap---monthly-publication-may-2025.pdf | 481 | 2025-05 | Car | Volvo | XC40 | Grey | Stop a vehicle on pedestrian crossing | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | NFA | No Offence | 52.4506039 | -1.8463952 | ||
| 19725 | op-snap---monthly-publication-may-2025.pdf | 1087 | 2025-05 | Car | Peugeot | 3008 | Red | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 19726 | op-snap---monthly-publication-may-2025.pdf | 1088 | 2025-05 | Car | Audi | R8 | red | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 19763 | op-snap---monthly-publication-may-2025.pdf | 1125 | 2025-05 | Car | Volkswagen | Toureg | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 19765 | op-snap---monthly-publication-may-2025.pdf | 1127 | 2025-05 | Car | Volkswagen | Touran | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | 52.4929304 | -1.8229092 | ||
| 19800 | op-snap---monthly-publication-may-2025.pdf | 1162 | 2025-05 | Car | BMW | X5 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Offence | 52.4929304 | -1.8229092 | ||
| 19834 | op-snap---monthly-publication-may-2025.pdf | 1196 | 2025-05 | Car | BYD | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | 52.4929304 | -1.8229092 | |||
| 19876 | op-snap---monthly-publication-may-2025.pdf | 1238 | 2025-05 | Car | Vauxhall | Insignia | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 19908 | op-snap---monthly-publication-may-2025.pdf | 1270 | 2025-05 | Pedestrian | Jaguar | NP | Black | Stop a vehicle on pedestrian crossing | None | Crossing Barrington road | Crossing Barrington road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 19910 | op-snap---monthly-publication-may-2025.pdf | 1272 | 2025-05 | Car | Audi | NP | Blue | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 19912 | op-snap---monthly-publication-may-2025.pdf | 1274 | 2025-05 | Car | Ford | NP | Red | Stop a vehicle on pedestrian crossing | None | Washwood heath | Washwood heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 | ||
| 19913 | op-snap---monthly-publication-may-2025.pdf | 1275 | 2025-05 | Car | Lexus | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood road | Washwood road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4914938 | -1.8574697 | ||
| 19920 | op-snap---monthly-publication-may-2025.pdf | 1282 | 2025-05 | Car | Mercedes-Benz | A class | Grey | Stop a vehicle on pedestrian crossing | None | Edward road, Balsall Heath | Edward road, Balsall Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4570389 | -1.8891657 | ||
| 19927 | op-snap---monthly-publication-may-2025.pdf | 1289 | 2025-05 | Car | Kia | NP | White | Stop a vehicle on pedestrian crossing | None | High street, tettenhall | High street, tettenhall | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5980906 | -2.168057 | ||
| 19939 | op-snap---monthly-publication-may-2025.pdf | 1301 | 2025-05 | Pedestrian | Seat | Ateca | White | Stop a vehicle on pedestrian crossing | None | Corner of Falstaff road, at JCT of Sh | Corner of Falstaff road, at JCT of Sh | aSkoelsihpuellare drive | Askoelsihpuellare Drive | NFA | Outside of 14 Days NIP | ||||
| 19942 | op-snap---monthly-publication-may-2025.pdf | 1304 | 2025-05 | Car | Mercedes-Benz | np | Black | Stop a vehicle on pedestrian crossing | None | old walsall road | Old Walsall Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5294399 | -1.9282714 | ||
| 19943 | op-snap---monthly-publication-may-2025.pdf | 1305 | 2025-05 | Car | Toyota | NP | Brown | Stop a vehicle on pedestrian crossing | None | Old walsall road | Old walsall road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5294399 | -1.9282714 | ||
| 19948 | op-snap---monthly-publication-may-2025.pdf | 1310 | 2025-05 | Car | Tesla | NP | White | Stop a vehicle on pedestrian crossing | None | Tettenhall Road | Tettenhall Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5883523 | -2.1466187 | ||
| 19952 | op-snap---monthly-publication-may-2025.pdf | 1314 | 2025-05 | Pedestrian | Volkswagen | GOLF | Silver | Stop a vehicle on pedestrian crossing | None | A435 King heath high street | King heath high street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.435978 | -1.8925342 | ||
| 19987 | op-snap---monthly-publication-may-2025.pdf | 1349 | 2025-05 | Pedestrian | BMW | NP | Grey | Stop a vehicle on pedestrian crossing | None | Aston street | Aston street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860595 | -1.8878051 | ||
| 19991 | op-snap---monthly-publication-may-2025.pdf | 1353 | 2025-05 | Pedal Bike | BMW | 520D | Grey | Stop a vehicle on pedestrian crossing | None | Stoney stanton | Stoney stanton | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4196813 | -1.4978941 | ||
| 20025 | op-snap---monthly-publication-may-2025.pdf | 1387 | 2025-05 | Pedestrian | BMW | NP | Silver | Stop a vehicle on pedestrian crossing | None | Wattville road | Wattville road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5063926 | -1.9548648 | ||
| 20051 | op-snap---monthly-publication-may-2025.pdf | 1413 | 2025-05 | Pedal Bike | Skoda | Skoda | Grey | Stop a vehicle on pedestrian crossing | None | smallbrook queensway | Smallbrook Queensway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4772584 | -1.8965734 | ||
| 20078 | op-snap---monthly-publication-may-2025.pdf | 1440 | 2025-05 | Car | Lexus | NP | White | Stop a vehicle on pedestrian crossing | None | fox hollies rd | Fox Hollies Rd | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4425992 | -1.8338234 | ||
| 20079 | op-snap---monthly-publication-may-2025.pdf | 1441 | 2025-05 | Car | Volkswagen | NP | Grey | Stop a vehicle on pedestrian crossing | None | Fox hollies road | Fox hollies road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5517052 | -1.7825505 | ||
| 20081 | op-snap---monthly-publication-may-2025.pdf | 1443 | 2025-05 | car | Volkswagen | NP | Grey | Stop a vehicle on pedestrian crossing | None | Garretts green lane birmingham | Garretts green lane birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4675802 | -1.7905748 | ||
| 20082 | op-snap---monthly-publication-may-2025.pdf | 1444 | 2025-05 | Car | Volkswagen | NP | White | Stop a vehicle on pedestrian crossing | None | Garretts green lane | Garretts green lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4675802 | -1.7905748 | ||
| 20093 | op-snap---monthly-publication-may-2025.pdf | 1455 | 2025-05 | Pedal Bike | London taxi TX4 | Black | Stop a vehicle on pedestrian crossing | None | Earlsdon avenue | Earlsdon avenue | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4047134 | -1.5351834 | |||
| 20095 | op-snap---monthly-publication-may-2025.pdf | 1457 | 2025-05 | Pedal Bike | Toyota | Auris | White | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3988977 | -1.5323674 | ||
| 20103 | op-snap---monthly-publication-may-2025.pdf | 1465 | 2025-05 | Pedestrian | Volkswagen | np | Grey | Stop a vehicle on pedestrian crossing | None | Allens croft road | Allens croft road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4242527 | -1.910803 | ||
| 20120 | op-snap---monthly-publication-may-2025.pdf | 1482 | 2025-05 | Car | Toyota | NP | Beige | Stop a vehicle on pedestrian crossing | None | WASHWOOD HEATH RD | Washwood Heath Rd | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 20122 | op-snap---monthly-publication-may-2025.pdf | 1484 | 2025-05 | Car | Ford | NP | Red | Stop a vehicle on pedestrian crossing | None | WASHWOOD HEATH | Washwood Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 | ||
| 20123 | op-snap---monthly-publication-may-2025.pdf | 1485 | 2025-05 | Car | Seat | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood heath | Washwood heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 | ||
| 591 | op-snap---monthly-publication-april-2025.pdf | 590 | 2025-04 | Pedestrian | BMW | 316d | White | Stop a vehicle on pedestrian crossing | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4456462 | -1.827993 | ||
| 1371 | op-snap---monthly-publication-april-2025.pdf | 1370 | 2025-04 | Pedal Bike | Mercedes-Benz | NP | Black | Stop a vehicle on pedestrian crossing | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4221152 | -1.4959475 | ||
| 1373 | op-snap---monthly-publication-april-2025.pdf | 1372 | 2025-04 | Car | Toyota | NP | Blue | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1388 | op-snap---monthly-publication-april-2025.pdf | 1387 | 2025-04 | Car | Toyota | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1391 | op-snap---monthly-publication-april-2025.pdf | 1390 | 2025-04 | Car | Honda | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1392 | op-snap---monthly-publication-april-2025.pdf | 1391 | 2025-04 | Car | Mercedes-Benz | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1420 | op-snap---monthly-publication-april-2025.pdf | 1419 | 2025-04 | Pedestrian | Seat | Leon | Black | Stop a vehicle on pedestrian crossing | None | stratford road | Stratford Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4191184 | -1.8326637 | ||
| 1435 | op-snap---monthly-publication-april-2025.pdf | 1434 | 2025-04 | Pedestrian | BMW | NP | White | Stop a vehicle on pedestrian crossing | None | Hazelville Road | Hazelville Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4254442 | -1.8341081 | ||
| 1440 | op-snap---monthly-publication-april-2025.pdf | 1439 | 2025-04 | Car | BMW | NP | Blue | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1445 | op-snap---monthly-publication-april-2025.pdf | 1444 | 2025-04 | Car | Mercedes-Benz | NP | Black | Stop a vehicle on pedestrian crossing | None | Coleshill road | Coleshill road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4967329 | -1.8097462 | ||
| 1446 | op-snap---monthly-publication-april-2025.pdf | 1445 | 2025-04 | Car | Honda | NP | Silver | Stop a vehicle on pedestrian crossing | None | Coleshill road | Coleshill road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4967329 | -1.8097462 | ||
| 1447 | op-snap---monthly-publication-april-2025.pdf | 1446 | 2025-04 | Car | Audi | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1470 | op-snap---monthly-publication-april-2025.pdf | 1469 | 2025-04 | Car | Toyota | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1473 | op-snap---monthly-publication-april-2025.pdf | 1472 | 2025-04 | Car | Volkswagen | NP | White | Stop a vehicle on pedestrian crossing | None | Fox hollies road | Fox hollies road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5517052 | -1.7825505 | ||
| 1476 | op-snap---monthly-publication-april-2025.pdf | 1475 | 2025-04 | Car | Mercedes-Benz | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road , Birmingham | Washwood Heath Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1477 | op-snap---monthly-publication-april-2025.pdf | 1476 | 2025-04 | Car | Lexus | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road , Birmingham | Washwood Heath Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1502 | op-snap---monthly-publication-april-2025.pdf | 1501 | 2025-04 | Car | Ford | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood heat road | Washwood heat road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1503 | op-snap---monthly-publication-april-2025.pdf | 1502 | 2025-04 | Car | Mini | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1505 | op-snap---monthly-publication-april-2025.pdf | 1504 | 2025-04 | Car | Audi | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1506 | op-snap---monthly-publication-april-2025.pdf | 1505 | 2025-04 | Car | Vauxhall | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1507 | op-snap---monthly-publication-april-2025.pdf | 1506 | 2025-04 | Car | Volkswagen | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1509 | op-snap---monthly-publication-april-2025.pdf | 1508 | 2025-04 | Car | Nissan | NP | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1510 | op-snap---monthly-publication-april-2025.pdf | 1509 | 2025-04 | Car | Toyota | NP | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | |||
| 1543 | op-snap---monthly-publication-april-2025.pdf | 1542 | 2025-04 | Car | Volkswagen | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1544 | op-snap---monthly-publication-april-2025.pdf | 1543 | 2025-04 | Car | Ford | NP | Red | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1545 | op-snap---monthly-publication-april-2025.pdf | 1544 | 2025-04 | Car | Peugeot | np | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1547 | op-snap---monthly-publication-april-2025.pdf | 1546 | 2025-04 | Car | Volkswagen | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1585 | op-snap---monthly-publication-april-2025.pdf | 1584 | 2025-04 | Car | Volvo | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1586 | op-snap---monthly-publication-april-2025.pdf | 1585 | 2025-04 | Car | Audi | NP | Blue | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Birmingham | Birmingham | NFA | Outside of 14 days NIP | 52.4929304 | -1.8229092 | ||
| 1590 | op-snap---monthly-publication-april-2025.pdf | 1589 | 2025-04 | Pedestrian | NP | White | Stop a vehicle on pedestrian crossing | None | Bertam road | Bertam road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 1628 | op-snap---monthly-publication-april-2025.pdf | 1627 | 2025-04 | Pedestrian | Honda | np | Black | Stop a vehicle on pedestrian crossing | None | n/a (junction road, near corner of Clarence news store) | n/a (junction road, near corner of Clarence news store) | NFA | Outside of 14 Days NIP | ||||||
| 1657 | op-snap---monthly-publication-april-2025.pdf | 1656 | 2025-04 | Pedestrian | Volkswagen | NP | Black | Stop a vehicle on pedestrian crossing | None | Moseley road. Balsall heath | Moseley road. Balsall heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4426959 | -1.8847675 | ||
| 1660 | op-snap---monthly-publication-april-2025.pdf | 1659 | 2025-04 | Car | Toyota | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood heath Road , Birmingham | Washwood heath Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1661 | op-snap---monthly-publication-april-2025.pdf | 1660 | 2025-04 | Car | Volkswagen | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood heath Road , Birmingham | Washwood heath Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1662 | op-snap---monthly-publication-april-2025.pdf | 1661 | 2025-04 | Car | Ford | np | White | Stop a vehicle on pedestrian crossing | None | washwood heath Road , Birmingham | washwood heath Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1663 | op-snap---monthly-publication-april-2025.pdf | 1662 | 2025-04 | Car | Nissan | NP | Black | Stop a vehicle on pedestrian crossing | None | washwood heath Road , Birmingham | washwood heath Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1667 | op-snap---monthly-publication-april-2025.pdf | 1666 | 2025-04 | Car | Volkswagen | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood heath road, birmingham | Washwood heath road, birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 1781 | op-snap---monthly-publication-april-2025.pdf | 1780 | 2025-04 | Car | Mercedes-Benz | NP | White | Stop a vehicle on pedestrian crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4967329 | -1.8097462 | ||
| 1809 | op-snap---monthly-publication-april-2025.pdf | 1808 | 2025-04 | Car | Vauxhall | Vivaro | Silver | Stop a vehicle on pedestrian crossing | None | A41 Bilston road | Bilston road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5801329 | -2.1138283 | ||
| 1874 | op-snap---monthly-publication-april-2025.pdf | 1873 | 2025-04 | Car | Honda | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1875 | op-snap---monthly-publication-april-2025.pdf | 1874 | 2025-04 | Car | Vauxhall | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1877 | op-snap---monthly-publication-april-2025.pdf | 1876 | 2025-04 | Car | Kia | NP | Red | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1879 | op-snap---monthly-publication-april-2025.pdf | 1878 | 2025-04 | Car | Mercedes-Benz | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1886 | op-snap---monthly-publication-april-2025.pdf | 1885 | 2025-04 | Car | Audi | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1913 | op-snap---monthly-publication-april-2025.pdf | 1912 | 2025-04 | Car | Toyota | NP | Grey | Stop a vehicle on pedestrian crossing | None | WASHWOOD HEATH ROAD | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1914 | op-snap---monthly-publication-april-2025.pdf | 1913 | 2025-04 | Car | Mitsubishi | NP | White | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 1915 | op-snap---monthly-publication-april-2025.pdf | 1914 | 2025-04 | Car | Volkswagen | NP | Blue | Stop a vehicle on pedestrian crossing | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 |
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);