home / opsnap

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

192 rows where disposal = "NFA" 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 24

  • Volkswagen 25
  • BMW 21
  • Ford 21
  • Mercedes-Benz 18
  • Toyota 15
  • Audi 12
  • Vauxhall 10
  • Skoda 7
  • Honda 6
  • Nissan 6
  • Peugeot 6
  • Renault 6
  • Hyundai 5
  • Kia 5
  • Lexus 4
  • Mini 4
  • Volvo 4
  • Seat 3
  • Citroen 2
  • Fiat 2
  • Jaguar 2
  • Mg 2
  • Mitsubishi 1
  • Suzuki 1

council_area 11

  • Birmingham 149
  • Coventry 13
  • Wolverhampton 10
  • Sandwell 5
  • Mbirmingham 4
  • Out of Force Area 4
  • Sutton Coldfield 3
  • Dudley 1
  • Halesowen 1
  • Solihull 1
  • Walsall 1

month 10

  • 2025-04 116
  • 2025-05 20
  • 2025-02 11
  • 2025-06 11
  • 2026-01 10
  • 2025-03 7
  • 2025-07 7
  • 2026-02 6
  • 2025-01 3
  • 2025-12 1

reporter_transport_mode 5

  • Car 142
  • Pedestrian 24
  • Pedal Bike 22
  • Other 3
  • Lorry 1

offence 1

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

