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

81 rows where offence = "Driving without Due Care and Attention", reporter_transport_mode = "Pedal Bike" and vehicle_make = "Toyota" 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

month 14

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

council_area 10

  • Birmingham 48
  • Coventry 17
  • Solihull 3
  • Sutton Coldfield 3
  • Walsall 3
  • Halesowen 2
  • Out of Force Area 2
  • Dudley 1
  • Sandwell 1
  • Wolverhampton 1

disposal 5

  • Education 42
  • NFA 20
  • Warning Letter 10
  • Court 5
  • Fixed Penalty 4

vehicle_make 1

  • Toyota · 81 ✖

reporter_transport_mode 1

  • Pedal Bike · 81 ✖

offence 1

  • Driving without Due Care and Attention · 81 ✖
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
7297 op-snap---monthly-publication-february-2026.pdf   44 2026-02 Pedal Bike Toyota Prius Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
7299 op-snap---monthly-publication-february-2026.pdf   46 2026-02 Pedal Bike Toyota Auris Brown Driving without Due Care and Attention None Franklin Road Franklin Road Birmingham Birmingham Education N/A   52.4195456 -1.9350703
7426 op-snap---monthly-publication-february-2026.pdf   173 2026-02 Pedal Bike Toyota Estima Silver Driving without Due Care and Attention None Weoley Park Road Weoley Park Road Birmingham Birmingham Warning Letter N/A   52.4368136 -1.9495478
7498 op-snap---monthly-publication-february-2026.pdf   245 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Westwood WAY Westwood WAY Coventry Coventry Education N/A   52.3880214 -1.5797132
7828 op-snap---monthly-publication-february-2026.pdf   575 2026-02 Pedal Bike Toyota CHR Silver Driving without Due Care and Attention None Hagley Causeway, Halesowen Hagley Causeway, Halesowen Halesowen Halesowen Fixed Penalty N/A   52.4349292 -2.0850774
7833 op-snap---monthly-publication-february-2026.pdf   580 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
7843 op-snap---monthly-publication-february-2026.pdf   590 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Kings Heath High Street Kings Heath High Street Birmingham Birmingham Education N/A   52.4391028 -1.893289
8205 op-snap---monthly-publication-february-2026.pdf   952 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Gibbins Road, Selly Oak Gibbins Road, Selly Oak Birmingham Birmingham Education N/A   52.4390303 -1.9512931
8227 op-snap---monthly-publication-february-2026.pdf   974 2026-02 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Clevedon Road, Balsall Heath Clevedon Road, Balsall Heath Birmingham Birmingham Education N/A   52.4618531 -1.894645
8321 op-snap---monthly-publication-february-2026.pdf   1068 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Education N/A   52.4073149 -1.5250454
8357 op-snap---monthly-publication-february-2026.pdf   1104 2026-02 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Sandpits Sandpits Birmingham Birmingham Court N/A   52.482308 -1.9133277
8616 op-snap---monthly-publication-february-2026.pdf   1363 2026-02 Pedal Bike Toyota Van Grey Driving without Due Care and Attention None California Way California Way Birmingham Birmingham NFA No Offence   52.4454714 -1.9753804
8747 op-snap---monthly-publication-february-2026.pdf   1494 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham Court N/A   52.4381959 -1.8907391
8766 op-snap---monthly-publication-february-2026.pdf   1513 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Spon End Spon End Coventry Coventry Education N/A   52.4069072 -1.5247498
10557 op-snap---monthly-publication-january-2026.pdf   18 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Robin Hood lane Robin Hood lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
10984 op-snap---monthly-publication-january-2026.pdf   445 2026-01 Pedal Bike Toyota MPV White Driving without Due Care and Attention None Reservoir Road, Edgbaston Reservoir Road, Edgbaston Birmingham Birmingham Education N/A   52.4771764 -1.93246
11098 op-snap---monthly-publication-january-2026.pdf   559 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry NFA Not in Public Interest   52.4073149 -1.5250454
11665 op-snap---monthly-publication-january-2026.pdf   1126 2026-01 Pedal Bike Toyota Hilux White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
4079 op-snap---monthly-publication-december-2025.pdf   207 2025-12 Pedal Bike Toyota Rav4 Black Driving without Due Care and Attention None Spiceland Road Northfield Spiceland Road Northfield Birmingham Birmingham NFA No Independent Evidence Available   52.4243001 -1.9747504
4533 op-snap---monthly-publication-december-2025.pdf   661 2025-12 Pedal Bike Toyota Yaris Grey Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA No Offence   52.4190728 -1.7449943
4715 op-snap---monthly-publication-december-2025.pdf   843 2025-12 Pedal Bike Toyota Auris Brown Driving without Due Care and Attention None Ralph Road, Shirley, Solihull Ralph Road, Shirley, Solihull Solihull Solihull Education N/A   52.4156768 -1.8193235
4720 op-snap---monthly-publication-december-2025.pdf   848 2025-12 Pedal Bike Toyota Estima Silver Driving without Due Care and Attention None Belle Walk Belle Walk Birmingham Birmingham Education N/A   52.4451434 -1.8736544
20561 op-snap---monthly-publication-november-2025.pdf   103 2025-11 Pedal Bike Toyota Yaris Red Driving without Due Care and Attention None Witherford Way Witherford Way Birmingham Birmingham Warning Letter N/A   52.4346604 -1.9538812
20743 op-snap---monthly-publication-november-2025.pdf   285 2025-11 Pedal Bike Toyota Auris Blue Driving without Due Care and Attention None Lucknow Road Lucknow Road Wolverhampton Wolverhampton Fixed Penalty N/A      
21242 op-snap---monthly-publication-november-2025.pdf   784 2025-11 Pedal Bike Toyota Yaris Black Driving without Due Care and Attention None Ashleigh Road Ashleigh Road Birmingham Birmingham Warning Letter N/A   52.5124638 -1.9824678
21756 op-snap---monthly-publication-november-2025.pdf   1298 2025-11 Pedal Bike Toyota Yaris Black Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Education N/A      
21757 op-snap---monthly-publication-november-2025.pdf   1299 2025-11 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Hill Street Hill Street Birmingham Birmingham Court N/A   52.4777765 -1.901321
21968 op-snap---monthly-publication-november-2025.pdf   1510 2025-11 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Swanawell Street Swanawell Street Coventry Coventry Warning Letter N/A      
22311 op-snap---monthly-publication-october-2025.pdf   261 2025-10 Pedal Bike Toyota Aygo Red Driving without Due Care and Attention None Corporation Road Corporation Road Coventry Coventry Education N/A      
22328 op-snap---monthly-publication-october-2025.pdf   278 2025-10 Pedal Bike Toyota   Black Driving without Due Care and Attention None 6 Ways 6 Ways Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4728311 -1.9185712
22408 op-snap---monthly-publication-october-2025.pdf   358 2025-10 Pedal Bike Toyota Yaris Blue Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Education N/A   52.4298554 -1.9086629
22596 op-snap---monthly-publication-october-2025.pdf   546 2025-10 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Education N/A   52.4624743 -1.7763934
22637 op-snap---monthly-publication-october-2025.pdf   587 2025-10 Pedal Bike Toyota Auris Black Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
22690 op-snap---monthly-publication-october-2025.pdf   640 2025-10 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
22830 op-snap---monthly-publication-october-2025.pdf   780 2025-10 Pedal Bike Toyota Corolla Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
22968 op-snap---monthly-publication-october-2025.pdf   918 2025-10 Pedal Bike Toyota Yaris White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
22999 op-snap---monthly-publication-october-2025.pdf   949 2025-10 Pedal Bike Toyota Corolla White Driving without Due Care and Attention None Scarborough Road Scarborough Road Walsall Walsall Education N/A   52.5794092 -2.0002339
23083 op-snap---monthly-publication-october-2025.pdf   1033 2025-10 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Beverley Road / Leach Heath Lane Beverley Road / Leach Heath Lane Birmingham Birmingham Education N/A   52.3943903 -2.0150381
24186 op-snap---monthly-publication-september-2025.pdf   405 2025-09 Pedal Bike Toyota Yaris Red Driving without Due Care and Attention None Bibury Road Cheltenham Bibury Road Cheltenham Out of Force Area Out of Force Area NFA Out of Force      
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
24663 op-snap---monthly-publication-september-2025.pdf   882 2025-09 Pedal Bike Toyota Avenis Silver Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Education N/A   52.4422505 -1.8539684
24810 op-snap---monthly-publication-september-2025.pdf   1029 2025-09 Pedal Bike Toyota Prius white Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
2371 op-snap---monthly-publication-august-2025.pdf   346 2025-08 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
2407 op-snap---monthly-publication-august-2025.pdf   382 2025-08 Pedal Bike Toyota Yaris Grey Driving without Due Care and Attention None Woodland Road Woodland Road Birmingham Birmingham Education N/A   52.4108681 -1.9611917
2523 op-snap---monthly-publication-august-2025.pdf   498 2025-08 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Middle Park Road Middle Park Road Birmingham Birmingham Education N/A   52.433278 -1.956176
3012 op-snap---monthly-publication-august-2025.pdf   987 2025-08 Pedal Bike Toyota Prius Blue Driving without Due Care and Attention None Dudley Road Dudley Road Halesowen Halesowen NFA No Offence   52.5717314 -2.1249182
12067 op-snap---monthly-publication-july-2025.pdf   119 2025-07 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Bickenhill Road Bickenhill Road Solihull Solihull Court N/A   52.4640893 -1.7362681
12400 op-snap---monthly-publication-july-2025.pdf   452 2025-07 Pedal Bike Toyota Auris Black Driving without Due Care and Attention None May Lane May Lane Birmingham Birmingham Education N/A   52.4197342 -1.8839613
12761 op-snap---monthly-publication-july-2025.pdf   813 2025-07 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Northfiled Road Northfiled Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12983 op-snap---monthly-publication-july-2025.pdf   1035 2025-07 Pedal Bike Toyota Aygo Red Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
13024 op-snap---monthly-publication-july-2025.pdf   1076 2025-07 Pedal Bike Toyota Auris Silver Driving without Due Care and Attention None Darlsaton Road (Wednesbury) Darlsaton Road (Wednesbury) Sandwell Sandwell Warning Letter N/A      
13066 op-snap---monthly-publication-july-2025.pdf   1118 2025-07 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None War Lane, harborne War Lane, harborne Birmingham Birmingham NFA Outside of 14 Days NIP   52.4569552 -1.9616483
13072 op-snap---monthly-publication-july-2025.pdf   1124 2025-07 Pedal Bike Toyota Corolla Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13895 op-snap---monthly-publication-july-2025.pdf   1947 2025-07 Pedal Bike Toyota CHR White Driving without Due Care and Attention None The Broadwa, Stourbridge The Broadwa, Stourbridge Dudley Dudley Warning Letter N/A      
14118 op-snap---monthly-publication-june-2025.pdf   47 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
14119 op-snap---monthly-publication-june-2025.pdf   48 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Warning Letter N/A   52.4718503 -1.9195423
14307 op-snap---monthly-publication-june-2025.pdf   236 2025-06 Pedal Bike Toyota Corolla White Driving without Due Care and Attention None Berkswell Road Berkswell Road Coventry Coventry Education N/A   52.4422534 -1.4791016
14430 op-snap---monthly-publication-june-2025.pdf   359 2025-06 Pedal Bike Toyota Yaris Silver Driving without Due Care and Attention None Rotton Park Road Rotton Park Road Birmingham Birmingham Education N/A   52.4851072 -1.9468115
14485 op-snap---monthly-publication-june-2025.pdf   414 2025-06 Pedal Bike Toyota Pruis Red Driving without Due Care and Attention None Qunton Road Qunton Road Birmingham Birmingham Education N/A      
14489 op-snap---monthly-publication-june-2025.pdf   418 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Burnaby Road Burnaby Road Coventry Coventry Education N/A   52.4352 -1.5194238
14507 op-snap---monthly-publication-june-2025.pdf   436 2025-06 Pedal Bike Toyota Yaris White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
14517 op-snap---monthly-publication-june-2025.pdf   446 2025-06 Pedal Bike Toyota Auris Green Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
14746 op-snap---monthly-publication-june-2025.pdf   675 2025-06 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
15044 op-snap---monthly-publication-june-2025.pdf   973 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Wigston Road Wigston Road Coventry Coventry Fixed Penalty N/A   52.4302822 -1.4386034
15422 op-snap---monthly-publication-june-2025.pdf   1351 2025-06 Pedal Bike Toyota Auris Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
15463 op-snap---monthly-publication-june-2025.pdf   1392 2025-06 Pedal Bike Toyota Yaris Grey Driving without Due Care and Attention None Brookvale Road Brookvale Road Birmingham Birmingham Education N/A   52.5219365 -1.8755325
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
19441 op-snap---monthly-publication-may-2025.pdf   803 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19502 op-snap---monthly-publication-may-2025.pdf   864 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Fairfax Street Fairfax Street Coventry Coventry NFA Outside of 14 Days NIP   52.4097547 -1.5065519
19665 op-snap---monthly-publication-may-2025.pdf   1027 2025-05 Pedal Bike Toyota   White Driving without Due Care and Attention None Station Road, Marston Green Station Road, Marston Green Birmingham Birmingham Education N/A      
20148 op-snap---monthly-publication-may-2025.pdf   1510 2025-05 Pedal Bike Toyota corolla Silver Driving without Due Care and Attention None Cateswell Road Cateswell Road Birmingham Birmingham NFA Misc Inc Crimes   52.4387009 -1.8454267
20385 op-snap---monthly-publication-may-2025.pdf   1747 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention none Heath Road Heath Road Walsall Walsall Warning Letter N/A   52.5736792 -2.0223376
1946 op-snap---monthly-publication-april-2025.pdf   1945 2025-04 Pedal Bike Toyota Prius White Driving without Due Care and Attention None foleshill road Foleshill Road Coventry Coventry NFA Outside of 14 Days NIP   52.4274335 -1.5002381
16420 op-snap---monthly-publication-march-2025.pdf   177 2025-03 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
17301 op-snap---monthly-publication-march-2025.pdf   1058 2025-03 Pedal Bike Toyota Yaris grey Driving without Due Care and Attention None Gillhurst Road Gillhurst Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.467676 -1.9548345
5226 op-snap---monthly-publication-february-2025.pdf   43 2025-02 Pedal Bike Toyota Yaris Silver Driving without Due Care and Attention None Forest Road, Moseley Forest Road, Moseley Birmingham Birmingham Education N/A Yes - Via Email 52.4467275 -1.8804014
5245 op-snap---monthly-publication-february-2025.pdf   62 2025-02 Pedal Bike Toyota Corolla Black Driving without Due Care and Attention None Thorpe Road Thorpe Road Walsall Walsall Court N/A Yes - Via Email 52.5745111 -1.9826069
6137 op-snap---monthly-publication-february-2025.pdf   954 2025-02 Pedal Bike Toyota MPV Grey Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
6542 op-snap---monthly-publication-february-2025.pdf   1359 2025-02 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Birmingham Road Birmingham Road Coventry Coventry Education N/A Yes - Via Email 52.4272882 -1.5753221
6655 op-snap---monthly-publication-february-2025.pdf   1472 2025-02 Pedal Bike Toyota Corolla White Driving without Due Care and Attention None Newport Road Newport Road Birmingham Birmingham Education N/A Yes - Via Email 52.5027779 -1.7982159
9144 op-snap---monthly-publication-january-2025.pdf   252 2025-01 Pedal Bike Toyota Rav 4 Black Driving without Due Care and Attention None Droitwich Road Droitwich Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    

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