home / opsnap

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

129 rows where council_area = "Coventry", disposal = "Warning Letter" 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, nfa_rationale

vehicle_make >30

  • Mercedes-Benz 24
  • Ford 13
  • BMW 10
  • Vauxhall 10
  • Audi 7
  • Toyota 6
  • Volkswagen 6
  • Nissan 5
  • Citroen 3
  • Hyundai 3
  • Kia 3
  • Land Rover 3
  • Mazda 3
  • Peugeot 3
  • Renault 3
  • Seat 3
  • Mg 2
  • Mini 2
  • Scania 2
  • Skoda 2
  • Cupra 1
  • Dacia 1
  • Daf 1
  • Fiat 1
  • Honda 1
  • Mitsubishi 1
  • Polestar 1
  • Porsche 1
  • Suzuki 1
  • Tesla 1
  • …

month 14

  • 2025-07 23
  • 2025-05 17
  • 2025-08 14
  • 2025-09 14
  • 2025-03 13
  • 2026-01 10
  • 2025-11 9
  • 2026-02 9
  • 2025-02 5
  • 2025-06 5
  • 2025-10 5
  • 2025-04 2
  • 2025-12 2
  • 2025-01 1

reporter_transport_mode 6

  • Car 77
  • Pedal Bike 46
  • Motorbike 2
  • Pedestrian 2
  • Other 1
  • car 1

offence 1

  • Driving without Due Care and Attention · 129 ✖

disposal 1

  • Warning Letter · 129 ✖

