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

251 rows where 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 · 251 ✖

month 1

  • 2025-04 · 251 ✖
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
103 op-snap---monthly-publication-april-2025.pdf   102 2025-04 Pedestrian Porsche Macan Silver Contravening a Red Traffic Light None Littleton St Littleton Street Walsall Walsall Education N/A   52.5885092 -1.9817997
104 op-snap---monthly-publication-april-2025.pdf   103 2025-04 Pedestrian Kia Sedona Red Contravening a Red Traffic Light None Littleton St Littleton Street Walsall Walsall Education N/A   52.5885092 -1.9817997
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
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
137 op-snap---monthly-publication-april-2025.pdf   136 2025-04 Pedal Bike BMW 216d White Contravening a Red Traffic Light None Hurst Street Hurst Street Birmingham Birmingham Warning Letter N/A   52.4714381 -1.893243
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
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
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      
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
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
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
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      
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
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
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
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      
699 op-snap---monthly-publication-april-2025.pdf   698 2025-04 Pedal Bike Audi Q2 Black Contravening a Red Traffic Light None Horton Square Horton Square Birmingham Birmingham Warning Letter N/A   52.4649176 -1.8918971
700 op-snap---monthly-publication-april-2025.pdf   699 2025-04 Pedal Bike Ford Transit Silver Contravening a Red Traffic Light None Horton Square Horton Square Birmingham Birmingham Warning Letter N/A   52.4649176 -1.8918971
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
727 op-snap---monthly-publication-april-2025.pdf   726 2025-04 Pedestrian Ford Fiesta White Contravening a Red Traffic Light None Stratford Road, Shirley Stratford Road, Shirley Birmingham Birmingham Warning Letter N/A      
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
771 op-snap---monthly-publication-april-2025.pdf   770 2025-04 Pedestrian Toyota Corolla Silver Contravening a Red Traffic Light None Greyfriars Road Greyfriars Road Coventry Coventry Education N/A   52.4052565 -1.515244
772 op-snap---monthly-publication-april-2025.pdf   771 2025-04 Pedestrian BMW M3 Sport White Contravening a Red Traffic Light None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
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      

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