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

136 rows where disposal = "Education", 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, council_area_raw

reporter_transport_mode 6

offence 1

  • Driving without Due Care and Attention · 136 ✖

month 1

  • 2025-08 · 136 ✖

disposal 1

  • Education · 136 ✖
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
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      
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      
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      
2054 op-snap---monthly-publication-august-2025.pdf   29 2025-08 Car Ford Puma Grey Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley Education N/A   52.4881161 -2.1199108
2058 op-snap---monthly-publication-august-2025.pdf   33 2025-08 Car Ford Fiesta Grey Driving without Due Care and Attention None Blake Street Blake Street Sutton Coldfield Sutton Coldfield Education N/A   52.6043776 -1.8446597
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
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
2110 op-snap---monthly-publication-august-2025.pdf   85 2025-08 Car Seat Tarraco Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
2118 op-snap---monthly-publication-august-2025.pdf   93 2025-08 Car Lexus CT Black Driving without Due Care and Attention None     Coventry Coventry Education N/A      
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
2123 op-snap---monthly-publication-august-2025.pdf   98 2025-08 Lorry Jaguar I Pace Blue Driving without Due Care and Attention None M42 M42 Solihull Solihull Education N/A      
2126 op-snap---monthly-publication-august-2025.pdf   101 2025-08 Car Hyundai I30 White Driving without Due Care and Attention None Upper Church Road Upper Church Road Walsall Walsall Education N/A      
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
2129 op-snap---monthly-publication-august-2025.pdf   104 2025-08 Car BMW 330 Black Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2130 op-snap---monthly-publication-august-2025.pdf   105 2025-08 Car Mercedes-Benz AMG White Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2138 op-snap---monthly-publication-august-2025.pdf   113 2025-08 Pedestrian Volvo XC60 Grey Driving without Due Care and Attention None Sandyfields Road Sandyfields Road Dudley Dudley Education N/A   52.5334161 -2.1371465
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
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
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
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      
2210 op-snap---monthly-publication-august-2025.pdf   185 2025-08 Other Renault Clio White Driving without Due Care and Attention None Waterfront Merry Hill Waterfront Merry Hill Dudley Dudley Education N/A   52.4874176 -2.1129449
2212 op-snap---monthly-publication-august-2025.pdf   187 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Barrs Road Cradley Heath Barrs Road Cradley Heath Sandwell Sandwell Education N/A   52.4682935 -2.0660364
2215 op-snap---monthly-publication-august-2025.pdf   190 2025-08 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Hatherton Street Hatherton Street Walsall Walsall Education N/A   52.5880551 -1.9796606
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
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
2233 op-snap---monthly-publication-august-2025.pdf   208 2025-08 Car Vauxhall Agila Red Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
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      
2242 op-snap---monthly-publication-august-2025.pdf   217 2025-08 Car Volkswagen Golf Red Driving without Due Care and Attention None Puma Way Puma Way Coventry Coventry Education N/A   52.401984 -1.5046079
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
2263 op-snap---monthly-publication-august-2025.pdf   238 2025-08 Car Toyota Yaris Black Driving without Due Care and Attention None Coventry Road Coventry Road Solihull Solihull Education N/A   52.4505232 -1.7606378
2284 op-snap---monthly-publication-august-2025.pdf   259 2025-08 Pedal Bike Ford B Max Blue Driving without Due Care and Attention None Station Road Station Road Solihull Solihull Education N/A   52.3927253 -1.6455823
2288 op-snap---monthly-publication-august-2025.pdf   263 2025-08 Car Vauxhall Corsa White Driving without Due Care and Attention None     Sandwell Sandwell Education N/A      
2306 op-snap---monthly-publication-august-2025.pdf   281 2025-08 Car Skoda Yeti Grey Driving without Due Care and Attention None Black Country New Road Black Country New Road Sandwell Sandwell Education N/A   52.5527191 -2.0312967
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
2321 op-snap---monthly-publication-august-2025.pdf   296 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Longford Road Longford Road Coventry Coventry Education N/A   52.445164 -1.4879298
2326 op-snap---monthly-publication-august-2025.pdf   301 2025-08 Pedal Bike Vauxhall Grandland Blue Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Education N/A   52.6095168 -2.0493009
2340 op-snap---monthly-publication-august-2025.pdf   315 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Longford Longford Coventry Coventry Education N/A   52.4516182 -1.4885443
2345 op-snap---monthly-publication-august-2025.pdf   320 2025-08 Other Mercedes-Benz C-class Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
2347 op-snap---monthly-publication-august-2025.pdf   322 2025-08 Car Ford Mondeo Blue Driving without Due Care and Attention None A463 A463 Wolverhampton Wolverhampton Education N/A      
2365 op-snap---monthly-publication-august-2025.pdf   340 2025-08 Pedal Bike Renault Scenic Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Walsall Walsall Education N/A   52.64682 -1.9259844
2369 op-snap---monthly-publication-august-2025.pdf   344 2025-08 Pedal Bike Mercedes-Benz EClass White Driving without Due Care and Attention None Underhill Road Underhill Road Wolverhampton Wolverhampton Education N/A      
2371 op-snap---monthly-publication-august-2025.pdf   346 2025-08 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
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
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
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      
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
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      
2433 op-snap---monthly-publication-august-2025.pdf   408 2025-08 Motorbike Skoda Yeti Silver Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Education N/A   52.6095168 -2.0493009
2435 op-snap---monthly-publication-august-2025.pdf   410 2025-08 Car Audi SQ5 White Driving without Due Care and Attention None Daventry Road Daventry Road Coventry Coventry Education N/A   52.3930931 -1.4976428
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
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
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
2468 op-snap---monthly-publication-august-2025.pdf   443 2025-08 Car BMW 320 Grey Driving without Due Care and Attention None Neachells Lane Neachells Lane Wolverhampton Wolverhampton Education N/A   52.597459 -2.0791894
2506 op-snap---monthly-publication-august-2025.pdf   481 2025-08 Car Volkswagen Toureg Grey Driving without Due Care and Attention None Norton Road Norton Road Dudley Dudley Education N/A   52.4483733 -2.1546673
2508 op-snap---monthly-publication-august-2025.pdf   483 2025-08 Car S Sangyong Tivoli Silver Driving without Due Care and Attention None Green Lane Green Lane Walsall Walsall Education N/A   52.5995834 -1.9971273
2523 op-snap---monthly-publication-august-2025.pdf   498 2025-08 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Middle Park Road Middle Park Road Birmingham Birmingham Education N/A   52.433278 -1.956176
2527 op-snap---monthly-publication-august-2025.pdf   502 2025-08 Lorry Ford Fiesta Silver Driving without Due Care and Attention None A458 Lye By Pass Lye By Pass Dudley Dudley Education N/A   52.4589885 -2.1160387
2532 op-snap---monthly-publication-august-2025.pdf   507 2025-08 Pedal Bike Audi RS5 White Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A      
2547 op-snap---monthly-publication-august-2025.pdf   522 2025-08 Car Citroen DS£ Red Driving without Due Care and Attention None A452 Spitfire Island Spitfire Island Birmingham Birmingham Education N/A   52.5138106 -1.797297
2552 op-snap---monthly-publication-august-2025.pdf   527 2025-08 Pedal Bike Mercedes-Benz AMG Blue Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A      
2554 op-snap---monthly-publication-august-2025.pdf   529 2025-08 Pedal Bike Vauxhall Mokka Grey Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A      
2572 op-snap---monthly-publication-august-2025.pdf   547 2025-08 Pedal Bike Mercedes-Benz sprinter White Driving without Due Care and Attention None Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
2590 op-snap---monthly-publication-august-2025.pdf   565 2025-08 Pedal Bike Volkswagen Polo Blue Driving without Due Care and Attention None Green Lane Green Lane Solihull Solihull Education N/A   52.5069826 -1.7643766
2594 op-snap---monthly-publication-august-2025.pdf   569 2025-08 Pedal Bike Renault Clio Blue Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Education N/A   52.402753 -1.5385829
2599 op-snap---monthly-publication-august-2025.pdf   574 2025-08 Other Peugeot 3008 Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
2606 op-snap---monthly-publication-august-2025.pdf   581 2025-08 Pedal Bike Mercedes-Benz GLC 220 Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
2615 op-snap---monthly-publication-august-2025.pdf   590 2025-08 Pedal Bike BMW 120D Black Driving without Due Care and Attention None Rayner Road Rayner Road Wolverhampton Wolverhampton Education N/A      
2642 op-snap---monthly-publication-august-2025.pdf   617 2025-08 Other Toyota Hi Lux Grey Driving without Due Care and Attention None Norwood Rpad Norwood Rpad Dudley Dudley Education N/A      
2647 op-snap---monthly-publication-august-2025.pdf   622 2025-08 Car Ford Transit White Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
2661 op-snap---monthly-publication-august-2025.pdf   636 2025-08 Car Vauxhall Mokka Blue Driving without Due Care and Attention None Stonebridge Island Stonebridge Island Coventry Coventry Education N/A   52.4459998 -1.6949291
2671 op-snap---monthly-publication-august-2025.pdf   646 2025-08 Car Audi A4 Blue Driving without Due Care and Attention None Olton Boulevard East Olton Boulevard East Solihull Solihull Education N/A   52.4430078 -1.8124079
2674 op-snap---monthly-publication-august-2025.pdf   649 2025-08 Car BMW 118.. Grey Driving without Due Care and Attention None Egghill Lane Egghill Lane Birmingham Birmingham Education N/A   52.4093768 -1.9976236
2686 op-snap---monthly-publication-august-2025.pdf   661 2025-08 Car Kia Picanto Blue Driving without Due Care and Attention None Clevedon Road Clevedon Road Birmingham Birmingham Education N/A   52.4618531 -1.894645
2687 op-snap---monthly-publication-august-2025.pdf   662 2025-08 Car Mg GS White Driving without Due Care and Attention None Icknield Street Icknield Street Birmingham Birmingham Education N/A   52.5709191 -1.8759339
2715 op-snap---monthly-publication-august-2025.pdf   690 2025-08 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Education N/A      
2723 op-snap---monthly-publication-august-2025.pdf   698 2025-08 Car Volkswagen Golf Red Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Education N/A   52.4708802 -1.8792135
2726 op-snap---monthly-publication-august-2025.pdf   701 2025-08 Car BMW X5 Silver Driving without Due Care and Attention None Holford Drive Holford Drive Birmingham Birmingham Education N/A   52.5216608 -1.8903521
2736 op-snap---monthly-publication-august-2025.pdf   711 2025-08 Car Citroen C1 Black Driving without Due Care and Attention None Sir Herbert Austin Way Sir Herbert Austin Way Birmingham Birmingham Education N/A   52.4132666 -1.9735631
2741 op-snap---monthly-publication-august-2025.pdf   716 2025-08 Car Vauxhall Corsa Red Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
2742 op-snap---monthly-publication-august-2025.pdf   717 2025-08 Car Nissan Acenta White Driving without Due Care and Attention None St Stephens Road Street Stephens Road Birmingham Birmingham Education N/A      
2766 op-snap---monthly-publication-august-2025.pdf   741 2025-08 Pedal Bike Ford C Max Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5872149 -1.8300386
2775 op-snap---monthly-publication-august-2025.pdf   750 2025-08 Car Ford Fiesta Red Driving without Due Care and Attention None Stanhope Road Stanhope Road Sandwell Sandwell Education N/A   52.4817557 -1.9769853
2780 op-snap---monthly-publication-august-2025.pdf   755 2025-08 Car Mercedes-Benz Vito White Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Wolverhampton Wolverhampton Education N/A   52.5560698 -2.1044322
2783 op-snap---monthly-publication-august-2025.pdf   758 2025-08 Car Volkswagen golf Blue Driving without Due Care and Attention None Halesowen Road Halesowen Road Birmingham Birmingham Education N/A      
2785 op-snap---monthly-publication-august-2025.pdf   760 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Belgrave Interchange Belgrave Interchange Birmingham Birmingham Education N/A   52.466118 -1.8982999
2786 op-snap---monthly-publication-august-2025.pdf   761 2025-08 Pedal Bike Mercedes-Benz GLA Black Driving without Due Care and Attention None Pritchatts Road Pritchatts Road Birmingham Birmingham Education N/A   52.4522304 -1.9267446
2824 op-snap---monthly-publication-august-2025.pdf   799 2025-08 Pedal Bike Mini Cooper Black Driving without Due Care and Attention None Dovehouse Lane Dovehouse Lane Solihull Solihull Education N/A   52.4319915 -1.7915192
2825 op-snap---monthly-publication-august-2025.pdf   800 2025-08 Pedal Bike Mitsubishi Shogun Black Driving without Due Care and Attention None Dovehouse Lane Dovehouse Lane Solihull Solihull Education N/A   52.4319915 -1.7915192
2832 op-snap---monthly-publication-august-2025.pdf   807 2025-08 Car Toyota Prius White Driving without Due Care and Attention None Court Way Court Way Walsall Walsall Education N/A   52.5884303 -1.9862688
2840 op-snap---monthly-publication-august-2025.pdf   815 2025-08 Car Honda JAZZ Red Driving without Due Care and Attention None B4102 B4102 Solihull Solihull Education N/A   52.4045574 -1.8056034
2861 op-snap---monthly-publication-august-2025.pdf   836 2025-08 Car Seat Ibiza Red Driving without Due Care and Attention None Coventry Road / Talbot Road Coventry Road / Talbot Road Birmingham Birmingham Education N/A   52.4513272 -1.7638967
2876 op-snap---monthly-publication-august-2025.pdf   851 2025-08 Car Volkswagen Golf White Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
2879 op-snap---monthly-publication-august-2025.pdf   854 2025-08 Car Toyota Aygo White Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226

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