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

178 rows where council_area = "Birmingham", month = "2025-02" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

vehicle_make 25

  • Volkswagen 22
  • Ford 21
  • Toyota 20
  • BMW 16
  • Audi 15
  • Mercedes-Benz 15
  • Vauxhall 11
  • Honda 7
  • Seat 7
  • Peugeot 6
  • Kia 5
  • Renault 4
  • Hyundai 3
  • Lexus 3
  • Fiat 2
  • Skoda 2
  • Suzuki 2
  • Volvo 2
  • Citroen 1
  • Daf 1
  • Mazda 1
  • Mg 1
  • Mini 1
  • Mitsubishi 1
  • Yamaha 1

disposal 7

  • Fixed Penalty 52
  • Education 40
  • Warning Letter 37
  • Court 26
  • NFA 19
  • Other Action Taken 2
  • RTC - Actioned 2

reporter_transport_mode 5

  • Car 143
  • Pedal Bike 26
  • Pedestrian 7
  • Motorbike 1
  • Other 1

offence 1

  • Driving without Due Care and Attention · 178 ✖

month 1

  • 2025-02 · 178 ✖

council_area 1

  • Birmingham · 178 ✖
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
5197 op-snap---monthly-publication-february-2025.pdf   14 2025-02 Car Audi QUATTRO Black Driving without Due Care and Attention None HOLDER ROAD Holder Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4655509 -1.8219
5226 op-snap---monthly-publication-february-2025.pdf   43 2025-02 Pedal Bike Toyota Yaris Silver Driving without Due Care and Attention None Forest Road, Moseley Forest Road, Moseley Birmingham Birmingham Education N/A Yes - Via Email 52.4467275 -1.8804014
5227 op-snap---monthly-publication-february-2025.pdf   44 2025-02 Car Mercedes-Benz SPRINTER White Driving without Due Care and Attention None BLACK COUNTRY ROUTE Black Country Route Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
5229 op-snap---monthly-publication-february-2025.pdf   46 2025-02 Car Toyota Aygo Orange Driving without Due Care and Attention None Great Hampton Street Great Hampton Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4910446 -1.9105163
5256 op-snap---monthly-publication-february-2025.pdf   73 2025-02 Car Honda CIVIC BLACK Driving without Due Care and Attention No vehicle excise licence BROMFORD LANE Bromford Lane Birmingham Birmingham Court N/A Yes - Via Email 52.5083238 -1.8332287
5271 op-snap---monthly-publication-february-2025.pdf   88 2025-02 Car Fiat 500 Black Driving without Due Care and Attention None Mackadown Lane Mackadown Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4708415 -1.7675939
5278 op-snap---monthly-publication-february-2025.pdf   95 2025-02 Car Volkswagen T-cross Black Driving without Due Care and Attention None Birchfield Lane Birchfield Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5297 op-snap---monthly-publication-february-2025.pdf   114 2025-02 Car Mercedes-Benz E220 Grey Driving without Due Care and Attention None FRIARY ROAD Friary Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5162814 -1.9395798
5298 op-snap---monthly-publication-february-2025.pdf   115 2025-02 Car Volkswagen GOLF R Black Driving without Due Care and Attention None HIGH STREET, ASTON High Street, Aston Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4973154 -1.8956143
5299 op-snap---monthly-publication-february-2025.pdf   116 2025-02 Car Toyota COROLLA Black Driving without Due Care and Attention None VILLA STREET Villa Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.500382 -1.913307
5304 op-snap---monthly-publication-february-2025.pdf   121 2025-02 Car Vauxhall Vivaro White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
5323 op-snap---monthly-publication-february-2025.pdf   140 2025-02 Car Ford Fiesat Silver Driving without Due Care and Attention None Stoney Lane Stoney Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4745488 -1.8065911
5324 op-snap---monthly-publication-february-2025.pdf   141 2025-02 Car Toyota PRIUS Silver Driving without Due Care and Attention None PORTLAND ROAD Portland Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4737014 -1.9412436
5331 op-snap---monthly-publication-february-2025.pdf   148 2025-02 Car Volkswagen Polo White Driving without Due Care and Attention No Insurance Church Lane Church Lane Birmingham Birmingham Court N/A Yes - Via Email 52.5030217 -1.8764632
5333 op-snap---monthly-publication-february-2025.pdf   150 2025-02 Car Mercedes-Benz CLA220 Black Driving without Due Care and Attention None Hagley Rd, Edgbaston Hagley Road, Edgbaston Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4719401 -1.9323711
5354 op-snap---monthly-publication-february-2025.pdf   171 2025-02 Car Peugeot 2008 White Driving without Due Care and Attention None Alcester Road at Salisbury Road Alcester Road at Salisbury Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4467548 -1.8880528
5356 op-snap---monthly-publication-february-2025.pdf   173 2025-02 Car Vauxhall CORSA White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5357 op-snap---monthly-publication-february-2025.pdf   174 2025-02 Car Mercedes-Benz C CLASS White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5358 op-snap---monthly-publication-february-2025.pdf   175 2025-02 Car Audi A3 White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5359 op-snap---monthly-publication-february-2025.pdf   176 2025-02 Car Seat LEON White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5360 op-snap---monthly-publication-february-2025.pdf   177 2025-02 Car Volkswagen TIGUAN Blue Driving without Due Care and Attention No vehicle excise licence Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5361 op-snap---monthly-publication-february-2025.pdf   178 2025-02 Car Audi A5 Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5363 op-snap---monthly-publication-february-2025.pdf   180 2025-02 Car Audi RS3 Silver Driving without Due Care and Attention Use vehicle on a road without valid test certificate Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5364 op-snap---monthly-publication-february-2025.pdf   181 2025-02 Car Hyundai I40 White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5365 op-snap---monthly-publication-february-2025.pdf   182 2025-02 Car Audi A3 Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5368 op-snap---monthly-publication-february-2025.pdf   185 2025-02 Car Ford TRANSIT White Driving without Due Care and Attention None MONICA ROAD Monica Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4714936 -1.8386654
5369 op-snap---monthly-publication-february-2025.pdf   186 2025-02 Car Hyundai Kona Black Driving without Due Care and Attention None College Road College Road Birmingham Birmingham Court N/A Yes - Via Email 52.5151832 -1.9361664
5370 op-snap---monthly-publication-february-2025.pdf   187 2025-02 Car Lexus CT Red Driving without Due Care and Attention None Park Road Park Road Birmingham Birmingham Court N/A Yes - Via Email 52.5641687 -1.8272087
5378 op-snap---monthly-publication-february-2025.pdf   195 2025-02 Car Suzuki GSF1250 Black Driving without Due Care and Attention No Insurance BRANDWOOD Brandwood Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.4167623 -1.8959344
5413 op-snap---monthly-publication-february-2025.pdf   230 2025-02 Pedal Bike Mg ZS Silver Driving without Due Care and Attention None GIBBINS ROAD Gibbins Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4390303 -1.9512931
5438 op-snap---monthly-publication-february-2025.pdf   255 2025-02 Pedal Bike Suzuki Alto White Driving without Due Care and Attention None Redhill Rd and A441 Kings Norton Redhill Road and A441 Kings Norton Birmingham Birmingham Education N/A Yes - Via Email 52.3942085 -1.9534932
5441 op-snap---monthly-publication-february-2025.pdf   258 2025-02 Car Vauxhall Vivaro Grey Driving without Due Care and Attention None Rubery Lane Rubery Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4007375 -2.0158237
5445 op-snap---monthly-publication-february-2025.pdf   262 2025-02 Car Honda 125 Blue Driving without Due Care and Attention None Wellington Road Wellington Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.5133725 -1.9193405
5447 op-snap---monthly-publication-february-2025.pdf   264 2025-02 Car   MAN   Driving without Due Care and Attention None Alston Street Alston Street Birmingham Birmingham Education N/A Yes - Via Email 52.4772629 -1.9267359
5453 op-snap---monthly-publication-february-2025.pdf   270 2025-02 Pedestrian Daf Truck White Driving without Due Care and Attention None Sheepcoat Street, City Centre Sheepcoat Street, City Centre Birmingham Birmingham Education N/A Yes - Via Email    
5459 op-snap---monthly-publication-february-2025.pdf   276 2025-02 Car Ford S-max Black Driving without Due Care and Attention No Insurance Vicarage Road Vicarage Road Birmingham Birmingham Court N/A Yes - Via Email 52.470423 -1.9304786
5470 op-snap---monthly-publication-february-2025.pdf   287 2025-02 Pedal Bike Mazda CX5 Grey Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4299657 -1.9599121
5471 op-snap---monthly-publication-february-2025.pdf   288 2025-02 Pedal Bike Mercedes-Benz GLC 220 Black Driving without Due Care and Attention None Churchyard Lane Churchyard Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4089716 -1.9295218
5484 op-snap---monthly-publication-february-2025.pdf   301 2025-02 Car Renault Clio White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
5492 op-snap---monthly-publication-february-2025.pdf   309 2025-02 Car Kia Picanto Blue Driving without Due Care and Attention None Old Horns Crescent, Birmingham Old Horns Crescent, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5506799 -1.9100116
5496 op-snap---monthly-publication-february-2025.pdf   313 2025-02 Car Volkswagen Toureg Black Driving without Due Care and Attention None St Marys Row Street Marys Row Birmingham Birmingham Education N/A Yes - Via Email    
5497 op-snap---monthly-publication-february-2025.pdf   314 2025-02 Car Lexus CT White Driving without Due Care and Attention No Insurance Warwick Road, Olton Warwick Road, Olton Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5498 op-snap---monthly-publication-february-2025.pdf   315 2025-02 Car Kia EV9 Black Driving without Due Care and Attention None St Marys Row Street Marys Row Birmingham Birmingham Education N/A Yes - Via Email    
5504 op-snap---monthly-publication-february-2025.pdf   321 2025-02 Pedestrian Audi S3 Blue Driving without Due Care and Attention No Insurance Cardigan Street Cardigan Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4849063 -1.8846609
5505 op-snap---monthly-publication-february-2025.pdf   322 2025-02 Car Mercedes-Benz GLB 200 AMG White Driving without Due Care and Attention None Hamstead Hill Hamstead Hill Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5274116 -1.9287273
5529 op-snap---monthly-publication-february-2025.pdf   346 2025-02 Car Kia Rio Black Driving without Due Care and Attention None Scarsdale Road Scarsdale Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.540994 -1.9027862
5545 op-snap---monthly-publication-february-2025.pdf   362 2025-02 Car Toyota PRIUS White Driving without Due Care and Attention None ASTON EXPRESSWAY Aston Expressway Birmingham Birmingham Education N/A Yes - Via Email 52.493793 -1.8881773
5558 op-snap---monthly-publication-february-2025.pdf   375 2025-02 Motorbike Ford focus Silver Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.5292752 -1.7618805
5562 op-snap---monthly-publication-february-2025.pdf   379 2025-02 Car Vauxhall ASTRA Silver Driving without Due Care and Attention None BELGRAVE INTERCHANGE Belgrave Interchange Birmingham Birmingham Education N/A Yes - Via Email 52.466118 -1.8982999
5564 op-snap---monthly-publication-february-2025.pdf   381 2025-02 Pedestrian Toyota Yaris Grey Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4103191 -1.8670224
5574 op-snap---monthly-publication-february-2025.pdf   391 2025-02 Car Volkswagen Passat Black Driving without Due Care and Attention None Green Lane Green Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4618966 -1.9955421
5578 op-snap---monthly-publication-february-2025.pdf   395 2025-02 Car BMW X5 Black Driving without Due Care and Attention None Cole Bank Road Birmingham Cole Bank Road Birmingham Birmingham Birmingham NFA No VRM Yes - Via Email 52.4349375 -1.8510007
5579 op-snap---monthly-publication-february-2025.pdf   396 2025-02 Car Seat Leon Grey Driving without Due Care and Attention None Cooks Lane Birmingham Cooks Lane Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.482758 -1.7603097
5583 op-snap---monthly-publication-february-2025.pdf   400 2025-02 Car BMW 118D Black Driving without Due Care and Attention None M6, Junction 6 M6, Junction 6 Birmingham Birmingham Court N/A Yes - Via Email 52.6760749 -2.0862582
5589 op-snap---monthly-publication-february-2025.pdf   406 2025-02 Car BMW 5 Series Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5590 op-snap---monthly-publication-february-2025.pdf   407 2025-02 Car   Lex Moto Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5591 op-snap---monthly-publication-february-2025.pdf   408 2025-02 Car Volkswagen Golf R White Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5592 op-snap---monthly-publication-february-2025.pdf   409 2025-02 Car Toyota Yaris Silver Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5596 op-snap---monthly-publication-february-2025.pdf   413 2025-02 Car Renault Trucks White Driving without Due Care and Attention None Junction 6 M6 Southbound Junction 6 M6 Southbound Birmingham Birmingham NFA No offence Yes - Via Email    
5598 op-snap---monthly-publication-february-2025.pdf   415 2025-02 Pedestrian   N/P White Driving without Due Care and Attention None Brandwood Park Road Brandwood Park Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4138206 -1.9041686
5600 op-snap---monthly-publication-february-2025.pdf   417 2025-02 Car Ford Fiesta Blue Driving without Due Care and Attention None Highters Heath Road Highters Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4120728 -1.8622915
5604 op-snap---monthly-publication-february-2025.pdf   421 2025-02 Pedestrian Toyota Auris   Driving without Due Care and Attention None Court Oak Road Court Oak Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4604383 -1.9760104
5605 op-snap---monthly-publication-february-2025.pdf   422 2025-02 Car Mercedes-Benz 400 AMG Black Driving without Due Care and Attention None Portway Road Portway Road Birmingham Birmingham Education N/A Yes - Via Email    
5611 op-snap---monthly-publication-february-2025.pdf   428 2025-02 Car Toyota Auris White Driving without Due Care and Attention None A38 inbound A38 inbound Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5613 op-snap---monthly-publication-february-2025.pdf   430 2025-02 Car Seat Leon Grey Driving without Due Care and Attention None Sheldon Heath Road Sheldon Heath Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4744736 -1.7892633
5616 op-snap---monthly-publication-february-2025.pdf   433 2025-02 Car Toyota Prius White Driving without Due Care and Attention None Booth Street Booth Street Birmingham Birmingham Education N/A Yes - Via Email 52.5039035 -1.9447084
5618 op-snap---monthly-publication-february-2025.pdf   435 2025-02 Car Kia Rio Silver Driving without Due Care and Attention None Heybarnes Road Heybarnes Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4677423 -1.8351236
5619 op-snap---monthly-publication-february-2025.pdf   436 2025-02 Car Peugeot 107 Black Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4624743 -1.7763934
5625 op-snap---monthly-publication-february-2025.pdf   442 2025-02 Car Vauxhall Corsa Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Court N/A Yes - Via Email 52.4308271 -1.920078
5674 op-snap---monthly-publication-february-2025.pdf   491 2025-02 Car Volkswagen GOLF R Black Driving without Due Care and Attention None Bishopgate Stret Bishopgate Stret Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
5676 op-snap---monthly-publication-february-2025.pdf   493 2025-02 Car Volkswagen Golf White Driving without Due Care and Attention None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.472238 -1.9127983
5686 op-snap---monthly-publication-february-2025.pdf   503 2025-02 Car Seat Arona Grey Driving without Due Care and Attention None Coleshill Road Coleshill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4967329 -1.8097462
5692 op-snap---monthly-publication-february-2025.pdf   509 2025-02 Car BMW 218i Grey Driving without Due Care and Attention None M5 South, J1 M5 South, J1 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5715 op-snap---monthly-publication-february-2025.pdf   532 2025-02 Car Ford Fiesta Blue Driving without Due Care and Attention None M5 S/B approaching Jn3 M5 Southbound approaching Jn3 Birmingham Birmingham Court N/A Yes - Via Email    
5723 op-snap---monthly-publication-february-2025.pdf   540 2025-02 Car Mini Cooper White Driving without Due Care and Attention None Spies Lane Spies Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4618792 -2.0130081
5752 op-snap---monthly-publication-february-2025.pdf   569 2025-02 Pedal Bike Seat Leon White Driving without Due Care and Attention None Showel Green Lane Showel Green Lane Birmingham Birmingham Education N/A Yes - Via Email    
5754 op-snap---monthly-publication-february-2025.pdf   571 2025-02 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention None St Marys Row Street Marys Row Birmingham Birmingham Warning Letter N/A      
5791 op-snap---monthly-publication-february-2025.pdf   608 2025-02 Car Volkswagen Transporter White Driving without Due Care and Attention None Hamstead Road Birmingham Hamstead Road Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.5073301 -1.9199406
5796 op-snap---monthly-publication-february-2025.pdf   613 2025-02 Car Volkswagen Passatt Black Driving without Due Care and Attention None Green Lane Bordsley Green Green Lane Bordsley Green Birmingham Birmingham Court N/A Yes - Via Email    
5829 op-snap---monthly-publication-february-2025.pdf   646 2025-02 Pedal Bike Volkswagen Tiguan Black Driving without Due Care and Attention None Greenfield Road Harborne Greenfield Road Harborne Birmingham Birmingham Education N/A Yes - Via Email 52.4577374 -1.9533202
5830 op-snap---monthly-publication-february-2025.pdf   647 2025-02 Pedal Bike   Cupra Black Driving without Due Care and Attention None Greenfield Road Harborne Greenfield Road Harborne Birmingham Birmingham Education N/A Yes - Via Email 52.4577374 -1.9533202
5832 op-snap---monthly-publication-february-2025.pdf   649 2025-02 Pedal Bike Mercedes-Benz GLE Black Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham Court N/A Yes - Via Email 52.4695793 -1.9378608
5834 op-snap---monthly-publication-february-2025.pdf   651 2025-02 Pedal Bike   TX Black Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham Court N/A Yes - Via Email 52.4695793 -1.9378608
5840 op-snap---monthly-publication-february-2025.pdf   657 2025-02 Car Renault Van White Driving without Due Care and Attention None Ladywood Middleway Ladywood Middleway Birmingham Birmingham NFA No VRM Yes - Via Email 52.473883 -1.9198244
5858 op-snap---monthly-publication-february-2025.pdf   675 2025-02 Car Fiat 500 White Driving without Due Care and Attention None Russel Road Russel Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4297153 -1.934958
5929 op-snap---monthly-publication-february-2025.pdf   746 2025-02 Car Volkswagen Tiguan Grey Driving without Due Care and Attention None A456 at M5 Jn3 roundabout A456 at M5 Jn3 roundabout Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4537468 -2.0080889
5934 op-snap---monthly-publication-february-2025.pdf   751 2025-02 Car Toyota Verso Blue Driving without Due Care and Attention None Hawthorne Road Hawthorne Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4195457 -1.9441049
5935 op-snap---monthly-publication-february-2025.pdf   752 2025-02 Car Peugeot Independance Silver Driving without Due Care and Attention None Soho Hill Soho Hill Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4983151 -1.9186252
5937 op-snap---monthly-publication-february-2025.pdf   754 2025-02 Car Toyota AURIS Red Driving without Due Care and Attention None BOOTH STREET Booth Street Birmingham Birmingham Court N/A Yes - Via Email 52.5039035 -1.9447084
5941 op-snap---monthly-publication-february-2025.pdf   758 2025-02 Car Audi Q7 Black Driving without Due Care and Attention None Walter Street Walter Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4973929 -1.8742203
5980 op-snap---monthly-publication-february-2025.pdf   797 2025-02 Car Audi A3 White Driving without Due Care and Attention None A45 Airport and Station Exit Airport and Station Exit Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4474175 -1.735823
5995 op-snap---monthly-publication-february-2025.pdf   812 2025-02 Car Vauxhall VIVARO Grey Driving without Due Care and Attention None LEACH GREEN Leach Green Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.392246 -2.0101736
5999 op-snap---monthly-publication-february-2025.pdf   816 2025-02 Car Volkswagen Golf Blue Driving without Due Care and Attention None Highgate Middleway Highgate Middleway Birmingham Birmingham Court N/A Yes - Via Email 52.4661171 -1.8832818
6002 op-snap---monthly-publication-february-2025.pdf   819 2025-02 Pedal Bike Peugeot 208 Blue Driving without Due Care and Attention None Digbeth High Street Digbeth High Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4745895 -1.8821244
6057 op-snap---monthly-publication-february-2025.pdf   874 2025-02 Other Honda Jazz Green Driving without Due Care and Attention None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A Yes - Via Email 52.5265939 -1.8509884
6097 op-snap---monthly-publication-february-2025.pdf   914 2025-02 Car Vauxhall Corsa Black Driving without Due Care and Attention None Jockey Road Jockey Road Birmingham Birmingham Education N/A Yes - Via Email 52.5512291 -1.8357776
6105 op-snap---monthly-publication-february-2025.pdf   922 2025-02 Car Audi Q3 Silver Driving without Due Care and Attention None M6 South J7-J6 M6 South J7-J6 Birmingham Birmingham Court N/A Yes - Via Email    
6137 op-snap---monthly-publication-february-2025.pdf   954 2025-02 Pedal Bike Toyota MPV Grey Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
6138 op-snap---monthly-publication-february-2025.pdf   955 2025-02 Car Vauxhall Astra Grey Driving without Due Care and Attention None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4327486 -1.8844997
6177 op-snap---monthly-publication-february-2025.pdf   994 2025-02 Pedal Bike Mercedes-Benz A class Grey Driving without Due Care and Attention None Calthorpe Road Calthorpe Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5142235 -1.9073557

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