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'}
86 rows where council_area = "Walsall" and month = "2025-05" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 24
offence 14
- Contravening a Red Traffic Light 34
- Driving without Due Care and Attention 27
- Using a Mobile Phone Whilst Driving 9
- Misc - Non Traffic Offences 3
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 2
- Driving without Reasonable Consideration 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Cause vehicle to be left in a dangerous position 1
- Contravene Lane Closure Red X 1
- Dangerous Driving 1
- Driver not in position to have Proper Control 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
disposal 7
- NFA 42
- Warning Letter 17
- Education 15
- Fixed Penalty 9
- Court 1
- Other Action Taken 1
- RTC - Actioned 1
reporter_transport_mode 6
- Car 43
- Pedal Bike 21
- Pedestrian 19
- Lorry 1
- Other 1
- car 1
month 1
- 2025-05 · 86 ✖
council_area 1
- Walsall · 86 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18673 | op-snap---monthly-publication-may-2025.pdf | 35 | 2025-05 | Car | Ford | Focus | Black | Using a Mobile Phone Whilst Driving | None | Field Road | Field Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6185043 | -1.9962803 | ||
| 18690 | op-snap---monthly-publication-may-2025.pdf | 52 | 2025-05 | Car | Honda | C-RV | Grey | Contravening a Red Traffic Light | None | St Paul Street | Street Paul Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5857518 | -1.9828836 | ||
| 18705 | op-snap---monthly-publication-may-2025.pdf | 67 | 2025-05 | Car | Vauxhall | Corsa | Black | Using a Mobile Phone Whilst Driving | None | Lord Street Walsall | Lord Street Walsall | Walsall | Walsall | Fixed Penalty | N/A | 52.5700579 | -1.9889188 | ||
| 18714 | op-snap---monthly-publication-may-2025.pdf | 76 | 2025-05 | Car | Honda | Insight | Silver | Misc - Non Traffic Offences | None | M6 NB J9 | M6 Northbound J9 | Walsall | Walsall | Other Action Taken | nN/A | 52.676119 | -2.0858425 | ||
| 18765 | op-snap---monthly-publication-may-2025.pdf | 127 | 2025-05 | Car | Driving without Due Care and Attention | None | WATLING STREET A5 | Watling Street A5 | Walsall | Walsall | Education | N/A | 52.6562907 | -1.9111505 | |||||
| 18766 | op-snap---monthly-publication-may-2025.pdf | 128 | 2025-05 | Car | Driving without Due Care and Attention | None | WATLING STREET A5 | Watling Street A5 | Walsall | Walsall | Education | N/A | 52.6562907 | -1.9111505 | |||||
| 18768 | op-snap---monthly-publication-may-2025.pdf | 130 | 2025-05 | Car | Renault | TRAFIC | Silver | Driving without Due Care and Attention | None | WATLING STREET A5 | Watling Street A5 | Walsall | Walsall | Fixed Penalty | N/A | 52.6562907 | -1.9111505 | ||
| 18772 | op-snap---monthly-publication-may-2025.pdf | 134 | 2025-05 | Car | Land Rover | Range Rover | Green | Contravening a Red Traffic Light | None | Broadway Walsall | Broadway Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5719937 | -1.9639882 | ||
| 18791 | op-snap---monthly-publication-may-2025.pdf | 153 | 2025-05 | Car | Citroen | Xsara | Silver | Contravening a Red Traffic Light | None | Blue Lane West | Blue Lane West | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5880833 | -1.9891415 | ||
| 18799 | op-snap---monthly-publication-may-2025.pdf | 161 | 2025-05 | Pedestrian | Iveco | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Birmingham Road Aldridge | Birmingham Road Aldridge | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5766298 | -1.9685663 | |||
| 18822 | op-snap---monthly-publication-may-2025.pdf | 184 | 2025-05 | Car | Iveco | HGV | White | Misc - Non Traffic Offences | None | M6 South | M6 South | Walsall | Walsall | NFA | Not in Public Interest | 52.6170728 | -2.030393 | ||
| 18883 | op-snap---monthly-publication-may-2025.pdf | 245 | 2025-05 | Pedestrian | Ford | Transit | Blue | No Seat Belt | None | A$148 Walsall | A$148 Walsall | Walsall | Walsall | Warning Letter | N/A | 52.629207 | -1.9300274 | ||
| 18884 | op-snap---monthly-publication-may-2025.pdf | 246 | 2025-05 | Pedestrian | Jaguar | XF... | Grey | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18887 | op-snap---monthly-publication-may-2025.pdf | 249 | 2025-05 | Pedestrian | BMW | 535 D | Silver | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18889 | op-snap---monthly-publication-may-2025.pdf | 251 | 2025-05 | Pedestrian | Audi | A5 | Grey | Contravening a Red Traffic Light | None | A4148 | A4148 | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 18893 | op-snap---monthly-publication-may-2025.pdf | 255 | 2025-05 | Car | Volkswagen | Golf | Silver | Using a Mobile Phone Whilst Driving | None | A34 Walsall Road | Walsall Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6166864 | -1.9660822 | ||
| 18896 | op-snap---monthly-publication-may-2025.pdf | 258 | 2025-05 | Car | Mercedes-Benz | S class | Black | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | NFA | Outside of 14 DAYS Late Submission | 52.5867763 | -2.0104342 | ||
| 18905 | op-snap---monthly-publication-may-2025.pdf | 267 | 2025-05 | Pedal Bike | Driving without Due Care and Attention | None | Corporation street | Corporation street | Walsall | Walsall | NFA | No VRM | 52.5773099 | -1.9850716 | |||||
| 18906 | op-snap---monthly-publication-may-2025.pdf | 268 | 2025-05 | Pedal Bike | Mercedes-Benz | A class | Red | Contravening a Red Traffic Light | None | Walstead Road | Walstead Road | Walsall | Walsall | NFA | Outside of 14 DAYS Late Submission | 52.5648629 | -1.9517624 | ||
| 18973 | op-snap---monthly-publication-may-2025.pdf | 335 | 2025-05 | Pedal Bike | Volkswagen | Transporter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wolverhampton Road West Walsall | Wolverhampton Road West Walsall | Walsall | Walsall | Warning Letter | N/A | 52.586437 | -2.0276998 | ||
| 19032 | op-snap---monthly-publication-may-2025.pdf | 394 | 2025-05 | Pedestrian | Land Rover | Range Rover | Black | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19033 | op-snap---monthly-publication-may-2025.pdf | 395 | 2025-05 | Pedestrian | Ford | Puma | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19035 | op-snap---monthly-publication-may-2025.pdf | 397 | 2025-05 | Pedestrian | Vauxhall | Corsa | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19039 | op-snap---monthly-publication-may-2025.pdf | 401 | 2025-05 | Pedestrian | Toyota | MPV | White | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19040 | op-snap---monthly-publication-may-2025.pdf | 402 | 2025-05 | Pedestrian | Grey | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||||
| 19048 | op-snap---monthly-publication-may-2025.pdf | 410 | 2025-05 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Walsall | Walsall | NFA | Outside of 14 DAYS Late Submission | 52.5692139 | -1.8799672 | ||
| 19071 | op-snap---monthly-publication-may-2025.pdf | 433 | 2025-05 | Car | BMW | M4 | Grey | Using a Mobile Phone Whilst Driving | NONE | M6 JUNCTION 9 | M6 Junction 9 | Walsall | Walsall | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 19103 | op-snap---monthly-publication-may-2025.pdf | 465 | 2025-05 | Car | Audi | A3 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | ROOKERY LANE . ALDRIDGE | Rookery Lane . Aldridge | Walsall | Walsall | NFA | No Offence | 52.6036562 | -1.9157561 | ||
| 19125 | op-snap---monthly-publication-may-2025.pdf | 487 | 2025-05 | Car | Renault | Megane | Silver | Driving without Due Care and Attention | None | Ashmore Lake Road | Ashmore Lake Road | Walsall | Walsall | Education | N/A | 52.5961284 | -2.0497272 | ||
| 19189 | op-snap---monthly-publication-may-2025.pdf | 551 | 2025-05 | Pedestrian | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Bosty Lane | Bosty Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5948329 | -1.927787 | ||
| 19199 | op-snap---monthly-publication-may-2025.pdf | 561 | 2025-05 | Car | Ford | TRANSIT | White | Contravening a Red Traffic Light | None | CHASE ROAD | Chase Road | Walsall | Walsall | Education | N/A | 52.6146822 | -2.0143222 | ||
| 19235 | op-snap---monthly-publication-may-2025.pdf | 597 | 2025-05 | Car | Iveco | Daily | Yellow | Driving without Due Care and Attention | No Insurance | Birmingham Road Walsall | Birmingham Road Walsall | Walsall | Walsall | Court | N/A | 52.5718546 | -1.9579366 | ||
| 19247 | op-snap---monthly-publication-may-2025.pdf | 609 | 2025-05 | Car | BMW | 3 series | White | Using a Mobile Phone Whilst Driving | None | Wilkin Road, Brownhills | Wilkin Road, Brownhills | Walsall | Walsall | Fixed Penalty | N/A | 52.6580428 | -1.9502105 | ||
| 19314 | op-snap---monthly-publication-may-2025.pdf | 676 | 2025-05 | Pedal Bike | Mini | Countryman | Grey | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Walsall | Walsall | Warning Letter | N/A | 52.5692139 | -1.8799672 | ||
| 19337 | op-snap---monthly-publication-may-2025.pdf | 699 | 2025-05 | Pedestrian | Mazda | CX-5 | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19338 | op-snap---monthly-publication-may-2025.pdf | 700 | 2025-05 | Pedestrian | Mazda | CX-30 | White | Contravening a Red Traffic Light | None | Daw End lane | Daw End lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19339 | op-snap---monthly-publication-may-2025.pdf | 701 | 2025-05 | Pedestrian | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Daw End lane | Daw End lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19341 | op-snap---monthly-publication-may-2025.pdf | 703 | 2025-05 | Pedal Bike | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19342 | op-snap---monthly-publication-may-2025.pdf | 704 | 2025-05 | Pedal Bike | Seat | Ibiza | Red | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Warning Letter | N/A | 52.6068849 | -1.9611652 | ||
| 19343 | op-snap---monthly-publication-may-2025.pdf | 705 | 2025-05 | Pedal Bike | Volkswagen | Passatt | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19344 | op-snap---monthly-publication-may-2025.pdf | 706 | 2025-05 | Pedal Bike | Ford | Puma | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19346 | op-snap---monthly-publication-may-2025.pdf | 708 | 2025-05 | Pedal Bike | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19356 | op-snap---monthly-publication-may-2025.pdf | 718 | 2025-05 | Car | Skoda | Superb | Black | Driving without Due Care and Attention | None | Broadway north | Broadway north | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 19379 | op-snap---monthly-publication-may-2025.pdf | 741 | 2025-05 | Car | Mercedes-Benz | GLE | Grey | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Walsall | Walsall | NFA | Outside of 14 DAYS Late Submission | 52.6095168 | -2.0493009 | ||
| 19427 | op-snap---monthly-publication-may-2025.pdf | 789 | 2025-05 | Car | Ford | Fiesta | Blue | Driver not in position to have Proper Control | None | M6 Cannock | M6 Cannock | Walsall | Walsall | NFA | No Independent Evidence Available | 52.6610423 | -1.9498692 | ||
| 19472 | op-snap---monthly-publication-may-2025.pdf | 834 | 2025-05 | Lorry | Vauxhall | Astra | Red | Contravening a Red Traffic Light | None | Bescot Road | Bescot Road | Walsall | Walsall | Education | N/A | 52.5707373 | -2.0014215 | ||
| 19475 | op-snap---monthly-publication-may-2025.pdf | 837 | 2025-05 | Car | Nissan | Micra | Black | Driving without Reasonable Consideration | None | Bridgeman Street | Bridgeman Street | Walsall | Walsall | NFA | No Offence | 52.583034 | -1.9839161 | ||
| 19480 | op-snap---monthly-publication-may-2025.pdf | 842 | 2025-05 | Car | Ford | transit | White | Driving without Due Care and Attention | None | M6 J10 | M6 J10 | Walsall | Walsall | Education | N/A | 52.676119 | -2.0858425 | ||
| 19510 | op-snap---monthly-publication-may-2025.pdf | 872 | 2025-05 | Car | Toyota | Aygo | Blue | Contravene Lane Closure Red X | None | Chester Road | Chester Road | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5692139 | -1.8799672 | ||
| 19542 | op-snap---monthly-publication-may-2025.pdf | 904 | 2025-05 | Car | Skoda | Fabia | Blue | Driving without Due Care and Attention | None | Vicarage Road | Vicarage Road | Walsall | Walsall | RTC - Actioned | N/A | 52.64682 | -1.9259844 | ||
| 19595 | op-snap---monthly-publication-may-2025.pdf | 957 | 2025-05 | car | Vauxhall | Mokka | Black | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Walsall | Walsall | Education | N/A | 52.6095168 | -2.0493009 | ||
| 19687 | op-snap---monthly-publication-may-2025.pdf | 1049 | 2025-05 | Car | Renault | Clio | Black | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | Warning Letter | N/A | 52.5867763 | -2.0104342 | ||
| 19828 | op-snap---monthly-publication-may-2025.pdf | 1190 | 2025-05 | Car | Honda | Jazz | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodwards Road | Woodwards Road | Walsall | Walsall | Fixed Penalty | N/A | 52.5783717 | -2.0074744 | ||
| 19900 | op-snap---monthly-publication-may-2025.pdf | 1262 | 2025-05 | Pedestrian | Nissan | Black | Contravening a Red Traffic Light | None | Daw end Lane , Walsall | Daw end Lane , Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.6069179 | -1.9610677 | |||
| 19934 | op-snap---monthly-publication-may-2025.pdf | 1296 | 2025-05 | Car | Jaguar | NP | Black | Driving without Due Care and Attention | None | Ablewell street | Ablewell street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5821593 | -1.9747872 | ||
| 19953 | op-snap---monthly-publication-may-2025.pdf | 1315 | 2025-05 | Pedal Bike | Daf | Truck | White | Driving without Due Care and Attention | None | Chester road | Chester road | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5692139 | -1.8799672 | ||
| 20000 | op-snap---monthly-publication-may-2025.pdf | 1362 | 2025-05 | Pedal Bike | BMW | 600 SERIES | Blue | Driving without Due Care and Attention | None | jtc with barns lane | Jtc With Barns Lane | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 20020 | op-snap---monthly-publication-may-2025.pdf | 1382 | 2025-05 | Pedal Bike | Honda | jazz | Silver | Driving without Due Care and Attention | None | Bescot Crescent road | Bescot Crescent road | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.575204 | -1.9916288 | ||
| 20030 | op-snap---monthly-publication-may-2025.pdf | 1392 | 2025-05 | Pedal Bike | Volkswagen | NP | Black | Contravening a Red Traffic Light | None | Daw end lane, rushall | Daw end lane, rushall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.6051634 | -1.956872 | ||
| 20031 | op-snap---monthly-publication-may-2025.pdf | 1393 | 2025-05 | Pedal Bike | BMW | NP | Black | Using a Mobile Phone Whilst Driving | None | Daw end lane | Daw end lane | Walsall | Walsall | Fixed Penalty | N/A | 52.6068849 | -1.9611652 | ||
| 20032 | op-snap---monthly-publication-may-2025.pdf | 1394 | 2025-05 | Pedal Bike | Ford | NP | Grey | Using a Mobile Phone Whilst Driving | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | 52.6068849 | -1.9611652 | ||
| 20033 | op-snap---monthly-publication-may-2025.pdf | 1395 | 2025-05 | Pedal Bike | Dacia | NP | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.6068849 | -1.9611652 | ||
| 20035 | op-snap---monthly-publication-may-2025.pdf | 1397 | 2025-05 | Pedal Bike | NP | Black | Contravening a Red Traffic Light | None | Daw end lane | Daw end lane | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.6068849 | -1.9611652 | |||
| 20039 | op-snap---monthly-publication-may-2025.pdf | 1401 | 2025-05 | Car | Kia | np | Black | Contravening a Red Traffic Light | None | Chester road, neat to birch lane | Chester road, neat to birch lane | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 20040 | op-snap---monthly-publication-may-2025.pdf | 1402 | 2025-05 | Car | Jaguar | NP | Black | Contravening a Red Traffic Light | None | Chester road, neat to birch lane | Chester road, neat to birch lane | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 20041 | op-snap---monthly-publication-may-2025.pdf | 1403 | 2025-05 | Other | Mazda | NP | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | TOWER STREET | Tower Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5859017 | -1.9794975 | ||
| 20057 | op-snap---monthly-publication-may-2025.pdf | 1419 | 2025-05 | Car | Mercedes-Benz | benz e22od salo | oBnlack | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Traffic light of bescott road | Traffic light of bescott road | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 20085 | op-snap---monthly-publication-may-2025.pdf | 1447 | 2025-05 | Car | BMW | 3rd series | Black | Driving without Due Care and Attention | None | TRYSULL RD TO BRADMORE RD | Trysull Rd To Bradmore Rd | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 20130 | op-snap---monthly-publication-may-2025.pdf | 1492 | 2025-05 | Car | Contravening a Red Traffic Light | None | Norton Caines | Norton Caines | Walsall | Walsall | NFA | No VRM | |||||||
| 20132 | op-snap---monthly-publication-may-2025.pdf | 1494 | 2025-05 | Pedestrian | Audi | SQ8 | Black | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 20218 | op-snap---monthly-publication-may-2025.pdf | 1580 | 2025-05 | Car | Toyota | Yaris | Black | Contravening a Red Traffic Light | No Insurance | Station Road | Station Road | Walsall | Walsall | Warning Letter | N/A | 52.6281831 | -1.9664494 | ||
| 20222 | op-snap---monthly-publication-may-2025.pdf | 1584 | 2025-05 | Pedestrian | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | Station Road | Station Road | Walsall | Walsall | Warning Letter | N/A | 52.6281831 | -1.9664494 | ||
| 20223 | op-snap---monthly-publication-may-2025.pdf | 1585 | 2025-05 | Pedestrian | Vauxhall | Corsa | Blue | Contravening a Red Traffic Light | None | Station Road | Station Road | Walsall | Walsall | Warning Letter | N/A | 52.6281831 | -1.9664494 | ||
| 20225 | op-snap---monthly-publication-may-2025.pdf | 1587 | 2025-05 | Pedestrian | White | Driving without Due Care and Attention | None | Poplar Avenue, Walsall | Poplar Avenue, Walsall | Walsall | Walsall | NFA | No VRM | 52.5945052 | -2.0227343 | ||||
| 20228 | op-snap---monthly-publication-may-2025.pdf | 1590 | 2025-05 | Pedal Bike | Driving without Due Care and Attention | None | Broad Lane, Bloxwich | Broad Lane, Bloxwich | Walsall | Walsall | NFA | No VRM | 52.6263759 | -2.0189428 | |||||
| 20231 | op-snap---monthly-publication-may-2025.pdf | 1593 | 2025-05 | Car | Audi | q2 | Black | Driving without Due Care and Attention | None | Chester Road, Streetly | Chester Road, Streetly | Walsall | Walsall | NFA | Misc Inc Crimes | 52.5774374 | -1.8842966 | ||
| 20270 | op-snap---monthly-publication-may-2025.pdf | 1632 | 2025-05 | Car | Honda | Jazz | Grey | Using a Mobile Phone Whilst Driving | none | Trouse Lane | Trouse Lane | Walsall | Walsall | Warning Letter | N/A | ||||
| 20336 | op-snap---monthly-publication-may-2025.pdf | 1698 | 2025-05 | Pedal Bike | Renault | Ambulance | White | Driving without Due Care and Attention | None | Stubby Lane | Stubby Lane | Walsall | Walsall | Warning Letter | N/A | ||||
| 20341 | op-snap---monthly-publication-may-2025.pdf | 1703 | 2025-05 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | New Road | New Road | Walsall | Walsall | Warning Letter | N/A | 52.6453327 | -1.9283021 | ||
| 20358 | op-snap---monthly-publication-may-2025.pdf | 1720 | 2025-05 | Car | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | Wood Green Road | Wood Green Road | Walsall | Walsall | NFA | Misc Inc Crimes | 52.6248989 | -1.9343969 | ||
| 20376 | op-snap---monthly-publication-may-2025.pdf | 1738 | 2025-05 | Car | Scania | Tractor Unit | White | Dangerous Driving | none | M6 Northbound | M6 Northbound | Walsall | Walsall | Warning Letter | N/A | ||||
| 20385 | op-snap---monthly-publication-may-2025.pdf | 1747 | 2025-05 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | none | Heath Road | Heath Road | Walsall | Walsall | Warning Letter | N/A | 52.5736792 | -2.0223376 | ||
| 20388 | op-snap---monthly-publication-may-2025.pdf | 1750 | 2025-05 | Pedal Bike | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Willenhall Road | Willenhall Road | Walsall | Walsall | Warning Letter | N/A | 52.5771198 | -2.0320614 | ||
| 20393 | op-snap---monthly-publication-may-2025.pdf | 1755 | 2025-05 | Car | Peugeot | Expert | Black | Misc - Non Traffic Offences | None | Bosty Lane | Bosty Lane | Walsall | Walsall | NFA | No Offence | 52.5948329 | -1.927787 | ||
| 20445 | op-snap---monthly-publication-may-2025.pdf | 1807 | 2025-05 | Car | Fiat | 500 | White | Driving without Due Care and Attention | None | Stephenson Avenue | Stephenson Avenue | Walsall | Walsall | Warning Letter | N/A | 52.6031501 | -2.0117279 | ||
| 20446 | op-snap---monthly-publication-may-2025.pdf | 1808 | 2025-05 | Car | Skoda | Kamiq | White | Driving without Due Care and Attention | None | Tasker Street | Tasker Street | Walsall | Walsall | Warning Letter | N/A | 52.5794888 | -1.9876754 |
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);