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

73 rows where disposal = "Education", month = "2025-12" 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

reporter_transport_mode 6

offence 1

  • Driving without Due Care and Attention · 73 ✖

month 1

  • 2025-12 · 73 ✖

disposal 1

  • Education · 73 ✖
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
3884 op-snap---monthly-publication-december-2025.pdf   12 2025-12 Pedal Bike Volkswagen Golf Red Driving without Due Care and Attention None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Education N/A   52.5690586 -1.8794686
3886 op-snap---monthly-publication-december-2025.pdf   14 2025-12 Car   Caetano White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
3985 op-snap---monthly-publication-december-2025.pdf   113 2025-12 Car Kia Sportage White Driving without Due Care and Attention None M42 Junction 4 M42 Junction 4 Solihull Solihull Education N/A      
4017 op-snap---monthly-publication-december-2025.pdf   145 2025-12 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Westward Way Westward Way Coventry Coventry Education N/A      
4020 op-snap---monthly-publication-december-2025.pdf   148 2025-12 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
4026 op-snap---monthly-publication-december-2025.pdf   154 2025-12 Other Renault Clio Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4034 op-snap---monthly-publication-december-2025.pdf   162 2025-12 Car Porsche Boxster White Driving without Due Care and Attention None Black Country Route Black Country Route Wolverhampton Wolverhampton Education N/A   52.5642677 -2.0755469
4035 op-snap---monthly-publication-december-2025.pdf   163 2025-12 Other Vauxhall Vivaro White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4075 op-snap---monthly-publication-december-2025.pdf   203 2025-12 Other Fiat 500 Beige Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4086 op-snap---monthly-publication-december-2025.pdf   214 2025-12 Pedal Bike Volkswagen UP Red Driving without Due Care and Attention None Swanswwell St Swanswwell Street Coventry Coventry Education N/A      
4094 op-snap---monthly-publication-december-2025.pdf   222 2025-12 Car Seat Ibiza Grey Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
4095 op-snap---monthly-publication-december-2025.pdf   223 2025-12 Car Nissan Qashqai White Driving without Due Care and Attention none Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
4096 op-snap---monthly-publication-december-2025.pdf   224 2025-12 Car Mercedes-Benz GLE Blue Driving without Due Care and Attention None Marsh Hill Marsh Hill Birmingham Birmingham Education N/A   52.5246617 -1.8687505
4097 op-snap---monthly-publication-december-2025.pdf   225 2025-12 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Station Road, Stechford Station Road, Stechford Birmingham Birmingham Education N/A   52.480771 -1.8086714
4159 op-snap---monthly-publication-december-2025.pdf   287 2025-12 Car Nissan Qashqai White Driving without Due Care and Attention None Icknield Street Icknield Street Birmingham Birmingham Education N/A   52.5709191 -1.8759339
4161 op-snap---monthly-publication-december-2025.pdf   289 2025-12 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Sarehold Road Sarehold Road Birmingham Birmingham Education N/A      
4182 op-snap---monthly-publication-december-2025.pdf   310 2025-12 Car BMW 316 Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
4183 op-snap---monthly-publication-december-2025.pdf   311 2025-12 Pedal Bike Volvo XC90 White Driving without Due Care and Attention None Charles Henry Street Charles Henry Street Birmingham Birmingham Education N/A   52.4709195 -1.8888591
4185 op-snap---monthly-publication-december-2025.pdf   313 2025-12 Car Renault Traffic White Driving without Due Care and Attention None Darthmouth middleway Darthmouth middleway Birmingham Birmingham Education N/A      
4308 op-snap---monthly-publication-december-2025.pdf   436 2025-12 Car Volkswagen Polo Black Driving without Due Care and Attention None Barker Butt Lane Barker Butt Lane Coventry Coventry Education N/A      
4320 op-snap---monthly-publication-december-2025.pdf   448 2025-12 Pedal Bike Skoda Enyaq Grey Driving without Due Care and Attention None Bourneville Lane Bourneville Lane Birmingham Birmingham Education N/A      
4334 op-snap---monthly-publication-december-2025.pdf   462 2025-12 Car Toyota prius Black Driving without Due Care and Attention None startford road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
4343 op-snap---monthly-publication-december-2025.pdf   471 2025-12 Car Kia Rio Silver Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
4380 op-snap---monthly-publication-december-2025.pdf   508 2025-12 Lorry Daf HGV White Driving without Due Care and Attention None M6 (N), near Wednesbury M6 (N), near Wednesbury Walsall Walsall Education N/A      
4400 op-snap---monthly-publication-december-2025.pdf   528 2025-12 Car Mercedes-Benz a-class White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
4401 op-snap---monthly-publication-december-2025.pdf   529 2025-12 Car Mercedes-Benz C Class Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
4415 op-snap---monthly-publication-december-2025.pdf   543 2025-12 Pedal Bike Honda Civic Silver Driving without Due Care and Attention None Tessal Lane Tessal Lane Birmingham Birmingham Education N/A      
4416 op-snap---monthly-publication-december-2025.pdf   544 2025-12 Car Volkswagen ID4 White Driving without Due Care and Attention None A4123 Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
4430 op-snap---monthly-publication-december-2025.pdf   558 2025-12 Car BMW 1 Series Black Driving without Due Care and Attention None Wednesfield Road Wednesfield Road Wolverhampton Wolverhampton Education N/A   52.5885601 -2.122003
4448 op-snap---monthly-publication-december-2025.pdf   576 2025-12 Car Kia Ceed Red Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
4451 op-snap---monthly-publication-december-2025.pdf   579 2025-12 Pedal Bike Volkswagen Polo Silver Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A   52.4390303 -1.9512931
4477 op-snap---monthly-publication-december-2025.pdf   605 2025-12 Pedal Bike Mercedes-Benz Camper White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
4513 op-snap---monthly-publication-december-2025.pdf   641 2025-12 Pedestrian Yamaha GPD125 Blue Driving without Due Care and Attention None bishopsgate street Bishopsgate Street Birmingham Birmingham Education N/A   52.473986 -1.9147087
4538 op-snap---monthly-publication-december-2025.pdf   666 2025-12 Car Ford Transit Grey Driving without Due Care and Attention None A444 A444 Coventry Coventry Education N/A      
4551 op-snap---monthly-publication-december-2025.pdf   679 2025-12 Pedal Bike   Benelli Tornado Naked White Driving without Due Care and Attention None Portman Road, Kings Heath Portman Road, Kings Heath Birmingham Birmingham Education N/A   52.4289531 -1.8834204
4570 op-snap---monthly-publication-december-2025.pdf   698 2025-12 Car Ford Focus Black Driving without Due Care and Attention None Clifford Bridge Road to Ansty Road Clifford Bridge Road to Ansty Road Coventry Coventry Education N/A      
4578 op-snap---monthly-publication-december-2025.pdf   706 2025-12 Car Mini Cooper Green Driving without Due Care and Attention None Minworth Island Minworth Island Sutton Coldfield Sutton Coldfield Education N/A   52.5310982 -1.7747583
4579 op-snap---monthly-publication-december-2025.pdf   707 2025-12 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
4584 op-snap---monthly-publication-december-2025.pdf   712 2025-12 Pedal Bike Seat Arona Black Driving without Due Care and Attention None Broad Lane, Balsall Common Broad Lane, Balsall Common Solihull Solihull Education N/A      
4585 op-snap---monthly-publication-december-2025.pdf   713 2025-12 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry Education N/A   52.4144409 -1.5990259
4603 op-snap---monthly-publication-december-2025.pdf   731 2025-12 Car Nissan Micra White Driving without Due Care and Attention None Parson's Hill and Bells Lane, Kings Parson's Hill and Bells Lane, Kings NBoirrmtoinng.ham Nboirrmtoinng.Ham Education N/A   52.4748473 -2.0066867
4607 op-snap---monthly-publication-december-2025.pdf   735 2025-12 Car Skoda Octavia Silver Driving without Due Care and Attention None A38(M) A38(M) Birmingham Birmingham Education N/A   52.4946291 -1.8874209
4620 op-snap---monthly-publication-december-2025.pdf   748 2025-12 Pedal Bike Skoda Fabia grey Driving without Due Care and Attention None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
4641 op-snap---monthly-publication-december-2025.pdf   769 2025-12 Car Ford Focus Silver Driving without Due Care and Attention None Harborne lane Harborne lane Birmingham Birmingham Education N/A   52.4468464 -1.9454816
4665 op-snap---monthly-publication-december-2025.pdf   793 2025-12 Pedal Bike Renault Master White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
4693 op-snap---monthly-publication-december-2025.pdf   821 2025-12 Car BMW E220 Black Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
4704 op-snap---monthly-publication-december-2025.pdf   832 2025-12 Pedal Bike Honda CRV Grey Driving without Due Care and Attention None Portman Road Portman Road Birmingham Birmingham Education N/A   52.4306424 -1.8844833
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
4716 op-snap---monthly-publication-december-2025.pdf   844 2025-12 Pedal Bike Jeep Renegade Black Driving without Due Care and Attention None Broad Lane, Tile Hill, Coventry Broad Lane, Tile Hill, Coventry Coventry Coventry Education N/A   52.4112706 -1.5792697
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
4725 op-snap---monthly-publication-december-2025.pdf   853 2025-12 Pedal Bike Mazda CX3 Silver Driving without Due Care and Attention None Tile Hill Lane, Tile Hill, Coventry Tile Hill Lane, Tile Hill, Coventry Coventry Coventry Education N/A   52.4019676 -1.5834005
4760 op-snap---monthly-publication-december-2025.pdf   888 2025-12 Car Honda CRV Blue Driving without Due Care and Attention None Oakenshaw Road Oakenshaw Road Solihull Solihull Education N/A   52.4017754 -1.8151522
4762 op-snap---monthly-publication-december-2025.pdf   890 2025-12 Pedal Bike Kia Carens Silver Driving without Due Care and Attention None Camp Hill Middleway Camp Hill Middleway Birmingham Birmingham Education N/A   52.468339 -1.8796724
4774 op-snap---monthly-publication-december-2025.pdf   902 2025-12 car Vauxhall Corsa Silver Driving without Due Care and Attention None California Way California Way Birmingham Birmingham Education N/A   52.4454714 -1.9753804
4775 op-snap---monthly-publication-december-2025.pdf   903 2025-12 Car Audi A1 White Driving without Due Care and Attention None Vauxhall Road Vauxhall Road Birmingham Birmingham Education N/A   52.4834623 -1.8796522
4789 op-snap---monthly-publication-december-2025.pdf   917 2025-12 Pedal Bike Volkswagen Tiguan Green Driving without Due Care and Attention None Walkmley Road Walkmley Road Sutton Coldfield Sutton Coldfield Education N/A      
4816 op-snap---monthly-publication-december-2025.pdf   944 2025-12 Pedal Bike BMW IX Grey Driving without Due Care and Attention None Whitefields Road Whitefields Road Solihull Solihull Education N/A   52.4060267 -1.7849657
4835 op-snap---monthly-publication-december-2025.pdf   963 2025-12 Other Volkswagen Crafter Silver Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4852 op-snap---monthly-publication-december-2025.pdf   980 2025-12 Car Peugeot 2008 White Driving without Due Care and Attention None Webster Way, Walmley Webster Way, Walmley Sutton Coldfield Sutton Coldfield Education N/A   52.535716 -1.7856098
4871 op-snap---monthly-publication-december-2025.pdf   999 2025-12 Car Mercedes-Benz A180 White Driving without Due Care and Attention None Lucas Circus Hockley Lucas Circus Hockley Birmingham Birmingham Education N/A      
4877 op-snap---monthly-publication-december-2025.pdf   1005 2025-12 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Teviot Grove, Kings Norton Teviot Grove, Kings Norton Birmingham Birmingham Education N/A   52.3986816 -1.9362011
4878 op-snap---monthly-publication-december-2025.pdf   1006 2025-12 Pedal Bike Peugeot Boxer White Driving without Due Care and Attention None Melrose Avenue Melrose Avenue Sutton Coldfield Sutton Coldfield Education N/A   52.5511462 -1.8479052
4879 op-snap---monthly-publication-december-2025.pdf   1007 2025-12 Pedal Bike Jaguar Fpace Black Driving without Due Care and Attention None Cordbridge Road Cordbridge Road Sutton Coldfield Sutton Coldfield Education N/A      
4882 op-snap---monthly-publication-december-2025.pdf   1010 2025-12 Pedal Bike Citroen DS3 White Driving without Due Care and Attention None Redhill Road Redhill Road Birmingham Birmingham Education N/A   52.4618364 -1.8328803
4905 op-snap---monthly-publication-december-2025.pdf   1033 2025-12 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention None Kent Street Kent Street Birmingham Birmingham Education N/A   52.4717099 -1.897463
4910 op-snap---monthly-publication-december-2025.pdf   1038 2025-12 Car Mercedes-Benz C class Grey Driving without Due Care and Attention None Bordesley Green East Bordesley Green East Birmingham Birmingham Education N/A   52.4802441 -1.8327073
4925 op-snap---monthly-publication-december-2025.pdf   1053 2025-12 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Edward Road / Lincoln Street Edward Road / Lincoln Street Birmingham Birmingham Education N/A   52.4580901 -1.894458
4929 op-snap---monthly-publication-december-2025.pdf   1057 2025-12 Pedal Bike Kia Picanto Silver Driving without Due Care and Attention None Russell Road / Edgbaston Road Russell Road / Edgbaston Road Birmingham Birmingham Education N/A   52.4398245 -1.8469786
4984 op-snap---monthly-publication-december-2025.pdf   1112 2025-12 Car BMW X5 Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
5062 op-snap---monthly-publication-december-2025.pdf   1190 2025-12 Car Volkswagen Polo Silver Driving without Due Care and Attention None Barrows Lane at Moat Lane Barrows Lane at Moat Lane Birmingham Birmingham Education N/A   52.4566463 -1.7912653
5101 op-snap---monthly-publication-december-2025.pdf   1229 2025-12 Car Ford Puma Silver Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
5142 op-snap---monthly-publication-december-2025.pdf   1270 2025-12 Car Ford Focus Black Driving without Due Care and Attention None St Johns Road Street Johns Road Walsall Walsall Education N/A   52.5774583 -2.0018611
5161 op-snap---monthly-publication-december-2025.pdf   1289 2025-12 Car Nissan Qashqai Red Driving without Due Care and Attention None Longmore Road Longmore Road Solihull Solihull Education N/A   52.4078616 -1.8211577

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