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

207 rows where disposal = "NFA", month = "2025-04" and offence = "Contravening a Red Traffic Light" 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 5

offence 1

  • Contravening a Red Traffic Light · 207 ✖

month 1

  • 2025-04 · 207 ✖

disposal 1

  • NFA · 207 ✖
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
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
159 op-snap---monthly-publication-april-2025.pdf   158 2025-04 Car Ford Fiesta Black Contravening a Red Traffic Light None Alridge Rd Aldridge Road Birmingham Birmingham NFA No Independent Evidence Available   52.5368764 -1.8976461
188 op-snap---monthly-publication-april-2025.pdf   187 2025-04 Car Seat Leon White Contravening a Red Traffic Light None Clifford Street Clifford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4989738 -1.9005402
252 op-snap---monthly-publication-april-2025.pdf   251 2025-04 Car Toyota Prius Silver Contravening a Red Traffic Light None Park Road Bedford Park Road Bedford Area Area NFA Out of Force      
271 op-snap---monthly-publication-april-2025.pdf   270 2025-04 Car Volkswagen Transporter Black Contravening a Red Traffic Light None Balsall Street Balsall Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4579985 -1.8916996
276 op-snap---monthly-publication-april-2025.pdf   275 2025-04 Pedal Bike Audi A1 White Contravening a Red Traffic Light None St Marys Row Street Marys Row Birmingham Birmingham NFA Outside of 14 Days NIP      
330 op-snap---monthly-publication-april-2025.pdf   329 2025-04 Car Peugeot Rifter Grey Contravening a Red Traffic Light None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5010052 -2.0306321
348 op-snap---monthly-publication-april-2025.pdf   347 2025-04 Car BMW I4... Black Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4308271 -1.920078
349 op-snap---monthly-publication-april-2025.pdf   348 2025-04 Other Tesla   Black Contravening a Red Traffic Light None Alcester Road Alcester Road BOiurmt oinf gFhoarmce Boiurmt Oinf Gfhoarmce NFA Outside of 14 DAYS Late Submission   52.452635 -1.8874738
355 op-snap---monthly-publication-april-2025.pdf   354 2025-04 Car       Contravening a Red Traffic Light None fletchamstead highway Fletchamstead Highway Birmingham Birmingham NFA No Independent Evidence Available      
357 op-snap---monthly-publication-april-2025.pdf   356 2025-04 Car Ford TRANSIT Silver Contravening a Red Traffic Light None FLETCHAMSTEAD HIGHWAY Fletchamstead Highway Birmingham Birmingham NFA No Offence      
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
362 op-snap---monthly-publication-april-2025.pdf   361 2025-04 Car Fiat 500.. Blue Contravening a Red Traffic Light None A435 Moseley Road Moseley Road BOiurmt oinf gFhoarmce Boiurmt Oinf Gfhoarmce NFA Outside of 14 Days NIP   52.4622719 -1.8838349
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
368 op-snap---monthly-publication-april-2025.pdf   367 2025-04 Car Seat leon Red Contravening a Red Traffic Light None BROMFORD Bromford Birmingham Birmingham NFA Outside of 14 Days NIP   52.5049062 -1.8152832
387 op-snap---monthly-publication-april-2025.pdf   386 2025-04 Car Volvo XC60 Red Contravening a Red Traffic Light None SPITFIRE ISLAND M6 Spitfire Island M6 Birmingham Birmingham NFA Outside of 14 Days NIP   52.5139463 -1.7980911
398 op-snap---monthly-publication-april-2025.pdf   397 2025-04 Car Toyota Aygo White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
438 op-snap---monthly-publication-april-2025.pdf   437 2025-04 Pedal Bike Ford TRANSIT Blue Contravening a Red Traffic Light None BELL GREEN ROAD Bell Green Road COouvt eonft Fryorce Coouvt Eonft Fryorce NFA Outside of 14 Days NIP   52.4361538 -1.4756447
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
479 op-snap---monthly-publication-april-2025.pdf   478 2025-04 Car Mercedes-Benz C220 Black Contravening a Red Traffic Light None Corporation St Corporation Street Walsall Walsall NFA Outside of 14 Days NIP   52.5773099 -1.9850716
482 op-snap---monthly-publication-april-2025.pdf   481 2025-04 Car Volkswagen Golf Grey Contravening a Red Traffic Light None Brandwood Park Rd Brandwood Park Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4138206 -1.9041686
491 op-snap---monthly-publication-april-2025.pdf   490 2025-04 Car Ford Focus Grey Contravening a Red Traffic Light None A5 Cannock Cannock Area Area NFA Out of Force   52.6115346 -2.1002311
493 op-snap---monthly-publication-april-2025.pdf   492 2025-04 Car   Yamasaki Grey Contravening a Red Traffic Light None Castle GATE iSLAND Castle GATE i SLAND Dudley Dudley NFA Outside of 14 Days NIP      
502 op-snap---monthly-publication-april-2025.pdf   501 2025-04 Car Vauxhall Corsa Green Contravening a Red Traffic Light None Venture Way Venture Way Dudley Dudley NFA Outside of 14 Days NIP   52.4836603 -2.1189326
514 op-snap---monthly-publication-april-2025.pdf   513 2025-04 Pedal Bike Volkswagen Polo Silver Contravening a Red Traffic Light None Coundon Road Coundon Road Coventry Coventry NFA Outside of 14 Days NIP   52.4125737 -1.5215178
516 op-snap---monthly-publication-april-2025.pdf   515 2025-04 Car Audi Q5 White Contravening a Red Traffic Light None FOUR OAKS ROAD Four Oaks Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5840096 -1.8355803
522 op-snap---monthly-publication-april-2025.pdf   521 2025-04 Car Hyundai I20 Black Contravening a Red Traffic Light None BROMFORD LANE Bromford Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5083238 -1.8332287
528 op-snap---monthly-publication-april-2025.pdf   527 2025-04 Car       Contravening a Red Traffic Light None M6 NORTH M6 North Walsall Walsall NFA No Independent Evidence Available   52.5859649 -1.9897914
530 op-snap---monthly-publication-april-2025.pdf   529 2025-04 Car Volkswagen GOLF Blue Contravening a Red Traffic Light None REDDINGS LANE Reddings Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4506039 -1.8463952
547 op-snap---monthly-publication-april-2025.pdf   546 2025-04 Car Daf TRUCKS White Contravening a Red Traffic Light None TOLLBAR END Tollbar End Birmingham Birmingham NFA No Offence      
552 op-snap---monthly-publication-april-2025.pdf   551 2025-04 Pedal Bike Mercedes-Benz Vito Black Contravening a Red Traffic Light None Hill Street Hill Street Birmingham Birmingham NFA Misc Inc Crimes   52.4777765 -1.901321
554 op-snap---monthly-publication-april-2025.pdf   553 2025-04 Car Kia Sportage Blue Contravening a Red Traffic Light None Jockey Road Jockey Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5512291 -1.8357776
561 op-snap---monthly-publication-april-2025.pdf   560 2025-04 Car Toyota MPV Silver Contravening a Red Traffic Light None Black Lake Black Lake Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.5341947 -2.0098521
636 op-snap---monthly-publication-april-2025.pdf   635 2025-04 Car Nissan Juke Black Contravening a Red Traffic Light None Bentley Lane Bentley Lane Walsall Walsall NFA Outside of 14 Days NIP   52.5944332 -2.0119525
640 op-snap---monthly-publication-april-2025.pdf   639 2025-04 Pedal Bike Nissan Qashqai Black Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA Outside of 14 Days NIP   52.4221152 -1.4959475
643 op-snap---monthly-publication-april-2025.pdf   642 2025-04 Car Volkswagen Polo Grey Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall NFA Outside of 14 Days NIP   52.5648629 -1.9517624
664 op-snap---monthly-publication-april-2025.pdf   663 2025-04 Car Volkswagen Golf Grey Contravening a Red Traffic Light None High St High Street Birmingham Birmingham NFA No Independent Evidence Available   52.5254588 -1.8373064
683 op-snap---monthly-publication-april-2025.pdf   682 2025-04 Car Nissan Qashqai Black Contravening a Red Traffic Light None Cofton Hackett, West Mercia Cofton Hackett, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
703 op-snap---monthly-publication-april-2025.pdf   702 2025-04 Car Ford Focus Blue Contravening a Red Traffic Light None Bescot Road Bescot Road Walsall Walsall NFA No Independent Evidence Available   52.5707373 -2.0014215
713 op-snap---monthly-publication-april-2025.pdf   712 2025-04 Car Fiat 500 Red Contravening a Red Traffic Light None Newtown Road Newtown Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4990909 -1.8963634
755 op-snap---monthly-publication-april-2025.pdf   754 2025-04 Car Honda Civic Blue Contravening a Red Traffic Light None A460 Cannock Cannock Out of Force Area Out of Force Area NFA Out of Force      
756 op-snap---monthly-publication-april-2025.pdf   755 2025-04 Car Toyota Landcruiser Grey Contravening a Red Traffic Light None Telford Telford Out of Force Area Out of Force Area NFA Out of Force   52.4979333 -1.9664857
773 op-snap---monthly-publication-april-2025.pdf   772 2025-04 Car Land Rover Discovery Grey Contravening a Red Traffic Light None Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
785 op-snap---monthly-publication-april-2025.pdf   784 2025-04 Car Volvo XC40 Black Contravening a Red Traffic Light None Bristol Road Bristol Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4543565 -1.9114004
790 op-snap---monthly-publication-april-2025.pdf   789 2025-04 Pedal Bike Ford Transit White Contravening a Red Traffic Light None Kenilworth Road Kenilworth Road Coventry Coventry NFA Outside of 14 Days NIP   52.3833298 -1.5379214
796 op-snap---monthly-publication-april-2025.pdf   795 2025-04 Car Peugeot 3008.. Grey Contravening a Red Traffic Light None Walstead Road Walstead Road Birmingham Birmingham NFA Outside of 14 Days NIP      
798 op-snap---monthly-publication-april-2025.pdf   797 2025-04 Car Vauxhall Astra Grey Contravening a Red Traffic Light None Tamworth Road Tamworth Road Solihull Solihull NFA Outside of 14 Days NIP      
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
805 op-snap---monthly-publication-april-2025.pdf   804 2025-04 Car Volkswagen Touran Grey Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
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
837 op-snap---monthly-publication-april-2025.pdf   836 2025-04 Car Mercedes-Benz Benz White Contravening a Red Traffic Light None Thorns Road , Dudley Thorns Road , Dudley Coventry Coventry NFA Outside of 14 Days NIP      
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
893 op-snap---monthly-publication-april-2025.pdf   892 2025-04 Car BMW   Black Contravening a Red Traffic Light None College Road , Perry Barr College Road , Perry Barr Birmingham Birmingham NFA Outside of 14 Days NIP   52.5321869 -1.886442
901 op-snap---monthly-publication-april-2025.pdf   900 2025-04 Car Peugeot   White Contravening a Red Traffic Light None Norfolk Road , Birmingham Norfolk Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4672547 -1.9435381
914 op-snap---monthly-publication-april-2025.pdf   913 2025-04 Car Skoda Octavia Black Contravening a Red Traffic Light None A38M and M6 Exit towards Sutton Coldfield A38M and M6 Exit towards Sutton Coldfield Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
924 op-snap---monthly-publication-april-2025.pdf   923 2025-04 Car Tesla   Grey Contravening a Red Traffic Light None Along Hagley towards Stourbridge / Halesowen Along Hagley towards Stourbridge / Halesowen Dudley Dudley NFA Outside of 14 Days NIP      
925 op-snap---monthly-publication-april-2025.pdf   924 2025-04 Car Nissan Qashqai Blue Contravening a Red Traffic Light None A34 Birmingham Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4796992 -1.9026911
937 op-snap---monthly-publication-april-2025.pdf   936 2025-04 Car BMW   Grey Contravening a Red Traffic Light None Priory Road , Edgbaston Priory Road , Edgbaston Birmingham Birmingham NFA Outside of 14 Days NIP   52.4556998 -1.9102592
941 op-snap---monthly-publication-april-2025.pdf   940 2025-04 Car Mercedes-Benz   Black Contravening a Red Traffic Light None JUnction of Priory Road and Bristol Road , Birmingham JUnction of Priory Road and Bristol Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
955 op-snap---monthly-publication-april-2025.pdf   954 2025-04 Car Hyundai Getz Black Contravening a Red Traffic Light None Muntz Street , Birmingham Muntz Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4725275 -1.854984
962 op-snap---monthly-publication-april-2025.pdf   961 2025-04 Car Land Rover   Black Contravening a Red Traffic Light None B4102 , Solihull B4102 , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.3954127 -1.8215562
963 op-snap---monthly-publication-april-2025.pdf   962 2025-04 Car Ford   Black Contravening a Red Traffic Light None A45 , Coventry A45 , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.3772596 -1.4884352
972 op-snap---monthly-publication-april-2025.pdf   971 2025-04 Car Alfa Romeo Mito Black Contravening a Red Traffic Light None Newton Road , Great Barr Newton Road , Great Barr Birmingham Birmingham NFA Outside of 14 Days NIP      
975 op-snap---monthly-publication-april-2025.pdf   974 2025-04 Car Volkswagen SCirotto GTI Grey Contravening a Red Traffic Light None     Dudley Dudley NFA Outside of 14 Days NIP      
977 op-snap---monthly-publication-april-2025.pdf   976 2025-04 Car Vauxhall Ampera White Contravening a Red Traffic Light None Walsall Road , Perry Barr Walsall Road , Perry Barr Birmingham Birmingham NFA Outside of 14 Days NIP   52.5219655 -1.9010321
982 op-snap---monthly-publication-april-2025.pdf   981 2025-04 Car   Motorbike Black Contravening a Red Traffic Light None A4040 Southbound , Birm,ingham Southbound , Birm, ingham Birmingham Birmingham NFA Outside of 14 Days NIP      
983 op-snap---monthly-publication-april-2025.pdf   982 2025-04 Car Volkswagen Touran Black Contravening a Red Traffic Light None Slade Road , Birmingham Slade Road , Birmingham Coventry Coventry NFA Outside of 14 Days NIP      
986 op-snap---monthly-publication-april-2025.pdf   985 2025-04 Car Seat Ibiza Black Contravening a Red Traffic Light None Hamilton Road , Birmingham Hamilton Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5071997 -1.9439595
987 op-snap---monthly-publication-april-2025.pdf   986 2025-04 Car Toyota Estima White Contravening a Red Traffic Light None Coopers Lane , Smethwick Coopers Lane , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4915505 -1.9742227
1009 op-snap---monthly-publication-april-2025.pdf   1008 2025-04 Car Mercedes-Benz   Grey Contravening a Red Traffic Light None North bound A 34 North bound A 34 Birmingham Birmingham NFA Outside of 14 Days NIP      
1012 op-snap---monthly-publication-april-2025.pdf   1011 2025-04 Car Audi   Grey Contravening a Red Traffic Light none Alum Rock Road , Birmingham Alum Rock Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4879833 -1.8417304
1029 op-snap---monthly-publication-april-2025.pdf   1028 2025-04 Car Citroen C3 Blue Contravening a Red Traffic Light None Blue Ribbon Roundabout , Coventry Blue Ribbon Roundabout , Coventry Coventry Coventry NFA Outside of 14 Days NIP      
1030 op-snap---monthly-publication-april-2025.pdf   1029 2025-04 Car Land Rover Sport Black Contravening a Red Traffic Light None Alcester Road , Birmingham Alcester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.452635 -1.8874738
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
1051 op-snap---monthly-publication-april-2025.pdf   1050 2025-04 Pedal Bike Ford Van 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
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      
1064 op-snap---monthly-publication-april-2025.pdf   1063 2025-04 Pedal Bike Suzuki   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
1065 op-snap---monthly-publication-april-2025.pdf   1064 2025-04 Car BMW   Blue Contravening a Red Traffic Light None Elston Hall Lane , Wolverhampton Elston Hall Lane , Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6187794 -2.1216676
1070 op-snap---monthly-publication-april-2025.pdf   1069 2025-04 Car Citroen   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
1078 op-snap---monthly-publication-april-2025.pdf   1077 2025-04 Car Daf truck 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
1098 op-snap---monthly-publication-april-2025.pdf   1097 2025-04 Car Mazda   Black Contravening a Red Traffic Light None Westbourne Road , Edgbaston Westbourne Road , Edgbaston Birmingham Birmingham NFA Outside of 14 Days NIP   52.4676786 -1.9260796
1120 op-snap---monthly-publication-april-2025.pdf   1119 2025-04 Car Land Rover   Black Contravening a Red Traffic Light None Middlemore Lane , Walsall Middlemore Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6046656 -1.9262024
1125 op-snap---monthly-publication-april-2025.pdf   1124 2025-04 Car Toyota   Grey Contravening a Red Traffic Light None Middle more Lane , Walsall Middle more Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP      
1131 op-snap---monthly-publication-april-2025.pdf   1130 2025-04 Car Kia   Grey Contravening a Red Traffic Light None Bosty Lane , Walsall Bosty Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5973696 -1.9377903
1140 op-snap---monthly-publication-april-2025.pdf   1139 2025-04 Car   NP White Contravening a Red Traffic Light None Tyburn Road , Birmingham Tyburn Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5227071 -1.8071946
1171 op-snap---monthly-publication-april-2025.pdf   1170 2025-04 Car   Box Van White & Orange Contravening a Red Traffic Light None A452 towards Aldridge A452 towards Aldridge Walsall Walsall NFA Outside of 14 Days NIP      
1191 op-snap---monthly-publication-april-2025.pdf   1190 2025-04 Car Yamaha   Blue Contravening a Red Traffic Light None B4025 , Solihull B4025 , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.4223176 -1.8253145
1198 op-snap---monthly-publication-april-2025.pdf   1197 2025-04 Car Mercedes-Benz Benz GLA White Contravening a Red Traffic Light None Broadlands Road , Wolverhampton Broadlands Road , Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
1199 op-snap---monthly-publication-april-2025.pdf   1198 2025-04 Car Ford Transit Leader White Contravening a Red Traffic Light None Wolverhampton Road , Dudley Wolverhampton Road , Dudley Dudley Dudley NFA Outside of 14 Days NIP   52.5491587 -2.1238257
1203 op-snap---monthly-publication-april-2025.pdf   1202 2025-04 Car   Motorbike   Contravening a Red Traffic Light None Main road heading towards Quarry Bank Main road heading towards Quarry Bank Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1232 op-snap---monthly-publication-april-2025.pdf   1231 2025-04 Car Ford   White Contravening a Red Traffic Light None Pilkington Avenue , Birmingham Pilkington Avenue , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5504704 -1.8195028
1244 op-snap---monthly-publication-april-2025.pdf   1243 2025-04 Car   NP   Contravening a Red Traffic Light None Sutton new Road , Sutton Sutton new Road , Sutton Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
1258 op-snap---monthly-publication-april-2025.pdf   1257 2025-04 Car Volkswagen Polo Grey Contravening a Red Traffic Light None Tennal Road , Birmingham Tennal Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4596769 -1.9795353
1259 op-snap---monthly-publication-april-2025.pdf   1258 2025-04 Car BMW   Blue Contravening a Red Traffic Light None The Lea , Birmingham The Lea , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4790124 -1.7913257
1262 op-snap---monthly-publication-april-2025.pdf   1261 2025-04 Car Citroen   Blue Contravening a Red Traffic Light None The Lea , Sheldon The Lea , Sheldon Birmingham Birmingham NFA Outside of 14 Days NIP      
1278 op-snap---monthly-publication-april-2025.pdf   1277 2025-04 Car   NP Grey Contravening a Red Traffic Light None Stratford Road , Birmingham Stratford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
1284 op-snap---monthly-publication-april-2025.pdf   1283 2025-04 Pedal Bike Land Rover Land rover Silver Contravening a Red Traffic Light None Far Gosford Street Far Gosford Street Coventry Coventry NFA Outside of 14 Days NIP   52.4071231 -1.4985178

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