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'}
106 rows where offence = "Dangerous Driving" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, witness_contacted
vehicle_make 23
month 11
council_area 11
- Birmingham 40
- Dudley 15
- Out of Force Area 14
- Walsall 9
- Sandwell 8
- Wolverhampton 7
- Solihull 5
- Coventry 4
- Halesowen 2
- Out Of Force Area 1
- Sutton Coldfield 1
reporter_transport_mode 7
- Car 79
- Pedestrian 12
- Other 6
- Pedal Bike 4
- Lorry 3
- Bus 1
- Van 1
disposal 5
- NFA 40
- Court 38
- Warning Letter 21
- RTC - Actioned 4
- Other Action Taken 3
offence 1
- Dangerous Driving · 106 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10883 | op-snap---monthly-publication-january-2026.pdf | 344 | 2026-01 | Car | Toyota | Yaris | Grey | Dangerous Driving | None | M1 near Brogborough | M1 near Brogborough | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11314 | op-snap---monthly-publication-january-2026.pdf | 775 | 2026-01 | Car | Mini | Black | Dangerous Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4203897 | -1.8338574 | |||
| 11482 | op-snap---monthly-publication-january-2026.pdf | 943 | 2026-01 | Other | BMW | 5 Series | Silver | Dangerous Driving | None | Spring road Tyseley | Spring road Tyseley | Birmingham | Birmingham | NFA | No VRM | 52.444262 | -1.8362585 | ||
| 20512 | op-snap---monthly-publication-november-2025.pdf | 54 | 2025-11 | Lorry | Ford | White | Dangerous Driving | None | M6 Motorway | M6 Motorway | Walsall | Walsall | NFA | No VRM | 52.6151447 | -2.0290522 | |||
| 20833 | op-snap---monthly-publication-november-2025.pdf | 375 | 2025-11 | Car | Yamaha | RayZR | Red | Dangerous Driving | None | jockey Rd | jockey Road | Sutton Coldfield | Sutton Coldfield | NFA | Misc Inc Crimes | 52.5535276 | -1.8302584 | ||
| 20855 | op-snap---monthly-publication-november-2025.pdf | 397 | 2025-11 | Car | Audi | A6 | Black | Dangerous Driving | None | Cotterills Lane | Cotterills Lane | Birmingham | Birmingham | Court | N/A | 52.4884297 | -1.817811 | ||
| 24146 | op-snap---monthly-publication-september-2025.pdf | 365 | 2025-09 | Car | Ford | S Max | Black | Dangerous Driving | No Insurance | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | Court | N/A | 52.3793117 | -1.4625379 | ||
| 25243 | op-snap---monthly-publication-september-2025.pdf | 1462 | 2025-09 | Car | Other | Dangerous Driving | None | Chamberlain Road | Chamberlain Road | Birmingham | Birmingham | NFA | No VRM | 52.4235868 | -1.8826808 | ||||
| 25421 | op-snap---monthly-publication-september-2025.pdf | 1640 | 2025-09 | Pedestrian | Kia | Ceed | Black | Dangerous Driving | None | Clare Street | Clare Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4706879 | -2.0861765 | ||
| 25543 | op-snap---monthly-publication-september-2025.pdf | 1762 | 2025-09 | Car | Dangerous Driving | None | Harborne Lane | Harborne Lane | Birmingham | Birmingham | NFA | No VRM | 52.4468464 | -1.9454816 | |||||
| 2238 | op-snap---monthly-publication-august-2025.pdf | 213 | 2025-08 | Other | Fiat | Punto | white | Dangerous Driving | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Court | N/A | ||||
| 2368 | op-snap---monthly-publication-august-2025.pdf | 343 | 2025-08 | Car | BMW | 335 | Black | Dangerous Driving | None | Stourbridge Ring Road | Stourbridge Ring Road | Dudley | Dudley | Court | N/A | 52.4590366 | -2.1465735 | ||
| 2439 | op-snap---monthly-publication-august-2025.pdf | 414 | 2025-08 | Car | Volkswagen | Crafter | White | Dangerous Driving | None | M6 - M5 Slip | M6 - M5 Slip | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3095 | op-snap---monthly-publication-august-2025.pdf | 1070 | 2025-08 | Car | UK | Dangerous Driving | None | Stonebridge Island | Stonebridge Island | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4459998 | -1.6949291 | ||||
| 3296 | op-snap---monthly-publication-august-2025.pdf | 1271 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Dangerous Driving | None | Tenby Road | Tenby Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4412727 | -1.8563704 | ||
| 3390 | op-snap---monthly-publication-august-2025.pdf | 1365 | 2025-08 | Car | Audi | Q7 | Silver | Dangerous Driving | None | Tyseley Road | Tyseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4534057 | -1.8384339 | ||
| 3487 | op-snap---monthly-publication-august-2025.pdf | 1462 | 2025-08 | Pedestrian | Seat | Ibiza | White | Dangerous Driving | None | Brendon Way | Brendon Way | Coventry | Coventry | Warning Letter | N/A | ||||
| 3531 | op-snap---monthly-publication-august-2025.pdf | 1506 | 2025-08 | Car | Volkswagen | Golf | Blue | Dangerous Driving | None | M6 Northbound Entry | M6 Northbound Entry | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3553 | op-snap---monthly-publication-august-2025.pdf | 1528 | 2025-08 | Car | Other | moped | Black | Dangerous Driving | No Insurance | howard road | Howard Road | Solihull | Solihull | Other Action Taken | N/A | 52.4478024 | -1.8063862 | ||
| 3599 | op-snap---monthly-publication-august-2025.pdf | 1574 | 2025-08 | Car | Daf | Skip loader | White | Dangerous Driving | None | Bilston Lane | Bilston Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5728229 | -2.0974344 | ||
| 3609 | op-snap---monthly-publication-august-2025.pdf | 1584 | 2025-08 | Pedestrian | Nissan | X-trail | Black | Dangerous Driving | None | Hockley Heath | Hockley Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4921873 | -1.9258317 | ||
| 3659 | op-snap---monthly-publication-august-2025.pdf | 1634 | 2025-08 | Pedestrian | Volkswagen | Polo | White | Dangerous Driving | None | Alum Rock Rd | Alum Rock Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4883936 | -1.8310056 | ||
| 12404 | op-snap---monthly-publication-july-2025.pdf | 456 | 2025-07 | Car | Vauxhall | Astra | White | Dangerous Driving | None | Third Avenue | Third Avenue | Wolverhampton | Wolverhampton | NFA | No VRM | 52.6074696 | -2.1092185 | ||
| 12405 | op-snap---monthly-publication-july-2025.pdf | 457 | 2025-07 | Car | Vauxhall | Karoq | Grey | Dangerous Driving | None | Third Avenue | Third Avenue | Wolverhampton | Wolverhampton | Court | N/A | 52.6074696 | -2.1092185 | ||
| 12423 | op-snap---monthly-publication-july-2025.pdf | 475 | 2025-07 | Pedal Bike | Ford | fiesta | Silver | Dangerous Driving | None | Worcester, West Mercia Force area | Worcester, West Mercia Force area | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12473 | op-snap---monthly-publication-july-2025.pdf | 525 | 2025-07 | Car | Ford | Focus | Blue | Dangerous Driving | No Insurance | Chester Road | Chester Road | walsall | Walsall | Court | N/A | 52.5692139 | -1.8799672 | ||
| 12481 | op-snap---monthly-publication-july-2025.pdf | 533 | 2025-07 | Car | Ford | Focus | Grey | Dangerous Driving | None | Chester Road | Chester Road | Walsall | Walsall | Court | N/A | 52.5692139 | -1.8799672 | ||
| 12512 | op-snap---monthly-publication-july-2025.pdf | 564 | 2025-07 | Other | Hyundai | Matrix | Black | Dangerous Driving | None | B62 0LR Rubery | B62 0LR Rubery | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12589 | op-snap---monthly-publication-july-2025.pdf | 641 | 2025-07 | Other | Citroen | DS3 | White | Dangerous Driving | None | High Street, Stourbridge | High Street, Stourbridge | Dudley | Dudley | Court | N/A | 52.4570763 | -2.1136199 | ||
| 12971 | op-snap---monthly-publication-july-2025.pdf | 1023 | 2025-07 | Car | Van | White | Dangerous Driving | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 12988 | op-snap---monthly-publication-july-2025.pdf | 1040 | 2025-07 | Pedestrian | Vauxhall | Van | White | Dangerous Driving | None | High Street , Princess End | High Street , Princess End | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12990 | op-snap---monthly-publication-july-2025.pdf | 1042 | 2025-07 | Car | Van | White | Dangerous Driving | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | Warning Letter | N/A | |||||
| 13277 | op-snap---monthly-publication-july-2025.pdf | 1329 | 2025-07 | Car | Ford | Ranger | White | Dangerous Driving | None | M5 Northbound from Junction 4 | M5 Northbound from Junction 4 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13588 | op-snap---monthly-publication-july-2025.pdf | 1640 | 2025-07 | Car | Dangerous Driving | None | Hasluck Road | Hasluck Road | Solihull | Solihull | NFA | No Independent Evidence Available | |||||||
| 14145 | op-snap---monthly-publication-june-2025.pdf | 74 | 2025-06 | Other | Peugeot | Bipper | White | Dangerous Driving | None | Waterfront car park | Waterfront car park | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 14241 | op-snap---monthly-publication-june-2025.pdf | 170 | 2025-06 | Other | Seat | ATECA | Black | Dangerous Driving | None | WATERFRONT CAR PARK | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 14359 | op-snap---monthly-publication-june-2025.pdf | 288 | 2025-06 | Car | Mercedes-Benz | Sprinter minibus | Silver | Dangerous Driving | None | Kingsbury Road / Tyburn Road | Kingsbury Road / Tyburn Road | Birmingham | Birmingham | Court | N/A | 52.5184687 | -1.8052101 | ||
| 14860 | op-snap---monthly-publication-june-2025.pdf | 789 | 2025-06 | Car | Volkswagen | Golf | Blue | Dangerous Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Court | N/A | 52.471632 | -1.9456776 | ||
| 15051 | op-snap---monthly-publication-june-2025.pdf | 980 | 2025-06 | Car | Audi | A4 | Black | Dangerous Driving | None | COTTERILLS LANE | Cotterills Lane | Birmingham | Birmingham | Court | N/A | 52.4884297 | -1.817811 | ||
| 15444 | op-snap---monthly-publication-june-2025.pdf | 1373 | 2025-06 | Car | Yamaha | EW50 | Grey | Dangerous Driving | No Insurance | A4101 | A4101 | Dudley | Dudley | NFA | Outside of 14 Days NIP | ||||
| 16096 | op-snap---monthly-publication-june-2025.pdf | 2025 | 2025-06 | Car | Mercedes-Benz | E200 | Grey | Dangerous Driving | None | Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 19198 | op-snap---monthly-publication-may-2025.pdf | 560 | 2025-05 | Pedestrian | Dangerous Driving | none | Commonside road | Commonside road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||||
| 19215 | op-snap---monthly-publication-may-2025.pdf | 577 | 2025-05 | Car | Mercedes-Benz | c220 | Black | Dangerous Driving | None | RICHMOND ROAD | Richmond Road | Birmingham | Birmingham | Court | N/A | 52.566947 | -1.8291809 | ||
| 19216 | op-snap---monthly-publication-may-2025.pdf | 578 | 2025-05 | Car | Volkswagen | jetta | Black | Dangerous Driving | No Insurance | RICHMOND ROAD | Richmond Road | Birmingham | Birmingham | Court | N/A | 52.566947 | -1.8291809 | ||
| 19604 | op-snap---monthly-publication-may-2025.pdf | 966 | 2025-05 | Car | Ford | Transit | Silver | Dangerous Driving | No Insurance | Dudley Road Kingswinford | Dudley Road Kingswinford | Dudley | Dudley | NFA | No VRM | 52.5040708 | -2.1714184 | ||
| 19916 | op-snap---monthly-publication-may-2025.pdf | 1278 | 2025-05 | Pedestrian | Kia | Rio | Black | Dangerous Driving | None | Kenilworth road | Kenilworth road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3833298 | -1.5379214 | ||
| 20194 | op-snap---monthly-publication-may-2025.pdf | 1556 | 2025-05 | Car | Mini | Cooper | Grey | Dangerous Driving | none | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 20196 | op-snap---monthly-publication-may-2025.pdf | 1558 | 2025-05 | Car | Ford | Ranger | White | Dangerous Driving | none | Worcester Street | Worcester Street | Dudley | Dudley | Warning Letter | N/A | 52.4507058 | -2.1503743 | ||
| 20255 | op-snap---monthly-publication-may-2025.pdf | 1617 | 2025-05 | Car | BMW | 520D | Grey | Dangerous Driving | None | Lewisham Road | Lewisham Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5007274 | -1.9661248 | ||
| 20256 | op-snap---monthly-publication-may-2025.pdf | 1618 | 2025-05 | Car | BMW | M140 | Blue | Dangerous Driving | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Warning Letter | N/A | 52.50787 | -1.8195713 | ||
| 20269 | op-snap---monthly-publication-may-2025.pdf | 1631 | 2025-05 | Car | Seat | Ibiza | White | Dangerous Driving | None | Market Place, Tipton | Market Place, Tipton | Sandwell | Sandwell | Warning Letter | N/A | 52.5303627 | -2.0353018 | ||
| 20350 | op-snap---monthly-publication-may-2025.pdf | 1712 | 2025-05 | Car | BMW | 118 | White | Dangerous Driving | None | Parkfield Drive | Parkfield Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5086984 | -1.777555 | ||
| 20365 | op-snap---monthly-publication-may-2025.pdf | 1727 | 2025-05 | Car | Mazda | 6 | Blue | Dangerous Driving | None | Dayus Square | Dayus Square | Birmingham | Birmingham | Warning Letter | N/A | 52.4846586 | -1.9140974 | ||
| 20376 | op-snap---monthly-publication-may-2025.pdf | 1738 | 2025-05 | Car | Scania | Tractor Unit | White | Dangerous Driving | none | M6 Northbound | M6 Northbound | Walsall | Walsall | Warning Letter | N/A | ||||
| 20406 | op-snap---monthly-publication-may-2025.pdf | 1768 | 2025-05 | Car | Volkswagen | Golf | Black | Dangerous Driving | None | Streetsbrook Road | Streetsbrook Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4223176 | -1.8253145 | ||
| 20422 | op-snap---monthly-publication-may-2025.pdf | 1784 | 2025-05 | Car | BMW | 3 series | Black | Dangerous Driving | None | Worcester Bypass | Worcester Bypass | Out of Force Area | Out of Force Area | Warning Letter | N/A | ||||
| 20438 | op-snap---monthly-publication-may-2025.pdf | 1800 | 2025-05 | Car | Lexus | CVT | Blue | Dangerous Driving | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4191184 | -1.8326637 | ||
| 58 | op-snap---monthly-publication-april-2025.pdf | 57 | 2025-04 | Pedestrian | NP | Dangerous Driving | None | Pelsall High Street | Pelsall High Street | Walsall | Walsall | NFA | No Independent Evidence Available | 52.628914 | -1.9675162 | ||||
| 512 | op-snap---monthly-publication-april-2025.pdf | 511 | 2025-04 | Car | BMW | 1 SERIES | Grey | Dangerous Driving | None | PRIORY ROAD | Priory Road | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4531211 | -2.0210432 | ||
| 723 | op-snap---monthly-publication-april-2025.pdf | 722 | 2025-04 | Car | Audi | S3 | Black | Dangerous Driving | None | Three Tuns lane | Three Tuns lane | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.6201713 | -2.1268549 | ||
| 834 | op-snap---monthly-publication-april-2025.pdf | 833 | 2025-04 | Car | Mercedes-Benz | Black | Dangerous Driving | None | Hurstbourne Crescent , Wolverhampton | Hurstbourne Crescent , Wolverhampton | Wolverhampton | Wolverhampton | RTC - Actioned | N/A | 52.580856 | -2.0924732 | |||
| 841 | op-snap---monthly-publication-april-2025.pdf | 840 | 2025-04 | Car | BMW | Grey | Dangerous Driving | None | Broad Road , Birmingham | Broad Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.446961 | -1.8289431 | |||
| 1149 | op-snap---monthly-publication-april-2025.pdf | 1148 | 2025-04 | Car | Peugeot | Black | Dangerous Driving | None | KIngs Street | KIngs Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4352049 | -1.8927095 | |||
| 1313 | op-snap---monthly-publication-april-2025.pdf | 1312 | 2025-04 | Car | BMW | 4 series | Black | Dangerous Driving | None | Birmingham coventry road | Birmingham coventry road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4707545 | -1.8616196 | ||
| 1317 | op-snap---monthly-publication-april-2025.pdf | 1316 | 2025-04 | Car | Volkswagen | Tiguan Allspace | Black | Dangerous Driving | None | M5 inside Lane Northbound | M5 inside Lane Northbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1336 | op-snap---monthly-publication-april-2025.pdf | 1335 | 2025-04 | Bus | Van / Lorry | White | Dangerous Driving | None | Near Whitgrave Stafford | Near Whitgrave Stafford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1387 | op-snap---monthly-publication-april-2025.pdf | 1386 | 2025-04 | Car | Audi | A1 | Blue | Dangerous Driving | None | M5 Southbound | M5 Southbound | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1421 | op-snap---monthly-publication-april-2025.pdf | 1420 | 2025-04 | Pedal Bike | Peugeot | Boxer | White | Dangerous Driving | None | Barboune road, left side lane | Barboune road, left side lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1521 | op-snap---monthly-publication-april-2025.pdf | 1520 | 2025-04 | Car | BMW | 4 Series | White | Dangerous Driving | None | Manor Way , Halesowen | Manor Way , Halesowen | Halesowen | Halesowen | NFA | Outside of 14 Days NIP | 52.4456717 | -2.0407862 | ||
| 16445 | op-snap---monthly-publication-march-2025.pdf | 202 | 2025-03 | Car | Seat | Arona | Red | Dangerous Driving | None | A38M inbound | A38M inbound | Birmingham | Birmingham | Court | N/A | Yes - Via Email | |||
| 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 | ||||
| 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 | |
| 17376 | op-snap---monthly-publication-march-2025.pdf | 1133 | 2025-03 | Car | Audi | Q5 | Grey | Dangerous Driving | None | Skip Lane | Skip Lane | Metropolitan Borough of Walsall | Walsall | Court | N/A | Yes - Via Email | 52.5767458 | -1.938027 | |
| 17489 | op-snap---monthly-publication-march-2025.pdf | 1246 | 2025-03 | Pedestrian | Volkswagen | Polo | Silver | Dangerous Driving | None | Waterfront Way (Car Park 7), Brierley Hill | Waterfront Way (Car Park 7), Brierley Hill | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 17944 | op-snap---monthly-publication-march-2025.pdf | 1701 | 2025-03 | Car | Nissan | micra | Silver | Dangerous Driving | None | Church Road | Church Road | Birmingham | Birmingham | Other Action Taken | N/A | Yes - Via Telephone | 52.4624743 | -1.7763934 | |
| 18000 | op-snap---monthly-publication-march-2025.pdf | 1757 | 2025-03 | Car | Volkswagen | GOLF | Black | Dangerous Driving | None | YEW TRE ISLAND | Yew Tre Island | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 18035 | op-snap---monthly-publication-march-2025.pdf | 1792 | 2025-03 | Car | Nissan | Micra | Silver | Dangerous Driving | None | Church Road | Church Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4624743 | -1.7763934 | |
| 18117 | op-snap---monthly-publication-march-2025.pdf | 1874 | 2025-03 | Car | Audi | A3 | White | Dangerous Driving | None | Pendeford Avenue towards Green Lane | Pendeford Avenue towards Green Lane | Wolverhampton | Wolverhampton | Court | N/A | Yes - Via Email | |||
| 18155 | op-snap---monthly-publication-march-2025.pdf | 1912 | 2025-03 | Van | Yamaha | GPD | Grey | Dangerous Driving | None | ASHTREE ROAD | Ashtree Road | Walsall | Walsall | Court | N/A | Yes - Via Email | |||
| 18233 | op-snap---monthly-publication-march-2025.pdf | 1990 | 2025-03 | Lorry | Kia | Sportage | White | Dangerous Driving | None | M6 NB J7 | M6 Northbound J7 | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.6912891 | -2.1046372 | |
| 18416 | op-snap---monthly-publication-march-2025.pdf | 2173 | 2025-03 | Car | BMW | 320D | Blue | Dangerous Driving | Use vehicle on a road without valid test certificate | CHESTER ROAD | Chester Road | Walsall | Walsall | Court | N/A | Yes - Via Email | 52.5692139 | -1.8799672 | |
| 5386 | op-snap---monthly-publication-february-2025.pdf | 203 | 2025-02 | Car | Mercedes-Benz | Sprinter | White | Dangerous Driving | None | M25 J16 | M25 J16 | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 5892 | op-snap---monthly-publication-february-2025.pdf | 709 | 2025-02 | Lorry | Peugeot | 107 | Red | Dangerous Driving | None | M5 Southbound | M5 Southbound | Sandwell | Sandwell | Court | N/A | Yes - Via Email | |||
| 6041 | op-snap---monthly-publication-february-2025.pdf | 858 | 2025-02 | Car | BMW | M140i | White | Dangerous Driving | None | A46 Grimsby Road, Grimsby | Grimsby Road, Grimsby | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 6225 | op-snap---monthly-publication-february-2025.pdf | 1042 | 2025-02 | Car | Land Rover | vogue | Black | Dangerous Driving | No vehicle excise licence | WALLOWS LANE | Wallows Lane | Walsall | Walsall | Court | N/A | Yes - Via Email | 52.5699435 | -2.0008354 | |
| 6623 | op-snap---monthly-publication-february-2025.pdf | 1440 | 2025-02 | Car | Scania | White | Dangerous Driving | None | M1 Northamptonshire | M1 Northamptonshire | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | ||||
| 6863 | op-snap---monthly-publication-february-2025.pdf | 1680 | 2025-02 | Car | Peugeot | 208 | White | Dangerous Driving | None | M25, near the M23 exit | M25, near the M23 exit | Out of Force Area | Out of Force Area | Court | N/A | Yes - Via Email | |||
| 6901 | op-snap---monthly-publication-february-2025.pdf | 1718 | 2025-02 | Car | Volkswagen | T-ROC | White | Dangerous Driving | No Insurance | HAUNCH LANE | Haunch Lane | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4244287 | -1.8867396 | |
| 6951 | op-snap---monthly-publication-february-2025.pdf | 1768 | 2025-02 | Car | Dangerous Driving | None | M42 /M40 split. | M42 /M40 split | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||||
| 7084 | op-snap---monthly-publication-february-2025.pdf | 1901 | 2025-02 | Car | Toyota | HILUX | Black | Dangerous Driving | None | A38 SALFORD CIRCUS | A38 Salford Circus | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5095071 | -1.8593732 | |
| 8985 | op-snap---monthly-publication-january-2025.pdf | 93 | 2025-01 | Car | BMW | 320D SPORT | Silver | Dangerous Driving | No Insurance | A461 DUDLEY PORT | A461 Dudley Port | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5137817 | -2.0633457 | |
| 9198 | op-snap---monthly-publication-january-2025.pdf | 306 | 2025-01 | Car | Ford | FIESTA | Silver | Dangerous Driving | None | WARWICK ROAD | Warwick Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4555288 | -1.8613929 | |
| 9270 | op-snap---monthly-publication-january-2025.pdf | 378 | 2025-01 | Pedestrian | BMW | 1 SERIES | Grey | Dangerous Driving | None | WATERFRONT MAIN CAR PARK | Waterfront Main Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9274 | op-snap---monthly-publication-january-2025.pdf | 382 | 2025-01 | Car | Ford | Fiesta | Blue | Dangerous Driving | None | Brandwood Road | Brandwood Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4139427 | -1.9037653 | |
| 9307 | op-snap---monthly-publication-january-2025.pdf | 415 | 2025-01 | Car | N/K | Dangerous Driving | None | COPPICE LANE | Coppice Lane | Dudley | Dudley | RTC - Actioned | N/A | Yes - Via Email | 52.4781025 | -2.098027 | |||
| 9556 | op-snap---monthly-publication-january-2025.pdf | 664 | 2025-01 | Pedal Bike | Mini | Countryman | Blue | Dangerous Driving | Offence to be added | B4483 National Cycle Route 81 | National Cycle Route 81 | Wolverhampton | Wolverhampton | Court | N/A | Yes - Via Email | |||
| 9557 | op-snap---monthly-publication-january-2025.pdf | 665 | 2025-01 | Car | Volkswagen | Golf | Grey | Dangerous Driving | No Insurance | Cole Street, Netherton | Cole Street, Netherton | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9670 | op-snap---monthly-publication-january-2025.pdf | 778 | 2025-01 | Car | BMW | 120D | Blue | Dangerous Driving | No Insurance | Stockfield Road | Stockfield Road | Birmingham | Birmingham | Other Action Taken | eNn/A | Yes - Via Email | 52.4519414 | -1.831688 | |
| 9888 | op-snap---monthly-publication-january-2025.pdf | 996 | 2025-01 | Car | BMW | 320D | Black | Dangerous Driving | None | Egghill Lane | Egghill Lane | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4093768 | -1.9976236 | |
| 10024 | op-snap---monthly-publication-january-2025.pdf | 1132 | 2025-01 | Car | Volvo | Tractor | Blue | Dangerous Driving | None | M5 NB J5-4a | M5 Northbound J5-4a | 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);