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

121 rows where month = "2025-07", 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

vehicle_make 26

  • Ford 13
  • BMW 12
  • Vauxhall 11
  • Volkswagen 10
  • Audi 9
  • Mercedes-Benz 8
  • Toyota 8
  • Land Rover 6
  • Nissan 6
  • Peugeot 4
  • Honda 3
  • Mini 3
  • Seat 3
  • Daf 2
  • Fiat 2
  • Hyundai 2
  • Kia 2
  • Mg 2
  • Renault 2
  • Skoda 2
  • Volvo 2
  • Chevrolet 1
  • Citroen 1
  • Iveco 1
  • Jaguar 1
  • Mazda 1

council_area 10

  • Birmingham 66
  • Coventry 20
  • Solihull 12
  • Out of Force Area 5
  • Sandwell 5
  • Wolverhampton 4
  • Metropolitan Borough Of Dudley 3
  • Sutton Coldfield 3
  • Dudley 2
  • Walsall 1

disposal 4

  • NFA 63
  • Warning Letter 28
  • Education 25
  • Court 5

reporter_transport_mode 1

  • Pedal Bike · 121 ✖

offence 1

  • Driving without Due Care and Attention · 121 ✖

month 1

  • 2025-07 · 121 ✖
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
11960 op-snap---monthly-publication-july-2025.pdf   12 2025-07 Pedal Bike Vauxhall Zafira Black Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A   52.4762784 -1.9678366
11982 op-snap---monthly-publication-july-2025.pdf   34 2025-07 Pedal Bike   Scania White Driving without Due Care and Attention None Cornets End Lane Cornets End Lane Coventry Coventry Education N/A      
11983 op-snap---monthly-publication-july-2025.pdf   35 2025-07 Pedal Bike Peugeot 208 Black Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11991 op-snap---monthly-publication-july-2025.pdf   43 2025-07 Pedal Bike Audi A3 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Wolverhampton Wolverhampton Education N/A   52.5968709 -2.0954054
11992 op-snap---monthly-publication-july-2025.pdf   44 2025-07 Pedal Bike Kia Rio Silver Driving without Due Care and Attention None A38 Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
12010 op-snap---monthly-publication-july-2025.pdf   62 2025-07 Pedal Bike Volvo V40 Blue Driving without Due Care and Attention None Meer End Road Meer End Road Solihull Solihull Education N/A   52.373396 -1.6335409
12038 op-snap---monthly-publication-july-2025.pdf   90 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull NFA Outside of 14 Days NIP   52.4193964 -1.8252207
12040 op-snap---monthly-publication-july-2025.pdf   92 2025-07 Pedal Bike BMW 520.. Black Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull NFA Outside of 14 Days NIP      
12049 op-snap---monthly-publication-july-2025.pdf   101 2025-07 Pedal Bike BMW 320d Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
12067 op-snap---monthly-publication-july-2025.pdf   119 2025-07 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Bickenhill Road Bickenhill Road Solihull Solihull Court N/A   52.4640893 -1.7362681
12073 op-snap---monthly-publication-july-2025.pdf   125 2025-07 Pedal Bike Vauxhall astra Red Driving without Due Care and Attention None Forest Road Forest Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4467275 -1.8804014
12087 op-snap---monthly-publication-july-2025.pdf   139 2025-07 Pedal Bike BMW 116.. White Driving without Due Care and Attention None Bearwood Road Bearwood Road Sandwell Sandwell Education N/A   52.4725977 -1.9684448
12121 op-snap---monthly-publication-july-2025.pdf   173 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Dorchester Road Dorchester Road Solihull Solihull Court N/A   52.4157911 -1.7926505
12125 op-snap---monthly-publication-july-2025.pdf   177 2025-07 Pedal Bike Audi Q5 Blue Driving without Due Care and Attention None Bookvale Road Bookvale Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12126 op-snap---monthly-publication-july-2025.pdf   178 2025-07 Pedal Bike Citroen C3 Blue Driving without Due Care and Attention None City Road City Road Birmingham Birmingham NFA No Offence   52.4763176 -1.9584897
12130 op-snap---monthly-publication-july-2025.pdf   182 2025-07 Pedal Bike Skoda   Black Driving without Due Care and Attention None Witton Road, Witton Lane Witton Road, Witton Lane Birmingham Birmingham NFA No VRM      
12132 op-snap---monthly-publication-july-2025.pdf   184 2025-07 Pedal Bike Daf   White Driving without Due Care and Attention None Gooch st at Bissell St Gooch st at Bissell Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4696234 -1.8952392
12133 op-snap---monthly-publication-july-2025.pdf   185 2025-07 Pedal Bike Volvo Bus Red Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham NFA No Offence      
12174 op-snap---monthly-publication-july-2025.pdf   226 2025-07 Pedal Bike Ford B-Max Blue Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
12179 op-snap---monthly-publication-july-2025.pdf   231 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Ampton Road Ampton Road Birmingham Birmingham Education N/A   52.4632489 -1.917458
12195 op-snap---monthly-publication-july-2025.pdf   247 2025-07 Pedal Bike Mini cooper Blue Driving without Due Care and Attention None Bewdley Bewdley Out of Force Area Out of Force Area NFA Out of Force   52.4330724 -1.9181313
12218 op-snap---monthly-publication-july-2025.pdf   270 2025-07 Pedal Bike Jaguar XE Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5872149 -1.8300386
12224 op-snap---monthly-publication-july-2025.pdf   276 2025-07 Pedal Bike Seat Ibiza Black Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Education N/A   52.4375913 -1.9068522
12227 op-snap---monthly-publication-july-2025.pdf   279 2025-07 Pedal Bike Chevrolet Chrysler Black Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Education N/A   52.4092804 -1.8056214
12241 op-snap---monthly-publication-july-2025.pdf   293 2025-07 Pedal Bike Vauxhall Meriva White Driving without Due Care and Attention None Linden Road Linden Road Solihull Solihull NFA Outside of 14 Days NIP      
12242 op-snap---monthly-publication-july-2025.pdf   294 2025-07 Pedal Bike Vauxhall Corsa Grey Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4390303 -1.9512931
12244 op-snap---monthly-publication-july-2025.pdf   296 2025-07 Pedal Bike Hyundai I10 Red Driving without Due Care and Attention None Shenley Hill Shenley Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.4267534 -1.9790765
12245 op-snap---monthly-publication-july-2025.pdf   297 2025-07 Pedal Bike Volkswagen Passat Blue Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4436471 -1.9604594
12270 op-snap---monthly-publication-july-2025.pdf   322 2025-07 Pedal Bike BMW 220i White Driving without Due Care and Attention None Woodbourne Road Woodbourne Road Birmingham Birmingham Warning Letter N/A   52.4702361 -1.951945
12273 op-snap---monthly-publication-july-2025.pdf   325 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Haxelhurst Road Haxelhurst Road Birmingham Birmingham NFA No Offence      
12277 op-snap---monthly-publication-july-2025.pdf   329 2025-07 Pedal Bike Audi RSQ8 Grey Driving without Due Care and Attention None Cornwall Street Cornwall Street Birmingham Birmingham Warning Letter N/A   52.4815054 -1.9032499
12327 op-snap---monthly-publication-july-2025.pdf   379 2025-07 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None Hazelhurts Road Hazelhurts Road Birmingham Birmingham NFA Not in Public Interest      
12353 op-snap---monthly-publication-july-2025.pdf   405 2025-07 Pedal Bike Audi A6... Black Driving without Due Care and Attention None Butts Road Butts Road Walsall Walsall NFA Not in Public Interest   52.592263 -1.9743536
12380 op-snap---monthly-publication-july-2025.pdf   432 2025-07 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Moor Green Lane Moor Green Lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
12391 op-snap---monthly-publication-july-2025.pdf   443 2025-07 Pedal Bike Peugeot 2008 Grey Driving without Due Care and Attention None Coventry Road Coventry Road Coventry Coventry Education N/A   52.4111289 -1.5094345
12400 op-snap---monthly-publication-july-2025.pdf   452 2025-07 Pedal Bike Toyota Auris Black Driving without Due Care and Attention None May Lane May Lane Birmingham Birmingham Education N/A   52.4197342 -1.8839613
12417 op-snap---monthly-publication-july-2025.pdf   469 2025-07 Pedal Bike Renault Captur Silver Driving without Due Care and Attention None Upper Hill Street Upper Hill Street Coventry Coventry NFA No Offence   52.4106808 -1.5185684
12420 op-snap---monthly-publication-july-2025.pdf   472 2025-07 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Bridgenorth Road Bridgenorth Road Out of Force Area Out of Force Area NFA Out of Force      
12422 op-snap---monthly-publication-july-2025.pdf   474 2025-07 Pedal Bike Mazda 6... Red Driving without Due Care and Attention None Melrose Avenue Melrose Avenue Sutton Coldfield Sutton Coldfield NFA No Offence   52.5511462 -1.8479052
12457 op-snap---monthly-publication-july-2025.pdf   509 2025-07 Pedal Bike BMW M135i Grey Driving without Due Care and Attention None Shilton Lane Shilton Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4425711 -1.4532921
12459 op-snap---monthly-publication-july-2025.pdf   511 2025-07 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
12462 op-snap---monthly-publication-july-2025.pdf   514 2025-07 Pedal Bike Audi Q3 White Driving without Due Care and Attention None Kenilworth Road Knowle Kenilworth Road Knowle Solihull Solihull Education N/A   52.3877147 -1.732243
12485 op-snap---monthly-publication-july-2025.pdf   537 2025-07 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Thruxton, Herefordshire Thruxton, Herefordshire Out of Force Area Out of Force Area NFA Out of Force      
12504 op-snap---monthly-publication-july-2025.pdf   556 2025-07 Pedal Bike Nissan Micra Black Driving without Due Care and Attention None Talbot Street, Hockley Talbot Street, Hockley Birmingham Birmingham NFA No Independent Evidence Available   52.4956227 -1.9324692
12513 op-snap---monthly-publication-july-2025.pdf   565 2025-07 Pedal Bike BMW X3 Blue Driving without Due Care and Attention None Norton Rd Stourbridge Norton Road Stourbridge Metropolitan Borough of Dudley Metropolitan Borough Of Dudley NFA No Offence   52.4388442 -2.1645703
12517 op-snap---monthly-publication-july-2025.pdf   569 2025-07 Pedal Bike Kia Sportage Silver Driving without Due Care and Attention None Talbot Street Talbot Street Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4956227 -1.9324692
12525 op-snap---monthly-publication-july-2025.pdf   577 2025-07 Pedal Bike Mg 3 Silver Driving without Due Care and Attention None Hagley Road West Hagley Road West Sandwell Sandwell Education N/A   52.4634145 -1.9969046
12542 op-snap---monthly-publication-july-2025.pdf   594 2025-07 Pedal Bike Vauxhall Insignia Grey Driving without Due Care and Attention None Enville Road, Kingswinford Enville Road, Kingswinford Sandwell Sandwell Education N/A      
12562 op-snap---monthly-publication-july-2025.pdf   614 2025-07 Pedal Bike Nissan Note Grey Driving without Due Care and Attention None Oakfield Road Oakfield Road Birmingham Birmingham Education N/A   52.4464556 -1.9200958
12610 op-snap---monthly-publication-july-2025.pdf   662 2025-07 Pedal Bike Land Rover Freelander Black Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham NFA No Offence   52.4220705 -1.8372335
12620 op-snap---monthly-publication-july-2025.pdf   672 2025-07 Pedal Bike Land Rover Range Rover White Driving without Due Care and Attention None Redhill Road Redhill Road Birmingham Birmingham Education N/A   52.4618364 -1.8328803
12624 op-snap---monthly-publication-july-2025.pdf   676 2025-07 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
12639 op-snap---monthly-publication-july-2025.pdf   691 2025-07 Pedal Bike Mercedes-Benz E class Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12641 op-snap---monthly-publication-july-2025.pdf   693 2025-07 Pedal Bike Volkswagen Polo Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12646 op-snap---monthly-publication-july-2025.pdf   698 2025-07 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None Norman Place Road Norman Place Road Coventry Coventry NFA No Offence   52.4285935 -1.5370895
12663 op-snap---monthly-publication-july-2025.pdf   715 2025-07 Pedal Bike Mini cooper Blue Driving without Due Care and Attention No Insurance William Street William Street Birmingham Birmingham Court N/A   52.4737583 -1.9124023
12697 op-snap---monthly-publication-july-2025.pdf   749 2025-07 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Valley Road, Earlswood Valley Road, Earlswood Out of Force Area Out of Force Area NFA Out of Force      
12703 op-snap---monthly-publication-july-2025.pdf   755 2025-07 Pedal Bike Fiat 500 Blue Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull Education N/A   52.4193964 -1.8252207
12705 op-snap---monthly-publication-july-2025.pdf   757 2025-07 Pedal Bike Seat Leon Black Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
12710 op-snap---monthly-publication-july-2025.pdf   762 2025-07 Pedal Bike Ford Transit Blue Driving without Due Care and Attention No Insurance Grange Road Grange Road Birmingham Birmingham Court N/A   52.5065077 -1.892207
12712 op-snap---monthly-publication-july-2025.pdf   764 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None West Heath Road West Heath Road Birmingham Birmingham Education N/A   52.402785 -1.9620058
12714 op-snap---monthly-publication-july-2025.pdf   766 2025-07 Pedal Bike Volkswagen Golf White Driving without Due Care and Attention None Wuchall Road Northfield Wuchall Road Northfield Birmingham Birmingham Warning Letter N/A      
12719 op-snap---monthly-publication-july-2025.pdf   771 2025-07 Pedal Bike BMW   Black Driving without Due Care and Attention None Packwood Road Packwood Road Solihull Solihull NFA No Offence   52.3617789 -1.7409895
12724 op-snap---monthly-publication-july-2025.pdf   776 2025-07 Pedal Bike Audi A4.. White Driving without Due Care and Attention None Hagley Road (5 ways underpass) Hagley Road (5 ways underpass) Birmingham Birmingham Education N/A      
12730 op-snap---monthly-publication-july-2025.pdf   782 2025-07 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Close Pass Close Pass Dudley Dudley NFA Outside of 14 Days NIP      
12747 op-snap---monthly-publication-july-2025.pdf   799 2025-07 Pedal Bike Nissan Note Grey Driving without Due Care and Attention None Brierley Hill Road Brierley Hill Road Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4811151 -2.1456435
12760 op-snap---monthly-publication-july-2025.pdf   812 2025-07 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12761 op-snap---monthly-publication-july-2025.pdf   813 2025-07 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Northfiled Road Northfiled Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12762 op-snap---monthly-publication-july-2025.pdf   814 2025-07 Pedal Bike Volkswagen Passatt Blue Driving without Due Care and Attention None Lordswood Road Lordswood Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4591339 -1.9601054
12763 op-snap---monthly-publication-july-2025.pdf   815 2025-07 Pedal Bike Vauxhall Corsa Red Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12764 op-snap---monthly-publication-july-2025.pdf   816 2025-07 Pedal Bike Iveco Daily White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12765 op-snap---monthly-publication-july-2025.pdf   817 2025-07 Pedal Bike Mercedes-Benz GLC 220 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12766 op-snap---monthly-publication-july-2025.pdf   818 2025-07 Pedal Bike Mercedes-Benz CLA Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull Warning Letter N/A   52.4191184 -1.8326637
12767 op-snap---monthly-publication-july-2025.pdf   819 2025-07 Pedal Bike Mg zs Yellow Driving without Due Care and Attention None Lordswood roundabout Lordswood roundabout Birmingham Birmingham NFA Outside of 14 Days NIP      
12768 op-snap---monthly-publication-july-2025.pdf   820 2025-07 Pedal Bike   Perodua Black Driving without Due Care and Attention None The Barley lea The Barley lea Coventry Coventry NFA Outside of 14 Days NIP   52.3952661 -1.4705187
12775 op-snap---monthly-publication-july-2025.pdf   827 2025-07 Pedal Bike Renault   Blue Driving without Due Care and Attention None Gravelly Lane Gravelly Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.534608 -1.8379769
12912 op-snap---monthly-publication-july-2025.pdf   964 2025-07 Pedal Bike BMW 116 Silver Driving without Due Care and Attention None Highfield Road Highfield Road Wolverhampton Wolverhampton NFA No Offence   52.5570756 -2.073188
12914 op-snap---monthly-publication-july-2025.pdf   966 2025-07 Pedal Bike Ford Transit Silver Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5836778 -2.0894997
12929 op-snap---monthly-publication-july-2025.pdf   981 2025-07 Pedal Bike Volkswagen golf Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
12931 op-snap---monthly-publication-july-2025.pdf   983 2025-07 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
12949 op-snap---monthly-publication-july-2025.pdf   1001 2025-07 Pedal Bike BMW 335.. Blue Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA No Offence   52.4390303 -1.9512931
12951 op-snap---monthly-publication-july-2025.pdf   1003 2025-07 Pedal Bike Mercedes-Benz E220 Grey Driving without Due Care and Attention None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
12983 op-snap---monthly-publication-july-2025.pdf   1035 2025-07 Pedal Bike Toyota Aygo Red Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
13024 op-snap---monthly-publication-july-2025.pdf   1076 2025-07 Pedal Bike Toyota Auris Silver Driving without Due Care and Attention None Darlsaton Road (Wednesbury) Darlsaton Road (Wednesbury) Sandwell Sandwell Warning Letter N/A      
13047 op-snap---monthly-publication-july-2025.pdf   1099 2025-07 Pedal Bike Land Rover Range Rover Grey Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4415108 -1.8971434
13066 op-snap---monthly-publication-july-2025.pdf   1118 2025-07 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None War Lane, harborne War Lane, harborne Birmingham Birmingham NFA Outside of 14 Days NIP   52.4569552 -1.9616483
13067 op-snap---monthly-publication-july-2025.pdf   1119 2025-07 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13069 op-snap---monthly-publication-july-2025.pdf   1121 2025-07 Pedal Bike Audi Q6 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13070 op-snap---monthly-publication-july-2025.pdf   1122 2025-07 Pedal Bike Volkswagen Polo White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13071 op-snap---monthly-publication-july-2025.pdf   1123 2025-07 Pedal Bike Mini Cooper Green Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13072 op-snap---monthly-publication-july-2025.pdf   1124 2025-07 Pedal Bike Toyota Corolla Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13074 op-snap---monthly-publication-july-2025.pdf   1126 2025-07 Pedal Bike Ford Fusion Black Driving without Due Care and Attention None Stonehouse Hill Stonehouse Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.4448348 -1.9713792
13075 op-snap---monthly-publication-july-2025.pdf   1127 2025-07 Pedal Bike     Blue Driving without Due Care and Attention None War Lane Harbourne War Lane Harbourne Birmingham Birmingham NFA Outside of 14 Days NIP      
13076 op-snap---monthly-publication-july-2025.pdf   1128 2025-07 Pedal Bike Volkswagen Tiguan Blue Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham NFA Outside of 14 Days NIP      
13077 op-snap---monthly-publication-july-2025.pdf   1129 2025-07 Pedal Bike Seat Ibiza White Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham NFA No Offence      
13078 op-snap---monthly-publication-july-2025.pdf   1130 2025-07 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham NFA No Offence   52.4468506 -1.9395619
13079 op-snap---monthly-publication-july-2025.pdf   1131 2025-07 Pedal Bike Peugeot Expert White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA No Offence   52.4167654 -1.9411244
13080 op-snap---monthly-publication-july-2025.pdf   1132 2025-07 Pedal Bike Fiat Spider Blue Driving without Due Care and Attention None War lane War lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
13081 op-snap---monthly-publication-july-2025.pdf   1133 2025-07 Pedal Bike Peugeot van White Driving without Due Care and Attention None War lane War lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
13082 op-snap---monthly-publication-july-2025.pdf   1134 2025-07 Pedal Bike Nissan Qashqai Grey Driving without Due Care and Attention None War lane War lane Birmingham Birmingham Education N/A   52.4569552 -1.9616483

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