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

110 rows where council_area = "Out of Force Area" and offence = "Misc - Non Traffic Offences" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, latitude, longitude

reporter_transport_mode 6

disposal 2

offence 1

  • Misc - Non Traffic Offences · 110 ✖

council_area 1

  • Out of Force Area · 110 ✖
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
7324 op-snap---monthly-publication-february-2026.pdf   71 2026-02 Pedestrian Ford Puma Black Misc - Non Traffic Offences None Halord Lane Halord Lane Out of Force Area Out of Force Area NFA Out of Force      
7589 op-snap---monthly-publication-february-2026.pdf   336 2026-02 Car Renault Clio Blue Misc - Non Traffic Offences None Basford (Staffs) Basford (Staffs) Out of Force Area Out of Force Area NFA Out of Force      
7608 op-snap---monthly-publication-february-2026.pdf   355 2026-02 Other Hyundai Tucson White Misc - Non Traffic Offences None N/K N/K Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.5359146 -2.0278244
7628 op-snap---monthly-publication-february-2026.pdf   375 2026-02 Other Vauxhall Corsa Silver Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Defford Road Worcester Defford Road Worcester Out of Force Area Out of Force Area NFA Out of Force      
7638 op-snap---monthly-publication-february-2026.pdf   385 2026-02 Other Volkswagen Polo Red Misc - Non Traffic Offences None Rugby Town Centre Rugby Town Centre Out of Force Area Out of Force Area NFA Out of Force      
8581 op-snap---monthly-publication-february-2026.pdf   1328 2026-02 Car Toyota Verso White Misc - Non Traffic Offences None Foxlydaite Crescent Foxlydaite Crescent Out of Force Area Out of Force Area NFA Out of Force      
8710 op-snap---monthly-publication-february-2026.pdf   1457 2026-02 Pedestrian Land Rover freelander Silver Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
8729 op-snap---monthly-publication-february-2026.pdf   1476 2026-02 Car Land Rover discovery Black Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
8873 op-snap---monthly-publication-february-2026.pdf   1620 2026-02 Car Volvo c30 Grey Misc - Non Traffic Offences None windsor close Windsor Close Out of Force Area Out of Force Area NFA Out of Force   52.404722 -2.0141058
8879 op-snap---monthly-publication-february-2026.pdf   1626 2026-02 Car Audi Q4 Black Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
10663 op-snap---monthly-publication-january-2026.pdf   124 2026-01 Car Land Rover defender Green Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
10769 op-snap---monthly-publication-january-2026.pdf   230 2026-01 Pedestrian     Grey Misc - Non Traffic Offences None Camp Lane, Worcester Camp Lane, Worcester Out of Force Area Out of Force Area NFA Out of Force      
10920 op-snap---monthly-publication-january-2026.pdf   381 2026-01 Car   Mazda   Misc - Non Traffic Offences None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force      
10964 op-snap---monthly-publication-january-2026.pdf   425 2026-01 Car Audi Q2 Blue Misc - Non Traffic Offences None Friary Road, Lichfield Friary Road, Lichfield Out of Force Area Out of Force Area NFA Out of Force      
11666 op-snap---monthly-publication-january-2026.pdf   1127 2026-01 Car Ford Transit White Misc - Non Traffic Offences None Catherine Close Bromsgrove (West Mercia) Catherine Close Bromsgrove (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
11831 op-snap---monthly-publication-january-2026.pdf   1292 2026-01 Other   NP   Misc - Non Traffic Offences None Test Test Out of Force Area Out of Force Area Other Action Taken N/A   52.5082944 -2.0789873
11906 op-snap---monthly-publication-january-2026.pdf   1367 2026-01 Car Ford galaxy Silver Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
11931 op-snap---monthly-publication-january-2026.pdf   1392 2026-01 Car       Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
11946 op-snap---monthly-publication-january-2026.pdf   1407 2026-01 Car Seat leon White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
3900 op-snap---monthly-publication-december-2025.pdf   28 2025-12 Car Fiat 500 White Misc - Non Traffic Offences None M5, worcestershire M5, worcestershire Out of Force Area Out of Force Area NFA No VRM   52.432364 -2.0176127
3946 op-snap---monthly-publication-december-2025.pdf   74 2025-12 Pedestrian       Misc - Non Traffic Offences None Himley Road Himley Road Out of Force Area Out of Force Area NFA Out of Force   52.5130072 -2.09584
4461 op-snap---monthly-publication-december-2025.pdf   589 2025-12 Car Mercedes-Benz   White Misc - Non Traffic Offences None OOF- Shrewsbury OOF- Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4481 op-snap---monthly-publication-december-2025.pdf   609 2025-12 Car Toyota Corolla Blue Misc - Non Traffic Offences None M5 West Mercia M5 West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4495 op-snap---monthly-publication-december-2025.pdf   623 2025-12 Car Fiat   Grey Misc - Non Traffic Offences None OOF Warwickshire OOF Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
4509 op-snap---monthly-publication-december-2025.pdf   637 2025-12 Car Vauxhall corsa Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
4534 op-snap---monthly-publication-december-2025.pdf   662 2025-12 Car Vauxhall Corsa Blue Misc - Non Traffic Offences None Lickey Lane West Mercia Lickey Lane West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4669 op-snap---monthly-publication-december-2025.pdf   797 2025-12 Pedestrian BMW 1 Series Silver Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4670 op-snap---monthly-publication-december-2025.pdf   798 2025-12 Pedestrian BMW 3 Series Black Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4671 op-snap---monthly-publication-december-2025.pdf   799 2025-12 Pedestrian Audi A4 Grey Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4685 op-snap---monthly-publication-december-2025.pdf   813 2025-12 Pedestrian Tesla Model 3 Black Misc - Non Traffic Offences None Centurion Drive Worcester Centurion Drive Worcester Out of Force Area Out of Force Area NFA Out of Force      
4714 op-snap---monthly-publication-december-2025.pdf   842 2025-12 Car BMW 840i Red Misc - Non Traffic Offences None B6049 Hope, Sheffield Hope, Sheffield Out of Force Area Out of Force Area NFA Out of Force      
4844 op-snap---monthly-publication-december-2025.pdf   972 2025-12 Car   Scooter Grey Misc - Non Traffic Offences None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
5026 op-snap---monthly-publication-december-2025.pdf   1154 2025-12 Pedestrian Volkswagen Up White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
5107 op-snap---monthly-publication-december-2025.pdf   1235 2025-12 Car Mercedes-Benz C Class White Misc - Non Traffic Offences None Warwick Warwick Out of Force Area Out of Force Area NFA Out of Force   52.3813073 -1.5639569
20701 op-snap---monthly-publication-november-2025.pdf   243 2025-11 Car BMW 640 D Black Misc - Non Traffic Offences None A456 (Tenbury Wells) A456 (Tenbury Wells) Out of Force Area Out of Force Area NFA Out of Force      
20829 op-snap---monthly-publication-november-2025.pdf   371 2025-11 Pedestrian       Misc - Non Traffic Offences None Leicester Leicester Out of Force Area Out of Force Area NFA Out of Force   52.4145125 -1.5097639
20840 op-snap---monthly-publication-november-2025.pdf   382 2025-11 Other       Misc - Non Traffic Offences None np Np Out of Force Area Out of Force Area NFA Misc Inc Crimes      
20993 op-snap---monthly-publication-november-2025.pdf   535 2025-11 Pedestrian Ford fiesta Blue Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
21208 op-snap---monthly-publication-november-2025.pdf   750 2025-11 Pedestrian BMW 1 Series Grey Misc - Non Traffic Offences None Ramsden Avenue Ramsden Avenue Out of Force Area Out of Force Area NFA Out of Force      
21291 op-snap---monthly-publication-november-2025.pdf   833 2025-11 Pedestrian Volkswagen golf Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
21352 op-snap---monthly-publication-november-2025.pdf   894 2025-11 Pedestrian Skoda Octavia Red Misc - Non Traffic Offences None Bidford On Avon Bidford On Avon Out of Force Area Out of Force Area NFA No Offence      
21594 op-snap---monthly-publication-november-2025.pdf   1136 2025-11 Car Honda Civic Silver Misc - Non Traffic Offences None A14 A14 Out of Force Area Out of Force Area NFA Out of Force      
21608 op-snap---monthly-publication-november-2025.pdf   1150 2025-11 Car Man truck White Misc - Non Traffic Offences None lottle oxon lane Lottle Oxon Lane Out of Force Area Out of Force Area NFA Out of Force      
21649 op-snap---monthly-publication-november-2025.pdf   1191 2025-11 Car Audi a6 Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
21806 op-snap---monthly-publication-november-2025.pdf   1348 2025-11 Pedestrian Kia picanto Silver Misc - Non Traffic Offences None cambridge Cambridge Out of Force Area Out of Force Area NFA Out of Force   52.4652475 -1.9056734
21937 op-snap---monthly-publication-november-2025.pdf   1479 2025-11 Car Ford transit White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
22420 op-snap---monthly-publication-october-2025.pdf   370 2025-10 Pedestrian   Tractor Red Misc - Non Traffic Offences None Wall Hill Road Wall Hill Road Out of Force Area Out of Force Area NFA Out of Force   52.4459445 -1.5552508
22707 op-snap---monthly-publication-october-2025.pdf   657 2025-10 Car Vauxhall Corsa White Misc - Non Traffic Offences None M6 near Knutsford M6 near Knutsford Out of Force Area Out of Force Area NFA Out of Force      
22854 op-snap---monthly-publication-october-2025.pdf   804 2025-10 Car Audi A3 Black Misc - Non Traffic Offences None West End Lane, London West End Lane, London Out of Force Area Out of Force Area NFA Out of Force      
22921 op-snap---monthly-publication-october-2025.pdf   871 2025-10 Car Volkswagen Golf Grey Misc - Non Traffic Offences None Stafford Stafford Out of Force Area Out of Force Area NFA Out of Force   52.6014882 -2.1310443
23145 op-snap---monthly-publication-october-2025.pdf   1095 2025-10 Pedestrian Other     Misc - Non Traffic Offences None warwickshire Warwickshire Out of Force Area Out of Force Area NFA Misc Inc Crimes   52.4318492 -1.7319529
23148 op-snap---monthly-publication-october-2025.pdf   1098 2025-10 Car BMW X5 Black Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
23219 op-snap---monthly-publication-october-2025.pdf   1169 2025-10 Pedestrian Other     Misc - Non Traffic Offences None Stock Wood Lodge Farm Stock Wood Lodge Farm Out of Force Area Out of Force Area NFA Out of Force      
23289 op-snap---monthly-publication-october-2025.pdf   1239 2025-10 Pedestrian Mg hs Black Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
23292 op-snap---monthly-publication-october-2025.pdf   1242 2025-10 Car Land Rover discovery Grey Misc - Non Traffic Offences None hereford Hereford Out of Force Area Out of Force Area NFA Misc Inc Crimes   52.4047807 -2.0101216
23358 op-snap---monthly-publication-october-2025.pdf   1308 2025-10 Car Nissan X-Trail Silver Misc - Non Traffic Offences None Out of Force-Northamptonshire Out of Force-Northamptonshire Out of Force Area Out of Force Area NFA Out of Force      
23366 op-snap---monthly-publication-october-2025.pdf   1316 2025-10 Pedestrian Seat arona White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
23406 op-snap---monthly-publication-october-2025.pdf   1356 2025-10 Car Scania   White Misc - Non Traffic Offences None M5 M5 Out of Force Area Out of Force Area NFA Out of Force      
23422 op-snap---monthly-publication-october-2025.pdf   1372 2025-10 Pedestrian       Misc - Non Traffic Offences None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
23445 op-snap---monthly-publication-october-2025.pdf   1395 2025-10 Pedestrian       Misc - Non Traffic Offences None Borrington Road, Kidderminster Borrington Road, Kidderminster Out of Force Area Out of Force Area NFA Out of Force      
23703 op-snap---monthly-publication-october-2025.pdf   1653 2025-10 Pedestrian       Misc - Non Traffic Offences None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force      
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      
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      
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      
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      
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      
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
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      
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      
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
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      
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      
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
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      
2258 op-snap---monthly-publication-august-2025.pdf   233 2025-08 Car       Misc - Non Traffic Offences None Manor way Manor way Out of Force Are Out of Force Area NFA Out of Force      
3278 op-snap---monthly-publication-august-2025.pdf   1253 2025-08 Pedestrian Vauxhall corsa Green Misc - Non Traffic Offences None Broseley high Street Broseley high Street Out of Force Are Out of Force Area NFA No Offence      
3480 op-snap---monthly-publication-august-2025.pdf   1455 2025-08 Car Toyota C-HR Grey Misc - Non Traffic Offences None m6 towards Suffolk m6 towards Suffolk Out of Force Are Out of Force Area NFA Out of Force      
3733 op-snap---monthly-publication-august-2025.pdf   1708 2025-08 Car Mercedes-Benz   Blue Misc - Non Traffic Offences None Banbury Retail Park Banbury Retail Park Out of Force Are Out of Force Area NFA No Offence      
12119 op-snap---monthly-publication-july-2025.pdf   171 2025-07 Other Audi A6.. White Misc - Non Traffic Offences None Not known.   Out of Force Area Out of Force Area NFA Misc Inc Crimes      
12135 op-snap---monthly-publication-july-2025.pdf   187 2025-07 Pedestrian Scania Lorry White Misc - Non Traffic Offences None Stockton Road Stockton Road Out of Force Area Out of Force Area NFA Out of Force   52.4163443 -1.4992768
12682 op-snap---monthly-publication-july-2025.pdf   734 2025-07 Car BMW 330 Black Misc - Non Traffic Offences None A4110 Wigmore Wigmore Out of Force Area Out of Force Area NFA Out of Force      
12704 op-snap---monthly-publication-july-2025.pdf   756 2025-07 Car Ford S-Max Black Misc - Non Traffic Offences None Edinburgh Road, Nuneaton Edinburgh Road, Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
13171 op-snap---monthly-publication-july-2025.pdf   1223 2025-07 Car Vauxhall Corsa Grey Misc - Non Traffic Offences None Out of Force Out of Force Out of Force Area Out of Force Area NFA Out of Force      
13237 op-snap---monthly-publication-july-2025.pdf   1289 2025-07 Pedestrian Mitsubishi Outlander Blue Misc - Non Traffic Offences None High Street Wem (Shrewsbury) High Street Wem (Shrewsbury) Out of Force Area Out of Force Area NFA Misc Inc Crimes      
13460 op-snap---monthly-publication-july-2025.pdf   1512 2025-07 Pedestrian Seat Ibiza Black Misc - Non Traffic Offences No Insurance Windsor Gardens Windsor Gardens Out of Force Area Out of Force Area NFA Misc Inc Crimes   52.5756368 -2.1867206
13490 op-snap---monthly-publication-july-2025.pdf   1542 2025-07 Pedestrian Ford Ranger Black Misc - Non Traffic Offences None Wild Thyme Drive Wild Thyme Drive Out of Force Area Out of Force Area NFA Misc Inc Crimes      
13526 op-snap---monthly-publication-july-2025.pdf   1578 2025-07 Car Audi RSQ8 Black Misc - Non Traffic Offences None M6 J2 (warwickshire) M6 J2 (warwickshire) Out of Force Area Out of Force Area NFA Out of Force   52.676119 -2.0858425
13864 op-snap---monthly-publication-july-2025.pdf   1916 2025-07 Car Honda crv Green Misc - Non Traffic Offences None A46 Stratford Stratford Out of Force Area Out of Force Area NFA Misc Inc Crimes      
13912 op-snap---monthly-publication-july-2025.pdf   1964 2025-07 Car Vauxhall corsa Grey Misc - Non Traffic Offences None manchester Manchester Out of Force Area Out of Force Area NFA No Offence   52.4908553 -1.8943638
14268 op-snap---monthly-publication-june-2025.pdf   197 2025-06 Car   Kawasaki Black Misc - Non Traffic Offences Fail to stop, Fail to report Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
15365 op-snap---monthly-publication-june-2025.pdf   1294 2025-06 Car Ford Fiesta Blue Misc - Non Traffic Offences None Fosse Way, Warwick Fosse Way, Warwick Out of Force Area Out of Force Area NFA Out of Force      
16117 op-snap---monthly-publication-june-2025.pdf   2046 2025-06 Pedestrian Ford Transit White Misc - Non Traffic Offences None Meadowhill Road Meadowhill Road Out of Force Area Out of Force Area NFA Not in Public Interest      
16131 op-snap---monthly-publication-june-2025.pdf   2060 2025-06 Car Citroen relay White Misc - Non Traffic Offences None M5 M5 Out of Force Area Out of Force Area NFA Not in Public Interest      
19021 op-snap---monthly-publication-may-2025.pdf   383 2025-05 Car Mg ZS Red Misc - Non Traffic Offences None Alder Road Shifnal Alder Road Shifnal Out of Force Area Out of Force Area NFA Out of Force      
19478 op-snap---monthly-publication-may-2025.pdf   840 2025-05 Car   bike   Misc - Non Traffic Offences None Telford Telford Out of Force Area Out of Force Area NFA No Offence   52.4979333 -1.9664857
19744 op-snap---monthly-publication-may-2025.pdf   1106 2025-05 Car Volkswagen Polo Black Misc - Non Traffic Offences None A44, West mercia A44, West mercia Out of Force Area Out of Force Area NFA Out of Force      
19844 op-snap---monthly-publication-may-2025.pdf   1206 2025-05 Car Audi A3 Silver Misc - Non Traffic Offences None A5 Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
20452 op-snap---monthly-publication-may-2025.pdf   1814 2025-05 Car       Misc - Non Traffic Offences None Market Drayton Market Drayton Out of Force Area Out of Force Area NFA Misc Inc Crimes      
654 op-snap---monthly-publication-april-2025.pdf   653 2025-04 Car Nissan XTrail Black Misc - Non Traffic Offences None M40 Warwickshire M40 Warwickshire Out of Force Area Out of Force Area NFA No Offence   52.3976134 -1.4337873
808 op-snap---monthly-publication-april-2025.pdf   807 2025-04 Other       Misc - Non Traffic Offences None Unknown.   Out of Force Area Out of Force Area NFA No Independent Evidence Available      

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