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

662 rows where council_area = "Dudley" 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, witness_contacted

vehicle_make >30

month 14

reporter_transport_mode 1

  • Car · 662 ✖

council_area 1

  • Dudley · 662 ✖
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
7257 op-snap---monthly-publication-february-2026.pdf   4 2026-02 Car Mazda CX30 Grey Driving without Due Care and Attention None High Street, Quarry Bank High Street, Quarry Bank Dudley Dudley Education N/A   52.4576453 -2.1150716
7258 op-snap---monthly-publication-february-2026.pdf   5 2026-02 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Delph Road, Delph Road Dudley Dudley NFA No Independent Evidence Available   52.4754271 -2.1310168
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
7372 op-snap---monthly-publication-february-2026.pdf   119 2026-02 Car Vauxhall corsa Red Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA No Offence   52.4779764 -2.1598371
7413 op-snap---monthly-publication-february-2026.pdf   160 2026-02 Car Ford Kuga Green Driving without Due Care and Attention None Tipton Street Tipton Street Dudley Dudley RTC - Actioned N/A   52.5387558 -2.1179869
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
7515 op-snap---monthly-publication-february-2026.pdf   262 2026-02 Car Mercedes-Benz C 220 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Springfield Road Halesowen Springfield Road Halesowen Dudley Dudley NFA No Offence   52.4664617 -2.0319975
7579 op-snap---monthly-publication-february-2026.pdf   326 2026-02 Car Kia Xceed Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
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      
7617 op-snap---monthly-publication-february-2026.pdf   364 2026-02 Car Ford Transit White Driving without Due Care and Attention None The Embankment The Embankment Dudley Dudley NFA No Offence   52.4826167 -2.1144546
7618 op-snap---monthly-publication-february-2026.pdf   365 2026-02 Car Man TGE White Driving without Due Care and Attention None The Embankment The Embankment Dudley Dudley NFA No Offence   52.4826167 -2.1144546
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
7676 op-snap---monthly-publication-february-2026.pdf   423 2026-02 Car Vauxhall Insignia Grey Using a Mobile Phone Whilst Driving None Embankment Merry Hill Embankment Merry Hill Dudley Dudley Fixed Penalty N/A   52.4814094 -2.1134278
7717 op-snap---monthly-publication-february-2026.pdf   464 2026-02 Car Citroen C4 Blue Driving without Due Care and Attention None Oakham Road Oakham Road Dudley Dudley NFA No Offence   52.5030757 -2.0663819
7732 op-snap---monthly-publication-february-2026.pdf   479 2026-02 Car Toyota Yaris Blue Driving without Due Care and Attention No Insurance Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley NFA No Independent Evidence Available   52.4590366 -2.1465735
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
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
7752 op-snap---monthly-publication-february-2026.pdf   499 2026-02 Car Volkswagen V40.. Blue Driving without Due Care and Attention None Chadd Road Coseley Chadd Road Coseley Dudley Dudley Other Action Taken N/A      
7827 op-snap---monthly-publication-february-2026.pdf   574 2026-02 Car Skoda Kodiaq Grey Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA Not in Public Interest   52.4779764 -2.1598371
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      
7972 op-snap---monthly-publication-february-2026.pdf   719 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Scotts Green Island Scotts Green Island Dudley Dudley Fixed Penalty N/A   52.5029355 -2.1051117
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
8194 op-snap---monthly-publication-february-2026.pdf   941 2026-02 Car Toyota C-HR Blue Driving without Due Care and Attention None Birmingham Street Birmingham Street Dudley Dudley Education N/A   52.5122152 -2.0791208
8214 op-snap---monthly-publication-february-2026.pdf   961 2026-02 Car Ford Fiesta Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silverthorne Lane Silverthorne Lane Dudley Dudley NFA No Offence      
8215 op-snap---monthly-publication-february-2026.pdf   962 2026-02 Car BMW X1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silverthorne Lane Silverthorne Lane Dudley Dudley Fixed Penalty N/A      
8225 op-snap---monthly-publication-february-2026.pdf   972 2026-02 Car Volkswagen Crafter White Stop a vehicle within pelican pedestrian crossing limits None Brettle Lane Brettle Lane Dudley Dudley Education N/A      
8240 op-snap---monthly-publication-february-2026.pdf   987 2026-02 Car Vauxhall Vivaro Grey Driving without Due Care and Attention None Dudley Port Road, Tipton Dudley Port Road, Tipton Dudley Dudley Education N/A   52.5320271 -2.0666926
8241 op-snap---monthly-publication-february-2026.pdf   988 2026-02 Car Citroen Dispatch Grey Driving without Due Care and Attention None Dudley Port Road, Tipton Dudley Port Road, Tipton Dudley Dudley Education N/A   52.5320271 -2.0666926
8258 op-snap---monthly-publication-february-2026.pdf   1005 2026-02 Car Peugeot Expert Grey Driving without Due Care and Attention None Himley Road Himley Road Dudley Dudley Education N/A   52.5142667 -2.1304764
8269 op-snap---monthly-publication-february-2026.pdf   1016 2026-02 Car Ford Transit Blue Driving without Due Care and Attention No Insurance Halesowen Road Netherton Halesowen Road Netherton Dudley Dudley Court N/A   52.4904317 -2.0833451
8273 op-snap---monthly-publication-february-2026.pdf   1020 2026-02 Car Ford Mondeo White Misc - Non Traffic Offences None Manor Way Halesowen Manor Way Halesowen Dudley Dudley NFA Not in Public Interest   52.443598 -2.0464887
8417 op-snap---monthly-publication-february-2026.pdf   1164 2026-02 Car Volkswagen Passat Green Driving without Due Care and Attention No Insurance The Inhedge, The Inhedge Dudley Dudley Fixed Penalty N/A   52.5099671 -2.0871664
8458 op-snap---monthly-publication-february-2026.pdf   1205 2026-02 Car BMW 5 series White Using a Mobile Phone Whilst Driving None Kidderminster Road Kidderminster Road Dudley Dudley NFA No Independent Evidence Available   52.5000055 -2.1844503
8467 op-snap---monthly-publication-february-2026.pdf   1214 2026-02 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Wollescote Road Wollescote Road Dudley Dudley NFA No Independent Evidence Available   52.4471527 -2.1236271
8470 op-snap---monthly-publication-february-2026.pdf   1217 2026-02 Car Volkswagen Golf White Driving without Due Care and Attention None Highbridge Road Netherton Highbridge Road Netherton Dudley Dudley Other Action Taken N/A   52.485907 -2.0953009
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
8504 op-snap---monthly-publication-february-2026.pdf   1251 2026-02 Car Audi A3 White Misc - Non Traffic Offences None Pembridge Close Pembridge Close Dudley Dudley NFA No Offence   52.4755298 -2.1067444
8520 op-snap---monthly-publication-february-2026.pdf   1267 2026-02 Car Renault Kadjar Grey Driving without Due Care and Attention None Cinder Bank Island Cinder Bank Island Dudley Dudley NFA Outside of 14 Days NIP   52.5004694 -2.0904035
8642 op-snap---monthly-publication-february-2026.pdf   1389 2026-02 Car Volkswagen polo Blue Misc - Non Traffic Offences None netherton Netherton Dudley Dudley NFA Misc Inc Crimes   52.4914577 -2.0831125
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
8702 op-snap---monthly-publication-february-2026.pdf   1449 2026-02 Car Volkswagen Golf White Driving without Due Care and Attention None Highbridge Road Highbridge Road Dudley Dudley Court N/A   52.485907 -2.0953009
8761 op-snap---monthly-publication-february-2026.pdf   1508 2026-02 Car Hyundai Ioniq Black Driving without Due Care and Attention None Stafford Street Stafford Street Dudley Dudley NFA No Offence   52.5095163 -2.0898951
8783 op-snap---monthly-publication-february-2026.pdf   1530 2026-02 Car Toyota Rav 4 Silver Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Independent Evidence Available   52.5047428 -2.0823754
8786 op-snap---monthly-publication-february-2026.pdf   1533 2026-02 Car Volkswagen Transporter White VRM fails to conform to Regulations None Huntingtree Road Huntingtree Road Dudley Dudley Fixed Penalty N/A   52.4484682 -2.0689885
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
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
11063 op-snap---monthly-publication-january-2026.pdf   524 2026-01 Car Peugeot Boxvan White Driving without Due Care and Attention None New Road, Halesowen New Road, Halesowen Dudley Dudley Court N/A   52.4514694 -2.0500697
11095 op-snap---monthly-publication-january-2026.pdf   556 2026-01 Car BMW 520 Black No Seat Belt None Hurst Lane Merry Hill Hurst Lane Merry Hill Dudley Dudley NFA No Offence      
11255 op-snap---monthly-publication-january-2026.pdf   716 2026-01 Car Ford Fiesta Blue Driving without Due Care and Attention None Greyhouse Lane, Stourbridge Greyhouse Lane, Stourbridge Dudley Dudley Fixed Penalty N/A      
11258 op-snap---monthly-publication-january-2026.pdf   719 2026-01 Car Peugeot 308 Grey Driving without Due Care and Attention None Cinder Bank Island Cinder Bank Island Dudley Dudley Education N/A   52.5004694 -2.0904035
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
11331 op-snap---monthly-publication-january-2026.pdf   792 2026-01 Car Land Rover Discovery Grey VRM fails to conform to Regulations None Birmingham New Road Birmingham New Road Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
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      
11372 op-snap---monthly-publication-january-2026.pdf   833 2026-01 Car Vauxhall Zafira Black Stop a vehicle on pedestrian crossing None Robert Street Robert Street Dudley Dudley Fixed Penalty N/A   52.5221845 -2.1196502
11374 op-snap---monthly-publication-january-2026.pdf   835 2026-01 Car Nissan Qashqai Blue Stop a vehicle within pelican pedestrian crossing limits None Robert Street Robert Street Dudley Dudley Education N/A   52.5221845 -2.1196502
11376 op-snap---monthly-publication-january-2026.pdf   837 2026-01 Car Ford C-Max Silver Stop a vehicle within pelican pedestrian crossing limits None Roberts Street Roberts Street Dudley Dudley Education N/A   52.5213135 -2.1197042
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
11504 op-snap---monthly-publication-january-2026.pdf   965 2026-01 Car Seat leon White Driving without Reasonable Consideration No Insurance Wrens Nest Road Wrens Nest Road Dudley Dudley Court N/A   52.5253252 -2.0995407
11560 op-snap---monthly-publication-january-2026.pdf   1021 2026-01 Car Dennis Alexander Red Driving without Due Care and Attention None Brierley Hill Road Brierley Hill Road Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4811151 -2.1456435
11641 op-snap---monthly-publication-january-2026.pdf   1102 2026-01 Car BMW X3 Black Driving without Due Care and Attention None Strourbridge Ring Road Strourbridge Ring Road Dudley Dudley Education N/A      
11646 op-snap---monthly-publication-january-2026.pdf   1107 2026-01 Car Peugeot boxer Black Driving without Due Care and Attention None Kidderminster Road Kidderminster Road Dudley Dudley Fixed Penalty N/A   52.5000055 -2.1844503
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
11685 op-snap---monthly-publication-january-2026.pdf   1146 2026-01 Car Volkswagen Golf Grey Driving without Due Care and Attention None Deepdale Lane Deepdale Lane Dudley Dudley Education N/A   52.5211263 -2.1174674
11688 op-snap---monthly-publication-january-2026.pdf   1149 2026-01 Car Vauxhall MOKKA Black Driving without Due Care and Attention None Lodge Lane Lodge Lane Dudley Dudley Court N/A   52.4953929 -2.1814598
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
11917 op-snap---monthly-publication-january-2026.pdf   1378 2026-01 Car Hyundai Kona Grey Driving without Due Care and Attention None Sawn Street Sawn Street Dudley Dudley Education N/A      
11920 op-snap---monthly-publication-january-2026.pdf   1381 2026-01 Car Mazda model3 silver Driving without Due Care and Attention None Pensnett Road, Brierley Hill Pensnett Road, Brierley Hill Dudley Dudley Fixed Penalty N/A   52.4890857 -2.1299003
3965 op-snap---monthly-publication-december-2025.pdf   93 2025-12 Car Audi q3 Black Misc - Non Traffic Offences None huntingtree road Huntingtree Road Dudley Dudley NFA No Independent Evidence Available   52.4484682 -2.0689885
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
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
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      
4135 op-snap---monthly-publication-december-2025.pdf   263 2025-12 Car Vauxhall Corsa Blue Driving without Due Care and Attention Contravening a Red Traffic Li gEhvte Lane g Ehvte Lane Dudley Dudley Fixed Penalty N/A      
4176 op-snap---monthly-publication-december-2025.pdf   304 2025-12 Car Renault Master White Using a Mobile Phone Whilst Driving None Pale Street Upper Gornal Pale Street Upper Gornal Dudley Dudley Fixed Penalty N/A   52.525959 -2.1142205
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
4317 op-snap---monthly-publication-december-2025.pdf   445 2025-12 Car BMW 1 series White Misc - Non Traffic Offences None Burnt Tree Burnt Tree Dudley Dudley NFA No Independent Evidence Available   52.513767 -2.0633163
4411 op-snap---monthly-publication-december-2025.pdf   539 2025-12 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Sedgley Road Sedgley Road Dudley Dudley Court N/A   52.5329532 -2.0933963
4416 op-snap---monthly-publication-december-2025.pdf   544 2025-12 Car Volkswagen ID4 White Driving without Due Care and Attention None A4123 Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
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
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
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
4645 op-snap---monthly-publication-december-2025.pdf   773 2025-12 Car Vauxhall Zafira Green Driving without Due Care and Attention None Birmingham Road Birmingham Road Dudley Dudley NFA No Offence   52.5131355 -2.0651615
4703 op-snap---monthly-publication-december-2025.pdf   831 2025-12 Car Peugeot boxer Silver Misc - Non Traffic Offences None court street Court Street Dudley Dudley NFA Misc Inc Crimes   52.455056 -2.1443561
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      
4801 op-snap---monthly-publication-december-2025.pdf   929 2025-12 Car Seat CUPRA Grey Driving without Due Care and Attention None Cinder bank at Simms Cinder bank at Simms Dudley Dudley NFA Outside of 14 Days NIP   52.4951209 -2.0924902
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
4914 op-snap---monthly-publication-december-2025.pdf   1042 2025-12 Car Skoda Kodiaq Grey Misc - Non Traffic Offences None Dudley Dudley Dudley Dudley RTC - Actioned Misc Inc Crimes   52.5110832 -2.0816813
4915 op-snap---monthly-publication-december-2025.pdf   1043 2025-12 Car BMW 5 series Black Driving without Due Care and Attention None St Johns Road, Stourbridge Street Johns Road, Stourbridge Dudley Dudley NFA No VRM      
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      

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