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

137 rows where month = "2025-05", 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

disposal 5

reporter_transport_mode 1

  • Pedal Bike · 137 ✖

offence 1

  • Driving without Due Care and Attention · 137 ✖

month 1

  • 2025-05 · 137 ✖
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
18695 op-snap---monthly-publication-may-2025.pdf   57 2025-05 Pedal Bike Ford Tourneo Silver Driving without Due Care and Attention None Wherretts Well Lane Wherretts Well Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4225399 -1.763283
18725 op-snap---monthly-publication-may-2025.pdf   87 2025-05 Pedal Bike Peugeot Partner Red Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA No Offence      
18905 op-snap---monthly-publication-may-2025.pdf   267 2025-05 Pedal Bike       Driving without Due Care and Attention None Corporation street Corporation street Walsall Walsall NFA No VRM   52.5773099 -1.9850716
18921 op-snap---monthly-publication-may-2025.pdf   283 2025-05 Pedal Bike BMW X4 Black Driving without Due Care and Attention None Flaxley Road Flaxley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.487709 -1.8077323
19031 op-snap---monthly-publication-may-2025.pdf   393 2025-05 Pedal Bike Ford fiesta White Driving without Due Care and Attention None Kiddiminster road Kiddiminster road Solihull Solihull Fixed Penalty N/A      
19037 op-snap---monthly-publication-may-2025.pdf   399 2025-05 Pedal Bike Ford Transit White Driving without Due Care and Attention None Malvern area Malvern area Out of Force Area Out of Force Area NFA Out of Force      
19038 op-snap---monthly-publication-may-2025.pdf   400 2025-05 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Malvern area Malvern area Out of Force Area Out of Force Area NFA Out of Force      
19054 op-snap---monthly-publication-may-2025.pdf   416 2025-05 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention No Insurance Hinksford Lane Swindon Hinksford Lane Swindon Out of Force Area Out of Force Area NFA Out of Force   52.5079592 -2.1966932
19097 op-snap---monthly-publication-may-2025.pdf   459 2025-05 Pedal Bike Audi TT Silver Driving without Due Care and Attention None BEDWORTH ROAD Bedworth Road Coventry Coventry Education N/A   52.4554838 -1.4848593
19128 op-snap---monthly-publication-may-2025.pdf   490 2025-05 Pedal Bike Toyota Prius Red Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham Warning Letter N/A   52.4299657 -1.9599121
19129 op-snap---monthly-publication-may-2025.pdf   491 2025-05 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham Warning Letter N/A   52.4299657 -1.9599121
19133 op-snap---monthly-publication-may-2025.pdf   495 2025-05 Pedal Bike Ford FIESTA White Driving without Due Care and Attention None Merritts Brook lane Merritts Brook lane Birmingham Birmingham NFA No Offence   52.4159246 -1.9848186
19188 op-snap---monthly-publication-may-2025.pdf   550 2025-05 Pedal Bike Citroen C3 Orange Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4580901 -1.894458
19211 op-snap---monthly-publication-may-2025.pdf   573 2025-05 Pedal Bike BMW 5 series Blue Driving without Due Care and Attention No Insurance Hagley Road Hagley Road Birmingham Birmingham Court N/A   52.471632 -1.9456776
19253 op-snap---monthly-publication-may-2025.pdf   615 2025-05 Pedal Bike Daf Scania White Driving without Due Care and Attention None Damson Parkway Damson Parkway Solihull Solihull Education N/A   52.437016 -1.7578446
19258 op-snap---monthly-publication-may-2025.pdf   620 2025-05 Pedal Bike Volkswagen Golf White Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A   52.4103191 -1.8670224
19266 op-snap---monthly-publication-may-2025.pdf   628 2025-05 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Bond Street Bond Street Birmingham Birmingham Education N/A   52.4305652 -1.9245064
19271 op-snap---monthly-publication-may-2025.pdf   633 2025-05 Pedal Bike Peugeot partner White Driving without Due Care and Attention None George Road George Road Birmingham Birmingham NFA No Offence   52.5155831 -1.8598862
19280 op-snap---monthly-publication-may-2025.pdf   642 2025-05 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No VRM   52.4191184 -1.8326637
19310 op-snap---monthly-publication-may-2025.pdf   672 2025-05 Pedal Bike Renault Master White Driving without Due Care and Attention None Merriden Road Merriden Road Coventry Coventry Education N/A   52.3784069 -1.5583289
19357 op-snap---monthly-publication-may-2025.pdf   719 2025-05 Pedal Bike Renault Kadjar Grey Driving without Due Care and Attention None Bognop Road Bognop Road Wolverhampton Wolverhampton Education N/A      
19360 op-snap---monthly-publication-may-2025.pdf   722 2025-05 Pedal Bike Nissan Leaf Grey Driving without Due Care and Attention None Maidenhead Road Maidenhead Road Dudley Dudley NFA Outside of 14 Days NIP      
19361 op-snap---monthly-publication-may-2025.pdf   723 2025-05 Pedal Bike Suzuki Vitara Red Driving without Due Care and Attention None Mile Flat Mile Flat Dudley Dudley NFA Outside of 14 Days NIP   52.5000458 -2.1979547
19362 op-snap---monthly-publication-may-2025.pdf   724 2025-05 Pedal Bike Citroen DS4 Black Driving without Due Care and Attention None Boleyn Road Boleyn Road Birmingham Birmingham Education N/A   52.4030543 -2.0296756
19381 op-snap---monthly-publication-may-2025.pdf   743 2025-05 Pedal Bike Peugeot Partner Silver Driving without Due Care and Attention None Princethorpe Way Princethorpe Way Coventry Coventry Education N/A   52.3953553 -1.4561037
19382 op-snap---monthly-publication-may-2025.pdf   744 2025-05 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
19396 op-snap---monthly-publication-may-2025.pdf   758 2025-05 Pedal Bike BMW M135I Blue Driving without Due Care and Attention None Mary Vale Road Mary Vale Road Birmingham Birmingham Education N/A   52.425105 -1.9312861
19411 op-snap---monthly-publication-may-2025.pdf   773 2025-05 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Wake Green Road Wake Green Road Birmingham Birmingham Education n/a   52.4437078 -1.8783408
19436 op-snap---monthly-publication-may-2025.pdf   798 2025-05 Pedal Bike Vauxhall Corsa Grey Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4282602 -1.9861769
19437 op-snap---monthly-publication-may-2025.pdf   799 2025-05 Pedal Bike BMW 116d White Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
19438 op-snap---monthly-publication-may-2025.pdf   800 2025-05 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19439 op-snap---monthly-publication-may-2025.pdf   801 2025-05 Pedal Bike BMW M340i Black Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19440 op-snap---monthly-publication-may-2025.pdf   802 2025-05 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Stonehouse Lane Stonehouse Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4440435 -1.9818872
19441 op-snap---monthly-publication-may-2025.pdf   803 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19442 op-snap---monthly-publication-may-2025.pdf   804 2025-05 Pedal Bike Mitsubishi L200 Grey Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
19444 op-snap---monthly-publication-may-2025.pdf   806 2025-05 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Stonehouse Road Stonehouse Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5507024 -1.8418964
19457 op-snap---monthly-publication-may-2025.pdf   819 2025-05 Pedal Bike Ford Fiesta Black Driving without Due Care and Attention None High Street High Street Sandwell Sandwell Education N/A   52.5128738 -1.9842054
19460 op-snap---monthly-publication-may-2025.pdf   822 2025-05 Pedal Bike Mini Cooper Green Driving without Due Care and Attention None Bickenhall Lane Bickenhall Lane Birmingham Birmingham Education N/A      
19483 op-snap---monthly-publication-may-2025.pdf   845 2025-05 Pedal Bike Audi A3 White Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Education N/A   52.4073149 -1.5250454
19500 op-snap---monthly-publication-may-2025.pdf   862 2025-05 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
19501 op-snap---monthly-publication-may-2025.pdf   863 2025-05 Pedal Bike Peugeot 508 White Driving without Due Care and Attention None Slade Road Slade Road Birmingham Birmingham Education N/A   52.5894461 -1.8082962
19502 op-snap---monthly-publication-may-2025.pdf   864 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Fairfax Street Fairfax Street Coventry Coventry NFA Outside of 14 Days NIP   52.4097547 -1.5065519
19513 op-snap---monthly-publication-may-2025.pdf   875 2025-05 Pedal Bike Peugeot 3008 White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
19536 op-snap---monthly-publication-may-2025.pdf   898 2025-05 Pedal Bike BMW M2.. Black Driving without Due Care and Attention None A38 Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
19541 op-snap---monthly-publication-may-2025.pdf   903 2025-05 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Yardley Wood Rd Yardley Wood Road Birmingham Birmingham Education N/A   52.4103191 -1.8670224
19561 op-snap---monthly-publication-may-2025.pdf   923 2025-05 Pedal Bike Ford Fiesta Grey Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Education N/A   52.4624743 -1.7763934
19591 op-snap---monthly-publication-may-2025.pdf   953 2025-05 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham Education N/A   52.4580901 -1.894458
19596 op-snap---monthly-publication-may-2025.pdf   958 2025-05 Pedal Bike Land Rover Discovery Grey Driving without Due Care and Attention None Monkspath Road Monkspath Road Solihull Solihull Education N/A   52.3909753 -1.8020771
19601 op-snap---monthly-publication-may-2025.pdf   963 2025-05 Pedal Bike Audi A5.. Grey Driving without Due Care and Attention None Harbourne Road Harborne Road Birmingham Birmingham Education N/A   52.4718503 -1.9195423
19602 op-snap---monthly-publication-may-2025.pdf   964 2025-05 Pedal Bike Vauxhall Insignia Black Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
19603 op-snap---monthly-publication-may-2025.pdf   965 2025-05 Pedal Bike Audi A1.. White Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham Education N/A   52.4695793 -1.9378608
19605 op-snap---monthly-publication-may-2025.pdf   967 2025-05 Pedal Bike Audi A6 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
19606 op-snap---monthly-publication-may-2025.pdf   968 2025-05 Pedal Bike Citroen C4 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
19608 op-snap---monthly-publication-may-2025.pdf   970 2025-05 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
19612 op-snap---monthly-publication-may-2025.pdf   974 2025-05 Pedal Bike Volvo V70... Green Driving without Due Care and Attention none B4102 Meriden Road Meriden Road Solihull Solihull Education N/A   52.4137518 -1.6414448
19631 op-snap---monthly-publication-may-2025.pdf   993 2025-05 Pedal Bike Land Rover Range Rover Black Driving without Due Care and Attention VRM fails to conform t oB oRredgeusllaetyio mnsiddleway o B o Rredgeusllaetyio mnsiddleway Birmingham Birmingham Court N/A      
19632 op-snap---monthly-publication-may-2025.pdf   994 2025-05 Pedal Bike   Saab Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
19633 op-snap---monthly-publication-may-2025.pdf   995 2025-05 Pedal Bike Audi A4 Grey Driving without Due Care and Attention None Dartmouth Circus Dartmouth Circus Birmingham Birmingham Education N/A   52.4926487 -1.8879638
19634 op-snap---monthly-publication-may-2025.pdf   996 2025-05 Pedal Bike BMW 220 Blue Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
19643 op-snap---monthly-publication-may-2025.pdf   1005 2025-05 Pedal Bike Volvo HGV Green Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
19644 op-snap---monthly-publication-may-2025.pdf   1006 2025-05 Pedal Bike Ford C-Max Blue Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
19665 op-snap---monthly-publication-may-2025.pdf   1027 2025-05 Pedal Bike Toyota   White Driving without Due Care and Attention None Station Road, Marston Green Station Road, Marston Green Birmingham Birmingham Education N/A      
19666 op-snap---monthly-publication-may-2025.pdf   1028 2025-05 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Woodclose Rd Woodclose Road Birmingham Birmingham Warning Letter N/A      
19673 op-snap---monthly-publication-may-2025.pdf   1035 2025-05 Pedal Bike Citroen DS3 White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
19681 op-snap---monthly-publication-may-2025.pdf   1043 2025-05 Pedal Bike BMW X1 Blue Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19682 op-snap---monthly-publication-may-2025.pdf   1044 2025-05 Pedal Bike Mercedes-Benz GLB Silver Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19683 op-snap---monthly-publication-may-2025.pdf   1045 2025-05 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
19684 op-snap---monthly-publication-may-2025.pdf   1046 2025-05 Pedal Bike Peugeot Royal Mail Red Driving without Due Care and Attention None Cox Street Cox Street Coventry Coventry Education N/A   52.4092228 -1.5034119
19902 op-snap---monthly-publication-may-2025.pdf   1264 2025-05 Pedal Bike Vauxhall NP White Driving without Due Care and Attention None Birmingham road, A5127 Birmingham road, A5127 Birmingham Birmingham NFA Outside of 14 Days NIP   52.5519132 -1.8267718
19903 op-snap---monthly-publication-may-2025.pdf   1265 2025-05 Pedal Bike Renault NP Grey Driving without Due Care and Attention None hoggs lane, frankley Hoggs Lane, Frankley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4158643 -1.9846878
19904 op-snap---monthly-publication-may-2025.pdf   1266 2025-05 Pedal Bike Mini NP Red Driving without Due Care and Attention None JCT Dimsdale road JCT Dimsdale road Birmingham Birmingham NFA Outside of 14 Days NIP      
19905 op-snap---monthly-publication-may-2025.pdf   1267 2025-05 Pedal Bike Mini NP Red Driving without Due Care and Attention None jct frankley beeches road Jct Frankley Beeches Road Birmingham Birmingham NFA Outside of 14 Days NIP      
19907 op-snap---monthly-publication-may-2025.pdf   1269 2025-05 Pedal Bike Renault NP White Driving without Due Care and Attention None RAB A38, lickey road RAB A38, lickey road Birmingham Birmingham NFA Outside of 14 Days NIP      
19914 op-snap---monthly-publication-may-2025.pdf   1276 2025-05 Pedal Bike Vauxhall Combo White Driving without Due Care and Attention None JTC cock hll lane/sandstone avenue JTC cock hll lane/sandstone avenue Birmingham Birmingham NFA Outside of 14 Days NIP      
19933 op-snap---monthly-publication-may-2025.pdf   1295 2025-05 Pedal Bike Mitsubishi L200 Black Driving without Due Care and Attention None holyhead road Holyhead Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5967563 -2.1605854
19953 op-snap---monthly-publication-may-2025.pdf   1315 2025-05 Pedal Bike Daf Truck White Driving without Due Care and Attention None Chester road Chester road Walsall Walsall NFA Outside of 14 Days NIP   52.5692139 -1.8799672
19981 op-snap---monthly-publication-may-2025.pdf   1343 2025-05 Pedal Bike Audi S4 Estate Grey Driving without Due Care and Attention None Tile house green lane Tile house green lane Solihull Solihull NFA Outside of 14 Days NIP      
19986 op-snap---monthly-publication-may-2025.pdf   1348 2025-05 Pedal Bike Kia Creed Silver Driving without Due Care and Attention None Stoney stanton road Stoney stanton road Coventry Coventry NFA Outside of 14 Days NIP   52.4221152 -1.4959475
19990 op-snap---monthly-publication-may-2025.pdf   1352 2025-05 Pedal Bike Mercedes-Benz ML250 Silver Driving without Due Care and Attention None Stoney Stanton road Stoney Stanton road Coventry Coventry NFA Outside of 14 Days NIP   52.4221152 -1.4959475
19994 op-snap---monthly-publication-may-2025.pdf   1356 2025-05 Pedal Bike Land Rover NP Silver Driving without Due Care and Attention None Spring lane Spring lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.5182019 -1.8336169
19995 op-snap---monthly-publication-may-2025.pdf   1357 2025-05 Pedal Bike Seat Leon Grey Driving without Due Care and Attention None Pedmore lane Pedmore lane Dudley Dudley NFA Outside of 14 Days NIP   52.4380762 -2.1151301
20000 op-snap---monthly-publication-may-2025.pdf   1362 2025-05 Pedal Bike BMW 600 SERIES Blue Driving without Due Care and Attention None jtc with barns lane Jtc With Barns Lane Walsall Walsall NFA Outside of 14 Days NIP      
20020 op-snap---monthly-publication-may-2025.pdf   1382 2025-05 Pedal Bike Honda jazz Silver Driving without Due Care and Attention None Bescot Crescent road Bescot Crescent road Walsall Walsall NFA Outside of 14 Days NIP   52.575204 -1.9916288
20047 op-snap---monthly-publication-may-2025.pdf   1409 2025-05 Pedal Bike Volkswagen np Black Driving without Due Care and Attention None four oaks road Four Oaks Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5840096 -1.8355803
20048 op-snap---monthly-publication-may-2025.pdf   1410 2025-05 Pedal Bike   np Black Driving without Due Care and Attention None selly park Selly Park Birmingham Birmingham NFA Outside of 14 Days NIP   52.4440464 -1.9204327
20049 op-snap---monthly-publication-may-2025.pdf   1411 2025-05 Pedal Bike   NP White Driving without Due Care and Attention None gay hill lane Gay Hill Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4012688 -1.9184744
20050 op-snap---monthly-publication-may-2025.pdf   1412 2025-05 Pedal Bike   np Purple Driving without Due Care and Attention None Northfield road Northfield road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
20053 op-snap---monthly-publication-may-2025.pdf   1415 2025-05 Pedal Bike Mg 4x4 White Driving without Due Care and Attention None northfield road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
20054 op-snap---monthly-publication-may-2025.pdf   1416 2025-05 Pedal Bike   Transit van Grey Driving without Due Care and Attention None northfield road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
20059 op-snap---monthly-publication-may-2025.pdf   1421 2025-05 Pedal Bike Mazda np Blue Driving without Due Care and Attention None junction with B4135 , heath street junction with B4135 , heath street Birmingham Birmingham NFA Outside of 14 Days NIP      
20063 op-snap---monthly-publication-may-2025.pdf   1425 2025-05 Pedal Bike Mercedes-Benz Benz Red Driving without Due Care and Attention None kenilworth road Kenilworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5124557 -1.8917609
20064 op-snap---monthly-publication-may-2025.pdf   1426 2025-05 Pedal Bike Mercedes-Benz Benz Blue Driving without Due Care and Attention None russell road Russell Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4398245 -1.8469786
20069 op-snap---monthly-publication-may-2025.pdf   1431 2025-05 Pedal Bike Citroen NP Red Driving without Due Care and Attention None Moor green lane road Moor green lane road Birmingham Birmingham NFA Outside of 14 Days NIP   52.442442 -1.8924975
20088 op-snap---monthly-publication-may-2025.pdf   1450 2025-05 Pedal Bike   Victory hammers Black Driving without Due Care and Attention None Corporation street Corporation street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4895456 -1.8900666
20104 op-snap---monthly-publication-may-2025.pdf   1466 2025-05 Pedal Bike Peugeot Canal and river t rBuslute Driving without Due Care and Attention None Birmingham road Birmingham road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5461417 -1.9334193
20118 op-snap---monthly-publication-may-2025.pdf   1480 2025-05 Pedal Bike Nissan NP Silver Driving without Due Care and Attention None Castle hill road Castle hill road Out of Force Area Out of Force Area NFA Out of Force   52.4688431 -1.9992051
20148 op-snap---monthly-publication-may-2025.pdf   1510 2025-05 Pedal Bike Toyota corolla Silver Driving without Due Care and Attention None Cateswell Road Cateswell Road Birmingham Birmingham NFA Misc Inc Crimes   52.4387009 -1.8454267
20149 op-snap---monthly-publication-may-2025.pdf   1511 2025-05 Pedal Bike Ford focus Silver Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham Warning Letter N/A   52.5148331 -1.79231
20154 op-snap---monthly-publication-may-2025.pdf   1516 2025-05 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Shidas Lane Shidas Lane Sandwell Sandwell Warning Letter N/A   52.501103 -2.0254412
20159 op-snap---monthly-publication-may-2025.pdf   1521 2025-05 Pedal Bike Audi q7 White Driving without Due Care and Attention None Price Street Price Street Sandwell Sandwell Warning Letter N/A   52.5173895 -1.9973426

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