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

171 rows where disposal = "Warning Letter", month = "2025-05" 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, nfa_rationale

reporter_transport_mode 6

offence 1

  • Driving without Due Care and Attention · 171 ✖

month 1

  • 2025-05 · 171 ✖

disposal 1

  • Warning Letter · 171 ✖
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
18675 op-snap---monthly-publication-may-2025.pdf   37 2025-05 Car Ford Transit White Driving without Due Care and Attention None Eccleshall Road Eccleshall Road Wolverhampton Wolverhampton Warning Letter N/A      
18858 op-snap---monthly-publication-may-2025.pdf   220 2025-05 Car Toyota Yaris White Driving without Due Care and Attention None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton Warning Letter N/A   52.5847884 -2.1341887
18917 op-snap---monthly-publication-may-2025.pdf   279 2025-05 Car Mercedes-Benz Van White Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry Warning Letter N/A   52.4085943 -1.4943275
18967 op-snap---monthly-publication-may-2025.pdf   329 2025-05 Car Mini Cooper Grey Driving without Due Care and Attention None Balsall St Balsall Street Solihull Solihull Warning Letter N/A   52.3826029 -1.6998649
19128 op-snap---monthly-publication-may-2025.pdf   490 2025-05 Pedal Bike Toyota Prius Red Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham Warning Letter N/A   52.4299657 -1.9599121
19129 op-snap---monthly-publication-may-2025.pdf   491 2025-05 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham Warning Letter N/A   52.4299657 -1.9599121
19200 op-snap---monthly-publication-may-2025.pdf   562 2025-05 Car BMW 530.. Blue Driving without Due Care and Attention None Bickenhill parkway Bickenhill parkway Birmingham Birmingham Warning Letter N/A      
19201 op-snap---monthly-publication-may-2025.pdf   563 2025-05 Car Volvo XC40. Grey Driving without Due Care and Attention None Bickenhill Parkway Bickenhill Parkway Birmingham Birmingham Warning Letter N/A      
19209 op-snap---monthly-publication-may-2025.pdf   571 2025-05 Car Nissan Leaf Blue Driving without Due Care and Attention None Solihull Lodge Solihull Lodge Solihull Solihull Warning Letter N/A   52.4048909 -1.8577716
19224 op-snap---monthly-publication-may-2025.pdf   586 2025-05 Car Mercedes-Benz 310 Blue Driving without Due Care and Attention None Heath Street Heath Street Sandwell Sandwell Warning Letter n/a   52.4919542 -1.9467735
19228 op-snap---monthly-publication-may-2025.pdf   590 2025-05 Car Volkswagen Passat Grey Driving without Due Care and Attention None Cateeswell Rd Cateeswell Road Birmingham Birmingham Warning Letter N/A      
19240 op-snap---monthly-publication-may-2025.pdf   602 2025-05 Car Ford Kuga Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
19250 op-snap---monthly-publication-may-2025.pdf   612 2025-05 Pedestrian Ford Transit White Driving without Due Care and Attention None Old Walsall Road/ Spouthouse Lane Old Walsall Road/ Spouthouse Lane Birmingham Birmingham Warning Letter N/A   52.5294399 -1.9282714
19283 op-snap---monthly-publication-may-2025.pdf   645 2025-05 Car Mercedes-Benz CLS350 Black Driving without Due Care and Attention None Gibbett Hill Road Gibbett Hill Road Coventry Coventry Warning Letter N/A   52.3744413 -1.553746
19311 op-snap---monthly-publication-may-2025.pdf   673 2025-05 Car Peugeot 308.. Grey Driving without Due Care and Attention None Wednesbury Road Wednesbury Road Wolverhampton Wolverhampton Warning Letter N/A      
19313 op-snap---monthly-publication-may-2025.pdf   675 2025-05 Car Audi Q3 White Driving without Due Care and Attention None Newbury Rd Newbury Road Birmingham Birmingham Warning Letter N/A   52.4993019 -1.8964495
19348 op-snap---monthly-publication-may-2025.pdf   710 2025-05 Car Renault Megane Black Driving without Due Care and Attention None Spouthouse Lane Spouthouse Lane Birmingham Birmingham Warning Letter N/A   52.5390972 -1.9319478
19366 op-snap---monthly-publication-may-2025.pdf   728 2025-05 Other Citroen DS3 Black Driving without Due Care and Attention None Waterfront car park 7 Waterfront car park 7 Dudley Dudley Warning Letter N/A      
19416 op-snap---monthly-publication-may-2025.pdf   778 2025-05 Car Mercedes-Benz E220. Black Driving without Due Care and Attention None M42 M42 Birmingham Birmingham Warning Letter N/A      
19428 op-snap---monthly-publication-may-2025.pdf   790 2025-05 Car Seat Leon Red Driving without Due Care and Attention None M6 Southbound, Jn4A M6 Southbound, Jn4A Birmingham Birmingham Warning Letter N/A      
19429 op-snap---monthly-publication-may-2025.pdf   791 2025-05 Car Volkswagen Golf Silver Driving without Due Care and Attention None A4123 Birmingham New Road Birmingham New Road Sandwell Sandwell Warning Letter N/A   52.5151598 -2.064717
19431 op-snap---monthly-publication-may-2025.pdf   793 2025-05 Car Vauxhall Corsa Black Driving without Due Care and Attention None Level Street Level Street Dudley Dudley Warning Letter N/A   52.4850236 -2.1088919
19464 op-snap---monthly-publication-may-2025.pdf   826 2025-05 Car Suzuki Alto Red Driving without Due Care and Attention None wake green road Wake Green Road Birmingham Birmingham Warning Letter N/A   52.4437078 -1.8783408
19488 op-snap---monthly-publication-may-2025.pdf   850 2025-05 Car BMW 7 Series White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A   52.4816806 -1.8788939
19511 op-snap---monthly-publication-may-2025.pdf   873 2025-05 Car Hyundai I 10. Blue Driving without Due Care and Attention None Station Road Wythall Birmingham Station Road Wythall Birmingham Birmingham Birmingham Warning Letter N/A      
19513 op-snap---monthly-publication-may-2025.pdf   875 2025-05 Pedal Bike Peugeot 3008 White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
19518 op-snap---monthly-publication-may-2025.pdf   880 2025-05 Car Audi Q7 Black Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull Warning Letter N/A   52.4322443 -1.6746508
19528 op-snap---monthly-publication-may-2025.pdf   890 2025-05 Car BMW 740.. Silver Driving without Due Care and Attention None Aston Expressway Aston Expressway Birmingham Birmingham Warning Letter N/A   52.493793 -1.8881773
19562 op-snap---monthly-publication-may-2025.pdf   924 2025-05 Car Renault Trafic Black Driving without Due Care and Attention None Maypole Island Maypole Island Birmingham Birmingham Warning Letter N/A   52.4047413 -1.8859323
19579 op-snap---monthly-publication-may-2025.pdf   941 2025-05 Car Toyota Yaris Black Driving without Due Care and Attention None Garretts Green Lane Garretts Green Lane Birmingham Birmingham Warning Letter N/A   52.4675802 -1.7905748
19583 op-snap---monthly-publication-may-2025.pdf   945 2025-05 Car Ford Fiesta Silver Driving without Due Care and Attention None Sharmans Close Sharmans Close Solihull Solihull Warning Letter N/A      
19584 op-snap---monthly-publication-may-2025.pdf   946 2025-05 Car Mercedes-Benz A Class Black Driving without Due Care and Attention None Sharmans Cross Road Sharmans Cross Road Solihull Solihull Warning Letter N/A   52.4167172 -1.7990388
19585 op-snap---monthly-publication-may-2025.pdf   947 2025-05 Car Peugeot 3008 White Driving without Due Care and Attention None Hamstesd Rd Hamstesd Road Birmingham Birmingham Warning Letter N/A      
19606 op-snap---monthly-publication-may-2025.pdf   968 2025-05 Pedal Bike Citroen C4 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
19608 op-snap---monthly-publication-may-2025.pdf   970 2025-05 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
19611 op-snap---monthly-publication-may-2025.pdf   973 2025-05 Car Seat Leon Black Driving without Due Care and Attention None Highgate Road Highgate Road Birmingham Birmingham Warning Letter N/A   52.4606652 -1.8791145
19643 op-snap---monthly-publication-may-2025.pdf   1005 2025-05 Pedal Bike Volvo HGV Green Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
19666 op-snap---monthly-publication-may-2025.pdf   1028 2025-05 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Woodclose Rd Woodclose Road Birmingham Birmingham Warning Letter N/A      
19681 op-snap---monthly-publication-may-2025.pdf   1043 2025-05 Pedal Bike BMW X1 Blue Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19682 op-snap---monthly-publication-may-2025.pdf   1044 2025-05 Pedal Bike Mercedes-Benz GLB Silver Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19683 op-snap---monthly-publication-may-2025.pdf   1045 2025-05 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
20125 op-snap---monthly-publication-may-2025.pdf   1487 2025-05 Car Seat Leon Black Driving without Due Care and Attention None Eastfield Road Eastfield Road Wolverhampton Wolverhampton Warning Letter N/A   52.5858674 -2.1052384
20126 op-snap---monthly-publication-may-2025.pdf   1488 2025-05 Pedestrian Mercedes-Benz E350 White Driving without Due Care and Attention None Greswolde Road Greswolde Road Birmingham Birmingham Warning Letter N/A   52.4455718 -1.861478
20127 op-snap---monthly-publication-may-2025.pdf   1489 2025-05 Pedestrian Honda Jazz Black Driving without Due Care and Attention None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
20128 op-snap---monthly-publication-may-2025.pdf   1490 2025-05 Pedestrian Renault scenic Blue Driving without Due Care and Attention None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
20129 op-snap---monthly-publication-may-2025.pdf   1491 2025-05 Car Honda Jazz Black Driving without Due Care and Attention None Kennilworth Road Kennilworth Road Coventry Coventry Warning Letter N/A      
20131 op-snap---monthly-publication-may-2025.pdf   1493 2025-05 Pedestrian Tesla   Blue Driving without Due Care and Attention None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
20133 op-snap---monthly-publication-may-2025.pdf   1495 2025-05 Pedestrian BMW 3 Series Grey Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
20135 op-snap---monthly-publication-may-2025.pdf   1497 2025-05 Car Scania   White Driving without Due Care and Attention None Wharfdale Road Wharfdale Road Birmingham Birmingham Warning Letter N/A   52.4554916 -1.8300959
20149 op-snap---monthly-publication-may-2025.pdf   1511 2025-05 Pedal Bike Ford focus Silver Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham Warning Letter N/A   52.5148331 -1.79231
20150 op-snap---monthly-publication-may-2025.pdf   1512 2025-05 Car Mercedes-Benz GLC White Driving without Due Care and Attention None A34 Perry Barr Perry Barr Birmingham Birmingham Warning Letter N/A   52.516903 -1.9012399
20152 op-snap---monthly-publication-may-2025.pdf   1514 2025-05 Horse Rider BMW 420 Grey Driving without Due Care and Attention None Hawthorns Road, Drysbrook (off forc Hawthorns Road, Drysbrook (off forc eO)ut of Force Area Eo)Ut Of Force Area Warning Letter N/A      
20154 op-snap---monthly-publication-may-2025.pdf   1516 2025-05 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Shidas Lane Shidas Lane Sandwell Sandwell Warning Letter N/A   52.501103 -2.0254412
20159 op-snap---monthly-publication-may-2025.pdf   1521 2025-05 Pedal Bike Audi q7 White Driving without Due Care and Attention None Price Street Price Street Sandwell Sandwell Warning Letter N/A   52.5173895 -1.9973426
20160 op-snap---monthly-publication-may-2025.pdf   1522 2025-05 Car Suzuki sx4 Black Driving without Due Care and Attention None Park Lane West Park Lane West Sandwell Sandwell Warning Letter N/A   52.5227061 -2.0617482
20161 op-snap---monthly-publication-may-2025.pdf   1523 2025-05 Car Mini Cooper Black Driving without Due Care and Attention None Halesowen Road Halesowen Road Sandwell Sandwell Warning Letter N/A   52.4727241 -2.0645309
20162 op-snap---monthly-publication-may-2025.pdf   1524 2025-05 Car Mini Cooper s Black Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Warning Letter N/A   52.4624413 -2.0175178
20170 op-snap---monthly-publication-may-2025.pdf   1532 2025-05 Pedal Bike Volkswagen Caddy White Driving without Due Care and Attention None Genners lane Genners lane birmingham Birmingham Warning Letter N/A   52.4282602 -1.9861769
20179 op-snap---monthly-publication-may-2025.pdf   1541 2025-05 Car Ford Fiesta White Driving without Due Care and Attention None Weeford Interchange Weeford Interchange Birmingham Birmingham Warning Letter N/A      
20180 op-snap---monthly-publication-may-2025.pdf   1542 2025-05 Pedal Bike Audi Q3 Black Driving without Due Care and Attention None Bristol St Bristol Street Birmingham Birmingham Warning Letter N/A   52.4691145 -1.9003257
20181 op-snap---monthly-publication-may-2025.pdf   1543 2025-05 Car Honda NSC 110-M White Driving without Due Care and Attention None Pope Street Pope Street Birmingham Birmingham Warning Letter N/A   52.4852929 -1.9163779
20183 op-snap---monthly-publication-may-2025.pdf   1545 2025-05 Pedal Bike Mercedes-Benz A class Black Driving without Due Care and Attention none Ansty Road Ansty Road Coventry Coventry Warning Letter N/A   52.4205675 -1.4520187
20188 op-snap---monthly-publication-may-2025.pdf   1550 2025-05 Pedal Bike Ford Transit Blue Driving without Due Care and Attention none Ansty Road Ansty Road Coventry Coventry Warning Letter N/A   52.4205675 -1.4520187
20190 op-snap---monthly-publication-may-2025.pdf   1552 2025-05 Pedestrian Tesla Model Y Grey Driving without Due Care and Attention none Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
20191 op-snap---monthly-publication-may-2025.pdf   1553 2025-05 Pedestrian BMW IX3 Grey Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
20192 op-snap---monthly-publication-may-2025.pdf   1554 2025-05 Car Vauxhall Astra grey Driving without Due Care and Attention none Prescot Road Prescot Road Dudley Dudley Warning Letter N/A   52.448888 -2.1286977
20193 op-snap---monthly-publication-may-2025.pdf   1555 2025-05 Car Volkswagen Tiguan Grey Driving without Due Care and Attention none Coventry Road A45 Coventry Road A45 Birmingham Birmingham Warning Letter N/A   52.4516899 -1.7753139
20197 op-snap---monthly-publication-may-2025.pdf   1559 2025-05 Pedal Bike Nissan Juke Silver Driving without Due Care and Attention None Pershore road South Pershore road South Birmingham Birmingham Warning Letter N/A   52.4150779 -1.930901
20198 op-snap---monthly-publication-may-2025.pdf   1560 2025-05 Car Mercedes-Benz A Class Blue Driving without Due Care and Attention none M6 Motorway, Northbound M6 Motorway, Northbound Birmingham Birmingham Warning Letter N/A      
20214 op-snap---monthly-publication-may-2025.pdf   1576 2025-05 Pedal Bike Volkswagen transporter Silver Driving without Due Care and Attention VRM fails to conform t oL iRckeegyu Rlaotiaodns o L i Rckeegyu Rlaotiaodns Birmingham Birmingham Warning Letter N/A      
20221 op-snap---monthly-publication-may-2025.pdf   1583 2025-05 Car Suzuki SV1000 Silver Driving without Due Care and Attention None Leicester Road Leicester Road Out of Force Area Out of Force Area Warning Letter N/A   52.5929765 -2.1404343
20226 op-snap---monthly-publication-may-2025.pdf   1588 2025-05 Car Ford Puma Blue Driving without Due Care and Attention None Cock Hill Lane, Rubery Cock Hill Lane, Rubery Birmingham Birmingham Warning Letter N/A      
20227 op-snap---monthly-publication-may-2025.pdf   1589 2025-05 Car Skoda Fabia Silver Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Warning Letter N/A   52.4624413 -2.0175178
20229 op-snap---monthly-publication-may-2025.pdf   1591 2025-05 Pedal Bike Ford Focus White Driving without Due Care and Attention None Bucklands End, Kitts Green Bucklands End, Kitts Green Birmingham Birmingham Warning Letter N/A   52.4980357 -1.8006813
20230 op-snap---monthly-publication-may-2025.pdf   1592 2025-05 Car     Green Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
20232 op-snap---monthly-publication-may-2025.pdf   1594 2025-05 Car Audi Q2 Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20233 op-snap---monthly-publication-may-2025.pdf   1595 2025-05 Car Hyundai I10 Green Driving without Due Care and Attention None Willenhall road Willenhall road Wolverhampton Wolverhampton Warning Letter N/A   52.5836778 -2.0894997
20236 op-snap---monthly-publication-may-2025.pdf   1598 2025-05 Pedestrian Audi A3 Grey Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
20237 op-snap---monthly-publication-may-2025.pdf   1599 2025-05 Pedal Bike Mercedes-Benz c200 Silver Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
20238 op-snap---monthly-publication-may-2025.pdf   1600 2025-05 Car Nissan Qashqi Orange Driving without Due Care and Attention None Medow Park, Coventry Medow Park, Coventry Coventry Coventry Warning Letter N/A      
20239 op-snap---monthly-publication-may-2025.pdf   1601 2025-05 Car Ford Mondeo Silver Driving without Due Care and Attention None Norwood Road, Brierley Hill Norwood Road, Brierley Hill Dudley Dudley Warning Letter N/A   52.4831397 -2.1309273
20246 op-snap---monthly-publication-may-2025.pdf   1608 2025-05 Car Toyota Yaris Grey Driving without Due Care and Attention None Underhill Lane Underhill Lane Wolverhampton Wolverhampton Warning Letter N/A   52.6184526 -2.0954562
20247 op-snap---monthly-publication-may-2025.pdf   1609 2025-05 Pedal Bike BMW 1 Series Black Driving without Due Care and Attention none Chester road Chester road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20248 op-snap---monthly-publication-may-2025.pdf   1610 2025-05 Car Audi A3 Black Driving without Due Care and Attention None Small Heath highway Small Heath highway Birmingham Birmingham Warning Letter N/A   52.4709298 -1.8722585
20249 op-snap---monthly-publication-may-2025.pdf   1611 2025-05 Car Toyota MPV White Driving without Due Care and Attention None Covnetry Road Covnetry Road Birmingham Birmingham Warning Letter N/A      
20254 op-snap---monthly-publication-may-2025.pdf   1616 2025-05 Car Audi S3 Black Driving without Due Care and Attention None Lea Ford Road Lea Ford Road Birmingham Birmingham Warning Letter N/A   52.4882128 -1.7814913
20257 op-snap---monthly-publication-may-2025.pdf   1619 2025-05 Car Toyota Estima White Driving without Due Care and Attention None sutton rd Sutton Rd Birmingham Birmingham Warning Letter N/A   52.5346721 -1.827743
20259 op-snap---monthly-publication-may-2025.pdf   1621 2025-05 Car Mini JCP Cooper S Black Driving without Due Care and Attention None A452 A452 Birmingham Birmingham Warning Letter N/A      
20261 op-snap---monthly-publication-may-2025.pdf   1623 2025-05 Car Audi A3 Black Driving without Due Care and Attention None Cole Hall Lane Cole Hall Lane Birmingham Birmingham Warning Letter N/A   52.4877244 -1.787883
20264 op-snap---monthly-publication-may-2025.pdf   1626 2025-05 Car Volkswagen Polo White Driving without Due Care and Attention None Out Of Force Out Of Force Out of Force Area Out of Force Area Warning Letter N/A      
20265 op-snap---monthly-publication-may-2025.pdf   1627 2025-05 Car Volvo XC60 Grey Driving without Due Care and Attention None Balds Lane Balds Lane Dudley Dudley Warning Letter N/A   52.455416 -2.1051567
20267 op-snap---monthly-publication-may-2025.pdf   1629 2025-05 Car BMW IX3 Blue Driving without Due Care and Attention None Chester Avenue Chester Avenue Birmingham Birmingham Warning Letter N/A      
20271 op-snap---monthly-publication-may-2025.pdf   1633 2025-05 Car Ford Fiesta Grey Driving without Due Care and Attention none meriden Meriden Coventry Coventry Warning Letter N/A   52.4233575 -1.4380372
20273 op-snap---monthly-publication-may-2025.pdf   1635 2025-05 Pedal Bike Mercedes-Benz A 180 Silver Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
20274 op-snap---monthly-publication-may-2025.pdf   1636 2025-05 Car Fiat 500 Orange Driving without Due Care and Attention None Chapel Ash Chapel Ash Wolverhampton Wolverhampton Warning Letter N/A   52.5857494 -2.1409393
20277 op-snap---monthly-publication-may-2025.pdf   1639 2025-05 Car Mitsubishi outlander Silver Driving without Due Care and Attention None New Swan Lane New Swan Lane Sandwell Sandwell Warning Letter N/A   52.5293372 -2.0107584
20280 op-snap---monthly-publication-may-2025.pdf   1642 2025-05 Car Ford focus Black Driving without Due Care and Attention None Stourbridge Road Stourbridge Road Dudley Dudley Warning Letter N/A   52.5002997 -2.1081386
20282 op-snap---monthly-publication-may-2025.pdf   1644 2025-05 Car BMW 330E Grey Driving without Due Care and Attention Contravening a Red T rBarffoica dL iLgahnte r Barffoica d L i Lgahnte Coventry Coventry Warning Letter N/A      
20285 op-snap---monthly-publication-may-2025.pdf   1647 2025-05 Car Suzuki motorcycle Black Driving without Due Care and Attention No Insurance Out of force Out of force Out of Force Area Out of Force Area Warning Letter N/A      
20286 op-snap---monthly-publication-may-2025.pdf   1648 2025-05 Other Honda Civic Black Driving without Due Care and Attention None Stone Street Stone Street Dudley Dudley Warning Letter N/A   52.5104511 -2.0836025

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