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

118 rows where disposal = "NFA", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedestrian" 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

reporter_transport_mode 1

  • Pedestrian · 118 ✖

offence 1

  • Driving without Due Care and Attention · 118 ✖

disposal 1

  • NFA · 118 ✖
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
7441 op-snap---monthly-publication-february-2026.pdf   188 2026-02 Pedestrian Hyundai I30 Black Driving without Due Care and Attention None Tachbrook Road Tachbrook Road Out of Force Area Out of Force Area NFA Out of Force      
7508 op-snap---monthly-publication-february-2026.pdf   255 2026-02 Pedestrian BMW 325D Blue Driving without Due Care and Attention None Stratford Upon Avon Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force   52.3499075 -1.7812051
7601 op-snap---monthly-publication-february-2026.pdf   348 2026-02 Pedestrian Fiat Mylife Blue Driving without Due Care and Attention None Briar Close Briar Close Out of Force Area Out of Force Area NFA Out of Force   52.5215268 -1.8348724
7914 op-snap---monthly-publication-february-2026.pdf   661 2026-02 Pedestrian Ford Focus Black Driving without Due Care and Attention None Wedgewood Road Wedgewood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4560365 -1.9936623
8035 op-snap---monthly-publication-february-2026.pdf   782 2026-02 Pedestrian Seat   Silver Driving without Due Care and Attention None Brownshore Lane Brownshore Lane Out of Force Area Out of Force Area NFA Out of Force      
8054 op-snap---monthly-publication-february-2026.pdf   801 2026-02 Pedestrian Mercedes-Benz Sprinter White Driving without Due Care and Attention None Sandford Avenue Church Stretton Sandford Avenue Church Stretton Out of Force Area Out of Force Area NFA Out of Force      
8307 op-snap---monthly-publication-february-2026.pdf   1054 2026-02 Pedestrian Mercedes-Benz   Black Driving without Due Care and Attention None Highters Heath Lane Highters Heath Lane Birmingham Birmingham NFA No VRM   52.4100972 -1.8742772
8482 op-snap---monthly-publication-february-2026.pdf   1229 2026-02 Pedestrian Vauxhall Adam Black Driving without Due Care and Attention None Mcdonalds Car Park Mcdonalds Car Park Walsall Walsall NFA No Independent Evidence Available      
8568 op-snap---monthly-publication-february-2026.pdf   1315 2026-02 Pedestrian Toyota   Blue Driving without Due Care and Attention None Sherlock Street Sherlock Street Birmingham Birmingham NFA     52.4702385 -1.895011
8758 op-snap---monthly-publication-february-2026.pdf   1505 2026-02 Pedestrian   Multiple   Driving without Due Care and Attention None Metchley lane Metchley lane Birmingham Birmingham NFA Misc Inc Crimes   52.4552055 -1.9461279
10630 op-snap---monthly-publication-january-2026.pdf   91 2026-01 Pedestrian BMW 3 series White Driving without Due Care and Attention None Navigation Street Navigation Street Walsall Walsall NFA No Independent Evidence Available   52.5842791 -1.9872353
10653 op-snap---monthly-publication-january-2026.pdf   114 2026-01 Pedestrian Hyundai I20 Grey Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham NFA No Independent Evidence Available   52.4762433 -1.9176665
10988 op-snap---monthly-publication-january-2026.pdf   449 2026-01 Pedestrian Audi A3 Blue Driving without Due Care and Attention None Boleyn Road Boleyn Road Birmingham Birmingham NFA No Offence   52.4030543 -2.0296756
11493 op-snap---monthly-publication-january-2026.pdf   954 2026-01 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None High Street High Street Birmingham Birmingham NFA No Independent Evidence Available   52.5254588 -1.8373064
11512 op-snap---monthly-publication-january-2026.pdf   973 2026-01 Pedestrian BMW 520D White Driving without Due Care and Attention None Broad Street Broad Street Out of Force Area Out of Force Area NFA Out of Force   52.474024 -1.9163084
11840 op-snap---monthly-publication-january-2026.pdf   1301 2026-01 Pedestrian Kia Sportage Black Driving without Due Care and Attention No Insurance Floodgate Street Floodgate Street Birmingham Birmingham NFA Misc Inc Crimes   52.4752856 -1.8858047
4070 op-snap---monthly-publication-december-2025.pdf   198 2025-12 Pedestrian Volkswagen Passatt Blue Driving without Due Care and Attention None Glenville Drivce Glenville Drivce Birmingham Birmingham NFA No Independent Evidence Available      
4577 op-snap---monthly-publication-december-2025.pdf   705 2025-12 Pedestrian Audi A6 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No Independent Evidence Available   52.4622646 -1.8599985
4602 op-snap---monthly-publication-december-2025.pdf   730 2025-12 Pedestrian Renault Clio Black Driving without Due Care and Attention None Shrewsbury Road Shrewsbury Road Out of Force Area Out of Force Area NFA Out of Force      
4687 op-snap---monthly-publication-december-2025.pdf   815 2025-12 Pedestrian       Driving without Due Care and Attention None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham NFA No Independent Evidence Available   52.4760986 -1.9018641
4688 op-snap---monthly-publication-december-2025.pdf   816 2025-12 Pedestrian       Driving without Due Care and Attention None Alston Street Alston Street Birmingham Birmingham NFA No Independent Evidence Available   52.4772629 -1.9267359
4936 op-snap---monthly-publication-december-2025.pdf   1064 2025-12 Pedestrian BMW 525d White Driving without Due Care and Attention None oval Oval Birmingham Birmingham NFA Misc Inc Crimes   52.4577754 -1.8692099
20536 op-snap---monthly-publication-november-2025.pdf   78 2025-11 Pedestrian   Scooter Black Driving without Due Care and Attention None Sedgley Road West Sedgley Road West Dudley Dudley NFA No VRM   52.5301627 -2.0799509
20788 op-snap---monthly-publication-november-2025.pdf   330 2025-11 Pedestrian Ford Transit White Driving without Due Care and Attention None School Bank School Bank Out of Force Area Out of Force Area NFA Out of Force   52.5149378 -2.1130096
20805 op-snap---monthly-publication-november-2025.pdf   347 2025-11 Pedestrian Volkswagen Crafter Grey Driving without Due Care and Attention None Market Place Market Place Sandwell Sandwell NFA No Independent Evidence Available   52.5303627 -2.0353018
21106 op-snap---monthly-publication-november-2025.pdf   648 2025-11 Pedestrian Volkswagen Golf Black Driving without Due Care and Attention None Alderbrooke Road Alderbrooke Road Birmingham Birmingham NFA Misc Inc Crimes      
21408 op-snap---monthly-publication-november-2025.pdf   950 2025-11 Pedestrian   Unknown Red Driving without Due Care and Attention None Sir Henry Parkes Road Sir Henry Parkes Road Coventry Coventry NFA No Offence   52.3900568 -1.5550766
21559 op-snap---monthly-publication-november-2025.pdf   1101 2025-11 Pedestrian Land Rover Range Rover Black Driving without Due Care and Attention None Leominster bypass A49 Leominster bypass A49 Out of Force Area Out of Force Area NFA Out of Force      
21735 op-snap---monthly-publication-november-2025.pdf   1277 2025-11 Pedestrian Peugeot 207.. Grey Driving without Due Care and Attention No Insurance Sherwood Road Bromsgrove. Sherwood Road Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
21852 op-snap---monthly-publication-november-2025.pdf   1394 2025-11 Pedestrian Hyundai tucson Red Driving without Due Care and Attention None regent road Regent Road Birmingham Birmingham NFA No VRM   52.5077359 -1.9452509
21919 op-snap---monthly-publication-november-2025.pdf   1461 2025-11 Pedestrian Mini Mini White Driving without Due Care and Attention None Filton Road Filton Road Out of Force Area Out of Force Area NFA Out of Force   52.5244726 -1.7880916
22210 op-snap---monthly-publication-october-2025.pdf   160 2025-10 Pedestrian   Subara Blue Driving without Due Care and Attention None Tesco Car Park, Stourbridge Tesco Car Park, Stourbridge Dudley Dudley NFA Outside of 14 Days NIP   52.4530893 -2.0628772
22235 op-snap---monthly-publication-october-2025.pdf   185 2025-10 Pedestrian     White Driving without Due Care and Attention None Newtown Newtown Birmingham Birmingham NFA No Independent Evidence Available   52.4978509 -1.8963733
22752 op-snap---monthly-publication-october-2025.pdf   702 2025-10 Pedestrian Ford Kuga White Driving without Due Care and Attention Use vehicle on a road without valid test certificate Longmore Road, Shirley Longmore Road, Shirley Solihull Solihull NFA No Offence   52.4078616 -1.8211577
22801 op-snap---monthly-publication-october-2025.pdf   751 2025-10 Pedestrian BMW   Grey Driving without Due Care and Attention None Newport Road Newport Road Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4373088 -1.504993
22928 op-snap---monthly-publication-october-2025.pdf   878 2025-10 Pedestrian Mercedes-Benz A Class White Driving without Due Care and Attention None Priory Road Priory Road Birmingham Birmingham NFA No Offence   52.4132696 -1.8555008
23229 op-snap---monthly-publication-october-2025.pdf   1179 2025-10 Pedestrian       Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Misc Inc Crimes   52.4831397 -2.1309273
24233 op-snap---monthly-publication-september-2025.pdf   452 2025-09 Pedestrian Ford S Max Grey Driving without Due Care and Attention None Aldi,Hall Green Aldi, Hall Green Birmingham Birmingham NFA No Independent Evidence Available   52.4271029 -1.8406313
24267 op-snap---monthly-publication-september-2025.pdf   486 2025-09 Pedestrian Audi R8 Black Driving without Due Care and Attention None Swallows Meadow Swallows Meadow Solihull Solihull NFA No Offence   52.3971037 -1.8160644
24503 op-snap---monthly-publication-september-2025.pdf   722 2025-09 Pedestrian Ford Fiesta Grey Driving without Due Care and Attention None Lionel Street Lionel Street Birmingham Birmingham NFA No Independent Evidence Available   52.4821516 -1.9058355
24538 op-snap---monthly-publication-september-2025.pdf   757 2025-09 Pedestrian Peugeot Partner white Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No VRM   52.4191184 -1.8326637
24545 op-snap---monthly-publication-september-2025.pdf   764 2025-09 Pedestrian Skoda   Grey Driving without Due Care and Attention None Midland Road Midland Road Birmingham Birmingham NFA No Independent Evidence Available   52.4190372 -1.9294685
2108 op-snap---monthly-publication-august-2025.pdf   83 2025-08 Pedestrian BMW   Black Driving without Due Care and Attention None Lower Valley Road Lower Valley Road Dudley Dudley NFA Outside of 14 Days NIP   52.478607 -2.1430965
2221 op-snap---monthly-publication-august-2025.pdf   196 2025-08 Pedestrian Audi Q2.. Black Driving without Due Care and Attention None A38.. A38 Birmingham Birmingham NFA No Offence      
2254 op-snap---monthly-publication-august-2025.pdf   229 2025-08 Pedestrian   Unknown   Driving without Due Care and Attention None Churchfields Churchfields Out of Force Are Out of Force Area NFA Out of Force      
2274 op-snap---monthly-publication-august-2025.pdf   249 2025-08 Pedestrian Land Rover Range Blue Driving without Due Care and Attention None Henry Street, Rugby Henry Street, Rugby Out of Force Are Out of Force Area NFA Out of Force      
2588 op-snap---monthly-publication-august-2025.pdf   563 2025-08 Pedestrian Audi A5 Grey Driving without Due Care and Attention None Lightwoods Hill Lightwoods Hill Birmingham Birmingham NFA No Independent Evidence Available      
2627 op-snap---monthly-publication-august-2025.pdf   602 2025-08 Pedestrian Peugeot 208.. Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
2778 op-snap---monthly-publication-august-2025.pdf   753 2025-08 Pedestrian Suzuki   Blue Driving without Due Care and Attention None Bushbury Avenue Bushbury Avenue Wolverhampton Wolverhampton NFA No Offence   52.6081028 -2.1237815
2801 op-snap---monthly-publication-august-2025.pdf   776 2025-08 Pedestrian Vauxhall Astra Black Driving without Due Care and Attention None M6 Manchester M6 Manchester Out of Force Are Out of Force Area NFA Out of Force      
2803 op-snap---monthly-publication-august-2025.pdf   778 2025-08 Pedestrian Toyota Corolla Silver Driving without Due Care and Attention None High Street Smethwick High Street Smethwick Sandwell Sandwell NFA No Independent Evidence Available   52.4955266 -1.9697742
2983 op-snap---monthly-publication-august-2025.pdf   958 2025-08 Pedestrian Volkswagen   Grey Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4543565 -1.9114004
3030 op-snap---monthly-publication-august-2025.pdf   1005 2025-08 Pedestrian Vauxhall Movano White Driving without Due Care and Attention None Chester Road roundabout Chester Road roundabout Sutton Coldfield Sutton Coldfield NFA Not in Public Interest      
3257 op-snap---monthly-publication-august-2025.pdf   1232 2025-08 Pedestrian Honda Motorcycle White Driving without Due Care and Attention None Stratford-upon-avon Stratford-upon-avon Out of Force Are Out of Force Area NFA Out of Force      
3350 op-snap---monthly-publication-august-2025.pdf   1325 2025-08 Pedestrian Land Rover Defender Blue Driving without Due Care and Attention None M6 North J16 M6 North J16 Out of Force Are Out of Force Area NFA Out of Force      
3746 op-snap---monthly-publication-august-2025.pdf   1721 2025-08 Pedestrian       Driving without Due Care and Attention None The Rock, Bury The Rock, Bury Out of Force Are Out of Force Area NFA No VRM      
3834 op-snap---monthly-publication-august-2025.pdf   1809 2025-08 Pedestrian       Driving without Due Care and Attention None Clarence Road Clarence Road Birmingham Birmingham NFA Misc Inc Crimes   52.5940902 -1.843503
11967 op-snap---monthly-publication-july-2025.pdf   19 2025-07 Pedestrian Seat Leon Blue Driving without Due Care and Attention None Heath Road South Heath Road South Birmingham Birmingham NFA No VRM   52.415858 -1.9632649
11974 op-snap---monthly-publication-july-2025.pdf   26 2025-07 Pedestrian Kia Sportage White Driving without Due Care and Attention None Heath Road Heath Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5977729 -2.1078698
12092 op-snap---monthly-publication-july-2025.pdf   144 2025-07 Pedestrian     White Driving without Due Care and Attention None Millennium Place Millennium Place Coventry Coventry NFA No VRM   52.4105671 -1.5087697
12099 op-snap---monthly-publication-july-2025.pdf   151 2025-07 Pedestrian Nissan Juke Red Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No Independent Evidence Available   52.4622646 -1.8599985
12107 op-snap---monthly-publication-july-2025.pdf   159 2025-07 Pedestrian Mini Mini Blue Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley NFA Outside of 14 Days NIP   52.4628538 -2.1160108
12214 op-snap---monthly-publication-july-2025.pdf   266 2025-07 Pedestrian Volkswagen Golf Blue Driving without Due Care and Attention None Bernard Road Bernard Road Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.4777838 -1.9587163
12444 op-snap---monthly-publication-july-2025.pdf   496 2025-07 Pedestrian Ford Focus Orange Driving without Due Care and Attention None Off Force Off Force Out of Force Area Out of Force Area NFA Out of Force      
12449 op-snap---monthly-publication-july-2025.pdf   501 2025-07 Pedestrian Volkswagen   White Driving without Due Care and Attention None St Gerards Street Gerards Solihull Solihull NFA Outside of 14 Days NIP      
12452 op-snap---monthly-publication-july-2025.pdf   504 2025-07 Pedestrian BMW M2 White Driving without Due Care and Attention None Tesco Blackpool Tesco Blackpool Out of Force Area Out of Force Area NFA Out of Force      
12506 op-snap---monthly-publication-july-2025.pdf   558 2025-07 Pedestrian Peugeot 207 Silver Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Birmingham Birmingham NFA No Independent Evidence Available   52.5124557 -1.8917609
12590 op-snap---monthly-publication-july-2025.pdf   642 2025-07 Pedestrian Citroen   Grey Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
12591 op-snap---monthly-publication-july-2025.pdf   643 2025-07 Pedestrian BMW   White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4831397 -2.1309273
12604 op-snap---monthly-publication-july-2025.pdf   656 2025-07 Pedestrian Ford Fiesta Brown Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
12670 op-snap---monthly-publication-july-2025.pdf   722 2025-07 Pedestrian Renault Clio Black Driving without Due Care and Attention None Turners Lane Turners Lane Dudley Dudley NFA No Independent Evidence Available   52.4721372 -2.1243522
12684 op-snap---monthly-publication-july-2025.pdf   736 2025-07 Pedestrian Seat Ibiza Black Driving without Due Care and Attention None Hobbs Moat Road Hobbs Moat Road Solihull Solihull NFA No Offence      
12689 op-snap---monthly-publication-july-2025.pdf   741 2025-07 Pedestrian Jaguar F Pace Grey Driving without Due Care and Attention None B4034 Stratford Stratford Out of Force Area Out of Force Area NFA Out of Force      
12779 op-snap---monthly-publication-july-2025.pdf   831 2025-07 Pedestrian Toyota Yaris Black Driving without Due Care and Attention None Turners Lane Turners Lane Dudley Dudley NFA No Independent Evidence Available   52.4721372 -2.1243522
12794 op-snap---monthly-publication-july-2025.pdf   846 2025-07 Pedestrian Volkswagen polo Black Driving without Due Care and Attention None Telford Telford Out of Force Area Out of Force Area NFA Out of Force   52.4979333 -1.9664857
12815 op-snap---monthly-publication-july-2025.pdf   867 2025-07 Pedestrian Mercedes-Benz S350 Silver Driving without Due Care and Attention None A3400 (Stratford Up on Avon) Warks A3400 (Stratford Up on Avon) Warks Out of Force Area Out of Force Area NFA Out of Force      
12828 op-snap---monthly-publication-july-2025.pdf   880 2025-07 Pedestrian Suzuki Jimmy Blue Driving without Due Care and Attention None Red House Avenue Red House Avenue Sandwell Sandwell NFA No Offence   52.5540383 -2.0075594
13001 op-snap---monthly-publication-july-2025.pdf   1053 2025-07 Pedestrian Mercedes-Benz   White Driving without Due Care and Attention None Russell Bank Road Russell Bank Road Birmingham Birmingham NFA No VRM   52.5941017 -1.8521585
13121 op-snap---monthly-publication-july-2025.pdf   1173 2025-07 Pedestrian Chevrolet Spark White Driving without Due Care and Attention None Malvern Malvern Out of Force Area Out of Force Area NFA Out of Force   52.4093693 -1.7713445
13362 op-snap---monthly-publication-july-2025.pdf   1414 2025-07 Pedestrian   U/K   Driving without Due Care and Attention No Insurance Northfield Northfield Birmingham Birmingham NFA No VRM   52.4082951 -1.9651246
13682 op-snap---monthly-publication-july-2025.pdf   1734 2025-07 Pedestrian       Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA No VRM   52.4831397 -2.1309273
13914 op-snap---monthly-publication-july-2025.pdf   1966 2025-07 Pedestrian Audi UK Black Driving without Due Care and Attention None coventry Coventry Coventry Coventry NFA Misc Inc Crimes   52.400739 -1.5135474
14112 op-snap---monthly-publication-june-2025.pdf   41 2025-06 Pedestrian Mercedes-Benz GLB Black Driving without Due Care and Attention None Perry Barr Train Station Perry Barr Train Station Birmingham Birmingham NFA No Independent Evidence Available      
14214 op-snap---monthly-publication-june-2025.pdf   143 2025-06 Pedestrian Ford Icecream van White Driving without Due Care and Attention None Breedon Road Breedon Road Birmingham Birmingham NFA No Independent Evidence Available   52.4191978 -1.9251219
14251 op-snap---monthly-publication-june-2025.pdf   180 2025-06 Pedestrian Seat Leon Grey Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham NFA Outside of 14 Days NIP   52.4860376 -1.9095854
14382 op-snap---monthly-publication-june-2025.pdf   311 2025-06 Pedestrian Audi A4 Blue Driving without Due Care and Attention None CHESTER ROAD Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
14437 op-snap---monthly-publication-june-2025.pdf   366 2025-06 Pedestrian Kia Ceed White Driving without Due Care and Attention None Sharmans Cross Road Sharmans Cross Road Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4167172 -1.7990388
14438 op-snap---monthly-publication-june-2025.pdf   367 2025-06 Pedestrian Audi A1 Black Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham NFA Not in Public Interest   52.4762433 -1.9176665
14459 op-snap---monthly-publication-june-2025.pdf   388 2025-06 Pedestrian Mitsubishi L200 Black Driving without Due Care and Attention None Six Ashes Road Six Ashes Road Out of Force Area Out of Force Area NFA Out of Force      
14510 op-snap---monthly-publication-june-2025.pdf   439 2025-06 Pedestrian Iveco Daily White Driving without Due Care and Attention None Minerva Road Minerva Road Out of Force Area Out of Force Area NFA Out of Force   52.4894131 -1.8524068
14899 op-snap---monthly-publication-june-2025.pdf   828 2025-06 Pedestrian   Zonte Red Driving without Due Care and Attention None Coventry Road Kenilworth Coventry Road Kenilworth Out of Force Area Out of Force Area NFA Out of Force   52.3954514 -1.5222001
14955 op-snap---monthly-publication-june-2025.pdf   884 2025-06 Pedestrian Toyota Yaris Black Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5170745 -1.9012542
15073 op-snap---monthly-publication-june-2025.pdf   1002 2025-06 Pedestrian Ford Fiesta Silver Driving without Due Care and Attention None Newfield Crescent Newfield Crescent Birmingham Birmingham NFA No Independent Evidence Available      
15104 op-snap---monthly-publication-june-2025.pdf   1033 2025-06 Pedestrian   Unknown Black Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA No VRM   52.5692139 -1.8799672
15230 op-snap---monthly-publication-june-2025.pdf   1159 2025-06 Pedestrian Ford Transit White Driving without Due Care and Attention None Breedon Road Breedon Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4191978 -1.9251219
15421 op-snap---monthly-publication-june-2025.pdf   1350 2025-06 Pedestrian Ford   Grey Driving without Due Care and Attention None King Street King Street Dudley Dudley NFA Outside of 14 Days NIP   52.5095654 -2.0806912
18988 op-snap---monthly-publication-may-2025.pdf   350 2025-05 Pedestrian Seat Leon Silver Driving without Due Care and Attention None Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
19116 op-snap---monthly-publication-may-2025.pdf   478 2025-05 Pedestrian Volkswagen polo White Driving without Due Care and Attention None Robin Hood Road Robin Hood Road Dudley Dudley NFA No Independent Evidence Available   52.4781594 -2.1049925
19130 op-snap---monthly-publication-may-2025.pdf   492 2025-05 Pedestrian BMW M4 White Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4381959 -1.8907391
19284 op-snap---monthly-publication-may-2025.pdf   646 2025-05 Pedestrian Ford Fiesta Red Driving without Due Care and Attention None Shottery Road, Stratford Upon Avon Shottery Road, Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force      

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