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

133 rows where council_area = "Dudley", disposal = "Warning Letter" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 1

  • Car · 133 ✖

disposal 1

  • Warning Letter · 133 ✖

council_area 1

  • Dudley · 133 ✖
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
7418 op-snap---monthly-publication-february-2026.pdf   165 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Venture Way Venture Way Dudley Dudley Warning Letter N/A   52.4836603 -2.1189326
7614 op-snap---monthly-publication-february-2026.pdf   361 2026-02 Car Mg HS Red Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley Warning Letter N/A   52.4881161 -2.1199108
7615 op-snap---monthly-publication-february-2026.pdf   362 2026-02 Car Vauxhall Astra Black Contravening a Red Traffic Light None A491 A491 Dudley Dudley Warning Letter N/A      
7630 op-snap---monthly-publication-february-2026.pdf   377 2026-02 Car Mitsubishi Outlander Black Contravening a Red Traffic Light None Stourbridge Road Stourbridge Road Dudley Dudley Warning Letter N/A   52.5002997 -2.1081386
7742 op-snap---monthly-publication-february-2026.pdf   489 2026-02 Car Vauxhall Corsa Orange Driving without Due Care and Attention None High Street, Stourbridge High Street, Stourbridge Dudley Dudley Warning Letter N/A   52.4570763 -2.1136199
8682 op-snap---monthly-publication-february-2026.pdf   1429 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None The Broadway Stourbridge The Broadway Stourbridge Dudley Dudley Warning Letter N/A   52.4411413 -2.1695219
10958 op-snap---monthly-publication-january-2026.pdf   419 2026-01 Car Audi A3 grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate Cinder Bank Island, Netherton Cinder Bank Island, Netherton Dudley Dudley Warning Letter N/A   52.5004694 -2.0904035
10963 op-snap---monthly-publication-january-2026.pdf   424 2026-01 Car Scania Tipper Yellow Contravening a Red Traffic Light None Birmingham Road Birmingham Road Dudley Dudley Warning Letter N/A   52.5131355 -2.0651615
11365 op-snap---monthly-publication-january-2026.pdf   826 2026-01 Car Vauxhall Corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moor Green Lane Moor Green Lane Dudley Dudley Warning Letter N/A      
11415 op-snap---monthly-publication-january-2026.pdf   876 2026-01 Car Audi SQ5 Blue Driving without Due Care and Attention None The Broadwway The Broadwway Dudley Dudley Warning Letter N/A      
11442 op-snap---monthly-publication-january-2026.pdf   903 2026-01 Car BMW 220i Blue Driving without Due Care and Attention None Greenfields Greenfields Dudley Dudley Warning Letter N/A   52.4938043 -2.1639183
11443 op-snap---monthly-publication-january-2026.pdf   904 2026-01 Car Volkswagen T Cross White Driving without Due Care and Attention None Stream Road Stream Road Dudley Dudley Warning Letter N/A   52.4871725 -2.1623764
4069 op-snap---monthly-publication-december-2025.pdf   197 2025-12 Car Kia Picanto White Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
4184 op-snap---monthly-publication-december-2025.pdf   312 2025-12 Car Lexus RX Black Driving without Due Care and Attention None The Boulevard Brierley Hill The Boulevard Brierley Hill Dudley Dudley Warning Letter N/A   52.4788849 -2.1125394
4514 op-snap---monthly-publication-december-2025.pdf   642 2025-12 Car Kia rio Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None silvertrees road Silvertrees Road Dudley Dudley Warning Letter N/A   52.5263871 -2.0677928
4911 op-snap---monthly-publication-december-2025.pdf   1039 2025-12 Car Nissan Micra Silver Contravening a Red Traffic Light None New Birmingham Road New Birmingham Road Dudley Dudley Warning Letter N/A   52.5123958 -2.0585145
4965 op-snap---monthly-publication-december-2025.pdf   1093 2025-12 Car Vauxhall Mokka Black Contravening a Red Traffic Light None Stroubridge Road Stroubridge Road Dudley Dudley Warning Letter N/A      
4998 op-snap---monthly-publication-december-2025.pdf   1126 2025-12 Car Peugeot 308cc Red Driving without Due Care and Attention None Pedmore Road Pedmore Road Dudley Dudley Warning Letter N/A   52.4897451 -2.1069141
5078 op-snap---monthly-publication-december-2025.pdf   1206 2025-12 Car Volvo XC40 Black Driving without Due Care and Attention None Black Country New Road Black Country New Road Dudley Dudley Warning Letter N/A      
20830 op-snap---monthly-publication-november-2025.pdf   372 2025-11 Car Audi A7 White VRM fails to conform to Regulations None Sedgley Town Centre Sedgley Town Centre Dudley Dudley Warning Letter N/A      
20895 op-snap---monthly-publication-november-2025.pdf   437 2025-11 Car Volvo XC60 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grange Lane Grange Lane Dudley Dudley Warning Letter N/A   52.4505457 -2.1266938
20961 op-snap---monthly-publication-november-2025.pdf   503 2025-11 Car Honda civic Red Cause vehicle to be left in a dangerous position None regend road Regend Road Dudley Dudley Warning Letter N/A      
21036 op-snap---monthly-publication-november-2025.pdf   578 2025-11 Car Land Rover Evoque White Stop a vehicle on pedestrian crossing None Lower Church Lane Lower Church Lane Dudley Dudley Warning Letter N/A   52.5264111 -2.0472971
21045 op-snap---monthly-publication-november-2025.pdf   587 2025-11 Car Renault clio Orange Cause vehicle to be left in a dangerous position None hobbs road Hobbs Road Dudley Dudley Warning Letter N/A   52.5225246 -2.0764333
21067 op-snap---monthly-publication-november-2025.pdf   609 2025-11 Car Toyota corolla Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None hobbs road Hobbs Road Dudley Dudley Warning Letter N/A   52.5225246 -2.0764333
21082 op-snap---monthly-publication-november-2025.pdf   624 2025-11 Car Honda Jazz Blue Driving without Due Care and Attention None Birmingham Road Birmingham Road Dudley Dudley Warning Letter N/A   52.5131355 -2.0651615
21401 op-snap---monthly-publication-november-2025.pdf   943 2025-11 Car Vauxhall astra Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None titiford road Titiford Road Dudley Dudley Warning Letter N/A      
21519 op-snap---monthly-publication-november-2025.pdf   1061 2025-11 Car Hyundai I10 Silver Driving without Due Care and Attention None Westland Gardens Westland Gardens Dudley Dudley Warning Letter N/A   52.4638535 -2.1506664
21571 op-snap---monthly-publication-november-2025.pdf   1113 2025-11 Car Toyota   White Driving without Due Care and Attention None Cinder Bank Cinder Bank Dudley Dudley Warning Letter N/A   52.4951209 -2.0924902
21676 op-snap---monthly-publication-november-2025.pdf   1218 2025-11 Car Seat Ibiza Blue Driver not in position to have Proper Control None High Street, Wordsley High Street, Wordsley Dudley Dudley Warning Letter N/A   52.4778645 -2.1594686
22154 op-snap---monthly-publication-october-2025.pdf   104 2025-10 Car Land Rover Sport Black Driving without Due Care and Attention None A456 A456 Dudley Dudley Warning Letter N/A      
22170 op-snap---monthly-publication-october-2025.pdf   120 2025-10 Car Vauxhall Corsa White Contravening a Red Traffic Light None Birmingham Road Birmingham Road Dudley Dudley Warning Letter N/A   52.5131355 -2.0651615
22199 op-snap---monthly-publication-october-2025.pdf   149 2025-10 Car Vauxhall Astra Red Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley Warning Letter N/A   52.4628538 -2.1160108
22246 op-snap---monthly-publication-october-2025.pdf   196 2025-10 Car Nissan Qashqai Silver Driving without Due Care and Attention None Wolverhampton Road East Wolverhampton Road East Dudley Dudley Warning Letter N/A      
22339 op-snap---monthly-publication-october-2025.pdf   289 2025-10 Car Ford Transit Blue Driving a vehicle wholly or partly on a footpath None South Road Wollaston South Road Wollaston Dudley Dudley Warning Letter N/A   52.4520277 -2.1653372
22406 op-snap---monthly-publication-october-2025.pdf   356 2025-10 Car Volkswagen Golf White Driving without Due Care and Attention None a459 A459 Dudley Dudley Warning Letter N/A      
22916 op-snap---monthly-publication-october-2025.pdf   866 2025-10 Car Mercedes-Benz Sprinter White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None High Street, High Street Dudley Dudley Warning Letter N/A   52.4779764 -2.1598371
23254 op-snap---monthly-publication-october-2025.pdf   1204 2025-10 Car Audi A1 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None New John St New John Street Dudley Dudley Warning Letter N/A   52.4713277 -2.0384732
23293 op-snap---monthly-publication-october-2025.pdf   1243 2025-10 Car Toyota prius Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None tividale road Tividale Road Dudley Dudley Warning Letter N/A   52.5132412 -2.0618845
23315 op-snap---monthly-publication-october-2025.pdf   1265 2025-10 Car Mg HS White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tividale hall school Tividale hall school Dudley Dudley Warning Letter N/A      
23362 op-snap---monthly-publication-october-2025.pdf   1312 2025-10 Car Hyundai santa fe Green Cause vehicle to be left in a dangerous position None school furnace lane School Furnace Lane Dudley Dudley Warning Letter N/A   52.4536097 -2.0510246
23448 op-snap---monthly-publication-october-2025.pdf   1398 2025-10 Car Toyota chr Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None gayfield avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
23580 op-snap---monthly-publication-october-2025.pdf   1530 2025-10 Car Audi A5 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymoor Primary School Whithymoor Primary School Dudley Dudley Warning Letter N/A      
23581 op-snap---monthly-publication-october-2025.pdf   1531 2025-10 Car Vauxhall Astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymor Primary School Whithymor Primary School Dudley Dudley Warning Letter N/A      
23582 op-snap---monthly-publication-october-2025.pdf   1532 2025-10 Car Audi A4 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymoor Primary School Whithymoor Primary School Dudley Dudley Warning Letter N/A      
23890 op-snap---monthly-publication-september-2025.pdf   109 2025-09 Car Chevrolet Orlando Silver Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
23917 op-snap---monthly-publication-september-2025.pdf   136 2025-09 Car Suzuki GSXS Black Driving without Due Care and Attention None A449 A449 Dudley Dudley Warning Letter N/A      
24230 op-snap---monthly-publication-september-2025.pdf   449 2025-09 Car Land Rover Evoque White Driving without Due Care and Attention None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Warning Letter N/A   52.4722518 -2.1552954
24436 op-snap---monthly-publication-september-2025.pdf   655 2025-09 Car Hyundai I30 Silver Driving without Due Care and Attention None Manor Park Manor Park Dudley Dudley Warning Letter N/A   52.4961407 -2.1668754
24795 op-snap---monthly-publication-september-2025.pdf   1014 2025-09 Car Kia Venga Silver Driving without Due Care and Attention None Bowers Lane Bowers Lane Dudley Dudley Warning Letter N/A      
24870 op-snap---monthly-publication-september-2025.pdf   1089 2025-09 Car BMW 320.. White Driving without Due Care and Attention None Mucklow Hill Mucklow Hill Dudley Dudley Warning Letter N/A   52.461008 -2.0345574
24900 op-snap---monthly-publication-september-2025.pdf   1119 2025-09 Car Renault Trafic Black Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
25211 op-snap---monthly-publication-september-2025.pdf   1430 2025-09 Car Ford Ranger Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Whithymoor primary school Whithymoor primary school Dudley Dudley Warning Letter N/A      
25241 op-snap---monthly-publication-september-2025.pdf   1460 2025-09 Car Audi A3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Roberts St Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
25264 op-snap---monthly-publication-september-2025.pdf   1483 2025-09 Car Volkswagen Polo White VRM fails to conform to Regulations None Wollescote Road Wollescote Road Dudley Dudley Warning Letter N/A   52.4471527 -2.1236271
25316 op-snap---monthly-publication-september-2025.pdf   1535 2025-09 Car Mg 3 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Dudley Dudley Warning Letter N/A      
25317 op-snap---monthly-publication-september-2025.pdf   1536 2025-09 Car Audi q3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Dudley Dudley Warning Letter N/A      
25318 op-snap---monthly-publication-september-2025.pdf   1537 2025-09 Car Toyota Rav4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Dudley Dudley Warning Letter N/A      
25402 op-snap---monthly-publication-september-2025.pdf   1621 2025-09 Car Mg HS Trophy White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Clifton Street Clifton Street Dudley Dudley Warning Letter N/A   52.5433505 -2.1042345
25561 op-snap---monthly-publication-september-2025.pdf   1780 2025-09 Car Ford   Grey Cause vehicle to be left in a dangerous position None roberts road Roberts Road Dudley Dudley Warning Letter N/A   52.5246963 -2.1150892
2102 op-snap---monthly-publication-august-2025.pdf   77 2025-08 Car BMW 320.. Blue Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
2393 op-snap---monthly-publication-august-2025.pdf   368 2025-08 Car Kia Sportage Grey Driving without Reasonable Consideration None Wolverhampton Road Wolverhampton Road Dudley Dudley Warning Letter N/A   52.5063917 -2.1711502
2597 op-snap---monthly-publication-august-2025.pdf   572 2025-08 Car Volkswagen Crafter White Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
2855 op-snap---monthly-publication-august-2025.pdf   830 2025-08 Car Nissan Primastar Grey Driving without Reasonable Consideration None St Andrews Road Street Andrews Road Dudley Dudley Warning Letter N/A      
2857 op-snap---monthly-publication-august-2025.pdf   832 2025-08 Car Mercedes-Benz A class Silver Driving without Reasonable Consideration None St Andrews Street, Netherton Street Andrews Street, Netherton Dudley Dudley Warning Letter N/A   52.4905847 -2.0868385
2860 op-snap---monthly-publication-august-2025.pdf   835 2025-08 Car Skoda Karoq White Driving without Reasonable Consideration None St Andrews Road Street Andrews Road Dudley Dudley Warning Letter N/A      
2884 op-snap---monthly-publication-august-2025.pdf   859 2025-08 Car Vauxhall Astra White Driving without Due Care and Attention None Brettle Lane Brettle Lane Dudley Dudley Warning Letter N/A      
2999 op-snap---monthly-publication-august-2025.pdf   974 2025-08 Car Mitsubishi Mirage Blue Contravening a Red Traffic Light None Brettel Lane Brettel Lane Dudley Dudley Warning Letter N/A      
3035 op-snap---monthly-publication-august-2025.pdf   1010 2025-08 Car Volkswagen T Roc Black Driving without Due Care and Attention None Robert Street Robert Street Dudley Dudley Warning Letter N/A   52.5221845 -2.1196502
3037 op-snap---monthly-publication-august-2025.pdf   1012 2025-08 Car Audi A1 Blue Driving without Due Care and Attention None Stourbridge Ringroad Stourbridge Ringroad Dudley Dudley Warning Letter N/A      
3208 op-snap---monthly-publication-august-2025.pdf   1183 2025-08 Car Kia Picanto Blue Driving without Due Care and Attention None Stream Road Stream Road Dudley Dudley Warning Letter N/A   52.4871725 -2.1623764
3332 op-snap---monthly-publication-august-2025.pdf   1307 2025-08 Car Ford Focus Silver Driver not in position to have Proper Control None Burnt Tree road Burnt Tree road Dudley Dudley Warning Letter N/A   52.5126298 -2.065062
3413 op-snap---monthly-publication-august-2025.pdf   1388 2025-08 Car Audi a4 Blue Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None Junglebugs rowley regis Junglebugs rowley regis Dudley Dudley Warning Letter N/A      
3459 op-snap---monthly-publication-august-2025.pdf   1434 2025-08 Car BMW X5 Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Warning Letter N/A   52.5478387 -2.0943116
3583 op-snap---monthly-publication-august-2025.pdf   1558 2025-08 Car Vauxhall combi Blue Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Horsley field Horsley field Dudley Dudley Warning Letter N/A      
13260 op-snap---monthly-publication-july-2025.pdf   1312 2025-07 Car Volvo XC60 Grey Cause vehicle to be left in a dangerous position None Roberts St Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
13261 op-snap---monthly-publication-july-2025.pdf   1313 2025-07 Car Volkswagen T-Roc Grey Cause vehicle to be left in a dangerous position None Roberts St Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
13278 op-snap---monthly-publication-july-2025.pdf   1330 2025-07 Car Ford Fiesta Blue Cause vehicle to be left in a dangerous position None Sevendwellings View Sevendwellings View Dudley Dudley Warning Letter N/A   52.4740529 -2.1270111
13572 op-snap---monthly-publication-july-2025.pdf   1624 2025-07 Car Kia Rio White Driving without Due Care and Attention None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Warning Letter N/A   52.4590366 -2.1465735
13651 op-snap---monthly-publication-july-2025.pdf   1703 2025-07 Car Volkswagen Fox Black Driving without Due Care and Attention None High Street, Dudley High Street, Dudley Dudley Dudley Warning Letter N/A   52.4503499 -2.0504997
13659 op-snap---monthly-publication-july-2025.pdf   1711 2025-07 Car Nissan X-Trail Black Cause vehicle to be left in a dangerous position None strourbridge ring road Strourbridge Ring Road Dudley Dudley Warning Letter N/A      
13660 op-snap---monthly-publication-july-2025.pdf   1712 2025-07 Car Ford Focus Black Cause vehicle to be left in a dangerous position None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Warning Letter N/A   52.4590366 -2.1465735
13868 op-snap---monthly-publication-july-2025.pdf   1920 2025-07 Car Nissan qashqai Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stourbridge Road Stourbridge Road Dudley Dudley Warning Letter N/A   52.5002997 -2.1081386
13888 op-snap---monthly-publication-july-2025.pdf   1940 2025-07 Car BMW 5 Series White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None White Hall Road White Hall Road Dudley Dudley Warning Letter N/A      
13889 op-snap---monthly-publication-july-2025.pdf   1941 2025-07 Car Ford Fiesta Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None White Hall Road White Hall Road Dudley Dudley Warning Letter N/A      
13993 op-snap---monthly-publication-july-2025.pdf   2045 2025-07 Car Nissan Juke White Driving a vehicle wholly or partly on a footpath None High street, princes end High street, princes end Dudley Dudley Warning Letter N/A   52.5260689 -2.0738642
16077 op-snap---monthly-publication-june-2025.pdf   2006 2025-06 Car Honda NSC-110 White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165
16079 op-snap---monthly-publication-june-2025.pdf   2008 2025-06 Car Volvo XC60 White Cause vehicle to be left in a dangerous position None Sweetpool Lane Sweetpool Lane Dudley Dudley Warning Letter N/A      
16083 op-snap---monthly-publication-june-2025.pdf   2012 2025-06 Car Ford Ecosport Blue Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Norwood Road Norwood Road Dudley Dudley Warning Letter N/A   52.4831397 -2.1309273
16118 op-snap---monthly-publication-june-2025.pdf   2047 2025-06 Car Fiat punto Grey Cause vehicle to be left in a dangerous position None Roberts Street Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
16233 op-snap---monthly-publication-june-2025.pdf   2162 2025-06 Car Fiat Punto Grey Cause vehicle to be left in a dangerous position None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
19431 op-snap---monthly-publication-may-2025.pdf   793 2025-05 Car Vauxhall Corsa Black Driving without Due Care and Attention None Level Street Level Street Dudley Dudley Warning Letter N/A   52.4850236 -2.1088919
19463 op-snap---monthly-publication-may-2025.pdf   825 2025-05 Car Audi A4 Silver Contravening a Red Traffic Light None A449 A449 Dudley Dudley Warning Letter N/A      
20162 op-snap---monthly-publication-may-2025.pdf   1524 2025-05 Car Mini Cooper s Black Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Warning Letter N/A   52.4624413 -2.0175178
20192 op-snap---monthly-publication-may-2025.pdf   1554 2025-05 Car Vauxhall Astra grey Driving without Due Care and Attention none Prescot Road Prescot Road Dudley Dudley Warning Letter N/A   52.448888 -2.1286977
20196 op-snap---monthly-publication-may-2025.pdf   1558 2025-05 Car Ford Ranger White Dangerous Driving none Worcester Street Worcester Street Dudley Dudley Warning Letter N/A   52.4507058 -2.1503743
20227 op-snap---monthly-publication-may-2025.pdf   1589 2025-05 Car Skoda Fabia Silver Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Warning Letter N/A   52.4624413 -2.0175178
20235 op-snap---monthly-publication-may-2025.pdf   1597 2025-05 Car Kia   Grey Using a Mobile Phone Whilst Driving None George Road George Road Dudley Dudley Warning Letter N/A   52.451966 -2.065151
20239 op-snap---monthly-publication-may-2025.pdf   1601 2025-05 Car Ford Mondeo Silver Driving without Due Care and Attention None Norwood Road, Brierley Hill Norwood Road, Brierley Hill Dudley Dudley Warning Letter N/A   52.4831397 -2.1309273
20265 op-snap---monthly-publication-may-2025.pdf   1627 2025-05 Car Volvo XC60 Grey Driving without Due Care and Attention None Balds Lane Balds Lane Dudley Dudley Warning Letter N/A   52.455416 -2.1051567

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