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'}
811 rows where council_area = "Birmingham", disposal = "NFA" and month = "2025-04" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 25
- Driving without Reasonable Consideration 229
- Cause vehicle to be left in a dangerous position 119
- Driving without Due Care and Attention 104
- Stop a vehicle within pelican pedestrian crossing limits 95
- Contravening a Red Traffic Light 86
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 56
- Stop a vehicle on pedestrian crossing 52
- Misc - Non Traffic Offences 13
- Using a Mobile Phone Whilst Driving 13
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 10
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 8
- Dangerous Driving 3
- Driving a vehicle wholly or partly on a footpath 3
- Fail to Conform to Cycle Lane 3
- Fail to display front VRM plate 3
- Contravene Lane Closure Red X 2
- Driver parked on pedestrian road marked by a white “Zig-zag line” 2
- Motor vehicle fail to comply with solid white line road markings 2
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 2
- Drive on hard shoulder 1
- Duplicate Submission 1
- Keeping a vehicle with registration marks obscured 1
- No Seat Belt 1
- No vehicle excise licence 1
- driving without due care/attention 1
reporter_transport_mode 8
- Car 576
- Pedal Bike 129
- Pedestrian 92
- Other 8
- Lorry 3
- Bus 1
- Van 1
- car 1
month 1
- 2025-04 · 811 ✖
disposal 1
- NFA · 811 ✖
council_area 1
- Birmingham · 811 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46 | op-snap---monthly-publication-april-2025.pdf | 45 | 2025-04 | Pedestrian | Volkswagen | T-roc | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 54 | op-snap---monthly-publication-april-2025.pdf | 53 | 2025-04 | Car | Audi | RS | White | Driving without Due Care and Attention | None | M6 JCT 8 | M6 Jct 8 | Birmingham | Birmingham | NFA | No Offence | 52.6760749 | -2.0862582 | ||
| 84 | op-snap---monthly-publication-april-2025.pdf | 83 | 2025-04 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Island Road | Island Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5095686 | -1.9544485 | ||
| 90 | op-snap---monthly-publication-april-2025.pdf | 89 | 2025-04 | Pedestrian | Toyota | Yaris | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | NFA | No Offence | 52.5292752 | -1.7618805 | ||
| 92 | op-snap---monthly-publication-april-2025.pdf | 91 | 2025-04 | Pedestrian | Mercedes-Benz | C220 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | York Road | York Road | Birmingham | Birmingham | NFA | No Offence | 52.5231321 | -1.8415573 | ||
| 110 | op-snap---monthly-publication-april-2025.pdf | 109 | 2025-04 | Pedestrian | Mercedes-Benz | AMG GT63 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Offence | 52.4679402 | -1.881408 | ||
| 126 | op-snap---monthly-publication-april-2025.pdf | 125 | 2025-04 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Bordesley Green road | Bordesley Green road | Birmingham | Birmingham | NFA | No VRM | 52.4804926 | -1.8563658 | ||
| 140 | op-snap---monthly-publication-april-2025.pdf | 139 | 2025-04 | Pedestrian | Vauxhall | Astra | White | Driving without Due Care and Attention | None | Aston Avenue | Aston Avenue | Birmingham | Birmingham | NFA | No Offence | 52.4961499 | -1.8855814 | ||
| 143 | op-snap---monthly-publication-april-2025.pdf | 142 | 2025-04 | Pedestrian | Audi | TT | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Willow Avenue | Willow Avenue | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4792236 | -1.9652858 | ||
| 144 | op-snap---monthly-publication-april-2025.pdf | 143 | 2025-04 | Car | BMW | Silver | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No VRM | 52.5359496 | -1.8324115 | |||
| 159 | op-snap---monthly-publication-april-2025.pdf | 158 | 2025-04 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Alridge Rd | Aldridge Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5368764 | -1.8976461 | ||
| 170 | op-snap---monthly-publication-april-2025.pdf | 169 | 2025-04 | Car | Driving without Due Care and Attention | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | NFA | No VRM | 52.4709298 | -1.8722585 | |||||
| 183 | op-snap---monthly-publication-april-2025.pdf | 182 | 2025-04 | Lorry | Honda | Civic | Silver | Driving without Due Care and Attention | None | M6 SB J6 | M6 Southbound J6 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.676119 | -2.0858425 | ||
| 184 | op-snap---monthly-publication-april-2025.pdf | 183 | 2025-04 | Pedal Bike | BMW | X1 | White | Driving without Reasonable Consideration | None | Acheson Road | Acheson Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4117199 | -1.8461055 | ||
| 186 | op-snap---monthly-publication-april-2025.pdf | 185 | 2025-04 | Pedestrian | Ford | Kuga | White | No Seat Belt | None | Colebourne Road | Colebourne Road | Birmingham | Birmingham | NFA | No Offence | 52.4284711 | -1.8612796 | ||
| 188 | op-snap---monthly-publication-april-2025.pdf | 187 | 2025-04 | Car | Seat | Leon | White | Contravening a Red Traffic Light | None | Clifford Street | Clifford Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4989738 | -1.9005402 | ||
| 190 | op-snap---monthly-publication-april-2025.pdf | 189 | 2025-04 | Other | Volkswagen | Crafter | Red | Driving a vehicle wholly or partly on a footpath | None | Smallbrook Queensway | Smallbrook Queensway | Birmingham | Birmingham | NFA | No Offence | 52.4772584 | -1.8965734 | ||
| 191 | op-snap---monthly-publication-april-2025.pdf | 190 | 2025-04 | Lorry | Mercedes-Benz | AMG G63 | Blue | Driving without Due Care and Attention | None | M6 NB J6 | M6 Northbound J6 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.676119 | -2.0858425 | ||
| 210 | op-snap---monthly-publication-april-2025.pdf | 209 | 2025-04 | Car | Renault | Trafic | Black | Driving without Due Care and Attention | None | A456 Quinton interchange | Quinton interchange | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 218 | op-snap---monthly-publication-april-2025.pdf | 217 | 2025-04 | Car | Alfa Romeo | Black | Driving without Due Care and Attention | None | Aston Expressway | Aston Expressway | Birmingham | Birmingham | NFA | No VRM | 52.493793 | -1.8881773 | |||
| 231 | op-snap---monthly-publication-april-2025.pdf | 230 | 2025-04 | Pedal Bike | Audi | A4 | White | Driving without Reasonable Consideration | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5113867 | -1.8337258 | ||
| 232 | op-snap---monthly-publication-april-2025.pdf | 231 | 2025-04 | Car | Ford | Focus | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 233 | op-snap---monthly-publication-april-2025.pdf | 232 | 2025-04 | Car | Mercedes-Benz | Sprinter | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 234 | op-snap---monthly-publication-april-2025.pdf | 233 | 2025-04 | Car | Toyota | Aygo | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 235 | op-snap---monthly-publication-april-2025.pdf | 234 | 2025-04 | Car | Toyota | Corolla | Blue | Driving without Due Care and Attention | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 236 | op-snap---monthly-publication-april-2025.pdf | 235 | 2025-04 | Car | Mercedes-Benz | A class | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 237 | op-snap---monthly-publication-april-2025.pdf | 236 | 2025-04 | Car | Kia | Picanto | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 238 | op-snap---monthly-publication-april-2025.pdf | 237 | 2025-04 | Car | Toyota | Prius | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 239 | op-snap---monthly-publication-april-2025.pdf | 238 | 2025-04 | Car | Volkswagen | Golf | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 247 | op-snap---monthly-publication-april-2025.pdf | 246 | 2025-04 | Pedal Bike | Vauxhall | Astra | Silver | Cause vehicle to be left in a dangerous position | None | Beverley Court Road | Beverley Court Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.460932 | -1.999684 | ||
| 255 | op-snap---monthly-publication-april-2025.pdf | 254 | 2025-04 | Pedal Bike | Skoda | Octavia | Blue | Driving without Reasonable Consideration | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5113867 | -1.8337258 | ||
| 257 | op-snap---monthly-publication-april-2025.pdf | 256 | 2025-04 | Car | Mercedes-Benz | G Wagon | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4816806 | -1.8788939 | ||
| 262 | op-snap---monthly-publication-april-2025.pdf | 261 | 2025-04 | Car | Volkswagen | Polo | Silver | Using a Mobile Phone Whilst Driving | None | M6 Jct 7-6 | M6 Junction 7-6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.676119 | -2.0858425 | ||
| 264 | op-snap---monthly-publication-april-2025.pdf | 263 | 2025-04 | Pedestrian | Mercedes-Benz | Vito | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Elizabeth Rd | Elizabeth Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4831858 | -1.817325 | ||
| 267 | op-snap---monthly-publication-april-2025.pdf | 266 | 2025-04 | Pedestrian | Nissan | Micra | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4374665 | -1.9119895 | ||
| 269 | op-snap---monthly-publication-april-2025.pdf | 268 | 2025-04 | Car | Vauxhall | Movano | White | Drive on hard shoulder | None | M42 J6 | M42 J6 | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | ||||
| 271 | op-snap---monthly-publication-april-2025.pdf | 270 | 2025-04 | Car | Volkswagen | Transporter | Black | Contravening a Red Traffic Light | None | Balsall Street | Balsall Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4579985 | -1.8916996 | ||
| 276 | op-snap---monthly-publication-april-2025.pdf | 275 | 2025-04 | Pedal Bike | Audi | A1 | White | Contravening a Red Traffic Light | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 277 | op-snap---monthly-publication-april-2025.pdf | 276 | 2025-04 | Pedestrian | Volkswagen | Tiguan | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4306504 | -1.878052 | ||
| 278 | op-snap---monthly-publication-april-2025.pdf | 277 | 2025-04 | Car | Mercedes-Benz | 300D | Blue | Driving without Reasonable Consideration | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4119174 | -1.9735247 | ||
| 289 | op-snap---monthly-publication-april-2025.pdf | 288 | 2025-04 | Pedal Bike | Nissan | Juke | White | Driving without Reasonable Consideration | None | Lickey Road, Rednal | Lickey Road, Rednal | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.3868298 | -2.0003781 | ||
| 301 | op-snap---monthly-publication-april-2025.pdf | 300 | 2025-04 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Cole Bank Road | Cole Bank Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4349375 | -1.8510007 | ||
| 307 | op-snap---monthly-publication-april-2025.pdf | 306 | 2025-04 | Pedestrian | Ford | Fiesta | Black | Cause vehicle to be left in a dangerous position | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4307 | -1.8494663 | ||
| 308 | op-snap---monthly-publication-april-2025.pdf | 307 | 2025-04 | Pedestrian | Volkswagen | Passat | Black | Cause vehicle to be left in a dangerous position | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4307 | -1.8494663 | ||
| 310 | op-snap---monthly-publication-april-2025.pdf | 309 | 2025-04 | Car | Seat | Leon | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4745488 | -1.8065911 | ||
| 311 | op-snap---monthly-publication-april-2025.pdf | 310 | 2025-04 | Car | Toyota | Auris | White | Driving without Due Care and Attention | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4103191 | -1.8670224 | ||
| 313 | op-snap---monthly-publication-april-2025.pdf | 312 | 2025-04 | Pedal Bike | Skoda | Superb | Blue | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5359496 | -1.8324115 | ||
| 315 | op-snap---monthly-publication-april-2025.pdf | 314 | 2025-04 | Car | BMW | 118d | Black | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.471632 | -1.9456776 | ||
| 316 | op-snap---monthly-publication-april-2025.pdf | 315 | 2025-04 | Car | Nissan | Qashqai | Silver | Driving without Due Care and Attention | None | Russell Road | Russell Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4398245 | -1.8469786 | ||
| 324 | op-snap---monthly-publication-april-2025.pdf | 323 | 2025-04 | Car | Ford | Focus | Red | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 327 | op-snap---monthly-publication-april-2025.pdf | 326 | 2025-04 | Car | Land Rover | Discovery | Grey | Driving without Due Care and Attention | None | Brandwood Road / Broad Lane junction | Brandwood Road / Broad Lane junction | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4139427 | -1.9037653 | ||
| 333 | op-snap---monthly-publication-april-2025.pdf | 332 | 2025-04 | Pedal Bike | Audi | A3... | Grey | Driving without Reasonable Consideration | None | Woodbridge Road Moseley | Woodbridge Road Moseley | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4480261 | -1.8846421 | ||
| 335 | op-snap---monthly-publication-april-2025.pdf | 334 | 2025-04 | Car | Volkswagen | Jetta | Grey | Driving without Due Care and Attention | None | Swan Island Small Heath | Swan Island Small Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 338 | op-snap---monthly-publication-april-2025.pdf | 337 | 2025-04 | Pedal Bike | Mercedes-Benz | C 300 | Black | Driving without Reasonable Consideration | None | Woodbridge Road | Woodbridge Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4482076 | -1.8864335 | ||
| 339 | op-snap---monthly-publication-april-2025.pdf | 338 | 2025-04 | Pedestrian | Skoda | Octavia | White | Misc - Non Traffic Offences | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4307 | -1.8494663 | ||
| 340 | op-snap---monthly-publication-april-2025.pdf | 339 | 2025-04 | Pedal Bike | Volkswagen | Passat | Black | Cause vehicle to be left in a dangerous position | None | Chantry Road | Chantry Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4496376 | -1.8915224 | ||
| 341 | op-snap---monthly-publication-april-2025.pdf | 340 | 2025-04 | Car | Citroen | Panel Van | White | Driving without Due Care and Attention | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4397168 | -1.9260414 | ||
| 342 | op-snap---monthly-publication-april-2025.pdf | 341 | 2025-04 | Van | Toyota | Yaris | Brown | Driving without Due Care and Attention | None | Reservoir Road | Reservoir Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5242452 | -1.8572541 | ||
| 343 | op-snap---monthly-publication-april-2025.pdf | 342 | 2025-04 | Car | Nissan | Qashqai | Red | Driving without Due Care and Attention | None | A45 | A45 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 344 | op-snap---monthly-publication-april-2025.pdf | 343 | 2025-04 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | Belchers Lane | Belchers Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4800061 | -1.833007 | ||
| 348 | op-snap---monthly-publication-april-2025.pdf | 347 | 2025-04 | Car | BMW | I4... | Black | Contravening a Red Traffic Light | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4308271 | -1.920078 | ||
| 353 | op-snap---monthly-publication-april-2025.pdf | 352 | 2025-04 | Car | Brown | Driving without Due Care and Attention | None | COUNON WEDGE DRIVE | Counon Wedge Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||||
| 355 | op-snap---monthly-publication-april-2025.pdf | 354 | 2025-04 | Car | Contravening a Red Traffic Light | None | fletchamstead highway | Fletchamstead Highway | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 357 | op-snap---monthly-publication-april-2025.pdf | 356 | 2025-04 | Car | Ford | TRANSIT | Silver | Contravening a Red Traffic Light | None | FLETCHAMSTEAD HIGHWAY | Fletchamstead Highway | Birmingham | Birmingham | NFA | No Offence | ||||
| 364 | op-snap---monthly-publication-april-2025.pdf | 363 | 2025-04 | Car | Ford | Puma | Black | Cause vehicle to be left in a dangerous position | None | Darwin Street | Darwin Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.468128 | -1.8848315 | ||
| 367 | op-snap---monthly-publication-april-2025.pdf | 366 | 2025-04 | Car | BMW | 218.. | Grey | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5194011 | -1.8008643 | ||
| 368 | op-snap---monthly-publication-april-2025.pdf | 367 | 2025-04 | Car | Seat | leon | Red | Contravening a Red Traffic Light | None | BROMFORD | Bromford | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5049062 | -1.8152832 | ||
| 374 | op-snap---monthly-publication-april-2025.pdf | 373 | 2025-04 | Car | BMW | 320i | Blue | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 377 | op-snap---monthly-publication-april-2025.pdf | 376 | 2025-04 | Car | Kia | EV6 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Station Road | Station Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5054559 | -1.9506109 | ||
| 379 | op-snap---monthly-publication-april-2025.pdf | 378 | 2025-04 | Car | Peugeot | Partner | White | Driving without Due Care and Attention | None | Church Road | Church Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4624743 | -1.7763934 | ||
| 380 | op-snap---monthly-publication-april-2025.pdf | 379 | 2025-04 | Car | Quad | Black | Driving without Due Care and Attention | None | Lime Grove | Lime Grove | Birmingham | Birmingham | NFA | No Offence | 52.5042965 | -1.9074069 | |||
| 381 | op-snap---monthly-publication-april-2025.pdf | 380 | 2025-04 | Car | Audi | Q7 | Blue | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.471632 | -1.9456776 | ||
| 382 | op-snap---monthly-publication-april-2025.pdf | 381 | 2025-04 | Car | Honda | Civic | Black | Cause vehicle to be left in a dangerous position | None | Naseby Drive | Naseby Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 383 | op-snap---monthly-publication-april-2025.pdf | 382 | 2025-04 | Pedestrian | Mercedes-Benz | E200 | Black | Cause vehicle to be left in a dangerous position | None | Chesterwood Road | Chesterwood Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.425486 | -1.8853886 | ||
| 387 | op-snap---monthly-publication-april-2025.pdf | 386 | 2025-04 | Car | Volvo | XC60 | Red | Contravening a Red Traffic Light | None | SPITFIRE ISLAND M6 | Spitfire Island M6 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5139463 | -1.7980911 | ||
| 388 | op-snap---monthly-publication-april-2025.pdf | 387 | 2025-04 | Pedal Bike | Volvo | XC60 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4543565 | -1.9114004 | ||
| 395 | op-snap---monthly-publication-april-2025.pdf | 394 | 2025-04 | Pedestrian | Mercedes-Benz | CLA | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Friary Gardens | Friary Gardens | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5156395 | -1.9424976 | ||
| 398 | op-snap---monthly-publication-april-2025.pdf | 397 | 2025-04 | Car | Toyota | Aygo | White | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5113867 | -1.8337258 | ||
| 405 | op-snap---monthly-publication-april-2025.pdf | 404 | 2025-04 | Car | Hyundai | I10 | Red | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4203897 | -1.8338574 | ||
| 407 | op-snap---monthly-publication-april-2025.pdf | 406 | 2025-04 | Other | Mercedes-Benz | E220 | White | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5265939 | -1.8509884 | ||
| 408 | op-snap---monthly-publication-april-2025.pdf | 407 | 2025-04 | Pedal Bike | Ford | Focus | Grey | Driving without Reasonable Consideration | None | Pershore Rd | Pershore Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4308271 | -1.920078 | ||
| 412 | op-snap---monthly-publication-april-2025.pdf | 411 | 2025-04 | Pedestrian | Ford | Focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rectory Rd | Rectory Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4129269 | -1.9633057 | ||
| 413 | op-snap---monthly-publication-april-2025.pdf | 412 | 2025-04 | Car | Peugeot | 3008GT | Blue | Driving without Due Care and Attention | None | Tynedale Rd | Tynedale Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4496563 | -1.8403969 | ||
| 417 | op-snap---monthly-publication-april-2025.pdf | 416 | 2025-04 | Lorry | Seat | Exeo | Silver | Contravene Lane Closure Red X | None | M6 Junction 9 - 10. | M6 Junction 9 - 10 | Birmingham | Birmingham | NFA | No VRM | 52.676119 | -2.0858425 | ||
| 425 | op-snap---monthly-publication-april-2025.pdf | 424 | 2025-04 | Pedestrian | BMW | 320D | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4506039 | -1.8463952 | ||
| 431 | op-snap---monthly-publication-april-2025.pdf | 430 | 2025-04 | Pedestrian | Volkswagen | GOLF | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | SHERBORNE STREET | Sherborne Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4762433 | -1.9176665 | ||
| 434 | op-snap---monthly-publication-april-2025.pdf | 433 | 2025-04 | Car | Ford | TRANSIT | Blue | Driving without Due Care and Attention | None | ALCESTER HIGHWAY | Alcester Highway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 437 | op-snap---monthly-publication-april-2025.pdf | 436 | 2025-04 | Car | Vauxhall | corsa | Black | Driving without Due Care and Attention | None | Bordesley Green East | Bordesley Green East | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4802441 | -1.8327073 | ||
| 440 | op-snap---monthly-publication-april-2025.pdf | 439 | 2025-04 | Pedal Bike | Kia | PICANTO | Black | Driving without Reasonable Consideration | None | SCOTLAND LANE | Scotland Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4277732 | -2.0022005 | ||
| 444 | op-snap---monthly-publication-april-2025.pdf | 443 | 2025-04 | Car | Seat | Leon | White | Driving without Reasonable Consideration | None | A45 Birmingham | Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4796992 | -1.9026911 | ||
| 451 | op-snap---monthly-publication-april-2025.pdf | 450 | 2025-04 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | Green Lane Castle Bromwich | Green Lane Castle Bromwich | Birmingham | Birmingham | NFA | No Offence | ||||
| 454 | op-snap---monthly-publication-april-2025.pdf | 453 | 2025-04 | Pedal Bike | Mercedes-Benz | GLC 300 | Black | Driving without Reasonable Consideration | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5113867 | -1.8337258 | ||
| 456 | op-snap---monthly-publication-april-2025.pdf | 455 | 2025-04 | Pedestrian | Citroen | ds3 | Purple | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | NP | Np | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 464 | op-snap---monthly-publication-april-2025.pdf | 463 | 2025-04 | Car | Ford | KUGA | Grey | Driving without Due Care and Attention | None | SOUTHAM ROAD | Southam Road | Birmingham | Birmingham | NFA | No Offence | 52.4334787 | -1.8516882 | ||
| 474 | op-snap---monthly-publication-april-2025.pdf | 473 | 2025-04 | Car | Mercedes-Benz | C class | Black | Misc - Non Traffic Offences | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5292752 | -1.7618805 | ||
| 480 | op-snap---monthly-publication-april-2025.pdf | 479 | 2025-04 | Car | Ford | Kuga | White | Driving without Reasonable Consideration | None | Washwood Heath | Washwood Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 | ||
| 481 | op-snap---monthly-publication-april-2025.pdf | 480 | 2025-04 | Pedal Bike | Mercedes-Benz | Sprinter | Green | Driving without Reasonable Consideration | None | Genners Lane | Genners Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4282602 | -1.9861769 | ||
| 482 | op-snap---monthly-publication-april-2025.pdf | 481 | 2025-04 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Brandwood Park Rd | Brandwood Park Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4138206 | -1.9041686 | ||
| 483 | op-snap---monthly-publication-april-2025.pdf | 482 | 2025-04 | Car | Peugeot | 308 Allure | Black | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5505398 | -1.8252993 | ||
| 487 | op-snap---monthly-publication-april-2025.pdf | 486 | 2025-04 | Pedestrian | Volkswagen | Golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oakfield Rd | Oakfield Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4464556 | -1.9200958 |
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);