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

129 rows where disposal = "Warning Letter", offence = "Driving without Due Care and Attention" and vehicle_make = "BMW" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

month 14

  • 2025-07 20
  • 2025-08 19
  • 2025-05 18
  • 2025-06 14
  • 2025-03 13
  • 2025-09 12
  • 2025-10 8
  • 2026-01 7
  • 2025-01 6
  • 2025-11 4
  • 2025-12 3
  • 2025-02 2
  • 2026-02 2
  • 2025-04 1

council_area 12

  • Birmingham 69
  • Dudley 14
  • Coventry 10
  • Sandwell 8
  • Walsall 8
  • Solihull 7
  • Wolverhampton 6
  • Metropolitan Borough Of Dudley 2
  • Sutton Coldfield 2
  • Eo)Ut Of Force Area 1
  • Halesowen 1
  • Out of Force Area 1

reporter_transport_mode 7

  • Car 89
  • Pedal Bike 14
  • Pedestrian 13
  • Other 7
  • Motorbike 4
  • Bus 1
  • Horse Rider 1

vehicle_make 1

  • BMW · 129 ✖

offence 1

  • Driving without Due Care and Attention · 129 ✖

disposal 1

  • Warning Letter · 129 ✖
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
8407 op-snap---monthly-publication-february-2026.pdf   1154 2026-02 Car BMW 220.. Grey Driving without Due Care and Attention No Insurance Spring Road Tysley Spring Road Tysley Birmingham Birmingham Warning Letter N/A      
8782 op-snap---monthly-publication-february-2026.pdf   1529 2026-02 Pedestrian BMW 118.. Blue Driving without Due Care and Attention None Perry Street at Potters Lane Wednesbury Perry Street at Potters Lane Wednesbury Sandwell Sandwell Warning Letter N/A   52.5004634 -1.9710382
11210 op-snap---monthly-publication-january-2026.pdf   671 2026-01 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Warning Letter N/A   52.4061531 -1.505845
11265 op-snap---monthly-publication-january-2026.pdf   726 2026-01 Other BMW 318d Grey Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
11266 op-snap---monthly-publication-january-2026.pdf   727 2026-01 Other BMW 323i White Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
11367 op-snap---monthly-publication-january-2026.pdf   828 2026-01 Pedal Bike BMW X4 Blue Driving without Due Care and Attention None South Road South Road Birmingham Birmingham Warning Letter N/A   52.4972567 -1.9214327
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
11541 op-snap---monthly-publication-january-2026.pdf   1002 2026-01 Car BMW 5 Series Blue Driving without Due Care and Attention None M6 J3A M6 J3A Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.6912652 -2.1043715
11775 op-snap---monthly-publication-january-2026.pdf   1236 2026-01 Car BMW 218I White Driving without Due Care and Attention None Stourbridge Road Stourbridge Road Wolverhampton Wolverhampton Warning Letter N/A      
4002 op-snap---monthly-publication-december-2025.pdf   130 2025-12 Car BMW 3 Series Grey Driving without Due Care and Attention None Stafford St Stafford Street Wolverhampton Wolverhampton Warning Letter N/A   52.5653849 -2.0755665
4621 op-snap---monthly-publication-december-2025.pdf   749 2025-12 Car BMW 840i Black Driving without Due Care and Attention None M5 NB J1 M5 Northbound J1 Sandwell Sandwell Warning Letter N/A      
4963 op-snap---monthly-publication-december-2025.pdf   1091 2025-12 Car BMW 1 series Blue Driving without Due Care and Attention None Warstock Road Warstock Road Birmingham Birmingham Warning Letter N/A   52.413031 -1.8782144
20556 op-snap---monthly-publication-november-2025.pdf   98 2025-11 Car BMW 320.. Blue Driving without Due Care and Attention None M5 Northbound... ? M5 Northbound. ? Birmingham Birmingham Warning Letter N/A      
20764 op-snap---monthly-publication-november-2025.pdf   306 2025-11 Car BMW 335i Blue Driving without Due Care and Attention None Hockley Circus Hockley Circus Birmingham Birmingham Warning Letter N/A   52.4952382 -1.9146705
20939 op-snap---monthly-publication-november-2025.pdf   481 2025-11 Car BMW 420D Grey Driving without Due Care and Attention None Coopers Lane Coopers Lane Sandwell Sandwell Warning Letter N/A   52.4921093 -1.9705849
22042 op-snap---monthly-publication-november-2025.pdf   1584 2025-11 Car BMW 420D Grey Driving without Due Care and Attention None A456 A456 Birmingham Birmingham Warning Letter N/A      
22118 op-snap---monthly-publication-october-2025.pdf   68 2025-10 Car BMW X3 Grey Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Warning Letter N/A      
22215 op-snap---monthly-publication-october-2025.pdf   165 2025-10 Car BMW 320d Blue Driving without Due Care and Attention None Great Barr St Great Barr Street Birmingham Birmingham Warning Letter N/A   52.4795188 -1.8770102
22305 op-snap---monthly-publication-october-2025.pdf   255 2025-10 Pedestrian BMW M140.. Yellow Driving without Due Care and Attention None Upper High Street Wednesbury Upper High Street Wednesbury Sandwell Sandwell Warning Letter N/A   52.5533962 -2.0204699
22676 op-snap---monthly-publication-october-2025.pdf   626 2025-10 Car BMW M3 White Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Warning Letter n/a   52.4656414 -1.9852276
22975 op-snap---monthly-publication-october-2025.pdf   925 2025-10 Car BMW X5 Black Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
23070 op-snap---monthly-publication-october-2025.pdf   1020 2025-10 Car BMW 3 series Grey Driving without Due Care and Attention None A4053 Coventry Ring Road Coventry Ring Road Coventry Coventry Warning Letter N/A      
23738 op-snap---monthly-publication-october-2025.pdf   1688 2025-10 Pedestrian BMW 520D White Driving without Due Care and Attention None Oxford Road Oxford Road Birmingham Birmingham Warning Letter N/A   52.4456323 -1.8858352
23739 op-snap---monthly-publication-october-2025.pdf   1689 2025-10 Car BMW 320i Grey Driving without Due Care and Attention None M42 M42 Birmingham Birmingham Warning Letter N/A      
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
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      
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      
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
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
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
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      
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
25009 op-snap---monthly-publication-september-2025.pdf   1228 2025-09 Pedestrian BMW 1 Series White Driving without Due Care and Attention None M6 southbound M6 southbound Birmingham Birmingham Warning Letter N/A      
25068 op-snap---monthly-publication-september-2025.pdf   1287 2025-09 Car BMW 318d Grey Driving without Due Care and Attention None st saviours road St Saviours Road Birmingham Birmingham Warning Letter N/A   52.4850522 -1.853815
25219 op-snap---monthly-publication-september-2025.pdf   1438 2025-09 Car BMW M235 Black Driving without Due Care and Attention None three Shires Oak three Shires Oak Birmingham Birmingham Warning Letter N/A      
25248 op-snap---monthly-publication-september-2025.pdf   1467 2025-09 Car BMW 1 Series Grey Driving without Due Care and Attention None Spring Ln Spring Lane Walsall Walsall Warning Letter N/A   52.6203096 -1.9547526
2056 op-snap---monthly-publication-august-2025.pdf   31 2025-08 Car BMW X3 Black Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Warning Letter N/A      
2102 op-snap---monthly-publication-august-2025.pdf   77 2025-08 Car BMW 320.. Blue Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
2301 op-snap---monthly-publication-august-2025.pdf   276 2025-08 Car BMW 325d Silver Driving without Due Care and Attention None Thompson Avenue Thompson Avenue Wolverhampton Wolverhampton Warning Letter N/A   52.5722181 -2.1205684
2428 op-snap---monthly-publication-august-2025.pdf   403 2025-08 Motorbike BMW 5 series White Driving without Due Care and Attention None Alcester Road / Salisbury Road Alcester Road / Salisbury Road Birmingham Birmingham Warning Letter N/A   52.4467548 -1.8880528
2529 op-snap---monthly-publication-august-2025.pdf   504 2025-08 Motorbike BMW X5 Blue Driving without Due Care and Attention None Holbeach Road Holbeach Road Dudley Dudley Warning Letter N/A      
2548 op-snap---monthly-publication-august-2025.pdf   523 2025-08 Car BMW 1 series Grey Driving without Due Care and Attention None Lower Prestwood Road Lower Prestwood Road Wolverhampton Wolverhampton Warning Letter N/A   52.609833 -2.0871598
2648 op-snap---monthly-publication-august-2025.pdf   623 2025-08 Pedal Bike BMW X1 Grey Driving without Due Care and Attention None Manor Road Manor Road Solihull Solihull Warning Letter N/A   52.4193737 -1.7798629
2709 op-snap---monthly-publication-august-2025.pdf   684 2025-08 Car BMW M3 Grey Driving without Due Care and Attention None Birmingham New Road Bilston Birmingham New Road Bilston Wolverhampton Wolverhampton Warning Letter N/A      
2757 op-snap---monthly-publication-august-2025.pdf   732 2025-08 Car BMW 320D Blue Driving without Due Care and Attention None Green Lane Green Lane Coventry Coventry Warning Letter N/A   52.38188 -1.5300381
2877 op-snap---monthly-publication-august-2025.pdf   852 2025-08 Car BMW 335.. White Driving without Due Care and Attention None Bridge Road Saltley Bridge Road Saltley Birmingham Birmingham Warning Letter N/A   52.4857537 -1.8531485
3023 op-snap---monthly-publication-august-2025.pdf   998 2025-08 Pedestrian BMW X3 White Driving without Due Care and Attention None Clapgate Lane Clapgate Lane Birmingham Birmingham Warning Letter N/A   52.4417035 -1.9902817
3175 op-snap---monthly-publication-august-2025.pdf   1150 2025-08 Car BMW 1 series White Driving without Due Care and Attention None Silver Eagle Way Silver Eagle Way Coventry Coventry Warning Letter N/A      
3217 op-snap---monthly-publication-august-2025.pdf   1192 2025-08 Car BMW 218D White Driving without Due Care and Attention None Aldrige Road Aldridge Road Birmingham Birmingham Warning Letter N/A   52.5368764 -1.8976461
3377 op-snap---monthly-publication-august-2025.pdf   1352 2025-08 Car BMW M340d Grey Driving without Due Care and Attention None Bishopsgate Street Bishopsgate Street Birmingham Birmingham Warning Letter N/A   52.473986 -1.9147087
3404 op-snap---monthly-publication-august-2025.pdf   1379 2025-08 Car BMW 318I Red Driving without Due Care and Attention None M6 South Bound towards junction 7 M6 South Bound towards junction 7 Birmingham Birmingham Warning Letter N/A      
3459 op-snap---monthly-publication-august-2025.pdf   1434 2025-08 Car BMW X5 Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Warning Letter N/A   52.5478387 -2.0943116
3563 op-snap---monthly-publication-august-2025.pdf   1538 2025-08 Car BMW X6 Black Driving without Due Care and Attention None Keepers Lane Keepers Lane Wolverhampton Wolverhampton Warning Letter N/A   52.615585 -2.1878558
3594 op-snap---monthly-publication-august-2025.pdf   1569 2025-08 Pedestrian BMW X5 Blue Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
3614 op-snap---monthly-publication-august-2025.pdf   1589 2025-08 Car BMW X4 Grey Driving without Due Care and Attention None Outside Westwood Academy School Outside Westwood Academy School Birmingham Birmingham Warning Letter N/A      
12111 op-snap---monthly-publication-july-2025.pdf   163 2025-07 Car BMW 3 SERIES Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Warning Letter N/A   52.5517052 -1.7825505
12198 op-snap---monthly-publication-july-2025.pdf   250 2025-07 Car BMW   Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
12213 op-snap---monthly-publication-july-2025.pdf   265 2025-07 Car BMW 318.. White Driving without Due Care and Attention None Bath Row Bath Row Birmingham Birmingham Warning Letter N/A   52.472238 -1.9127983
12219 op-snap---monthly-publication-july-2025.pdf   271 2025-07 Other BMW 330.. White Driving without Due Care and Attention None Waterfrnt Car Park Waterfrnt Car Park Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A      
12270 op-snap---monthly-publication-july-2025.pdf   322 2025-07 Pedal Bike BMW 220i White Driving without Due Care and Attention None Woodbourne Road Woodbourne Road Birmingham Birmingham Warning Letter N/A   52.4702361 -1.951945
12789 op-snap---monthly-publication-july-2025.pdf   841 2025-07 Car BMW X4.. Grey Driving without Due Care and Attention None M6 Jct 10 M6 Junction 10 Walsall Walsall Warning Letter N/A   52.676119 -2.0858425
12791 op-snap---monthly-publication-july-2025.pdf   843 2025-07 Other BMW 135.. Blue Driving without Due Care and Attention None Beacon Park Farm Beacon Park Farm Walsall Walsall Warning Letter N/A      
12806 op-snap---monthly-publication-july-2025.pdf   858 2025-07 Other BMW 116.. Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.5846796 -1.9935385
12913 op-snap---monthly-publication-july-2025.pdf   965 2025-07 Car BMW X2 Black Driving without Due Care and Attention None Valbourne Road Valbourne Road Birmingham Birmingham Warning Letter N/A   52.4165707 -1.9062691
13159 op-snap---monthly-publication-july-2025.pdf   1211 2025-07 Car BMW   Grey Driving without Due Care and Attention None Dartmouth Circus Dartmouth Circus Birmingham Birmingham Warning Letter N/A   52.4926487 -1.8879638
13224 op-snap---monthly-publication-july-2025.pdf   1276 2025-07 Car BMW 218i White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
13321 op-snap---monthly-publication-july-2025.pdf   1373 2025-07 Car BMW 520D Blue Driving without Due Care and Attention None M42 Northbound M42 Northbound Birmingham Birmingham Warning Letter N/A      
13419 op-snap---monthly-publication-july-2025.pdf   1471 2025-07 Car BMW 730 Beige Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Warning Letter N/A   52.4103191 -1.8670224
13574 op-snap---monthly-publication-july-2025.pdf   1626 2025-07 Car BMW 320D White Driving without Due Care and Attention None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
13783 op-snap---monthly-publication-july-2025.pdf   1835 2025-07 Car BMW 430D Blue Driving without Due Care and Attention None M6 Northbound between jct 9 and 10 M6 Northbound between jct 9 and 10 Walsall Walsall Warning Letter N/A   52.676119 -2.0858425
13923 op-snap---monthly-publication-july-2025.pdf   1975 2025-07 Pedal Bike BMW I20 Green Driving without Due Care and Attention None Bristol Street Bristol Street Birmingham Birmingham Warning Letter N/A   52.4691145 -1.9003257
13950 op-snap---monthly-publication-july-2025.pdf   2002 2025-07 Pedal Bike BMW 120D Brown Driving without Due Care and Attention None Queensland Avenue Queensland Avenue Coventry Coventry Warning Letter N/A   52.406658 -1.5363495
13978 op-snap---monthly-publication-july-2025.pdf   2030 2025-07 Pedestrian BMW M3 Green Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
13999 op-snap---monthly-publication-july-2025.pdf   2051 2025-07 Car BMW 3 series Silver Driving without Due Care and Attention None M6 Manchester out of force area M6 Manchester out of force area Out of Force Area Out of Force Area Warning Letter N/A      
14009 op-snap---monthly-publication-july-2025.pdf   2061 2025-07 Pedal Bike BMW 330D Black Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
14100 op-snap---monthly-publication-june-2025.pdf   29 2025-06 Car BMW X6 White Driving without Due Care and Attention None Rowleys Green Roundabout Rowleys Green Roundabout Coventry Coventry Warning Letter N/A   52.4486967 -1.4991069
14190 op-snap---monthly-publication-june-2025.pdf   119 2025-06 Car BMW X3 Black Driving without Due Care and Attention None Ebrook Road Ebrook Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5557273 -1.8159805
14203 op-snap---monthly-publication-june-2025.pdf   132 2025-06 Car BMW 440i Blue Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Warning Letter N/A   52.4428606 -1.812114
14389 op-snap---monthly-publication-june-2025.pdf   318 2025-06 Car BMW 118i White Driving without Due Care and Attention None McKean Road Mc Kean Road Sandwell Sandwell Warning Letter N/A   52.5077405 -2.0124813
14444 op-snap---monthly-publication-june-2025.pdf   373 2025-06 Car BMW X3 Grey Driving without Due Care and Attention None Barnes Hill Barnes Hill Birmingham Birmingham Warning Letter N/A   52.4401325 -1.9785938
14848 op-snap---monthly-publication-june-2025.pdf   777 2025-06 Car BMW 520e Silver Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Warning Letter N/A   52.4624743 -1.7763934
14870 op-snap---monthly-publication-june-2025.pdf   799 2025-06 Car BMW 530d Grey Driving without Due Care and Attention None Monkspath Hall Road Monkspath Hall Road Solihull Solihull Warning Letter N/A   52.3900358 -1.8026595
15189 op-snap---monthly-publication-june-2025.pdf   1118 2025-06 Car BMW 1 Series Red Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Warning Letter N/A   52.4515759 -1.8296192
15192 op-snap---monthly-publication-june-2025.pdf   1121 2025-06 Car BMW 320 D White Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Warning Letter N/A   52.4515759 -1.8296192
15267 op-snap---monthly-publication-june-2025.pdf   1196 2025-06 Car BMW 520d Gold Driving without Due Care and Attention None Pleck Road Pleck Road Walsall Walsall Warning Letter N/A   52.5827033 -1.9960274
15286 op-snap---monthly-publication-june-2025.pdf   1215 2025-06 Car BMW 420d Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
15449 op-snap---monthly-publication-june-2025.pdf   1378 2025-06 Car BMW X1 Grey Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Warning Letter N/A   52.5153884 -1.8527437
16178 op-snap---monthly-publication-june-2025.pdf   2107 2025-06 Other BMW 320 White Driving without Due Care and Attention None Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165
16196 op-snap---monthly-publication-june-2025.pdf   2125 2025-06 Car BMW LF16PMV White Driving without Due Care and Attention None New Road New Road Solihull Solihull Warning Letter N/A   52.4119526 -1.773235
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      
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
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
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
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
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      
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      
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
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
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      
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      

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