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'}
83 rows where month = "2025-12", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 24
- Volkswagen 12
- Ford 10
- Audi 7
- BMW 4
- Kia 4
- Mercedes-Benz 4
- Toyota 4
- Vauxhall 4
- Citroen 3
- Jaguar 3
- Nissan 3
- Skoda 3
- Volvo 3
- Honda 2
- Hyundai 2
- Mazda 2
- Mitsubishi 2
- Peugeot 2
- Renault 2
- Alfa Romeo 1
- Iveco 1
- Jeep 1
- Land Rover 1
- Seat 1
council_area 7
- Birmingham 45
- Coventry 14
- Solihull 8
- Out of Force Area 6
- Sutton Coldfield 5
- Dudley 4
- Cbtiiromningham 1
disposal 5
- Education 31
- NFA 17
- Warning Letter 16
- Fixed Penalty 14
- Court 5
reporter_transport_mode 1
- Pedal Bike · 83 ✖
offence 1
- Driving without Due Care and Attention · 83 ✖
month 1
- 2025-12 · 83 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3884 | op-snap---monthly-publication-december-2025.pdf | 12 | 2025-12 | Pedal Bike | Volkswagen | Golf | Red | Driving without Due Care and Attention | None | Thornhill Road | Thornhill Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5690586 | -1.8794686 | ||
| 3891 | op-snap---monthly-publication-december-2025.pdf | 19 | 2025-12 | Pedal Bike | Ford | Mondeo | Silver | Driving without Due Care and Attention | None | Longdales Road | Longdales Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3947881 | -1.9285109 | ||
| 3892 | op-snap---monthly-publication-december-2025.pdf | 20 | 2025-12 | Pedal Bike | Nissan | Note | White | Driving without Due Care and Attention | None | Wychall Lane | Wychall Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4090761 | -1.9404121 | ||
| 3910 | op-snap---monthly-publication-december-2025.pdf | 38 | 2025-12 | Pedal Bike | Kia | Blue | Driving without Due Care and Attention | None | Woodville Road | Woodville Road | Birmingham | Birmingham | NFA | No Offence | 52.4616763 | -1.9653016 | |||
| 3920 | op-snap---monthly-publication-december-2025.pdf | 48 | 2025-12 | Pedal Bike | Audi | Q7 | White | Driving without Due Care and Attention | None | Yardley Green Lane | Yardley Green Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4551082 | -1.8103696 | ||
| 3987 | op-snap---monthly-publication-december-2025.pdf | 115 | 2025-12 | Pedal Bike | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | Sarehole Road | Sarehole Road | Birmingham | Birmingham | Court | N/A | 52.4422505 | -1.8539684 | ||
| 3994 | op-snap---monthly-publication-december-2025.pdf | 122 | 2025-12 | Pedal Bike | Kia | Sportage | Blue | Driving without Due Care and Attention | None | Cressage | Cressage | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.40435 | -1.9677367 | ||
| 3995 | op-snap---monthly-publication-december-2025.pdf | 123 | 2025-12 | Pedal Bike | Volkswagen | Red | Driving without Due Care and Attention | None | Atcham | Atcham | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4009 | op-snap---monthly-publication-december-2025.pdf | 137 | 2025-12 | Pedal Bike | Volkswagen | TRoc | Silver | Driving without Due Care and Attention | none | Longmoor Street | Longmoor Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 4011 | op-snap---monthly-publication-december-2025.pdf | 139 | 2025-12 | Pedal Bike | Land Rover | Velar | Black | Driving without Due Care and Attention | None | High Street, Deritend | High Street, Deritend | Birmingham | Birmingham | Warning Letter | N/A | 52.4746492 | -1.8839977 | ||
| 4017 | op-snap---monthly-publication-december-2025.pdf | 145 | 2025-12 | Pedal Bike | Ford | Transit | Grey | Driving without Due Care and Attention | None | Westward Way | Westward Way | Coventry | Coventry | Education | N/A | ||||
| 4020 | op-snap---monthly-publication-december-2025.pdf | 148 | 2025-12 | Pedal Bike | Ford | Transit | Grey | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 4027 | op-snap---monthly-publication-december-2025.pdf | 155 | 2025-12 | Pedal Bike | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | A491 Hagley Road | Hagley Road | Dudley | Dudley | Warning Letter | N/A | 52.4514139 | -2.1423625 | ||
| 4041 | op-snap---monthly-publication-december-2025.pdf | 169 | 2025-12 | Pedal Bike | Renault | Kadjar | Black | Driving without Due Care and Attention | None | Lincoln Street | Lincoln Street | Birmingham | Birmingham | Court | N/A | 52.459298 | -1.8933648 | ||
| 4079 | op-snap---monthly-publication-december-2025.pdf | 207 | 2025-12 | Pedal Bike | Toyota | Rav4 | Black | Driving without Due Care and Attention | None | Spiceland Road Northfield | Spiceland Road Northfield | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4243001 | -1.9747504 | ||
| 4080 | op-snap---monthly-publication-december-2025.pdf | 208 | 2025-12 | Pedal Bike | BMW | White | Driving without Due Care and Attention | None | B5063 West Mercia | West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5827653 | -2.0983246 | |||
| 4082 | op-snap---monthly-publication-december-2025.pdf | 210 | 2025-12 | Pedal Bike | BMW | White | Driving without Due Care and Attention | None | B5063 West Mercia | West Mercia | Out of Force Area | Out of Force Area | NFA | Duplicate Submission | 52.5827653 | -2.0983246 | |||
| 4086 | op-snap---monthly-publication-december-2025.pdf | 214 | 2025-12 | Pedal Bike | Volkswagen | UP | Red | Driving without Due Care and Attention | None | Swanswwell St | Swanswwell Street | Coventry | Coventry | Education | N/A | ||||
| 4117 | op-snap---monthly-publication-december-2025.pdf | 245 | 2025-12 | Pedal Bike | Volkswagen | Touran | Black | Driving without Due Care and Attention | None | Sarehole Road | Sarehole Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4422505 | -1.8539684 | ||
| 4138 | op-snap---monthly-publication-december-2025.pdf | 266 | 2025-12 | Pedal Bike | Mitsubishi | Outlander | Red | Driving without Due Care and Attention | None | Monkspath Hall Rd | Monkspath Hall Road | Solihull | Solihull | Fixed Penalty | N/A | 52.3900358 | -1.8026595 | ||
| 4152 | op-snap---monthly-publication-december-2025.pdf | 280 | 2025-12 | Pedal Bike | Audi | A4 | White | Driving without Due Care and Attention | No Insurance | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Court | N/A | 52.5113867 | -1.8337258 | ||
| 4155 | op-snap---monthly-publication-december-2025.pdf | 283 | 2025-12 | Pedal Bike | Hyundai | i30 | Black | Driving without Due Care and Attention | None | Stratford Road and Farm Road jun | Stratford Road and Farm Road jun | cBtiiromningham | Cbtiiromningham | Fixed Penalty | N/A | 52.4532265 | -1.8659356 | ||
| 4160 | op-snap---monthly-publication-december-2025.pdf | 288 | 2025-12 | Pedal Bike | BMW | M4 | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 4161 | op-snap---monthly-publication-december-2025.pdf | 289 | 2025-12 | Pedal Bike | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Sarehold Road | Sarehold Road | Birmingham | Birmingham | Education | N/A | ||||
| 4183 | op-snap---monthly-publication-december-2025.pdf | 311 | 2025-12 | Pedal Bike | Volvo | XC90 | White | Driving without Due Care and Attention | None | Charles Henry Street | Charles Henry Street | Birmingham | Birmingham | Education | N/A | 52.4709195 | -1.8888591 | ||
| 4290 | op-snap---monthly-publication-december-2025.pdf | 418 | 2025-12 | Pedal Bike | Mitsubishi | ASX.. | Black | Driving without Due Care and Attention | None | Reservoir Road | Reservoir Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5242452 | -1.8572541 | ||
| 4291 | op-snap---monthly-publication-december-2025.pdf | 419 | 2025-12 | Pedal Bike | Skoda | Superb | Grey | Driving without Due Care and Attention | None | Reservoir Road | Reservoir Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5242452 | -1.8572541 | ||
| 4302 | op-snap---monthly-publication-december-2025.pdf | 430 | 2025-12 | Pedal Bike | Volvo | V60 | Black | Driving without Due Care and Attention | None | Frankley Beeches Road | Frankley Beeches Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4094108 | -1.9930633 | ||
| 4311 | op-snap---monthly-publication-december-2025.pdf | 439 | 2025-12 | Pedal Bike | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Hereford Road Shrewsbury | Hereford Road Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4313 | op-snap---monthly-publication-december-2025.pdf | 441 | 2025-12 | Pedal Bike | Ford | Kuga | Blue | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 4320 | op-snap---monthly-publication-december-2025.pdf | 448 | 2025-12 | Pedal Bike | Skoda | Enyaq | Grey | Driving without Due Care and Attention | None | Bourneville Lane | Bourneville Lane | Birmingham | Birmingham | Education | N/A | ||||
| 4328 | op-snap---monthly-publication-december-2025.pdf | 456 | 2025-12 | Pedal Bike | Iveco | Daily | White | Driving without Due Care and Attention | None | Lady Byron Lane | Lady Byron Lane | Solihull | Solihull | Warning Letter | N/A | 52.4026126 | -1.7503668 | ||
| 4330 | op-snap---monthly-publication-december-2025.pdf | 458 | 2025-12 | Pedal Bike | Hyundai | I40.. | White | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 4378 | op-snap---monthly-publication-december-2025.pdf | 506 | 2025-12 | Pedal Bike | U/K | White | Driving without Due Care and Attention | None | Belgrave Road | Belgrave Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4141017 | -1.4571973 | |||
| 4379 | op-snap---monthly-publication-december-2025.pdf | 507 | 2025-12 | Pedal Bike | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | No Offence | 52.5113867 | -1.8337258 | ||
| 4388 | op-snap---monthly-publication-december-2025.pdf | 516 | 2025-12 | Pedal Bike | Nissan | Juke | Black | Driving without Due Care and Attention | None | Corners End Lane | Corners End Lane | Solihull | Solihull | NFA | No Offence | ||||
| 4391 | op-snap---monthly-publication-december-2025.pdf | 519 | 2025-12 | Pedal Bike | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | South Road | South Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4530371 | -2.1660216 | ||
| 4413 | op-snap---monthly-publication-december-2025.pdf | 541 | 2025-12 | Pedal Bike | Audi | A5 | Grey | Driving without Due Care and Attention | None | Frankly Beeches Road | Frankly Beeches Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 4414 | op-snap---monthly-publication-december-2025.pdf | 542 | 2025-12 | Pedal Bike | Audi | A4.. | Black | Driving without Due Care and Attention | None | Church Road Northfield | Church Road Northfield | Birmingham | Birmingham | NFA | No Offence | 52.4143428 | -1.966939 | ||
| 4415 | op-snap---monthly-publication-december-2025.pdf | 543 | 2025-12 | Pedal Bike | Honda | Civic | Silver | Driving without Due Care and Attention | None | Tessal Lane | Tessal Lane | Birmingham | Birmingham | Education | N/A | ||||
| 4426 | op-snap---monthly-publication-december-2025.pdf | 554 | 2025-12 | Pedal Bike | Peugeot | 3008.. | Blue | Driving without Due Care and Attention | None | Gosford Street | Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4068712 | -1.4994695 | ||
| 4451 | op-snap---monthly-publication-december-2025.pdf | 579 | 2025-12 | Pedal Bike | Volkswagen | Polo | Silver | Driving without Due Care and Attention | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 4477 | op-snap---monthly-publication-december-2025.pdf | 605 | 2025-12 | Pedal Bike | Mercedes-Benz | Camper | White | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 4533 | op-snap---monthly-publication-december-2025.pdf | 661 | 2025-12 | Pedal Bike | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | NFA | No Offence | 52.4190728 | -1.7449943 | ||
| 4551 | op-snap---monthly-publication-december-2025.pdf | 679 | 2025-12 | Pedal Bike | Benelli Tornado Naked | White | Driving without Due Care and Attention | None | Portman Road, Kings Heath | Portman Road, Kings Heath | Birmingham | Birmingham | Education | N/A | 52.4289531 | -1.8834204 | |||
| 4579 | op-snap---monthly-publication-december-2025.pdf | 707 | 2025-12 | Pedal Bike | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 4584 | op-snap---monthly-publication-december-2025.pdf | 712 | 2025-12 | Pedal Bike | Seat | Arona | Black | Driving without Due Care and Attention | None | Broad Lane, Balsall Common | Broad Lane, Balsall Common | Solihull | Solihull | Education | N/A | ||||
| 4585 | op-snap---monthly-publication-december-2025.pdf | 713 | 2025-12 | Pedal Bike | Audi | A3 | Black | Driving without Due Care and Attention | None | Broad Lane, Coventry | Broad Lane, Coventry | Coventry | Coventry | Education | N/A | 52.4144409 | -1.5990259 | ||
| 4586 | op-snap---monthly-publication-december-2025.pdf | 714 | 2025-12 | Pedal Bike | Ford | Focus | Blue | Driving without Due Care and Attention | None | Waste Lane, Balsall Common | Waste Lane, Balsall Common | Coventry | Coventry | NFA | No Offence | ||||
| 4620 | op-snap---monthly-publication-december-2025.pdf | 748 | 2025-12 | Pedal Bike | Skoda | Fabia | grey | Driving without Due Care and Attention | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 4626 | op-snap---monthly-publication-december-2025.pdf | 754 | 2025-12 | Pedal Bike | Alfa Romeo | Giulietta | White | Driving without Due Care and Attention | None | Stonehouse Hill, California | Stonehouse Hill, California | Birmingham | Birmingham | Warning Letter | N/A | 52.4457793 | -1.97093 | ||
| 4634 | op-snap---monthly-publication-december-2025.pdf | 762 | 2025-12 | Pedal Bike | Jaguar | XF | Blue | Driving without Due Care and Attention | None | Lowhill Lane, Rednal | Lowhill Lane, Rednal | Birmingham | Birmingham | Warning Letter | N/A | 52.3875654 | -1.9924345 | ||
| 4665 | op-snap---monthly-publication-december-2025.pdf | 793 | 2025-12 | Pedal Bike | Renault | Master | White | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 4690 | op-snap---monthly-publication-december-2025.pdf | 818 | 2025-12 | Pedal Bike | Jaguar | Epace | Grey | Driving without Due Care and Attention | None | Danford Lane | Danford Lane | Solihull | Solihull | Court | N/A | 52.4092804 | -1.8056214 | ||
| 4704 | op-snap---monthly-publication-december-2025.pdf | 832 | 2025-12 | Pedal Bike | Honda | CRV | Grey | Driving without Due Care and Attention | None | Portman Road | Portman Road | Birmingham | Birmingham | Education | N/A | 52.4306424 | -1.8844833 | ||
| 4705 | op-snap---monthly-publication-december-2025.pdf | 833 | 2025-12 | Pedal Bike | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 4715 | op-snap---monthly-publication-december-2025.pdf | 843 | 2025-12 | Pedal Bike | Toyota | Auris | Brown | Driving without Due Care and Attention | None | Ralph Road, Shirley, Solihull | Ralph Road, Shirley, Solihull | Solihull | Solihull | Education | N/A | 52.4156768 | -1.8193235 | ||
| 4716 | op-snap---monthly-publication-december-2025.pdf | 844 | 2025-12 | Pedal Bike | Jeep | Renegade | Black | Driving without Due Care and Attention | None | Broad Lane, Tile Hill, Coventry | Broad Lane, Tile Hill, Coventry | Coventry | Coventry | Education | N/A | 52.4112706 | -1.5792697 | ||
| 4720 | op-snap---monthly-publication-december-2025.pdf | 848 | 2025-12 | Pedal Bike | Toyota | Estima | Silver | Driving without Due Care and Attention | None | Belle Walk | Belle Walk | Birmingham | Birmingham | Education | N/A | 52.4451434 | -1.8736544 | ||
| 4725 | op-snap---monthly-publication-december-2025.pdf | 853 | 2025-12 | Pedal Bike | Mazda | CX3 | Silver | Driving without Due Care and Attention | None | Tile Hill Lane, Tile Hill, Coventry | Tile Hill Lane, Tile Hill, Coventry | Coventry | Coventry | Education | N/A | 52.4019676 | -1.5834005 | ||
| 4727 | op-snap---monthly-publication-december-2025.pdf | 855 | 2025-12 | Pedal Bike | Mazda | CX3 | Silver | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Warning Letter | N/A | 52.4074716 | -1.5620671 | ||
| 4728 | op-snap---monthly-publication-december-2025.pdf | 856 | 2025-12 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Warning Letter | N/A | 52.4074716 | -1.5620671 | ||
| 4731 | op-snap---monthly-publication-december-2025.pdf | 859 | 2025-12 | Pedal Bike | Volvo | XC60 | Grey | Driving without Due Care and Attention | None | Gorsty Hill | Gorsty Hill | Dudley | Dudley | Fixed Penalty | N/A | 52.4674777 | -2.0479299 | ||
| 4762 | op-snap---monthly-publication-december-2025.pdf | 890 | 2025-12 | Pedal Bike | Kia | Carens | Silver | Driving without Due Care and Attention | None | Camp Hill Middleway | Camp Hill Middleway | Birmingham | Birmingham | Education | N/A | 52.468339 | -1.8796724 | ||
| 4771 | op-snap---monthly-publication-december-2025.pdf | 899 | 2025-12 | Pedal Bike | Citroen | Dispatch | White | Driving without Due Care and Attention | None | Station Road | Station Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5463049 | -1.8271004 | ||
| 4789 | op-snap---monthly-publication-december-2025.pdf | 917 | 2025-12 | Pedal Bike | Volkswagen | Tiguan | Green | Driving without Due Care and Attention | None | Walkmley Road | Walkmley Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | ||||
| 4803 | op-snap---monthly-publication-december-2025.pdf | 931 | 2025-12 | Pedal Bike | Mercedes-Benz | S350 | Black | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 4810 | op-snap---monthly-publication-december-2025.pdf | 938 | 2025-12 | Pedal Bike | Mercedes-Benz | C180 | Silver | Driving without Due Care and Attention | None | Moseley road | Moseley road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4679402 | -1.881408 | ||
| 4816 | op-snap---monthly-publication-december-2025.pdf | 944 | 2025-12 | Pedal Bike | BMW | IX | Grey | Driving without Due Care and Attention | None | Whitefields Road | Whitefields Road | Solihull | Solihull | Education | N/A | 52.4060267 | -1.7849657 | ||
| 4818 | op-snap---monthly-publication-december-2025.pdf | 946 | 2025-12 | Pedal Bike | Audi | A5 | White | Driving without Due Care and Attention | None | Oak Tree Lane, Selly Oak | Oak Tree Lane, Selly Oak | Birmingham | Birmingham | Warning Letter | N/A | 52.4386794 | -1.939894 | ||
| 4864 | op-snap---monthly-publication-december-2025.pdf | 992 | 2025-12 | Pedal Bike | Vauxhall | Grandland | Brown | Driving without Due Care and Attention | None | Heath Street, Stourbridge | Heath Street, Stourbridge | Dudley | Dudley | Warning Letter | N/A | 52.4528944 | -2.152138 | ||
| 4877 | op-snap---monthly-publication-december-2025.pdf | 1005 | 2025-12 | Pedal Bike | Vauxhall | Zafira | Silver | Driving without Due Care and Attention | None | Teviot Grove, Kings Norton | Teviot Grove, Kings Norton | Birmingham | Birmingham | Education | N/A | 52.3986816 | -1.9362011 | ||
| 4878 | op-snap---monthly-publication-december-2025.pdf | 1006 | 2025-12 | Pedal Bike | Peugeot | Boxer | White | Driving without Due Care and Attention | None | Melrose Avenue | Melrose Avenue | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5511462 | -1.8479052 | ||
| 4879 | op-snap---monthly-publication-december-2025.pdf | 1007 | 2025-12 | Pedal Bike | Jaguar | Fpace | Black | Driving without Due Care and Attention | None | Cordbridge Road | Cordbridge Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | ||||
| 4880 | op-snap---monthly-publication-december-2025.pdf | 1008 | 2025-12 | Pedal Bike | Nissan | Juke | Blue | Driving without Due Care and Attention | None | Frankley Beeches Road | Frankley Beeches Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4094108 | -1.9930633 | ||
| 4881 | op-snap---monthly-publication-december-2025.pdf | 1009 | 2025-12 | Pedal Bike | Volkswagen | Tiguan | Silver | Driving without Due Care and Attention | None | Swindon Road kingswinford | Swindon Road kingswinford | Out of Force Area | Out of Force Area | Fixed Penalty | N/A | 52.498429 | -2.179519 | ||
| 4882 | op-snap---monthly-publication-december-2025.pdf | 1010 | 2025-12 | Pedal Bike | Citroen | DS3 | White | Driving without Due Care and Attention | None | Redhill Road | Redhill Road | Birmingham | Birmingham | Education | N/A | 52.4618364 | -1.8328803 | ||
| 4905 | op-snap---monthly-publication-december-2025.pdf | 1033 | 2025-12 | Pedal Bike | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Kent Street | Kent Street | Birmingham | Birmingham | Education | N/A | 52.4717099 | -1.897463 | ||
| 4916 | op-snap---monthly-publication-december-2025.pdf | 1044 | 2025-12 | Pedal Bike | Mercedes-Benz | C350 | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 4925 | op-snap---monthly-publication-december-2025.pdf | 1053 | 2025-12 | Pedal Bike | Audi | A3 | Blue | Driving without Due Care and Attention | None | Edward Road / Lincoln Street | Edward Road / Lincoln Street | Birmingham | Birmingham | Education | N/A | 52.4580901 | -1.894458 | ||
| 4929 | op-snap---monthly-publication-december-2025.pdf | 1057 | 2025-12 | Pedal Bike | Kia | Picanto | Silver | Driving without Due Care and Attention | None | Russell Road / Edgbaston Road | Russell Road / Edgbaston Road | Birmingham | Birmingham | Education | N/A | 52.4398245 | -1.8469786 | ||
| 4964 | op-snap---monthly-publication-december-2025.pdf | 1092 | 2025-12 | Pedal Bike | Citroen | C3 | Grey | Driving without Due Care and Attention | None | Watford Road | Watford Road | Birmingham | Birmingham | NFA | No Offence | 52.4182952 | -1.9316395 | ||
| 5086 | op-snap---monthly-publication-december-2025.pdf | 1214 | 2025-12 | Pedal Bike | Vauxhall | Corsa | Green | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Court | N/A | 52.4221152 | -1.4959475 |
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);