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

88 rows where disposal = "Warning Letter", month = "2025-03" 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

reporter_transport_mode 1

  • Pedal Bike · 88 ✖

month 1

  • 2025-03 · 88 ✖

disposal 1

  • Warning Letter · 88 ✖
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
16390 op-snap---monthly-publication-march-2025.pdf   147 2025-03 Pedal Bike Audi A5 Grey Driving without Reasonable Consideration None Icknield Port Road Icknield Port Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4792334 -1.92925
16416 op-snap---monthly-publication-march-2025.pdf   173 2025-03 Pedal Bike Renault Clio Silver Driving without Reasonable Consideration None Newton Road, Scott Arms Newton Road, Scott Arms Birmingham Birmingham Warning Letter N/A Yes - Via Email    
16446 op-snap---monthly-publication-march-2025.pdf   203 2025-03 Pedal Bike Daf Ssmart Silver Driving without Reasonable Consideration None Selly Park Road Selly Park Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4390561 -1.9209229
16505 op-snap---monthly-publication-march-2025.pdf   262 2025-03 Pedal Bike Hyundai Kona Black Driving without Reasonable Consideration None Grange Road Grange Road Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A Yes - Via Email 52.4460133 -1.9330868
16552 op-snap---monthly-publication-march-2025.pdf   309 2025-03 Pedal Bike Daf HGV White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sherlock Street Sherlock Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4702385 -1.895011
16565 op-snap---monthly-publication-march-2025.pdf   322 2025-03 Pedal Bike Ford Ranger Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Breedon Road Breedon Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4191978 -1.9251219
16579 op-snap---monthly-publication-march-2025.pdf   336 2025-03 Pedal Bike Toyota Yaris Black Driving without Reasonable Consideration None Walsall Wood Road Walsall Wood Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5623476 -1.9436356
16637 op-snap---monthly-publication-march-2025.pdf   394 2025-03 Pedal Bike Mercedes-Benz GLA 220 White Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3875525 -1.8339426
16638 op-snap---monthly-publication-march-2025.pdf   395 2025-03 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None Frogmill Lane Frogmill Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4023807 -2.0047634
16641 op-snap---monthly-publication-march-2025.pdf   398 2025-03 Pedal Bike Mercedes-Benz Sprinter Yellow Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lodge Hill Road Lodge Hill Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4390011 -1.9455485
16683 op-snap---monthly-publication-march-2025.pdf   440 2025-03 Pedal Bike Daf Box Van White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Smallbrook Queensway Smallbrook Queensway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4772584 -1.8965734
16774 op-snap---monthly-publication-march-2025.pdf   531 2025-03 Pedal Bike Nissan NAVARA White Driving without Reasonable Consideration None BRISTOL ROAD Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
16778 op-snap---monthly-publication-march-2025.pdf   535 2025-03 Pedal Bike Land Rover EVOQUE Black Driving without Reasonable Consideration None UPPER HOLLAND ROAD Upper Holland Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.561 -1.8187105
16888 op-snap---monthly-publication-march-2025.pdf   645 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Friday Lane Friday Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4142542 -1.7217662
16903 op-snap---monthly-publication-march-2025.pdf   660 2025-03 Pedal Bike Volkswagen Caddy White Driving without Reasonable Consideration None Long Acre Long Acre Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5051253 -1.8646383
16916 op-snap---monthly-publication-march-2025.pdf   673 2025-03 Pedal Bike Mercedes-Benz A class Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Yardley Wood Lane Yardley Wood Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.411163 -1.8533471
16918 op-snap---monthly-publication-march-2025.pdf   675 2025-03 Pedal Bike Mercedes-Benz C CLASS Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Yardley Wood Lane Yardley Wood Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.411163 -1.8533471
16931 op-snap---monthly-publication-march-2025.pdf   688 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Billesley Lane Billesley Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4344402 -1.8845368
16948 op-snap---monthly-publication-march-2025.pdf   705 2025-03 Pedal Bike Volkswagen Crafter Black Contravening a Red Traffic Light None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5405351 -1.8002219
16965 op-snap---monthly-publication-march-2025.pdf   722 2025-03 Pedal Bike Peugeot 308CC Blue Fail to display front VRM plate None Worcester Lane Worcester Lane Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5908671 -1.8140277
16969 op-snap---monthly-publication-march-2025.pdf   726 2025-03 Pedal Bike Peugeot 308 Grey Driving without Reasonable Consideration None Cliff Road Road Cliff Road Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email    
16999 op-snap---monthly-publication-march-2025.pdf   756 2025-03 Pedal Bike Vauxhall Zafira Black Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4134557 -1.4442138
17002 op-snap---monthly-publication-march-2025.pdf   759 2025-03 Pedal Bike Toyota Prius White Driving without Reasonable Consideration None Humber Road Humber Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4050667 -1.4866877
17014 op-snap---monthly-publication-march-2025.pdf   771 2025-03 Pedal Bike Mercedes-Benz Box van White Driving without Reasonable Consideration None Holiday Street Holiday Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4757071 -1.8988573
17016 op-snap---monthly-publication-march-2025.pdf   773 2025-03 Pedal Bike Audi A3 Silver Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.471632 -1.9456776
17050 op-snap---monthly-publication-march-2025.pdf   807 2025-03 Pedal Bike Lexus ch200 Black Driving without Reasonable Consideration None Grantham Road Grantham Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4624098 -1.8708709
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
17056 op-snap---monthly-publication-march-2025.pdf   813 2025-03 Pedal Bike Honda Jazz Blue Driving without Reasonable Consideration None Warwick Road Warwick Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.401916 -1.5154953
17090 op-snap---monthly-publication-march-2025.pdf   847 2025-03 Pedal Bike Mg ZS White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.471632 -1.9456776
17179 op-snap---monthly-publication-march-2025.pdf   936 2025-03 Pedal Bike Mercedes-Benz X250 Grey Driving without Due Care and Attention None Quinton Road Quinton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.447826 -1.9574468
17240 op-snap---monthly-publication-march-2025.pdf   997 2025-03 Pedal Bike Mitsubishi L200 Silver Driving without Due Care and Attention None Wall Hill Road Wall Hill Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4459445 -1.5552508
17265 op-snap---monthly-publication-march-2025.pdf   1022 2025-03 Pedal Bike   SCANIA White Contravening a Red Traffic Light None Hearsall Common Hearsall Common Coventry Coventry Warning Letter N/A Yes - Via Email 52.402753 -1.5385829
17304 op-snap---monthly-publication-march-2025.pdf   1061 2025-03 Pedal Bike Kia Sportage White Driving without Reasonable Consideration None Holyhead Road Holyhead Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.418488 -1.5472387
17355 op-snap---monthly-publication-march-2025.pdf   1112 2025-03 Pedal Bike Volvo XC40 Blue Driving without Reasonable Consideration None Quinton Rd Quinton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.447826 -1.9574468
17464 op-snap---monthly-publication-march-2025.pdf   1221 2025-03 Pedal Bike Ford Transit Silver Driving without Reasonable Consideration None Hill Street Hill Street Coventry Coventry Warning Letter N/A Yes - Via Email 52.4094312 -1.51615
17465 op-snap---monthly-publication-march-2025.pdf   1222 2025-03 Pedal Bike Ford Focus Black Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4063195 -1.5157306
17504 op-snap---monthly-publication-march-2025.pdf   1261 2025-03 Pedal Bike Ford Ranger Black Driving without Reasonable Consideration None Warwick Road Warwick Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.4428606 -1.812114
17514 op-snap---monthly-publication-march-2025.pdf   1271 2025-03 Pedal Bike Chevrolet Trax White Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
17575 op-snap---monthly-publication-march-2025.pdf   1332 2025-03 Pedal Bike Mercedes-Benz A class Grey VRM fails to conform to Regulations None Bennetts Hill Bennetts Hill Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17625 op-snap---monthly-publication-march-2025.pdf   1382 2025-03 Pedal Bike Audi A3 Silver Driving without Reasonable Consideration No vehicle excise licence Lea Road Lea Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4533235 -1.8606305
17711 op-snap---monthly-publication-march-2025.pdf   1468 2025-03 Pedal Bike Ford Transit Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hollyfast Road Hollyfast Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4230701 -1.5346523
17747 op-snap---monthly-publication-march-2025.pdf   1504 2025-03 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Highfield road Highfield road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4216321 -1.855984
17774 op-snap---monthly-publication-march-2025.pdf   1531 2025-03 Pedal Bike Land Rover Evoque Orange Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Warning Letter N/A Yes - Via Email 52.4275505 -1.4448681
17781 op-snap---monthly-publication-march-2025.pdf   1538 2025-03 Pedal Bike Vauxhall Astra Red Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Carrington Road, Wednesbury Carrington Road, Wednesbury Walsall Walsall Warning Letter N/A Yes - Via Email    
17796 op-snap---monthly-publication-march-2025.pdf   1553 2025-03 Pedal Bike Porsche Macan Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
17798 op-snap---monthly-publication-march-2025.pdf   1555 2025-03 Pedal Bike Skoda Octivia Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford St Braford Street Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17799 op-snap---monthly-publication-march-2025.pdf   1556 2025-03 Pedal Bike Vauxhall Astra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford St Bradford Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4708802 -1.8792135
17850 op-snap---monthly-publication-march-2025.pdf   1607 2025-03 Pedal Bike Ford Ranger Black Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
17852 op-snap---monthly-publication-march-2025.pdf   1609 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Chester Rd Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
17854 op-snap---monthly-publication-march-2025.pdf   1611 2025-03 Pedal Bike Volkswagen Sharan Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
17908 op-snap---monthly-publication-march-2025.pdf   1665 2025-03 Pedal Bike Ford Minibus White Driving without Reasonable Consideration None Primrose Hill, Kings Norton Primrose Hill, Kings Norton Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.3967197 -1.924102
17952 op-snap---monthly-publication-march-2025.pdf   1709 2025-03 Pedal Bike BMW 118d Silver Driving without Due Care and Attention None Sandy Lane Sandy Lane Coventry Coventry Warning Letter N/A Yes - Via Email 52.4172858 -1.5134012
17977 op-snap---monthly-publication-march-2025.pdf   1734 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Gillhurst Lane Gillhurst Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email    
18011 op-snap---monthly-publication-march-2025.pdf   1768 2025-03 Pedal Bike Volvo XC40 Blue Driving without Reasonable Consideration None Maynard Avenue Maynard Avenue Dudley Dudley Warning Letter N/A Yes - Via Email 52.4464709 -2.1663682
18042 op-snap---monthly-publication-march-2025.pdf   1799 2025-03 Pedal Bike Land Rover   Grey Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Warning Letter N/A Yes - Via Email 52.6068849 -1.9611652
18082 op-snap---monthly-publication-march-2025.pdf   1839 2025-03 Pedal Bike Land Rover Range Rover Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Union Street Coventry Union Street Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.405218 -1.5109433
18123 op-snap---monthly-publication-march-2025.pdf   1880 2025-03 Pedal Bike Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Vivian Road Vivian Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4579568 -1.9510865
18168 op-snap---monthly-publication-march-2025.pdf   1925 2025-03 Pedal Bike Porsche Taycan White Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.471632 -1.9456776
18181 op-snap---monthly-publication-march-2025.pdf   1938 2025-03 Pedal Bike Volkswagen Golf Blue Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4308271 -1.920078
18187 op-snap---monthly-publication-march-2025.pdf   1944 2025-03 Pedal Bike Toyota Corolla White Driving without Reasonable Consideration None Hil Street Hil Street Birmingham Birmingham Warning Letter N/A Yes - Via Email    
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
18230 op-snap---monthly-publication-march-2025.pdf   1987 2025-03 Pedal Bike Nissan Qashqai Silver Driving without Reasonable Consideration None Booths Lane, Queslett Booths Lane, Queslett Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5426102 -1.9049087
18235 op-snap---monthly-publication-march-2025.pdf   1992 2025-03 Pedal Bike Volkswagen Arteon Grey Driving without Reasonable Consideration None Birmingham Road, Wylde Green Birmingham Road, Wylde Green Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5352433 -1.8276127
18280 op-snap---monthly-publication-march-2025.pdf   2037 2025-03 Pedal Bike Toyota Corolla Red Driving without Reasonable Consideration None Ansty Road Ansty Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4205675 -1.4520187
18315 op-snap---monthly-publication-march-2025.pdf   2072 2025-03 Pedal Bike   Scania White Driving without Due Care and Attention None Mitchell Avenue Mitchell Avenue Coventry Coventry Warning Letter Outside of 14 Days NIP Yes - Via Email 52.3940834 -1.5696642
18316 op-snap---monthly-publication-march-2025.pdf   2073 2025-03 Pedal Bike Nissan Note White Driving without Reasonable Consideration None Tanworth Lane Tanworth Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4014694 -1.8220541
18415 op-snap---monthly-publication-march-2025.pdf   2172 2025-03 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Much Park Street Much Park Street Coventry Coventry Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4061531 -1.505845
18422 op-snap---monthly-publication-march-2025.pdf   2179 2025-03 Pedal Bike Toyota Auris Grey Driving without Reasonable Consideration None Hospital Way Hospital Way Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4492818 -1.9391685
18429 op-snap---monthly-publication-march-2025.pdf   2186 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None CHESTER ROAD Chester Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5359496 -1.8324115
18443 op-snap---monthly-publication-march-2025.pdf   2200 2025-03 Pedal Bike Hyundai i40 Black Driving without Due Care and Attention None Vecqueray street at Far Gosford Street Vecqueray street at Far Gosford Street Coventry Coventry Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4066697 -1.4969077
18447 op-snap---monthly-publication-march-2025.pdf   2204 2025-03 Pedal Bike Toyota Prius Silver Using a Mobile Phone Whilst Driving None Alwold Road, Weoley Castle Alwold Road, Weoley Castle Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4436471 -1.9604594
18489 op-snap---monthly-publication-march-2025.pdf   2246 2025-03 Pedal Bike Citroen C1 Red Fail to Conform to Cycle Lane None UPPER WELL STREET Upper Well Street Coventry Coventry Warning Letter N/A Yes - Via Email 52.4102625 -1.5137293
18493 op-snap---monthly-publication-march-2025.pdf   2250 2025-03 Pedal Bike Ford focus Blue Driving without Due Care and Attention None Dale Road Dale Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4470038 -1.9356202
18511 op-snap---monthly-publication-march-2025.pdf   2268 2025-03 Pedal Bike Volkswagen CADDY White Driving without Reasonable Consideration None NORTHFIELD ROAD Northfield Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4167654 -1.9411244
18532 op-snap---monthly-publication-march-2025.pdf   2289 2025-03 Pedal Bike Volvo V40 Grey Driving without Due Care and Attention None Dog Pool Lane Dog Pool Lane Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18537 op-snap---monthly-publication-march-2025.pdf   2294 2025-03 Pedal Bike Audi Quattro Blue Contravening a Red Traffic Light None Nursery Road Harbourne Nursery Road Harbourne Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18539 op-snap---monthly-publication-march-2025.pdf   2296 2025-03 Pedal Bike Skoda Octavia Silver Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4308271 -1.920078
18544 op-snap---monthly-publication-march-2025.pdf   2301 2025-03 Pedal Bike Volkswagen Transporter Black Driving without Reasonable Consideration None Wake Green Road Wake Green Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4437078 -1.8783408
18549 op-snap---monthly-publication-march-2025.pdf   2306 2025-03 Pedal Bike Lamborghini Urus Blue Driving without Reasonable Consideration No Insurance A38 A38 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18550 op-snap---monthly-publication-march-2025.pdf   2307 2025-03 Pedal Bike Volvo XC90 Grey Driving without Reasonable Consideration None A38 A38 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18554 op-snap---monthly-publication-march-2025.pdf   2311 2025-03 Pedal Bike BMW i4 Blue Use a motor vehicle / trailer in a condition likely to cause danger of injury None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.473883 -1.9198244
18584 op-snap---monthly-publication-march-2025.pdf   2341 2025-03 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None Wyhcal Lane Wyhcal Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
18599 op-snap---monthly-publication-march-2025.pdf   2356 2025-03 Pedal Bike Nissan Juke Purple Driving without Reasonable Consideration None Pritchatts Road Pritchatts Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4522304 -1.9267446
18601 op-snap---monthly-publication-march-2025.pdf   2358 2025-03 Pedal Bike Jaguar XE White Driving without Reasonable Consideration None Edward Road Edward Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4580901 -1.894458
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
18614 op-snap---monthly-publication-march-2025.pdf   2371 2025-03 Pedal Bike Hyundai I 10.. Blue Driving without Due Care and Attention None Goodby Road Goodby Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4463558 -1.9039231
18616 op-snap---monthly-publication-march-2025.pdf   2373 2025-03 Pedal Bike Volkswagen Polo Silver Driving without Reasonable Consideration None Wheelers Lane Wheelers Lane Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4306504 -1.878052
18633 op-snap---monthly-publication-march-2025.pdf   2390 2025-03 Pedal Bike Vauxhall Grandland Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Walsall Walsall Warning Letter Outside of 14 Days NIP Yes - Via Email 52.64682 -1.9259844

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