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

108 rows where council_area = "Birmingham", 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, nfa_rationale

disposal 4

reporter_transport_mode 3

offence 1

  • Contravening a Red Traffic Light · 108 ✖

month 1

  • 2025-04 · 108 ✖

council_area 1

  • Birmingham · 108 ✖
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
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
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
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
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
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      
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      
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
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      
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
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
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
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
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
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
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
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
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      
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      
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
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
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
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      
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      
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
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
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
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      
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
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
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
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
1297 op-snap---monthly-publication-april-2025.pdf   1296 2025-04 Car Audi NP Grey Contravening a Red Traffic Light None Wood Lane , Erdinghton Wood Lane , Erdinghton Birmingham Birmingham NFA Outside of 14 Days NIP      
1300 op-snap---monthly-publication-april-2025.pdf   1299 2025-04 Car BMW NP White Contravening a Red Traffic Light None Ladypool road, Sparkbrook, Birmingham Birmingham B12 8JA Ladypool road, Sparkbrook, Birmingham Birmingham B12 8JA Birmingham Birmingham NFA Outside of 14 Days NIP   52.459026 -1.8767525
1312 op-snap---monthly-publication-april-2025.pdf   1311 2025-04 Car Mercedes-Benz Benz Black Contravening a Red Traffic Light None ALum Roack Road , Birmingham ALum Roack Road , Birmingham Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
1320 op-snap---monthly-publication-april-2025.pdf   1319 2025-04 Car Mercedes-Benz NP Black Contravening a Red Traffic Light None A4148 Broadway con approach to the roundabout junction with A34 Bimiingham RD Broadway con approach to the roundabout junction with A34 Bimiingham RD Birmingham Birmingham NFA Outside of 14 Days NIP      
1327 op-snap---monthly-publication-april-2025.pdf   1326 2025-04 Car Ford Fiesta Grey Contravening a Red Traffic Light None high Street. A4100 high Street. A4100 Birmingham Birmingham NFA Outside of 14 Days NIP   52.564965 -1.8221416
1333 op-snap---monthly-publication-april-2025.pdf   1332 2025-04 Car Skoda T21 YDT White Contravening a Red Traffic Light None A45 Small heath highway Small heath highway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4709298 -1.8722585
1425 op-snap---monthly-publication-april-2025.pdf   1424 2025-04 Car Volkswagen Tigan Blue Contravening a Red Traffic Light None Wylde Green Road towards Walmley Wylde Green Road towards Walmley Birmingham Birmingham NFA Outside of 14 Days NIP      
1475 op-snap---monthly-publication-april-2025.pdf   1474 2025-04 Car Audi A3 SPORTSBACK Grey Contravening a Red Traffic Light None Stafford rd Stafford rd Birmingham Birmingham NFA Outside of 14 Days NIP   52.5039962 -1.9310883
1508 op-snap---monthly-publication-april-2025.pdf   1507 2025-04 Car Nissan Juke N-connecta Grey Contravening a Red Traffic Light None Lichfield road Lichfield road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5012458 -1.8780942
1512 op-snap---monthly-publication-april-2025.pdf   1511 2025-04 Car BMW NP Grey Contravening a Red Traffic Light None Alcester Road , Birmingham Alcester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.452635 -1.8874738
1513 op-snap---monthly-publication-april-2025.pdf   1512 2025-04 Car Mercedes-Benz   Grey Contravening a Red Traffic Light None Alcester Road , Birmingham Alcester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.452635 -1.8874738
1520 op-snap---monthly-publication-april-2025.pdf   1519 2025-04 Car Cupra NP Black Contravening a Red Traffic Light None Junction of Warwick Road , Birmingham Junction of Warwick Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1535 op-snap---monthly-publication-april-2025.pdf   1534 2025-04 Car Toyota PRIUS Black Contravening a Red Traffic Light None Road adjacent to 2a High sreet, kings heath Road adjacent to 2a High sreet, kings heath Birmingham Birmingham NFA Outside of 14 Days NIP      
1592 op-snap---monthly-publication-april-2025.pdf   1591 2025-04 Car Ford Kuga St-line x Black Contravening a Red Traffic Light None Salford circus Salford circus Birmingham Birmingham NFA Outside of 14 Days NIP   52.5095071 -1.8593732
1606 op-snap---monthly-publication-april-2025.pdf   1605 2025-04 Car Audi NP White Contravening a Red Traffic Light None Fox Hollies Road , Birmingham Fox Hollies Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5431333 -1.7960713
1609 op-snap---monthly-publication-april-2025.pdf   1608 2025-04 Car Mercedes-Benz NP Grey Contravening a Red Traffic Light None Binley Road , Birmingham Binley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1610 op-snap---monthly-publication-april-2025.pdf   1609 2025-04 Car Mg HS Red Contravening a Red Traffic Light None Marshall Road Marshall Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4499052 -1.819404
1615 op-snap---monthly-publication-april-2025.pdf   1614 2025-04 Car Skoda NP Blue Contravening a Red Traffic Light None Coleshill Road , Washwood Heath Coleshill Road , Washwood Heath Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
1618 op-snap---monthly-publication-april-2025.pdf   1617 2025-04 Car Skoda Superb Black Contravening a Red Traffic Light None Bristol Road , Birmingham Bristol Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4471946 -1.927388
1621 op-snap---monthly-publication-april-2025.pdf   1620 2025-04 Car Toyota Estima Silver Contravening a Red Traffic Light None Birchfield Road , Birmingham Birchfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5170745 -1.9012542
1635 op-snap---monthly-publication-april-2025.pdf   1634 2025-04 Car Audi Q5 White Contravening a Red Traffic Light None Chuch Lane , Handsworth Chuch Lane , Handsworth Birmingham Birmingham NFA Outside of 14 Days NIP      
1638 op-snap---monthly-publication-april-2025.pdf   1637 2025-04 Car Mercedes-Benz A Class Silver Contravening a Red Traffic Light None Church Lane , Handsworth Church Lane , Handsworth Birmingham Birmingham NFA Outside of 14 Days NIP   52.5133161 -1.9278283
1649 op-snap---monthly-publication-april-2025.pdf   1648 2025-04 Car Ford Focus Grey Contravening a Red Traffic Light None Wake green road Wake green road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4437078 -1.8783408
1659 op-snap---monthly-publication-april-2025.pdf   1658 2025-04 Car Mercedes-Benz NP Black Contravening a Red Traffic Light None JTC of the hagley road , rotton park road JTC of the hagley road , rotton park road Birmingham Birmingham NFA Outside of 14 Days NIP      
1669 op-snap---monthly-publication-april-2025.pdf   1668 2025-04 Car Jaguar XF Sportbrake Red Contravening a Red Traffic Light none Bordesley green east/ stoney lane/ yew tree Bordesley green east/ stoney lane/ yew tree Birmingham Birmingham NFA Outside of 14 Days NIP   52.4779178 -1.8069073
1671 op-snap---monthly-publication-april-2025.pdf   1670 2025-04 Car Ford Focus White Contravening a Red Traffic Light None Coventry road Coventry road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4726661 -1.8769032
1691 op-snap---monthly-publication-april-2025.pdf   1690 2025-04 Car Hyundai Kona Grey Contravening a Red Traffic Light none Church Road Church Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4624743 -1.7763934
1707 op-snap---monthly-publication-april-2025.pdf   1706 2025-04 Car Audi Q7 Black Contravening a Red Traffic Light None Bristol STreet roundabout , Birmingham Bristol STreet roundabout , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1731 op-snap---monthly-publication-april-2025.pdf   1730 2025-04 Car Volkswagen Van White Contravening a Red Traffic Light None Chester Road , Birmingham Chester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
1762 op-snap---monthly-publication-april-2025.pdf   1761 2025-04 Car Kia CEED Grey Contravening a Red Traffic Light None Alcester Road , Birmingham Alcester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.452635 -1.8874738
1795 op-snap---monthly-publication-april-2025.pdf   1794 2025-04 Car Skoda Fabia Green Contravening a Red Traffic Light None Bordsley Green Bordsley Green Birmingham Birmingham NFA Outside of 14 Days NIP      
1814 op-snap---monthly-publication-april-2025.pdf   1813 2025-04 Car   Motorbike Black Contravening a Red Traffic Light None Stratford road , Birmingham Stratford road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
1863 op-snap---monthly-publication-april-2025.pdf   1862 2025-04 Car Mercedes-Benz G Wagon Black Contravening a Red Traffic Light None Friary Road Friary Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5162814 -1.9395798
1871 op-snap---monthly-publication-april-2025.pdf   1870 2025-04 Car Seat Leon White Contravening a Red Traffic Light None Traffic light of Stratford road/Solihull road Traffic light of Stratford road/Solihull road Birmingham Birmingham NFA Outside of 14 Days NIP      
1881 op-snap---monthly-publication-april-2025.pdf   1880 2025-04 Car Mercedes-Benz NP Black Contravening a Red Traffic Light None Bromford lane road Bromford lane road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5158286 -1.8356734
1882 op-snap---monthly-publication-april-2025.pdf   1881 2025-04 Car Toyota NP Grey Contravening a Red Traffic Light None Bromford lane Bromford lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.5083238 -1.8332287

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