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'}
70 rows where month = "2025-08", offence = "Driving without Due Care and Attention" and vehicle_make = "BMW" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
council_area 8
- Birmingham 27
- Out of Force Area 16
- Dudley 8
- Wolverhampton 6
- Coventry 4
- Solihull 4
- Walsall 4
- Sandwell 1
disposal 7
- NFA 25
- Warning Letter 19
- Education 13
- Fixed Penalty 6
- Court 5
- Other Action Taken 1
- RTC - Actioned 1
reporter_transport_mode 5
- Car 57
- Pedal Bike 5
- Other 3
- Pedestrian 3
- Motorbike 2
vehicle_make 1
- BMW · 70 ✖
offence 1
- Driving without Due Care and Attention · 70 ✖
month 1
- 2025-08 · 70 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025 | op-snap---monthly-publication-august-2025.pdf | 0 | 2025-08 | Car | BMW | 120M | White | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Education | N/A | 52.4865107 | -1.9386263 | ||
| 2032 | op-snap---monthly-publication-august-2025.pdf | 7 | 2025-08 | Car | BMW | 525I | Grey | Driving without Due Care and Attention | None | Richmond Hill Road | Richmond Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4607238 | -1.935227 | ||
| 2056 | op-snap---monthly-publication-august-2025.pdf | 31 | 2025-08 | Car | BMW | X3 | Black | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2102 | op-snap---monthly-publication-august-2025.pdf | 77 | 2025-08 | Car | BMW | 320.. | Blue | Driving without Due Care and Attention | None | Duncan Edwards Way | Duncan Edwards Way | Dudley | Dudley | Warning Letter | N/A | 52.5047428 | -2.0823754 | ||
| 2108 | op-snap---monthly-publication-august-2025.pdf | 83 | 2025-08 | Pedestrian | BMW | Black | Driving without Due Care and Attention | None | Lower Valley Road | Lower Valley Road | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.478607 | -2.1430965 | |||
| 2120 | op-snap---monthly-publication-august-2025.pdf | 95 | 2025-08 | Car | BMW | 320d | Black | Driving without Due Care and Attention | None | Merry Hill | Merry Hill | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4817646 | -2.1113435 | ||
| 2127 | op-snap---monthly-publication-august-2025.pdf | 102 | 2025-08 | Pedal Bike | BMW | 530D | Silver | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 2129 | op-snap---monthly-publication-august-2025.pdf | 104 | 2025-08 | Car | BMW | 330 | Black | Driving without Due Care and Attention | None | The Broadway | The Broadway | Walsall | Walsall | Education | N/A | 52.6090076 | -2.0515573 | ||
| 2186 | op-snap---monthly-publication-august-2025.pdf | 161 | 2025-08 | Car | BMW | 118i | Grey | Driving without Due Care and Attention | None | Cole Hall Road | Cole Hall Road | Birmingham | Birmingham | Education | N/A | 52.4968357 | -1.7908553 | ||
| 2214 | op-snap---monthly-publication-august-2025.pdf | 189 | 2025-08 | Car | BMW | 118d | White | Driving without Due Care and Attention | None | M6 South | M6 South | Coventry | Coventry | Fixed Penalty | N/A | 52.4146643 | -1.5694761 | ||
| 2237 | op-snap---monthly-publication-august-2025.pdf | 212 | 2025-08 | Car | BMW | 530.. | White | Driving without Due Care and Attention | None | Childs Way Milton Keynes | Childs Way Milton Keynes | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2244 | op-snap---monthly-publication-august-2025.pdf | 219 | 2025-08 | Car | BMW | X5 | Black | Driving without Due Care and Attention | None | M4/m42 | M4/m42 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2290 | op-snap---monthly-publication-august-2025.pdf | 265 | 2025-08 | Car | BMW | 530D | Grey | Driving without Due Care and Attention | None | Widdrington Road | Widdrington Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4191764 | -1.5105738 | ||
| 2296 | op-snap---monthly-publication-august-2025.pdf | 271 | 2025-08 | Car | BMW | 320D | Blue | Driving without Due Care and Attention | None | Springfield Road | Springfield Road | Birmingham | Birmingham | Court | N/A | 52.4327486 | -1.8844997 | ||
| 2301 | op-snap---monthly-publication-august-2025.pdf | 276 | 2025-08 | Car | BMW | 325d | Silver | Driving without Due Care and Attention | None | Thompson Avenue | Thompson Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5722181 | -2.1205684 | ||
| 2319 | op-snap---monthly-publication-august-2025.pdf | 294 | 2025-08 | Car | BMW | Silver | Driving without Due Care and Attention | None | M6 J4 | M6 J4 | Solihull | Solihull | RTC - Actioned | N/A | 52.6912891 | -2.1046372 | |||
| 2353 | op-snap---monthly-publication-august-2025.pdf | 328 | 2025-08 | Car | BMW | Silver | Driving without Due Care and Attention | None | Brasshouse Lane Smethwick | Brasshouse Lane Smethwick | Sandwell | Sandwell | NFA | No VRM | 52.5006605 | -1.9694988 | |||
| 2428 | op-snap---monthly-publication-august-2025.pdf | 403 | 2025-08 | Motorbike | BMW | 5 series | White | Driving without Due Care and Attention | None | Alcester Road / Salisbury Road | Alcester Road / Salisbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4467548 | -1.8880528 | ||
| 2468 | op-snap---monthly-publication-august-2025.pdf | 443 | 2025-08 | Car | BMW | 320 | Grey | Driving without Due Care and Attention | None | Neachells Lane | Neachells Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.597459 | -2.0791894 | ||
| 2482 | op-snap---monthly-publication-august-2025.pdf | 457 | 2025-08 | Car | BMW | 335d | Blue | Driving without Due Care and Attention | None | Sheepwash Road | Sheepwash Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2496 | op-snap---monthly-publication-august-2025.pdf | 471 | 2025-08 | Car | BMW | 535D | Grey | Driving without Due Care and Attention | None | M6 | M6 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2528 | op-snap---monthly-publication-august-2025.pdf | 503 | 2025-08 | Other | BMW | Black | Driving without Due Care and Attention | None | Sandringham Way Brierley Hill | Sandringham Way Brierley Hill | Dudley | Dudley | Other Action Taken | N/A | 52.4681072 | -2.1288671 | |||
| 2529 | op-snap---monthly-publication-august-2025.pdf | 504 | 2025-08 | Motorbike | BMW | X5 | Blue | Driving without Due Care and Attention | None | Holbeach Road | Holbeach Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 2541 | op-snap---monthly-publication-august-2025.pdf | 516 | 2025-08 | Car | BMW | X5 | Black | Driving without Due Care and Attention | None | A4040 | A4040 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2548 | op-snap---monthly-publication-august-2025.pdf | 523 | 2025-08 | Car | BMW | 1 series | Grey | Driving without Due Care and Attention | None | Lower Prestwood Road | Lower Prestwood Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.609833 | -2.0871598 | ||
| 2577 | op-snap---monthly-publication-august-2025.pdf | 552 | 2025-08 | Car | BMW | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | |||
| 2615 | op-snap---monthly-publication-august-2025.pdf | 590 | 2025-08 | Pedal Bike | BMW | 120D | Black | Driving without Due Care and Attention | None | Rayner Road | Rayner Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 2629 | op-snap---monthly-publication-august-2025.pdf | 604 | 2025-08 | Car | BMW | 320.. | White | Driving without Due Care and Attention | None | Castle Farm Way Priorslee | Castle Farm Way Priorslee | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2648 | op-snap---monthly-publication-august-2025.pdf | 623 | 2025-08 | Pedal Bike | BMW | X1 | Grey | Driving without Due Care and Attention | None | Manor Road | Manor Road | Solihull | Solihull | Warning Letter | N/A | 52.4193737 | -1.7798629 | ||
| 2674 | op-snap---monthly-publication-august-2025.pdf | 649 | 2025-08 | Car | BMW | 118.. | Grey | Driving without Due Care and Attention | None | Egghill Lane | Egghill Lane | Birmingham | Birmingham | Education | N/A | 52.4093768 | -1.9976236 | ||
| 2709 | op-snap---monthly-publication-august-2025.pdf | 684 | 2025-08 | Car | BMW | M3 | Grey | Driving without Due Care and Attention | None | Birmingham New Road Bilston | Birmingham New Road Bilston | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 2726 | op-snap---monthly-publication-august-2025.pdf | 701 | 2025-08 | Car | BMW | X5 | Silver | Driving without Due Care and Attention | None | Holford Drive | Holford Drive | Birmingham | Birmingham | Education | N/A | 52.5216608 | -1.8903521 | ||
| 2738 | op-snap---monthly-publication-august-2025.pdf | 713 | 2025-08 | Car | BMW | 3 Series | White | Driving without Due Care and Attention | No Insurance | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Court | N/A | 52.5083238 | -1.8332287 | ||
| 2757 | op-snap---monthly-publication-august-2025.pdf | 732 | 2025-08 | Car | BMW | 320D | Blue | Driving without Due Care and Attention | None | Green Lane | Green Lane | Coventry | Coventry | Warning Letter | N/A | 52.38188 | -1.5300381 | ||
| 2761 | op-snap---monthly-publication-august-2025.pdf | 736 | 2025-08 | Car | BMW | 4 Series | Green | Driving without Due Care and Attention | None | A528 | A528 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2762 | op-snap---monthly-publication-august-2025.pdf | 737 | 2025-08 | Car | BMW | N/K | Black | Driving without Due Care and Attention | None | M6 South Jct 19 | M6 South Junction 19 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2772 | op-snap---monthly-publication-august-2025.pdf | 747 | 2025-08 | Car | BMW | X5 | Grey | Driving without Due Care and Attention | None | Shrewsbury | Shrewsbury | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 2847 | op-snap---monthly-publication-august-2025.pdf | 822 | 2025-08 | Car | BMW | 340.. | Black | Driving without Due Care and Attention | None | M6 North Jct 10 | M6 North Junction 10 | Walsall | Walsall | Court | N/A | ||||
| 2877 | op-snap---monthly-publication-august-2025.pdf | 852 | 2025-08 | Car | BMW | 335.. | White | Driving without Due Care and Attention | None | Bridge Road Saltley | Bridge Road Saltley | Birmingham | Birmingham | Warning Letter | N/A | 52.4857537 | -1.8531485 | ||
| 2882 | op-snap---monthly-publication-august-2025.pdf | 857 | 2025-08 | Car | BMW | M4 | Blue | Driving without Due Care and Attention | None | Wednesbury Road | Wednesbury Road | Walsall | Walsall | Education | N/A | 52.5738499 | -1.9961575 | ||
| 2883 | op-snap---monthly-publication-august-2025.pdf | 858 | 2025-08 | Car | BMW | 318 | Blue | Driving without Due Care and Attention | None | Brettle Lane | Brettle Lane | Dudley | Dudley | Education | N/A | ||||
| 2902 | op-snap---monthly-publication-august-2025.pdf | 877 | 2025-08 | Car | BMW | White | Driving without Due Care and Attention | None | M40 J13 | M40 J13 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2927 | op-snap---monthly-publication-august-2025.pdf | 902 | 2025-08 | Car | BMW | 320d | Blue | Driving without Due Care and Attention | None | Nechell Parkway | Nechell Parkway | Birmingham | Birmingham | NFA | No VRM | ||||
| 2929 | op-snap---monthly-publication-august-2025.pdf | 904 | 2025-08 | Car | BMW | 320D | Blue | Driving without Due Care and Attention | None | Goodrick WAY | Goodrick WAY | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4940185 | -1.8696608 | ||
| 2939 | op-snap---monthly-publication-august-2025.pdf | 914 | 2025-08 | Other | BMW | 1 series | Blue | Driving without Due Care and Attention | None | Bridle Lane | Bridle Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5742643 | -1.8934596 | ||
| 2962 | op-snap---monthly-publication-august-2025.pdf | 937 | 2025-08 | Car | BMW | 7 series | Grey | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 2974 | op-snap---monthly-publication-august-2025.pdf | 949 | 2025-08 | Car | BMW | 1 | White | Driving without Due Care and Attention | None | M42 J3 to M40 | M42 J3 to M40 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2977 | op-snap---monthly-publication-august-2025.pdf | 952 | 2025-08 | Car | BMW | 3 Series | Grey | Driving without Due Care and Attention | None | City Road | City Road | Birmingham | Birmingham | Education | N/A | 52.4763176 | -1.9584897 | ||
| 3004 | op-snap---monthly-publication-august-2025.pdf | 979 | 2025-08 | Car | BMW | M135I | Grey | Driving without Due Care and Attention | None | Lighthouse Avenue | Lighthouse Avenue | Birmingham | Birmingham | Court | N/A | ||||
| 3023 | op-snap---monthly-publication-august-2025.pdf | 998 | 2025-08 | Pedestrian | BMW | X3 | White | Driving without Due Care and Attention | None | Clapgate Lane | Clapgate Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4417035 | -1.9902817 | ||
| 3040 | op-snap---monthly-publication-august-2025.pdf | 1015 | 2025-08 | Car | BMW | M135i | Grey | Driving without Due Care and Attention | None | Stonehouse Lane | Stonehouse Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4440435 | -1.9818872 | ||
| 3074 | op-snap---monthly-publication-august-2025.pdf | 1049 | 2025-08 | Pedal Bike | BMW | 320 | Red | Driving without Due Care and Attention | None | Brinklow | Brinklow | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3082 | op-snap---monthly-publication-august-2025.pdf | 1057 | 2025-08 | Car | BMW | 320 | Black | Driving without Due Care and Attention | None | Gerrards Street, Lozells | Gerrards Street, Lozells | Birmingham | Birmingham | Education | N/A | ||||
| 3088 | op-snap---monthly-publication-august-2025.pdf | 1063 | 2025-08 | Car | BMW | 118i | Black | Driving without Due Care and Attention | None | Newcastle Road | Newcastle Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3089 | op-snap---monthly-publication-august-2025.pdf | 1064 | 2025-08 | Car | BMW | 335.. | Silver | Driving without Due Care and Attention | None | Richmond Road at Warwick Road | Richmond Road at Warwick Road | Solihull | Solihull | Court | N/A | 52.4430188 | -1.8022218 | ||
| 3096 | op-snap---monthly-publication-august-2025.pdf | 1071 | 2025-08 | Car | BMW | 3 | Silver | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 3108 | op-snap---monthly-publication-august-2025.pdf | 1083 | 2025-08 | Other | BMW | Z3 | Red | Driving without Due Care and Attention | None | Pound Bank Road | Pound Bank Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3170 | op-snap---monthly-publication-august-2025.pdf | 1145 | 2025-08 | Car | BMW | 118.. | Grey | Driving without Due Care and Attention | None | Towards Junction 2 M54 (Feathrstone) Staffs | Towards Junction 2 M54 (Feathrstone) Staffs | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3174 | op-snap---monthly-publication-august-2025.pdf | 1149 | 2025-08 | Car | BMW | 2 Series | Grey | Driving without Due Care and Attention | None | Gledrid | Gledrid | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3175 | op-snap---monthly-publication-august-2025.pdf | 1150 | 2025-08 | Car | BMW | 1 series | White | Driving without Due Care and Attention | None | Silver Eagle Way | Silver Eagle Way | Coventry | Coventry | Warning Letter | N/A | ||||
| 3176 | op-snap---monthly-publication-august-2025.pdf | 1151 | 2025-08 | Car | BMW | 320i | Black | Driving without Due Care and Attention | None | A423 Rugby area, Warwickshire | Rugby area, Warwickshire | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3180 | op-snap---monthly-publication-august-2025.pdf | 1155 | 2025-08 | Pedal Bike | BMW | 118.. | Black | Driving without Due Care and Attention | None | Boleyn Road | Boleyn Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4030543 | -2.0296756 | ||
| 3205 | op-snap---monthly-publication-august-2025.pdf | 1180 | 2025-08 | Car | BMW | S1000 | Silver | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 3217 | op-snap---monthly-publication-august-2025.pdf | 1192 | 2025-08 | Car | BMW | 218D | White | Driving without Due Care and Attention | None | Aldrige Road | Aldridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5368764 | -1.8976461 | ||
| 3377 | op-snap---monthly-publication-august-2025.pdf | 1352 | 2025-08 | Car | BMW | M340d | Grey | Driving without Due Care and Attention | None | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 3404 | op-snap---monthly-publication-august-2025.pdf | 1379 | 2025-08 | Car | BMW | 318I | Red | Driving without Due Care and Attention | None | M6 South Bound towards junction 7 | M6 South Bound towards junction 7 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3459 | op-snap---monthly-publication-august-2025.pdf | 1434 | 2025-08 | Car | BMW | X5 | Grey | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Warning Letter | N/A | 52.5478387 | -2.0943116 | ||
| 3563 | op-snap---monthly-publication-august-2025.pdf | 1538 | 2025-08 | Car | BMW | X6 | Black | Driving without Due Care and Attention | None | Keepers Lane | Keepers Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.615585 | -2.1878558 | ||
| 3594 | op-snap---monthly-publication-august-2025.pdf | 1569 | 2025-08 | Pedestrian | BMW | X5 | Blue | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 3614 | op-snap---monthly-publication-august-2025.pdf | 1589 | 2025-08 | Car | BMW | X4 | Grey | Driving without Due Care and Attention | None | Outside Westwood Academy School | Outside Westwood Academy School | Birmingham | Birmingham | Warning Letter | N/A |
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);