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'}
24 rows where disposal = "Education", month = "2025-08" and vehicle_make = "Mercedes-Benz" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_model, vehicle_colour, council_area_raw
council_area 6
- Birmingham 14
- Wolverhampton 3
- Coventry 2
- Dudley 2
- Sandwell 2
- Walsall 1
reporter_transport_mode 3
- Car 14
- Pedal Bike 9
- Other 1
offence 3
vehicle_make 1
- Mercedes-Benz · 24 ✖
month 1
- 2025-08 · 24 ✖
disposal 1
- Education · 24 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2082 | op-snap---monthly-publication-august-2025.pdf | 57 | 2025-08 | Car | Mercedes-Benz | A160.. | Blue | Contravening a Red Traffic Light | None | Hollyhedge Road West Brom | Hollyhedge Road West Brom | Sandwell | Sandwell | Education | N/A | ||||
| 2130 | op-snap---monthly-publication-august-2025.pdf | 105 | 2025-08 | Car | Mercedes-Benz | AMG | White | Driving without Due Care and Attention | None | The Broadway | The Broadway | Walsall | Walsall | Education | N/A | 52.6090076 | -2.0515573 | ||
| 2147 | op-snap---monthly-publication-august-2025.pdf | 122 | 2025-08 | Car | Mercedes-Benz | GLA | Black | Driving without Due Care and Attention | None | Battery Way | Battery Way | Birmingham | Birmingham | Education | N/A | 52.4493988 | -1.8476406 | ||
| 2343 | op-snap---monthly-publication-august-2025.pdf | 318 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Darthmouth Middleway | Darthmouth Middleway | Birmingham | Birmingham | Education | N/A | ||||
| 2345 | op-snap---monthly-publication-august-2025.pdf | 320 | 2025-08 | Other | Mercedes-Benz | C-class | Silver | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Education | N/A | ||||
| 2369 | op-snap---monthly-publication-august-2025.pdf | 344 | 2025-08 | Pedal Bike | Mercedes-Benz | EClass | White | Driving without Due Care and Attention | None | Underhill Road | Underhill Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 2449 | op-snap---monthly-publication-august-2025.pdf | 424 | 2025-08 | Car | Mercedes-Benz | GLA220 | Black | Contravening a Red Traffic Light | None | Grove Lane | Grove Lane | Sandwell | Sandwell | Education | N/A | 52.4882564 | -1.949089 | ||
| 2552 | op-snap---monthly-publication-august-2025.pdf | 527 | 2025-08 | Pedal Bike | Mercedes-Benz | AMG | Blue | Driving without Due Care and Attention | None | Maryvale Road | Maryvale Road | Birmingham | Birmingham | Education | N/A | ||||
| 2572 | op-snap---monthly-publication-august-2025.pdf | 547 | 2025-08 | Pedal Bike | Mercedes-Benz | sprinter | White | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Dudley | Dudley | Education | N/A | 52.4514139 | -2.1423625 | ||
| 2606 | op-snap---monthly-publication-august-2025.pdf | 581 | 2025-08 | Pedal Bike | Mercedes-Benz | GLC 220 | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 2715 | op-snap---monthly-publication-august-2025.pdf | 690 | 2025-08 | Car | Mercedes-Benz | A180 | Grey | Driving without Due Care and Attention | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 2750 | op-snap---monthly-publication-august-2025.pdf | 725 | 2025-08 | Car | Mercedes-Benz | E Class | Black | Contravening a Red Traffic Light | None | Bilston Street | Bilston Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5838892 | -2.1231759 | ||
| 2780 | op-snap---monthly-publication-august-2025.pdf | 755 | 2025-08 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5560698 | -2.1044322 | ||
| 2786 | op-snap---monthly-publication-august-2025.pdf | 761 | 2025-08 | Pedal Bike | Mercedes-Benz | GLA | Black | Driving without Due Care and Attention | None | Pritchatts Road | Pritchatts Road | Birmingham | Birmingham | Education | N/A | 52.4522304 | -1.9267446 | ||
| 2841 | op-snap---monthly-publication-august-2025.pdf | 816 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Soho Road | Soho Road | Birmingham | Birmingham | Education | N/A | 52.502568 | -1.9305447 | ||
| 2891 | op-snap---monthly-publication-august-2025.pdf | 866 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Coleshill Road at Newport Island | Coleshill Road at Newport Island | Birmingham | Birmingham | Education | N/A | 52.5008899 | -1.7993095 | ||
| 2930 | op-snap---monthly-publication-august-2025.pdf | 905 | 2025-08 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 2944 | op-snap---monthly-publication-august-2025.pdf | 919 | 2025-08 | Car | Mercedes-Benz | A250 | Silver | Contravening a Red Traffic Light | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 3029 | op-snap---monthly-publication-august-2025.pdf | 1004 | 2025-08 | Car | Mercedes-Benz | GLC | Blue | Driving without Due Care and Attention | None | School Road | School Road | Birmingham | Birmingham | Education | N/A | 52.4161736 | -1.8619692 | ||
| 3055 | op-snap---monthly-publication-august-2025.pdf | 1030 | 2025-08 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 3086 | op-snap---monthly-publication-august-2025.pdf | 1061 | 2025-08 | Pedal Bike | Mercedes-Benz | GLS | Black | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 3116 | op-snap---monthly-publication-august-2025.pdf | 1091 | 2025-08 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | High Street | High Street | Birmingham | Birmingham | Education | N/A | 52.5254588 | -1.8373064 | ||
| 3140 | op-snap---monthly-publication-august-2025.pdf | 1115 | 2025-08 | Car | Mercedes-Benz | AMG | Black | Driving without Due Care and Attention | None | Cateswell Road | Cateswell Road | Birmingham | Birmingham | Education | N/A | 52.4387009 | -1.8454267 | ||
| 3146 | op-snap---monthly-publication-august-2025.pdf | 1121 | 2025-08 | Pedal Bike | Mercedes-Benz | AMG GT | White | Stop a vehicle within pelican pedestrian crossing limits | None | Gooch Street | Gooch Street | Birmingham | Birmingham | Education | N/A | 52.4686609 | -1.8945007 |
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);