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'}
2,526 rows where 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, council_area_raw, nfa_rationale
vehicle_make >30
- Volkswagen 272
- Ford 258
- Audi 245
- BMW 241
- Mercedes-Benz 241
- Toyota 237
- Vauxhall 157
- Nissan 101
- Seat 92
- Peugeot 77
- Honda 63
- Hyundai 59
- Citroen 47
- Kia 45
- Renault 44
- Skoda 43
- Land Rover 37
- Volvo 36
- Fiat 26
- Mazda 17
- Mg 16
- Mini 16
- Jaguar 14
- Suzuki 13
- Tesla 13
- Lexus 12
- Mitsubishi 9
- Yamaha 9
- Porsche 7
- Dacia 6
- …
offence 25
- Driving without Due Care and Attention 875
- Contravening a Red Traffic Light 801
- Stop a vehicle within pelican pedestrian crossing limits 456
- Stop a vehicle on pedestrian crossing 136
- Driving without Reasonable Consideration 101
- Cause vehicle to be left in a dangerous position 39
- Drive a vehicle other than on the carriageway of a motorway 25
- Drive on hard shoulder 23
- Contravene Lane Closure Red X 19
- Vehicle overtake within crossing limits 11
- Motor vehicle fail to accord precedence at a pelican crossing 7
- Drive a vehicle other than on the carriageway of a 6
- Prohibited vehicle in offside lane of motorway 5
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 4
- Driver not in position to have Proper Control 4
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 3
- Using a Mobile Phone Whilst Driving 3
- DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Motor vehicle fail to comply with solid white line road markings 1
- No Seat Belt 1
- Stop a vehicle within pelican pedestrian crossing l 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
council_area 22
- Birmingham 1,642
- Coventry 162
- Sandwell 140
- Wolverhampton 127
- Solihull 125
- Dudley 124
- Walsall 114
- Sutton Coldfield 73
- Halesowen 4
- Metropolitan Borough 2
- Metropolitan Borough Of Dudley 2
- Abdirmingham 1
- Basirtmingham 1
- Borirt Mrionagdham 1
- Cst Arnadwell 1
- Eb Ivrmaleingham 1
- Ebtisrm Cinogrhnamer 1
- Nboirrmtoinng.Ham 1
- Nwolverhampton 1
- Tbanirtmonin Rghda Nmr Junction With Cambrid 1
- Toount Corfo Sfsorrocaed As.Rea 1
- Uwnodlavbeorhuatmpton 1
month 14
reporter_transport_mode 1
- Car · 2,526 ✖
disposal 1
- Education · 2,526 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7257 | op-snap---monthly-publication-february-2026.pdf | 4 | 2026-02 | Car | Mazda | CX30 | Grey | Driving without Due Care and Attention | None | High Street, Quarry Bank | High Street, Quarry Bank | Dudley | Dudley | Education | N/A | 52.4576453 | -2.1150716 | ||
| 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 | ||
| 7268 | op-snap---monthly-publication-february-2026.pdf | 15 | 2026-02 | Car | Rolls-Royce | Blue | Contravening a Red Traffic Light | None | M6 J9 | M6 J9 | Walsall | Walsall | Education | N/A | 52.676119 | -2.0858425 | |||
| 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 | ||
| 7292 | op-snap---monthly-publication-february-2026.pdf | 39 | 2026-02 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Knowle High Street | Knowle High Street | Coventry | Coventry | Education | N/A | ||||
| 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 | ||
| 7343 | op-snap---monthly-publication-february-2026.pdf | 90 | 2026-02 | Car | Audi | A3 | Silver | Contravening a Red Traffic Light | None | Station Road | Station Road | Sandwell | Sandwell | Education | N/A | 52.4774652 | -2.0337514 | ||
| 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 | ||
| 7371 | op-snap---monthly-publication-february-2026.pdf | 118 | 2026-02 | Car | Land Rover | Evoque | Beige | Contravening a Red Traffic Light | None | Venture Way | Venture Way | Dudley | Dudley | Education | N/A | 52.4836603 | -2.1189326 | ||
| 7377 | op-snap---monthly-publication-february-2026.pdf | 124 | 2026-02 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Walmley Road | Walmley Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5405351 | -1.8002219 | ||
| 7379 | op-snap---monthly-publication-february-2026.pdf | 126 | 2026-02 | Car | Ford | Ecosport | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Clarkes Lane, West Bromwich | Clarkes Lane, West Bromwich | Sandwell | Sandwell | Education | N/A | ||||
| 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 | ||
| 7487 | op-snap---monthly-publication-february-2026.pdf | 234 | 2026-02 | Car | Seat | mii | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Hollyfield Road | Hollyfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5620486 | -1.8030784 | ||
| 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 | ||
| 7497 | op-snap---monthly-publication-february-2026.pdf | 244 | 2026-02 | Car | BMW | X1 | Blue | Driving without Due Care and Attention | None | Torcross Avenue | Torcross Avenue | Coventry | Coventry | Education | N/A | 52.4218194 | -1.46546 | ||
| 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 | ||
| 7532 | op-snap---monthly-publication-february-2026.pdf | 279 | 2026-02 | Car | Lexus | CT200 | White | Driving without Due Care and Attention | None | Cross Street South | Cross Street South | Wolverhampton | Wolverhampton | Education | N/A | 52.570955 | -2.130838 | ||
| 7535 | op-snap---monthly-publication-february-2026.pdf | 282 | 2026-02 | Car | Peugeot | 206 | Silver | Driving without Due Care and Attention | None | Winding House Lane | Winding House Lane | Coventry | Coventry | Education | N/A | 52.4490457 | -1.5001195 | ||
| 7572 | op-snap---monthly-publication-february-2026.pdf | 319 | 2026-02 | Car | BMW | 325D | Black | Contravening a Red Traffic Light | None | Danford Lane at Blossomfield Road | Danford Lane at Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 7579 | op-snap---monthly-publication-february-2026.pdf | 326 | 2026-02 | Car | Kia | Xceed | Grey | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Education | N/A | 52.5478387 | -2.0943116 | ||
| 7580 | op-snap---monthly-publication-february-2026.pdf | 327 | 2026-02 | Car | Honda | CR-V | Blue | Contravening a Red Traffic Light | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Education | N/A | 52.437016 | -1.7578446 | ||
| 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 | |||
| 7585 | op-snap---monthly-publication-february-2026.pdf | 332 | 2026-02 | Car | Land Rover | Land Rover | Blue | Contravening a Red Traffic Light | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 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 | ||
| 7603 | op-snap---monthly-publication-february-2026.pdf | 350 | 2026-02 | Car | Hyundai | 130 | Blue | Driving without Due Care and Attention | None | A46 Coventry | Coventry | Coventry | Coventry | Education | N/A | 52.400739 | -1.5135474 | ||
| 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 | ||
| 7625 | op-snap---monthly-publication-february-2026.pdf | 372 | 2026-02 | Car | Mercedes-Benz | CLA 220 | Red | Driving without Due Care and Attention | None | Coventry A45 W | Coventry A45 W | Coventry | Coventry | Education | N/A | 52.4314215 | -1.5948907 | ||
| 7634 | op-snap---monthly-publication-february-2026.pdf | 381 | 2026-02 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Education | N/A | 52.4096725 | -1.487901 | ||
| 7635 | op-snap---monthly-publication-february-2026.pdf | 382 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | High Street Tettenhall | High Street Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 7641 | op-snap---monthly-publication-february-2026.pdf | 388 | 2026-02 | Car | Peugeot | 408 | Silver | Driving without Due Care and Attention | None | Monmouth Drive | Monmouth Drive | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5575249 | -1.8640053 | ||
| 7644 | op-snap---monthly-publication-february-2026.pdf | 391 | 2026-02 | Car | Ford | Transit Connect | Black | Driving without Due Care and Attention | None | Ambergate Road / Highfield Rd, Bilston | Ambergate Road / Highfield Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | 52.5597351 | -2.081298 | ||
| 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 | ||
| 7674 | op-snap---monthly-publication-february-2026.pdf | 421 | 2026-02 | Car | Audi | A3 | White | Drive on hard shoulder | None | M5 NB 2-1 | M5 Northbound 2-1 | Sandwell | Sandwell | Education | N/A | ||||
| 7683 | op-snap---monthly-publication-february-2026.pdf | 430 | 2026-02 | Car | Peugeot | 208 | White | Contravening a Red Traffic Light | None | Bloxwich | Bloxwich | Walsall | Walsall | Education | N/A | 52.6161194 | -2.0030496 | ||
| 7685 | op-snap---monthly-publication-february-2026.pdf | 432 | 2026-02 | Car | Audi | Q2 | Blue | Driving without Due Care and Attention | None | Leamore Lane | Leamore Lane | Walsall | Walsall | Education | N/A | 52.6056653 | -2.0050776 | ||
| 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 | ||
| 7721 | op-snap---monthly-publication-february-2026.pdf | 468 | 2026-02 | Car | Volkswagen | Golf | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5615573 | -1.820549 | ||
| 7723 | op-snap---monthly-publication-february-2026.pdf | 470 | 2026-02 | Car | Kia | EV3 | Green | Driving without Due Care and Attention | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Education | N/A | 52.4014694 | -1.8220541 | ||
| 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 | ||
| 7726 | op-snap---monthly-publication-february-2026.pdf | 473 | 2026-02 | Car | Mazda | 3.. | White | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5959906 | -1.8345802 | ||
| 7731 | op-snap---monthly-publication-february-2026.pdf | 478 | 2026-02 | Car | Jaguar | F-Pace | Blue | Contravening a Red Traffic Light | None | Thompson Avenue | Thompson Avenue | Wolverhampton | Wolverhampton | Education | N/A | 52.5722181 | -2.1205684 | ||
| 7734 | op-snap---monthly-publication-february-2026.pdf | 481 | 2026-02 | Car | Vauxhall | Meriva | Black | Contravening a Red Traffic Light | None | High Street, Wordsley | High Street, Wordsley | Dudley | Dudley | Education | N/A | 52.4778645 | -2.1594686 | ||
| 7735 | op-snap---monthly-publication-february-2026.pdf | 482 | 2026-02 | Car | Ford | Mondeo | Grey | Contravening a Red Traffic Light | None | High Street, Wordsley | High Street, Wordsley | Dudley | Dudley | Education | N/A | 52.4778645 | -2.1594686 | ||
| 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 | ||
| 7759 | op-snap---monthly-publication-february-2026.pdf | 506 | 2026-02 | Car | Nissan | X Trail | White | Contravening a Red Traffic Light | None | All Saints Way | All Saints Way | Sandwell | Sandwell | Education | N/A | 52.5344405 | -1.985568 | ||
| 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 | ||||
| 7810 | op-snap---monthly-publication-february-2026.pdf | 557 | 2026-02 | Car | Volkswagen | golf | White | Driving without Reasonable Consideration | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 7816 | op-snap---monthly-publication-february-2026.pdf | 563 | 2026-02 | Car | Ford | Fiesta | Silver | Stop a vehicle on pedestrian crossing | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5615573 | -1.820549 | ||
| 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 | ||
| 7830 | op-snap---monthly-publication-february-2026.pdf | 577 | 2026-02 | Car | Seat | Leon | Grey | Contravening a Red Traffic Light | None | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | Education | N/A | 52.3793117 | -1.4625379 | ||
| 7835 | op-snap---monthly-publication-february-2026.pdf | 582 | 2026-02 | Car | Mercedes-Benz | EQB | Black | Driving without Due Care and Attention | None | Sewall Highway | Sewall Highway | Coventry | Coventry | Education | N/A | 52.4318623 | -1.4804069 | ||
| 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 | ||
| 7872 | op-snap---monthly-publication-february-2026.pdf | 619 | 2026-02 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Brettle Lane, Brierley Hill | Brettle Lane, Brierley Hill | Dudley | Dudley | Education | N/A | ||||
| 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 | ||
| 7882 | op-snap---monthly-publication-february-2026.pdf | 629 | 2026-02 | Car | BMW | 318D | Black | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Education | N/A | 52.3916468 | -1.4925995 | ||
| 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 | ||||
| 7900 | op-snap---monthly-publication-february-2026.pdf | 647 | 2026-02 | Car | Dacia | Jogger | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5615573 | -1.820549 | ||
| 7908 | op-snap---monthly-publication-february-2026.pdf | 655 | 2026-02 | Car | Nissan | Qashqai | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road Sutton | Victoria Road Sutton | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5624555 | -1.8218251 |
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);