home / opsnap

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

127 rows where disposal = "Warning Letter", month = "2025-09" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw

vehicle_make 28

  • Volkswagen 16
  • BMW 12
  • Vauxhall 12
  • Mercedes-Benz 11
  • Ford 9
  • Audi 7
  • Peugeot 6
  • Kia 5
  • Seat 5
  • Land Rover 4
  • Nissan 4
  • Renault 4
  • Skoda 4
  • Toyota 4
  • Volvo 4
  • Mg 3
  • Dacia 2
  • Suzuki 2
  • Yamaha 2
  • Chevrolet 1
  • Citroen 1
  • Honda 1
  • Hyundai 1
  • Mini 1
  • Mitsubishi 1
  • Porsche 1
  • Scania 1
  • Tesla 1

council_area 8

  • Birmingham 75
  • Dudley 15
  • Coventry 14
  • Wolverhampton 9
  • Solihull 5
  • Walsall 5
  • Sandwell 3
  • Out of Force Area 1

reporter_transport_mode 6

  • Car 86
  • Pedal Bike 18
  • Other 11
  • Pedestrian 10
  • Lorry 1
  • Motorbike 1

offence 1

  • Driving without Due Care and Attention · 127 ✖

month 1

  • 2025-09 · 127 ✖

disposal 1

  • Warning Letter · 127 ✖
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
23781 op-snap---monthly-publication-september-2025.pdf   0 2025-09 Other Skoda Fabia White Driving without Due Care and Attention None Waterfron main car park Waterfron main car park Dudley Dudley Warning Letter N/A      
23786 op-snap---monthly-publication-september-2025.pdf   5 2025-09 Car Tesla Model 3 Grey Driving without Due Care and Attention None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham Warning Letter N/A   52.4650893 -1.8425008
23799 op-snap---monthly-publication-september-2025.pdf   18 2025-09 Car Volvo   Black Driving without Due Care and Attention None Camp Hill Camp Hill Birmingham Birmingham Warning Letter N/A   52.4702894 -1.8786299
23810 op-snap---monthly-publication-september-2025.pdf   29 2025-09 Pedestrian Kia Rio Red Driving without Due Care and Attention None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
23844 op-snap---monthly-publication-september-2025.pdf   63 2025-09 Car Ford B Max Gold Driving without Due Care and Attention None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Warning Letter N/A      
23862 op-snap---monthly-publication-september-2025.pdf   81 2025-09 Car Volkswagen Golf Red Driving without Due Care and Attention None Wills Street Wills Street Birmingham Birmingham Warning Letter N/A   52.500453 -1.9141126
23864 op-snap---monthly-publication-september-2025.pdf   83 2025-09 Car Volkswagen T-Roc Silver Driving without Due Care and Attention None Collingswood Drive Collingswood Drive Birmingham Birmingham Warning Letter N/A      
23872 op-snap---monthly-publication-september-2025.pdf   91 2025-09 Car Vauxhall Mokka White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
23881 op-snap---monthly-publication-september-2025.pdf   100 2025-09 Pedal Bike Land Rover Evoque White Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
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      
23936 op-snap---monthly-publication-september-2025.pdf   155 2025-09 Car Volvo S90 Blue Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
23978 op-snap---monthly-publication-september-2025.pdf   197 2025-09 Car Ford Fiesta Black Driving without Due Care and Attention None Curzon Circus Curzon Circus Birmingham Birmingham Warning Letter N/A      
24024 op-snap---monthly-publication-september-2025.pdf   243 2025-09 Car Nissan Qashqai Black Driving without Due Care and Attention None Deelands Road Deelands Road Birmingham Birmingham Warning Letter N/A   52.3970488 -2.0184857
24029 op-snap---monthly-publication-september-2025.pdf   248 2025-09 Car Volkswagen Passat Black Driving without Due Care and Attention None Gerrard Street Gerrard Street Birmingham Birmingham Warning Letter N/A   52.5002335 -1.9032351
24030 op-snap---monthly-publication-september-2025.pdf   249 2025-09 Car Audi Q5 Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24032 op-snap---monthly-publication-september-2025.pdf   251 2025-09 Other Nissan Qashqai Black Driving without Due Care and Attention None Dean Road Dean Road Wolverhampton Wolverhampton Warning Letter N/A   52.5932146 -2.102601
24035 op-snap---monthly-publication-september-2025.pdf   254 2025-09 Car Audi A3 Black Driving without Due Care and Attention None Boldmere Road Boldmere Road Birmingham Birmingham Warning Letter N/A   52.548309 -1.8411769
24057 op-snap---monthly-publication-september-2025.pdf   276 2025-09 Car Seat Leon Black Driving without Due Care and Attention None Nursery Road Nursery Road Birmingham Birmingham Warning Letter N/A   52.4979836 -1.9118163
24060 op-snap---monthly-publication-september-2025.pdf   279 2025-09 Car Mercedes-Benz c300 Grey Driving without Due Care and Attention None High Street, Newtown High Street, Newtown Birmingham Birmingham Warning Letter N/A   52.5000098 -1.8959802
24086 op-snap---monthly-publication-september-2025.pdf   305 2025-09 Car BMW 116 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Sandwell Sandwell Warning Letter N/A   52.4702299 -1.9948976
24102 op-snap---monthly-publication-september-2025.pdf   321 2025-09 Car Mg HS Red Driving without Due Care and Attention None M6 SB J4a - 4 M6 Southbound J4a - 4 Coventry Coventry Warning Letter N/A   52.6912652 -2.1043715
24108 op-snap---monthly-publication-september-2025.pdf   327 2025-09 Pedal Bike Land Rover Range Rover White Driving without Due Care and Attention None Devon Road Devon Road Sandwell Sandwell Warning Letter N/A   52.4674008 -1.9805667
24118 op-snap---monthly-publication-september-2025.pdf   337 2025-09 Car Vauxhall Astra White Driving without Due Care and Attention None M6 Coventry M6 Coventry Coventry Coventry Warning Letter N/A   52.4457805 -1.454783
24141 op-snap---monthly-publication-september-2025.pdf   360 2025-09 Car Volkswagen Polo Red Driving without Due Care and Attention None Norman Road Norman Road Birmingham Birmingham Warning Letter N/A   52.411848 -1.9590923
24153 op-snap---monthly-publication-september-2025.pdf   372 2025-09 Car Toyota Corolla Grey Driving without Due Care and Attention None Central Six retail park Central Six retail park Coventry Coventry Warning Letter N/A   52.4022899 -1.5191819
24157 op-snap---monthly-publication-september-2025.pdf   376 2025-09 Car Peugeot Expert White Driving without Due Care and Attention None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham Warning Letter N/A   52.4760986 -1.9018641
24164 op-snap---monthly-publication-september-2025.pdf   383 2025-09 Car Audi Q6 Grey Driving without Due Care and Attention None Ulverley Green Lane Ulverley Green Lane Solihull Solihull Warning Letter N/A      
24171 op-snap---monthly-publication-september-2025.pdf   390 2025-09 Car Ford Kuga Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Warning Letter N/A   52.5517052 -1.7825505
24176 op-snap---monthly-publication-september-2025.pdf   395 2025-09 Pedal Bike Volkswagen Tiguan Grey Driving without Due Care and Attention None Stonnal Road Aldridge Stonnal Road Aldridge Walsall Walsall Warning Letter N/A      
24181 op-snap---monthly-publication-september-2025.pdf   400 2025-09 Pedestrian Volvo V50 Blue Driving without Due Care and Attention None Farrington Road Farrington Road Wolverhampton Wolverhampton Warning Letter N/A   52.5550312 -2.1191799
24184 op-snap---monthly-publication-september-2025.pdf   403 2025-09 Car Vauxhall mokka Blue Driving without Due Care and Attention None The Crescent The Crescent Birmingham Birmingham Warning Letter N/A   52.4568799 -1.8734416
24187 op-snap---monthly-publication-september-2025.pdf   406 2025-09 Car Suzuki vitara Grey Driving without Due Care and Attention None Smallheath Highway Smallheath Highway Birmingham Birmingham Warning Letter N/A      
24193 op-snap---monthly-publication-september-2025.pdf   412 2025-09 Pedal Bike Mg 4.. Grey Driving without Due Care and Attention None Beake Avenue Beake Avenue Coventry Coventry Warning Letter N/A   52.4388246 -1.5229308
24202 op-snap---monthly-publication-september-2025.pdf   421 2025-09 Car Ford Transit Silver Driving without Due Care and Attention None Coventry Highway Coventry Highway Coventry Coventry Warning Letter N/A   52.4034983 -1.5600081
24218 op-snap---monthly-publication-september-2025.pdf   437 2025-09 Pedal Bike Peugeot 208 Black Driving without Due Care and Attention None Inchlaggon Road Inchlaggon Road Wolverhampton Wolverhampton Warning Letter N/A      
24223 op-snap---monthly-publication-september-2025.pdf   442 2025-09 Car Mitsubishi Shogun Silver Driving without Due Care and Attention None Billingsley Road Billingsley Road Birmingham Birmingham Warning Letter N/A   52.4696617 -1.7890822
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
24239 op-snap---monthly-publication-september-2025.pdf   458 2025-09 Car Peugeot Boxer White Driving without Due Care and Attention None Billesley Lane Billesley Lane Birmingham Birmingham Warning Letter N/A   52.4344402 -1.8845368
24240 op-snap---monthly-publication-september-2025.pdf   459 2025-09 Pedal Bike Toyota Landcruiser Silver Driving without Due Care and Attention None Lordswood Road Lordswood Road Birmingham Birmingham Warning Letter N/A   52.4591339 -1.9601054
24244 op-snap---monthly-publication-september-2025.pdf   463 2025-09 Car Mg ZS Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24262 op-snap---monthly-publication-september-2025.pdf   481 2025-09 Car Ford Galaxy Black Driving without Due Care and Attention None Grove Street Grove Street Wolverhampton Wolverhampton Warning Letter N/A   52.5930351 -2.1050815
24265 op-snap---monthly-publication-september-2025.pdf   484 2025-09 Car Nissan Qashqai Orange Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Warning Letter N/A   52.4073149 -1.5250454
24272 op-snap---monthly-publication-september-2025.pdf   491 2025-09 Car Vauxhall Corsa Red Driving without Due Care and Attention None Reservoir Place Reservoir Place Walsall Walsall Warning Letter N/A   52.5770818 -2.0074916
24281 op-snap---monthly-publication-september-2025.pdf   500 2025-09 Car Mercedes-Benz Sprinter Yellow Driving without Due Care and Attention Use vehicle on a road without valid test certificate Ringway, Swanswell Ringway, Swanswell Coventry Coventry Warning Letter N/A      
24297 op-snap---monthly-publication-september-2025.pdf   516 2025-09 Car Audi A3.. Grey Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
24319 op-snap---monthly-publication-september-2025.pdf   538 2025-09 Car Skoda Octavia White Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A   52.5194011 -1.8008643
24331 op-snap---monthly-publication-september-2025.pdf   550 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Bowstone Road Bowstone Road Birmingham Birmingham Warning Letter N/A      
24362 op-snap---monthly-publication-september-2025.pdf   581 2025-09 Car Mercedes-Benz C220 Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
24367 op-snap---monthly-publication-september-2025.pdf   586 2025-09 Car Skoda Octavia Silver Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24370 op-snap---monthly-publication-september-2025.pdf   589 2025-09 Car Toyota Estima Red Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24371 op-snap---monthly-publication-september-2025.pdf   590 2025-09 Car Volkswagen Polo White Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24389 op-snap---monthly-publication-september-2025.pdf   608 2025-09 Car Volkswagen Golf GTI Black Driving without Due Care and Attention None Camp Hill Camp Hill Birmingham Birmingham Warning Letter N/A   52.4702894 -1.8786299
24392 op-snap---monthly-publication-september-2025.pdf   611 2025-09 Pedal Bike Vauxhall Vivaro Black Driving without Due Care and Attention None Lichfield Road towards Dartmouth Circus Lichfield Road towards Dartmouth Circus Birmingham Birmingham Warning Letter N/A      
24396 op-snap---monthly-publication-september-2025.pdf   615 2025-09 Car BMW 5 series Grey Driving without Due Care and Attention None M6 Northbound, nr Jn4 M6 Northbound, nr Jn4 Birmingham Birmingham Warning Letter N/A      
24399 op-snap---monthly-publication-september-2025.pdf   618 2025-09 Car Dacia Duster Grey Driving without Due Care and Attention None Richard St Richard Street Wolverhampton Wolverhampton Warning Letter N/A      
24406 op-snap---monthly-publication-september-2025.pdf   625 2025-09 Car Vauxhall Zafira Brown Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24420 op-snap---monthly-publication-september-2025.pdf   639 2025-09 Car Seat Leon White Driving without Due Care and Attention None Grove Road Grove Road Birmingham Birmingham Warning Letter N/A   52.4453942 -1.8644982
24427 op-snap---monthly-publication-september-2025.pdf   646 2025-09 Car Nissan Qasqai Grey Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
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
24450 op-snap---monthly-publication-september-2025.pdf   669 2025-09 Car Porsche Macan Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
24462 op-snap---monthly-publication-september-2025.pdf   681 2025-09 Car Volkswagen Tiguan Silver Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Warning Letter N/A   52.4318623 -1.4804069
24474 op-snap---monthly-publication-september-2025.pdf   693 2025-09 Motorbike BMW X3 Black Driving without Due Care and Attention None Sharespeare Drive Sharespeare Drive Solihull Solihull Warning Letter N/A      
24479 op-snap---monthly-publication-september-2025.pdf   698 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Quinton Expressway Quinton Expressway Birmingham Birmingham Warning Letter N/A   52.4491086 -2.0131915
24486 op-snap---monthly-publication-september-2025.pdf   705 2025-09 Car Kia Optima White Driving without Due Care and Attention No vehicle excise licence A38(M) inbound to Birmingham A38(M) inbound to Birmingham Birmingham Birmingham Warning Letter N/A      
24494 op-snap---monthly-publication-september-2025.pdf   713 2025-09 Pedal Bike Citroen C4 Picasso Red Driving without Due Care and Attention None Potters Lane, Wednesbury Potters Lane, Wednesbury Wolverhampton Wolverhampton Warning Letter N/A      
24498 op-snap---monthly-publication-september-2025.pdf   717 2025-09 Pedal Bike Ford Mondeo Silver Driving without Due Care and Attention None Umberslade Road, Stirchley Umberslade Road, Stirchley Birmingham Birmingham Warning Letter N/A   52.4304526 -1.9216716
24512 op-snap---monthly-publication-september-2025.pdf   731 2025-09 Pedal Bike Scania Coach Green Driving without Due Care and Attention None Balsall Street East, Balsall Common Balsall Street East, Balsall Common Coventry Coventry Warning Letter N/A      
24514 op-snap---monthly-publication-september-2025.pdf   733 2025-09 Car BMW M3 Blue Driving without Due Care and Attention None Pleck Road Pleck Road Walsall Walsall Warning Letter N/A   52.5827033 -1.9960274
24520 op-snap---monthly-publication-september-2025.pdf   739 2025-09 Pedal Bike Renault Zoe Blue Driving without Due Care and Attention None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
24584 op-snap---monthly-publication-september-2025.pdf   803 2025-09 Other Audi A1 Black Driving without Due Care and Attention None Waterfront car park 7 Waterfront car park 7 Dudley Dudley Warning Letter N/A      
24586 op-snap---monthly-publication-september-2025.pdf   805 2025-09 Other Audi A4 Grey Driving without Due Care and Attention None Waterfron car park 7 Waterfron car park 7 Dudley Dudley Warning Letter N/A      
24593 op-snap---monthly-publication-september-2025.pdf   812 2025-09 Car Land Rover Discovery Black Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
24622 op-snap---monthly-publication-september-2025.pdf   841 2025-09 Lorry Peugeot 2008.. Black Driving without Due Care and Attention None Willenhall Road - Neachalls Lane Willenhall Road - Neachalls Lane Wolverhampton Wolverhampton Warning Letter N/A      
24624 op-snap---monthly-publication-september-2025.pdf   843 2025-09 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Slade Road Slade Road Birmingham Birmingham Warning Letter N/A   52.5894461 -1.8082962
24660 op-snap---monthly-publication-september-2025.pdf   879 2025-09 Pedestrian Mercedes-Benz A-class Silver Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
24662 op-snap---monthly-publication-september-2025.pdf   881 2025-09 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Formans Road Formans Road Birmingham Birmingham Warning Letter N/A   52.4482024 -1.8507493
24686 op-snap---monthly-publication-september-2025.pdf   905 2025-09 Pedal Bike Audi A1 Green Driving without Due Care and Attention None Marshall Lake Road Marshall Lake Road Solihull Solihull Warning Letter N/A   52.3975426 -1.818252
24731 op-snap---monthly-publication-september-2025.pdf   950 2025-09 Car Mercedes-Benz S class Silver Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A   52.5194011 -1.8008643
24770 op-snap---monthly-publication-september-2025.pdf   989 2025-09 Car BMW 3 series Black Driving without Due Care and Attention None B4121 B4121 Birmingham Birmingham Warning Letter N/A   52.4448693 -1.9772096
24771 op-snap---monthly-publication-september-2025.pdf   990 2025-09 Other Volkswagen EOS Black Driving without Due Care and Attention None Merry Hill Main Car Park Merry Hill Main Car Park Dudley Dudley Warning Letter N/A      
24773 op-snap---monthly-publication-september-2025.pdf   992 2025-09 Car Volkswagen Polo Blue Driving without Due Care and Attention None A34 A34 Birmingham Birmingham Warning Letter N/A      
24775 op-snap---monthly-publication-september-2025.pdf   994 2025-09 Pedal Bike BMW IX3 Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
24789 op-snap---monthly-publication-september-2025.pdf   1008 2025-09 Other Seat MII Red Driving without Due Care and Attention None St Margarets Avenue Street Margarets Avenue Birmingham Birmingham Warning Letter N/A      
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      
24809 op-snap---monthly-publication-september-2025.pdf   1028 2025-09 Pedal Bike Vauxhall Corsa Silver Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham Warning Letter N/A   52.4436471 -1.9604594
24827 op-snap---monthly-publication-september-2025.pdf   1046 2025-09 Car   Dennis Bus   Driving without Due Care and Attention None Adams Hill Road Adams Hill Road Birmingham Birmingham Warning Letter N/A   52.4355492 -2.0043534
24834 op-snap---monthly-publication-september-2025.pdf   1053 2025-09 Car BMW 325D Black Driving without Due Care and Attention None Fordbrook Lane Fordbrook Lane Birmingham Birmingham Warning Letter N/A      
24838 op-snap---monthly-publication-september-2025.pdf   1057 2025-09 Other Seat Leon White Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
24839 op-snap---monthly-publication-september-2025.pdf   1058 2025-09 Other Yamaha Aprilia 125 Black Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
24864 op-snap---monthly-publication-september-2025.pdf   1083 2025-09 Car   Bentley Green Driving without Due Care and Attention None A45 A45 Coventry Coventry 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
24875 op-snap---monthly-publication-september-2025.pdf   1094 2025-09 Other Ford Fiesta Red Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
24876 op-snap---monthly-publication-september-2025.pdf   1095 2025-09 Other Ford Fiesta Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
24883 op-snap---monthly-publication-september-2025.pdf   1102 2025-09 Other Seat Leon Red Driving without Due Care and Attention None Star City Star City Birmingham Birmingham Warning Letter N/A   52.5054363 -1.8556273
24892 op-snap---monthly-publication-september-2025.pdf   1111 2025-09 Car Mercedes-Benz C350 Blue Driving without Due Care and Attention None M6 / M5 Junction M6 / M5 Junction Birmingham Birmingham Warning Letter N/A      
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
24910 op-snap---monthly-publication-september-2025.pdf   1129 2025-09 Car Mercedes-Benz A200 Grey Driving without Due Care and Attention None a4150 A4150 Wolverhampton Wolverhampton Warning Letter N/A      
24916 op-snap---monthly-publication-september-2025.pdf   1135 2025-09 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
24925 op-snap---monthly-publication-september-2025.pdf   1144 2025-09 Car Mini Cooper Red Driving without Due Care and Attention None Four Pound Avenue Four Pound Avenue Coventry Coventry 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);