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

78 rows where month = "2026-01", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

disposal 5

reporter_transport_mode 1

  • Pedal Bike · 78 ✖

offence 1

  • Driving without Due Care and Attention · 78 ✖

month 1

  • 2026-01 · 78 ✖
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
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
10558 op-snap---monthly-publication-january-2026.pdf   19 2026-01 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention No vehicle excise licence Brook Lane Brook Lane Birmingham Birmingham Court N/A   52.4297007 -1.8668846
10579 op-snap---monthly-publication-january-2026.pdf   40 2026-01 Pedal Bike Ford Transit Green Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham Warning Letter N/A      
10580 op-snap---monthly-publication-january-2026.pdf   41 2026-01 Pedal Bike Honda CR-V Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
10581 op-snap---monthly-publication-january-2026.pdf   42 2026-01 Pedal Bike   Bus   Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
10607 op-snap---monthly-publication-january-2026.pdf   68 2026-01 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Lower Broad Heath (worcester) Lower Broad Heath (worcester) Out of Force Area Out of Force Area NFA Out of Force      
10628 op-snap---monthly-publication-january-2026.pdf   89 2026-01 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Warning Letter N/A   52.4297007 -1.8668846
10762 op-snap---monthly-publication-january-2026.pdf   223 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10825 op-snap---monthly-publication-january-2026.pdf   286 2026-01 Pedal Bike Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Quinton Island Quinton Island Birmingham Birmingham NFA No Independent Evidence Available   52.4617515 -2.0079008
10845 op-snap---monthly-publication-january-2026.pdf   306 2026-01 Pedal Bike   Irizar Coach Grey Driving without Due Care and Attention None Lawley Middleway, Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10846 op-snap---monthly-publication-january-2026.pdf   307 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10884 op-snap---monthly-publication-january-2026.pdf   345 2026-01 Pedal Bike Volkswagen Crafter White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10918 op-snap---monthly-publication-january-2026.pdf   379 2026-01 Pedal Bike Iveco Daily White Driving without Due Care and Attention None Pedmore Road Pedmore Road Dudley Dudley Fixed Penalty N/A   52.4897451 -2.1069141
10977 op-snap---monthly-publication-january-2026.pdf   438 2026-01 Pedal Bike BMW 330 E Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10979 op-snap---monthly-publication-january-2026.pdf   440 2026-01 Pedal Bike Citroen DS3 White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
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
10994 op-snap---monthly-publication-january-2026.pdf   455 2026-01 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Education N/A   52.4682339 -1.8793662
11043 op-snap---monthly-publication-january-2026.pdf   504 2026-01 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11080 op-snap---monthly-publication-january-2026.pdf   541 2026-01 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Slade Road, Edgbaston Slade Road, Edgbaston Birmingham Birmingham Education N/A      
11091 op-snap---monthly-publication-january-2026.pdf   552 2026-01 Pedal Bike BMW z4 Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
11097 op-snap---monthly-publication-january-2026.pdf   558 2026-01 Pedal Bike Ford Kuga Silver Driving without Due Care and Attention None Eachway Lane Eachway Lane Birmingham Birmingham Education N/A   52.3882492 -2.0091218
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
11109 op-snap---monthly-publication-january-2026.pdf   570 2026-01 Pedal Bike Lexus UX250 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
11120 op-snap---monthly-publication-january-2026.pdf   581 2026-01 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry Education N/A   52.4352 -1.5194238
11194 op-snap---monthly-publication-january-2026.pdf   655 2026-01 Pedal Bike BMW 428i Blue Driving without Due Care and Attention None Fosse Way, Warwick Fosse Way, Warwick Out of Force Area Out of Force Area NFA Out of Force      
11210 op-snap---monthly-publication-january-2026.pdf   671 2026-01 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Warning Letter N/A   52.4061531 -1.505845
11213 op-snap---monthly-publication-january-2026.pdf   674 2026-01 Pedal Bike Mg hatchback White Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No Independent Evidence Available   52.3868298 -2.0003781
11245 op-snap---monthly-publication-january-2026.pdf   706 2026-01 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Pershore Road South, Kings Norton Pershore Road South, Kings Norton Birmingham Birmingham Education N/A   52.4116071 -1.9297714
11273 op-snap---monthly-publication-january-2026.pdf   734 2026-01 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Warning Letter N/A   52.402753 -1.5385829
11279 op-snap---monthly-publication-january-2026.pdf   740 2026-01 Pedal Bike Mitsubishi Outlander Silver Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11281 op-snap---monthly-publication-january-2026.pdf   742 2026-01 Pedal Bike BMW 320D White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
11283 op-snap---monthly-publication-january-2026.pdf   744 2026-01 Pedal Bike Volkswagen Passat Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
11285 op-snap---monthly-publication-january-2026.pdf   746 2026-01 Pedal Bike Volvo V40.. Grey Driving without Due Care and Attention None Cranmore Boulevard Cranmore Boulevard Solihull Solihull Education N/A   52.3947549 -1.8141729
11286 op-snap---monthly-publication-january-2026.pdf   747 2026-01 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham NFA No Offence   52.4695793 -1.9378608
11315 op-snap---monthly-publication-january-2026.pdf   776 2026-01 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None The Broadway The Broadway Dudley Dudley Warning Letter N/A   52.515445 -2.0885791
11336 op-snap---monthly-publication-january-2026.pdf   797 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
11344 op-snap---monthly-publication-january-2026.pdf   805 2026-01 Pedal Bike Porsche Panamera Black Driving without Due Care and Attention None Lordswood Road Lordswood Road Birmingham Birmingham Education N/A   52.4591339 -1.9601054
11351 op-snap---monthly-publication-january-2026.pdf   812 2026-01 Pedal Bike Citroen C3 Black Driving without Due Care and Attention None Hollyfast Lane Hollyfast Lane Coventry Coventry Warning Letter N/A   52.4517652 -1.5578662
11356 op-snap---monthly-publication-january-2026.pdf   817 2026-01 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Wenlock Road, Shrewsbury Wenlock Road, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
11367 op-snap---monthly-publication-january-2026.pdf   828 2026-01 Pedal Bike BMW X4 Blue Driving without Due Care and Attention None South Road South Road Birmingham Birmingham Warning Letter N/A   52.4972567 -1.9214327
11368 op-snap---monthly-publication-january-2026.pdf   829 2026-01 Pedal Bike Mercedes-Benz C300 Black Driving without Due Care and Attention None Quinton Interchange Quinton Interchange Dudley Dudley Education N/A   52.4539668 -2.0119854
11402 op-snap---monthly-publication-january-2026.pdf   863 2026-01 Pedal Bike Kia Sportage Black Driving without Due Care and Attention None Park Road Park Road Birmingham Birmingham Warning Letter N/A   52.5641687 -1.8272087
11427 op-snap---monthly-publication-january-2026.pdf   888 2026-01 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
11432 op-snap---monthly-publication-january-2026.pdf   893 2026-01 Pedal Bike Honda Civic Grey Driving without Due Care and Attention None Belford Road Belford Road Out of Force Area Out of Force Area NFA Out of Force      
11451 op-snap---monthly-publication-january-2026.pdf   912 2026-01 Pedal Bike Audi A3 Grey Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11460 op-snap---monthly-publication-january-2026.pdf   921 2026-01 Pedal Bike Volkswagen Golf White Driving without Due Care and Attention None Brook lane Brook lane Birmingham Birmingham Court N/A   52.4297007 -1.8668846
11507 op-snap---monthly-publication-january-2026.pdf   968 2026-01 Pedal Bike Volkswagen Golf Red Driving without Due Care and Attention None Norton Road Norton Road Dudley Dudley NFA No Offence   52.4483733 -2.1546673
11516 op-snap---monthly-publication-january-2026.pdf   977 2026-01 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11549 op-snap---monthly-publication-january-2026.pdf   1010 2026-01 Pedal Bike Nissan Qashqai White Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
11550 op-snap---monthly-publication-january-2026.pdf   1011 2026-01 Pedal Bike Vauxhall Corsa Red Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham Education N/A   52.4045186 -1.9891793
11552 op-snap---monthly-publication-january-2026.pdf   1013 2026-01 Pedal Bike Kia Sportage Grey Driving without Due Care and Attention None Black Haynes Road Black Haynes Road Birmingham Birmingham Warning Letter N/A   52.4260755 -1.9679443
11553 op-snap---monthly-publication-january-2026.pdf   1014 2026-01 Pedal Bike Jaguar F Pace Black Driving without Due Care and Attention No Insurance Stoney Stanton road Stoney Stanton road Coventry Coventry Court N/A   52.4221152 -1.4959475
11562 op-snap---monthly-publication-january-2026.pdf   1023 2026-01 Pedal Bike Audi A4 Red Driving without Due Care and Attention None Westfield Road Westfield Road Birmingham Birmingham Fixed Penalty N/A   52.4362187 -1.8987821
11584 op-snap---monthly-publication-january-2026.pdf   1045 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Heath Lane Heath Lane Sandwell Sandwell Education N/A   52.5369717 -1.9907285
11590 op-snap---monthly-publication-january-2026.pdf   1051 2026-01 Pedal Bike Scania HGV White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
11594 op-snap---monthly-publication-january-2026.pdf   1055 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Wychall Road Wychall Road Birmingham Birmingham Education N/A   52.4089092 -1.9498562
11605 op-snap---monthly-publication-january-2026.pdf   1066 2026-01 Pedal Bike Skoda Superb Black Driving without Due Care and Attention None Kineton Green Road Kineton Green Road Solihull Solihull Education N/A   52.4332233 -1.812229
11627 op-snap---monthly-publication-january-2026.pdf   1088 2026-01 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Maynard Avenue Maynard Avenue Dudley Dudley NFA No Offence   52.4464709 -2.1663682
11629 op-snap---monthly-publication-january-2026.pdf   1090 2026-01 Pedal Bike   Infiniti Grey Driving without Due Care and Attention None Underhill Road Underhill Road Walsall Walsall Education N/A      
11636 op-snap---monthly-publication-january-2026.pdf   1097 2026-01 Pedal Bike Mercedes-Benz Tourismo Blue Driving without Due Care and Attention None Warwick Road at Ashleigh Road Warwick Road at Ashleigh Road Solihull Solihull Warning Letter N/A   52.4385199 -1.8069384
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
11690 op-snap---monthly-publication-january-2026.pdf   1151 2026-01 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
11696 op-snap---monthly-publication-january-2026.pdf   1157 2026-01 Pedal Bike Hyundai i10 Blue Driving without Due Care and Attention None Albany Road Albany Road Coventry Coventry Education N/A   52.4006218 -1.5284125
11742 op-snap---monthly-publication-january-2026.pdf   1203 2026-01 Pedal Bike Peugeot Partner White Driving without Due Care and Attention None Lakey Lane Lakey Lane Birmingham Birmingham Warning Letter N/A   52.4311142 -1.8324795
11743 op-snap---monthly-publication-january-2026.pdf   1204 2026-01 Pedal Bike Ford Kuga Black Driving without Due Care and Attention None Lakey Lane Lakey Lane Birmingham Birmingham Warning Letter N/A   52.4311142 -1.8324795
11752 op-snap---monthly-publication-january-2026.pdf   1213 2026-01 Pedal Bike Fiat 500 Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
11834 op-snap---monthly-publication-january-2026.pdf   1295 2026-01 Pedal Bike Suzuki Swift Blue Driving without Due Care and Attention None White Street White Street Coventry Coventry Court N/A   52.4122951 -1.5045181
11838 op-snap---monthly-publication-january-2026.pdf   1299 2026-01 Pedal Bike Lamborghini Urus Blue Driving without Due Care and Attention No Insurance Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
11844 op-snap---monthly-publication-january-2026.pdf   1305 2026-01 Pedal Bike Audi   White Driving without Due Care and Attention None Albany Road Albany Road Birmingham Birmingham NFA No VRM   52.4591259 -1.9506139
11873 op-snap---monthly-publication-january-2026.pdf   1334 2026-01 Pedal Bike Mercedes-Benz C220 Blue Driving without Due Care and Attention No Insurance Augustus Road Augustus Road Birmingham Birmingham Court N/A   52.4695793 -1.9378608
11896 op-snap---monthly-publication-january-2026.pdf   1357 2026-01 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Pensnett Road Pensnett Road Dudley Dudley Education N/A   52.4890857 -2.1299003
11913 op-snap---monthly-publication-january-2026.pdf   1374 2026-01 Pedal Bike Volvo XC60 Red Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
11914 op-snap---monthly-publication-january-2026.pdf   1375 2026-01 Pedal Bike Citroen Berlingo Grey Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham Education N/A   52.4045186 -1.9891793
11915 op-snap---monthly-publication-january-2026.pdf   1376 2026-01 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Bourneville Lane Bourneville Lane Birmingham Birmingham Education N/A      
11916 op-snap---monthly-publication-january-2026.pdf   1377 2026-01 Pedal Bike Volvo V40 blue Driving without Due Care and Attention None Raddlebarn Road, Selly Oak Raddlebarn Road, Selly Oak Birmingham Birmingham Education N/A   52.4355872 -1.9346434
11924 op-snap---monthly-publication-january-2026.pdf   1385 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None B4102 Solihull Road Solihull Road Solihull Solihull Education N/A   52.4114159 -1.8197732
11937 op-snap---monthly-publication-january-2026.pdf   1398 2026-01 Pedal Bike Peugeot 2008 White Driving without Due Care and Attention None Burlton, Shropshire Burlton, Shropshire Out of Force Area Out of Force Area NFA Out of Force      
11939 op-snap---monthly-publication-january-2026.pdf   1400 2026-01 Pedal Bike Audi   White Driving without Due Care and Attention None off force Off Force Out of Force Area Out of Force Area NFA Out of Force      

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