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

109 rows where month = "2025-03", offence = "Driving without Reasonable Consideration" and reporter_transport_mode = "Car" 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

  • Car · 109 ✖

offence 1

  • Driving without Reasonable Consideration · 109 ✖

month 1

  • 2025-03 · 109 ✖
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
16307 op-snap---monthly-publication-march-2025.pdf   64 2025-03 Car Volkswagen Golf White Driving without Reasonable Consideration None M42 Junction 2 M42 Junction 2 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4945433 -2.0190848
16483 op-snap---monthly-publication-march-2025.pdf   240 2025-03 Car Audi Q7 Blue Driving without Reasonable Consideration None School Road, Yardley Wood School Road, Yardley Wood Birmingham Birmingham Education N/A Yes - Via Email 52.4135867 -1.8703299
16484 op-snap---monthly-publication-march-2025.pdf   241 2025-03 Car Volkswagen Passat Grey Driving without Reasonable Consideration None Key Way Key Way Wolverhampton Wolverhampton Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
16485 op-snap---monthly-publication-march-2025.pdf   242 2025-03 Car Ford Focus Red Driving without Reasonable Consideration None Inkerman Street Inkerman Street Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.5898145 -2.1098908
16491 op-snap---monthly-publication-march-2025.pdf   248 2025-03 Car Vauxhall Insignia Silver Driving without Reasonable Consideration None Featherstone Road / Alcester Road Featherstone Road / Alcester Road Birmingham Birmingham Education N/A Yes - Via Email 52.4261289 -1.8929741
16492 op-snap---monthly-publication-march-2025.pdf   249 2025-03 Car Fiat 500 Grey Driving without Reasonable Consideration None Featherstone Road / Alcester Road Featherstone Road / Alcester Road Birmingham Birmingham Education N/A Yes - Via Email 52.4261289 -1.8929741
16509 op-snap---monthly-publication-march-2025.pdf   266 2025-03 Car Vauxhall Insignia Grey Driving without Reasonable Consideration None North Island North Island Solihull Solihull Warning Letter N/A Yes - Via Email    
16534 op-snap---monthly-publication-march-2025.pdf   291 2025-03 Car Audi TT Black Driving without Reasonable Consideration None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A Yes - Via Email 52.4804926 -1.8563658
16568 op-snap---monthly-publication-march-2025.pdf   325 2025-03 Car Hyundai i20 Blue Driving without Reasonable Consideration None Gillott Road Gillott Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4791408 -1.9467501
16640 op-snap---monthly-publication-march-2025.pdf   397 2025-03 Car Seat Ateca White Driving without Reasonable Consideration None Watling Street, Atherstone Watling Street, Atherstone Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16692 op-snap---monthly-publication-march-2025.pdf   449 2025-03 Car Volkswagen T-Roc Black Driving without Reasonable Consideration None Trafalgar Road Trafalgar Road Birmingham Birmingham Education N/A Yes - Via Email 52.5205313 -1.8399396
16700 op-snap---monthly-publication-march-2025.pdf   457 2025-03 Car BMW 220D Black Driving without Reasonable Consideration None Wellhead Lane Wellhead Lane Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.5162215 -1.896087
16702 op-snap---monthly-publication-march-2025.pdf   459 2025-03 Car Toyota   Silver Driving without Reasonable Consideration None A461 Birmingham Road Birmingham Road Dudley Dudley Education N/A Yes - Via Email 52.5131355 -2.0651615
16768 op-snap---monthly-publication-march-2025.pdf   525 2025-03 Car Peugeot 308 Silver Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4103191 -1.8670224
16776 op-snap---monthly-publication-march-2025.pdf   533 2025-03 Car Mercedes-Benz E200 Grey Driving without Reasonable Consideration None Queslett Road Queslett Road Birmingham Birmingham Education N/A Yes - Via Email 52.5458699 -1.9304484
16779 op-snap---monthly-publication-march-2025.pdf   536 2025-03 Car Ford Transit White Driving without Reasonable Consideration None Birchley Island Birchley Island Sandwell Sandwell Education N/A Yes - Via Email 52.4926604 -2.0216743
16792 op-snap---monthly-publication-march-2025.pdf   549 2025-03 Car Nissan Qashqai Grey Driving without Reasonable Consideration None Third Avenue, Pensnett Trading Estate Third Avenue, Pensnett Trading Estate Dudley Dudley NFA No Independent Evidence Available Yes - Via Email 52.5046812 -2.1550209
16804 op-snap---monthly-publication-march-2025.pdf   561 2025-03 Car Mercedes-Benz A CLASS Grey Driving without Reasonable Consideration None BELGRAVE INTERCHANGE Belgrave Interchange Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.466118 -1.8982999
16805 op-snap---monthly-publication-march-2025.pdf   562 2025-03 Car Peugeot 208 Red Driving without Reasonable Consideration None CAMP HILL Camp Hill Birmingham Birmingham Education N/A Yes - Via Email 52.4702894 -1.8786299
16875 op-snap---monthly-publication-march-2025.pdf   632 2025-03 Car Citroen Belingo Silver Driving without Reasonable Consideration None Dumblederry Lane Dumblederry Lane Walsall Walsall Warning Letter N/A Yes - Via Email 52.6069109 -1.9342315
16876 op-snap---monthly-publication-march-2025.pdf   633 2025-03 Car Seat Leon Black Driving without Reasonable Consideration None Bridle Lane Bridle Lane Walsall Walsall Warning Letter N/A Yes - Via Email 52.5742643 -1.8934596
16904 op-snap---monthly-publication-march-2025.pdf   661 2025-03 Car Toyota   Purple Driving without Reasonable Consideration None Long Acre Long Acre Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5051253 -1.8646383
16906 op-snap---monthly-publication-march-2025.pdf   663 2025-03 Car Ford Fiesta Black Driving without Reasonable Consideration None Thimble Mill Lane Thimble Mill Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4965745 -1.8714709
16961 op-snap---monthly-publication-march-2025.pdf   718 2025-03 Car BMW 320D Silver Driving without Reasonable Consideration None Queensland Avenue Queensland Avenue Coventry Coventry Warning Letter N/A Yes - Via Email 52.406658 -1.5363495
16976 op-snap---monthly-publication-march-2025.pdf   733 2025-03 Car Mazda 3 White Driving without Reasonable Consideration None Angesley Avenue Angesley Avenue Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17093 op-snap---monthly-publication-march-2025.pdf   850 2025-03 Car Ford C Max Blue Driving without Reasonable Consideration None Campden Road (Stratford) Campden Road (Stratford) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17120 op-snap---monthly-publication-march-2025.pdf   877 2025-03 Car Ford Transit Grey Driving without Reasonable Consideration None Green Meadow Rd Green Meadow Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.430056 -1.9692611
17132 op-snap---monthly-publication-march-2025.pdf   889 2025-03 Car Kia Sportage Grey Driving without Reasonable Consideration None Chester Road Chester Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.5021946 -1.7719526
17178 op-snap---monthly-publication-march-2025.pdf   935 2025-03 Car BMW X3 Grey Driving without Reasonable Consideration Use vehicle on a road without valid test certificate Priory Road Priory Road Birmingham Birmingham Court N/A Yes - Via Email 52.4132696 -1.8555008
17218 op-snap---monthly-publication-march-2025.pdf   975 2025-03 Car Renault Clio White Driving without Reasonable Consideration None Daventry Road Daventry Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.3930931 -1.4976428
17239 op-snap---monthly-publication-march-2025.pdf   996 2025-03 Car Seat Ateca White Driving without Reasonable Consideration None Woodburn Road Woodburn Road Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17324 op-snap---monthly-publication-march-2025.pdf   1081 2025-03 Car Volkswagen Polo White Driving without Reasonable Consideration None A45 A45 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17338 op-snap---monthly-publication-march-2025.pdf   1095 2025-03 Car Ford Focus Silver Driving without Reasonable Consideration None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5038363 -1.8432663
17391 op-snap---monthly-publication-march-2025.pdf   1148 2025-03 Car Mini Cooper Grey Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
17392 op-snap---monthly-publication-march-2025.pdf   1149 2025-03 Car Ford Kuga Blue Driving without Reasonable Consideration None Monkspath Hall Road Monkspath Hall Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3900358 -1.8026595
17408 op-snap---monthly-publication-march-2025.pdf   1165 2025-03 Car Citroen C3 Blue Driving without Reasonable Consideration None Islington Middleway Islington Middleway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4713211 -1.91264
17471 op-snap---monthly-publication-march-2025.pdf   1228 2025-03 Car Ford Transit Grey Driving without Reasonable Consideration None London Road London Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.3916468 -1.4925995
17481 op-snap---monthly-publication-march-2025.pdf   1238 2025-03 Car Ford Transit White Driving without Reasonable Consideration None Lilly Lane A441 Lilly Lane A441 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17544 op-snap---monthly-publication-march-2025.pdf   1301 2025-03 Car Nissan Note Black Driving without Reasonable Consideration None Kenilworth Road Kenilworth Road Solihull Solihull Education N/A Yes - Via Email 52.4322443 -1.6746508
17551 op-snap---monthly-publication-march-2025.pdf   1308 2025-03 Car Volkswagen Golf Red Driving without Reasonable Consideration None Barker Butts Lane Barker Butts Lane Coventry Coventry Education N/A Yes - Via Email    
17563 op-snap---monthly-publication-march-2025.pdf   1320 2025-03 Car Audi A3 Grey Driving without Reasonable Consideration None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A Yes - Via Email 52.4728608 -1.8754722
17566 op-snap---monthly-publication-march-2025.pdf   1323 2025-03 Car BMW X5 White Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry NFA No Independent Evidence Available Yes - Via Email 52.4274335 -1.5002381
17598 op-snap---monthly-publication-march-2025.pdf   1355 2025-03 Car Ford kuga silver Driving without Reasonable Consideration None Shenley Lane Shenley Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.430111 -1.9753703
17614 op-snap---monthly-publication-march-2025.pdf   1371 2025-03 Car BMW X5 Grey Driving without Reasonable Consideration None M6 Junction 7 Roundabout M6 Junction 7 Roundabout Birmingham Birmingham NFA No Offence Yes - Via Email 52.676119 -2.0858425
17641 op-snap---monthly-publication-march-2025.pdf   1398 2025-03 Car BMW 3 series Grey Driving without Reasonable Consideration None M6 Motorway, Northbound, between 6 and 7 M6 Motorway, Northbound, between 6 and 7 Birmingham Birmingham Education N/A Yes - Via Email    
17645 op-snap---monthly-publication-march-2025.pdf   1402 2025-03 Car Volkswagen Passat Grey Driving without Reasonable Consideration None Lichfield Road Lichfield Road Walsall Walsall Education N/A Yes - Via Email 52.6095168 -2.0493009
17672 op-snap---monthly-publication-march-2025.pdf   1429 2025-03 Car Mercedes-Benz GLB220 White Driving without Reasonable Consideration None Windward Way Windward Way Solihull Solihull NFA No Offence Yes - Via Email 52.5023715 -1.7555515
17706 op-snap---monthly-publication-march-2025.pdf   1463 2025-03 Car Ford Fiesta Black Driving without Reasonable Consideration None Heartlands Parkway Heartlands Parkway Birmingham Birmingham NFA Not in Public Interest Yes - Via Email 52.5038363 -1.8432663
17716 op-snap---monthly-publication-march-2025.pdf   1473 2025-03 Car Hyundai i20 Red Driving without Reasonable Consideration None NEWPORT ROAD Newport Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.5027779 -1.7982159
17769 op-snap---monthly-publication-march-2025.pdf   1526 2025-03 Car Audi A3 Grey Driving without Reasonable Consideration None Tanworth Lane B4102 Tanworth Lane B4102 Solihull Solihull Education N/A Yes - Via Email 52.4014694 -1.8220541
17771 op-snap---monthly-publication-march-2025.pdf   1528 2025-03 Car Ford Kuga White Driving without Reasonable Consideration No vehicle excise licence Foxoak Street Foxoak Street Dudley Dudley Education N/A Yes - Via Email    
17821 op-snap---monthly-publication-march-2025.pdf   1578 2025-03 Car Toyota Prius White Driving without Reasonable Consideration None M42 Jn8-8a M42 Jn8-8a Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17832 op-snap---monthly-publication-march-2025.pdf   1589 2025-03 Car BMW 218 Silver Driving without Reasonable Consideration None Wrentham St Wrentham Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4708757 -1.8966158
17907 op-snap---monthly-publication-march-2025.pdf   1664 2025-03 Car Vauxhall Vivaro White Driving without Reasonable Consideration None Barn Lane Barn Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4307492 -1.8828708
17909 op-snap---monthly-publication-march-2025.pdf   1666 2025-03 Car Ford transit Grey Driving without Reasonable Consideration None Halesown Road Halesown Road Dudley Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
17920 op-snap---monthly-publication-march-2025.pdf   1677 2025-03 Car Renault Scenic Blue Driving without Reasonable Consideration None Edinburgh Road Edinburgh Road Walsall Walsall Warning Letter N/A Yes - Via Email 52.5761712 -1.9594293
17922 op-snap---monthly-publication-march-2025.pdf   1679 2025-03 Car Ford Transit Black Driving without Reasonable Consideration None Stafford Street Stafford Street Walsall Walsall Warning Letter N/A Yes - Via Email 52.5899955 -1.9853333
17929 op-snap---monthly-publication-march-2025.pdf   1686 2025-03 Car Mercedes-Benz GLA250 Black Driving without Reasonable Consideration None Lee Bank Middleway Lee Bank Middleway Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4677721 -1.9037358
17932 op-snap---monthly-publication-march-2025.pdf   1689 2025-03 Car Mini Cooper Black Driving without Reasonable Consideration None Warwick Road Warwick Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4555288 -1.8613929
17934 op-snap---monthly-publication-march-2025.pdf   1691 2025-03 Car BMW 2 Series Blue Driving without Reasonable Consideration None Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.3837388 -1.5529669
17978 op-snap---monthly-publication-march-2025.pdf   1735 2025-03 Car Volkswagen Tiguan Grey Driving without Reasonable Consideration None Mackadown Lane Mackadown Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4708415 -1.7675939
17991 op-snap---monthly-publication-march-2025.pdf   1748 2025-03 Car Volkswagen Toureg Grey Driving without Reasonable Consideration None M5 Junction 1 - 2 M5 Junction 1 - 2 Sandwell Sandwell Warning Letter N/A Yes - Via Email    
18028 op-snap---monthly-publication-march-2025.pdf   1785 2025-03 Car Mercedes-Benz A200 Black Driving without Reasonable Consideration None Coventry Road at Kings Road Coventry Road at Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
18029 op-snap---monthly-publication-march-2025.pdf   1786 2025-03 Car Mercedes-Benz B180 Grey Driving without Reasonable Consideration None Coventry Road at Kings Road Coventry Road at Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
18030 op-snap---monthly-publication-march-2025.pdf   1787 2025-03 Car Nissan Micra Black Driving without Reasonable Consideration None Coventry Road at Kings Road Coventry Road at Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
18032 op-snap---monthly-publication-march-2025.pdf   1789 2025-03 Car Jaguar iPace Black Driving without Reasonable Consideration None M42 (N/B) Jn9, Warwickshire M42 (Northbound) Jn9, Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18049 op-snap---monthly-publication-march-2025.pdf   1806 2025-03 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
18153 op-snap---monthly-publication-march-2025.pdf   1910 2025-03 Car Ford Focus Red Driving without Reasonable Consideration None The Mill Walk The Mill Walk Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4021031 -1.9732141
18161 op-snap---monthly-publication-march-2025.pdf   1918 2025-03 Car Seat Ibiza Black Driving without Reasonable Consideration None M42 M42 Birmingham Birmingham Education N/A Yes - Via Email    
18166 op-snap---monthly-publication-march-2025.pdf   1923 2025-03 Car Vauxhall Astra Black Driving without Reasonable Consideration None Butts Road Butts Road Coventry Coventry Education N/A Yes - Via Email 52.4073149 -1.5250454
18183 op-snap---monthly-publication-march-2025.pdf   1940 2025-03 Car Nissan QASHQUI Grey Driving without Reasonable Consideration None B4380 SHREWSBURY B4380 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18185 op-snap---monthly-publication-march-2025.pdf   1942 2025-03 Car Ford KUGA Grey Driving without Reasonable Consideration None B4380 SHREWSBURY B4380 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18206 op-snap---monthly-publication-march-2025.pdf   1963 2025-03 Car Porsche 911 Black Driving without Reasonable Consideration None Questlet Road Questlet Road Sandwell Sandwell NFA No VRM Yes - Via Email    
18222 op-snap---monthly-publication-march-2025.pdf   1979 2025-03 Car Dacia   Grey Driving without Reasonable Consideration None Tolladine Road Worcester Tolladine Road Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18225 op-snap---monthly-publication-march-2025.pdf   1982 2025-03 Car Daf HGV White Driving without Reasonable Consideration None A42 Warwickshire Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4318492 -1.7319529
18234 op-snap---monthly-publication-march-2025.pdf   1991 2025-03 Car Lexus RX450 Silver Driving without Reasonable Consideration None Hinkley Road Hinkley Road Coventry Coventry Warning Letter N/A Yes - Via Email    
18240 op-snap---monthly-publication-march-2025.pdf   1997 2025-03 Car Daf HGV Red Driving without Reasonable Consideration None Lichfield Road Lichfield Road Walsall Walsall Warning Letter N/A Yes - Via Email 52.6095168 -2.0493009
18255 op-snap---monthly-publication-march-2025.pdf   2012 2025-03 Car Ford Focus Grey Driving without Reasonable Consideration None Broadway North Broadway North Walsall Walsall NFA No VRM Yes - Via Email 52.5886007 -1.9741222
18258 op-snap---monthly-publication-march-2025.pdf   2015 2025-03 Car Nissan Leaf Silver Driving without Reasonable Consideration None Moseley Road Moseley Road Birmingham Birmingham Education N/A Yes - Via Email 52.4679402 -1.881408
18259 op-snap---monthly-publication-march-2025.pdf   2016 2025-03 Car Mitsubishi Shogun White Driving without Reasonable Consideration None Moseley Road Moseley Road Birmingham Birmingham Education N/A Yes - Via Email 52.4679402 -1.881408
18261 op-snap---monthly-publication-march-2025.pdf   2018 2025-03 Car Volkswagen Polo Grey Driving without Reasonable Consideration None Moseley Road Moseley Road Birmingham Birmingham Education N/A Yes - Via Email 52.4679402 -1.881408
18284 op-snap---monthly-publication-march-2025.pdf   2041 2025-03 Car Mercedes-Benz C250 Black Driving without Reasonable Consideration None Dog Kennel Lane Dog Kennel Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.3916957 -1.8169275
18287 op-snap---monthly-publication-march-2025.pdf   2044 2025-03 Car   Scania Truck Blue Driving without Reasonable Consideration None Stourbridge Road Stourbridge Road Dudley Dudley NFA No Independent Evidence Available Yes - Via Email 52.5002997 -2.1081386
18321 op-snap---monthly-publication-march-2025.pdf   2078 2025-03 Car Ford Focus Black Driving without Reasonable Consideration None A444, jn with A46, Coventry A444, jn with A46, Coventry Coventry Coventry Warning Letter N/A Yes - Via Email    
18323 op-snap---monthly-publication-march-2025.pdf   2080 2025-03 Car Toyota Corolla Black Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18325 op-snap---monthly-publication-march-2025.pdf   2082 2025-03 Car Mercedes-Benz C class White Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18326 op-snap---monthly-publication-march-2025.pdf   2083 2025-03 Car Audi Q3 Black Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18327 op-snap---monthly-publication-march-2025.pdf   2084 2025-03 Car Chevrolet Jeep Compass Grey Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18328 op-snap---monthly-publication-march-2025.pdf   2085 2025-03 Car Ford Fiesta Grey Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18329 op-snap---monthly-publication-march-2025.pdf   2086 2025-03 Car Volkswagen Golf Black Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18331 op-snap---monthly-publication-march-2025.pdf   2088 2025-03 Car Volkswagen Tiguan White Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18332 op-snap---monthly-publication-march-2025.pdf   2089 2025-03 Car Toyota Prius Grey Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
18334 op-snap---monthly-publication-march-2025.pdf   2091 2025-03 Car Land Rover Sport Black Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4134557 -1.4442138
18363 op-snap---monthly-publication-march-2025.pdf   2120 2025-03 Car Peugeot Partner van White Driving without Reasonable Consideration No Insurance Holloway, Northfield Holloway, Northfield Birmingham Birmingham Court N/A Yes - Via Email 52.4187366 -1.9720072
18367 op-snap---monthly-publication-march-2025.pdf   2124 2025-03 Car Peugeot Partner van White Driving without Reasonable Consideration No Insurance Holloway, Northfield Holloway, Northfield Birmingham Birmingham Court N/A Yes - Via Email 52.4187366 -1.9720072
18375 op-snap---monthly-publication-march-2025.pdf   2132 2025-03 Car Vauxhall Astra Black Driving without Reasonable Consideration None Lode Lane Lode Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4149064 -1.7832364
18381 op-snap---monthly-publication-march-2025.pdf   2138 2025-03 Car Skoda Octavia Red Driving without Reasonable Consideration None Kenpas Highway Kenpas Highway Coventry Coventry NFA No Independent Evidence Available Yes - Via Email 52.3833661 -1.5265665
18428 op-snap---monthly-publication-march-2025.pdf   2185 2025-03 Car Honda Cr - V Black Driving without Reasonable Consideration None New John Street West New John Street West Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4944784 -1.9122329
18467 op-snap---monthly-publication-march-2025.pdf   2224 2025-03 Car Audi A7 Grey Driving without Reasonable Consideration None M6 J2 M6 J2 Coventry Coventry NFA No Offence Yes - Via Email 52.6760749 -2.0862582
18468 op-snap---monthly-publication-march-2025.pdf   2225 2025-03 Car Ford mondeo White Driving without Reasonable Consideration None M6 J2 M6 J2 Coventry Coventry NFA No Offence Yes - Via Email 52.6760749 -2.0862582

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