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'}
31 rows where council_area = "Sandwell", month = "2025-04" and offence = "Driving without Reasonable Consideration" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_model, vehicle_colour, offence_location_raw, offence_location, nfa_rationale, latitude, longitude
vehicle_make 13
disposal 3
- NFA 28
- Warning Letter 2
- Education 1
reporter_transport_mode 2
- Car 27
- Pedal Bike 4
offence 1
- Driving without Reasonable Consideration · 31 ✖
month 1
- 2025-04 · 31 ✖
council_area 1
- Sandwell · 31 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | op-snap---monthly-publication-april-2025.pdf | 52 | 2025-04 | Car | Ford | Puma | Blue | Driving without Reasonable Consideration | None | Birmingham Road | Birmingham Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5461417 | -1.9334193 | ||
| 55 | op-snap---monthly-publication-april-2025.pdf | 54 | 2025-04 | Pedal Bike | Peugeot | 207 | Red | Driving without Reasonable Consideration | None | Sandon Road | Sandon Road | Sandwell | Sandwell | Education | N/A | 52.4763582 | -1.9676181 | ||
| 334 | op-snap---monthly-publication-april-2025.pdf | 333 | 2025-04 | Pedal Bike | BMW | X6 | White | Driving without Reasonable Consideration | None | South Road, Stourbridge | South Road, Stourbridge | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 400 | op-snap---monthly-publication-april-2025.pdf | 399 | 2025-04 | Car | Skoda | Octavia | Blue | Driving without Reasonable Consideration | None | High Street, Cradley Heath | High Street, Cradley Heath | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4757272 | -2.043439 | ||
| 712 | op-snap---monthly-publication-april-2025.pdf | 711 | 2025-04 | Car | Nissan | Qashqai | Black | Driving without Reasonable Consideration | None | Black Country Route | Black Country Route | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 795 | op-snap---monthly-publication-april-2025.pdf | 794 | 2025-04 | Car | BMW | M135 | Grey | Driving without Reasonable Consideration | None | Black Country Route | Black Country Route | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 956 | op-snap---monthly-publication-april-2025.pdf | 955 | 2025-04 | Car | Audi | Black | Driving without Reasonable Consideration | None | High Street , Dudley | High Street , Dudley | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5278614 | -2.0712031 | |||
| 980 | op-snap---monthly-publication-april-2025.pdf | 979 | 2025-04 | Car | Mercedes-Benz | Viano | Grey | Driving without Reasonable Consideration | None | A461 & A457 heading towards Dudley Port | A461 & A457 heading towards Dudley Port | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5193521 | -2.0559955 | ||
| 991 | op-snap---monthly-publication-april-2025.pdf | 990 | 2025-04 | Car | Ford | Blue | Driving without Reasonable Consideration | None | Lower City Road , Tividale | Lower City Road , Tividale | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.50942 | -2.0371695 | |||
| 992 | op-snap---monthly-publication-april-2025.pdf | 991 | 2025-04 | Car | Volkswagen | Estate | Blue | Driving without Reasonable Consideration | None | Booth Street , Smethwick | Booth Street , Smethwick | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5007123 | -1.9518885 | ||
| 1079 | op-snap---monthly-publication-april-2025.pdf | 1078 | 2025-04 | Car | Vauxhall | Silver | Driving without Reasonable Consideration | None | Norwood Road | Norwood Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4655265 | -2.0494856 | |||
| 1080 | op-snap---monthly-publication-april-2025.pdf | 1079 | 2025-04 | Car | Volkswagen | Blue | Driving without Reasonable Consideration | None | Norwood Road | Norwood Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4655265 | -2.0494856 | |||
| 1081 | op-snap---monthly-publication-april-2025.pdf | 1080 | 2025-04 | Car | Ford | Silver | Driving without Reasonable Consideration | None | Norwood Road | Norwood Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4655265 | -2.0494856 | |||
| 1082 | op-snap---monthly-publication-april-2025.pdf | 1081 | 2025-04 | Car | Ford | Silver | Driving without Reasonable Consideration | None | Norwood Road | Norwood Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4655265 | -2.0494856 | |||
| 1084 | op-snap---monthly-publication-april-2025.pdf | 1083 | 2025-04 | Car | Ford | White | Driving without Reasonable Consideration | None | Norwood Road | Norwood Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4655265 | -2.0494856 | |||
| 1138 | op-snap---monthly-publication-april-2025.pdf | 1137 | 2025-04 | Car | Vauxhall | Corsa | Grey | Driving without Reasonable Consideration | None | Express way , West bromwich | Express way , West bromwich | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1172 | op-snap---monthly-publication-april-2025.pdf | 1171 | 2025-04 | Pedal Bike | Bus | Red | Driving without Reasonable Consideration | None | JUnction Lordswood Road / Bearwood Road | JUnction Lordswood Road / Bearwood Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 1226 | op-snap---monthly-publication-april-2025.pdf | 1225 | 2025-04 | Car | Ford | KUGA | Black | Driving without Reasonable Consideration | None | M5 South , West Bromwich | M5 South , West Bromwich | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5199167 | -1.9934333 | ||
| 1237 | op-snap---monthly-publication-april-2025.pdf | 1236 | 2025-04 | Car | Volkswagen | Blue | Driving without Reasonable Consideration | None | M5 Towards Junction 4 | M5 Towards Junction 4 | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 1265 | op-snap---monthly-publication-april-2025.pdf | 1264 | 2025-04 | Car | Mercedes-Benz | A Class | White | Driving without Reasonable Consideration | None | Perry Park Road , Rowley Regis | Perry Park Road , Rowley Regis | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4717873 | -2.0494663 | ||
| 1267 | op-snap---monthly-publication-april-2025.pdf | 1266 | 2025-04 | Car | Mercedes-Benz | Black | Driving without Reasonable Consideration | None | M6 Southbound , Junction 10 | M6 Southbound , Junction 10 | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.676119 | -2.0858425 | |||
| 1342 | op-snap---monthly-publication-april-2025.pdf | 1341 | 2025-04 | Car | Yamaha | Blue | Driving without Reasonable Consideration | None | Horseley heath , Tipton | Horseley heath , Tipton | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5292478 | -2.0422614 | |||
| 1408 | op-snap---monthly-publication-april-2025.pdf | 1407 | 2025-04 | Car | Ford | Transit | White | Driving without Reasonable Consideration | None | Woodgate Lane , West Bromwich | Woodgate Lane , West Bromwich | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1487 | op-snap---monthly-publication-april-2025.pdf | 1486 | 2025-04 | Car | Suzuki | Swift | Red | Driving without Reasonable Consideration | None | Telford Way , Smethwick | Telford Way , Smethwick | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5041001 | -1.9769903 | ||
| 1489 | op-snap---monthly-publication-april-2025.pdf | 1488 | 2025-04 | Pedal Bike | Citroen | C3 | Black | Driving without Reasonable Consideration | None | Crankhall Lane , Wednesbury | Crankhall Lane , Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5562019 | -2.0028056 | ||
| 1493 | op-snap---monthly-publication-april-2025.pdf | 1492 | 2025-04 | Car | BMW | NP | White | Driving without Reasonable Consideration | None | A457 Rolfe street junction , Smethwick | Rolfe street junction , Smethwick | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1636 | op-snap---monthly-publication-april-2025.pdf | 1635 | 2025-04 | Car | BMW | NP | Blue | Driving without Reasonable Consideration | None | Black country new road ( A41 ) | Black country new road ( A41 ) | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5501534 | -2.0296946 | ||
| 1734 | op-snap---monthly-publication-april-2025.pdf | 1733 | 2025-04 | Car | Mg | NP | Black | Driving without Reasonable Consideration | None | Stanhope Road , Smethwick | Stanhope Road , Smethwick | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4856586 | -1.9704663 | ||
| 1743 | op-snap---monthly-publication-april-2025.pdf | 1742 | 2025-04 | Car | Ford | Mondeo | Blue | Driving without Reasonable Consideration | None | M5 North between J1 and M6 slip road | M5 North between J1 and M6 slip road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 1756 | op-snap---monthly-publication-april-2025.pdf | 1755 | 2025-04 | Car | Volkswagen | Polo | Silver | Driving without Reasonable Consideration | None | A4123 | A4123 | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 2019 | op-snap---monthly-publication-april-2025.pdf | 2018 | 2025-04 | Car | Yamaha | MB 50 - 10 | Black | Driving without Reasonable Consideration | None | Dudley Road East , Oldbury | Dudley Road East , Oldbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5101307 | -2.0289105 |
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);