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

515 rows where disposal = "NFA", reporter_transport_mode = "Car" and vehicle_make = "BMW" 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

offence 28

  • Driving without Due Care and Attention 230
  • Contravening a Red Traffic Light 81
  • Driving without Reasonable Consideration 55
  • Misc - Non Traffic Offences 34
  • Cause vehicle to be left in a dangerous position 23
  • Using a Mobile Phone Whilst Driving 22
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 15
  • Stop a vehicle within pelican pedestrian crossing limits 15
  • Dangerous Driving 5
  • Stop a vehicle on pedestrian crossing 5
  • Cause unnecessary obstruction by motor vehicle 3
  • No Seat Belt 3
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
  • VRM fails to conform to Regulations 3
  • Fail to display front VRM plate 2
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
  • Motor vehicle fail to comply with solid white line road markings 2
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
  • DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
  • Drive / Ride / Lead an animal on a footpath 1
  • Drive a vehicle other than on the carriageway of a motorway 1
  • Drive on hard shoulder 1
  • Driver not in position to have Proper Control 1
  • MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
  • Motor vehicle fail to comply with endorsable sect 1
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
  • No vehicle excise licence 1
  • Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1

council_area 20

  • Birmingham 229
  • Out of Force Area 136
  • Coventry 31
  • Wolverhampton 28
  • Sandwell 25
  • Dudley 21
  • Solihull 11
  • Walsall 11
  • Sutton Coldfield 10
  • Halesowen 3
  • 3B2Irmingham 1
  • Ao4U0T9 O7F Force Area 1
  • Aorueta Of Force 1
  • Area 1
  • Bafifromrdin Grhoaamd 1
  • Hbeiramthingham 1
  • Ouruyt Of Force Area 1
  • Scoouvtehn Try 1
  • Two Bolrvaedrmhaomrep Rtooand 1
  • Woaurtd Osf Dfeovrcoen Area 1

month 14

  • 2025-04 77
  • 2025-07 64
  • 2025-06 48
  • 2025-05 46
  • 2025-12 45
  • 2025-10 40
  • 2025-08 39
  • 2025-09 35
  • 2025-11 28
  • 2025-03 23
  • 2026-01 21
  • 2025-02 17
  • 2026-02 17
  • 2025-01 15

vehicle_make 1

  • BMW · 515 ✖

reporter_transport_mode 1

  • Car · 515 ✖

