home / opsnap

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

1,232 rows where 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: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

  • Ford 162
  • Mercedes-Benz 117
  • Volkswagen 97
  • BMW 89
  • Vauxhall 87
  • Toyota 81
  • Audi 79
  • Peugeot 48
  • Nissan 37
  • Hyundai 32
  • Kia 32
  • Renault 31
  • Citroen 30
  • Land Rover 29
  • Seat 27
  • Honda 25
  • Skoda 23
  • Volvo 23
  • Mini 18
  • Fiat 14
  • Jaguar 12
  • Mazda 12
  • Mitsubishi 11
  • Daf 10
  • Mg 9
  • Suzuki 9
  • Porsche 8
  • Lexus 5
  • Tesla 5
  • Alfa Romeo 3
  • …

council_area 15

  • Birmingham 643
  • Coventry 210
  • Solihull 106
  • Out of Force Area 69
  • Sutton Coldfield 51
  • Dudley 43
  • Walsall 40
  • Sandwell 33
  • Wolverhampton 22
  • Halesowen 6
  • Metropolitan Borough Of Dudley 3
  • Area 2
  • Metropolitan Borough 2
  • Cbtiiromningham 1
  • Mbinirgmhianmgham 1

month 14

  • 2025-06 149
  • 2025-05 137
  • 2025-10 122
  • 2026-02 122
  • 2025-07 121
  • 2025-09 94
  • 2025-11 85
  • 2025-12 83
  • 2025-08 81
  • 2026-01 78
  • 2025-02 49
  • 2025-03 44
  • 2025-04 39
  • 2025-01 28

disposal 7

  • Education 499
  • NFA 368
  • Warning Letter 224
  • Court 77
  • Fixed Penalty 60
  • Other Action Taken 3
  • Duplicate Submission 1

reporter_transport_mode 1

  • Pedal Bike · 1,232 ✖

