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'}
1,642 rows where council_area = "Birmingham", disposal = "Education" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 19
- Driving without Due Care and Attention 504
- Contravening a Red Traffic Light 449
- Stop a vehicle within pelican pedestrian crossing limits 402
- Stop a vehicle on pedestrian crossing 116
- Driving without Reasonable Consideration 62
- Cause vehicle to be left in a dangerous position 35
- Contravene Lane Closure Red X 17
- Drive a vehicle other than on the carriageway of a motorway 16
- Drive on hard shoulder 14
- Vehicle overtake within crossing limits 8
- Drive a vehicle other than on the carriageway of a 4
- Motor vehicle fail to accord precedence at a pelican crossing 4
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3
- Driver not in position to have Proper Control 3
- 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
- Prohibited vehicle in offside lane of motorway 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
- Using a Mobile Phone Whilst Driving 1
month 14
reporter_transport_mode 1
- Car · 1,642 ✖
disposal 1
- Education · 1,642 ✖
council_area 1
- Birmingham · 1,642 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7260 | op-snap---monthly-publication-february-2026.pdf | 7 | 2026-02 | Car | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Education | N/A | 52.5274116 | -1.9287273 | ||
| 7262 | op-snap---monthly-publication-february-2026.pdf | 9 | 2026-02 | Car | Fiat | 500.. | Grey | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 7265 | op-snap---monthly-publication-february-2026.pdf | 12 | 2026-02 | Car | Mercedes-Benz | CLA 180 | Black | Contravening a Red Traffic Light | None | Oak Tree Lane | Oak Tree Lane | Birmingham | Birmingham | Education | N/A | 52.431258 | -1.9394381 | ||
| 7283 | op-snap---monthly-publication-february-2026.pdf | 30 | 2026-02 | Car | Nissan | Qashqai | White | Cause vehicle to be left in a dangerous position | None | Chantry Road | Chantry Road | Birmingham | Birmingham | Education | N/A | 52.4496376 | -1.8915224 | ||
| 7289 | op-snap---monthly-publication-february-2026.pdf | 36 | 2026-02 | Car | Mg | 6 S GT | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 7335 | op-snap---monthly-publication-february-2026.pdf | 82 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7336 | op-snap---monthly-publication-february-2026.pdf | 83 | 2026-02 | Car | Audi | A4 | red | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7337 | op-snap---monthly-publication-february-2026.pdf | 84 | 2026-02 | Car | Volkswagen | Touran | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7339 | op-snap---monthly-publication-february-2026.pdf | 86 | 2026-02 | Car | Vauxhall | Adam | Red | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7341 | op-snap---monthly-publication-february-2026.pdf | 88 | 2026-02 | Car | Toyota | Corolla | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7347 | op-snap---monthly-publication-february-2026.pdf | 94 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Streetly Road, Short Heath | Streetly Road, Short Heath | Birmingham | Birmingham | Education | N/A | 52.5316018 | -1.8581289 | ||
| 7348 | op-snap---monthly-publication-february-2026.pdf | 95 | 2026-02 | Car | Citroen | DS3 | Purple | Contravening a Red Traffic Light | None | Sir Herbert Austin Way | Sir Herbert Austin Way | Birmingham | Birmingham | Education | N/A | 52.4132666 | -1.9735631 | ||
| 7365 | op-snap---monthly-publication-february-2026.pdf | 112 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Booth Street, Handsworth | Booth Street, Handsworth | Birmingham | Birmingham | Education | N/A | 52.5039035 | -1.9447084 | ||
| 7385 | op-snap---monthly-publication-february-2026.pdf | 132 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7386 | op-snap---monthly-publication-february-2026.pdf | 133 | 2026-02 | Car | Ford | KA | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7390 | op-snap---monthly-publication-february-2026.pdf | 137 | 2026-02 | Car | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Church Street | Church Street | Birmingham | Birmingham | Education | N/A | 52.5020781 | -1.9122368 | ||
| 7391 | op-snap---monthly-publication-february-2026.pdf | 138 | 2026-02 | Car | Ford | Fiesta | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7425 | op-snap---monthly-publication-february-2026.pdf | 172 | 2026-02 | Car | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | Gravelly Hill | Gravelly Hill | Birmingham | Birmingham | Education | N/A | 52.5153884 | -1.8527437 | ||
| 7471 | op-snap---monthly-publication-february-2026.pdf | 218 | 2026-02 | Car | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7473 | op-snap---monthly-publication-february-2026.pdf | 220 | 2026-02 | Car | Mercedes-Benz | 312.. | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7477 | op-snap---monthly-publication-february-2026.pdf | 224 | 2026-02 | Car | Volkswagen | Golf R | Silver | Contravening a Red Traffic Light | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 7478 | op-snap---monthly-publication-february-2026.pdf | 225 | 2026-02 | Car | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Education | N/A | 52.5531351 | -1.8852761 | ||
| 7489 | op-snap---monthly-publication-february-2026.pdf | 236 | 2026-02 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 7496 | op-snap---monthly-publication-february-2026.pdf | 243 | 2026-02 | Car | Hyundai | I10 | Silver | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | Education | N/A | 52.4622646 | -1.8599985 | ||
| 7505 | op-snap---monthly-publication-february-2026.pdf | 252 | 2026-02 | Car | Seat | Cupra | Grey | Driving without Due Care and Attention | None | Sand Pits | Sand Pits | Birmingham | Birmingham | Education | N/A | ||||
| 7509 | op-snap---monthly-publication-february-2026.pdf | 256 | 2026-02 | Car | Skoda | Octavia | White | Driving without Due Care and Attention | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Education | N/A | 52.50787 | -1.8195713 | ||
| 7513 | op-snap---monthly-publication-february-2026.pdf | 260 | 2026-02 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 7582 | op-snap---monthly-publication-february-2026.pdf | 329 | 2026-02 | Car | Dennis | Green | Cause vehicle to be left in a dangerous position | None | Tinkers Farm Road | Tinkers Farm Road | Birmingham | Birmingham | Education | N/A | 52.4124264 | -1.981477 | |||
| 7596 | op-snap---monthly-publication-february-2026.pdf | 343 | 2026-02 | Car | Citroen | C3.. | White | Driving without Due Care and Attention | None | New John Street West | New John Street West | Birmingham | Birmingham | Education | N/A | 52.4944784 | -1.9122329 | ||
| 7619 | op-snap---monthly-publication-february-2026.pdf | 366 | 2026-02 | Car | Skoda | Octavia | Grey | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 7649 | op-snap---monthly-publication-february-2026.pdf | 396 | 2026-02 | Car | Volkswagen | Polo | Silver | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 7650 | op-snap---monthly-publication-february-2026.pdf | 397 | 2026-02 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 7658 | op-snap---monthly-publication-february-2026.pdf | 405 | 2026-02 | Car | Audi | A4 | Red | Driving without Due Care and Attention | None | Hustcroft Road | Hustcroft Road | Birmingham | Birmingham | Education | N/A | ||||
| 7661 | op-snap---monthly-publication-february-2026.pdf | 408 | 2026-02 | Car | Toyota | Auris | Black | Cause vehicle to be left in a dangerous position | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Education | N/A | 52.4830179 | -1.783876 | ||
| 7662 | op-snap---monthly-publication-february-2026.pdf | 409 | 2026-02 | Car | Volkswagen | Tiguan | Grey | Cause vehicle to be left in a dangerous position | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Education | N/A | 52.4830179 | -1.783876 | ||
| 7710 | op-snap---monthly-publication-february-2026.pdf | 457 | 2026-02 | Car | BMW | X3 M | Grey | Driving without Due Care and Attention | None | Heath Way | Heath Way | Birmingham | Birmingham | Education | N/A | 52.4963549 | -1.7806171 | ||
| 7718 | op-snap---monthly-publication-february-2026.pdf | 465 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Education | N/A | 52.471632 | -1.9456776 | ||
| 7725 | op-snap---monthly-publication-february-2026.pdf | 472 | 2026-02 | Car | BMW | 3 series | Black | Contravene Lane Closure Red X | None | M6 SB, before Jn 6 | M6 Southbound, before Junction 6 | Birmingham | Birmingham | Education | N/A | 52.6760749 | -2.0862582 | ||
| 7743 | op-snap---monthly-publication-february-2026.pdf | 490 | 2026-02 | Car | Toyota | Previa | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7746 | op-snap---monthly-publication-february-2026.pdf | 493 | 2026-02 | Car | Mercedes-Benz | A180.. | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7748 | op-snap---monthly-publication-february-2026.pdf | 495 | 2026-02 | Car | Peugeot | Rifter | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7750 | op-snap---monthly-publication-february-2026.pdf | 497 | 2026-02 | Car | Nissan | Qashqai | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7755 | op-snap---monthly-publication-february-2026.pdf | 502 | 2026-02 | Car | Vauxhall | Meriva | White | Contravening a Red Traffic Light | None | Hampstead Road at Victorian Way | Hampstead Road at Victorian Way | Birmingham | Birmingham | Education | N/A | 52.3993507 | -1.9640409 | ||
| 7761 | op-snap---monthly-publication-february-2026.pdf | 508 | 2026-02 | Car | Skoda | Octavia | White | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 7762 | op-snap---monthly-publication-february-2026.pdf | 509 | 2026-02 | Car | Ford | Smax | blue | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 7765 | op-snap---monthly-publication-february-2026.pdf | 512 | 2026-02 | Car | Mercedes-Benz | Splinter | Green | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 7767 | op-snap---monthly-publication-february-2026.pdf | 514 | 2026-02 | Car | Ford | Fiesta | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7773 | op-snap---monthly-publication-february-2026.pdf | 520 | 2026-02 | Car | Audi | Q4 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7776 | op-snap---monthly-publication-february-2026.pdf | 523 | 2026-02 | Car | Mercedes-Benz | A180 | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7781 | op-snap---monthly-publication-february-2026.pdf | 528 | 2026-02 | Car | Nissan | Qashqai | Grey | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7782 | op-snap---monthly-publication-february-2026.pdf | 529 | 2026-02 | Car | Ford | Mondeo | Blue | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Education | N/A | 52.471632 | -1.9456776 | ||
| 7795 | op-snap---monthly-publication-february-2026.pdf | 542 | 2026-02 | Car | BMW | X1 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Kitts Green Road | Kitts Green Road | Birmingham | Birmingham | Education | N/A | 52.4815372 | -1.7766518 | ||
| 7801 | op-snap---monthly-publication-february-2026.pdf | 548 | 2026-02 | Car | Byd | Bus | Grey | Driving without Due Care and Attention | None | Haden Way | Haden Way | Birmingham | Birmingham | Education | N/A | 52.4596018 | -1.8864623 | ||
| 7803 | op-snap---monthly-publication-february-2026.pdf | 550 | 2026-02 | Car | Toyota | Corolla | White | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Education | N/A | 52.5274116 | -1.9287273 | ||
| 7809 | op-snap---monthly-publication-february-2026.pdf | 556 | 2026-02 | Car | Mercedes-Benz | A180 | Red | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | Education | N/A | ||||
| 7817 | op-snap---monthly-publication-february-2026.pdf | 564 | 2026-02 | Car | Ford | Transit connect | White | Contravening a Red Traffic Light | None | A5127 Erdington | Erdington | Birmingham | Birmingham | Education | N/A | 52.5232514 | -1.8395109 | ||
| 7855 | op-snap---monthly-publication-february-2026.pdf | 602 | 2026-02 | Car | Land Rover | Range Rover | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 7873 | op-snap---monthly-publication-february-2026.pdf | 620 | 2026-02 | Car | Yamaha | YZF125 | White | Driving without Due Care and Attention | None | Station Road, Stechford | Station Road, Stechford | Birmingham | Birmingham | Education | N/A | 52.480771 | -1.8086714 | ||
| 7876 | op-snap---monthly-publication-february-2026.pdf | 623 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Anglesey Street, Lozells | Anglesey Street, Lozells | Birmingham | Birmingham | Education | N/A | 52.5000379 | -1.9102942 | ||
| 7878 | op-snap---monthly-publication-february-2026.pdf | 625 | 2026-02 | Car | Tesla | Model Y | White | Driving without Due Care and Attention | None | Anglesey Street | Anglesey Street | Birmingham | Birmingham | Education | N/A | 52.5000379 | -1.9102942 | ||
| 7885 | op-snap---monthly-publication-february-2026.pdf | 632 | 2026-02 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | M6 after J4 | M6 after J4 | Birmingham | Birmingham | Education | N/A | ||||
| 7921 | op-snap---monthly-publication-february-2026.pdf | 668 | 2026-02 | Car | Volkswagen | Caddy | White | Driving without Due Care and Attention | None | J10 slip M6 towards Bham | J10 slip M6 towards Bham | Birmingham | Birmingham | Education | N/A | ||||
| 7927 | op-snap---monthly-publication-february-2026.pdf | 674 | 2026-02 | Car | Toyota | MPV | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7928 | op-snap---monthly-publication-february-2026.pdf | 675 | 2026-02 | Car | Volkswagen | Crafter | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7930 | op-snap---monthly-publication-february-2026.pdf | 677 | 2026-02 | Car | Volkswagen | Passat | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7931 | op-snap---monthly-publication-february-2026.pdf | 678 | 2026-02 | Car | Hyundai | I10 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7943 | op-snap---monthly-publication-february-2026.pdf | 690 | 2026-02 | Car | Audi | Red | Driving without Due Care and Attention | None | West Boulevard | West Boulevard | Birmingham | Birmingham | Education | N/A | 52.4484674 | -1.9780395 | |||
| 7987 | op-snap---monthly-publication-february-2026.pdf | 734 | 2026-02 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Education | N/A | 52.4606652 | -1.8791145 | ||
| 7988 | op-snap---monthly-publication-february-2026.pdf | 735 | 2026-02 | Car | Mercedes-Benz | A Class | Silver | Contravening a Red Traffic Light | None | Longmore Street | Longmore Street | Birmingham | Birmingham | Education | N/A | 52.464484 | -1.8923374 | ||
| 7991 | op-snap---monthly-publication-february-2026.pdf | 738 | 2026-02 | Car | Mitsubishi | Outlander | White | Contravening a Red Traffic Light | None | Chester Road at Bradford Road | Chester Road at Bradford Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 8003 | op-snap---monthly-publication-february-2026.pdf | 750 | 2026-02 | Car | Toyota | Corolla | White | Stop a vehicle within pelican pedestrian crossing limits | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Education | N/A | 52.4520441 | -1.8787544 | ||
| 8009 | op-snap---monthly-publication-february-2026.pdf | 756 | 2026-02 | Car | Volkswagen | ID4 | Blue | Contravening a Red Traffic Light | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | Education | N/A | 52.4718503 | -1.9195423 | ||
| 8010 | op-snap---monthly-publication-february-2026.pdf | 757 | 2026-02 | Car | Toyota | Auris | Black | Contravening a Red Traffic Light | None | Salford Circus Roundabout, Erdington | Salford Circus Roundabout, Erdington | Birmingham | Birmingham | Education | N/A | ||||
| 8011 | op-snap---monthly-publication-february-2026.pdf | 758 | 2026-02 | Car | Kia | Ceed | Grey | Contravening a Red Traffic Light | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8013 | op-snap---monthly-publication-february-2026.pdf | 760 | 2026-02 | Car | Mercedes-Benz | A180 | Grey | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Education | N/A | 52.473883 | -1.9198244 | ||
| 8014 | op-snap---monthly-publication-february-2026.pdf | 761 | 2026-02 | Car | Citroen | C3 | Black | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Education | N/A | 52.4198291 | -1.9241732 | ||
| 8039 | op-snap---monthly-publication-february-2026.pdf | 786 | 2026-02 | Car | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | Russell Road | Russell Road | Birmingham | Birmingham | Education | N/A | 52.4398245 | -1.8469786 | ||
| 8051 | op-snap---monthly-publication-february-2026.pdf | 798 | 2026-02 | Car | Volkswagen | Caddy | Blue | Driving without Due Care and Attention | None | Kings Road, Tyseley | Kings Road, Tyseley | Birmingham | Birmingham | Education | N/A | 52.4572996 | -1.8391692 | ||
| 8057 | op-snap---monthly-publication-february-2026.pdf | 804 | 2026-02 | Car | Nissan | Micra | Red | Contravening a Red Traffic Light | No Insurance | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8059 | op-snap---monthly-publication-february-2026.pdf | 806 | 2026-02 | Car | Toyota | Corolla | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8060 | op-snap---monthly-publication-february-2026.pdf | 807 | 2026-02 | Car | Nissan | Juke | Blue | Driving without Due Care and Attention | None | Victoria Road Perry Barr | Victoria Road Perry Barr | Birmingham | Birmingham | Education | N/A | 52.5024231 | -1.8980876 | ||
| 8066 | op-snap---monthly-publication-february-2026.pdf | 813 | 2026-02 | Car | Suzuki | Alto | Grey | Driving without Due Care and Attention | None | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | Education | N/A | 52.4883936 | -1.8310056 | ||
| 8072 | op-snap---monthly-publication-february-2026.pdf | 819 | 2026-02 | Car | Volkswagen | Passat | White | Driving without Due Care and Attention | None | M6 J5 | M6 J5 | Birmingham | Birmingham | Education | N/A | 52.6760749 | -2.0862582 | ||
| 8073 | op-snap---monthly-publication-february-2026.pdf | 820 | 2026-02 | Car | BMW | 4 series | Grey | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 8074 | op-snap---monthly-publication-february-2026.pdf | 821 | 2026-02 | Car | BMW | 4 series | Grey | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 8086 | op-snap---monthly-publication-february-2026.pdf | 833 | 2026-02 | Car | Skoda | Octavia | Beige | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Education | N/A | 52.5919543 | -1.8517118 | ||
| 8090 | op-snap---monthly-publication-february-2026.pdf | 837 | 2026-02 | Car | Vmoto | Black | Contravening a Red Traffic Light | None | Aston Lane at London Road | Aston Lane at London Road | Birmingham | Birmingham | Education | N/A | 52.5151247 | -1.9007033 | |||
| 8098 | op-snap---monthly-publication-february-2026.pdf | 845 | 2026-02 | Car | BMW | 520.. | White | Driving without Due Care and Attention | None | Heartlands Parkway | Heartlands Parkway | Birmingham | Birmingham | Education | N/A | 52.5038363 | -1.8432663 | ||
| 8100 | op-snap---monthly-publication-february-2026.pdf | 847 | 2026-02 | Car | Skoda | Octavia | Red | Driving without Due Care and Attention | None | Kingscote Road | Kingscote Road | Birmingham | Birmingham | Education | N/A | 52.4628762 | -1.9419862 | ||
| 8101 | op-snap---monthly-publication-february-2026.pdf | 848 | 2026-02 | Car | Honda | Insight | Black | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Education | N/A | 52.473883 | -1.9198244 | ||
| 8112 | op-snap---monthly-publication-february-2026.pdf | 859 | 2026-02 | Car | BMW | 320d | Blue | Driving without Due Care and Attention | None | Hockley Circus | Hockley Circus | Birmingham | Birmingham | Education | N/A | 52.4952382 | -1.9146705 | ||
| 8113 | op-snap---monthly-publication-february-2026.pdf | 860 | 2026-02 | Car | Vauxhall | Mokka | Silver | Driving without Due Care and Attention | None | Foundry Road | Foundry Road | Birmingham | Birmingham | Education | N/A | 52.4939937 | -1.9413942 | ||
| 8122 | op-snap---monthly-publication-february-2026.pdf | 869 | 2026-02 | Car | Mercedes-Benz | B180 | Silver | Driving without Due Care and Attention | None | Bordesley Circus | Bordesley Circus | Birmingham | Birmingham | Education | N/A | 52.4728608 | -1.8754722 | ||
| 8139 | op-snap---monthly-publication-february-2026.pdf | 886 | 2026-02 | Car | Audi | A6 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8141 | op-snap---monthly-publication-february-2026.pdf | 888 | 2026-02 | Car | Toyota | C-HR | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8142 | op-snap---monthly-publication-february-2026.pdf | 889 | 2026-02 | Car | Nissan | Micra | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8143 | op-snap---monthly-publication-february-2026.pdf | 890 | 2026-02 | Car | Honda | Jazz | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8165 | op-snap---monthly-publication-february-2026.pdf | 912 | 2026-02 | Car | Toyota | Yaris | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8168 | op-snap---monthly-publication-february-2026.pdf | 915 | 2026-02 | Car | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8169 | op-snap---monthly-publication-february-2026.pdf | 916 | 2026-02 | Car | Kia | Stonic | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 |
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);