reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

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'}

92 rows where disposal = "Warning Letter" and offence = "Stop a vehicle within pelican pedestrian crossing limits" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make 25

reporter_transport_mode 4

offence 1

  • Stop a vehicle within pelican pedestrian crossing limits · 92 ✖

disposal 1

  • Warning Letter · 92 ✖
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
7269 op-snap---monthly-publication-february-2026.pdf   16 2026-02 Van Toyota C-HR White Stop a vehicle within pelican pedestrian crossing limits None Radford Road Radford Road Coventry Coventry Warning Letter N/A   52.4235908 -1.5226276
7670 op-snap---monthly-publication-february-2026.pdf   417 2026-02 Car Kia Sportage Black Stop a vehicle within pelican pedestrian crossing limits None Sharman's Cross Road Sharman's Cross Road Solihull Solihull Warning Letter N/A      
8600 op-snap---monthly-publication-february-2026.pdf   1347 2026-02 Car Volkswagen golf Silver Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8601 op-snap---monthly-publication-february-2026.pdf   1348 2026-02 Car BMW m3 Grey Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8714 op-snap---monthly-publication-february-2026.pdf   1461 2026-02 Pedestrian Vauxhall vivaro White Stop a vehicle within pelican pedestrian crossing limits None kingstanding road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
8720 op-snap---monthly-publication-february-2026.pdf   1467 2026-02 Pedestrian Skoda ocatavia Grey Stop a vehicle within pelican pedestrian crossing limits None birmingham Birmingham Birmingham Birmingham Warning Letter N/A   52.4796992 -1.9026911
8726 op-snap---monthly-publication-february-2026.pdf   1473 2026-02 Car Fiat panda Blue Stop a vehicle within pelican pedestrian crossing limits None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
8727 op-snap---monthly-publication-february-2026.pdf   1474 2026-02 Car Seat ateca Blue Stop a vehicle within pelican pedestrian crossing limits None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
8728 op-snap---monthly-publication-february-2026.pdf   1475 2026-02 Pedal Bike Mercedes-Benz spinter White Stop a vehicle within pelican pedestrian crossing limits None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
8731 op-snap---monthly-publication-february-2026.pdf   1478 2026-02 Pedestrian Mercedes-Benz a180 Black Stop a vehicle within pelican pedestrian crossing limits None bearwood road Bearwood Road Birmingham Birmingham Warning Letter Duplicate Submission   52.4762784 -1.9678366
8795 op-snap---monthly-publication-february-2026.pdf   1542 2026-02 Car Mercedes-Benz sprinter White Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8796 op-snap---monthly-publication-february-2026.pdf   1543 2026-02 Car Mercedes-Benz c220 Black Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8797 op-snap---monthly-publication-february-2026.pdf   1544 2026-02 Car Mini cooper Red Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8798 op-snap---monthly-publication-february-2026.pdf   1545 2026-02 Car Audi a1 Grey Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8799 op-snap---monthly-publication-february-2026.pdf   1546 2026-02 Car Nissan qashqai Blue Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8800 op-snap---monthly-publication-february-2026.pdf   1547 2026-02 Car Audi s3 Grey Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8801 op-snap---monthly-publication-february-2026.pdf   1548 2026-02 Car Volkswagen golf Blue Stop a vehicle within pelican pedestrian crossing limits None washwood hetah road Washwood Hetah Road Birmingham Birmingham Warning Letter N/A      
8884 op-snap---monthly-publication-february-2026.pdf   1631 2026-02 Car Honda civic Red Stop a vehicle within pelican pedestrian crossing limits None high street, tettenhall High Street, Tettenhall Birmingham Birmingham Warning Letter N/A      
8891 op-snap---monthly-publication-february-2026.pdf   1638 2026-02 Pedal Bike Peugeot 107 Black Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
10700 op-snap---monthly-publication-january-2026.pdf   161 2026-01 Car Iveco Daily White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
10877 op-snap---monthly-publication-january-2026.pdf   338 2026-01 Car Renault Master White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
10912 op-snap---monthly-publication-january-2026.pdf   373 2026-01 Car Honda Jazz Blue Stop a vehicle within pelican pedestrian crossing limits None RobinHood Lane Robin Hood Lane Birmingham Birmingham Warning Letter N/A   52.4221526 -1.8425617
10916 op-snap---monthly-publication-january-2026.pdf   377 2026-01 Pedal Bike Hyundai Kona Blue Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
11018 op-snap---monthly-publication-january-2026.pdf   479 2026-01 Pedestrian Honda Jazz Red Stop a vehicle within pelican pedestrian crossing limits None Kettlehouse Road Kettlehouse Road Birmingham Birmingham Warning Letter N/A   52.5546392 -1.8859041
11186 op-snap---monthly-publication-january-2026.pdf   647 2026-01 Pedestrian Tesla Model Y Grey Stop a vehicle within pelican pedestrian crossing limits None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5361464 -1.8270283
4517 op-snap---monthly-publication-december-2025.pdf   645 2025-12 Pedestrian Renault traffic Silver Stop a vehicle within pelican pedestrian crossing limits None regent road Regent Road Birmingham Birmingham Warning Letter N/A   52.5077359 -1.9452509
4615 op-snap---monthly-publication-december-2025.pdf   743 2025-12 Car Skoda kamiq Grey Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4616 op-snap---monthly-publication-december-2025.pdf   744 2025-12 Car Toyota prius Black Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4617 op-snap---monthly-publication-december-2025.pdf   745 2025-12 Car Kia carens Silver Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
5085 op-snap---monthly-publication-december-2025.pdf   1213 2025-12 Pedestrian Toyota Prius Silver Stop a vehicle within pelican pedestrian crossing limits None Watford Road Watford Road Birmingham Birmingham Warning Letter N/A   52.4182952 -1.9316395
5089 op-snap---monthly-publication-december-2025.pdf   1217 2025-12 Car Peugeot 3008 White Stop a vehicle within pelican pedestrian crossing limits None Wattville Road Wattville Road Birmingham Birmingham Warning Letter N/A   52.5063926 -1.9548648
5116 op-snap---monthly-publication-december-2025.pdf   1244 2025-12 Car BMW 3 SERIES Black Stop a vehicle within pelican pedestrian crossing limits None Waterloo Road Waterloo Road Wolverhampton Wolverhampton Warning Letter N/A   52.5960155 -2.1295068
5174 op-snap---monthly-publication-december-2025.pdf   1302 2025-12 Car Audi Q3 Grey Stop a vehicle within pelican pedestrian crossing limits None High St Tettenhall High Street Tettenhall Wolverhampton Wolverhampton Warning Letter N/A   52.5980906 -2.168057
20471 op-snap---monthly-publication-november-2025.pdf   13 2025-11 Pedal Bike Seat Leon Black Stop a vehicle within pelican pedestrian crossing limits None Far Gosford Street Far Gosford Street Coventry Coventry Warning Letter N/A   52.4071231 -1.4985178
21199 op-snap---monthly-publication-november-2025.pdf   741 2025-11 Pedestrian BMW IX1 Silver Stop a vehicle within pelican pedestrian crossing limits None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
21200 op-snap---monthly-publication-november-2025.pdf   742 2025-11 Pedestrian Audi Q2 Grey Stop a vehicle within pelican pedestrian crossing limits None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
21201 op-snap---monthly-publication-november-2025.pdf   743 2025-11 Pedestrian Vauxhall Astra Grey Stop a vehicle within pelican pedestrian crossing limits None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
21206 op-snap---monthly-publication-november-2025.pdf   748 2025-11 Pedestrian BMW 520d Black Stop a vehicle within pelican pedestrian crossing limits None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
21218 op-snap---monthly-publication-november-2025.pdf   760 2025-11 Car Toyota Yaris Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21219 op-snap---monthly-publication-november-2025.pdf   761 2025-11 Car BMW 430d Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21223 op-snap---monthly-publication-november-2025.pdf   765 2025-11 Car Nissan Qashqai Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21224 op-snap---monthly-publication-november-2025.pdf   766 2025-11 Car Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23272 op-snap---monthly-publication-october-2025.pdf   1222 2025-10 Pedestrian Mini countryman White Stop a vehicle within pelican pedestrian crossing limits None vicarage road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
3498 op-snap---monthly-publication-august-2025.pdf   1473 2025-08 Car Toyota Yaris Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath road Washwood Heath road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13153 op-snap---monthly-publication-july-2025.pdf   1205 2025-07 Pedal Bike Volkswagen Golf S Black Stop a vehicle within pelican pedestrian crossing limits None Edward Road , Balsall Heath Edward Road , Balsall Heath Birmingham Birmingham Warning Letter N/A   52.4593504 -1.9013281
13154 op-snap---monthly-publication-july-2025.pdf   1206 2025-07 Pedestrian Renault   White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Wahswood Washwood Heath Road , Wahswood HBeiramthingham Hbeiramthingham Warning Letter N/A      
13172 op-snap---monthly-publication-july-2025.pdf   1224 2025-07 Car Dacia   Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham Warning Letter N/A   52.4949047 -1.8544884
13173 op-snap---monthly-publication-july-2025.pdf   1225 2025-07 Car Mercedes-Benz   Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham Warning Letter N/A   52.4949047 -1.8544884
13174 op-snap---monthly-publication-july-2025.pdf   1226 2025-07 Car Audi   White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham Warning Letter N/A   52.4949047 -1.8544884
13175 op-snap---monthly-publication-july-2025.pdf   1227 2025-07 Car BMW   Blue Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road , Hodge Hill Coleshill Road , Hodge Hill Birmingham Birmingham Warning Letter N/A   52.4967329 -1.8097462
13176 op-snap---monthly-publication-july-2025.pdf   1228 2025-07 Car Mercedes-Benz Van White Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road , Hodge Hill Coleshill Road , Hodge Hill Birmingham Birmingham Warning Letter N/A   52.4967329 -1.8097462
13177 op-snap---monthly-publication-july-2025.pdf   1229 2025-07 Car Skoda Fabia White Stop a vehicle within pelican pedestrian crossing limits None Nineveh Road Nineveh Road Birmingham Birmingham Warning Letter N/A   52.5023053 -1.9329023
13179 op-snap---monthly-publication-july-2025.pdf   1231 2025-07 Car Fiat   Black Stop a vehicle within pelican pedestrian crossing limits None Pedestrain crossing area junction of U Pedestrain crossing area junction of U nBiicrmorinn ghhilal amnd Church Green W Nbiicrmorinn Ghhilal Amnd Church Green W Warning Letter N/A      
14605 op-snap---monthly-publication-june-2025.pdf   534 2025-06 Pedestrian Renault Megane Silver Stop a vehicle within pelican pedestrian crossing limits None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
15417 op-snap---monthly-publication-june-2025.pdf   1346 2025-06 Pedestrian Toyota Aygo Black Stop a vehicle within pelican pedestrian crossing limits None Solihull Train Station Solihull Train Station Solihull Solihull Warning Letter N/A   52.4147491 -1.7879378
15940 op-snap---monthly-publication-june-2025.pdf   1869 2025-06 Car Toyota CHR.. Red Stop a vehicle within pelican pedestrian crossing limits None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
19203 op-snap---monthly-publication-may-2025.pdf   565 2025-05 Pedestrian Volkswagen Tiguan Silver Stop a vehicle within pelican pedestrian crossing limits None Solihull train station Solihull train station Solihull Solihull Warning Letter N/A   52.4147491 -1.7879378
19242 op-snap---monthly-publication-may-2025.pdf   604 2025-05 Car Mercedes-Benz C200.. Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
19872 op-snap---monthly-publication-may-2025.pdf   1234 2025-05 Car Toyota Proace White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
94 op-snap---monthly-publication-april-2025.pdf   93 2025-04 Car Seat Leon Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
174 op-snap---monthly-publication-april-2025.pdf   173 2025-04 Pedestrian Vauxhall Corsa White Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road Kingstanding Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
176 op-snap---monthly-publication-april-2025.pdf   175 2025-04 Pedestrian Mercedes-Benz GLC220 Grey Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road Kingstanding Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
375 op-snap---monthly-publication-april-2025.pdf   374 2025-04 Car BMW 320i White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
415 op-snap---monthly-publication-april-2025.pdf   414 2025-04 Car Volkswagen Crafter White Stop a vehicle within pelican pedestrian crossing limits None Wednesbury Road Wednesbury Road Walsall Walsall Warning Letter N/A   52.5738499 -1.9961575
572 op-snap---monthly-publication-april-2025.pdf   571 2025-04 Pedal Bike BMW 320D Blue Stop a vehicle within pelican pedestrian crossing limits None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
1289 op-snap---monthly-publication-april-2025.pdf   1288 2025-04 Pedal Bike Toyota PRIUS Black Stop a vehicle within pelican pedestrian crossing limits None Far Gosford Street Far Gosford Street Coventry Coventry Warning Letter N/A   52.4071231 -1.4985178
16295 op-snap---monthly-publication-march-2025.pdf   52 2025-03 Car Jaguar XF Black Stop a vehicle within pelican pedestrian crossing limits None Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4762784 -1.9678366
16323 op-snap---monthly-publication-march-2025.pdf   80 2025-03 Car Toyota Yaris Blue Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
16399 op-snap---monthly-publication-march-2025.pdf   156 2025-03 Car Nissan Qashqai Grey Stop a vehicle within pelican pedestrian crossing limits None Audley Road Audley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4876917 -1.7963729
16609 op-snap---monthly-publication-march-2025.pdf   366 2025-03 Car Toyota Camry Grey Stop a vehicle within pelican pedestrian crossing limits None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4833672 -1.7871439
16643 op-snap---monthly-publication-march-2025.pdf   400 2025-03 Pedestrian Toyota Prius White Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4242527 -1.910803
16734 op-snap---monthly-publication-march-2025.pdf   491 2025-03 Car Volkswagen Golf Black Stop a vehicle within pelican pedestrian crossing limits None Audley Rd Audley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4876917 -1.7963729
16867 op-snap---monthly-publication-march-2025.pdf   624 2025-03 Car Toyota Prius Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
17064 op-snap---monthly-publication-march-2025.pdf   821 2025-03 Pedestrian Volkswagen Touran Silver Stop a vehicle within pelican pedestrian crossing limits None Albany Road Albany Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4591259 -1.9506139
17251 op-snap---monthly-publication-march-2025.pdf   1008 2025-03 Pedestrian Suzuki Grand Vitara Black Stop a vehicle within pelican pedestrian crossing limits No vehicle excise licence Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4865107 -1.9386263
17341 op-snap---monthly-publication-march-2025.pdf   1098 2025-03 Pedestrian Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Norton Road Norton Road Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A Yes - Via Email 52.6289578 -1.9667839
17664 op-snap---monthly-publication-march-2025.pdf   1421 2025-03 Pedestrian Audi A4 Blue Stop a vehicle within pelican pedestrian crossing limits None Hobs Road Hobs Road Walsall Walsall Warning Letter N/A Yes - Via Email    
18096 op-snap---monthly-publication-march-2025.pdf   1853 2025-03 Car Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
18217 op-snap---monthly-publication-march-2025.pdf   1974 2025-03 Car Mg Trophy Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
18227 op-snap---monthly-publication-march-2025.pdf   1984 2025-03 Pedestrian Volvo XC90 Black Stop a vehicle within pelican pedestrian crossing limits None Station Approach, Station Approach Solihull Solihull Warning Letter N/A Yes - Via Email 52.4146834 -1.7879896
18250 op-snap---monthly-publication-march-2025.pdf   2007 2025-03 Car Toyota Prius White Stop a vehicle within pelican pedestrian crossing limits None Ladypool Road Ladypool Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4520441 -1.8787544
18475 op-snap---monthly-publication-march-2025.pdf   2232 2025-03 Car Ford Fiesat White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
18587 op-snap---monthly-publication-march-2025.pdf   2344 2025-03 Car Mercedes-Benz C250. White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
6028 op-snap---monthly-publication-february-2025.pdf   845 2025-02 Car Volvo XC40 Black Stop a vehicle within pelican pedestrian crossing limits None BARNHURST LANE Barnhurst Lane Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.618907 -2.1614857
6098 op-snap---monthly-publication-february-2025.pdf   915 2025-02 Car Citroen C3 Red Stop a vehicle within pelican pedestrian crossing limits None Audley Road Audley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4876917 -1.7963729
6752 op-snap---monthly-publication-february-2025.pdf   1569 2025-02 Car Volkswagen Touran Beige Stop a vehicle within pelican pedestrian crossing limits None Victoria Street Sutton Coldfield Victoria Street Sutton Coldfield Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5586132 -1.8260076
8973 op-snap---monthly-publication-january-2025.pdf   81 2025-01 Pedestrian Volkswagen Golf Black Stop a vehicle within pelican pedestrian crossing limits None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4865107 -1.9386263
9173 op-snap---monthly-publication-january-2025.pdf   281 2025-01 Car Nissan Qashqai Black Stop a vehicle within pelican pedestrian crossing limits None High Street, Tettenhall High Street, Tettenhall Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.5980906 -2.168057
9336 op-snap---monthly-publication-january-2025.pdf   444 2025-01 Car Hyundai Tucson Grey Stop a vehicle within pelican pedestrian crossing limits None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5361464 -1.8270283
9483 op-snap---monthly-publication-january-2025.pdf   591 2025-01 Pedal Bike Mercedes-Benz Sprinter Green Stop a vehicle within pelican pedestrian crossing limits None Charter Avenue Charter Avenue Coventry Coventry Warning Letter N/A Yes - Via Email 52.3928409 -1.5888076
9745 op-snap---monthly-publication-january-2025.pdf   853 2025-01 Pedestrian Mg 6 Grey Stop a vehicle within pelican pedestrian crossing limits None HIGH STREET High Street Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.5635963 -2.0827567
10106 op-snap---monthly-publication-january-2025.pdf   1214 2025-01 Pedestrian Mercedes-Benz A200 Red Stop a vehicle within pelican pedestrian crossing limits None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4865107 -1.9386263

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);