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'}
88 rows where disposal = "Education", month = "2025-07" and offence = "Contravening a Red Traffic Light" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 25
- Audi 12
- Toyota 11
- BMW 10
- Mercedes-Benz 7
- Ford 6
- Volkswagen 6
- Nissan 5
- Seat 4
- Citroen 2
- Honda 2
- Mg 2
- Peugeot 2
- Renault 2
- Vauxhall 2
- Volvo 2
- Daf 1
- Hyundai 1
- Jaguar 1
- Kia 1
- Land Rover 1
- London Taxi 1
- Mazda 1
- Mitsubishi 1
- Skoda 1
- Suzuki 1
council_area 9
- Birmingham 42
- Coventry 12
- Solihull 9
- Walsall 9
- Sandwell 6
- Wolverhampton 4
- Dudley 3
- Sutton Coldfield 2
- Basirtmingham 1
reporter_transport_mode 4
- Car 75
- Pedestrian 7
- Pedal Bike 5
- car 1
offence 1
- Contravening a Red Traffic Light · 88 ✖
month 1
- 2025-07 · 88 ✖
disposal 1
- Education · 88 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11955 | op-snap---monthly-publication-july-2025.pdf | 7 | 2025-07 | Car | Seat | Ateca | Grey | Contravening a Red Traffic Light | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Education | N/A | 52.4220705 | -1.8372335 | ||
| 11970 | op-snap---monthly-publication-july-2025.pdf | 22 | 2025-07 | Car | Seat | Leon | Silver | Contravening a Red Traffic Light | None | Amesbury Road | Amesbury Road | Birmingham | Birmingham | Education | N/A | 52.4465507 | -1.8957752 | ||
| 11981 | op-snap---monthly-publication-july-2025.pdf | 33 | 2025-07 | Car | Audi | A3 | White | Contravening a Red Traffic Light | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Education | N/A | 52.4145149 | -1.8301272 | ||
| 12008 | op-snap---monthly-publication-july-2025.pdf | 60 | 2025-07 | Car | Nissan | Qashqai | Blue | Contravening a Red Traffic Light | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 12028 | op-snap---monthly-publication-july-2025.pdf | 80 | 2025-07 | Car | Audi | Q5 | Grey | Contravening a Red Traffic Light | None | Bills Lane, Shirley | Bills Lane, Shirley | Solihull | Solihull | Education | N/A | 52.4054849 | -1.8281697 | ||
| 12030 | op-snap---monthly-publication-july-2025.pdf | 82 | 2025-07 | Car | Mercedes-Benz | no trace | Silver | Contravening a Red Traffic Light | None | Bills Lane, Shirley | Bills Lane, Shirley | Solihull | Solihull | Education | N/A | 52.4054849 | -1.8281697 | ||
| 12031 | op-snap---monthly-publication-july-2025.pdf | 83 | 2025-07 | Pedestrian | Audi | A3.. | Grey | Contravening a Red Traffic Light | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 12084 | op-snap---monthly-publication-july-2025.pdf | 136 | 2025-07 | Car | Nissan | Juke | Grey | Contravening a Red Traffic Light | None | High Street | High Street | Sandwell | Sandwell | Education | N/A | 52.5128738 | -1.9842054 | ||
| 12095 | op-snap---monthly-publication-july-2025.pdf | 147 | 2025-07 | Car | BMW | x6 | White | Contravening a Red Traffic Light | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Education | N/A | 52.4709298 | -1.8722585 | ||
| 12105 | op-snap---monthly-publication-july-2025.pdf | 157 | 2025-07 | Car | Daf | Lorry | White | Contravening a Red Traffic Light | None | A38 Minworth | Minworth | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5301514 | -1.7586638 | ||
| 12106 | op-snap---monthly-publication-july-2025.pdf | 158 | 2025-07 | Car | Mazda | CX 5 | Blue | Contravening a Red Traffic Light | None | Dingle Lane | Dingle Lane | Solihull | Solihull | Education | N/A | 52.4044204 | -1.7965379 | ||
| 12151 | op-snap---monthly-publication-july-2025.pdf | 203 | 2025-07 | Car | Toyota | Aygo | Grey | Contravening a Red Traffic Light | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Education | N/A | 52.5899123 | -1.8057069 | ||
| 12158 | op-snap---monthly-publication-july-2025.pdf | 210 | 2025-07 | Car | Toyota | Aygo | White | Contravening a Red Traffic Light | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Education | N/A | 52.5899123 | -1.8057069 | ||
| 12166 | op-snap---monthly-publication-july-2025.pdf | 218 | 2025-07 | Car | Land Rover | Discovery | Black | Contravening a Red Traffic Light | None | Solihull Road | Solihull Road | Solihull | Solihull | Education | N/A | 52.4114159 | -1.8197732 | ||
| 12175 | op-snap---monthly-publication-july-2025.pdf | 227 | 2025-07 | Pedal Bike | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Education | N/A | 52.4145149 | -1.8301272 | ||
| 12187 | op-snap---monthly-publication-july-2025.pdf | 239 | 2025-07 | Car | BMW | M 440.. | Blue | Contravening a Red Traffic Light | None | Mile Lane | Mile Lane | Coventry | Coventry | Education | N/A | 52.3992732 | -1.5044832 | ||
| 12188 | op-snap---monthly-publication-july-2025.pdf | 240 | 2025-07 | Car | Toyota | Estima | White | Contravening a Red Traffic Light | None | Morris Road | Morris Road | Birmingham | Birmingham | Education | N/A | 52.4953902 | -1.8236361 | ||
| 12189 | op-snap---monthly-publication-july-2025.pdf | 241 | 2025-07 | Car | Honda | CRV | White | Contravening a Red Traffic Light | None | Bromford lane | Bromford lane | Birmingham | Birmingham | Education | N/A | 52.5083238 | -1.8332287 | ||
| 12200 | op-snap---monthly-publication-july-2025.pdf | 252 | 2025-07 | Car | Jaguar | XF | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12206 | op-snap---monthly-publication-july-2025.pdf | 258 | 2025-07 | Car | Audi | A6... | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12208 | op-snap---monthly-publication-july-2025.pdf | 260 | 2025-07 | Car | Mitsubishi | Outlander | White | Contravening a Red Traffic Light | None | Isloington Row | Isloington Row | Birmingham | Birmingham | Education | N/A | ||||
| 12217 | op-snap---monthly-publication-july-2025.pdf | 269 | 2025-07 | Car | BMW | 320 | Black | Contravening a Red Traffic Light | None | Stechford Lane | Stechford Lane | Birmingham | Birmingham | Education | N/A | 52.4930549 | -1.8179571 | ||
| 12220 | op-snap---monthly-publication-july-2025.pdf | 272 | 2025-07 | Car | Toyota | Camry | Grey | Contravening a Red Traffic Light | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Education | N/A | 52.4679402 | -1.881408 | ||
| 12232 | op-snap---monthly-publication-july-2025.pdf | 284 | 2025-07 | Car | Suzuki | Swace | White | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | Education | N/A | 52.5867763 | -2.0104342 | ||
| 12289 | op-snap---monthly-publication-july-2025.pdf | 341 | 2025-07 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Pershore Street | Pershore Street | Birmingham | Birmingham | Education | N/A | 52.4727929 | -1.8934901 | ||
| 12305 | op-snap---monthly-publication-july-2025.pdf | 357 | 2025-07 | Car | Toyota | Rav 4. | Blue | Contravening a Red Traffic Light | None | Dudley Road Rowley Regis | Dudley Road Rowley Regis | Sandwell | Sandwell | Education | N/A | 52.4952912 | -2.0641749 | ||
| 12306 | op-snap---monthly-publication-july-2025.pdf | 358 | 2025-07 | Car | Toyota | Pro Ace | White | Contravening a Red Traffic Light | None | Hall Street | Hall Street | Dudley | Dudley | Education | N/A | 52.5409774 | -2.1235921 | ||
| 12325 | op-snap---monthly-publication-july-2025.pdf | 377 | 2025-07 | Car | Peugeot | 107.. | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 12343 | op-snap---monthly-publication-july-2025.pdf | 395 | 2025-07 | Car | Audi | A4 | Black | Contravening a Red Traffic Light | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Education | N/A | 52.4591339 | -1.9601054 | ||
| 12344 | op-snap---monthly-publication-july-2025.pdf | 396 | 2025-07 | Car | Citroen | C1 | Red | Contravening a Red Traffic Light | None | Bell Lane | Bell Lane | Birmingham | Birmingham | Education | N/A | 52.4178465 | -1.968864 | ||
| 12346 | op-snap---monthly-publication-july-2025.pdf | 398 | 2025-07 | Car | Audi | A3 | Grey | Contravening a Red Traffic Light | None | Frankley Beeches Road | Frankley Beeches Road | Birmingham | Birmingham | Education | N/A | 52.4094108 | -1.9930633 | ||
| 12355 | op-snap---monthly-publication-july-2025.pdf | 407 | 2025-07 | Car | Dennis (Bus) | Grey | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Education | N/A | 52.4428606 | -1.812114 | |||
| 12358 | op-snap---monthly-publication-july-2025.pdf | 410 | 2025-07 | Car | Peugeot | 3008 | Black | Contravening a Red Traffic Light | None | Wolverhampton Road, Oldbury | Wolverhampton Road, Oldbury | Sandwell | Sandwell | Education | N/A | 52.5028787 | -2.0328384 | ||
| 12360 | op-snap---monthly-publication-july-2025.pdf | 412 | 2025-07 | Pedestrian | Volkswagen | Polo | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12361 | op-snap---monthly-publication-july-2025.pdf | 413 | 2025-07 | Car | Toyota | yaris | Silver | Contravening a Red Traffic Light | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Education | N/A | 52.4751651 | -1.8559775 | ||
| 12362 | op-snap---monthly-publication-july-2025.pdf | 414 | 2025-07 | Pedestrian | Volvo | Lorry | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12364 | op-snap---monthly-publication-july-2025.pdf | 416 | 2025-07 | Pedestrian | Honda | Civic | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12372 | op-snap---monthly-publication-july-2025.pdf | 424 | 2025-07 | Car | Volvo | V40 | Blue | Contravening a Red Traffic Light | None | High Street | High Street | Dudley | Dudley | Education | N/A | 52.4779764 | -2.1598371 | ||
| 12382 | op-snap---monthly-publication-july-2025.pdf | 434 | 2025-07 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12385 | op-snap---monthly-publication-july-2025.pdf | 437 | 2025-07 | Car | Toyota | Yaris | Black | Contravening a Red Traffic Light | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 12410 | op-snap---monthly-publication-july-2025.pdf | 462 | 2025-07 | Pedestrian | BMW | 318.. | Grey | Contravening a Red Traffic Light | None | Ringway St Nicholas | Ringway Street Nicholas | Coventry | Coventry | Education | N/A | ||||
| 12415 | op-snap---monthly-publication-july-2025.pdf | 467 | 2025-07 | Car | Nissan | Qashqai | Silver | Contravening a Red Traffic Light | None | Four Pounds Avenue | Four Pounds Avenue | Coventry | Coventry | Education | N/A | 52.413228 | -1.5323652 | ||
| 12421 | op-snap---monthly-publication-july-2025.pdf | 473 | 2025-07 | Car | Audi | RS3 | Black | Contravening a Red Traffic Light | None | Catherine de Barnes Lane | Catherine de Barnes Lane | Solihull | Solihull | Education | N/A | 52.4391457 | -1.7277084 | ||
| 12438 | op-snap---monthly-publication-july-2025.pdf | 490 | 2025-07 | Car | Mercedes-Benz | GLA 200 | Grey | Contravening a Red Traffic Light | None | Riland Road | Riland Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5634102 | -1.8161524 | ||
| 12439 | op-snap---monthly-publication-july-2025.pdf | 491 | 2025-07 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A454 Wolverhampton | Wolverhampton | Wolverhampton | Wolverhampton | Education | N/A | 52.5879884 | -2.120242 | ||
| 12446 | op-snap---monthly-publication-july-2025.pdf | 498 | 2025-07 | Car | Saab | Silver | Contravening a Red Traffic Light | None | Church Road | Church Road | Birmingham | Birmingham | Education | N/A | 52.4624743 | -1.7763934 | |||
| 12447 | op-snap---monthly-publication-july-2025.pdf | 499 | 2025-07 | Car | Audi | S3 | Black | Contravening a Red Traffic Light | None | Hayes Lane | Hayes Lane | Dudley | Dudley | Education | N/A | 52.4599414 | -2.1028651 | ||
| 12453 | op-snap---monthly-publication-july-2025.pdf | 505 | 2025-07 | Car | Ford | Fiesta | Orange | Contravening a Red Traffic Light | None | A4041 Queslett Road | Queslett Road | Birmingham | Birmingham | Education | N/A | 52.5458699 | -1.9304484 | ||
| 12479 | op-snap---monthly-publication-july-2025.pdf | 531 | 2025-07 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Bromford Road | Bromford Road | Birmingham | Birmingham | Education | N/A | 52.503036 | -1.8289972 | ||
| 12490 | op-snap---monthly-publication-july-2025.pdf | 542 | 2025-07 | Car | BMW | 118 | White | Contravening a Red Traffic Light | None | Sutton Road | Sutton Road | Walsall | Walsall | Education | N/A | 52.5612988 | -2.0522715 | ||
| 12515 | op-snap---monthly-publication-july-2025.pdf | 567 | 2025-07 | Car | Mercedes-Benz | C180 | Silver | Contravening a Red Traffic Light | None | Rosemary Hill Road | Rosemary Hill Road | Birmingham | Birmingham | Education | N/A | 52.5918569 | -1.8630817 | ||
| 12516 | op-snap---monthly-publication-july-2025.pdf | 568 | 2025-07 | Pedestrian | Hyundai | i10 | Blue | Contravening a Red Traffic Light | None | A452 at NEC | A452 at NEC | Solihull | Solihull | Education | N/A | 52.3686316 | -1.6251483 | ||
| 12534 | op-snap---monthly-publication-july-2025.pdf | 586 | 2025-07 | Car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | Sneyd Lane | Sneyd Lane | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 12549 | op-snap---monthly-publication-july-2025.pdf | 601 | 2025-07 | Car | Mercedes-Benz | C220 | Grey | Contravening a Red Traffic Light | None | Norton Road | Norton Road | Walsall | Walsall | Education | N/A | 52.6260635 | -1.9672945 | ||
| 12550 | op-snap---monthly-publication-july-2025.pdf | 602 | 2025-07 | Car | Mercedes-Benz | 180 | Blue | Contravening a Red Traffic Light | None | Norton Road | Norton Road | Walsall | Walsall | Education | N/A | 52.6260635 | -1.9672945 | ||
| 12564 | op-snap---monthly-publication-july-2025.pdf | 616 | 2025-07 | Car | BMW | 1 series | White | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 12572 | op-snap---monthly-publication-july-2025.pdf | 624 | 2025-07 | Car | Mercedes-Benz | B class | Silver | Contravening a Red Traffic Light | None | Black Country Route, A463 | Black Country Route, A463 | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 12578 | op-snap---monthly-publication-july-2025.pdf | 630 | 2025-07 | Car | BMW | 3 series | Silver | Contravening a Red Traffic Light | None | Aldridge Road | Aldridge Road | Birmingham | Birmingham | Education | N/A | 52.5368764 | -1.8976461 | ||
| 12621 | op-snap---monthly-publication-july-2025.pdf | 673 | 2025-07 | Pedestrian | London Taxi | Taxi | Black | Contravening a Red Traffic Light | None | A444 at Austin Drive | A444 at Austin Drive | Coventry | Coventry | Education | N/A | 52.4471432 | -1.4975901 | ||
| 12623 | op-snap---monthly-publication-july-2025.pdf | 675 | 2025-07 | Pedal Bike | Mg | 5 exectuive | Silver | Contravening a Red Traffic Light | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 12691 | op-snap---monthly-publication-july-2025.pdf | 743 | 2025-07 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Blue Lane West | Blue Lane West | Walsall | Walsall | Education | N/A | 52.5880833 | -1.9891415 | ||
| 12728 | op-snap---monthly-publication-july-2025.pdf | 780 | 2025-07 | Car | Toyota | Yaris | Blue | Contravening a Red Traffic Light | None | Richmond Road at Bordesley Green E | Richmond Road at Bordesley Green E | Basirtmingham | Basirtmingham | Education | N/A | 52.4782908 | -1.814803 | ||
| 12740 | op-snap---monthly-publication-july-2025.pdf | 792 | 2025-07 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Salford Circus M6 J6 | Salford Circus M6 J6 | Birmingham | Birmingham | Education | N/A | ||||
| 12774 | op-snap---monthly-publication-july-2025.pdf | 826 | 2025-07 | Car | Mg | ZS | Orange | Contravening a Red Traffic Light | None | Harrier Way | Harrier Way | Birmingham | Birmingham | Education | N/A | ||||
| 12781 | op-snap---monthly-publication-july-2025.pdf | 833 | 2025-07 | Car | Audi | Q3 | Grey | Contravening a Red Traffic Light | None | B4027 | B4027 | Coventry | Coventry | Education | N/A | 52.3994858 | -1.4923603 | ||
| 12784 | op-snap---monthly-publication-july-2025.pdf | 836 | 2025-07 | Car | Renault | Clio | Red | Contravening a Red Traffic Light | None | Wobaston Road | Wobaston Road | Wolverhampton | Wolverhampton | Education | N/A | 52.628768 | -2.1306154 | ||
| 12813 | op-snap---monthly-publication-july-2025.pdf | 865 | 2025-07 | Car | BMW | 320 | Black | Contravening a Red Traffic Light | None | Bordesley Circus | Bordesley Circus | Birmingham | Birmingham | Education | N/A | 52.4728608 | -1.8754722 | ||
| 12847 | op-snap---monthly-publication-july-2025.pdf | 899 | 2025-07 | car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | All Saits Way | All Saits Way | Sandwell | Sandwell | Education | N/A | ||||
| 12854 | op-snap---monthly-publication-july-2025.pdf | 906 | 2025-07 | Car | Seat | Ibiza | Grey | Contravening a Red Traffic Light | None | Cooks Lane | Cooks Lane | Birmingham | Birmingham | Education | N/A | 52.482758 | -1.7603097 | ||
| 12883 | op-snap---monthly-publication-july-2025.pdf | 935 | 2025-07 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Stockfield Road | Stockfield Road | Birmingham | Birmingham | Education | N/A | 52.4519414 | -1.831688 | ||
| 12901 | op-snap---monthly-publication-july-2025.pdf | 953 | 2025-07 | Car | Audi | A3 | White | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 12941 | op-snap---monthly-publication-july-2025.pdf | 993 | 2025-07 | Car | BMW | M3 | Black | Contravening a Red Traffic Light | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 12984 | op-snap---monthly-publication-july-2025.pdf | 1036 | 2025-07 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Ladywood Midleway | Ladywood Midleway | Birmingham | Birmingham | Education | N/A | ||||
| 13023 | op-snap---monthly-publication-july-2025.pdf | 1075 | 2025-07 | Car | BMW | X5 | Grey | Contravening a Red Traffic Light | None | Lodge Lane | Lodge Lane | Birmingham | Birmingham | Education | N/A | 52.5380023 | -1.8594966 | ||
| 13041 | op-snap---monthly-publication-july-2025.pdf | 1093 | 2025-07 | Pedal Bike | Byd, Enviro | Contravening a Red Traffic Light | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Education | N/A | 52.4324855 | -1.4815548 | ||||
| 13043 | op-snap---monthly-publication-july-2025.pdf | 1095 | 2025-07 | Pedal Bike | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 13044 | op-snap---monthly-publication-july-2025.pdf | 1096 | 2025-07 | Pedal Bike | Nissan | Note | Red | Contravening a Red Traffic Light | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 13046 | op-snap---monthly-publication-july-2025.pdf | 1098 | 2025-07 | Car | Audi | A6.. | Grey | Contravening a Red Traffic Light | None | Shareholders Road | Shareholders Road | Birmingham | Birmingham | Education | N/A | ||||
| 13049 | op-snap---monthly-publication-july-2025.pdf | 1101 | 2025-07 | Car | Skoda | Superb | Grey | Contravening a Red Traffic Light | None | Aston Lane | Aston Lane | Birmingham | Birmingham | Education | N/A | 52.5151247 | -1.9007033 | ||
| 13050 | op-snap---monthly-publication-july-2025.pdf | 1102 | 2025-07 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Walsall Road, Tynings Lane | Walsall Road, Tynings Lane | Walsall | Walsall | Education | N/A | ||||
| 13104 | op-snap---monthly-publication-july-2025.pdf | 1156 | 2025-07 | Car | Renault | Clio | Grey | Contravening a Red Traffic Light | None | Owen Street Tipton | Owen Street Tipton | Sandwell | Sandwell | Education | N/A | 52.529375 | -2.0627257 | ||
| 13108 | op-snap---monthly-publication-july-2025.pdf | 1160 | 2025-07 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Banner Lane | Banner Lane | Coventry | Coventry | Education | N/A | 52.4010821 | -1.5953502 | ||
| 13112 | op-snap---monthly-publication-july-2025.pdf | 1164 | 2025-07 | Car | Audi | Q7 | Black | Contravening a Red Traffic Light | None | College Road | College Road | Birmingham | Birmingham | Education | N/A | 52.5151832 | -1.9361664 | ||
| 13183 | op-snap---monthly-publication-july-2025.pdf | 1235 | 2025-07 | Car | Ford | fiesta | Silver | Contravening a Red Traffic Light | None | B4540 | B4540 | Birmingham | Birmingham | Education | N/A | 52.5420127 | -1.7952145 | ||
| 13184 | op-snap---monthly-publication-july-2025.pdf | 1236 | 2025-07 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | A453 | A453 | Birmingham | Birmingham | Education | N/A | ||||
| 13190 | op-snap---monthly-publication-july-2025.pdf | 1242 | 2025-07 | Car | Kia | Rio.. | Red | Contravening a Red Traffic Light | None | B4109 Aldermans Green Road | Aldermans Green Road | Coventry | Coventry | Education | N/A | 52.4520641 | -1.4663835 | ||
| 13209 | op-snap---monthly-publication-july-2025.pdf | 1261 | 2025-07 | Car | Vauxhall | Zafira | Silver | Contravening a Red Traffic Light | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Education | N/A | 52.5458699 | -1.9304484 | ||
| 13220 | op-snap---monthly-publication-july-2025.pdf | 1272 | 2025-07 | Car | Citroen | C4 | White | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Sandwell | Sandwell | Education | N/A | 52.5461417 | -1.9334193 |
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);