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

375 rows where disposal = "NFA", offence = "Misc - Non Traffic Offences" 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, council_area_raw, nfa_rationale

month 14

reporter_transport_mode 1

  • Car · 375 ✖

offence 1

  • Misc - Non Traffic Offences · 375 ✖

disposal 1

  • NFA · 375 ✖
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
7451 op-snap---monthly-publication-february-2026.pdf   198 2026-02 Car   multiple   Misc - Non Traffic Offences None Willes Road Willes Road Birmingham Birmingham NFA Misc Inc Crimes   52.4964973 -1.9367016
7452 op-snap---monthly-publication-february-2026.pdf   199 2026-02 Car Peugeot Expert White Misc - Non Traffic Offences None Hertford Way / Balkwell Crescent Hertford Way / Balkwell Crescent Solihull Solihull NFA Not in Public Interest   52.3778812 -1.7427424
7574 op-snap---monthly-publication-february-2026.pdf   321 2026-02 Car Volkswagen Taigo White Misc - Non Traffic Offences None A4040 Island Road Island Road Sandwell Sandwell NFA No Offence   52.4634433 -1.9965278
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      
7605 op-snap---monthly-publication-february-2026.pdf   352 2026-02 Car Mini Cooper Grey Misc - Non Traffic Offences None Harborne Lane Harborne Lane Birmingham Birmingham NFA No Offence   52.4468464 -1.9454816
8105 op-snap---monthly-publication-february-2026.pdf   852 2026-02 Car Ford Transit Silver Misc - Non Traffic Offences None Wolverley Crescent, Lion Farm Wolverley Crescent, Lion Farm Sandwell Sandwell NFA Misc Inc Crimes   52.4919463 -2.0292691
8136 op-snap---monthly-publication-february-2026.pdf   883 2026-02 Car Nissan Juke Red Misc - Non Traffic Offences None St Marys Row Street Marys Row Birmingham Birmingham NFA Not in Public Interest      
8183 op-snap---monthly-publication-february-2026.pdf   930 2026-02 Car       Misc - Non Traffic Offences None Vicarage Road Vicarage Road Birmingham Birmingham NFA No Offence   52.470423 -1.9304786
8273 op-snap---monthly-publication-february-2026.pdf   1020 2026-02 Car Ford Mondeo White Misc - Non Traffic Offences None Manor Way Halesowen Manor Way Halesowen Dudley Dudley NFA Not in Public Interest   52.443598 -2.0464887
8427 op-snap---monthly-publication-february-2026.pdf   1174 2026-02 Car Peugeot Expert White Misc - Non Traffic Offences None Hertford Way Hertford Way Solihull Solihull NFA No Offence   52.3778812 -1.7427424
8428 op-snap---monthly-publication-february-2026.pdf   1175 2026-02 Car Ford Transit White Misc - Non Traffic Offences None Hertford Way Hertford Way Solihull Solihull NFA No Offence   52.3778812 -1.7427424
8504 op-snap---monthly-publication-february-2026.pdf   1251 2026-02 Car Audi A3 White Misc - Non Traffic Offences None Pembridge Close Pembridge Close Dudley Dudley NFA No Offence   52.4755298 -2.1067444
8559 op-snap---monthly-publication-february-2026.pdf   1306 2026-02 Car Seat Leon Black Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No VRM   52.4543565 -1.9114004
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      
8630 op-snap---monthly-publication-february-2026.pdf   1377 2026-02 Car Vauxhall insignia Grey Misc - Non Traffic Offences None granthan road Granthan Road Birmingham Birmingham NFA Misc Inc Crimes      
8642 op-snap---monthly-publication-february-2026.pdf   1389 2026-02 Car Volkswagen polo Blue Misc - Non Traffic Offences None netherton Netherton Dudley Dudley NFA Misc Inc Crimes   52.4914577 -2.0831125
8647 op-snap---monthly-publication-february-2026.pdf   1394 2026-02 Car Audi   Black Misc - Non Traffic Offences None washwood heath road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
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      
8793 op-snap---monthly-publication-february-2026.pdf   1540 2026-02 Car       Misc - Non Traffic Offences None np Np Birmingham Birmingham NFA Misc Inc Crimes      
8846 op-snap---monthly-publication-february-2026.pdf   1593 2026-02 Car Mercedes-Benz slk White Misc - Non Traffic Offences None lower queen street Lower Queen Street Birmingham Birmingham NFA Misc Inc Crimes   52.5603978 -1.8227403
8847 op-snap---monthly-publication-february-2026.pdf   1594 2026-02 Car Nissan qashqai Grey Misc - Non Traffic Offences None lower queen street Lower Queen Street Birmingham Birmingham NFA Misc Inc Crimes   52.5603978 -1.8227403
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      
8880 op-snap---monthly-publication-february-2026.pdf   1627 2026-02 Car Vauxhall movano White Misc - Non Traffic Offences None park lane Park Lane Sandwell Sandwell NFA Misc Inc Crimes   52.5687807 -2.0165653
10626 op-snap---monthly-publication-january-2026.pdf   87 2026-01 Car Volkswagen golf Grey Misc - Non Traffic Offences None cox street Cox Street Birmingham Birmingham NFA No Independent Evidence Available   52.4864073 -1.905273
10627 op-snap---monthly-publication-january-2026.pdf   88 2026-01 Car Audi a4 Grey Misc - Non Traffic Offences None M6 SB J9 M6 Southbound J9 Birmingham Birmingham NFA Misc Inc Crimes   52.676119 -2.0858425
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      
10735 op-snap---monthly-publication-january-2026.pdf   196 2026-01 Car   Food trailor Black Misc - Non Traffic Offences None Merridale Street West Merridale Street West Wolverhampton Wolverhampton NFA No VRM   52.579403 -2.1408941
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      
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
11051 op-snap---monthly-publication-january-2026.pdf   512 2026-01 Car Daf HGV White Misc - Non Traffic Offences None Manor Road, Smethwick Manor Road, Smethwick Sandwell Sandwell NFA No Offence   52.4884746 -1.9800128
11053 op-snap---monthly-publication-january-2026.pdf   514 2026-01 Car   multiple   Misc - Non Traffic Offences None Rookery Road Rookery Road Sandwell Sandwell NFA No Independent Evidence Available      
11138 op-snap---monthly-publication-january-2026.pdf   599 2026-01 Car Ford Ka Red Misc - Non Traffic Offences None McKean Road, Oldbury Mc Kean Road, Oldbury Sandwell Sandwell NFA No Offence   52.5077405 -2.0124813
11358 op-snap---monthly-publication-january-2026.pdf   819 2026-01 Car Volkswagen Golf Blue Misc - Non Traffic Offences None Millfield Road Millfield Road Wolverhampton Wolverhampton NFA No Offence      
11603 op-snap---monthly-publication-january-2026.pdf   1064 2026-01 Car Vauxhall Mokka Brown Misc - Non Traffic Offences None Friary Road / Oxhill Road junction Friary Road / Oxhill Road junction Birmingham Birmingham NFA No Offence   52.5162814 -1.9395798
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      
11684 op-snap---monthly-publication-january-2026.pdf   1145 2026-01 Car Daf HGV White Misc - Non Traffic Offences None Manor Abbey Road Manor Abbey Road Halesowen Halesowen NFA No Offence   52.4497108 -2.0241801
11713 op-snap---monthly-publication-january-2026.pdf   1174 2026-01 Car Volkswagen Golf Grey Misc - Non Traffic Offences None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham NFA No Offence   52.4580375 -1.9261777
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      
11910 op-snap---monthly-publication-january-2026.pdf   1371 2026-01 Car Land Rover evoque Grey Misc - Non Traffic Offences None plough and harrow road Plough And Harrow Road Halesowen Halesowen NFA Misc Inc Crimes   52.5899123 -1.8057069
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      
11941 op-snap---monthly-publication-january-2026.pdf   1402 2026-01 Car Ford focus Grey Misc - Non Traffic Offences None eddish road Eddish Road Birmingham Birmingham NFA Misc Inc Crimes   52.4833672 -1.7871439
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
3965 op-snap---monthly-publication-december-2025.pdf   93 2025-12 Car Audi q3 Black Misc - Non Traffic Offences None huntingtree road Huntingtree Road Dudley Dudley NFA No Independent Evidence Available   52.4484682 -2.0689885
4063 op-snap---monthly-publication-december-2025.pdf   191 2025-12 Car Jeep Renegade White Misc - Non Traffic Offences None A4040 Island Road Island Road Sandwell Sandwell NFA No Offence   52.4634433 -1.9965278
4173 op-snap---monthly-publication-december-2025.pdf   301 2025-12 Car Ford Transit Blue Misc - Non Traffic Offences None Wednesbury Oak Road Wednesbury Oak Road Sandwell Sandwell NFA No Offence   52.5461405 -2.0536516
4310 op-snap---monthly-publication-december-2025.pdf   438 2025-12 Car Jaguar XF Silver Misc - Non Traffic Offences None A4040 Island Road Island Road Sandwell Sandwell NFA Not in Public Interest   52.4634433 -1.9965278
4317 op-snap---monthly-publication-december-2025.pdf   445 2025-12 Car BMW 1 series White Misc - Non Traffic Offences None Burnt Tree Burnt Tree Dudley Dudley NFA No Independent Evidence Available   52.513767 -2.0633163
4373 op-snap---monthly-publication-december-2025.pdf   501 2025-12 Car       Misc - Non Traffic Offences None penn road Penn Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5599616 -2.1556338
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      
4483 op-snap---monthly-publication-december-2025.pdf   611 2025-12 Car Volkswagen Tiguan Grey Misc - Non Traffic Offences None A45 A45 Birmingham Birmingham NFA No Independent Evidence Available      
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      
4562 op-snap---monthly-publication-december-2025.pdf   690 2025-12 Car BMW 3 series Silver Misc - Non Traffic Offences None dudley road Dudley Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5717314 -2.1249182
4565 op-snap---monthly-publication-december-2025.pdf   693 2025-12 Car Audi   White Misc - Non Traffic Offences None boldmere road Boldmere Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.548309 -1.8411769
4566 op-snap---monthly-publication-december-2025.pdf   694 2025-12 Car Jaguar epace White Misc - Non Traffic Offences None boldmere road Boldmere Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.548309 -1.8411769
4594 op-snap---monthly-publication-december-2025.pdf   722 2025-12 Car       Misc - Non Traffic Offences None startford road Stratford Road Birmingham Birmingham NFA Misc Inc Crimes   52.4203897 -1.8338574
4596 op-snap---monthly-publication-december-2025.pdf   724 2025-12 Car Volvo xc90 Grey Misc - Non Traffic Offences None birchfield road Birchfield Road Birmingham Birmingham NFA Misc Inc Crimes   52.5170745 -1.9012542
4683 op-snap---monthly-publication-december-2025.pdf   811 2025-12 Car Volkswagen Polo Black Misc - Non Traffic Offences None Garretts Green Lane Garretts Green Lane Birmingham Birmingham NFA No Offence   52.4675802 -1.7905748
4703 op-snap---monthly-publication-december-2025.pdf   831 2025-12 Car Peugeot boxer Silver Misc - Non Traffic Offences None court street Court Street Dudley Dudley NFA Misc Inc Crimes   52.455056 -2.1443561
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      
4737 op-snap---monthly-publication-december-2025.pdf   865 2025-12 Car Peugeot Allure Black Misc - Non Traffic Offences None Leicester Row Leicester Row Coventry Coventry NFA No Independent Evidence Available   52.414317 -1.5104573
4768 op-snap---monthly-publication-december-2025.pdf   896 2025-12 Car Volkswagen TAIGO Green Misc - Non Traffic Offences None sainsburys castle vale Sainsburys Castle Vale Birmingham Birmingham NFA No Independent Evidence Available   52.5168269 -1.7940387
4823 op-snap---monthly-publication-december-2025.pdf   951 2025-12 Car Hyundai Ioniq Black Misc - Non Traffic Offences None Alridge Road Aldridge Road Birmingham Birmingham NFA No Offence   52.5368764 -1.8976461
4824 op-snap---monthly-publication-december-2025.pdf   952 2025-12 Car Vauxhall Vivaro Blue Misc - Non Traffic Offences None Startford Road Stratford Road Birmingham Birmingham NFA No VRM   52.4203897 -1.8338574
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
4857 op-snap---monthly-publication-december-2025.pdf   985 2025-12 Car BMW 320i Grey Misc - Non Traffic Offences None M5 jn1 M5 jn1 Sandwell Sandwell NFA No Offence      
4890 op-snap---monthly-publication-december-2025.pdf   1018 2025-12 Car Renault Megane Blue Misc - Non Traffic Offences None Lauderdale Gardens Lauderdale Gardens Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6283075 -2.1143864
4893 op-snap---monthly-publication-december-2025.pdf   1021 2025-12 Car Seat Leon Black Misc - Non Traffic Offences none A4040 Island Road Island Road Birmingham Birmingham NFA Misc Inc Crimes   52.5095686 -1.9544485
4951 op-snap---monthly-publication-december-2025.pdf   1079 2025-12 Car Porsche taycan Blue Misc - Non Traffic Offences None broadway west Broadway West Walsall Walsall NFA Misc Inc Crimes   52.5698309 -1.9942176
5028 op-snap---monthly-publication-december-2025.pdf   1156 2025-12 Car Mercedes-Benz na Black Misc - Non Traffic Offences None blosomfield road Blosomfield Road Solihull Solihull NFA No VRM      
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
20500 op-snap---monthly-publication-november-2025.pdf   42 2025-11 Car Mercedes-Benz Vito Black Misc - Non Traffic Offences None Bordesley Circus Bordesley Circus Birmingham Birmingham NFA No Offence   52.4728608 -1.8754722
20578 op-snap---monthly-publication-november-2025.pdf   120 2025-11 Car       Misc - Non Traffic Offences None Warwick Road Warwick Road Solihull Solihull NFA No Independent Evidence Available   52.4428606 -1.812114
20586 op-snap---monthly-publication-november-2025.pdf   128 2025-11 Car       Misc - Non Traffic Offences None J9 M6 Roundabout J9 M6 Roundabout Sandwell Sandwell NFA No Independent Evidence Available      
20651 op-snap---monthly-publication-november-2025.pdf   193 2025-11 Car Skoda Yeti Blue Misc - Non Traffic Offences None Cinderbank Cinderbank Dudley Dudley NFA No Offence      
20653 op-snap---monthly-publication-november-2025.pdf   195 2025-11 Car Mercedes-Benz cla White Misc - Non Traffic Offences None London Road London Road Coventry Coventry NFA No Offence   52.3916468 -1.4925995
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      
20727 op-snap---monthly-publication-november-2025.pdf   269 2025-11 Car Vauxhall Insignia Brown Misc - Non Traffic Offences None Richmond Road Richmond Road Birmingham Birmingham NFA No Offence   52.566947 -1.8291809
20809 op-snap---monthly-publication-november-2025.pdf   351 2025-11 Car       Misc - Non Traffic Offences None A41 Roundabout Roundabout Sandwell Sandwell NFA Misc Inc Crimes   52.5478272 -2.0297104
20853 op-snap---monthly-publication-november-2025.pdf   395 2025-11 Car BMW X5 Grey Misc - Non Traffic Offences None Spitfire Island Spitfire Island Birmingham Birmingham NFA No Offence   52.5138106 -1.797297
20862 op-snap---monthly-publication-november-2025.pdf   404 2025-11 Car Ford cmax Black Misc - Non Traffic Offences None gilpin close Gilpin Close Birmingham Birmingham NFA Misc Inc Crimes   52.4990396 -1.8229018
20997 op-snap---monthly-publication-november-2025.pdf   539 2025-11 Car Audi a7 Black Misc - Non Traffic Offences None salford circus Salford Circus Birmingham Birmingham NFA Misc Inc Crimes   52.5095071 -1.8593732
21005 op-snap---monthly-publication-november-2025.pdf   547 2025-11 Car Renault Scenic Blue Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Balkwill Crescent Balkwill Crescent Solihull Solihull NFA No offence   52.3786268 -1.7420081
21007 op-snap---monthly-publication-november-2025.pdf   549 2025-11 Car Toyota Estima White Misc - Non Traffic Offences None Balkwill Crescent Balkwill Crescent Solihull Solihull NFA No offence   52.3786268 -1.7420081
21113 op-snap---monthly-publication-november-2025.pdf   655 2025-11 Car       Misc - Non Traffic Offences None Snow Hill Car Park Snow Hill Car Park Birmingham Birmingham NFA Misc Inc Crimes   52.4835821 -1.8993799
21131 op-snap---monthly-publication-november-2025.pdf   673 2025-11 Car       Misc - Non Traffic Offences None New Town Row New Town Row Birmingham Birmingham NFA Misc Inc Crimes   52.4896513 -1.8947514
21243 op-snap---monthly-publication-november-2025.pdf   785 2025-11 Car BMW 520D Grey Misc - Non Traffic Offences None windwatd way Windwatd Way Solihull Solihull NFA Misc Inc Crimes      
21380 op-snap---monthly-publication-november-2025.pdf   922 2025-11 Car Toyota Prius Grey Misc - Non Traffic Offences None titford road Titford Road Sandwell Sandwell NFA Misc Inc Crimes   52.4912913 -2.0143264
21381 op-snap---monthly-publication-november-2025.pdf   923 2025-11 Car Vauxhall corsa Silver Misc - Non Traffic Offences None titford road Titford Road Sandwell Sandwell NFA Misc Inc Crimes   52.4912913 -2.0143264
21398 op-snap---monthly-publication-november-2025.pdf   940 2025-11 Car Ford explorer Blue Misc - Non Traffic Offences None titford road Titford Road Birmingham Birmingham NFA Misc Inc Crimes      
21425 op-snap---monthly-publication-november-2025.pdf   967 2025-11 Car       Misc - Non Traffic Offences None Dawson Roaad Dawson Roaad Birmingham Birmingham NFA Misc Inc Crimes      
21435 op-snap---monthly-publication-november-2025.pdf   977 2025-11 Car Ford Fiesta Black Misc - Non Traffic Offences None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
21452 op-snap---monthly-publication-november-2025.pdf   994 2025-11 Car Renault Scenic blue Misc - Non Traffic Offences None Barton Drive Barton Drive Solihull Solihull NFA No Offence   52.3770722 -1.7420909
21462 op-snap---monthly-publication-november-2025.pdf   1004 2025-11 Car       Misc - Non Traffic Offences None m6 M6 Birmingham Birmingham NFA Misc Inc Crimes      
21497 op-snap---monthly-publication-november-2025.pdf   1039 2025-11 Car Citroen picasso Blue Misc - Non Traffic Offences None harborne high street Harborne High Street Birmingham Birmingham NFA Misc Inc Crimes   52.459563 -1.946922

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