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

134 rows where disposal = "Education", month = "2026-01" 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 7

offence 1

  • Driving without Due Care and Attention · 134 ✖

month 1

  • 2026-01 · 134 ✖

disposal 1

  • Education · 134 ✖
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
10539 op-snap---monthly-publication-january-2026.pdf   0 2026-01 Car Mercedes-Benz GLC 300 Silver Driving without Due Care and Attention None High Street, Bloxwich High Street, Bloxwich Walsall Walsall Education N/A   52.6142343 -2.0043397
10551 op-snap---monthly-publication-january-2026.pdf   12 2026-01 Car Lexus IS 250 Grey Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
10557 op-snap---monthly-publication-january-2026.pdf   18 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Robin Hood lane Robin Hood lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
10560 op-snap---monthly-publication-january-2026.pdf   21 2026-01 Car Honda Civic Grey Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall Education N/A   52.5692139 -1.8799672
10584 op-snap---monthly-publication-january-2026.pdf   45 2026-01 Car Audi Q3.. Black Driving without Due Care and Attention None Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10585 op-snap---monthly-publication-january-2026.pdf   46 2026-01 Car Nissan Micra White Driving without Due Care and Attention No Insurance Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10603 op-snap---monthly-publication-january-2026.pdf   64 2026-01 Car Seat Leon Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
10612 op-snap---monthly-publication-january-2026.pdf   73 2026-01 Car Suzuki SX4 white Driving without Due Care and Attention None Jn9 M6 Jn9 M6 Walsall Walsall Education N/A      
10639 op-snap---monthly-publication-january-2026.pdf   100 2026-01 Car Mitsubishi Outlander Grey Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Education N/A   52.4161736 -1.8619692
10640 op-snap---monthly-publication-january-2026.pdf   101 2026-01 Other BMW 3 series blue Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10641 op-snap---monthly-publication-january-2026.pdf   102 2026-01 Other BMW 3 series black Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10648 op-snap---monthly-publication-january-2026.pdf   109 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
10655 op-snap---monthly-publication-january-2026.pdf   116 2026-01 Car Toyota Prius Silver Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Education N/A   52.4509038 -1.8083784
10762 op-snap---monthly-publication-january-2026.pdf   223 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10791 op-snap---monthly-publication-january-2026.pdf   252 2026-01 Car Mercedes-Benz C350 Black Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
10810 op-snap---monthly-publication-january-2026.pdf   271 2026-01 Car Mercedes-Benz G 63 Black Driving without Due Care and Attention None Church Lane Church Lane Sandwell Sandwell Education N/A   52.5311655 -2.0008707
10817 op-snap---monthly-publication-january-2026.pdf   278 2026-01 Other Volkswagen Amarok Black Driving without Due Care and Attention None Castlegate Way, Dudley Castlegate Way, Dudley Dudley Dudley Education N/A   52.5152644 -2.07245
10824 op-snap---monthly-publication-january-2026.pdf   285 2026-01 Car Vauxhall Astra Red Driving without Due Care and Attention None Darlaston Road, Pleck Darlaston Road, Pleck Walsall Walsall Education N/A   52.5746221 -2.0037353
10828 op-snap---monthly-publication-january-2026.pdf   289 2026-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Tyburn Road, Gravely Hill Tyburn Road, Gravely Hill Birmingham Birmingham Education N/A      
10845 op-snap---monthly-publication-january-2026.pdf   306 2026-01 Pedal Bike   Irizar Coach Grey Driving without Due Care and Attention None Lawley Middleway, Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10846 op-snap---monthly-publication-january-2026.pdf   307 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10858 op-snap---monthly-publication-january-2026.pdf   319 2026-01 Car Vauxhall Insignia Black Driving without Due Care and Attention None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell Education N/A   52.5010052 -2.0306321
10884 op-snap---monthly-publication-january-2026.pdf   345 2026-01 Pedal Bike Volkswagen Crafter White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10901 op-snap---monthly-publication-january-2026.pdf   362 2026-01 Car Audi A5 Black Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
10902 op-snap---monthly-publication-january-2026.pdf   363 2026-01 Car Ford Fiesta Black Driving without Due Care and Attention None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Education N/A   52.473883 -1.9198244
10939 op-snap---monthly-publication-january-2026.pdf   400 2026-01 Car BMW 320d Black Driving without Due Care and Attention None M5 SB J1-2 M5 Southbound J1-2 Sandwell Sandwell Education N/A      
10941 op-snap---monthly-publication-january-2026.pdf   402 2026-01 Car Mini Mini Black Driving without Due Care and Attention None Western Road Western Road Birmingham Birmingham Education N/A   52.5461182 -1.8340257
10946 op-snap---monthly-publication-january-2026.pdf   407 2026-01 Car Toyota yaris Grey Driving without Due Care and Attention None The Green The Green Birmingham Birmingham Education N/A   52.547254 -1.8143667
10977 op-snap---monthly-publication-january-2026.pdf   438 2026-01 Pedal Bike BMW 330 E Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10979 op-snap---monthly-publication-january-2026.pdf   440 2026-01 Pedal Bike Citroen DS3 White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10982 op-snap---monthly-publication-january-2026.pdf   443 2026-01 Car Fiat 500L White Driving without Due Care and Attention None Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.546976 -1.8098124
10984 op-snap---monthly-publication-january-2026.pdf   445 2026-01 Pedal Bike Toyota MPV White Driving without Due Care and Attention None Reservoir Road, Edgbaston Reservoir Road, Edgbaston Birmingham Birmingham Education N/A   52.4771764 -1.93246
10990 op-snap---monthly-publication-january-2026.pdf   451 2026-01 car Peugeot 107 Black Driving without Due Care and Attention None Tyburn Island, Chester Road Tyburn Island, Chester Road Birmingham Birmingham Education N/A      
10994 op-snap---monthly-publication-january-2026.pdf   455 2026-01 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Education N/A   52.4682339 -1.8793662
10999 op-snap---monthly-publication-january-2026.pdf   460 2026-01 Car BMW 1 Series Grey Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull Education N/A   52.4144779 -1.7848758
11008 op-snap---monthly-publication-january-2026.pdf   469 2026-01 Car Nissan Juke Black Driving without Due Care and Attention None Bolton Road at Arthur Street Bolton Road at Arthur Street Birmingham Birmingham Education N/A   52.4667482 -1.8642338
11011 op-snap---monthly-publication-january-2026.pdf   472 2026-01 Car BMW 1 Series Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
11043 op-snap---monthly-publication-january-2026.pdf   504 2026-01 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11067 op-snap---monthly-publication-january-2026.pdf   528 2026-01 Car Toyota Avensis Blue Driving without Due Care and Attention None Berkeley Road East Berkeley Road East Birmingham Birmingham Education N/A   52.4658801 -1.8290005
11070 op-snap---monthly-publication-january-2026.pdf   531 2026-01 Car Ford Fiesta Blue Driving without Due Care and Attention None Dogpool Lane Dogpool Lane Birmingham Birmingham Education N/A   52.4373055 -1.9126748
11080 op-snap---monthly-publication-january-2026.pdf   541 2026-01 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Slade Road, Edgbaston Slade Road, Edgbaston Birmingham Birmingham Education N/A      
11087 op-snap---monthly-publication-january-2026.pdf   548 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Education N/A   52.4198291 -1.9241732
11091 op-snap---monthly-publication-january-2026.pdf   552 2026-01 Pedal Bike BMW z4 Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
11097 op-snap---monthly-publication-january-2026.pdf   558 2026-01 Pedal Bike Ford Kuga Silver Driving without Due Care and Attention None Eachway Lane Eachway Lane Birmingham Birmingham Education N/A   52.3882492 -2.0091218
11109 op-snap---monthly-publication-january-2026.pdf   570 2026-01 Pedal Bike Lexus UX250 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
11120 op-snap---monthly-publication-january-2026.pdf   581 2026-01 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry Education N/A   52.4352 -1.5194238
11171 op-snap---monthly-publication-january-2026.pdf   632 2026-01 Car Daf Truck White Driving without Due Care and Attention None M6 SB, JCT 10 to 9 M6 Southbound, JCT 10 to 9 Walsall Walsall Education N/A   52.676119 -2.0858425
11172 op-snap---monthly-publication-january-2026.pdf   633 2026-01 Car BMW X1 White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
11211 op-snap---monthly-publication-january-2026.pdf   672 2026-01 Car Land Rover Discovery Red Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
11229 op-snap---monthly-publication-january-2026.pdf   690 2026-01 Car Volkswagen Polo Black Driving without Due Care and Attention None Gerrards Street, Lozells Gerrards Street, Lozells Birmingham Birmingham Education N/A      
11237 op-snap---monthly-publication-january-2026.pdf   698 2026-01 Pedestrian Toyota Prius Silver Driving without Due Care and Attention None Lichfield Road, Mere Green Lichfield Road, Mere Green Sutton Coldfield Sutton Coldfield Education N/A   52.5890813 -1.8316626
11239 op-snap---monthly-publication-january-2026.pdf   700 2026-01 Car Seat Ibiza White Driving without Due Care and Attention None M6 Jct 5 M6 Junction 5 Sutton Coldfield Sutton Coldfield Education N/A   52.676119 -2.0858425
11244 op-snap---monthly-publication-january-2026.pdf   705 2026-01 Car Audi A3 Black Driving without Due Care and Attention None A4540 Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Education N/A   52.4861917 -1.8829748
11245 op-snap---monthly-publication-january-2026.pdf   706 2026-01 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Pershore Road South, Kings Norton Pershore Road South, Kings Norton Birmingham Birmingham Education N/A   52.4116071 -1.9297714
11250 op-snap---monthly-publication-january-2026.pdf   711 2026-01 Car Audi RS3 Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Walsall Walsall Education N/A   52.5723244 -1.9607214
11258 op-snap---monthly-publication-january-2026.pdf   719 2026-01 Car Peugeot 308 Grey Driving without Due Care and Attention None Cinder Bank Island Cinder Bank Island Dudley Dudley Education N/A   52.5004694 -2.0904035
11279 op-snap---monthly-publication-january-2026.pdf   740 2026-01 Pedal Bike Mitsubishi Outlander Silver Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11281 op-snap---monthly-publication-january-2026.pdf   742 2026-01 Pedal Bike BMW 320D White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
11283 op-snap---monthly-publication-january-2026.pdf   744 2026-01 Pedal Bike Volkswagen Passat Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
11285 op-snap---monthly-publication-january-2026.pdf   746 2026-01 Pedal Bike Volvo V40.. Grey Driving without Due Care and Attention None Cranmore Boulevard Cranmore Boulevard Solihull Solihull Education N/A   52.3947549 -1.8141729
11291 op-snap---monthly-publication-january-2026.pdf   752 2026-01 Car Toyota C-HR Grey Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
11292 op-snap---monthly-publication-january-2026.pdf   753 2026-01 Car Audi RS 3 Black Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
11302 op-snap---monthly-publication-january-2026.pdf   763 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Education N/A   52.4428606 -1.812114
11305 op-snap---monthly-publication-january-2026.pdf   766 2026-01 Car Audi A4 Black Driving without Due Care and Attention None Bridgnorth Road Bridgnorth Road Birmingham Birmingham Education N/A   52.4758675 -1.7882992
11328 op-snap---monthly-publication-january-2026.pdf   789 2026-01 Car Seat Leon Blue Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
11336 op-snap---monthly-publication-january-2026.pdf   797 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
11339 op-snap---monthly-publication-january-2026.pdf   800 2026-01 Car Toyota Prius Grey Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5872149 -1.8300386
11344 op-snap---monthly-publication-january-2026.pdf   805 2026-01 Pedal Bike Porsche Panamera Black Driving without Due Care and Attention None Lordswood Road Lordswood Road Birmingham Birmingham Education N/A   52.4591339 -1.9601054
11368 op-snap---monthly-publication-january-2026.pdf   829 2026-01 Pedal Bike Mercedes-Benz C300 Black Driving without Due Care and Attention None Quinton Interchange Quinton Interchange Dudley Dudley Education N/A   52.4539668 -2.0119854
11381 op-snap---monthly-publication-january-2026.pdf   842 2026-01 Car Mercedes-Benz A180.. Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
11385 op-snap---monthly-publication-january-2026.pdf   846 2026-01 Car Volkswagen Golf White Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
11387 op-snap---monthly-publication-january-2026.pdf   848 2026-01 Other Fiat DOBLO Grey Driving without Due Care and Attention None Miall Park Road Miall Park Road Solihull Solihull Education N/A   52.4214617 -1.8086577
11388 op-snap---monthly-publication-january-2026.pdf   849 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Education N/A   52.4762784 -1.9678366
11410 op-snap---monthly-publication-january-2026.pdf   871 2026-01 Car Mercedes-Benz Tipper White Driving without Due Care and Attention None Lawley MIddleway Lawley MIddleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
11423 op-snap---monthly-publication-january-2026.pdf   884 2026-01 Car   Taxi Grey Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
11427 op-snap---monthly-publication-january-2026.pdf   888 2026-01 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
11451 op-snap---monthly-publication-january-2026.pdf   912 2026-01 Pedal Bike Audi A3 Grey Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11454 op-snap---monthly-publication-january-2026.pdf   915 2026-01 Other Jaecoo 7 Luxury Silver Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
11457 op-snap---monthly-publication-january-2026.pdf   918 2026-01 Car Kia Stonic Grey Driving without Due Care and Attention None Dennis Road Dennis Road Birmingham Birmingham Education N/A   52.4524736 -1.8748228
11461 op-snap---monthly-publication-january-2026.pdf   922 2026-01 Car Kia Xceed Black Driving without Due Care and Attention None Lowr Queen Street Lowr Queen Street Sutton Coldfield Sutton Coldfield Education N/A      
11470 op-snap---monthly-publication-january-2026.pdf   931 2026-01 Car Vauxhall Astra Grey Driving without Due Care and Attention None Balsall Street East Balsall Street East Solihull Solihull Education N/A   52.3854087 -1.6550831
11476 op-snap---monthly-publication-january-2026.pdf   937 2026-01 Car Ford Focus Black Driving without Due Care and Attention None Harborne Lane Harborne Lane Birmingham Birmingham Education N/A   52.4468464 -1.9454816
11497 op-snap---monthly-publication-january-2026.pdf   958 2026-01 Car Toyota Yaris Grey Driving without Due Care and Attention None Moseley Road Moseley Road Birmingham Birmingham Education N/A   52.4679402 -1.881408
11516 op-snap---monthly-publication-january-2026.pdf   977 2026-01 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11517 op-snap---monthly-publication-january-2026.pdf   978 2026-01 Car Vauxhall Insignia White Driving without Due Care and Attention None Moseley Avenue Moseley Avenue Coventry Coventry Education N/A   52.417344 -1.5264979
11518 op-snap---monthly-publication-january-2026.pdf   979 2026-01 Car BMW 320d Blue Driving without Due Care and Attention None Stockfield Road Stockfield Road Birmingham Birmingham Education N/A   52.4519414 -1.831688
11520 op-snap---monthly-publication-january-2026.pdf   981 2026-01 Car Toyota Auris Red Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
11521 op-snap---monthly-publication-january-2026.pdf   982 2026-01 Car Volkswagen ID Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
11527 op-snap---monthly-publication-january-2026.pdf   988 2026-01 Car Ford Fiesta Blue Driving without Due Care and Attention None George Road George Road Birmingham Birmingham Education N/A   52.5155831 -1.8598862
11531 op-snap---monthly-publication-january-2026.pdf   992 2026-01 Motorbike Toyota Hilux Grey Driving without Due Care and Attention None Solihull Road Solihull Road Birmingham Birmingham Education N/A   52.4458555 -1.8584046
11539 op-snap---monthly-publication-january-2026.pdf   1000 2026-01 Car Kia Ceed Red Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
11542 op-snap---monthly-publication-january-2026.pdf   1003 2026-01 Car Mercedes-Benz A250 Grey Driving without Due Care and Attention None Blackberry Lane Blackberry Lane Sutton Coldfield Sutton Coldfield Education N/A   52.5962461 -1.8492935
11550 op-snap---monthly-publication-january-2026.pdf   1011 2026-01 Pedal Bike Vauxhall Corsa Red Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham Education N/A   52.4045186 -1.9891793
11584 op-snap---monthly-publication-january-2026.pdf   1045 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Heath Lane Heath Lane Sandwell Sandwell Education N/A   52.5369717 -1.9907285
11588 op-snap---monthly-publication-january-2026.pdf   1049 2026-01 Car Land Rover Defender Black Driving without Due Care and Attention None Stivichall Highway Stivichall Highway Coventry Coventry Education N/A   52.3774003 -1.493293
11590 op-snap---monthly-publication-january-2026.pdf   1051 2026-01 Pedal Bike Scania HGV White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
11594 op-snap---monthly-publication-january-2026.pdf   1055 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Wychall Road Wychall Road Birmingham Birmingham Education N/A   52.4089092 -1.9498562
11599 op-snap---monthly-publication-january-2026.pdf   1060 2026-01 Car Jaguar I-Pace Grey Driving without Due Care and Attention None Devon Street Devon Street Birmingham Birmingham Education N/A   52.4899353 -1.8683073
11604 op-snap---monthly-publication-january-2026.pdf   1065 2026-01 Car BMW 420d Black Driving without Due Care and Attention None Gilbertson Avenue Gilbertson Avenue Birmingham Birmingham Education N/A      
11605 op-snap---monthly-publication-january-2026.pdf   1066 2026-01 Pedal Bike Skoda Superb Black Driving without Due Care and Attention None Kineton Green Road Kineton Green Road Solihull Solihull Education N/A   52.4332233 -1.812229

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