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'}
238 rows where council_area = "Birmingham", disposal = "NFA" and month = "2025-11" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 15
- Driving without Due Care and Attention 68
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 62
- Misc - Non Traffic Offences 38
- Contravening a Red Traffic Light 25
- Using a Mobile Phone Whilst Driving 19
- Cause vehicle to be left in a dangerous position 13
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- No Seat Belt 2
- Stop a vehicle on pedestrian crossing 2
- Drive a vehicle other than on the carriageway of a motorway 1
- Driver not in position to have Proper Control 1
- Driving without Reasonable Consideration 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Waiting on a road in a prohibited area 1
reporter_transport_mode 7
- Car 151
- Pedestrian 56
- Pedal Bike 19
- Other 8
- Motorbike 2
- Lorry 1
- Van 1
month 1
- 2025-11 · 238 ✖
disposal 1
- NFA · 238 ✖
council_area 1
- Birmingham · 238 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20459 | op-snap---monthly-publication-november-2025.pdf | 1 | 2025-11 | Pedestrian | Vauxhall | insignia | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 20460 | op-snap---monthly-publication-november-2025.pdf | 2 | 2025-11 | Pedestrian | Mercedes-Benz | b200 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 20461 | op-snap---monthly-publication-november-2025.pdf | 3 | 2025-11 | Pedestrian | Peugeot | 107 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 20465 | op-snap---monthly-publication-november-2025.pdf | 7 | 2025-11 | Car | Ferrari | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bath Row, Birmingham | Bath Row, Birmingham | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4729953 | -1.905901 | |||
| 20484 | op-snap---monthly-publication-november-2025.pdf | 26 | 2025-11 | Car | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 20485 | op-snap---monthly-publication-november-2025.pdf | 27 | 2025-11 | Other | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Beauchamp Road | Beauchamp Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4209386 | -1.8699242 | ||
| 20489 | op-snap---monthly-publication-november-2025.pdf | 31 | 2025-11 | Car | Jaecoo | Delux | Black | Driving without Reasonable Consideration | None | M42 Solihull | M42 Solihull | Birmingham | Birmingham | NFA | No Offence | 52.4711059 | -1.8461809 | ||
| 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 | ||
| 20521 | op-snap---monthly-publication-november-2025.pdf | 63 | 2025-11 | Car | Mercedes-Benz | C220 | Grey | Driving without Due Care and Attention | No Insurance | Collector Road | Collector Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.5139393 | -1.7600186 | ||
| 20533 | op-snap---monthly-publication-november-2025.pdf | 75 | 2025-11 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | M6 | M6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 20537 | op-snap---monthly-publication-november-2025.pdf | 79 | 2025-11 | Car | Mercedes-Benz | E250 | Silver | Contravening a Red Traffic Light | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.502683 | -1.9033516 | ||
| 20553 | op-snap---monthly-publication-november-2025.pdf | 95 | 2025-11 | Car | Volkswagen | Amarok | Black | Using a Mobile Phone Whilst Driving | None | Watery Lane Middleway | Watery Lane Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4752679 | -1.8748608 | ||
| 20555 | op-snap---monthly-publication-november-2025.pdf | 97 | 2025-11 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Belmont Row | Belmont Row | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4840765 | -1.8819479 | ||
| 20558 | op-snap---monthly-publication-november-2025.pdf | 100 | 2025-11 | Car | Toyota | Yaris | White | Waiting on a road in a prohibited area | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4437078 | -1.8783408 | ||
| 20566 | op-snap---monthly-publication-november-2025.pdf | 108 | 2025-11 | Pedestrian | Dacia | sandro | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.430111 | -1.9753703 | ||
| 20567 | op-snap---monthly-publication-november-2025.pdf | 109 | 2025-11 | Car | Audi | S6 | Silver | Driving without Due Care and Attention | None | M6 NB J6 | M6 Northbound J6 | Birmingham | Birmingham | NFA | No Offence | 52.676119 | -2.0858425 | ||
| 20570 | op-snap---monthly-publication-november-2025.pdf | 112 | 2025-11 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Midland Road | Midland Road | Birmingham | Birmingham | NFA | No Offence | 52.4190372 | -1.9294685 | ||
| 20629 | op-snap---monthly-publication-november-2025.pdf | 171 | 2025-11 | Pedal Bike | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5027779 | -1.7982159 | ||
| 20649 | op-snap---monthly-publication-november-2025.pdf | 191 | 2025-11 | Car | Vauxhall | Astra | Red | Driving without Due Care and Attention | None | Newbury Road | Newbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4993019 | -1.8964495 | ||
| 20650 | op-snap---monthly-publication-november-2025.pdf | 192 | 2025-11 | Car | Mercedes-Benz | CLA | Grey | Driving without Due Care and Attention | None | Newbury Road | Newbury Road | Birmingham | Birmingham | NFA | No Offence | 52.4993019 | -1.8964495 | ||
| 20656 | op-snap---monthly-publication-november-2025.pdf | 198 | 2025-11 | Lorry | Misc - Non Traffic Offences | None | M6 | M6 | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 20666 | op-snap---monthly-publication-november-2025.pdf | 208 | 2025-11 | Car | Mercedes-Benz | Blue | Contravening a Red Traffic Light | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4967329 | -1.8097462 | |||
| 20679 | op-snap---monthly-publication-november-2025.pdf | 221 | 2025-11 | Car | BMW | 320.. | Silver | No Seat Belt | None | Dudley Road | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4865107 | -1.9386263 | ||
| 20692 | op-snap---monthly-publication-november-2025.pdf | 234 | 2025-11 | Car | Citroen | Grey | Driving without Due Care and Attention | None | M42 SB | M42 Southbound | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 20707 | op-snap---monthly-publication-november-2025.pdf | 249 | 2025-11 | Car | Volkswagen | T-roc | White | Driving without Due Care and Attention | None | Newton Road | Newton Road | Birmingham | Birmingham | NFA | No Offence | 52.4541102 | -1.8710993 | ||
| 20708 | op-snap---monthly-publication-november-2025.pdf | 250 | 2025-11 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4391028 | -1.893289 | ||
| 20709 | op-snap---monthly-publication-november-2025.pdf | 251 | 2025-11 | Car | Volkswagen | T Roc | Grey | Driving without Due Care and Attention | None | Short Heath Road | Short Heath Road | Birmingham | Birmingham | NFA | No Offence | 52.5302344 | -1.8505439 | ||
| 20713 | op-snap---monthly-publication-november-2025.pdf | 255 | 2025-11 | Car | Mercedes-Benz | A Class | White | Using a Mobile Phone Whilst Driving | None | Sutton New Road | Sutton New Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5260956 | -1.8379401 | ||
| 20716 | op-snap---monthly-publication-november-2025.pdf | 258 | 2025-11 | Car | Mercedes-Benz | A200 | White | Driving without Due Care and Attention | None | High Street, Erdington | High Street, Erdington | Birmingham | Birmingham | NFA | No Offence | 52.5256828 | -1.8373143 | ||
| 20718 | op-snap---monthly-publication-november-2025.pdf | 260 | 2025-11 | Car | Mercedes-Benz | A200 | White | Driving without Due Care and Attention | None | High Street Erdington | High Street Erdington | Birmingham | Birmingham | NFA | No Offence | 52.5257176 | -1.8373568 | ||
| 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 | ||
| 20735 | op-snap---monthly-publication-november-2025.pdf | 277 | 2025-11 | Car | Honda | CRV | Grey | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Offence | 52.4726661 | -1.8769032 | ||
| 20737 | op-snap---monthly-publication-november-2025.pdf | 279 | 2025-11 | Car | Audi | S3 | Black | Contravening a Red Traffic Light | None | Mackadown Lane | Mackadown Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4708415 | -1.7675939 | ||
| 20739 | op-snap---monthly-publication-november-2025.pdf | 281 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Oxhill Road Handsworth | Oxhill Road Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.513857 | -1.9367367 | ||
| 20760 | op-snap---monthly-publication-november-2025.pdf | 302 | 2025-11 | Motorbike | BMW | 320D | Grey | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4591339 | -1.9601054 | ||
| 20776 | op-snap---monthly-publication-november-2025.pdf | 318 | 2025-11 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Offence | 52.4679402 | -1.881408 | ||
| 20783 | op-snap---monthly-publication-november-2025.pdf | 325 | 2025-11 | Car | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | A450 Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | NFA | No Offence | 52.4720132 | -1.9142946 | ||
| 20787 | op-snap---monthly-publication-november-2025.pdf | 329 | 2025-11 | Car | BMW | X7 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | College Road | College Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5151832 | -1.9361664 | ||
| 20795 | op-snap---monthly-publication-november-2025.pdf | 337 | 2025-11 | Car | Ford | Ranger | Blue | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.5274116 | -1.9287273 | ||
| 20808 | op-snap---monthly-publication-november-2025.pdf | 350 | 2025-11 | Car | BMW | 118D | Black | Using a Mobile Phone Whilst Driving | None | A45 | A45 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 20810 | op-snap---monthly-publication-november-2025.pdf | 352 | 2025-11 | Car | Renault | Scenic | Blue | Contravening a Red Traffic Light | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.513857 | -1.9367367 | ||
| 20811 | op-snap---monthly-publication-november-2025.pdf | 353 | 2025-11 | Car | Byd | Atto | Grey | Driving without Due Care and Attention | None | Middlemore Road | Middlemore Road | Birmingham | Birmingham | NFA | No Offence | 52.4091255 | -1.957673 | ||
| 20812 | op-snap---monthly-publication-november-2025.pdf | 354 | 2025-11 | Car | BMW | 320D | Blue | Contravening a Red Traffic Light | None | Grove Lane | Grove Lane | Birmingham | Birmingham | NFA | No VRM | 52.5055208 | -1.9328067 | ||
| 20816 | op-snap---monthly-publication-november-2025.pdf | 358 | 2025-11 | Car | Toyota | Grey | Motor vehicle fail to accord precedence at a pelican crossing | None | A4040 Church Lane | Church Lane | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5030217 | -1.8764632 | |||
| 20846 | op-snap---monthly-publication-november-2025.pdf | 388 | 2025-11 | Car | Land Rover | Discovery | Red | Driving without Due Care and Attention | None | A452 Collector | Collector | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 20847 | op-snap---monthly-publication-november-2025.pdf | 389 | 2025-11 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | A452 | A452 | Birmingham | Birmingham | NFA | No Offence | ||||
| 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 | ||
| 20857 | op-snap---monthly-publication-november-2025.pdf | 399 | 2025-11 | Car | Suzuki | Ibiza | Grey | Using a Mobile Phone Whilst Driving | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | NFA | No Offence | 52.4415108 | -1.8971434 | ||
| 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 | ||
| 20866 | op-snap---monthly-publication-november-2025.pdf | 408 | 2025-11 | Car | Kia | Picanto | Black | Driving without Due Care and Attention | None | M6 Junction 7 | M6 Junction 7 | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.676119 | -2.0858425 | ||
| 20870 | op-snap---monthly-publication-november-2025.pdf | 412 | 2025-11 | Car | Volkswagen | Golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 20879 | op-snap---monthly-publication-november-2025.pdf | 421 | 2025-11 | Car | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | NFA | No VRM | 52.4762784 | -1.9678366 | |||||
| 20908 | op-snap---monthly-publication-november-2025.pdf | 450 | 2025-11 | Pedestrian | Ford | Fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane | Holly Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5236889 | -1.8253311 | ||
| 20930 | op-snap---monthly-publication-november-2025.pdf | 472 | 2025-11 | Car | Audi | Q3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4967329 | -1.8097462 | ||
| 20934 | op-snap---monthly-publication-november-2025.pdf | 476 | 2025-11 | Car | Honda | Jazz | Grey | Contravening a Red Traffic Light | None | Winson Green Road | Winson Green Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4870332 | -1.9373713 | ||
| 20942 | op-snap---monthly-publication-november-2025.pdf | 484 | 2025-11 | Pedestrian | Kia | Stonic | Red | No Seat Belt | None | Martineau Drive | Martineau Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4621711 | -1.9776235 | ||
| 20962 | op-snap---monthly-publication-november-2025.pdf | 504 | 2025-11 | Pedestrian | Citroen | berlingo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | woodland road | Woodland Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4108681 | -1.9611917 | ||
| 20987 | op-snap---monthly-publication-november-2025.pdf | 529 | 2025-11 | Pedestrian | Honda | frv | Grey | Misc - Non Traffic Offences | None | Longbridge | Longbridge | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.3940521 | -1.9807506 | ||
| 20989 | op-snap---monthly-publication-november-2025.pdf | 531 | 2025-11 | Pedestrian | Volkswagen | golf | Black | Misc - Non Traffic Offences | None | alderbrook road | Alderbrook Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 20992 | op-snap---monthly-publication-november-2025.pdf | 534 | 2025-11 | Pedestrian | Seat | Ateca | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | pershore road | Pershore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4308271 | -1.920078 | ||
| 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 | ||
| 20998 | op-snap---monthly-publication-november-2025.pdf | 540 | 2025-11 | Pedestrian | Volkswagen | touran | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4307 | -1.8494663 | ||
| 20999 | op-snap---monthly-publication-november-2025.pdf | 541 | 2025-11 | Car | Kia | niro | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | hagley road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 21001 | op-snap---monthly-publication-november-2025.pdf | 543 | 2025-11 | Car | Mercedes-Benz | C220 | Grey | Driving without Due Care and Attention | None | Newbury Road | Newbury Road | Birmingham | Birmingham | NFA | No Offence | 52.4993019 | -1.8964495 | ||
| 21006 | op-snap---monthly-publication-november-2025.pdf | 548 | 2025-11 | Pedal Bike | Volkswagen | Golf | Silver | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4943878 | -1.8504211 | ||
| 21012 | op-snap---monthly-publication-november-2025.pdf | 554 | 2025-11 | Car | BMW | M3 | Grey | Driving without Due Care and Attention | None | M6 Jct 6 | M6 Junction 6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.676119 | -2.0858425 | ||
| 21017 | op-snap---monthly-publication-november-2025.pdf | 559 | 2025-11 | Car | Nissan | Juke | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 21047 | op-snap---monthly-publication-november-2025.pdf | 589 | 2025-11 | Pedestrian | Misc - Non Traffic Offences | None | goodyear road | Goodyear Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 21056 | op-snap---monthly-publication-november-2025.pdf | 598 | 2025-11 | Car | Daf | Tipper | White | Contravening a Red Traffic Light | None | Walmley Road | Walmley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5534398 | -1.7987049 | ||
| 21058 | op-snap---monthly-publication-november-2025.pdf | 600 | 2025-11 | Car | BMW | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monkspath | Monkspath | Birmingham | Birmingham | NFA | No Offence | 52.5441651 | -1.7964249 | |||
| 21062 | op-snap---monthly-publication-november-2025.pdf | 604 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | 52.471632 | -1.9456776 | ||
| 21063 | op-snap---monthly-publication-november-2025.pdf | 605 | 2025-11 | Car | Vauxhall | MPV | white | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | 52.471632 | -1.9456776 | ||
| 21106 | op-snap---monthly-publication-november-2025.pdf | 648 | 2025-11 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Alderbrooke Road | Alderbrooke Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 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 | |||||
| 21135 | op-snap---monthly-publication-november-2025.pdf | 677 | 2025-11 | Pedestrian | Audi | RSQ8 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4456462 | -1.827993 | ||
| 21136 | op-snap---monthly-publication-november-2025.pdf | 678 | 2025-11 | Pedestrian | Renault | Clio | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 21137 | op-snap---monthly-publication-november-2025.pdf | 679 | 2025-11 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 21138 | op-snap---monthly-publication-november-2025.pdf | 680 | 2025-11 | Pedestrian | Vauxhall | Astra | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4374665 | -1.9119895 | ||
| 21143 | op-snap---monthly-publication-november-2025.pdf | 685 | 2025-11 | Car | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anglesey Street | Anglesey Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5000379 | -1.9102942 | ||
| 21160 | op-snap---monthly-publication-november-2025.pdf | 702 | 2025-11 | Car | Peugeot | 208 | Yellow | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5458699 | -1.9304484 | ||
| 21171 | op-snap---monthly-publication-november-2025.pdf | 713 | 2025-11 | Pedestrian | Mazda | CX5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Balaclava Road | Balaclava Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4337176 | -1.896658 | ||
| 21178 | op-snap---monthly-publication-november-2025.pdf | 720 | 2025-11 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | |||||
| 21184 | op-snap---monthly-publication-november-2025.pdf | 726 | 2025-11 | Car | Citroen | C3 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4833672 | -1.7871439 | ||
| 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 | ||
| 21193 | op-snap---monthly-publication-november-2025.pdf | 735 | 2025-11 | Car | Audi | A3 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5065077 | -1.892207 | ||
| 21238 | op-snap---monthly-publication-november-2025.pdf | 780 | 2025-11 | Car | Audi | S3 | Black | Driving without Due Care and Attention | No Insurance | Old Postway, Handsworth | Old Postway, Handsworth | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 21270 | op-snap---monthly-publication-november-2025.pdf | 812 | 2025-11 | Car | Audi | Q3 | Grey | Driving without Due Care and Attention | None | Icknield Street | Icknield Street | Birmingham | Birmingham | NFA | No Offence | 52.5709191 | -1.8759339 | ||
| 21272 | op-snap---monthly-publication-november-2025.pdf | 814 | 2025-11 | Car | Toyota | Auris | Silver | Contravening a Red Traffic Light | None | Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 21287 | op-snap---monthly-publication-november-2025.pdf | 829 | 2025-11 | Pedestrian | Ford | fiesta | Silver | Misc - Non Traffic Offences | None | sir hiltons road | Sir Hiltons Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.3932637 | -1.9575554 | ||
| 21292 | op-snap---monthly-publication-november-2025.pdf | 834 | 2025-11 | Pedestrian | BMW | 320D | Grey | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 21311 | op-snap---monthly-publication-november-2025.pdf | 853 | 2025-11 | Car | Ford | toureno | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 21314 | op-snap---monthly-publication-november-2025.pdf | 856 | 2025-11 | Car | Vauxhall | corsa | Blue | Cause vehicle to be left in a dangerous position | None | eddish road | Eddish Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4833672 | -1.7871439 | ||
| 21315 | op-snap---monthly-publication-november-2025.pdf | 857 | 2025-11 | Other | Yamaha | GPD 125 | Red | Driving without Due Care and Attention | None | No Offence Location given | No Offence Location given | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 21320 | op-snap---monthly-publication-november-2025.pdf | 862 | 2025-11 | Pedestrian | Toyota | Avensis | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | kings heath highstreet | Kings Heath Highstreet | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21329 | op-snap---monthly-publication-november-2025.pdf | 871 | 2025-11 | Pedestrian | Misc - Non Traffic Offences | None | shirley road | Shirley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4198291 | -1.9241732 | |||||
| 21340 | op-snap---monthly-publication-november-2025.pdf | 882 | 2025-11 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | handsworth road | Handsworth Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5137414 | -1.9222827 | ||
| 21357 | op-snap---monthly-publication-november-2025.pdf | 899 | 2025-11 | Pedestrian | Audi | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | antrobus road | Antrobus Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5457851 | -1.8457052 | |||
| 21378 | op-snap---monthly-publication-november-2025.pdf | 920 | 2025-11 | Pedestrian | Mercedes-Benz | Cause vehicle to be left in a dangerous position | None | wooten road | Wooten Road | Birmingham | Birmingham | NFA | No Independent Evidence Available |
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);