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

197 rows where month = "2025-04", offence = "Contravening a Red Traffic Light" and reporter_transport_mode = "Car" 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 1

  • Car · 197 ✖

offence 1

  • Contravening a Red Traffic Light · 197 ✖

month 1

  • 2025-04 · 197 ✖
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
4 op-snap---monthly-publication-april-2025.pdf   3 2025-04 Car Porsche Cayenne Black Contravening a Red Traffic Light None Bordsely Road Bordsely Road Birmingham Birmingham Warning Letter N/A      
11 op-snap---monthly-publication-april-2025.pdf   10 2025-04 Car Mitsubishi Colt Silver Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
17 op-snap---monthly-publication-april-2025.pdf   16 2025-04 Car Volkswagen Tiguan Blue Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
18 op-snap---monthly-publication-april-2025.pdf   17 2025-04 Car Volkswagen Amarock Grey Contravening a Red Traffic Light None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A   52.4720132 -1.9142946
19 op-snap---monthly-publication-april-2025.pdf   18 2025-04 Car Ford Toureno Silver Contravening a Red Traffic Light None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A   52.4720132 -1.9142946
26 op-snap---monthly-publication-april-2025.pdf   25 2025-04 Car Audi A5 Grey Contravening a Red Traffic Light None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
48 op-snap---monthly-publication-april-2025.pdf   47 2025-04 Car Peugeot 206 Blue Contravening a Red Traffic Light None Walters Road Walters Road Walsall Walsall Other Action Taken N/A      
60 op-snap---monthly-publication-april-2025.pdf   59 2025-04 Car Ford Transit White Contravening a Red Traffic Light None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
65 op-snap---monthly-publication-april-2025.pdf   64 2025-04 Car Vauxhall Corsa Grey Contravening a Red Traffic Light None Bell Lane Bell Lane Birmingham Birmingham Warning Letter N/A   52.4178465 -1.968864
96 op-snap---monthly-publication-april-2025.pdf   95 2025-04 Car Peugeot 208.. White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Fixed Penalty N/A   52.5083238 -1.8332287
97 op-snap---monthly-publication-april-2025.pdf   96 2025-04 Car Toyota Yaris Silver Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
115 op-snap---monthly-publication-april-2025.pdf   114 2025-04 Car Volkswagen Transporter Brown Contravening a Red Traffic Light None Longbridge Lane Longbridge Lane Birmingham Birmingham Warning Letter N/A   52.3962003 -1.9821252
124 op-snap---monthly-publication-april-2025.pdf   123 2025-04 Car Nissan JUKE Grey Contravening a Red Traffic Light None BROMFORD LANE Bromford Lane Birmingham Birmingham Fixed Penalty N/A   52.5083238 -1.8332287
131 op-snap---monthly-publication-april-2025.pdf   130 2025-04 Car Peugeot 3008.. Red Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall Fixed Penalty N/A   52.5648629 -1.9517624
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
163 op-snap---monthly-publication-april-2025.pdf   162 2025-04 Car Ford KUGA Grey Contravening a Red Traffic Light None SUN ISLAND BROWNHILLS Sun Island Brownhills Walsall Walsall Warning Letter N/A      
172 op-snap---monthly-publication-april-2025.pdf   171 2025-04 Car Ford Transit White Contravening a Red Traffic Light None Hanging Lane at Frankley Beeches Road Hanging Lane at Frankley Beeches Road Birmingham Birmingham Warning Letter N/A   52.4091382 -1.9838016
173 op-snap---monthly-publication-april-2025.pdf   172 2025-04 Car Mercedes-Benz A CLASS White Contravening a Red Traffic Light None BENTLEY MILL WAY Bentley Mill Way Walsall Walsall Fixed Penalty N/A   52.5786876 -2.0165115
175 op-snap---monthly-publication-april-2025.pdf   174 2025-04 Car BMW 320i White Contravening a Red Traffic Light None TOWNEND STREET Townend Street Walsall Walsall Fixed Penalty N/A   52.5863213 -1.9852108
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
211 op-snap---monthly-publication-april-2025.pdf   210 2025-04 Car Volkswagen Polo Black Contravening a Red Traffic Light No Insurance Brownshore Lane Brownshore Lane Wolverhampton Wolverhampton Court N/A      
226 op-snap---monthly-publication-april-2025.pdf   225 2025-04 Car Audi A3 Grey Contravening a Red Traffic Light None NEWBURY LANE Newbury Lane Birmingham Birmingham Fixed Penalty N/A      
229 op-snap---monthly-publication-april-2025.pdf   228 2025-04 Car Ford Transit White Contravening a Red Traffic Light None Monkswood Crescent Monkswood Crescent Coventry Coventry Fixed Penalty N/A   52.4326493 -1.463362
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      
256 op-snap---monthly-publication-april-2025.pdf   255 2025-04 Car Toyota Yaris Black Contravening a Red Traffic Light None Nechells Parkway Nechells Parkway Birmingham Birmingham Warning Letter N/A   52.4922722 -1.8711754
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
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
352 op-snap---monthly-publication-april-2025.pdf   351 2025-04 Car Peugeot 3008 White Contravening a Red Traffic Light None Wednesbury Interchange Wednesbury Interchange Walsall Walsall Education N/A   52.5667977 -2.0037424
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      
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
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
472 op-snap---monthly-publication-april-2025.pdf   471 2025-04 Car Volkswagen Caddy White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
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
492 op-snap---monthly-publication-april-2025.pdf   491 2025-04 Car Ford Focus Blue Contravening a Red Traffic Light None Littleton St East Littleton Street East Walsall Walsall Warning Letter N/A   52.5887823 -1.9801166
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
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
519 op-snap---monthly-publication-april-2025.pdf   518 2025-04 Car Volkswagen Tourareg Black Contravening a Red Traffic Light None Found Pounds Av Found Pounds Avenue Coventry Coventry Fixed Penalty N/A      
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
525 op-snap---monthly-publication-april-2025.pdf   524 2025-04 Car Ford Transit Silver Contravening a Red Traffic Light None Sky Blue Way Sky Blue Way Coventry Coventry Fixed Penalty N/A   52.4085943 -1.4943275
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
529 op-snap---monthly-publication-april-2025.pdf   528 2025-04 Car Nissan Pulsar Red Contravening a Red Traffic Light None Alcester Road South Alcester Road South Birmingham Birmingham Fixed Penalty N/A   52.4170522 -1.8906187
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      
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
569 op-snap---monthly-publication-april-2025.pdf   568 2025-04 Car Renault Captur Black Contravening a Red Traffic Light None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Fixed Penalty N/A   52.5517052 -1.7825505
575 op-snap---monthly-publication-april-2025.pdf   574 2025-04 Car Audi Q2 White Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull Fixed Penalty N/A   52.4191184 -1.8326637
582 op-snap---monthly-publication-april-2025.pdf   581 2025-04 Car Mercedes-Benz A180. Black Contravening a Red Traffic Light None Hinkley Road Hinkley Road Coventry Coventry Fixed Penalty N/A      
607 op-snap---monthly-publication-april-2025.pdf   606 2025-04 Car Ford Focus Red Contravening a Red Traffic Light None Nechells Lane Nechells Lane Wolverhampton Wolverhampton Education N/A      
626 op-snap---monthly-publication-april-2025.pdf   625 2025-04 Car BMW 3 Seris Blue Contravening a Red Traffic Light None Broadway North Broadway North Walsall Walsall Warning Letter N/A   52.5886007 -1.9741222
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
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
682 op-snap---monthly-publication-april-2025.pdf   681 2025-04 Car Honda Jazz Red Contravening a Red Traffic Light None A41 Bilston Road Bilston Road Wolverhampton Wolverhampton Warning Letter N/A   52.5801329 -2.1138283
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
710 op-snap---monthly-publication-april-2025.pdf   709 2025-04 Car Yamaha MT-09 Grey Contravening a Red Traffic Light None Lyon Queensway Lyon Queensway Birmingham Birmingham Fixed Penalty N/A   52.4785129 -1.9047486
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
716 op-snap---monthly-publication-april-2025.pdf   715 2025-04 Car Vauxhall Vivaro White Contravening a Red Traffic Light None High Bullen High Bullen Sandwell Sandwell Fixed Penalty N/A   52.5532368 -2.0227385
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
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      
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
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      
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
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

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