reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

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'}

169 rows where council_area = "Birmingham", month = "2025-12" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 5

offence 1

  • Driving without Due Care and Attention · 169 ✖

month 1

  • 2025-12 · 169 ✖

council_area 1

  • Birmingham · 169 ✖
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
3874 op-snap---monthly-publication-december-2025.pdf   2 2025-12 Car Volvo Exc30 Blue Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
3875 op-snap---monthly-publication-december-2025.pdf   3 2025-12 Car Vauxhall Astra Grey Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham NFA No Independent Evidence Available   52.4304526 -1.9216716
3876 op-snap---monthly-publication-december-2025.pdf   4 2025-12 Pedestrian Toyota Corolla Silver Driving without Due Care and Attention None New John Street New John Street Birmingham Birmingham Other Action Taken No Independent Evidence Available   52.4920451 -1.8920402
3886 op-snap---monthly-publication-december-2025.pdf   14 2025-12 Car   Caetano White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
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
3919 op-snap---monthly-publication-december-2025.pdf   47 2025-12 Car Vauxhall Astra White Driving without Due Care and Attention None Chruch Lane Chruch Lane Birmingham Birmingham NFA No Offence      
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
3922 op-snap---monthly-publication-december-2025.pdf   50 2025-12 Car Nissan Qashqai Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
3983 op-snap---monthly-publication-december-2025.pdf   111 2025-12 Car Mercedes-Benz A35 White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
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
3989 op-snap---monthly-publication-december-2025.pdf   117 2025-12 Car Mercedes-Benz C220 White Driving without Due Care and Attention None Lodge Road Lodge Road Birmingham Birmingham NFA No Independent Evidence Available   52.5072626 -1.8935604
3996 op-snap---monthly-publication-december-2025.pdf   124 2025-12 Car Mercedes-Benz AMG Grey Driving without Due Care and Attention No Insurance High Street Kings Heath High Street Kings Heath Birmingham Birmingham Court N/A   52.4375456 -1.8926849
4005 op-snap---monthly-publication-december-2025.pdf   133 2025-12 Car Renault Capture Red Driving without Due Care and Attention None Shenley Fields Road Shenley Fields Road Birmingham Birmingham NFA No Independent Evidence Available   52.4373076 -1.9543847
4006 op-snap---monthly-publication-december-2025.pdf   134 2025-12 Car Volkswagen Polo Black Driving without Due Care and Attention None M42 M42 Birmingham Birmingham NFA No Independent Evidence Available      
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
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
4032 op-snap---monthly-publication-december-2025.pdf   160 2025-12 Car BMW 1 Series Silver Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham NFA No Independent Evidence Available   52.502683 -1.9033516
4033 op-snap---monthly-publication-december-2025.pdf   161 2025-12 Car Iveco HGV White Driving without Due Care and Attention None M5 Northbound M5 Northbound Birmingham Birmingham NFA Not in Public Interest      
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
4062 op-snap---monthly-publication-december-2025.pdf   190 2025-12 Other Audi A5 Black Driving without Due Care and Attention None Gopsal Street Gopsal Street Birmingham Birmingham Court N/A   52.4837913 -1.8822888
4064 op-snap---monthly-publication-december-2025.pdf   192 2025-12 Other Volkswagen Caddy White Driving without Due Care and Attention None Gravelly HIll Gravelly HIll Birmingham Birmingham NFA No Independent Evidence Available   52.5153884 -1.8527437
4065 op-snap---monthly-publication-december-2025.pdf   193 2025-12 Car Ford Transit Blue Driving without Due Care and Attention None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
4067 op-snap---monthly-publication-december-2025.pdf   195 2025-12 Car Skoda Octivia White Driving without Due Care and Attention None A45 A45 Birmingham Birmingham NFA No VRM      
4068 op-snap---monthly-publication-december-2025.pdf   196 2025-12 Car Mercedes-Benz A-Class Black Driving without Due Care and Attention None Hubert Road Hubert Road Birmingham Birmingham NFA No Independent Evidence Available   52.4395644 -1.9305389
4070 op-snap---monthly-publication-december-2025.pdf   198 2025-12 Pedestrian Volkswagen Passatt Blue Driving without Due Care and Attention None Glenville Drivce Glenville Drivce Birmingham Birmingham NFA No Independent Evidence Available      
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
4088 op-snap---monthly-publication-december-2025.pdf   216 2025-12 Car Mercedes-Benz c250 Black Driving without Due Care and Attention None Shaftmoor Lane Shaftmoor Lane Birmingham Birmingham Court N/A   52.4418944 -1.8407335
4090 op-snap---monthly-publication-december-2025.pdf   218 2025-12 Car Peugeot 3008.. Grey Driving without Due Care and Attention None Birmingham Fort Parkway Birmingham Fort Parkway Birmingham Birmingham Court N/A   52.5084571 -1.8214016
4094 op-snap---monthly-publication-december-2025.pdf   222 2025-12 Car Seat Ibiza Grey Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
4095 op-snap---monthly-publication-december-2025.pdf   223 2025-12 Car Nissan Qashqai White Driving without Due Care and Attention none Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
4096 op-snap---monthly-publication-december-2025.pdf   224 2025-12 Car Mercedes-Benz GLE Blue Driving without Due Care and Attention None Marsh Hill Marsh Hill Birmingham Birmingham Education N/A   52.5246617 -1.8687505
4097 op-snap---monthly-publication-december-2025.pdf   225 2025-12 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Station Road, Stechford Station Road, Stechford Birmingham Birmingham Education N/A   52.480771 -1.8086714
4098 op-snap---monthly-publication-december-2025.pdf   226 2025-12 Car Ford Ranger Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
4103 op-snap---monthly-publication-december-2025.pdf   231 2025-12 Car Hyundai Kona Grey Driving without Due Care and Attention None Beeches Road Beeches Road Birmingham Birmingham NFA No Independent Evidence Available   52.5394371 -1.9087331
4105 op-snap---monthly-publication-december-2025.pdf   233 2025-12 Car Kia Niro.. Black Driving without Due Care and Attention None Hawthorn Road Hawthorn Road Birmingham Birmingham Warning Letter N/A   52.5436609 -1.8214668
4108 op-snap---monthly-publication-december-2025.pdf   236 2025-12 Car Volvo Coach White Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Fixed Penalty N/A   52.4668753 -1.8996143
4109 op-snap---monthly-publication-december-2025.pdf   237 2025-12 Car Volkswagen Golf Grey Driving without Due Care and Attention None Bentley Lane Bentley Lane Birmingham Birmingham Fixed Penalty N/A      
4111 op-snap---monthly-publication-december-2025.pdf   239 2025-12 Car Volkswagen   Black Driving without Due Care and Attention None Fort Retail Shopping Centre Fort Retail Shopping Centre Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
4113 op-snap---monthly-publication-december-2025.pdf   241 2025-12 Car Daf HGV White Driving without Due Care and Attention None M6 SB, approaching Jn7 M6 Southbound, approaching Jn7 Birmingham Birmingham NFA No Offence      
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
4119 op-snap---monthly-publication-december-2025.pdf   247 2025-12 Car Seat Leon Grey Driving without Due Care and Attention None Buckland End Lane Buckland End Lane Birmingham Birmingham Court N/A      
4136 op-snap---monthly-publication-december-2025.pdf   264 2025-12 Car Nissan Micra Blue Driving without Due Care and Attention None Salford Circus Salford Circus Birmingham Birmingham NFA No Offence   52.5095071 -1.8593732
4137 op-snap---monthly-publication-december-2025.pdf   265 2025-12 Car Cupra Ateca Grey Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Fixed Penalty N/A   52.5368764 -1.8976461
4151 op-snap---monthly-publication-december-2025.pdf   279 2025-12 Car Lexus Lexus Silver Driving without Due Care and Attention None Castle Vale Castle Vale Birmingham Birmingham Warning Letter N/A   52.5212593 -1.7845494
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
4159 op-snap---monthly-publication-december-2025.pdf   287 2025-12 Car Nissan Qashqai White Driving without Due Care and Attention None Icknield Street Icknield Street Birmingham Birmingham Education N/A   52.5709191 -1.8759339
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      
4179 op-snap---monthly-publication-december-2025.pdf   307 2025-12 Other BMW 330E White Driving without Due Care and Attention None Metchley Lane Metchley Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4552055 -1.9461279
4180 op-snap---monthly-publication-december-2025.pdf   308 2025-12 Car Hyundai Kona Grey Driving without Due Care and Attention None Beeches Rd Beeches Road Birmingham Birmingham NFA No Independent Evidence Available   52.5394371 -1.9087331
4182 op-snap---monthly-publication-december-2025.pdf   310 2025-12 Car BMW 316 Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
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
4185 op-snap---monthly-publication-december-2025.pdf   313 2025-12 Car Renault Traffic White Driving without Due Care and Attention None Darthmouth middleway Darthmouth middleway Birmingham Birmingham Education N/A      
4186 op-snap---monthly-publication-december-2025.pdf   314 2025-12 Car Volvo XC90 Blue Driving without Due Care and Attention No Insurance Richmond Road Richmond Road Birmingham Birmingham Court N/A   52.566947 -1.8291809
4190 op-snap---monthly-publication-december-2025.pdf   318 2025-12 Car Peugeot 208 Black Driving without Due Care and Attention None A38 Aston Expressway Aston Expressway Birmingham Birmingham Court N/A   52.493793 -1.8881773
4249 op-snap---monthly-publication-december-2025.pdf   377 2025-12 Car Skoda Octavia Grey Driving without Due Care and Attention None Tile Cross Road at Cooks Lane Tile Cross Road at Cooks Lane Birmingham Birmingham Fixed Penalty N/A   52.4733145 -1.7662713
4263 op-snap---monthly-publication-december-2025.pdf   391 2025-12 Car Nissan Juke Blue Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Warning Letter N/A   52.4216321 -1.855984
4264 op-snap---monthly-publication-december-2025.pdf   392 2025-12 Car Skoda Octavia White Driving without Due Care and Attention None Arden Oak Road Arden Oak Road Birmingham Birmingham Warning Letter N/A   52.4533929 -1.7703309
4270 op-snap---monthly-publication-december-2025.pdf   398 2025-12 Car Volkswagen Golf White Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Fixed Penalty N/A   52.4103191 -1.8670224
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
4305 op-snap---monthly-publication-december-2025.pdf   433 2025-12 Car Seat Leon Silver Driving without Due Care and Attention None A452 A452 Birmingham Birmingham Warning Letter N/A      
4307 op-snap---monthly-publication-december-2025.pdf   435 2025-12 Car Volkswagen Golf Blue Driving without Due Care and Attention None Longbridge Lane Longbridge Lane Birmingham Birmingham Court N/A   52.3962003 -1.9821252
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
4319 op-snap---monthly-publication-december-2025.pdf   447 2025-12 Car Toyota   White Driving without Due Care and Attention None M6 M6 Birmingham Birmingham RTC - Actioned N/A      
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      
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
4334 op-snap---monthly-publication-december-2025.pdf   462 2025-12 Car Toyota prius Black Driving without Due Care and Attention None startford road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
4335 op-snap---monthly-publication-december-2025.pdf   463 2025-12 Car Mercedes-Benz sprinter White Driving without Due Care and Attention None startfrod road Startfrod Road Birmingham Birmingham NFA No VRM      
4351 op-snap---monthly-publication-december-2025.pdf   479 2025-12 Car Volvo V40.. Blue Driving without Due Care and Attention None Greenholm Road Greenholm Road Birmingham Birmingham Court N/A   52.5356973 -1.8929646
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
4381 op-snap---monthly-publication-december-2025.pdf   509 2025-12 Car Suzuki Swace White Driving without Due Care and Attention None Garrison Circus Garrison Circus Birmingham Birmingham NFA No Independent Evidence Available   52.4794658 -1.8762374
4383 op-snap---monthly-publication-december-2025.pdf   511 2025-12 Car Land Rover Range Rover Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
4392 op-snap---monthly-publication-december-2025.pdf   520 2025-12 Car Peugeot Speedight Green Driving without Due Care and Attention No Insurance Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
4398 op-snap---monthly-publication-december-2025.pdf   526 2025-12 Car Audi A4 Silver Driving without Due Care and Attention None Hunters Road Hunters Road Birmingham Birmingham Warning Letter N/A   52.5011362 -1.9175837
4399 op-snap---monthly-publication-december-2025.pdf   527 2025-12 Car Mercedes-Benz a-class Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
4400 op-snap---monthly-publication-december-2025.pdf   528 2025-12 Car Mercedes-Benz a-class White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
4401 op-snap---monthly-publication-december-2025.pdf   529 2025-12 Car Mercedes-Benz C Class Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
4402 op-snap---monthly-publication-december-2025.pdf   530 2025-12 Car Volkswagen Crafter White Driving without Due Care and Attention None Small Heath Highway Small Heath Highway Birmingham Birmingham Court N/A   52.4709298 -1.8722585
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      
4431 op-snap---monthly-publication-december-2025.pdf   559 2025-12 Car Volkswagen Arteon Blue Driving without Due Care and Attention None Newport Road, Castle Bromwich Newport Road, Castle Bromwich Birmingham Birmingham Court N/A      
4432 op-snap---monthly-publication-december-2025.pdf   560 2025-12 Car BMW 3 Series Grey Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham NFA No Offence   52.5148331 -1.79231
4448 op-snap---monthly-publication-december-2025.pdf   576 2025-12 Car Kia Ceed Red Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
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
4464 op-snap---monthly-publication-december-2025.pdf   592 2025-12 Car Land Rover Range Grey Driving without Due Care and Attention No Insurance Garrision Lane Garrision Lane Birmingham Birmingham Other Action Taken Misc Inc Crimes      
4467 op-snap---monthly-publication-december-2025.pdf   595 2025-12 Car Citroen Berlingo Green Driving without Due Care and Attention None Longbridge Lane Longbridge Lane Birmingham Birmingham Warning Letter N/A   52.3962003 -1.9821252
4469 op-snap---monthly-publication-december-2025.pdf   597 2025-12 Car Volkswagen Polo Silver Driving without Due Care and Attention None Forest Road Forest Road Birmingham Birmingham Fixed Penalty N/A   52.4467275 -1.8804014
4474 op-snap---monthly-publication-december-2025.pdf   602 2025-12 Car BMW ! Series Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Birmingham Birmingham Fixed Penalty N/A   52.5012458 -1.8780942
4498 op-snap---monthly-publication-december-2025.pdf   626 2025-12 Car Mercedes-Benz GLE Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
4506 op-snap---monthly-publication-december-2025.pdf   634 2025-12 Car BMW 520 Grey Driving without Due Care and Attention None Motorway but are u/K Motorway but are u/K Birmingham Birmingham NFA No Independent Evidence Available      
4513 op-snap---monthly-publication-december-2025.pdf   641 2025-12 Pedestrian Yamaha GPD125 Blue Driving without Due Care and Attention None bishopsgate street Bishopsgate Street Birmingham Birmingham Education N/A   52.473986 -1.9147087
4539 op-snap---monthly-publication-december-2025.pdf   667 2025-12 Car   Maserati Blue Driving without Due Care and Attention None A38m A38m Birmingham Birmingham Court N/A      
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
4577 op-snap---monthly-publication-december-2025.pdf   705 2025-12 Pedestrian Audi A6 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No Independent Evidence Available   52.4622646 -1.8599985

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);