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

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

month 1

  • 2025-12 · 147 ✖

disposal 1

  • Education · 147 ✖
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
3974 op-snap---monthly-publication-december-2025.pdf   102 2025-12 Car Volkswagen golf Black Cause vehicle to be left in a dangerous position None washwood heath road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
3979 op-snap---monthly-publication-december-2025.pdf   107 2025-12 Pedestrian Audi q3 Black Cause vehicle to be left in a dangerous position None gayfield avenue Gayfield Avenue Dudley Dudley Education N/A   52.4693896 -2.1251602
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      
3991 op-snap---monthly-publication-december-2025.pdf   119 2025-12 Car Ford Transit White Contravening a Red Traffic Light None Factory Road Factory Road Dudley Dudley Education N/A   52.5324055 -2.0739923
3992 op-snap---monthly-publication-december-2025.pdf   120 2025-12 Car Mercedes-Benz Vito White Contravening a Red Traffic Light None Factory Road Factory Road Dudley Dudley Education N/A   52.5324055 -2.0739923
3997 op-snap---monthly-publication-december-2025.pdf   125 2025-12 Car Renault Truck White Contravening a Red Traffic Light None Newport Road, Castle Bromwich Newport Road, Castle Bromwich Birmingham Birmingham Education N/A      
4007 op-snap---monthly-publication-december-2025.pdf   135 2025-12 Car Audi A5 Silver Contravening a Red Traffic Light None Church Hill Road Church Hill Road Solihull Solihull Education N/A   52.4078582 -1.7777439
4014 op-snap---monthly-publication-december-2025.pdf   142 2025-12 Car BMW 2 series Black Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
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
4036 op-snap---monthly-publication-december-2025.pdf   164 2025-12 Car BMW 420 Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
4039 op-snap---monthly-publication-december-2025.pdf   167 2025-12 Car Ford Fiesta White Driving without Reasonable Consideration None Black Country New Road Black Country New Road Sandwell Sandwell Education N/A   52.5527191 -2.0312967
4073 op-snap---monthly-publication-december-2025.pdf   201 2025-12 Car Suzuki Swift White Contravening a Red Traffic Light None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Education N/A   52.4861917 -1.8829748
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
4116 op-snap---monthly-publication-december-2025.pdf   244 2025-12 Car Volkswagen Tiguan Black Contravening a Red Traffic Light None Kitchen Lane, Ashmore Park Kitchen Lane, Ashmore Park Wolverhampton Wolverhampton Education N/A   52.6214265 -2.0603757
4122 op-snap---monthly-publication-december-2025.pdf   250 2025-12 Car Ford Focus Silver Contravening a Red Traffic Light None Chester Road, Spitfire Island, Castl Chester Road, Spitfire Island, Castl eB iVrmaleingham Eb Ivrmaleingham Education N/A      
4153 op-snap---monthly-publication-december-2025.pdf   281 2025-12 Car Volkswagen Polo White Contravening a Red Traffic Light None Lichfield Road A5127 / Cuckoo Ro Lichfield Road A5127 / Cuckoo Ro aBdirmingham Abdirmingham Education N/A   52.5872149 -1.8300386
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      
4165 op-snap---monthly-publication-december-2025.pdf   293 2025-12 Car Toyota Camry Black Contravening a Red Traffic Light None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
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      
4253 op-snap---monthly-publication-december-2025.pdf   381 2025-12 Pedestrian Volkswagen golf White Cause vehicle to be left in a dangerous position VRM fails to conform to Regu glaatyiofinesld avenue Glaatyiofinesld Avenue Dudley Dudley 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      
4324 op-snap---monthly-publication-december-2025.pdf   452 2025-12 Pedestrian Vauxhall corsa Black Stop a vehicle within pelican pedestrian crossing limits None bristol road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
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
4368 op-snap---monthly-publication-december-2025.pdf   496 2025-12 Car Mercedes-Benz glc 250 White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
4372 op-snap---monthly-publication-december-2025.pdf   500 2025-12 Pedestrian BMW 330e Blue Cause vehicle to be left in a dangerous position None westley road Westley Road Birmingham Birmingham Education N/A   52.4456462 -1.827993
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      
4394 op-snap---monthly-publication-december-2025.pdf   522 2025-12 Car Volkswagen Scirroco White Contravening a Red Traffic Light None Stratford Road Shirley Stratford Road Shirley Birmingham Birmingham Education N/A      
4396 op-snap---monthly-publication-december-2025.pdf   524 2025-12 Car BMW 420D Grey Contravening a Red Traffic Light None Hamsread Road, Hockley Hamsread Road, Hockley Birmingham Birmingham Education N/A      
4397 op-snap---monthly-publication-december-2025.pdf   525 2025-12 Car Volkswagen Golf Silver Contravening a Red Traffic Light None A4040 Wellington Road Wellington Road Birmingham Birmingham Education N/A   52.5133725 -1.9193405
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
4422 op-snap---monthly-publication-december-2025.pdf   550 2025-12 Car Toyota Yaris Red Stop a vehicle within pelican pedestrian crossing limits None Near Pedestrian CrossingStoney S Near Pedestrian Crossing Stoney S tBanirtmonin Rghda nmr junction with Cambrid Tbanirtmonin Rghda Nmr Junction With Cambrid Education N/A      
4424 op-snap---monthly-publication-december-2025.pdf   552 2025-12 Car Toyota Yaris Red Contravening a Red Traffic Light None High Street (A491), Stourbridge High Street (A491), Stourbridge Dudley Dudley Education N/A   52.4602651 -2.1490725
4429 op-snap---monthly-publication-december-2025.pdf   557 2025-12 Car BMW 33D Grey Contravening a Red Traffic Light None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
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
4433 op-snap---monthly-publication-december-2025.pdf   561 2025-12 Pedestrian Lexus CT White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
4434 op-snap---monthly-publication-december-2025.pdf   562 2025-12 Pedestrian BMW X1 White Cause vehicle to be left in a dangerous position None Bamville Road corner Washwood Bamville Road corner Washwood HBeiramthi nRgohaadm Hbeiramthi Nrgohaadm Education N/A      
4446 op-snap---monthly-publication-december-2025.pdf   574 2025-12 Car Audi q3 Blue Contravene Lane Closure Red X None m42 NB junction 3 m42 Northbound junction 3 Solihull Solihull Education N/A   52.4846642 -1.9297585
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
4466 op-snap---monthly-publication-december-2025.pdf   594 2025-12 Car Land Rover Defender Brown Vehicle overtake within crossing limits None Solihull lane Solihull lane Birmingham Birmingham Education N/A   52.4230862 -1.8347873
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
4519 op-snap---monthly-publication-december-2025.pdf   647 2025-12 Car Audi A3 Black Contravening a Red Traffic Light None Brighton Road Brighton Road Birmingham Birmingham Education N/A   52.4543156 -1.8840717
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
4569 op-snap---monthly-publication-december-2025.pdf   697 2025-12 Car BMW 740.. White Contravene Lane Closure Red X None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
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
4614 op-snap---monthly-publication-december-2025.pdf   742 2025-12 Car Audi a4 Silver Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
4619 op-snap---monthly-publication-december-2025.pdf   747 2025-12 Car Volkswagen Passat Grey Driving without Reasonable Consideration None M6 NB 4-5 M6 Northbound 4-5 Birmingham Birmingham Education N/A      
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
4633 op-snap---monthly-publication-december-2025.pdf   761 2025-12 Car Audi A3 Blue Contravening a Red Traffic Light None Hickman Road Hickman Road Dudley Dudley Education N/A   52.4878144 -2.1286751
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
4644 op-snap---monthly-publication-december-2025.pdf   772 2025-12 Car Peugeot 5008 Grey Drive a vehicle other than on the carriageway of a motorway None M6 SB J6 M6 Southbound J6 Birmingham Birmingham Education N/A   52.676119 -2.0858425
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
4667 op-snap---monthly-publication-december-2025.pdf   795 2025-12 Car Ford eco sport Grey Contravening a Red Traffic Light None Wednesbury J9 Roundabout Wednesbury J9 Roundabout Sandwell Sandwell Education N/A      
4675 op-snap---monthly-publication-december-2025.pdf   803 2025-12 Car Mg 3.. Black Contravening a Red Traffic Light None Blackberry Lane Blackberry Lane Coventry Coventry Education N/A   52.4254016 -1.4665041
4676 op-snap---monthly-publication-december-2025.pdf   804 2025-12 Car Ford Focus Blue Contravening a Red Traffic Light None West Boulevard West Boulevard Birmingham Birmingham Education N/A   52.4484674 -1.9780395
4686 op-snap---monthly-publication-december-2025.pdf   814 2025-12 Car Hyundai Tuscon Black Contravening a Red Traffic Light None Jennens Road Jennens Road Birmingham Birmingham Education N/A   52.4855858 -1.8837544
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
4701 op-snap---monthly-publication-december-2025.pdf   829 2025-12 Car Ford Transit Blue Stop a vehicle within pelican pedestrian crossing limits None far gosford street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
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
4753 op-snap---monthly-publication-december-2025.pdf   881 2025-12 Car Vauxhall Vivaro Silver Contravening a Red Traffic Light None Digby Road / Somerville Road Digby Road / Somerville Road Sutton Coldfield Sutton Coldfield Education N/A   52.5573003 -1.8317101
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
4761 op-snap---monthly-publication-december-2025.pdf   889 2025-12 Car Seat Toledo Blue Contravening a Red Traffic Light None A4123 Black Country New Road Black Country New Road Dudley Dudley Education N/A      
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
4780 op-snap---monthly-publication-december-2025.pdf   908 2025-12 Pedestrian Audi   Blue Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Rd Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
4781 op-snap---monthly-publication-december-2025.pdf   909 2025-12 Pedestrian Mini Cooper Red Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Rd Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
4787 op-snap---monthly-publication-december-2025.pdf   915 2025-12 Pedestrian Toyota Prius Black Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
4788 op-snap---monthly-publication-december-2025.pdf   916 2025-12 Pedestrian Toyota prius White Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092

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