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

311 rows where 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 · 311 ✖

offence 1

  • Driving without Due Care and Attention · 311 ✖
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
7349 op-snap---monthly-publication-february-2026.pdf   96 2026-02 Pedestrian Nissan Juke Black Driving without Due Care and Attention None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5405351 -1.8002219
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
7912 op-snap---monthly-publication-february-2026.pdf   659 2026-02 Pedestrian Volkswagen Polo Green Driving without Due Care and Attention None Wedgewood Road Wedgewood Road Birmingham Birmingham Court N/A   52.4560365 -1.9936623
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      
8144 op-snap---monthly-publication-february-2026.pdf   891 2026-02 Pedestrian Toyota Prius Silver Driving without Due Care and Attention None Alum Rock Road Alum Rock Road Birmingham Birmingham Education N/A   52.4883936 -1.8310056
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
8334 op-snap---monthly-publication-february-2026.pdf   1081 2026-02 Pedestrian BMW X4 Black Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham Education N/A   52.4762433 -1.9176665
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      
8566 op-snap---monthly-publication-february-2026.pdf   1313 2026-02 Pedestrian Mercedes-Benz A200 Grey Driving without Due Care and Attention None Sherlock Street Sherlock Street Birmingham Birmingham Education N/A   52.4702385 -1.895011
8567 op-snap---monthly-publication-february-2026.pdf   1314 2026-02 Pedestrian Toyota   White Driving without Due Care and Attention None Sherlock Street Sherlock Street Birmingham Birmingham Education N/A   52.4702385 -1.895011
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
8585 op-snap---monthly-publication-february-2026.pdf   1332 2026-02 Pedestrian Toyota yaris Grey Driving without Due Care and Attention None Tenbury Road Tenbury Road Birmingham Birmingham Fixed Penalty N/A   52.4264041 -1.8966768
8749 op-snap---monthly-publication-february-2026.pdf   1496 2026-02 Pedestrian Volkswagen Golf Grey Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
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
8782 op-snap---monthly-publication-february-2026.pdf   1529 2026-02 Pedestrian BMW 118.. Blue Driving without Due Care and Attention None Perry Street at Potters Lane Wednesbury Perry Street at Potters Lane Wednesbury Sandwell Sandwell Warning Letter N/A   52.5004634 -1.9710382
10587 op-snap---monthly-publication-january-2026.pdf   48 2026-01 Pedestrian Yamaha gpd125 Grey Driving without Due Care and Attention None bishopsgate street Bishopsgate Street Birmingham Birmingham Warning Letter N/A   52.473986 -1.9147087
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
11132 op-snap---monthly-publication-january-2026.pdf   593 2026-01 Pedestrian Peugeot 307.. Silver Driving without Due Care and Attention No Insurance Stonor Road Stonor Road Birmingham Birmingham Court N/A   52.4176973 -1.8351247
11237 op-snap---monthly-publication-january-2026.pdf   698 2026-01 Pedestrian Toyota Prius Silver Driving without Due Care and Attention None Lichfield Road, Mere Green Lichfield Road, Mere Green Sutton Coldfield Sutton Coldfield Education N/A   52.5890813 -1.8316626
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
11664 op-snap---monthly-publication-january-2026.pdf   1125 2026-01 Pedestrian Toyota Aygo Red Driving without Due Care and Attention None Maypole Lane Maypole Lane Birmingham Birmingham Warning Letter N/A   52.4046925 -1.8764112
11755 op-snap---monthly-publication-january-2026.pdf   1216 2026-01 Pedestrian Audi Q2 Grey Driving without Due Care and Attention None Cotford Road Cotford Road Birmingham Birmingham Education N/A   52.4062317 -1.8814294
11784 op-snap---monthly-publication-january-2026.pdf   1245 2026-01 Pedestrian Ford B Max White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
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
3876 op-snap---monthly-publication-december-2025.pdf   4 2025-12 Pedestrian Toyota Corolla Silver Driving without Due Care and Attention None New John Street New John Street Birmingham Birmingham Other Action Taken No Independent Evidence Available   52.4920451 -1.8920402
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      
4513 op-snap---monthly-publication-december-2025.pdf   641 2025-12 Pedestrian Yamaha GPD125 Blue Driving without Due Care and Attention None bishopsgate street Bishopsgate Street Birmingham Birmingham Education N/A   52.473986 -1.9147087
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
4592 op-snap---monthly-publication-december-2025.pdf   720 2025-12 Pedestrian Audi s3 Blue Driving without Due Care and Attention None south parade South Parade Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5618877 -1.8226794
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      
4625 op-snap---monthly-publication-december-2025.pdf   753 2025-12 Pedestrian   Unknown Red Driving without Due Care and Attention None Mandelson Crescent Mandelson Crescent Birmingham Birmingham RTC - Actioned N/A      
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
4961 op-snap---monthly-publication-december-2025.pdf   1089 2025-12 Pedestrian Volkswagen Golf Black Driving without Due Care and Attention None Aston Church Road Aston Church Road Birmingham Birmingham RTC - Actioned N/A   52.4998848 -1.8630958
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
20885 op-snap---monthly-publication-november-2025.pdf   427 2025-11 Pedestrian Rolls-Royce Cullinan Black Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
20902 op-snap---monthly-publication-november-2025.pdf   444 2025-11 Pedestrian Ford Kuga White Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20903 op-snap---monthly-publication-november-2025.pdf   445 2025-11 Pedestrian Vauxhall Zafira Black Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20904 op-snap---monthly-publication-november-2025.pdf   446 2025-11 Pedestrian Honda FRV Grey Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
21021 op-snap---monthly-publication-november-2025.pdf   563 2025-11 Pedestrian Mercedes-Benz E300 Black Driving without Due Care and Attention None Ivanhoe Street Ivanhoe Street Birmingham Birmingham Warning Letter N/A      
21049 op-snap---monthly-publication-november-2025.pdf   591 2025-11 Pedestrian Yamaha GPD125 Red Driving without Due Care and Attention None Newtown St Newtown Street Birmingham Birmingham Court N/A   52.4964717 -1.8963477
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      
21851 op-snap---monthly-publication-november-2025.pdf   1393 2025-11 Pedestrian Ford Fiesta Blue Driving without Due Care and Attention None regent road Regent Road Birmingham Birmingham Education N/A   52.5077359 -1.9452509
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
21868 op-snap---monthly-publication-november-2025.pdf   1410 2025-11 Pedestrian Land Rover velar Blue Driving without Due Care and Attention None regent place Regent Place Birmingham Birmingham Education N/A   52.4860376 -1.9095854
21870 op-snap---monthly-publication-november-2025.pdf   1412 2025-11 Pedestrian Ford transit Grey Driving without Due Care and Attention None regent place Regent Place Birmingham Birmingham Education N/A   52.4860376 -1.9095854
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
21964 op-snap---monthly-publication-november-2025.pdf   1506 2025-11 Pedestrian BMW 3 Series White Driving without Due Care and Attention No Insurance Overfield Road Overfield Road Dudley Dudley Other Action Taken N/A   52.5062784 -2.1165195
22171 op-snap---monthly-publication-october-2025.pdf   121 2025-10 Pedestrian Yamaha GPD 125 White Driving without Due Care and Attention None Lyon Queensway Lyon Queensway Birmingham Birmingham Education N/A   52.4785129 -1.9047486
22201 op-snap---monthly-publication-october-2025.pdf   151 2025-10 Pedestrian Mazda 2 Black Driving without Due Care and Attention None Lower High Street, Stourbridge Lower High Street, Stourbridge Dudley Dudley Court N/A   52.4586871 -2.1483642
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
22305 op-snap---monthly-publication-october-2025.pdf   255 2025-10 Pedestrian BMW M140.. Yellow Driving without Due Care and Attention None Upper High Street Wednesbury Upper High Street Wednesbury Sandwell Sandwell Warning Letter N/A   52.5533962 -2.0204699
22316 op-snap---monthly-publication-october-2025.pdf   266 2025-10 Pedestrian Mercedes-Benz GLC Blue Driving without Due Care and Attention None Holly Bush Lane Holly Bush Lane Wolverhampton Wolverhampton Warning Letter N/A      
22553 op-snap---monthly-publication-october-2025.pdf   503 2025-10 Pedestrian Mercedes-Benz   Silver Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham RTC - Actioned N/A   52.4422505 -1.8539684
22660 op-snap---monthly-publication-october-2025.pdf   610 2025-10 Pedestrian Skoda Kamiq Grey Driving without Due Care and Attention None Burtons Way Burtons Way Birmingham Birmingham Education N/A      
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
23184 op-snap---monthly-publication-october-2025.pdf   1134 2025-10 Pedestrian Audi A3 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
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
23303 op-snap---monthly-publication-october-2025.pdf   1253 2025-10 Pedestrian Suzuki UZ 125 Red Driving without Due Care and Attention None Bishopsgate Street Bishopsgate Street Birmingham Birmingham Warning Letter N/A   52.473986 -1.9147087
23576 op-snap---monthly-publication-october-2025.pdf   1526 2025-10 Pedestrian Mercedes-Benz C200 White Driving without Due Care and Attention None Walford Road Walford Road Birmingham Birmingham Warning Letter N/A   52.4594072 -1.8658859
23734 op-snap---monthly-publication-october-2025.pdf   1684 2025-10 Pedestrian Volkswagen Tiguan White Driving without Due Care and Attention None Newton Shipping Centre Newton Shipping Centre Birmingham Birmingham Warning Letter N/A      
23738 op-snap---monthly-publication-october-2025.pdf   1688 2025-10 Pedestrian BMW 520D White Driving without Due Care and Attention None Oxford Road Oxford Road Birmingham Birmingham Warning Letter N/A   52.4456323 -1.8858352
23810 op-snap---monthly-publication-september-2025.pdf   29 2025-09 Pedestrian Kia Rio Red Driving without Due Care and Attention None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
24181 op-snap---monthly-publication-september-2025.pdf   400 2025-09 Pedestrian Volvo V50 Blue Driving without Due Care and Attention None Farrington Road Farrington Road Wolverhampton Wolverhampton Warning Letter N/A   52.5550312 -2.1191799
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
24660 op-snap---monthly-publication-september-2025.pdf   879 2025-09 Pedestrian Mercedes-Benz A-class Silver Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
24712 op-snap---monthly-publication-september-2025.pdf   931 2025-09 Pedestrian Vauxhall Caddy White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
24949 op-snap---monthly-publication-september-2025.pdf   1168 2025-09 Pedestrian BMW 335D Silver Driving without Due Care and Attention No vehicle excise licence Bishopsgate Street Bishopsgate Street Birmingham Birmingham Court N/A   52.473986 -1.9147087
24964 op-snap---monthly-publication-september-2025.pdf   1183 2025-09 Pedestrian Volvo Tipper White Driving without Due Care and Attention None Honiley ROad Honiley ROad Birmingham Birmingham Warning Letter N/A   52.4789688 -1.7931848
25009 op-snap---monthly-publication-september-2025.pdf   1228 2025-09 Pedestrian BMW 1 Series White Driving without Due Care and Attention None M6 southbound M6 southbound Birmingham Birmingham Warning Letter N/A      
25177 op-snap---monthly-publication-september-2025.pdf   1396 2025-09 Pedestrian Renault Trafic Grey Driving without Due Care and Attention None CLay Lane CLay Lane Birmingham Birmingham Warning Letter N/A   52.4509038 -1.8083784
25245 op-snap---monthly-publication-september-2025.pdf   1464 2025-09 Pedestrian Honda CBF Red Driving without Due Care and Attention None Wood Common Grange Wood Common Grange Walsall Walsall Warning Letter N/A   52.6319931 -1.9785842
25364 op-snap---monthly-publication-september-2025.pdf   1583 2025-09 Pedestrian Mercedes-Benz Sprinter White Driving without Due Care and Attention none Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A   52.4762784 -1.9678366
25417 op-snap---monthly-publication-september-2025.pdf   1636 2025-09 Pedestrian Peugeot Partner White Driving without Due Care and Attention None Mossfield Rd Mossfield Road Birmingham Birmingham Warning Letter N/A   52.4305104 -1.8890824
25588 op-snap---monthly-publication-september-2025.pdf   1807 2025-09 Pedestrian Peugeot Expert White Driving without Due Care and Attention None Yardley Road Yardley Road Birmingham Birmingham Warning Letter N/A   52.4613544 -1.8160137
2051 op-snap---monthly-publication-august-2025.pdf   26 2025-08 Pedestrian Ford Fiesta Yellow Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Education N/A      
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
2138 op-snap---monthly-publication-august-2025.pdf   113 2025-08 Pedestrian Volvo XC60 Grey Driving without Due Care and Attention None Sandyfields Road Sandyfields Road Dudley Dudley Education N/A   52.5334161 -2.1371465
2146 op-snap---monthly-publication-august-2025.pdf   121 2025-08 Pedestrian Volkswagen Tiguan Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Walsall Walsall Fixed Penalty N/A   52.5723244 -1.9607214
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      

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