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

262 rows where council_area = "Dudley", offence = "Driving without Due Care and Attention" 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

month 14

reporter_transport_mode 1

  • Car · 262 ✖

offence 1

  • Driving without Due Care and Attention · 262 ✖

council_area 1

  • Dudley · 262 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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      
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
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
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
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
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      
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      
20504 op-snap---monthly-publication-november-2025.pdf   46 2025-11 Car Vauxhall Grandland White Driving without Due Care and Attention None Marriott Road Marriott Road Dudley Dudley NFA No Offence   52.486651 -2.084271
20576 op-snap---monthly-publication-november-2025.pdf   118 2025-11 Car Audi A3 Grey Driving without Due Care and Attention None Himley Road Himley Road Dudley Dudley NFA No Offence   52.5142667 -2.1304764
20588 op-snap---monthly-publication-november-2025.pdf   130 2025-11 Car Honda CR V Brown Driving without Due Care and Attention None The Broadway The Broadway Dudley Dudley NFA No Independent Evidence Available   52.515445 -2.0885791
20641 op-snap---monthly-publication-november-2025.pdf   183 2025-11 Car BMW 320.. Grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate High Street Sedgley High Street Sedgley Dudley Dudley Education N/A   52.543975 -2.122501
20674 op-snap---monthly-publication-november-2025.pdf   216 2025-11 Car Ford Kuga Black Driving without Due Care and Attention None Tipton Road Tipton Road Dudley Dudley Court N/A   52.5198386 -2.0740876
20796 op-snap---monthly-publication-november-2025.pdf   338 2025-11 Car Vauxhall Astra Black Driving without Due Care and Attention None Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
21035 op-snap---monthly-publication-november-2025.pdf   577 2025-11 Car Seat Leon Grey Driving without Due Care and Attention None Glasshouse Hill Glasshouse Hill Dudley Dudley Fixed Penalty N/A   52.4487368 -2.1384768
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
21093 op-snap---monthly-publication-november-2025.pdf   635 2025-11 Car Nissan Navara Silver Driving without Due Care and Attention No Insurance Graingers Lane Graingers Lane Dudley Dudley Court N/A   52.4840702 -2.0657046
21394 op-snap---monthly-publication-november-2025.pdf   936 2025-11 Car Fiat Punto White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
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
21554 op-snap---monthly-publication-november-2025.pdf   1096 2025-11 Car Vauxhall Vivaro White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Dudley Dudley Education N/A   52.5063917 -2.1711502
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
21582 op-snap---monthly-publication-november-2025.pdf   1124 2025-11 Car Kia Sportage Brown Driving without Due Care and Attention None St Johns Road Stourbridge Street Johns Road Stourbridge Dudley Dudley Fixed Penalty N/A      
22028 op-snap---monthly-publication-november-2025.pdf   1570 2025-11 Car Toyota Prius Black Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Offence   52.5047428 -2.0823754
22029 op-snap---monthly-publication-november-2025.pdf   1571 2025-11 Car BMW BMW Grey Driving without Due Care and Attention None Hall Street Hall Street Dudley Dudley NFA Not in Public Interest   52.5409774 -2.1235921
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      
22160 op-snap---monthly-publication-october-2025.pdf   110 2025-10 Car Isuzu Trucks White Driving without Due Care and Attention None Grange Island Grange Island Dudley Dudley Fixed Penalty N/A      
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
22200 op-snap---monthly-publication-october-2025.pdf   150 2025-10 Car Ford Focus Blue Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley RTC - Actioned N/A   52.4879006 -2.1188734
22218 op-snap---monthly-publication-october-2025.pdf   168 2025-10 Car Ford   Black Driving without Due Care and Attention None A491 High Street Stourbridge High Street Stourbridge Dudley Dudley Court N/A   52.4570763 -2.1136199
22219 op-snap---monthly-publication-october-2025.pdf   169 2025-10 Car Toyota Yaris Grey Driving without Due Care and Attention None A491 High Street Stourbridge High Street Stourbridge Dudley Dudley NFA Not in Public Interest   52.4570763 -2.1136199
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      
22247 op-snap---monthly-publication-october-2025.pdf   197 2025-10 Car Ford Fiesta Blue Driving without Due Care and Attention None Castel Gate Island Castel Gate Island Dudley Dudley Fixed Penalty N/A      
22363 op-snap---monthly-publication-october-2025.pdf   313 2025-10 Car Ford Transit Grey Driving without Due Care and Attention None Manor Way / Hagley Road Manor Way / Hagley Road Dudley Dudley NFA No Offence   52.4493861 -2.0168307
22388 op-snap---monthly-publication-october-2025.pdf   338 2025-10 Car Renault Twingo Black Driving without Due Care and Attention None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley NFA No VRM   52.4590366 -2.1465735
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      
22454 op-snap---monthly-publication-october-2025.pdf   404 2025-10 Car Vauxhall Corsa White Driving without Due Care and Attention No Insurance Vicar Street Vicar Street Dudley Dudley Court N/A   52.5401776 -2.121708
22508 op-snap---monthly-publication-october-2025.pdf   458 2025-10 Car Mini Countryman white Driving without Due Care and Attention None Enville Road / High Street, Wall Heath Enville Road / High Street, Wall Heath Dudley Dudley Education N/A   52.5239908 -2.1262445
22569 op-snap---monthly-publication-october-2025.pdf   519 2025-10 Car Volkswagen Jetta Black Driving without Due Care and Attention None Warstones Road, Stourbridge Warstones Road, Stourbridge Dudley Dudley NFA Outside of 14 DAYS Late Submission      
22581 op-snap---monthly-publication-october-2025.pdf   531 2025-10 Car Scania Tractor Orange Driving without Due Care and Attention None Castlegate Island Castlegate Island Dudley Dudley NFA No Offence      
22658 op-snap---monthly-publication-october-2025.pdf   608 2025-10 Car BMW 530e Blue Driving without Due Care and Attention None Noose Lane, Willenhall Noose Lane, Willenhall Dudley Dudley NFA No Independent Evidence Available      
22846 op-snap---monthly-publication-october-2025.pdf   796 2025-10 Car Ford Fiesta Blue Driving without Due Care and Attention None High St Stourbridge High Street Stourbridge Dudley Dudley NFA No Offence   52.4570763 -2.1136199
22911 op-snap---monthly-publication-october-2025.pdf   861 2025-10 Car Peugeot 2008 White Driving without Due Care and Attention None Northfield Road Northfield Road Dudley Dudley NFA No Independent Evidence Available   52.4879172 -2.07401
22913 op-snap---monthly-publication-october-2025.pdf   863 2025-10 Car Volkswagen Tiguan Black Driving without Due Care and Attention None St Johns Road Street Johns Road Dudley Dudley NFA No Offence      
22976 op-snap---monthly-publication-october-2025.pdf   926 2025-10 Car Nissan Micra Black Driving without Due Care and Attention None High Street, Brierley Hill High Street, Brierley Hill Dudley Dudley NFA No Offence   52.50139 -2.1461685
22980 op-snap---monthly-publication-october-2025.pdf   930 2025-10 Car Nissan Juke Grey Driving without Due Care and Attention None Thorns Road Quarry Bank Thorns Road Quarry Bank Dudley Dudley Education N/A   52.4628538 -2.1160108
22990 op-snap---monthly-publication-october-2025.pdf   940 2025-10 Car Honda Civic Blue Driving without Due Care and Attention None Cinder Bank Island Cinder Bank Island Dudley Dudley Education N/A   52.5004694 -2.0904035
23840 op-snap---monthly-publication-september-2025.pdf   59 2025-09 Car Nissan Primastar Grey Driving without Due Care and Attention None A4036 Merry Hill Merry Hill Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4817646 -2.1113435
23846 op-snap---monthly-publication-september-2025.pdf   65 2025-09 Car Mercedes-Benz Smart ForTwo Black Driving without Due Care and Attention No Insurance Roberts Street Roberts Street Dudley Dudley Court N/A   52.5213135 -2.1197042
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      
23919 op-snap---monthly-publication-september-2025.pdf   138 2025-09 Car Hyundai Tuscon Grey Driving without Due Care and Attention None Bridgnorth Road Bridgnorth Road Dudley Dudley Court N/A   52.4603456 -2.1716457
24227 op-snap---monthly-publication-september-2025.pdf   446 2025-09 Car Toyota Aygo Silver Driving without Due Care and Attention None Castlegate Island Castlegate Island Dudley Dudley NFA No Offence      
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
24261 op-snap---monthly-publication-september-2025.pdf   480 2025-09 Car BMW 1 Series Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Education N/A   52.4879006 -2.1188734
24334 op-snap---monthly-publication-september-2025.pdf   553 2025-09 Car BMW   White Driving without Due Care and Attention None A491 High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
24354 op-snap---monthly-publication-september-2025.pdf   573 2025-09 Car   Piaggio Black Driving without Due Care and Attention None Gospel End Road Gospel End Road Dudley Dudley NFA No Independent Evidence Available   52.5392439 -2.1282642
24363 op-snap---monthly-publication-september-2025.pdf   582 2025-09 Car Ford Fiesta Silver Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Education N/A   52.4624413 -2.0175178
24431 op-snap---monthly-publication-september-2025.pdf   650 2025-09 Car Seat Leon White Driving without Due Care and Attention None Prince Street Prince Street Dudley Dudley NFA Not in Public Interest   52.4966192 -2.0854322

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