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

157 rows where council_area = "Dudley", offence = "Contravening a Red Traffic Light" 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 · 157 ✖

offence 1

  • Contravening a Red Traffic Light · 157 ✖

council_area 1

  • Dudley · 157 ✖
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
7304 op-snap---monthly-publication-february-2026.pdf   51 2026-02 Car     White Contravening a Red Traffic Light None High Street Wordesley High Street Wordesley Dudley Dudley NFA No Independent Evidence Available      
7371 op-snap---monthly-publication-february-2026.pdf   118 2026-02 Car Land Rover Evoque Beige Contravening a Red Traffic Light None Venture Way Venture Way Dudley Dudley Education N/A   52.4836603 -2.1189326
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
7734 op-snap---monthly-publication-february-2026.pdf   481 2026-02 Car Vauxhall Meriva Black Contravening a Red Traffic Light None High Street, Wordsley High Street, Wordsley Dudley Dudley Education N/A   52.4778645 -2.1594686
7735 op-snap---monthly-publication-february-2026.pdf   482 2026-02 Car Ford Mondeo Grey Contravening a Red Traffic Light None High Street, Wordsley High Street, Wordsley Dudley Dudley Education N/A   52.4778645 -2.1594686
7872 op-snap---monthly-publication-february-2026.pdf   619 2026-02 Car Seat Ibiza White Contravening a Red Traffic Light None Brettle Lane, Brierley Hill Brettle Lane, Brierley Hill Dudley Dudley Education N/A      
8061 op-snap---monthly-publication-february-2026.pdf   808 2026-02 Car Volkswagen Golf Silver Contravening a Red Traffic Light None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Fixed Penalty N/A   52.4590366 -2.1465735
8479 op-snap---monthly-publication-february-2026.pdf   1226 2026-02 Car BMW 330D White Contravening a Red Traffic Light None Bunns Lane Bunns Lane Dudley Dudley Education N/A   52.5111371 -2.0643295
10789 op-snap---monthly-publication-january-2026.pdf   250 2026-01 Car Mercedes-Benz C250 White Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA Not in Public Interest   52.5047428 -2.0823754
10790 op-snap---monthly-publication-january-2026.pdf   251 2026-01 Car Land Rover Discovery Black Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Independent Evidence Available   52.5047428 -2.0823754
10897 op-snap---monthly-publication-january-2026.pdf   358 2026-01 Car Vauxhall Astra Silver Contravening a Red Traffic Light None Commonside Commonside Dudley Dudley Fixed Penalty N/A   52.4931112 -2.1326078
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
11280 op-snap---monthly-publication-january-2026.pdf   741 2026-01 Car Renault Clio Beige Contravening a Red Traffic Light None Venture Way Brierley Hill Venture Way Brierley Hill Dudley Dudley Education N/A   52.4845535 -2.1206737
11681 op-snap---monthly-publication-january-2026.pdf   1142 2026-01 Car Ford Ranger Black Contravening a Red Traffic Light None Venture Way Venture Way Dudley Dudley Fixed Penalty N/A   52.4836603 -2.1189326
11706 op-snap---monthly-publication-january-2026.pdf   1167 2026-01 Car Hyundai i20 White Contravening a Red Traffic Light None Racecourse Lane Racecourse Lane Dudley Dudley Education N/A   52.4377169 -2.1495045
3991 op-snap---monthly-publication-december-2025.pdf   119 2025-12 Car Ford Transit White Contravening a Red Traffic Light None Factory Road Factory Road Dudley Dudley Education N/A   52.5324055 -2.0739923
3992 op-snap---monthly-publication-december-2025.pdf   120 2025-12 Car Mercedes-Benz Vito White Contravening a Red Traffic Light None Factory Road Factory Road Dudley Dudley Education N/A   52.5324055 -2.0739923
4084 op-snap---monthly-publication-december-2025.pdf   212 2025-12 Car Ford Focus Grey Contravening a Red Traffic Light None Brockmoor High St Brockmoor High Street Dudley Dudley NFA No Independent Evidence Available      
4424 op-snap---monthly-publication-december-2025.pdf   552 2025-12 Car Toyota Yaris Red Contravening a Red Traffic Light None High Street (A491), Stourbridge High Street (A491), Stourbridge Dudley Dudley Education N/A   52.4602651 -2.1490725
4633 op-snap---monthly-publication-december-2025.pdf   761 2025-12 Car Audi A3 Blue Contravening a Red Traffic Light None Hickman Road Hickman Road Dudley Dudley Education N/A   52.4878144 -2.1286751
4761 op-snap---monthly-publication-december-2025.pdf   889 2025-12 Car Seat Toledo Blue Contravening a Red Traffic Light None A4123 Black Country New Road Black Country New Road Dudley Dudley Education N/A      
4828 op-snap---monthly-publication-december-2025.pdf   956 2025-12 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None A491 High Street, Amblecote High Street, Amblecote Dudley Dudley Education N/A   52.461983 -2.1492141
4831 op-snap---monthly-publication-december-2025.pdf   959 2025-12 Car Ford Focus Blue Contravening a Red Traffic Light None John Street Brierley Hill John Street Brierley Hill Dudley Dudley NFA Outside of 14 Days NIP   52.4875113 -2.1217558
4873 op-snap---monthly-publication-december-2025.pdf   1001 2025-12 Car BMW 530D Black Contravening a Red Traffic Light None Cinder Bank Cinder Bank Dudley Dudley NFA Outside of 14 Days NIP   52.4951209 -2.0924902
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      
20575 op-snap---monthly-publication-november-2025.pdf   117 2025-11 Car   Van Black Contravening a Red Traffic Light None Wellington Road Wellington Road Dudley Dudley NFA Misc Inc Crimes   52.5072771 -2.0954756
20632 op-snap---monthly-publication-november-2025.pdf   174 2025-11 Car   N/K   Contravening a Red Traffic Light None Merry Hill Brierley Hill Merry Hill Brierley Hill Dudley Dudley NFA No VRM   52.4817646 -2.1113435
20825 op-snap---monthly-publication-november-2025.pdf   367 2025-11 Car BMW 320.. Blue Contravening a Red Traffic Light None Worcester Lane Stourbridge Worcester Lane Stourbridge Dudley Dudley Education N/A   52.4336498 -2.1403487
21317 op-snap---monthly-publication-november-2025.pdf   859 2025-11 Car Vauxhall Corsa Black Contravening a Red Traffic Light None High Street, Amblecote High Street, Amblecote Dudley Dudley Education N/A   52.461983 -2.1492141
21762 op-snap---monthly-publication-november-2025.pdf   1304 2025-11 Car Ford Fiesta White Contravening a Red Traffic Light None Bloomfield Road Bloomfield Road Dudley Dudley Education N/A   52.5377733 -2.0733724
21950 op-snap---monthly-publication-november-2025.pdf   1492 2025-11 Car Volkswagen Golf Black Contravening a Red Traffic Light None Jews Lane Lower Gornal Jews Lane Lower Gornal Dudley Dudley Education N/A   52.5253578 -2.1124896
22038 op-snap---monthly-publication-november-2025.pdf   1580 2025-11 Car Volkswagen Polo White Contravening a Red Traffic Light None Limes Road Dudley Limes Road Dudley Dudley Dudley Education N/A   52.5176816 -2.0931862
22169 op-snap---monthly-publication-october-2025.pdf   119 2025-10 Car Vauxhall Grandland Black Contravening a Red Traffic Light None Trindle Road Trindle Road Dudley Dudley Education N/A   52.5126263 -2.0755358
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
22318 op-snap---monthly-publication-october-2025.pdf   268 2025-10 Car Citroen C1 Grey Contravening a Red Traffic Light None Bath Road Bath Road Dudley Dudley NFA No Independent Evidence Available   52.4552307 -2.1496182
22465 op-snap---monthly-publication-october-2025.pdf   415 2025-10 Car Vauxhall Corsa Black Contravening a Red Traffic Light None Birmingham New Road Birmingham New Road Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.5478387 -2.0943116
22497 op-snap---monthly-publication-october-2025.pdf   447 2025-10 Car Ford Transit White Contravening a Red Traffic Light No Insurance Moss Grove Moss Grove Dudley Dudley Court N/A   52.5025066 -2.1702039
22528 op-snap---monthly-publication-october-2025.pdf   478 2025-10 Car Peugeot Partner White Contravening a Red Traffic Light None Dudley Road East Dudley Road East Dudley Dudley NFA No Independent Evidence Available   52.5139671 -2.0396184
22631 op-snap---monthly-publication-october-2025.pdf   581 2025-10 Car BMW 220d Black Contravening a Red Traffic Light None Bath Road Bath Road Dudley Dudley Education N/A   52.4552307 -2.1496182
22636 op-snap---monthly-publication-october-2025.pdf   586 2025-10 Car Volkswagen Polo White Contravening a Red Traffic Light None Hall Road Hall Road Dudley Dudley Education N/A   52.5325489 -2.1023195
22661 op-snap---monthly-publication-october-2025.pdf   611 2025-10 Car Peugeot PM-01 Black Contravening a Red Traffic Light None A459 Bromsgrove Road Bromsgrove Road Dudley Dudley Fixed Penalty N/A   52.4473174 -2.0452886
22813 op-snap---monthly-publication-october-2025.pdf   763 2025-10 Car Volkswagen MV65NPD Black Contravening a Red Traffic Light None Dudley Road Dudley Road Dudley Dudley NFA Outside of 14 Days NIP   52.4881161 -2.1199108
22825 op-snap---monthly-publication-october-2025.pdf   775 2025-10 Car Ford Focus Blue Contravening a Red Traffic Light None Rufford Road Rufford Road Dudley Dudley Education N/A   52.4517 -2.1321091
22885 op-snap---monthly-publication-october-2025.pdf   835 2025-10 Car Citroen C4 Red Contravening a Red Traffic Light None Tipton Road Tipton Road Dudley Dudley NFA No Independent Evidence Available   52.5198386 -2.0740876
22988 op-snap---monthly-publication-october-2025.pdf   938 2025-10 Car Ford Focus White Contravening a Red Traffic Light No Insurance Pedmore Road Pedmore Road Dudley Dudley Court N/A   52.4897451 -2.1069141
22991 op-snap---monthly-publication-october-2025.pdf   941 2025-10 Car BMW M135I Grey Contravening a Red Traffic Light None Heath Lane Heath Lane Dudley Dudley Education N/A   52.4495524 -2.1459067
23782 op-snap---monthly-publication-september-2025.pdf   1 2025-09 Car Toyota Yaris Black Contravening a Red Traffic Light None Central Way, Merry Hill Central Way, Merry Hill Dudley Dudley NFA No Offence      
23839 op-snap---monthly-publication-september-2025.pdf   58 2025-09 Car BMW M3 Black Contravening a Red Traffic Light None A4036 Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
23992 op-snap---monthly-publication-september-2025.pdf   211 2025-09 Car Vauxhall Astra Silver Contravening a Red Traffic Light None A4123 at Bunns Lane A4123 at Bunns Lane Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
24195 op-snap---monthly-publication-september-2025.pdf   414 2025-09 Car Seat Leon White Contravening a Red Traffic Light None Level Street Brierley Hill Level Street Brierley Hill Dudley Dudley Education N/A   52.4842017 -2.116248
24229 op-snap---monthly-publication-september-2025.pdf   448 2025-09 Car Peugeot Partner White Contravening a Red Traffic Light None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Education N/A   52.4722518 -2.1552954
24269 op-snap---monthly-publication-september-2025.pdf   488 2025-09 Car Toyota   Blue Contravening a Red Traffic Light None Castle Gate Island Castle Gate Island Dudley Dudley NFA No Independent Evidence Available   52.5136155 -2.0733909
24296 op-snap---monthly-publication-september-2025.pdf   515 2025-09 Car Seat Leon Silver Contravening a Red Traffic Light None A449 Wolverhampton Road Wolverhampton Road Dudley Dudley NFA No Independent Evidence Available   52.5063917 -2.1711502
24375 op-snap---monthly-publication-september-2025.pdf   594 2025-09 Car BMW   Blue Contravening a Red Traffic Light None Brettell Lane Brettell Lane Dudley Dudley Education N/A   52.4706676 -2.1545486
24398 op-snap---monthly-publication-september-2025.pdf   617 2025-09 Car   VDL Bus Blue Contravening a Red Traffic Light None Merry Hill Merry Hill Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4817646 -2.1113435
24417 op-snap---monthly-publication-september-2025.pdf   636 2025-09 Car Audi A1 Grey Contravening a Red Traffic Light None Hall Street Hall Street Dudley Dudley NFA Not in Public Interest   52.5409774 -2.1235921
24435 op-snap---monthly-publication-september-2025.pdf   654 2025-09 Car BMW 116d White Contravening a Red Traffic Light None Racecourse Lane Racecourse Lane Dudley Dudley NFA No Independent Evidence Available   52.4377169 -2.1495045
24612 op-snap---monthly-publication-september-2025.pdf   831 2025-09 Car Toyota CHR White Contravening a Red Traffic Light None Birmingham New Road (Burntree) Birmingham New Road (Burntree) Dudley Dudley Fixed Penalty N/A      
24639 op-snap---monthly-publication-september-2025.pdf   858 2025-09 Car Volvo S90.. Grey Contravening a Red Traffic Light None Aston Road B4177 Aston Road B4177 Dudley Dudley Fixed Penalty N/A   52.5054243 -2.0950625
24735 op-snap---monthly-publication-september-2025.pdf   954 2025-09 Car BMW X1 Silver Contravening a Red Traffic Light None Castlegate Island Castlegate Island Dudley Dudley Education N/A      
24791 op-snap---monthly-publication-september-2025.pdf   1010 2025-09 Car Mercedes-Benz GLA 300 Grey Contravening a Red Traffic Light None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
24794 op-snap---monthly-publication-september-2025.pdf   1013 2025-09 Car Hyundai Ioniq Silver Contravening a Red Traffic Light None Highbridge Road Highbridge Road Dudley Dudley NFA Outside of 14 Days NIP   52.485907 -2.0953009
24846 op-snap---monthly-publication-september-2025.pdf   1065 2025-09 Car Lamborghini Ferrari Red Contravening a Red Traffic Light None Moss Grove / Summer Hill Road, Kingswinford Moss Grove / Summer Hill Road, Kingswinford Dudley Dudley Education N/A   52.5025066 -2.1702039
24850 op-snap---monthly-publication-september-2025.pdf   1069 2025-09 Car Volkswagen Touran Black Contravening a Red Traffic Light None King Street King Street Dudley Dudley NFA Outside of 14 Days NIP   52.5095654 -2.0806912
2094 op-snap---monthly-publication-august-2025.pdf   69 2025-08 Car BMW 330 D White Contravening a Red Traffic Light None A4123 Wolverhampton Wolverhampton Dudley Dudley Education N/A   52.5082944 -2.0789873
2184 op-snap---monthly-publication-august-2025.pdf   159 2025-08 Car BMW 520.. Black Contravening a Red Traffic Light None Thorns Road Thorns Road Dudley Dudley Education N/A   52.4628538 -2.1160108
2251 op-snap---monthly-publication-august-2025.pdf   226 2025-08 Car Land Rover Range Rover Grey Contravening a Red Traffic Light None Castlegate Island Castlegate Island Dudley Dudley Education N/A      
2514 op-snap---monthly-publication-august-2025.pdf   489 2025-08 Car Land Rover Freelander Grey Contravening a Red Traffic Light None A459 Halesowen Halesowen Dudley Dudley Education N/A   52.4492074 -2.0514646
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
2639 op-snap---monthly-publication-august-2025.pdf   614 2025-08 Car Volvo XC40 Black Contravening a Red Traffic Light None Pedmore Road Brierley Hill Pedmore Road Brierley Hill Dudley Dudley Fixed Penalty N/A   52.4897451 -2.1069141
2646 op-snap---monthly-publication-august-2025.pdf   621 2025-08 Car Mercedes-Benz A180 Blue Contravening a Red Traffic Light None Stourbridge Road Stourbridge Road Dudley Dudley Fixed Penalty N/A   52.5002997 -2.1081386
2765 op-snap---monthly-publication-august-2025.pdf   740 2025-08 Car Renault Megane White Contravening a Red Traffic Light None A4123 (Coseley) A4123 (Coseley) Dudley Dudley Fixed Penalty N/A   52.5477155 -2.0940631
2782 op-snap---monthly-publication-august-2025.pdf   757 2025-08 Car Nissan Qashqai Black Contravening a Red Traffic Light None A491 Hagley Road Stourbridge Hagley Road Stourbridge Dudley Dudley Education N/A   52.4407776 -2.1344067
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      
11994 op-snap---monthly-publication-july-2025.pdf   46 2025-07 Car Ford Fiesta White Contravening a Red Traffic Light None High Street, Wordsley High Street, Wordsley Dudley Dudley NFA Outside of 14 Days NIP   52.4778645 -2.1594686
12129 op-snap---monthly-publication-july-2025.pdf   181 2025-07 Car Ford Transit White Contravening a Red Traffic Light None Oldswinford cross Oldswinford cross Dudley Dudley NFA No Independent Evidence Available   52.4485777 -2.1407627
12160 op-snap---monthly-publication-july-2025.pdf   212 2025-07 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Hagley Road Hagley Road Dudley Dudley NFA No Offence   52.4514139 -2.1423625
12306 op-snap---monthly-publication-july-2025.pdf   358 2025-07 Car Toyota Pro Ace White Contravening a Red Traffic Light None Hall Street Hall Street Dudley Dudley Education N/A   52.5409774 -2.1235921
12329 op-snap---monthly-publication-july-2025.pdf   381 2025-07 Car Peugeot   Black Contravening a Red Traffic Light None Birmingham New Road Birmingham New Road Dudley Dudley NFA Outside of 14 Days NIP   52.5478387 -2.0943116
12372 op-snap---monthly-publication-july-2025.pdf   424 2025-07 Car Volvo V40 Blue Contravening a Red Traffic Light None High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
12447 op-snap---monthly-publication-july-2025.pdf   499 2025-07 Car Audi S3 Black Contravening a Red Traffic Light None Hayes Lane Hayes Lane Dudley Dudley Education N/A   52.4599414 -2.1028651
12664 op-snap---monthly-publication-july-2025.pdf   716 2025-07 Car Ford Fiesta Black Contravening a Red Traffic Light None Upper High Street Upper High Street Dudley Dudley NFA No Independent Evidence Available      
12947 op-snap---monthly-publication-july-2025.pdf   999 2025-07 Car BMW 335.. Grey Contravening a Red Traffic Light None Stourbridge Road Stourbridge Road Dudley Dudley NFA Outside of 14 Days NIP   52.5002997 -2.1081386
12994 op-snap---monthly-publication-july-2025.pdf   1046 2025-07 Car   motorbike dark   Contravening a Red Traffic Light None Venture Way , Brierley Hill Venture Way , Brierley Hill Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4836603 -2.1189326
13218 op-snap---monthly-publication-july-2025.pdf   1270 2025-07 Car Audi A3 Black Contravening a Red Traffic Light None Wollescote Road Wollescote Road Dudley Dudley NFA Outside of 14 Days NIP   52.4471527 -2.1236271
14098 op-snap---monthly-publication-june-2025.pdf   27 2025-06 Car Fiat 500.. Pink Contravening a Red Traffic Light None Balds Lane Lye Balds Lane Lye Dudley Dudley Education N/A   52.455416 -2.1051567
14207 op-snap---monthly-publication-june-2025.pdf   136 2025-06 Car Volkswagen GOLF Black Contravening a Red Traffic Light None KING STREET King Street Dudley Dudley Court N/A   52.5095654 -2.0806912
14260 op-snap---monthly-publication-june-2025.pdf   189 2025-06 Car Nissan Micra Grey Contravening a Red Traffic Light None Heath Street Heath Street Dudley Dudley Education N/A   52.4528944 -2.152138
14443 op-snap---monthly-publication-june-2025.pdf   372 2025-06 Car BMW 318M Silver Contravening a Red Traffic Light None OPEDMORE ROAD Opedmore Road Dudley Dudley Education N/A      
14720 op-snap---monthly-publication-june-2025.pdf   649 2025-06 Car Ford Mondeo Blue Contravening a Red Traffic Light None Saltwells Road Saltwells Road Dudley Dudley Education N/A   52.4828169 -2.0775182
14803 op-snap---monthly-publication-june-2025.pdf   732 2025-06 Car Seat Mii White Contravening a Red Traffic Light None Saltwells Road Saltwells Road Dudley Dudley NFA Outside of 14 Days NIP   52.4828169 -2.0775182
15055 op-snap---monthly-publication-june-2025.pdf   984 2025-06 Car Ford Ranger Silver Contravening a Red Traffic Light None Hickman Road Hickman Road Dudley Dudley Education N/A   52.4878144 -2.1286751
15086 op-snap---monthly-publication-june-2025.pdf   1015 2025-06 Car Seat Leon Blue Contravening a Red Traffic Light None King Street King Street Dudley Dudley Education N/A   52.5095654 -2.0806912
15091 op-snap---monthly-publication-june-2025.pdf   1020 2025-06 Car Mg ZS Blue Contravening a Red Traffic Light None Trindle Street Trindle Street Dudley Dudley NFA Outside of 14 Days NIP      
15136 op-snap---monthly-publication-june-2025.pdf   1065 2025-06 Car Audi Q2 Red Contravening a Red Traffic Light None Heath Lane Heath Lane Dudley Dudley NFA No Offence   52.4495524 -2.1459067
15207 op-snap---monthly-publication-june-2025.pdf   1136 2025-06 Car Seat ibiza White Contravening a Red Traffic Light None A419 KINGSWINFORD A419 Kingswinford Dudley Dudley Education N/A   52.4967692 -2.1661721
15246 op-snap---monthly-publication-june-2025.pdf   1175 2025-06 Car BMW M4 White Contravening a Red Traffic Light None NEW B-HAM ROAD New B-Ham Road Dudley Dudley Court N/A      
15459 op-snap---monthly-publication-june-2025.pdf   1388 2025-06 Car Skoda Rapid Black Contravening a Red Traffic Light None Cradley Road, Netherton Cradley Road, Netherton Dudley Dudley Education N/A   52.4877241 -2.0818998

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