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'}
504 rows where council_area = "Birmingham", disposal = "Warning Letter" and month = "2025-08" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence
vehicle_make >30
offence 23
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 298
- Driving without Due Care and Attention 71
- Cause vehicle to be left in a dangerous position 62
- Contravening a Red Traffic Light 17
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 14
- VRM fails to conform to Regulations 6
- Dangerous Driving 5
- Driving without Reasonable Consideration 5
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 4
- Misc - Non Traffic Offences 3
- Contravene Lane Closure Red X 2
- Drive on hard shoulder 2
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 2
- Driving a vehicle wholly or partly on a footpath 1
- Fail to display front VRM plate 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with solid white line road markings 1
- No Insurance 1
- No Seat Belt 1
- Stop a vehicle within pelican pedestrian crossing limits 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Using a Mobile Phone Whilst Driving 1
reporter_transport_mode 5
- Pedestrian 262
- Car 219
- Pedal Bike 20
- Motorbike 2
- Other 1
month 1
- 2025-08 · 504 ✖
disposal 1
- Warning Letter · 504 ✖
council_area 1
- Birmingham · 504 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2038 | op-snap---monthly-publication-august-2025.pdf | 13 | 2025-08 | Car | Nissan | Note | Black | Contravening a Red Traffic Light | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 2047 | op-snap---monthly-publication-august-2025.pdf | 22 | 2025-08 | Car | Ferrari | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham | Birmingham | Warning Letter | N/A | |||||||
| 2055 | op-snap---monthly-publication-august-2025.pdf | 30 | 2025-08 | Car | Ford | Fiesta | Grey | Driving without Reasonable Consideration | None | Friston Av | Friston Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.4744592 | -1.9198786 | ||
| 2056 | op-snap---monthly-publication-august-2025.pdf | 31 | 2025-08 | Car | BMW | X3 | Black | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2074 | op-snap---monthly-publication-august-2025.pdf | 49 | 2025-08 | Car | Fiat | Scudo | Grey | Driving without Due Care and Attention | None | Bunbury Road | Bunbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4142089 | -1.9587147 | ||
| 2099 | op-snap---monthly-publication-august-2025.pdf | 74 | 2025-08 | Car | Hyundai | I30 | Red | Driving without Due Care and Attention | None | Shenstone Road | Shenstone Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4011594 | -1.879934 | ||
| 2135 | op-snap---monthly-publication-august-2025.pdf | 110 | 2025-08 | Pedal Bike | Mercedes-Benz | C220 | Blue | Contravening a Red Traffic Light | None | High Street | High Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5254588 | -1.8373064 | ||
| 2137 | op-snap---monthly-publication-august-2025.pdf | 112 | 2025-08 | Car | Ford | Kuga | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lottie Road | Lottie Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4393277 | -1.9383576 | ||
| 2190 | op-snap---monthly-publication-august-2025.pdf | 165 | 2025-08 | Car | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4555288 | -1.8613929 | ||
| 2201 | op-snap---monthly-publication-august-2025.pdf | 176 | 2025-08 | Pedal Bike | Volkswagen | T-Roc | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 2211 | op-snap---monthly-publication-august-2025.pdf | 186 | 2025-08 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Aston Road | Aston Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929386 | -1.888744 | ||
| 2219 | op-snap---monthly-publication-august-2025.pdf | 194 | 2025-08 | Car | Volkswagen | Touran | Blue | Driving without Due Care and Attention | None | Bordsley Middleway | Bordsley Middleway | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2240 | op-snap---monthly-publication-august-2025.pdf | 215 | 2025-08 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Warning Letter | N/A | 52.4220705 | -1.8372335 | ||
| 2266 | op-snap---monthly-publication-august-2025.pdf | 241 | 2025-08 | Pedal Bike | Renault | Traffic | Grey | Driving without Due Care and Attention | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5398019 | -1.8455792 | ||
| 2305 | op-snap---monthly-publication-august-2025.pdf | 280 | 2025-08 | Car | Mini | Countryman | Grey | Contravening a Red Traffic Light | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4397168 | -1.9260414 | ||
| 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 | ||
| 2384 | op-snap---monthly-publication-august-2025.pdf | 359 | 2025-08 | Pedal Bike | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Corportaion Street | Corportaion Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2387 | op-snap---monthly-publication-august-2025.pdf | 362 | 2025-08 | Car | BMW | 330.. | Blue | Motor vehicle fail to accord precedence at a pelican crossing | None | A4040 Church Road | Church Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4624743 | -1.7763934 | ||
| 2389 | op-snap---monthly-publication-august-2025.pdf | 364 | 2025-08 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Wyrley Road | Wyrley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5172973 | -1.8785949 | ||
| 2390 | op-snap---monthly-publication-august-2025.pdf | 365 | 2025-08 | Car | Mercedes-Benz | GLE | Blue | Contravening a Red Traffic Light | None | Bell Hill at A38, Northfield | Bell Hill at A38, Northfield | Birmingham | Birmingham | Warning Letter | N/A | 52.4179505 | -1.9696413 | ||
| 2392 | op-snap---monthly-publication-august-2025.pdf | 367 | 2025-08 | Car | Skoda | Octavia | Grey | Driving without Due Care and Attention | None | A38 Queensway | Queensway | Birmingham | Birmingham | Warning Letter | N/A | 52.4856447 | -1.8972389 | ||
| 2404 | op-snap---monthly-publication-august-2025.pdf | 379 | 2025-08 | Car | Mercedes-Benz | C-class | Red | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 2428 | op-snap---monthly-publication-august-2025.pdf | 403 | 2025-08 | Motorbike | BMW | 5 series | White | Driving without Due Care and Attention | None | Alcester Road / Salisbury Road | Alcester Road / Salisbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4467548 | -1.8880528 | ||
| 2432 | op-snap---monthly-publication-august-2025.pdf | 407 | 2025-08 | Car | Nissan | X-Trail | Silver | Driving without Reasonable Consideration | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 2437 | op-snap---monthly-publication-august-2025.pdf | 412 | 2025-08 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4221526 | -1.8425617 | ||
| 2439 | op-snap---monthly-publication-august-2025.pdf | 414 | 2025-08 | Car | Volkswagen | Crafter | White | Dangerous Driving | None | M6 - M5 Slip | M6 - M5 Slip | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2445 | op-snap---monthly-publication-august-2025.pdf | 420 | 2025-08 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Constitution Hill | Constitution Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4866022 | -1.901562 | ||
| 2456 | op-snap---monthly-publication-august-2025.pdf | 431 | 2025-08 | Car | Toyota | Aygo | Red | Driving without Due Care and Attention | None | Bromfield Lane | Bromfield Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2457 | op-snap---monthly-publication-august-2025.pdf | 432 | 2025-08 | Car | Audi | Q3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | New John Street West | New John Street West | Birmingham | Birmingham | Warning Letter | N/A | 52.4944784 | -1.9122329 | ||
| 2486 | op-snap---monthly-publication-august-2025.pdf | 461 | 2025-08 | Pedal Bike | Hyundai | Santa Fe | White | Driving without Due Care and Attention | None | Smallbrook Queensway | Smallbrook Queensway | Birmingham | Birmingham | Warning Letter | N/A | 52.4772584 | -1.8965734 | ||
| 2493 | op-snap---monthly-publication-august-2025.pdf | 468 | 2025-08 | Car | Mercedes-Benz | A class | White | Driving without Due Care and Attention | None | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Warning Letter | N/A | 52.4709298 | -1.8722585 | ||
| 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 | ||
| 2513 | op-snap---monthly-publication-august-2025.pdf | 488 | 2025-08 | Car | Toyota | Corolla | Grey | Driving without Reasonable Consideration | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.5274116 | -1.9287273 | ||
| 2530 | op-snap---monthly-publication-august-2025.pdf | 505 | 2025-08 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Bordesley Middleway | Bordesley Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4704236 | -1.8769606 | ||
| 2546 | op-snap---monthly-publication-august-2025.pdf | 521 | 2025-08 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | A452 Spitfire Island | Spitfire Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5138106 | -1.797297 | ||
| 2549 | op-snap---monthly-publication-august-2025.pdf | 524 | 2025-08 | Pedal Bike | Toyota | Prius | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Vicarage Road, High Street, Kings Heath | Vicarage Road, High Street, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2578 | op-snap---monthly-publication-august-2025.pdf | 553 | 2025-08 | Car | Nissan | Micra | Red | Contravening a Red Traffic Light | None | Park Hall Scool | Park Hall Scool | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2589 | op-snap---monthly-publication-august-2025.pdf | 564 | 2025-08 | Car | Renault | Scenic | Black | Contravening a Red Traffic Light | None | Alridge Road | Aldridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5368764 | -1.8976461 | ||
| 2592 | op-snap---monthly-publication-august-2025.pdf | 567 | 2025-08 | Pedal Bike | Skoda | Octavia | Black | Driving without Due Care and Attention | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 2605 | op-snap---monthly-publication-august-2025.pdf | 580 | 2025-08 | Pedal Bike | Nissan | Juke | Black | Driving without Due Care and Attention | None | Bakers Lane | Bakers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5632567 | -1.8782299 | ||
| 2607 | op-snap---monthly-publication-august-2025.pdf | 582 | 2025-08 | Car | Nissan | Qashqai | Silver | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4555288 | -1.8613929 | ||
| 2621 | op-snap---monthly-publication-august-2025.pdf | 596 | 2025-08 | Car | Toyota | Avensis | Black | Contravening a Red Traffic Light | None | Botteville Road | Botteville Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4439249 | -1.8229207 | ||
| 2669 | op-snap---monthly-publication-august-2025.pdf | 644 | 2025-08 | Car | Vauxhall | Mokka | Black | Contravene Lane Closure Red X | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 2672 | op-snap---monthly-publication-august-2025.pdf | 647 | 2025-08 | Car | Ford | Galaxy | Silver | Contravene Lane Closure Red X | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 2676 | op-snap---monthly-publication-august-2025.pdf | 651 | 2025-08 | Car | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | Mavis Road | Mavis Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4020383 | -1.9799109 | ||
| 2681 | op-snap---monthly-publication-august-2025.pdf | 656 | 2025-08 | Car | Skoda | Octavia | Blue | Driving without Due Care and Attention | None | Bickenhill Road | Bickenhill Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2684 | op-snap---monthly-publication-august-2025.pdf | 659 | 2025-08 | Car | Skoda | FABIA | Black | Driving without Due Care and Attention | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4668753 | -1.8996143 | ||
| 2753 | op-snap---monthly-publication-august-2025.pdf | 728 | 2025-08 | Car | BMW | 520.. | Grey | Drive on hard shoulder | None | M6 (North) | M6 (North) | Birmingham | Birmingham | Warning Letter | N/A | 52.5143137 | -1.7683873 | ||
| 2754 | op-snap---monthly-publication-august-2025.pdf | 729 | 2025-08 | Car | Skoda | Octivia | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5505398 | -1.8252993 | ||
| 2759 | op-snap---monthly-publication-august-2025.pdf | 734 | 2025-08 | Car | Toyota | Prius | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5505398 | -1.8252993 | ||
| 2774 | op-snap---monthly-publication-august-2025.pdf | 749 | 2025-08 | Car | BMW | X5 | White | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 2817 | op-snap---monthly-publication-august-2025.pdf | 792 | 2025-08 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 2828 | op-snap---monthly-publication-august-2025.pdf | 803 | 2025-08 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | College Road | College Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5151832 | -1.9361664 | ||
| 2844 | op-snap---monthly-publication-august-2025.pdf | 819 | 2025-08 | Car | Toyota | Yaris | Silver | Driving without Due Care and Attention | None | Billesley Lane | Billesley Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4344402 | -1.8845368 | ||
| 2859 | op-snap---monthly-publication-august-2025.pdf | 834 | 2025-08 | Car | Ford | Fiesta | White | Contravening a Red Traffic Light | None | California Way | California Way | Birmingham | Birmingham | Warning Letter | N/A | 52.4454714 | -1.9753804 | ||
| 2877 | op-snap---monthly-publication-august-2025.pdf | 852 | 2025-08 | Car | BMW | 335.. | White | Driving without Due Care and Attention | None | Bridge Road Saltley | Bridge Road Saltley | Birmingham | Birmingham | Warning Letter | N/A | 52.4857537 | -1.8531485 | ||
| 2890 | op-snap---monthly-publication-august-2025.pdf | 865 | 2025-08 | Car | Iveco | Daily | White | Driving without Due Care and Attention | None | M6 SB J6 | M6 Southbound J6 | Birmingham | Birmingham | Warning Letter | N/A | 52.676119 | -2.0858425 | ||
| 2915 | op-snap---monthly-publication-august-2025.pdf | 890 | 2025-08 | Car | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | M6 NB J6 | M6 Northbound J6 | Birmingham | Birmingham | Warning Letter | N/A | 52.676119 | -2.0858425 | ||
| 2919 | op-snap---monthly-publication-august-2025.pdf | 894 | 2025-08 | Car | Volkswagen | Touran | Black | Driving without Reasonable Consideration | None | Battery Way | Battery Way | Birmingham | Birmingham | Warning Letter | N/A | 52.4493988 | -1.8476406 | ||
| 2936 | op-snap---monthly-publication-august-2025.pdf | 911 | 2025-08 | Car | Vauxhall | Corsa | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5012458 | -1.8780942 | ||
| 2938 | op-snap---monthly-publication-august-2025.pdf | 913 | 2025-08 | Car | Audi | Q4 | Black | Driving without Due Care and Attention | None | Trinity Road | Trinity Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5812323 | -1.8234706 | ||
| 2942 | op-snap---monthly-publication-august-2025.pdf | 917 | 2025-08 | Pedal Bike | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Langleys Road, Selly Oak | Langleys Road, Selly Oak | Birmingham | Birmingham | Warning Letter | N/A | 52.4358093 | -1.9411176 | ||
| 2947 | op-snap---monthly-publication-august-2025.pdf | 922 | 2025-08 | Car | Audi | A1 | White | Driving without Due Care and Attention | None | Snow Hill | Snow Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4825769 | -1.897234 | ||
| 2969 | op-snap---monthly-publication-august-2025.pdf | 944 | 2025-08 | Car | Audi | A3 | White | Driving without Due Care and Attention | None | Egghill Lane | Egghill Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4093768 | -1.9976236 | ||
| 2975 | op-snap---monthly-publication-august-2025.pdf | 950 | 2025-08 | Car | Fiat | Bravo | Grey | Contravening a Red Traffic Light | None | Argyle Street | Argyle Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5063232 | -1.8611255 | ||
| 2985 | op-snap---monthly-publication-august-2025.pdf | 960 | 2025-08 | Car | Land Rover | Black | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 3021 | op-snap---monthly-publication-august-2025.pdf | 996 | 2025-08 | Car | Mini | Cooper | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 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 | ||
| 3034 | op-snap---monthly-publication-august-2025.pdf | 1009 | 2025-08 | Car | Volkswagen | ID3 | Silver | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 3044 | op-snap---monthly-publication-august-2025.pdf | 1019 | 2025-08 | Car | Audi | Q2 | Grey | Driving without Due Care and Attention | None | Pritchatts Road | Pritchatts Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4522304 | -1.9267446 | ||
| 3045 | op-snap---monthly-publication-august-2025.pdf | 1020 | 2025-08 | Car | Audi | S3 | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4437078 | -1.8783408 | ||
| 3051 | op-snap---monthly-publication-august-2025.pdf | 1026 | 2025-08 | Car | Dacia | Jogger | Grey | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 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 | ||
| 3073 | op-snap---monthly-publication-august-2025.pdf | 1048 | 2025-08 | Car | Nissan | Micra | White | Driving without Due Care and Attention | None | B4101 Balsall Street | Balsall Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4579985 | -1.8916996 | ||
| 3091 | op-snap---monthly-publication-august-2025.pdf | 1066 | 2025-08 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.3962003 | -1.9821252 | ||
| 3103 | op-snap---monthly-publication-august-2025.pdf | 1078 | 2025-08 | Car | Mercedes-Benz | Evito | Black | Contravening a Red Traffic Light | None | A452 Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 3117 | op-snap---monthly-publication-august-2025.pdf | 1092 | 2025-08 | Pedal Bike | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 3122 | op-snap---monthly-publication-august-2025.pdf | 1097 | 2025-08 | Pedal Bike | Skoda | Octavia | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3123 | op-snap---monthly-publication-august-2025.pdf | 1098 | 2025-08 | Car | Renault | Clio | Orange | Driving without Due Care and Attention | None | Lodge Road, Winson Green | Lodge Road, Winson Green | Birmingham | Birmingham | Warning Letter | N/A | 52.4925309 | -1.9177131 | ||
| 3138 | op-snap---monthly-publication-august-2025.pdf | 1113 | 2025-08 | Car | Citroen | C3 | White | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 3151 | op-snap---monthly-publication-august-2025.pdf | 1126 | 2025-08 | Car | Seat | Ibiza | Blue | Driving a vehicle wholly or partly on a footpath | None | Church Hill | Church Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4112239 | -1.9643143 | ||
| 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 | ||
| 3163 | op-snap---monthly-publication-august-2025.pdf | 1138 | 2025-08 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 3199 | op-snap---monthly-publication-august-2025.pdf | 1174 | 2025-08 | Car | Audi | A3 | White | Driving without Reasonable Consideration | None | Chester Road, New Oscott | Chester Road, New Oscott | Birmingham | Birmingham | Warning Letter | N/A | 52.5459731 | -1.8568254 | ||
| 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 | ||
| 3214 | op-snap---monthly-publication-august-2025.pdf | 1189 | 2025-08 | Car | Ford | fiesta | Black | Driving without Due Care and Attention | None | Aldrige Road | Aldridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5368764 | -1.8976461 | ||
| 3215 | op-snap---monthly-publication-august-2025.pdf | 1190 | 2025-08 | Car | Nissan | juke | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells road | Lozells road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3216 | op-snap---monthly-publication-august-2025.pdf | 1191 | 2025-08 | Car | Volkswagen | golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells road | Lozells road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3217 | op-snap---monthly-publication-august-2025.pdf | 1192 | 2025-08 | Car | BMW | 218D | White | Driving without Due Care and Attention | None | Aldrige Road | Aldridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5368764 | -1.8976461 | ||
| 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 | ||
| 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 | ||
| 3235 | op-snap---monthly-publication-august-2025.pdf | 1210 | 2025-08 | Car | Citroen | Curtain Side | White | Cause vehicle to be left in a dangerous position | None | Lyons Grove | Lyons Grove | Birmingham | Birmingham | Warning Letter | N/A | 52.4471223 | -1.8664309 | ||
| 3236 | op-snap---monthly-publication-august-2025.pdf | 1211 | 2025-08 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Durham Avenue | Durham Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 |
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);