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

115 rows where council_area = "Coventry" and month = "2026-01" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 5

month 1

  • 2026-01 · 115 ✖

council_area 1

  • Coventry · 115 ✖
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
10543 op-snap---monthly-publication-january-2026.pdf   4 2026-01 Pedal Bike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
10544 op-snap---monthly-publication-january-2026.pdf   5 2026-01 Pedal Bike Toyota Aygo Red Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
10547 op-snap---monthly-publication-january-2026.pdf   8 2026-01 Pedal Bike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving No Insurance Stoney Stanton Road Stoney Stanton Road Coventry Coventry Duplicate Submission Duplicate Submission   52.4221152 -1.4959475
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
10561 op-snap---monthly-publication-january-2026.pdf   22 2026-01 Pedal Bike Iveco Daily White Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
10562 op-snap---monthly-publication-january-2026.pdf   23 2026-01 Pedal Bike Mercedes-Benz CITAN White Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
10564 op-snap---monthly-publication-january-2026.pdf   25 2026-01 Pedal Bike Ford Transit Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
10565 op-snap---monthly-publication-january-2026.pdf   26 2026-01 Pedal Bike BMW M3 Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
10567 op-snap---monthly-publication-january-2026.pdf   28 2026-01 Pedal Bike Vauxhall Astra Grey Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
10568 op-snap---monthly-publication-january-2026.pdf   29 2026-01 Pedal Bike BMW 120d Black Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
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
10661 op-snap---monthly-publication-january-2026.pdf   122 2026-01 Pedal Bike Volkswagen troc White Cause vehicle to be left in a dangerous position None far gosford strett Far Gosford Strett Coventry Coventry Warning Letter N/A      
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      
10757 op-snap---monthly-publication-january-2026.pdf   218 2026-01 Pedestrian Ford Fiesta Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fenton Road Fenton Road Coventry Coventry NFA No Independent Evidence Available   52.4331816 -1.5630141
10764 op-snap---monthly-publication-january-2026.pdf   225 2026-01 Pedestrian Citroen Picasso Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fenton Rd Fenton Road Coventry Coventry NFA No Independent Evidence Available   52.4331816 -1.5630141
10765 op-snap---monthly-publication-january-2026.pdf   226 2026-01 Pedestrian Citroen Picasso Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fenton Rd Fenton Road Coventry Coventry NFA No Independent Evidence Available   52.4331816 -1.5630141
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
10826 op-snap---monthly-publication-january-2026.pdf   287 2026-01 Pedestrian Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coombe Park Road Coombe Park Road Coventry Coventry Fixed Penalty N/A   52.4065551 -1.4426433
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
10878 op-snap---monthly-publication-january-2026.pdf   339 2026-01 Pedestrian Ford Focus Grey Use a motor vehicle / trailer in a condition likely to cause danger of injury None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
10884 op-snap---monthly-publication-january-2026.pdf   345 2026-01 Pedal Bike Volkswagen Crafter White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10906 op-snap---monthly-publication-january-2026.pdf   367 2026-01 Pedestrian Audi A3 Black Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
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      
10914 op-snap---monthly-publication-january-2026.pdf   375 2026-01 Pedal Bike Audi A7 Blue Stop a vehicle within pelican pedestrian crossing limits None Earlsdon St Cov Earlsdon Street Cov Coventry Coventry Education N/A   52.3988977 -1.5323674
10916 op-snap---monthly-publication-january-2026.pdf   377 2026-01 Pedal Bike Hyundai Kona Blue Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
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
10956 op-snap---monthly-publication-january-2026.pdf   417 2026-01 Pedestrian Ford Transit white Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lentons Lane Lentons Lane Coventry Coventry Fixed Penalty N/A   52.4503238 -1.4546397
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
10996 op-snap---monthly-publication-january-2026.pdf   457 2026-01 Pedestrian Ford Kuga Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Valley Road Valley Road Coventry Coventry Fixed Penalty N/A   52.4232784 -1.4819114
11000 op-snap---monthly-publication-january-2026.pdf   461 2026-01 Pedal Bike Volkswagen   Silver Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
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
11081 op-snap---monthly-publication-january-2026.pdf   542 2026-01 Pedal Bike Honda C-RV Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coat of Arms Bridge Road Coat of Arms Bridge Road Coventry Coventry Fixed Penalty N/A   52.3887077 -1.5308677
11093 op-snap---monthly-publication-january-2026.pdf   554 2026-01 Pedestrian Seat alhambra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Green Lane North Green Lane North Coventry Coventry Warning Letter N/A      
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
11119 op-snap---monthly-publication-january-2026.pdf   580 2026-01 Pedal Bike Honda Civic Blue Contravening a Red Traffic Light None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry NFA No Independent Evidence Available   52.4352 -1.5194238
11120 op-snap---monthly-publication-january-2026.pdf   581 2026-01 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry Education N/A   52.4352 -1.5194238
11121 op-snap---monthly-publication-january-2026.pdf   582 2026-01 Pedal Bike BMW 320D Black Contravening a Red Traffic Light None A45 slip road Allesley Green to Birmingham A45 slip road Allesley Green to Birmingham Coventry Coventry Warning Letter N/A      
11126 op-snap---monthly-publication-january-2026.pdf   587 2026-01 Pedestrian Nissan Qashqai Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Halford Lane Halford Lane Coventry Coventry Fixed Penalty N/A   52.4398231 -1.526811
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      
11209 op-snap---monthly-publication-january-2026.pdf   670 2026-01 Pedal Bike Ford Focus Silver Using a Mobile Phone Whilst Driving None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
11210 op-snap---monthly-publication-january-2026.pdf   671 2026-01 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Warning Letter N/A   52.4061531 -1.505845
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
11212 op-snap---monthly-publication-january-2026.pdf   673 2026-01 Pedal Bike Volkswagen Touran Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
11215 op-snap---monthly-publication-january-2026.pdf   676 2026-01 Pedal Bike BMW 320D White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11216 op-snap---monthly-publication-january-2026.pdf   677 2026-01 Pedal Bike Renault Megane Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
11217 op-snap---monthly-publication-january-2026.pdf   678 2026-01 Pedal Bike BMW 120 SPORT Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11219 op-snap---monthly-publication-january-2026.pdf   680 2026-01 Other Volkswagen Crafter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lentons Lane Lentons Lane Coventry Coventry Warning Letter N/A   52.4503238 -1.4546397
11253 op-snap---monthly-publication-january-2026.pdf   714 2026-01 Pedal Bike Land Rover Sport Black Stop a vehicle on pedestrian crossing None Earlsdon Street Earlsdon Street Coventry Coventry Education N/A   52.3988977 -1.5323674
11254 op-snap---monthly-publication-january-2026.pdf   715 2026-01 Pedestrian Renault Megane Silver Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA Misc Inc Crimes   52.4331816 -1.5630141
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
11273 op-snap---monthly-publication-january-2026.pdf   734 2026-01 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Warning Letter N/A   52.402753 -1.5385829
11279 op-snap---monthly-publication-january-2026.pdf   740 2026-01 Pedal Bike Mitsubishi Outlander Silver Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11298 op-snap---monthly-publication-january-2026.pdf   759 2026-01 Pedestrian Renault Megane Silver Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA No Offence   52.4331816 -1.5630141
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
11351 op-snap---monthly-publication-january-2026.pdf   812 2026-01 Pedal Bike Citroen C3 Black Driving without Due Care and Attention None Hollyfast Lane Hollyfast Lane Coventry Coventry Warning Letter N/A   52.4517652 -1.5578662
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
11378 op-snap---monthly-publication-january-2026.pdf   839 2026-01 Pedestrian Land Rover Discovery Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11380 op-snap---monthly-publication-january-2026.pdf   841 2026-01 Pedestrian Audi Q5 Grey Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11427 op-snap---monthly-publication-january-2026.pdf   888 2026-01 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
11451 op-snap---monthly-publication-january-2026.pdf   912 2026-01 Pedal Bike Audi A3 Grey Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11472 op-snap---monthly-publication-january-2026.pdf   933 2026-01 Pedal Bike Ford Fiesta Red Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Fixed Penalty N/A   52.3988977 -1.5323674
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      
11511 op-snap---monthly-publication-january-2026.pdf   972 2026-01 Pedal Bike Citroen C3.. Silver Stop a vehicle within pelican pedestrian crossing limits No Insurance Earlsdon Avenue South Earlsdon Avenue South Coventry Coventry Education N/A   52.3960991 -1.5255671
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
11553 op-snap---monthly-publication-january-2026.pdf   1014 2026-01 Pedal Bike Jaguar F Pace Black Driving without Due Care and Attention No Insurance Stoney Stanton road Stoney Stanton road Coventry Coventry Court N/A   52.4221152 -1.4959475
11555 op-snap---monthly-publication-january-2026.pdf   1016 2026-01 Pedal Bike Toyota CH-R Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
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
11558 op-snap---monthly-publication-january-2026.pdf   1019 2026-01 Pedal Bike Vauxhall Corsa White Using a Mobile Phone Whilst Driving None A45, Coventry A45, Coventry Coventry Coventry NFA No Independent Evidence Available   52.3791309 -1.4740067
11565 op-snap---monthly-publication-january-2026.pdf   1026 2026-01 Pedal Bike Hyundai Tucson Blue Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
11569 op-snap---monthly-publication-january-2026.pdf   1030 2026-01 Pedal Bike BMW 1 series White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11570 op-snap---monthly-publication-january-2026.pdf   1031 2026-01 Pedal Bike Mercedes-Benz C220 Silver Stop a vehicle within pelican pedestrian crossing limits None Daventry Road Daventry Road Coventry Coventry Education N/A   52.3930931 -1.4976428
11571 op-snap---monthly-publication-january-2026.pdf   1032 2026-01 Pedal Bike Mini Cooper Orange Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
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
11626 op-snap---monthly-publication-january-2026.pdf   1087 2026-01 Pedestrian Peugeot 208 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Arden Street Arden Street Coventry Coventry Warning Letter N/A   52.3987861 -1.5354013

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