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

180 rows where council_area = "Coventry", disposal = "Education" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence

reporter_transport_mode 5

offence 1

  • Driving without Due Care and Attention · 180 ✖

disposal 1

  • Education · 180 ✖

council_area 1

  • Coventry · 180 ✖
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
7312 op-snap---monthly-publication-february-2026.pdf   59 2026-02 Pedal Bike BMW 218i Blue Driving without Due Care and Attention None Bird Street at White Street Bird Street at White Street Coventry Coventry Education N/A   52.4124171 -1.5065021
7359 op-snap---monthly-publication-february-2026.pdf   106 2026-02 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Greens Road Greens Road Coventry Coventry Education N/A   52.4381927 -1.5291209
7470 op-snap---monthly-publication-february-2026.pdf   217 2026-02 Pedal Bike Kia Rio Blue Driving without Due Care and Attention None Ansty Road Ansty Road Coventry Coventry Education N/A   52.4205675 -1.4520187
7497 op-snap---monthly-publication-february-2026.pdf   244 2026-02 Car BMW X1 Blue Driving without Due Care and Attention None Torcross Avenue Torcross Avenue Coventry Coventry Education N/A   52.4218194 -1.46546
7498 op-snap---monthly-publication-february-2026.pdf   245 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Westwood WAY Westwood WAY Coventry Coventry Education N/A   52.3880214 -1.5797132
7535 op-snap---monthly-publication-february-2026.pdf   282 2026-02 Car Peugeot 206 Silver Driving without Due Care and Attention None Winding House Lane Winding House Lane Coventry Coventry Education N/A   52.4490457 -1.5001195
7538 op-snap---monthly-publication-february-2026.pdf   285 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
7603 op-snap---monthly-publication-february-2026.pdf   350 2026-02 Car Hyundai 130 Blue Driving without Due Care and Attention None A46 Coventry Coventry Coventry Coventry Education N/A   52.400739 -1.5135474
7625 op-snap---monthly-publication-february-2026.pdf   372 2026-02 Car Mercedes-Benz CLA 220 Red Driving without Due Care and Attention None Coventry A45 W Coventry A45 W Coventry Coventry Education N/A   52.4314215 -1.5948907
7699 op-snap---monthly-publication-february-2026.pdf   446 2026-02 Pedal Bike Mercedes-Benz Sprinter white Driving without Due Care and Attention None Broad Lane, Tile Hill Broad Lane, Tile Hill Coventry Coventry Education N/A   52.4112706 -1.5792697
7700 op-snap---monthly-publication-february-2026.pdf   447 2026-02 Pedal Bike Kia Niro White Driving without Due Care and Attention None Bloomfield Road, Earlsdon Bloomfield Road, Earlsdon Coventry Coventry Education N/A      
7833 op-snap---monthly-publication-february-2026.pdf   580 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
7835 op-snap---monthly-publication-february-2026.pdf   582 2026-02 Car Mercedes-Benz EQB Black Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Education N/A   52.4318623 -1.4804069
7882 op-snap---monthly-publication-february-2026.pdf   629 2026-02 Car BMW 318D Black Driving without Due Care and Attention None London Road London Road Coventry Coventry Education N/A   52.3916468 -1.4925995
7934 op-snap---monthly-publication-february-2026.pdf   681 2026-02 Pedal Bike BMW   Orange Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
7938 op-snap---monthly-publication-february-2026.pdf   685 2026-02 Pedal Bike BMW   Grey Driving without Due Care and Attention None Back Lane Coventry Back Lane Coventry Coventry Coventry Education N/A   52.3796433 -1.5600371
8017 op-snap---monthly-publication-february-2026.pdf   764 2026-02 Pedal Bike Mercedes-Benz CLA220 Red Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
8027 op-snap---monthly-publication-february-2026.pdf   774 2026-02 Pedal Bike Nissan Qashqai Beige Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Education N/A   52.402753 -1.5385829
8049 op-snap---monthly-publication-february-2026.pdf   796 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Broad Lane nr The Glade junction Broad Lane nr The Glade junction Coventry Coventry Education N/A      
8050 op-snap---monthly-publication-february-2026.pdf   797 2026-02 Pedal Bike Hyundai i30 Grey Driving without Due Care and Attention None Broad Lane near Coral Close Broad Lane near Coral Close Coventry Coventry Education N/A   52.4144409 -1.5990259
8083 op-snap---monthly-publication-february-2026.pdf   830 2026-02 Car Ford Focus Red Driving without Due Care and Attention None Lamb Street Lamb Street Coventry Coventry Education N/A   52.4110367 -1.5143617
8103 op-snap---monthly-publication-february-2026.pdf   850 2026-02 Pedal Bike Audi Q3 White Driving without Due Care and Attention None Hearsall Lane Hearsall Lane Coventry Coventry Education N/A   52.4064125 -1.5320113
8321 op-snap---monthly-publication-february-2026.pdf   1068 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Education N/A   52.4073149 -1.5250454
8339 op-snap---monthly-publication-february-2026.pdf   1086 2026-02 Car Seat Leon Blue Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Education N/A   52.4074716 -1.5620671
8354 op-snap---monthly-publication-february-2026.pdf   1101 2026-02 Pedal Bike Citroen C4.. White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Education N/A   52.4041117 -1.5595662
8514 op-snap---monthly-publication-february-2026.pdf   1261 2026-02 Pedal Bike Mercedes-Benz C220 Silver Driving without Due Care and Attention None White Street White Street Coventry Coventry Education N/A   52.4122951 -1.5045181
8515 op-snap---monthly-publication-february-2026.pdf   1262 2026-02 Pedal Bike Peugeot Expert White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
8542 op-snap---monthly-publication-february-2026.pdf   1289 2026-02 Pedal Bike Nissan Qashqai Silver Driving without Due Care and Attention None Broad Lane Coventry Broad Lane Coventry Coventry Coventry Education N/A   52.4144409 -1.5990259
8546 op-snap---monthly-publication-february-2026.pdf   1293 2026-02 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
8594 op-snap---monthly-publication-february-2026.pdf   1341 2026-02 Car Ford Transit White Driving without Due Care and Attention None Ludgate Road Ludgate Road Coventry Coventry Education N/A      
8760 op-snap---monthly-publication-february-2026.pdf   1507 2026-02 Pedal Bike Ford Puma Red Driving without Due Care and Attention None Wall Hill Road Wall Hill Road Coventry Coventry Education N/A   52.4459445 -1.5552508
8766 op-snap---monthly-publication-february-2026.pdf   1513 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Spon End Spon End Coventry Coventry Education N/A   52.4069072 -1.5247498
8814 op-snap---monthly-publication-february-2026.pdf   1561 2026-02 Pedal Bike Seat Leon Grey Driving without Due Care and Attention None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
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      
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
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
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
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
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
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
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
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
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
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
11690 op-snap---monthly-publication-january-2026.pdf   1151 2026-01 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
11696 op-snap---monthly-publication-january-2026.pdf   1157 2026-01 Pedal Bike Hyundai i10 Blue Driving without Due Care and Attention None Albany Road Albany Road Coventry Coventry Education N/A   52.4006218 -1.5284125
11877 op-snap---monthly-publication-january-2026.pdf   1338 2026-01 Lorry Vauxhall Antara Silver Driving without Due Care and Attention None M6 Motorway M6 Motorway Coventry Coventry Education N/A      
4017 op-snap---monthly-publication-december-2025.pdf   145 2025-12 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Westward Way Westward Way Coventry Coventry Education N/A      
4086 op-snap---monthly-publication-december-2025.pdf   214 2025-12 Pedal Bike Volkswagen UP Red Driving without Due Care and Attention None Swanswwell St Swanswwell Street Coventry Coventry Education N/A      
4308 op-snap---monthly-publication-december-2025.pdf   436 2025-12 Car Volkswagen Polo Black Driving without Due Care and Attention None Barker Butt Lane Barker Butt Lane Coventry Coventry Education N/A      
4343 op-snap---monthly-publication-december-2025.pdf   471 2025-12 Car Kia Rio Silver Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
4477 op-snap---monthly-publication-december-2025.pdf   605 2025-12 Pedal Bike Mercedes-Benz Camper White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
4538 op-snap---monthly-publication-december-2025.pdf   666 2025-12 Car Ford Transit Grey Driving without Due Care and Attention None A444 A444 Coventry Coventry Education N/A      
4570 op-snap---monthly-publication-december-2025.pdf   698 2025-12 Car Ford Focus Black Driving without Due Care and Attention None Clifford Bridge Road to Ansty Road Clifford Bridge Road to Ansty Road Coventry Coventry Education N/A      
4585 op-snap---monthly-publication-december-2025.pdf   713 2025-12 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry Education N/A   52.4144409 -1.5990259
4620 op-snap---monthly-publication-december-2025.pdf   748 2025-12 Pedal Bike Skoda Fabia grey Driving without Due Care and Attention None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
4716 op-snap---monthly-publication-december-2025.pdf   844 2025-12 Pedal Bike Jeep Renegade Black Driving without Due Care and Attention None Broad Lane, Tile Hill, Coventry Broad Lane, Tile Hill, Coventry Coventry Coventry Education N/A   52.4112706 -1.5792697
4725 op-snap---monthly-publication-december-2025.pdf   853 2025-12 Pedal Bike Mazda CX3 Silver Driving without Due Care and Attention None Tile Hill Lane, Tile Hill, Coventry Tile Hill Lane, Tile Hill, Coventry Coventry Coventry Education N/A   52.4019676 -1.5834005
20488 op-snap---monthly-publication-november-2025.pdf   30 2025-11 Pedal Bike London Taxi taxi Black Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
20517 op-snap---monthly-publication-november-2025.pdf   59 2025-11 Pedal Bike Kia Ceed Brown Driving without Due Care and Attention None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
20577 op-snap---monthly-publication-november-2025.pdf   119 2025-11 Car Honda CR V Black Driving without Due Care and Attention None Hermes Crescent Hermes Crescent Coventry Coventry Education N/A   52.4257211 -1.4566304
20614 op-snap---monthly-publication-november-2025.pdf   156 2025-11 Pedal Bike Ford Focus White Driving without Due Care and Attention None Counden Wedge Drive Counden Wedge Drive Coventry Coventry Education N/A      
20626 op-snap---monthly-publication-november-2025.pdf   168 2025-11 Car Audi A4 Black Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
20710 op-snap---monthly-publication-november-2025.pdf   252 2025-11 Car Volkswagen Golf Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Coventry Coventry Education N/A   52.4272882 -1.5753221
20778 op-snap---monthly-publication-november-2025.pdf   320 2025-11 Car Ford GALAXY White Driving without Due Care and Attention None A444 A444 Coventry Coventry Education N/A      
20817 op-snap---monthly-publication-november-2025.pdf   359 2025-11 Car Toyota Auris Grey Driving without Due Care and Attention None Pickford Way Pickford Way Coventry Coventry Education N/A   52.4220824 -1.5625669
21438 op-snap---monthly-publication-november-2025.pdf   980 2025-11 Car Peugeot 106 Black Driving without Due Care and Attention None Ringway St Johns Ringway Street Johns Coventry Coventry Education N/A      
21471 op-snap---monthly-publication-november-2025.pdf   1013 2025-11 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
21551 op-snap---monthly-publication-november-2025.pdf   1093 2025-11 Pedal Bike London Taxi Taxi Black Driving without Due Care and Attention None Croft Road Croft Road Coventry Coventry Education N/A   52.4064698 -1.5167474
21613 op-snap---monthly-publication-november-2025.pdf   1155 2025-11 Car Mercedes-Benz C220 Black Driving without Due Care and Attention None Nunts Lane Nunts Lane Coventry Coventry Education N/A   52.4483335 -1.5168597
21665 op-snap---monthly-publication-november-2025.pdf   1207 2025-11 Car Ford B-Max Blue Driving without Due Care and Attention   Foleshill Road, Coventry Foleshill Road, Coventry Coventry Coventry Education N/A   52.4363104 -1.4936555
21693 op-snap---monthly-publication-november-2025.pdf   1235 2025-11 Car Ford galaxy Silver Driving without Due Care and Attention None crampers field Crampers Field Coventry Coventry Education N/A   52.4176927 -1.5257854
21820 op-snap---monthly-publication-november-2025.pdf   1362 2025-11 Car Skoda Superb White Driving without Due Care and Attention None Hinkley Road, Coventry Hinkley Road, Coventry Coventry Coventry Education N/A      
21982 op-snap---monthly-publication-november-2025.pdf   1524 2025-11 Pedal Bike Volkswagen Caddy Red Driving without Due Care and Attention None Bridle Brook Lane Bridle Brook Lane Coventry Coventry Education N/A   52.4475078 -1.5736787
22110 op-snap---monthly-publication-october-2025.pdf   60 2025-10 Pedal Bike Volkswagen Transporter Grey Driving without Due Care and Attention None Earlsdon Av Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
22311 op-snap---monthly-publication-october-2025.pdf   261 2025-10 Pedal Bike Toyota Aygo Red Driving without Due Care and Attention None Corporation Road Corporation Road Coventry Coventry Education N/A      
22425 op-snap---monthly-publication-october-2025.pdf   375 2025-10 Car Volvo VC90 Grey Driving without Due Care and Attention None A45 Birmingham Road Birmingham Road Coventry Coventry Education N/A   52.4272882 -1.5753221
22447 op-snap---monthly-publication-october-2025.pdf   397 2025-10 Pedal Bike Volkswagen Polo Orange Driving without Due Care and Attention None Moseley Avenue Moseley Avenue Coventry Coventry Education N/A   52.417344 -1.5264979
22550 op-snap---monthly-publication-october-2025.pdf   500 2025-10 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Stoneleigh Road Stoneleigh Road Coventry Coventry Education N/A   52.3698519 -1.5482742
22623 op-snap---monthly-publication-october-2025.pdf   573 2025-10 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None West Hill Road West Hill Road Coventry Coventry Education N/A   52.3994858 -1.4923603
22637 op-snap---monthly-publication-october-2025.pdf   587 2025-10 Pedal Bike Toyota Auris Black Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
22649 op-snap---monthly-publication-october-2025.pdf   599 2025-10 Car BMW   White Driving without Due Care and Attention None Coventry town centre Coventry town centre Coventry Coventry Education N/A      
22690 op-snap---monthly-publication-october-2025.pdf   640 2025-10 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
22713 op-snap---monthly-publication-october-2025.pdf   663 2025-10 Pedal Bike Volkswagen T-Roc Black Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
22718 op-snap---monthly-publication-october-2025.pdf   668 2025-10 Pedal Bike Ford B-Max White Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Education N/A   52.3921304 -1.5156601
22830 op-snap---monthly-publication-october-2025.pdf   780 2025-10 Pedal Bike Toyota Corolla Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
22847 op-snap---monthly-publication-october-2025.pdf   797 2025-10 Pedal Bike Audi   Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
22865 op-snap---monthly-publication-october-2025.pdf   815 2025-10 Car   Smart White Driving without Due Care and Attention None M6 J2 M6 J2 Coventry Coventry Education N/A   52.6760749 -2.0862582
22939 op-snap---monthly-publication-october-2025.pdf   889 2025-10 Pedal Bike BMW X2` Blue Driving without Due Care and Attention None St Nicholas St Street Nicholas Street Coventry Coventry Education N/A   52.4133001 -1.5126792
23005 op-snap---monthly-publication-october-2025.pdf   955 2025-10 Pedal Bike Mercedes-Benz E200 Black Driving without Due Care and Attention None Butts Road near Albany Road Butts Road near Albany Road Coventry Coventry Education N/A   52.4078926 -1.5256816
23024 op-snap---monthly-publication-october-2025.pdf   974 2025-10 Pedal Bike Honda Civic Red Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
23048 op-snap---monthly-publication-october-2025.pdf   998 2025-10 Pedal Bike Seat Arona Blue Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
24012 op-snap---monthly-publication-september-2025.pdf   231 2025-09 Car Volkswagen Golf Grey Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Education N/A   52.3921304 -1.5156601
24019 op-snap---monthly-publication-september-2025.pdf   238 2025-09 Car Mercedes-Benz E200 Blue Driving without Due Care and Attention None M6 Motorway M6 Motorway Coventry Coventry Education N/A      
24081 op-snap---monthly-publication-september-2025.pdf   300 2025-09 Car Seat Leon White Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
24222 op-snap---monthly-publication-september-2025.pdf   441 2025-09 Motorbike Chevrolet Jeep Compass Grey Driving without Due Care and Attention None Roundabout, Allard Way / London Road / Humber Rd Roundabout, Allard Way / London Road / Humber Road Coventry Coventry Education N/A      
24374 op-snap---monthly-publication-september-2025.pdf   593 2025-09 Pedal Bike Nissan Note Blue Driving without Due Care and Attention None Albany Road Albany Road Coventry Coventry Education N/A   52.4006218 -1.5284125
24472 op-snap---monthly-publication-september-2025.pdf   691 2025-09 Pedal Bike Skoda Fabia Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
24475 op-snap---monthly-publication-september-2025.pdf   694 2025-09 Pedal Bike Mazda 3 Red Driving without Due Care and Attention None The Firs The Firs Coventry Coventry Education N/A   52.3965706 -1.523038

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