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

230 rows where council_area = "Birmingham", month = "2025-11" 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 6

offence 1

  • Driving without Due Care and Attention · 230 ✖

month 1

  • 2025-11 · 230 ✖

council_area 1

  • Birmingham · 230 ✖
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
20468 op-snap---monthly-publication-november-2025.pdf   10 2025-11 Pedal Bike Audi A3.. White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20478 op-snap---monthly-publication-november-2025.pdf   20 2025-11 Car Seat Leon Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Court N/A      
20483 op-snap---monthly-publication-november-2025.pdf   25 2025-11 Car Vauxhall astra Red Driving without Due Care and Attention None M6 /M42 M6 /M42 Birmingham Birmingham Education N/A   52.5183642 -1.8724942
20494 op-snap---monthly-publication-november-2025.pdf   36 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
20498 op-snap---monthly-publication-november-2025.pdf   40 2025-11 Car Vauxhall corsa Grey Driving without Due Care and Attention None Booth Street Booth Street Birmingham Birmingham Education N/A   52.5039035 -1.9447084
20502 op-snap---monthly-publication-november-2025.pdf   44 2025-11 Car Audi A3 Blue Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
20506 op-snap---monthly-publication-november-2025.pdf   48 2025-11 Car Volvo Lorry White Driving without Due Care and Attention None M42 Motorway M42 Motorway Birmingham Birmingham Court N/A   52.490826 -1.8882034
20511 op-snap---monthly-publication-november-2025.pdf   53 2025-11 Car Volkswagen Polo White Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Education N/A   52.4298554 -1.9086629
20521 op-snap---monthly-publication-november-2025.pdf   63 2025-11 Car Mercedes-Benz C220 Grey Driving without Due Care and Attention No Insurance Collector Road Collector Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5139393 -1.7600186
20524 op-snap---monthly-publication-november-2025.pdf   66 2025-11 Car Audi Q3 Grey Driving without Due Care and Attention None Priory Road / Bristol Road Priory Road / Bristol Road Birmingham Birmingham Education N/A   52.4552604 -1.9104552
20532 op-snap---monthly-publication-november-2025.pdf   74 2025-11 Car Ford Transit White Driving without Due Care and Attention None Warren Farm Road Warren Farm Road Birmingham Birmingham Warning Letter N/A   52.5424846 -1.8794625
20534 op-snap---monthly-publication-november-2025.pdf   76 2025-11 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Longdales Road Longdales Road Birmingham Birmingham Warning Letter N/A   52.3947881 -1.9285109
20539 op-snap---monthly-publication-november-2025.pdf   81 2025-11 Car Ford Mondeo Silver Driving without Due Care and Attention None Edgbaston Road Edgbaston Road Birmingham Birmingham Warning Letter N/A   52.4552785 -1.906384
20540 op-snap---monthly-publication-november-2025.pdf   82 2025-11 Car BMW 750E Grey Driving without Due Care and Attention None Edgbaston Road Edgbaston Road Birmingham Birmingham Education N/A   52.4552785 -1.906384
20542 op-snap---monthly-publication-november-2025.pdf   84 2025-11 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention No vehicle excise licence Farnborough Road, Castle Vale Farnborough Road, Castle Vale Birmingham Birmingham Fixed Penalty N/A   52.5148331 -1.79231
20548 op-snap---monthly-publication-november-2025.pdf   90 2025-11 Car Audi A5 Red Driving without Due Care and Attention None Bromford Road Bromford Road Birmingham Birmingham Warning Letter N/A   52.503036 -1.8289972
20549 op-snap---monthly-publication-november-2025.pdf   91 2025-11 Car   HGV White Driving without Due Care and Attention None Grasmere Road Grasmere Road Birmingham Birmingham RTC - Actioned N/A   52.5006918 -1.9302528
20556 op-snap---monthly-publication-november-2025.pdf   98 2025-11 Car BMW 320.. Blue Driving without Due Care and Attention None M5 Northbound... ? M5 Northbound. ? Birmingham Birmingham Warning Letter N/A      
20561 op-snap---monthly-publication-november-2025.pdf   103 2025-11 Pedal Bike Toyota Yaris Red Driving without Due Care and Attention None Witherford Way Witherford Way Birmingham Birmingham Warning Letter N/A   52.4346604 -1.9538812
20567 op-snap---monthly-publication-november-2025.pdf   109 2025-11 Car Audi S6 Silver Driving without Due Care and Attention None M6 NB J6 M6 Northbound J6 Birmingham Birmingham NFA No Offence   52.676119 -2.0858425
20570 op-snap---monthly-publication-november-2025.pdf   112 2025-11 Car Volkswagen Golf Grey Driving without Due Care and Attention None Midland Road Midland Road Birmingham Birmingham NFA No Offence   52.4190372 -1.9294685
20579 op-snap---monthly-publication-november-2025.pdf   121 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention No Insurance Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
20583 op-snap---monthly-publication-november-2025.pdf   125 2025-11 Car BMW 118I Blue Driving without Due Care and Attention None Heathfield Road Heathfield Road Birmingham Birmingham Fixed Penalty N/A   52.5905365 -1.8453418
20584 op-snap---monthly-publication-november-2025.pdf   126 2025-11 Car Audi A4 White Driving without Due Care and Attention No Insurance Stonehouse Lane Stonehouse Lane Birmingham Birmingham Court N/A   52.4440435 -1.9818872
20596 op-snap---monthly-publication-november-2025.pdf   138 2025-11 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Warning Letter N/A   52.5170745 -1.9012542
20597 op-snap---monthly-publication-november-2025.pdf   139 2025-11 Car Mazda Sprinter White Driving without Due Care and Attention None Questett Road Questett Road Birmingham Birmingham Warning Letter N/A      
20598 op-snap---monthly-publication-november-2025.pdf   140 2025-11 Other Ford Transit Black Driving without Due Care and Attention None The Deers Leap The Deers Leap Birmingham Birmingham Court N/A   52.5601871 -1.8928907
20599 op-snap---monthly-publication-november-2025.pdf   141 2025-11 Car Ford Transit White Driving without Due Care and Attention None Newbury Road Newbury Road Birmingham Birmingham Warning Letter N/A   52.4993019 -1.8964495
20609 op-snap---monthly-publication-november-2025.pdf   151 2025-11 Pedal Bike Citroen Berlingo Silver Driving without Due Care and Attention None Solihull Lane Solihull Lane Birmingham Birmingham Education N/A   52.4230862 -1.8347873
20611 op-snap---monthly-publication-november-2025.pdf   153 2025-11 Car Ford Focus Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
20616 op-snap---monthly-publication-november-2025.pdf   158 2025-11 Car Hyundai Tucson Grey Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
20619 op-snap---monthly-publication-november-2025.pdf   161 2025-11 Car Vauxhall Crossland Black Driving without Due Care and Attention None Tixall Road Tixall Road Birmingham Birmingham Court N/A   52.4193312 -1.8517995
20628 op-snap---monthly-publication-november-2025.pdf   170 2025-11 Car Skoda Yeti Grey Driving without Due Care and Attention None Bells Lane Bells Lane Birmingham Birmingham Education N/A   52.4053419 -1.8944602
20634 op-snap---monthly-publication-november-2025.pdf   176 2025-11 Car Ford Transit White Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Court N/A      
20637 op-snap---monthly-publication-november-2025.pdf   179 2025-11 Car Hyundai Tucson Grey Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
20640 op-snap---monthly-publication-november-2025.pdf   182 2025-11 Car BMW 440.. Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
20644 op-snap---monthly-publication-november-2025.pdf   186 2025-11 Car Volkswagen Tayron Silver Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham Education N/A   52.4580901 -1.894458
20646 op-snap---monthly-publication-november-2025.pdf   188 2025-11 Car Nissan Juke Red Driving without Due Care and Attention None Garrison Circus Garrison Circus Birmingham Birmingham Warning Letter N/A   52.4794658 -1.8762374
20649 op-snap---monthly-publication-november-2025.pdf   191 2025-11 Car Vauxhall Astra Red Driving without Due Care and Attention None Newbury Road Newbury Road Birmingham Birmingham NFA No Independent Evidence Available   52.4993019 -1.8964495
20650 op-snap---monthly-publication-november-2025.pdf   192 2025-11 Car Mercedes-Benz CLA Grey Driving without Due Care and Attention None Newbury Road Newbury Road Birmingham Birmingham NFA No Offence   52.4993019 -1.8964495
20662 op-snap---monthly-publication-november-2025.pdf   204 2025-11 Car Volkswagen Taigo Grey Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
20663 op-snap---monthly-publication-november-2025.pdf   205 2025-11 Pedal Bike Mercedes-Benz Tractor White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20665 op-snap---monthly-publication-november-2025.pdf   207 2025-11 Pedal Bike Peugeot 308 Active Black Driving without Due Care and Attention None Blackwood Road Blackwood Road Birmingham Birmingham Warning Letter N/A   52.5529452 -1.909824
20672 op-snap---monthly-publication-november-2025.pdf   214 2025-11 Car Volkswagen Sharan Black Driving without Due Care and Attention No Insurance St Margarets Road Street Margarets Road Birmingham Birmingham Court N/A      
20692 op-snap---monthly-publication-november-2025.pdf   234 2025-11 Car Citroen   Grey Driving without Due Care and Attention None M42 SB M42 Southbound Birmingham Birmingham NFA No Independent Evidence Available      
20700 op-snap---monthly-publication-november-2025.pdf   242 2025-11 Pedal Bike Mercedes-Benz C180 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20705 op-snap---monthly-publication-november-2025.pdf   247 2025-11 Car Porsche Taycan Purple Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
20707 op-snap---monthly-publication-november-2025.pdf   249 2025-11 Car Volkswagen T-roc White Driving without Due Care and Attention None Newton Road Newton Road Birmingham Birmingham NFA No Offence   52.4541102 -1.8710993
20708 op-snap---monthly-publication-november-2025.pdf   250 2025-11 Car Ford Fiesta Black Driving without Due Care and Attention None Kings Heath High Street Kings Heath High Street Birmingham Birmingham NFA Misc Inc Crimes   52.4391028 -1.893289
20709 op-snap---monthly-publication-november-2025.pdf   251 2025-11 Car Volkswagen T Roc Grey Driving without Due Care and Attention None Short Heath Road Short Heath Road Birmingham Birmingham NFA No Offence   52.5302344 -1.8505439
20716 op-snap---monthly-publication-november-2025.pdf   258 2025-11 Car Mercedes-Benz A200 White Driving without Due Care and Attention None High Street, Erdington High Street, Erdington Birmingham Birmingham NFA No Offence   52.5256828 -1.8373143
20718 op-snap---monthly-publication-november-2025.pdf   260 2025-11 Car Mercedes-Benz A200 White Driving without Due Care and Attention None High Street Erdington High Street Erdington Birmingham Birmingham NFA No Offence   52.5257176 -1.8373568
20719 op-snap---monthly-publication-november-2025.pdf   261 2025-11 Car Land Rover Range Rover Black Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
20729 op-snap---monthly-publication-november-2025.pdf   271 2025-11 Car Seat Leon Blue Driving without Due Care and Attention None a45 A45 Birmingham Birmingham Warning Letter N/A      
20733 op-snap---monthly-publication-november-2025.pdf   275 2025-11 Car Vauxhall Agila Red Driving without Due Care and Attention None Robbin Wood Lane Robbin Wood Lane Birmingham Birmingham Warning Letter N/A      
20734 op-snap---monthly-publication-november-2025.pdf   276 2025-11 Car Mini Cooper Black Driving without Due Care and Attention None Wellington Road Perry Barr Wellington Road Perry Barr Birmingham Birmingham Fixed Penalty N/A   52.5140398 -1.9164334
20740 op-snap---monthly-publication-november-2025.pdf   282 2025-11 Car BMW 120d Black Driving without Due Care and Attention No Insurance Barnes Hill Barnes Hill Birmingham Birmingham Court N/A   52.4401325 -1.9785938
20744 op-snap---monthly-publication-november-2025.pdf   286 2025-11 Car Mitsubishi Shogun Grey Driving without Due Care and Attention No Insurance City Road City Road Birmingham Birmingham Other Action Taken No Independent Evidence Available   52.4763176 -1.9584897
20745 op-snap---monthly-publication-november-2025.pdf   287 2025-11 Car Jaguar XF Silver Driving without Due Care and Attention No vehicle excise licence Bromford Lane Bromford Lane Birmingham Birmingham Court N/A   52.5083238 -1.8332287
20748 op-snap---monthly-publication-november-2025.pdf   290 2025-11 Lorry Mercedes-Benz ML250 Silver Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
20750 op-snap---monthly-publication-november-2025.pdf   292 2025-11 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20751 op-snap---monthly-publication-november-2025.pdf   293 2025-11 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20754 op-snap---monthly-publication-november-2025.pdf   296 2025-11 Car Mercedes-Benz A200 Silver Driving without Due Care and Attention None Selly Oak Road Selly Oak Road Birmingham Birmingham Education N/A   52.4263875 -1.9397954
20759 op-snap---monthly-publication-november-2025.pdf   301 2025-11 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Wretham Street Wretham Street Birmingham Birmingham Education N/A      
20761 op-snap---monthly-publication-november-2025.pdf   303 2025-11 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham Education N/A   52.4304526 -1.9216716
20764 op-snap---monthly-publication-november-2025.pdf   306 2025-11 Car BMW 335i Blue Driving without Due Care and Attention None Hockley Circus Hockley Circus Birmingham Birmingham Warning Letter N/A   52.4952382 -1.9146705
20768 op-snap---monthly-publication-november-2025.pdf   310 2025-11 Car Jaguar e Pace Grey Driving without Due Care and Attention None Hamstead Hill Hamstead Hill Birmingham Birmingham Fixed Penalty N/A   52.5274116 -1.9287273
20769 op-snap---monthly-publication-november-2025.pdf   311 2025-11 Car Mg HS Black Driving without Due Care and Attention None Six Ways Island, Erdington Six Ways Island, Erdington Birmingham Birmingham Education N/A      
20771 op-snap---monthly-publication-november-2025.pdf   313 2025-11 Car Toyota Prius Silver Driving without Due Care and Attention None A4040 A4040 Birmingham Birmingham Warning Letter N/A      
20772 op-snap---monthly-publication-november-2025.pdf   314 2025-11 Car Volvo Tractor Orange Driving without Due Care and Attention None M42 NB towards J9 M42 Northbound towards J9 Birmingham Birmingham Education N/A      
20777 op-snap---monthly-publication-november-2025.pdf   319 2025-11 Car Audi A5 Grey Driving without Due Care and Attention None Great Charles Street Queensway Great Charles Street Queensway Birmingham Birmingham Fixed Penalty N/A   52.4821283 -1.9037074
20784 op-snap---monthly-publication-november-2025.pdf   326 2025-11 Pedal Bike Mazda 6 SE Silver Driving without Due Care and Attention None Black Haynes Road Black Haynes Road Birmingham Birmingham Warning Letter N/A   52.4260755 -1.9679443
20786 op-snap---monthly-publication-november-2025.pdf   328 2025-11 Car Volkswagen Golf Grey Driving without Due Care and Attention No Insurance Hamstead Hill Hamstead Hill Birmingham Birmingham Court N/A   52.5274116 -1.9287273
20790 op-snap---monthly-publication-november-2025.pdf   332 2025-11 Pedal Bike BMW 520D Grey Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20791 op-snap---monthly-publication-november-2025.pdf   333 2025-11 Pedal Bike Peugeot 208GT Yellow Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20792 op-snap---monthly-publication-november-2025.pdf   334 2025-11 Pedal Bike Suzuki Swift Silver Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20795 op-snap---monthly-publication-november-2025.pdf   337 2025-11 Car Ford Ranger Blue Driving without Due Care and Attention None Hamstead Hill Hamstead Hill Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5274116 -1.9287273
20802 op-snap---monthly-publication-november-2025.pdf   344 2025-11 Car Yamaha GPD125 Red Driving without Due Care and Attention None Durham Road Durham Road Birmingham Birmingham Warning Letter N/A   52.4535652 -1.8699279
20811 op-snap---monthly-publication-november-2025.pdf   353 2025-11 Car Byd Atto Grey Driving without Due Care and Attention None Middlemore Road Middlemore Road Birmingham Birmingham NFA No Offence   52.4091255 -1.957673
20814 op-snap---monthly-publication-november-2025.pdf   356 2025-11 Car Volkswagen Crafter White Driving without Due Care and Attention None St Mary's Road Street Mary's Road Birmingham Birmingham Education N/A      
20815 op-snap---monthly-publication-november-2025.pdf   357 2025-11 Car Citroen Berlingo White Driving without Due Care and Attention None Eyre Street Eyre Street Birmingham Birmingham Warning Letter N/A   52.4851493 -1.9262172
20820 op-snap---monthly-publication-november-2025.pdf   362 2025-11 Car Volkswagen Caddy White Driving without Due Care and Attention None Edgewood Road Edgewood Road Birmingham Birmingham Court N/A   52.3904074 -2.0028084
20826 op-snap---monthly-publication-november-2025.pdf   368 2025-11 Car Volvo Tractor White Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
20839 op-snap---monthly-publication-november-2025.pdf   381 2025-11 Pedal Bike Mercedes-Benz S350 Black Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Education N/A   52.4216321 -1.855984
20845 op-snap---monthly-publication-november-2025.pdf   387 2025-11 Car Ford Fiesta Orange Driving without Due Care and Attention None Walmey Ash Road Walmey Ash Road Birmingham Birmingham Court N/A      
20846 op-snap---monthly-publication-november-2025.pdf   388 2025-11 Car Land Rover Discovery Red Driving without Due Care and Attention None A452 Collector Collector Birmingham Birmingham NFA No Offence   52.5139393 -1.7600186
20847 op-snap---monthly-publication-november-2025.pdf   389 2025-11 Car Ford Mondeo Black Driving without Due Care and Attention None A452 A452 Birmingham Birmingham NFA No Offence      
20854 op-snap---monthly-publication-november-2025.pdf   396 2025-11 Pedal Bike Mercedes-Benz A200 White Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
20856 op-snap---monthly-publication-november-2025.pdf   398 2025-11 Car Fiat Ducato White Driving without Due Care and Attention None Jockey Road Jockey Road Birmingham Birmingham Education N/A   52.5512291 -1.8357776
20864 op-snap---monthly-publication-november-2025.pdf   406 2025-11 Car Volkswagen Crafter White Driving without Due Care and Attention None Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
20866 op-snap---monthly-publication-november-2025.pdf   408 2025-11 Car Kia Picanto Black Driving without Due Care and Attention None M6 Junction 7 M6 Junction 7 Birmingham Birmingham NFA No Independent Evidence Available   52.676119 -2.0858425
20885 op-snap---monthly-publication-november-2025.pdf   427 2025-11 Pedestrian Rolls-Royce Cullinan Black Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
20902 op-snap---monthly-publication-november-2025.pdf   444 2025-11 Pedestrian Ford Kuga White Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20903 op-snap---monthly-publication-november-2025.pdf   445 2025-11 Pedestrian Vauxhall Zafira Black Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20904 op-snap---monthly-publication-november-2025.pdf   446 2025-11 Pedestrian Honda FRV Grey Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20906 op-snap---monthly-publication-november-2025.pdf   448 2025-11 Car Toyota Previa Black Driving without Due Care and Attention None Heather Road Heather Road Birmingham Birmingham Warning Letter N/A   52.4699812 -1.841443
20931 op-snap---monthly-publication-november-2025.pdf   473 2025-11 Car Audi A4 White Driving without Due Care and Attention None Moseley Road / Cromer Rd Moseley Road / Cromer Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
20933 op-snap---monthly-publication-november-2025.pdf   475 2025-11 Car Skoda Rapide Beige Driving without Due Care and Attention None B4114 Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20985 op-snap---monthly-publication-november-2025.pdf   527 2025-11 Car Scania P410 White Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
21001 op-snap---monthly-publication-november-2025.pdf   543 2025-11 Car Mercedes-Benz C220 Grey Driving without Due Care and Attention None Newbury Road Newbury Road Birmingham Birmingham NFA No Offence   52.4993019 -1.8964495

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