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

94 rows where month = "2025-09", 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 · 94 ✖

offence 1

  • Driving without Due Care and Attention · 94 ✖

month 1

  • 2025-09 · 94 ✖
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
23788 op-snap---monthly-publication-september-2025.pdf   7 2025-09 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Moor Green lane Moor Green lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
23802 op-snap---monthly-publication-september-2025.pdf   21 2025-09 Pedal Bike Kia Sportage Green Driving without Due Care and Attention None Belgrave Road Belgrave Road Birmingham Birmingham Education N/A   52.4669004 -1.9011385
23820 op-snap---monthly-publication-september-2025.pdf   39 2025-09 Pedal Bike Skoda SUV Grey Driving without Due Care and Attention None Weston Road Evesham Weston Road Evesham Out of Force Area Out of Force Area NFA Out of Force      
23855 op-snap---monthly-publication-september-2025.pdf   74 2025-09 Pedal Bike Peugeot 107 Silver Driving without Due Care and Attention None Wolverhampton Rd , jn with Dimmock Street Wolverhampton Road , jn with Dimmock Street Wolverhampton Wolverhampton Education N/A      
23881 op-snap---monthly-publication-september-2025.pdf   100 2025-09 Pedal Bike Land Rover Evoque White Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
23946 op-snap---monthly-publication-september-2025.pdf   165 2025-09 Pedal Bike Mitsubishi L200 Red Driving without Due Care and Attention None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
23964 op-snap---monthly-publication-september-2025.pdf   183 2025-09 Pedal Bike Mercedes-Benz C220 Grey Driving without Due Care and Attention None Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
23974 op-snap---monthly-publication-september-2025.pdf   193 2025-09 Pedal Bike   M/C Black Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No VRM   52.3868298 -2.0003781
23982 op-snap---monthly-publication-september-2025.pdf   201 2025-09 Pedal Bike Ford Focus Black Driving without Due Care and Attention No vehicle excise licence Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
23998 op-snap---monthly-publication-september-2025.pdf   217 2025-09 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Church Road Edgbaston Church Road Edgbaston Birmingham Birmingham Education N/A   52.46114 -1.9180882
24010 op-snap---monthly-publication-september-2025.pdf   229 2025-09 Pedal Bike BMW 118 Black Driving without Due Care and Attention None Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.546976 -1.8098124
24015 op-snap---monthly-publication-september-2025.pdf   234 2025-09 Pedal Bike BMW 120d White Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall Education N/A   52.6166864 -1.9660822
24020 op-snap---monthly-publication-september-2025.pdf   239 2025-09 Pedal Bike Honda Civic Black Driving without Due Care and Attention None Sampson Road Sampson Road Solihull Solihull NFA No Offence      
24023 op-snap---monthly-publication-september-2025.pdf   242 2025-09 Pedal Bike Ford Focus Red Driving without Due Care and Attention None Tixall Road Shirley Tixall Road Shirley Birmingham Birmingham Education N/A      
24037 op-snap---monthly-publication-september-2025.pdf   256 2025-09 Pedal Bike Hyundai Tucson Blue Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham Education N/A   52.548449 -1.8594603
24042 op-snap---monthly-publication-september-2025.pdf   261 2025-09 Pedal Bike Tesla   Black Driving without Due Care and Attention None Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.546976 -1.8098124
24090 op-snap---monthly-publication-september-2025.pdf   309 2025-09 Pedal Bike Hyundai I20 Grey Driving without Due Care and Attention None Turners Lane Turners Lane Dudley Dudley Education N/A   52.4721372 -2.1243522
24105 op-snap---monthly-publication-september-2025.pdf   324 2025-09 Pedal Bike Renault Traffic Black Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull Education N/A   52.4322443 -1.6746508
24106 op-snap---monthly-publication-september-2025.pdf   325 2025-09 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Gower Street Gower Street Walsall Walsall Education N/A   52.5737189 -2.0065411
24107 op-snap---monthly-publication-september-2025.pdf   326 2025-09 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None B4101 TILE HILL LANE B4101 Tile Hill Lane Coventry Coventry Fixed Penalty N/A      
24108 op-snap---monthly-publication-september-2025.pdf   327 2025-09 Pedal Bike Land Rover Range Rover White Driving without Due Care and Attention None Devon Road Devon Road Sandwell Sandwell Warning Letter N/A   52.4674008 -1.9805667
24114 op-snap---monthly-publication-september-2025.pdf   333 2025-09 Pedal Bike Peugeot Partner Grey Driving without Due Care and Attention None Tipton Road Tipton Road Dudley Dudley Education N/A   52.5198386 -2.0740876
24119 op-snap---monthly-publication-september-2025.pdf   338 2025-09 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Tat Bank Road Tat Bank Road Sandwell Sandwell Education N/A   52.4979925 -2.0082232
24121 op-snap---monthly-publication-september-2025.pdf   340 2025-09 Pedal Bike Seat Leon White Driving without Due Care and Attention None Priory Road Priory Road Birmingham Birmingham Education N/A   52.4132696 -1.8555008
24122 op-snap---monthly-publication-september-2025.pdf   341 2025-09 Pedal Bike Audi A1 Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
24131 op-snap---monthly-publication-september-2025.pdf   350 2025-09 Pedal Bike Isuzu truck Red Driving without Due Care and Attention None B4234 Bishopswood Village, Staffordshire Bishopswood Village, Staffordshire Out of Force Area Out of Force Area NFA Out of Force      
24158 op-snap---monthly-publication-september-2025.pdf   377 2025-09 Pedal Bike   Alexander Dennis Grey Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
24174 op-snap---monthly-publication-september-2025.pdf   393 2025-09 Pedal Bike Audi A5 White Driving without Due Care and Attention None Harbury Lane Harbury Lane Out of Force Area Out of Force Area NFA Out of Force      
24176 op-snap---monthly-publication-september-2025.pdf   395 2025-09 Pedal Bike Volkswagen Tiguan Grey Driving without Due Care and Attention None Stonnal Road Aldridge Stonnal Road Aldridge Walsall Walsall Warning Letter N/A      
24185 op-snap---monthly-publication-september-2025.pdf   404 2025-09 Pedal Bike Mercedes-Benz A-class Grey Driving without Due Care and Attention None Lichfield Road, Aston Lichfield Road, Aston Birmingham Birmingham Fixed Penalty N/A   52.5084175 -1.8613455
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      
24193 op-snap---monthly-publication-september-2025.pdf   412 2025-09 Pedal Bike Mg 4.. Grey Driving without Due Care and Attention None Beake Avenue Beake Avenue Coventry Coventry Warning Letter N/A   52.4388246 -1.5229308
24198 op-snap---monthly-publication-september-2025.pdf   417 2025-09 Pedal Bike BMW 2 series Grey Driving without Due Care and Attention No vehicle excise licence Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Education N/A   52.5940902 -1.843503
24218 op-snap---monthly-publication-september-2025.pdf   437 2025-09 Pedal Bike Peugeot 208 Black Driving without Due Care and Attention None Inchlaggon Road Inchlaggon Road Wolverhampton Wolverhampton Warning Letter N/A      
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
24268 op-snap---monthly-publication-september-2025.pdf   487 2025-09 Pedal Bike Vauxhall Combo Grey Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley Education N/A   52.4628538 -2.1160108
24341 op-snap---monthly-publication-september-2025.pdf   560 2025-09 Pedal Bike Volkswagen Tiguan Grey Driving without Due Care and Attention None Breedon Road Breedon Road Birmingham Birmingham Education N/A   52.4191978 -1.9251219
24357 op-snap---monthly-publication-september-2025.pdf   576 2025-09 Pedal Bike Ford Fiesta Black Driving without Due Care and Attention None Hob Lane Hob Lane Solihull Solihull Education N/A   52.377539 -1.6201491
24374 op-snap---monthly-publication-september-2025.pdf   593 2025-09 Pedal Bike Nissan Note Blue Driving without Due Care and Attention None Albany Road Albany Road Coventry Coventry Education N/A   52.4006218 -1.5284125
24387 op-snap---monthly-publication-september-2025.pdf   606 2025-09 Pedal Bike Mercedes-Benz EQA Blue Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Education N/A   52.4718503 -1.9195423
24392 op-snap---monthly-publication-september-2025.pdf   611 2025-09 Pedal Bike Vauxhall Vivaro Black Driving without Due Care and Attention None Lichfield Road towards Dartmouth Circus Lichfield Road towards Dartmouth Circus Birmingham Birmingham Warning Letter N/A      
24443 op-snap---monthly-publication-september-2025.pdf   662 2025-09 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None George Road George Road Birmingham Birmingham Education N/A   52.5155831 -1.8598862
24457 op-snap---monthly-publication-september-2025.pdf   676 2025-09 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
24472 op-snap---monthly-publication-september-2025.pdf   691 2025-09 Pedal Bike Skoda Fabia Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
24475 op-snap---monthly-publication-september-2025.pdf   694 2025-09 Pedal Bike Mazda 3 Red Driving without Due Care and Attention None The Firs The Firs Coventry Coventry Education N/A   52.3965706 -1.523038
24491 op-snap---monthly-publication-september-2025.pdf   710 2025-09 Pedal Bike Chysler 300C Silver Driving without Due Care and Attention None The Broadway The Broadway Dudley Dudley Education N/A   52.515445 -2.0885791
24493 op-snap---monthly-publication-september-2025.pdf   712 2025-09 Pedal Bike Land Rover Evoque Black Driving without Due Care and Attention None A491 Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
24494 op-snap---monthly-publication-september-2025.pdf   713 2025-09 Pedal Bike Citroen C4 Picasso Red Driving without Due Care and Attention None Potters Lane, Wednesbury Potters Lane, Wednesbury Wolverhampton Wolverhampton Warning Letter N/A      
24495 op-snap---monthly-publication-september-2025.pdf   714 2025-09 Pedal Bike Chysler Voyager Silver Driving without Due Care and Attention No Insurance Great Bridge Road, Bilston Great Bridge Road, Bilston Wolverhampton Wolverhampton Court N/A   52.5602666 -2.0579414
24496 op-snap---monthly-publication-september-2025.pdf   715 2025-09 Pedal Bike Porsche Cayman White Driving without Due Care and Attention None Great Bridge Road, Bilston Great Bridge Road, Bilston Wolverhampton Wolverhampton Education N/A   52.5602666 -2.0579414
24498 op-snap---monthly-publication-september-2025.pdf   717 2025-09 Pedal Bike Ford Mondeo Silver Driving without Due Care and Attention None Umberslade Road, Stirchley Umberslade Road, Stirchley Birmingham Birmingham Warning Letter N/A   52.4304526 -1.9216716
24511 op-snap---monthly-publication-september-2025.pdf   730 2025-09 Pedal Bike BMW M135 Grey Driving without Due Care and Attention None Tanners Lane Coventry Tanners Lane Coventry Coventry Coventry Fixed Penalty N/A   52.4007746 -1.5997847
24512 op-snap---monthly-publication-september-2025.pdf   731 2025-09 Pedal Bike Scania Coach Green Driving without Due Care and Attention None Balsall Street East, Balsall Common Balsall Street East, Balsall Common Coventry Coventry Warning Letter N/A      
24513 op-snap---monthly-publication-september-2025.pdf   732 2025-09 Pedal Bike Seat Leon Grey Driving without Due Care and Attention None Wall Hill Road Wall Hill Road Coventry Coventry Education N/A   52.4459445 -1.5552508
24520 op-snap---monthly-publication-september-2025.pdf   739 2025-09 Pedal Bike Renault Zoe Blue Driving without Due Care and Attention None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
24531 op-snap---monthly-publication-september-2025.pdf   750 2025-09 Pedal Bike Volkswagen   Black Driving without Due Care and Attention None Warstock Lane Warstock Lane Birmingham Birmingham Education N/A   52.4175988 -1.8774655
24554 op-snap---monthly-publication-september-2025.pdf   773 2025-09 Pedal Bike Vauxhall Corsa Silver Driving without Due Care and Attention None Linthouse Lane Linthouse Lane Wolverhampton Wolverhampton Court N/A   52.6118187 -2.0810618
24596 op-snap---monthly-publication-september-2025.pdf   815 2025-09 Pedal Bike BMW 3 Series White Driving without Due Care and Attention None Chester Road North Chester Road North Walsall Walsall Education N/A   52.654063 -1.9460461
24608 op-snap---monthly-publication-september-2025.pdf   827 2025-09 Pedal Bike Audi A5 Red Driving without Due Care and Attention None Newton Road Newton Road Sandwell Sandwell Education N/A   52.5428224 -1.9569444
24609 op-snap---monthly-publication-september-2025.pdf   828 2025-09 Pedal Bike Peugeot Boxer van White Driving without Due Care and Attention None Newton Road Newton Road Sandwell Sandwell Education N/A   52.5428224 -1.9569444
24610 op-snap---monthly-publication-september-2025.pdf   829 2025-09 Pedal Bike Daf lorry White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
24614 op-snap---monthly-publication-september-2025.pdf   833 2025-09 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
24616 op-snap---monthly-publication-september-2025.pdf   835 2025-09 Pedal Bike Audi A4 Black Driving without Due Care and Attention None Slaters Lane Slaters Lane Walsall Walsall NFA No Offence   52.5719978 -2.0041926
24617 op-snap---monthly-publication-september-2025.pdf   836 2025-09 Pedal Bike Nissan Qashqai Silver Driving without Due Care and Attention None B1190 / A46 in Lincolnshire B1190 / A46 in Lincolnshire Out of Force Area Out of Force Area NFA Out of Force      
24619 op-snap---monthly-publication-september-2025.pdf   838 2025-09 Pedal Bike Hyundai IX20 Blue Driving without Due Care and Attention None Wood Green Road, Wednesbury Wood Green Road, Wednesbury Walsall Walsall Education N/A      
24624 op-snap---monthly-publication-september-2025.pdf   843 2025-09 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Slade Road Slade Road Birmingham Birmingham Warning Letter N/A   52.5894461 -1.8082962
24646 op-snap---monthly-publication-september-2025.pdf   865 2025-09 Pedal Bike Mg ZS Black Driving without Due Care and Attention None Walsall Road Walsall Road Sandwell Sandwell Education N/A   52.5439824 -1.9306805
24656 op-snap---monthly-publication-september-2025.pdf   875 2025-09 Pedal Bike Audi A4 Grey Driving without Due Care and Attention None Edgbaston Road at Mary Street Edgbaston Road at Mary Street Birmingham Birmingham Fixed Penalty N/A   52.4540425 -1.8918301
24662 op-snap---monthly-publication-september-2025.pdf   881 2025-09 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Formans Road Formans Road Birmingham Birmingham Warning Letter N/A   52.4482024 -1.8507493
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
24664 op-snap---monthly-publication-september-2025.pdf   883 2025-09 Pedal Bike Mini Cooper Black Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham NFA No Independent Evidence Available   52.4422505 -1.8539684
24673 op-snap---monthly-publication-september-2025.pdf   892 2025-09 Pedal Bike Ford Fiesat White Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Education N/A   52.5242452 -1.8572541
24686 op-snap---monthly-publication-september-2025.pdf   905 2025-09 Pedal Bike Audi A1 Green Driving without Due Care and Attention None Marshall Lake Road Marshall Lake Road Solihull Solihull Warning Letter N/A   52.3975426 -1.818252
24695 op-snap---monthly-publication-september-2025.pdf   914 2025-09 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bradley Lane, Bradley, Bilston Bradley Lane, Bradley, Bilston Wolverhampton Wolverhampton Court N/A   52.5559816 -2.0576788
24748 op-snap---monthly-publication-september-2025.pdf   967 2025-09 Pedal Bike BMW X4 Grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate Springfield Road Moseley Springfield Road Moseley Birmingham Birmingham Education N/A      
24763 op-snap---monthly-publication-september-2025.pdf   982 2025-09 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Midelsohn Way, Selly Oak Midelsohn Way, Selly Oak Birmingham Birmingham Education N/A      
24768 op-snap---monthly-publication-september-2025.pdf   987 2025-09 Pedal Bike Volkswagen Tiguan Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Birmingham Birmingham Education N/A   52.4223176 -1.8253145
24775 op-snap---monthly-publication-september-2025.pdf   994 2025-09 Pedal Bike BMW IX3 Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
24780 op-snap---monthly-publication-september-2025.pdf   999 2025-09 Pedal Bike Volkswagen Polo   Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4299657 -1.9599121
24788 op-snap---monthly-publication-september-2025.pdf   1007 2025-09 Pedal Bike Honda Civic Silver Driving without Due Care and Attention None Mere Green Road Mere Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.5874888 -1.8297106
24790 op-snap---monthly-publication-september-2025.pdf   1009 2025-09 Pedal Bike   Bova Futura Blue Driving without Due Care and Attention None Rugby Road Rugby Road Out of Force Area Out of Force Area NFA Out of Force   52.4648068 -2.1642076
24792 op-snap---monthly-publication-september-2025.pdf   1011 2025-09 Pedal Bike Ford Puma Black Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry NFA No Independent Evidence Available   52.4257402 -1.5185037
24793 op-snap---monthly-publication-september-2025.pdf   1012 2025-09 Pedal Bike BMW 3 Silver Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry NFA No Independent Evidence Available   52.4257402 -1.5185037
24809 op-snap---monthly-publication-september-2025.pdf   1028 2025-09 Pedal Bike Vauxhall Corsa Silver Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham Warning Letter N/A   52.4436471 -1.9604594
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
24837 op-snap---monthly-publication-september-2025.pdf   1056 2025-09 Pedal Bike Dacia Duster Black Driving without Due Care and Attention None Barton Lane towards Apeton, Staffs Barton Lane towards Apeton, Staffs Out of Force Area Out of Force Area NFA Out of Force      
24861 op-snap---monthly-publication-september-2025.pdf   1080 2025-09 Pedal Bike Ford Ka White Driving without Due Care and Attention None Bridgewater Road Stratford Bridgewater Road Stratford Out of Force Area Out of Force Area NFA Out of Force      
24881 op-snap---monthly-publication-september-2025.pdf   1100 2025-09 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Beechwood Ave Beechwood Ave Coventry Coventry Education N/A   52.3963882 -1.5379305
24934 op-snap---monthly-publication-september-2025.pdf   1153 2025-09 Pedal Bike Hyundai Sportage Silver Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Education N/A   52.5368764 -1.8976461
24935 op-snap---monthly-publication-september-2025.pdf   1154 2025-09 Pedal Bike Ford C max Brown Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
24944 op-snap---monthly-publication-september-2025.pdf   1163 2025-09 Pedal Bike Mercedes-Benz E220 Grey Driving without Due Care and Attention None High Street High Street Sandwell Sandwell NFA No Offence   52.5128738 -1.9842054
24947 op-snap---monthly-publication-september-2025.pdf   1166 2025-09 Pedal Bike BMW 218I White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
24952 op-snap---monthly-publication-september-2025.pdf   1171 2025-09 Pedal Bike Skoda Scala Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
25484 op-snap---monthly-publication-september-2025.pdf   1703 2025-09 Pedal Bike Volkswagen polo White Driving without Due Care and Attention None alcester road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749

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