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

156 rows where council_area = "Birmingham", month = "2025-03" and offence = "Driving without Reasonable Consideration" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

disposal 5

reporter_transport_mode 4

offence 1

  • Driving without Reasonable Consideration · 156 ✖

month 1

  • 2025-03 · 156 ✖

council_area 1

  • Birmingham · 156 ✖
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
16244 op-snap---monthly-publication-march-2025.pdf   1 2025-03 Pedal Bike Vauxhall Zafira Blue Driving without Reasonable Consideration No vehicle excise licence Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
16261 op-snap---monthly-publication-march-2025.pdf   18 2025-03 Pedal Bike Toyota   White Driving without Reasonable Consideration None Cotterills Lane Cotterills Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4884297 -1.817811
16279 op-snap---monthly-publication-march-2025.pdf   36 2025-03 Pedal Bike BMW 118 White Driving without Reasonable Consideration None Cliff Rock Road Cliff Rock Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.3937169 -2.0011078
16321 op-snap---monthly-publication-march-2025.pdf   78 2025-03 Pedal Bike Peugeot 308 Black Driving without Reasonable Consideration None Masshouse Lane Masshouse Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4072996 -1.9273914
16341 op-snap---monthly-publication-march-2025.pdf   98 2025-03 Pedal Bike Dacia Sandero White Driving without Reasonable Consideration None Digbeth Coach Station, B4100 Digbeth Coach Station, B4100 Birmingham Birmingham Education N/A Yes - Via Email 52.4753014 -1.8884997
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
16401 op-snap---monthly-publication-march-2025.pdf   158 2025-03 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4941712 -1.8795158
16402 op-snap---monthly-publication-march-2025.pdf   159 2025-03 Pedal Bike Hyundai I30. Red Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
16404 op-snap---monthly-publication-march-2025.pdf   161 2025-03 Pedal Bike Ford Ranger White Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
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    
16419 op-snap---monthly-publication-march-2025.pdf   176 2025-03 Pedal Bike Honda Crv Grey Driving without Reasonable Consideration None Highfield Road Highfield Road Birmingham Birmingham Education N/A Yes - Via Email 52.4216321 -1.855984
16421 op-snap---monthly-publication-march-2025.pdf   178 2025-03 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Millisoms Road Millisoms Road Birmingham Birmingham Education 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
16447 op-snap---monthly-publication-march-2025.pdf   204 2025-03 Pedal Bike Nissan Cube Black Driving without Reasonable Consideration None Dads Lane Dads Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4375913 -1.9068522
16458 op-snap---monthly-publication-march-2025.pdf   215 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4308271 -1.920078
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
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
16514 op-snap---monthly-publication-march-2025.pdf   271 2025-03 Pedal Bike Kia Rio White Driving without Reasonable Consideration None Queensbridge Road Queensbridge Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4415108 -1.8971434
16519 op-snap---monthly-publication-march-2025.pdf   276 2025-03 Pedal Bike Toyota Prius Silver Driving without Reasonable Consideration None Smallbrook Queensway Smallbrook Queensway Birmingham Birmingham Education N/A Yes - Via Email 52.4772584 -1.8965734
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
16566 op-snap---monthly-publication-march-2025.pdf   323 2025-03 Pedal Bike Toyota Prius White Driving without Reasonable Consideration None Northfield Road Northfield Road Birmingham Birmingham Education N/A Yes - Via Email 52.4167654 -1.9411244
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
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
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
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
16740 op-snap---monthly-publication-march-2025.pdf   497 2025-03 Pedal Bike Toyota Corolla White Driving without Reasonable Consideration None Priory Road Priory Road Birmingham Birmingham Education N/A Yes - Via Email 52.4132696 -1.8555008
16742 op-snap---monthly-publication-march-2025.pdf   499 2025-03 Pedal Bike Citroen C4 Silver Driving without Reasonable Consideration None Park Street Birmingham Park Street Birmingham Birmingham Birmingham Education N/A Yes - Via Email 52.4720381 -1.9046266
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
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
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
16783 op-snap---monthly-publication-march-2025.pdf   540 2025-03 Pedal Bike Toyota Auris Blue Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4119174 -1.9735247
16787 op-snap---monthly-publication-march-2025.pdf   544 2025-03 Pedal Bike Ford Focus Red Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4119174 -1.9735247
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
16807 op-snap---monthly-publication-march-2025.pdf   564 2025-03 Pedal Bike Volkswagen TRANSPORTER Black Driving without Reasonable Consideration Use vehicle on a road without valid test certificate WYCHALL ROAD Wychall Road Birmingham Birmingham Education N/A Yes - Via Email 52.4089092 -1.9498562
16829 op-snap---monthly-publication-march-2025.pdf   586 2025-03 Pedal Bike Ford Transit Blue Driving without Reasonable Consideration None Gilhurst Road Gilhurst Road Birmingham Birmingham Education N/A Yes - Via Email    
16882 op-snap---monthly-publication-march-2025.pdf   639 2025-03 Pedal Bike Vauxhall Insignia Blue Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A Yes - Via Email 52.5292752 -1.7618805
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
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
16911 op-snap---monthly-publication-march-2025.pdf   668 2025-03 Pedestrian Vauxhall Astra Grey Driving without Reasonable Consideration None Long Acre Road Long Acre Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
16912 op-snap---monthly-publication-march-2025.pdf   669 2025-03 Pedestrian Lamborghini 4X4 Red Driving without Reasonable Consideration None Newhall Street Newhall Street Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4830482 -1.905069
16920 op-snap---monthly-publication-march-2025.pdf   677 2025-03 Pedal Bike Ford Puma Black Driving without Reasonable Consideration None A45 Small Heath Highway Small Heath Highway Birmingham Birmingham Education N/A Yes - Via Email 52.4709298 -1.8722585
16936 op-snap---monthly-publication-march-2025.pdf   693 2025-03 Pedal Bike Vauxhall Astra Silver Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Court N/A Yes - Via Email 52.4308271 -1.920078
16957 op-snap---monthly-publication-march-2025.pdf   714 2025-03 Pedal Bike Ford C Maxx Black Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
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    
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
17028 op-snap---monthly-publication-march-2025.pdf   785 2025-03 Pedal Bike Mercedes-Benz E220... Black Driving without Reasonable Consideration None Hollie Lucas Road Hollie Lucas Road Birmingham Birmingham Education N/A Yes - Via Email 52.4263502 -1.8840926
17029 op-snap---monthly-publication-march-2025.pdf   786 2025-03 Pedal Bike Porsche Macan Black Driving without Reasonable Consideration None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A Yes - Via Email 52.4415108 -1.8971434
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
17107 op-snap---monthly-publication-march-2025.pdf   864 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Langleys Road Langleys Road Birmingham Birmingham Education N/A Yes - Via Email 52.4358093 -1.9411176
17108 op-snap---monthly-publication-march-2025.pdf   865 2025-03 Pedal Bike Citroen Grand Picasso Blue Driving without Reasonable Consideration None Oak Tree Lane Oak Tree Lane Birmingham Birmingham Education N/A Yes - Via Email 52.431258 -1.9394381
17110 op-snap---monthly-publication-march-2025.pdf   867 2025-03 Pedal Bike Hyundai Tucson Red Driving without Reasonable Consideration None A38 Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
17118 op-snap---monthly-publication-march-2025.pdf   875 2025-03 Pedal Bike Ford Connect White Driving without Reasonable Consideration None dads lane Dads Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4375913 -1.9068522
17119 op-snap---monthly-publication-march-2025.pdf   876 2025-03 Pedal Bike Skoda Superb Silver Driving without Reasonable Consideration None Balsall Street Balsall Street Birmingham Birmingham Education N/A Yes - Via Email 52.4579985 -1.8916996
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
17149 op-snap---monthly-publication-march-2025.pdf   906 2025-03 Pedal Bike Vauxhall Corsa Grey Driving without Reasonable Consideration None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Education N/A Yes - Via Email 52.4397168 -1.9260414
17150 op-snap---monthly-publication-march-2025.pdf   907 2025-03 Pedal Bike Audi A3 Grey Driving without Reasonable Consideration None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Education N/A Yes - Via Email 52.4397168 -1.9260414
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
17212 op-snap---monthly-publication-march-2025.pdf   969 2025-03 Pedal Bike Ford Focus Blue Driving without Reasonable Consideration None A441 Pershore Road South Pershore Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4150779 -1.930901
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    
17290 op-snap---monthly-publication-march-2025.pdf   1047 2025-03 Pedal Bike Peugeot 5008 Grey Driving without Reasonable Consideration None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A Yes - Via Email 52.4415108 -1.8971434
17295 op-snap---monthly-publication-march-2025.pdf   1052 2025-03 Pedal Bike Hyundai TUCSON Brown Driving without Reasonable Consideration None MERE GREEN ROAD Mere Green Road Birmingham Birmingham Education N/A Yes - Via Email 52.5874888 -1.8297106
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
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
17360 op-snap---monthly-publication-march-2025.pdf   1117 2025-03 Pedal Bike Land Rover Defender Grey Driving without Reasonable Consideration None Pershore Rd Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
17361 op-snap---monthly-publication-march-2025.pdf   1118 2025-03 Pedal Bike Fiat 124 spider Blue Driving without Reasonable Consideration None Pershore Rd Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
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
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
17409 op-snap---monthly-publication-march-2025.pdf   1166 2025-03 Pedal Bike Toyota   Black Driving without Reasonable Consideration None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A Yes - Via Email 52.4390303 -1.9512931
17479 op-snap---monthly-publication-march-2025.pdf   1236 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Quinton Road Quinton Road Birmingham Birmingham Education N/A Yes - Via Email 52.447826 -1.9574468
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    
17506 op-snap---monthly-publication-march-2025.pdf   1263 2025-03 Pedal Bike Mazda MPV Brown Driving without Reasonable Consideration None Edward Road Edward Road Birmingham Birmingham Education N/A Yes - Via Email 52.4580901 -1.894458
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
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
17588 op-snap---monthly-publication-march-2025.pdf   1345 2025-03 Lorry Renault Trucks White Driving without Reasonable Consideration None M6 Junction 6-7 Southbound M6 Junction 6-7 Southbound Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.676119 -2.0858425
17597 op-snap---monthly-publication-march-2025.pdf   1354 2025-03 Pedal Bike Ford FOCUS Silver Driving without Reasonable Consideration None ROCKY LANE Rocky Lane Birmingham Birmingham Education N/A Yes - Via Email 52.5285859 -1.9100513
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
17599 op-snap---monthly-publication-march-2025.pdf   1356 2025-03 Pedal Bike Toyota Hilux Silver Driving without Reasonable Consideration None Leach Green Lane Leach Green Lane Birmingham Birmingham Education N/A Yes - Via Email 52.392246 -2.0101736
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
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
17634 op-snap---monthly-publication-march-2025.pdf   1391 2025-03 Pedal Bike Volvo XC60 White Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Court N/A Yes - Via Email 52.4470686 -1.8880749
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    
17671 op-snap---monthly-publication-march-2025.pdf   1428 2025-03 Pedal Bike Hyundai IX20 Silver Driving without Reasonable Consideration None Tennal Road Tennal Road Birmingham Birmingham Education N/A Yes - Via Email 52.4578511 -1.9734988
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
17733 op-snap---monthly-publication-march-2025.pdf   1490 2025-03 Pedal Bike Ford focus Black Driving without Reasonable Consideration No vehicle excise licence PERSHORE ROAD SOUTH Pershore Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4150779 -1.930901
17734 op-snap---monthly-publication-march-2025.pdf   1491 2025-03 Pedal Bike Volkswagen POLO Silver Driving without Reasonable Consideration None PERSHORE ROAD SOUTH Pershore Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4150779 -1.930901
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
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
17848 op-snap---monthly-publication-march-2025.pdf   1605 2025-03 Pedal Bike Mazda 3 Blue Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
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
17851 op-snap---monthly-publication-march-2025.pdf   1608 2025-03 Pedal Bike Mercedes-Benz C200 Silver Driving without Reasonable Consideration None Stonnall Rd Stonnall Road Birmingham Birmingham Education N/A Yes - Via Email    
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
17906 op-snap---monthly-publication-march-2025.pdf   1663 2025-03 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4150779 -1.930901
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

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