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'}
198 rows where disposal = "NFA", month = "2025-03" and reporter_transport_mode = "Car" 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 23
- Driving without Due Care and Attention 87
- Driving without Reasonable Consideration 27
- Contravening a Red Traffic Light 24
- Misc - Non Traffic Offences 17
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 8
- Using a Mobile Phone Whilst Driving 8
- Stop a vehicle within pelican pedestrian crossing limits 3
- Drive on hard shoulder 2
- Fail to display rear VRM plate 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- Motor vehicle fail to comply with solid white line road markings 2
- No Seat Belt 2
- Stop a vehicle on pedestrian crossing 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Dangerous Driving 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Driving a vehicle wholly or partly on a footpath 1
- Fail to display front VRM plate 1
- Motor vehicle fail to accord precedence at a pelican crossing 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 10
- Out of Force Area 84
- Birmingham 55
- Coventry 16
- Walsall 8
- Dudley 7
- Sandwell 7
- Solihull 7
- Sutton Coldfield 5
- Wolverhampton 5
- Ao)Ut Of Force Area 1
reporter_transport_mode 1
- Car · 198 ✖
month 1
- 2025-03 · 198 ✖
disposal 1
- NFA · 198 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||||
| 16955 | op-snap---monthly-publication-march-2025.pdf | 712 | 2025-03 | Car | BMW | 3 | Blue | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Metropolitan Borough of Walsall | Walsall | NFA | No VRM | Yes - Via Email | 52.5723244 | -1.9607214 | |
| 16956 | op-snap---monthly-publication-march-2025.pdf | 713 | 2025-03 | Car | Seat | Ibiza | Blue | Misc - Non Traffic Offences | None | M54 | M54 | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | Yes - Via Email | |||
| 16958 | op-snap---monthly-publication-march-2025.pdf | 715 | 2025-03 | Car | Audi | UK | Driving without Due Care and Attention | None | A5 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.6195535 | -2.0193824 | ||
| 16966 | op-snap---monthly-publication-march-2025.pdf | 723 | 2025-03 | Car | N/P | Misc - Non Traffic Offences | None | Birmingham | Birmingham | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4796992 | -1.9026911 | |||
| 16997 | op-snap---monthly-publication-march-2025.pdf | 754 | 2025-03 | Car | Hyundai | IX35 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradshaw Road | Bradshaw Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 17007 | op-snap---monthly-publication-march-2025.pdf | 764 | 2025-03 | Car | Honda | Jazz | Black | Driving without Due Care and Attention | None | A441 Warwick Highway | Warwick Highway | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17009 | op-snap---monthly-publication-march-2025.pdf | 766 | 2025-03 | Car | Ssangyong | Red | Driving without Due Care and Attention | None | Dunstable | Dunstable | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 17021 | op-snap---monthly-publication-march-2025.pdf | 778 | 2025-03 | Car | Skoda | Octivia | Silver | No Seat Belt | None | Furnace End | Furnace End | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.4585095 | -2.0531143 | |
| 17026 | op-snap---monthly-publication-march-2025.pdf | 783 | 2025-03 | Car | BMW | 118I | Blue | Misc - Non Traffic Offences | None | Robinhood ISLAND | Robinhood ISLAND | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | |||
| 17047 | op-snap---monthly-publication-march-2025.pdf | 804 | 2025-03 | Car | Ford | fOCUS | Blue | Driving without Due Care and Attention | None | M1 Notts | M1 Notts | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17051 | op-snap---monthly-publication-march-2025.pdf | 808 | 2025-03 | Car | Volkswagen | transporter | Blue | Driving without Due Care and Attention | None | Lickey Road, Longbridge | Lickey Road, Longbridge | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.3871038 | -1.9995833 | |
| 17060 | op-snap---monthly-publication-march-2025.pdf | 817 | 2025-03 | Car | Mercedes-Benz | Benz | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Old Smithfield (Bridgnorth) | Old Smithfield (Bridgnorth) | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17078 | op-snap---monthly-publication-march-2025.pdf | 835 | 2025-03 | Car | Mg | 4 | Blue | Contravening a Red Traffic Light | None | A34 | A34 | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 17080 | op-snap---monthly-publication-march-2025.pdf | 837 | 2025-03 | Car | BMW | 420.. | White | Fail to display front VRM plate | None | Ravenhurst Road | Ravenhurst Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.462696 | -1.9537936 | |
| 17093 | op-snap---monthly-publication-march-2025.pdf | 850 | 2025-03 | Car | Ford | C Max | Blue | Driving without Reasonable Consideration | None | Campden Road (Stratford) | Campden Road (Stratford) | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17097 | op-snap---monthly-publication-march-2025.pdf | 854 | 2025-03 | Car | Audi | A3 | White | Driving without Due Care and Attention | No Insurance | Kingston Road | Kingston Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | 52.4747333 | -1.8728345 | |
| 17130 | op-snap---monthly-publication-march-2025.pdf | 887 | 2025-03 | Car | Mercedes-Benz | Grey | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.471632 | -1.9456776 | ||
| 17152 | op-snap---monthly-publication-march-2025.pdf | 909 | 2025-03 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Harvington | Harvington | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.5428258 | -1.7945489 | |
| 17180 | op-snap---monthly-publication-march-2025.pdf | 937 | 2025-03 | Car | Nissan | Qashqai | Blue | Contravening a Red Traffic Light | None | A456 Hagley Road (West Mercia) | Hagley Road (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17183 | op-snap---monthly-publication-march-2025.pdf | 940 | 2025-03 | Car | Vauxhall | Corsa | Black | Contravening a Red Traffic Light | None | Snowford Hill Road | Snowford Hill Road | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17192 | op-snap---monthly-publication-march-2025.pdf | 949 | 2025-03 | Car | Scania | White | Driving without Due Care and Attention | None | Meriden Road CV7 7BE | Meriden Road CV7 7BE | Solihull | Solihull | NFA | No Offence | Yes - Via Email | 52.4112554 | -1.6404862 | ||
| 17197 | op-snap---monthly-publication-march-2025.pdf | 954 | 2025-03 | Car | Vauxhall | Astra | Blue | Driving without Due Care and Attention | None | School Road | School Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4161736 | -1.8619692 | |
| 17203 | op-snap---monthly-publication-march-2025.pdf | 960 | 2025-03 | Car | Volkswagen | transporter | White | Fail to display rear VRM plate | None | Manor Rd | Manor Road | Solihull | Solihull | NFA | No Independent Evidence Available | Yes - Via Email | 52.4193737 | -1.7798629 | |
| 17208 | op-snap---monthly-publication-march-2025.pdf | 965 | 2025-03 | Car | Mercedes-Benz | C63 | Silver | Driving without Due Care and Attention | None | M62 Pontefract | M62 Pontefract | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 17358 | op-snap---monthly-publication-march-2025.pdf | 1115 | 2025-03 | Car | BMW | 530e | Black | Contravening a Red Traffic Light | None | no location provided | No Location Provided | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 17363 | op-snap---monthly-publication-march-2025.pdf | 1120 | 2025-03 | Car | Seat | Ateca | Red | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | |||
| 17372 | op-snap---monthly-publication-march-2025.pdf | 1129 | 2025-03 | Car | Volvo | Grey | Driving without Due Care and Attention | None | A491 Stourbridge Road | Stourbridge Road | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | 52.501035 | -2.107981 | ||
| 17411 | op-snap---monthly-publication-march-2025.pdf | 1168 | 2025-03 | Car | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.418488 | -1.5472387 | ||||
| 17415 | op-snap---monthly-publication-march-2025.pdf | 1172 | 2025-03 | Car | BMW | 1 series | Grey | Driving without Due Care and Attention | None | M4 motorway | M4 motorway | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email |
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);