council_area 1

  • Coventry · 129 ✖
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
7696 op-snap---monthly-publication-february-2026.pdf   443 2026-02 Pedal Bike Mercedes-Benz A Class Silver Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
7697 op-snap---monthly-publication-february-2026.pdf   444 2026-02 Pedal Bike Kia Sportage Silver Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
7754 op-snap---monthly-publication-february-2026.pdf   501 2026-02 Car Citroen Berlingo Silver Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Warning Letter N/A   52.396476 -1.5561348
7756 op-snap---monthly-publication-february-2026.pdf   503 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Warning Letter N/A   52.418488 -1.5472387
7857 op-snap---monthly-publication-february-2026.pdf   604 2026-02 Pedal Bike Seat Ibiza Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
7874 op-snap---monthly-publication-february-2026.pdf   621 2026-02 Car Ford KA Red Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
8543 op-snap---monthly-publication-february-2026.pdf   1290 2026-02 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Westwood Way Westwood Way Coventry Coventry Warning Letter N/A   52.3880214 -1.5797132
8550 op-snap---monthly-publication-february-2026.pdf   1297 2026-02 Car Toyota Yaris Red Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Warning Letter N/A   52.396476 -1.5561348
8668 op-snap---monthly-publication-february-2026.pdf   1415 2026-02 Car Mercedes-Benz Vito White Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
10582 op-snap---monthly-publication-january-2026.pdf   43 2026-01 Car Polestar   White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
10801 op-snap---monthly-publication-january-2026.pdf   262 2026-01 Car Mercedes-Benz   White Driving without Due Care and Attention None London Road London Road Coventry Coventry Warning Letter N/A   52.3916468 -1.4925995
10910 op-snap---monthly-publication-january-2026.pdf   371 2026-01 Car Volvo C30 Silver Driving without Due Care and Attention None Barkers Butt Lane Barkers Butt Lane Coventry Coventry Warning Letter N/A      
10985 op-snap---monthly-publication-january-2026.pdf   446 2026-01 Car Hyundai i40 Silver Driving without Due Care and Attention None Links Road Links Road Coventry Coventry Warning Letter N/A   52.4310925 -1.5197728
11210 op-snap---monthly-publication-january-2026.pdf   671 2026-01 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Warning Letter N/A   52.4061531 -1.505845
11273 op-snap---monthly-publication-january-2026.pdf   734 2026-01 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Warning Letter N/A   52.402753 -1.5385829
11351 op-snap---monthly-publication-january-2026.pdf   812 2026-01 Pedal Bike Citroen C3 Black Driving without Due Care and Attention None Hollyfast Lane Hollyfast Lane Coventry Coventry Warning Letter N/A   52.4517652 -1.5578662
11528 op-snap---monthly-publication-january-2026.pdf   989 2026-01 Car Ford Transit Blue Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Warning Letter N/A   52.3921304 -1.5156601
11530 op-snap---monthly-publication-january-2026.pdf   991 2026-01 Car Hyundai I30.. Grey Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Warning Letter N/A   52.396476 -1.5561348
11597 op-snap---monthly-publication-january-2026.pdf   1058 2026-01 Car Vauxhall Vivaro White Driving without Due Care and Attention None Morrisons Car park exit to Holyhead Road Morrisons Car park exit to Holyhead Road Coventry Coventry Warning Letter N/A      
4727 op-snap---monthly-publication-december-2025.pdf   855 2025-12 Pedal Bike Mazda CX3 Silver Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
4728 op-snap---monthly-publication-december-2025.pdf   856 2025-12 Pedal Bike Ford Transit White Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
20531 op-snap---monthly-publication-november-2025.pdf   73 2025-11 Car Audi A3 Black Driving without Due Care and Attention None B4101 Coventry City Centre Coventry City Centre Coventry Coventry Warning Letter N/A   52.4146776 -1.5056904
20544 op-snap---monthly-publication-november-2025.pdf   86 2025-11 Car Mercedes-Benz GLC Blue Driving without Due Care and Attention None Wigston Road, Hinkley Road Roundabout Wigston Road, Hinkley Road Roundabout Coventry Coventry Warning Letter N/A      
20574 op-snap---monthly-publication-november-2025.pdf   116 2025-11 Car Mercedes-Benz CLA 200 Silver Driving without Due Care and Attention None Jimmy HIll Way Jimmy HIll Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
20801 op-snap---monthly-publication-november-2025.pdf   343 2025-11 Car Renault Master White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
20848 op-snap---monthly-publication-november-2025.pdf   390 2025-11 Car Mercedes-Benz A 200 Black Driving without Due Care and Attention None Central Boulevard Central Boulevard Coventry Coventry Warning Letter N/A   52.4543969 -1.5168781
21011 op-snap---monthly-publication-november-2025.pdf   553 2025-11 Car Audi A6 Black Driving without Due Care and Attention None Coventry Road Coventry Road Coventry Coventry Warning Letter N/A   52.4111289 -1.5094345
21235 op-snap---monthly-publication-november-2025.pdf   777 2025-11 Car Skoda Octavia Beige Driving without Due Care and Attention None London Road London Road Coventry Coventry Warning Letter N/A   52.3916468 -1.4925995
21255 op-snap---monthly-publication-november-2025.pdf   797 2025-11 Car Toyota Hi Lux Grey Driving without Due Care and Attention None Bell Green Road Bell Green Road Coventry Coventry Warning Letter N/A   52.4324855 -1.4815548
21968 op-snap---monthly-publication-november-2025.pdf   1510 2025-11 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Swanawell Street Swanawell Street Coventry Coventry Warning Letter N/A      
22448 op-snap---monthly-publication-october-2025.pdf   398 2025-10 Pedal Bike Mini Mini Black Driving without Due Care and Attention None Four Pounds Avenue Four Pounds Avenue Coventry Coventry Warning Letter N/A   52.413228 -1.5323652
22673 op-snap---monthly-publication-october-2025.pdf   623 2025-10 Car Ford Transit White Driving without Due Care and Attention None Cannon Hill Road Cannon Hill Road Coventry Coventry Warning Letter N/A   52.3833286 -1.5453196
22699 op-snap---monthly-publication-october-2025.pdf   649 2025-10 Pedal Bike Mazda 3 Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
22772 op-snap---monthly-publication-october-2025.pdf   722 2025-10 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
23070 op-snap---monthly-publication-october-2025.pdf   1020 2025-10 Car BMW 3 series Grey Driving without Due Care and Attention None A4053 Coventry Ring Road Coventry Ring Road Coventry Coventry Warning Letter N/A      
23881 op-snap---monthly-publication-september-2025.pdf   100 2025-09 Pedal Bike Land Rover Evoque White Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
24102 op-snap---monthly-publication-september-2025.pdf   321 2025-09 Car Mg HS Red Driving without Due Care and Attention None M6 SB J4a - 4 M6 Southbound J4a - 4 Coventry Coventry Warning Letter N/A   52.6912652 -2.1043715
24118 op-snap---monthly-publication-september-2025.pdf   337 2025-09 Car Vauxhall Astra White Driving without Due Care and Attention None M6 Coventry M6 Coventry Coventry Coventry Warning Letter N/A   52.4457805 -1.454783
24153 op-snap---monthly-publication-september-2025.pdf   372 2025-09 Car Toyota Corolla Grey Driving without Due Care and Attention None Central Six retail park Central Six retail park Coventry Coventry Warning Letter N/A   52.4022899 -1.5191819
24193 op-snap---monthly-publication-september-2025.pdf   412 2025-09 Pedal Bike Mg 4.. Grey Driving without Due Care and Attention None Beake Avenue Beake Avenue Coventry Coventry Warning Letter N/A   52.4388246 -1.5229308
24202 op-snap---monthly-publication-september-2025.pdf   421 2025-09 Car Ford Transit Silver Driving without Due Care and Attention None Coventry Highway Coventry Highway Coventry Coventry Warning Letter N/A   52.4034983 -1.5600081
24265 op-snap---monthly-publication-september-2025.pdf   484 2025-09 Car Nissan Qashqai Orange Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Warning Letter N/A   52.4073149 -1.5250454
24281 op-snap---monthly-publication-september-2025.pdf   500 2025-09 Car Mercedes-Benz Sprinter Yellow Driving without Due Care and Attention Use vehicle on a road without valid test certificate Ringway, Swanswell Ringway, Swanswell Coventry Coventry Warning Letter N/A      
24462 op-snap---monthly-publication-september-2025.pdf   681 2025-09 Car Volkswagen Tiguan Silver Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Warning Letter N/A   52.4318623 -1.4804069
24512 op-snap---monthly-publication-september-2025.pdf   731 2025-09 Pedal Bike Scania Coach Green Driving without Due Care and Attention None Balsall Street East, Balsall Common Balsall Street East, Balsall Common Coventry Coventry Warning Letter N/A      
24520 op-snap---monthly-publication-september-2025.pdf   739 2025-09 Pedal Bike Renault Zoe Blue Driving without Due Care and Attention None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
24864 op-snap---monthly-publication-september-2025.pdf   1083 2025-09 Car   Bentley Green Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
24925 op-snap---monthly-publication-september-2025.pdf   1144 2025-09 Car Mini Cooper Red Driving without Due Care and Attention None Four Pound Avenue Four Pound Avenue Coventry Coventry Warning Letter N/A      
24938 op-snap---monthly-publication-september-2025.pdf   1157 2025-09 Car Mercedes-Benz van white Driving without Due Care and Attention None A42 Coventry Coventry Coventry Coventry Warning Letter N/A   52.400739 -1.5135474
2088 op-snap---monthly-publication-august-2025.pdf   63 2025-08 Car Tesla Model 3 White Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Warning Letter N/A   52.4073149 -1.5250454
2220 op-snap---monthly-publication-august-2025.pdf   195 2025-08 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Keresley Road Keresley Road Coventry Coventry Warning Letter N/A   52.4331176 -1.5314475
2595 op-snap---monthly-publication-august-2025.pdf   570 2025-08 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Earlsdon Av Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
2675 op-snap---monthly-publication-august-2025.pdf   650 2025-08 Car   Subuara Grey Driving without Due Care and Attention None Torrington Avenue Torrington Avenue Coventry Coventry Warning Letter N/A   52.3987354 -1.567693
2720 op-snap---monthly-publication-august-2025.pdf   695 2025-08 Car Peugeot 1007SE Black Driving without Due Care and Attention None Holbrook WAY Holbrook WAY Coventry Coventry Warning Letter N/A   52.438551 -1.502488
2757 op-snap---monthly-publication-august-2025.pdf   732 2025-08 Car BMW 320D Blue Driving without Due Care and Attention None Green Lane Green Lane Coventry Coventry Warning Letter N/A   52.38188 -1.5300381
2993 op-snap---monthly-publication-august-2025.pdf   968 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Anderton Road Anderton Road Coventry Coventry Warning Letter N/A   52.4519205 -1.4736655
3175 op-snap---monthly-publication-august-2025.pdf   1150 2025-08 Car BMW 1 series White Driving without Due Care and Attention None Silver Eagle Way Silver Eagle Way Coventry Coventry Warning Letter N/A      
3182 op-snap---monthly-publication-august-2025.pdf   1157 2025-08 Car Renault Trafic White Driving without Due Care and Attention None Silver Birch Avenue, Canley Silver Birch Avenue, Canley Coventry Coventry Warning Letter N/A   52.3954274 -1.5568965
3314 op-snap---monthly-publication-august-2025.pdf   1289 2025-08 Car Vauxhall Movano White Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Warning Letter N/A   52.3921304 -1.5156601
3442 op-snap---monthly-publication-august-2025.pdf   1417 2025-08 Pedal Bike Cupra Leon Black Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
3485 op-snap---monthly-publication-august-2025.pdf   1460 2025-08 Car Land Rover Range Rover Grey Driving without Due Care and Attention None Ansty Road Ansty Road Coventry Coventry Warning Letter N/A   52.4205675 -1.4520187
3564 op-snap---monthly-publication-august-2025.pdf   1539 2025-08 Car Toyota Auris Blue Driving without Due Care and Attention None Stoeny Stanton Road Stoeny Stanton Road Coventry Coventry Warning Letter N/A      
3630 op-snap---monthly-publication-august-2025.pdf   1605 2025-08 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Welsh Road Welsh Road Coventry Coventry Warning Letter N/A   52.4134223 -1.4781861
12178 op-snap---monthly-publication-july-2025.pdf   230 2025-07 Pedestrian Vauxhall Zafira Beige Driving without Due Care and Attention None Outside Coventry Market Outside Coventry Market Coventry Coventry Warning Letter N/A      
12459 op-snap---monthly-publication-july-2025.pdf   511 2025-07 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
12505 op-snap---monthly-publication-july-2025.pdf   557 2025-07 Car Skoda Citigo Red Driving without Due Care and Attention None Stivichall Roundabout Stivichall Roundabout Coventry Coventry Warning Letter N/A   52.3776818 -1.4982138
12671 op-snap---monthly-publication-july-2025.pdf   723 2025-07 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
13085 op-snap---monthly-publication-july-2025.pdf   1137 2025-07 Car Mercedes-Benz   Silver Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Warning Letter N/A   52.4235908 -1.5226276
13167 op-snap---monthly-publication-july-2025.pdf   1219 2025-07 Pedal Bike Land Rover Defender Green Driving without Due Care and Attention None Lavender Hall Lane Lavender Hall Lane Coventry Coventry Warning Letter N/A      
13168 op-snap---monthly-publication-july-2025.pdf   1220 2025-07 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Lavender Hall Lane Lavender Hall Lane Coventry Coventry Warning Letter N/A      
13198 op-snap---monthly-publication-july-2025.pdf   1250 2025-07 Car Scania Tractor White Driving without Due Care and Attention None Toll Bar End Toll Bar End Coventry Coventry Warning Letter N/A   52.377406 -1.4651313
13224 op-snap---monthly-publication-july-2025.pdf   1276 2025-07 Car BMW 218i White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
13249 op-snap---monthly-publication-july-2025.pdf   1301 2025-07 Car Dacia Sandero White Driving without Due Care and Attention None A45 Sir Henry Parkes Road Sir Henry Parkes Road Coventry Coventry Warning Letter N/A   52.3900568 -1.5550766
13319 op-snap---monthly-publication-july-2025.pdf   1371 2025-07 Pedal Bike Mercedes-Benz GLE Green Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13323 op-snap---monthly-publication-july-2025.pdf   1375 2025-07 Pedal Bike Daf Tipper Blue Driving without Due Care and Attention None Stoney Stanton Lane Stoney Stanton Lane Coventry Coventry Warning Letter N/A   52.4211068 -1.4966527
13325 op-snap---monthly-publication-july-2025.pdf   1377 2025-07 Pedal Bike Mercedes-Benz Coach White Driving without Due Care and Attention None Stoney Stanton Lane Stoney Stanton Lane Coventry Coventry Warning Letter N/A   52.4211068 -1.4966527
13410 op-snap---monthly-publication-july-2025.pdf   1462 2025-07 Car Citroen C4 Blue Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry Warning Letter N/A   52.4257402 -1.5185037
13902 op-snap---monthly-publication-july-2025.pdf   1954 2025-07 Pedal Bike Nissan qashqai Black Driving without Due Care and Attention None Stoney Stanton Stoney Stanton Coventry Coventry Warning Letter N/A   52.4196813 -1.4978941
13913 op-snap---monthly-publication-july-2025.pdf   1965 2025-07 Pedal Bike Audi A4 Black Driving without Due Care and Attention None broad lane Broad Lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
13918 op-snap---monthly-publication-july-2025.pdf   1970 2025-07 Car Mazda 3 Sport Silver Driving without Due Care and Attention None Holyhead road Holyhead road Coventry Coventry Warning Letter N/A   52.418488 -1.5472387
13947 op-snap---monthly-publication-july-2025.pdf   1999 2025-07 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
13948 op-snap---monthly-publication-july-2025.pdf   2000 2025-07 Pedal Bike Vauxhall Movano White Driving without Due Care and Attention None Broadway Broadway Coventry Coventry Warning Letter N/A   52.3999339 -1.5249817
13949 op-snap---monthly-publication-july-2025.pdf   2001 2025-07 Pedal Bike Ford Ranger Silver Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
13950 op-snap---monthly-publication-july-2025.pdf   2002 2025-07 Pedal Bike BMW 120D Brown Driving without Due Care and Attention None Queensland Avenue Queensland Avenue Coventry Coventry Warning Letter N/A   52.406658 -1.5363495
13957 op-snap---monthly-publication-july-2025.pdf   2009 2025-07 Motorbike Ford Fiesta Red Driving without Due Care and Attention None A444 Gallagher shopping center Gallagher shopping center Coventry Coventry Warning Letter N/A      
13961 op-snap---monthly-publication-july-2025.pdf   2013 2025-07 Car Mercedes-Benz c220 Black Driving without Due Care and Attention None A444 A444 Coventry Coventry Warning Letter N/A      
14100 op-snap---monthly-publication-june-2025.pdf   29 2025-06 Car BMW X6 White Driving without Due Care and Attention None Rowleys Green Roundabout Rowleys Green Roundabout Coventry Coventry Warning Letter N/A   52.4486967 -1.4991069
14217 op-snap---monthly-publication-june-2025.pdf   146 2025-06 Car Audi A3 Grey Driving without Due Care and Attention None Stonebridge Island Stonebridge Island Coventry Coventry Warning Letter N/A   52.4459998 -1.6949291
14527 op-snap---monthly-publication-june-2025.pdf   456 2025-06 Pedal Bike Audi A6 Black Driving without Due Care and Attention None Gibbet Hill Road Gibbet Hill Road Coventry Coventry Warning Letter N/A   52.3749141 -1.5564977
15052 op-snap---monthly-publication-june-2025.pdf   981 2025-06 Pedal Bike Suzuki Ignis White Driving without Due Care and Attention None Herald Avenue Herald Avenue Coventry Coventry Warning Letter N/A   52.4029059 -1.5541193
15429 op-snap---monthly-publication-june-2025.pdf   1358 2025-06 Pedal Bike Mercedes-Benz A45 Black Driving without Due Care and Attention None A429 Kenilworth Road Kenilworth Road Coventry Coventry Warning Letter N/A   52.3833298 -1.5379214
18917 op-snap---monthly-publication-may-2025.pdf   279 2025-05 Car Mercedes-Benz Van White Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry Warning Letter N/A   52.4085943 -1.4943275
19283 op-snap---monthly-publication-may-2025.pdf   645 2025-05 Car Mercedes-Benz CLS350 Black Driving without Due Care and Attention None Gibbett Hill Road Gibbett Hill Road Coventry Coventry Warning Letter N/A   52.3744413 -1.553746
19681 op-snap---monthly-publication-may-2025.pdf   1043 2025-05 Pedal Bike BMW X1 Blue Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19682 op-snap---monthly-publication-may-2025.pdf   1044 2025-05 Pedal Bike Mercedes-Benz GLB Silver Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19683 op-snap---monthly-publication-may-2025.pdf   1045 2025-05 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
20129 op-snap---monthly-publication-may-2025.pdf   1491 2025-05 Car Honda Jazz Black Driving without Due Care and Attention None Kennilworth Road Kennilworth Road Coventry Coventry Warning Letter N/A      
20183 op-snap---monthly-publication-may-2025.pdf   1545 2025-05 Pedal Bike Mercedes-Benz A class Black Driving without Due Care and Attention none Ansty Road Ansty Road Coventry Coventry Warning Letter N/A   52.4205675 -1.4520187
20188 op-snap---monthly-publication-may-2025.pdf   1550 2025-05 Pedal Bike Ford Transit Blue Driving without Due Care and Attention none Ansty Road Ansty Road Coventry Coventry Warning Letter N/A   52.4205675 -1.4520187
20238 op-snap---monthly-publication-may-2025.pdf   1600 2025-05 Car Nissan Qashqi Orange Driving without Due Care and Attention None Medow Park, Coventry Medow Park, Coventry Coventry Coventry Warning Letter N/A      

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