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'}
422 rows where council_area = "Birmingham", disposal = "Court" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence
vehicle_make 28
offence 20
- Driving without Due Care and Attention 272
- Contravening a Red Traffic Light 60
- Stop a vehicle within pelican pedestrian crossing limits 21
- Dangerous Driving 15
- Driving without Reasonable Consideration 13
- Using a Mobile Phone Whilst Driving 6
- Motor vehicle fail to accord precedence at a pelican crossing 5
- No Insurance 4
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 4
- Vehicle overtake within crossing limits 4
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3
- Drive on hard shoulder 3
- Stop a vehicle on pedestrian crossing 3
- Cause vehicle to be left in a dangerous position 2
- Driving a vehicle wholly or partly on a footpath 2
- Contravene Lane Closure Red X 1
- Misc - Non Traffic Offences 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 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 c 1
month 14
reporter_transport_mode 1
- Car · 422 ✖
disposal 1
- Court · 422 ✖
council_area 1
- Birmingham · 422 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7590 | op-snap---monthly-publication-february-2026.pdf | 337 | 2026-02 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Cole Bank Road | Cole Bank Road | Birmingham | Birmingham | Court | N/A | 52.4349375 | -1.8510007 | ||
| 7593 | op-snap---monthly-publication-february-2026.pdf | 340 | 2026-02 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | Walford Road | Walford Road | Birmingham | Birmingham | Court | N/A | 52.4594072 | -1.8658859 | ||
| 7680 | op-snap---monthly-publication-february-2026.pdf | 427 | 2026-02 | Car | Audi | Q5 | Grey | Contravening a Red Traffic Light | None | Newbury Lane | Newbury Lane | Birmingham | Birmingham | Court | N/A | ||||
| 7805 | op-snap---monthly-publication-february-2026.pdf | 552 | 2026-02 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Court | N/A | 52.4198291 | -1.9241732 | ||
| 7929 | op-snap---monthly-publication-february-2026.pdf | 676 | 2026-02 | Car | Volkswagen | golf | Grey | Stop a vehicle within pelican pedestrian crossing limits | No vehicle excise licence | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Court | N/A | 52.4929304 | -1.8229092 | ||
| 8045 | op-snap---monthly-publication-february-2026.pdf | 792 | 2026-02 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Battery Way | Battery Way | Birmingham | Birmingham | Court | N/A | 52.4493988 | -1.8476406 | ||
| 8065 | op-snap---monthly-publication-february-2026.pdf | 812 | 2026-02 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | No Insurance | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Court | N/A | 52.4709298 | -1.8722585 | ||
| 8209 | op-snap---monthly-publication-february-2026.pdf | 956 | 2026-02 | Car | Mercedes-Benz | C220 D | Black | Driving without Due Care and Attention | None | Lawley MIddleway | Lawley MIddleway | Birmingham | Birmingham | Court | N/A | 52.4801772 | -1.8769185 | ||
| 8250 | op-snap---monthly-publication-february-2026.pdf | 997 | 2026-02 | Car | Volkswagen | Toureg | Black | Contravening a Red Traffic Light | None | Cuckoo Road | Cuckoo Road | Birmingham | Birmingham | Court | N/A | 52.5049023 | -1.8603659 | ||
| 8252 | op-snap---monthly-publication-february-2026.pdf | 999 | 2026-02 | Car | BMW | S1000 XR | Grey | Driving without Due Care and Attention | Contravening a Red Traffic Light | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Court | N/A | 52.5012458 | -1.8780942 | ||
| 8289 | op-snap---monthly-publication-february-2026.pdf | 1036 | 2026-02 | Car | Honda | Civic | Black | Driving without Due Care and Attention | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | Court | N/A | 52.4221526 | -1.8425617 | ||
| 8333 | op-snap---monthly-publication-february-2026.pdf | 1080 | 2026-02 | Car | Peugeot | Partner | White | Driving without Due Care and Attention | No Insurance | Cooks Lane | Cooks Lane | Birmingham | Birmingham | Court | N/A | 52.482758 | -1.7603097 | ||
| 8360 | op-snap---monthly-publication-february-2026.pdf | 1107 | 2026-02 | Car | Ford | Transit | Blue | Contravening a Red Traffic Light | No Insurance | Brookvale Road | Brookvale Road | Birmingham | Birmingham | Court | N/A | 52.5219365 | -1.8755325 | ||
| 8412 | op-snap---monthly-publication-february-2026.pdf | 1159 | 2026-02 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | No Insurance | Norrington Road | Norrington Road | Birmingham | Birmingham | Court | N/A | 52.4114918 | -1.9900683 | ||
| 8419 | op-snap---monthly-publication-february-2026.pdf | 1166 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | Court | N/A | 52.4760986 | -1.9018641 | ||
| 8443 | op-snap---monthly-publication-february-2026.pdf | 1190 | 2026-02 | Car | Ford | Fiesta | Silver | Contravening a Red Traffic Light | Drive otherwise than in accordance with a licence | Walsall Road | Walsall Road | Birmingham | Birmingham | Court | N/A | 52.5919543 | -1.8517118 | ||
| 8480 | op-snap---monthly-publication-february-2026.pdf | 1227 | 2026-02 | Car | Volkswagen | golf | Red | Driving without Due Care and Attention | None | Watery Lane Middleway | Watery Lane Middleway | Birmingham | Birmingham | Court | N/A | 52.4752679 | -1.8748608 | ||
| 8502 | op-snap---monthly-publication-february-2026.pdf | 1249 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Moor Lane at Brookvale Road (Perry Barr) | Moor Lane at Brookvale Road (Perry Barr) | Birmingham | Birmingham | Court | N/A | 52.5276389 | -1.8831953 | ||
| 8516 | op-snap---monthly-publication-february-2026.pdf | 1263 | 2026-02 | Car | BMW | 320I | Black | Driving without Due Care and Attention | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Court | N/A | 52.4216321 | -1.855984 | ||
| 8518 | op-snap---monthly-publication-february-2026.pdf | 1265 | 2026-02 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | Hurst Lane North | Hurst Lane North | Birmingham | Birmingham | Court | N/A | 52.4994582 | -1.7644778 | ||
| 8519 | op-snap---monthly-publication-february-2026.pdf | 1266 | 2026-02 | Car | Volkswagen | Jetta | Grey | Driving without Due Care and Attention | None | Hurst Lane North | Hurst Lane North | Birmingham | Birmingham | Court | N/A | 52.4994582 | -1.7644778 | ||
| 8525 | op-snap---monthly-publication-february-2026.pdf | 1272 | 2026-02 | Car | Honda | jazz | Blue | No Insurance | Use vehicle on a road without valid test certificate | Upper Balsall Heath Road | Upper Balsall Heath Road | Birmingham | Birmingham | Court | N/A | 52.4603726 | -1.8856671 | ||
| 8654 | op-snap---monthly-publication-february-2026.pdf | 1401 | 2026-02 | Car | Volkswagen | T Roc | Black | Driving without Due Care and Attention | None | Collingwood Drive | Collingwood Drive | Birmingham | Birmingham | Court | N/A | ||||
| 8674 | op-snap---monthly-publication-february-2026.pdf | 1421 | 2026-02 | Car | Volkswagen | Passat | Black | Driving without Due Care and Attention | No Insurance | Walford Road | Walford Road | Birmingham | Birmingham | Court | N/A | 52.4594072 | -1.8658859 | ||
| 8743 | op-snap---monthly-publication-february-2026.pdf | 1490 | 2026-02 | Car | Vauxhall | Corsa | Silver | Driving without Due Care and Attention | No Insurance | Woodland Road | Woodland Road | Birmingham | Birmingham | Court | N/A | 52.4108681 | -1.9611917 | ||
| 8784 | op-snap---monthly-publication-february-2026.pdf | 1531 | 2026-02 | Car | Honda | CBR 600 | Yellow | Driving without Due Care and Attention | None | Carters Lane | Carters Lane | Birmingham | Birmingham | Court | N/A | 52.4445826 | -2.013123 | ||
| 8810 | op-snap---monthly-publication-february-2026.pdf | 1557 | 2026-02 | Car | Lexus | NX450 | Black | Driving without Due Care and Attention | None | Chester Road, Castle Bromwich | Chester Road, Castle Bromwich | Birmingham | Birmingham | Court | N/A | ||||
| 10541 | op-snap---monthly-publication-january-2026.pdf | 2 | 2026-01 | Car | Audi | S3 | Black | Contravening a Red Traffic Light | No Insurance | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | Court | N/A | 52.4883936 | -1.8310056 | ||
| 10859 | op-snap---monthly-publication-january-2026.pdf | 320 | 2026-01 | Car | Toyota | Yaris | Green | Contravening a Red Traffic Light | No Insurance | Alcester Road | Alcester Road | Birmingham | Birmingham | Court | N/A | 52.4470686 | -1.8880749 | ||
| 10922 | op-snap---monthly-publication-january-2026.pdf | 383 | 2026-01 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Olton Boulevard | Olton Boulevard | Birmingham | Birmingham | Court | N/A | 52.443439 | -1.8180486 | ||
| 11027 | op-snap---monthly-publication-january-2026.pdf | 488 | 2026-01 | Car | Suzuki | GSXS 125 | Black | Driving without Due Care and Attention | Drive otherwise than in accordance with a licence | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Court | N/A | 52.4119174 | -1.9735247 | ||
| 11050 | op-snap---monthly-publication-january-2026.pdf | 511 | 2026-01 | Car | Toyota | Corolla | silver | Driving without Due Care and Attention | None | Sutton Road, Erdington | Sutton Road, Erdington | Birmingham | Birmingham | Court | N/A | 52.5339483 | -1.8285296 | ||
| 11145 | op-snap---monthly-publication-january-2026.pdf | 606 | 2026-01 | Car | BMW | M3 | White | Driving without Due Care and Attention | Contravening a Red Traffic Light | Linden Rd | Linden Road | Birmingham | Birmingham | Court | N/A | 52.4263156 | -1.9351622 | ||
| 11164 | op-snap---monthly-publication-january-2026.pdf | 625 | 2026-01 | Car | Toyota | Prius | White | Driving without Due Care and Attention | Driving without Due Care and Attention | Five Ways Roundabout, Birmingham | Five Ways Roundabout, Birmingham | Birmingham | Birmingham | Court | N/A | ||||
| 11199 | op-snap---monthly-publication-january-2026.pdf | 660 | 2026-01 | Car | Volkswagen | T-Roc | Blue | Contravening a Red Traffic Light | None | Reddings Lane Tysley | Reddings Lane Tysley | Birmingham | Birmingham | Court | N/A | ||||
| 11206 | op-snap---monthly-publication-january-2026.pdf | 667 | 2026-01 | Car | Audi | A5 | Grey | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | Court | N/A | 52.4622646 | -1.8599985 | ||
| 11208 | op-snap---monthly-publication-january-2026.pdf | 669 | 2026-01 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Court | N/A | 52.4929304 | -1.8229092 | ||
| 11321 | op-snap---monthly-publication-january-2026.pdf | 782 | 2026-01 | Car | Renault | Captur | Black | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Grosvenor Road | Grosvenor Road | Birmingham | Birmingham | Court | N/A | 52.4613204 | -1.9681665 | ||
| 11363 | op-snap---monthly-publication-january-2026.pdf | 824 | 2026-01 | Car | Vauxhall | Insignia | Black | Driving without Due Care and Attention | Contravening a Red Traffic Light | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | Court | N/A | 52.4851072 | -1.9468115 | ||
| 11382 | op-snap---monthly-publication-january-2026.pdf | 843 | 2026-01 | Car | Chysler | Black | Driving without Due Care and Attention | None | Warwick Road at Stockfield Road | Warwick Road at Stockfield Road | Birmingham | Birmingham | Court | N/A | 52.551985 | -1.860445 | |||
| 11396 | op-snap---monthly-publication-january-2026.pdf | 857 | 2026-01 | Car | BMW | M4 | Red | Driving without Due Care and Attention | No Insurance | Holiday Street | Holiday Street | Birmingham | Birmingham | Court | N/A | 52.4757071 | -1.8988573 | ||
| 11397 | op-snap---monthly-publication-january-2026.pdf | 858 | 2026-01 | Car | Skoda | Octavia | Blue | Contravening a Red Traffic Light | No Insurance | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 11635 | op-snap---monthly-publication-january-2026.pdf | 1096 | 2026-01 | Car | Vauxhall | Astra | Silver | Contravening a Red Traffic Light | No Insurance | Queslett Road | Queslett Road | Birmingham | Birmingham | Court | N/A | 52.5458699 | -1.9304484 | ||
| 11642 | op-snap---monthly-publication-january-2026.pdf | 1103 | 2026-01 | Car | Volkswagen | Scirroco | Blue | Contravening a Red Traffic Light | None | Great Charles Street | Great Charles Street | Birmingham | Birmingham | Court | N/A | 52.4837518 | -1.901874 | ||
| 11689 | op-snap---monthly-publication-january-2026.pdf | 1150 | 2026-01 | Car | Audi | A3.. | Grey | Driving a vehicle wholly or partly on a footpath | None | Granville Street | Granville Street | Birmingham | Birmingham | Court | N/A | 52.4762076 | -1.9124263 | ||
| 11754 | op-snap---monthly-publication-january-2026.pdf | 1215 | 2026-01 | Car | Hyundai | Bayon | Grey | Driving without Due Care and Attention | None | Clay Lane | Clay Lane | Birmingham | Birmingham | Court | N/A | 52.4509038 | -1.8083784 | ||
| 11778 | op-snap---monthly-publication-january-2026.pdf | 1239 | 2026-01 | Car | Volkswagen | Golf | Black | Using a Mobile Phone Whilst Driving | No Insurance | Old Croft Lane | Old Croft Lane | Birmingham | Birmingham | Court | N/A | 52.496737 | -1.7773905 | ||
| 11806 | op-snap---monthly-publication-january-2026.pdf | 1267 | 2026-01 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | Cole Bank Rd, Sarehole Mill | Cole Bank Road, Sarehole Mill | Birmingham | Birmingham | Court | N/A | ||||
| 11836 | op-snap---monthly-publication-january-2026.pdf | 1297 | 2026-01 | Car | Ford | Eco Sport | Grey | Driving without Due Care and Attention | None | Allens Croft Road | Allens Croft Road | Birmingham | Birmingham | Court | N/A | 52.4242527 | -1.910803 | ||
| 3996 | op-snap---monthly-publication-december-2025.pdf | 124 | 2025-12 | Car | Mercedes-Benz | AMG | Grey | Driving without Due Care and Attention | No Insurance | High Street Kings Heath | High Street Kings Heath | Birmingham | Birmingham | Court | N/A | 52.4375456 | -1.8926849 | ||
| 4088 | op-snap---monthly-publication-december-2025.pdf | 216 | 2025-12 | Car | Mercedes-Benz | c250 | Black | Driving without Due Care and Attention | None | Shaftmoor Lane | Shaftmoor Lane | Birmingham | Birmingham | Court | N/A | 52.4418944 | -1.8407335 | ||
| 4090 | op-snap---monthly-publication-december-2025.pdf | 218 | 2025-12 | Car | Peugeot | 3008.. | Grey | Driving without Due Care and Attention | None | Birmingham Fort Parkway | Birmingham Fort Parkway | Birmingham | Birmingham | Court | N/A | 52.5084571 | -1.8214016 | ||
| 4119 | op-snap---monthly-publication-december-2025.pdf | 247 | 2025-12 | Car | Seat | Leon | Grey | Driving without Due Care and Attention | None | Buckland End Lane | Buckland End Lane | Birmingham | Birmingham | Court | N/A | ||||
| 4186 | op-snap---monthly-publication-december-2025.pdf | 314 | 2025-12 | Car | Volvo | XC90 | Blue | Driving without Due Care and Attention | No Insurance | Richmond Road | Richmond Road | Birmingham | Birmingham | Court | N/A | 52.566947 | -1.8291809 | ||
| 4190 | op-snap---monthly-publication-december-2025.pdf | 318 | 2025-12 | Car | Peugeot | 208 | Black | Driving without Due Care and Attention | None | A38 Aston Expressway | Aston Expressway | Birmingham | Birmingham | Court | N/A | 52.493793 | -1.8881773 | ||
| 4307 | op-snap---monthly-publication-december-2025.pdf | 435 | 2025-12 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | Court | N/A | 52.3962003 | -1.9821252 | ||
| 4325 | op-snap---monthly-publication-december-2025.pdf | 453 | 2025-12 | Car | Yamaha | 125 | Grey | Misc - Non Traffic Offences | None | A38 (M) | A38 (M) | Birmingham | Birmingham | Court | N/A | 52.5096656 | -1.8611835 | ||
| 4351 | op-snap---monthly-publication-december-2025.pdf | 479 | 2025-12 | Car | Volvo | V40.. | Blue | Driving without Due Care and Attention | None | Greenholm Road | Greenholm Road | Birmingham | Birmingham | Court | N/A | 52.5356973 | -1.8929646 | ||
| 4402 | op-snap---monthly-publication-december-2025.pdf | 530 | 2025-12 | Car | Volkswagen | Crafter | White | Driving without Due Care and Attention | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Court | N/A | 52.4709298 | -1.8722585 | ||
| 4431 | op-snap---monthly-publication-december-2025.pdf | 559 | 2025-12 | Car | Volkswagen | Arteon | Blue | Driving without Due Care and Attention | None | Newport Road, Castle Bromwich | Newport Road, Castle Bromwich | Birmingham | Birmingham | Court | N/A | ||||
| 4539 | op-snap---monthly-publication-december-2025.pdf | 667 | 2025-12 | Car | Maserati | Blue | Driving without Due Care and Attention | None | A38m | A38m | Birmingham | Birmingham | Court | N/A | |||||
| 4730 | op-snap---monthly-publication-december-2025.pdf | 858 | 2025-12 | Car | Tesla | Model Y | White | Driving without Due Care and Attention | None | Bunbury Road | Bunbury Road | Birmingham | Birmingham | Court | N/A | 52.4142089 | -1.9587147 | ||
| 4826 | op-snap---monthly-publication-december-2025.pdf | 954 | 2025-12 | Car | Seat | MII | Black | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 4894 | op-snap---monthly-publication-december-2025.pdf | 1022 | 2025-12 | Car | Ford | Connect | White | Contravening a Red Traffic Light | No Insurance | A4041 Newton Road | Newton Road | Birmingham | Birmingham | Court | N/A | 52.4541102 | -1.8710993 | ||
| 4968 | op-snap---monthly-publication-december-2025.pdf | 1096 | 2025-12 | Car | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Court | N/A | 52.4119174 | -1.9735247 | ||
| 5046 | op-snap---monthly-publication-december-2025.pdf | 1174 | 2025-12 | Car | Mercedes-Benz | C220 | white | Driving without Due Care and Attention | None | Cattel Road | Cattel Road | Birmingham | Birmingham | Court | N/A | ||||
| 5047 | op-snap---monthly-publication-december-2025.pdf | 1175 | 2025-12 | Car | Toyota | Aygo | Black | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Court | N/A | 52.4555288 | -1.8613929 | ||
| 5054 | op-snap---monthly-publication-december-2025.pdf | 1182 | 2025-12 | Car | BMW | 330.. | Grey | Contravening a Red Traffic Light | None | Great Barr Interchange | Great Barr Interchange | Birmingham | Birmingham | Court | N/A | 52.544549 | -1.9310678 | ||
| 5058 | op-snap---monthly-publication-december-2025.pdf | 1186 | 2025-12 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Court | N/A | 52.5458699 | -1.9304484 | ||
| 20478 | op-snap---monthly-publication-november-2025.pdf | 20 | 2025-11 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Court | N/A | ||||
| 20506 | op-snap---monthly-publication-november-2025.pdf | 48 | 2025-11 | Car | Volvo | Lorry | White | Driving without Due Care and Attention | None | M42 Motorway | M42 Motorway | Birmingham | Birmingham | Court | N/A | 52.490826 | -1.8882034 | ||
| 20518 | op-snap---monthly-publication-november-2025.pdf | 60 | 2025-11 | Car | Volkswagen | Golf | Red | Drive on hard shoulder | No Insurance | M6 Northbound jn 5 to 6 | M6 Northbound jn 5 to 6 | Birmingham | Birmingham | Court | N/A | ||||
| 20579 | op-snap---monthly-publication-november-2025.pdf | 121 | 2025-11 | Car | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | No Insurance | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Court | N/A | 52.5292752 | -1.7618805 | ||
| 20584 | op-snap---monthly-publication-november-2025.pdf | 126 | 2025-11 | Car | Audi | A4 | White | Driving without Due Care and Attention | No Insurance | Stonehouse Lane | Stonehouse Lane | Birmingham | Birmingham | Court | N/A | 52.4440435 | -1.9818872 | ||
| 20611 | op-snap---monthly-publication-november-2025.pdf | 153 | 2025-11 | Car | Ford | Focus | Blue | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Court | N/A | 52.4167654 | -1.9411244 | ||
| 20612 | op-snap---monthly-publication-november-2025.pdf | 154 | 2025-11 | Car | Seat | Leon | Blue | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Court | N/A | 52.5113867 | -1.8337258 | ||
| 20613 | op-snap---monthly-publication-november-2025.pdf | 155 | 2025-11 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Court | N/A | 52.5113867 | -1.8337258 | ||
| 20619 | op-snap---monthly-publication-november-2025.pdf | 161 | 2025-11 | Car | Vauxhall | Crossland | Black | Driving without Due Care and Attention | None | Tixall Road | Tixall Road | Birmingham | Birmingham | Court | N/A | 52.4193312 | -1.8517995 | ||
| 20634 | op-snap---monthly-publication-november-2025.pdf | 176 | 2025-11 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Court | N/A | ||||
| 20672 | op-snap---monthly-publication-november-2025.pdf | 214 | 2025-11 | Car | Volkswagen | Sharan | Black | Driving without Due Care and Attention | No Insurance | St Margarets Road | Street Margarets Road | Birmingham | Birmingham | Court | N/A | ||||
| 20740 | op-snap---monthly-publication-november-2025.pdf | 282 | 2025-11 | Car | BMW | 120d | Black | Driving without Due Care and Attention | No Insurance | Barnes Hill | Barnes Hill | Birmingham | Birmingham | Court | N/A | 52.4401325 | -1.9785938 | ||
| 20745 | op-snap---monthly-publication-november-2025.pdf | 287 | 2025-11 | Car | Jaguar | XF | Silver | Driving without Due Care and Attention | No vehicle excise licence | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Court | N/A | 52.5083238 | -1.8332287 | ||
| 20786 | op-snap---monthly-publication-november-2025.pdf | 328 | 2025-11 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | No Insurance | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Court | N/A | 52.5274116 | -1.9287273 | ||
| 20820 | op-snap---monthly-publication-november-2025.pdf | 362 | 2025-11 | Car | Volkswagen | Caddy | White | Driving without Due Care and Attention | None | Edgewood Road | Edgewood Road | Birmingham | Birmingham | Court | N/A | 52.3904074 | -2.0028084 | ||
| 20845 | op-snap---monthly-publication-november-2025.pdf | 387 | 2025-11 | Car | Ford | Fiesta | Orange | Driving without Due Care and Attention | None | Walmey Ash Road | Walmey Ash Road | Birmingham | Birmingham | Court | N/A | ||||
| 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 | ||
| 21326 | op-snap---monthly-publication-november-2025.pdf | 868 | 2025-11 | Car | Land Rover | Land Rover | Black | Driving without Due Care and Attention | None | Billesley Lane | Billesley Lane | Birmingham | Birmingham | Court | N/A | 52.4344402 | -1.8845368 | ||
| 21327 | op-snap---monthly-publication-november-2025.pdf | 869 | 2025-11 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Beacon Road | Beacon Road | Birmingham | Birmingham | Court | N/A | 52.545172 | -1.836877 | ||
| 21403 | op-snap---monthly-publication-november-2025.pdf | 945 | 2025-11 | Car | Nissan | QASQHAI | Silver | Driving without Due Care and Attention | None | Reddings LANE | Reddings LANE | Birmingham | Birmingham | Court | N/A | 52.4506039 | -1.8463952 | ||
| 21409 | op-snap---monthly-publication-november-2025.pdf | 951 | 2025-11 | Car | Peugeot | Expert | White | Contravening a Red Traffic Light | No Insurance | Coventry Road | Coventry Road | Birmingham | Birmingham | Court | N/A | 52.4726661 | -1.8769032 | ||
| 21417 | op-snap---monthly-publication-november-2025.pdf | 959 | 2025-11 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Court | N/A | 52.4709298 | -1.8722585 | ||
| 21522 | op-snap---monthly-publication-november-2025.pdf | 1064 | 2025-11 | Car | Skoda | Kamiq | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Court | N/A | 52.5012458 | -1.8780942 | ||
| 21576 | op-snap---monthly-publication-november-2025.pdf | 1118 | 2025-11 | Car | Peugeot | 208 | Blue | Driving without Due Care and Attention | None | Burney Lane | Burney Lane | Birmingham | Birmingham | Court | N/A | 52.489521 | -1.8206611 | ||
| 21587 | op-snap---monthly-publication-november-2025.pdf | 1129 | 2025-11 | Car | Mercedes-Benz | CLA 200 | Blue | Driving without Due Care and Attention | None | Heathfield Road | Heathfield Road | Birmingham | Birmingham | Court | N/A | 52.5905365 | -1.8453418 | ||
| 21673 | op-snap---monthly-publication-november-2025.pdf | 1215 | 2025-11 | Car | BMW | 530 D | Blue | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Court | N/A | ||||
| 21683 | op-snap---monthly-publication-november-2025.pdf | 1225 | 2025-11 | Car | Mercedes-Benz | CLA | Blue | Using a Mobile Phone Whilst Driving | Driving without Due Care and Attention | Hagley Road / Portland Road | Hagley Road / Portland Road | Birmingham | Birmingham | Court | N/A | 52.471836 | -1.9401037 | ||
| 21781 | op-snap---monthly-publication-november-2025.pdf | 1323 | 2025-11 | Car | Citroen | Xsara | Grey | Driving without Due Care and Attention | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Court | N/A | 52.50787 | -1.8195713 | ||
| 21782 | op-snap---monthly-publication-november-2025.pdf | 1324 | 2025-11 | Car | Skoda | Octavia | Green | Driving without Due Care and Attention | None | Black Country Route | Black Country Route | Birmingham | Birmingham | Court | N/A | ||||
| 21884 | op-snap---monthly-publication-november-2025.pdf | 1426 | 2025-11 | Car | BMW | 118d | Blue | Driving without Due Care and Attention | No Insurance | Wharf Road | Wharf Road | Birmingham | Birmingham | Court | N/A | 52.4075531 | -1.927329 | ||
| 21948 | op-snap---monthly-publication-november-2025.pdf | 1490 | 2025-11 | Car | Audi | R8 | Blue | Driving without Due Care and Attention | None | Victoria Road | Victoria Road | Birmingham | Birmingham | Court | N/A | 52.5615573 | -1.820549 |
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);