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

93 rows where month = "2025-09" and offence = "Misc - Non Traffic Offences" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 7

offence 1

  • Misc - Non Traffic Offences · 93 ✖

month 1

  • 2025-09 · 93 ✖
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
23874 op-snap---monthly-publication-september-2025.pdf   93 2025-09 Pedal Bike Nissan Ariya Green Misc - Non Traffic Offences None Aldersly Leisure Village Aldersly Leisure Village Wolverhampton Wolverhampton NFA No Offence      
23875 op-snap---monthly-publication-september-2025.pdf   94 2025-09 Car Ford Kuga Black Misc - Non Traffic Offences None Tachbrook Rd, Leamington Spa Tachbrook Road, Leamington Spa Out of Force Area Out of Force Area NFA Out of Force      
23879 op-snap---monthly-publication-september-2025.pdf   98 2025-09 Car Renault Scenic Blue Misc - Non Traffic Offences None Hertford Way . Balkwill Crescent Hertford Way . Balkwill Crescent Solihull Solihull NFA No Offence      
23896 op-snap---monthly-publication-september-2025.pdf   115 2025-09 Car       Misc - Non Traffic Offences None Cape Hill Cape Hill Birmingham Birmingham RTC - Actioned N/A      
23928 op-snap---monthly-publication-september-2025.pdf   147 2025-09 Pedestrian Audi A4 Black Misc - Non Traffic Offences None Petersfield Road Petersfield Road Birmingham Birmingham NFA No Offence   52.4307 -1.8494663
23929 op-snap---monthly-publication-september-2025.pdf   148 2025-09 Pedestrian Ford Focus Grey Misc - Non Traffic Offences None Petersfeild Road Petersfeild Road Birmingham Birmingham NFA No Offence      
23930 op-snap---monthly-publication-september-2025.pdf   149 2025-09 Pedestrian Toyota Prius Silver Misc - Non Traffic Offences None Peterfield Road Peterfield Road Birmingham Birmingham NFA No Offence      
24022 op-snap---monthly-publication-september-2025.pdf   241 2025-09 Pedestrian Hyundai Getz Blue Misc - Non Traffic Offences None Butt Lane Butt Lane Coventry Coventry Warning Letter N/A   52.4303178 -1.5668089
24059 op-snap---monthly-publication-september-2025.pdf   278 2025-09 Other BMW 1 series Blue Misc - Non Traffic Offences None Doe Bank Lane Doe Bank Lane Walsall Walsall NFA No Independent Evidence Available   52.5679007 -1.9058642
24091 op-snap---monthly-publication-september-2025.pdf   310 2025-09 Other Skoda Octavia Grey Misc - Non Traffic Offences None Metchley Lane Metchley Lane Birmingham Birmingham NFA Not in Public Interest   52.4552055 -1.9461279
24092 op-snap---monthly-publication-september-2025.pdf   311 2025-09 Other Land Rover Discovery Black Misc - Non Traffic Offences None Metchley Lane Metchley Lane Birmingham Birmingham NFA Not in Public Interest   52.4552055 -1.9461279
24124 op-snap---monthly-publication-september-2025.pdf   343 2025-09 Car   UNKNOWN   Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No VRM   52.4543565 -1.9114004
24128 op-snap---monthly-publication-september-2025.pdf   347 2025-09 Van BMW X3 Black Misc - Non Traffic Offences None M1 Southbound M1 Southbound Out of Force Area Out of Force Area NFA Out of Force      
24220 op-snap---monthly-publication-september-2025.pdf   439 2025-09 Pedestrian BMW 7 series Black Misc - Non Traffic Offences None Green Lane, Hob Moor Lane Green Lane, Hob Moor Lane Birmingham Birmingham RTC - Actioned N/A      
24249 op-snap---monthly-publication-september-2025.pdf   468 2025-09 Car Vauxhall Astra Blue Misc - Non Traffic Offences None Kitts Green Road Kitts Green Road Birmingham Birmingham NFA No Offence   52.4815372 -1.7766518
24250 op-snap---monthly-publication-september-2025.pdf   469 2025-09 Car BMW 320d Black Misc - Non Traffic Offences None Vicarage Road Vicarage Road Birmingham Birmingham NFA No Offence   52.470423 -1.9304786
24254 op-snap---monthly-publication-september-2025.pdf   473 2025-09 Other   Cycle   Misc - Non Traffic Offences None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
24264 op-snap---monthly-publication-september-2025.pdf   483 2025-09 Lorry Ford Puma White Misc - Non Traffic Offences None Coventry Road (A45) Coventry Road (A45) Birmingham Birmingham Other Action Taken N/A   52.4516899 -1.7753139
24298 op-snap---monthly-publication-september-2025.pdf   517 2025-09 Other Mercedes-Benz Vito Black Misc - Non Traffic Offences None Russell Road by Cannon Hill Park Russell Road by Cannon Hill Park Birmingham Birmingham NFA No Offence      
24302 op-snap---monthly-publication-september-2025.pdf   521 2025-09 Car Audi SQ5. Grey Misc - Non Traffic Offences None M6 North near to Welcome Brek Services M6 North near to Welcome Brek Services Out of Force Area Out of Force Area NFA Out of Force      
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      
24359 op-snap---monthly-publication-september-2025.pdf   578 2025-09 Car Volkswagen Caddy White Misc - Non Traffic Offences None M6 North M6 North Birmingham Birmingham NFA Not in Public Interest   52.5143137 -1.7683873
24372 op-snap---monthly-publication-september-2025.pdf   591 2025-09 Car BMW 3 series Grey Misc - Non Traffic Offences None A4311 in Swindon A4311 in Swindon Out of Force Area Out of Force Area NFA Out of Force      
24384 op-snap---monthly-publication-september-2025.pdf   603 2025-09 Car Toyota Hilux Black Misc - Non Traffic Offences None Rookery Road Rookery Road Birmingham Birmingham NFA No VRM   52.5076603 -1.9405515
24390 op-snap---monthly-publication-september-2025.pdf   609 2025-09 Car Land Rover Discovery Blue Misc - Non Traffic Offences None Vicarage Road Vicarage Road Birmingham Birmingham NFA No Offence   52.470423 -1.9304786
24401 op-snap---monthly-publication-september-2025.pdf   620 2025-09 Other Mercedes-Benz Sprinter Grey Misc - Non Traffic Offences None High Street, Brockmoor High Street, Brockmoor Dudley Dudley NFA No Offence   52.501153 -2.1208987
24480 op-snap---monthly-publication-september-2025.pdf   699 2025-09 Car Iveco S-Way White Misc - Non Traffic Offences None M42 Motorway, northbound M42 Motorway, northbound Birmingham Birmingham Fixed Penalty N/A      
24484 op-snap---monthly-publication-september-2025.pdf   703 2025-09 Car Volvo XC90 Blue Misc - Non Traffic Offences None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence   52.5113867 -1.8337258
24556 op-snap---monthly-publication-september-2025.pdf   775 2025-09 Car Volkswagen Golf Grey Misc - Non Traffic Offences None Formans Road Formans Road Birmingham Birmingham Other Action Taken N/A   52.4482024 -1.8507493
24620 op-snap---monthly-publication-september-2025.pdf   839 2025-09 other Volkswagen golf Grey Misc - Non Traffic Offences None Waterfront car park Waterfront car park Dudley Dudley NFA No Independent Evidence Available      
24621 op-snap---monthly-publication-september-2025.pdf   840 2025-09 Car Mazda 3.. Silver Misc - Non Traffic Offences None Newton Road Newton Road Sandwell Sandwell Warning Letter N/A   52.5428224 -1.9569444
24623 op-snap---monthly-publication-september-2025.pdf   842 2025-09 Other Volkswagen Caddy van White Misc - Non Traffic Offences None Waterfront car park Waterfront car park Dudley Dudley NFA No Independent Evidence Available      
24655 op-snap---monthly-publication-september-2025.pdf   874 2025-09 Pedestrian   M/C Red Misc - Non Traffic Offences None Kingsacre Drive Kingsacre Drive Out of Force Area Out of Force Area NFA No VRM      
24669 op-snap---monthly-publication-september-2025.pdf   888 2025-09 Other BMW NK Blue Misc - Non Traffic Offences None Buryfield Road Buryfield Road Solihull Solihull NFA No VRM   52.4244296 -1.7823135
24677 op-snap---monthly-publication-september-2025.pdf   896 2025-09 Car Jaguar e Pace Grey Misc - Non Traffic Offences None Multi-story car park of Utilia Arena Multi-story car park of Utilia Arena Birmingham Birmingham NFA No Offence      
24820 op-snap---monthly-publication-september-2025.pdf   1039 2025-09 Car Peugeot 2008 Black Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Chester Road / College Road Chester Road / College Road Birmingham Birmingham NFA No VRM   52.5460025 -1.8572602
24821 op-snap---monthly-publication-september-2025.pdf   1040 2025-09 Car Nissan Qashqai Red Misc - Non Traffic Offences No Insurance Wolverhampton Road West Wolverhampton Road West Walsall Walsall RTC - Actioned N/A   52.5866889 -2.0354488
24899 op-snap---monthly-publication-september-2025.pdf   1118 2025-09 Car Volkswagen Golf Blue Misc - Non Traffic Offences No vehicle excise licence B92 8JJ, Hobs Moat Road B92 8JJ, Hobs Moat Road Solihull Solihull RTC - Actioned N/A      
24967 op-snap---monthly-publication-september-2025.pdf   1186 2025-09 Car BMW 5 SERIES Blue Misc - Non Traffic Offences None M42 Oxford M42 Oxford Out of Force Area Out of Force Area NFA Out of Force   52.476098 -1.8869977
24969 op-snap---monthly-publication-september-2025.pdf   1188 2025-09 Pedal Bike Other BUS White Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24970 op-snap---monthly-publication-september-2025.pdf   1189 2025-09 Pedal Bike Vauxhall Corsa Blue Misc - Non Traffic Offences None Cannock ROad Cannock ROad Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24971 op-snap---monthly-publication-september-2025.pdf   1190 2025-09 Pedal Bike Citroen C4 Red Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24972 op-snap---monthly-publication-september-2025.pdf   1191 2025-09 Pedal Bike Other BUS White Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24973 op-snap---monthly-publication-september-2025.pdf   1192 2025-09 Pedal Bike Other Bus Green Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24974 op-snap---monthly-publication-september-2025.pdf   1193 2025-09 Pedal Bike Volkswagen Golf Silver Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24988 op-snap---monthly-publication-september-2025.pdf   1207 2025-09 Car Skoda karoq White Misc - Non Traffic Offences None A45 coventry road A45 coventry road Birmingham Birmingham Warning Letter N/A   52.4714538 -1.8627901
24989 op-snap---monthly-publication-september-2025.pdf   1208 2025-09 Car Volkswagen passat Grey Misc - Non Traffic Offences None M5 M5 Birmingham Birmingham NFA Misc Inc Crimes      
24992 op-snap---monthly-publication-september-2025.pdf   1211 2025-09 Car Volkswagen scirocco White Misc - Non Traffic Offences None m5 M5 Dudley Dudley NFA Misc Inc Crimes      
24994 op-snap---monthly-publication-september-2025.pdf   1213 2025-09 Pedestrian Yamaha YZF Blue Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
25034 op-snap---monthly-publication-september-2025.pdf   1253 2025-09 Pedestrian Volkswagen polo Blue Misc - Non Traffic Offences None High Street, Kings Heath High Street, Kings Heath Birmingham Birmingham NFA Misc Inc Crimes   52.4353506 -1.8927483
25037 op-snap---monthly-publication-september-2025.pdf   1256 2025-09 Pedestrian Audi q2 Black Misc - Non Traffic Offences None station approach Station Approach Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.6036307 -1.8446735
25048 op-snap---monthly-publication-september-2025.pdf   1267 2025-09 Car Vauxhall combo White Misc - Non Traffic Offences None Rookery Rooad Rookery Rooad Birmingham Birmingham NFA Misc Inc Crimes      
25056 op-snap---monthly-publication-september-2025.pdf   1275 2025-09 Pedal Bike Audi A6 Black Misc - Non Traffic Offences None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
25057 op-snap---monthly-publication-september-2025.pdf   1276 2025-09 Car Kia Stonic Grey Misc - Non Traffic Offences None Park avenue, Park avenue Walsall Walsall RTC - Actioned N/A   52.5853624 -2.0632143
25061 op-snap---monthly-publication-september-2025.pdf   1280 2025-09 Pedestrian Other Lomousine White Misc - Non Traffic Offences None ELmdon Road ELmdon Road Birmingham Birmingham Warning Letter N/A   52.4418657 -1.9240253
25065 op-snap---monthly-publication-september-2025.pdf   1284 2025-09 Pedestrian Other     Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.6083917 -2.1033365
25066 op-snap---monthly-publication-september-2025.pdf   1285 2025-09 Pedestrian Other     Misc - Non Traffic Offences None cannock road Cannock Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.6083917 -2.1033365
25067 op-snap---monthly-publication-september-2025.pdf   1286 2025-09 Pedestrian Other     Misc - Non Traffic Offences None cannock road Cannock Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.6083917 -2.1033365
25070 op-snap---monthly-publication-september-2025.pdf   1289 2025-09 Car Porsche panerma Black Misc - Non Traffic Offences None Lady Byron Lane Lady Byron Lane Solihull Solihull NFA Misc Inc Crimes   52.4026126 -1.7503668
25081 op-snap---monthly-publication-september-2025.pdf   1300 2025-09 Car Ford fiesta Blue Misc - Non Traffic Offences No Insurance quarry bank high street Quarry Bank High Street Dudley Dudley NFA Misc Inc Crimes   52.4725789 -2.100641
25097 op-snap---monthly-publication-september-2025.pdf   1316 2025-09 Car Nissan leaf Red Misc - Non Traffic Offences None islingtonrow Islingtonrow Birmingham Birmingham NFA Misc Inc Crimes      
25135 op-snap---monthly-publication-september-2025.pdf   1354 2025-09 Pedestrian Dacia Jogger Green Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
25155 op-snap---monthly-publication-september-2025.pdf   1374 2025-09 Car Vauxhall Crossalnd Black Misc - Non Traffic Offences None victoria street Victoria Street Birmingham Birmingham NFA No Offence   52.4751651 -1.8559775
25163 op-snap---monthly-publication-september-2025.pdf   1382 2025-09 Pedestrian Daf Box White Misc - Non Traffic Offences None Earlsdon Road Earlsdon Road Coventry Coventry NFA No Offence   52.3972344 -1.5388569
25164 op-snap---monthly-publication-september-2025.pdf   1383 2025-09 Car Audi A4 White Misc - Non Traffic Offences None Burlington Road Burlington Road Birmingham Birmingham NFA No Offence   52.4744358 -1.8427399
25238 op-snap---monthly-publication-september-2025.pdf   1457 2025-09 Car Mercedes-Benz van White Misc - Non Traffic Offences None Birchley Island Birchley Island Birmingham Birmingham NFA Misc Inc Crimes      
25252 op-snap---monthly-publication-september-2025.pdf   1471 2025-09 Pedestrian Ferrari   Red Misc - Non Traffic Offences None Broad Street Broad Street Birmingham Birmingham NFA Misc Inc Crimes   52.4749212 -1.9147497
25260 op-snap---monthly-publication-september-2025.pdf   1479 2025-09 Pedestrian Other     Misc - Non Traffic Offences None cannock road Cannock Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.6083917 -2.1033365
25263 op-snap---monthly-publication-september-2025.pdf   1482 2025-09 Pedal Bike Other     Misc - Non Traffic Offences None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.6083917 -2.1033365
25272 op-snap---monthly-publication-september-2025.pdf   1491 2025-09 Pedestrian Vauxhall Vectra Red Misc - Non Traffic Offences None Hockley Heath Hockley Heath Birmingham Birmingham Warning Letter N/A   52.4921873 -1.9258317
25273 op-snap---monthly-publication-september-2025.pdf   1492 2025-09 Pedestrian Audi A3 Silver Misc - Non Traffic Offences None Unknown   Birmingham Birmingham NFA Misc Inc Crimes      
25274 op-snap---monthly-publication-september-2025.pdf   1493 2025-09 Car Mini Cooper Black Misc - Non Traffic Offences None Heath road south Heath road south Birmingham Birmingham NFA Misc Inc Crimes   52.415858 -1.9632649
25299 op-snap---monthly-publication-september-2025.pdf   1518 2025-09 Pedestrian Honda Accord Silver Misc - Non Traffic Offences None Parkdale close Parkdale close Birmingham Birmingham Other Action Taken N/A   52.513341 -1.8406439
25303 op-snap---monthly-publication-september-2025.pdf   1522 2025-09 Pedestrian Honda Accord Silver Misc - Non Traffic Offences None Unknown   Birmingham Birmingham Warning Letter N/A      
25392 op-snap---monthly-publication-september-2025.pdf   1611 2025-09 Pedestrian Citroen c3 Silver Misc - Non Traffic Offences None eddish road Eddish Road Birmingham Birmingham NFA Misc Inc Crimes   52.4833672 -1.7871439
25393 op-snap---monthly-publication-september-2025.pdf   1612 2025-09 Car Volkswagen taigo Grey Misc - Non Traffic Offences None tettenhall Tettenhall Wolverhampton Wolverhampton NFA No Offence   52.5986015 -2.1665631
25447 op-snap---monthly-publication-september-2025.pdf   1666 2025-09 Car Toyota   White Misc - Non Traffic Offences None M6 Warwickshire M6 Warwickshire Out of Force Area Out of Force Area NFA Misc Inc Crimes   52.4572944 -1.4815973
25449 op-snap---monthly-publication-september-2025.pdf   1668 2025-09 Pedestrian Seat Ibiza White Misc - Non Traffic Offences none Roshven road Roshven road Birmingham Birmingham NFA Misc Inc Crimes   52.4536503 -1.8766772
25451 op-snap---monthly-publication-september-2025.pdf   1670 2025-09 Pedestrian       Misc - Non Traffic Offences None Kings Road Kings Road Birmingham Birmingham NFA Misc Inc Crimes   52.5531351 -1.8852761
25453 op-snap---monthly-publication-september-2025.pdf   1672 2025-09 Car Honda accord Silver Misc - Non Traffic Offences No Insurance Parkdale close Parkdale close Birmingham Birmingham Other Action Taken N/A   52.513341 -1.8406439
25463 op-snap---monthly-publication-september-2025.pdf   1682 2025-09 Pedestrian BMW 225xe Black Misc - Non Traffic Offences None howard road Howard Road Birmingham Birmingham NFA No Offence   52.5154198 -1.9135452
25465 op-snap---monthly-publication-september-2025.pdf   1684 2025-09 Pedestrian Honda accord Silver Misc - Non Traffic Offences None parkdale close Parkdale Close Birmingham Birmingham Warning Letter N/A   52.513341 -1.8406439
25515 op-snap---monthly-publication-september-2025.pdf   1734 2025-09 Pedestrian Audi A3 Grey Misc - Non Traffic Offences None Withymoor Road Withymoor Road Dudley Dudley NFA No Offence   52.4871674 -2.0702998
25516 op-snap---monthly-publication-september-2025.pdf   1735 2025-09 Pedestrian Toyota aeras White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA No Offence      
25523 op-snap---monthly-publication-september-2025.pdf   1742 2025-09 Pedestrian Vauxhall zafira Black Misc - Non Traffic Offences None cuthbert street Cuthbert Street Birmingham Birmingham NFA No Offence      
25527 op-snap---monthly-publication-september-2025.pdf   1746 2025-09 Pedestrian Peugeot   Black Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
25533 op-snap---monthly-publication-september-2025.pdf   1752 2025-09 Pedestrian Ford puma Silver Misc - Non Traffic Offences None handworth Handsworth Birmingham Birmingham NFA No Offence   52.5135967 -1.9394384
25564 op-snap---monthly-publication-september-2025.pdf   1783 2025-09 Pedestrian Other blank   Misc - Non Traffic Offences None abbey junior school Abbey Junior School Sandwell Sandwell NFA No Independent Evidence Available   52.4763264 -1.9806732
25573 op-snap---monthly-publication-september-2025.pdf   1792 2025-09 Pedestrian Mercedes-Benz A180 Grey Misc - Non Traffic Offences None Thomas Avenue Thomas Avenue Birmingham Birmingham NFA No Offence   52.5328528 -1.8429578
25575 op-snap---monthly-publication-september-2025.pdf   1794 2025-09 Car Audi A3 Grey Misc - Non Traffic Offences None Newport Newport Out of Force Area Out of Force Area NFA Misc Inc Crimes   52.5027779 -1.7982159
25584 op-snap---monthly-publication-september-2025.pdf   1803 2025-09 Car Honda Civic Blue Misc - Non Traffic Offences None Foleshill Road Foleshill Road Coventry Coventry NFA No Offence   52.4274335 -1.5002381
25585 op-snap---monthly-publication-september-2025.pdf   1804 2025-09 Car Mercedes-Benz C200 Silver Misc - Non Traffic Offences None Foleshill Road Foleshill Road Coventry Coventry NFA No Offence   52.4274335 -1.5002381
25619 op-snap---monthly-publication-september-2025.pdf   1838 2025-09 Car Peugeot 3008 Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      

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