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

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

month 1

  • 2025-08 · 264 ✖

council_area 1

  • Birmingham · 264 ✖
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
2025 op-snap---monthly-publication-august-2025.pdf   0 2025-08 Car BMW 120M White Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Education N/A   52.4865107 -1.9386263
2030 op-snap---monthly-publication-august-2025.pdf   5 2025-08 Pedal Bike Ford Focus Orange Driving without Due Care and Attention None Westhill Road Westhill Road Birmingham Birmingham NFA No Offence   52.4121033 -1.9354529
2031 op-snap---monthly-publication-august-2025.pdf   6 2025-08 Pedal Bike   Ferrari Red Driving without Due Care and Attention None A4040 A4040 Birmingham Birmingham Education N/A      
2032 op-snap---monthly-publication-august-2025.pdf   7 2025-08 Car BMW 525I Grey Driving without Due Care and Attention None Richmond Hill Road Richmond Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4607238 -1.935227
2039 op-snap---monthly-publication-august-2025.pdf   14 2025-08 Car Skoda Suberb Black Driving without Due Care and Attention None Jayshaw Avenue Jayshaw Avenue Birmingham Birmingham Education N/A      
2041 op-snap---monthly-publication-august-2025.pdf   16 2025-08 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA Not in Public Interest   52.505832 -1.92002
2049 op-snap---monthly-publication-august-2025.pdf   24 2025-08 Car Seat Leon White Driving without Due Care and Attention None Swanshurst Lane Swanshurst Lane Birmingham Birmingham Education N/A   52.4337146 -1.8634884
2051 op-snap---monthly-publication-august-2025.pdf   26 2025-08 Pedestrian Ford Fiesta Yellow Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Education N/A      
2056 op-snap---monthly-publication-august-2025.pdf   31 2025-08 Car BMW X3 Black Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Warning Letter N/A      
2064 op-snap---monthly-publication-august-2025.pdf   39 2025-08 Car Volvo XC40 Black Driving without Due Care and Attention None Wellington Road Wellington Road Birmingham Birmingham Education N/A   52.5133725 -1.9193405
2065 op-snap---monthly-publication-august-2025.pdf   40 2025-08 Car Ford C Maxx White Driving without Due Care and Attention None A5127 A5127 Birmingham Birmingham Education N/A      
2067 op-snap---monthly-publication-august-2025.pdf   42 2025-08 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
2071 op-snap---monthly-publication-august-2025.pdf   46 2025-08 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
2074 op-snap---monthly-publication-august-2025.pdf   49 2025-08 Car Fiat Scudo Grey Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
2075 op-snap---monthly-publication-august-2025.pdf   50 2025-08 Car Volkswagen Golf Grey Driving without Due Care and Attention None Green Lane Small Heath Green Lane Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
2076 op-snap---monthly-publication-august-2025.pdf   51 2025-08 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Bromford Lane / Heartlands Parkway Bromford Lane / Heartlands Parkway Birmingham Birmingham Court N/A   52.5083238 -1.8332287
2085 op-snap---monthly-publication-august-2025.pdf   60 2025-08 Car Vauxhall Corsa White Driving without Due Care and Attention None Charnwood Close Charnwood Close Birmingham Birmingham NFA No Offence   52.4095185 -2.0031237
2095 op-snap---monthly-publication-august-2025.pdf   70 2025-08 Car Skoda Rapid Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
2098 op-snap---monthly-publication-august-2025.pdf   73 2025-08 Car Audi A3 White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
2099 op-snap---monthly-publication-august-2025.pdf   74 2025-08 Car Hyundai I30 Red Driving without Due Care and Attention None Shenstone Road Shenstone Road Birmingham Birmingham Warning Letter N/A   52.4011594 -1.879934
2105 op-snap---monthly-publication-august-2025.pdf   80 2025-08 Car Honda Civic Blue Driving without Due Care and Attention No Insurance Billesley Lane Billesley Lane Birmingham Birmingham Fixed Penalty N/A   52.4344402 -1.8845368
2107 op-snap---monthly-publication-august-2025.pdf   82 2025-08 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Thornhill Road Thornhill Road Birmingham Birmingham Education N/A   52.5042818 -1.9279918
2113 op-snap---monthly-publication-august-2025.pdf   88 2025-08 Car Vauxhall Astra Black Driving without Due Care and Attention None Quinton Road Quinton Road Birmingham Birmingham NFA No Offence   52.447826 -1.9574468
2119 op-snap---monthly-publication-august-2025.pdf   94 2025-08 Pedal Bike Ford Fiesta Grey Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
2127 op-snap---monthly-publication-august-2025.pdf   102 2025-08 Pedal Bike BMW 530D Silver Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
2131 op-snap---monthly-publication-august-2025.pdf   106 2025-08 Car Mercedes-Benz N/K Silver Driving without Due Care and Attention None B4121 Barnes Hill Barnes Hill Birmingham Birmingham NFA No VRM   52.4401325 -1.9785938
2145 op-snap---monthly-publication-august-2025.pdf   120 2025-08 Car Mercedes-Benz Vito Grey Driving without Due Care and Attention None M42 NB J7 M42 Northbound J7 Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
2147 op-snap---monthly-publication-august-2025.pdf   122 2025-08 Car Mercedes-Benz GLA Black Driving without Due Care and Attention None Battery Way Battery Way Birmingham Birmingham Education N/A   52.4493988 -1.8476406
2150 op-snap---monthly-publication-august-2025.pdf   125 2025-08 Car Mercedes-Benz AMG C Black Driving without Due Care and Attention None M6 (T2 Toll) M6 (T2 Toll) Birmingham Birmingham NFA No Independent Evidence Available      
2151 op-snap---monthly-publication-august-2025.pdf   126 2025-08 Car Audi S3 Grey Driving without Due Care and Attention None M6 (T2 Toll) M6 (T2 Toll) Birmingham Birmingham NFA No Independent Evidence Available      
2153 op-snap---monthly-publication-august-2025.pdf   128 2025-08 Car Hyundai I10 Red Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA Not in Public Interest      
2162 op-snap---monthly-publication-august-2025.pdf   137 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5292752 -1.7618805
2164 op-snap---monthly-publication-august-2025.pdf   139 2025-08 Car Mg 4SE Grey Driving without Due Care and Attention None Queensway Queensway Birmingham Birmingham NFA No Offence   52.4856447 -1.8972389
2166 op-snap---monthly-publication-august-2025.pdf   141 2025-08 Car Mazda 2.. Blue Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
2169 op-snap---monthly-publication-august-2025.pdf   144 2025-08 Car Honda CRV Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
2172 op-snap---monthly-publication-august-2025.pdf   147 2025-08 Pedal Bike Volkswagen Tiguan Black Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham NFA No Offence   52.4422505 -1.8539684
2181 op-snap---monthly-publication-august-2025.pdf   156 2025-08 Car Honda   Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA Not in Public Interest      
2182 op-snap---monthly-publication-august-2025.pdf   157 2025-08 Car Audi RS3 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No VRM   52.4622646 -1.8599985
2183 op-snap---monthly-publication-august-2025.pdf   158 2025-08 Car Volkswagen Passat Black Driving without Due Care and Attention None City Road City Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4763176 -1.9584897
2186 op-snap---monthly-publication-august-2025.pdf   161 2025-08 Car BMW 118i Grey Driving without Due Care and Attention None Cole Hall Road Cole Hall Road Birmingham Birmingham Education N/A   52.4968357 -1.7908553
2190 op-snap---monthly-publication-august-2025.pdf   165 2025-08 Car Ford Fiesta Red Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
2197 op-snap---monthly-publication-august-2025.pdf   172 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Waverly Road Waverly Road Birmingham Birmingham NFA Misc Inc Crimes      
2200 op-snap---monthly-publication-august-2025.pdf   175 2025-08 Pedal Bike Volkswagen Golf Beige Driving without Due Care and Attention None Moorgreen Lane Moorgreen Lane Birmingham Birmingham Education N/A      
2201 op-snap---monthly-publication-august-2025.pdf   176 2025-08 Pedal Bike Volkswagen T-Roc Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
2211 op-snap---monthly-publication-august-2025.pdf   186 2025-08 Car Ford Transit White Driving without Due Care and Attention None Aston Road Aston Road Birmingham Birmingham Warning Letter N/A   52.4929386 -1.888744
2219 op-snap---monthly-publication-august-2025.pdf   194 2025-08 Car Volkswagen Touran Blue Driving without Due Care and Attention None Bordsley Middleway Bordsley Middleway Birmingham Birmingham Warning Letter N/A      
2221 op-snap---monthly-publication-august-2025.pdf   196 2025-08 Pedestrian Audi Q2.. Black Driving without Due Care and Attention None A38.. A38 Birmingham Birmingham NFA No Offence      
2222 op-snap---monthly-publication-august-2025.pdf   197 2025-08 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Not in Public Interest   52.4203897 -1.8338574
2225 op-snap---monthly-publication-august-2025.pdf   200 2025-08 Pedal Bike Peugeot Partner White Driving without Due Care and Attention None Caldwell Road Caldwell Road Birmingham Birmingham Education N/A   52.4847159 -1.8263643
2228 op-snap---monthly-publication-august-2025.pdf   203 2025-08 Car Mercedes-Benz CLC180 Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
2231 op-snap---monthly-publication-august-2025.pdf   206 2025-08 Pedal Bike Land Rover Range Rover Black Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
2235 op-snap---monthly-publication-august-2025.pdf   210 2025-08 Car Toyota Aygo White Driving without Due Care and Attention Use vehicle on a road without valid test certificate A4040 A4040 Birmingham Birmingham Education N/A      
2236 op-snap---monthly-publication-august-2025.pdf   211 2025-08 Pedal Bike   WM BUS   Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham NFA No Offence   52.4708802 -1.8792135
2240 op-snap---monthly-publication-august-2025.pdf   215 2025-08 Car Ford Fiesta White Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
2247 op-snap---monthly-publication-august-2025.pdf   222 2025-08 Car Toyota Corolla White Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Education N/A   52.4375913 -1.9068522
2250 op-snap---monthly-publication-august-2025.pdf   225 2025-08 Car Audi Q2 Black Driving without Due Care and Attention None A34 A34 Birmingham Birmingham RTC - Actioned N/A      
2256 op-snap---monthly-publication-august-2025.pdf   231 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None M42 M42 Birmingham Birmingham NFA No VRM      
2266 op-snap---monthly-publication-august-2025.pdf   241 2025-08 Pedal Bike Renault Traffic Grey Driving without Due Care and Attention None Sycamore Road Sycamore Road Birmingham Birmingham Warning Letter N/A   52.5398019 -1.8455792
2283 op-snap---monthly-publication-august-2025.pdf   258 2025-08 Car Toyota Prius Black Driving without Due Care and Attention None Suffolk Street Suffolk Street Birmingham Birmingham NFA Not in Public Interest   52.4749336 -1.9003475
2296 op-snap---monthly-publication-august-2025.pdf   271 2025-08 Car BMW 320D Blue Driving without Due Care and Attention None Springfield Road Springfield Road Birmingham Birmingham Court N/A   52.4327486 -1.8844997
2299 op-snap---monthly-publication-august-2025.pdf   274 2025-08 Car Renault Megane Yellow Driving without Due Care and Attention None Great Lister Street Great Lister Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4896989 -1.8830592
2300 op-snap---monthly-publication-august-2025.pdf   275 2025-08 Car Mg 4 Trophy Grey Driving without Due Care and Attention None Maypole Lane Maypole Lane Birmingham Birmingham NFA No Offence   52.4046925 -1.8764112
2302 op-snap---monthly-publication-august-2025.pdf   277 2025-08 Car Nissan Qashqai White Driving without Due Care and Attention None Triiiford Road Triiiford Road Birmingham Birmingham NFA No Offence      
2314 op-snap---monthly-publication-august-2025.pdf   289 2025-08 Car Fiat Tipo Grey Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Education N/A   52.5153884 -1.8527437
2323 op-snap---monthly-publication-august-2025.pdf   298 2025-08 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Camphill Circus Camphill Circus Birmingham Birmingham Fixed Penalty N/A      
2324 op-snap---monthly-publication-august-2025.pdf   299 2025-08 Pedal Bike Audi RS3 Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
2325 op-snap---monthly-publication-august-2025.pdf   300 2025-08 Other Volkswagen golf Blue Driving without Due Care and Attention None Reddings Lane Reddings Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4506039 -1.8463952
2358 op-snap---monthly-publication-august-2025.pdf   333 2025-08 Car Audi Q3 Silver Driving without Due Care and Attention None A457 Dudley Road Dudley Road Birmingham Birmingham NFA No Independent Evidence Available   52.4865107 -1.9386263
2359 op-snap---monthly-publication-august-2025.pdf   334 2025-08 Car Mercedes-Benz C-class Silver Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.471632 -1.9456776
2363 op-snap---monthly-publication-august-2025.pdf   338 2025-08 Car Seat False plates Black Driving without Due Care and Attention Keeping a vehicle with registration marks oBbisllceusrleeyd Lane o Bbisllceusrleeyd Lane Birmingham Birmingham NFA Misc Inc Crimes      
2366 op-snap---monthly-publication-august-2025.pdf   341 2025-08 Car Honda Jazz Yellow Driving without Due Care and Attention None Longmore Street Longmore Street Birmingham Birmingham Court N/A   52.464484 -1.8923374
2370 op-snap---monthly-publication-august-2025.pdf   345 2025-08 Pedestrian Mazda CX-30 Red Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
2373 op-snap---monthly-publication-august-2025.pdf   348 2025-08 Car Vauxhall Combo Silver Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Education N/A   52.470423 -1.9304786
2380 op-snap---monthly-publication-august-2025.pdf   355 2025-08 Car Volvo XC40 Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Education N/A   52.470423 -1.9304786
2382 op-snap---monthly-publication-august-2025.pdf   357 2025-08 Car Mercedes-Benz A-class Grey Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham RTC - Actioned N/A   52.5148331 -1.79231
2389 op-snap---monthly-publication-august-2025.pdf   364 2025-08 Car Ford Transit White Driving without Due Care and Attention None Wyrley Road Wyrley Road Birmingham Birmingham Warning Letter N/A   52.5172973 -1.8785949
2391 op-snap---monthly-publication-august-2025.pdf   366 2025-08 Car Seat Ibiza Black Driving without Due Care and Attention None Wyrley Road Wyrley Road Birmingham Birmingham Education N/A   52.5172973 -1.8785949
2392 op-snap---monthly-publication-august-2025.pdf   367 2025-08 Car Skoda Octavia Grey Driving without Due Care and Attention None A38 Queensway Queensway Birmingham Birmingham Warning Letter N/A   52.4856447 -1.8972389
2394 op-snap---monthly-publication-august-2025.pdf   369 2025-08 Car Mg   White Driving without Due Care and Attention None A4040 A4040 Birmingham Birmingham Education N/A      
2398 op-snap---monthly-publication-august-2025.pdf   373 2025-08 Car Honda FR Grey Driving without Due Care and Attention None Cole Bank Road Cole Bank Road Birmingham Birmingham NFA No Offence   52.4349375 -1.8510007
2400 op-snap---monthly-publication-august-2025.pdf   375 2025-08 Car Audi TT Grey Driving without Due Care and Attention None Cole Hall Lane Cole Hall Lane Birmingham Birmingham Education N/A   52.4877244 -1.787883
2407 op-snap---monthly-publication-august-2025.pdf   382 2025-08 Pedal Bike Toyota Yaris Grey Driving without Due Care and Attention None Woodland Road Woodland Road Birmingham Birmingham Education N/A   52.4108681 -1.9611917
2410 op-snap---monthly-publication-august-2025.pdf   385 2025-08 Car Land Rover Range Rover Black Driving without Due Care and Attention None M5 Northbound M5 Northbound Birmingham Birmingham NFA No Independent Evidence Available      
2413 op-snap---monthly-publication-august-2025.pdf   388 2025-08 Car Ford Mustang Grey Driving without Due Care and Attention None Rotten Park Road Rotten Park Road Birmingham Birmingham Education N/A      
2424 op-snap---monthly-publication-august-2025.pdf   399 2025-08 car Audi Q2 Grey Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Court N/A   52.4865107 -1.9386263
2427 op-snap---monthly-publication-august-2025.pdf   402 2025-08 Car Mercedes-Benz A Class Silver Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4801772 -1.8769185
2428 op-snap---monthly-publication-august-2025.pdf   403 2025-08 Motorbike BMW 5 series White Driving without Due Care and Attention None Alcester Road / Salisbury Road Alcester Road / Salisbury Road Birmingham Birmingham Warning Letter N/A   52.4467548 -1.8880528
2437 op-snap---monthly-publication-august-2025.pdf   412 2025-08 Car Ford Fiesta Silver Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Warning Letter N/A   52.4221526 -1.8425617
2438 op-snap---monthly-publication-august-2025.pdf   413 2025-08 Car Mercedes-Benz b180 Black Driving without Due Care and Attention None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham NFA No Offence   52.4861917 -1.8829748
2442 op-snap---monthly-publication-august-2025.pdf   417 2025-08 Car Volvo Car transpoerter Grey Driving without Due Care and Attention None Mucklow Hill Mucklow Hill Birmingham Birmingham NFA No Offence      
2443 op-snap---monthly-publication-august-2025.pdf   418 2025-08 Car Ford Focus Grey Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
2445 op-snap---monthly-publication-august-2025.pdf   420 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Constitution Hill Constitution Hill Birmingham Birmingham Warning Letter N/A   52.4866022 -1.901562
2446 op-snap---monthly-publication-august-2025.pdf   421 2025-08 Car Toyota Corolla White Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
2455 op-snap---monthly-publication-august-2025.pdf   430 2025-08 Car Volkswagen Golf White Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
2456 op-snap---monthly-publication-august-2025.pdf   431 2025-08 Car Toyota Aygo Red Driving without Due Care and Attention None Bromfield Lane Bromfield Lane Birmingham Birmingham Warning Letter N/A      
2460 op-snap---monthly-publication-august-2025.pdf   435 2025-08 Car Fiat 500 Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
2472 op-snap---monthly-publication-august-2025.pdf   447 2025-08 Car Volkswagen Polo White Driving without Due Care and Attention None Bell Lane A38 Bell Lane A38 Birmingham Birmingham NFA No Independent Evidence Available   52.4166966 -1.9699974
2473 op-snap---monthly-publication-august-2025.pdf   448 2025-08 Car   Unknown   Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
2478 op-snap---monthly-publication-august-2025.pdf   453 2025-08 Pedal Bike Mercedes-Benz C300 Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
2485 op-snap---monthly-publication-august-2025.pdf   460 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA Outside of 14 Days NIP      

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