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'}
231 rows where council_area = "Birmingham", offence = "Misc - Non Traffic Offences" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
month 14
disposal 6
- NFA 170
- Warning Letter 27
- Other Action Taken 19
- RTC - Actioned 12
- Fixed Penalty 2
- Court 1
reporter_transport_mode 1
- Car · 231 ✖
offence 1
- Misc - Non Traffic Offences · 231 ✖
council_area 1
- Birmingham · 231 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7451 | op-snap---monthly-publication-february-2026.pdf | 198 | 2026-02 | Car | multiple | Misc - Non Traffic Offences | None | Willes Road | Willes Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4964973 | -1.9367016 | ||||
| 7453 | op-snap---monthly-publication-february-2026.pdf | 200 | 2026-02 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.4198291 | -1.9241732 | ||
| 7519 | op-snap---monthly-publication-february-2026.pdf | 266 | 2026-02 | Car | Volvo | XC90 | Grey | Misc - Non Traffic Offences | None | Bristol Street | Bristol Street | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4691145 | -1.9003257 | ||
| 7605 | op-snap---monthly-publication-february-2026.pdf | 352 | 2026-02 | Car | Mini | Cooper | Grey | Misc - Non Traffic Offences | None | Harborne Lane | Harborne Lane | Birmingham | Birmingham | NFA | No Offence | 52.4468464 | -1.9454816 | ||
| 8038 | op-snap---monthly-publication-february-2026.pdf | 785 | 2026-02 | Car | BMW | X3.. | White | Misc - Non Traffic Offences | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.471632 | -1.9456776 | ||
| 8136 | op-snap---monthly-publication-february-2026.pdf | 883 | 2026-02 | Car | Nissan | Juke | Red | Misc - Non Traffic Offences | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 8183 | op-snap---monthly-publication-february-2026.pdf | 930 | 2026-02 | Car | Misc - Non Traffic Offences | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | NFA | No Offence | 52.470423 | -1.9304786 | |||||
| 8559 | op-snap---monthly-publication-february-2026.pdf | 1306 | 2026-02 | Car | Seat | Leon | Black | Misc - Non Traffic Offences | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No VRM | 52.4543565 | -1.9114004 | ||
| 8630 | op-snap---monthly-publication-february-2026.pdf | 1377 | 2026-02 | Car | Vauxhall | insignia | Grey | Misc - Non Traffic Offences | None | granthan road | Granthan Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 8647 | op-snap---monthly-publication-february-2026.pdf | 1394 | 2026-02 | Car | Audi | Black | Misc - Non Traffic Offences | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | |||
| 8748 | op-snap---monthly-publication-february-2026.pdf | 1495 | 2026-02 | Car | Mercedes-Benz | S220D | Blue | Misc - Non Traffic Offences | No vehicle excise licence | Moseley Road | Moseley Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4679402 | -1.881408 | ||
| 8793 | op-snap---monthly-publication-february-2026.pdf | 1540 | 2026-02 | Car | Misc - Non Traffic Offences | None | np | Np | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 8846 | op-snap---monthly-publication-february-2026.pdf | 1593 | 2026-02 | Car | Mercedes-Benz | slk | White | Misc - Non Traffic Offences | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5603978 | -1.8227403 | ||
| 8847 | op-snap---monthly-publication-february-2026.pdf | 1594 | 2026-02 | Car | Nissan | qashqai | Grey | Misc - Non Traffic Offences | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5603978 | -1.8227403 | ||
| 10626 | op-snap---monthly-publication-january-2026.pdf | 87 | 2026-01 | Car | Volkswagen | golf | Grey | Misc - Non Traffic Offences | None | cox street | Cox Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4864073 | -1.905273 | ||
| 10627 | op-snap---monthly-publication-january-2026.pdf | 88 | 2026-01 | Car | Audi | a4 | Grey | Misc - Non Traffic Offences | None | M6 SB J9 | M6 Southbound J9 | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.676119 | -2.0858425 | ||
| 10998 | op-snap---monthly-publication-january-2026.pdf | 459 | 2026-01 | Car | Audi | Q5 | Grey | Misc - Non Traffic Offences | None | Colley Gate | Colley Gate | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 11031 | op-snap---monthly-publication-january-2026.pdf | 492 | 2026-01 | Car | Seat | Ibiza | Red | Misc - Non Traffic Offences | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Other Action Taken | N/A | 52.5083238 | -1.8332287 | ||
| 11234 | op-snap---monthly-publication-january-2026.pdf | 695 | 2026-01 | Car | Mazda | MX 5 | Grey | Misc - Non Traffic Offences | None | M42 Jct 3A | M42 Junction 3A | Birmingham | Birmingham | Other Action Taken | N/A | 52.4846642 | -1.9297585 | ||
| 11603 | op-snap---monthly-publication-january-2026.pdf | 1064 | 2026-01 | Car | Vauxhall | Mokka | Brown | Misc - Non Traffic Offences | None | Friary Road / Oxhill Road junction | Friary Road / Oxhill Road junction | Birmingham | Birmingham | NFA | No Offence | 52.5162814 | -1.9395798 | ||
| 11713 | op-snap---monthly-publication-january-2026.pdf | 1174 | 2026-01 | Car | Volkswagen | Golf | Grey | Misc - Non Traffic Offences | None | Edgbaston Park Road | Edgbaston Park Road | Birmingham | Birmingham | NFA | No Offence | 52.4580375 | -1.9261777 | ||
| 11941 | op-snap---monthly-publication-january-2026.pdf | 1402 | 2026-01 | Car | Ford | focus | Grey | Misc - Non Traffic Offences | None | eddish road | Eddish Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4833672 | -1.7871439 | ||
| 4127 | op-snap---monthly-publication-december-2025.pdf | 255 | 2025-12 | Car | Volkswagen | Golf | Grey | Misc - Non Traffic Offences | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 4325 | op-snap---monthly-publication-december-2025.pdf | 453 | 2025-12 | Car | Yamaha | 125 | Grey | Misc - Non Traffic Offences | None | A38 (M) | A38 (M) | Birmingham | Birmingham | Court | N/A | 52.5096656 | -1.8611835 | ||
| 4483 | op-snap---monthly-publication-december-2025.pdf | 611 | 2025-12 | Car | Volkswagen | Tiguan | Grey | Misc - Non Traffic Offences | None | A45 | A45 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4594 | op-snap---monthly-publication-december-2025.pdf | 722 | 2025-12 | Car | Misc - Non Traffic Offences | None | startford road | Stratford Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4203897 | -1.8338574 | |||||
| 4596 | op-snap---monthly-publication-december-2025.pdf | 724 | 2025-12 | Car | Volvo | xc90 | Grey | Misc - Non Traffic Offences | None | birchfield road | Birchfield Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5170745 | -1.9012542 | ||
| 4627 | op-snap---monthly-publication-december-2025.pdf | 755 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4683 | op-snap---monthly-publication-december-2025.pdf | 811 | 2025-12 | Car | Volkswagen | Polo | Black | Misc - Non Traffic Offences | None | Garretts Green Lane | Garretts Green Lane | Birmingham | Birmingham | NFA | No Offence | 52.4675802 | -1.7905748 | ||
| 4768 | op-snap---monthly-publication-december-2025.pdf | 896 | 2025-12 | Car | Volkswagen | TAIGO | Green | Misc - Non Traffic Offences | None | sainsburys castle vale | Sainsburys Castle Vale | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5168269 | -1.7940387 | ||
| 4823 | op-snap---monthly-publication-december-2025.pdf | 951 | 2025-12 | Car | Hyundai | Ioniq | Black | Misc - Non Traffic Offences | None | Alridge Road | Aldridge Road | Birmingham | Birmingham | NFA | No Offence | 52.5368764 | -1.8976461 | ||
| 4824 | op-snap---monthly-publication-december-2025.pdf | 952 | 2025-12 | Car | Vauxhall | Vivaro | Blue | Misc - Non Traffic Offences | None | Startford Road | Stratford Road | Birmingham | Birmingham | NFA | No VRM | 52.4203897 | -1.8338574 | ||
| 4874 | op-snap---monthly-publication-december-2025.pdf | 1002 | 2025-12 | Car | Renault | Captur | Black | Misc - Non Traffic Offences | Use vehicle on a road withou | tI lvsaalnidd tReosat dc ertificate | t I lvsaalnidd t Reosat dc ertificate | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 4875 | op-snap---monthly-publication-december-2025.pdf | 1003 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4893 | op-snap---monthly-publication-december-2025.pdf | 1021 | 2025-12 | Car | Seat | Leon | Black | Misc - Non Traffic Offences | none | A4040 Island Road | Island Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5095686 | -1.9544485 | ||
| 4960 | op-snap---monthly-publication-december-2025.pdf | 1088 | 2025-12 | Car | Porsche | Cayenne | Silver | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4995 | op-snap---monthly-publication-december-2025.pdf | 1123 | 2025-12 | Car | Peugeot | 107 | Black | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 5084 | op-snap---monthly-publication-december-2025.pdf | 1212 | 2025-12 | Car | Kia | Ceed | White | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 5167 | op-snap---monthly-publication-december-2025.pdf | 1295 | 2025-12 | Car | Ford | Fiesta | White | Misc - Non Traffic Offences | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | Other Action Taken | Misc Inc Crimes | 52.4804926 | -1.8563658 | ||
| 20500 | op-snap---monthly-publication-november-2025.pdf | 42 | 2025-11 | Car | Mercedes-Benz | Vito | Black | Misc - Non Traffic Offences | None | Bordesley Circus | Bordesley Circus | Birmingham | Birmingham | NFA | No Offence | 52.4728608 | -1.8754722 | ||
| 20727 | op-snap---monthly-publication-november-2025.pdf | 269 | 2025-11 | Car | Vauxhall | Insignia | Brown | Misc - Non Traffic Offences | None | Richmond Road | Richmond Road | Birmingham | Birmingham | NFA | No Offence | 52.566947 | -1.8291809 | ||
| 20853 | op-snap---monthly-publication-november-2025.pdf | 395 | 2025-11 | Car | BMW | X5 | Grey | Misc - Non Traffic Offences | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | NFA | No Offence | 52.5138106 | -1.797297 | ||
| 20862 | op-snap---monthly-publication-november-2025.pdf | 404 | 2025-11 | Car | Ford | cmax | Black | Misc - Non Traffic Offences | None | gilpin close | Gilpin Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4990396 | -1.8229018 | ||
| 20997 | op-snap---monthly-publication-november-2025.pdf | 539 | 2025-11 | Car | Audi | a7 | Black | Misc - Non Traffic Offences | None | salford circus | Salford Circus | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5095071 | -1.8593732 | ||
| 21030 | op-snap---monthly-publication-november-2025.pdf | 572 | 2025-11 | Car | Mercedes-Benz | C220 | Silver | Misc - Non Traffic Offences | None | Lincoln Street | Lincoln Street | Birmingham | Birmingham | Warning Letter | N/A | 52.459298 | -1.8933648 | ||
| 21113 | op-snap---monthly-publication-november-2025.pdf | 655 | 2025-11 | Car | Misc - Non Traffic Offences | None | Snow Hill Car Park | Snow Hill Car Park | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4835821 | -1.8993799 | |||||
| 21131 | op-snap---monthly-publication-november-2025.pdf | 673 | 2025-11 | Car | Misc - Non Traffic Offences | None | New Town Row | New Town Row | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4896513 | -1.8947514 | |||||
| 21398 | op-snap---monthly-publication-november-2025.pdf | 940 | 2025-11 | Car | Ford | explorer | Blue | Misc - Non Traffic Offences | None | titford road | Titford Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21425 | op-snap---monthly-publication-november-2025.pdf | 967 | 2025-11 | Car | Misc - Non Traffic Offences | None | Dawson Roaad | Dawson Roaad | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 21435 | op-snap---monthly-publication-november-2025.pdf | 977 | 2025-11 | Car | Ford | Fiesta | Black | Misc - Non Traffic Offences | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 21462 | op-snap---monthly-publication-november-2025.pdf | 1004 | 2025-11 | Car | Misc - Non Traffic Offences | None | m6 | M6 | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 21497 | op-snap---monthly-publication-november-2025.pdf | 1039 | 2025-11 | Car | Citroen | picasso | Blue | Misc - Non Traffic Offences | None | harborne high street | Harborne High Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.459563 | -1.946922 | ||
| 21652 | op-snap---monthly-publication-november-2025.pdf | 1194 | 2025-11 | Car | Toyota | prius | Silver | Misc - Non Traffic Offences | None | icknield port road | Icknield Port Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4792334 | -1.92925 | ||
| 21750 | op-snap---monthly-publication-november-2025.pdf | 1292 | 2025-11 | Car | Misc - Non Traffic Offences | None | soho road | Soho Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.502568 | -1.9305447 | |||||
| 21751 | op-snap---monthly-publication-november-2025.pdf | 1293 | 2025-11 | Car | Vauxhall | corsa | Red | Misc - Non Traffic Offences | None | coventry road | Coventry Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4726661 | -1.8769032 | ||
| 21875 | op-snap---monthly-publication-november-2025.pdf | 1417 | 2025-11 | Car | Toyota | chr | White | Misc - Non Traffic Offences | None | gerrards street | Gerrards Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21890 | op-snap---monthly-publication-november-2025.pdf | 1432 | 2025-11 | Car | Honda | cb600 | Silver | Misc - Non Traffic Offences | None | alcester road south | Alcester Road South | Birmingham | Birmingham | Other Action Taken | Misc Inc Crimes | 52.4170522 | -1.8906187 | ||
| 21891 | op-snap---monthly-publication-november-2025.pdf | 1433 | 2025-11 | Car | BMW | I4 | Grey | Misc - Non Traffic Offences | None | high street, kings heath | High Street, Kings Heath | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4353506 | -1.8927483 | ||
| 21907 | op-snap---monthly-publication-november-2025.pdf | 1449 | 2025-11 | Car | Misc - Non Traffic Offences | None | chapel street | Chapel Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5018023 | -1.9478681 | |||||
| 21908 | op-snap---monthly-publication-november-2025.pdf | 1450 | 2025-11 | Car | Misc - Non Traffic Offences | None | holy head road | Holy Head Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 21909 | op-snap---monthly-publication-november-2025.pdf | 1451 | 2025-11 | Car | Misc - Non Traffic Offences | None | chapel street | Chapel Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5018023 | -1.9478681 | |||||
| 21910 | op-snap---monthly-publication-november-2025.pdf | 1452 | 2025-11 | Car | Toyota | yaris | Silver | Misc - Non Traffic Offences | None | george road | George Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5155831 | -1.8598862 | ||
| 22113 | op-snap---monthly-publication-october-2025.pdf | 63 | 2025-10 | Car | Toyota | Estima | Silver | Misc - Non Traffic Offences | None | Barton Lodge Road | Barton Lodge Road | Birmingham | Birmingham | NFA | No Offence | 52.4154349 | -1.8472336 | ||
| 22227 | op-snap---monthly-publication-october-2025.pdf | 177 | 2025-10 | Car | Seat | Ibiza | Red | Misc - Non Traffic Offences | None | Kidderminster Road | Kidderminster Road | Birmingham | Birmingham | NFA | Out of Force | ||||
| 22320 | op-snap---monthly-publication-october-2025.pdf | 270 | 2025-10 | Car | Toyota | Auris | Red | Misc - Non Traffic Offences | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 22333 | op-snap---monthly-publication-october-2025.pdf | 283 | 2025-10 | Car | Audi | Q5 | Blue | Misc - Non Traffic Offences | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4745488 | -1.8065911 | ||
| 22409 | op-snap---monthly-publication-october-2025.pdf | 359 | 2025-10 | Car | Volkswagen | Golf | Black | Misc - Non Traffic Offences | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4221526 | -1.8425617 | ||
| 22471 | op-snap---monthly-publication-october-2025.pdf | 421 | 2025-10 | Car | Ford | Fiesta | Black | Misc - Non Traffic Offences | None | M42 Jct 4 | M42 Junction 4 | Birmingham | Birmingham | NFA | No Offence | ||||
| 22681 | op-snap---monthly-publication-october-2025.pdf | 631 | 2025-10 | Car | Misc - Non Traffic Offences | None | Kingston Road | Kingston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4747333 | -1.8728345 | |||||
| 22723 | op-snap---monthly-publication-october-2025.pdf | 673 | 2025-10 | Car | Toyota | Prius | Black | Misc - Non Traffic Offences | None | Hill Street | Hill Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4777765 | -1.901321 | ||
| 22753 | op-snap---monthly-publication-october-2025.pdf | 703 | 2025-10 | Car | Toyota | Prius | White | Misc - Non Traffic Offences | None | Queslett Road | Queslett Road | Birmingham | Birmingham | NFA | No Offence | 52.5458699 | -1.9304484 | ||
| 23143 | op-snap---monthly-publication-october-2025.pdf | 1093 | 2025-10 | Car | Skoda | fabia | Black | Misc - Non Traffic Offences | None | eddish road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 23152 | op-snap---monthly-publication-october-2025.pdf | 1102 | 2025-10 | Car | Vauxhall | Astra | White | Misc - Non Traffic Offences | None | Eachlehurst Road | Eachlehurst Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23195 | op-snap---monthly-publication-october-2025.pdf | 1145 | 2025-10 | Car | Skoda | citigo | Red | Misc - Non Traffic Offences | None | Boardesley green road | Boardesley green road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 23196 | op-snap---monthly-publication-october-2025.pdf | 1146 | 2025-10 | Car | Ford | Pickup | White | Misc - Non Traffic Offences | None | m6 south | M6 South | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4031308 | -2.0142003 | ||
| 23244 | op-snap---monthly-publication-october-2025.pdf | 1194 | 2025-10 | Car | Ford | Ranger | Blue | Misc - Non Traffic Offences | None | Warwick Road | Warwick Road | Birmingham | Birmingham | NFA | No Offence | 52.4555288 | -1.8613929 | ||
| 23309 | op-snap---monthly-publication-october-2025.pdf | 1259 | 2025-10 | Car | Toyota | Prius | White | Misc - Non Traffic Offences | None | Gret charles street | Gret charles street | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 23310 | op-snap---monthly-publication-october-2025.pdf | 1260 | 2025-10 | Car | Toyota | yaris | Grey | Misc - Non Traffic Offences | None | great charles street | Great Charles Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4837518 | -1.901874 | ||
| 23478 | op-snap---monthly-publication-october-2025.pdf | 1428 | 2025-10 | Car | Misc - Non Traffic Offences | None | kingston road | Kingston Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4747333 | -1.8728345 | |||||
| 23494 | op-snap---monthly-publication-october-2025.pdf | 1444 | 2025-10 | Car | Volkswagen | Polo | Silver | Misc - Non Traffic Offences | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.502683 | -1.9033516 | ||
| 23511 | op-snap---monthly-publication-october-2025.pdf | 1461 | 2025-10 | Car | Honda | Civic | Blue | Misc - Non Traffic Offences | None | M5 | M5 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 23604 | op-snap---monthly-publication-october-2025.pdf | 1554 | 2025-10 | Car | Seat | Leon | Black | Misc - Non Traffic Offences | None | A452 | A452 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23896 | op-snap---monthly-publication-september-2025.pdf | 115 | 2025-09 | Car | Misc - Non Traffic Offences | None | Cape Hill | Cape Hill | Birmingham | Birmingham | RTC - Actioned | N/A | |||||||
| 24124 | op-snap---monthly-publication-september-2025.pdf | 343 | 2025-09 | Car | UNKNOWN | Misc - Non Traffic Offences | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No VRM | 52.4543565 | -1.9114004 | ||||
| 24249 | op-snap---monthly-publication-september-2025.pdf | 468 | 2025-09 | Car | Vauxhall | Astra | Blue | Misc - Non Traffic Offences | None | Kitts Green Road | Kitts Green Road | Birmingham | Birmingham | NFA | No Offence | 52.4815372 | -1.7766518 | ||
| 24250 | op-snap---monthly-publication-september-2025.pdf | 469 | 2025-09 | Car | BMW | 320d | Black | Misc - Non Traffic Offences | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | NFA | No Offence | 52.470423 | -1.9304786 | ||
| 24359 | op-snap---monthly-publication-september-2025.pdf | 578 | 2025-09 | Car | Volkswagen | Caddy | White | Misc - Non Traffic Offences | None | M6 North | M6 North | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5143137 | -1.7683873 | ||
| 24384 | op-snap---monthly-publication-september-2025.pdf | 603 | 2025-09 | Car | Toyota | Hilux | Black | Misc - Non Traffic Offences | None | Rookery Road | Rookery Road | Birmingham | Birmingham | NFA | No VRM | 52.5076603 | -1.9405515 | ||
| 24390 | op-snap---monthly-publication-september-2025.pdf | 609 | 2025-09 | Car | Land Rover | Discovery | Blue | Misc - Non Traffic Offences | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | NFA | No Offence | 52.470423 | -1.9304786 | ||
| 24480 | op-snap---monthly-publication-september-2025.pdf | 699 | 2025-09 | Car | Iveco | S-Way | White | Misc - Non Traffic Offences | None | M42 Motorway, northbound | M42 Motorway, northbound | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 24484 | op-snap---monthly-publication-september-2025.pdf | 703 | 2025-09 | Car | Volvo | XC90 | Blue | Misc - Non Traffic Offences | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | No Offence | 52.5113867 | -1.8337258 | ||
| 24556 | op-snap---monthly-publication-september-2025.pdf | 775 | 2025-09 | Car | Volkswagen | Golf | Grey | Misc - Non Traffic Offences | None | Formans Road | Formans Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.4482024 | -1.8507493 | ||
| 24677 | op-snap---monthly-publication-september-2025.pdf | 896 | 2025-09 | Car | Jaguar | e Pace | Grey | Misc - Non Traffic Offences | None | Multi-story car park of Utilia Arena | Multi-story car park of Utilia Arena | Birmingham | Birmingham | NFA | No Offence | ||||
| 24820 | op-snap---monthly-publication-september-2025.pdf | 1039 | 2025-09 | Car | Peugeot | 2008 | Black | Misc - Non Traffic Offences | Use vehicle on a road without valid test certificate | Chester Road / College Road | Chester Road / College Road | Birmingham | Birmingham | NFA | No VRM | 52.5460025 | -1.8572602 | ||
| 24988 | op-snap---monthly-publication-september-2025.pdf | 1207 | 2025-09 | Car | Skoda | karoq | White | Misc - Non Traffic Offences | None | A45 coventry road | A45 coventry road | Birmingham | Birmingham | Warning Letter | N/A | 52.4714538 | -1.8627901 | ||
| 24989 | op-snap---monthly-publication-september-2025.pdf | 1208 | 2025-09 | Car | Volkswagen | passat | Grey | Misc - Non Traffic Offences | None | M5 | M5 | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 25048 | op-snap---monthly-publication-september-2025.pdf | 1267 | 2025-09 | Car | Vauxhall | combo | White | Misc - Non Traffic Offences | None | Rookery Rooad | Rookery Rooad | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 25097 | op-snap---monthly-publication-september-2025.pdf | 1316 | 2025-09 | Car | Nissan | leaf | Red | Misc - Non Traffic Offences | None | islingtonrow | Islingtonrow | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 25155 | op-snap---monthly-publication-september-2025.pdf | 1374 | 2025-09 | Car | Vauxhall | Crossalnd | Black | Misc - Non Traffic Offences | None | victoria street | Victoria Street | Birmingham | Birmingham | NFA | No Offence | 52.4751651 | -1.8559775 | ||
| 25164 | op-snap---monthly-publication-september-2025.pdf | 1383 | 2025-09 | Car | Audi | A4 | White | Misc - Non Traffic Offences | None | Burlington Road | Burlington Road | Birmingham | Birmingham | NFA | No Offence | 52.4744358 | -1.8427399 |
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);