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'}
106 rows where disposal = "Warning Letter", month = "2025-03" and offence = "Driving without Reasonable Consideration" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 27
council_area 9
- Birmingham 64
- Coventry 15
- Solihull 9
- Dudley 6
- Walsall 5
- Sandwell 2
- Sutton Coldfield 2
- Wolverhampton 2
- Metropolitan Borough Of Dudley 1
reporter_transport_mode 5
- Pedal Bike 52
- Car 50
- Pedestrian 2
- Lorry 1
- Other 1
offence 1
- Driving without Reasonable Consideration · 106 ✖
month 1
- 2025-03 · 106 ✖
disposal 1
- Warning Letter · 106 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16390 | op-snap---monthly-publication-march-2025.pdf | 147 | 2025-03 | Pedal Bike | Audi | A5 | Grey | Driving without Reasonable Consideration | None | Icknield Port Road | Icknield Port Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4792334 | -1.92925 | |
| 16416 | op-snap---monthly-publication-march-2025.pdf | 173 | 2025-03 | Pedal Bike | Renault | Clio | Silver | Driving without Reasonable Consideration | None | Newton Road, Scott Arms | Newton Road, Scott Arms | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 16446 | op-snap---monthly-publication-march-2025.pdf | 203 | 2025-03 | Pedal Bike | Daf | Ssmart | Silver | Driving without Reasonable Consideration | None | Selly Park Road | Selly Park Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4390561 | -1.9209229 | |
| 16484 | op-snap---monthly-publication-march-2025.pdf | 241 | 2025-03 | Car | Volkswagen | Passat | Grey | Driving without Reasonable Consideration | None | Key Way | Key Way | Wolverhampton | Wolverhampton | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | |||
| 16485 | op-snap---monthly-publication-march-2025.pdf | 242 | 2025-03 | Car | Ford | Focus | Red | Driving without Reasonable Consideration | None | Inkerman Street | Inkerman Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5898145 | -2.1098908 | |
| 16505 | op-snap---monthly-publication-march-2025.pdf | 262 | 2025-03 | Pedal Bike | Hyundai | Kona | Black | Driving without Reasonable Consideration | None | Grange Road | Grange Road | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | Yes - Via Email | 52.4460133 | -1.9330868 | |
| 16509 | op-snap---monthly-publication-march-2025.pdf | 266 | 2025-03 | Car | Vauxhall | Insignia | Grey | Driving without Reasonable Consideration | None | North Island | North Island | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | |||
| 16568 | op-snap---monthly-publication-march-2025.pdf | 325 | 2025-03 | Car | Hyundai | i20 | Blue | Driving without Reasonable Consideration | None | Gillott Road | Gillott Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4791408 | -1.9467501 | |
| 16579 | op-snap---monthly-publication-march-2025.pdf | 336 | 2025-03 | Pedal Bike | Toyota | Yaris | Black | Driving without Reasonable Consideration | None | Walsall Wood Road | Walsall Wood Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5623476 | -1.9436356 | |
| 16637 | op-snap---monthly-publication-march-2025.pdf | 394 | 2025-03 | Pedal Bike | Mercedes-Benz | GLA 220 | White | Driving without Reasonable Consideration | None | Dickens Heath Road | Dickens Heath Road | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.3875525 | -1.8339426 | |
| 16638 | op-snap---monthly-publication-march-2025.pdf | 395 | 2025-03 | Pedal Bike | Ford | Transit | Grey | Driving without Reasonable Consideration | None | Frogmill Lane | Frogmill Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4023807 | -2.0047634 | |
| 16774 | op-snap---monthly-publication-march-2025.pdf | 531 | 2025-03 | Pedal Bike | Nissan | NAVARA | White | Driving without Reasonable Consideration | None | BRISTOL ROAD | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 16778 | op-snap---monthly-publication-march-2025.pdf | 535 | 2025-03 | Pedal Bike | Land Rover | EVOQUE | Black | Driving without Reasonable Consideration | None | UPPER HOLLAND ROAD | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 16804 | op-snap---monthly-publication-march-2025.pdf | 561 | 2025-03 | Car | Mercedes-Benz | A CLASS | Grey | Driving without Reasonable Consideration | None | BELGRAVE INTERCHANGE | Belgrave Interchange | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.466118 | -1.8982999 | |
| 16875 | op-snap---monthly-publication-march-2025.pdf | 632 | 2025-03 | Car | Citroen | Belingo | Silver | Driving without Reasonable Consideration | None | Dumblederry Lane | Dumblederry Lane | Walsall | Walsall | Warning Letter | N/A | Yes - Via Email | 52.6069109 | -1.9342315 | |
| 16876 | op-snap---monthly-publication-march-2025.pdf | 633 | 2025-03 | Car | Seat | Leon | Black | Driving without Reasonable Consideration | None | Bridle Lane | Bridle Lane | Walsall | Walsall | Warning Letter | N/A | Yes - Via Email | 52.5742643 | -1.8934596 | |
| 16888 | op-snap---monthly-publication-march-2025.pdf | 645 | 2025-03 | Pedal Bike | Ford | Transit | White | Driving without Reasonable Consideration | None | Friday Lane | Friday Lane | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.4142542 | -1.7217662 | |
| 16903 | op-snap---monthly-publication-march-2025.pdf | 660 | 2025-03 | Pedal Bike | Volkswagen | Caddy | White | Driving without Reasonable Consideration | None | Long Acre | Long Acre | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5051253 | -1.8646383 | |
| 16904 | op-snap---monthly-publication-march-2025.pdf | 661 | 2025-03 | Car | Toyota | Purple | Driving without Reasonable Consideration | None | Long Acre | Long Acre | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5051253 | -1.8646383 | ||
| 16906 | op-snap---monthly-publication-march-2025.pdf | 663 | 2025-03 | Car | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | Thimble Mill Lane | Thimble Mill Lane | Birmingham | Birmingham | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4965745 | -1.8714709 | |
| 16910 | op-snap---monthly-publication-march-2025.pdf | 667 | 2025-03 | Pedestrian | Mercedes-Benz | Black | Driving without Reasonable Consideration | No Insurance | Thimble Mill Lane | Thimble Mill Lane | Sandwell | Sandwell | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | ||||
| 16911 | op-snap---monthly-publication-march-2025.pdf | 668 | 2025-03 | Pedestrian | Vauxhall | Astra | Grey | Driving without Reasonable Consideration | None | Long Acre Road | Long Acre Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 16961 | op-snap---monthly-publication-march-2025.pdf | 718 | 2025-03 | Car | BMW | 320D | Silver | Driving without Reasonable Consideration | None | Queensland Avenue | Queensland Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.406658 | -1.5363495 | |
| 16969 | op-snap---monthly-publication-march-2025.pdf | 726 | 2025-03 | Pedal Bike | Peugeot | 308 | Grey | Driving without Reasonable Consideration | None | Cliff Road Road | Cliff Road Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | |||
| 16976 | op-snap---monthly-publication-march-2025.pdf | 733 | 2025-03 | Car | Mazda | 3 | White | Driving without Reasonable Consideration | None | Angesley Avenue | Angesley Avenue | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17002 | op-snap---monthly-publication-march-2025.pdf | 759 | 2025-03 | Pedal Bike | Toyota | Prius | White | Driving without Reasonable Consideration | None | Humber Road | Humber Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4050667 | -1.4866877 | |
| 17014 | op-snap---monthly-publication-march-2025.pdf | 771 | 2025-03 | Pedal Bike | Mercedes-Benz | Box van | White | Driving without Reasonable Consideration | None | Holiday Street | Holiday Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4757071 | -1.8988573 | |
| 17016 | op-snap---monthly-publication-march-2025.pdf | 773 | 2025-03 | Pedal Bike | Audi | A3 | Silver | Driving without Reasonable Consideration | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.471632 | -1.9456776 | |
| 17050 | op-snap---monthly-publication-march-2025.pdf | 807 | 2025-03 | Pedal Bike | Lexus | ch200 | Black | Driving without Reasonable Consideration | None | Grantham Road | Grantham Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4624098 | -1.8708709 | |
| 17054 | op-snap---monthly-publication-march-2025.pdf | 811 | 2025-03 | Pedal Bike | Vauxhall | Astra | Blue | Driving without Reasonable Consideration | None | Foles Hill Road | Foleshill Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17056 | op-snap---monthly-publication-march-2025.pdf | 813 | 2025-03 | Pedal Bike | Honda | Jazz | Blue | Driving without Reasonable Consideration | None | Warwick Road | Warwick Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.401916 | -1.5154953 | |
| 17132 | op-snap---monthly-publication-march-2025.pdf | 889 | 2025-03 | Car | Kia | Sportage | Grey | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.5021946 | -1.7719526 | |
| 17218 | op-snap---monthly-publication-march-2025.pdf | 975 | 2025-03 | Car | Renault | Clio | White | Driving without Reasonable Consideration | None | Daventry Road | Daventry Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3930931 | -1.4976428 | |
| 17239 | op-snap---monthly-publication-march-2025.pdf | 996 | 2025-03 | Car | Seat | Ateca | White | Driving without Reasonable Consideration | None | Woodburn Road | Woodburn Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17304 | op-snap---monthly-publication-march-2025.pdf | 1061 | 2025-03 | Pedal Bike | Kia | Sportage | White | Driving without Reasonable Consideration | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.418488 | -1.5472387 | |
| 17338 | op-snap---monthly-publication-march-2025.pdf | 1095 | 2025-03 | Car | Ford | Focus | Silver | Driving without Reasonable Consideration | None | Heartlands Parkway | Heartlands Parkway | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5038363 | -1.8432663 | |
| 17355 | op-snap---monthly-publication-march-2025.pdf | 1112 | 2025-03 | Pedal Bike | Volvo | XC40 | Blue | Driving without Reasonable Consideration | None | Quinton Rd | Quinton Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.447826 | -1.9574468 | |
| 17391 | op-snap---monthly-publication-march-2025.pdf | 1148 | 2025-03 | Car | Mini | Cooper | Grey | Driving without Reasonable Consideration | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 17392 | op-snap---monthly-publication-march-2025.pdf | 1149 | 2025-03 | Car | Ford | Kuga | Blue | Driving without Reasonable Consideration | None | Monkspath Hall Road | Monkspath Hall Road | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.3900358 | -1.8026595 | |
| 17408 | op-snap---monthly-publication-march-2025.pdf | 1165 | 2025-03 | Car | Citroen | C3 | Blue | Driving without Reasonable Consideration | None | Islington Middleway | Islington Middleway | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4713211 | -1.91264 | |
| 17464 | op-snap---monthly-publication-march-2025.pdf | 1221 | 2025-03 | Pedal Bike | Ford | Transit | Silver | Driving without Reasonable Consideration | None | Hill Street | Hill Street | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4094312 | -1.51615 | |
| 17465 | op-snap---monthly-publication-march-2025.pdf | 1222 | 2025-03 | Pedal Bike | Ford | Focus | Black | Driving without Reasonable Consideration | None | Queen Victoria Road | Queen Victoria Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4063195 | -1.5157306 | |
| 17471 | op-snap---monthly-publication-march-2025.pdf | 1228 | 2025-03 | Car | Ford | Transit | Grey | Driving without Reasonable Consideration | None | London Road | London Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3916468 | -1.4925995 | |
| 17481 | op-snap---monthly-publication-march-2025.pdf | 1238 | 2025-03 | Car | Ford | Transit | White | Driving without Reasonable Consideration | None | Lilly Lane A441 | Lilly Lane A441 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17504 | op-snap---monthly-publication-march-2025.pdf | 1261 | 2025-03 | Pedal Bike | Ford | Ranger | Black | Driving without Reasonable Consideration | None | Warwick Road | Warwick Road | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.4428606 | -1.812114 | |
| 17514 | op-snap---monthly-publication-march-2025.pdf | 1271 | 2025-03 | Pedal Bike | Chevrolet | Trax | White | Driving without Reasonable Consideration | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 17588 | op-snap---monthly-publication-march-2025.pdf | 1345 | 2025-03 | Lorry | Renault | Trucks | White | Driving without Reasonable Consideration | None | M6 Junction 6-7 Southbound | M6 Junction 6-7 Southbound | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.676119 | -2.0858425 | |
| 17598 | op-snap---monthly-publication-march-2025.pdf | 1355 | 2025-03 | Car | Ford | kuga | silver | Driving without Reasonable Consideration | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.430111 | -1.9753703 | |
| 17625 | op-snap---monthly-publication-march-2025.pdf | 1382 | 2025-03 | Pedal Bike | Audi | A3 | Silver | Driving without Reasonable Consideration | No vehicle excise licence | Lea Road | Lea Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4533235 | -1.8606305 | |
| 17747 | op-snap---monthly-publication-march-2025.pdf | 1504 | 2025-03 | Pedal Bike | Ford | Fiesta | Blue | Driving without Reasonable Consideration | None | Highfield road | Highfield road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4216321 | -1.855984 | |
| 17832 | op-snap---monthly-publication-march-2025.pdf | 1589 | 2025-03 | Car | BMW | 218 | Silver | Driving without Reasonable Consideration | None | Wrentham St | Wrentham Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4708757 | -1.8966158 | |
| 17850 | op-snap---monthly-publication-march-2025.pdf | 1607 | 2025-03 | Pedal Bike | Ford | Ranger | Black | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17852 | op-snap---monthly-publication-march-2025.pdf | 1609 | 2025-03 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Reasonable Consideration | None | Chester Rd | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17908 | op-snap---monthly-publication-march-2025.pdf | 1665 | 2025-03 | Pedal Bike | Ford | Minibus | White | Driving without Reasonable Consideration | None | Primrose Hill, Kings Norton | Primrose Hill, Kings Norton | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.3967197 | -1.924102 | |
| 17909 | op-snap---monthly-publication-march-2025.pdf | 1666 | 2025-03 | Car | Ford | transit | Grey | Driving without Reasonable Consideration | None | Halesown Road | Halesown Road | Dudley | Dudley | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | |||
| 17920 | op-snap---monthly-publication-march-2025.pdf | 1677 | 2025-03 | Car | Renault | Scenic | Blue | Driving without Reasonable Consideration | None | Edinburgh Road | Edinburgh Road | Walsall | Walsall | Warning Letter | N/A | Yes - Via Email | 52.5761712 | -1.9594293 | |
| 17922 | op-snap---monthly-publication-march-2025.pdf | 1679 | 2025-03 | Car | Ford | Transit | Black | Driving without Reasonable Consideration | None | Stafford Street | Stafford Street | Walsall | Walsall | Warning Letter | N/A | Yes - Via Email | 52.5899955 | -1.9853333 | |
| 17929 | op-snap---monthly-publication-march-2025.pdf | 1686 | 2025-03 | Car | Mercedes-Benz | GLA250 | Black | Driving without Reasonable Consideration | None | Lee Bank Middleway | Lee Bank Middleway | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4677721 | -1.9037358 | |
| 17932 | op-snap---monthly-publication-march-2025.pdf | 1689 | 2025-03 | Car | Mini | Cooper | Black | Driving without Reasonable Consideration | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4555288 | -1.8613929 | |
| 17977 | op-snap---monthly-publication-march-2025.pdf | 1734 | 2025-03 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Reasonable Consideration | None | Gillhurst Lane | Gillhurst Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17978 | op-snap---monthly-publication-march-2025.pdf | 1735 | 2025-03 | Car | Volkswagen | Tiguan | Grey | Driving without Reasonable Consideration | None | Mackadown Lane | Mackadown Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4708415 | -1.7675939 | |
| 17991 | op-snap---monthly-publication-march-2025.pdf | 1748 | 2025-03 | Car | Volkswagen | Toureg | Grey | Driving without Reasonable Consideration | None | M5 Junction 1 - 2 | M5 Junction 1 - 2 | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | |||
| 18011 | op-snap---monthly-publication-march-2025.pdf | 1768 | 2025-03 | Pedal Bike | Volvo | XC40 | Blue | Driving without Reasonable Consideration | None | Maynard Avenue | Maynard Avenue | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4464709 | -2.1663682 | |
| 18036 | op-snap---monthly-publication-march-2025.pdf | 1793 | 2025-03 | Other | Volkswagen | Golf | Grey | Driving without Reasonable Consideration | None | Tower Street | Tower Street | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 18153 | op-snap---monthly-publication-march-2025.pdf | 1910 | 2025-03 | Car | Ford | Focus | Red | Driving without Reasonable Consideration | None | The Mill Walk | The Mill Walk | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4021031 | -1.9732141 | |
| 18168 | op-snap---monthly-publication-march-2025.pdf | 1925 | 2025-03 | Pedal Bike | Porsche | Taycan | White | Driving without Reasonable Consideration | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.471632 | -1.9456776 | |
| 18181 | op-snap---monthly-publication-march-2025.pdf | 1938 | 2025-03 | Pedal Bike | Volkswagen | Golf | Blue | Driving without Reasonable Consideration | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4308271 | -1.920078 | |
| 18187 | op-snap---monthly-publication-march-2025.pdf | 1944 | 2025-03 | Pedal Bike | Toyota | Corolla | White | Driving without Reasonable Consideration | None | Hil Street | Hil Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 18193 | op-snap---monthly-publication-march-2025.pdf | 1950 | 2025-03 | Pedal Bike | Vauxhall | ASTRA | Grey | Driving without Reasonable Consideration | None | HEATH LANE | Heath Lane | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4495524 | -2.1459067 | |
| 18230 | op-snap---monthly-publication-march-2025.pdf | 1987 | 2025-03 | Pedal Bike | Nissan | Qashqai | Silver | Driving without Reasonable Consideration | None | Booths Lane, Queslett | Booths Lane, Queslett | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5426102 | -1.9049087 | |
| 18234 | op-snap---monthly-publication-march-2025.pdf | 1991 | 2025-03 | Car | Lexus | RX450 | Silver | Driving without Reasonable Consideration | None | Hinkley Road | Hinkley Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | |||
| 18235 | op-snap---monthly-publication-march-2025.pdf | 1992 | 2025-03 | Pedal Bike | Volkswagen | Arteon | Grey | Driving without Reasonable Consideration | None | Birmingham Road, Wylde Green | Birmingham Road, Wylde Green | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5352433 | -1.8276127 | |
| 18240 | op-snap---monthly-publication-march-2025.pdf | 1997 | 2025-03 | Car | Daf | HGV | Red | Driving without Reasonable Consideration | None | Lichfield Road | Lichfield Road | Walsall | Walsall | Warning Letter | N/A | Yes - Via Email | 52.6095168 | -2.0493009 | |
| 18280 | op-snap---monthly-publication-march-2025.pdf | 2037 | 2025-03 | Pedal Bike | Toyota | Corolla | Red | Driving without Reasonable Consideration | None | Ansty Road | Ansty Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4205675 | -1.4520187 | |
| 18284 | op-snap---monthly-publication-march-2025.pdf | 2041 | 2025-03 | Car | Mercedes-Benz | C250 | Black | Driving without Reasonable Consideration | None | Dog Kennel Lane | Dog Kennel Lane | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.3916957 | -1.8169275 | |
| 18316 | op-snap---monthly-publication-march-2025.pdf | 2073 | 2025-03 | Pedal Bike | Nissan | Note | White | Driving without Reasonable Consideration | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.4014694 | -1.8220541 | |
| 18321 | op-snap---monthly-publication-march-2025.pdf | 2078 | 2025-03 | Car | Ford | Focus | Black | Driving without Reasonable Consideration | None | A444, jn with A46, Coventry | A444, jn with A46, Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | |||
| 18323 | op-snap---monthly-publication-march-2025.pdf | 2080 | 2025-03 | Car | Toyota | Corolla | Black | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18325 | op-snap---monthly-publication-march-2025.pdf | 2082 | 2025-03 | Car | Mercedes-Benz | C class | White | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18326 | op-snap---monthly-publication-march-2025.pdf | 2083 | 2025-03 | Car | Audi | Q3 | Black | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18327 | op-snap---monthly-publication-march-2025.pdf | 2084 | 2025-03 | Car | Chevrolet | Jeep Compass | Grey | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18328 | op-snap---monthly-publication-march-2025.pdf | 2085 | 2025-03 | Car | Ford | Fiesta | Grey | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18329 | op-snap---monthly-publication-march-2025.pdf | 2086 | 2025-03 | Car | Volkswagen | Golf | Black | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18331 | op-snap---monthly-publication-march-2025.pdf | 2088 | 2025-03 | Car | Volkswagen | Tiguan | White | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18332 | op-snap---monthly-publication-march-2025.pdf | 2089 | 2025-03 | Car | Toyota | Prius | Grey | Driving without Reasonable Consideration | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 18334 | op-snap---monthly-publication-march-2025.pdf | 2091 | 2025-03 | Car | Land Rover | Sport | Black | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 18375 | op-snap---monthly-publication-march-2025.pdf | 2132 | 2025-03 | Car | Vauxhall | Astra | Black | Driving without Reasonable Consideration | None | Lode Lane | Lode Lane | Solihull | Solihull | Warning Letter | N/A | Yes - Via Email | 52.4149064 | -1.7832364 | |
| 18415 | op-snap---monthly-publication-march-2025.pdf | 2172 | 2025-03 | Pedal Bike | Ford | Transit | Black | Driving without Reasonable Consideration | None | Much Park Street | Much Park Street | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4061531 | -1.505845 | |
| 18422 | op-snap---monthly-publication-march-2025.pdf | 2179 | 2025-03 | Pedal Bike | Toyota | Auris | Grey | Driving without Reasonable Consideration | None | Hospital Way | Hospital Way | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4492818 | -1.9391685 | |
| 18428 | op-snap---monthly-publication-march-2025.pdf | 2185 | 2025-03 | Car | Honda | Cr - V | Black | Driving without Reasonable Consideration | None | New John Street West | New John Street West | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4944784 | -1.9122329 | |
| 18429 | op-snap---monthly-publication-march-2025.pdf | 2186 | 2025-03 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Reasonable Consideration | None | CHESTER ROAD | Chester Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 18474 | op-snap---monthly-publication-march-2025.pdf | 2231 | 2025-03 | Car | Nissan | JUKE | White | Driving without Reasonable Consideration | None | BIRMINGHAM ROAD | Birmingham Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5505398 | -1.8252993 | |
| 18511 | op-snap---monthly-publication-march-2025.pdf | 2268 | 2025-03 | Pedal Bike | Volkswagen | CADDY | White | Driving without Reasonable Consideration | None | NORTHFIELD ROAD | Northfield Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4167654 | -1.9411244 | |
| 18531 | op-snap---monthly-publication-march-2025.pdf | 2288 | 2025-03 | Car | Hyundai | Tuscon | White | Driving without Reasonable Consideration | None | A45 | A45 | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | |||
| 18539 | op-snap---monthly-publication-march-2025.pdf | 2296 | 2025-03 | Pedal Bike | Skoda | Octavia | Silver | Driving without Reasonable Consideration | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4308271 | -1.920078 | |
| 18544 | op-snap---monthly-publication-march-2025.pdf | 2301 | 2025-03 | Pedal Bike | Volkswagen | Transporter | Black | Driving without Reasonable Consideration | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4437078 | -1.8783408 | |
| 18549 | op-snap---monthly-publication-march-2025.pdf | 2306 | 2025-03 | Pedal Bike | Lamborghini | Urus | Blue | Driving without Reasonable Consideration | No Insurance | A38 | A38 | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18550 | op-snap---monthly-publication-march-2025.pdf | 2307 | 2025-03 | Pedal Bike | Volvo | XC90 | Grey | Driving without Reasonable Consideration | None | A38 | A38 | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18584 | op-snap---monthly-publication-march-2025.pdf | 2341 | 2025-03 | Pedal Bike | Volkswagen | Golf | Black | Driving without Reasonable Consideration | None | Wyhcal Lane | Wyhcal Lane | Birmingham | Birmingham | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | |||
| 18599 | op-snap---monthly-publication-march-2025.pdf | 2356 | 2025-03 | Pedal Bike | Nissan | Juke | Purple | Driving without Reasonable Consideration | None | Pritchatts Road | Pritchatts Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4522304 | -1.9267446 |
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);