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

186 rows where council_area = "Coventry", disposal = "NFA" 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

reporter_transport_mode 6

offence 1

  • Driving without Due Care and Attention · 186 ✖

disposal 1

  • NFA · 186 ✖

council_area 1

  • Coventry · 186 ✖
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
7319 op-snap---monthly-publication-february-2026.pdf   66 2026-02 Car Mercedes-Benz 160 White Driving without Due Care and Attention None Ringway Queens Ringway Queens Coventry Coventry NFA No Offence   52.4039782 -1.5161639
7632 op-snap---monthly-publication-february-2026.pdf   379 2026-02 Pedal Bike Seat Leon Silver Driving without Due Care and Attention None Woodstock Road Woodstock Road Coventry Coventry NFA No Independent Evidence Available   52.3919059 -1.5026146
7831 op-snap---monthly-publication-february-2026.pdf   578 2026-02 Pedal Bike Daf   White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
8056 op-snap---monthly-publication-february-2026.pdf   803 2026-02 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None Brinklow Road Brinklow Road Coventry Coventry NFA Outside of 14 Days NIP   52.4028059 -1.4461048
8058 op-snap---monthly-publication-february-2026.pdf   805 2026-02 Car Volkswagen Golf Grey Driving without Due Care and Attention None A45 A45 Coventry Coventry NFA No Offence      
8245 op-snap---monthly-publication-february-2026.pdf   992 2026-02 Car BMW 5 Series Blue Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry NFA No Independent Evidence Available      
8541 op-snap---monthly-publication-february-2026.pdf   1288 2026-02 Car Nissan Micra Grey Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry NFA No Independent Evidence Available   52.4318623 -1.4804069
8552 op-snap---monthly-publication-february-2026.pdf   1299 2026-02 Car Vauxhall Vivaro Grey Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry NFA No Offence   52.4073149 -1.5250454
8613 op-snap---monthly-publication-february-2026.pdf   1360 2026-02 Car Mercedes-Benz CLA Black Driving without Due Care and Attention None A45 A45 Coventry Coventry NFA No Independent Evidence Available      
10553 op-snap---monthly-publication-january-2026.pdf   14 2026-01 Car Toyota Avensis Silver Driving without Due Care and Attention None M6 NB J3 M6 Northbound J3 Coventry Coventry NFA No Independent Evidence Available   52.6760749 -2.0862582
10570 op-snap---monthly-publication-january-2026.pdf   31 2026-01 Car Mazda 6 SE-L Grey Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4274335 -1.5002381
10803 op-snap---monthly-publication-january-2026.pdf   264 2026-01 Car Mercedes-Benz E250 Grey Driving without Due Care and Attention None London Road London Road Coventry Coventry NFA No Offence   52.3916468 -1.4925995
10853 op-snap---monthly-publication-january-2026.pdf   314 2026-01 Car BMW 439I White Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry NFA No Independent Evidence Available   52.4068712 -1.4994695
11098 op-snap---monthly-publication-january-2026.pdf   559 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry NFA Not in Public Interest   52.4073149 -1.5250454
11495 op-snap---monthly-publication-january-2026.pdf   956 2026-01 Car Toyota Yaris White Driving without Due Care and Attention None Daventry Road Daventry Road Coventry Coventry NFA Not in Public Interest   52.3930931 -1.4976428
11557 op-snap---monthly-publication-january-2026.pdf   1018 2026-01 Car   Unknown Green Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Coventry Coventry NFA No Offence   52.423427 -1.5471096
11585 op-snap---monthly-publication-january-2026.pdf   1046 2026-01 Car Seat Altea Silver Driving without Due Care and Attention None Wainbody Avenue Wainbody Avenue Coventry Coventry NFA No Independent Evidence Available   52.3849692 -1.5311416
11607 op-snap---monthly-publication-january-2026.pdf   1068 2026-01 Car Nissan X-Trail White Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry NFA No Independent Evidence Available   52.418488 -1.5472387
11797 op-snap---monthly-publication-january-2026.pdf   1258 2026-01 Car Toyota Dyna van White Driving without Due Care and Attention None Roundabout Middlemarch Business Park Roundabout Middlemarch Business Park Coventry Coventry NFA No Offence      
3879 op-snap---monthly-publication-december-2025.pdf   7 2025-12 Car Renault Lorry White Driving without Due Care and Attention None M6 M6 Coventry Coventry NFA No Offence      
4378 op-snap---monthly-publication-december-2025.pdf   506 2025-12 Pedal Bike   U/K White Driving without Due Care and Attention None Belgrave Road Belgrave Road Coventry Coventry NFA No Independent Evidence Available   52.4141017 -1.4571973
4465 op-snap---monthly-publication-december-2025.pdf   593 2025-12 Car   Quad Black Driving without Due Care and Attention None UK Uk Coventry Coventry NFA No VRM   52.3994858 -1.4923603
4586 op-snap---monthly-publication-december-2025.pdf   714 2025-12 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Waste Lane, Balsall Common Waste Lane, Balsall Common Coventry Coventry NFA No Offence      
4623 op-snap---monthly-publication-december-2025.pdf   751 2025-12 Car Mercedes-Benz GLE 400 Blue Driving without Due Care and Attention None A46 A46 Coventry Coventry NFA No Offence      
4638 op-snap---monthly-publication-december-2025.pdf   766 2025-12 Car BMW   Black Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry NFA No VRM   52.4085943 -1.4943275
4807 op-snap---monthly-publication-december-2025.pdf   935 2025-12 Car Ford Cmax Blue Driving without Due Care and Attention None Oakmoor Road Oakmoor Road Coventry Coventry NFA Outside of 14 Days NIP   52.4485736 -1.4819358
4815 op-snap---monthly-publication-december-2025.pdf   943 2025-12 Other Audi SQ7 Grey Driving without Due Care and Attention None Greens End Road Greens End Road Coventry Coventry NFA Out of Force      
4895 op-snap---monthly-publication-december-2025.pdf   1023 2025-12 Car Ford Focus Grey Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA No VRM   52.4235908 -1.5226276
4896 op-snap---monthly-publication-december-2025.pdf   1024 2025-12 Car Ford Focus Grey Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA Duplicate Submission   52.4235908 -1.5226276
4899 op-snap---monthly-publication-december-2025.pdf   1027 2025-12 Car Ford Focus Grey Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA Duplicate Submission   52.4235908 -1.5226276
4902 op-snap---monthly-publication-december-2025.pdf   1030 2025-12 Car Ford Focus Grey Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA Duplicate Submission   52.4235908 -1.5226276
4948 op-snap---monthly-publication-december-2025.pdf   1076 2025-12 Car Hyundai I10 White Driving without Due Care and Attention None Croft Road Ringway Croft Road Ringway Coventry Coventry NFA Outside of 14 DAYS Late Submission      
5005 op-snap---monthly-publication-december-2025.pdf   1133 2025-12 Car Vauxhall Insignia Black Driving without Due Care and Attention None Charter Avenue Charter Avenue Coventry Coventry NFA No Independent Evidence Available   52.3928409 -1.5888076
5051 op-snap---monthly-publication-december-2025.pdf   1179 2025-12 Car Ford Focus Black Driving without Due Care and Attention None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA No Independent Evidence Available   52.4214017 -1.4870278
5081 op-snap---monthly-publication-december-2025.pdf   1209 2025-12 Car Peugeot 3008.. Black Driving without Due Care and Attention None Stivichall Interchange Stivichall, Coventry Coventry Coventry NFA No Offence   52.3834202 -1.5132278
5137 op-snap---monthly-publication-december-2025.pdf   1265 2025-12 Car Kia Nero Black Driving without Due Care and Attention None A444 A444 Coventry Coventry NFA Not in Public Interest      
20492 op-snap---monthly-publication-november-2025.pdf   34 2025-11 Pedal Bike Byd Bus Grey Driving without Due Care and Attention None Hale Street Hale Street Coventry Coventry NFA No Offence      
20581 op-snap---monthly-publication-november-2025.pdf   123 2025-11 Other Volkswagen Golf Black Driving without Due Care and Attention None Gooch Street Gooch Street Coventry Coventry NFA No Independent Evidence Available      
20659 op-snap---monthly-publication-november-2025.pdf   201 2025-11 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Bell Green Road Bell Green Road Coventry Coventry NFA Not in Public Interest   52.4324855 -1.4815548
20711 op-snap---monthly-publication-november-2025.pdf   253 2025-11 Car Nissan Qashqai Black Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry NFA No Offence   52.396476 -1.5561348
21298 op-snap---monthly-publication-november-2025.pdf   840 2025-11 Pedal Bike Peugeot 2008 Grey Driving without Due Care and Attention None Rochester Road Rochester Road Coventry Coventry NFA No Offence   52.3974085 -1.5422796
21388 op-snap---monthly-publication-november-2025.pdf   930 2025-11 Pedal Bike Byd Temsa Coach White Driving without Due Care and Attention None Lawrence Sanders Road Lawrence Sanders Road Coventry Coventry NFA No Offence      
21392 op-snap---monthly-publication-november-2025.pdf   934 2025-11 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Tamworth Road Tamworth Road Coventry Coventry NFA No VRM   52.4380313 -1.5339558
21408 op-snap---monthly-publication-november-2025.pdf   950 2025-11 Pedestrian   Unknown Red Driving without Due Care and Attention None Sir Henry Parkes Road Sir Henry Parkes Road Coventry Coventry NFA No Offence   52.3900568 -1.5550766
21451 op-snap---monthly-publication-november-2025.pdf   993 2025-11 Car Honda Civic Red Driving without Due Care and Attention None Coventry Road Coventry Road Coventry Coventry NFA No Independent Evidence Available   52.4111289 -1.5094345
21493 op-snap---monthly-publication-november-2025.pdf   1035 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Grange Road Grange Road Coventry Coventry NFA No Offence   52.4521035 -1.4777638
21575 op-snap---monthly-publication-november-2025.pdf   1117 2025-11 Pedal Bike Volkswagen   Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA Not in Public Interest   52.4103629 -1.5441218
21927 op-snap---monthly-publication-november-2025.pdf   1469 2025-11 Car Ford Galaxy Red Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry NFA No Offence   52.4070602 -1.4732469
21967 op-snap---monthly-publication-november-2025.pdf   1509 2025-11 Pedal Bike   Levc White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
22072 op-snap---monthly-publication-october-2025.pdf   22 2025-10 Car BMW X5 Black Driving without Due Care and Attention None Styvechale Styvechale Coventry Coventry NFA No Offence   52.3834202 -1.5132278
22102 op-snap---monthly-publication-october-2025.pdf   52 2025-10 Pedal Bike BMW 435.. Black Driving without Due Care and Attention None Allesley Road Allesley Road Coventry Coventry NFA Outside of 14 Days NIP   52.412663 -1.5443742
22122 op-snap---monthly-publication-october-2025.pdf   72 2025-10 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Hurst Road Hurst Road Coventry Coventry NFA No Offence   52.4496884 -1.4816181
22212 op-snap---monthly-publication-october-2025.pdf   162 2025-10 Car Toyota C-HR Black Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA Outside of 14 Days NIP   52.4235908 -1.5226276
22213 op-snap---monthly-publication-october-2025.pdf   163 2025-10 Car Volkswagen   Grey Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA Outside of 14 DAYS Late Submission      
22224 op-snap---monthly-publication-october-2025.pdf   174 2025-10 Car BMW   Blue Driving without Due Care and Attention None Upper Eastern Green Lane, Upper Eastern Green Lane Coventry Coventry NFA No VRM   52.4171593 -1.5860076
22228 op-snap---monthly-publication-october-2025.pdf   178 2025-10 Car BMW 320D White Driving without Due Care and Attention None Anderton Road Anderton Road Coventry Coventry NFA Outside of 14 Days NIP   52.4519205 -1.4736655
22271 op-snap---monthly-publication-october-2025.pdf   221 2025-10 Pedal Bike Daf Lorry white Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4144409 -1.5990259
22353 op-snap---monthly-publication-october-2025.pdf   303 2025-10 Car Volvo XC60. Gold Driving without Due Care and Attention None Berskwell Road Berskwell Road Coventry Coventry NFA No Offence      
22403 op-snap---monthly-publication-october-2025.pdf   353 2025-10 Car Skoda Kodiaq Grey Driving without Due Care and Attention None Eastern Green Road Eastern Green Road Coventry Coventry NFA No Independent Evidence Available   52.4131188 -1.5784769
22449 op-snap---monthly-publication-october-2025.pdf   399 2025-10 Pedal Bike Renault Clio White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry NFA No Offence   52.4047134 -1.5351834
22450 op-snap---monthly-publication-october-2025.pdf   400 2025-10 Car Lexus   White Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA No Independent Evidence Available   52.4235908 -1.5226276
22546 op-snap---monthly-publication-october-2025.pdf   496 2025-10 Pedal Bike Mercedes-Benz C220 Grey Driving without Due Care and Attention None Hales Street / White Street Hales Street / White Street Coventry Coventry NFA No Offence   52.4107158 -1.5078486
22621 op-snap---monthly-publication-october-2025.pdf   571 2025-10 Pedal Bike Mercedes-Benz A35 Black Driving without Due Care and Attention None Shorncliffe Road Shorncliffe Road Coventry Coventry NFA Outside of 14 Days NIP   52.4243896 -1.5433694
22622 op-snap---monthly-publication-october-2025.pdf   572 2025-10 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Shorncliffe Road Shorncliffe Road Coventry Coventry NFA Outside of 14 Days NIP   52.4243896 -1.5433694
22678 op-snap---monthly-publication-october-2025.pdf   628 2025-10 Car Hyundai Kona Blue Driving without Due Care and Attention None Stonebridge Island Stonebridge Island Coventry Coventry NFA No Offence   52.4459998 -1.6949291
22680 op-snap---monthly-publication-october-2025.pdf   630 2025-10 Car Renault Cement mixer White Driving without Due Care and Attention None Dunchurch Highway Dunchurch Highway Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4131902 -1.5650136
22782 op-snap---monthly-publication-october-2025.pdf   732 2025-10 Car Mg HS Blue Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry NFA No Independent Evidence Available   52.4134557 -1.4442138
22801 op-snap---monthly-publication-october-2025.pdf   751 2025-10 Pedestrian BMW   Grey Driving without Due Care and Attention None Newport Road Newport Road Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4373088 -1.504993
22837 op-snap---monthly-publication-october-2025.pdf   787 2025-10 Car Jaguar XF Black Driving without Due Care and Attention None Bayton Road Bayton Road Coventry Coventry NFA Outside of 14 DAYS Late Submission      
22848 op-snap---monthly-publication-october-2025.pdf   798 2025-10 Car Ford S Max Grey Driving without Due Care and Attention None Barker Butts Lane Barker Butts Lane Coventry Coventry NFA No Independent Evidence Available      
22982 op-snap---monthly-publication-october-2025.pdf   932 2025-10 Car Audi A3 Grey Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry NFA No Offence   52.4070602 -1.4732469
23905 op-snap---monthly-publication-september-2025.pdf   124 2025-09 Car BMW   Silver Driving without Due Care and Attention None Tamworth Road Tamworth Road Coventry Coventry NFA No Offence   52.4380313 -1.5339558
23968 op-snap---monthly-publication-september-2025.pdf   187 2025-09 Car Vauxhall Zafira Blue Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry NFA No Offence   52.4070602 -1.4732469
24084 op-snap---monthly-publication-september-2025.pdf   303 2025-09 Car Ford Transit Grey Driving without Due Care and Attention None M6 NB J4-4A M6 Northbound J4-4A Coventry Coventry NFA Not in Public Interest   52.6912652 -2.1043715
24122 op-snap---monthly-publication-september-2025.pdf   341 2025-09 Pedal Bike Audi A1 Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
24138 op-snap---monthly-publication-september-2025.pdf   357 2025-09 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Fletchamstead Hwy Fletchamstead Hwy Coventry Coventry NFA No Offence   52.3971823 -1.5564772
24155 op-snap---monthly-publication-september-2025.pdf   374 2025-09 Car Vauxhall Corsa White Driving without Due Care and Attention Contravening a Red Traffic Light Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4214017 -1.4870278
24468 op-snap---monthly-publication-september-2025.pdf   687 2025-09 Car BMW M5 Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Coventry Coventry NFA No VRM   52.4111289 -1.5094345
24476 op-snap---monthly-publication-september-2025.pdf   695 2025-09 Car Audi A6 Silver Driving without Due Care and Attention None Charter Av Charter Avenue Coventry Coventry NFA No Offence   52.3928409 -1.5888076
24560 op-snap---monthly-publication-september-2025.pdf   779 2025-09 Car Ford Transit Grey Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry NFA No Offence   52.418488 -1.5472387
24588 op-snap---monthly-publication-september-2025.pdf   807 2025-09 Car Fiat 500 White Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry NFA No Independent Evidence Available   52.4134557 -1.4442138
24589 op-snap---monthly-publication-september-2025.pdf   808 2025-09 Car Seat Ibiza White Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry NFA No Independent Evidence Available   52.4134557 -1.4442138
24683 op-snap---monthly-publication-september-2025.pdf   902 2025-09 Car BMW M340 Grey Driving without Due Care and Attention None Coventry Inner Ring Road Coventry Inner Ring Road Coventry Coventry NFA No Offence      
24792 op-snap---monthly-publication-september-2025.pdf   1011 2025-09 Pedal Bike Ford Puma Black Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry NFA No Independent Evidence Available   52.4257402 -1.5185037
24793 op-snap---monthly-publication-september-2025.pdf   1012 2025-09 Pedal Bike BMW 3 Silver Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry NFA No Independent Evidence Available   52.4257402 -1.5185037
24803 op-snap---monthly-publication-september-2025.pdf   1022 2025-09 Car Toyota Prius White Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA No Independent Evidence Available   52.4235908 -1.5226276
24936 op-snap---monthly-publication-september-2025.pdf   1155 2025-09 Car Ford Transit Silver Driving without Due Care and Attention None Humber Road Humber Road Coventry Coventry NFA No Offence   52.4050667 -1.4866877
25319 op-snap---monthly-publication-september-2025.pdf   1538 2025-09 Car Honda motorcylcel Red Driving without Due Care and Attention None vanguard way Vanguard Way Coventry Coventry NFA Misc Inc Crimes      
2061 op-snap---monthly-publication-august-2025.pdf   36 2025-08 Car   Subaru Grey Driving without Due Care and Attention None Meeting House Lane Meeting House Lane Coventry Coventry NFA No Offence      
2078 op-snap---monthly-publication-august-2025.pdf   53 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA No Offence   52.4214017 -1.4870278
2097 op-snap---monthly-publication-august-2025.pdf   72 2025-08 Car Audi   Grey Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry NFA Not in Public Interest   52.4085943 -1.4943275
2179 op-snap---monthly-publication-august-2025.pdf   154 2025-08 Car Mercedes-Benz A Class White Driving without Due Care and Attention None Ringway, Whitefriars Ringway, Whitefriars Coventry Coventry NFA Not in Public Interest      
2255 op-snap---monthly-publication-august-2025.pdf   230 2025-08 Car Ford   Grey Driving without Due Care and Attention None A45 A45 Coventry Coventry NFA Not in Public Interest      
2290 op-snap---monthly-publication-august-2025.pdf   265 2025-08 Car BMW 530D Grey Driving without Due Care and Attention None Widdrington Road Widdrington Road Coventry Coventry NFA No Independent Evidence Available   52.4191764 -1.5105738
2317 op-snap---monthly-publication-august-2025.pdf   292 2025-08 Car Hyundai   Red Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry NFA Outside of 14 Days NIP   52.4274335 -1.5002381
2429 op-snap---monthly-publication-august-2025.pdf   404 2025-08 Car Ford C-Max Blue Driving without Due Care and Attention None Windmill Hill Windmill Hill Coventry Coventry NFA No VRM   52.4290141 -1.5708635
2464 op-snap---monthly-publication-august-2025.pdf   439 2025-08 Car Mercedes-Benz C220 Grey Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry NFA No Independent Evidence Available   52.4274335 -1.5002381
2614 op-snap---monthly-publication-august-2025.pdf   589 2025-08 Car Volkswagen Golf Silver Driving without Due Care and Attention None Ansty Island Coventry Ansty Island Coventry Coventry Coventry NFA No Independent Evidence Available      
2695 op-snap---monthly-publication-august-2025.pdf   670 2025-08 Car Mercedes-Benz C220 Black Driving without Due Care and Attention None A444 A444 Coventry Coventry NFA No Independent Evidence Available      
2728 op-snap---monthly-publication-august-2025.pdf   703 2025-08 Other   NP   Driving without Due Care and Attention None Squirrel Close Squirrel Close Coventry Coventry NFA No VRM   52.4384449 -1.4683592

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