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

92 rows where disposal = "Education", month = "2025-03" 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, nfa_rationale

reporter_transport_mode 6

offence 1

  • Driving without Due Care and Attention · 92 ✖

month 1

  • 2025-03 · 92 ✖

disposal 1

  • Education · 92 ✖
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
16287 op-snap---monthly-publication-march-2025.pdf   44 2025-03 Car BMW M235i Black Driving without Due Care and Attention None M6 j7 to 6 M6 j7 to 6 Birmingham Birmingham Education N/A Yes - Via Email 52.676119 -2.0858425
16327 op-snap---monthly-publication-march-2025.pdf   84 2025-03 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Stivichall Croft Stivichall Croft Coventry Coventry Education N/A Yes - Via Email 52.387363 -1.522136
16340 op-snap---monthly-publication-march-2025.pdf   97 2025-03 Car Audi A5 White Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham Education N/A Yes - Via Email 52.5148331 -1.79231
16353 op-snap---monthly-publication-march-2025.pdf   110 2025-03 Other Hyundai I10 Blue Driving without Due Care and Attention None Stone Steet Stone Steet Dudley Dudley Education N/A Yes - Via Email    
16379 op-snap---monthly-publication-march-2025.pdf   136 2025-03 Pedestrian Mercedes-Benz A180 Grey Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham Education N/A Yes - Via Email 52.4398245 -1.8469786
16380 op-snap---monthly-publication-march-2025.pdf   137 2025-03 Pedal Bike Daf Truck - Concrete Mixer Green Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Education N/A Yes - Via Email 52.4235908 -1.5226276
16381 op-snap---monthly-publication-march-2025.pdf   138 2025-03 Pedal Bike Alfa Romeo Giulietta Red Driving without Due Care and Attention None Lichfield Road, Sutton Coldfield Lichfield Road, Sutton Coldfield Birmingham Birmingham Education N/A Yes - Via Email 52.5724042 -1.8239307
16414 op-snap---monthly-publication-march-2025.pdf   171 2025-03 Motorbike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Vicar Street at Dudley Road Sedgley Vicar Street at Dudley Road Sedgley Dudley Dudley Education N/A Yes - Via Email 52.5081139 -2.0856851
16420 op-snap---monthly-publication-march-2025.pdf   177 2025-03 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
16434 op-snap---monthly-publication-march-2025.pdf   191 2025-03 Car Seat Arona White Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Education N/A Yes - Via Email 52.4235908 -1.5226276
16448 op-snap---monthly-publication-march-2025.pdf   205 2025-03 Car Dacia Sandero Green Driving without Due Care and Attention None Mackadown Lane Mackadown Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4708415 -1.7675939
16460 op-snap---monthly-publication-march-2025.pdf   217 2025-03 Car Vauxhall Zafira Silver Driving without Due Care and Attention None A45, B4137 Roundabout A45, B4137 Roundabout Birmingham Birmingham Education N/A Yes - Via Email    
16465 op-snap---monthly-publication-march-2025.pdf   222 2025-03 Car Audi A1 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
16520 op-snap---monthly-publication-march-2025.pdf   277 2025-03 Car Volkswagen T-Roc Blue Driving without Due Care and Attention None Wing Foot Way Wing Foot Way Birmingham Birmingham Education n/a Yes - Via Email    
16551 op-snap---monthly-publication-march-2025.pdf   308 2025-03 Pedal Bike Land Rover Evoque Red Driving without Due Care and Attention None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16556 op-snap---monthly-publication-march-2025.pdf   313 2025-03 Car BMW 518D Silver Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A Yes - Via Email 52.4390303 -1.9512931
16610 op-snap---monthly-publication-march-2025.pdf   367 2025-03 Car Toyota AVENSIS Silver Driving without Due Care and Attention None HARBORNE ROAD Harborne Road Birmingham Birmingham Education N/A Yes - Via Email 52.4718503 -1.9195423
16669 op-snap---monthly-publication-march-2025.pdf   426 2025-03 Car Vauxhall Mokka White Driving without Due Care and Attention None Summerhill Street Summerhill Street Birmingham Birmingham Education N/A Yes - Via Email    
16686 op-snap---monthly-publication-march-2025.pdf   443 2025-03 Lorry Land Rover Discovery Grey Driving without Due Care and Attention None M6 jct 9 heading onto M6 south M6 jct 9 heading onto M6 south Birmingham Birmingham Education N/A Yes - Via Email 52.676119 -2.0858425
16715 op-snap---monthly-publication-march-2025.pdf   472 2025-03 Car Citroen Berlingo 1000 Grey Driving without Due Care and Attention None A446 Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
16718 op-snap---monthly-publication-march-2025.pdf   475 2025-03 Car Honda Jazz Grey Driving without Due Care and Attention None B4102 Blossomfield Road Blossomfield Road Solihull Solihull Education N/A Yes - Via Email 52.4144779 -1.7848758
16756 op-snap---monthly-publication-march-2025.pdf   513 2025-03 Pedestrian Volvo XC40 Black Driving without Due Care and Attention None Herbert Road Herbert Road Solihull Solihull Education N/A Yes - Via Email 52.413399 -1.7818177
16794 op-snap---monthly-publication-march-2025.pdf   551 2025-03 Pedal Bike Honda WW 125 White Driving without Due Care and Attention None Bristol Street Bristol Street Birmingham Birmingham Education N/A Yes - Via Email 52.4691145 -1.9003257
16797 op-snap---monthly-publication-march-2025.pdf   554 2025-03 Car Volkswagen GOLF Black Driving without Due Care and Attention None JUNCTION 10 M6 Junction 10 M6 Wolverhampton Wolverhampton Education N/A Yes - Via Email    
16816 op-snap---monthly-publication-march-2025.pdf   573 2025-03 Car Volkswagen Tiguan White Driving without Due Care and Attention None A38 Bristol Street Bristol Street Birmingham Birmingham Education N/A Yes - Via Email 52.4691145 -1.9003257
16864 op-snap---monthly-publication-march-2025.pdf   621 2025-03 Motorbike Vauxhall Insignia Silver Driving without Due Care and Attention None Brades Road Brades Road Sandwell Sandwell Education N/A Yes - Via Email 52.5087861 -2.0285026
16878 op-snap---monthly-publication-march-2025.pdf   635 2025-03 Car Seat Mii. Silver Driving without Due Care and Attention none Kingstanding Road Kingstanding Road Birmingham Birmingham Education N/A Yes - Via Email 52.5521118 -1.8845138
16886 op-snap---monthly-publication-march-2025.pdf   643 2025-03 Car BMW 6-series Blue Driving without Due Care and Attention None Old Pleck Road Old Pleck Road Walsall Walsall Education N/A Yes - Via Email 52.5747536 -2.0007419
16964 op-snap---monthly-publication-march-2025.pdf   721 2025-03 Car Volkswagen Polo Grey Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
16983 op-snap---monthly-publication-march-2025.pdf   740 2025-03 Car Seat Ibiza Silver Driving without Due Care and Attention None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Education N/A Yes - Via Email 52.473883 -1.9198244
16998 op-snap---monthly-publication-march-2025.pdf   755 2025-03 Car Volvo XC40 Silver Driving without Due Care and Attention None M42 M6 M42 M6 Birmingham Birmingham Education N/A Yes - Via Email 52.5184417 -1.8723226
17001 op-snap---monthly-publication-march-2025.pdf   758 2025-03 Pedal Bike Ford Focus Black Driving without Due Care and Attention None Alma Street Alma Street Coventry Coventry Education N/A Yes - Via Email 52.4097148 -1.500004
17015 op-snap---monthly-publication-march-2025.pdf   772 2025-03 Pedal Bike Ford focus Red Driving without Due Care and Attention None Valenting Road Valenting Road Birmingham Birmingham Education N/A Yes - Via Email    
17019 op-snap---monthly-publication-march-2025.pdf   776 2025-03 Car Renault Master White Driving without Due Care and Attention None Church Street Church Street Dudley Dudley Education N/A Yes - Via Email 52.4737921 -2.0330173
17020 op-snap---monthly-publication-march-2025.pdf   777 2025-03 Car Volkswagen Toureg Black Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A Yes - Via Email    
17058 op-snap---monthly-publication-march-2025.pdf   815 2025-03 Car Mercedes-Benz Citan White Driving without Due Care and Attention None Montague Sreet Montague Sreet Birmingham Birmingham Education N/A Yes - Via Email    
17059 op-snap---monthly-publication-march-2025.pdf   816 2025-03 Car Alfa Romeo Giulietta Grey Driving without Due Care and Attention None Montague Sreet Montague Sreet Birmingham Birmingham Education N/A Yes - Via Email    
17061 op-snap---monthly-publication-march-2025.pdf   818 2025-03 Car Toyota   Grey Driving without Due Care and Attention None Montague Sreet Montague Sreet Birmingham Birmingham Education N/A Yes - Via Email    
17062 op-snap---monthly-publication-march-2025.pdf   819 2025-03 Car Lexus   Grey Driving without Due Care and Attention None Montague Sreet Montague Sreet Birmingham Birmingham Education N/A Yes - Via Email    
17063 op-snap---monthly-publication-march-2025.pdf   820 2025-03 Car Volvo XC40 Black Driving without Due Care and Attention None Montague Sreet Montague Sreet Birmingham Birmingham Education N/A Yes - Via Email    
17094 op-snap---monthly-publication-march-2025.pdf   851 2025-03 Car Mercedes-Benz CLG Grey Driving without Due Care and Attention None Brandwood road Brandwood road Birmingham Birmingham Education N/A Yes - Via Email 52.4139427 -1.9037653
17157 op-snap---monthly-publication-march-2025.pdf   914 2025-03 Pedestrian Kia Niro Blue Driving without Due Care and Attention None Vittoria Street Vittoria Street Birmingham Birmingham Education N/A Yes - Via Email 52.4851181 -1.9106263
17184 op-snap---monthly-publication-march-2025.pdf   941 2025-03 Car BMW BMw Black Driving without Due Care and Attention None Stonebridge Island Stonebridge Island Birmingham Birmingham Education N/A Yes - Via Email    
17214 op-snap---monthly-publication-march-2025.pdf   971 2025-03 Car Fiat Punto Red Driving without Due Care and Attention None A45 Small Heath Bypass Small Heath Bypass Birmingham Birmingham Education N/A Yes - Via Email    
17227 op-snap---monthly-publication-march-2025.pdf   984 2025-03 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Wednesbury Road Wednesbury Road Walsall Walsall Education N/A Yes - Via Email 52.5738499 -1.9961575
17234 op-snap---monthly-publication-march-2025.pdf   991 2025-03 Car Volkswagen Transporter Grey Driving without Due Care and Attention None Birmingham Road Perry Barr Birmingham Road Perry Barr Birmingham Birmingham Education N/A Yes - Via Email 52.5309256 -1.9061963
17280 op-snap---monthly-publication-march-2025.pdf   1037 2025-03 Car Ford Transit White Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull Education N/A Yes - Via Email 52.4191184 -1.8326637
17299 op-snap---monthly-publication-march-2025.pdf   1056 2025-03 Car Vauxhall Meriva White Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
17305 op-snap---monthly-publication-march-2025.pdf   1062 2025-03 Car Mazda 3 White Driving without Due Care and Attention None Farnborough Road, Castle Vale Farnborough Road, Castle Vale Birmingham Birmingham Education N/A Yes - Via Email 52.5148331 -1.79231
17319 op-snap---monthly-publication-march-2025.pdf   1076 2025-03 Car Volkswagen move-up Red Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
17340 op-snap---monthly-publication-march-2025.pdf   1097 2025-03 Car Nissan Juke Beige Driving without Due Care and Attention None St Chads Queensway out of city Street Chads Queensway out of city Birmingham Birmingham Education N/A Yes - Via Email    
17348 op-snap---monthly-publication-march-2025.pdf   1105 2025-03 Car Audi A1 Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Education N/A Yes - Via Email 52.470423 -1.9304786
17404 op-snap---monthly-publication-march-2025.pdf   1161 2025-03 Car Nissan Note White Driving without Due Care and Attention None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A Yes - Via Email 52.4437078 -1.8783408
17406 op-snap---monthly-publication-march-2025.pdf   1163 2025-03 Car Renault PARTNER Grey Driving without Due Care and Attention None GREEN LANE ROAD Green Lane Road Birmingham Birmingham Education N/A Yes - Via Email 52.3954164 -2.0120756
17419 op-snap---monthly-publication-march-2025.pdf   1176 2025-03 Car Seat Arona Black Driving without Due Care and Attention None Coventry Road Coventry Road Solihull Solihull Education N/A Yes - Via Email 52.4505232 -1.7606378
17448 op-snap---monthly-publication-march-2025.pdf   1205 2025-03 Pedal Bike Peugeot 2008 Black Driving without Due Care and Attention None OLD PARK ROAD Old Park Road Sandwell Sandwell Education N/A Yes - Via Email 52.5612071 -2.0247828
17463 op-snap---monthly-publication-march-2025.pdf   1220 2025-03 Car Volkswagen Golf Black Driving without Due Care and Attention None Bell Hill Bell Hill Birmingham Birmingham Education N/A Yes - Via Email 52.4179505 -1.9696413
17505 op-snap---monthly-publication-march-2025.pdf   1262 2025-03 Car Toyota C-HR White Driving without Due Care and Attention None Warwards Lane Warwards Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4366272 -1.9239954
17509 op-snap---monthly-publication-march-2025.pdf   1266 2025-03 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Education N/A Yes - Via Email 52.471632 -1.9456776
17510 op-snap---monthly-publication-march-2025.pdf   1267 2025-03 Pedal Bike Citroen Picasso Red Driving without Due Care and Attention None Waterfall Lane Waterfall Lane Sandwell Sandwell Education N/A Yes - Via Email 52.4745234 -2.0503509
17543 op-snap---monthly-publication-march-2025.pdf   1300 2025-03 Car BMW M140 Black Driving without Due Care and Attention None Burton Road Burton Road Dudley Dudley Education N/A Yes - Via Email 52.5248087 -2.1098939
17564 op-snap---monthly-publication-march-2025.pdf   1321 2025-03 Car Audi A3 Black Driving without Due Care and Attention None Lawley Middlway Lawley Middlway Birmingham Birmingham Education N/A Yes - Via Email    
17565 op-snap---monthly-publication-march-2025.pdf   1322 2025-03 Car Volkswagen Polo Grey Driving without Due Care and Attention None Small Heath Highway Small Heath Highway Birmingham Birmingham Education N/A Yes - Via Email 52.4709298 -1.8722585
17585 op-snap---monthly-publication-march-2025.pdf   1342 2025-03 Car Mercedes-Benz A200 Silver Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
17689 op-snap---monthly-publication-march-2025.pdf   1446 2025-03 Car Ford Fiesta Blue Driving without Due Care and Attention None Lawley Middleway, Birmingham Lawley Middleway, Birmingham Birmingham Birmingham Education N/A Yes - Via Email 52.4856388 -1.8823789
17708 op-snap---monthly-publication-march-2025.pdf   1465 2025-03 Car BMW 118 Blue Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Education N/A Yes - Via Email 52.5242452 -1.8572541
17712 op-snap---monthly-publication-march-2025.pdf   1469 2025-03 Car Vauxhall transit Black Driving without Due Care and Attention None BROMFORD LANE Bromford Lane Birmingham Birmingham Education N/A Yes - Via Email 52.5083238 -1.8332287
17717 op-snap---monthly-publication-march-2025.pdf   1474 2025-03 Car Audi A5 White Driving without Due Care and Attention None M6 JCT 8/9 M6 Jct 8/9 Walsall Walsall Education N/A Yes - Via Email 52.6760749 -2.0862582
17785 op-snap---monthly-publication-march-2025.pdf   1542 2025-03 Car Citroen Cactus Silver Driving without Due Care and Attention None Hampstead Road Hampstead Road Birmingham Birmingham Education N/A Yes - Via Email 52.3993507 -1.9640409
17795 op-snap---monthly-publication-march-2025.pdf   1552 2025-03 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Moseley Road Moseley Road Birmingham Birmingham Education N/A Yes - Via Email 52.4679402 -1.881408
17818 op-snap---monthly-publication-march-2025.pdf   1575 2025-03 Car Mercedes-Benz B CLASS White Driving without Due Care and Attention None Horner way Horner way Sandwell Sandwell Education N/A Yes - Via Email 52.4735009 -2.0396978
17828 op-snap---monthly-publication-march-2025.pdf   1585 2025-03 Car Mercedes-Benz SPRINTER White Driving without Due Care and Attention None PEDMORE ROAD Pedmore Road Dudley Dudley Education N/A Yes - Via Email 52.4897451 -2.1069141
17894 op-snap---monthly-publication-march-2025.pdf   1651 2025-03 Car Ford FOCUS Black Driving without Due Care and Attention None A45 COVENTRY ROAD A45 Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4714538 -1.8627901
17895 op-snap---monthly-publication-march-2025.pdf   1652 2025-03 Car Audi S3 White Driving without Due Care and Attention None A45 COVENTRY ROAD A45 Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4714538 -1.8627901
17903 op-snap---monthly-publication-march-2025.pdf   1660 2025-03 Pedal Bike Porsche 911 Grey Driving without Due Care and Attention None Lyons Queensway Lyons Queensway Birmingham Birmingham Education N/A Yes - Via Email    
17936 op-snap---monthly-publication-march-2025.pdf   1693 2025-03 Car Toyota Aygo Black Driving without Due Care and Attention None Newton Road Newton Road Sandwell Sandwell Education N/A Yes - Via Email 52.5428224 -1.9569444
17972 op-snap---monthly-publication-march-2025.pdf   1729 2025-03 Pedal Bike Vauxhall Zafira Black Driving without Due Care and Attention None Sandwell Road Sandwell Road Birmingham Birmingham Education N/A Yes - Via Email 52.5082522 -1.9487918
17996 op-snap---monthly-publication-march-2025.pdf   1753 2025-03 Car Audi A5 Black Driving without Due Care and Attention None M6 JCT 9 M6 Jct 9 Walsall Walsall Education N/A Yes - Via Email 52.676119 -2.0858425
18024 op-snap---monthly-publication-march-2025.pdf   1781 2025-03 Car Toyota MPV White Driving without Due Care and Attention None Coventry Road at Kings Road Coventry Road at Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
18044 op-snap---monthly-publication-march-2025.pdf   1801 2025-03 Car Vauxhall Combo Red Driving without Due Care and Attention None The Radley's, The Radley's Birmingham Birmingham Education N/A Yes - Via Email    
18105 op-snap---monthly-publication-march-2025.pdf   1862 2025-03 Car Ford Fiesta Black Driving without Due Care and Attention None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A Yes - Via Email 52.4071231 -1.4985178
18111 op-snap---monthly-publication-march-2025.pdf   1868 2025-03 Car Ford Ranger Black Driving without Due Care and Attention None Telford Way Telford Way Sandwell Sandwell Education N/A Yes - Via Email 52.5041001 -1.9769903
18126 op-snap---monthly-publication-march-2025.pdf   1883 2025-03 Car Kia Sportage Green Driving without Due Care and Attention None Tenbury Road Kings Heath Tenbury Road Kings Heath Birmingham Birmingham Education N/A Yes - Via Email 52.4264041 -1.8966768
18163 op-snap---monthly-publication-march-2025.pdf   1920 2025-03 Car Ford PUMA Black Driving without Due Care and Attention None CHESTER ROAD Chester Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5359496 -1.8324115
18171 op-snap---monthly-publication-march-2025.pdf   1928 2025-03 Pedal Bike Vauxhall Zafira Grey Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Education N/A Yes - Via Email 52.4624743 -1.7763934
18204 op-snap---monthly-publication-march-2025.pdf   1961 2025-03 Car Honda JAZZ Blue Driving without Due Care and Attention None M6 JCT 3 M6 Jct 3 Coventry Coventry Education N/A Yes - Via Email 52.6912652 -2.1043715
18275 op-snap---monthly-publication-march-2025.pdf   2032 2025-03 Car Toyota Previa Silver Driving without Due Care and Attention None Reddings Road Reddings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4446673 -1.8966483
18282 op-snap---monthly-publication-march-2025.pdf   2039 2025-03 Car Volkswagen POLO White Driving without Due Care and Attention None ARDEN ROAD Arden Road Birmingham Birmingham Education N/A Yes - Via Email 52.4515759 -1.8296192
18299 op-snap---monthly-publication-march-2025.pdf   2056 2025-03 Car Fiat 124 White Driving without Due Care and Attention None ASTON UNIVERSITY Aston University Birmingham Birmingham Education N/A Yes - Via Email 52.4861905 -1.8884689
18337 op-snap---monthly-publication-march-2025.pdf   2094 2025-03 Car BMW 330 Black Driving without Due Care and Attention None CARTLAND ROAD Cartland Road Solihull Solihull Education N/A Yes - Via Email    
18446 op-snap---monthly-publication-march-2025.pdf   2203 2025-03 Pedal Bike Hyundai Tucson Brown Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
18498 op-snap---monthly-publication-march-2025.pdf   2255 2025-03 Car Audi A3 Grey Driving without Due Care and Attention None Brookvale Road Brookvale Road Birmingham Birmingham Education N/A Yes - Via Email 52.5219365 -1.8755325

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