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

900 rows where council_area = "Coventry" 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 >30

offence >30

month 14

reporter_transport_mode 1

  • Car · 900 ✖

council_area 1

  • Coventry · 900 ✖
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
7292 op-snap---monthly-publication-february-2026.pdf   39 2026-02 Car Ford Transit White Stop a vehicle on pedestrian crossing None Knowle High Street Knowle High Street Coventry Coventry Education N/A      
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
7331 op-snap---monthly-publication-february-2026.pdf   78 2026-02 Car Land Rover Discovery White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Burnaby Road Burnaby Road Coventry Coventry Warning Letter N/A   52.4352 -1.5194238
7393 op-snap---monthly-publication-february-2026.pdf   140 2026-02 Car Toyota Auris Grey Driving without Due Care and Attention No Insurance Crampers Field Crampers Field Coventry Coventry Court N/A   52.4176927 -1.5257854
7435 op-snap---monthly-publication-february-2026.pdf   182 2026-02 Car Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
7497 op-snap---monthly-publication-february-2026.pdf   244 2026-02 Car BMW X1 Blue Driving without Due Care and Attention None Torcross Avenue Torcross Avenue Coventry Coventry Education N/A   52.4218194 -1.46546
7535 op-snap---monthly-publication-february-2026.pdf   282 2026-02 Car Peugeot 206 Silver Driving without Due Care and Attention None Winding House Lane Winding House Lane Coventry Coventry Education N/A   52.4490457 -1.5001195
7585 op-snap---monthly-publication-february-2026.pdf   332 2026-02 Car Land Rover Land Rover Blue Contravening a Red Traffic Light None Tile Hill Lane Tile Hill Lane Coventry Coventry Education N/A   52.4041117 -1.5595662
7603 op-snap---monthly-publication-february-2026.pdf   350 2026-02 Car Hyundai 130 Blue Driving without Due Care and Attention None A46 Coventry Coventry Coventry Coventry Education N/A   52.400739 -1.5135474
7625 op-snap---monthly-publication-february-2026.pdf   372 2026-02 Car Mercedes-Benz CLA 220 Red Driving without Due Care and Attention None Coventry A45 W Coventry A45 W Coventry Coventry Education N/A   52.4314215 -1.5948907
7634 op-snap---monthly-publication-february-2026.pdf   381 2026-02 Car Ford Focus Blue Contravening a Red Traffic Light None Walsgrave Road Walsgrave Road Coventry Coventry Education N/A   52.4096725 -1.487901
7637 op-snap---monthly-publication-february-2026.pdf   384 2026-02 Car Mercedes-Benz C200 Blue Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Walsgrave Road Walsgrave Road Coventry Coventry Fixed Penalty N/A   52.4096725 -1.487901
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
7811 op-snap---monthly-publication-february-2026.pdf   558 2026-02 Car Vauxhall Corsa White Contravening a Red Traffic Light None A444/Coventry Rd roundabout A444/Coventry Road roundabout Coventry Coventry Warning Letter N/A   52.4471432 -1.4975901
7830 op-snap---monthly-publication-february-2026.pdf   577 2026-02 Car Seat Leon Grey Contravening a Red Traffic Light None Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry Education N/A   52.3793117 -1.4625379
7835 op-snap---monthly-publication-february-2026.pdf   582 2026-02 Car Mercedes-Benz EQB Black Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Education N/A   52.4318623 -1.4804069
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
7882 op-snap---monthly-publication-february-2026.pdf   629 2026-02 Car BMW 318D Black Driving without Due Care and Attention None London Road London Road Coventry Coventry Education N/A   52.3916468 -1.4925995
7976 op-snap---monthly-publication-february-2026.pdf   723 2026-02 Car Toyota Prius Black Using a Mobile Phone Whilst Driving Driving without Due Care and Attention A45 Coventry Coventry Coventry Coventry Fixed Penalty N/A   52.400739 -1.5135474
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      
8030 op-snap---monthly-publication-february-2026.pdf   777 2026-02 Car Ford Kuga White Misc - Non Traffic Offences None Sir henry Parkes Road Sir henry Parkes Road Coventry Coventry RTC - Actioned N/A   52.3900568 -1.5550766
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      
8083 op-snap---monthly-publication-february-2026.pdf   830 2026-02 Car Ford Focus Red Driving without Due Care and Attention None Lamb Street Lamb Street Coventry Coventry Education N/A   52.4110367 -1.5143617
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
8167 op-snap---monthly-publication-february-2026.pdf   914 2026-02 Car Ford Focus Black Driving without Due Care and Attention None Toll Bar End Toll Bar End Coventry Coventry Other Action Taken N/A   52.377406 -1.4651313
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
8294 op-snap---monthly-publication-february-2026.pdf   1041 2026-02 Car Audi A5 Black Driving without Due Care and Attention No Insurance Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry Court N/A   52.3793117 -1.4625379
8339 op-snap---monthly-publication-february-2026.pdf   1086 2026-02 Car Seat Leon Blue Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Education N/A   52.4074716 -1.5620671
8410 op-snap---monthly-publication-february-2026.pdf   1157 2026-02 Car Seat Leon White Driving without Due Care and Attention None Rowleys Green Roundabout at Jummy Hill Way Rowleys Green Roundabout at Jummy Hill Way Coventry Coventry RTC - Actioned N/A   52.4486967 -1.4991069
8437 op-snap---monthly-publication-february-2026.pdf   1184 2026-02 Car Audi A7 Silver Using a Mobile Phone Whilst Driving None Oliver Way Oliver Way Coventry Coventry Fixed Penalty N/A      
8463 op-snap---monthly-publication-february-2026.pdf   1210 2026-02 Car Vauxhall Corsa Grey Contravening a Red Traffic Light None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
8492 op-snap---monthly-publication-february-2026.pdf   1239 2026-02 Car Audi A3 grey Using a Mobile Phone Whilst Driving None Station Road, Balsall Common Station Road, Balsall Common Coventry Coventry Fixed Penalty N/A      
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
8532 op-snap---monthly-publication-february-2026.pdf   1279 2026-02 Car Polestar   Black Driving without Due Care and Attention None London toward Twds Coventry at Whitley Interchange London toward Twds Coventry at Whitley Interchange Coventry Coventry Fixed Penalty N/A      
8540 op-snap---monthly-publication-february-2026.pdf   1287 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None Longfellow Road Longfellow Road Coventry Coventry Fixed Penalty N/A   52.4102345 -1.4609881
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
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
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
8554 op-snap---monthly-publication-february-2026.pdf   1301 2026-02 Car Mercedes-Benz E220 Silver Driving without Due Care and Attention None London Road to A444 Whitley Interchange London Road to A444 Whitley Interchange Coventry Coventry Fixed Penalty N/A      
8594 op-snap---monthly-publication-february-2026.pdf   1341 2026-02 Car Ford Transit White Driving without Due Care and Attention None Ludgate Road Ludgate Road Coventry Coventry Education N/A      
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      
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
8739 op-snap---monthly-publication-february-2026.pdf   1486 2026-02 Car Seat Ateca Silver Driving without Due Care and Attention None A45 A45 Coventry Coventry Court N/A      
8806 op-snap---monthly-publication-february-2026.pdf   1553 2026-02 Car Skoda Kodiaq Black Misc - Non Traffic Offences None Freehold Street Freehold Street Coventry Coventry RTC - Actioned N/A   52.4164191 -1.4928534
8808 op-snap---monthly-publication-february-2026.pdf   1555 2026-02 Car Jeep Avenger Beige Driving without Due Care and Attention None Tollbar End Roundabout Tollbar End Roundabout Coventry Coventry Court N/A      
8838 op-snap---monthly-publication-february-2026.pdf   1585 2026-02 Car Toyota aygo White Cause vehicle to be left in a dangerous position None De Montfort road De Montfort road Coventry Coventry Warning Letter N/A      
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
10551 op-snap---monthly-publication-january-2026.pdf   12 2026-01 Car Lexus IS 250 Grey Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
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
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      
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
10743 op-snap---monthly-publication-january-2026.pdf   204 2026-01 Car Ford Ranger Red Contravening a Red Traffic Light None A45 Coventry - Jct of Tile Hill Lane Coventry - Junction of Tile Hill Lane Coventry Coventry Education N/A      
10791 op-snap---monthly-publication-january-2026.pdf   252 2026-01 Car Mercedes-Benz C350 Black Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
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
10802 op-snap---monthly-publication-january-2026.pdf   263 2026-01 Car Daf   Orange Driving without Due Care and Attention None Beake Avenue/ Rupert Road Beake Avenue/ Rupert Road Coventry Coventry Fixed Penalty N/A   52.4242259 -1.5233419
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
10852 op-snap---monthly-publication-january-2026.pdf   313 2026-01 Car Audi A3 Black Contravening a Red Traffic Light None Walsgrave Road Jct with Sky Blue Way Walsgrave Road Junction with Sky Blue Way Coventry Coventry Education N/A   52.410402 -1.4847441
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
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      
10940 op-snap---monthly-publication-january-2026.pdf   401 2026-01 Car Citroen C1 Black Contravening a Red Traffic Light None Foleshill Road Foleshill Road Coventry Coventry Education N/A   52.4274335 -1.5002381
10943 op-snap---monthly-publication-january-2026.pdf   404 2026-01 Car Nissan Juke Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holbrooks Lane Holbrooks Lane Coventry Coventry Warning Letter N/A   52.4423504 -1.5068606
10959 op-snap---monthly-publication-january-2026.pdf   420 2026-01 Car BMW 2 series Purple VRM fails to conform to Regulations None Henry Wychard Drive Henry Wychard Drive Coventry Coventry Warning Letter N/A   52.4468299 -1.5440051
10970 op-snap---monthly-publication-january-2026.pdf   431 2026-01 Car Suzuki Vitara Black Contravening a Red Traffic Light None Winsford Avenue Winsford Avenue Coventry Coventry Education N/A   52.4151819 -1.5629773
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
10978 op-snap---monthly-publication-january-2026.pdf   439 2026-01 Car   Subaru Impreza   Drive a vehicle other than on the carriageway of a motorway None M6 NB J3a M6 Northbound J3a Coventry Coventry Education N/A   52.6760749 -2.0862582
10983 op-snap---monthly-publication-january-2026.pdf   444 2026-01 Car Ford Transit White Contravening a Red Traffic Light none London Road London Road Coventry Coventry Fixed Penalty N/A   52.3916468 -1.4925995
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
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
11131 op-snap---monthly-publication-january-2026.pdf   592 2026-01 Car Volkswagen Transporter Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moseley Avenue Moseley Avenue Coventry Coventry Fixed Penalty N/A   52.417344 -1.5264979
11151 op-snap---monthly-publication-january-2026.pdf   612 2026-01 Car Fiat 500.. White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Tile Hill Road Tile Hill Road Coventry Coventry Fixed Penalty N/A      
11211 op-snap---monthly-publication-january-2026.pdf   672 2026-01 Car Land Rover Discovery Red Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
11264 op-snap---monthly-publication-january-2026.pdf   725 2026-01 Car Tesla model 3 White Keeping a vehicle with registration marks obscured None Four Pounds Avenue Four Pounds Avenue Coventry Coventry Fixed Penalty N/A   52.413228 -1.5323652
11312 op-snap---monthly-publication-january-2026.pdf   773 2026-01 Car Toyota Prius White Contravening a Red Traffic Light None Walsgrave Road Walsgrave Road Coventry Coventry Warning Letter N/A   52.4096725 -1.487901
11328 op-snap---monthly-publication-january-2026.pdf   789 2026-01 Car Seat Leon Blue Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
11377 op-snap---monthly-publication-january-2026.pdf   838 2026-01 Car Volvo XC90 Silver Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
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
11501 op-snap---monthly-publication-january-2026.pdf   962 2026-01 Car Honda CRV Grey Driving without Due Care and Attention None Bonley Rd, Jimmy Hill Way Roundabout Bonley Road, Jimmy Hill Way Roundabout Coventry Coventry Fixed Penalty N/A      
11517 op-snap---monthly-publication-january-2026.pdf   978 2026-01 Car Vauxhall Insignia White Driving without Due Care and Attention None Moseley Avenue Moseley Avenue Coventry Coventry Education N/A   52.417344 -1.5264979
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
11533 op-snap---monthly-publication-january-2026.pdf   994 2026-01 Car Iveco Daily luton van White Driving without Due Care and Attention None A4053 Ringway Queens Ringway Queens Coventry Coventry Fixed Penalty N/A   52.4039782 -1.5161639
11539 op-snap---monthly-publication-january-2026.pdf   1000 2026-01 Car Kia Ceed Red Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
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
11574 op-snap---monthly-publication-january-2026.pdf   1035 2026-01 Car Hyundai Tucson Grey Using a Mobile Phone Whilst Driving None Blackberry Lane Blackberry Lane Coventry Coventry Fixed Penalty N/A   52.4254016 -1.4665041
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
11588 op-snap---monthly-publication-january-2026.pdf   1049 2026-01 Car Land Rover Defender Black Driving without Due Care and Attention None Stivichall Highway Stivichall Highway Coventry Coventry Education N/A   52.3774003 -1.493293
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      
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
11647 op-snap---monthly-publication-january-2026.pdf   1108 2026-01 Car BMW 430.. Black Driving without Due Care and Attention None Gulson Road Gulson Road Coventry Coventry Court N/A   52.4076795 -1.4911676
11651 op-snap---monthly-publication-january-2026.pdf   1112 2026-01 Car Ford Fiesta Black Driver not in position to have Proper Control None Winding House Lane Winding House Lane Coventry Coventry Warning Letter N/A   52.4490457 -1.5001195
11662 op-snap---monthly-publication-january-2026.pdf   1123 2026-01 Car Peugeot 3008 Silver Contravening a Red Traffic Light None Firefly Road Firefly Road Coventry Coventry Education N/A   52.3786307 -1.4839701
11680 op-snap---monthly-publication-january-2026.pdf   1141 2026-01 Car BMW M135i Black Driving without Due Care and Attention No Insurance Cox Street Cox Street Coventry Coventry Court N/A   52.4092228 -1.5034119
11765 op-snap---monthly-publication-january-2026.pdf   1226 2026-01 Car BMW 320D Grey Driving without Due Care and Attention None Styvechale Croft Styvechale Croft Coventry Coventry Fixed Penalty N/A      
11795 op-snap---monthly-publication-january-2026.pdf   1256 2026-01 Car Peugeot 3008 Grey Contravening a Red Traffic Light None Lynchgate Road Lynchgate Road Coventry Coventry Fixed Penalty N/A   52.3894664 -1.5558269
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      

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