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

252 rows where council_area = "Birmingham", month = "2025-09" 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 · 252 ✖

month 1

  • 2025-09 · 252 ✖

council_area 1

  • Birmingham · 252 ✖
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
23785 op-snap---monthly-publication-september-2025.pdf   4 2025-09 Car   U/K White Driving without Due Care and Attention None M6. M6 Birmingham Birmingham RTC - Actioned N/A      
23786 op-snap---monthly-publication-september-2025.pdf   5 2025-09 Car Tesla Model 3 Grey Driving without Due Care and Attention None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham Warning Letter N/A   52.4650893 -1.8425008
23787 op-snap---monthly-publication-september-2025.pdf   6 2025-09 Car Hyundai Bayon Blue Driving without Due Care and Attention None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham RTC - Actioned N/A   52.4861917 -1.8829748
23788 op-snap---monthly-publication-september-2025.pdf   7 2025-09 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Moor Green lane Moor Green lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
23795 op-snap---monthly-publication-september-2025.pdf   14 2025-09 Car Renault Clio Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
23799 op-snap---monthly-publication-september-2025.pdf   18 2025-09 Car Volvo   Black Driving without Due Care and Attention None Camp Hill Camp Hill Birmingham Birmingham Warning Letter N/A   52.4702894 -1.8786299
23802 op-snap---monthly-publication-september-2025.pdf   21 2025-09 Pedal Bike Kia Sportage Green Driving without Due Care and Attention None Belgrave Road Belgrave Road Birmingham Birmingham Education N/A   52.4669004 -1.9011385
23807 op-snap---monthly-publication-september-2025.pdf   26 2025-09 Horse Rider Volvo V70 Blue Driving without Due Care and Attention No vehicle excise licence Dark lane, Wythall Dark lane, Wythall Birmingham Birmingham NFA No Independent Evidence Available      
23808 op-snap---monthly-publication-september-2025.pdf   27 2025-09 Car Toyota Prius Black Driving without Due Care and Attention None Gravelly Lane Gravelly Lane Birmingham Birmingham NFA No Independent Evidence Available   52.534608 -1.8379769
23812 op-snap---monthly-publication-september-2025.pdf   31 2025-09 Car Toyota Yaris Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
23815 op-snap---monthly-publication-september-2025.pdf   34 2025-09 Car Skoda Octavia Blue Driving without Due Care and Attention None Consitiution Hill Consitiution Hill Birmingham Birmingham Education N/A      
23816 op-snap---monthly-publication-september-2025.pdf   35 2025-09 Car Audi A3 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4203897 -1.8338574
23844 op-snap---monthly-publication-september-2025.pdf   63 2025-09 Car Ford B Max Gold Driving without Due Care and Attention None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Warning Letter N/A      
23857 op-snap---monthly-publication-september-2025.pdf   76 2025-09 Car Vauxhall Zafira Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
23862 op-snap---monthly-publication-september-2025.pdf   81 2025-09 Car Volkswagen Golf Red Driving without Due Care and Attention None Wills Street Wills Street Birmingham Birmingham Warning Letter N/A   52.500453 -1.9141126
23863 op-snap---monthly-publication-september-2025.pdf   82 2025-09 Car Vauxhall Corsa Black Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham Court N/A   52.505832 -1.92002
23864 op-snap---monthly-publication-september-2025.pdf   83 2025-09 Car Volkswagen T-Roc Silver Driving without Due Care and Attention None Collingswood Drive Collingswood Drive Birmingham Birmingham Warning Letter N/A      
23870 op-snap---monthly-publication-september-2025.pdf   89 2025-09 Car Audi RS 3 Black Driving without Due Care and Attention None Wake Green Road Wake Green Road Birmingham Birmingham Court N/A   52.4437078 -1.8783408
23872 op-snap---monthly-publication-september-2025.pdf   91 2025-09 Car Vauxhall Mokka White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
23889 op-snap---monthly-publication-september-2025.pdf   108 2025-09 Car Mercedes-Benz A35 AMG Yellow Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
23891 op-snap---monthly-publication-september-2025.pdf   110 2025-09 Car Nissan Qashqai Red Driving without Due Care and Attention None Heathfield Road Heathfield Road Birmingham Birmingham NFA No Independent Evidence Available   52.5905365 -1.8453418
23898 op-snap---monthly-publication-september-2025.pdf   117 2025-09 Car BMW 3 series Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Education N/A   52.5368764 -1.8976461
23903 op-snap---monthly-publication-september-2025.pdf   122 2025-09 Other BMW X6 White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
23908 op-snap---monthly-publication-september-2025.pdf   127 2025-09 Car BMW X3 Grey Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Court N/A   52.4298554 -1.9086629
23915 op-snap---monthly-publication-september-2025.pdf   134 2025-09 Car Ford Mondeo Black Driving without Due Care and Attention None A45 to Stonbridge A45 to Stonbridge Birmingham Birmingham Fixed Penalty N/A      
23916 op-snap---monthly-publication-september-2025.pdf   135 2025-09 Car Ford Fusion Black Driving without Due Care and Attention None Melton Avenue Melton Avenue Birmingham Birmingham Fixed Penalty N/A      
23920 op-snap---monthly-publication-september-2025.pdf   139 2025-09 Other Peugeot 208 Active Black Driving without Due Care and Attention None Watson Road Watson Road Birmingham Birmingham Fixed Penalty N/A   52.4897107 -1.839943
23932 op-snap---monthly-publication-september-2025.pdf   151 2025-09 Car Audi Q7.. Grey Driving without Due Care and Attention None Spitfire island Spitfire island Birmingham Birmingham Education N/A   52.5138106 -1.797297
23936 op-snap---monthly-publication-september-2025.pdf   155 2025-09 Car Volvo S90 Blue Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
23943 op-snap---monthly-publication-september-2025.pdf   162 2025-09 Car Seat Ibiza Black Driving without Due Care and Attention None Yardley Green Road Yardley Green Road Birmingham Birmingham Education N/A   52.4764154 -1.8311418
23945 op-snap---monthly-publication-september-2025.pdf   164 2025-09 Car Nissan Qashqai Grey Driving without Due Care and Attention None Bosworth Drive Bosworth Drive Birmingham Birmingham Fixed Penalty N/A   52.4779726 -1.7596871
23955 op-snap---monthly-publication-september-2025.pdf   174 2025-09 Car Toyota Corolla Black Driving without Due Care and Attention None Warwick Road Acocks Green Warwick Road Acocks Green Birmingham Birmingham Education N/A   52.4468495 -1.8244484
23957 op-snap---monthly-publication-september-2025.pdf   176 2025-09 Car Land Rover Evoque White Driving without Due Care and Attention None Bradford Road Bradford Road Birmingham Birmingham NFA No Offence   52.5024148 -1.7961753
23958 op-snap---monthly-publication-september-2025.pdf   177 2025-09 Car Seat Ibiza Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
23960 op-snap---monthly-publication-september-2025.pdf   179 2025-09 Car Mg 3 Trophy White Driving without Due Care and Attention None B4173 B4173 Birmingham Birmingham NFA Misc Inc Crimes   52.4496153 -1.8646204
23973 op-snap---monthly-publication-september-2025.pdf   192 2025-09 Car Vauxhall Insignia Silver Driving without Due Care and Attention None M6 SB J7 M6 Southbound J7 Birmingham Birmingham NFA No Offence   52.676119 -2.0858425
23974 op-snap---monthly-publication-september-2025.pdf   193 2025-09 Pedal Bike   M/C Black Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No VRM   52.3868298 -2.0003781
23976 op-snap---monthly-publication-september-2025.pdf   195 2025-09 Car BMW 320.. White Driving without Due Care and Attention None A38 Aston Expressway Aston Expressway Birmingham Birmingham Education N/A   52.493793 -1.8881773
23978 op-snap---monthly-publication-september-2025.pdf   197 2025-09 Car Ford Fiesta Black Driving without Due Care and Attention None Curzon Circus Curzon Circus Birmingham Birmingham Warning Letter N/A      
23981 op-snap---monthly-publication-september-2025.pdf   200 2025-09 Car   Husqvarna White Driving without Due Care and Attention None Melchett Road Melchett Road Birmingham Birmingham Education N/A   52.413984 -1.9251511
23982 op-snap---monthly-publication-september-2025.pdf   201 2025-09 Pedal Bike Ford Focus Black Driving without Due Care and Attention No vehicle excise licence Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
23986 op-snap---monthly-publication-september-2025.pdf   205 2025-09 Car BMW 320.. White Driving without Due Care and Attention None Wash Lane Yardley Wood Wash Lane Yardley Wood Birmingham Birmingham Fixed Penalty N/A      
23987 op-snap---monthly-publication-september-2025.pdf   206 2025-09 Car Volvo V90 White Driving without Due Care and Attention None Broadmeadow Lane Broadmeadow Lane Birmingham Birmingham Education N/A      
23991 op-snap---monthly-publication-september-2025.pdf   210 2025-09 Car Seat Leon Black Driving without Due Care and Attention None Small Heath Highway Small Heath Highway Birmingham Birmingham NFA No Offence   52.4709298 -1.8722585
23994 op-snap---monthly-publication-september-2025.pdf   213 2025-09 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Fort Parkway Fort Parkway Birmingham Birmingham Court N/A   52.50787 -1.8195713
23998 op-snap---monthly-publication-september-2025.pdf   217 2025-09 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Church Road Edgbaston Church Road Edgbaston Birmingham Birmingham Education N/A   52.46114 -1.9180882
24001 op-snap---monthly-publication-september-2025.pdf   220 2025-09 Car Audi A6 Grey Driving without Due Care and Attention None Turves Green, Longbridge Turves Green, Longbridge Birmingham Birmingham NFA No Offence   52.3964205 -1.9697415
24004 op-snap---monthly-publication-september-2025.pdf   223 2025-09 Car Mercedes-Benz A200 Purple Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No Independent Evidence Available   52.3868298 -2.0003781
24023 op-snap---monthly-publication-september-2025.pdf   242 2025-09 Pedal Bike Ford Focus Red Driving without Due Care and Attention None Tixall Road Shirley Tixall Road Shirley Birmingham Birmingham Education N/A      
24024 op-snap---monthly-publication-september-2025.pdf   243 2025-09 Car Nissan Qashqai Black Driving without Due Care and Attention None Deelands Road Deelands Road Birmingham Birmingham Warning Letter N/A   52.3970488 -2.0184857
24026 op-snap---monthly-publication-september-2025.pdf   245 2025-09 Other Kia Creed Black Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham NFA No Independent Evidence Available   52.5327447 -1.899844
24028 op-snap---monthly-publication-september-2025.pdf   247 2025-09 Car Audi A3 Black Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham NFA Not in Public Interest   52.5458699 -1.9304484
24029 op-snap---monthly-publication-september-2025.pdf   248 2025-09 Car Volkswagen Passat Black Driving without Due Care and Attention None Gerrard Street Gerrard Street Birmingham Birmingham Warning Letter N/A   52.5002335 -1.9032351
24030 op-snap---monthly-publication-september-2025.pdf   249 2025-09 Car Audi Q5 Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24031 op-snap---monthly-publication-september-2025.pdf   250 2025-09 Motorbike Ford Fiesta Silver Driving without Due Care and Attention None Old Snow Hill Old Snow Hill Birmingham Birmingham RTC - Actioned N/A   52.4858844 -1.9003652
24033 op-snap---monthly-publication-september-2025.pdf   252 2025-09 Car Vauxhall MOKKA Black Driving without Due Care and Attention None Wolverton Road Wolverton Road Birmingham Birmingham NFA Out of Force   52.3900767 -1.9976014
24034 op-snap---monthly-publication-september-2025.pdf   253 2025-09 Car Land Rover Range Rover Black Driving without Due Care and Attention None Coleshill Road Coleshill Road Birmingham Birmingham Court N/A   52.4967329 -1.8097462
24035 op-snap---monthly-publication-september-2025.pdf   254 2025-09 Car Audi A3 Black Driving without Due Care and Attention None Boldmere Road Boldmere Road Birmingham Birmingham Warning Letter N/A   52.548309 -1.8411769
24037 op-snap---monthly-publication-september-2025.pdf   256 2025-09 Pedal Bike Hyundai Tucson Blue Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham Education N/A   52.548449 -1.8594603
24045 op-snap---monthly-publication-september-2025.pdf   264 2025-09 Car Volkswagen Golf Grey Driving without Due Care and Attention No Insurance Drews Lane, Erdington Drews Lane, Erdington Birmingham Birmingham Fixed Penalty N/A      
24052 op-snap---monthly-publication-september-2025.pdf   271 2025-09 Car Peugeot Traveller Black Driving without Due Care and Attention None A38 Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
24054 op-snap---monthly-publication-september-2025.pdf   273 2025-09 Car BMW S1000RR White Driving without Due Care and Attention None Sundial Lane Sundial Lane Birmingham Birmingham Education N/A   52.5471217 -1.9336068
24057 op-snap---monthly-publication-september-2025.pdf   276 2025-09 Car Seat Leon Black Driving without Due Care and Attention None Nursery Road Nursery Road Birmingham Birmingham Warning Letter N/A   52.4979836 -1.9118163
24058 op-snap---monthly-publication-september-2025.pdf   277 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA No Offence      
24060 op-snap---monthly-publication-september-2025.pdf   279 2025-09 Car Mercedes-Benz c300 Grey Driving without Due Care and Attention None High Street, Newtown High Street, Newtown Birmingham Birmingham Warning Letter N/A   52.5000098 -1.8959802
24061 op-snap---monthly-publication-september-2025.pdf   280 2025-09 Car Porsche Cayenne Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA No Offence      
24066 op-snap---monthly-publication-september-2025.pdf   285 2025-09 Car Audi S3 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Fixed Penalty N/A   52.4622646 -1.8599985
24078 op-snap---monthly-publication-september-2025.pdf   297 2025-09 Car Volkswagen T Roc Black Driving without Due Care and Attention None Wellington Road Wellington Road Birmingham Birmingham Court N/A   52.5133725 -1.9193405
24085 op-snap---monthly-publication-september-2025.pdf   304 2025-09 Car Audi Q5 Silver Driving without Due Care and Attention None Hollybank Road Hollybank Road Birmingham Birmingham NFA No VRM   52.4236341 -1.8787502
24087 op-snap---monthly-publication-september-2025.pdf   306 2025-09 Car Citroen C3 Grey Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham Education N/A      
24094 op-snap---monthly-publication-september-2025.pdf   313 2025-09 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Aston Lane Aston Lane Birmingham Birmingham Fixed Penalty N/A   52.5151247 -1.9007033
24097 op-snap---monthly-publication-september-2025.pdf   316 2025-09 Other       Driving without Due Care and Attention None Wharf Road Wharf Road Birmingham Birmingham NFA No Independent Evidence Available   52.4075531 -1.927329
24109 op-snap---monthly-publication-september-2025.pdf   328 2025-09 Car Kia Sportage Black Driving without Due Care and Attention None Finchley Road Finchley Road Birmingham Birmingham Education N/A   52.5488456 -1.8735092
24112 op-snap---monthly-publication-september-2025.pdf   331 2025-09 Car Suzuki Alto Pink Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA No Offence   52.505832 -1.92002
24121 op-snap---monthly-publication-september-2025.pdf   340 2025-09 Pedal Bike Seat Leon White Driving without Due Care and Attention None Priory Road Priory Road Birmingham Birmingham Education N/A   52.4132696 -1.8555008
24133 op-snap---monthly-publication-september-2025.pdf   352 2025-09 Car Skoda Octavia Silver Driving without Due Care and Attention None Redditch Road Redditch Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.3954946 -1.9516557
24139 op-snap---monthly-publication-september-2025.pdf   358 2025-09 Car Ford Transit Red Driving without Due Care and Attention None Baldwin Lane Baldwin Lane Birmingham Birmingham Education N/A   52.4151192 -1.84291
24140 op-snap---monthly-publication-september-2025.pdf   359 2025-09 Car BMW 118 Grey Driving without Due Care and Attention None Harborne Lane Harborne Lane Birmingham Birmingham Fixed Penalty N/A   52.4468464 -1.9454816
24141 op-snap---monthly-publication-september-2025.pdf   360 2025-09 Car Volkswagen Polo Red Driving without Due Care and Attention None Norman Road Norman Road Birmingham Birmingham Warning Letter N/A   52.411848 -1.9590923
24152 op-snap---monthly-publication-september-2025.pdf   371 2025-09 Car BMW 1 series Black Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Court N/A   52.4656414 -1.9852276
24154 op-snap---monthly-publication-september-2025.pdf   373 2025-09 Car Audi A3 White Driving without Due Care and Attention None Redditch Road Redditch Road Birmingham Birmingham Court N/A   52.3954946 -1.9516557
24156 op-snap---monthly-publication-september-2025.pdf   375 2025-09 Car Seat Alhambra Silver Driving without Due Care and Attention None Monument Road Monument Road Birmingham Birmingham Education N/A   52.4731312 -1.930947
24157 op-snap---monthly-publication-september-2025.pdf   376 2025-09 Car Peugeot Expert White Driving without Due Care and Attention None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham Warning Letter N/A   52.4760986 -1.9018641
24158 op-snap---monthly-publication-september-2025.pdf   377 2025-09 Pedal Bike   Alexander Dennis Grey Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
24159 op-snap---monthly-publication-september-2025.pdf   378 2025-09 Car Kia Ceed Grey Driving without Due Care and Attention None Queslett Road Great Barr Queslett Road Great Barr Birmingham Birmingham Fixed Penalty N/A   52.5518873 -1.9122043
24160 op-snap---monthly-publication-september-2025.pdf   379 2025-09 Car Ford Transit White Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Birmingham Birmingham NFA No Offence   52.5199797 -2.0683265
24162 op-snap---monthly-publication-september-2025.pdf   381 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Rubery Lane Frankley Rubery Lane Frankley Birmingham Birmingham Court N/A   52.4022216 -2.0074676
24163 op-snap---monthly-publication-september-2025.pdf   382 2025-09 Car   motorbike Black Driving without Due Care and Attention None Tyburn Island Tyburn Island Birmingham Birmingham NFA No Offence   52.5193542 -1.800381
24166 op-snap---monthly-publication-september-2025.pdf   385 2025-09 Car Tesla Model 3 Black Driving without Due Care and Attention None A446 Roundabout with Jct 4 M6 Roundabout with Junction 4 M6 Birmingham Birmingham Court N/A      
24171 op-snap---monthly-publication-september-2025.pdf   390 2025-09 Car Ford Kuga Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Warning Letter N/A   52.5517052 -1.7825505
24175 op-snap---monthly-publication-september-2025.pdf   394 2025-09 Car Land Rover Evoque Blue Driving without Due Care and Attention None A38 (M) Southbound A38 (M) Southbound Birmingham Birmingham NFA No Independent Evidence Available      
24184 op-snap---monthly-publication-september-2025.pdf   403 2025-09 Car Vauxhall mokka Blue Driving without Due Care and Attention None The Crescent The Crescent Birmingham Birmingham Warning Letter N/A   52.4568799 -1.8734416
24185 op-snap---monthly-publication-september-2025.pdf   404 2025-09 Pedal Bike Mercedes-Benz A-class Grey Driving without Due Care and Attention None Lichfield Road, Aston Lichfield Road, Aston Birmingham Birmingham Fixed Penalty N/A   52.5084175 -1.8613455
24187 op-snap---monthly-publication-september-2025.pdf   406 2025-09 Car Suzuki vitara Grey Driving without Due Care and Attention None Smallheath Highway Smallheath Highway Birmingham Birmingham Warning Letter N/A      
24188 op-snap---monthly-publication-september-2025.pdf   407 2025-09 Car Honda Jazz Red Driving without Due Care and Attention No Insurance A45 Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham NFA Misc Inc Crimes   52.4650893 -1.8425008
24207 op-snap---monthly-publication-september-2025.pdf   426 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Victoria Road Victoria Road Birmingham Birmingham NFA No Offence   52.5615573 -1.820549
24223 op-snap---monthly-publication-september-2025.pdf   442 2025-09 Car Mitsubishi Shogun Silver Driving without Due Care and Attention None Billingsley Road Billingsley Road Birmingham Birmingham Warning Letter N/A   52.4696617 -1.7890822
24224 op-snap---monthly-publication-september-2025.pdf   443 2025-09 Car BMW 218I Grey Driving without Due Care and Attention None A38 M A38 M Birmingham Birmingham NFA No VRM   52.5092312 -1.8706799
24233 op-snap---monthly-publication-september-2025.pdf   452 2025-09 Pedestrian Ford S Max Grey Driving without Due Care and Attention None Aldi,Hall Green Aldi, Hall Green Birmingham Birmingham NFA No Independent Evidence Available   52.4271029 -1.8406313
24239 op-snap---monthly-publication-september-2025.pdf   458 2025-09 Car Peugeot Boxer White Driving without Due Care and Attention None Billesley Lane Billesley Lane Birmingham Birmingham Warning Letter N/A   52.4344402 -1.8845368

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