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

172 rows where disposal = "NFA", month = "2025-04" and offence = "Cause vehicle to be left in a dangerous position" 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

reporter_transport_mode 4

offence 1

  • Cause vehicle to be left in a dangerous position · 172 ✖

month 1

  • 2025-04 · 172 ✖

disposal 1

  • NFA · 172 ✖
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
247 op-snap---monthly-publication-april-2025.pdf   246 2025-04 Pedal Bike Vauxhall Astra Silver Cause vehicle to be left in a dangerous position None Beverley Court Road Beverley Court Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.460932 -1.999684
307 op-snap---monthly-publication-april-2025.pdf   306 2025-04 Pedestrian Ford Fiesta Black Cause vehicle to be left in a dangerous position None Petersfield Road Petersfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4307 -1.8494663
308 op-snap---monthly-publication-april-2025.pdf   307 2025-04 Pedestrian Volkswagen Passat Black Cause vehicle to be left in a dangerous position None Petersfield Road Petersfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4307 -1.8494663
332 op-snap---monthly-publication-april-2025.pdf   331 2025-04 Pedestrian Mercedes-Benz Sprinter White Cause vehicle to be left in a dangerous position None Coverdale Road Coverdale Road Solihull Solihull NFA Outside of 14 Days NIP   52.452017 -1.7918994
340 op-snap---monthly-publication-april-2025.pdf   339 2025-04 Pedal Bike Volkswagen Passat Black Cause vehicle to be left in a dangerous position None Chantry Road Chantry Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4496376 -1.8915224
364 op-snap---monthly-publication-april-2025.pdf   363 2025-04 Car Ford Puma Black Cause vehicle to be left in a dangerous position None Darwin Street Darwin Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.468128 -1.8848315
374 op-snap---monthly-publication-april-2025.pdf   373 2025-04 Car BMW 320i Blue Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4929304 -1.8229092
382 op-snap---monthly-publication-april-2025.pdf   381 2025-04 Car Honda Civic Black Cause vehicle to be left in a dangerous position None Naseby Drive Naseby Drive Birmingham Birmingham NFA Outside of 14 Days NIP      
383 op-snap---monthly-publication-april-2025.pdf   382 2025-04 Pedestrian Mercedes-Benz E200 Black Cause vehicle to be left in a dangerous position None Chesterwood Road Chesterwood Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.425486 -1.8853886
407 op-snap---monthly-publication-april-2025.pdf   406 2025-04 Other Mercedes-Benz E220 White Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
416 op-snap---monthly-publication-april-2025.pdf   415 2025-04 Car Volvo V70 Grey Cause vehicle to be left in a dangerous position None Meriden Road Meriden Road Coventry Coventry NFA Outside of 14 Days NIP   52.4233575 -1.4380372
420 op-snap---monthly-publication-april-2025.pdf   419 2025-04 Pedestrian Jaguar X Type Black Cause vehicle to be left in a dangerous position None Hazlehurst Rd Hazlehurst Road BOiurmt oinf gFhoarmce Boiurmt Oinf Gfhoarmce NFA Outside of 14 Days NIP      
447 op-snap---monthly-publication-april-2025.pdf   446 2025-04 Pedal Bike Mercedes-Benz 300 Black Cause vehicle to be left in a dangerous position None Berwood Road Berwood Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5342947 -1.8155375
537 op-snap---monthly-publication-april-2025.pdf   536 2025-04 Pedestrian Vauxhall Corsa Red Cause vehicle to be left in a dangerous position None Colmore Road Colmore Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4296373 -1.8993161
589 op-snap---monthly-publication-april-2025.pdf   588 2025-04 Pedestrian Ford Kuga Grey Cause vehicle to be left in a dangerous position None Halford Lane Halford Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
614 op-snap---monthly-publication-april-2025.pdf   613 2025-04 Car BMW 116i White Cause vehicle to be left in a dangerous position None Heath Crst Heath Crst Coventry Coventry NFA Outside of 14 Days NIP      
644 op-snap---monthly-publication-april-2025.pdf   643 2025-04 Pedal Bike Volkswagen Polo Silver Cause vehicle to be left in a dangerous position None Station Road Station Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5054559 -1.9506109
820 op-snap---monthly-publication-april-2025.pdf   819 2025-04 Pedestrian Mini Countryman Blue Cause vehicle to be left in a dangerous position None Gayfield Avenue Gayfield Avenue Dudley Dudley NFA Outside of 14 Days NIP   52.4693896 -2.1251602
830 op-snap---monthly-publication-april-2025.pdf   829 2025-04 Pedal Bike   Smart Silver Cause vehicle to be left in a dangerous position none Divot Drive , Frankley Divot Drive , Frankley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4082257 -1.9923005
831 op-snap---monthly-publication-april-2025.pdf   830 2025-04 Pedal Bike Toyota Estima White Cause vehicle to be left in a dangerous position none Norrington Road Birmingham Norrington Road Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4099675 -1.9934379
833 op-snap---monthly-publication-april-2025.pdf   832 2025-04 Pedestrian Volkswagen   Silver Cause vehicle to be left in a dangerous position none Harbourne Lane , Birmingham Harbourne Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
858 op-snap---monthly-publication-april-2025.pdf   857 2025-04 Pedal Bike Land Rover   White Cause vehicle to be left in a dangerous position None Gayfield Avenue , Brierley Hill Gayfield Avenue , Brierley Hill Dudley Dudley NFA Outside of 14 Days NIP   52.4693896 -2.1251602
861 op-snap---monthly-publication-april-2025.pdf   860 2025-04 Car Mg   Black Cause vehicle to be left in a dangerous position None Gayfield Avenue , Brierley Hill Gayfield Avenue , Brierley Hill Dudley Dudley NFA Outside of 14 Days NIP   52.4693896 -2.1251602
863 op-snap---monthly-publication-april-2025.pdf   862 2025-04 Pedestrian Mercedes-Benz   Black Cause vehicle to be left in a dangerous position None Moor Green Lane , Birmingham Moor Green Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4377484 -1.9109884
864 op-snap---monthly-publication-april-2025.pdf   863 2025-04 Pedestrian Mercedes-Benz   Silver Cause vehicle to be left in a dangerous position None Corner of Moor Green lane , Birmingham Corner of Moor Green lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
869 op-snap---monthly-publication-april-2025.pdf   868 2025-04 Pedestrian Vauxhall   White Cause vehicle to be left in a dangerous position None Slade Road , Colley gate Slade Road , Colley gate Dudley Dudley NFA Outside of 14 Days NIP      
875 op-snap---monthly-publication-april-2025.pdf   874 2025-04 Car BMW   White Cause vehicle to be left in a dangerous position None The Oval School The Oval School Birmingham Birmingham NFA Outside of 14 Days NIP   52.4801359 -1.7963993
877 op-snap---monthly-publication-april-2025.pdf   876 2025-04 Car Skoda   Grey Cause vehicle to be left in a dangerous position None Springfield Road , Birmingham Springfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4348104 -1.887573
878 op-snap---monthly-publication-april-2025.pdf   877 2025-04 Car Vauxhall   White Cause vehicle to be left in a dangerous position None Mary Vale Road , Birmingham Mary Vale Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.425105 -1.9312861
879 op-snap---monthly-publication-april-2025.pdf   878 2025-04 Car Vauxhall   White Cause vehicle to be left in a dangerous position None Mary Vale Road , Birmingham Mary Vale Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.425105 -1.9312861
890 op-snap---monthly-publication-april-2025.pdf   889 2025-04 Car Nissan   Black Cause vehicle to be left in a dangerous position None Glenville Drive , Birmingham Glenville Drive , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
891 op-snap---monthly-publication-april-2025.pdf   890 2025-04 Car Volkswagen   Black Cause vehicle to be left in a dangerous position None Glenville drive , Birmingham Glenville drive , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
894 op-snap---monthly-publication-april-2025.pdf   893 2025-04 Car Honda   Blue Cause vehicle to be left in a dangerous position None Glenville Drive , Birmingham Glenville Drive , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
900 op-snap---monthly-publication-april-2025.pdf   899 2025-04 Car Ford   Black Cause vehicle to be left in a dangerous position None Windsor Street , Birmingham Windsor Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4897606 -1.8829894
907 op-snap---monthly-publication-april-2025.pdf   906 2025-04 Car Nissan   Blue Cause vehicle to be left in a dangerous position None Alcester Road , Birmingham Alcester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.452635 -1.8874738
916 op-snap---monthly-publication-april-2025.pdf   915 2025-04 Car Volkswagen Life Grey Cause vehicle to be left in a dangerous position None Junstion of Spring Lane and Farm Road , Birmingham Junstion of Spring Lane and Farm Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
917 op-snap---monthly-publication-april-2025.pdf   916 2025-04 Car Ford   Black Cause vehicle to be left in a dangerous position None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
918 op-snap---monthly-publication-april-2025.pdf   917 2025-04 Car Volkswagen Transporter White Cause vehicle to be left in a dangerous position None High Street , Tetenhall High Street , Tetenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
919 op-snap---monthly-publication-april-2025.pdf   918 2025-04 Car Volkswagen   Red Cause vehicle to be left in a dangerous position None Washwood heath Road , Birmingham Washwood heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
942 op-snap---monthly-publication-april-2025.pdf   941 2025-04 Car BMW   Grey Cause vehicle to be left in a dangerous position None Wensley Road , Birmingham Wensley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4609736 -1.7959487
943 op-snap---monthly-publication-april-2025.pdf   942 2025-04 Car Nissan   Grey Cause vehicle to be left in a dangerous position None Lyndon Road , Birmingham Lyndon Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4843621 -1.8083355
945 op-snap---monthly-publication-april-2025.pdf   944 2025-04 Pedestrian Ford Focus Blue Cause vehicle to be left in a dangerous position None Lyndon Road , Birmingham Lyndon Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4843621 -1.8083355
959 op-snap---monthly-publication-april-2025.pdf   958 2025-04 Car Ford   Grey Cause vehicle to be left in a dangerous position None Popular Road , Kings heath Popular Road , Kings heath Birmingham Birmingham NFA Outside of 14 Days NIP      
964 op-snap---monthly-publication-april-2025.pdf   963 2025-04 Car Porsche   Black Cause vehicle to be left in a dangerous position None     Halesowen Halesowen NFA Outside of 14 Days NIP      
970 op-snap---monthly-publication-april-2025.pdf   969 2025-04 Car Toyota   Silver Cause vehicle to be left in a dangerous position None St Bernards Road , Solihull Street Bernards Road , Solihull Solihull Solihull NFA Outside of 14 Days NIP      
971 op-snap---monthly-publication-april-2025.pdf   970 2025-04 Car Mini Cooper   Cause vehicle to be left in a dangerous position None Vittoria Street , Birmingham Vittoria Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4865378 -1.9112801
976 op-snap---monthly-publication-april-2025.pdf   975 2025-04 Car Nissan   White Cause vehicle to be left in a dangerous position None Highwood Avenue , SOlihull Highwood Avenue , SOlihull Solihull Solihull NFA Outside of 14 Days NIP   52.4385191 -1.78891
989 op-snap---monthly-publication-april-2025.pdf   988 2025-04 Car Seat   Grey Cause vehicle to be left in a dangerous position None Halford Lane , Coventry Halford Lane , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4398231 -1.526811
1004 op-snap---monthly-publication-april-2025.pdf   1003 2025-04 Car Mazda   Grey Cause vehicle to be left in a dangerous position None High Street , Kings Heath High Street , Kings Heath Birmingham Birmingham NFA Outside of 14 Days NIP   52.4375456 -1.8926849
1007 op-snap---monthly-publication-april-2025.pdf   1006 2025-04 Pedal Bike Seat   Grey Cause vehicle to be left in a dangerous position None Bradford Street , Birmingham Bradford Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4744205 -1.8886758
1008 op-snap---monthly-publication-april-2025.pdf   1007 2025-04 Pedal Bike Volkswagen   Silver Cause vehicle to be left in a dangerous position None Bradford Street , Birmingham Bradford Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4744205 -1.8886758
1018 op-snap---monthly-publication-april-2025.pdf   1017 2025-04 Car Audi   Black Cause vehicle to be left in a dangerous position None Orphange road , Birmingham Orphange road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1019 op-snap---monthly-publication-april-2025.pdf   1018 2025-04 Pedal Bike Audi A6 Silver Cause vehicle to be left in a dangerous position None Stoney STanton Road , Coventry Stoney STanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1020 op-snap---monthly-publication-april-2025.pdf   1019 2025-04 Car Honda   Red Cause vehicle to be left in a dangerous position None High Street , Harbourne High Street , Harbourne Birmingham Birmingham NFA Outside of 14 Days NIP      
1021 op-snap---monthly-publication-april-2025.pdf   1020 2025-04 Pedal Bike Volkswagen Golf Grey Cause vehicle to be left in a dangerous position None Stoney STanton Road , Coventry Stoney STanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1022 op-snap---monthly-publication-april-2025.pdf   1021 2025-04 Pedal Bike Suzuki Hatch White Cause vehicle to be left in a dangerous position None Briton Road , Coventry Briton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.412783 -1.480642
1037 op-snap---monthly-publication-april-2025.pdf   1036 2025-04 Car Nissan SUV Black Cause vehicle to be left in a dangerous position None Naseby Drive , Halesowen Naseby Drive , Halesowen Halesowen Halesowen NFA Outside of 14 Days NIP      
1042 op-snap---monthly-publication-april-2025.pdf   1041 2025-04 Pedestrian Volkswagen Caddy White Cause vehicle to be left in a dangerous position None Lavender Farm Nursery , bookfields Road , Oldbury Lavender Farm Nursery , bookfields Road , Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP      
1048 op-snap---monthly-publication-april-2025.pdf   1047 2025-04 Car   Unknown Silver Cause vehicle to be left in a dangerous position None Stoney stanton Road , Coventry Stoney stanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1058 op-snap---monthly-publication-april-2025.pdf   1057 2025-04 Car Seat Ibiza Blue Cause vehicle to be left in a dangerous position None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1061 op-snap---monthly-publication-april-2025.pdf   1060 2025-04 Car   NP Black Cause vehicle to be left in a dangerous position None All Saints Road , Birmingham All Saints Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4918459 -1.9192303
1068 op-snap---monthly-publication-april-2025.pdf   1067 2025-04 Pedestrian Volvo   Silver Cause vehicle to be left in a dangerous position None All Saints Road , Kings Heath All Saints Road , Kings Heath Birmingham Birmingham NFA Outside of 14 Days NIP   52.4312552 -1.8943977
1085 op-snap---monthly-publication-april-2025.pdf   1084 2025-04 Car Renault   White Cause vehicle to be left in a dangerous position None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1086 op-snap---monthly-publication-april-2025.pdf   1085 2025-04 Car Volkswagen   White Cause vehicle to be left in a dangerous position None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1088 op-snap---monthly-publication-april-2025.pdf   1087 2025-04 Car Ford Focus Blue Cause vehicle to be left in a dangerous position None Lozells Road , Birmingham Lozells Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5025035 -1.8998926
1089 op-snap---monthly-publication-april-2025.pdf   1088 2025-04 Car Hyundai Ionic Black Cause vehicle to be left in a dangerous position None Lozells Road , Birmingham Lozells Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5025035 -1.8998926
1090 op-snap---monthly-publication-april-2025.pdf   1089 2025-04 Car Nissan   Red Cause vehicle to be left in a dangerous position None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1091 op-snap---monthly-publication-april-2025.pdf   1090 2025-04 Pedestrian Volkswagen   Grey Cause vehicle to be left in a dangerous position None     Halesowen Halesowen NFA Outside of 14 Days NIP      
1092 op-snap---monthly-publication-april-2025.pdf   1091 2025-04 Car Toyota   White Cause vehicle to be left in a dangerous position None     Halesowen Halesowen NFA Outside of 14 Days NIP      
1093 op-snap---monthly-publication-april-2025.pdf   1092 2025-04 Pedestrian Ford KA Black Cause vehicle to be left in a dangerous position None Naseby drive , Halesowen Naseby drive , Halesowen Halesowen Halesowen NFA Outside of 14 Days NIP      
1094 op-snap---monthly-publication-april-2025.pdf   1093 2025-04 Car Audi   Blue Cause vehicle to be left in a dangerous position None Washwood heath Road , Birmingham Washwood heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1096 op-snap---monthly-publication-april-2025.pdf   1095 2025-04 Car Volkswagen   White Cause vehicle to be left in a dangerous position None Ashdale drive , Birmingham Ashdale drive , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4027335 -1.876125
1099 op-snap---monthly-publication-april-2025.pdf   1098 2025-04 Car Volkswagen   Grey Cause vehicle to be left in a dangerous position none Warwick Road , Birmingham Warwick Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.551985 -1.860445
1102 op-snap---monthly-publication-april-2025.pdf   1101 2025-04 Car Toyota   Grey Cause vehicle to be left in a dangerous position None Warwick Road , Birmingham Warwick Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.551985 -1.860445
1104 op-snap---monthly-publication-april-2025.pdf   1103 2025-04 Car Honda   Grey Cause vehicle to be left in a dangerous position None Addison Road , Birminghman Addison Road , Birminghman Birmingham Birmingham NFA Outside of 14 Days NIP      
1106 op-snap---monthly-publication-april-2025.pdf   1105 2025-04 Car Toyota   Blue Cause vehicle to be left in a dangerous position None Fallows Road , Birmingham Fallows Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4613056 -1.8636034
1110 op-snap---monthly-publication-april-2025.pdf   1109 2025-04 Car Volkswagen   White Cause vehicle to be left in a dangerous position None Washwood heath Road , Birmingham Washwood heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1112 op-snap---monthly-publication-april-2025.pdf   1111 2025-04 Car   Polestar Black Cause vehicle to be left in a dangerous position None Moseley Road , Birmingham Moseley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4622719 -1.8838349
1119 op-snap---monthly-publication-april-2025.pdf   1118 2025-04 Pedestrian Tesla   White Cause vehicle to be left in a dangerous position None Grange Road , Dorridge Grange Road , Dorridge Coventry Coventry NFA No Independent Evidence Available      
1124 op-snap---monthly-publication-april-2025.pdf   1123 2025-04 Car Volvo XC60 Silver Cause vehicle to be left in a dangerous position None Clent Road , Oldbury Clent Road , Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.4796168 -1.9761642
1126 op-snap---monthly-publication-april-2025.pdf   1125 2025-04 Car Toyota   White Cause vehicle to be left in a dangerous position None Coventry road , Birmingham Coventry road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4513272 -1.7638967
1127 op-snap---monthly-publication-april-2025.pdf   1126 2025-04 Car Ford Transit White Cause vehicle to be left in a dangerous position None Avon Street , Birmingham Avon Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4556565 -1.8643304
1128 op-snap---monthly-publication-april-2025.pdf   1127 2025-04 Car Toyota   White Cause vehicle to be left in a dangerous position None Wychwood Crescent , Birmingham Wychwood Crescent , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4597489 -1.7936546
1129 op-snap---monthly-publication-april-2025.pdf   1128 2025-04 Car Nissan   Black Cause vehicle to be left in a dangerous position None Brays Road , Birmingham Brays Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4602629 -1.7875818
1130 op-snap---monthly-publication-april-2025.pdf   1129 2025-04 Car Mazda   Blue Cause vehicle to be left in a dangerous position No vehicle excise licence Coventry Road , Birmingham Coventry Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4513272 -1.7638967
1133 op-snap---monthly-publication-april-2025.pdf   1132 2025-04 Pedestrian Peugeot   Silver Cause vehicle to be left in a dangerous position None Faulkner Road , Birmingham Faulkner Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4431157 -1.929785
1134 op-snap---monthly-publication-april-2025.pdf   1133 2025-04 Car Seat   Blue Cause vehicle to be left in a dangerous position None Springfield Road , Birmingham Springfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4348104 -1.887573
1136 op-snap---monthly-publication-april-2025.pdf   1135 2025-04 Car Skoda   White Cause vehicle to be left in a dangerous position None Springfield Road , Birmingham Springfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4348104 -1.887573
1146 op-snap---monthly-publication-april-2025.pdf   1145 2025-04 Car Kia Stonic Yellow Cause vehicle to be left in a dangerous position None Wake Green Road , Birmingham Wake Green Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4437078 -1.8783408
1147 op-snap---monthly-publication-april-2025.pdf   1146 2025-04 Car Ford Zetec Black Cause vehicle to be left in a dangerous position None Wake Green Road , Birmingham Wake Green Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4437078 -1.8783408
1148 op-snap---monthly-publication-april-2025.pdf   1147 2025-04 Car Mg   Black Cause vehicle to be left in a dangerous position None Gayfield Ave , Brierley Hill Gayfield Ave , Brierley Hill Dudley Dudley NFA Outside of 14 Days NIP   52.4693896 -2.1251602
1150 op-snap---monthly-publication-april-2025.pdf   1149 2025-04 Car Ford Zetec Black Cause vehicle to be left in a dangerous position None Wake Green Road , Birmingham Wake Green Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4437078 -1.8783408
1151 op-snap---monthly-publication-april-2025.pdf   1150 2025-04 Car Ford   Silver Cause vehicle to be left in a dangerous position None Swanhurst Lane , Birmingham Swanhurst Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1152 op-snap---monthly-publication-april-2025.pdf   1151 2025-04 Car Toyota OPrius Grey Cause vehicle to be left in a dangerous position None Beechmount Drive , Birmingham Beechmount Drive , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5318064 -1.8324021
1153 op-snap---monthly-publication-april-2025.pdf   1152 2025-04 Car BMW   Silver Cause vehicle to be left in a dangerous position none Bordesley Green East , Birmingham Bordesley Green East , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.480482 -1.8298289
1155 op-snap---monthly-publication-april-2025.pdf   1154 2025-04 Car Ford   White Cause vehicle to be left in a dangerous position none Poplar Road , Birmingham Poplar Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.436035 -1.891685
1157 op-snap---monthly-publication-april-2025.pdf   1156 2025-04 Pedestrian Mercedes-Benz   Silver Cause vehicle to be left in a dangerous position None     Coventry Coventry NFA Outside of 14 Days NIP      
1160 op-snap---monthly-publication-april-2025.pdf   1159 2025-04 Car   NP Black Cause vehicle to be left in a dangerous position None Allens Croft Road , Birmingham Allens Croft Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4242527 -1.910803
1162 op-snap---monthly-publication-april-2025.pdf   1161 2025-04 Car   NP Grey Cause vehicle to be left in a dangerous position None Allans Croft Road , Birmingham Allans Croft Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1163 op-snap---monthly-publication-april-2025.pdf   1162 2025-04 Pedestrian   Van White Cause vehicle to be left in a dangerous position None Junction of Epwell Road , Birmingham Junction of Epwell Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      

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