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

105 rows where disposal = "Education", offence = "Driving without Due Care and Attention" and vehicle_make = "Vauxhall" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

month 13

  • 2025-11 15
  • 2025-10 11
  • 2025-05 10
  • 2026-01 10
  • 2025-03 9
  • 2026-02 9
  • 2025-06 8
  • 2025-07 8
  • 2025-08 8
  • 2025-09 8
  • 2025-02 4
  • 2025-12 3
  • 2025-01 2

reporter_transport_mode 8

  • Car 62
  • Pedal Bike 31
  • Motorbike 4
  • Lorry 2
  • Pedestrian 2
  • car 2
  • Horse Rider 1
  • Other 1

council_area 8

  • Birmingham 60
  • Sandwell 12
  • Dudley 8
  • Solihull 7
  • Walsall 7
  • Sutton Coldfield 5
  • Coventry 4
  • Wolverhampton 2

vehicle_make 1

  • Vauxhall · 105 ✖

offence 1

  • Driving without Due Care and Attention · 105 ✖

disposal 1

  • Education · 105 ✖
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
7353 op-snap---monthly-publication-february-2026.pdf   100 2026-02 Pedal Bike Vauxhall Corsa Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
7577 op-snap---monthly-publication-february-2026.pdf   324 2026-02 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Bromyard Road Bromyard Road Birmingham Birmingham Education N/A   52.4457403 -1.8536648
7698 op-snap---monthly-publication-february-2026.pdf   445 2026-02 Horse Rider Vauxhall Corsa Grey Driving without Due Care and Attention None Wakeley Hill Penn between Mount Rd and Swan Bank Wakeley Hill Penn between Mount Road and Swan Bank Wolverhampton Wolverhampton Education N/A      
7885 op-snap---monthly-publication-february-2026.pdf   632 2026-02 Car Vauxhall Corsa Blue Driving without Due Care and Attention None M6 after J4 M6 after J4 Birmingham Birmingham Education N/A      
8081 op-snap---monthly-publication-february-2026.pdf   828 2026-02 Pedal Bike Vauxhall Vicaro silver Driving without Due Care and Attention none A491 Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
8110 op-snap---monthly-publication-february-2026.pdf   857 2026-02 Car Vauxhall Mokka Grey Driving without Due Care and Attention None Black Country New Road Black Country New Road Sandwell Sandwell Education N/A   52.5527191 -2.0312967
8113 op-snap---monthly-publication-february-2026.pdf   860 2026-02 Car Vauxhall Mokka Silver Driving without Due Care and Attention None Foundry Road Foundry Road Birmingham Birmingham Education N/A   52.4939937 -1.9413942
8240 op-snap---monthly-publication-february-2026.pdf   987 2026-02 Car Vauxhall Vivaro Grey Driving without Due Care and Attention None Dudley Port Road, Tipton Dudley Port Road, Tipton Dudley Dudley Education N/A   52.5320271 -2.0666926
8673 op-snap---monthly-publication-february-2026.pdf   1420 2026-02 Car Vauxhall Combo White Driving without Due Care and Attention None Rowley Village Rowley Village Sandwell Sandwell Education N/A   52.48281 -2.042749
10824 op-snap---monthly-publication-january-2026.pdf   285 2026-01 Car Vauxhall Astra Red Driving without Due Care and Attention None Darlaston Road, Pleck Darlaston Road, Pleck Walsall Walsall Education N/A   52.5746221 -2.0037353
10858 op-snap---monthly-publication-january-2026.pdf   319 2026-01 Car Vauxhall Insignia Black Driving without Due Care and Attention None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell Education N/A   52.5010052 -2.0306321
11245 op-snap---monthly-publication-january-2026.pdf   706 2026-01 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Pershore Road South, Kings Norton Pershore Road South, Kings Norton Birmingham Birmingham Education N/A   52.4116071 -1.9297714
11470 op-snap---monthly-publication-january-2026.pdf   931 2026-01 Car Vauxhall Astra Grey Driving without Due Care and Attention None Balsall Street East Balsall Street East Solihull Solihull Education N/A   52.3854087 -1.6550831
11517 op-snap---monthly-publication-january-2026.pdf   978 2026-01 Car Vauxhall Insignia White Driving without Due Care and Attention None Moseley Avenue Moseley Avenue Coventry Coventry Education N/A   52.417344 -1.5264979
11550 op-snap---monthly-publication-january-2026.pdf   1011 2026-01 Pedal Bike Vauxhall Corsa Red Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham Education N/A   52.4045186 -1.9891793
11594 op-snap---monthly-publication-january-2026.pdf   1055 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Wychall Road Wychall Road Birmingham Birmingham Education N/A   52.4089092 -1.9498562
11691 op-snap---monthly-publication-january-2026.pdf   1152 2026-01 Car Vauxhall Movano Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
11877 op-snap---monthly-publication-january-2026.pdf   1338 2026-01 Lorry Vauxhall Antara Silver Driving without Due Care and Attention None M6 Motorway M6 Motorway Coventry Coventry Education N/A      
11924 op-snap---monthly-publication-january-2026.pdf   1385 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None B4102 Solihull Road Solihull Road Solihull Solihull Education N/A   52.4114159 -1.8197732
4035 op-snap---monthly-publication-december-2025.pdf   163 2025-12 Other Vauxhall Vivaro White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4774 op-snap---monthly-publication-december-2025.pdf   902 2025-12 car Vauxhall Corsa Silver Driving without Due Care and Attention None California Way California Way Birmingham Birmingham Education N/A   52.4454714 -1.9753804
4877 op-snap---monthly-publication-december-2025.pdf   1005 2025-12 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Teviot Grove, Kings Norton Teviot Grove, Kings Norton Birmingham Birmingham Education N/A   52.3986816 -1.9362011
20464 op-snap---monthly-publication-november-2025.pdf   6 2025-11 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Upper Clifton Road Upper Clifton Road Sutton Coldfield Sutton Coldfield Education N/A   52.5664481 -1.8270564
20483 op-snap---monthly-publication-november-2025.pdf   25 2025-11 Car Vauxhall astra Red Driving without Due Care and Attention None M6 /M42 M6 /M42 Birmingham Birmingham Education N/A   52.5183642 -1.8724942
20498 op-snap---monthly-publication-november-2025.pdf   40 2025-11 Car Vauxhall corsa Grey Driving without Due Care and Attention None Booth Street Booth Street Birmingham Birmingham Education N/A   52.5039035 -1.9447084
20761 op-snap---monthly-publication-november-2025.pdf   303 2025-11 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham Education N/A   52.4304526 -1.9216716
20796 op-snap---monthly-publication-november-2025.pdf   338 2025-11 Car Vauxhall Astra Black Driving without Due Care and Attention None Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
21052 op-snap---monthly-publication-november-2025.pdf   594 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Lower Queen Street Lower Queen Street Sutton Coldfield Sutton Coldfield Education N/A   52.5603978 -1.8227403
21412 op-snap---monthly-publication-november-2025.pdf   954 2025-11 Car Vauxhall Corsa Black Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
21432 op-snap---monthly-publication-november-2025.pdf   974 2025-11 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Walsall Road, Perry Barr Walsall Road, Perry Barr Birmingham Birmingham Education N/A   52.5290137 -1.9098939
21554 op-snap---monthly-publication-november-2025.pdf   1096 2025-11 Car Vauxhall Vivaro White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Dudley Dudley Education N/A   52.5063917 -2.1711502
21562 op-snap---monthly-publication-november-2025.pdf   1104 2025-11 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
21671 op-snap---monthly-publication-november-2025.pdf   1213 2025-11 Car Vauxhall Corsa White Driving without Due Care and Attention None Drew's Lane, Washwood Heath Drew's Lane, Washwood Heath Birmingham Birmingham Education N/A      
21740 op-snap---monthly-publication-november-2025.pdf   1282 2025-11 Car Vauxhall Mokka Black Driving without Due Care and Attention None Farnhurst Road Farnhurst Road Birmingham Birmingham Education N/A   52.5020897 -1.8273258
21865 op-snap---monthly-publication-november-2025.pdf   1407 2025-11 Car Vauxhall Mokka Black Driving without Due Care and Attention None Station Road, Dorridge Station Road, Dorridge Solihull Solihull Education N/A   52.3737352 -1.7528435
21900 op-snap---monthly-publication-november-2025.pdf   1442 2025-11 Motorbike Vauxhall Astra Purple Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
21994 op-snap---monthly-publication-november-2025.pdf   1536 2025-11 Car Vauxhall Vivaro White Driving without Due Care and Attention None Lincoln Street Lincoln Street Birmingham Birmingham Education N/A   52.459298 -1.8933648
22144 op-snap---monthly-publication-october-2025.pdf   94 2025-10 Car Vauxhall Mokka Red Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
22277 op-snap---monthly-publication-october-2025.pdf   227 2025-10 Car Vauxhall Astra Silver Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
22415 op-snap---monthly-publication-october-2025.pdf   365 2025-10 Pedal Bike Vauxhall Grandland White Driving without Due Care and Attention None A452 Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
22498 op-snap---monthly-publication-october-2025.pdf   448 2025-10 Car Vauxhall Astra Silver Driving without Due Care and Attention None Broadway Broadway Walsall Walsall Education N/A   52.5719937 -1.9639882
22511 op-snap---monthly-publication-october-2025.pdf   461 2025-10 Pedal Bike Vauxhall Insignia Silver Driving without Due Care and Attention None Redhill Road Redhill Road Birmingham Birmingham Education N/A   52.4618364 -1.8328803
22575 op-snap---monthly-publication-october-2025.pdf   525 2025-10 Pedal Bike Vauxhall Vivaro Blue Driving without Due Care and Attention None Wagon Lane Wagon Lane Birmingham Birmingham Education N/A   52.4546868 -1.793848
22630 op-snap---monthly-publication-october-2025.pdf   580 2025-10 Car Vauxhall Corsa Red Driving without Due Care and Attention Use vehicle on a road without valid test certificate Stratford Road, Sparkhill Stratford Road, Sparkhill Birmingham Birmingham Education N/A   52.4629039 -1.8756464
22685 op-snap---monthly-publication-october-2025.pdf   635 2025-10 Pedal Bike Vauxhall Astra Black Driving without Due Care and Attention None Highfield Road Hall Green Highfield Road Hall Green Birmingham Birmingham Education N/A   52.4259801 -1.8449998
22946 op-snap---monthly-publication-october-2025.pdf   896 2025-10 Pedal Bike Vauxhall Corsa Grey Driving without Due Care and Attention None Walsall Road Walsall Road Sandwell Sandwell Education N/A   52.5439824 -1.9306805
22969 op-snap---monthly-publication-october-2025.pdf   919 2025-10 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Education N/A   52.5170745 -1.9012542
22996 op-snap---monthly-publication-october-2025.pdf   946 2025-10 Pedal Bike Vauxhall Mokka White Driving without Due Care and Attention None Woden Road East Woden Road East Walsall Walsall Education N/A      
23998 op-snap---monthly-publication-september-2025.pdf   217 2025-09 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Church Road Edgbaston Church Road Edgbaston Birmingham Birmingham Education N/A   52.46114 -1.9180882
24182 op-snap---monthly-publication-september-2025.pdf   401 2025-09 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield Education N/A   52.5405351 -1.8002219
24268 op-snap---monthly-publication-september-2025.pdf   487 2025-09 Pedal Bike Vauxhall Combo Grey Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley Education N/A   52.4628538 -2.1160108
24290 op-snap---monthly-publication-september-2025.pdf   509 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Education N/A   52.5344405 -1.985568
24403 op-snap---monthly-publication-september-2025.pdf   622 2025-09 Car Vauxhall Zafira Brown Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Education N/A      
24443 op-snap---monthly-publication-september-2025.pdf   662 2025-09 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None George Road George Road Birmingham Birmingham Education N/A   52.5155831 -1.8598862
24457 op-snap---monthly-publication-september-2025.pdf   676 2025-09 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
24712 op-snap---monthly-publication-september-2025.pdf   931 2025-09 Pedestrian Vauxhall Caddy White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
2233 op-snap---monthly-publication-august-2025.pdf   208 2025-08 Car Vauxhall Agila Red Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
2288 op-snap---monthly-publication-august-2025.pdf   263 2025-08 Car Vauxhall Corsa White Driving without Due Care and Attention None     Sandwell Sandwell Education N/A      
2326 op-snap---monthly-publication-august-2025.pdf   301 2025-08 Pedal Bike Vauxhall Grandland Blue Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Education N/A   52.6095168 -2.0493009
2373 op-snap---monthly-publication-august-2025.pdf   348 2025-08 Car Vauxhall Combo Silver Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Education N/A   52.470423 -1.9304786
2554 op-snap---monthly-publication-august-2025.pdf   529 2025-08 Pedal Bike Vauxhall Mokka Grey Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A      
2661 op-snap---monthly-publication-august-2025.pdf   636 2025-08 Car Vauxhall Mokka Blue Driving without Due Care and Attention None Stonebridge Island Stonebridge Island Coventry Coventry Education N/A   52.4459998 -1.6949291
2741 op-snap---monthly-publication-august-2025.pdf   716 2025-08 Car Vauxhall Corsa Red Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
3078 op-snap---monthly-publication-august-2025.pdf   1053 2025-08 Pedal Bike Vauxhall Adam Black Driving without Due Care and Attention None Wychall Lane Wychall Lane Birmingham Birmingham Education N/A   52.4090761 -1.9404121
11975 op-snap---monthly-publication-july-2025.pdf   27 2025-07 Motorbike Vauxhall Corsa Grey Driving without Due Care and Attention None Tamworth Road Tamworth Road Sutton Coldfield Sutton Coldfield Education N/A   52.5750404 -1.8129485
12197 op-snap---monthly-publication-july-2025.pdf   249 2025-07 Car Vauxhall Astra Grey Driving without Due Care and Attention None Wharf Road Wharf Road Birmingham Birmingham Education N/A   52.4075531 -1.927329
12258 op-snap---monthly-publication-july-2025.pdf   310 2025-07 Car Vauxhall Combo Grey Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Education N/A   52.4428606 -1.812114
12520 op-snap---monthly-publication-july-2025.pdf   572 2025-07 Car Vauxhall   White Driving without Due Care and Attention None Newbury Lane Newbury Lane Sandwell Sandwell Education N/A   52.4994655 -2.0285102
12542 op-snap---monthly-publication-july-2025.pdf   594 2025-07 Pedal Bike Vauxhall Insignia Grey Driving without Due Care and Attention None Enville Road, Kingswinford Enville Road, Kingswinford Sandwell Sandwell Education N/A      
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      
12826 op-snap---monthly-publication-july-2025.pdf   878 2025-07 Car Vauxhall Astra Black Driving without Due Care and Attention None Holyhead Road Holyhead Road Birmingham Birmingham Education N/A   52.505233 -1.9446276
13202 op-snap---monthly-publication-july-2025.pdf   1254 2025-07 Car Vauxhall Astra Black Driving without Due Care and Attention None Water Orton Road Water Orton Road Birmingham Birmingham Education N/A   52.5153394 -1.7573409
14164 op-snap---monthly-publication-june-2025.pdf   93 2025-06 Car Vauxhall Insignia White Driving without Due Care and Attention None A41 West Bromwich West Bromwich Sandwell Sandwell Education N/A   52.5186579 -1.9923114
14282 op-snap---monthly-publication-june-2025.pdf   211 2025-06 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
14753 op-snap---monthly-publication-june-2025.pdf   682 2025-06 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Haden Circus Haden Circus Birmingham Birmingham Education N/A   52.46284 -1.8867453
14868 op-snap---monthly-publication-june-2025.pdf   797 2025-06 Car Vauxhall Corsa Black Driving without Due Care and Attention None Westbourne Road Westbourne Road Birmingham Birmingham Education N/A   52.5083818 -1.9447229
15166 op-snap---monthly-publication-june-2025.pdf   1095 2025-06 Car Vauxhall Astra White Driving without Due Care and Attention None Park Road West Park Road West Wolverhampton Wolverhampton Education N/A   52.587131 -2.1396643
15284 op-snap---monthly-publication-june-2025.pdf   1213 2025-06 Car Vauxhall Astra Silver Driving without Due Care and Attention None Old Dickens Heath Road Old Dickens Heath Road Solihull Solihull Education N/A   52.3864791 -1.8355922
15521 op-snap---monthly-publication-june-2025.pdf   1450 2025-06 Lorry Vauxhall Astra Blue Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Education N/A      
15671 op-snap---monthly-publication-june-2025.pdf   1600 2025-06 Car Vauxhall Insignia Blue Driving without Due Care and Attention None Dyas Road Dyas Road Birmingham Birmingham Education N/A   52.5424796 -1.8885732
18749 op-snap---monthly-publication-may-2025.pdf   111 2025-05 Car Vauxhall Mokka Silver Driving without Due Care and Attention None Finch Road Finch Road Birmingham Birmingham Education N/A   52.506108 -1.9083155
18897 op-snap---monthly-publication-may-2025.pdf   259 2025-05 Car Vauxhall Meriva Silver Driving without Due Care and Attention none Harbourne Park Road Harbourne Park Road Birmingham Birmingham Education N/A      
19266 op-snap---monthly-publication-may-2025.pdf   628 2025-05 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Bond Street Bond Street Birmingham Birmingham Education N/A   52.4305652 -1.9245064
19318 op-snap---monthly-publication-may-2025.pdf   680 2025-05 Car Vauxhall Astra Silver Driving without Due Care and Attention None Gospel End Road Gospel End Road Dudley Dudley Education N/A   52.5392439 -2.1282642
19426 op-snap---monthly-publication-may-2025.pdf   788 2025-05 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Belgrave Interchange Belgrave Interchange Birmingham Birmingham Education N/A   52.466118 -1.8982999
19529 op-snap---monthly-publication-may-2025.pdf   891 2025-05 Car Vauxhall Crossland Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
19591 op-snap---monthly-publication-may-2025.pdf   953 2025-05 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham Education N/A   52.4580901 -1.894458
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
19598 op-snap---monthly-publication-may-2025.pdf   960 2025-05 Car Vauxhall Insignia White Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
19602 op-snap---monthly-publication-may-2025.pdf   964 2025-05 Pedal Bike Vauxhall Insignia Black Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
16460 op-snap---monthly-publication-march-2025.pdf   217 2025-03 Car Vauxhall Zafira Silver Driving without Due Care and Attention None A45, B4137 Roundabout A45, B4137 Roundabout Birmingham Birmingham Education N/A Yes - Via Email    
16669 op-snap---monthly-publication-march-2025.pdf   426 2025-03 Car Vauxhall Mokka White Driving without Due Care and Attention None Summerhill Street Summerhill Street Birmingham Birmingham Education N/A Yes - Via Email    
16864 op-snap---monthly-publication-march-2025.pdf   621 2025-03 Motorbike Vauxhall Insignia Silver Driving without Due Care and Attention None Brades Road Brades Road Sandwell Sandwell Education N/A Yes - Via Email 52.5087861 -2.0285026
17227 op-snap---monthly-publication-march-2025.pdf   984 2025-03 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Wednesbury Road Wednesbury Road Walsall Walsall Education N/A Yes - Via Email 52.5738499 -1.9961575
17299 op-snap---monthly-publication-march-2025.pdf   1056 2025-03 Car Vauxhall Meriva White Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
17712 op-snap---monthly-publication-march-2025.pdf   1469 2025-03 Car Vauxhall transit Black Driving without Due Care and Attention None BROMFORD LANE Bromford Lane Birmingham Birmingham Education N/A Yes - Via Email 52.5083238 -1.8332287
17972 op-snap---monthly-publication-march-2025.pdf   1729 2025-03 Pedal Bike Vauxhall Zafira Black Driving without Due Care and Attention None Sandwell Road Sandwell Road Birmingham Birmingham Education N/A Yes - Via Email 52.5082522 -1.9487918
18044 op-snap---monthly-publication-march-2025.pdf   1801 2025-03 Car Vauxhall Combo Red Driving without Due Care and Attention None The Radley's, The Radley's Birmingham Birmingham Education N/A Yes - Via Email    
18171 op-snap---monthly-publication-march-2025.pdf   1928 2025-03 Pedal Bike Vauxhall Zafira Grey Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Education N/A Yes - Via Email 52.4624743 -1.7763934
5562 op-snap---monthly-publication-february-2025.pdf   379 2025-02 Car Vauxhall ASTRA Silver Driving without Due Care and Attention None BELGRAVE INTERCHANGE Belgrave Interchange Birmingham Birmingham Education N/A Yes - Via Email 52.466118 -1.8982999

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