reports
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'}
47 rows where council_area = "Sandwell", disposal = "NFA" and month = "2025-07" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, nfa_rationale, latitude, longitude
vehicle_make 20
offence 10
- Driving without Due Care and Attention 20
- Contravening a Red Traffic Light 8
- Driving without Reasonable Consideration 7
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Using a Mobile Phone Whilst Driving 3
- Dangerous Driving 2
- Drive on hard shoulder 1
- Keeping a vehicle with registration marks obscured 1
- Misc - Non Traffic Offences 1
- No Seat Belt 1
reporter_transport_mode 4
- Car 40
- Pedal Bike 3
- Pedestrian 3
- Motorbike 1
month 1
- 2025-07 · 47 ✖
disposal 1
- NFA · 47 ✖
council_area 1
- Sandwell · 47 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11953 | op-snap---monthly-publication-july-2025.pdf | 5 | 2025-07 | Car | Ford | Fiesta | Orange | Driving without Reasonable Consideration | None | Oldbury Ring Way | Oldbury Ring Way | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 11973 | op-snap---monthly-publication-july-2025.pdf | 25 | 2025-07 | Car | Volvo | XC40 | Black | Driving without Due Care and Attention | None | Birchley Island | Birchley Island | Sandwell | Sandwell | NFA | No Offence | 52.4926604 | -2.0216743 | ||
| 12006 | op-snap---monthly-publication-july-2025.pdf | 58 | 2025-07 | Pedal Bike | Peugeot | 308 | Grey | Contravening a Red Traffic Light | None | Beauty Bank | Beauty Bank | Sandwell | Sandwell | NFA | No Offence | 52.4707042 | -2.0596027 | ||
| 12022 | op-snap---monthly-publication-july-2025.pdf | 74 | 2025-07 | Car | Mazda | 3 series | White | Driving without Due Care and Attention | None | M5 motorway nr Jn1 | M5 motorway nr Jn1 | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 12041 | op-snap---monthly-publication-july-2025.pdf | 93 | 2025-07 | Car | Toyota | Yaris | Silver | Contravening a Red Traffic Light | None | A4123 Tividale | Tividale | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5077595 | -2.044305 | ||
| 12043 | op-snap---monthly-publication-july-2025.pdf | 95 | 2025-07 | Car | Skoda | Fabia | White | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4702299 | -1.9948976 | ||
| 12144 | op-snap---monthly-publication-july-2025.pdf | 196 | 2025-07 | Car | BMW | M140i | White | Driving without Due Care and Attention | None | Langley Road | Langley Road | Sandwell | Sandwell | NFA | No Offence | 52.488131 | -2.0079901 | ||
| 12181 | op-snap---monthly-publication-july-2025.pdf | 233 | 2025-07 | Car | Ford | Puma | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Broadwell Road | Broadwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5043614 | -2.0104333 | ||
| 12182 | op-snap---monthly-publication-july-2025.pdf | 234 | 2025-07 | Car | Ford | Fiesta | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Braodwell Road | Braodwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 12283 | op-snap---monthly-publication-july-2025.pdf | 335 | 2025-07 | Car | Volkswagen | Crafter | White | Contravening a Red Traffic Light | None | Portway Road | Portway Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5527219 | -2.0296243 | ||
| 12586 | op-snap---monthly-publication-july-2025.pdf | 638 | 2025-07 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5439824 | -1.9306805 | ||
| 12601 | op-snap---monthly-publication-july-2025.pdf | 653 | 2025-07 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | A41 Great Barr | Great Barr | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5506235 | -1.9358809 | ||
| 12622 | op-snap---monthly-publication-july-2025.pdf | 674 | 2025-07 | Car | Seat | Ibiza | Red | Driving without Due Care and Attention | None | Archer Way | Archer Way | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4761026 | -2.0372023 | ||
| 12647 | op-snap---monthly-publication-july-2025.pdf | 699 | 2025-07 | Car | Mercedes-Benz | 220.. | Silver | Using a Mobile Phone Whilst Driving | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4722765 | -1.9787531 | ||
| 12715 | op-snap---monthly-publication-july-2025.pdf | 767 | 2025-07 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Thorne Road | Thorne Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5133025 | -2.0221414 | ||
| 12722 | op-snap---monthly-publication-july-2025.pdf | 774 | 2025-07 | Car | Peugeot | Expert | White | Driving without Due Care and Attention | None | A462 Owen Road | Owen Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12734 | op-snap---monthly-publication-july-2025.pdf | 786 | 2025-07 | Motorbike | Ford | Transit | Blue | Driving without Due Care and Attention | None | M5 Northbound | M5 Northbound | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12777 | op-snap---monthly-publication-july-2025.pdf | 829 | 2025-07 | Car | Ford | Blue | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4877352 | -1.9494469 | |||
| 12787 | op-snap---monthly-publication-july-2025.pdf | 839 | 2025-07 | Car | Skoda | Kodiaq | Silver | Driving without Due Care and Attention | None | Cronehills Linkway | Cronehills Linkway | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5216057 | -1.9934283 | ||
| 12801 | op-snap---monthly-publication-july-2025.pdf | 853 | 2025-07 | Car | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | New Swan Lane | New Swan Lane | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5293372 | -2.0107584 | ||
| 12828 | op-snap---monthly-publication-july-2025.pdf | 880 | 2025-07 | Pedestrian | Suzuki | Jimmy | Blue | Driving without Due Care and Attention | None | Red House Avenue | Red House Avenue | Sandwell | Sandwell | NFA | No Offence | 52.5540383 | -2.0075594 | ||
| 12832 | op-snap---monthly-publication-july-2025.pdf | 884 | 2025-07 | Car | Hyundai | ioniq | White | Driving without Reasonable Consideration | None | M5 West Brom | M5 West Brom | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12895 | op-snap---monthly-publication-july-2025.pdf | 947 | 2025-07 | Car | Renault | clio | Red | Driving without Reasonable Consideration | None | Walsall Road , West Bromwich | Walsall Road , West Bromwich | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5366137 | -1.9867997 | ||
| 12897 | op-snap---monthly-publication-july-2025.pdf | 949 | 2025-07 | Car | Volkswagen | Passatt | Black | Driving without Due Care and Attention | None | Wolverhampton Road Oldbury | Wolverhampton Road Oldbury | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5010052 | -2.0306321 | ||
| 12928 | op-snap---monthly-publication-july-2025.pdf | 980 | 2025-07 | Car | Black | Using a Mobile Phone Whilst Driving | None | Halesowen Road | Halesowen Road | Sandwell | Sandwell | NFA | No VRM | 52.4727241 | -2.0645309 | ||||
| 12930 | op-snap---monthly-publication-july-2025.pdf | 982 | 2025-07 | Car | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Oldbury Ringway | Oldbury Ringway | Sandwell | Sandwell | NFA | No Offence | 52.5021337 | -2.0133861 | ||
| 12934 | op-snap---monthly-publication-july-2025.pdf | 986 | 2025-07 | Car | N/K | Green | Misc - Non Traffic Offences | None | Oldbury Ringway | Oldbury Ringway | Sandwell | Sandwell | NFA | No VRM | 52.5021337 | -2.0133861 | |||
| 12971 | op-snap---monthly-publication-july-2025.pdf | 1023 | 2025-07 | Car | Van | White | Dangerous Driving | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 12988 | op-snap---monthly-publication-july-2025.pdf | 1040 | 2025-07 | Pedestrian | Vauxhall | Van | White | Dangerous Driving | None | High Street , Princess End | High Street , Princess End | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12989 | op-snap---monthly-publication-july-2025.pdf | 1041 | 2025-07 | Car | Toyota | Corolla | Silver | Driving without Reasonable Consideration | None | Walsall Road , Stone Cross | Walsall Road , Stone Cross | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.54591 | -1.9841049 | ||
| 12991 | op-snap---monthly-publication-july-2025.pdf | 1043 | 2025-07 | Car | Land Rover | Grey | Driving without Reasonable Consideration | None | Spring Lane South | Spring Lane South | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 13008 | op-snap---monthly-publication-july-2025.pdf | 1060 | 2025-07 | Car | Mercedes-Benz | White | Keeping a vehicle with registration marks obscured | None | M5 North Junction 3 - 2 | M5 North Junction 3 - 2 | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 13009 | op-snap---monthly-publication-july-2025.pdf | 1061 | 2025-07 | Car | Vauxhall | Vivaro | White | Driving without Reasonable Consideration | None | Cakemore Road , Rowley regis | Cakemore Road , Rowley regis | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 13015 | op-snap---monthly-publication-july-2025.pdf | 1067 | 2025-07 | Pedal Bike | Ford | Independance | Blue | Driving without Reasonable Consideration | None | Friar Park Road , Wednesbury | Friar Park Road , Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5538676 | -1.9965667 | ||
| 13022 | op-snap---monthly-publication-july-2025.pdf | 1074 | 2025-07 | Car | Mercedes-Benz | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | McKean Road Oldbury | Mc Kean Road Oldbury | Sandwell | Sandwell | NFA | No Independent Evidence Available | |||||
| 13031 | op-snap---monthly-publication-july-2025.pdf | 1083 | 2025-07 | Car | Honda | Accord | Black | Contravening a Red Traffic Light | None | Halesowen Road , Old Hill | Halesowen Road , Old Hill | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4712653 | -2.0623799 | ||
| 13035 | op-snap---monthly-publication-july-2025.pdf | 1087 | 2025-07 | Car | Vauxhall | Blue | Driving without Due Care and Attention | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 13036 | op-snap---monthly-publication-july-2025.pdf | 1088 | 2025-07 | Car | Kia | Orange | Driving without Due Care and Attention | None | High Street Princess End , Tipton | High Street Princess End , Tipton | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 13088 | op-snap---monthly-publication-july-2025.pdf | 1140 | 2025-07 | Pedal Bike | Ford | Focus | Grey | Driving without Due Care and Attention | None | Toll End Road Tipton | Toll End Road Tipton | Sandwell | Sandwell | NFA | No Offence | 52.5404048 | -2.0400078 | ||
| 13156 | op-snap---monthly-publication-july-2025.pdf | 1208 | 2025-07 | Car | Renault | Clio | Silver | Driving without Due Care and Attention | None | Dudley Road Wednesbury | Dudley Road Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5519203 | -2.0246866 | ||
| 13158 | op-snap---monthly-publication-july-2025.pdf | 1210 | 2025-07 | Car | Vauxhall | Astra | White | Driving without Due Care and Attention | None | Parkway Roundabout Wednesbury | Parkway Roundabout Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5478186 | -2.0297122 | ||
| 13191 | op-snap---monthly-publication-july-2025.pdf | 1243 | 2025-07 | Car | Ford | Focus | White | Drive on hard shoulder | None | M5 J1 NB | M5 J1 Northbound | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | ||||
| 13234 | op-snap---monthly-publication-july-2025.pdf | 1286 | 2025-07 | Car | Seat | Leon | Grey | Driving without Due Care and Attention | None | Birchley Island | Birchley Island | Sandwell | Sandwell | NFA | No Offence | 52.4926604 | -2.0216743 | ||
| 13250 | op-snap---monthly-publication-july-2025.pdf | 1302 | 2025-07 | Car | Renault | Clio | White | Contravening a Red Traffic Light | None | Birmingham New Road | Birmingham New Road | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | 52.5151598 | -2.064717 | ||
| 13504 | op-snap---monthly-publication-july-2025.pdf | 1556 | 2025-07 | Pedestrian | BMW | 118I | Black | No Seat Belt | None | Halesowne Road | Halesowne Road | Sandwell | Sandwell | NFA | No Offence | ||||
| 13960 | op-snap---monthly-publication-july-2025.pdf | 2012 | 2025-07 | Car | Yamaha | Blue | Driving without Due Care and Attention | None | Farley Park, Whitehall Road | Farley Park, Whitehall Road | Sandwell | Sandwell | NFA | No VRM | 52.5235228 | -2.0278023 | |||
| 13964 | op-snap---monthly-publication-july-2025.pdf | 2016 | 2025-07 | Car | Porsche | 911 Turbo | Silver | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Sandwell | Sandwell | NFA | Not in Public Interest | 52.5461417 | -1.9334193 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);