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

152 rows where disposal = "Education", offence = "Driving without Due Care and Attention" and vehicle_make = "Volkswagen" 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

month 14

  • 2025-06 21
  • 2025-10 16
  • 2025-09 15
  • 2025-11 15
  • 2025-08 13
  • 2026-02 13
  • 2025-03 11
  • 2026-01 11
  • 2025-07 10
  • 2025-12 10
  • 2025-01 6
  • 2025-02 6
  • 2025-05 4
  • 2025-04 1

council_area 10

  • Birmingham 92
  • Coventry 18
  • Dudley 12
  • Wolverhampton 9
  • Solihull 6
  • Sutton Coldfield 5
  • Sandwell 4
  • Walsall 4
  • Cst Arnadwell 1
  • Out of Force Area 1

reporter_transport_mode 4

  • Car 102
  • Pedal Bike 42
  • Other 6
  • Pedestrian 2

vehicle_make 1

  • Volkswagen · 152 ✖

offence 1

  • Driving without Due Care and Attention · 152 ✖

disposal 1

  • Education · 152 ✖
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
7390 op-snap---monthly-publication-february-2026.pdf   137 2026-02 Car Volkswagen Tiguan Grey Driving without Due Care and Attention None Church Street Church Street Birmingham Birmingham Education N/A   52.5020781 -1.9122368
7454 op-snap---monthly-publication-february-2026.pdf   201 2026-02 Pedal Bike Volkswagen Tayron Grey Driving without Due Care and Attention None Hallam Street Hallam Street Birmingham Birmingham Education N/A   52.4563937 -1.8933429
7514 op-snap---monthly-publication-february-2026.pdf   261 2026-02 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention None Ridgacre Road Ridgacre Road Birmingham Birmingham Education N/A   52.4593367 -2.0000298
7921 op-snap---monthly-publication-february-2026.pdf   668 2026-02 Car Volkswagen Caddy White Driving without Due Care and Attention None J10 slip M6 towards Bham J10 slip M6 towards Bham Birmingham Birmingham Education N/A      
8039 op-snap---monthly-publication-february-2026.pdf   786 2026-02 Car Volkswagen Polo Blue Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham Education N/A   52.4398245 -1.8469786
8051 op-snap---monthly-publication-february-2026.pdf   798 2026-02 Car Volkswagen Caddy Blue Driving without Due Care and Attention None Kings Road, Tyseley Kings Road, Tyseley Birmingham Birmingham Education N/A   52.4572996 -1.8391692
8072 op-snap---monthly-publication-february-2026.pdf   819 2026-02 Car Volkswagen Passat White Driving without Due Care and Attention None M6 J5 M6 J5 Birmingham Birmingham Education N/A   52.6760749 -2.0862582
8332 op-snap---monthly-publication-february-2026.pdf   1079 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None A41 Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
8336 op-snap---monthly-publication-february-2026.pdf   1083 2026-02 Car Volkswagen Caddy Silver Driving without Due Care and Attention None Sheldon Heath Road Sheldon Heath Road Birmingham Birmingham Education N/A   52.4744736 -1.7892633
8449 op-snap---monthly-publication-february-2026.pdf   1196 2026-02 Car Volkswagen Caddy White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
8464 op-snap---monthly-publication-february-2026.pdf   1211 2026-02 Car Volkswagen Golf Red Driving without Due Care and Attention None M5 SB 2-3 M5 Southbound 2-3 Birmingham Birmingham Education N/A      
8592 op-snap---monthly-publication-february-2026.pdf   1339 2026-02 Car Volkswagen Caddy White Driving without Due Care and Attention None M6 Jn7 M6 Jn7 Birmingham Birmingham Education N/A      
8596 op-snap---monthly-publication-february-2026.pdf   1343 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
10817 op-snap---monthly-publication-january-2026.pdf   278 2026-01 Other Volkswagen Amarok Black Driving without Due Care and Attention None Castlegate Way, Dudley Castlegate Way, Dudley Dudley Dudley Education N/A   52.5152644 -2.07245
10884 op-snap---monthly-publication-january-2026.pdf   345 2026-01 Pedal Bike Volkswagen Crafter White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
11043 op-snap---monthly-publication-january-2026.pdf   504 2026-01 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11229 op-snap---monthly-publication-january-2026.pdf   690 2026-01 Car Volkswagen Polo Black Driving without Due Care and Attention None Gerrards Street, Lozells Gerrards Street, Lozells Birmingham Birmingham Education N/A      
11283 op-snap---monthly-publication-january-2026.pdf   744 2026-01 Pedal Bike Volkswagen Passat Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
11385 op-snap---monthly-publication-january-2026.pdf   846 2026-01 Car Volkswagen Golf White Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
11521 op-snap---monthly-publication-january-2026.pdf   982 2026-01 Car Volkswagen ID Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
11685 op-snap---monthly-publication-january-2026.pdf   1146 2026-01 Car Volkswagen Golf Grey Driving without Due Care and Attention None Deepdale Lane Deepdale Lane Dudley Dudley Education N/A   52.5211263 -2.1174674
11690 op-snap---monthly-publication-january-2026.pdf   1151 2026-01 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
11745 op-snap---monthly-publication-january-2026.pdf   1206 2026-01 Car Volkswagen Minibus White Driving without Due Care and Attention None Beeches Road Beeches Road Birmingham Birmingham Education N/A   52.5394371 -1.9087331
11918 op-snap---monthly-publication-january-2026.pdf   1379 2026-01 Car Volkswagen Passat Blue Driving without Due Care and Attention None Melrose Avenue South Melrose Avenue South Sutton Coldfield Sutton Coldfield Education N/A      
3884 op-snap---monthly-publication-december-2025.pdf   12 2025-12 Pedal Bike Volkswagen Golf Red Driving without Due Care and Attention None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Education N/A   52.5690586 -1.8794686
4086 op-snap---monthly-publication-december-2025.pdf   214 2025-12 Pedal Bike Volkswagen UP Red Driving without Due Care and Attention None Swanswwell St Swanswwell Street Coventry Coventry Education N/A      
4161 op-snap---monthly-publication-december-2025.pdf   289 2025-12 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Sarehold Road Sarehold Road Birmingham Birmingham Education N/A      
4308 op-snap---monthly-publication-december-2025.pdf   436 2025-12 Car Volkswagen Polo Black Driving without Due Care and Attention None Barker Butt Lane Barker Butt Lane Coventry Coventry Education N/A      
4416 op-snap---monthly-publication-december-2025.pdf   544 2025-12 Car Volkswagen ID4 White Driving without Due Care and Attention None A4123 Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
4451 op-snap---monthly-publication-december-2025.pdf   579 2025-12 Pedal Bike Volkswagen Polo Silver Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A   52.4390303 -1.9512931
4789 op-snap---monthly-publication-december-2025.pdf   917 2025-12 Pedal Bike Volkswagen Tiguan Green Driving without Due Care and Attention None Walkmley Road Walkmley Road Sutton Coldfield Sutton Coldfield Education N/A      
4835 op-snap---monthly-publication-december-2025.pdf   963 2025-12 Other Volkswagen Crafter Silver Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4905 op-snap---monthly-publication-december-2025.pdf   1033 2025-12 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention None Kent Street Kent Street Birmingham Birmingham Education N/A   52.4717099 -1.897463
5062 op-snap---monthly-publication-december-2025.pdf   1190 2025-12 Car Volkswagen Polo Silver Driving without Due Care and Attention None Barrows Lane at Moat Lane Barrows Lane at Moat Lane Birmingham Birmingham Education N/A   52.4566463 -1.7912653
20511 op-snap---monthly-publication-november-2025.pdf   53 2025-11 Car Volkswagen Polo White Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Education N/A   52.4298554 -1.9086629
20564 op-snap---monthly-publication-november-2025.pdf   106 2025-11 Other Volkswagen Tiago Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20623 op-snap---monthly-publication-november-2025.pdf   165 2025-11 Car Volkswagen ID7 Blue Driving without Due Care and Attention None M6 North M6 North Wolverhampton Wolverhampton Education N/A   52.6049795 -2.085282
20644 op-snap---monthly-publication-november-2025.pdf   186 2025-11 Car Volkswagen Tayron Silver Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham Education N/A   52.4580901 -1.894458
20710 op-snap---monthly-publication-november-2025.pdf   252 2025-11 Car Volkswagen Golf Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Coventry Coventry Education N/A   52.4272882 -1.5753221
20751 op-snap---monthly-publication-november-2025.pdf   293 2025-11 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20814 op-snap---monthly-publication-november-2025.pdf   356 2025-11 Car Volkswagen Crafter White Driving without Due Care and Attention None St Mary's Road Street Mary's Road Birmingham Birmingham Education N/A      
21033 op-snap---monthly-publication-november-2025.pdf   575 2025-11 Car Volkswagen Polo White Driving without Due Care and Attention None Kingston Road Kingston Road Birmingham Birmingham Education N/A   52.4747333 -1.8728345
21066 op-snap---monthly-publication-november-2025.pdf   608 2025-11 Car Volkswagen polo Grey Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
21273 op-snap---monthly-publication-november-2025.pdf   815 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None High Street Great Bridge... not sure where that is yet High Street Great Bridge. not sure where that is yet Sandwell Sandwell Education N/A      
21295 op-snap---monthly-publication-november-2025.pdf   837 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
21389 op-snap---monthly-publication-november-2025.pdf   931 2025-11 Pedal Bike Volkswagen Scirocco Red Driving without Due Care and Attention None Linthouse Lane Linthouse Lane Wolverhampton Wolverhampton Education N/A   52.6118187 -2.0810618
21492 op-snap---monthly-publication-november-2025.pdf   1034 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
21585 op-snap---monthly-publication-november-2025.pdf   1127 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
21982 op-snap---monthly-publication-november-2025.pdf   1524 2025-11 Pedal Bike Volkswagen Caddy Red Driving without Due Care and Attention None Bridle Brook Lane Bridle Brook Lane Coventry Coventry Education N/A   52.4475078 -1.5736787
22110 op-snap---monthly-publication-october-2025.pdf   60 2025-10 Pedal Bike Volkswagen Transporter Grey Driving without Due Care and Attention None Earlsdon Av Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
22158 op-snap---monthly-publication-october-2025.pdf   108 2025-10 Car Volkswagen Golf Black Driving without Due Care and Attention None Connaught Road Connaught Road Wolverhampton Wolverhampton Education N/A   52.5876226 -2.1426533
22304 op-snap---monthly-publication-october-2025.pdf   254 2025-10 Car Volkswagen Transporter Grey Driving without Due Care and Attention None Warstones Road / Coalway Road, Penn Warstones Road / Coalway Road, Penn Wolverhampton Wolverhampton Education N/A   52.5687693 -2.1613924
22324 op-snap---monthly-publication-october-2025.pdf   274 2025-10 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham Education N/A   52.4580375 -1.9261777
22332 op-snap---monthly-publication-october-2025.pdf   282 2025-10 Car Volkswagen Passat White Driving without Due Care and Attention None Stoney Lane Stoney Lane Birmingham Birmingham Education N/A   52.4745488 -1.8065911
22395 op-snap---monthly-publication-october-2025.pdf   345 2025-10 Car Volkswagen Polo White Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
22447 op-snap---monthly-publication-october-2025.pdf   397 2025-10 Pedal Bike Volkswagen Polo Orange Driving without Due Care and Attention None Moseley Avenue Moseley Avenue Coventry Coventry Education N/A   52.417344 -1.5264979
22453 op-snap---monthly-publication-october-2025.pdf   403 2025-10 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Birmingham Birmingham Education N/A   52.4223176 -1.8253145
22598 op-snap---monthly-publication-october-2025.pdf   548 2025-10 Pedal Bike Volkswagen Fox Black Driving without Due Care and Attention None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
22713 op-snap---monthly-publication-october-2025.pdf   663 2025-10 Pedal Bike Volkswagen T-Roc Black Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
22787 op-snap---monthly-publication-october-2025.pdf   737 2025-10 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
22829 op-snap---monthly-publication-october-2025.pdf   779 2025-10 Car Volkswagen Golf Grey Driving without Due Care and Attention None Springfield Road Springfield Road Birmingham Birmingham Education N/A   52.4327486 -1.8844997
22971 op-snap---monthly-publication-october-2025.pdf   921 2025-10 Car Volkswagen   Grey Driving without Due Care and Attention None Kings HIgh Street Kings HIgh Street Birmingham Birmingham Education N/A   52.4377293 -1.893092
22983 op-snap---monthly-publication-october-2025.pdf   933 2025-10 Car Volkswagen Passat Black Driving without Due Care and Attention None Ettingshall Road Ettingshall Road Wolverhampton Wolverhampton Education N/A   52.5737672 -2.1037249
22993 op-snap---monthly-publication-october-2025.pdf   943 2025-10 Car Volkswagen Passat Black Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Education N/A   52.471632 -1.9456776
23014 op-snap---monthly-publication-october-2025.pdf   964 2025-10 Car Volkswagen Passatt Black Driving without Due Care and Attention None Vauxhall Road Vauxhall Road Birmingham Birmingham Education N/A   52.4834623 -1.8796522
23990 op-snap---monthly-publication-september-2025.pdf   209 2025-09 Other Volkswagen Golf Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
24012 op-snap---monthly-publication-september-2025.pdf   231 2025-09 Car Volkswagen Golf Grey Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Education N/A   52.3921304 -1.5156601
24165 op-snap---monthly-publication-september-2025.pdf   384 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Chester Road North, Streetly Chester Road North, Streetly Sutton Coldfield Sutton Coldfield Education N/A      
24246 op-snap---monthly-publication-september-2025.pdf   465 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
24303 op-snap---monthly-publication-september-2025.pdf   522 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
24341 op-snap---monthly-publication-september-2025.pdf   560 2025-09 Pedal Bike Volkswagen Tiguan Grey Driving without Due Care and Attention None Breedon Road Breedon Road Birmingham Birmingham Education N/A   52.4191978 -1.9251219
24531 op-snap---monthly-publication-september-2025.pdf   750 2025-09 Pedal Bike Volkswagen   Black Driving without Due Care and Attention None Warstock Lane Warstock Lane Birmingham Birmingham Education N/A   52.4175988 -1.8774655
24580 op-snap---monthly-publication-september-2025.pdf   799 2025-09 Car Volkswagen Transporter Blue Driving without Due Care and Attention None Allard Way Allard Way Birmingham Birmingham Education N/A      
24607 op-snap---monthly-publication-september-2025.pdf   826 2025-09 Car Volkswagen Tiguan Black Driving without Due Care and Attention None High Street, Stourbridge High Street, Stourbridge Dudley Dudley Education N/A   52.4570763 -2.1136199
24632 op-snap---monthly-publication-september-2025.pdf   851 2025-09 Other Volkswagen Polo Silver Driving without Due Care and Attention None Star City, Nechells Star City, Nechells Birmingham Birmingham Education N/A   52.5054363 -1.8556273
24643 op-snap---monthly-publication-september-2025.pdf   862 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Monyhull Hall Road Monyhull Hall Road Birmingham Birmingham Education N/A   52.4126079 -1.905127
24747 op-snap---monthly-publication-september-2025.pdf   966 2025-09 Car Volkswagen Passat Grey Driving without Due Care and Attention None Black Country Route Black Country Route Wolverhampton Wolverhampton Education N/A   52.5642677 -2.0755469
24752 op-snap---monthly-publication-september-2025.pdf   971 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
24763 op-snap---monthly-publication-september-2025.pdf   982 2025-09 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Midelsohn Way, Selly Oak Midelsohn Way, Selly Oak Birmingham Birmingham Education N/A      
24768 op-snap---monthly-publication-september-2025.pdf   987 2025-09 Pedal Bike Volkswagen Tiguan Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Birmingham Birmingham Education N/A   52.4223176 -1.8253145
2200 op-snap---monthly-publication-august-2025.pdf   175 2025-08 Pedal Bike Volkswagen Golf Beige Driving without Due Care and Attention None Moorgreen Lane Moorgreen Lane Birmingham Birmingham Education N/A      
2212 op-snap---monthly-publication-august-2025.pdf   187 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Barrs Road Cradley Heath Barrs Road Cradley Heath Sandwell Sandwell Education N/A   52.4682935 -2.0660364
2215 op-snap---monthly-publication-august-2025.pdf   190 2025-08 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Hatherton Street Hatherton Street Walsall Walsall Education N/A   52.5880551 -1.9796606
2242 op-snap---monthly-publication-august-2025.pdf   217 2025-08 Car Volkswagen Golf Red Driving without Due Care and Attention None Puma Way Puma Way Coventry Coventry Education N/A   52.401984 -1.5046079
2321 op-snap---monthly-publication-august-2025.pdf   296 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Longford Road Longford Road Coventry Coventry Education N/A   52.445164 -1.4879298
2340 op-snap---monthly-publication-august-2025.pdf   315 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Longford Longford Coventry Coventry Education N/A   52.4516182 -1.4885443
2506 op-snap---monthly-publication-august-2025.pdf   481 2025-08 Car Volkswagen Toureg Grey Driving without Due Care and Attention None Norton Road Norton Road Dudley Dudley Education N/A   52.4483733 -2.1546673
2590 op-snap---monthly-publication-august-2025.pdf   565 2025-08 Pedal Bike Volkswagen Polo Blue Driving without Due Care and Attention None Green Lane Green Lane Solihull Solihull Education N/A   52.5069826 -1.7643766
2723 op-snap---monthly-publication-august-2025.pdf   698 2025-08 Car Volkswagen Golf Red Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Education N/A   52.4708802 -1.8792135
2783 op-snap---monthly-publication-august-2025.pdf   758 2025-08 Car Volkswagen golf Blue Driving without Due Care and Attention None Halesowen Road Halesowen Road Birmingham Birmingham Education N/A      
2785 op-snap---monthly-publication-august-2025.pdf   760 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Belgrave Interchange Belgrave Interchange Birmingham Birmingham Education N/A   52.466118 -1.8982999
2876 op-snap---monthly-publication-august-2025.pdf   851 2025-08 Car Volkswagen Golf White Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
3069 op-snap---monthly-publication-august-2025.pdf   1044 2025-08 Car Volkswagen Troc Silver Driving without Due Care and Attention None Holbrook WAY Holbrook WAY Coventry Coventry Education N/A   52.438551 -1.502488
12009 op-snap---monthly-publication-july-2025.pdf   61 2025-07 Car Volkswagen Passatt Grey Driving without Due Care and Attention None Richmond Road Richmond Road Solihull Solihull Education N/A   52.4430188 -1.8022218
12261 op-snap---monthly-publication-july-2025.pdf   313 2025-07 Car Volkswagen Transporter Blue Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Education N/A   52.471632 -1.9456776
12398 op-snap---monthly-publication-july-2025.pdf   450 2025-07 Car Volkswagen Transporter Blue Driving without Due Care and Attention None Tyburn Roundabout Tyburn Roundabout Birmingham Birmingham Education N/A      
12412 op-snap---monthly-publication-july-2025.pdf   464 2025-07 Car Volkswagen Up Gold Driving without Due Care and Attention None Sir William Lyons Road Sir William Lyons Road Coventry Coventry Education N/A   52.3877545 -1.5585877
12521 op-snap---monthly-publication-july-2025.pdf   573 2025-07 Other Volkswagen Caddy Silver Driving without Due Care and Attention None Norwood Road Norwood Road Sandwell Sandwell Education N/A   52.4655265 -2.0494856
12570 op-snap---monthly-publication-july-2025.pdf   622 2025-07 Car Volkswagen Golf Grey Driving without Due Care and Attention None Rabone Lane Rabone Lane Sandwell Sandwell Education N/A   52.496577 -1.9614637
12753 op-snap---monthly-publication-july-2025.pdf   805 2025-07 Car Volkswagen Touran Blue Driving without Due Care and Attention None Rotton Park Road Rotton Park Road Birmingham Birmingham Education N/A   52.4851072 -1.9468115

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