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

979 rows where 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

vehicle_make >30

month 14

reporter_transport_mode 11

offence 1

  • Misc - Non Traffic Offences · 979 ✖
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
7306 op-snap---monthly-publication-february-2026.pdf   53 2026-02 Other Audi A1 Blue Misc - Non Traffic Offences None UK Uk Birmingham Birmingham Other Action Taken N/A   52.45124 -1.937937
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      
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
7453 op-snap---monthly-publication-february-2026.pdf   200 2026-02 Car Ford Transit White Misc - Non Traffic Offences None Shirley Road Shirley Road Birmingham Birmingham Other Action Taken N/A   52.4198291 -1.9241732
7502 op-snap---monthly-publication-february-2026.pdf   249 2026-02 Other Toyota Prius White Misc - Non Traffic Offences None Newton Street Newton Street Sandwell Sandwell Other Action Taken N/A   52.536581 -1.9817474
7516 op-snap---monthly-publication-february-2026.pdf   263 2026-02 Pedestrian Scania Lorry Yellow Misc - Non Traffic Offences None Avenue Road Avenue Road Birmingham Birmingham NFA No Offence   52.4941712 -1.8795158
7519 op-snap---monthly-publication-february-2026.pdf   266 2026-02 Car Volvo XC90 Grey Misc - Non Traffic Offences None Bristol Street Bristol Street Birmingham Birmingham RTC - Actioned N/A   52.4691145 -1.9003257
7565 op-snap---monthly-publication-february-2026.pdf   312 2026-02 Pedestrian Volkswagen Polo Silver Misc - Non Traffic Offences None Hamlet Road Hamlet Road Birmingham Birmingham NFA No Independent Evidence Available   52.4315327 -1.8421334
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
7584 op-snap---monthly-publication-february-2026.pdf   331 2026-02 Other Nissan Xtrail Orange Misc - Non Traffic Offences None Unett Street Unett Street Birmingham Birmingham NFA No Offence   52.4921149 -1.9071925
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
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
7624 op-snap---monthly-publication-february-2026.pdf   371 2026-02 Car Audi A3 Grey Misc - Non Traffic Offences None School Road, Shirley School Road, Shirley Solihull Solihull RTC - Actioned N/A   52.4057898 -1.8254544
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      
7637 op-snap---monthly-publication-february-2026.pdf   384 2026-02 Car Mercedes-Benz C200 Blue Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Walsgrave Road Walsgrave Road Coventry Coventry Fixed Penalty N/A   52.4096725 -1.487901
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      
7686 op-snap---monthly-publication-february-2026.pdf   433 2026-02 Pedestrian Toyota CHR White Misc - Non Traffic Offences None Robin Hood Lane Robin Hood Lane Birmingham Birmingham NFA No Offence   52.4221526 -1.8425617
7880 op-snap---monthly-publication-february-2026.pdf   627 2026-02 Other Skoda Kodiaq White Misc - Non Traffic Offences None Welhead Road Welhead Road Birmingham Birmingham NFA No Offence      
7881 op-snap---monthly-publication-february-2026.pdf   628 2026-02 Other   multiple   Misc - Non Traffic Offences None Perry Barr Village Perry Barr Village Birmingham Birmingham NFA No Offence   52.5243314 -1.8819868
7955 op-snap---monthly-publication-february-2026.pdf   702 2026-02 Pedestrian Mercedes-Benz E300.. Blue Misc - Non Traffic Offences None Edward Street Edward Street Birmingham Birmingham Warning Letter N/A   52.4816233 -1.9124334
7999 op-snap---monthly-publication-february-2026.pdf   746 2026-02 Pedestrian Vauxhall Mokka Blue Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
8030 op-snap---monthly-publication-february-2026.pdf   777 2026-02 Car Ford Kuga White Misc - Non Traffic Offences None Sir henry Parkes Road Sir henry Parkes Road Coventry Coventry RTC - Actioned N/A   52.3900568 -1.5550766
8038 op-snap---monthly-publication-february-2026.pdf   785 2026-02 Car BMW X3.. White Misc - Non Traffic Offences None Hagley Road Hagley Road Birmingham Birmingham Other Action Taken N/A   52.471632 -1.9456776
8075 op-snap---monthly-publication-february-2026.pdf   822 2026-02 Other   Trials m/cycle   Misc - Non Traffic Offences None Fileds of Poplar Avenue and Stroud Avenue Walsall Fileds of Poplar Avenue and Stroud Avenue Walsall Metropolitan Borough of Walsall Walsall Other Action Taken N/A      
8099 op-snap---monthly-publication-february-2026.pdf   846 2026-02 Other Vauxhall Corsa White Misc - Non Traffic Offences None Standhill Road Kingswinford Standhill Road Kingswinford Dudley Dudley RTC - Actioned N/A      
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
8117 op-snap---monthly-publication-february-2026.pdf   864 2026-02 Other BMW 525d Silver Misc - Non Traffic Offences None Spring Road Spring Road Birmingham Birmingham Other Action Taken N/A   52.444262 -1.8362585
8120 op-snap---monthly-publication-february-2026.pdf   867 2026-02 Other BMW 220.. Grey Misc - Non Traffic Offences None Spring Road Spring Road Birmingham Birmingham Other Action Taken N/A   52.444262 -1.8362585
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
8226 op-snap---monthly-publication-february-2026.pdf   973 2026-02 Other       Misc - Non Traffic Offences None Fernleigh Road Fernleigh Road Metropolitan Borough of Walsall Walsall Other Action Taken N/A   52.5909213 -1.9596055
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
8356 op-snap---monthly-publication-february-2026.pdf   1103 2026-02 Other Ford Fiesta Blue Misc - Non Traffic Offences None Star City Star City Birmingham Birmingham NFA No Offence   52.5054363 -1.8556273
8409 op-snap---monthly-publication-february-2026.pdf   1156 2026-02 Pedestrian Toyota Rav 4 Green Misc - Non Traffic Offences No Insurance Woodstock Road Woodstock Road Birmingham Birmingham NFA Not in Public Interest   52.4486205 -1.8740822
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
8517 op-snap---monthly-publication-february-2026.pdf   1264 2026-02 Car     Black Misc - Non Traffic Offences None Cape Hill Smethwick Cape Hill Smethwick Sandwell Sandwell RTC - Actioned N/A   52.4909694 -1.9579807
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      
8610 op-snap---monthly-publication-february-2026.pdf   1357 2026-02 Pedestrian Mg hs Black Misc - Non Traffic Offences None wolverhampton Wolverhampton Wolverhampton Wolverhampton NFA No Offence   52.5879884 -2.120242
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
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      
8713 op-snap---monthly-publication-february-2026.pdf   1460 2026-02 Pedestrian BMW 320d White Misc - Non Traffic Offences None homer street Homer Street Solihull Solihull NFA Misc Inc Crimes      
8715 op-snap---monthly-publication-february-2026.pdf   1462 2026-02 Pedestrian Lamborghini urus Black Misc - Non Traffic Offences None rockingham gardens Rockingham Gardens Birmingham Birmingham NFA Misc Inc Crimes   52.5690681 -1.8271174
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      
8730 op-snap---monthly-publication-february-2026.pdf   1477 2026-02 Pedestrian Kia sorento Grey Misc - Non Traffic Offences None broadmeadow Broadmeadow Walsall Walsall Warning Letter N/A   52.6100022 -1.9177041
8748 op-snap---monthly-publication-february-2026.pdf   1495 2026-02 Car Mercedes-Benz S220D Blue Misc - Non Traffic Offences No vehicle excise licence Moseley Road Moseley Road Birmingham Birmingham RTC - Actioned N/A   52.4679402 -1.881408
8781 op-snap---monthly-publication-february-2026.pdf   1528 2026-02 Other Ford Fiesta Black Misc - Non Traffic Offences None Waterfrotn car park Waterfrotn car park Dudley Dudley NFA No Offence      
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      
8806 op-snap---monthly-publication-february-2026.pdf   1553 2026-02 Car Skoda Kodiaq Black Misc - Non Traffic Offences None Freehold Street Freehold Street Coventry Coventry RTC - Actioned N/A   52.4164191 -1.4928534
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
8851 op-snap---monthly-publication-february-2026.pdf   1598 2026-02 Pedestrian Vauxhall corsa Grey Misc - Non Traffic Offences None birmingham road Birmingham Road Birmingham Birmingham NFA Misc Inc Crimes   52.5505398 -1.8252993
8857 op-snap---monthly-publication-february-2026.pdf   1604 2026-02 Pedal Bike Volkswagen caddy Black Misc - Non Traffic Offences None black haynes road Black Haynes Road Birmingham Birmingham NFA Misc Inc Crimes   52.4260755 -1.9679443
8862 op-snap---monthly-publication-february-2026.pdf   1609 2026-02 Pedestrian Volkswagen passat Silver Misc - Non Traffic Offences None holly lane Holly Lane Birmingham Birmingham NFA Misc Inc Crimes   52.5236889 -1.8253311
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
10586 op-snap---monthly-publication-january-2026.pdf   47 2026-01 Pedestrian Audi r8 Black Misc - Non Traffic Offences None bishopsgate street Bishopsgate Street Birmingham Birmingham NFA Misc Inc Crimes   52.473986 -1.9147087
10589 op-snap---monthly-publication-january-2026.pdf   50 2026-01 Van Ford transit White Misc - Non Traffic Offences None m42 NB airport m42 Northbound airport Birmingham Birmingham NFA Misc Inc Crimes      
10591 op-snap---monthly-publication-january-2026.pdf   52 2026-01 Pedestrian       Misc - Non Traffic Offences None aldre drive Aldre Drive Birmingham Birmingham NFA Misc Inc Crimes      
10592 op-snap---monthly-publication-january-2026.pdf   53 2026-01 Pedestrian Toyota rav4 Green Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
10595 op-snap---monthly-publication-january-2026.pdf   56 2026-01 Pedal Bike Hyundai i10 Grey Misc - Non Traffic Offences None lower essex street Lower Essex Street Birmingham Birmingham NFA No Offence   52.4716178 -1.8954045
10613 op-snap---monthly-publication-january-2026.pdf   74 2026-01 Other Volvo XC60. Black Misc - Non Traffic Offences None Claypit Lane Claypit Lane Sandwell Sandwell NFA Not in Public Interest   52.5214953 -2.0136299
10616 op-snap---monthly-publication-january-2026.pdf   77 2026-01 Pedestrian Volkswagen polo Blue Misc - Non Traffic Offences None homelea road Homelea Road Birmingham Birmingham NFA No Offence   52.4711252 -1.8149195
10617 op-snap---monthly-publication-january-2026.pdf   78 2026-01 Car Volkswagen passat Silver Misc - Non Traffic Offences None west brom West Brom Sandwell Sandwell Other Action Taken N/A   52.473606 -1.9686379
10620 op-snap---monthly-publication-january-2026.pdf   81 2026-01 Pedestrian Other smart car Black Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
10622 op-snap---monthly-publication-january-2026.pdf   83 2026-01 Pedestrian Seat leon Grey Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
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
10632 op-snap---monthly-publication-january-2026.pdf   93 2026-01 Other Vauxhall Meriva White Misc - Non Traffic Offences None The Oak Walk The Oak Walk Birmingham Birmingham RTC - Actioned N/A   52.4020485 -1.9696265
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      
10692 op-snap---monthly-publication-january-2026.pdf   153 2026-01 Other BMW X3.. White Misc - Non Traffic Offences None Canal Court Canal Court Birmingham Birmingham Warning Letter N/A   52.4486586 -1.8085554
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
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      
10849 op-snap---monthly-publication-january-2026.pdf   310 2026-01 Other   Unknown VRM   Misc - Non Traffic Offences None Kingstanding Circle Kingstanding Circle Birmingham Birmingham NFA No VRM   52.5536651 -1.8826944
10867 op-snap---monthly-publication-january-2026.pdf   328 2026-01 Pedestrian Mercedes-Benz 330 White Misc - Non Traffic Offences None Barclay Road Barclay Road Sandwell Sandwell Warning Letter N/A   52.4722765 -1.9787531
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      
10981 op-snap---monthly-publication-january-2026.pdf   442 2026-01 Pedestrian Vauxhall Viva Red Misc - Non Traffic Offences None Fontley Close Fontley Close Birmingham Birmingham NFA No Offence   52.4760797 -1.7952034
10998 op-snap---monthly-publication-january-2026.pdf   459 2026-01 Car Audi Q5 Grey Misc - Non Traffic Offences None Colley Gate Colley Gate Birmingham Birmingham Warning Letter N/A      
11031 op-snap---monthly-publication-january-2026.pdf   492 2026-01 Car Seat Ibiza Red Misc - Non Traffic Offences None Bromford Lane Bromford Lane Birmingham Birmingham Other Action Taken N/A   52.5083238 -1.8332287
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
11185 op-snap---monthly-publication-january-2026.pdf   646 2026-01 Other BMW 3 series White Misc - Non Traffic Offences None Walsall Walsall Walsall Walsall NFA No Offence   52.5841365 -1.9852679
11234 op-snap---monthly-publication-january-2026.pdf   695 2026-01 Car Mazda MX 5 Grey Misc - Non Traffic Offences None M42 Jct 3A M42 Junction 3A Birmingham Birmingham Other Action Taken N/A   52.4846642 -1.9297585
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
11257 op-snap---monthly-publication-january-2026.pdf   718 2026-01 Pedestrian Ford Focus Blue Misc - Non Traffic Offences None Freer Road Freer Road Birmingham Birmingham NFA No Offence   52.5074462 -1.8979307
11263 op-snap---monthly-publication-january-2026.pdf   724 2026-01 Pedestrian BMW 1 series Black Misc - Non Traffic Offences None Freer Road Freer Road Birmingham Birmingham NFA No Offence   52.5074462 -1.8979307
11296 op-snap---monthly-publication-january-2026.pdf   757 2026-01 Pedestrian BMW 116d White Misc - Non Traffic Offences None Maitland Road Maitland Road Birmingham Birmingham NFA No Offence   52.4868494 -1.8448776
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
11306 op-snap---monthly-publication-january-2026.pdf   767 2026-01 Other Audi S3 Silver Misc - Non Traffic Offences None High Street Stourbridge High Street Stourbridge Dudley Dudley NFA No Offence   52.4570763 -2.1136199
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      

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