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

100 rows where reporter_transport_mode = "Motorbike" 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

reporter_transport_mode 1

  • Motorbike · 100 ✖
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
8751 op-snap---monthly-publication-february-2026.pdf   1498 2026-02 Motorbike Mercedes-Benz   Black Driving without Due Care and Attention None J15 M40 J15 M40 Out of Force Area Out of Force Area NFA Out of Force      
8268 op-snap---monthly-publication-february-2026.pdf   1015 2026-02 Motorbike BMW 320d Black Driving without Due Care and Attention None M3/M25 M3/M25 Out of Force Area Out of Force Area NFA Out of Force      
7918 op-snap---monthly-publication-february-2026.pdf   665 2026-02 Motorbike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving None Belgrave Middleway towards Five Ways Belgrave Middleway towards Five Ways Birmingham Birmingham Fixed Penalty N/A      
7716 op-snap---monthly-publication-february-2026.pdf   463 2026-02 Motorbike Kia Ceed Red Driving without Due Care and Attention None Quarry Bank HS Quarry Bank HS Dudley Dudley Court N/A   52.4733135 -2.1014635
11879 op-snap---monthly-publication-january-2026.pdf   1340 2026-01 Motorbike Renault Zoe White Using a Mobile Phone Whilst Driving None Frank Street Frank Street Birmingham Birmingham Fixed Penalty N/A   52.4643146 -1.8879566
11774 op-snap---monthly-publication-january-2026.pdf   1235 2026-01 Motorbike Ford Transit White Driving without Due Care and Attention None Roundabout at A4545 towards A45 Roundabout at A4545 towards A45 Birmingham Birmingham Education N/A   52.4629863 -1.9976032
11531 op-snap---monthly-publication-january-2026.pdf   992 2026-01 Motorbike Toyota Hilux Grey Driving without Due Care and Attention None Solihull Road Solihull Road Birmingham Birmingham Education N/A   52.4458555 -1.8584046
11409 op-snap---monthly-publication-january-2026.pdf   870 2026-01 Motorbike Audi Q7 White Contravening a Red Traffic Light None Alcester Road South Alcester Road South Birmingham Birmingham Education N/A   52.4170522 -1.8906187
4285 op-snap---monthly-publication-december-2025.pdf   413 2025-12 Motorbike Vauxhall Corsa Red Misc - Non Traffic Offences None Mount Pleasant Mount Pleasant Dudley Dudley RTC - Actioned N/A   52.4734063 -2.1135639
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
21577 op-snap---monthly-publication-november-2025.pdf   1119 2025-11 Motorbike Volkswagen Passatt Silver Driving without Due Care and Attention None Mucklow Hill Mucklow Hill Dudley Dudley Fixed Penalty N/A   52.461008 -2.0345574
21410 op-snap---monthly-publication-november-2025.pdf   952 2025-11 Motorbike Vauxhall Corsa Grey Using a Mobile Phone Whilst Driving None Court Oak Road Court Oak Road Birmingham Birmingham NFA No Independent Evidence Available   52.4604383 -1.9760104
21354 op-snap---monthly-publication-november-2025.pdf   896 2025-11 Motorbike Volvo   Black Drive a vehicle other than on the carriageway of a motorway None M6 Motorway J4a M6 Motorway J4a Birmingham Birmingham Education N/A      
21318 op-snap---monthly-publication-november-2025.pdf   860 2025-11 Motorbike Audi A3 Grey Driving without Due Care and Attention None M42 J7 M42 J7 Birmingham Birmingham Education N/A      
21316 op-snap---monthly-publication-november-2025.pdf   858 2025-11 Motorbike Hyundai   Black Using a Mobile Phone Whilst Driving None Queensway Island Queensway Island Out of Force Area Out of Force Area NFA Out of Force      
20793 op-snap---monthly-publication-november-2025.pdf   335 2025-11 Motorbike     Red Contravening a Red Traffic Light None Weedon Road, Northampton Weedon Road, Northampton Out of Force Area Out of Force Area NFA Out of Force      
20760 op-snap---monthly-publication-november-2025.pdf   302 2025-11 Motorbike BMW 320D Grey Using a Mobile Phone Whilst Driving None Lordswood Road Lordswood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4591339 -1.9601054
20682 op-snap---monthly-publication-november-2025.pdf   224 2025-11 Motorbike Fiat 500l White Using a Mobile Phone Whilst Driving None Mount Pleasant Mount Pleasant Dudley Dudley Fixed Penalty N/A   52.4734063 -2.1135639
20617 op-snap---monthly-publication-november-2025.pdf   159 2025-11 Motorbike Seat Ibiza Grey Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
20551 op-snap---monthly-publication-november-2025.pdf   93 2025-11 Motorbike Mercedes-Benz C220 Black Contravening a Red Traffic Light None Pedmore Road Pedmore Road Dudley Dudley Warning Letter N/A   52.4897451 -2.1069141
23264 op-snap---monthly-publication-october-2025.pdf   1214 2025-10 Motorbike Mercedes-Benz E220D White Driving without Due Care and Attention None M6 Northbound M6 Northbound Birmingham Birmingham Warning Letter N/A      
22836 op-snap---monthly-publication-october-2025.pdf   786 2025-10 Motorbike Man HGV White Contravening a Red Traffic Light None A426 Lutterworth Lutterworth Out of Force Area Out of Force Area NFA Out of Force      
22795 op-snap---monthly-publication-october-2025.pdf   745 2025-10 Motorbike Audi S4 Blue Driving without Reasonable Consideration None Astwood Bank Astwood Bank Out of Force Area Out of Force Area NFA Out of Force      
22739 op-snap---monthly-publication-october-2025.pdf   689 2025-10 Motorbike Seat Ibiza White Contravening a Red Traffic Light None Bosworth Drive Bosworth Drive Birmingham Birmingham NFA No Independent Evidence Available   52.4779726 -1.7596871
22730 op-snap---monthly-publication-october-2025.pdf   680 2025-10 Motorbike Toyota Yaris Silver Driving without Due Care and Attention None Romeo Arbour Romeo Arbour Out of Force Area Out of Force Area NFA Out of Force      
22456 op-snap---monthly-publication-october-2025.pdf   406 2025-10 Motorbike Tesla Model 3 Blue Contravening a Red Traffic Light None Not provided Not provided Birmingham Birmingham NFA No Independent Evidence Available      
22446 op-snap---monthly-publication-october-2025.pdf   396 2025-10 Motorbike Ford Transit Grey Using a Mobile Phone Whilst Driving None Black Country Route Black Country Route Wolverhampton Wolverhampton Fixed Penalty N/A   52.5642677 -2.0755469
22379 op-snap---monthly-publication-october-2025.pdf   329 2025-10 Motorbike Volkswagen Golf White Misc - Non Traffic Offences None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence   52.5113867 -1.8337258
22175 op-snap---monthly-publication-october-2025.pdf   125 2025-10 Motorbike BMW 330d White Driving without Due Care and Attention None A46 Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
25510 op-snap---monthly-publication-september-2025.pdf   1729 2025-09 Motorbike Yamaha   Grey Driving without Reasonable Consideration None Queensway Tunnel Queensway Tunnel Birmingham Birmingham Warning Letter N/A      
24943 op-snap---monthly-publication-september-2025.pdf   1162 2025-09 Motorbike Citroen DS3 Red Contravening a Red Traffic Light None Allard Way Allard Way Coventry Coventry NFA No Independent Evidence Available   52.3955174 -1.4685442
24474 op-snap---monthly-publication-september-2025.pdf   693 2025-09 Motorbike BMW X3 Black Driving without Due Care and Attention None Sharespeare Drive Sharespeare Drive Solihull Solihull Warning Letter N/A      
24360 op-snap---monthly-publication-september-2025.pdf   579 2025-09 Motorbike Ford Puma Blue Contravening a Red Traffic Light None Hinckley, Warwickshire Hinckley, Warwickshire Out of Force Area Out of Force Area NFA Out of Force   52.435502 -1.4327166
24358 op-snap---monthly-publication-september-2025.pdf   577 2025-09 Motorbike Mercedes-Benz   Black Contravening a Red Traffic Light None Park Lane Park Lane Walsall Walsall Education N/A   52.5703934 -2.0184
24352 op-snap---monthly-publication-september-2025.pdf   571 2025-09 Motorbike   Husqvarna White Driving without Due Care and Attention None Clap Gate Lane Clap Gate Lane Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
24222 op-snap---monthly-publication-september-2025.pdf   441 2025-09 Motorbike Chevrolet Jeep Compass Grey Driving without Due Care and Attention None Roundabout, Allard Way / London Road / Humber Rd Roundabout, Allard Way / London Road / Humber Road Coventry Coventry Education N/A      
24099 op-snap---monthly-publication-september-2025.pdf   318 2025-09 Motorbike Mercedes-Benz EQA250 Grey Using a Mobile Phone Whilst Driving None Chawn Park Drive Chawn Park Drive Dudley Dudley Warning Letter N/A   52.4453636 -2.1319058
24051 op-snap---monthly-publication-september-2025.pdf   270 2025-09 Motorbike Ford Transit White Using a Mobile Phone Whilst Driving None Mucklow Hill Mucklow Hill Birmingham Birmingham Fixed Penalty N/A      
24031 op-snap---monthly-publication-september-2025.pdf   250 2025-09 Motorbike Ford Fiesta Silver Driving without Due Care and Attention None Old Snow Hill Old Snow Hill Birmingham Birmingham RTC - Actioned N/A   52.4858844 -1.9003652
3598 op-snap---monthly-publication-august-2025.pdf   1573 2025-08 Motorbike Fiat 500s Black Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham Warning Letter N/A   52.5327447 -1.899844
3167 op-snap---monthly-publication-august-2025.pdf   1142 2025-08 Motorbike Ford Kuga Blue Using a Mobile Phone Whilst Driving None A47 to Spitfire Island A47 to Spitfire Island Birmingham Birmingham Fixed Penalty N/A      
2894 op-snap---monthly-publication-august-2025.pdf   869 2025-08 Motorbike Ford Focus Blue Driving without Reasonable Consideration None Sir Robert Peel Junction, Bloxwich Sir Robert Peel Junction, Bloxwich Wolverhampton Wolverhampton Warning Letter N/A      
2640 op-snap---monthly-publication-august-2025.pdf   615 2025-08 Motorbike Mercedes-Benz A180 White Driving without Due Care and Attention None Tom Hill, Tanworth in Arden Tom Hill, Tanworth in Arden Out of Force Are Out of Force Area NFA Out of Force      
2617 op-snap---monthly-publication-august-2025.pdf   592 2025-08 Motorbike Citroen DS3 White Contravening a Red Traffic Light None Lower High Street Cradley Lower High Street Cradley Sandwell Sandwell Education N/A   52.4705129 -2.0883002
2560 op-snap---monthly-publication-august-2025.pdf   535 2025-08 Motorbike Tesla Model 3 Blue Using a Mobile Phone Whilst Driving None A38M A38M Birmingham Birmingham Fixed Penalty N/A      
2529 op-snap---monthly-publication-august-2025.pdf   504 2025-08 Motorbike BMW X5 Blue Driving without Due Care and Attention None Holbeach Road Holbeach Road Dudley Dudley Warning Letter N/A      
2433 op-snap---monthly-publication-august-2025.pdf   408 2025-08 Motorbike Skoda Yeti Silver Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Education N/A   52.6095168 -2.0493009
2428 op-snap---monthly-publication-august-2025.pdf   403 2025-08 Motorbike BMW 5 series White Driving without Due Care and Attention None Alcester Road / Salisbury Road Alcester Road / Salisbury Road Birmingham Birmingham Warning Letter N/A   52.4467548 -1.8880528
2141 op-snap---monthly-publication-august-2025.pdf   116 2025-08 Motorbike Mercedes-Benz GLC 300 Black Driving without Due Care and Attention None Truggist Lane Truggist Lane Solihull Solihull Warning Letter N/A   52.3962708 -1.6254918
13957 op-snap---monthly-publication-july-2025.pdf   2009 2025-07 Motorbike Ford Fiesta Red Driving without Due Care and Attention None A444 Gallagher shopping center Gallagher shopping center Coventry Coventry Warning Letter N/A      
13247 op-snap---monthly-publication-july-2025.pdf   1299 2025-07 Motorbike Audi A7 Black Contravening a Red Traffic Light None Aldersley Road Aldersley Road Wolverhampton Wolverhampton Court N/A   52.6058472 -2.1521123
13245 op-snap---monthly-publication-july-2025.pdf   1297 2025-07 Motorbike Ford Transit White Driving without Due Care and Attention None Finchfield Road Finchfield Road Wolverhampton Wolverhampton Education N/A   52.5805119 -2.1581621
12734 op-snap---monthly-publication-july-2025.pdf   786 2025-07 Motorbike Ford Transit Blue Driving without Due Care and Attention None M5 Northbound M5 Northbound Sandwell Sandwell NFA Outside of 14 Days NIP      
12644 op-snap---monthly-publication-july-2025.pdf   696 2025-07 Motorbike BMW 118M Blue Driving without Due Care and Attention None Salisbury Road, Moseley Salisbury Road, Moseley Birmingham Birmingham NFA No Independent Evidence Available   52.4490203 -1.8955977
12632 op-snap---monthly-publication-july-2025.pdf   684 2025-07 Motorbike Land Rover Defender Grey Driving without Due Care and Attention None New Road Norton Lindsey New Road Norton Lindsey Out of Force Area Out of Force Area NFA Out of Force      
12256 op-snap---monthly-publication-july-2025.pdf   308 2025-07 Motorbike Vauxhall Corsa Silver Driving without Due Care and Attention None New Cross Hospital New Cross Hospital Wolverhampton Wolverhampton Warning Letter N/A   52.6000052 -2.0954966
12078 op-snap---monthly-publication-july-2025.pdf   130 2025-07 Motorbike Nissan Qashqai Black Driving without Due Care and Attention None Aldersley Road Aldersley Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6058472 -2.1521123
12039 op-snap---monthly-publication-july-2025.pdf   91 2025-07 Motorbike Vauxhall Corsa Grey Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5919543 -1.8517118
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
15558 op-snap---monthly-publication-june-2025.pdf   1487 2025-06 Motorbike Mercedes-Benz Vito White Contravening a Red Traffic Light None Rowley Regis Rowley Regis Sandwell Sandwell NFA No VRM   52.4833326 -2.0674067
15479 op-snap---monthly-publication-june-2025.pdf   1408 2025-06 Motorbike Volkswagen Polo Silver Driving without Reasonable Consideration None Commandery Road, Worcester Commandery Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
14911 op-snap---monthly-publication-june-2025.pdf   840 2025-06 Motorbike Audi Q3 Black Using a Mobile Phone Whilst Driving None Hagley Road West Hagley Road West Birmingham Birmingham Fixed Penalty N/A   52.4656414 -1.9852276
14559 op-snap---monthly-publication-june-2025.pdf   488 2025-06 Motorbike Audi A6 Black Driving without Due Care and Attention None A45 Small Heath Highway Small Heath Highway Birmingham Birmingham Warning Letter N/A   52.4709298 -1.8722585
14524 op-snap---monthly-publication-june-2025.pdf   453 2025-06 Motorbike Audi A1 Black Driving without Due Care and Attention None College Road College Road Birmingham Birmingham Fixed Penalty N/A   52.5151832 -1.9361664
14256 op-snap---monthly-publication-june-2025.pdf   185 2025-06 Motorbike Mini Cooper Green Using a Mobile Phone Whilst Driving None Lincoln St Lincoln Street Birmingham Birmingham Fixed Penalty N/A   52.459298 -1.8933648
14220 op-snap---monthly-publication-june-2025.pdf   149 2025-06 Motorbike Seat Cupra Black Driving without Due Care and Attention None Station Road, Rowley Regis Station Road, Rowley Regis Sandwell Sandwell Warning Letter N/A   52.4712548 -2.0554193
20326 op-snap---monthly-publication-may-2025.pdf   1688 2025-05 Motorbike   q30 Black Driving without Due Care and Attention None Bennetts Road Bennetts Road Coventry Coventry Warning Letter N/A   52.4589908 -1.534516
20083 op-snap---monthly-publication-may-2025.pdf   1445 2025-05 Motorbike Audi TT Beige Driving without Due Care and Attention None Wheeleys road Wheeleys road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4709044 -1.9117603
20076 op-snap---monthly-publication-may-2025.pdf   1438 2025-05 Motorbike   coach Grey Driving without Due Care and Attention None Stockfield road Stockfield road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4519414 -1.831688
19930 op-snap---monthly-publication-may-2025.pdf   1292 2025-05 Motorbike Citroen Relay White Contravening a Red Traffic Light None Haydem circus traffic island Haydem circus traffic island Birmingham Birmingham NFA Outside of 14 Days NIP      
19929 op-snap---monthly-publication-may-2025.pdf   1291 2025-05 Motorbike Ford Transit Silver Driving without Due Care and Attention None JTC of ST Vincent Street West JTC of ST Vincent Street West Birmingham Birmingham NFA Outside of 14 Days NIP      
19710 op-snap---monthly-publication-may-2025.pdf   1072 2025-05 Motorbike Vauxhall Astra Black VRM fails to conform to Regulations None Measham - off force Measham - off force Out of Force Area Out of Force Area NFA Out of Force      
19686 op-snap---monthly-publication-may-2025.pdf   1048 2025-05 Motorbike   Alexander Denni sWhite Driving without Due Care and Attention None Shakespeare Drive Shakespeare Drive Solihull Solihull NFA No Offence   52.4021013 -1.8317213
19057 op-snap---monthly-publication-may-2025.pdf   419 2025-05 Motorbike Toyota Yaris Blue Using a Mobile Phone Whilst Driving None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A   52.4327486 -1.8844997
18693 op-snap---monthly-publication-may-2025.pdf   55 2025-05 Motorbike Toyota Pirus White Driving without Reasonable Consideration None M40 J15-J16 M40 J15-J16 Solihull Solihull NFA Outside of 14 Days NIP      
18689 op-snap---monthly-publication-may-2025.pdf   51 2025-05 Motorbike BMW 320d Blue Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18684 op-snap---monthly-publication-may-2025.pdf   46 2025-05 Motorbike Hyundai IX35 Grey Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
1442 op-snap---monthly-publication-april-2025.pdf   1441 2025-04 Motorbike Mercedes-Benz NP Black Contravening a Red Traffic Light None Oldbury road Oldbury road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5018196 -1.9811249
789 op-snap---monthly-publication-april-2025.pdf   788 2025-04 Motorbike BMW 840D Black Using a Mobile Phone Whilst Driving None Mount Pleasant Mount Pleasant Dudley Dudley Fixed Penalty N/A   52.4734063 -2.1135639
783 op-snap---monthly-publication-april-2025.pdf   782 2025-04 Motorbike Nissan Qashqai White Using a Mobile Phone Whilst Driving None Dudley Road Dudley Road Halesowen Halesowen Warning Letter N/A   52.5717314 -2.1249182
18618 op-snap---monthly-publication-march-2025.pdf   2375 2025-03 Motorbike BMW 320 D.. Black Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4193964 -1.8252207
18027 op-snap---monthly-publication-march-2025.pdf   1784 2025-03 Motorbike Vauxhall Corsa Grey Contravening a Red Traffic Light None Gooch Street Gooch Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4686609 -1.8945007
17845 op-snap---monthly-publication-march-2025.pdf   1602 2025-03 Motorbike Nissan Qashqai Blue Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4726661 -1.8769032
17369 op-snap---monthly-publication-march-2025.pdf   1126 2025-03 Motorbike Audi A6 Black Using a Mobile Phone Whilst Driving None Halesowen Road Halesowen Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4727241 -2.0645309
17024 op-snap---monthly-publication-march-2025.pdf   781 2025-03 Motorbike Honda CBR125 Red Misc - Non Traffic Offences None Binley Woods Leicester Binley Woods Leicester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16977 op-snap---monthly-publication-march-2025.pdf   734 2025-03 Motorbike Seat Arona Blue Contravening a Red Traffic Light None A38 A38 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
16974 op-snap---monthly-publication-march-2025.pdf   731 2025-03 Motorbike Vauxhall Insignia Black Contravening a Red Traffic Light None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
16870 op-snap---monthly-publication-march-2025.pdf   627 2025-03 Motorbike Audi A1 Black Driving without Due Care and Attention Use vehicle on a road without valid test certificate Ladywood Middleway Ladywood Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.473883 -1.9198244
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
16531 op-snap---monthly-publication-march-2025.pdf   288 2025-03 Motorbike Isuzu D-max White Driving without Due Care and Attention None Aston Expressway Aston Expressway Birmingham Birmingham RTC - Actioned N/A Yes - Via Email 52.493793 -1.8881773
16414 op-snap---monthly-publication-march-2025.pdf   171 2025-03 Motorbike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Vicar Street at Dudley Road Sedgley Vicar Street at Dudley Road Sedgley Dudley Dudley Education N/A Yes - Via Email 52.5081139 -2.0856851
6543 op-snap---monthly-publication-february-2025.pdf   1360 2025-02 Motorbike Nissan Juke Blue Contravening a Red Traffic Light None Great Charles Street Birmingham Great Charles Street Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4837518 -1.901874
6540 op-snap---monthly-publication-february-2025.pdf   1357 2025-02 Motorbike Volkswagen Golf Grey Contravening a Red Traffic Light None Dartmouth Circus Birmingham Dartmouth Circus Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4924084 -1.887629
6488 op-snap---monthly-publication-february-2025.pdf   1305 2025-02 Motorbike Ford FOCUS Red Contravening a Red Traffic Light None BELLS LANE Bells Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4053419 -1.8944602
5835 op-snap---monthly-publication-february-2025.pdf   652 2025-02 Motorbike   Kawasaki Green Driving without Due Care and Attention No Insurance Dudley Road, Halesowen Dudley Road, Halesowen Halesowen Halesowen Court N/A Yes - Via Email 52.4584767 -2.0483421
5558 op-snap---monthly-publication-february-2025.pdf   375 2025-02 Motorbike Ford focus Silver Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.5292752 -1.7618805
9536 op-snap---monthly-publication-january-2025.pdf   644 2025-01 Motorbike Vauxhall Zafira Grey Driving without Due Care and Attention None Bickenhill Interchange Bickenhill Interchange Solihull Solihull Education N/A Yes - Via Email 52.4457674 -1.7082354
9533 op-snap---monthly-publication-january-2025.pdf   641 2025-01 Motorbike Daf MAN White Driving without Due Care and Attention None STONEBRIDGE HIGHWAY Stonebridge Highway Coventry Coventry Education N/A Yes - Via Email 52.3782187 -1.478696
9416 op-snap---monthly-publication-january-2025.pdf   524 2025-01 Motorbike Lexus IS200 Black Driving without Due Care and Attention None MARSH HILL Marsh Hill Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
9217 op-snap---monthly-publication-january-2025.pdf   325 2025-01 Motorbike Mini Cooper Orange Using a Mobile Phone Whilst Driving None A45 Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032

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