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

133 rows where disposal = "Education", offence = "Driving without Due Care and Attention" and vehicle_make = "Mercedes-Benz" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, council_area_raw

month 14

  • 2026-02 20
  • 2025-08 17
  • 2025-06 16
  • 2025-10 12
  • 2026-01 12
  • 2025-09 10
  • 2025-11 10
  • 2025-03 8
  • 2025-05 7
  • 2025-12 7
  • 2025-01 6
  • 2025-07 5
  • 2025-02 2
  • 2025-04 1

reporter_transport_mode 8

  • Car 78
  • Pedal Bike 42
  • Pedestrian 5
  • Other 4
  • Bus 1
  • Lorry 1
  • Motorbike 1
  • car 1

council_area 8

  • Birmingham 77
  • Coventry 15
  • Sandwell 12
  • Dudley 9
  • Solihull 9
  • Walsall 5
  • Wolverhampton 4
  • Sutton Coldfield 2

vehicle_make 1

  • Mercedes-Benz · 133 ✖

offence 1

  • Driving without Due Care and Attention · 133 ✖

disposal 1

  • Education · 133 ✖
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
7383 op-snap---monthly-publication-february-2026.pdf   130 2026-02 Pedal Bike Mercedes-Benz 180 Grey Driving without Due Care and Attention None Weoley Castle Weoley Castle Birmingham Birmingham Education N/A   52.4428373 -1.9698276
7536 op-snap---monthly-publication-february-2026.pdf   283 2026-02 Pedal Bike Mercedes-Benz ML320 Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
7625 op-snap---monthly-publication-february-2026.pdf   372 2026-02 Car Mercedes-Benz CLA 220 Red Driving without Due Care and Attention None Coventry A45 W Coventry A45 W Coventry Coventry Education N/A   52.4314215 -1.5948907
7699 op-snap---monthly-publication-february-2026.pdf   446 2026-02 Pedal Bike Mercedes-Benz Sprinter white Driving without Due Care and Attention None Broad Lane, Tile Hill Broad Lane, Tile Hill Coventry Coventry Education N/A   52.4112706 -1.5792697
7783 op-snap---monthly-publication-february-2026.pdf   530 2026-02 Pedal Bike Mercedes-Benz 180 White Driving without Due Care and Attention None Cornetts End Lane Cornetts End Lane Solihull Solihull Education N/A      
7809 op-snap---monthly-publication-february-2026.pdf   556 2026-02 Car Mercedes-Benz A180 Red Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Education N/A      
7835 op-snap---monthly-publication-february-2026.pdf   582 2026-02 Car Mercedes-Benz EQB Black Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Education N/A   52.4318623 -1.4804069
7971 op-snap---monthly-publication-february-2026.pdf   718 2026-02 Lorry Mercedes-Benz C300 Blue Driving without Due Care and Attention None All saints Way All saints Way Sandwell Sandwell Education N/A   52.5344405 -1.985568
8017 op-snap---monthly-publication-february-2026.pdf   764 2026-02 Pedal Bike Mercedes-Benz CLA220 Red Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
8122 op-snap---monthly-publication-february-2026.pdf   869 2026-02 Car Mercedes-Benz B180 Silver Driving without Due Care and Attention None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A   52.4728608 -1.8754722
8158 op-snap---monthly-publication-february-2026.pdf   905 2026-02 Car Mercedes-Benz Tipper White Driving without Due Care and Attention None M6 Motorway M6 Motorway Walsall Walsall Education N/A   52.6151447 -2.0290522
8184 op-snap---monthly-publication-february-2026.pdf   931 2026-02 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bills Lane Bills Lane Solihull Solihull Education N/A   52.3998632 -1.8392819
8203 op-snap---monthly-publication-february-2026.pdf   950 2026-02 Pedal Bike Mercedes-Benz C180 Silver Driving without Due Care and Attention None Hobls Hole Lane Hobls Hole Lane Walsall Walsall Education N/A      
8257 op-snap---monthly-publication-february-2026.pdf   1004 2026-02 car Mercedes-Benz C200 White Driving without Due Care and Attention None Holloway Circus Holloway Circus Birmingham Birmingham Education N/A   52.474604 -1.89977
8261 op-snap---monthly-publication-february-2026.pdf   1008 2026-02 Pedal Bike Mercedes-Benz Benz White Driving without Due Care and Attention None Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
8306 op-snap---monthly-publication-february-2026.pdf   1053 2026-02 Car Mercedes-Benz A200 Black Driving without Due Care and Attention   M5 Motorway Jn1 M5 Motorway Jn1 Sandwell Sandwell Education N/A      
8514 op-snap---monthly-publication-february-2026.pdf   1261 2026-02 Pedal Bike Mercedes-Benz C220 Silver Driving without Due Care and Attention None White Street White Street Coventry Coventry Education N/A   52.4122951 -1.5045181
8566 op-snap---monthly-publication-february-2026.pdf   1313 2026-02 Pedestrian Mercedes-Benz A200 Grey Driving without Due Care and Attention None Sherlock Street Sherlock Street Birmingham Birmingham Education N/A   52.4702385 -1.895011
8577 op-snap---monthly-publication-february-2026.pdf   1324 2026-02 Pedal Bike Mercedes-Benz GLA 200 Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
8663 op-snap---monthly-publication-february-2026.pdf   1410 2026-02 Pedal Bike Mercedes-Benz A180 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
10539 op-snap---monthly-publication-january-2026.pdf   0 2026-01 Car Mercedes-Benz GLC 300 Silver Driving without Due Care and Attention None High Street, Bloxwich High Street, Bloxwich Walsall Walsall Education N/A   52.6142343 -2.0043397
10791 op-snap---monthly-publication-january-2026.pdf   252 2026-01 Car Mercedes-Benz C350 Black Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
10810 op-snap---monthly-publication-january-2026.pdf   271 2026-01 Car Mercedes-Benz G 63 Black Driving without Due Care and Attention None Church Lane Church Lane Sandwell Sandwell Education N/A   52.5311655 -2.0008707
10828 op-snap---monthly-publication-january-2026.pdf   289 2026-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Tyburn Road, Gravely Hill Tyburn Road, Gravely Hill Birmingham Birmingham Education N/A      
11087 op-snap---monthly-publication-january-2026.pdf   548 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Education N/A   52.4198291 -1.9241732
11302 op-snap---monthly-publication-january-2026.pdf   763 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Education N/A   52.4428606 -1.812114
11368 op-snap---monthly-publication-january-2026.pdf   829 2026-01 Pedal Bike Mercedes-Benz C300 Black Driving without Due Care and Attention None Quinton Interchange Quinton Interchange Dudley Dudley Education N/A   52.4539668 -2.0119854
11381 op-snap---monthly-publication-january-2026.pdf   842 2026-01 Car Mercedes-Benz A180.. Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
11388 op-snap---monthly-publication-january-2026.pdf   849 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Education N/A   52.4762784 -1.9678366
11410 op-snap---monthly-publication-january-2026.pdf   871 2026-01 Car Mercedes-Benz Tipper White Driving without Due Care and Attention None Lawley MIddleway Lawley MIddleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
11542 op-snap---monthly-publication-january-2026.pdf   1003 2026-01 Car Mercedes-Benz A250 Grey Driving without Due Care and Attention None Blackberry Lane Blackberry Lane Sutton Coldfield Sutton Coldfield Education N/A   52.5962461 -1.8492935
11625 op-snap---monthly-publication-january-2026.pdf   1086 2026-01 Car Mercedes-Benz EQC Blue Driving without Due Care and Attention None Bosworth Drive Bosworth Drive Solihull Solihull Education N/A   52.4780944 -1.7586668
4096 op-snap---monthly-publication-december-2025.pdf   224 2025-12 Car Mercedes-Benz GLE Blue Driving without Due Care and Attention None Marsh Hill Marsh Hill Birmingham Birmingham Education N/A   52.5246617 -1.8687505
4097 op-snap---monthly-publication-december-2025.pdf   225 2025-12 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Station Road, Stechford Station Road, Stechford Birmingham Birmingham Education N/A   52.480771 -1.8086714
4400 op-snap---monthly-publication-december-2025.pdf   528 2025-12 Car Mercedes-Benz a-class White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
4401 op-snap---monthly-publication-december-2025.pdf   529 2025-12 Car Mercedes-Benz C Class Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
4477 op-snap---monthly-publication-december-2025.pdf   605 2025-12 Pedal Bike Mercedes-Benz Camper White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
4871 op-snap---monthly-publication-december-2025.pdf   999 2025-12 Car Mercedes-Benz A180 White Driving without Due Care and Attention None Lucas Circus Hockley Lucas Circus Hockley Birmingham Birmingham Education N/A      
4910 op-snap---monthly-publication-december-2025.pdf   1038 2025-12 Car Mercedes-Benz C class Grey Driving without Due Care and Attention None Bordesley Green East Bordesley Green East Birmingham Birmingham Education N/A   52.4802441 -1.8327073
20652 op-snap---monthly-publication-november-2025.pdf   194 2025-11 Car Mercedes-Benz AMG Blue Driving without Due Care and Attention None Richmond Road Olton Richmond Road Olton Solihull Solihull Education N/A   52.4430827 -1.8006217
20671 op-snap---monthly-publication-november-2025.pdf   213 2025-11 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Rolfe Street Rolfe Street Sandwell Sandwell Education N/A   52.4972172 -1.9607539
20700 op-snap---monthly-publication-november-2025.pdf   242 2025-11 Pedal Bike Mercedes-Benz C180 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20750 op-snap---monthly-publication-november-2025.pdf   292 2025-11 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20754 op-snap---monthly-publication-november-2025.pdf   296 2025-11 Car Mercedes-Benz A200 Silver Driving without Due Care and Attention None Selly Oak Road Selly Oak Road Birmingham Birmingham Education N/A   52.4263875 -1.9397954
20839 op-snap---monthly-publication-november-2025.pdf   381 2025-11 Pedal Bike Mercedes-Benz S350 Black Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Education N/A   52.4216321 -1.855984
21467 op-snap---monthly-publication-november-2025.pdf   1009 2025-11 Pedal Bike Mercedes-Benz Citan grey Driving without Due Care and Attention None South Road, B4186, Stourbridge South Road, B4186, Stourbridge Dudley Dudley Education N/A   52.45108 -2.1531606
21613 op-snap---monthly-publication-november-2025.pdf   1155 2025-11 Car Mercedes-Benz C220 Black Driving without Due Care and Attention None Nunts Lane Nunts Lane Coventry Coventry Education N/A   52.4483335 -1.5168597
21723 op-snap---monthly-publication-november-2025.pdf   1265 2025-11 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None High Street Jct Windmill Road High Street Junction Windmill Road Solihull Solihull Education N/A      
21777 op-snap---monthly-publication-november-2025.pdf   1319 2025-11 Car Mercedes-Benz E220 Grey Driving without Due Care and Attention None Chester Road at Orphanage Road Chester Road at Orphanage Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
22079 op-snap---monthly-publication-october-2025.pdf   29 2025-10 Pedal Bike Mercedes-Benz E320 Silver Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham Education N/A   52.4381959 -1.8907391
22317 op-snap---monthly-publication-october-2025.pdf   267 2025-10 Car Mercedes-Benz A Class Black Driving without Due Care and Attention None Camp Hill Island Camp Hill Island Birmingham Birmingham Education N/A      
22377 op-snap---monthly-publication-october-2025.pdf   327 2025-10 Pedal Bike Mercedes-Benz GLB Black Driving without Due Care and Attention None Constance Road, Edgbaston Constance Road, Edgbaston Birmingham Birmingham Education N/A   52.45815 -1.9008028
22378 op-snap---monthly-publication-october-2025.pdf   328 2025-10 Car Mercedes-Benz van White Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
22439 op-snap---monthly-publication-october-2025.pdf   389 2025-10 Car Mercedes-Benz GLC 300 Black Driving without Due Care and Attention None Hainge Road Hainge Road Sandwell Sandwell Education N/A   52.511993 -2.0394885
22467 op-snap---monthly-publication-october-2025.pdf   417 2025-10 Car Mercedes-Benz A200 Red Driving without Due Care and Attention None Barnsley Road Barnsley Road Sandwell Sandwell Education N/A   52.4743497 -1.965737
22550 op-snap---monthly-publication-october-2025.pdf   500 2025-10 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Stoneleigh Road Stoneleigh Road Coventry Coventry Education N/A   52.3698519 -1.5482742
22806 op-snap---monthly-publication-october-2025.pdf   756 2025-10 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Sheepcote Street Sheepcote Street Birmingham Birmingham Education N/A   52.4770877 -1.9154767
22810 op-snap---monthly-publication-october-2025.pdf   760 2025-10 Pedal Bike Mercedes-Benz Sprinter Black Driving without Due Care and Attention None Moor Green Lane Moor Green Lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
22811 op-snap---monthly-publication-october-2025.pdf   761 2025-10 Car Mercedes-Benz Sprinter Blue Driving without Due Care and Attention None M6 somewhere M6 somewhere Birmingham Birmingham Education N/A      
22868 op-snap---monthly-publication-october-2025.pdf   818 2025-10 Pedal Bike Mercedes-Benz C220d Silver Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
23005 op-snap---monthly-publication-october-2025.pdf   955 2025-10 Pedal Bike Mercedes-Benz E200 Black Driving without Due Care and Attention None Butts Road near Albany Road Butts Road near Albany Road Coventry Coventry Education N/A   52.4078926 -1.5256816
23788 op-snap---monthly-publication-september-2025.pdf   7 2025-09 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Moor Green lane Moor Green lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
23889 op-snap---monthly-publication-september-2025.pdf   108 2025-09 Car Mercedes-Benz A35 AMG Yellow Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
23984 op-snap---monthly-publication-september-2025.pdf   203 2025-09 Car Mercedes-Benz AMG C White Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
24019 op-snap---monthly-publication-september-2025.pdf   238 2025-09 Car Mercedes-Benz E200 Blue Driving without Due Care and Attention None M6 Motorway M6 Motorway Coventry Coventry Education N/A      
24119 op-snap---monthly-publication-september-2025.pdf   338 2025-09 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Tat Bank Road Tat Bank Road Sandwell Sandwell Education N/A   52.4979925 -2.0082232
24343 op-snap---monthly-publication-september-2025.pdf   562 2025-09 Car Mercedes-Benz A Class Red Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
24387 op-snap---monthly-publication-september-2025.pdf   606 2025-09 Pedal Bike Mercedes-Benz EQA Blue Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Education N/A   52.4718503 -1.9195423
24534 op-snap---monthly-publication-september-2025.pdf   753 2025-09 Car Mercedes-Benz GLC white Driving without Due Care and Attention None High Street, Wall Heath, Dudley High Street, Wall Heath, Dudley Dudley Dudley Education N/A   52.5046529 -2.1784687
24548 op-snap---monthly-publication-september-2025.pdf   767 2025-09 Car Mercedes-Benz   White Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham Education N/A   52.5327447 -1.899844
24614 op-snap---monthly-publication-september-2025.pdf   833 2025-09 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
2130 op-snap---monthly-publication-august-2025.pdf   105 2025-08 Car Mercedes-Benz AMG White Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2147 op-snap---monthly-publication-august-2025.pdf   122 2025-08 Car Mercedes-Benz GLA Black Driving without Due Care and Attention None Battery Way Battery Way Birmingham Birmingham Education N/A   52.4493988 -1.8476406
2345 op-snap---monthly-publication-august-2025.pdf   320 2025-08 Other Mercedes-Benz C-class Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
2369 op-snap---monthly-publication-august-2025.pdf   344 2025-08 Pedal Bike Mercedes-Benz EClass White Driving without Due Care and Attention None Underhill Road Underhill Road Wolverhampton Wolverhampton Education N/A      
2552 op-snap---monthly-publication-august-2025.pdf   527 2025-08 Pedal Bike Mercedes-Benz AMG Blue Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A      
2572 op-snap---monthly-publication-august-2025.pdf   547 2025-08 Pedal Bike Mercedes-Benz sprinter White Driving without Due Care and Attention None Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
2606 op-snap---monthly-publication-august-2025.pdf   581 2025-08 Pedal Bike Mercedes-Benz GLC 220 Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
2715 op-snap---monthly-publication-august-2025.pdf   690 2025-08 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Education N/A      
2780 op-snap---monthly-publication-august-2025.pdf   755 2025-08 Car Mercedes-Benz Vito White Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Wolverhampton Wolverhampton Education N/A   52.5560698 -2.1044322
2786 op-snap---monthly-publication-august-2025.pdf   761 2025-08 Pedal Bike Mercedes-Benz GLA Black Driving without Due Care and Attention None Pritchatts Road Pritchatts Road Birmingham Birmingham Education N/A   52.4522304 -1.9267446
2891 op-snap---monthly-publication-august-2025.pdf   866 2025-08 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Coleshill Road at Newport Island Coleshill Road at Newport Island Birmingham Birmingham Education N/A   52.5008899 -1.7993095
2930 op-snap---monthly-publication-august-2025.pdf   905 2025-08 Car Mercedes-Benz Vito White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
3029 op-snap---monthly-publication-august-2025.pdf   1004 2025-08 Car Mercedes-Benz GLC Blue Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Education N/A   52.4161736 -1.8619692
3055 op-snap---monthly-publication-august-2025.pdf   1030 2025-08 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Education N/A   52.4041117 -1.5595662
3086 op-snap---monthly-publication-august-2025.pdf   1061 2025-08 Pedal Bike Mercedes-Benz GLS Black Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
3116 op-snap---monthly-publication-august-2025.pdf   1091 2025-08 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None High Street High Street Birmingham Birmingham Education N/A   52.5254588 -1.8373064
3140 op-snap---monthly-publication-august-2025.pdf   1115 2025-08 Car Mercedes-Benz AMG Black Driving without Due Care and Attention None Cateswell Road Cateswell Road Birmingham Birmingham Education N/A   52.4387009 -1.8454267
12115 op-snap---monthly-publication-july-2025.pdf   167 2025-07 Car Mercedes-Benz C220 Red Driving without Due Care and Attention None Wood End Road Wood End Road Wolverhampton Wolverhampton Education N/A   52.605993 -2.0805938
12335 op-snap---monthly-publication-july-2025.pdf   387 2025-07 Car Mercedes-Benz A180 Black Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall Education N/A   52.5867763 -2.0104342
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
12357 op-snap---monthly-publication-july-2025.pdf   409 2025-07 Bus Mercedes-Benz C220.. Silver Driving without Due Care and Attention None Newton Road Newton Road Sandwell Sandwell Education N/A   52.5428224 -1.9569444
12850 op-snap---monthly-publication-july-2025.pdf   902 2025-07 Car Mercedes-Benz Benz Black Driving without Due Care and Attention None A38 Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
14095 op-snap---monthly-publication-june-2025.pdf   24 2025-06 Pedal Bike Mercedes-Benz E300 White Driving without Due Care and Attention None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
14245 op-snap---monthly-publication-june-2025.pdf   174 2025-06 Car Mercedes-Benz E320 Black Driving without Due Care and Attention None M6 SB J10 M6 Southbound J10 Wolverhampton Wolverhampton Education N/A   52.676119 -2.0858425
14302 op-snap---monthly-publication-june-2025.pdf   231 2025-06 Other Mercedes-Benz C class Silver Driving without Due Care and Attention None Castlegate Way car park Castlegate Way car park Sandwell Sandwell Education N/A      
14336 op-snap---monthly-publication-june-2025.pdf   265 2025-06 Car Mercedes-Benz C300.. Black Driving without Due Care and Attention None Shutlock Lane Shutlock Lane Birmingham Birmingham Education N/A   52.4381927 -1.9042054
14432 op-snap---monthly-publication-june-2025.pdf   361 2025-06 Car Mercedes-Benz C250 Blue Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
14526 op-snap---monthly-publication-june-2025.pdf   455 2025-06 Car Mercedes-Benz 220 Silver Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
14539 op-snap---monthly-publication-june-2025.pdf   468 2025-06 Pedal Bike Mercedes-Benz C220 Grey Driving without Due Care and Attention None Rowheath Road, Cotteridge Rowheath Road, Cotteridge Birmingham Birmingham Education N/A   52.4179718 -1.9289891

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