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'}
182 rows where council_area = "Birmingham", disposal = "NFA" and offence = "Using a Mobile Phone Whilst Driving" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
month 14
reporter_transport_mode 8
- Car 83
- Pedal Bike 56
- Pedestrian 21
- Other 16
- Bus 2
- Motorbike 2
- Van 1
- other 1
offence 1
- Using a Mobile Phone Whilst Driving · 182 ✖
disposal 1
- NFA · 182 ✖
council_area 1
- Birmingham · 182 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7364 | op-snap---monthly-publication-february-2026.pdf | 111 | 2026-02 | Pedal Bike | Volkswagen | Golf R | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4695793 | -1.9378608 | ||
| 7506 | op-snap---monthly-publication-february-2026.pdf | 253 | 2026-02 | Other | Volvo | C40 | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 7561 | op-snap---monthly-publication-february-2026.pdf | 308 | 2026-02 | Pedal Bike | Citroen | C3 | Grey | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 7623 | op-snap---monthly-publication-february-2026.pdf | 370 | 2026-02 | Other | Lamborghini | Silver | Using a Mobile Phone Whilst Driving | None | Birmingham | Birmingham | Birmingham | Birmingham | NFA | No VRM | 52.4796992 | -1.9026911 | |||
| 7829 | op-snap---monthly-publication-february-2026.pdf | 576 | 2026-02 | Car | Peugeot | 308.. | Grey | Using a Mobile Phone Whilst Driving | None | Cato Street | Cato Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4904718 | -1.8693759 | ||
| 8274 | op-snap---monthly-publication-february-2026.pdf | 1021 | 2026-02 | Car | Alfa Romeo | Romeo | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 8325 | op-snap---monthly-publication-february-2026.pdf | 1072 | 2026-02 | Pedestrian | BMW | 1 | White | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 8326 | op-snap---monthly-publication-february-2026.pdf | 1073 | 2026-02 | Pedal Bike | Tesla | Model 3 | Grey | Using a Mobile Phone Whilst Driving | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 8438 | op-snap---monthly-publication-february-2026.pdf | 1185 | 2026-02 | Car | Fiat | 500 | Green | Using a Mobile Phone Whilst Driving | None | Dudley Road East | Dudley Road East | Birmingham | Birmingham | NFA | No Offence | ||||
| 8660 | op-snap---monthly-publication-february-2026.pdf | 1407 | 2026-02 | Car | Land Rover | Evoque | White | Using a Mobile Phone Whilst Driving | None | Shard End Crescent | Shard End Crescent | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4927744 | -1.7781391 | ||
| 8856 | op-snap---monthly-publication-february-2026.pdf | 1603 | 2026-02 | Pedal Bike | Audi | A5 | Black | Using a Mobile Phone Whilst Driving | None | shenley hill | Shenley Hill | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4267534 | -1.9790765 | ||
| 10644 | op-snap---monthly-publication-january-2026.pdf | 105 | 2026-01 | other | Honda | Civic | Grey | Using a Mobile Phone Whilst Driving | None | Appleby Grove | Appleby Grove | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 10656 | op-snap---monthly-publication-january-2026.pdf | 117 | 2026-01 | Other | Daf | Truck | White | Using a Mobile Phone Whilst Driving | None | Northcote Road | Northcote Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4862344 | -1.8128298 | ||
| 10739 | op-snap---monthly-publication-january-2026.pdf | 200 | 2026-01 | Car | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | Boardsley Middleway | Boardsley Middleway | Birmingham | Birmingham | NFA | No VRM | ||||
| 10753 | op-snap---monthly-publication-january-2026.pdf | 214 | 2026-01 | Other | Vauxhall | Vivaro | Black | Using a Mobile Phone Whilst Driving | None | Fifield Road | Fifield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 10777 | op-snap---monthly-publication-january-2026.pdf | 238 | 2026-01 | Car | Chevrolet | Cruz | Black | Using a Mobile Phone Whilst Driving | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5113867 | -1.8337258 | ||
| 10855 | op-snap---monthly-publication-january-2026.pdf | 316 | 2026-01 | Pedestrian | Volkswagen | Polo | Red | Using a Mobile Phone Whilst Driving | None | Ninevah Road | Ninevah Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 10992 | op-snap---monthly-publication-january-2026.pdf | 453 | 2026-01 | Pedal Bike | BMW | 740LD | Blue | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4591339 | -1.9601054 | ||
| 11052 | op-snap---monthly-publication-january-2026.pdf | 513 | 2026-01 | Pedestrian | Audi | A5 | White | Using a Mobile Phone Whilst Driving | None | Silver Street | Silver Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.433129 | -1.8963794 | ||
| 11225 | op-snap---monthly-publication-january-2026.pdf | 686 | 2026-01 | Bus | Toyota | Prius | White | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 11276 | op-snap---monthly-publication-january-2026.pdf | 737 | 2026-01 | Car | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4860376 | -1.9095854 | ||
| 11316 | op-snap---monthly-publication-january-2026.pdf | 777 | 2026-01 | Car | Ford | Transit 350 | White | Using a Mobile Phone Whilst Driving | None | Graham St | Graham Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4843802 | -1.9108415 | ||
| 11509 | op-snap---monthly-publication-january-2026.pdf | 970 | 2026-01 | Car | Toyota | Prius | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 11624 | op-snap---monthly-publication-january-2026.pdf | 1085 | 2026-01 | Other | Using a Mobile Phone Whilst Driving | None | No exact location given. Taken from social media. | No exact location given. Taken from social media | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 11863 | op-snap---monthly-publication-january-2026.pdf | 1324 | 2026-01 | Pedal Bike | Skoda | Kodiaq | Blue | Using a Mobile Phone Whilst Driving | None | Stonehouse Hill | Stonehouse Hill | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4448348 | -1.9713792 | ||
| 3909 | op-snap---monthly-publication-december-2025.pdf | 37 | 2025-12 | Car | Mercedes-Benz | Benz | White | Using a Mobile Phone Whilst Driving | None | Alcester Street | Alcester Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4696096 | -1.8871873 | ||
| 3911 | op-snap---monthly-publication-december-2025.pdf | 39 | 2025-12 | Car | Renault | Twingo | Red | Using a Mobile Phone Whilst Driving | None | Bloomfield Road | Bloomfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4480767 | -1.8755275 | ||
| 4004 | op-snap---monthly-publication-december-2025.pdf | 132 | 2025-12 | Car | Vauxhall | Corsa | Silver | Using a Mobile Phone Whilst Driving | None | Coles Hill Road | Coles Hill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4187 | op-snap---monthly-publication-december-2025.pdf | 315 | 2025-12 | Other | Land Rover | SE | Black | Using a Mobile Phone Whilst Driving | Use vehicle on a road withou | tB viramlidin tgehsat mcertificate | t B viramlidin tgehsat mcertificate | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4194 | op-snap---monthly-publication-december-2025.pdf | 322 | 2025-12 | Pedal Bike | BMW | 520D | Black | Using a Mobile Phone Whilst Driving | None | Sarehole Road | Sarehole Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4422505 | -1.8539684 | ||
| 4341 | op-snap---monthly-publication-december-2025.pdf | 469 | 2025-12 | Pedal Bike | Toyota | Prius | Black | Using a Mobile Phone Whilst Driving | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | No Offence | 52.4708802 | -1.8792135 | ||
| 4360 | op-snap---monthly-publication-december-2025.pdf | 488 | 2025-12 | Pedal Bike | Mercedes-Benz | E350 | Blue | Using a Mobile Phone Whilst Driving | None | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||||
| 4553 | op-snap---monthly-publication-december-2025.pdf | 681 | 2025-12 | Other | BMW | X1 | Grey | Using a Mobile Phone Whilst Driving | None | B4124 ROcky Lane | B4124 ROcky Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4931 | op-snap---monthly-publication-december-2025.pdf | 1059 | 2025-12 | Car | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 4997 | op-snap---monthly-publication-december-2025.pdf | 1125 | 2025-12 | Car | Peugeot | Partner | White | Using a Mobile Phone Whilst Driving | None | Queslett Road | Queslett Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5458699 | -1.9304484 | ||
| 20484 | op-snap---monthly-publication-november-2025.pdf | 26 | 2025-11 | Car | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 20533 | op-snap---monthly-publication-november-2025.pdf | 75 | 2025-11 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | M6 | M6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 20553 | op-snap---monthly-publication-november-2025.pdf | 95 | 2025-11 | Car | Volkswagen | Amarok | Black | Using a Mobile Phone Whilst Driving | None | Watery Lane Middleway | Watery Lane Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4752679 | -1.8748608 | ||
| 20555 | op-snap---monthly-publication-november-2025.pdf | 97 | 2025-11 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Belmont Row | Belmont Row | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4840765 | -1.8819479 | ||
| 20566 | op-snap---monthly-publication-november-2025.pdf | 108 | 2025-11 | Pedestrian | Dacia | sandro | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.430111 | -1.9753703 | ||
| 20713 | op-snap---monthly-publication-november-2025.pdf | 255 | 2025-11 | Car | Mercedes-Benz | A Class | White | Using a Mobile Phone Whilst Driving | None | Sutton New Road | Sutton New Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5260956 | -1.8379401 | ||
| 20760 | op-snap---monthly-publication-november-2025.pdf | 302 | 2025-11 | Motorbike | BMW | 320D | Grey | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4591339 | -1.9601054 | ||
| 20808 | op-snap---monthly-publication-november-2025.pdf | 350 | 2025-11 | Car | BMW | 118D | Black | Using a Mobile Phone Whilst Driving | None | A45 | A45 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 20857 | op-snap---monthly-publication-november-2025.pdf | 399 | 2025-11 | Car | Suzuki | Ibiza | Grey | Using a Mobile Phone Whilst Driving | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | NFA | No Offence | 52.4415108 | -1.8971434 | ||
| 21006 | op-snap---monthly-publication-november-2025.pdf | 548 | 2025-11 | Pedal Bike | Volkswagen | Golf | Silver | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4943878 | -1.8504211 | ||
| 21410 | op-snap---monthly-publication-november-2025.pdf | 952 | 2025-11 | Motorbike | Vauxhall | Corsa | Grey | Using a Mobile Phone Whilst Driving | None | Court Oak Road | Court Oak Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4604383 | -1.9760104 | ||
| 21511 | op-snap---monthly-publication-november-2025.pdf | 1053 | 2025-11 | Car | Land Rover | Range | Grey | Using a Mobile Phone Whilst Driving | None | Highgate Road | Highgate Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4606652 | -1.8791145 | ||
| 21557 | op-snap---monthly-publication-november-2025.pdf | 1099 | 2025-11 | Car | Maxus | E Deliver | White | Using a Mobile Phone Whilst Driving | None | Park Lane | Park Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4986532 | -1.8873443 | ||
| 21583 | op-snap---monthly-publication-november-2025.pdf | 1125 | 2025-11 | Car | Kia | Sportage | White | Using a Mobile Phone Whilst Driving | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4749336 | -1.9003475 | ||
| 21666 | op-snap---monthly-publication-november-2025.pdf | 1208 | 2025-11 | Pedal Bike | Volkswagen | Polo | Black | Using a Mobile Phone Whilst Driving | None | Moseley Road at Alcester Road | Moseley Road at Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4679402 | -1.881408 | ||
| 21724 | op-snap---monthly-publication-november-2025.pdf | 1266 | 2025-11 | Van | NP | Using a Mobile Phone Whilst Driving | None | Redditch Road | Redditch Road | Birmingham | Birmingham | NFA | No VRM | 52.3954946 | -1.9516557 | ||||
| 21741 | op-snap---monthly-publication-november-2025.pdf | 1283 | 2025-11 | Car | BMW | 120d | Grey | Using a Mobile Phone Whilst Driving | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4506039 | -1.8463952 | ||
| 21760 | op-snap---monthly-publication-november-2025.pdf | 1302 | 2025-11 | Car | Using a Mobile Phone Whilst Driving | None | UK | Uk | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.45124 | -1.937937 | |||||
| 21764 | op-snap---monthly-publication-november-2025.pdf | 1306 | 2025-11 | Other | NP | Using a Mobile Phone Whilst Driving | None | Redditch Road | Redditch Road | Birmingham | Birmingham | NFA | No VRM | 52.3954946 | -1.9516557 | ||||
| 22168 | op-snap---monthly-publication-october-2025.pdf | 118 | 2025-10 | Car | Ford | Focus | Red | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 22221 | op-snap---monthly-publication-october-2025.pdf | 171 | 2025-10 | Car | Seat | Ibiza | Silver | Using a Mobile Phone Whilst Driving | None | Brays Road | Brays Road | Birmingham | Birmingham | NFA | No Offence | 52.4629816 | -1.780277 | ||
| 22223 | op-snap---monthly-publication-october-2025.pdf | 173 | 2025-10 | Car | Renault | Grey | Using a Mobile Phone Whilst Driving | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5517052 | -1.7825505 | |||
| 22275 | op-snap---monthly-publication-october-2025.pdf | 225 | 2025-10 | Car | Seat | Leon | White | Using a Mobile Phone Whilst Driving | None | New John St | New John Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4920451 | -1.8920402 | ||
| 22321 | op-snap---monthly-publication-october-2025.pdf | 271 | 2025-10 | Pedal Bike | Mini | Cooper | Blue | Using a Mobile Phone Whilst Driving | None | Icknield Port Road | Icknield Port Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4792334 | -1.92925 | ||
| 22650 | op-snap---monthly-publication-october-2025.pdf | 600 | 2025-10 | Car | Toyota | Yaris | White | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 22735 | op-snap---monthly-publication-october-2025.pdf | 685 | 2025-10 | Car | Peugeot | Blue | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | |||
| 22786 | op-snap---monthly-publication-october-2025.pdf | 736 | 2025-10 | Other | Rolls-Royce | Cullinan | Black | Using a Mobile Phone Whilst Driving | None | UK | Uk | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.45124 | -1.937937 | ||
| 22822 | op-snap---monthly-publication-october-2025.pdf | 772 | 2025-10 | Car | Mitsubishi | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | |||
| 22833 | op-snap---monthly-publication-october-2025.pdf | 783 | 2025-10 | Car | BMW | M340d | Grey | Using a Mobile Phone Whilst Driving | None | Woodlands Road | Woodlands Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.444502 | -1.8651818 | ||
| 22906 | op-snap---monthly-publication-october-2025.pdf | 856 | 2025-10 | Pedal Bike | BMW | X5.. | Black | Using a Mobile Phone Whilst Driving | None | Northfield Road | Northfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4167654 | -1.9411244 | ||
| 22943 | op-snap---monthly-publication-october-2025.pdf | 893 | 2025-10 | Pedestrian | Toyota | Prius | Silver | Using a Mobile Phone Whilst Driving | None | Trinity Road | Trinity Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5812323 | -1.8234706 | ||
| 22967 | op-snap---monthly-publication-october-2025.pdf | 917 | 2025-10 | Car | BMW | 218d | Blue | Using a Mobile Phone Whilst Driving | None | St Margarets Road | Street Margarets Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 23892 | op-snap---monthly-publication-september-2025.pdf | 111 | 2025-09 | Car | Peugeot | 208.. | Blue | Using a Mobile Phone Whilst Driving | None | University Locks (Outside Co-Op) | University Locks (Outside Co-Op) | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 23902 | op-snap---monthly-publication-september-2025.pdf | 121 | 2025-09 | Car | Mercedes-Benz | CLS | Silver | Using a Mobile Phone Whilst Driving | None | Rickman Drive | Rickman Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4701606 | -1.9013018 | ||
| 23926 | op-snap---monthly-publication-september-2025.pdf | 145 | 2025-09 | Car | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | M6 | M6 | Birmingham | Birmingham | NFA | No Offence | ||||
| 24038 | op-snap---monthly-publication-september-2025.pdf | 257 | 2025-09 | Car | Land Rover | Defender | Black | Using a Mobile Phone Whilst Driving | None | M6?? | M6?? | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5264754 | -1.8895798 | ||
| 24301 | op-snap---monthly-publication-september-2025.pdf | 520 | 2025-09 | Car | Mercedes-Benz | E200. | Silver | Using a Mobile Phone Whilst Driving | None | Cranmore Boulevard | Cranmore Boulevard | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 24340 | op-snap---monthly-publication-september-2025.pdf | 559 | 2025-09 | Pedal Bike | Toyota | Black | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | |||
| 24500 | op-snap---monthly-publication-september-2025.pdf | 719 | 2025-09 | Pedestrian | BMW | 1 series | White | Using a Mobile Phone Whilst Driving | None | Vicarage Road, Kings Heath | Vicarage Road, Kings Heath | Birmingham | Birmingham | NFA | No VRM | 52.4301512 | -1.8996659 | ||
| 24600 | op-snap---monthly-publication-september-2025.pdf | 819 | 2025-09 | Car | Audi | A5 | Blue | Using a Mobile Phone Whilst Driving | None | Dudley Road | Dudley Road | Birmingham | Birmingham | NFA | No Offence | 52.4865107 | -1.9386263 | ||
| 24706 | op-snap---monthly-publication-september-2025.pdf | 925 | 2025-09 | Car | Skoda | Black | Using a Mobile Phone Whilst Driving | None | Warwick Road | Warwick Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4555288 | -1.8613929 | |||
| 24845 | op-snap---monthly-publication-september-2025.pdf | 1064 | 2025-09 | Pedestrian | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4702385 | -1.895011 | ||
| 2057 | op-snap---monthly-publication-august-2025.pdf | 32 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | City Road at Rotten Park Road | City Road at Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4763176 | -1.9584897 | ||
| 2196 | op-snap---monthly-publication-august-2025.pdf | 171 | 2025-08 | Other | Renault | unknown | Using a Mobile Phone Whilst Driving | Driving without Due Care and Attention | Kingstanding | Kingstanding | Birmingham | Birmingham | NFA | No VRM | 52.5530147 | -1.8843477 | |||
| 2239 | op-snap---monthly-publication-august-2025.pdf | 214 | 2025-08 | Car | Hyundai | Blue | Using a Mobile Phone Whilst Driving | None | M6 SB 5-4A | M6 Southbound 5-4A | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||
| 2335 | op-snap---monthly-publication-august-2025.pdf | 310 | 2025-08 | Car | Mercedes-Benz | E220 | Black | Using a Mobile Phone Whilst Driving | None | Small Heath highway | Small Heath highway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4709298 | -1.8722585 | ||
| 2344 | op-snap---monthly-publication-august-2025.pdf | 319 | 2025-08 | Pedestrian | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4656414 | -1.9852276 | ||
| 2402 | op-snap---monthly-publication-august-2025.pdf | 377 | 2025-08 | Other | Audi | A6 | Grey | Using a Mobile Phone Whilst Driving | None | Motorway? Unknown | Motorway? Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2487 | op-snap---monthly-publication-august-2025.pdf | 462 | 2025-08 | Pedal Bike | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Essex Street | Essex Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4733232 | -1.8977941 | ||
| 2502 | op-snap---monthly-publication-august-2025.pdf | 477 | 2025-08 | Car | Mercedes-Benz | Black | Using a Mobile Phone Whilst Driving | None | A45 Sheldon | Sheldon | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4533229 | -1.778016 | |||
| 2638 | op-snap---monthly-publication-august-2025.pdf | 613 | 2025-08 | Car | Audi | A6.. | Grey | Using a Mobile Phone Whilst Driving | None | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4883936 | -1.8310056 | ||
| 2794 | op-snap---monthly-publication-august-2025.pdf | 769 | 2025-08 | Pedestrian | Mercedes-Benz | A Class | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 2862 | op-snap---monthly-publication-august-2025.pdf | 837 | 2025-08 | Car | Peugeot | Partner | White | Using a Mobile Phone Whilst Driving | None | St Benedicts Rd | Street Benedicts Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2948 | op-snap---monthly-publication-august-2025.pdf | 923 | 2025-08 | Car | Mercedes-Benz | A160 | White | Using a Mobile Phone Whilst Driving | None | St Saviours Road | Street Saviours Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 3027 | op-snap---monthly-publication-august-2025.pdf | 1002 | 2025-08 | Car | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | New Swan Lane at Gas Street | New Swan Lane at Gas Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 3107 | op-snap---monthly-publication-august-2025.pdf | 1082 | 2025-08 | Car | Toyota | Yaris | Silver | Using a Mobile Phone Whilst Driving | None | Billesley Lane | Billesley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4344402 | -1.8845368 | ||
| 11965 | op-snap---monthly-publication-july-2025.pdf | 17 | 2025-07 | Pedal Bike | Mazda | Three | Black | Using a Mobile Phone Whilst Driving | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4702385 | -1.895011 | ||
| 12118 | op-snap---monthly-publication-july-2025.pdf | 170 | 2025-07 | Pedal Bike | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Newhall Street | Newhall Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4830482 | -1.905069 | ||
| 12205 | op-snap---monthly-publication-july-2025.pdf | 257 | 2025-07 | Pedestrian | Toyota | Corolla | White | Using a Mobile Phone Whilst Driving | None | Stephenson Street | Stephenson Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4787219 | -1.9004997 | ||
| 12255 | op-snap---monthly-publication-july-2025.pdf | 307 | 2025-07 | Pedestrian | Audi | A6 | White | Using a Mobile Phone Whilst Driving | None | Cartland Road | Cartland Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4298554 | -1.9086629 | ||
| 12272 | op-snap---monthly-publication-july-2025.pdf | 324 | 2025-07 | Pedestrian | Honda | FSH125 | White | Using a Mobile Phone Whilst Driving | None | Moore Streer | Moore Streer | Birmingham | Birmingham | NFA | No Offence | ||||
| 12333 | op-snap---monthly-publication-july-2025.pdf | 385 | 2025-07 | Car | Renault | White | Using a Mobile Phone Whilst Driving | None | Burman Road | Burman Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 12350 | op-snap---monthly-publication-july-2025.pdf | 402 | 2025-07 | Pedal Bike | Mitsubishi | Colt | Black | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4943878 | -1.8504211 | ||
| 12374 | op-snap---monthly-publication-july-2025.pdf | 426 | 2025-07 | Pedal Bike | Audi | A3 | White | Using a Mobile Phone Whilst Driving | None | Warwick Road | Warwick Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4555288 | -1.8613929 | ||
| 12376 | op-snap---monthly-publication-july-2025.pdf | 428 | 2025-07 | Pedal Bike | Ford | Fiesta ST | Red | Using a Mobile Phone Whilst Driving | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4374665 | -1.9119895 |
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);