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

318 rows where council_area = "Coventry", disposal = "NFA" and reporter_transport_mode = "Car" 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 29

reporter_transport_mode 1

  • Car · 318 ✖

disposal 1

  • NFA · 318 ✖

council_area 1

  • Coventry · 318 ✖
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
7995 op-snap---monthly-publication-february-2026.pdf   742 2026-02 Car Dacia Sandero White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hawthorne Lane Hawthorne Lane Coventry Coventry NFA No Independent Evidence Available      
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      
8087 op-snap---monthly-publication-february-2026.pdf   834 2026-02 Car Audi A3 Black Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry NFA     52.4070602 -1.4732469
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      
8249 op-snap---monthly-publication-february-2026.pdf   996 2026-02 Car BMW 120 Sport White Using a Mobile Phone Whilst Driving None Scimitar Way Scimitar Way Coventry Coventry NFA No Independent Evidence Available   52.3836203 -1.4862458
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      
10548 op-snap---monthly-publication-january-2026.pdf   9 2026-01 Car Mercedes-Benz A200 Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
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
10633 op-snap---monthly-publication-january-2026.pdf   94 2026-01 Car Audi Q2 Grey Contravening a Red Traffic Light None Sky Blue Way Sky Blue Way Coventry Coventry NFA No Independent Evidence Available   52.4085943 -1.4943275
10638 op-snap---monthly-publication-january-2026.pdf   99 2026-01 Car Peugeot 3008 Red Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
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
10976 op-snap---monthly-publication-january-2026.pdf   437 2026-01 Car Renault Megane Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Fenton Road Fenton Road Coventry Coventry NFA No Offence   52.4331816 -1.5630141
11036 op-snap---monthly-publication-january-2026.pdf   497 2026-01 Car Mitsubishi   Black Misc - Non Traffic Offences None Coventry Coventry Coventry Coventry NFA Misc Inc Crimes   52.400739 -1.5135474
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      
4043 op-snap---monthly-publication-december-2025.pdf   171 2025-12 Car Ford   White Using a Mobile Phone Whilst Driving None Leamington Road Leamington Road Coventry Coventry NFA No Independent Evidence Available   52.3921304 -1.5156601
4058 op-snap---monthly-publication-december-2025.pdf   186 2025-12 Car Toyota Yaris White Contravening a Red Traffic Light None Beake Avenue Beake Avenue Coventry Coventry NFA No Independent Evidence Available   52.4388246 -1.5229308
4181 op-snap---monthly-publication-december-2025.pdf   309 2025-12 Car Ford Transit Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None A46 Warwick Road Warwick Road Coventry Coventry NFA No VRM   52.401916 -1.5154953
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
4572 op-snap---monthly-publication-december-2025.pdf   700 2025-12 Car Audi Q3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Binley Rd Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
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
4737 op-snap---monthly-publication-december-2025.pdf   865 2025-12 Car Peugeot Allure Black Misc - Non Traffic Offences None Leicester Row Leicester Row Coventry Coventry NFA No Independent Evidence Available   52.414317 -1.5104573
4757 op-snap---monthly-publication-december-2025.pdf   885 2025-12 Car Audi TT Black Using a Mobile Phone Whilst Driving None Stonebridge Island Stonebridge Island Coventry Coventry NFA No Independent Evidence Available   52.4459998 -1.6949291
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
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
4904 op-snap---monthly-publication-december-2025.pdf   1032 2025-12 Car Kia Sportage White Contravening a Red Traffic Light None Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA No VRM   52.4214017 -1.4870278
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      
20525 op-snap---monthly-publication-november-2025.pdf   67 2025-11 Car BMW X2 Blue Contravening a Red Traffic Light None Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry NFA No Independent Evidence Available   52.3793117 -1.4625379
20653 op-snap---monthly-publication-november-2025.pdf   195 2025-11 Car Mercedes-Benz cla White Misc - Non Traffic Offences None London Road London Road Coventry Coventry NFA No Offence   52.3916468 -1.4925995
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
20721 op-snap---monthly-publication-november-2025.pdf   263 2025-11 Car Vauxhall Corsa White Contravening a Red Traffic Light No Insurance Foleshll Island Foleshll Island Coventry Coventry NFA No Independent Evidence Available      
21302 op-snap---monthly-publication-november-2025.pdf   844 2025-11 Car Honda crv Grey Contravening a Red Traffic Light None A45 A45 Coventry Coventry NFA No VRM      
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
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
21509 op-snap---monthly-publication-november-2025.pdf   1051 2025-11 Car Peugeot 2008 Grey Contravening a Red Traffic Light None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4214017 -1.4870278
21578 op-snap---monthly-publication-november-2025.pdf   1120 2025-11 Car Ford Fiesta Blue Contravening a Red Traffic Light None Puma Way Puma Way Coventry Coventry NFA No Independent Evidence Available   52.401984 -1.5046079
21609 op-snap---monthly-publication-november-2025.pdf   1151 2025-11 Car Ford Explorer Blue Contravening a Red Traffic Light None Moseley Av Moseley Avenue Coventry Coventry NFA No Offence   52.417344 -1.5264979
21628 op-snap---monthly-publication-november-2025.pdf   1170 2025-11 Car   NP   Misc - Non Traffic Offences None A46 A46 Coventry Coventry NFA No Independent Evidence Available      
21812 op-snap---monthly-publication-november-2025.pdf   1354 2025-11 Car Toyota Prius Silver Motor vehicle fail to accord precedence at a pelican crossing None Eaton Road Eaton Road Coventry Coventry NFA No Offence   52.4024496 -1.515209
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
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
22172 op-snap---monthly-publication-october-2025.pdf   122 2025-10 Car Mercedes-Benz Sprinter White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Widdrington Road Widdrington Road Coventry Coventry NFA No Offence   52.4191764 -1.5105738
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
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
22410 op-snap---monthly-publication-october-2025.pdf   360 2025-10 Car BMW M140 Black Misc - Non Traffic Offences None Foleshill Road Foleshill Road Coventry Coventry NFA No Offence   52.4274335 -1.5002381
22424 op-snap---monthly-publication-october-2025.pdf   374 2025-10 Car Mercedes-Benz EQA Black Contravening a Red Traffic Light None M6 Jn2 M6 Jn2 Coventry Coventry NFA Outside of 14 Days NIP      
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
22516 op-snap---monthly-publication-october-2025.pdf   466 2025-10 Car Toyota   White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Far Gosford Street Far Gosford Street Coventry Coventry NFA No Independent Evidence Available   52.4071231 -1.4985178
22554 op-snap---monthly-publication-october-2025.pdf   504 2025-10 Car BMW 5 series White VRM fails to conform to Regulations None Holyhead Road Holyhead Road Coventry Coventry NFA No VRM   52.418488 -1.5472387
22578 op-snap---monthly-publication-october-2025.pdf   528 2025-10 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Firefly Road Firefly Road Coventry Coventry NFA No Offence   52.3786307 -1.4839701
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
22724 op-snap---monthly-publication-october-2025.pdf   674 2025-10 Car Nissan X-Trail Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Gulson Road Gulson Road Coventry Coventry NFA No VRM   52.4076795 -1.4911676
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
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      
22856 op-snap---monthly-publication-october-2025.pdf   806 2025-10 Car Vauxhall Mokka Red Contravening a Red Traffic Light None Daventry Road Daventry Road Coventry Coventry NFA No VRM   52.3930931 -1.4976428
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
23003 op-snap---monthly-publication-october-2025.pdf   953 2025-10 Car Citroen E-C4 Blue Using a Mobile Phone Whilst Driving None Skipworth Road Skipworth Road Coventry Coventry NFA No Independent Evidence Available   52.3980123 -1.438048
23008 op-snap---monthly-publication-october-2025.pdf   958 2025-10 Car Volkswagen Golf Blue Contravening a Red Traffic Light None Kenilworth Road Kenilworth Road Coventry Coventry NFA No Independent Evidence Available   52.3833298 -1.5379214
23039 op-snap---monthly-publication-october-2025.pdf   989 2025-10 Car Nissan Qashqai White Contravening a Red Traffic Light None Ansty Road Ansty Road Coventry Coventry NFA No Independent Evidence Available   52.4205675 -1.4520187
23063 op-snap---monthly-publication-october-2025.pdf   1013 2025-10 Car Audi A3 White Using a Mobile Phone Whilst Driving None Hinckley Road Hinckley Road Coventry Coventry NFA No Independent Evidence Available   52.435502 -1.4327166
23069 op-snap---monthly-publication-october-2025.pdf   1019 2025-10 Car Mercedes-Benz   Blue Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None M6 M6 Coventry Coventry NFA No Independent Evidence Available      
23092 op-snap---monthly-publication-october-2025.pdf   1042 2025-10 Car Audi A3 Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None St Martins Road Street Martins Road Coventry Coventry NFA No Independent Evidence Available      
23663 op-snap---monthly-publication-october-2025.pdf   1613 2025-10 Car Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA Misc Inc Crimes   52.4221152 -1.4959475
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
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
24291 op-snap---monthly-publication-september-2025.pdf   510 2025-09 Car Land Rover Freelander Black Using a Mobile Phone Whilst Driving None Brookside Avenue Brookside Avenue Coventry Coventry NFA No Independent Evidence Available   52.411064 -1.5578725
24322 op-snap---monthly-publication-september-2025.pdf   541 2025-09 Car Toyota Estima Silver Misc - Non Traffic Offences None A45 Coventry Road, towards B'ham Coventry Road, towards B'ham Coventry Coventry NFA No Independent Evidence Available      
24446 op-snap---monthly-publication-september-2025.pdf   665 2025-09 Car Nissan X-Trail Silver Contravening a Red Traffic Light None Fletchamstead Highway Fletchamstead Highway Coventry Coventry NFA No Independent Evidence Available   52.396476 -1.5561348
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
24523 op-snap---monthly-publication-september-2025.pdf   742 2025-09 Car BMW 330 Grey Motor vehicle fail to comply with endorsable sect ion 36 traffic sign -otheNr othnaen manned or automatic Setqounipeym Setnatnton Road Setqounipeym Setnatnton Road Coventry Coventry NFA No Independent Evidence Available      
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

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