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'}
724 rows where council_area = "Birmingham", month = "2025-07" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 26
- Driving without Due Care and Attention 226
- Cause vehicle to be left in a dangerous position 164
- Contravening a Red Traffic Light 125
- Driving without Reasonable Consideration 51
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 43
- Using a Mobile Phone Whilst Driving 25
- Misc - Non Traffic Offences 14
- Contravene Lane Closure Red X 10
- Stop a vehicle within pelican pedestrian crossing limits 10
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 10
- VRM fails to conform to Regulations 10
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 7
- Drive on hard shoulder 6
- Drive a vehicle other than on the carriageway of a motorway 3
- Driving a vehicle wholly or partly on a footpath 3
- Motor vehicle fail to accord precedence at a pelican crossing 3
- Fail to display front VRM plate 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 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
- Drive / Ride / Lead an animal on a footpath 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
- NFA 286
- Warning Letter 282
- Education 83
- Court 32
- Fixed Penalty 30
- Other Action Taken 6
- RTC - Actioned 5
reporter_transport_mode 1
- Car · 724 ✖
month 1
- 2025-07 · 724 ✖
council_area 1
- Birmingham · 724 ✖
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 12148 | op-snap---monthly-publication-july-2025.pdf | 200 | 2025-07 | Car | Ford | Fiesta | Yellow | Driving without Reasonable Consideration | None | Queen Elizabeth Hospital | Queen Elizabeth Hospital | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4517147 | -1.9423655 | ||
| 12151 | op-snap---monthly-publication-july-2025.pdf | 203 | 2025-07 | Car | Toyota | Aygo | Grey | Contravening a Red Traffic Light | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Education | N/A | 52.5899123 | -1.8057069 | ||
| 12155 | op-snap---monthly-publication-july-2025.pdf | 207 | 2025-07 | Car | Porsche | Black | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | |||
| 12158 | op-snap---monthly-publication-july-2025.pdf | 210 | 2025-07 | Car | Toyota | Aygo | White | Contravening a Red Traffic Light | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Education | N/A | 52.5899123 | -1.8057069 | ||
| 12162 | op-snap---monthly-publication-july-2025.pdf | 214 | 2025-07 | Car | Mercedes-Benz | Sprinter | White | Driving without Reasonable Consideration | None | M6 Southbound approaching Jn6 | M6 Southbound approaching Jn6 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 12163 | op-snap---monthly-publication-july-2025.pdf | 215 | 2025-07 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 12164 | op-snap---monthly-publication-july-2025.pdf | 216 | 2025-07 | Car | Audi | A4... | Black | Driving without Due Care and Attention | None | A452 Pype Hayes | Pype Hayes | Birmingham | Birmingham | Warning Letter | N/A | 52.5275673 | -1.8101068 | ||
| 12170 | op-snap---monthly-publication-july-2025.pdf | 222 | 2025-07 | Car | Audi | A8 | Black | Driving without Due Care and Attention | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | Education | N/A | 52.4762784 | -1.9678366 | ||
| 12173 | op-snap---monthly-publication-july-2025.pdf | 225 | 2025-07 | Car | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5083238 | -1.8332287 | ||
| 12177 | op-snap---monthly-publication-july-2025.pdf | 229 | 2025-07 | Car | Ssangyong taxi | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stetchford Lesiure Centre | Stetchford Lesiure Centre | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 12186 | op-snap---monthly-publication-july-2025.pdf | 238 | 2025-07 | Car | Volkswagen | Polo | Blue | Contravene Lane Closure Red X | None | Morris Road | Morris Road | Birmingham | Birmingham | NFA | No Offence | 52.4953902 | -1.8236361 | ||
| 12188 | op-snap---monthly-publication-july-2025.pdf | 240 | 2025-07 | Car | Toyota | Estima | White | Contravening a Red Traffic Light | None | Morris Road | Morris Road | Birmingham | Birmingham | Education | N/A | 52.4953902 | -1.8236361 | ||
| 12189 | op-snap---monthly-publication-july-2025.pdf | 241 | 2025-07 | Car | Honda | CRV | White | Contravening a Red Traffic Light | None | Bromford lane | Bromford lane | Birmingham | Birmingham | Education | N/A | 52.5083238 | -1.8332287 | ||
| 12194 | op-snap---monthly-publication-july-2025.pdf | 246 | 2025-07 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Highgate Road at Stratford Road | Highgate Road at Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4622664 | -1.8829508 | ||
| 12197 | op-snap---monthly-publication-july-2025.pdf | 249 | 2025-07 | Car | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Wharf Road | Wharf Road | Birmingham | Birmingham | Education | N/A | 52.4075531 | -1.927329 | ||
| 12198 | op-snap---monthly-publication-july-2025.pdf | 250 | 2025-07 | Car | BMW | Grey | Driving without Due Care and Attention | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Warning Letter | N/A | 52.470423 | -1.9304786 | |||
| 12199 | op-snap---monthly-publication-july-2025.pdf | 251 | 2025-07 | Car | Toyota | Police car | White | Driving without Reasonable Consideration | None | Anderton Park Road | Anderton Park Road | Birmingham | Birmingham | NFA | No Offence | 52.4481342 | -1.8776139 | ||
| 12200 | op-snap---monthly-publication-july-2025.pdf | 252 | 2025-07 | Car | Jaguar | XF | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12201 | op-snap---monthly-publication-july-2025.pdf | 253 | 2025-07 | Car | Peugeot | 206 | Grey | Driving without Due Care and Attention | No Insurance | Barn Lane | Barn Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4307492 | -1.8828708 | ||
| 12204 | op-snap---monthly-publication-july-2025.pdf | 256 | 2025-07 | Car | Renault | Clio | Blue | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Court | N/A | 52.4726661 | -1.8769032 | ||
| 12206 | op-snap---monthly-publication-july-2025.pdf | 258 | 2025-07 | Car | Audi | A6... | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12208 | op-snap---monthly-publication-july-2025.pdf | 260 | 2025-07 | Car | Mitsubishi | Outlander | White | Contravening a Red Traffic Light | None | Isloington Row | Isloington Row | Birmingham | Birmingham | Education | N/A | ||||
| 12211 | op-snap---monthly-publication-july-2025.pdf | 263 | 2025-07 | Car | Volvo | Lorry | Red | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5292752 | -1.7618805 | ||
| 12213 | op-snap---monthly-publication-july-2025.pdf | 265 | 2025-07 | Car | BMW | 318.. | White | Driving without Due Care and Attention | None | Bath Row | Bath Row | Birmingham | Birmingham | Warning Letter | N/A | 52.472238 | -1.9127983 | ||
| 12215 | op-snap---monthly-publication-july-2025.pdf | 267 | 2025-07 | Car | Yamaha | MT-07 | Silver | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 12216 | op-snap---monthly-publication-july-2025.pdf | 268 | 2025-07 | Car | Yamaha | Kawasaki ZR750 | Blue | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 12217 | op-snap---monthly-publication-july-2025.pdf | 269 | 2025-07 | Car | BMW | 320 | Black | Contravening a Red Traffic Light | None | Stechford Lane | Stechford Lane | Birmingham | Birmingham | Education | N/A | 52.4930549 | -1.8179571 | ||
| 12220 | op-snap---monthly-publication-july-2025.pdf | 272 | 2025-07 | Car | Toyota | Camry | Grey | Contravening a Red Traffic Light | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Education | N/A | 52.4679402 | -1.881408 | ||
| 12221 | op-snap---monthly-publication-july-2025.pdf | 273 | 2025-07 | Car | Nissan | GT-R | Blue | Driving without Due Care and Attention | None | Rumbush Lane | Rumbush Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 12222 | op-snap---monthly-publication-july-2025.pdf | 274 | 2025-07 | Car | Mitsubishi | Mirage | White | Driving without Due Care and Attention | None | St Mary's Row | Street Mary's Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 12226 | op-snap---monthly-publication-july-2025.pdf | 278 | 2025-07 | Car | Volkswagen | Tiguan | Black | Driving without Due Care and Attention | None | Bradford Road | Bradford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5024148 | -1.7961753 | ||
| 12233 | op-snap---monthly-publication-july-2025.pdf | 285 | 2025-07 | Car | Peugeot | Partner | White | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4656414 | -1.9852276 | ||
| 12234 | op-snap---monthly-publication-july-2025.pdf | 286 | 2025-07 | Car | BMW | X4 | Grey | Driving without Reasonable Consideration | None | Little Bromwich Road | Little Bromwich Road | Birmingham | Birmingham | Education | N/A | 52.4777017 | -1.8246255 | ||
| 12237 | op-snap---monthly-publication-july-2025.pdf | 289 | 2025-07 | Car | Nissan | Black | Contravening a Red Traffic Light | None | Clarence Road | Clarence Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5940902 | -1.843503 | |||
| 12247 | op-snap---monthly-publication-july-2025.pdf | 299 | 2025-07 | Car | Audi | A5 | Black | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5027779 | -1.7982159 | ||
| 12248 | op-snap---monthly-publication-july-2025.pdf | 300 | 2025-07 | Car | Mitsubishi | Colt | Black | Driving without Due Care and Attention | None | Station Road | Station Road | Birmingham | Birmingham | Court | N/A | 52.5054559 | -1.9506109 | ||
| 12250 | op-snap---monthly-publication-july-2025.pdf | 302 | 2025-07 | Car | Audi | A4 | Grey | Driving without Due Care and Attention | None | Collector Road | Collector Road | Birmingham | Birmingham | NFA | No VRM | 52.5139393 | -1.7600186 | ||
| 12260 | op-snap---monthly-publication-july-2025.pdf | 312 | 2025-07 | Car | Toyota | Estima | Black | Driving without Due Care and Attention | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5327447 | -1.899844 | ||
| 12261 | op-snap---monthly-publication-july-2025.pdf | 313 | 2025-07 | Car | Volkswagen | Transporter | Blue | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Education | N/A | 52.471632 | -1.9456776 |
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);