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'}
160 rows where council_area = "Out of Force Area" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
offence 20
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 39
- Misc - Non Traffic Offences 37
- Driving without Due Care and Attention 34
- Cause vehicle to be left in a dangerous position 10
- Using a Mobile Phone Whilst Driving 8
- Contravening a Red Traffic Light 6
- Driving a vehicle wholly or partly on a footpath 5
- Cause unnecessary obstruction by motor vehicle 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Stop a vehicle within pelican pedestrian crossing limits 3
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Dangerous Driving 1
- Drive / Ride / Lead an animal on a footpath 1
- Driving without Reasonable Consideration 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- No Seat Belt 1
- Stop a vehicle on pedestrian crossing 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
month 14
disposal 3
- NFA 149
- Warning Letter 10
- Education 1
reporter_transport_mode 1
- Pedestrian · 160 ✖
council_area 1
- Out of Force Area · 160 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7324 | op-snap---monthly-publication-february-2026.pdf | 71 | 2026-02 | Pedestrian | Ford | Puma | Black | Misc - Non Traffic Offences | None | Halord Lane | Halord Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7332 | op-snap---monthly-publication-february-2026.pdf | 79 | 2026-02 | Pedestrian | Dacia | Jogger | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Queens Road Kenilworth | Queens Road Kenilworth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7409 | op-snap---monthly-publication-february-2026.pdf | 156 | 2026-02 | Pedestrian | Peugeot | 5008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maypole Lane | Maypole Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4046654 | -1.8712644 | ||
| 7441 | op-snap---monthly-publication-february-2026.pdf | 188 | 2026-02 | Pedestrian | Hyundai | I30 | Black | Driving without Due Care and Attention | None | Tachbrook Road | Tachbrook Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7508 | op-snap---monthly-publication-february-2026.pdf | 255 | 2026-02 | Pedestrian | BMW | 325D | Blue | Driving without Due Care and Attention | None | Stratford Upon Avon | Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3499075 | -1.7812051 | ||
| 7570 | op-snap---monthly-publication-february-2026.pdf | 317 | 2026-02 | Pedestrian | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Nuneaton | Nuneaton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4014214 | -1.5189806 | ||
| 7601 | op-snap---monthly-publication-february-2026.pdf | 348 | 2026-02 | Pedestrian | Fiat | Mylife | Blue | Driving without Due Care and Attention | None | Briar Close | Briar Close | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5215268 | -1.8348724 | ||
| 7727 | op-snap---monthly-publication-february-2026.pdf | 474 | 2026-02 | Pedestrian | Ford | Transit | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Off force | Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7774 | op-snap---monthly-publication-february-2026.pdf | 521 | 2026-02 | Pedestrian | Yamaha | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | t None | Rugby | Rugby | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5458823 | -1.7949266 | |||
| 8004 | op-snap---monthly-publication-february-2026.pdf | 751 | 2026-02 | Pedestrian | Mercedes-Benz | GLB | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Milby Drive | Milby Drive | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8005 | op-snap---monthly-publication-february-2026.pdf | 752 | 2026-02 | Pedestrian | Volkswagen | Tiguan | Gold | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lea Lane | Lea Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4835462 | -1.7767904 | ||
| 8035 | op-snap---monthly-publication-february-2026.pdf | 782 | 2026-02 | Pedestrian | Seat | Silver | Driving without Due Care and Attention | None | Brownshore Lane | Brownshore Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8048 | op-snap---monthly-publication-february-2026.pdf | 795 | 2026-02 | Pedestrian | Vauxhall | Mokka | Grey | Contravening a Red Traffic Light | None | Stratford Upon Avon | Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3499075 | -1.7812051 | ||
| 8054 | op-snap---monthly-publication-february-2026.pdf | 801 | 2026-02 | Pedestrian | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Sandford Avenue Church Stretton | Sandford Avenue Church Stretton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8405 | op-snap---monthly-publication-february-2026.pdf | 1152 | 2026-02 | Pedestrian | Porsche | Cayenne | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey Road | Abbey Road | Out of Force Area | Out of Force Area | NFA | 52.5162302 | -1.8593733 | |||
| 8408 | op-snap---monthly-publication-february-2026.pdf | 1155 | 2026-02 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friars Street, Warwick | Friars Street, Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8710 | op-snap---monthly-publication-february-2026.pdf | 1457 | 2026-02 | Pedestrian | Land Rover | freelander | Silver | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 8859 | op-snap---monthly-publication-february-2026.pdf | 1606 | 2026-02 | Pedestrian | Toyota | hilux | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10769 | op-snap---monthly-publication-january-2026.pdf | 230 | 2026-01 | Pedestrian | Grey | Misc - Non Traffic Offences | None | Camp Lane, Worcester | Camp Lane, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 10900 | op-snap---monthly-publication-january-2026.pdf | 361 | 2026-01 | Pedestrian | Audi | Q6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chestnut Close | Chestnut Close | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4531575 | -1.8221982 | ||
| 10944 | op-snap---monthly-publication-january-2026.pdf | 405 | 2026-01 | Pedestrian | Volkswagen | Polo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lidl Tamworth | Lidl Tamworth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11090 | op-snap---monthly-publication-january-2026.pdf | 551 | 2026-01 | Pedestrian | Renault | Clio | Blue | Using a Mobile Phone Whilst Driving | None | out of force blackpool | Out Of Force Blackpool | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11297 | op-snap---monthly-publication-january-2026.pdf | 758 | 2026-01 | Pedestrian | Audi | A5 | Black | Stop a vehicle on pedestrian crossing | None | Oxford Street | Oxford Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4769326 | -1.8875782 | ||
| 11407 | op-snap---monthly-publication-january-2026.pdf | 868 | 2026-01 | Pedestrian | Renault | Megane | Black | Cause vehicle to be left in a dangerous position | None | Marlpool Lane, Kidderminster | Marlpool Lane, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11426 | op-snap---monthly-publication-january-2026.pdf | 887 | 2026-01 | Pedestrian | Vauxhall | Corsa | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No vehicle excise licence | Wolfenden Way (West Yorkshire) | Wolfenden Way (West Yorkshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11512 | op-snap---monthly-publication-january-2026.pdf | 973 | 2026-01 | Pedestrian | BMW | 520D | White | Driving without Due Care and Attention | None | Broad Street | Broad Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.474024 | -1.9163084 | ||
| 11809 | op-snap---monthly-publication-january-2026.pdf | 1270 | 2026-01 | Pedestrian | BMW | 320D | White | No Seat Belt | None | Tesco Kidderminster | Tesco Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5037416 | -2.1806078 | ||
| 11821 | op-snap---monthly-publication-january-2026.pdf | 1282 | 2026-01 | Pedestrian | Toyota | Avensis | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Northwick Road | Northwick Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3574075 | -1.7798401 | ||
| 3946 | op-snap---monthly-publication-december-2025.pdf | 74 | 2025-12 | Pedestrian | Misc - Non Traffic Offences | None | Himley Road | Himley Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5130072 | -2.09584 | |||||
| 4055 | op-snap---monthly-publication-december-2025.pdf | 183 | 2025-12 | Pedestrian | Ford | Yellow | Using a Mobile Phone Whilst Driving | None | Mallards Close | Mallards Close | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4149 | op-snap---monthly-publication-december-2025.pdf | 277 | 2025-12 | Pedestrian | Honda | Motorbike NSS | Blue | Drive / Ride / Lead an animal on a footpath | None | Whitington | Whitington | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4214 | op-snap---monthly-publication-december-2025.pdf | 342 | 2025-12 | Pedestrian | BMW | 3 Series | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Caroline Close | Caroline Close | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5172414 | -1.9775684 | ||
| 4602 | op-snap---monthly-publication-december-2025.pdf | 730 | 2025-12 | Pedestrian | Renault | Clio | Black | Driving without Due Care and Attention | None | Shrewsbury Road | Shrewsbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4669 | op-snap---monthly-publication-december-2025.pdf | 797 | 2025-12 | Pedestrian | BMW | 1 Series | Silver | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4670 | op-snap---monthly-publication-december-2025.pdf | 798 | 2025-12 | Pedestrian | BMW | 3 Series | Black | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4671 | op-snap---monthly-publication-december-2025.pdf | 799 | 2025-12 | Pedestrian | Audi | A4 | Grey | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4685 | op-snap---monthly-publication-december-2025.pdf | 813 | 2025-12 | Pedestrian | Tesla | Model 3 | Black | Misc - Non Traffic Offences | None | Centurion Drive Worcester | Centurion Drive Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 5026 | op-snap---monthly-publication-december-2025.pdf | 1154 | 2025-12 | Pedestrian | Volkswagen | Up | White | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 5122 | op-snap---monthly-publication-december-2025.pdf | 1250 | 2025-12 | Pedestrian | Mitsubishi | Lancer | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Wick | Lower Wick | Out of Force Area | Out of Force Area | NFA | N/A | ||||
| 5126 | op-snap---monthly-publication-december-2025.pdf | 1254 | 2025-12 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Forton Road Telford | Forton Road Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||||
| 5143 | op-snap---monthly-publication-december-2025.pdf | 1271 | 2025-12 | Pedestrian | Audi | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Horsford Road West Mercia | Horsford Road West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 20788 | op-snap---monthly-publication-november-2025.pdf | 330 | 2025-11 | Pedestrian | Ford | Transit | White | Driving without Due Care and Attention | None | School Bank | School Bank | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5149378 | -2.1130096 | ||
| 20829 | op-snap---monthly-publication-november-2025.pdf | 371 | 2025-11 | Pedestrian | Misc - Non Traffic Offences | None | Leicester | Leicester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4145125 | -1.5097639 | |||||
| 20878 | op-snap---monthly-publication-november-2025.pdf | 420 | 2025-11 | Pedestrian | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stoke On Trent | Stoke On Trent | Out of Force Area | Out of Force Area | Warning Letter | N/A | ||||
| 20898 | op-snap---monthly-publication-november-2025.pdf | 440 | 2025-11 | Pedestrian | Ford | C max | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Station Road | Station Road | Out of Force Area | Out of Force Area | Warning Letter | N/A | 52.480771 | -1.8086714 | ||
| 20943 | op-snap---monthly-publication-november-2025.pdf | 485 | 2025-11 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Malvern | Malvern | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4093693 | -1.7713445 | ||
| 20993 | op-snap---monthly-publication-november-2025.pdf | 535 | 2025-11 | Pedestrian | Ford | fiesta | Blue | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21126 | op-snap---monthly-publication-november-2025.pdf | 668 | 2025-11 | Pedestrian | Peugeot | Boxer | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | School Road, Honetbourne | School Road, Honetbourne | Out of Force Area | Out of Force Area | Warning Letter | N/A | ||||
| 21208 | op-snap---monthly-publication-november-2025.pdf | 750 | 2025-11 | Pedestrian | BMW | 1 Series | Grey | Misc - Non Traffic Offences | None | Ramsden Avenue | Ramsden Avenue | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21210 | op-snap---monthly-publication-november-2025.pdf | 752 | 2025-11 | Pedestrian | Kia | Stonic | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stourport Road | Stourport Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21291 | op-snap---monthly-publication-november-2025.pdf | 833 | 2025-11 | Pedestrian | Volkswagen | golf | Grey | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21352 | op-snap---monthly-publication-november-2025.pdf | 894 | 2025-11 | Pedestrian | Skoda | Octavia | Red | Misc - Non Traffic Offences | None | Bidford On Avon | Bidford On Avon | Out of Force Area | Out of Force Area | NFA | No Offence | ||||
| 21448 | op-snap---monthly-publication-november-2025.pdf | 990 | 2025-11 | Pedestrian | Kia | ceed | Grey | Cause vehicle to be left in a dangerous position | None | somer park avenue | Somer Park Avenue | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 21465 | op-snap---monthly-publication-november-2025.pdf | 1007 | 2025-11 | Pedestrian | Daf | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | |||||
| 21559 | op-snap---monthly-publication-november-2025.pdf | 1101 | 2025-11 | Pedestrian | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Leominster bypass A49 | Leominster bypass A49 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21735 | op-snap---monthly-publication-november-2025.pdf | 1277 | 2025-11 | Pedestrian | Peugeot | 207.. | Grey | Driving without Due Care and Attention | No Insurance | Sherwood Road Bromsgrove. | Sherwood Road Bromsgrove | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21806 | op-snap---monthly-publication-november-2025.pdf | 1348 | 2025-11 | Pedestrian | Kia | picanto | Silver | Misc - Non Traffic Offences | None | cambridge | Cambridge | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4652475 | -1.9056734 | ||
| 21919 | op-snap---monthly-publication-november-2025.pdf | 1461 | 2025-11 | Pedestrian | Mini | Mini | White | Driving without Due Care and Attention | None | Filton Road | Filton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5244726 | -1.7880916 | ||
| 22010 | op-snap---monthly-publication-november-2025.pdf | 1552 | 2025-11 | Pedestrian | BMW | 1 series | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Conrad Lewis Way, Warwick | Conrad Lewis Way, Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22420 | op-snap---monthly-publication-october-2025.pdf | 370 | 2025-10 | Pedestrian | Tractor | Red | Misc - Non Traffic Offences | None | Wall Hill Road | Wall Hill Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4459445 | -1.5552508 | |||
| 22451 | op-snap---monthly-publication-october-2025.pdf | 401 | 2025-10 | Pedestrian | BMW | X2 | Blue | Using a Mobile Phone Whilst Driving | None | Stoke Hospital | Stoke Hospital | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22486 | op-snap---monthly-publication-october-2025.pdf | 436 | 2025-10 | Pedestrian | Hyundai | I10 | Red | Contravening a Red Traffic Light | None | Berwick Road, Shrewsbury | Berwick Road, Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23015 | op-snap---monthly-publication-october-2025.pdf | 965 | 2025-10 | Pedestrian | Mercedes-Benz | Vito | White | Driving a vehicle wholly or partly on a footpath | None | Braces Lane | Braces Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23145 | op-snap---monthly-publication-october-2025.pdf | 1095 | 2025-10 | Pedestrian | Other | Misc - Non Traffic Offences | None | warwickshire | Warwickshire | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | 52.4318492 | -1.7319529 | ||||
| 23154 | op-snap---monthly-publication-october-2025.pdf | 1104 | 2025-10 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coalville | Coalville | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23191 | op-snap---monthly-publication-october-2025.pdf | 1141 | 2025-10 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Billsmore Green | Billsmore Green | Out of Force Area | Out of Force Area | NFA | No VRM | 52.4301865 | -1.7747746 | |||||
| 23219 | op-snap---monthly-publication-october-2025.pdf | 1169 | 2025-10 | Pedestrian | Other | Misc - Non Traffic Offences | None | Stock Wood Lodge Farm | Stock Wood Lodge Farm | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 23289 | op-snap---monthly-publication-october-2025.pdf | 1239 | 2025-10 | Pedestrian | Mg | hs | Black | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23366 | op-snap---monthly-publication-october-2025.pdf | 1316 | 2025-10 | Pedestrian | Seat | arona | White | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23408 | op-snap---monthly-publication-october-2025.pdf | 1358 | 2025-10 | Pedestrian | Audi | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bridge Street | Bridge Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.477534 | -1.908097 | |||
| 23422 | op-snap---monthly-publication-october-2025.pdf | 1372 | 2025-10 | Pedestrian | Misc - Non Traffic Offences | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | |||||
| 23445 | op-snap---monthly-publication-october-2025.pdf | 1395 | 2025-10 | Pedestrian | Misc - Non Traffic Offences | None | Borrington Road, Kidderminster | Borrington Road, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||||
| 23565 | op-snap---monthly-publication-october-2025.pdf | 1515 | 2025-10 | Pedestrian | Kia | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Worcester Road. OOF | Worcester Road. OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 23627 | op-snap---monthly-publication-october-2025.pdf | 1577 | 2025-10 | Pedestrian | Ford | Transit | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Northwick Road | Northwick Road | Out of Force Area | Out of Force Area | Warning Letter | N/A | 52.3574075 | -1.7798401 | ||
| 23651 | op-snap---monthly-publication-october-2025.pdf | 1601 | 2025-10 | Pedestrian | Volkswagen | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High St, Clee Hill OOF | High Street, Clee Hill OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 23652 | op-snap---monthly-publication-october-2025.pdf | 1602 | 2025-10 | Pedestrian | Volkswagen | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High St, Clee Hill OOF | High Street, Clee Hill OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 23683 | op-snap---monthly-publication-october-2025.pdf | 1633 | 2025-10 | Pedestrian | Land Rover | Discovery | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High St Clee Hill OOF | High Street Clee Hill OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23703 | op-snap---monthly-publication-october-2025.pdf | 1653 | 2025-10 | Pedestrian | Misc - Non Traffic Offences | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||||
| 23751 | op-snap---monthly-publication-october-2025.pdf | 1701 | 2025-10 | Pedestrian | Mercedes-Benz | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clee Hill High St OOF | Clee Hill High Street OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 24572 | op-snap---monthly-publication-september-2025.pdf | 791 | 2025-09 | Pedestrian | White | Using a Mobile Phone Whilst Driving | None | Baron Avenue, Kettering | Baron Avenue, Kettering | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 24655 | op-snap---monthly-publication-september-2025.pdf | 874 | 2025-09 | Pedestrian | M/C | Red | Misc - Non Traffic Offences | None | Kingsacre Drive | Kingsacre Drive | Out of Force Area | Out of Force Area | NFA | No VRM | |||||
| 24941 | op-snap---monthly-publication-september-2025.pdf | 1160 | 2025-09 | Pedestrian | Peugeot | 2008 | Black | Contravening a Red Traffic Light | None | Worcester, near the river | Worcester, near the river | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24956 | op-snap---monthly-publication-september-2025.pdf | 1175 | 2025-09 | Pedestrian | Mercedes-Benz | CLE300 | Grey | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 24994 | op-snap---monthly-publication-september-2025.pdf | 1213 | 2025-09 | Pedestrian | Yamaha | YZF | Blue | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 25135 | op-snap---monthly-publication-september-2025.pdf | 1354 | 2025-09 | Pedestrian | Dacia | Jogger | Green | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 25136 | op-snap---monthly-publication-september-2025.pdf | 1355 | 2025-09 | Pedestrian | Nissan | Qashqai | White | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Motala Close | Motala Close | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 25419 | op-snap---monthly-publication-september-2025.pdf | 1638 | 2025-09 | Pedestrian | Hyundai | Tuscon | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Gresley | Gresley | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5936518 | -1.8341593 | ||
| 25421 | op-snap---monthly-publication-september-2025.pdf | 1640 | 2025-09 | Pedestrian | Kia | Ceed | Black | Dangerous Driving | None | Clare Street | Clare Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4706879 | -2.0861765 | ||
| 25516 | op-snap---monthly-publication-september-2025.pdf | 1735 | 2025-09 | Pedestrian | Toyota | aeras | White | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | No Offence | ||||
| 25527 | op-snap---monthly-publication-september-2025.pdf | 1746 | 2025-09 | Pedestrian | Peugeot | Black | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 2254 | op-snap---monthly-publication-august-2025.pdf | 229 | 2025-08 | Pedestrian | Unknown | Driving without Due Care and Attention | None | Churchfields | Churchfields | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||||
| 2257 | op-snap---monthly-publication-august-2025.pdf | 232 | 2025-08 | Pedestrian | Bus | Blue | Contravening a Red Traffic Light | None | Easemore Road | Easemore Road | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2274 | op-snap---monthly-publication-august-2025.pdf | 249 | 2025-08 | Pedestrian | Land Rover | Range | Blue | Driving without Due Care and Attention | None | Henry Street, Rugby | Henry Street, Rugby | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2801 | op-snap---monthly-publication-august-2025.pdf | 776 | 2025-08 | Pedestrian | Vauxhall | Astra | Black | Driving without Due Care and Attention | None | M6 Manchester | M6 Manchester | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3188 | op-snap---monthly-publication-august-2025.pdf | 1163 | 2025-08 | Pedestrian | Toyota | Aygo | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A302 (London) | A302 (London) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3189 | op-snap---monthly-publication-august-2025.pdf | 1164 | 2025-08 | Pedestrian | Toyota | Yaris | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A302 (London) | A302 (London) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3255 | op-snap---monthly-publication-august-2025.pdf | 1230 | 2025-08 | Pedestrian | Audi | A3 | Silver | Cause vehicle to be left in a dangerous position | None | Bridge Street, Evesham | Bridge Street, Evesham | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3256 | op-snap---monthly-publication-august-2025.pdf | 1231 | 2025-08 | Pedestrian | Volkswagen | Golf | Silver | Cause vehicle to be left in a dangerous position | None | Bridge Street, Evesham | Bridge Street, Evesham | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3257 | op-snap---monthly-publication-august-2025.pdf | 1232 | 2025-08 | Pedestrian | Honda | Motorcycle | White | Driving without Due Care and Attention | None | Stratford-upon-avon | Stratford-upon-avon | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3278 | op-snap---monthly-publication-august-2025.pdf | 1253 | 2025-08 | Pedestrian | Vauxhall | corsa | Green | Misc - Non Traffic Offences | None | Broseley high Street | Broseley high Street | Out of Force Are | Out of Force Area | NFA | No Offence |
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);