offence 1

  • Driving without Due Care and Attention · 1,232 ✖
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
7275 op-snap---monthly-publication-february-2026.pdf   22 2026-02 Pedal Bike Audi   Silver Driving without Due Care and Attention None B4101 Spring Lane Spring Lane Out of Force Area Out of Force Area NFA Out of Force      
7297 op-snap---monthly-publication-february-2026.pdf   44 2026-02 Pedal Bike Toyota Prius Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
7298 op-snap---monthly-publication-february-2026.pdf   45 2026-02 Pedal Bike Peugeot 3008 Grey Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
7299 op-snap---monthly-publication-february-2026.pdf   46 2026-02 Pedal Bike Toyota Auris Brown Driving without Due Care and Attention None Franklin Road Franklin Road Birmingham Birmingham Education N/A   52.4195456 -1.9350703
7305 op-snap---monthly-publication-february-2026.pdf   52 2026-02 Pedal Bike BMW   Black Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
7312 op-snap---monthly-publication-february-2026.pdf   59 2026-02 Pedal Bike BMW 218i Blue Driving without Due Care and Attention None Bird Street at White Street Bird Street at White Street Coventry Coventry Education N/A   52.4124171 -1.5065021
7330 op-snap---monthly-publication-february-2026.pdf   77 2026-02 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Trittiford Road Trittiford Road Birmingham Birmingham Education N/A   52.4248084 -1.8660294
7353 op-snap---monthly-publication-february-2026.pdf   100 2026-02 Pedal Bike Vauxhall Corsa Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
7359 op-snap---monthly-publication-february-2026.pdf   106 2026-02 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Greens Road Greens Road Coventry Coventry Education N/A   52.4381927 -1.5291209
7380 op-snap---monthly-publication-february-2026.pdf   127 2026-02 Pedal Bike Honda Civic Grey Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Education N/A   52.4569552 -1.9616483
7381 op-snap---monthly-publication-february-2026.pdf   128 2026-02 Pedal Bike Volvo V60 Black Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Education N/A   52.4569552 -1.9616483
7383 op-snap---monthly-publication-february-2026.pdf   130 2026-02 Pedal Bike Mercedes-Benz 180 Grey Driving without Due Care and Attention None Weoley Castle Weoley Castle Birmingham Birmingham Education N/A   52.4428373 -1.9698276
7384 op-snap---monthly-publication-february-2026.pdf   131 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
7389 op-snap---monthly-publication-february-2026.pdf   136 2026-02 Pedal Bike Ford Mondeo Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
7419 op-snap---monthly-publication-february-2026.pdf   166 2026-02 Pedal Bike Volvo XC60 White Driving without Due Care and Attention None Bournville Lane Bournville Lane Birmingham Birmingham Education N/A   52.4271614 -1.9302862
7426 op-snap---monthly-publication-february-2026.pdf   173 2026-02 Pedal Bike Toyota Estima Silver Driving without Due Care and Attention None Weoley Park Road Weoley Park Road Birmingham Birmingham Warning Letter N/A   52.4368136 -1.9495478
7427 op-snap---monthly-publication-february-2026.pdf   174 2026-02 Pedal Bike Chysler Grand Voyager Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
7430 op-snap---monthly-publication-february-2026.pdf   177 2026-02 Pedal Bike Mg ZR Black Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
7442 op-snap---monthly-publication-february-2026.pdf   189 2026-02 Pedal Bike Mercedes-Benz E220 Silver Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Court N/A   52.4708802 -1.8792135
7454 op-snap---monthly-publication-february-2026.pdf   201 2026-02 Pedal Bike Volkswagen Tayron Grey Driving without Due Care and Attention None Hallam Street Hallam Street Birmingham Birmingham Education N/A   52.4563937 -1.8933429
7470 op-snap---monthly-publication-february-2026.pdf   217 2026-02 Pedal Bike Kia Rio Blue Driving without Due Care and Attention None Ansty Road Ansty Road Coventry Coventry Education N/A   52.4205675 -1.4520187
7482 op-snap---monthly-publication-february-2026.pdf   229 2026-02 Pedal Bike Citroen C8 Blue Driving without Due Care and Attention None Ashwood Road (Worcs) Ashwood Road (Worcs) Out of Force Area Out of Force Area NFA Out of Force      
7498 op-snap---monthly-publication-february-2026.pdf   245 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Westwood WAY Westwood WAY Coventry Coventry Education N/A   52.3880214 -1.5797132
7514 op-snap---monthly-publication-february-2026.pdf   261 2026-02 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention None Ridgacre Road Ridgacre Road Birmingham Birmingham Education N/A   52.4593367 -2.0000298
7517 op-snap---monthly-publication-february-2026.pdf   264 2026-02 Pedal Bike Jaguar i-Pace Black Driving without Due Care and Attention None South Road, Stourbridge South Road, Stourbridge Dudley Dudley Education N/A   52.4530371 -2.1660216
7536 op-snap---monthly-publication-february-2026.pdf   283 2026-02 Pedal Bike Mercedes-Benz ML320 Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
7538 op-snap---monthly-publication-february-2026.pdf   285 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
7577 op-snap---monthly-publication-february-2026.pdf   324 2026-02 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Bromyard Road Bromyard Road Birmingham Birmingham Education N/A   52.4457403 -1.8536648
7632 op-snap---monthly-publication-february-2026.pdf   379 2026-02 Pedal Bike Seat Leon Silver Driving without Due Care and Attention None Woodstock Road Woodstock Road Coventry Coventry NFA No Independent Evidence Available   52.3919059 -1.5026146
7682 op-snap---monthly-publication-february-2026.pdf   429 2026-02 Pedal Bike Land Rover Discovery Brown Driving without Due Care and Attention None Redhill Road Redhill Road Birmingham Birmingham Education N/A   52.4618364 -1.8328803
7696 op-snap---monthly-publication-february-2026.pdf   443 2026-02 Pedal Bike Mercedes-Benz A Class Silver Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
7697 op-snap---monthly-publication-february-2026.pdf   444 2026-02 Pedal Bike Kia Sportage Silver Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
7699 op-snap---monthly-publication-february-2026.pdf   446 2026-02 Pedal Bike Mercedes-Benz Sprinter white Driving without Due Care and Attention None Broad Lane, Tile Hill Broad Lane, Tile Hill Coventry Coventry Education N/A   52.4112706 -1.5792697
7700 op-snap---monthly-publication-february-2026.pdf   447 2026-02 Pedal Bike Kia Niro White Driving without Due Care and Attention None Bloomfield Road, Earlsdon Bloomfield Road, Earlsdon Coventry Coventry Education N/A      
7701 op-snap---monthly-publication-february-2026.pdf   448 2026-02 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull Warning Letter N/A   52.4190728 -1.7449943
7783 op-snap---monthly-publication-february-2026.pdf   530 2026-02 Pedal Bike Mercedes-Benz 180 White Driving without Due Care and Attention None Cornetts End Lane Cornetts End Lane Solihull Solihull Education N/A      
7785 op-snap---monthly-publication-february-2026.pdf   532 2026-02 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None High Street, Hampton in Arden High Street, Hampton in Arden Solihull Solihull NFA No Offence   52.4291828 -1.7000245
7786 op-snap---monthly-publication-february-2026.pdf   533 2026-02 Pedal Bike Citroen Nemo Blue Driving without Due Care and Attention None Linthouse Lane Linthouse Lane Wolverhampton Wolverhampton Education N/A   52.6118187 -2.0810618
7821 op-snap---monthly-publication-february-2026.pdf   568 2026-02 Pedal Bike Mercedes-Benz Lorry Blue Driving without Due Care and Attention None Grange Hill, near Manor Way roundabout, Halesowen Grange Hill, near Manor Way roundabout, Halesowen Halesowen Halesowen Fixed Penalty N/A   52.4417713 -2.0434182
7828 op-snap---monthly-publication-february-2026.pdf   575 2026-02 Pedal Bike Toyota CHR Silver Driving without Due Care and Attention None Hagley Causeway, Halesowen Hagley Causeway, Halesowen Halesowen Halesowen Fixed Penalty N/A   52.4349292 -2.0850774
7831 op-snap---monthly-publication-february-2026.pdf   578 2026-02 Pedal Bike Daf   White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
7833 op-snap---monthly-publication-february-2026.pdf   580 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
7839 op-snap---monthly-publication-february-2026.pdf   586 2026-02 Pedal Bike Skoda Octavia Blue Driving without Due Care and Attention No Insurance Dads Lane Dads Lane Birmingham Birmingham Court N/A   52.4375913 -1.9068522
7841 op-snap---monthly-publication-february-2026.pdf   588 2026-02 Pedal Bike Kia Sport White Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
7843 op-snap---monthly-publication-february-2026.pdf   590 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Kings Heath High Street Kings Heath High Street Birmingham Birmingham Education N/A   52.4391028 -1.893289
7849 op-snap---monthly-publication-february-2026.pdf   596 2026-02 Pedal Bike Mercedes-Benz A180 Grey Driving without Due Care and Attention None Gillhurst Road Gillhurst Road Birmingham Birmingham Court N/A   52.467676 -1.9548345
7856 op-snap---monthly-publication-february-2026.pdf   603 2026-02 Pedal Bike Seat Leon Grey Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
7857 op-snap---monthly-publication-february-2026.pdf   604 2026-02 Pedal Bike Seat Ibiza Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
7862 op-snap---monthly-publication-february-2026.pdf   609 2026-02 Pedal Bike Audi TT Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
7933 op-snap---monthly-publication-february-2026.pdf   680 2026-02 Pedal Bike Porsche Cayenne Grey Driving without Due Care and Attention None Streetbrook Road Solihull Streetbrook Road Solihull Solihull Solihull Education N/A      
7934 op-snap---monthly-publication-february-2026.pdf   681 2026-02 Pedal Bike BMW   Orange Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
7938 op-snap---monthly-publication-february-2026.pdf   685 2026-02 Pedal Bike BMW   Grey Driving without Due Care and Attention None Back Lane Coventry Back Lane Coventry Coventry Coventry Education N/A   52.3796433 -1.5600371
8015 op-snap---monthly-publication-february-2026.pdf   762 2026-02 Pedal Bike Audi A3 Green Driving without Due Care and Attention None Pritchatts Road, Edgbaston Pritchatts Road, Edgbaston Birmingham Birmingham Court N/A   52.4563161 -1.934895
8017 op-snap---monthly-publication-february-2026.pdf   764 2026-02 Pedal Bike Mercedes-Benz CLA220 Red Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
8025 op-snap---monthly-publication-february-2026.pdf   772 2026-02 Pedal Bike Audi Q2 White Driving without Due Care and Attention None High Street High Street Solihull Solihull Education N/A   52.4064169 -1.8557215
8027 op-snap---monthly-publication-february-2026.pdf   774 2026-02 Pedal Bike Nissan Qashqai Beige Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Education N/A   52.402753 -1.5385829
8040 op-snap---monthly-publication-february-2026.pdf   787 2026-02 Pedal Bike Peugeot 5008 Silver Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A   52.4390303 -1.9512931
8042 op-snap---monthly-publication-february-2026.pdf   789 2026-02 Pedal Bike Tesla Model S White Driving without Due Care and Attention None Shutt Lane Shutt Lane Solihull Solihull Education N/A   52.367795 -1.8250635
8047 op-snap---monthly-publication-february-2026.pdf   794 2026-02 Pedal Bike Ford Puma Red Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull Education N/A   52.4190728 -1.7449943
8049 op-snap---monthly-publication-february-2026.pdf   796 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Broad Lane nr The Glade junction Broad Lane nr The Glade junction Coventry Coventry Education N/A      
8050 op-snap---monthly-publication-february-2026.pdf   797 2026-02 Pedal Bike Hyundai i30 Grey Driving without Due Care and Attention None Broad Lane near Coral Close Broad Lane near Coral Close Coventry Coventry Education N/A   52.4144409 -1.5990259
8056 op-snap---monthly-publication-february-2026.pdf   803 2026-02 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None Brinklow Road Brinklow Road Coventry Coventry NFA Outside of 14 Days NIP   52.4028059 -1.4461048
8081 op-snap---monthly-publication-february-2026.pdf   828 2026-02 Pedal Bike Vauxhall Vicaro silver Driving without Due Care and Attention none A491 Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
8084 op-snap---monthly-publication-february-2026.pdf   831 2026-02 Pedal Bike Ford KA White Driving without Due Care and Attention None Heath Lane towards Norton Heath Lane towards Norton Dudley Dudley Education N/A      
8103 op-snap---monthly-publication-february-2026.pdf   850 2026-02 Pedal Bike Audi Q3 White Driving without Due Care and Attention None Hearsall Lane Hearsall Lane Coventry Coventry Education N/A   52.4064125 -1.5320113
8203 op-snap---monthly-publication-february-2026.pdf   950 2026-02 Pedal Bike Mercedes-Benz C180 Silver Driving without Due Care and Attention None Hobls Hole Lane Hobls Hole Lane Walsall Walsall Education N/A      
8205 op-snap---monthly-publication-february-2026.pdf   952 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Gibbins Road, Selly Oak Gibbins Road, Selly Oak Birmingham Birmingham Education N/A   52.4390303 -1.9512931
8206 op-snap---monthly-publication-february-2026.pdf   953 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Bristol Road, Bourneville Bristol Road, Bourneville Birmingham Birmingham Education N/A      
8207 op-snap---monthly-publication-february-2026.pdf   954 2026-02 Pedal Bike Peugeot Expert White Driving without Due Care and Attention None Cock Hill Lane, Rubery Cock Hill Lane, Rubery Birmingham Birmingham Education N/A      
8227 op-snap---monthly-publication-february-2026.pdf   974 2026-02 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Clevedon Road, Balsall Heath Clevedon Road, Balsall Heath Birmingham Birmingham Education N/A   52.4618531 -1.894645
8261 op-snap---monthly-publication-february-2026.pdf   1008 2026-02 Pedal Bike Mercedes-Benz Benz White Driving without Due Care and Attention None Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
8270 op-snap---monthly-publication-february-2026.pdf   1017 2026-02 Pedal Bike Mazda CX5 Black Driving without Due Care and Attention None Off force Off force Out of Force Area Out of Force Area NFA Out of Force      
8282 op-snap---monthly-publication-february-2026.pdf   1029 2026-02 Pedal Bike Audi A6 Silver Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
8295 op-snap---monthly-publication-february-2026.pdf   1042 2026-02 Pedal Bike Dennis Bus Grey Driving without Due Care and Attention None St Martins Street Martins Birmingham Birmingham Warning Letter N/A   52.477697 -1.8962719
8299 op-snap---monthly-publication-february-2026.pdf   1046 2026-02 Pedal Bike Land Rover Evoque Black Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
8318 op-snap---monthly-publication-february-2026.pdf   1065 2026-02 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Meriden Road Meriden Road Solihull Solihull NFA No Offence   52.4137518 -1.6414448
8321 op-snap---monthly-publication-february-2026.pdf   1068 2026-02 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Education N/A   52.4073149 -1.5250454
8349 op-snap---monthly-publication-february-2026.pdf   1096 2026-02 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Ladywood Road Ladywood Road Birmingham Birmingham Education N/A   52.5783972 -1.8355593
8350 op-snap---monthly-publication-february-2026.pdf   1097 2026-02 Pedal Bike Vauxhall Astra Grey Driving without Due Care and Attention None Cornets End Lane Cornets End Lane Solihull Solihull Warning Letter N/A   52.4269547 -1.6668911
8351 op-snap---monthly-publication-february-2026.pdf   1098 2026-02 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Ladywood Road Ladywood Road Birmingham Birmingham Duplicate Submission Duplicate Submission   52.5783972 -1.8355593
8354 op-snap---monthly-publication-february-2026.pdf   1101 2026-02 Pedal Bike Citroen C4.. White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Education N/A   52.4041117 -1.5595662
8357 op-snap---monthly-publication-february-2026.pdf   1104 2026-02 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Sandpits Sandpits Birmingham Birmingham Court N/A   52.482308 -1.9133277
8368 op-snap---monthly-publication-february-2026.pdf   1115 2026-02 Pedal Bike Hyundai Bayen Red Driving without Due Care and Attention None Rubery Lane, Frankley Rubery Lane, Frankley Birmingham Birmingham Education N/A   52.4022216 -2.0074676
8378 op-snap---monthly-publication-february-2026.pdf   1125 2026-02 Pedal Bike Kia Sportage Orange Driving without Due Care and Attention None Love Lane Love Lane Dudley Dudley Education N/A   52.448434 -2.1478173
8383 op-snap---monthly-publication-february-2026.pdf   1130 2026-02 Pedal Bike Volkswagen Beetle Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull NFA No Offence   52.4223176 -1.8253145
8414 op-snap---monthly-publication-february-2026.pdf   1161 2026-02 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Bakers Lane Bakers Lane Sutton Coldfield Sutton Coldfield Education N/A   52.5632567 -1.8782299
8440 op-snap---monthly-publication-february-2026.pdf   1187 2026-02 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
8490 op-snap---monthly-publication-february-2026.pdf   1237 2026-02 Pedal Bike Audi Q5 White Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
8508 op-snap---monthly-publication-february-2026.pdf   1255 2026-02 Pedal Bike Skoda Octavia White Driving without Due Care and Attention None Abbey Road Abbey Road Sandwell Sandwell Education N/A   52.47753 -1.9774758
8514 op-snap---monthly-publication-february-2026.pdf   1261 2026-02 Pedal Bike Mercedes-Benz C220 Silver Driving without Due Care and Attention None White Street White Street Coventry Coventry Education N/A   52.4122951 -1.5045181
8515 op-snap---monthly-publication-february-2026.pdf   1262 2026-02 Pedal Bike Peugeot Expert White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
8521 op-snap---monthly-publication-february-2026.pdf   1268 2026-02 Pedal Bike Mercedes-Benz Smart Fortwo Blue Driving without Due Care and Attention None Streetbrook Road Streetbrook Road Solihull Solihull NFA Outside of 14 Days NIP      
8524 op-snap---monthly-publication-february-2026.pdf   1271 2026-02 Pedal Bike Dacia Duster Orange Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Court N/A   52.4682339 -1.8793662
8528 op-snap---monthly-publication-february-2026.pdf   1275 2026-02 Pedal Bike Ford Ranger White Driving without Due Care and Attention None Lower Street Lower Street Wolverhampton Wolverhampton NFA     52.6017311 -2.1598475
8542 op-snap---monthly-publication-february-2026.pdf   1289 2026-02 Pedal Bike Nissan Qashqai Silver Driving without Due Care and Attention None Broad Lane Coventry Broad Lane Coventry Coventry Coventry Education N/A   52.4144409 -1.5990259
8543 op-snap---monthly-publication-february-2026.pdf   1290 2026-02 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Westwood Way Westwood Way Coventry Coventry Warning Letter N/A   52.3880214 -1.5797132
8546 op-snap---monthly-publication-february-2026.pdf   1293 2026-02 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
8558 op-snap---monthly-publication-february-2026.pdf   1305 2026-02 Pedal Bike Ford Cmax Blue Driving without Due Care and Attention None Cranmore Bvd Cranmore Bvd Solihull Solihull Court N/A   52.3947549 -1.8141729
8570 op-snap---monthly-publication-february-2026.pdf   1317 2026-02 Pedal Bike       Driving without Due Care and Attention None George Road towards Brookvale Road George Road towards Brookvale Road Birmingham Birmingham NFA No VRM      
8571 op-snap---monthly-publication-february-2026.pdf   1318 2026-02 Pedal Bike Renault Truck Master White Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Warning Letter N/A   52.4415108 -1.8971434

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