disposal 1

  • NFA · 515 ✖
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
7342 op-snap---monthly-publication-february-2026.pdf   89 2026-02 Car BMW 116D Red Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
7345 op-snap---monthly-publication-february-2026.pdf   92 2026-02 Car BMW X4 White Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
7356 op-snap---monthly-publication-february-2026.pdf   103 2026-02 Car BMW M340i Grey Driving without Due Care and Attention None Great North Road, Retford Great North Road, Retford Out of Force Area Out of Force Area NFA Out of Force      
7423 op-snap---monthly-publication-february-2026.pdf   170 2026-02 Car BMW 3 series Green Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None Springfield Lane / Greenfield Lane Springfield Lane / Greenfield Lane Wolverhampton Wolverhampton NFA No VRM   52.6345604 -2.1196834
7604 op-snap---monthly-publication-february-2026.pdf   351 2026-02 Car BMW X5 Grey Driving without Due Care and Attention None M6 Junction 15 M6 Junction 15 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
7693 op-snap---monthly-publication-february-2026.pdf   440 2026-02 Car BMW X Drive Black Driving without Due Care and Attention None M5 Southbound M5 Southbound Out of Force Area Out of Force Area NFA Out of Force      
7926 op-snap---monthly-publication-february-2026.pdf   673 2026-02 Car BMW X5 White Driving without Due Care and Attention None Stafford Rd Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
8037 op-snap---monthly-publication-february-2026.pdf   784 2026-02 Car BMW 320i Grey Driving without Due Care and Attention None Holloway Circus Queensway Holloway Circus Queensway Birmingham Birmingham NFA No Offence   52.4751679 -1.9006538
8091 op-snap---monthly-publication-february-2026.pdf   838 2026-02 Car BMW 116d Black Driving without Due Care and Attention None M6 EB J4 M6 Eb J4 Out of Force Area Out of Force Area NFA Out of Force   52.6912891 -2.1046372
8245 op-snap---monthly-publication-february-2026.pdf   992 2026-02 Car BMW 5 Series Blue Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry NFA No Independent Evidence Available      
8249 op-snap---monthly-publication-february-2026.pdf   996 2026-02 Car BMW 120 Sport White Using a Mobile Phone Whilst Driving None Scimitar Way Scimitar Way Coventry Coventry NFA No Independent Evidence Available   52.3836203 -1.4862458
8266 op-snap---monthly-publication-february-2026.pdf   1013 2026-02 Car BMW 7 Grey Driving without Due Care and Attention None M42 towards Solihull M42 towards Solihull Out of Force Area Out of Force Area NFA Out of Force      
8458 op-snap---monthly-publication-february-2026.pdf   1205 2026-02 Car BMW 5 series White Using a Mobile Phone Whilst Driving None Kidderminster Road Kidderminster Road Dudley Dudley NFA No Independent Evidence Available   52.5000055 -2.1844503
8471 op-snap---monthly-publication-february-2026.pdf   1218 2026-02 Car BMW 330 E Grey Driving without Due Care and Attention No Insurance Goldthorn Hill Goldthorn Hill Wolverhampton Wolverhampton NFA     52.5690522 -2.1388773
8472 op-snap---monthly-publication-february-2026.pdf   1219 2026-02 Car BMW 3 series Black Using a Mobile Phone Whilst Driving None M4 M4 Out of Force Area Out of Force Area NFA Out of Force      
8746 op-snap---monthly-publication-february-2026.pdf   1493 2026-02 Car BMW 5 series Grey Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA     52.4552785 -1.906384
8785 op-snap---monthly-publication-february-2026.pdf   1532 2026-02 Car BMW X3 White Driving without Due Care and Attention None Bromford Road / Bromford Lane Bromford Road / Bromford Lane Birmingham Birmingham NFA No VRM   52.503036 -1.8289972
10672 op-snap---monthly-publication-january-2026.pdf   133 2026-01 Car BMW 320d Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None High Street, Deritend High Street, Deritend Birmingham Birmingham NFA No Independent Evidence Available   52.4746492 -1.8839977
10768 op-snap---monthly-publication-january-2026.pdf   229 2026-01 Car BMW X6 White Driving without Due Care and Attention None Green lane Green lane Birmingham Birmingham NFA No Independent Evidence Available   52.4618966 -1.9955421
10795 op-snap---monthly-publication-january-2026.pdf   256 2026-01 Car BMW 1 Series Blue Contravening a Red Traffic Light None Coventry Road, Exhall Coventry Road, Exhall Out of Force Area Out of Force Area NFA Out of Force      
10820 op-snap---monthly-publication-january-2026.pdf   281 2026-01 Car BMW 320 Black Driving without Due Care and Attention Offence to be added A435 Alcester Road/M42 Roundabout Alcester Road/M42 Roundabout Out of Force Area Out of Force Area NFA Out of Force      
10830 op-snap---monthly-publication-january-2026.pdf   291 2026-01 Car BMW   White Driving without Due Care and Attention None Cotheridge Cotheridge Out of Force Area Out of Force Area NFA Out of Force   52.3899442 -1.7798813
10833 op-snap---monthly-publication-january-2026.pdf   294 2026-01 Car BMW 118 Grey Driving without Due Care and Attention none Chetwynd Bridge, Croxall, Staffordshire Chetwynd Bridge, Croxall, Staffordshire Out of Force Area Out of Force Area NFA Out of Force      
10853 op-snap---monthly-publication-january-2026.pdf   314 2026-01 Car BMW 439I White Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry NFA No Independent Evidence Available   52.4068712 -1.4994695
10905 op-snap---monthly-publication-january-2026.pdf   366 2026-01 Car BMW 6 Series Black Using a Mobile Phone Whilst Driving None M6 J14 M6 J14 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
11015 op-snap---monthly-publication-january-2026.pdf   476 2026-01 Car BMW M3 Black Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA No Independent Evidence Available   52.505832 -1.92002
11074 op-snap---monthly-publication-january-2026.pdf   535 2026-01 Car BMW 116d Black Contravening a Red Traffic Light None Soundwell Road, Bristol Soundwell Road, Bristol Out of Force Area Out of Force Area NFA Out of Force      
11095 op-snap---monthly-publication-january-2026.pdf   556 2026-01 Car BMW 520 Black No Seat Belt None Hurst Lane Merry Hill Hurst Lane Merry Hill Dudley Dudley NFA No Offence      
11310 op-snap---monthly-publication-january-2026.pdf   771 2026-01 Car BMW   Blue Contravening a Red Traffic Light None A34 Newcastle Newcastle Out of Force Area Out of Force Area NFA Out of Force      
11364 op-snap---monthly-publication-january-2026.pdf   825 2026-01 Car BMW 330 Grey Driving without Due Care and Attention None Bhllys Lane Bhllys Lane Wolverhampton Wolverhampton NFA No Independent Evidence Available      
11395 op-snap---monthly-publication-january-2026.pdf   856 2026-01 Car BMW 218D White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
11471 op-snap---monthly-publication-january-2026.pdf   932 2026-01 Car BMW 530.. Black Driving without Due Care and Attention None Ayelstone Road (Leicester) Ayelstone Road (Leicester) Out of Force Area Out of Force Area NFA Out of Force      
11483 op-snap---monthly-publication-january-2026.pdf   944 2026-01 Car BMW 520d White Driving without Due Care and Attention None Highfields Road, Burntwood Highfields Road, Burntwood Out of Force Area Out of Force Area NFA Out of Force      
11494 op-snap---monthly-publication-january-2026.pdf   955 2026-01 Car BMW X5 Black Using a Mobile Phone Whilst Driving None A6182 Doncatser Doncatser Out of Force Area Out of Force Area NFA Out of Force      
11496 op-snap---monthly-publication-january-2026.pdf   957 2026-01 Car BMW 640.. White Contravening a Red Traffic Light None A34 Grey Friars Grey Friars Out of Force Area Out of Force Area NFA Out of Force      
11577 op-snap---monthly-publication-january-2026.pdf   1038 2026-01 Car BMW 1 SERIS Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No VRM   52.4191184 -1.8326637
11598 op-snap---monthly-publication-january-2026.pdf   1059 2026-01 Car BMW M3 Blue Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No Independent Evidence Available   52.4191184 -1.8326637
11891 op-snap---monthly-publication-january-2026.pdf   1352 2026-01 Car BMW 1 Series White Contravening a Red Traffic Light None Hunter Road Hunter Road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
3877 op-snap---monthly-publication-december-2025.pdf   5 2025-12 Car BMW 220M Silver Contravening a Red Traffic Light None Alcester Road South Alcester Road South Birmingham Birmingham NFA No Independent Evidence Available   52.4170522 -1.8906187
4013 op-snap---monthly-publication-december-2025.pdf   141 2025-12 Car BMW 3 series Black Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Independent Evidence Available   52.4726661 -1.8769032
4032 op-snap---monthly-publication-december-2025.pdf   160 2025-12 Car BMW 1 Series Silver Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham NFA No Independent Evidence Available   52.502683 -1.9033516
4040 op-snap---monthly-publication-december-2025.pdf   168 2025-12 Car BMW X1 White Driving without Due Care and Attention None A46 A46 Out of Force Area Out of Force Area NFA Out of Force      
4042 op-snap---monthly-publication-december-2025.pdf   170 2025-12 Car BMW X5 White Contravening a Red Traffic Light None Newton Road Newton Road Birmingham Birmingham NFA No Independent Evidence Available   52.4541102 -1.8710993
4046 op-snap---monthly-publication-december-2025.pdf   174 2025-12 Car BMW 3 series Grey Driving without Due Care and Attention None West Mrob West Mrob Sandwell Sandwell NFA No Offence      
4078 op-snap---monthly-publication-december-2025.pdf   206 2025-12 Car BMW 320 Black Driving without Due Care and Attention None M1 M1 Out of Force Area Out of Force Area NFA Out of Force      
4146 op-snap---monthly-publication-december-2025.pdf   274 2025-12 Car BMW 525D Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
4170 op-snap---monthly-publication-december-2025.pdf   298 2025-12 Car BMW 1 Series White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Anthony Road Anthony Road Birmingham Birmingham NFA Misc Inc Crimes   52.4843724 -1.8470805
4188 op-snap---monthly-publication-december-2025.pdf   316 2025-12 Car BMW 118i Black Contravening a Red Traffic Light None Craddock Street Craddock Street Birmingham Birmingham NFA No Independent Evidence Available   52.490126 -1.9129277
4204 op-snap---monthly-publication-december-2025.pdf   332 2025-12 Car BMW 1 Series Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Heronswood Road Heronswood Road Out of Force Area Out of Force Area NFA Out of Force   52.3873141 -2.0016866
4261 op-snap---monthly-publication-december-2025.pdf   389 2025-12 Car BMW 3 Series Black Contravening a Red Traffic Light None Spring HIll Spring HIll Birmingham Birmingham NFA No Independent Evidence Available   52.4854232 -1.9218159
4287 op-snap---monthly-publication-december-2025.pdf   415 2025-12 Car BMW 520.. Grey Driving without Due Care and Attention None Houlton Way Houlton Way Out of Force Area Out of Force Area NFA Out of Force      
4317 op-snap---monthly-publication-december-2025.pdf   445 2025-12 Car BMW 1 series White Misc - Non Traffic Offences None Burnt Tree Burnt Tree Dudley Dudley NFA No Independent Evidence Available   52.513767 -2.0633163
4432 op-snap---monthly-publication-december-2025.pdf   560 2025-12 Car BMW 3 Series Grey Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham NFA No Offence   52.5148331 -1.79231
4450 op-snap---monthly-publication-december-2025.pdf   578 2025-12 Car BMW Mini Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Long Street, Atherstone Long Street, Atherstone Out of Force Area Out of Force Area NFA Out of Force      
4478 op-snap---monthly-publication-december-2025.pdf   606 2025-12 Car BMW 1 Series Silver Contravening a Red Traffic Light None Bridgnorth Road Bridgnorth Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5870072 -2.1755927
4497 op-snap---monthly-publication-december-2025.pdf   625 2025-12 Car BMW 3 Series Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Independent Evidence Available   52.4967329 -1.8097462
4504 op-snap---monthly-publication-december-2025.pdf   632 2025-12 Car BMW   White Contravening a Red Traffic Light None Old Walsall Road Old Walsall Road Birmingham Birmingham NFA No Independent Evidence Available   52.5294399 -1.9282714
4506 op-snap---monthly-publication-december-2025.pdf   634 2025-12 Car BMW 520 Grey Driving without Due Care and Attention None Motorway but are u/K Motorway but are u/K Birmingham Birmingham NFA No Independent Evidence Available      
4520 op-snap---monthly-publication-december-2025.pdf   648 2025-12 Car BMW 520 Grey Driving without Due Care and Attention None M1 J23 M1 J23 Out of Force Area Out of Force Area NFA Out of Force      
4535 op-snap---monthly-publication-december-2025.pdf   663 2025-12 Car BMW 120 Grey Driving without Due Care and Attention None Sanley Park Road, Croydon Sanley Park Road, Croydon Out of Force Area Out of Force Area NFA Out of Force      
4562 op-snap---monthly-publication-december-2025.pdf   690 2025-12 Car BMW 3 series Silver Misc - Non Traffic Offences None dudley road Dudley Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5717314 -2.1249182
4629 op-snap---monthly-publication-december-2025.pdf   757 2025-12 Car BMW   White Driving without Due Care and Attention None M5 M5 Halesowen Halesowen NFA No Independent Evidence Available      
4638 op-snap---monthly-publication-december-2025.pdf   766 2025-12 Car BMW   Black Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry NFA No VRM   52.4085943 -1.4943275
4640 op-snap---monthly-publication-december-2025.pdf   768 2025-12 Car BMW   Black Driving without Due Care and Attention None Montgomery Street Montgomery Street Birmingham Birmingham NFA No VRM   52.4644472 -1.8668879
4714 op-snap---monthly-publication-december-2025.pdf   842 2025-12 Car BMW 840i Red Misc - Non Traffic Offences None B6049 Hope, Sheffield Hope, Sheffield Out of Force Area Out of Force Area NFA Out of Force      
4770 op-snap---monthly-publication-december-2025.pdf   898 2025-12 Car BMW M3 Orange Driving without Due Care and Attention None Hallens drive Hallens drive Sandwell Sandwell NFA No Independent Evidence Available   52.5503398 -2.0350718
4782 op-snap---monthly-publication-december-2025.pdf   910 2025-12 Car BMW X1 Black Driving without Due Care and Attention None Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
4783 op-snap---monthly-publication-december-2025.pdf   911 2025-12 Car BMW   Grey Driving without Due Care and Attention None unknown   Birmingham Birmingham NFA No Independent Evidence Available      
4832 op-snap---monthly-publication-december-2025.pdf   960 2025-12 Car BMW 218I Black Contravening a Red Traffic Light None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5872149 -1.8300386
4857 op-snap---monthly-publication-december-2025.pdf   985 2025-12 Car BMW 320i Grey Misc - Non Traffic Offences None M5 jn1 M5 jn1 Sandwell Sandwell NFA No Offence      
4868 op-snap---monthly-publication-december-2025.pdf   996 2025-12 Car BMW M3 Yellow Driving without Due Care and Attention None A38M A38M Birmingham Birmingham NFA Outside of 14 Days NIP      
4873 op-snap---monthly-publication-december-2025.pdf   1001 2025-12 Car BMW 530D Black Contravening a Red Traffic Light None Cinder Bank Cinder Bank Dudley Dudley NFA Outside of 14 Days NIP   52.4951209 -2.0924902
4907 op-snap---monthly-publication-december-2025.pdf   1035 2025-12 Car BMW X3 Blue Driving without Due Care and Attention None A46 in Nottinghamshire A46 in Nottinghamshire Out of Force Area Out of Force Area NFA Out of Force      
4915 op-snap---monthly-publication-december-2025.pdf   1043 2025-12 Car BMW 5 series Black Driving without Due Care and Attention None St Johns Road, Stourbridge Street Johns Road, Stourbridge Dudley Dudley NFA No VRM      
4919 op-snap---monthly-publication-december-2025.pdf   1047 2025-12 Car BMW   Black Contravening a Red Traffic Light None Paget Road Paget Road Wolverhampton Wolverhampton NFA No VRM   52.5890037 -2.1560687
4966 op-snap---monthly-publication-december-2025.pdf   1094 2025-12 Car BMW 2 series Black Driver not in position to have Proper Control None M6 in Staffordshire M6 in Staffordshire Out of Force Area Out of Force Area NFA Out of Force      
5000 op-snap---monthly-publication-december-2025.pdf   1128 2025-12 Car BMW   Purple Using a Mobile Phone Whilst Driving None Guildford Guildford Out of Force Area Out of Force Area NFA Out of Force   52.4970635 -1.9013006
5042 op-snap---monthly-publication-december-2025.pdf   1170 2025-12 Car BMW 330.. Black Driving without Due Care and Attention None M42 towards Shrewsbury M42 towards Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
5044 op-snap---monthly-publication-december-2025.pdf   1172 2025-12 Car BMW 130.. White Driving without Due Care and Attention None Harlescroft Park and Ride Shrewsb Harlescroft Park and Ride Shrewsb Ouruyt of Force Area Ouruyt Of Force Area NFA Out of Force      
5052 op-snap---monthly-publication-december-2025.pdf   1180 2025-12 Car BMW   Blue Driving without Due Care and Attention None A451 Minster Road Minster Road Out of Force Area Out of Force Area NFA Out of Force   52.4100542 -1.5227279
5070 op-snap---monthly-publication-december-2025.pdf   1198 2025-12 Car BMW 730 LD Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
5079 op-snap---monthly-publication-december-2025.pdf   1207 2025-12 Car BMW   White Driving without Due Care and Attention None warwickshire Warwickshire Out of Force Area Out of Force Area NFA Out of Force   52.4318492 -1.7319529
5162 op-snap---monthly-publication-december-2025.pdf   1290 2025-12 Car BMW M3 White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
20467 op-snap---monthly-publication-november-2025.pdf   9 2025-11 Car BMW X4 Black Driving without Due Care and Attention None M6 Toll M6 Toll Out of Force Area Out of Force Area NFA Out of Force   52.5804962 -1.7833098
20499 op-snap---monthly-publication-november-2025.pdf   41 2025-11 Car BMW 2 series Blue Driving without Due Care and Attention None High Street, Alvechurch. West Mercia High Street, Alvechurch. West Mercia Out of Force Area Out of Force Area NFA Out of Force      
20525 op-snap---monthly-publication-november-2025.pdf   67 2025-11 Car BMW X2 Blue Contravening a Red Traffic Light None Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry NFA No Independent Evidence Available   52.3793117 -1.4625379
20565 op-snap---monthly-publication-november-2025.pdf   107 2025-11 Car BMW IX3.. White Driving without Due Care and Attention None Moseley Road Moseley Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5782924 -2.0742911
20607 op-snap---monthly-publication-november-2025.pdf   149 2025-11 Car BMW X5 Silver Driving without Due Care and Attention None M5 Gloucester M5 Gloucester Out of Force Area Out of Force Area NFA Out of Force   52.4760581 -1.8948199
20667 op-snap---monthly-publication-november-2025.pdf   209 2025-11 Car BMW M340 Grey Cause vehicle to be left in a dangerous position None Hobbs Road Hobbs Road Sandwell Sandwell NFA Misc Inc Crimes      
20679 op-snap---monthly-publication-november-2025.pdf   221 2025-11 Car BMW 320.. Silver No Seat Belt None Dudley Road Dudley Road Birmingham Birmingham NFA No Independent Evidence Available   52.4865107 -1.9386263
20701 op-snap---monthly-publication-november-2025.pdf   243 2025-11 Car BMW 640 D Black Misc - Non Traffic Offences None A456 (Tenbury Wells) A456 (Tenbury Wells) Out of Force Area Out of Force Area NFA Out of Force      
20787 op-snap---monthly-publication-november-2025.pdf   329 2025-11 Car BMW X7 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham NFA Not in Public Interest   52.5151832 -1.9361664
20808 op-snap---monthly-publication-november-2025.pdf   350 2025-11 Car BMW 118D Black Using a Mobile Phone Whilst Driving None A45 A45 Birmingham Birmingham NFA No Independent Evidence Available      
20812 op-snap---monthly-publication-november-2025.pdf   354 2025-11 Car BMW 320D Blue Contravening a Red Traffic Light None Grove Lane Grove Lane Birmingham Birmingham NFA No VRM   52.5055208 -1.9328067
20853 op-snap---monthly-publication-november-2025.pdf   395 2025-11 Car BMW X5 Grey Misc - Non Traffic Offences None Spitfire Island Spitfire Island Birmingham Birmingham NFA No Offence   52.5138106 -1.797297
20965 op-snap---monthly-publication-november-2025.pdf   507 2025-11 Car BMW M3 Black Driving without Due Care and Attention None Park Road, Ware Park Road, Ware Out of Force Area Out of Force Area NFA Out of Force      
21012 op-snap---monthly-publication-november-2025.pdf   554 2025-11 Car BMW M3 Grey Driving without Due Care and Attention None M6 Jct 6 M6 Junction 6 Birmingham Birmingham NFA No Independent Evidence Available   52.676119 -2.0858425
21013 op-snap---monthly-publication-november-2025.pdf   555 2025-11 Car BMW i3 Silver Contravening a Red Traffic Light None Priory Road, Kenilworth Priory Road, Kenilworth Out of Force Area Out of Force Area NFA Out of Force      
21058 op-snap---monthly-publication-november-2025.pdf   600 2025-11 Car BMW   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Monkspath Monkspath Birmingham Birmingham NFA No Offence   52.5441651 -1.7964249
21059 op-snap---monthly-publication-november-2025.pdf   601 2025-11 Car BMW X5 Black Driving without Due Care and Attention None Southam, Warwickshire Southam, Warwickshire Out of Force Area Out of Force Area NFA Out of Force      

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