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

104 rows where council_area = "Coventry", disposal = "Education" and offence = "Driving without Reasonable Consideration" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence

vehicle_make 24

  • Ford 17
  • Volkswagen 14
  • Toyota 10
  • BMW 9
  • Audi 8
  • Vauxhall 8
  • Mercedes-Benz 6
  • Land Rover 5
  • Nissan 3
  • Hyundai 2
  • Jaguar 2
  • Kia 2
  • Lexus 2
  • Renault 2
  • Tesla 2
  • Volvo 2
  • Citroen 1
  • Fiat 1
  • Honda 1
  • Mazda 1
  • Mini 1
  • Seat 1
  • Skoda 1
  • Suzuki 1

month 12

  • 2025-01 32
  • 2025-02 29
  • 2025-03 27
  • 2025-09 4
  • 2025-04 3
  • 2025-05 2
  • 2025-08 2
  • 2025-06 1
  • 2025-07 1
  • 2025-10 1
  • 2025-11 1
  • 2026-02 1

reporter_transport_mode 4

  • Pedal Bike 90
  • Car 11
  • Pedestrian 2
  • pedal bike 1

offence 1

  • Driving without Reasonable Consideration · 104 ✖

disposal 1

  • Education · 104 ✖

council_area 1

  • Coventry · 104 ✖
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
8494 op-snap---monthly-publication-february-2026.pdf   1241 2026-02 Car Mercedes-Benz 400 AMG Black Driving without Reasonable Consideration None Hockley Lane Hockley Lane Coventry Coventry Education N/A   52.4165323 -1.6001601
20635 op-snap---monthly-publication-november-2025.pdf   177 2025-11 Pedal Bike Toyota Auris Blue Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
22198 op-snap---monthly-publication-october-2025.pdf   148 2025-10 Car Ford Fiesta Red Driving without Reasonable Consideration None A4053 RIng Road A4053 RIng Road Coventry Coventry Education N/A      
24285 op-snap---monthly-publication-september-2025.pdf   504 2025-09 Car BMW 320 White Driving without Reasonable Consideration None Princetorpe Way Princetorpe Way Coventry Coventry Education N/A      
24312 op-snap---monthly-publication-september-2025.pdf   531 2025-09 Pedal Bike Toyota yaris Silver Driving without Reasonable Consideration None Radford Road/Wallace Road Radford Road/Wallace Road Coventry Coventry Education N/A   52.4235908 -1.5226276
24625 op-snap---monthly-publication-september-2025.pdf   844 2025-09 Car Ford Smax Grey Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
24633 op-snap---monthly-publication-september-2025.pdf   852 2025-09 Pedal Bike Volkswagen Crafter White Driving without Reasonable Consideration None Earlsdon Avenue North Earlsdon Avenue North Coventry Coventry Education N/A   52.4025196 -1.5327802
2171 op-snap---monthly-publication-august-2025.pdf   146 2025-08 Pedal Bike Tesla   Red Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
2203 op-snap---monthly-publication-august-2025.pdf   178 2025-08 Pedal Bike Volkswagen ID Grey Driving without Reasonable Consideration None St James Lane Street James Lane Coventry Coventry Education N/A      
12168 op-snap---monthly-publication-july-2025.pdf   220 2025-07 Pedal Bike Tesla Model 3 White Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
14146 op-snap---monthly-publication-june-2025.pdf   75 2025-06 Car Toyota Aygo Silver Driving without Reasonable Consideration None Radford Road Radford Road Coventry Coventry Education N/A   52.4235908 -1.5226276
18868 op-snap---monthly-publication-may-2025.pdf   230 2025-05 Pedal Bike Volkswagen Tiguan Grey Driving without Reasonable Consideration None Allesley Road Allesley Road Coventry Coventry Education N/A   52.412663 -1.5443742
18892 op-snap---monthly-publication-may-2025.pdf   254 2025-05 Pedal Bike Mini Cooper Red Driving without Reasonable Consideration None Tanners Lane Tanners Lane Coventry Coventry Education N/A   52.4007746 -1.5997847
37 op-snap---monthly-publication-april-2025.pdf   36 2025-04 Pedal Bike Vauxhall Zafira Blue Driving without Reasonable Consideration None Earlsdon Av South Earlsdon Avenue South Coventry Coventry Education N/A   52.3960991 -1.5255671
72 op-snap---monthly-publication-april-2025.pdf   71 2025-04 Pedal Bike Audi A3.. Red Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A   52.4274335 -1.5002381
147 op-snap---monthly-publication-april-2025.pdf   146 2025-04 Car Seat Mii White Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A   52.4274335 -1.5002381
16298 op-snap---monthly-publication-march-2025.pdf   55 2025-03 Pedal Bike Citroen C2 Blue Driving without Reasonable Consideration None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A Yes - Via Email 52.4047134 -1.5351834
16308 op-snap---monthly-publication-march-2025.pdf   65 2025-03 Pedal Bike BMW 3 series White Driving without Reasonable Consideration None Stoney Stanton Rd Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
16517 op-snap---monthly-publication-march-2025.pdf   274 2025-03 Pedal Bike Honda Jazz Blue Driving without Reasonable Consideration None Wigston Road Wigston Road Coventry Coventry Education N/A Yes - Via Email 52.4302822 -1.4386034
16890 op-snap---monthly-publication-march-2025.pdf   647 2025-03 Pedal Bike Volkswagen Golf White Driving without Reasonable Consideration None Knoll Drive Knoll Drive Coventry Coventry Education N/A Yes - Via Email 52.3875878 -1.5129201
16894 op-snap---monthly-publication-march-2025.pdf   651 2025-03 Pedal Bike BMW 520 Black Driving without Reasonable Consideration None Bridge Road Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4211632 -1.4473468
17053 op-snap---monthly-publication-march-2025.pdf   810 2025-03 Pedal Bike Mercedes-Benz Box Van Brown Driving without Reasonable Consideration None Foles Hill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
17055 op-snap---monthly-publication-march-2025.pdf   812 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Earlsdon Road Earlsdon Road Coventry Coventry Education N/A Yes - Via Email 52.3972344 -1.5388569
17302 op-snap---monthly-publication-march-2025.pdf   1059 2025-03 Pedal Bike Toyota CHR White Driving without Reasonable Consideration None Wallace Road Wallace Road Coventry Coventry Education N/A Yes - Via Email 52.4315278 -1.5274137
17306 op-snap---monthly-publication-march-2025.pdf   1063 2025-03 Pedestrian Ford Fiesta Grey Driving without Reasonable Consideration None Gosford Street Gosford Street Coventry Coventry Education N/A Yes - Via Email 52.4068712 -1.4994695
17399 op-snap---monthly-publication-march-2025.pdf   1156 2025-03 Pedal Bike Toyota BZ4X Grey Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
17400 op-snap---monthly-publication-march-2025.pdf   1157 2025-03 Pedal Bike Volkswagen Transporter White Driving without Reasonable Consideration None Cliffoird Bridge Road Cliffoird Bridge Road Coventry Coventry Education N/A Yes - Via Email    
17401 op-snap---monthly-publication-march-2025.pdf   1158 2025-03 Pedal Bike Renault HGV Green Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
17403 op-snap---monthly-publication-march-2025.pdf   1160 2025-03 Pedal Bike Ford Transit Silver Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
17466 op-snap---monthly-publication-march-2025.pdf   1223 2025-03 Pedal Bike Toyota Avensis Black Driving without Reasonable Consideration None Torrington Avenue Torrington Avenue Coventry Coventry Education N/A Yes - Via Email 52.3987354 -1.567693
17551 op-snap---monthly-publication-march-2025.pdf   1308 2025-03 Car Volkswagen Golf Red Driving without Reasonable Consideration None Barker Butts Lane Barker Butts Lane Coventry Coventry Education N/A Yes - Via Email    
17554 op-snap---monthly-publication-march-2025.pdf   1311 2025-03 Pedal Bike BMW X3 White Driving without Reasonable Consideration None BROOMFIELD ROAD Broomfield Road Coventry Coventry Education N/A Yes - Via Email 52.4034143 -1.5300449
17713 op-snap---monthly-publication-march-2025.pdf   1470 2025-03 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None The Scotchill The Scotchill Coventry Coventry Education N/A Yes - Via Email 52.435625 -1.528323
17715 op-snap---monthly-publication-march-2025.pdf   1472 2025-03 Pedal Bike Ford C-Max Black Driving without Reasonable Consideration None Browett Road Browett Road Coventry Coventry Education N/A Yes - Via Email 52.4159473 -1.5310383
17768 op-snap---monthly-publication-march-2025.pdf   1525 2025-03 Pedal Bike Vauxhall Astra White Driving without Reasonable Consideration None Spon End Spon End Coventry Coventry Education N/A Yes - Via Email 52.4069072 -1.5247498
18050 op-snap---monthly-publication-march-2025.pdf   1807 2025-03 Pedal Bike Lexus CT200 White Driving without Reasonable Consideration None Wigston Road Wigston Road Coventry Coventry Education N/A Yes - Via Email 52.4302822 -1.4386034
18084 op-snap---monthly-publication-march-2025.pdf   1841 2025-03 Pedal Bike BMW 520D Black Driving without Reasonable Consideration None Daventry Road Daventry Road Coventry Coventry Education N/A Yes - Via Email 52.3930931 -1.4976428
18166 op-snap---monthly-publication-march-2025.pdf   1923 2025-03 Car Vauxhall Astra Black Driving without Reasonable Consideration None Butts Road Butts Road Coventry Coventry Education N/A Yes - Via Email 52.4073149 -1.5250454
18167 op-snap---monthly-publication-march-2025.pdf   1924 2025-03 Pedal Bike Mazda 3... Red Driving without Reasonable Consideration None Lower Ford Street Lower Ford Street Coventry Coventry Education N/A Yes - Via Email 52.4082494 -1.4982568
18169 op-snap---monthly-publication-march-2025.pdf   1926 2025-03 Pedal Bike Volkswagen Golf Grey Driving without Reasonable Consideration None Willenhall Lane Coventry Willenhall Lane Coventry Coventry Coventry Education N/A Yes - Via Email 52.3842758 -1.4699612
18218 op-snap---monthly-publication-march-2025.pdf   1975 2025-03 Pedal Bike BMW 520 Blue Driving without Reasonable Consideration None Stonleigh Road Coventry Stonleigh Road Coventry Coventry Coventry Education N/A Yes - Via Email    
18350 op-snap---monthly-publication-march-2025.pdf   2107 2025-03 Pedal Bike Ford TRANSIT 350 White Driving without Reasonable Consideration None WOODWAY LANE Woodway Lane Coventry Coventry Education N/A Yes - Via Email 52.4275505 -1.4448681
18356 op-snap---monthly-publication-march-2025.pdf   2113 2025-03 Pedal Bike Ford Puma Black Driving without Reasonable Consideration None Woodway Lane, Woodway Lane Coventry Coventry Education N/A Yes - Via Email 52.4275505 -1.4448681
5214 op-snap---monthly-publication-february-2025.pdf   31 2025-02 Pedal Bike BMW 320D Silver Driving without Reasonable Consideration None Wall Hill Road Wall Hill Road Coventry Coventry Education N/A Yes - Via Email 52.4459445 -1.5552508
5272 op-snap---monthly-publication-february-2025.pdf   89 2025-02 Pedal Bike Volkswagen Taigo White Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
5342 op-snap---monthly-publication-february-2025.pdf   159 2025-02 Pedal Bike Volkswagen Passat Silver Driving without Reasonable Consideration None Woodway Lane Woodway Lane Coventry Coventry Education N/A Yes - Via Email 52.4275505 -1.4448681
5344 op-snap---monthly-publication-february-2025.pdf   161 2025-02 Pedal Bike Nissan   Red Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5345 op-snap---monthly-publication-february-2025.pdf   162 2025-02 Pedal Bike Audi S3 Black Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5348 op-snap---monthly-publication-february-2025.pdf   165 2025-02 Pedal Bike Ford Mondeo Red Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5362 op-snap---monthly-publication-february-2025.pdf   179 2025-02 Pedal Bike Renault Captur Grey Driving without Reasonable Consideration None Waste Lane Waste Lane Coventry Coventry Education N/A Yes - Via Email 52.437361 -1.5371291
5510 op-snap---monthly-publication-february-2025.pdf   327 2025-02 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
5697 op-snap---monthly-publication-february-2025.pdf   514 2025-02 Pedal Bike Mercedes-Benz A180 White Driving without Reasonable Consideration None Allesley OId Road Allesley OId Road Coventry Coventry Education N/A Yes - Via Email    
5982 op-snap---monthly-publication-february-2025.pdf   799 2025-02 Pedal Bike BMW I4 Grey Driving without Reasonable Consideration None Foleshill Rd Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
6120 op-snap---monthly-publication-february-2025.pdf   937 2025-02 Pedal Bike Volvo Car Transporter Orange Driving without Reasonable Consideration None Ansty Road Ansty Road Coventry Coventry Education N/A Yes - Via Email 52.4205675 -1.4520187
6124 op-snap---monthly-publication-february-2025.pdf   941 2025-02 Pedal Bike Nissan Qashqai Grey Driving without Reasonable Consideration None Walsgrave Road Walsgrave Road Coventry Coventry Education N/A Yes - Via Email 52.4096725 -1.487901
6287 op-snap---monthly-publication-february-2025.pdf   1104 2025-02 Pedal Bike Audi A3 Blue Driving without Reasonable Consideration None Butts Road Coventry Butts Road Coventry Coventry Coventry Education N/A Yes - Via Email 52.4057326 -1.5193939
6358 op-snap---monthly-publication-february-2025.pdf   1175 2025-02 Pedal Bike Audi A5 Grey Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
6471 op-snap---monthly-publication-february-2025.pdf   1288 2025-02 Pedal Bike Jaguar I-pace Blue Driving without Reasonable Consideration None Butts Road Butts Road Coventry Coventry Education N/A Yes - Via Email 52.4073149 -1.5250454
6533 op-snap---monthly-publication-february-2025.pdf   1350 2025-02 Pedal Bike Lexus RX-7 White Driving without Reasonable Consideration None Coundon Wedge Drive Coundon Wedge Drive Coventry Coventry Education N/A Yes - Via Email 52.4385402 -1.5483746
6537 op-snap---monthly-publication-february-2025.pdf   1354 2025-02 Pedal Bike Audi A8 Silver Driving without Reasonable Consideration None Hinckley Road Hinckley Road Coventry Coventry Education N/A Yes - Via Email 52.435502 -1.4327166
6631 op-snap---monthly-publication-february-2025.pdf   1448 2025-02 Pedal Bike Skoda Superb Silver Driving without Reasonable Consideration None A429 Kenilworth Road Kenilworth Road Coventry Coventry Education N/A Yes - Via Email 52.3833298 -1.5379214
6737 op-snap---monthly-publication-february-2025.pdf   1554 2025-02 Pedal Bike Volkswagen Tiguan Grey Driving without Reasonable Consideration none Condon Wedge Drive Condon Wedge Drive Coventry Coventry Education N/A Yes - Via Email    
6738 op-snap---monthly-publication-february-2025.pdf   1555 2025-02 Pedal Bike Volvo XC40 Grey Driving without Reasonable Consideration None Wall Hill Rd Wall Hill Road Coventry Coventry Education N/A Yes - Via Email 52.4459445 -1.5552508
6739 op-snap---monthly-publication-february-2025.pdf   1556 2025-02 Pedal Bike Land Rover Freelander Silver Driving without Reasonable Consideration None Allesley Old Rd Allesley Old Road Coventry Coventry Education N/A Yes - Via Email 52.4103629 -1.5441218
6870 op-snap---monthly-publication-february-2025.pdf   1687 2025-02 Pedal Bike Nissan Qashqai Grey Driving without Reasonable Consideration None Torrington Avenue Coventry Torrington Avenue Coventry Coventry Coventry Education N/A Yes - Via Email 52.3987354 -1.567693
6890 op-snap---monthly-publication-february-2025.pdf   1707 2025-02 Pedestrian Mercedes-Benz A250 Grey Driving without Reasonable Consideration None Tile Hill Lane, junction with Jobs Lane Tile Hill Lane, junction with Jobs Lane Coventry Coventry Education N/A Yes - Via Email 52.4041214 -1.5607562
6920 op-snap---monthly-publication-february-2025.pdf   1737 2025-02 Pedal Bike Vauxhall Vivaro White Driving without Reasonable Consideration None Queens Road Queens Road Coventry Coventry Education N/A Yes - Via Email 52.4045286 -1.5186641
7075 op-snap---monthly-publication-february-2025.pdf   1892 2025-02 Pedal Bike Jaguar XF Black Driving without Reasonable Consideration None TORRINGTON AVENUE Torrington Avenue Coventry Coventry Education N/A Yes - Via Email 52.3987354 -1.567693
7091 op-snap---monthly-publication-february-2025.pdf   1908 2025-02 Pedal Bike Land Rover Defender Black Driving without Reasonable Consideration None Lentons Lane Lentons Lane Coventry Coventry Education N/A Yes - Via Email 52.4503238 -1.4546397
7155 op-snap---monthly-publication-february-2025.pdf   1972 2025-02 Pedal Bike BMW 120 Black Driving without Reasonable Consideration None Wolfe Road Wolfe Road Coventry Coventry Education N/A Yes - Via Email 52.395482 -1.575749
7214 op-snap---monthly-publication-february-2025.pdf   2031 2025-02 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None Briton Road Briton Road Coventry Coventry Education N/A Yes - Via Email 52.412783 -1.480642
7215 op-snap---monthly-publication-february-2025.pdf   2032 2025-02 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None Mercer Avenue Mercer Avenue Coventry Coventry Education N/A Yes - Via Email 52.4170303 -1.482739
8971 op-snap---monthly-publication-january-2025.pdf   79 2025-01 Pedal Bike Vauxhall Zaffira Brown Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
9145 op-snap---monthly-publication-january-2025.pdf   253 2025-01 Pedal Bike Land Rover SPORT White Driving without Reasonable Consideration None MOSELEY AVENUE Moseley Avenue Coventry Coventry Education N/A Yes - Via Email 52.417344 -1.5264979
9187 op-snap---monthly-publication-january-2025.pdf   295 2025-01 Car Audi A3 Black Driving without Reasonable Consideration None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A Yes - Via Email 52.4214017 -1.4870278
9282 op-snap---monthly-publication-january-2025.pdf   390 2025-01 Pedal Bike Mercedes-Benz C250 AMG Grey Driving without Reasonable Consideration None Much Park Street Much Park Street Coventry Coventry Education N/A Yes - Via Email 52.4061531 -1.505845
9387 op-snap---monthly-publication-january-2025.pdf   495 2025-01 Pedal Bike Land Rover FREELANDER Black Driving without Reasonable Consideration None Middlemarch Road Middlemarch Road Coventry Coventry Education N/A Yes - Via Email 52.4316434 -1.5142862
9389 op-snap---monthly-publication-january-2025.pdf   497 2025-01 Pedal Bike Ford Fiesta Grey Driving without Reasonable Consideration None Spon End Spon End Coventry Coventry Education N/A Yes - Via Email 52.4069072 -1.5247498
9392 op-snap---monthly-publication-january-2025.pdf   500 2025-01 Pedal Bike Hyundai I10 Blue Driving without Reasonable Consideration None Browns Lane Browns Lane Coventry Coventry Education N/A Yes - Via Email 52.435719 -1.5617089
9470 op-snap---monthly-publication-january-2025.pdf   578 2025-01 pedal bike Kia SPORTAGE White Driving without Reasonable Consideration None STONEY STANTON ROAD Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
9544 op-snap---monthly-publication-january-2025.pdf   652 2025-01 Pedal Bike Suzuki SX4 Blue Driving without Reasonable Consideration None Mile Lane Mile Lane Coventry Coventry Education N/A Yes - Via Email 52.3992732 -1.5044832
9555 op-snap---monthly-publication-january-2025.pdf   663 2025-01 Car Toyota Corolla Black Driving without Reasonable Consideration None Radford Road Radford Road Coventry Coventry Education N/A Yes - Via Email 52.4235908 -1.5226276
9593 op-snap---monthly-publication-january-2025.pdf   701 2025-01 Pedal Bike Mercedes-Benz C200 Grey Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
9615 op-snap---monthly-publication-january-2025.pdf   723 2025-01 Pedal Bike Hyundai Ioniq White Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
9775 op-snap---monthly-publication-january-2025.pdf   883 2025-01 Pedal Bike Ford Ranger Grey Driving without Reasonable Consideration None Brandon Road Brandon Road Coventry Coventry Education N/A Yes - Via Email 52.399222 -1.4414386
9790 op-snap---monthly-publication-january-2025.pdf   898 2025-01 Pedal Bike Fiat TRANSIT Silver Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
9913 op-snap---monthly-publication-january-2025.pdf   1021 2025-01 Pedal Bike Volkswagen CADDY White Driving without Reasonable Consideration None CLIFFORD BRIDGE ROAD Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
9937 op-snap---monthly-publication-january-2025.pdf   1045 2025-01 Pedal Bike Volkswagen GOLF White Driving without Reasonable Consideration None DUGGINS LANE Duggins Lane Coventry Coventry Education N/A Yes - Via Email 52.3964189 -1.5989088
9949 op-snap---monthly-publication-january-2025.pdf   1057 2025-01 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Lockhurst Lane Lockhurst Lane Coventry Coventry Education N/A Yes - Via Email 52.4255689 -1.5023841
9951 op-snap---monthly-publication-january-2025.pdf   1059 2025-01 Pedal Bike Ford Kuga Silver Driving without Reasonable Consideration None Lockhurst Lane Lockhurst Lane Coventry Coventry Education N/A Yes - Via Email 52.4255689 -1.5023841
9966 op-snap---monthly-publication-january-2025.pdf   1074 2025-01 Pedal Bike Toyota Prius White Driving without Reasonable Consideration None Dutton Road Dutton Road Coventry Coventry Education N/A Yes - Via Email 52.4447067 -1.458495
9983 op-snap---monthly-publication-january-2025.pdf   1091 2025-01 Pedal Bike Ford Mondeo Blue Driving without Reasonable Consideration None Brinklow Road Brinklow Road Coventry Coventry Education N/A Yes - Via Email 52.4028059 -1.4461048
9984 op-snap---monthly-publication-january-2025.pdf   1092 2025-01 Pedal Bike Vauxhall Viva Silver Driving without Reasonable Consideration None Binley Road Binley Road Coventry Coventry Education N/A Yes - Via Email 52.4070602 -1.4732469
10065 op-snap---monthly-publication-january-2025.pdf   1173 2025-01 Pedal Bike   London Taxi Black Driving without Reasonable Consideration None Warwick Road Warwick Road Coventry Coventry Education N/A Yes - Via Email 52.401916 -1.5154953
10126 op-snap---monthly-publication-january-2025.pdf   1234 2025-01 Car Vauxhall Astra Blue Driving without Reasonable Consideration None A45, Dunchurch Highway A45, Dunchurch Highway Coventry Coventry Education N/A Yes - Via Email 52.4089495 -1.5595419
10221 op-snap---monthly-publication-january-2025.pdf   1329 2025-01 Pedal Bike Kia SPORTAGE White Driving without Reasonable Consideration None BROAD LANE Broad Lane Coventry Coventry Education N/A Yes - Via Email 52.4074716 -1.5620671
10429 op-snap---monthly-publication-january-2025.pdf   1537 2025-01 Pedal Bike Land Rover Sport Blue Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
10430 op-snap---monthly-publication-january-2025.pdf   1538 2025-01 Pedal Bike Audi A5 Black Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
10431 op-snap---monthly-publication-january-2025.pdf   1539 2025-01 Pedal Bike Audi Q2 Black Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
10433 op-snap---monthly-publication-january-2025.pdf   1541 2025-01 Pedal Bike   BYD Bus Grey Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958

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