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

53 rows where offence = "Driving without Reasonable Consideration", reporter_transport_mode = "Pedal Bike" and vehicle_make = "Vauxhall" 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, nfa_rationale, witness_contacted

month 10

  • 2025-01 16
  • 2025-02 11
  • 2025-03 11
  • 2025-04 7
  • 2025-05 2
  • 2025-10 2
  • 2025-06 1
  • 2025-07 1
  • 2025-08 1
  • 2025-09 1

council_area 8

  • Birmingham 30
  • Coventry 9
  • Dudley 5
  • Solihull 4
  • Walsall 2
  • Metropolitan Boroug 1
  • Sutton Coldfield 1
  • Vceostveern Rtreystaurant) 1

disposal 5

  • Education 26
  • Warning Letter 15
  • Fixed Penalty 5
  • NFA 5
  • Court 2

vehicle_make 1

  • Vauxhall · 53 ✖

reporter_transport_mode 1

  • Pedal Bike · 53 ✖

offence 1

  • Driving without Reasonable Consideration · 53 ✖
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
22624 op-snap---monthly-publication-october-2025.pdf   574 2025-10 Pedal Bike Vauxhall Crossland White Driving without Reasonable Consideration None Hagley Road Halesowen Hagley Road Halesowen Dudley Dudley Education N/A   52.4476209 -2.051289
22926 op-snap---monthly-publication-october-2025.pdf   876 2025-10 Pedal Bike Vauxhall Insigia Silver Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
23965 op-snap---monthly-publication-september-2025.pdf   184 2025-09 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Station Road Marston Green Station Road Marston Green Solihull Solihull Warning Letter N/A   52.4667342 -1.747421
3142 op-snap---monthly-publication-august-2025.pdf   1117 2025-08 Pedal Bike Vauxhall Vivaro Grey Driving without Reasonable Consideration None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
14055 op-snap---monthly-publication-july-2025.pdf   2107 2025-07 Pedal Bike Vauxhall Grandland Blue Driving without Reasonable Consideration None Colehill Heath Colehill Heath Birmingham Birmingham Warning Letter N/A      
15030 op-snap---monthly-publication-june-2025.pdf   959 2025-06 Pedal Bike Vauxhall INSIGNIA Green Driving without Reasonable Consideration None HALLAM STREET Hallam Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4563937 -1.8933429
18829 op-snap---monthly-publication-may-2025.pdf   191 2025-05 Pedal Bike Vauxhall Monovan White Driving without Reasonable Consideration None Racecourse Lane Racecourse Lane Metropolitan Boroug Metropolitan Boroug Warning Letter N/A   52.4377169 -2.1495045
19010 op-snap---monthly-publication-may-2025.pdf   372 2025-05 Pedal Bike Vauxhall corsa Red Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Court N/A   52.471632 -1.9456776
37 op-snap---monthly-publication-april-2025.pdf   36 2025-04 Pedal Bike Vauxhall Zafira Blue Driving without Reasonable Consideration None Earlsdon Av South Earlsdon Avenue South Coventry Coventry Education N/A   52.3960991 -1.5255671
154 op-snap---monthly-publication-april-2025.pdf   153 2025-04 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Oxford Road Oxford Road Birmingham Birmingham Warning Letter N/A   52.4456323 -1.8858352
220 op-snap---monthly-publication-april-2025.pdf   219 2025-04 Pedal Bike Vauxhall Astra White Driving without Reasonable Consideration None A38 Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
542 op-snap---monthly-publication-april-2025.pdf   541 2025-04 Pedal Bike Vauxhall Corsa Red Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
868 op-snap---monthly-publication-april-2025.pdf   867 2025-04 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Primrose Hill , Kings Norton Primrose Hill , Kings Norton Birmingham Birmingham NFA Outside of 14 Days NIP   52.3998874 -1.9258787
1409 op-snap---monthly-publication-april-2025.pdf   1408 2025-04 Pedal Bike Vauxhall NP Black Driving without Reasonable Consideration none     Birmingham Birmingham NFA Outside of 14 Days NIP      
1802 op-snap---monthly-publication-april-2025.pdf   1801 2025-04 Pedal Bike Vauxhall NP White Driving without Reasonable Consideration None Fox Hollies Road , Birmingham Fox Hollies Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5431333 -1.7960713
16244 op-snap---monthly-publication-march-2025.pdf   1 2025-03 Pedal Bike Vauxhall Zafira Blue Driving without Reasonable Consideration No vehicle excise licence Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
16687 op-snap---monthly-publication-march-2025.pdf   444 2025-03 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Vicarage Road Vicarage Road Walsall Walsall Education N/A Yes - Via Email 52.64682 -1.9259844
16882 op-snap---monthly-publication-march-2025.pdf   639 2025-03 Pedal Bike Vauxhall Insignia Blue Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A Yes - Via Email 52.5292752 -1.7618805
16936 op-snap---monthly-publication-march-2025.pdf   693 2025-03 Pedal Bike Vauxhall Astra Silver Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Court N/A Yes - Via Email 52.4308271 -1.920078
17054 op-snap---monthly-publication-march-2025.pdf   811 2025-03 Pedal Bike Vauxhall Astra Blue Driving without Reasonable Consideration None Foles Hill Road Foleshill Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4274335 -1.5002381
17149 op-snap---monthly-publication-march-2025.pdf   906 2025-03 Pedal Bike Vauxhall Corsa Grey Driving without Reasonable Consideration None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Education N/A Yes - Via Email 52.4397168 -1.9260414
17768 op-snap---monthly-publication-march-2025.pdf   1525 2025-03 Pedal Bike Vauxhall Astra White Driving without Reasonable Consideration None Spon End Spon End Coventry Coventry Education N/A Yes - Via Email 52.4069072 -1.5247498
18189 op-snap---monthly-publication-march-2025.pdf   1946 2025-03 Pedal Bike Vauxhall Corsa White Driving without Reasonable Consideration None Sampson Road Sampson Road Birmingham Birmingham Education N/A Yes - Via Email 52.4649611 -1.8735292
18193 op-snap---monthly-publication-march-2025.pdf   1950 2025-03 Pedal Bike Vauxhall ASTRA Grey Driving without Reasonable Consideration None HEATH LANE Heath Lane Dudley Dudley Warning Letter N/A Yes - Via Email 52.4495524 -2.1459067
18262 op-snap---monthly-publication-march-2025.pdf   2019 2025-03 Pedal Bike Vauxhall Astra Black Driving without Reasonable Consideration None Wheelers Lane Wheelers Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4306504 -1.878052
18605 op-snap---monthly-publication-march-2025.pdf   2362 2025-03 Pedal Bike Vauxhall Mokka White Driving without Reasonable Consideration None Dads Lane Kings Heath Dads Lane Kings Heath Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4375914 -1.9068522
5211 op-snap---monthly-publication-february-2025.pdf   28 2025-02 Pedal Bike Vauxhall Combo White Driving without Reasonable Consideration None Cot Lane Cot Lane Dudley Dudley Education N/A Yes - Via Email 52.4939289 -2.1730601
5260 op-snap---monthly-publication-february-2025.pdf   77 2025-02 Pedal Bike Vauxhall ZAFIRA Silver Driving without Reasonable Consideration None BARROWS ROAD Barrows Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4580926 -1.8627344
5690 op-snap---monthly-publication-february-2025.pdf   507 2025-02 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Box Tree Road, Solihul Box Tree Road, Solihul Solihull Solihull Fixed Penalty N/A Yes - Via Email    
6186 op-snap---monthly-publication-february-2025.pdf   1003 2025-02 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Bradford Street Bradford Street Birmingham Birmingham NFA No Offence Yes - Via Email 52.4708802 -1.8792135
6239 op-snap---monthly-publication-february-2025.pdf   1056 2025-02 Pedal Bike Vauxhall Astra Black Driving without Reasonable Consideration None Vicarage Road Walsall Vicarage Road Walsall Walsall Walsall Education N/A Yes - Via Email 52.64682 -1.9259844
6280 op-snap---monthly-publication-february-2025.pdf   1097 2025-02 Pedal Bike Vauxhall Astra Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
6538 op-snap---monthly-publication-february-2025.pdf   1355 2025-02 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Birmingham Road, Allesley (near Har Birmingham Road, Allesley (near Har vCeostveern Rtreystaurant) Vceostveern Rtreystaurant) Fixed Penalty N/A Yes - Via Email    
6815 op-snap---monthly-publication-february-2025.pdf   1632 2025-02 Pedal Bike Vauxhall Insignia White Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
6817 op-snap---monthly-publication-february-2025.pdf   1634 2025-02 Pedal Bike Vauxhall Corsa Silver Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
6920 op-snap---monthly-publication-february-2025.pdf   1737 2025-02 Pedal Bike Vauxhall Vivaro White Driving without Reasonable Consideration None Queens Road Queens Road Coventry Coventry Education N/A Yes - Via Email 52.4045286 -1.5186641
7184 op-snap---monthly-publication-february-2025.pdf   2001 2025-02 Pedal Bike Vauxhall Astra White Driving without Reasonable Consideration None Stretton Road Stretton Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3968954 -1.8276508
8971 op-snap---monthly-publication-january-2025.pdf   79 2025-01 Pedal Bike Vauxhall Zaffira Brown Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
9304 op-snap---monthly-publication-january-2025.pdf   412 2025-01 Pedal Bike Vauxhall Crossland Red Driving without Reasonable Consideration None Jervoise Lane Jervoise Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
9415 op-snap---monthly-publication-january-2025.pdf   523 2025-01 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5872149 -1.8300386
9422 op-snap---monthly-publication-january-2025.pdf   530 2025-01 Pedal Bike Vauxhall MOVANO White Driving without Reasonable Consideration None HAGLEY ROAD, STOURBRIDGE Hagley Road, Stourbridge Dudley Dudley Education N/A Yes - Via Email 52.4357078 -2.1323185
9442 op-snap---monthly-publication-january-2025.pdf   550 2025-01 Pedal Bike Vauxhall Corsa Silver Driving without Reasonable Consideration None Crocketts Lane Crocketts Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9734 op-snap---monthly-publication-january-2025.pdf   842 2025-01 Pedal Bike Vauxhall Vivaro White Driving without Reasonable Consideration None Priory Road Priory Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4132696 -1.8555008
9737 op-snap---monthly-publication-january-2025.pdf   845 2025-01 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Priory Road Priory Road Birmingham Birmingham Education N/A Yes - Via Email 52.4132696 -1.8555008
9777 op-snap---monthly-publication-january-2025.pdf   885 2025-01 Pedal Bike Vauxhall Movano Grey Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4134557 -1.4442138
9785 op-snap---monthly-publication-january-2025.pdf   893 2025-01 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Swancroft Road Swancroft Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4201997 -1.4875978
9949 op-snap---monthly-publication-january-2025.pdf   1057 2025-01 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Lockhurst Lane Lockhurst Lane Coventry Coventry Education N/A Yes - Via Email 52.4255689 -1.5023841
9971 op-snap---monthly-publication-january-2025.pdf   1079 2025-01 Pedal Bike Vauxhall ZAFIRA Blue Driving without Reasonable Consideration None BRISTOL ROAD Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
9976 op-snap---monthly-publication-january-2025.pdf   1084 2025-01 Pedal Bike Vauxhall Insignia Red Driving without Reasonable Consideration None Heath Lane Heath Lane Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4495524 -2.1459067
9984 op-snap---monthly-publication-january-2025.pdf   1092 2025-01 Pedal Bike Vauxhall Viva Silver Driving without Reasonable Consideration None Binley Road Binley Road Coventry Coventry Education N/A Yes - Via Email 52.4070602 -1.4732469
10025 op-snap---monthly-publication-january-2025.pdf   1133 2025-01 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Holder Road Holder Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4655509 -1.8219
10040 op-snap---monthly-publication-january-2025.pdf   1148 2025-01 Pedal Bike Vauxhall Meriva Silver Driving without Reasonable Consideration None Salisbury Road Salisbury Road Birmingham Birmingham Education N/A Yes - Via Email 52.4943878 -1.8504211
10383 op-snap---monthly-publication-january-2025.pdf   1491 2025-01 Pedal Bike Vauxhall corsa Blue Driving without Reasonable Consideration None A38 BRISTOL ROAD A38 Bristol Road Birmingham Birmingham Education N/A Yes - Via Telephone 52.4476938 -1.9256632

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