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'}
334 rows where disposal = "Warning Letter", month = "2025-08" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make >30
offence 15
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 233
- Cause vehicle to be left in a dangerous position 57
- Driving without Due Care and Attention 22
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 7
- Dangerous Driving 3
- Contravening a Red Traffic Light 2
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 2
- Misc - Non Traffic Offences 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- No Insurance 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 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
- VRM fails to conform to Regulations 1
council_area 10
- Birmingham 262
- Wolverhampton 27
- Coventry 14
- Sandwell 13
- Dudley 7
- Sutton Coldfield 6
- Solihull 2
- Halesowen 1
- Out of Force Area 1
- Walsall 1
reporter_transport_mode 1
- Pedestrian · 334 ✖
month 1
- 2025-08 · 334 ✖
disposal 1
- Warning Letter · 334 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2241 | op-snap---monthly-publication-august-2025.pdf | 216 | 2025-08 | Pedestrian | Audi | A5 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Turners Lane | Turners Lane | Dudley | Dudley | Warning Letter | N/A | 52.4721372 | -2.1243522 | ||
| 2370 | op-snap---monthly-publication-august-2025.pdf | 345 | 2025-08 | Pedestrian | Mazda | CX-30 | Red | Driving without Due Care and Attention | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 2507 | op-snap---monthly-publication-august-2025.pdf | 482 | 2025-08 | Pedestrian | Audi | A3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bank Street | Bank Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4359081 | -1.8936852 | ||
| 2713 | op-snap---monthly-publication-august-2025.pdf | 688 | 2025-08 | Pedestrian | Ford | Focus | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Tunners Lane | Tunners Lane | Dudley | Dudley | Warning Letter | N/A | ||||
| 2871 | op-snap---monthly-publication-august-2025.pdf | 846 | 2025-08 | Pedestrian | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 3000 | op-snap---monthly-publication-august-2025.pdf | 975 | 2025-08 | Pedestrian | Mercedes-Benz | E200 | White | Driving without Due Care and Attention | None | M5 North | M5 North | Sandwell | Sandwell | Warning Letter | N/A | 52.5274455 | -2.0298903 | ||
| 3023 | op-snap---monthly-publication-august-2025.pdf | 998 | 2025-08 | Pedestrian | BMW | X3 | White | Driving without Due Care and Attention | None | Clapgate Lane | Clapgate Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4417035 | -1.9902817 | ||
| 3070 | op-snap---monthly-publication-august-2025.pdf | 1045 | 2025-08 | Pedestrian | Ford | Transit | White | Contravening a Red Traffic Light | None | California Way at Stonehouse Hill. | California Way at Stonehouse Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4453318 | -1.9760483 | ||
| 3087 | op-snap---monthly-publication-august-2025.pdf | 1062 | 2025-08 | Pedestrian | Audi | E-tron | Silver | Driving without Due Care and Attention | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6043868 | -2.1046385 | ||
| 3162 | op-snap---monthly-publication-august-2025.pdf | 1137 | 2025-08 | Pedestrian | Hyundai | I10 | Blue | Driving without Due Care and Attention | None | Chapel Lane | Chapel Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4409424 | -1.9387702 | ||
| 3213 | op-snap---monthly-publication-august-2025.pdf | 1188 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | West Avenue | West Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.5236655 | -1.9263108 | ||
| 3223 | op-snap---monthly-publication-august-2025.pdf | 1198 | 2025-08 | Pedestrian | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3224 | op-snap---monthly-publication-august-2025.pdf | 1199 | 2025-08 | Pedestrian | Vauxhall | Corsa | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3226 | op-snap---monthly-publication-august-2025.pdf | 1201 | 2025-08 | Pedestrian | Vauxhall | astra | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3227 | op-snap---monthly-publication-august-2025.pdf | 1202 | 2025-08 | Pedestrian | Ford | tourneo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heath Green | Heath Green | Birmingham | Birmingham | Warning Letter | N/A | 52.4873353 | -1.9407986 | ||
| 3228 | op-snap---monthly-publication-august-2025.pdf | 1203 | 2025-08 | Pedestrian | Ford | mondeo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Dudley | Dudley | Warning Letter | N/A | 52.4881161 | -2.1199108 | ||
| 3229 | op-snap---monthly-publication-august-2025.pdf | 1204 | 2025-08 | Pedestrian | Toyota | prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | earlsdon street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 3230 | op-snap---monthly-publication-august-2025.pdf | 1205 | 2025-08 | Pedestrian | Kia | picanto | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley road | Dudley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3231 | op-snap---monthly-publication-august-2025.pdf | 1206 | 2025-08 | Pedestrian | Peugeot | Expert | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley road | Dudley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3232 | op-snap---monthly-publication-august-2025.pdf | 1207 | 2025-08 | Pedestrian | Ford | puma | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Upper Well Street | Upper Well Street | Coventry | Coventry | Warning Letter | N/A | 52.4102625 | -1.5137293 | ||
| 3233 | op-snap---monthly-publication-august-2025.pdf | 1208 | 2025-08 | Pedestrian | Volkswagen | golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Telfer Road | Telfer Road | Coventry | Coventry | Warning Letter | N/A | 52.4311807 | -1.5191239 | ||
| 3237 | op-snap---monthly-publication-august-2025.pdf | 1212 | 2025-08 | Pedestrian | Toyota | C-HR | White | Cause vehicle to be left in a dangerous position | None | Shutlock Lane | Shutlock Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4381927 | -1.9042054 | ||
| 3238 | op-snap---monthly-publication-august-2025.pdf | 1213 | 2025-08 | Pedestrian | Ford | focus | White | Cause vehicle to be left in a dangerous position | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3239 | op-snap---monthly-publication-august-2025.pdf | 1214 | 2025-08 | Pedestrian | Audi | A3 | Blue | Cause vehicle to be left in a dangerous position | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3240 | op-snap---monthly-publication-august-2025.pdf | 1215 | 2025-08 | Pedestrian | Volkswagen | Polo | Grey | Cause vehicle to be left in a dangerous position | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3241 | op-snap---monthly-publication-august-2025.pdf | 1216 | 2025-08 | Pedestrian | Seat | Leon | Blue | Cause vehicle to be left in a dangerous position | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3242 | op-snap---monthly-publication-august-2025.pdf | 1217 | 2025-08 | Pedestrian | BMW | 220D | White | Cause vehicle to be left in a dangerous position | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3243 | op-snap---monthly-publication-august-2025.pdf | 1218 | 2025-08 | Pedestrian | Seat | Leon | Blue | Cause vehicle to be left in a dangerous position | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3246 | op-snap---monthly-publication-august-2025.pdf | 1221 | 2025-08 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avon Street | Avon Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4556565 | -1.8643304 | ||
| 3247 | op-snap---monthly-publication-august-2025.pdf | 1222 | 2025-08 | Pedestrian | Peugeot | 3008 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3249 | op-snap---monthly-publication-august-2025.pdf | 1224 | 2025-08 | Pedestrian | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fairbourne Towerr | Fairbourne Towerr | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3250 | op-snap---monthly-publication-august-2025.pdf | 1225 | 2025-08 | Pedestrian | Mercedes-Benz | GLC200 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill road | Cannon Hill road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 | ||
| 3251 | op-snap---monthly-publication-august-2025.pdf | 1226 | 2025-08 | Pedestrian | Hyundai | Santa FE | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Canno Hill Road | Canno Hill Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3252 | op-snap---monthly-publication-august-2025.pdf | 1227 | 2025-08 | Pedestrian | Suzuki | swift | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 | ||
| 3253 | op-snap---monthly-publication-august-2025.pdf | 1228 | 2025-08 | Pedestrian | Mg | 4 | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 | ||
| 3254 | op-snap---monthly-publication-august-2025.pdf | 1229 | 2025-08 | Pedestrian | Cupra | Formentor | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3258 | op-snap---monthly-publication-august-2025.pdf | 1233 | 2025-08 | Pedestrian | Volkswagen | Polo | White | Cause vehicle to be left in a dangerous position | None | Saints road, kings heath | Saints road, kings heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4272595 | -1.8949973 | ||
| 3262 | op-snap---monthly-publication-august-2025.pdf | 1237 | 2025-08 | Pedestrian | Seat | Arona | Blue | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3263 | op-snap---monthly-publication-august-2025.pdf | 1238 | 2025-08 | Pedestrian | Man | Panel | White | Cause vehicle to be left in a dangerous position | None | Cannock road | Cannock road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3264 | op-snap---monthly-publication-august-2025.pdf | 1239 | 2025-08 | Pedestrian | Volkswagen | Golf | White | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3269 | op-snap---monthly-publication-august-2025.pdf | 1244 | 2025-08 | Pedestrian | Ford | Kuga | White | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3270 | op-snap---monthly-publication-august-2025.pdf | 1245 | 2025-08 | Pedestrian | Ford | S-Max | Blue | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3274 | op-snap---monthly-publication-august-2025.pdf | 1249 | 2025-08 | Pedestrian | Peugeot | 3008 | Black | Cause vehicle to be left in a dangerous position | None | Gurney Road | Gurney Road | Walsall | Walsall | Warning Letter | N/A | 52.6010218 | -2.0119092 | ||
| 3279 | op-snap---monthly-publication-august-2025.pdf | 1254 | 2025-08 | Pedestrian | Suzuki | vitara | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tetenhall road | Tetenhall road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3282 | op-snap---monthly-publication-august-2025.pdf | 1257 | 2025-08 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley road | Barnsley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3286 | op-snap---monthly-publication-august-2025.pdf | 1261 | 2025-08 | Pedestrian | Iveco | Daily | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bonner Grove | Bonner Grove | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3287 | op-snap---monthly-publication-august-2025.pdf | 1262 | 2025-08 | Pedestrian | Volkswagen | T-ROC | Grey | Cause vehicle to be left in a dangerous position | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | ||
| 3288 | op-snap---monthly-publication-august-2025.pdf | 1263 | 2025-08 | Pedestrian | Audi | A6 | Black | Driving without Due Care and Attention | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | ||
| 3289 | op-snap---monthly-publication-august-2025.pdf | 1264 | 2025-08 | Pedestrian | Porsche | Macan | Grey | Driving without Due Care and Attention | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | ||
| 3290 | op-snap---monthly-publication-august-2025.pdf | 1265 | 2025-08 | Pedestrian | Maserati | Grey | Driving without Due Care and Attention | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | |||
| 3291 | op-snap---monthly-publication-august-2025.pdf | 1266 | 2025-08 | Pedestrian | Audi | RSQ3 | Grey | Cause vehicle to be left in a dangerous position | None | Kingstanding Rd | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3292 | op-snap---monthly-publication-august-2025.pdf | 1267 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | Red | Cause vehicle to be left in a dangerous position | None | Kingstanding Rd | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3293 | op-snap---monthly-publication-august-2025.pdf | 1268 | 2025-08 | Pedestrian | Toyota | Prius | Blue | Cause vehicle to be left in a dangerous position | None | New Road | New Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3947919 | -2.0141009 | ||
| 3294 | op-snap---monthly-publication-august-2025.pdf | 1269 | 2025-08 | Pedestrian | Skoda | Fabia | Blue | Cause vehicle to be left in a dangerous position | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4552785 | -1.906384 | ||
| 3295 | op-snap---monthly-publication-august-2025.pdf | 1270 | 2025-08 | Pedestrian | Nissan | Micra | Grey | Cause vehicle to be left in a dangerous position | None | Tetenhall High Street | Tettenhall High Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.598292 | -2.1677123 | ||
| 3297 | op-snap---monthly-publication-august-2025.pdf | 1272 | 2025-08 | Pedestrian | Mercedes-Benz | EQC | Grey | Cause vehicle to be left in a dangerous position | None | Knowle High Street | Knowle High Street | Solihull | Solihull | Warning Letter | N/A | 52.3872283 | -1.733682 | ||
| 3298 | op-snap---monthly-publication-august-2025.pdf | 1273 | 2025-08 | Pedestrian | BMW | 118D | White | Cause vehicle to be left in a dangerous position | None | Cannon HIll | Cannon HIll | Birmingham | Birmingham | Warning Letter | N/A | 52.4516065 | -1.9026461 | ||
| 3299 | op-snap---monthly-publication-august-2025.pdf | 1274 | 2025-08 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ormes LAne | Ormes LAne | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5897993 | -2.1774009 | ||
| 3310 | op-snap---monthly-publication-august-2025.pdf | 1285 | 2025-08 | Pedestrian | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3311 | op-snap---monthly-publication-august-2025.pdf | 1286 | 2025-08 | Pedestrian | Toyota | MPV | Grey | Cause vehicle to be left in a dangerous position | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4878246 | -1.9421047 | ||
| 3312 | op-snap---monthly-publication-august-2025.pdf | 1287 | 2025-08 | Pedestrian | Kia | Niro | Grey | Cause vehicle to be left in a dangerous position | None | Wood Green Road | Wood Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4885732 | -1.9428314 | ||
| 3313 | op-snap---monthly-publication-august-2025.pdf | 1288 | 2025-08 | Pedestrian | Skoda | Fabia | Blue | Cause vehicle to be left in a dangerous position | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4878246 | -1.9421047 | ||
| 3321 | op-snap---monthly-publication-august-2025.pdf | 1296 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 3323 | op-snap---monthly-publication-august-2025.pdf | 1298 | 2025-08 | Pedestrian | Fiat | 500 | Green | Cause vehicle to be left in a dangerous position | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4700545 | -1.834436 | ||
| 3324 | op-snap---monthly-publication-august-2025.pdf | 1299 | 2025-08 | Pedestrian | BMW | X3 | Grey | Cause vehicle to be left in a dangerous position | None | Peacock Road | Peacock Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4244231 | -1.8883297 | ||
| 3325 | op-snap---monthly-publication-august-2025.pdf | 1300 | 2025-08 | Pedestrian | Lexus | GS | Blue | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3326 | op-snap---monthly-publication-august-2025.pdf | 1301 | 2025-08 | Pedestrian | Ford | Fiesta | Blue | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3327 | op-snap---monthly-publication-august-2025.pdf | 1302 | 2025-08 | Pedestrian | BMW | 220D | Grey | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3328 | op-snap---monthly-publication-august-2025.pdf | 1303 | 2025-08 | Pedestrian | Vauxhall | Astra | Red | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3329 | op-snap---monthly-publication-august-2025.pdf | 1304 | 2025-08 | Pedestrian | Lexus | UX | Red | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3330 | op-snap---monthly-publication-august-2025.pdf | 1305 | 2025-08 | Pedestrian | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 3331 | op-snap---monthly-publication-august-2025.pdf | 1306 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 3338 | op-snap---monthly-publication-august-2025.pdf | 1313 | 2025-08 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Craythorne Avenue | Craythorne Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.5264721 | -1.9412009 | ||
| 3339 | op-snap---monthly-publication-august-2025.pdf | 1314 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Craythorne Avenue | Craythorne Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.5264721 | -1.9412009 | ||
| 3342 | op-snap---monthly-publication-august-2025.pdf | 1317 | 2025-08 | Pedestrian | Land Rover | Velar | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Overdale Road | Overdale Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4540128 | -1.9850912 | ||
| 3345 | op-snap---monthly-publication-august-2025.pdf | 1320 | 2025-08 | Pedestrian | Mazda | s TS | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | John Street | John Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5010537 | -1.9155739 | ||
| 3347 | op-snap---monthly-publication-august-2025.pdf | 1322 | 2025-08 | Pedestrian | Mg | ZS | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avenue Road | Avenue Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4941712 | -1.8795158 | ||
| 3351 | op-snap---monthly-publication-august-2025.pdf | 1326 | 2025-08 | Pedestrian | BMW | 320d | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5065077 | -1.892207 | ||
| 3352 | op-snap---monthly-publication-august-2025.pdf | 1327 | 2025-08 | Pedestrian | Toyota | Yaris | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Inverness Road | Inverness Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4129524 | -1.9785922 | ||
| 3353 | op-snap---monthly-publication-august-2025.pdf | 1328 | 2025-08 | Pedestrian | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3354 | op-snap---monthly-publication-august-2025.pdf | 1329 | 2025-08 | Pedestrian | Ford | Kuga | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Rd | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3355 | op-snap---monthly-publication-august-2025.pdf | 1330 | 2025-08 | Pedestrian | Skoda | Enyaq | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kings Rd | Kings Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5531351 | -1.8852761 | ||
| 3356 | op-snap---monthly-publication-august-2025.pdf | 1331 | 2025-08 | Pedestrian | Toyota | Corolla | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5333535 | -1.9189815 | ||
| 3357 | op-snap---monthly-publication-august-2025.pdf | 1332 | 2025-08 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tower Hill | Tower Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.5335541 | -1.9186098 | ||
| 3358 | op-snap---monthly-publication-august-2025.pdf | 1333 | 2025-08 | Pedestrian | Land Rover | Sport SE | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5333535 | -1.9189815 | ||
| 3360 | op-snap---monthly-publication-august-2025.pdf | 1335 | 2025-08 | Pedestrian | Toyota | HiLUX | Grey | Cause vehicle to be left in a dangerous position | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 3361 | op-snap---monthly-publication-august-2025.pdf | 1336 | 2025-08 | Pedestrian | BMW | 335I | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley raod | Barnsley raod | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3362 | op-snap---monthly-publication-august-2025.pdf | 1337 | 2025-08 | Pedestrian | Isuzu | DMAZ | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5980906 | -2.168057 | ||
| 3364 | op-snap---monthly-publication-august-2025.pdf | 1339 | 2025-08 | Pedestrian | Tesla | model X | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stapenhall road | Stapenhall road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3365 | op-snap---monthly-publication-august-2025.pdf | 1340 | 2025-08 | Pedestrian | Citroen | relay | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Knightlow Road | Knightlow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4684561 | -1.9608907 | ||
| 3376 | op-snap---monthly-publication-august-2025.pdf | 1351 | 2025-08 | Pedestrian | Toyota | Aygo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Little Green Lane | Little Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4751722 | -1.860976 | ||
| 3378 | op-snap---monthly-publication-august-2025.pdf | 1353 | 2025-08 | Pedestrian | Hyundai | I30 | Blue | Cause vehicle to be left in a dangerous position | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 3379 | op-snap---monthly-publication-august-2025.pdf | 1354 | 2025-08 | Pedestrian | Audi | RS6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Port Hope ROad | Port Hope ROad | Birmingham | Birmingham | Warning Letter | N/A | 52.4661986 | -1.8764709 | ||
| 3380 | op-snap---monthly-publication-august-2025.pdf | 1355 | 2025-08 | Pedestrian | Kia | Stonic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Manor Farm Road | Manor Farm Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4539235 | -1.8493825 | ||
| 3387 | op-snap---monthly-publication-august-2025.pdf | 1362 | 2025-08 | Pedestrian | Audi | A1 | Grey | Cause vehicle to be left in a dangerous position | None | Hagley Road | Hagley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4724482 | -1.9678186 | ||
| 3389 | op-snap---monthly-publication-august-2025.pdf | 1364 | 2025-08 | Pedestrian | Ford | S-Max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4700545 | -1.834436 | ||
| 3391 | op-snap---monthly-publication-august-2025.pdf | 1366 | 2025-08 | Pedestrian | Audi | SQ5 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Carver Street | Carver Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4857687 | -1.915613 | ||
| 3392 | op-snap---monthly-publication-august-2025.pdf | 1367 | 2025-08 | Pedestrian | Nissan | qashqai | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friary Road | Friary Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5162814 | -1.9395798 | ||
| 3393 | op-snap---monthly-publication-august-2025.pdf | 1368 | 2025-08 | Pedestrian | Ford | focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradshaw Road | Bradshaw Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3394 | op-snap---monthly-publication-august-2025.pdf | 1369 | 2025-08 | Pedestrian | Vauxhall | Combo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shutlock Street | Shutlock Street | Birmingham | Birmingham | Warning Letter | N/A |
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);