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'}
308 rows where disposal = "NFA" and month = "2025-03" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
offence 27
- Driving without Due Care and Attention 105
- Driving without Reasonable Consideration 40
- Contravening a Red Traffic Light 29
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 28
- Misc - Non Traffic Offences 28
- Using a Mobile Phone Whilst Driving 21
- Stop a vehicle within pelican pedestrian crossing limits 7
- Driving a vehicle wholly or partly on a footpath 6
- Stop a vehicle on pedestrian crossing 5
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- VRM fails to conform to Regulations 4
- Drive on hard shoulder 3
- Driver not in position to have Proper Control 3
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 3
- Cause vehicle to be left in a dangerous position 2
- Dangerous Driving 2
- Fail to display rear VRM plate 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Motor vehicle fail to comply with solid white line road markings 2
- No Seat Belt 2
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Fail to display front VRM plate 1
- No Insurance 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- Vehicle overtake within crossing limits 1
council_area 11
- Birmingham 107
- Out of Force Area 107
- Coventry 21
- Dudley 15
- Sandwell 15
- Walsall 12
- Wolverhampton 10
- Solihull 8
- Sutton Coldfield 8
- Ao)Ut Of Force Area 1
- Hbaimrm Binagsheadm 1
reporter_transport_mode 10
- Car 198
- Pedestrian 58
- Pedal Bike 31
- Other 13
- Horse Rider 2
- Motorbike 2
- Bus 1
- Lorry 1
- car 1
- other 1
month 1
- 2025-03 · 308 ✖
disposal 1
- NFA · 308 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16267 | op-snap---monthly-publication-march-2025.pdf | 24 | 2025-03 | Pedestrian | Land Rover | Sport | Black | Misc - Non Traffic Offences | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.4569873 | -1.8971744 | |
| 16274 | op-snap---monthly-publication-march-2025.pdf | 31 | 2025-03 | Car | Skoda | Fabia | Silver | Driving without Due Care and Attention | None | Market Rasen, near Lincoln | Market Rasen, near Lincoln | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16276 | op-snap---monthly-publication-march-2025.pdf | 33 | 2025-03 | Other | Mercedes-Benz | N/P | Misc - Non Traffic Offences | None | Unknown, other than the 'Influencer' is Birming | Unknown, other than the 'Influencer' is Birming | hBaimrm binagsheadm | Hbaimrm Binagsheadm | NFA | No Independent Evidence Available | Yes - Via Email | ||||
| 16277 | op-snap---monthly-publication-march-2025.pdf | 34 | 2025-03 | Car | Audi | A4 | Black | Misc - Non Traffic Offences | None | Quinton Road roundabout | Quinton Road roundabout | Coventry | Coventry | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 16278 | op-snap---monthly-publication-march-2025.pdf | 35 | 2025-03 | Pedal Bike | Ford | C-Max | Blue | Driving without Reasonable Consideration | None | Four Pools, Evesham | Four Pools, Evesham | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16279 | op-snap---monthly-publication-march-2025.pdf | 36 | 2025-03 | Pedal Bike | BMW | 118 | White | Driving without Reasonable Consideration | None | Cliff Rock Road | Cliff Rock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.3937169 | -2.0011078 | |
| 16282 | op-snap---monthly-publication-march-2025.pdf | 39 | 2025-03 | Pedal Bike | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | Fairfield Kidderminster | Fairfield Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16283 | op-snap---monthly-publication-march-2025.pdf | 40 | 2025-03 | Car | Volkswagen | Golf | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16284 | op-snap---monthly-publication-march-2025.pdf | 41 | 2025-03 | Car | Ford | Fiesta | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16292 | op-snap---monthly-publication-march-2025.pdf | 49 | 2025-03 | Car | Renault | Kadjar | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Wattville Road | Wattville Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.5063926 | -1.9548648 | |
| 16293 | op-snap---monthly-publication-march-2025.pdf | 50 | 2025-03 | Car | Fiat | 500 | Grey | Stop a vehicle within pelican pedestrian crossing limits | none | Wattville Road | Wattville Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.5063926 | -1.9548648 | |
| 16303 | op-snap---monthly-publication-march-2025.pdf | 60 | 2025-03 | Car | Honda | Civic | Black | Driving without Due Care and Attention | None | Minworth Island | Minworth Island | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.5316279 | -1.7762358 | |
| 16307 | op-snap---monthly-publication-march-2025.pdf | 64 | 2025-03 | Car | Volkswagen | Golf | White | Driving without Reasonable Consideration | None | M42 Junction 2 | M42 Junction 2 | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.4945433 | -2.0190848 | |
| 16309 | op-snap---monthly-publication-march-2025.pdf | 66 | 2025-03 | Car | Honda | CRV | Black | Driving without Due Care and Attention | None | Alvechurch Highway, Bromsgrove | Alvechurch Highway, Bromsgrove | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16310 | op-snap---monthly-publication-march-2025.pdf | 67 | 2025-03 | Car | Fiat | 500 | Black | Driving without Due Care and Attention | None | Roughill Drive | Roughill Drive | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16324 | op-snap---monthly-publication-march-2025.pdf | 81 | 2025-03 | Car | Toyota | Auris | Grey | Contravening a Red Traffic Light | None | Great Hampton Street | Great Hampton Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4910446 | -1.9105163 | |
| 16330 | op-snap---monthly-publication-march-2025.pdf | 87 | 2025-03 | Car | Audi | Q2 | Blue | Contravening a Red Traffic Light | None | Slade Road | Slade Road | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.5245181 | -1.8591675 | |
| 16334 | op-snap---monthly-publication-march-2025.pdf | 91 | 2025-03 | Car | Citroen | C3 | Black | Misc - Non Traffic Offences | None | MERVYN ROAD | Mervyn Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.5116461 | -1.9412646 | |
| 16336 | op-snap---monthly-publication-march-2025.pdf | 93 | 2025-03 | Car | Honda | Civic | Black | No Seat Belt | None | Soho Road | Soho Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.502568 | -1.9305447 | |
| 16343 | op-snap---monthly-publication-march-2025.pdf | 100 | 2025-03 | Car | Audi | A3 | Black | Misc - Non Traffic Offences | None | Cakemore Road | Cakemore Road | Sandwell | Sandwell | NFA | Not in Public Interest | Yes - Via Email | 52.4784618 | -2.0263474 | |
| 16350 | op-snap---monthly-publication-march-2025.pdf | 107 | 2025-03 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Mappleborough Green | Mappleborough Green | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.402696 | -1.8478197 | |
| 16367 | op-snap---monthly-publication-march-2025.pdf | 124 | 2025-03 | Car | Nissan | Micra | Grey | Contravening a Red Traffic Light | None | Stourton on Staffs Police | Stourton on Staffs Police | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16368 | op-snap---monthly-publication-march-2025.pdf | 125 | 2025-03 | Car | Mg | ZS | White | Contravening a Red Traffic Light | None | Stourton on Staffs Police | Stourton on Staffs Police | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16369 | op-snap---monthly-publication-march-2025.pdf | 126 | 2025-03 | Car | Vauxhall | Corsa | Black | Contravening a Red Traffic Light | None | Stourton on Staffs Police | Stourton on Staffs Police | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16371 | op-snap---monthly-publication-march-2025.pdf | 128 | 2025-03 | Car | Dennis HGV | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Harvills Hawthorne | Harvills Hawthorne | Sandwell | Sandwell | NFA | No Independent Evidence Available | Yes - Via Email | 52.5373828 | -2.030222 | ||
| 16383 | op-snap---monthly-publication-march-2025.pdf | 140 | 2025-03 | Pedal Bike | Ford | Focus | Red | Driving without Due Care and Attention | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.4047807 | -2.0101216 | |
| 16384 | op-snap---monthly-publication-march-2025.pdf | 141 | 2025-03 | Car | BMW | 520 | Black | Contravening a Red Traffic Light | None | Newton Road | Newton Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.4541102 | -1.8710993 | |
| 16418 | op-snap---monthly-publication-march-2025.pdf | 175 | 2025-03 | Car | Audi | S8 | White | Driving without Due Care and Attention | No Insurance | Kite Hardwick, Warwickshire | Kite Hardwick, Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16424 | op-snap---monthly-publication-march-2025.pdf | 181 | 2025-03 | Pedal Bike | Porsche | 911 | Black | Cause vehicle to be left in a dangerous position | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4520441 | -1.8787544 | |
| 16438 | op-snap---monthly-publication-march-2025.pdf | 195 | 2025-03 | Car | Vauxhall | UK | Silver | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | |||
| 16440 | op-snap---monthly-publication-march-2025.pdf | 197 | 2025-03 | Car | Vauxhall | Vectra | Blue | Misc - Non Traffic Offences | None | M6 | M6 | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | |||
| 16451 | op-snap---monthly-publication-march-2025.pdf | 208 | 2025-03 | car | Seat | Leon | Black | Driving without Due Care and Attention | None | Biddings Lane, | Biddings Lane | Wolverhampton | Wolverhampton | NFA | No VRM | Yes - Via Email | 52.5498138 | -2.0913674 | |
| 16455 | op-snap---monthly-publication-march-2025.pdf | 212 | 2025-03 | Car | Ford | Focus | White | Driving without Due Care and Attention | None | Longford Road | Longford Road | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.445164 | -1.4879298 | |
| 16467 | op-snap---monthly-publication-march-2025.pdf | 224 | 2025-03 | Pedal Bike | Tesla | Black | Driving without Due Care and Attention | None | Barton Lodge Road | Barton Lodge Road | Solihull | Solihull | NFA | No Offence | Yes - Via Email | ||||
| 16476 | op-snap---monthly-publication-march-2025.pdf | 233 | 2025-03 | Car | Volkswagen | Passat | Blue | Misc - Non Traffic Offences | None | Black Country Route, Bilston | Black Country Route, Bilston | Wolverhampton | Wolverhampton | NFA | No Offence | Yes - Via Email | 52.5652656 | -2.0677422 | |
| 16482 | op-snap---monthly-publication-march-2025.pdf | 239 | 2025-03 | Car | Volkswagen | Passat | Grey | Driving without Due Care and Attention | None | a5 | A5 | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16490 | op-snap---monthly-publication-march-2025.pdf | 247 | 2025-03 | Car | Hyundai | Tucson | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | Use vehicle on a road without valid test certificate | Columbia Close | Columbia Close | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4632515 | -1.9032924 | |
| 16496 | op-snap---monthly-publication-march-2025.pdf | 253 | 2025-03 | Car | Skoda | Fabia | Blue | Misc - Non Traffic Offences | None | Castlegate Island | Castlegate Island | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 16499 | op-snap---monthly-publication-march-2025.pdf | 256 | 2025-03 | Car | Mercedes-Benz | C350 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 16508 | op-snap---monthly-publication-march-2025.pdf | 265 | 2025-03 | Car | Nissan | Micra | Black | Vehicle overtake within crossing limits | None | Watton Lane, Waterorton | Watton Lane, Waterorton | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16554 | op-snap---monthly-publication-march-2025.pdf | 311 | 2025-03 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Brynanston Road | Brynanston Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | |||
| 16555 | op-snap---monthly-publication-march-2025.pdf | 312 | 2025-03 | Car | BMW | N/K | Black | Driving without Due Care and Attention | None | Kenpas Highway | Kenpas Highway | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.3833661 | -1.5265665 | |
| 16563 | op-snap---monthly-publication-march-2025.pdf | 320 | 2025-03 | Car | Yamaha | MT125 | Silver | Misc - Non Traffic Offences | None | Audnam | Audnam | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | 52.4708277 | -2.15449 | |
| 16570 | op-snap---monthly-publication-march-2025.pdf | 327 | 2025-03 | Pedestrian | M/Cycle | White | Driving a vehicle wholly or partly on a footpath | None | Daw End Lane | Daw End Lane | Walsall | Walsall | NFA | No VRM | Yes - Via Email | 52.6068849 | -1.9611652 | ||
| 16572 | op-snap---monthly-publication-march-2025.pdf | 329 | 2025-03 | Car | Daf | Truck | White | Misc - Non Traffic Offences | None | A5 Cannock | Cannock | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16576 | op-snap---monthly-publication-march-2025.pdf | 333 | 2025-03 | Car | BMW | 520D | Black | Driving without Due Care and Attention | None | B4086 Warickshire | Warickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16583 | op-snap---monthly-publication-march-2025.pdf | 340 | 2025-03 | Car | Citroen | Berlingo | White | Using a Mobile Phone Whilst Driving | None | M5 Northbound towards Bromsgrove? | M5 Northbound towards Bromsgrove? | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16603 | op-snap---monthly-publication-march-2025.pdf | 360 | 2025-03 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Shrewsbury area | Shrewsbury area | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16629 | op-snap---monthly-publication-march-2025.pdf | 386 | 2025-03 | Pedestrian | Renault | Traffic | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4578511 | -1.9734988 | |
| 16635 | op-snap---monthly-publication-march-2025.pdf | 392 | 2025-03 | Pedal Bike | BMW | X1 | White | Driving without Reasonable Consideration | None | B4208 Castlemorton | Castlemorton | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16639 | op-snap---monthly-publication-march-2025.pdf | 396 | 2025-03 | Car | Kia | Sportage | Brown | Driving without Due Care and Attention | None | Hortonwood Road Telford | Hortonwood Road Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16640 | op-snap---monthly-publication-march-2025.pdf | 397 | 2025-03 | Car | Seat | Ateca | White | Driving without Reasonable Consideration | None | Watling Street, Atherstone | Watling Street, Atherstone | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16652 | op-snap---monthly-publication-march-2025.pdf | 409 | 2025-03 | Other | Nissan | UK | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tower Street | Tower Street | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 16657 | op-snap---monthly-publication-march-2025.pdf | 414 | 2025-03 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Stechford Lane | Stechford Lane | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4930549 | -1.8179571 | |
| 16664 | op-snap---monthly-publication-march-2025.pdf | 421 | 2025-03 | Car | Mini | Cooper | Grey | Contravening a Red Traffic Light | None | Fernhill Heath | Fernhill Heath | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16673 | op-snap---monthly-publication-march-2025.pdf | 430 | 2025-03 | Pedestrian | Kia | Optima | Silver | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 16674 | op-snap---monthly-publication-march-2025.pdf | 431 | 2025-03 | Car | Ford | Transit | Blue | Contravening a Red Traffic Light | None | A426 Rugby Road, Dunchurch, WARWICKSHIRE | Rugby Road, Dunchurch, WARWICKSHIRE | NFA | Out of Force | Yes - Via Email | |||||
| 16695 | op-snap---monthly-publication-march-2025.pdf | 452 | 2025-03 | Pedestrian | Ford | Transit | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16696 | op-snap---monthly-publication-march-2025.pdf | 453 | 2025-03 | Pedestrian | Fiat | 500 | White | Stop a vehicle on pedestrian crossing | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16697 | op-snap---monthly-publication-march-2025.pdf | 454 | 2025-03 | Pedestrian | Volkswagen | Sharan | Silver | Stop a vehicle on pedestrian crossing | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16699 | op-snap---monthly-publication-march-2025.pdf | 456 | 2025-03 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16700 | op-snap---monthly-publication-march-2025.pdf | 457 | 2025-03 | Car | BMW | 220D | Black | Driving without Reasonable Consideration | None | Wellhead Lane | Wellhead Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.5162215 | -1.896087 | |
| 16703 | op-snap---monthly-publication-march-2025.pdf | 460 | 2025-03 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | B4380 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.6195535 | -2.0193824 | |
| 16704 | op-snap---monthly-publication-march-2025.pdf | 461 | 2025-03 | Car | Black | Driving without Due Care and Attention | None | Blowers Green Road | Blowers Green Road | Dudley | Dudley | NFA | Misc Inc Crimes | Yes - Via Email | 52.5048062 | -2.0904536 | |||
| 16723 | op-snap---monthly-publication-march-2025.pdf | 480 | 2025-03 | Car | Porsche | Cayenne | Silver | Driving without Due Care and Attention | None | A51 Little Haywood, Staffs | Little Haywood, Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16724 | op-snap---monthly-publication-march-2025.pdf | 481 | 2025-03 | Pedestrian | Mercedes-Benz | B160 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hilton Road | Hilton Road | Sandwell | Sandwell | NFA | No Offence | Yes - Via Email | 52.5049194 | -2.0394583 | |
| 16730 | op-snap---monthly-publication-march-2025.pdf | 487 | 2025-03 | Car | BMW | R1200RT | Red | Driving without Due Care and Attention | None | A525 Whitchurch, Staffs. | Whitchurch, Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16731 | op-snap---monthly-publication-march-2025.pdf | 488 | 2025-03 | Car | Daf | Tractor | White | Driving without Due Care and Attention | None | Wolverhampton Road, Kidderminstrer | Wolverhampton Road, Kidderminstrer | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16746 | op-snap---monthly-publication-march-2025.pdf | 503 | 2025-03 | Car | Volkswagen | Golf | Blue | Contravening a Red Traffic Light | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | 52.3962003 | -1.9821252 | |
| 16747 | op-snap---monthly-publication-march-2025.pdf | 504 | 2025-03 | Car | Mercedes-Benz | AMG A35 | Grey | Driving without Due Care and Attention | None | Cheltenham Road | Cheltenham Road | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16748 | op-snap---monthly-publication-march-2025.pdf | 505 | 2025-03 | Pedestrian | BMW | 320D | Black | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Pritchatts Road | Pritchatts Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4522304 | -1.9267446 | |
| 16757 | op-snap---monthly-publication-march-2025.pdf | 514 | 2025-03 | Other | Ford | Transit | Yellow | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Tower Street | Tower Street | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 16758 | op-snap---monthly-publication-march-2025.pdf | 515 | 2025-03 | Pedestrian | Dangerous Driving | None | Kenrick Way | Kenrick Way | Sandwell | Sandwell | NFA | Misc Inc Crimes | Yes - Via Email | 52.5079468 | -1.9755194 | ||||
| 16759 | op-snap---monthly-publication-march-2025.pdf | 516 | 2025-03 | Car | Daf | Artic | White | Driving without Due Care and Attention | None | A45, London Road, Stretton on Dunsmore | A45, London Road, Stretton on Dunsmore | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16770 | op-snap---monthly-publication-march-2025.pdf | 527 | 2025-03 | Car | UK | Driving without Due Care and Attention | None | Yeman Road | Yeman Road | Sandwell | Sandwell | NFA | No VRM | Yes - Via Email | 52.4829268 | -1.9932127 | |||
| 16777 | op-snap---monthly-publication-march-2025.pdf | 534 | 2025-03 | Car | Volkswagen | Golf | White | Dangerous Driving | No Insurance | Cotterills Lane, Stechford | Cotterills Lane, Stechford | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | 52.4884297 | -1.817811 | |
| 16780 | op-snap---monthly-publication-march-2025.pdf | 537 | 2025-03 | Pedestrian | BMW | 116D | Silver | Driver not in position to have Proper Control | None | SALOP ROAD, OLDBURY | Salop Road, Oldbury | Sandwell | Sandwell | NFA | No Independent Evidence Available | Yes - Via Email | 52.4799354 | -1.9944601 | |
| 16792 | op-snap---monthly-publication-march-2025.pdf | 549 | 2025-03 | Car | Nissan | Qashqai | Grey | Driving without Reasonable Consideration | None | Third Avenue, Pensnett Trading Estate | Third Avenue, Pensnett Trading Estate | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | 52.5046812 | -2.1550209 | |
| 16799 | op-snap---monthly-publication-march-2025.pdf | 556 | 2025-03 | Pedestrian | Mercedes-Benz | White | Driving without Reasonable Consideration | None | LICHFIELD ROAD | Lichfield Road | Metropolitan Borough of Walsall | Walsall | NFA | No VRM | Yes - Via Email | 52.6095168 | -2.0493009 | ||
| 16810 | op-snap---monthly-publication-march-2025.pdf | 567 | 2025-03 | Car | Audi | A4 | Silver | Driving without Due Care and Attention | No Insurance | Bradeley Lane, Coseley | Bradeley Lane, Coseley | Wolverhampton | Wolverhampton | NFA | No VRM | Yes - Via Email | |||
| 16812 | op-snap---monthly-publication-march-2025.pdf | 569 | 2025-03 | Car | Ford | Transit | White | Fail to display rear VRM plate | None | M6 Junction 2 | M6 Junction 2 | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.676119 | -2.0858425 | |
| 16813 | op-snap---monthly-publication-march-2025.pdf | 570 | 2025-03 | Other | Land Rover | Range Rover | White | Misc - Non Traffic Offences | None | Highfield Road | Highfield Road | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | 52.5106203 | -2.0686081 | |
| 16815 | op-snap---monthly-publication-march-2025.pdf | 572 | 2025-03 | Car | Mercedes-Benz | GLE 350 | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Barker Street, Lozells | Barker Street, Lozells | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.5015478 | -1.916344 | |
| 16819 | op-snap---monthly-publication-march-2025.pdf | 576 | 2025-03 | Car | Land Rover | Discovery | White | Contravening a Red Traffic Light | None | A449 Towards Stafford | Towards Stafford | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16823 | op-snap---monthly-publication-march-2025.pdf | 580 | 2025-03 | Car | BMW | 3 series | Black | Using a Mobile Phone Whilst Driving | None | Astwood Bank, Worcester | Astwood Bank, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16840 | op-snap---monthly-publication-march-2025.pdf | 597 | 2025-03 | Car | Volvo | V90 | White | Driving without Due Care and Attention | None | Wolverhampton Road J 2 off M5 | Wolverhampton Road J 2 off M5 | Sandwell | Sandwell | NFA | No Offence | Yes - Via Email | |||
| 16843 | op-snap---monthly-publication-march-2025.pdf | 600 | 2025-03 | Pedestrian | Hyundai | i40 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Parkes Street, Smethwick | Parkes Street, Smethwick | Sandwell | Sandwell | NFA | No VRM | Yes - Via Email | 52.4892987 | -1.97475 | |
| 16855 | op-snap---monthly-publication-march-2025.pdf | 612 | 2025-03 | Car | BMW | 4 series | Grey | Misc - Non Traffic Offences | None | Meadway | Meadway | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | 52.4783348 | -1.8007708 | |
| 16861 | op-snap---monthly-publication-march-2025.pdf | 618 | 2025-03 | Car | Isuzu | D-MAX | Orange | Drive on hard shoulder | None | M18 | M18 | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16868 | op-snap---monthly-publication-march-2025.pdf | 625 | 2025-03 | Car | BMW | X3 | Black | Contravening a Red Traffic Light | None | Bescot Road, wednesbury | Bescot Road, wednesbury | Metropolitan Borough of Walsall | Walsall | NFA | No Offence | Yes - Via Email | 52.575204 | -1.9916288 | |
| 16881 | op-snap---monthly-publication-march-2025.pdf | 638 | 2025-03 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Green Street | Green Street | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.4737217 | -1.8844945 | |
| 16889 | op-snap---monthly-publication-march-2025.pdf | 646 | 2025-03 | Car | Mercedes-Benz | C class | White | Using a Mobile Phone Whilst Driving | None | Camp Hill, Wordsley | Camp Hill, Wordsley | Sandwell | Sandwell | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 16895 | op-snap---monthly-publication-march-2025.pdf | 652 | 2025-03 | Car | Mercedes-Benz | AMG | White | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 16912 | op-snap---monthly-publication-march-2025.pdf | 669 | 2025-03 | Pedestrian | Lamborghini | 4X4 | Red | Driving without Reasonable Consideration | None | Newhall Street | Newhall Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4830482 | -1.905069 | |
| 16927 | op-snap---monthly-publication-march-2025.pdf | 684 | 2025-03 | Car | BMW | 320D | Black | Misc - Non Traffic Offences | None | Pritchatts Road | Pritchatts Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4522304 | -1.9267446 | |
| 16930 | op-snap---monthly-publication-march-2025.pdf | 687 | 2025-03 | Car | Vauxhall | Movano | White | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | A520 Weston Road Meir Stoke on Trent | Weston Road Meir Stoke on Trent | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 16933 | op-snap---monthly-publication-march-2025.pdf | 690 | 2025-03 | Other | Hyundai | Ix35 | Grey | Misc - Non Traffic Offences | None | Bradshaw Avenue | Bradshaw Avenue | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.4018255 | -1.9490522 | |
| 16947 | op-snap---monthly-publication-march-2025.pdf | 704 | 2025-03 | Car | Honda | ncs 50 | Grey | Contravening a Red Traffic Light | None | Old Birmingham Road | Old Birmingham Road | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.5226944 | -2.0765801 | |
| 16949 | op-snap---monthly-publication-march-2025.pdf | 706 | 2025-03 | Car | Mini | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Basin Road, Worcester | Basin Road, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | ||||
| 16953 | op-snap---monthly-publication-march-2025.pdf | 710 | 2025-03 | Pedal Bike | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | Edward Road | Edward Road | Birmingham | Birmingham | NFA | Not in Public Interest | Yes - Via Email | 52.4580901 | -1.894458 |
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);