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

405 rows where disposal = "NFA" and reporter_transport_mode = "Other" 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

offence 26

reporter_transport_mode 1

  • Other · 405 ✖

disposal 1

  • NFA · 405 ✖
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
7261 op-snap---monthly-publication-february-2026.pdf   8 2026-02 Other       Offence to be added None Bewdley Bewdley Out of Force Area Out of Force Area NFA Out of Force   52.4330724 -1.9181313
7280 op-snap---monthly-publication-february-2026.pdf   27 2026-02 Other Vauxhall corsa White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Henwick Road Henwick Road Out of Force Area Out of Force Area NFA Out of Force      
7318 op-snap---monthly-publication-february-2026.pdf   65 2026-02 Other BMW 116 Silver Driving without Due Care and Attention None London Road Shrewsbury London Road Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
7420 op-snap---monthly-publication-february-2026.pdf   167 2026-02 Other Volkswagen Crafter White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Church St Church Street Birmingham Birmingham NFA No Independent Evidence Available   52.5020781 -1.9122368
7421 op-snap---monthly-publication-february-2026.pdf   168 2026-02 Other Jaguar XF Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Pauls Square Street Pauls Square Birmingham Birmingham NFA No Offence      
7506 op-snap---monthly-publication-february-2026.pdf   253 2026-02 Other Volvo C40 Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Independent Evidence Available   52.471632 -1.9456776
7523 op-snap---monthly-publication-february-2026.pdf   270 2026-02 Other   UK   Using a Mobile Phone Whilst Driving None UK Uk Solihull Solihull NFA No Independent Evidence Available   52.3864526 -1.6495655
7581 op-snap---monthly-publication-february-2026.pdf   328 2026-02 Other Jaguar u/k Blue Driving without Due Care and Attention None Long Bank Long Bank Out of Force Area Out of Force Area NFA Out of Force   52.5785967 -2.0581007
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
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
7623 op-snap---monthly-publication-february-2026.pdf   370 2026-02 Other Lamborghini   Silver Using a Mobile Phone Whilst Driving None Birmingham Birmingham Birmingham Birmingham NFA No VRM   52.4796992 -1.9026911
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      
7646 op-snap---monthly-publication-february-2026.pdf   393 2026-02 Other Vauxhall Corsa Brown Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA Not in Public Interest   52.4874281 -2.1117204
7663 op-snap---monthly-publication-february-2026.pdf   410 2026-02 Other Vauxhall Corsa Grey Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA No Offence   52.4874281 -2.1117204
7703 op-snap---monthly-publication-february-2026.pdf   450 2026-02 Other Hyundai I10 White Driving without Due Care and Attention None Ashmore Lake Road Ashmore Lake Road Walsall Walsall NFA No Offence   52.5961284 -2.0497272
7704 op-snap---monthly-publication-february-2026.pdf   451 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA Not in Public Interest   52.5521118 -1.8845138
7719 op-snap---monthly-publication-february-2026.pdf   466 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA Not in Public Interest   52.5521118 -1.8845138
7736 op-snap---monthly-publication-february-2026.pdf   483 2026-02 Other Mercedes-Benz   Grey Driving without Due Care and Attention None London somewhere? This is from social media. London somewhere? This is from social media Out of Force Area Out of Force Area NFA Out of Force      
7739 op-snap---monthly-publication-february-2026.pdf   486 2026-02 Other BMW 318d Grey Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Norwood Road Norwood Road Dudley Dudley NFA No Independent Evidence Available   52.4831397 -2.1309273
7768 op-snap---monthly-publication-february-2026.pdf   515 2026-02 Other Nissan Navara Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Montgomery Street Montgomery Street Birmingham Birmingham NFA No Offence   52.4644472 -1.8668879
7791 op-snap---monthly-publication-february-2026.pdf   538 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA No Independent Evidence Available   52.5521118 -1.8845138
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
7940 op-snap---monthly-publication-february-2026.pdf   687 2026-02 Other Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Longbridge Longbridge Birmingham Birmingham NFA No Independent Evidence Available   52.3940521 -1.9807506
7944 op-snap---monthly-publication-february-2026.pdf   691 2026-02 Other Ford Fiesta Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Findon Street Findon Street Out of Force Area Out of Force Area NFA Out of Force      
8202 op-snap---monthly-publication-february-2026.pdf   949 2026-02 Other       Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4103191 -1.8670224
8221 op-snap---monthly-publication-february-2026.pdf   968 2026-02 Other Kia Sportage Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA Not in Public Interest   52.5521118 -1.8845138
8223 op-snap---monthly-publication-february-2026.pdf   970 2026-02 Other Mercedes-Benz Sprinter Red Offence to be added None Uplands Road Uplands Road Birmingham Birmingham NFA No Offence   52.5131738 -1.9434941
8259 op-snap---monthly-publication-february-2026.pdf   1006 2026-02 Other Land Rover Range Rover Gold Using a Mobile Phone Whilst Driving None U/K U/K Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.5030589 -2.0265092
8284 op-snap---monthly-publication-february-2026.pdf   1031 2026-02 Other BMW 420.. Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham NFA No Independent Evidence Available      
8286 op-snap---monthly-publication-february-2026.pdf   1033 2026-02 Other Audi   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham NFA No Independent Evidence Available      
8288 op-snap---monthly-publication-february-2026.pdf   1035 2026-02 Other Skoda Superb Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotton Park Road Rotton Park Road Birmingham Birmingham NFA No Independent Evidence Available   52.4851072 -1.9468115
8310 op-snap---monthly-publication-february-2026.pdf   1057 2026-02 Other Volkswagen   Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotton Park Road Rotton Park Road Birmingham Birmingham NFA Misc Inc Crimes   52.4851072 -1.9468115
8317 op-snap---monthly-publication-february-2026.pdf   1064 2026-02 Other Ford Transit White Driving a vehicle wholly or partly on a footpath None Highters Heath Lane. Highters Heath Lane Birmingham Birmingham NFA No VRM   52.4100972 -1.8742772
8340 op-snap---monthly-publication-february-2026.pdf   1087 2026-02 Other       Driving a vehicle wholly or partly on a footpath None Highters Heath Lane Highters Heath Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4100972 -1.8742772
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
8389 op-snap---monthly-publication-february-2026.pdf   1136 2026-02 Other Volkswagen Polo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotton Park Road Rotton Park Road Birmingham Birmingham NFA Misc Inc Crimes   52.4851072 -1.9468115
8447 op-snap---monthly-publication-february-2026.pdf   1194 2026-02 Other Volkswagen Golf Green Using a Mobile Phone Whilst Driving None Epsom High Street Epsom High Street Out of Force Area Out of Force Area NFA Out of Force      
8690 op-snap---monthly-publication-february-2026.pdf   1437 2026-02 Other     Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Metchley Lane Metchley Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4552055 -1.9461279
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      
10575 op-snap---monthly-publication-january-2026.pdf   36 2026-01 Other BMW NK White Driving without Due Care and Attention None Unknown   Dudley Dudley NFA No Independent Evidence Available      
10576 op-snap---monthly-publication-january-2026.pdf   37 2026-01 Other BMW 330E White Driving without Due Care and Attention No vehicle excise licence Tulip Avenue Tulip Avenue Dudley Dudley NFA No Independent Evidence Available      
10578 op-snap---monthly-publication-january-2026.pdf   39 2026-01 Other BMW 330E White Driving without Due Care and Attention No vehicle excise licence Tulip Avenue Tulip Avenue Dudley Dudley NFA No Independent Evidence Available      
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
10656 op-snap---monthly-publication-january-2026.pdf   117 2026-01 Other Daf Truck White Using a Mobile Phone Whilst Driving None Northcote Road Northcote Road Birmingham Birmingham NFA No Independent Evidence Available   52.4862344 -1.8128298
10713 op-snap---monthly-publication-january-2026.pdf   174 2026-01 Other Hyundai Tucson Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rough Hay Road Rough Hay Road Walsall Walsall NFA Not in Public Interest   52.5724018 -2.0424514
10753 op-snap---monthly-publication-january-2026.pdf   214 2026-01 Other Vauxhall Vivaro Black Using a Mobile Phone Whilst Driving None Fifield Road Fifield Road Birmingham Birmingham NFA No Independent Evidence Available      
10771 op-snap---monthly-publication-january-2026.pdf   232 2026-01 Other Land Rover Discovery Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Chantry Road, Moseley Chantry Road, Moseley Birmingham Birmingham NFA No Independent Evidence Available   52.4496376 -1.8915224
10843 op-snap---monthly-publication-january-2026.pdf   304 2026-01 Other Ford Fiesta Blue Driving without Due Care and Attention None Dudley Cinema Dudley Cinema Dudley Dudley NFA No Independent Evidence Available      
10844 op-snap---monthly-publication-january-2026.pdf   305 2026-01 Other Volkswagen Golf White Driving without Due Care and Attention None Dudley Cinema Dudley Cinema Dudley Dudley NFA No Independent Evidence Available      
10847 op-snap---monthly-publication-january-2026.pdf   308 2026-01 Other Skoda Kodiaq White Driving without Due Care and Attention None Star City Star City Birmingham Birmingham NFA Misc Inc Crimes   52.5054363 -1.8556273
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
10935 op-snap---monthly-publication-january-2026.pdf   396 2026-01 Other Toyota Yaris Red Cause vehicle to be left in a dangerous position None Rotton Park Road Rotton Park Road Birmingham Birmingham NFA No Independent Evidence Available   52.4851072 -1.9468115
10980 op-snap---monthly-publication-january-2026.pdf   441 2026-01 Other   Unknown Black Driving without Due Care and Attention None Hydes Road Hydes Road Sandwell Sandwell NFA No VRM   52.5538064 -2.0139199
10986 op-snap---monthly-publication-january-2026.pdf   447 2026-01 Other Mercedes-Benz A Class Silver Driving without Due Care and Attention None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available      
11004 op-snap---monthly-publication-january-2026.pdf   465 2026-01 Other BMW X3 M Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cambridge Crescent Cambridge Crescent Birmingham Birmingham NFA No Independent Evidence Available   52.4652475 -1.9056734
11007 op-snap---monthly-publication-january-2026.pdf   468 2026-01 Other BMW   White Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None Canal Court Canal Court Birmingham Birmingham NFA No VRM   52.4486586 -1.8085554
11147 op-snap---monthly-publication-january-2026.pdf   608 2026-01 Other Volkswagen Golf Grey Driving without Due Care and Attention None Dry Thistle Close (West Mercia) Dry Thistle Close (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
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
11252 op-snap---monthly-publication-january-2026.pdf   713 2026-01 Other Audi A6 Black Offence to be added Drive otherwise than in accordance with a licence Swindon Swindon Out of Force Area Out of Force Area NFA Out of Force   52.480676 -1.9595336
11282 op-snap---monthly-publication-january-2026.pdf   743 2026-01 Other Toyota Auris Black Contravening a Red Traffic Light None Cakemore Road Cakemore Road Sandwell Sandwell NFA No Independent Evidence Available   52.4784618 -2.0263474
11288 op-snap---monthly-publication-january-2026.pdf   749 2026-01 Other BMW 4 series Black Using a Mobile Phone Whilst Driving None Leeds Leeds Out of Force Area Out of Force Area NFA Out of Force   52.4799028 -1.8973135
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
11408 op-snap---monthly-publication-january-2026.pdf   869 2026-01 Other Volkswagen T Roc Black Driving without Due Care and Attention None Lysander Road Lysander Road Birmingham Birmingham NFA No Offence   52.4066385 -2.0128329
11412 op-snap---monthly-publication-january-2026.pdf   873 2026-01 Other   Off road bikes Black Driving without Due Care and Attention None Dudley Wood Road Dudley Wood Road Dudley Dudley NFA No VRM   52.4776953 -2.0859444
11413 op-snap---monthly-publication-january-2026.pdf   874 2026-01 Other Skoda Octavia Grey Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5836778 -2.0894997
11441 op-snap---monthly-publication-january-2026.pdf   902 2026-01 Other Kia Picanto Silver Offence to be added None Waterfront Carpark 7 Waterfront Carpark 7 Dudley Dudley NFA No Independent Evidence Available      
11482 op-snap---monthly-publication-january-2026.pdf   943 2026-01 Other BMW 5 Series Silver Dangerous Driving None Spring road Tyseley Spring road Tyseley Birmingham Birmingham NFA No VRM   52.444262 -1.8362585
11513 op-snap---monthly-publication-january-2026.pdf   974 2026-01 Other   Unknown   Using a Mobile Phone Whilst Driving None Unknown   Unknown Unknown NFA No VRM      
11532 op-snap---monthly-publication-january-2026.pdf   993 2026-01 Other Vauxhall Astra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bromsgrove Road (West Mercia) Bromsgrove Road (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
11620 op-snap---monthly-publication-january-2026.pdf   1081 2026-01 Other Mitsubishi Hi Lux Red No Insurance No vehicle excise licence Waterfront Merry Hill Waterfront Merry Hill Dudley Dudley NFA No Independent Evidence Available   52.4874176 -2.1129449
11624 op-snap---monthly-publication-january-2026.pdf   1085 2026-01 Other       Using a Mobile Phone Whilst Driving None No exact location given. Taken from social media. No exact location given. Taken from social media Birmingham Birmingham NFA No Independent Evidence Available      
11659 op-snap---monthly-publication-january-2026.pdf   1120 2026-01 Other Ford transit White Stop a vehicle within pelican pedestrian crossing limits none Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
11807 op-snap---monthly-publication-january-2026.pdf   1268 2026-01 Other Hyundai Tucson Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham NFA No Independent Evidence Available      
11830 op-snap---monthly-publication-january-2026.pdf   1291 2026-01 Other Mercedes-Benz C Class Grey Drive / Ride / Lead an animal on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA No VRM   52.5521118 -1.8845138
11845 op-snap---monthly-publication-january-2026.pdf   1306 2026-01 Other Volvo XC60 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotton Park Road Rotton Park Road Birmingham Birmingham NFA No Independent Evidence Available   52.4851072 -1.9468115
11846 op-snap---monthly-publication-january-2026.pdf   1307 2026-01 Other Volkswagen Golf Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No vehicle excise licence Rotten Park Road Rotten Park Road Birmingham Birmingham NFA No Independent Evidence Available      
11850 op-snap---monthly-publication-january-2026.pdf   1311 2026-01 Other Mercedes-Benz C Class Grey Drive / Ride / Lead an animal on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA No VRM   52.5521118 -1.8845138
11859 op-snap---monthly-publication-january-2026.pdf   1320 2026-01 Other Ford Transit White Contravening a Red Traffic Light None Avenue road Avenue road Birmingham Birmingham NFA No Independent Evidence Available   52.4941712 -1.8795158
11902 op-snap---monthly-publication-january-2026.pdf   1363 2026-01 Other Ford Transit Grey Misc - Non Traffic Offences None ladywood Ladywood Birmingham Birmingham NFA Misc Inc Crimes   52.4774932 -1.9233654
11925 op-snap---monthly-publication-january-2026.pdf   1386 2026-01 Other Mercedes-Benz c class Grey Driving a vehicle wholly or partly on a footpath None kingstanding road Kingstanding Road Birmingham Birmingham NFA Misc Inc Crimes   52.5521118 -1.8845138
3885 op-snap---monthly-publication-december-2025.pdf   13 2025-12 Other   BUS Blue Misc - Non Traffic Offences None Howley Grange Road Howley Grange Road Halesowen Halesowen NFA No Independent Evidence Available   52.4547899 -2.0138907
4023 op-snap---monthly-publication-december-2025.pdf   151 2025-12 Other Nissan Leaf Red Use a motor vehicle / trailer in a condition likely to cause danger of injury None Alexander Road Alexander Road Walsall Walsall NFA No Independent Evidence Available   52.5862163 -2.0204906
4064 op-snap---monthly-publication-december-2025.pdf   192 2025-12 Other Volkswagen Caddy White Driving without Due Care and Attention None Gravelly HIll Gravelly HIll Birmingham Birmingham NFA No Independent Evidence Available   52.5153884 -1.8527437
4178 op-snap---monthly-publication-december-2025.pdf   306 2025-12 Other Ford focus Black Misc - Non Traffic Offences None Arundel Road Arundel Road Birmingham Birmingham NFA No Offence   52.4032204 -1.8821733
4179 op-snap---monthly-publication-december-2025.pdf   307 2025-12 Other BMW 330E White Driving without Due Care and Attention None Metchley Lane Metchley Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4552055 -1.9461279
4187 op-snap---monthly-publication-december-2025.pdf   315 2025-12 Other Land Rover SE Black Using a Mobile Phone Whilst Driving Use vehicle on a road withou tB viramlidin tgehsat mcertificate t B viramlidin tgehsat mcertificate Birmingham Birmingham NFA No Independent Evidence Available      
4192 op-snap---monthly-publication-december-2025.pdf   320 2025-12 Other Daf Lorry Black Using a Mobile Phone Whilst Driving No Insurance Motorway unknown Motorway unknown Out of Force Area Out of Force Area NFA No Independent Evidence Available      
4407 op-snap---monthly-publication-december-2025.pdf   535 2025-12 Other Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None UK Uk Birmingham Birmingham NFA No Offence   52.45124 -1.937937
4409 op-snap---monthly-publication-december-2025.pdf   537 2025-12 Other BMW 335D Black Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA No Independent Evidence Available   52.4874281 -2.1117204
4437 op-snap---monthly-publication-december-2025.pdf   565 2025-12 Other Volkswagen     Misc - Non Traffic Offences None edmund road Edmund Road Birmingham Birmingham NFA Misc Inc Crimes   52.4876113 -1.8542201
4482 op-snap---monthly-publication-december-2025.pdf   610 2025-12 Other Vauxhall Astra Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley NFA No Independent Evidence Available      
4536 op-snap---monthly-publication-december-2025.pdf   664 2025-12 Other Peugeot 208 White Misc - Non Traffic Offences None Merlin Grove Merlin Grove Birmingham Birmingham NFA No Offence   52.4578935 -1.7820619
4537 op-snap---monthly-publication-december-2025.pdf   665 2025-12 Other BMW X3.. White Using a Mobile Phone Whilst Driving None Leamington Spa.. No other details Leamington Spa No other details .Birmingham .Birmingham NFA No Independent Evidence Available      
4553 op-snap---monthly-publication-december-2025.pdf   681 2025-12 Other BMW X1 Grey Using a Mobile Phone Whilst Driving None B4124 ROcky Lane B4124 ROcky Lane Birmingham Birmingham NFA No Independent Evidence Available      
4815 op-snap---monthly-publication-december-2025.pdf   943 2025-12 Other Audi SQ7 Grey Driving without Due Care and Attention None Greens End Road Greens End Road Coventry Coventry NFA Out of Force      
4819 op-snap---monthly-publication-december-2025.pdf   947 2025-12 Other Volkswagen Caddy Black Misc - Non Traffic Offences None Greens End Road Greens End Road Coventry Coventry NFA Out of Force      
4903 op-snap---monthly-publication-december-2025.pdf   1031 2025-12 Other Ford Fiesta Blue Misc - Non Traffic Offences None Waterfront Car Park Waterfront Car Park Dudley Dudley NFA No Independent Evidence Available      
4918 op-snap---monthly-publication-december-2025.pdf   1046 2025-12 Other Yamaha Scrambler Orange Driving without Due Care and Attention Keeping a vehicle with registr aPtoiopnla rm Aavrekns uoeb,s cured a Ptoiopnla rm Aavrekns uoeb, s cured Walsall Walsall NFA No VRM      

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