disposal 1

  • NFA · 192 ✖
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
7588 op-snap---monthly-publication-february-2026.pdf   335 2026-02 Car       Stop a vehicle within pelican pedestrian crossing limits None Forman Road Forman Road Birmingham Birmingham NFA No Independent Evidence Available   52.4482084 -1.8578405
7907 op-snap---monthly-publication-february-2026.pdf   654 2026-02 Pedestrian Volkswagen   Black Stop a vehicle within pelican pedestrian crossing limits None Cheswick Green School Cheswick Green School Birmingham Birmingham NFA No Independent Evidence Available      
8236 op-snap---monthly-publication-february-2026.pdf   983 2026-02 Car Lexus IS 300H Silver Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham NFA Not in Public Interest   52.502683 -1.9033516
8703 op-snap---monthly-publication-february-2026.pdf   1450 2026-02 Car Peugeot 3008 Black Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
8849 op-snap---monthly-publication-february-2026.pdf   1596 2026-02 Car Renault master White Stop a vehicle within pelican pedestrian crossing limits None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
8890 op-snap---monthly-publication-february-2026.pdf   1637 2026-02 Pedal Bike Jaguar xj Black Stop a vehicle within pelican pedestrian crossing limits None stoney stanton road Stoney Stanton Road Coventry Coventry NFA Misc Inc Crimes   52.4221152 -1.4959475
10679 op-snap---monthly-publication-january-2026.pdf   140 2026-01 Car Ford Focus Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Independent Evidence Available   52.4929304 -1.8229092
10758 op-snap---monthly-publication-january-2026.pdf   219 2026-01 Pedestrian Nissan Juke Black Stop a vehicle within pelican pedestrian crossing limits None Regent Road Regent Road Sandwell Sandwell NFA No Offence   52.5106406 -2.0559963
10767 op-snap---monthly-publication-january-2026.pdf   228 2026-01 Pedestrian Toyota Prius Silver Stop a vehicle within pelican pedestrian crossing limits None Regent Road Regent Road Sandwell Sandwell NFA No Independent Evidence Available   52.5106406 -2.0559963
10965 op-snap---monthly-publication-january-2026.pdf   426 2026-01 Car Ford Fiesta Grey Stop a vehicle within pelican pedestrian crossing limits No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Independent Evidence Available   52.4929304 -1.8229092
10975 op-snap---monthly-publication-january-2026.pdf   436 2026-01 Car Peugeot 5008 Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Offence   52.4929304 -1.8229092
11184 op-snap---monthly-publication-january-2026.pdf   645 2026-01 Car Toyota ... Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Independent Evidence Available   52.4929304 -1.8229092
11271 op-snap---monthly-publication-january-2026.pdf   732 2026-01 Car Hyundai Santa Fe Silver Stop a vehicle within pelican pedestrian crossing limits No Insurance Garretts Green Lane Garretts Green Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4675802 -1.7905748
11322 op-snap---monthly-publication-january-2026.pdf   783 2026-01 Car Renault Captur White Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham NFA Not in Public Interest   52.502683 -1.9033516
11465 op-snap---monthly-publication-january-2026.pdf   926 2026-01 Pedestrian Ford transit Yellow Stop a vehicle within pelican pedestrian crossing limits None Zoar Street Zoar Street Dudley Dudley NFA No Independent Evidence Available   52.5178733 -2.1280333
11659 op-snap---monthly-publication-january-2026.pdf   1120 2026-01 Other Ford transit White Stop a vehicle within pelican pedestrian crossing limits none Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
5128 op-snap---monthly-publication-december-2025.pdf   1256 2025-12 Pedestrian Volvo V60 Blue Stop a vehicle within pelican pedestrian crossing limits None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
12837 op-snap---monthly-publication-july-2025.pdf   889 2025-07 Car Audi   Black Stop a vehicle within pelican pedestrian crossing limits None Garretts Lane , Sheldon Garretts Lane , Sheldon Birmingham Birmingham NFA Outside of 14 Days NIP      
12838 op-snap---monthly-publication-july-2025.pdf   890 2025-07 Car Mercedes-Benz   Blue Stop a vehicle within pelican pedestrian crossing limits None Garretts Green Lane , Sheldon Garretts Green Lane , Sheldon Birmingham Birmingham NFA Outside of 14 Days NIP      
12839 op-snap---monthly-publication-july-2025.pdf   891 2025-07 Car Ford   Grey Stop a vehicle within pelican pedestrian crossing limits None Garretts Green Lane , Sheldon Garretts Green Lane , Sheldon Birmingham Birmingham NFA Outside of 14 Days NIP      
13011 op-snap---monthly-publication-july-2025.pdf   1063 2025-07 Car   NP Silver Stop a vehicle within pelican pedestrian crossing limits None Coombes Road , Halesowen Coombes Road , Halesowen Halesowen Halesowen NFA Outside of 14 Days NIP   52.4586877 -2.0485388
13013 op-snap---monthly-publication-july-2025.pdf   1065 2025-07 Car Vauxhall   White Stop a vehicle within pelican pedestrian crossing limits None St Marys Row , Moseley , Birmingham Street Marys Row , Moseley , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
13063 op-snap---monthly-publication-july-2025.pdf   1115 2025-07 Other Ford Fiesta Silver Stop a vehicle within pelican pedestrian crossing limits None SYcamore Road , Bournville SYcamore Road , Bournville Birmingham Birmingham NFA Outside of 14 Days NIP   52.430564 -1.9341477
13064 op-snap---monthly-publication-july-2025.pdf   1116 2025-07 Other Volvo   Silver Stop a vehicle within pelican pedestrian crossing limits None Sycamore Road , Bournville Sycamore Road , Bournville Birmingham Birmingham NFA Outside of 14 Days NIP   52.430564 -1.9341477
14607 op-snap---monthly-publication-june-2025.pdf   536 2025-06 Pedestrian BMW X5 Black Stop a vehicle within pelican pedestrian crossing limits None Dudley Road Dudley Road Birmingham Birmingham NFA No VRM   52.4865107 -1.9386263
15368 op-snap---monthly-publication-june-2025.pdf   1297 2025-06 Pedestrian Vauxhall Corsa Black Stop a vehicle within pelican pedestrian crossing limits None Clifton Down, Bristol Clifton Down, Bristol Out of Force Area Out of Force Area NFA Out of Force      
15418 op-snap---monthly-publication-june-2025.pdf   1347 2025-06 Pedestrian Kia   White Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham NFA No Independent Evidence Available   52.4242527 -1.910803
15419 op-snap---monthly-publication-june-2025.pdf   1348 2025-06 Pedestrian Vauxhall   Grey Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham NFA No Independent Evidence Available   52.4242527 -1.910803
15786 op-snap---monthly-publication-june-2025.pdf   1715 2025-06 Pedal Bike Volkswagen   Blue Stop a vehicle within pelican pedestrian crossing limits None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
15788 op-snap---monthly-publication-june-2025.pdf   1717 2025-06 Pedal Bike Peugeot   White Stop a vehicle within pelican pedestrian crossing limits None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
15789 op-snap---monthly-publication-june-2025.pdf   1718 2025-06 Pedal Bike Vauxhall   Silver Stop a vehicle within pelican pedestrian crossing limits None Pershore Road Pershore Road Birmingham Birmingham NFA No VRM   52.4308271 -1.920078
15790 op-snap---monthly-publication-june-2025.pdf   1719 2025-06 Pedal Bike Mercedes-Benz   Blue Stop a vehicle within pelican pedestrian crossing limits None Pershore Road Pershore Road Birmingham Birmingham NFA No VRM   52.4308271 -1.920078
15801 op-snap---monthly-publication-june-2025.pdf   1730 2025-06 Car Mercedes-Benz E350 Black Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Offence   52.4967329 -1.8097462
15987 op-snap---monthly-publication-june-2025.pdf   1916 2025-06 Car Skoda   Grey Stop a vehicle within pelican pedestrian crossing limits None Robin Hood Lane Robin Hood Lane Solihull Solihull NFA Not in Public Interest   52.422933 -1.8352662
16023 op-snap---monthly-publication-june-2025.pdf   1952 2025-06 Pedestrian Citroen C1 Red Stop a vehicle within pelican pedestrian crossing limits None Coleshill Street Coleshill Street Birmingham Birmingham NFA No Offence   52.5645717 -1.8214603
18894 op-snap---monthly-publication-may-2025.pdf   256 2025-05 Pedal Bike BMW 320 Blue Stop a vehicle within pelican pedestrian crossing limits None High Street High Street Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5635963 -2.0827567
19111 op-snap---monthly-publication-may-2025.pdf   473 2025-05 Car BMW 123d Blue Stop a vehicle within pelican pedestrian crossing limits None High Street, Tettenhall High Street, Tettenhall Wolverhampton Wolverhampton NFA No Offence   52.5980906 -2.168057
19153 op-snap---monthly-publication-may-2025.pdf   515 2025-05 Pedal Bike Toyota Prius White Stop a vehicle within pelican pedestrian crossing limits None Trinity Street Trinity Street Coventry Coventry NFA Misc Inc Crimes   52.4086572 -1.5097176
19449 op-snap---monthly-publication-may-2025.pdf   811 2025-05 Pedal Bike Ford Puma Blue Stop a vehicle within pelican pedestrian crossing limits None Gooch St Gooch Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4686609 -1.8945007
19770 op-snap---monthly-publication-may-2025.pdf   1132 2025-05 Car BMW M135i Blue Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Independent Evidence Available   52.4929304 -1.8229092
19771 op-snap---monthly-publication-may-2025.pdf   1133 2025-05 Car Seat Leon Red Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Independent Evidence Available   52.4967329 -1.8097462
19833 op-snap---monthly-publication-may-2025.pdf   1195 2025-05 Car Mercedes-Benz   Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Offence   52.4929304 -1.8229092
19959 op-snap---monthly-publication-may-2025.pdf   1321 2025-05 Car Seat Tarraco White Stop a vehicle within pelican pedestrian crossing limits None Brockworth Road , Birmingham Brockworth Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4076164 -1.9073859
19960 op-snap---monthly-publication-may-2025.pdf   1322 2025-05 Car Peugeot NP Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingha Washwood Heath Road , Birmingha mBirmingham Mbirmingham NFA Outside of 14 Days NIP      
19961 op-snap---monthly-publication-may-2025.pdf   1323 2025-05 Car Jaguar E PACE White Stop a vehicle within pelican pedestrian crossing limits None Hurstcroft Road , Birmingham Hurstcroft Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4830179 -1.783876
19962 op-snap---monthly-publication-may-2025.pdf   1324 2025-05 Car Toyota NP White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4929304 -1.8229092
19963 op-snap---monthly-publication-may-2025.pdf   1325 2025-05 Pedal Bike Peugeot Boxer White Stop a vehicle within pelican pedestrian crossing limits None Stoney STanton Road , Coventry Stoney STanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
19964 op-snap---monthly-publication-may-2025.pdf   1326 2025-05 Car Honda Civic Red Stop a vehicle within pelican pedestrian crossing limits None High Street , Tetenhall High Street , Tetenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
19965 op-snap---monthly-publication-may-2025.pdf   1327 2025-05 Car Seat NP Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingha Washwood Heath Road , Birmingha mBirmingham Mbirmingham NFA Outside of 14 Days NIP      
19967 op-snap---monthly-publication-may-2025.pdf   1329 2025-05 Car Volkswagen NP Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingha Washwood Heath Road , Birmingha mBirmingham Mbirmingham NFA Outside of 14 Days NIP      
19968 op-snap---monthly-publication-may-2025.pdf   1330 2025-05 Car Audi NP Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingha Washwood Heath Road , Birmingha mBirmingham Mbirmingham NFA Outside of 14 Days NIP      
19969 op-snap---monthly-publication-may-2025.pdf   1331 2025-05 Car Honda NP White Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road , Birmingham Coleshill Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5008899 -1.7993095
19972 op-snap---monthly-publication-may-2025.pdf   1334 2025-05 Car Volkswagen NP Orange Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road , Birmingham Coleshill Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5008899 -1.7993095
19975 op-snap---monthly-publication-may-2025.pdf   1337 2025-05 Car Mercedes-Benz van White Stop a vehicle within pelican pedestrian crossing limits None Fox Hollies Road , Birmingham Fox Hollies Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5431333 -1.7960713
20109 op-snap---monthly-publication-may-2025.pdf   1471 2025-05 Car BMW NP White Stop a vehicle within pelican pedestrian crossing limits None College road, moseley College road, moseley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4295958 -1.8874346
324 op-snap---monthly-publication-april-2025.pdf   323 2025-04 Car Ford Focus Red Stop a vehicle within pelican pedestrian crossing limits No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
556 op-snap---monthly-publication-april-2025.pdf   555 2025-04 Pedal Bike Mercedes-Benz A180 Red Stop a vehicle within pelican pedestrian crossing limits None Delves Road Delves Road Birmingham Birmingham NFA Misc Inc Crimes      
619 op-snap---monthly-publication-april-2025.pdf   618 2025-04 Car BMW 420d Grey Stop a vehicle within pelican pedestrian crossing limits None High St, Tettenhall High Street, Tettenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5980906 -2.168057
622 op-snap---monthly-publication-april-2025.pdf   621 2025-04 Lorry Skoda Fabia Silver Stop a vehicle within pelican pedestrian crossing limits None High St, tettenhall High Street, tettenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5980906 -2.168057
637 op-snap---monthly-publication-april-2025.pdf   636 2025-04 Car Nissan Micra Grey Stop a vehicle within pelican pedestrian crossing limits None High St, Tettenhall High Street, Tettenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5980906 -2.168057
1337 op-snap---monthly-publication-april-2025.pdf   1336 2025-04 Car Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road , Kingstanding Kingstanding Road , Kingstanding Birmingham Birmingham NFA Outside of 14 Days NIP   52.5551037 -1.8834687
1338 op-snap---monthly-publication-april-2025.pdf   1337 2025-04 Car Nissan Qashqai Black Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road , Kingstanding Kingstanding Road , Kingstanding Birmingham Birmingham NFA Outside of 14 Days NIP   52.5551037 -1.8834687
1339 op-snap---monthly-publication-april-2025.pdf   1338 2025-04 Car Mercedes-Benz C Black Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road , Kingstanding Kingstanding Road , Kingstanding Birmingham Birmingham NFA Outside of 14 Days NIP   52.5551037 -1.8834687
1364 op-snap---monthly-publication-april-2025.pdf   1363 2025-04 Car Audi   Grey Stop a vehicle within pelican pedestrian crossing limits None High Street , Tetenhall High Street , Tetenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
1380 op-snap---monthly-publication-april-2025.pdf   1379 2025-04 Car Mercedes-Benz NP White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1381 op-snap---monthly-publication-april-2025.pdf   1380 2025-04 Car Toyota NP Beige Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1382 op-snap---monthly-publication-april-2025.pdf   1381 2025-04 Car Toyota NP Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1383 op-snap---monthly-publication-april-2025.pdf   1382 2025-04 Car Renault NP Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1385 op-snap---monthly-publication-april-2025.pdf   1384 2025-04 Pedestrian Ford NP Silver Stop a vehicle within pelican pedestrian crossing limits None Stratford Road , Birmingham Stratford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
1397 op-snap---monthly-publication-april-2025.pdf   1396 2025-04 Car Volkswagen NP White Stop a vehicle within pelican pedestrian crossing limits None College Road , Birmingham College Road , Birmingham Coventry Coventry NFA Outside of 14 Days NIP   52.4699264 -1.8595739
1411 op-snap---monthly-publication-april-2025.pdf   1410 2025-04 Car Toyota Prius Red Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road , Coventry Stoney Stanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1418 op-snap---monthly-publication-april-2025.pdf   1417 2025-04 Car Volkswagen Polo Silver Stop a vehicle within pelican pedestrian crossing limits None High Street , Tetenhall High Street , Tetenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
1429 op-snap---monthly-publication-april-2025.pdf   1428 2025-04 Car Ford NP Blue Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road , Coventry Stoney Stanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1431 op-snap---monthly-publication-april-2025.pdf   1430 2025-04 Car Ford Fiesta White Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road , Coventry Stoney Stanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1432 op-snap---monthly-publication-april-2025.pdf   1431 2025-04 Car Kia NP Silver Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road , Coventry Stoney Stanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963
1444 op-snap---monthly-publication-april-2025.pdf   1443 2025-04 Car Volkswagen NP Black Stop a vehicle within pelican pedestrian crossing limits None washwood Heath road washwood Heath road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4929304 -1.8229092
1467 op-snap---monthly-publication-april-2025.pdf   1466 2025-04 Car Mercedes-Benz NP White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1469 op-snap---monthly-publication-april-2025.pdf   1468 2025-04 Car Volkswagen NP Red Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1479 op-snap---monthly-publication-april-2025.pdf   1478 2025-04 Car Lexus NP Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1482 op-snap---monthly-publication-april-2025.pdf   1481 2025-04 Pedal Bike Skoda Octavia Silver Stop a vehicle within pelican pedestrian crossing limits None Fulford Road , Birmingham Fulford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1485 op-snap---monthly-publication-april-2025.pdf   1484 2025-04 Pedal Bike Vauxhall Corsa Silver Stop a vehicle within pelican pedestrian crossing limits None Fulford Hall Road Fulford Hall Road Birmingham Birmingham NFA Outside of 14 Days NIP      
1496 op-snap---monthly-publication-april-2025.pdf   1495 2025-04 Car Volkswagen Polo Grey Stop a vehicle within pelican pedestrian crossing limits None Rough Road , Kingstanding Rough Road , Kingstanding Birmingham Birmingham NFA Outside of 14 Days NIP   52.5539433 -1.8804348
1498 op-snap---monthly-publication-april-2025.pdf   1497 2025-04 Car Skoda NP White Stop a vehicle within pelican pedestrian crossing limits None Springfield Road , Birmingham Springfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4348104 -1.887573
1516 op-snap---monthly-publication-april-2025.pdf   1515 2025-04 Pedal Bike BMW 2 Series White Stop a vehicle within pelican pedestrian crossing limits None Alcester Road , Birmingham Alcester Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.452635 -1.8874738
1517 op-snap---monthly-publication-april-2025.pdf   1516 2025-04 Pedal Bike Mercedes-Benz Sprinter White Stop a vehicle within pelican pedestrian crossing limits None St Marys Row , Birmingham Street Marys Row , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1518 op-snap---monthly-publication-april-2025.pdf   1517 2025-04 Pedal Bike Mercedes-Benz Sprinter White Stop a vehicle within pelican pedestrian crossing limits None Gooch Street , Birmingham Gooch Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4671612 -1.8933216
1527 op-snap---monthly-publication-april-2025.pdf   1526 2025-04 Pedal Bike Ford Focus Black Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane , Wednesbury Crankhall Lane , Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5562019 -2.0028056
1532 op-snap---monthly-publication-april-2025.pdf   1531 2025-04 Pedestrian BMW NP Black Stop a vehicle within pelican pedestrian crossing limits None Walstead Road , Walsall Walstead Road , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5648629 -1.9517624
1554 op-snap---monthly-publication-april-2025.pdf   1553 2025-04 Car Skoda NP White Stop a vehicle within pelican pedestrian crossing limits None Springfield Road , Birmingham Springfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4348104 -1.887573
1555 op-snap---monthly-publication-april-2025.pdf   1554 2025-04 Car Audi NP Grey Stop a vehicle within pelican pedestrian crossing limits None Springfield Road , Birmingham Springfield Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4348104 -1.887573
1558 op-snap---monthly-publication-april-2025.pdf   1557 2025-04 Pedestrian BMW 118 Silver Stop a vehicle within pelican pedestrian crossing limits None High Street , Tetenhall High Street , Tetenhall Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
1559 op-snap---monthly-publication-april-2025.pdf   1558 2025-04 Car Volkswagen NP Grey Stop a vehicle within pelican pedestrian crossing limits None Stratford Road , Birmingham Stratford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
1570 op-snap---monthly-publication-april-2025.pdf   1569 2025-04 Car   Maximus Van White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1572 op-snap---monthly-publication-april-2025.pdf   1571 2025-04 Car Suzuki NP Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1574 op-snap---monthly-publication-april-2025.pdf   1573 2025-04 Car BMW NP White Stop a vehicle within pelican pedestrian crossing limits None Washwood heath Road , Birmingham Washwood heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1575 op-snap---monthly-publication-april-2025.pdf   1574 2025-04 Car Volkswagen NP Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1601 op-snap---monthly-publication-april-2025.pdf   1600 2025-04 Car Volkswagen NP White Stop a vehicle within pelican pedestrian crossing limits None Ladywood Middleway , Birmingham Ladywood Middleway , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4756405 -1.9233482
1602 op-snap---monthly-publication-april-2025.pdf   1601 2025-04 Car Volkswagen NP Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1603 op-snap---monthly-publication-april-2025.pdf   1602 2025-04 Car Mitsubishi NP Red Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Birmingham Washwood Heath Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
1607 op-snap---monthly-publication-april-2025.pdf   1606 2025-04 Pedestrian Ford TRansit White Stop a vehicle within pelican pedestrian crossing limits None KIngstanding Road , Birmingham KIngstanding Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5457664 -1.8850964

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