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'}
1,200 rows where council_area = "Birmingham" and month = "2025-07" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: second_offence, nfa_rationale
vehicle_make >30
offence 26
- Cause vehicle to be left in a dangerous position 330
- Driving without Due Care and Attention 321
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 137
- Contravening a Red Traffic Light 135
- Using a Mobile Phone Whilst Driving 91
- Driving without Reasonable Consideration 70
- Misc - Non Traffic Offences 24
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 13
- Stop a vehicle within pelican pedestrian crossing limits 13
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 12
- Contravene Lane Closure Red X 11
- VRM fails to conform to Regulations 10
- Drive on hard shoulder 6
- Driving a vehicle wholly or partly on a footpath 4
- Drive / Ride / Lead an animal on a footpath 3
- Drive a vehicle other than on the carriageway of a motorway 3
- Motor vehicle fail to accord precedence at a pelican crossing 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Fail to display front VRM plate 2
- Prohibited vehicle in offside lane of motorway 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Dangerous Driving 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- No Seat Belt 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- Vehicle overtake within crossing limits 1
disposal 7
- Warning Letter 526
- NFA 442
- Education 100
- Fixed Penalty 81
- Court 38
- Other Action Taken 8
- RTC - Actioned 5
reporter_transport_mode 6
- Car 724
- Pedestrian 295
- Pedal Bike 154
- Other 24
- Motorbike 2
- Lorry 1
month 1
- 2025-07 · 1,200 ✖
council_area 1
- Birmingham · 1,200 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11948 | op-snap---monthly-publication-july-2025.pdf | 0 | 2025-07 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Russell Road | Russell Road | Birmingham | Birmingham | NFA | No Offence | 52.4398245 | -1.8469786 | ||
| 11949 | op-snap---monthly-publication-july-2025.pdf | 1 | 2025-07 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Airport WAY | Airport WAY | Birmingham | Birmingham | Education | N/A | ||||
| 11952 | op-snap---monthly-publication-july-2025.pdf | 4 | 2025-07 | Car | Volvo | XC40 | Blue | Driving without Due Care and Attention | None | Metcheley Lane | Metcheley Lane | Birmingham | Birmingham | Court | N/A | ||||
| 11954 | op-snap---monthly-publication-july-2025.pdf | 6 | 2025-07 | Car | Nissan | NP | Black | Contravening a Red Traffic Light | None | Nechells Parkway | Nechells Parkway | Birmingham | Birmingham | NFA | No VRM | 52.4922722 | -1.8711754 | ||
| 11955 | op-snap---monthly-publication-july-2025.pdf | 7 | 2025-07 | Car | Seat | Ateca | Grey | Contravening a Red Traffic Light | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Education | N/A | 52.4220705 | -1.8372335 | ||
| 11957 | op-snap---monthly-publication-july-2025.pdf | 9 | 2025-07 | Car | Volkswagen | Passat | Grey | Contravene Lane Closure Red X | None | Robin Hood Islland | Robin Hood Islland | Birmingham | Birmingham | Education | N/A | ||||
| 11958 | op-snap---monthly-publication-july-2025.pdf | 10 | 2025-07 | Car | Toyota | Auris | Blue | Driving without Due Care and Attention | No Insurance | KIngs Road | KIngs Road | Birmingham | Birmingham | Court | N/A | 52.5531351 | -1.8852761 | ||
| 11960 | op-snap---monthly-publication-july-2025.pdf | 12 | 2025-07 | Pedal Bike | Vauxhall | Zafira | Black | Driving without Due Care and Attention | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4762784 | -1.9678366 | ||
| 11962 | op-snap---monthly-publication-july-2025.pdf | 14 | 2025-07 | Car | Nissan | Micra | Red | Driving without Reasonable Consideration | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4470686 | -1.8880749 | ||
| 11963 | op-snap---monthly-publication-july-2025.pdf | 15 | 2025-07 | Car | Kia | Black | Contravening a Red Traffic Light | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4520441 | -1.8787544 | |||
| 11964 | op-snap---monthly-publication-july-2025.pdf | 16 | 2025-07 | Car | Peugeot | White | Contravening a Red Traffic Light | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4745488 | -1.8065911 | |||
| 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 | ||
| 11966 | op-snap---monthly-publication-july-2025.pdf | 18 | 2025-07 | Car | Ford | Galaxy | Grey | Contravening a Red Traffic Light | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 11967 | op-snap---monthly-publication-july-2025.pdf | 19 | 2025-07 | Pedestrian | Seat | Leon | Blue | Driving without Due Care and Attention | None | Heath Road South | Heath Road South | Birmingham | Birmingham | NFA | No VRM | 52.415858 | -1.9632649 | ||
| 11968 | op-snap---monthly-publication-july-2025.pdf | 20 | 2025-07 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Harborne Lane | Harborne Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468464 | -1.9454816 | ||
| 11969 | op-snap---monthly-publication-july-2025.pdf | 21 | 2025-07 | Car | Skoda | Kamiq | White | Contravening a Red Traffic Light | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | NFA | No Offence | 52.4221526 | -1.8425617 | ||
| 11970 | op-snap---monthly-publication-july-2025.pdf | 22 | 2025-07 | Car | Seat | Leon | Silver | Contravening a Red Traffic Light | None | Amesbury Road | Amesbury Road | Birmingham | Birmingham | Education | N/A | 52.4465507 | -1.8957752 | ||
| 11972 | op-snap---monthly-publication-july-2025.pdf | 24 | 2025-07 | Car | Volkswagen | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | |||
| 11980 | op-snap---monthly-publication-july-2025.pdf | 32 | 2025-07 | Car | Mercedes-Benz | A Class | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 11987 | op-snap---monthly-publication-july-2025.pdf | 39 | 2025-07 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.471632 | -1.9456776 | ||
| 11992 | op-snap---monthly-publication-july-2025.pdf | 44 | 2025-07 | Pedal Bike | Kia | Rio | Silver | Driving without Due Care and Attention | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5113867 | -1.8337258 | ||
| 11993 | op-snap---monthly-publication-july-2025.pdf | 45 | 2025-07 | Pedal Bike | Volkswagen | Caddy | White | Using a Mobile Phone Whilst Driving | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4749336 | -1.9003475 | ||
| 11995 | op-snap---monthly-publication-july-2025.pdf | 47 | 2025-07 | Car | Mercedes-Benz | Grey | Driving without Due Care and Attention | None | Rocky Lane | Rocky Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5285859 | -1.9100513 | |||
| 11996 | op-snap---monthly-publication-july-2025.pdf | 48 | 2025-07 | Car | Seat | Red | Driving without Due Care and Attention | None | Rabone Lane | Rabone Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4998908 | -1.952631 | |||
| 11997 | op-snap---monthly-publication-july-2025.pdf | 49 | 2025-07 | Car | Volkswagen | Golf | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Heybarnes Road | Heybarnes Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4677423 | -1.8351236 | ||
| 11998 | op-snap---monthly-publication-july-2025.pdf | 50 | 2025-07 | Car | Peugeot | 308 | White | Contravening a Red Traffic Light | None | Crocketts Lane | Crocketts Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 11999 | op-snap---monthly-publication-july-2025.pdf | 51 | 2025-07 | Pedal Bike | Toyota | Yaris | Silver | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 12003 | op-snap---monthly-publication-july-2025.pdf | 55 | 2025-07 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 12004 | op-snap---monthly-publication-july-2025.pdf | 56 | 2025-07 | Pedal Bike | Kia | Sportage | Grey | Driving without Reasonable Consideration | None | Ridgacre Road | Ridgacre Road | Birmingham | Birmingham | Education | N/A | 52.4593367 | -2.0000298 | ||
| 12005 | op-snap---monthly-publication-july-2025.pdf | 57 | 2025-07 | Pedal Bike | Ford | Transit | White | Contravening a Red Traffic Light | None | Harborne Road | Harborne Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4718503 | -1.9195423 | ||
| 12008 | op-snap---monthly-publication-july-2025.pdf | 60 | 2025-07 | Car | Nissan | Qashqai | Blue | Contravening a Red Traffic Light | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 12011 | op-snap---monthly-publication-july-2025.pdf | 63 | 2025-07 | Pedal Bike | Mini | Cooper | White | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 12012 | op-snap---monthly-publication-july-2025.pdf | 64 | 2025-07 | Pedal Bike | Hyundai | Ioniq 5 | Blue | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 12015 | op-snap---monthly-publication-july-2025.pdf | 67 | 2025-07 | Pedal Bike | Ford | Focus | Blue | Using a Mobile Phone Whilst Driving | None | Winchester Drive, Chelmsley Wood | Winchester Drive, Chelmsley Wood | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 12016 | op-snap---monthly-publication-july-2025.pdf | 68 | 2025-07 | Car | Volkswagen | Polo | Red | Driving without Due Care and Attention | None | Berners Street | Berners Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5014952 | -1.9055936 | ||
| 12017 | op-snap---monthly-publication-july-2025.pdf | 69 | 2025-07 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | M5 NB J3-J2 | M5 Northbound J3-J2 | Birmingham | Birmingham | Court | N/A | 52.4846642 | -1.9297585 | ||
| 12021 | op-snap---monthly-publication-july-2025.pdf | 73 | 2025-07 | Car | Seat | Leon | Blue | Driving without Due Care and Attention | None | Small Heath Bridge | Small Heath Bridge | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4675008 | -1.8693303 | ||
| 12027 | op-snap---monthly-publication-july-2025.pdf | 79 | 2025-07 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4203897 | -1.8338574 | ||
| 12032 | op-snap---monthly-publication-july-2025.pdf | 84 | 2025-07 | Car | Toyota | Yaris | White | Driving without Due Care and Attention | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Court | N/A | 52.4967329 | -1.8097462 | ||
| 12033 | op-snap---monthly-publication-july-2025.pdf | 85 | 2025-07 | Car | Seat | Ateca | White | Driving without Due Care and Attention | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Court | N/A | 52.4967329 | -1.8097462 | ||
| 12037 | op-snap---monthly-publication-july-2025.pdf | 89 | 2025-07 | Car | Hyundai | I20 | Grey | Driving without Due Care and Attention | None | SHardend Crescent | SHardend Crescent | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 12039 | op-snap---monthly-publication-july-2025.pdf | 91 | 2025-07 | Motorbike | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5919543 | -1.8517118 | ||
| 12045 | op-snap---monthly-publication-july-2025.pdf | 97 | 2025-07 | Car | BMW | 3 Series | Blue | Contravening a Red Traffic Light | None | Duddeston Mill Road | Duddeston Mill Road | Birmingham | Birmingham | Court | N/A | 52.4884042 | -1.8688885 | ||
| 12046 | op-snap---monthly-publication-july-2025.pdf | 98 | 2025-07 | Car | Volkswagen | Golf | Blue | Contravening a Red Traffic Light | None | Newtown Middleway | Newtown Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4922617 | -1.8912734 | ||
| 12049 | op-snap---monthly-publication-july-2025.pdf | 101 | 2025-07 | Pedal Bike | BMW | 320d | Black | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Court | N/A | 52.5292752 | -1.7618805 | ||
| 12050 | op-snap---monthly-publication-july-2025.pdf | 102 | 2025-07 | Car | Mercedes-Benz | C300 | Black | Driving without Due Care and Attention | None | Broad Street | Broad Street | Birmingham | Birmingham | Court | N/A | 52.4749212 | -1.9147497 | ||
| 12051 | op-snap---monthly-publication-july-2025.pdf | 103 | 2025-07 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Bristol Street | Bristol Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4691145 | -1.9003257 | ||
| 12052 | op-snap---monthly-publication-july-2025.pdf | 104 | 2025-07 | Car | Volkswagen | Golf R | Black | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4282602 | -1.9861769 | ||
| 12053 | op-snap---monthly-publication-july-2025.pdf | 105 | 2025-07 | Car | Audi | RS3 | Blue | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4282602 | -1.9861769 | ||
| 12054 | op-snap---monthly-publication-july-2025.pdf | 106 | 2025-07 | Pedal Bike | Omoda | 5 Noble | Black | Using a Mobile Phone Whilst Driving | none | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4760986 | -1.9018641 | ||
| 12055 | op-snap---monthly-publication-july-2025.pdf | 107 | 2025-07 | Pedal Bike | Vauxhall | Astra | White | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 12056 | op-snap---monthly-publication-july-2025.pdf | 108 | 2025-07 | Pedal Bike | Hyundai | I20 | White | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 12057 | op-snap---monthly-publication-july-2025.pdf | 109 | 2025-07 | Pedal Bike | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 12059 | op-snap---monthly-publication-july-2025.pdf | 111 | 2025-07 | Pedal Bike | BMW | 4 series | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 12060 | op-snap---monthly-publication-july-2025.pdf | 112 | 2025-07 | Car | Mercedes-Benz | A 180.. | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bell Lane | Bell Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4178465 | -1.968864 | ||
| 12061 | op-snap---monthly-publication-july-2025.pdf | 113 | 2025-07 | Car | Alfa Romeo | Polo | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4816806 | -1.8788939 | ||
| 12063 | op-snap---monthly-publication-july-2025.pdf | 115 | 2025-07 | Pedestrian | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 12066 | op-snap---monthly-publication-july-2025.pdf | 118 | 2025-07 | Car | Corsa | Grey | Contravening a Red Traffic Light | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | |||
| 12068 | op-snap---monthly-publication-july-2025.pdf | 120 | 2025-07 | Car | Mercedes-Benz | E220 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Edward Road | Edward Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4580901 | -1.894458 | ||
| 12070 | op-snap---monthly-publication-july-2025.pdf | 122 | 2025-07 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 12072 | op-snap---monthly-publication-july-2025.pdf | 124 | 2025-07 | Car | Volvo | V40.. | Grey | Driving without Due Care and Attention | None | East Midway | East Midway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 12073 | op-snap---monthly-publication-july-2025.pdf | 125 | 2025-07 | Pedal Bike | Vauxhall | astra | Red | Driving without Due Care and Attention | None | Forest Road | Forest Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4467275 | -1.8804014 | ||
| 12075 | op-snap---monthly-publication-july-2025.pdf | 127 | 2025-07 | Other | Hyundai | Tucson | White | Cause vehicle to be left in a dangerous position | None | Institute Road | Institute Road | Birmingham | Birmingham | NFA | No Offence | 52.4334781 | -1.8892337 | ||
| 12076 | op-snap---monthly-publication-july-2025.pdf | 128 | 2025-07 | Other | Mercedes-Benz | C class | Blue | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5054363 | -1.8556273 | ||
| 12081 | op-snap---monthly-publication-july-2025.pdf | 133 | 2025-07 | Car | Volkswagen | Caddy | White | Using a Mobile Phone Whilst Driving | None | Edenhurst Road | Edenhurst Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.393221 | -1.978614 | ||
| 12082 | op-snap---monthly-publication-july-2025.pdf | 134 | 2025-07 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 12083 | op-snap---monthly-publication-july-2025.pdf | 135 | 2025-07 | Car | Mercedes-Benz | GLA | Black | Contravening a Red Traffic Light | None | Amesbury Road | Amesbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4465507 | -1.8957752 | ||
| 12085 | op-snap---monthly-publication-july-2025.pdf | 137 | 2025-07 | Car | Honda | jazz | Blue | Driving without Reasonable Consideration | None | Shenley Fields Road | Shenley Fields Road | Birmingham | Birmingham | NFA | No Offence | 52.4373076 | -1.9543847 | ||
| 12086 | op-snap---monthly-publication-july-2025.pdf | 138 | 2025-07 | Pedal Bike | BMW | 320i | Silver | Using a Mobile Phone Whilst Driving | None | Granville Street | Granville Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762076 | -1.9124263 | ||
| 12088 | op-snap---monthly-publication-july-2025.pdf | 140 | 2025-07 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4816806 | -1.8788939 | ||
| 12089 | op-snap---monthly-publication-july-2025.pdf | 141 | 2025-07 | Pedal Bike | BMW | 120.. | Grey | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 12090 | op-snap---monthly-publication-july-2025.pdf | 142 | 2025-07 | Pedal Bike | Vauxhall | Zafira | Black | Using a Mobile Phone Whilst Driving | None | Metchley Road | Metchley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4527174 | -1.9590253 | ||
| 12091 | op-snap---monthly-publication-july-2025.pdf | 143 | 2025-07 | Car | Mg | ZS | Black | Driving without Due Care and Attention | None | A4540 Bordesley Middleway | Bordesley Middleway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4704236 | -1.8769606 | ||
| 12093 | op-snap---monthly-publication-july-2025.pdf | 145 | 2025-07 | Pedal Bike | BMW | 330e | Blue | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 12095 | op-snap---monthly-publication-july-2025.pdf | 147 | 2025-07 | Car | BMW | x6 | White | Contravening a Red Traffic Light | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Education | N/A | 52.4709298 | -1.8722585 | ||
| 12096 | op-snap---monthly-publication-july-2025.pdf | 148 | 2025-07 | Car | Vauxhall | Insignia | Red | Driving without Due Care and Attention | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5327447 | -1.899844 | ||
| 12099 | op-snap---monthly-publication-july-2025.pdf | 151 | 2025-07 | Pedestrian | Nissan | Juke | Red | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4622646 | -1.8599985 | ||
| 12100 | op-snap---monthly-publication-july-2025.pdf | 152 | 2025-07 | Pedal Bike | Skoda | Kamiq | White | Driving without Reasonable Consideration | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Court | N/A | 52.5113867 | -1.8337258 | ||
| 12101 | op-snap---monthly-publication-july-2025.pdf | 153 | 2025-07 | Car | Hyundai | I40 | Black | Driving a vehicle wholly or partly on a footpath | None | Grove Lane | Grove Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5055208 | -1.9328067 | ||
| 12104 | op-snap---monthly-publication-july-2025.pdf | 156 | 2025-07 | Car | Land Rover | Sport | Blue | Drive a vehicle other than on the carriageway of a motorway | None | M6 SB J6 | M6 Southbound J6 | Birmingham | Birmingham | Education | N/A | 52.676119 | -2.0858425 | ||
| 12108 | op-snap---monthly-publication-july-2025.pdf | 160 | 2025-07 | Car | Seat | Leon | Black | Contravening a Red Traffic Light | None | Shenley Fields Road | Shenley Fields Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4373076 | -1.9543847 | ||
| 12109 | op-snap---monthly-publication-july-2025.pdf | 161 | 2025-07 | Car | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | East meadway | East meadway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4813031 | -1.7670825 | ||
| 12111 | op-snap---monthly-publication-july-2025.pdf | 163 | 2025-07 | Car | BMW | 3 SERIES | Grey | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5517052 | -1.7825505 | ||
| 12112 | op-snap---monthly-publication-july-2025.pdf | 164 | 2025-07 | Car | Toyota | Prius | Black | Contravene Lane Closure Red X | None | A38M | A38M | Birmingham | Birmingham | Court | N/A | ||||
| 12116 | op-snap---monthly-publication-july-2025.pdf | 168 | 2025-07 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 12117 | op-snap---monthly-publication-july-2025.pdf | 169 | 2025-07 | Pedal Bike | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Lionel Street | Lionel Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4821516 | -1.9058355 | ||
| 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 | ||
| 12120 | op-snap---monthly-publication-july-2025.pdf | 172 | 2025-07 | Pedestrian | Cupra | Ateca | Grey | Driving without Reasonable Consideration | None | M6 South Birmingham | M6 South Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4031308 | -2.0142003 | ||
| 12122 | op-snap---monthly-publication-july-2025.pdf | 174 | 2025-07 | Car | Vauxhall | Corsa | Gold | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 12123 | op-snap---monthly-publication-july-2025.pdf | 175 | 2025-07 | Car | Volkswagen | T-Roc | Black | Driving without Due Care and Attention | None | Garretts Green Lane | Garretts Green Lane | Birmingham | Birmingham | Court | N/A | 52.4675802 | -1.7905748 | ||
| 12125 | op-snap---monthly-publication-july-2025.pdf | 177 | 2025-07 | Pedal Bike | Audi | Q5 | Blue | Driving without Due Care and Attention | None | Bookvale Road | Bookvale Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 12126 | op-snap---monthly-publication-july-2025.pdf | 178 | 2025-07 | Pedal Bike | Citroen | C3 | Blue | Driving without Due Care and Attention | None | City Road | City Road | Birmingham | Birmingham | NFA | No Offence | 52.4763176 | -1.9584897 | ||
| 12128 | op-snap---monthly-publication-july-2025.pdf | 180 | 2025-07 | Car | Skoda | Elroq | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Road | Church Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4624743 | -1.7763934 | ||
| 12130 | op-snap---monthly-publication-july-2025.pdf | 182 | 2025-07 | Pedal Bike | Skoda | Black | Driving without Due Care and Attention | None | Witton Road, Witton Lane | Witton Road, Witton Lane | Birmingham | Birmingham | NFA | No VRM | |||||
| 12132 | op-snap---monthly-publication-july-2025.pdf | 184 | 2025-07 | Pedal Bike | Daf | White | Driving without Due Care and Attention | None | Gooch st at Bissell St | Gooch st at Bissell Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4696234 | -1.8952392 | |||
| 12133 | op-snap---monthly-publication-july-2025.pdf | 185 | 2025-07 | Pedal Bike | Volvo | Bus | Red | Driving without Due Care and Attention | None | Moorend Avenue | Moorend Avenue | Birmingham | Birmingham | NFA | No Offence | ||||
| 12137 | op-snap---monthly-publication-july-2025.pdf | 189 | 2025-07 | Pedal Bike | Renault | Captur | Blue | Using a Mobile Phone Whilst Driving | None | Winchester Road | Winchester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5111504 | -1.8987154 | ||
| 12138 | op-snap---monthly-publication-july-2025.pdf | 190 | 2025-07 | Pedal Bike | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 12141 | op-snap---monthly-publication-july-2025.pdf | 193 | 2025-07 | Car | BMW | M2 | Blue | Driving without Due Care and Attention | None | Kingshurst Way | Kingshurst Way | Birmingham | Birmingham | Court | N/A | ||||
| 12147 | op-snap---monthly-publication-july-2025.pdf | 199 | 2025-07 | Car | Mg | HS | Red | Driving without Due Care and Attention | None | Maypole Lane | Maypole Lane | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4046925 | -1.8764112 |
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);