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

114 rows where disposal = "NFA", offence = "Contravening a Red Traffic Light" and reporter_transport_mode = "Pedestrian" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Pedestrian · 114 ✖

offence 1

  • Contravening a Red Traffic Light · 114 ✖

disposal 1

  • NFA · 114 ✖
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
8048 op-snap---monthly-publication-february-2026.pdf   795 2026-02 Pedestrian Vauxhall Mokka Grey Contravening a Red Traffic Light None Stratford Upon Avon Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force   52.3499075 -1.7812051
8699 op-snap---monthly-publication-february-2026.pdf   1446 2026-02 Pedestrian Toyota   Black Contravening a Red Traffic Light None Cole Bank Road Cole Bank Road Birmingham Birmingham NFA No Independent Evidence Available   52.4349375 -1.8510007
10954 op-snap---monthly-publication-january-2026.pdf   415 2026-01 Pedestrian Fiat 500 White Contravening a Red Traffic Light None Chester Road North Chester Road North Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.548449 -1.8594603
3905 op-snap---monthly-publication-december-2025.pdf   33 2025-12 Pedestrian Volkswagen Crafter White Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
3906 op-snap---monthly-publication-december-2025.pdf   34 2025-12 Pedestrian Ford Fiesta White Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
3907 op-snap---monthly-publication-december-2025.pdf   35 2025-12 Pedestrian Mercedes-Benz   Grey Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
22026 op-snap---monthly-publication-november-2025.pdf   1568 2025-11 Pedestrian Volkswagen   Black Contravening a Red Traffic Light None Hill Street Hill Street Birmingham Birmingham NFA No VRM   52.4777765 -1.901321
22076 op-snap---monthly-publication-october-2025.pdf   26 2025-10 Pedestrian Ford Transit Grey Contravening a Red Traffic Light None Raynor Road Raynor Road Wolverhampton Wolverhampton NFA No Offence   52.6043868 -2.1046385
22427 op-snap---monthly-publication-october-2025.pdf   377 2025-10 Pedestrian Ford Transit blue Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
22486 op-snap---monthly-publication-october-2025.pdf   436 2025-10 Pedestrian Hyundai I10 Red Contravening a Red Traffic Light None Berwick Road, Shrewsbury Berwick Road, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
24342 op-snap---monthly-publication-september-2025.pdf   561 2025-09 Pedestrian BMW 335D Black Contravening a Red Traffic Light None Bunbury Road, Northfield Bunbury Road, Northfield Birmingham Birmingham NFA No Independent Evidence Available   52.4142089 -1.9587147
24707 op-snap---monthly-publication-september-2025.pdf   926 2025-09 Pedestrian Toyota   Black Contravening a Red Traffic Light None Bushbury Road Bushbury Road Wolverhampton Wolverhampton NFA No Offence   52.5988194 -2.1026037
24708 op-snap---monthly-publication-september-2025.pdf   927 2025-09 Pedestrian Volkswagen Golf Black Contravening a Red Traffic Light None Bushbury Road Bushbury Road Wolverhampton Wolverhampton NFA No Offence   52.5988194 -2.1026037
24709 op-snap---monthly-publication-september-2025.pdf   928 2025-09 Pedestrian Mercedes-Benz   Black Contravening a Red Traffic Light None Bushbury Road Bushbury Road Wolverhampton Wolverhampton NFA No Offence   52.5988194 -2.1026037
24745 op-snap---monthly-publication-september-2025.pdf   964 2025-09 Pedestrian BMW 118I White Contravening a Red Traffic Light None Bushbury Road Bushbury Road Wolverhampton Wolverhampton NFA No Offence   52.5988194 -2.1026037
24756 op-snap---monthly-publication-september-2025.pdf   975 2025-09 Pedestrian Dacia Sandero White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24854 op-snap---monthly-publication-september-2025.pdf   1073 2025-09 Pedestrian Kia Xceed Gold Contravening a Red Traffic Light None Bushbury Road / Cannock Road Bushbury Road / Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.5988194 -2.1026037
24856 op-snap---monthly-publication-september-2025.pdf   1075 2025-09 Pedestrian Mercedes-Benz C200 Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24857 op-snap---monthly-publication-september-2025.pdf   1076 2025-09 Pedestrian Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24858 op-snap---monthly-publication-september-2025.pdf   1077 2025-09 Pedestrian Toyota Yaris Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24859 op-snap---monthly-publication-september-2025.pdf   1078 2025-09 Pedestrian Toyota Auris Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24860 op-snap---monthly-publication-september-2025.pdf   1079 2025-09 Pedestrian Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24862 op-snap---monthly-publication-september-2025.pdf   1081 2025-09 Pedestrian Seat ibiza White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24863 op-snap---monthly-publication-september-2025.pdf   1082 2025-09 Pedestrian Hyundai Tucson Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24867 op-snap---monthly-publication-september-2025.pdf   1086 2025-09 Pedestrian Mg HS White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Offence   52.6083917 -2.1033365
24873 op-snap---monthly-publication-september-2025.pdf   1092 2025-09 Pedestrian Ford Focus Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24874 op-snap---monthly-publication-september-2025.pdf   1093 2025-09 Pedestrian Renault Scenic Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24884 op-snap---monthly-publication-september-2025.pdf   1103 2025-09 Pedestrian Renault Zoe Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24885 op-snap---monthly-publication-september-2025.pdf   1104 2025-09 Pedestrian Fiat Motorhome White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24886 op-snap---monthly-publication-september-2025.pdf   1105 2025-09 Pedestrian Toyota Estima White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24887 op-snap---monthly-publication-september-2025.pdf   1106 2025-09 Pedestrian Mercedes-Benz A-Class Silver Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24888 op-snap---monthly-publication-september-2025.pdf   1107 2025-09 Pedestrian Audi Q2 Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24912 op-snap---monthly-publication-september-2025.pdf   1131 2025-09 Pedestrian Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24914 op-snap---monthly-publication-september-2025.pdf   1133 2025-09 Pedestrian Seat Leon Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24915 op-snap---monthly-publication-september-2025.pdf   1134 2025-09 Pedestrian Kia Rio Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24918 op-snap---monthly-publication-september-2025.pdf   1137 2025-09 Pedestrian Renault Truck White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24919 op-snap---monthly-publication-september-2025.pdf   1138 2025-09 Pedestrian Nissan Leaf Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24920 op-snap---monthly-publication-september-2025.pdf   1139 2025-09 Pedestrian BMW 1 series Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24921 op-snap---monthly-publication-september-2025.pdf   1140 2025-09 Pedestrian Ford Focus White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24923 op-snap---monthly-publication-september-2025.pdf   1142 2025-09 Pedestrian BMW 118.. Silver Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24926 op-snap---monthly-publication-september-2025.pdf   1145 2025-09 Pedestrian Toyota Prius White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24927 op-snap---monthly-publication-september-2025.pdf   1146 2025-09 Pedestrian Vauxhall Astra Silver Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24928 op-snap---monthly-publication-september-2025.pdf   1147 2025-09 Pedestrian Audi A3 Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24929 op-snap---monthly-publication-september-2025.pdf   1148 2025-09 Pedestrian Ford Fiesta Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24930 op-snap---monthly-publication-september-2025.pdf   1149 2025-09 Pedestrian Nissan Qashqai Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24931 op-snap---monthly-publication-september-2025.pdf   1150 2025-09 Pedestrian Vauxhall Astra Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24932 op-snap---monthly-publication-september-2025.pdf   1151 2025-09 Pedestrian Renault Captur Silver Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24937 op-snap---monthly-publication-september-2025.pdf   1156 2025-09 Pedestrian Byd Optare bus Red Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24939 op-snap---monthly-publication-september-2025.pdf   1158 2025-09 Pedestrian Volvo V40 Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24940 op-snap---monthly-publication-september-2025.pdf   1159 2025-09 Pedestrian Vauxhall Astra Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24941 op-snap---monthly-publication-september-2025.pdf   1160 2025-09 Pedestrian Peugeot 2008 Black Contravening a Red Traffic Light None Worcester, near the river Worcester, near the river Out of Force Area Out of Force Area NFA Out of Force      
2257 op-snap---monthly-publication-august-2025.pdf   232 2025-08 Pedestrian   Bus Blue Contravening a Red Traffic Light None Easemore Road Easemore Road Out of Force Are Out of Force Area NFA Out of Force      
3022 op-snap---monthly-publication-august-2025.pdf   997 2025-08 Pedestrian Toyota Prius Silver Contravening a Red Traffic Light None Monument Road Monument Road Birmingham Birmingham NFA No Independent Evidence Available   52.4731312 -1.930947
3209 op-snap---monthly-publication-august-2025.pdf   1184 2025-08 Pedestrian Mazda 3.. White Contravening a Red Traffic Light None Bristol Road South Bristol Road South Birmingham Birmingham NFA No Independent Evidence Available   52.4119174 -1.9735247
12063 op-snap---monthly-publication-july-2025.pdf   115 2025-07 Pedestrian Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
12150 op-snap---monthly-publication-july-2025.pdf   202 2025-07 Pedestrian Hyundai Santa Fe Black Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12152 op-snap---monthly-publication-july-2025.pdf   204 2025-07 Pedestrian Nissan Ariya Black Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12153 op-snap---monthly-publication-july-2025.pdf   205 2025-07 Pedestrian Peugeot Expert Blue Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12154 op-snap---monthly-publication-july-2025.pdf   206 2025-07 Pedestrian Vauxhall Corsa Black Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12156 op-snap---monthly-publication-july-2025.pdf   208 2025-07 Pedestrian Renault Captur Blue Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12202 op-snap---monthly-publication-july-2025.pdf   254 2025-07 Pedestrian Skoda   Black Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
12363 op-snap---monthly-publication-july-2025.pdf   415 2025-07 Pedestrian Toyota Prius White Contravening a Red Traffic Light None Bordsley Green Road Bordsley Green Road Birmingham Birmingham NFA No Offence      
12411 op-snap---monthly-publication-july-2025.pdf   463 2025-07 Pedestrian Honda Jazz Brown Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14360 op-snap---monthly-publication-june-2025.pdf   289 2025-06 Pedestrian Ford Fiesta Black Contravening a Red Traffic Light None Friary Road Friary Road Birmingham Birmingham NFA No Independent Evidence Available   52.5162814 -1.9395798
15075 op-snap---monthly-publication-june-2025.pdf   1004 2025-06 Pedestrian Toyota PRIUS GREY Contravening a Red Traffic Light None PERCY ROAD Percy Road Birmingham Birmingham NFA No Independent Evidence Available   52.4506155 -1.8585325
15150 op-snap---monthly-publication-june-2025.pdf   1079 2025-06 Pedestrian Toyota Previa White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham NFA No VRM   52.5113867 -1.8337258
15492 op-snap---monthly-publication-june-2025.pdf   1421 2025-06 Pedestrian Peugeot 208 White Contravening a Red Traffic Light None Chester Road North Chester Road North Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.548449 -1.8594603
18740 op-snap---monthly-publication-may-2025.pdf   102 2025-05 Pedestrian BMW 218M White Contravening a Red Traffic Light None WARSTONE LANE Warstone Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4870496 -1.912873
18884 op-snap---monthly-publication-may-2025.pdf   246 2025-05 Pedestrian Jaguar XF... Grey Contravening a Red Traffic Light None A4148 Walsall Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5841365 -1.9852679
18887 op-snap---monthly-publication-may-2025.pdf   249 2025-05 Pedestrian BMW 535 D Silver Contravening a Red Traffic Light None A4148 Walsall Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5841365 -1.9852679
18889 op-snap---monthly-publication-may-2025.pdf   251 2025-05 Pedestrian Audi A5 Grey Contravening a Red Traffic Light None A4148 A4148 Walsall Walsall NFA Outside of 14 Days NIP      
19032 op-snap---monthly-publication-may-2025.pdf   394 2025-05 Pedestrian Land Rover Range Rover Black Contravening a Red Traffic Light None Lichfield Street Lichfield Street Walsall Walsall NFA Outside of 14 Days NIP   52.5882772 -1.9761264
19033 op-snap---monthly-publication-may-2025.pdf   395 2025-05 Pedestrian Ford Puma Red Contravening a Red Traffic Light None Lichfield Street Lichfield Street Walsall Walsall NFA Outside of 14 Days NIP   52.5882772 -1.9761264
19035 op-snap---monthly-publication-may-2025.pdf   397 2025-05 Pedestrian Vauxhall Corsa Red Contravening a Red Traffic Light None Lichfield Street Lichfield Street Walsall Walsall NFA Outside of 14 Days NIP   52.5882772 -1.9761264
19039 op-snap---monthly-publication-may-2025.pdf   401 2025-05 Pedestrian Toyota MPV White Contravening a Red Traffic Light None LICHFIELD STREET Lichfield Street Walsall Walsall NFA Outside of 14 Days NIP   52.5882772 -1.9761264
19040 op-snap---monthly-publication-may-2025.pdf   402 2025-05 Pedestrian     Grey Contravening a Red Traffic Light None LICHFIELD STREET Lichfield Street Walsall Walsall NFA Outside of 14 Days NIP   52.5882772 -1.9761264
19096 op-snap---monthly-publication-may-2025.pdf   458 2025-05 Pedestrian       Contravening a Red Traffic Light None PEDMORE ROAD Pedmore Road Dudley Dudley NFA No VRM   52.4897451 -2.1069141
19155 op-snap---monthly-publication-may-2025.pdf   517 2025-05 Pedestrian Suzuki Splash Grey Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
19900 op-snap---monthly-publication-may-2025.pdf   1262 2025-05 Pedestrian Nissan   Black Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
20251 op-snap---monthly-publication-may-2025.pdf   1613 2025-05 Pedestrian Toyota   Black Contravening a Red Traffic Light None lichfield road Lichfield Road Birmingham Birmingham NFA No VRM   52.5012458 -1.8780942
105 op-snap---monthly-publication-april-2025.pdf   104 2025-04 Pedestrian Toyota Yaris Blue Contravening a Red Traffic Light None Littleton St Littleton Street Walsall Walsall NFA No VRM   52.5885092 -1.9817997
359 op-snap---monthly-publication-april-2025.pdf   358 2025-04 Pedestrian Mercedes-Benz GLA 200 Silver Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
360 op-snap---monthly-publication-april-2025.pdf   359 2025-04 Pedestrian Audi A3 Black Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
365 op-snap---monthly-publication-april-2025.pdf   364 2025-04 Pedestrian Audi TT.. Silver Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
459 op-snap---monthly-publication-april-2025.pdf   458 2025-04 Pedestrian Vauxhall COMBO White Contravening a Red Traffic Light None DAW END LANE Daw End Lane Walsall Walsall NFA Outside of 14 Days NIP   52.6068849 -1.9611652
803 op-snap---monthly-publication-april-2025.pdf   802 2025-04 Pedestrian Vauxhall Astra White Contravening a Red Traffic Light None Daw End Lane Walsall Daw End Lane Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6070366 -1.96132
806 op-snap---monthly-publication-april-2025.pdf   805 2025-04 Pedestrian Peugeot 308.. Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall NFA Outside of 14 Days NIP   52.6068849 -1.9611652
847 op-snap---monthly-publication-april-2025.pdf   846 2025-04 Pedestrian Mercedes-Benz Benz Red Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1049 op-snap---monthly-publication-april-2025.pdf   1048 2025-04 Pedestrian Renault   Red Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1050 op-snap---monthly-publication-april-2025.pdf   1049 2025-04 Pedestrian Volkswagen   Blue Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1057 op-snap---monthly-publication-april-2025.pdf   1056 2025-04 Pedestrian Honda Motorbike Silver Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1059 op-snap---monthly-publication-april-2025.pdf   1058 2025-04 Pedestrian Ford Van White Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Birmingham Birmingham NFA Outside of 14 Days NIP      
1321 op-snap---monthly-publication-april-2025.pdf   1320 2025-04 Pedestrian Ford NP Black Contravening a Red Traffic Light None Greyfriars Road near the junction with Sheriffs Greyfriars Road near the junction with Sheriffs Solihull Solihull NFA Outside of 14 Days NIP      
1745 op-snap---monthly-publication-april-2025.pdf   1744 2025-04 Pedestrian Audi NP Grey Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1746 op-snap---monthly-publication-april-2025.pdf   1745 2025-04 Pedestrian Nissan NP Blue Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1747 op-snap---monthly-publication-april-2025.pdf   1746 2025-04 Pedestrian   NP White Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1811 op-snap---monthly-publication-april-2025.pdf   1810 2025-04 Pedestrian Peugeot NP Black Contravening a Red Traffic Light None All saints way All saints way Sandwell Sandwell NFA Outside of 14 Days NIP   52.5344405 -1.985568
1983 op-snap---monthly-publication-april-2025.pdf   1982 2025-04 Pedestrian   Make/Model NP White Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1984 op-snap---monthly-publication-april-2025.pdf   1983 2025-04 Pedestrian   Make/Model NP Black Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1986 op-snap---monthly-publication-april-2025.pdf   1985 2025-04 Pedestrian Nissan NP Grey Contravening a Red Traffic Light None LIchfield Street , Walsall LIchfield Street , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5854972 -1.9792935

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