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

75 rows where disposal = "Warning Letter", offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" and vehicle_make = "Peugeot" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

month 13

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

council_area 9

  • Birmingham 51
  • Sandwell 9
  • Coventry 5
  • Dudley 2
  • Solihull 2
  • Sutton Coldfield 2
  • Wolverhampton 2
  • Out of Force Area 1
  • Walsall 1

reporter_transport_mode 4

  • Pedestrian 47
  • Car 19
  • Pedal Bike 7
  • Other 2

vehicle_make 1

  • Peugeot · 75 ✖

offence 1

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 75 ✖

disposal 1

  • Warning Letter · 75 ✖
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
7500 op-snap---monthly-publication-february-2026.pdf   247 2026-02 Car Peugeot 208 active Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holland Street Holland Street Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5594346 -1.8239493
8636 op-snap---monthly-publication-february-2026.pdf   1383 2026-02 Pedestrian Peugeot 3008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None hurstcroft road Hurstcroft Road Birmingham Birmingham Warning Letter N/A   52.4830179 -1.783876
8789 op-snap---monthly-publication-february-2026.pdf   1536 2026-02 Pedal Bike Peugeot 207 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bristol road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
10937 op-snap---monthly-publication-january-2026.pdf   398 2026-01 Pedestrian Peugeot 3008 GT Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road East Castle Road East Sandwell Sandwell Warning Letter N/A   52.4687472 -1.9893922
11088 op-snap---monthly-publication-january-2026.pdf   549 2026-01 Other Peugeot Expert White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
11626 op-snap---monthly-publication-january-2026.pdf   1087 2026-01 Pedestrian Peugeot 208 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Arden Street Arden Street Coventry Coventry Warning Letter N/A   52.3987861 -1.5354013
3951 op-snap---monthly-publication-december-2025.pdf   79 2025-12 Pedestrian Peugeot 2008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Withymoor Road Withymoor Road Dudley Dudley Warning Letter N/A   52.4871674 -2.0702998
4277 op-snap---monthly-publication-december-2025.pdf   405 2025-12 Pedestrian Peugeot 5008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None abbey road Abbey Road Sandwell Sandwell Warning Letter N/A   52.47753 -1.9774758
4648 op-snap---monthly-publication-december-2025.pdf   776 2025-12 Pedestrian Peugeot 308 Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None heathcote road Heathcote Road Birmingham Birmingham Warning Letter N/A   52.4202959 -1.9249997
4681 op-snap---monthly-publication-december-2025.pdf   809 2025-12 Car Peugeot 208 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Garretts Green Lane Garretts Green Lane Birmingham Birmingham Warning Letter N/A   52.4675802 -1.7905748
4795 op-snap---monthly-publication-december-2025.pdf   923 2025-12 Car Peugeot 5008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road Church Road Sandwell Sandwell Warning Letter N/A   52.4857168 -1.9703938
4990 op-snap---monthly-publication-december-2025.pdf   1118 2025-12 Pedestrian Peugeot 3008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ludstone road Ludstone Road Birmingham Birmingham Warning Letter N/A   52.4400405 -1.9758361
5090 op-snap---monthly-publication-december-2025.pdf   1218 2025-12 Pedal Bike Peugeot 3008 grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ludstone Road Ludstone Road Birmingham Birmingham Warning Letter N/A   52.4400405 -1.9758361
5152 op-snap---monthly-publication-december-2025.pdf   1280 2025-12 Pedestrian Peugeot 308 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Priory Road Priory Road Solihull Solihull Warning Letter N/A   52.4080373 -1.8511521
20873 op-snap---monthly-publication-november-2025.pdf   415 2025-11 Car Peugeot 2008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
20888 op-snap---monthly-publication-november-2025.pdf   430 2025-11 Pedestrian Peugeot Boxer White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Street, Tettenhall High Street, Tettenhall Wolverhampton Wolverhampton Warning Letter N/A   52.5980906 -2.168057
20894 op-snap---monthly-publication-november-2025.pdf   436 2025-11 Pedestrian Peugeot 2008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stanhope Road Stanhope Road Sandwell Sandwell Warning Letter N/A   52.4817557 -1.9769853
21029 op-snap---monthly-publication-november-2025.pdf   571 2025-11 Pedal Bike Peugeot 308 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Foleshill Road Foleshill Road Coventry Coventry Warning Letter N/A   52.4274335 -1.5002381
21126 op-snap---monthly-publication-november-2025.pdf   668 2025-11 Pedestrian Peugeot Boxer White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None School Road, Honetbourne School Road, Honetbourne Out of Force Area Out of Force Area Warning Letter N/A      
21809 op-snap---monthly-publication-november-2025.pdf   1351 2025-11 Pedestrian Peugeot 208 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None institue road Institue Road Birmingham Birmingham Warning Letter N/A      
22105 op-snap---monthly-publication-october-2025.pdf   55 2025-10 Pedal Bike Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23139 op-snap---monthly-publication-october-2025.pdf   1089 2025-10 Car Peugeot 5008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Apsley Road Apsley Road Birmingham Birmingham Warning Letter N/A   52.4633793 -1.9102892
23161 op-snap---monthly-publication-october-2025.pdf   1111 2025-10 Pedal Bike Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23165 op-snap---monthly-publication-october-2025.pdf   1115 2025-10 Pedal Bike Peugeot 2008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23235 op-snap---monthly-publication-october-2025.pdf   1185 2025-10 Pedestrian Peugeot 5008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Maurice Road Maurice Road Birmingham Birmingham Warning Letter N/A   52.421645 -1.896394
23239 op-snap---monthly-publication-october-2025.pdf   1189 2025-10 Pedestrian Peugeot 2008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coleshill Road Coleshill Road Birmingham Birmingham Warning Letter N/A   52.4967329 -1.8097462
23241 op-snap---monthly-publication-october-2025.pdf   1191 2025-10 Pedestrian Peugeot 5008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Abbey Road Abbey Road Sandwell Sandwell Warning Letter N/A   52.47753 -1.9774758
23256 op-snap---monthly-publication-october-2025.pdf   1206 2025-10 Car Peugeot 3008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23257 op-snap---monthly-publication-october-2025.pdf   1207 2025-10 Car Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23330 op-snap---monthly-publication-october-2025.pdf   1280 2025-10 Pedestrian Peugeot 2008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tetenhall High street Tetenhall High street Wolverhampton Wolverhampton Warning Letter N/A      
23363 op-snap---monthly-publication-october-2025.pdf   1313 2025-10 Car Peugeot E7 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
23402 op-snap---monthly-publication-october-2025.pdf   1352 2025-10 Pedestrian Peugeot 2008 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Olton Boulevard East Olton Boulevard East Birmingham Birmingham Warning Letter N/A   52.4421599 -1.829532
23435 op-snap---monthly-publication-october-2025.pdf   1385 2025-10 Pedestrian Peugeot 2008 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None York Road York Road Birmingham Birmingham Warning Letter N/A   52.5231321 -1.8415573
23462 op-snap---monthly-publication-october-2025.pdf   1412 2025-10 Car Peugeot 207 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hob Moor Road Hob Moor Road Birmingham Birmingham Warning Letter N/A   52.467637 -1.8151581
23545 op-snap---monthly-publication-october-2025.pdf   1495 2025-10 Car Peugeot   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
23555 op-snap---monthly-publication-october-2025.pdf   1505 2025-10 Car Peugeot Boxter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Albany Road Albany Road Coventry Coventry Warning Letter N/A   52.4006218 -1.5284125
23590 op-snap---monthly-publication-october-2025.pdf   1540 2025-10 Pedestrian Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Abbey Road Abbey Road Sandwell Sandwell Warning Letter N/A   52.47753 -1.9774758
23598 op-snap---monthly-publication-october-2025.pdf   1548 2025-10 Car Peugeot   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23720 op-snap---monthly-publication-october-2025.pdf   1670 2025-10 Car Peugeot 107 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3231 op-snap---monthly-publication-august-2025.pdf   1206 2025-08 Pedestrian Peugeot Expert White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley road Dudley road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
3247 op-snap---monthly-publication-august-2025.pdf   1222 2025-08 Pedestrian Peugeot 3008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
3419 op-snap---monthly-publication-august-2025.pdf   1394 2025-08 Pedestrian Peugeot 5008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
3423 op-snap---monthly-publication-august-2025.pdf   1398 2025-08 Car Peugeot partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3546 op-snap---monthly-publication-august-2025.pdf   1521 2025-08 Pedestrian Peugeot Expert White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barsnley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3592 op-snap---monthly-publication-august-2025.pdf   1567 2025-08 Pedestrian Peugeot 208 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braymoor Road Braymoor Road Birmingham Birmingham Warning Letter N/A   52.4756937 -1.762603
3617 op-snap---monthly-publication-august-2025.pdf   1592 2025-08 Car Peugeot 5008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3637 op-snap---monthly-publication-august-2025.pdf   1612 2025-08 Pedestrian Peugeot 3008 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3641 op-snap---monthly-publication-august-2025.pdf   1616 2025-08 Pedestrian Peugeot 3008 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3652 op-snap---monthly-publication-august-2025.pdf   1627 2025-08 Pedestrian Peugeot boxer Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3688 op-snap---monthly-publication-august-2025.pdf   1663 2025-08 Pedestrian Peugeot   Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3693 op-snap---monthly-publication-august-2025.pdf   1668 2025-08 Pedestrian Peugeot   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3774 op-snap---monthly-publication-august-2025.pdf   1749 2025-08 Pedestrian Peugeot Partner Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Green Road Green Road Birmingham Birmingham Warning Letter N/A   52.436871 -1.8592799
3821 op-snap---monthly-publication-august-2025.pdf   1796 2025-08 Car Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Morland Place Morland Place Birmingham Birmingham Warning Letter N/A   52.4032699 -1.9761539
13420 op-snap---monthly-publication-july-2025.pdf   1472 2025-07 Pedestrian Peugeot 2008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
13427 op-snap---monthly-publication-july-2025.pdf   1479 2025-07 Pedestrian Peugeot 208 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holland Road Holland Road Birmingham Birmingham Warning Letter N/A   52.5568516 -1.8248341
13447 op-snap---monthly-publication-july-2025.pdf   1499 2025-07 Car Peugeot 308 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath road Washwood Heath road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13477 op-snap---monthly-publication-july-2025.pdf   1529 2025-07 Pedestrian Peugeot 208 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holland Road Holland Road Birmingham Birmingham Warning Letter N/A   52.5568516 -1.8248341
13497 op-snap---monthly-publication-july-2025.pdf   1549 2025-07 Pedestrian Peugeot 3008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Selly oak Road Selly oak Road Birmingham Birmingham Warning Letter N/A   52.4263875 -1.9397954
13502 op-snap---monthly-publication-july-2025.pdf   1554 2025-07 Pedestrian Peugeot 3008 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Welstead Road Welstead Road Walsall Walsall Warning Letter N/A      
13687 op-snap---monthly-publication-july-2025.pdf   1739 2025-07 Pedestrian Peugeot boxer White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance dudley road Dudley Road Dudley Dudley Warning Letter N/A   52.4881161 -2.1199108
13792 op-snap---monthly-publication-july-2025.pdf   1844 2025-07 Pedestrian Peugeot 208 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None icknield port road Icknield Port Road Birmingham Birmingham Warning Letter N/A   52.4792334 -1.92925
14666 op-snap---monthly-publication-june-2025.pdf   595 2025-06 Pedestrian Peugeot Partner Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hagley Road West Hagley Road West Birmingham Birmingham Warning Letter N/A   52.4656414 -1.9852276
15085 op-snap---monthly-publication-june-2025.pdf   1014 2025-06 Pedestrian Peugeot 407 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None White Road White Road Sandwell Sandwell Warning Letter N/A   52.4975395 -1.9782464
15993 op-snap---monthly-publication-june-2025.pdf   1922 2025-06 Car Peugeot 308.. White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
19720 op-snap---monthly-publication-may-2025.pdf   1082 2025-05 Pedestrian Peugeot Expert Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Formans Road Formans Road Birmingham Birmingham Warning Letter N/A   52.4482024 -1.8507493
427 op-snap---monthly-publication-april-2025.pdf   426 2025-04 Other Peugeot 207 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Vicarage Road, Kings Heath Vicarage Road, Kings Heath Birmingham Birmingham Warning Letter N/A   52.4301512 -1.8996659
16507 op-snap---monthly-publication-march-2025.pdf   264 2025-03 Pedestrian Peugeot 3008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Asheville Ave Asheville Ave Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17430 op-snap---monthly-publication-march-2025.pdf   1187 2025-03 Car Peugeot 207... Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lower Queen Street Lower Queen Street Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5603978 -1.8227403
5820 op-snap---monthly-publication-february-2025.pdf   637 2025-02 Pedestrian Peugeot 508 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moo Street, Coventry Moo Street, Coventry Coventry Coventry Warning Letter N/A Yes - Via Email    
5919 op-snap---monthly-publication-february-2025.pdf   736 2025-02 Pedestrian Peugeot 308 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gateside Road Coventry Gateside Road Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.4400759 -1.4966907
6297 op-snap---monthly-publication-february-2025.pdf   1114 2025-02 Pedestrian Peugeot 308 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fernhill Road Fernhill Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.4445476 -1.8038437
6552 op-snap---monthly-publication-february-2025.pdf   1369 2025-02 Pedestrian Peugeot 3008 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cranford Street Smethwick Cranford Street Smethwick Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.4936011 -1.9513262
8979 op-snap---monthly-publication-january-2025.pdf   87 2025-01 Pedestrian Peugeot 208 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Charles Road Charles Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5094492 -1.9113648
9381 op-snap---monthly-publication-january-2025.pdf   489 2025-01 Pedal Bike Peugeot 207 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Breedon Road Breedon Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4191978 -1.9251219
10006 op-snap---monthly-publication-january-2025.pdf   1114 2025-01 Pedestrian Peugeot 5008 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Marsham Road Marsham Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4117052 -1.888565

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