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

465 rows where month = "2025-07" and reporter_transport_mode = "Pedestrian" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Pedestrian · 465 ✖

month 1

  • 2025-07 · 465 ✖
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
11967 op-snap---monthly-publication-july-2025.pdf   19 2025-07 Pedestrian Seat Leon Blue Driving without Due Care and Attention None Heath Road South Heath Road South Birmingham Birmingham NFA No VRM   52.415858 -1.9632649
11974 op-snap---monthly-publication-july-2025.pdf   26 2025-07 Pedestrian Kia Sportage White Driving without Due Care and Attention None Heath Road Heath Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5977729 -2.1078698
12018 op-snap---monthly-publication-july-2025.pdf   70 2025-07 Pedestrian Volvo XC40 Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Dudley Town Centre Dudley Town Centre Dudley Dudley Fixed Penalty N/A   52.5136239 -2.0721522
12031 op-snap---monthly-publication-july-2025.pdf   83 2025-07 Pedestrian Audi A3.. Grey Contravening a Red Traffic Light None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
12058 op-snap---monthly-publication-july-2025.pdf   110 2025-07 Pedestrian Seat Leon White Using a Mobile Phone Whilst Driving None A46 A46 Coventry Coventry Fixed Penalty N/A      
12063 op-snap---monthly-publication-july-2025.pdf   115 2025-07 Pedestrian Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
12092 op-snap---monthly-publication-july-2025.pdf   144 2025-07 Pedestrian     White Driving without Due Care and Attention None Millennium Place Millennium Place Coventry Coventry NFA No VRM   52.4105671 -1.5087697
12099 op-snap---monthly-publication-july-2025.pdf   151 2025-07 Pedestrian Nissan Juke Red Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No Independent Evidence Available   52.4622646 -1.8599985
12107 op-snap---monthly-publication-july-2025.pdf   159 2025-07 Pedestrian Mini Mini Blue Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley NFA Outside of 14 Days NIP   52.4628538 -2.1160108
12120 op-snap---monthly-publication-july-2025.pdf   172 2025-07 Pedestrian Cupra Ateca Grey Driving without Reasonable Consideration None M6 South Birmingham M6 South Birmingham Birmingham Birmingham Fixed Penalty N/A   52.4031308 -2.0142003
12135 op-snap---monthly-publication-july-2025.pdf   187 2025-07 Pedestrian Scania Lorry White Misc - Non Traffic Offences None Stockton Road Stockton Road Out of Force Area Out of Force Area NFA Out of Force   52.4163443 -1.4992768
12150 op-snap---monthly-publication-july-2025.pdf   202 2025-07 Pedestrian Hyundai Santa Fe Black Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12152 op-snap---monthly-publication-july-2025.pdf   204 2025-07 Pedestrian Nissan Ariya Black Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12153 op-snap---monthly-publication-july-2025.pdf   205 2025-07 Pedestrian Peugeot Expert Blue Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12154 op-snap---monthly-publication-july-2025.pdf   206 2025-07 Pedestrian Vauxhall Corsa Black Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12156 op-snap---monthly-publication-july-2025.pdf   208 2025-07 Pedestrian Renault Captur Blue Contravening a Red Traffic Light None McDonalds, Walsall Mc Donalds, Walsall Walsall Walsall NFA Outside of 14 Days NIP      
12178 op-snap---monthly-publication-july-2025.pdf   230 2025-07 Pedestrian Vauxhall Zafira Beige Driving without Due Care and Attention None Outside Coventry Market Outside Coventry Market Coventry Coventry Warning Letter N/A      
12202 op-snap---monthly-publication-july-2025.pdf   254 2025-07 Pedestrian Skoda   Black Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
12205 op-snap---monthly-publication-july-2025.pdf   257 2025-07 Pedestrian Toyota Corolla White Using a Mobile Phone Whilst Driving None Stephenson Street Stephenson Street Birmingham Birmingham NFA No Independent Evidence Available   52.4787219 -1.9004997
12209 op-snap---monthly-publication-july-2025.pdf   261 2025-07 Pedestrian Volkswagen Golf Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Kirkstone Way Kirkstone Way Dudley Dudley Fixed Penalty N/A   52.4709992 -2.1310412
12214 op-snap---monthly-publication-july-2025.pdf   266 2025-07 Pedestrian Volkswagen Golf Blue Driving without Due Care and Attention None Bernard Road Bernard Road Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.4777838 -1.9587163
12251 op-snap---monthly-publication-july-2025.pdf   303 2025-07 Pedestrian Toyota Yaris Blue Using a Mobile Phone Whilst Driving None Charles Road Charles Road Birmingham Birmingham Fixed Penalty N/A   52.5094492 -1.9113648
12252 op-snap---monthly-publication-july-2025.pdf   304 2025-07 Pedestrian Ford Ranger Grey Using a Mobile Phone Whilst Driving None Grange Road Grange Road Solihull Solihull Fixed Penalty N/A   52.4285724 -1.8019101
12254 op-snap---monthly-publication-july-2025.pdf   306 2025-07 Pedestrian Toyota Aygo Green Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham Fixed Penalty N/A   52.4298554 -1.9086629
12255 op-snap---monthly-publication-july-2025.pdf   307 2025-07 Pedestrian Audi A6 White Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham NFA No Independent Evidence Available   52.4298554 -1.9086629
12257 op-snap---monthly-publication-july-2025.pdf   309 2025-07 Pedestrian Mercedes-Benz A200 Blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
12259 op-snap---monthly-publication-july-2025.pdf   311 2025-07 Pedestrian Volkswagen Up Blue Using a Mobile Phone Whilst Driving None Plough and Harrow Road Plough and Harrow Road Birmingham Birmingham Fixed Penalty N/A   52.5899123 -1.8057069
12272 op-snap---monthly-publication-july-2025.pdf   324 2025-07 Pedestrian Honda FSH125 White Using a Mobile Phone Whilst Driving None Moore Streer Moore Streer Birmingham Birmingham NFA No Offence      
12315 op-snap---monthly-publication-july-2025.pdf   367 2025-07 Pedestrian Volkswagen Golf Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Turners Lane Turners Lane Dudley Dudley NFA No Independent Evidence Available   52.4721372 -2.1243522
12340 op-snap---monthly-publication-july-2025.pdf   392 2025-07 Pedestrian Mercedes-Benz SLK 200 Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
12360 op-snap---monthly-publication-july-2025.pdf   412 2025-07 Pedestrian Volkswagen Polo Grey Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Education N/A   52.6068849 -1.9611652
12362 op-snap---monthly-publication-july-2025.pdf   414 2025-07 Pedestrian Volvo Lorry Black Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Education N/A   52.6068849 -1.9611652
12363 op-snap---monthly-publication-july-2025.pdf   415 2025-07 Pedestrian Toyota Prius White Contravening a Red Traffic Light None Bordsley Green Road Bordsley Green Road Birmingham Birmingham NFA No Offence      
12364 op-snap---monthly-publication-july-2025.pdf   416 2025-07 Pedestrian Honda Civic Silver Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Education N/A   52.6068849 -1.9611652
12365 op-snap---monthly-publication-july-2025.pdf   417 2025-07 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention No Insurance Bordsley Green Bordsley Green Birmingham Birmingham Court N/A      
12377 op-snap---monthly-publication-july-2025.pdf   429 2025-07 Pedestrian BMW X5 Grey Using a Mobile Phone Whilst Driving None M6 South M6 South Wolverhampton Wolverhampton Fixed Penalty N/A   52.5649086 -2.1705292
12410 op-snap---monthly-publication-july-2025.pdf   462 2025-07 Pedestrian BMW 318.. Grey Contravening a Red Traffic Light None Ringway St Nicholas Ringway Street Nicholas Coventry Coventry Education N/A      
12411 op-snap---monthly-publication-july-2025.pdf   463 2025-07 Pedestrian Honda Jazz Brown Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
12428 op-snap---monthly-publication-july-2025.pdf   480 2025-07 Pedestrian BMW 420D Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Windward Way Windward Way Birmingham Birmingham Warning Letter N/A      
12441 op-snap---monthly-publication-july-2025.pdf   493 2025-07 Pedestrian BMW X2 Black Drive / Ride / Lead an animal on a footpath None Valbourne Road Valbourne Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4165707 -1.9062691
12442 op-snap---monthly-publication-july-2025.pdf   494 2025-07 Pedestrian BMW X2 Black Drive / Ride / Lead an animal on a footpath None Valbourne Road Valbourne Road Birmingham Birmingham Warning Letter N/A   52.4165707 -1.9062691
12444 op-snap---monthly-publication-july-2025.pdf   496 2025-07 Pedestrian Ford Focus Orange Driving without Due Care and Attention None Off Force Off Force Out of Force Area Out of Force Area NFA Out of Force      
12449 op-snap---monthly-publication-july-2025.pdf   501 2025-07 Pedestrian Volkswagen   White Driving without Due Care and Attention None St Gerards Street Gerards Solihull Solihull NFA Outside of 14 Days NIP      
12452 op-snap---monthly-publication-july-2025.pdf   504 2025-07 Pedestrian BMW M2 White Driving without Due Care and Attention None Tesco Blackpool Tesco Blackpool Out of Force Area Out of Force Area NFA Out of Force      
12476 op-snap---monthly-publication-july-2025.pdf   528 2025-07 Pedestrian Audi SQ5 Black Using a Mobile Phone Whilst Driving None A458 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
12506 op-snap---monthly-publication-july-2025.pdf   558 2025-07 Pedestrian Peugeot 207 Silver Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Birmingham Birmingham NFA No Independent Evidence Available   52.5124557 -1.8917609
12516 op-snap---monthly-publication-july-2025.pdf   568 2025-07 Pedestrian Hyundai i10 Blue Contravening a Red Traffic Light None A452 at NEC A452 at NEC Solihull Solihull Education N/A   52.3686316 -1.6251483
12552 op-snap---monthly-publication-july-2025.pdf   604 2025-07 Pedestrian BMW 320d Blue Using a Mobile Phone Whilst Driving None Wrentham Street Wrentham Street Birmingham Birmingham Fixed Penalty N/A   52.4708757 -1.8966158
12566 op-snap---monthly-publication-july-2025.pdf   618 2025-07 Pedestrian Land Rover Evoque Black Driving without Due Care and Attention None Bransford Avenue Bransford Avenue Coventry Coventry Education N/A   52.3849916 -1.5503012
12590 op-snap---monthly-publication-july-2025.pdf   642 2025-07 Pedestrian Citroen   Grey Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
12591 op-snap---monthly-publication-july-2025.pdf   643 2025-07 Pedestrian BMW   White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4831397 -2.1309273
12598 op-snap---monthly-publication-july-2025.pdf   650 2025-07 Pedestrian Toyota Auris Silver Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Bishopsgate Street Bishopsgate Street Birmingham Birmingham Fixed Penalty N/A   52.473986 -1.9147087
12599 op-snap---monthly-publication-july-2025.pdf   651 2025-07 Pedestrian BMW 118.. Grey Using a Mobile Phone Whilst Driving None Plough and Harrow Road Plough and Harrow Road Birmingham Birmingham Fixed Penalty N/A   52.5899123 -1.8057069
12600 op-snap---monthly-publication-july-2025.pdf   652 2025-07 Pedestrian Vauxhall Corsa White Driving without Due Care and Attention None M5 Motorway J1 M5 Motorway J1 Sandwell Sandwell Education N/A      
12604 op-snap---monthly-publication-july-2025.pdf   656 2025-07 Pedestrian Ford Fiesta Brown Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
12607 op-snap---monthly-publication-july-2025.pdf   659 2025-07 Pedestrian Nissan Note White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Turners Lane, Brierley Hill Turners Lane, Brierley Hill Dudley Dudley Fixed Penalty N/A   52.4721372 -2.1243522
12621 op-snap---monthly-publication-july-2025.pdf   673 2025-07 Pedestrian London Taxi Taxi Black Contravening a Red Traffic Light None A444 at Austin Drive A444 at Austin Drive Coventry Coventry Education N/A   52.4471432 -1.4975901
12636 op-snap---monthly-publication-july-2025.pdf   688 2025-07 Pedestrian Mg 3... White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
12670 op-snap---monthly-publication-july-2025.pdf   722 2025-07 Pedestrian Renault Clio Black Driving without Due Care and Attention None Turners Lane Turners Lane Dudley Dudley NFA No Independent Evidence Available   52.4721372 -2.1243522
12673 op-snap---monthly-publication-july-2025.pdf   725 2025-07 Pedestrian Renault Zoe White Using a Mobile Phone Whilst Driving None Plough and Harrow Road Plough and Harrow Road Birmingham Birmingham Fixed Penalty N/A   52.5899123 -1.8057069
12684 op-snap---monthly-publication-july-2025.pdf   736 2025-07 Pedestrian Seat Ibiza Black Driving without Due Care and Attention None Hobbs Moat Road Hobbs Moat Road Solihull Solihull NFA No Offence      
12689 op-snap---monthly-publication-july-2025.pdf   741 2025-07 Pedestrian Jaguar F Pace Grey Driving without Due Care and Attention None B4034 Stratford Stratford Out of Force Area Out of Force Area NFA Out of Force      
12770 op-snap---monthly-publication-july-2025.pdf   822 2025-07 Pedestrian Peugeot 2008 Grey Misc - Non Traffic Offences None Reddicap Heath Road Reddicap Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.5606633 -1.7993168
12773 op-snap---monthly-publication-july-2025.pdf   825 2025-07 Pedestrian Toyota   White Using a Mobile Phone Whilst Driving None Fazeley Street Fazeley Street Birmingham Birmingham NFA No Offence   52.4798316 -1.8863917
12779 op-snap---monthly-publication-july-2025.pdf   831 2025-07 Pedestrian Toyota Yaris Black Driving without Due Care and Attention None Turners Lane Turners Lane Dudley Dudley NFA No Independent Evidence Available   52.4721372 -2.1243522
12785 op-snap---monthly-publication-july-2025.pdf   837 2025-07 Pedestrian Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Petersfield Road Petersfield Road Birmingham Birmingham Warning Letter N/A   52.4307 -1.8494663
12794 op-snap---monthly-publication-july-2025.pdf   846 2025-07 Pedestrian Volkswagen polo Black Driving without Due Care and Attention None Telford Telford Out of Force Area Out of Force Area NFA Out of Force   52.4979333 -1.9664857
12815 op-snap---monthly-publication-july-2025.pdf   867 2025-07 Pedestrian Mercedes-Benz S350 Silver Driving without Due Care and Attention None A3400 (Stratford Up on Avon) Warks A3400 (Stratford Up on Avon) Warks Out of Force Area Out of Force Area NFA Out of Force      
12820 op-snap---monthly-publication-july-2025.pdf   872 2025-07 Pedestrian Nissan   Black Cause vehicle to be left in a dangerous position None Bunbury Road , Northfield Bunbury Road , Northfield Birmingham Birmingham NFA Outside of 14 Days NIP   52.4142089 -1.9587147
12821 op-snap---monthly-publication-july-2025.pdf   873 2025-07 Pedestrian Ford   White Cause vehicle to be left in a dangerous position None Barnsley Road , Birmingham Barnsley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4743497 -1.965737
12822 op-snap---monthly-publication-july-2025.pdf   874 2025-07 Pedestrian Citroen   Red Cause vehicle to be left in a dangerous position None Barnsley Road , Birmingham Barnsley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4743497 -1.965737
12823 op-snap---monthly-publication-july-2025.pdf   875 2025-07 Pedestrian Citroen   Red Cause vehicle to be left in a dangerous position None Barnsley Road , Birmingham Barnsley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4743497 -1.965737
12824 op-snap---monthly-publication-july-2025.pdf   876 2025-07 Pedestrian Citroen   Red Cause vehicle to be left in a dangerous position None Barnsley Road , Birmingham Barnsley Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4743497 -1.965737
12828 op-snap---monthly-publication-july-2025.pdf   880 2025-07 Pedestrian Suzuki Jimmy Blue Driving without Due Care and Attention None Red House Avenue Red House Avenue Sandwell Sandwell NFA No Offence   52.5540383 -2.0075594
12829 op-snap---monthly-publication-july-2025.pdf   881 2025-07 Pedestrian Renault Traffic Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hertford WAY Hertford WAY Solihull Solihull NFA No Offence   52.3778812 -1.7427424
12836 op-snap---monthly-publication-july-2025.pdf   888 2025-07 Pedestrian Volkswagen Crafter White Cause vehicle to be left in a dangerous position None Kingstanging Road , Birningham Kingstanging Road , Birningham Birmingham Birmingham NFA Outside of 14 Days NIP      
12869 op-snap---monthly-publication-july-2025.pdf   921 2025-07 Pedestrian BMW 420 White Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12870 op-snap---monthly-publication-july-2025.pdf   922 2025-07 Pedestrian Audi   Grey Driving without Reasonable Consideration None York Road , Birmingham York Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5231321 -1.8415573
12871 op-snap---monthly-publication-july-2025.pdf   923 2025-07 Pedestrian Toyota Yaris Black Driving without Reasonable Consideration None Bradford Road , Birmingham Bradford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5024148 -1.7961753
12896 op-snap---monthly-publication-july-2025.pdf   948 2025-07 Pedestrian Ford Fiesta Black Driving without Reasonable Consideration None Level Street , Merry Hill Level Street , Merry Hill Dudley Dudley NFA Outside of 14 Days NIP      
12903 op-snap---monthly-publication-july-2025.pdf   955 2025-07 Pedestrian BMW 320D Black Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612733 -1.9430543
12906 op-snap---monthly-publication-july-2025.pdf   958 2025-07 Pedestrian Volkswagen Tiguan Silver Using a Mobile Phone Whilst Driving None Moseley Road, Willenhall Moseley Road, Willenhall Wolverhampton Wolverhampton Warning Letter N/A   52.5735847 -2.061316
12926 op-snap---monthly-publication-july-2025.pdf   978 2025-07 Pedestrian Ford Transit Silver Driving without Reasonable Consideration None Cole Hall Lane , Kitts Green Cole Hall Lane , Kitts Green Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883
12962 op-snap---monthly-publication-july-2025.pdf   1014 2025-07 Pedestrian Audi   Blue Driving without Reasonable Consideration None Newton Middleway , Birmingham Newton Middleway , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
12965 op-snap---monthly-publication-july-2025.pdf   1017 2025-07 Pedestrian Toyota Yaris Grey Driving without Reasonable Consideration None Paradise Street , Birmingham Paradise Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4790667 -1.9039768
12966 op-snap---monthly-publication-july-2025.pdf   1018 2025-07 Pedestrian Ford Fiesta Purple Cause vehicle to be left in a dangerous position None KIngstanding Road , Birmingham KIngstanding Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5457664 -1.8850964
12988 op-snap---monthly-publication-july-2025.pdf   1040 2025-07 Pedestrian Vauxhall Van White Dangerous Driving None High Street , Princess End High Street , Princess End Sandwell Sandwell NFA Outside of 14 Days NIP      
13001 op-snap---monthly-publication-july-2025.pdf   1053 2025-07 Pedestrian Mercedes-Benz   White Driving without Due Care and Attention None Russell Bank Road Russell Bank Road Birmingham Birmingham NFA No VRM   52.5941017 -1.8521585
13019 op-snap---monthly-publication-july-2025.pdf   1071 2025-07 Pedestrian Iveco Daily Blue Contravening a Red Traffic Light None Ansty Road A4600 Ansty Road A4600 Coventry Coventry Warning Letter N/A   52.416665 -1.4604791
13048 op-snap---monthly-publication-july-2025.pdf   1100 2025-07 Pedestrian Toyota Verso Black Using a Mobile Phone Whilst Driving None Heath Way Heath Way Birmingham Birmingham Fixed Penalty N/A   52.4963549 -1.7806171
13065 op-snap---monthly-publication-july-2025.pdf   1117 2025-07 Pedestrian Nissan Juke Red VRM fails to conform to Regulations None Slip Road Junction 10 M6 South Bou Slip Road Junction 10 M6 South Bou nOdut of Force Area Nodut Of Force Area NFA Outside of 14 Days NIP      
13095 op-snap---monthly-publication-july-2025.pdf   1147 2025-07 Pedestrian Nissan   Black Driving without Reasonable Consideration None The Parade , Boldmere The Parade , Boldmere Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
13120 op-snap---monthly-publication-july-2025.pdf   1172 2025-07 Pedestrian Nissan Qashqai Grey Contravening a Red Traffic Light None Foleshill Road A444 Foleshill Road A444 Coventry Coventry Warning Letter N/A   52.4363104 -1.4936555
13121 op-snap---monthly-publication-july-2025.pdf   1173 2025-07 Pedestrian Chevrolet Spark White Driving without Due Care and Attention None Malvern Malvern Out of Force Area Out of Force Area NFA Out of Force   52.4093693 -1.7713445
13126 op-snap---monthly-publication-july-2025.pdf   1178 2025-07 Pedestrian Nissan X Trail Silver Cause vehicle to be left in a dangerous position None Gabriel Drive , Birmingham Gabriel Drive , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
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      
13180 op-snap---monthly-publication-july-2025.pdf   1232 2025-07 Pedestrian Mercedes-Benz Benz Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None KIngs Road , Birmingham KIngs Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5540058 -1.888884
13194 op-snap---monthly-publication-july-2025.pdf   1246 2025-07 Pedestrian BMW 330e Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Sherborne Street Sherborne Street Birmingham Birmingham NFA No Independent Evidence Available   52.4762433 -1.9176665
13237 op-snap---monthly-publication-july-2025.pdf   1289 2025-07 Pedestrian Mitsubishi Outlander Blue Misc - Non Traffic Offences None High Street Wem (Shrewsbury) High Street Wem (Shrewsbury) Out of Force Area Out of Force Area NFA Misc Inc Crimes      
13259 op-snap---monthly-publication-july-2025.pdf   1311 2025-07 Pedestrian Vauxhall Corsa Blue Cause vehicle to be left in a dangerous position None St. Bernard Road Street. Bernard Road Birmingham Birmingham Warning Letter N/A      

Next page

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