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

542 rows where reporter_transport_mode = "Car" and vehicle_make = "Nissan" 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, witness_contacted

month 14

vehicle_make 1

  • Nissan · 542 ✖

reporter_transport_mode 1

  • Car · 542 ✖
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
8865 op-snap---monthly-publication-february-2026.pdf   1612 2026-02 Car Nissan leaf White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
8847 op-snap---monthly-publication-february-2026.pdf   1594 2026-02 Car Nissan qashqai Grey Misc - Non Traffic Offences None lower queen street Lower Queen Street Birmingham Birmingham NFA Misc Inc Crimes   52.5603978 -1.8227403
8841 op-snap---monthly-publication-february-2026.pdf   1588 2026-02 Car Nissan navara Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8799 op-snap---monthly-publication-february-2026.pdf   1546 2026-02 Car Nissan qashqai Blue Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8774 op-snap---monthly-publication-february-2026.pdf   1521 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None Lower Hillmorton Road Lower Hillmorton Road Out of Force Area Out of Force Area NFA Out of Force      
8759 op-snap---monthly-publication-february-2026.pdf   1506 2026-02 Car Nissan Qashqai Black Contravening a Red Traffic Light None Bath Street Hereford (West Mercia) Bath Street Hereford (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
8757 op-snap---monthly-publication-february-2026.pdf   1504 2026-02 Car Nissan Qashqai Black Driving without Due Care and Attention None John Macadam Way Hastings. John Macadam Way Hastings Out of Force Area Out of Force Area NFA Out of Force      
8698 op-snap---monthly-publication-february-2026.pdf   1445 2026-02 Car Nissan Juke White Contravening a Red Traffic Light None A45 Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
8682 op-snap---monthly-publication-february-2026.pdf   1429 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None The Broadway Stourbridge The Broadway Stourbridge Dudley Dudley Warning Letter N/A   52.4411413 -2.1695219
8604 op-snap---monthly-publication-february-2026.pdf   1351 2026-02 Car Nissan juke White Stop a vehicle on pedestrian crossing None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8564 op-snap---monthly-publication-february-2026.pdf   1311 2026-02 Car Nissan Juke Black Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
8541 op-snap---monthly-publication-february-2026.pdf   1288 2026-02 Car Nissan Micra Grey Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry NFA No Independent Evidence Available   52.4318623 -1.4804069
8523 op-snap---monthly-publication-february-2026.pdf   1270 2026-02 Car Nissan X Trail White Driving without Due Care and Attention None Station Road Station Road Birmingham Birmingham RTC - Actioned N/A   52.5054559 -1.9506109
8509 op-snap---monthly-publication-february-2026.pdf   1256 2026-02 Car Nissan Qashqai Black Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham NFA     52.4167654 -1.9411244
8453 op-snap---monthly-publication-february-2026.pdf   1200 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None Stafford Road Stafford Road Wolverhampton Wolverhampton Warning Letter N/A   52.6291998 -2.126312
8396 op-snap---monthly-publication-february-2026.pdf   1143 2026-02 Car Nissan Xtrail Orange Stop a vehicle within pelican pedestrian crossing limits None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
8361 op-snap---monthly-publication-february-2026.pdf   1108 2026-02 Car Nissan note Red Using a Mobile Phone Whilst Driving None A460 four ashes A460 four ashes Out of Force Area Out of Force Area NFA Out of Force   52.3828826 -1.7624844
8305 op-snap---monthly-publication-february-2026.pdf   1052 2026-02 Car Nissan Ariya Green Driving without Due Care and Attention None Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
8276 op-snap---monthly-publication-february-2026.pdf   1023 2026-02 Car Nissan Qashqai Blue Stop a vehicle within pelican pedestrian crossing limits None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
8170 op-snap---monthly-publication-february-2026.pdf   917 2026-02 Car Nissan Qashqai Silver Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
8162 op-snap---monthly-publication-february-2026.pdf   909 2026-02 Car Nissan Juke Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Wheelwright Road Wheelwright Road Out of Force Area Out of Force Area NFA Out of Force   52.5096312 -1.8353508
8142 op-snap---monthly-publication-february-2026.pdf   889 2026-02 Car Nissan Micra Black Stop a vehicle on pedestrian crossing None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
8136 op-snap---monthly-publication-february-2026.pdf   883 2026-02 Car Nissan Juke Red Misc - Non Traffic Offences None St Marys Row Street Marys Row Birmingham Birmingham NFA Not in Public Interest      
8060 op-snap---monthly-publication-february-2026.pdf   807 2026-02 Car Nissan Juke Blue Driving without Due Care and Attention None Victoria Road Perry Barr Victoria Road Perry Barr Birmingham Birmingham Education N/A   52.5024231 -1.8980876
8057 op-snap---monthly-publication-february-2026.pdf   804 2026-02 Car Nissan Micra Red Contravening a Red Traffic Light No Insurance Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
7910 op-snap---monthly-publication-february-2026.pdf   657 2026-02 Car Nissan Leaf Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Lower Queen Street Lower Queen Street Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5603978 -1.8227403
7908 op-snap---monthly-publication-february-2026.pdf   655 2026-02 Car Nissan Qashqai Black Stop a vehicle within pelican pedestrian crossing limits None Victoria Road Sutton Victoria Road Sutton Sutton Coldfield Sutton Coldfield Education N/A   52.5624555 -1.8218251
7813 op-snap---monthly-publication-february-2026.pdf   560 2026-02 Car Nissan Qashqai Black No Seat Belt None Coton Park Drive Coton Park Drive Out of Force Area Out of Force Area NFA Out of Force      
7781 op-snap---monthly-publication-february-2026.pdf   528 2026-02 Car Nissan Qashqai Grey Stop a vehicle on pedestrian crossing None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
7764 op-snap---monthly-publication-february-2026.pdf   511 2026-02 Car Nissan X-Trail Blue Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
7759 op-snap---monthly-publication-february-2026.pdf   506 2026-02 Car Nissan X Trail White Contravening a Red Traffic Light None All Saints Way All Saints Way Sandwell Sandwell Education N/A   52.5344405 -1.985568
7757 op-snap---monthly-publication-february-2026.pdf   504 2026-02 Car Nissan Ariya Grey Contravening a Red Traffic Light None Sheaf Lane at Coventry Road Sheaf Lane at Coventry Road Birmingham Birmingham Warning Letter N/A   52.4521337 -1.7818858
7750 op-snap---monthly-publication-february-2026.pdf   497 2026-02 Car Nissan Qashqai Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
7684 op-snap---monthly-publication-february-2026.pdf   431 2026-02 Car Nissan Pixo Black Contravene Lane Closure Red X None A38m A38m Birmingham Birmingham NFA No Offence      
7513 op-snap---monthly-publication-february-2026.pdf   260 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
7476 op-snap---monthly-publication-february-2026.pdf   223 2026-02 Car Nissan Juke Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
7411 op-snap---monthly-publication-february-2026.pdf   158 2026-02 Car Nissan Juke Black Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
7283 op-snap---monthly-publication-february-2026.pdf   30 2026-02 Car Nissan Qashqai White Cause vehicle to be left in a dangerous position None Chantry Road Chantry Road Birmingham Birmingham Education N/A   52.4496376 -1.8915224
11933 op-snap---monthly-publication-january-2026.pdf   1394 2026-01 Car Nissan Juke Black Contravening a Red Traffic Light None A34 Walsall Road towards Harrier Way Walsall Road towards Harrier Way Sutton Coldfield Sutton Coldfield Education N/A      
11875 op-snap---monthly-publication-january-2026.pdf   1336 2026-01 Car Nissan Qashqai Red Driving without Due Care and Attention None A452 Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
11758 op-snap---monthly-publication-january-2026.pdf   1219 2026-01 Car Nissan Micra Black Driver not in position to have Proper Control None Suffolk Street Suffolk Street Birmingham Birmingham Education N/A   52.4749336 -1.9003475
11705 op-snap---monthly-publication-january-2026.pdf   1166 2026-01 Car Nissan Qashqai Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kettlehouse Road Kettlehouse Road Birmingham Birmingham Warning Letter N/A   52.5546392 -1.8859041
11619 op-snap---monthly-publication-january-2026.pdf   1080 2026-01 Car Nissan Qashqai Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
11607 op-snap---monthly-publication-january-2026.pdf   1068 2026-01 Car Nissan X-Trail White Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry NFA No Independent Evidence Available   52.418488 -1.5472387
11595 op-snap---monthly-publication-january-2026.pdf   1056 2026-01 Car Nissan Micra Blue Driving without Due Care and Attention None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Fixed Penalty N/A   52.5038363 -1.8432663
11508 op-snap---monthly-publication-january-2026.pdf   969 2026-01 Car Nissan Micra Blue Driving without Due Care and Attention None Guildford Guildford Out of Force Area Out of Force Area NFA Out of Force   52.4970635 -1.9013006
11374 op-snap---monthly-publication-january-2026.pdf   835 2026-01 Car Nissan Qashqai Blue Stop a vehicle within pelican pedestrian crossing limits None Robert Street Robert Street Dudley Dudley Education N/A   52.5221845 -2.1196502
11348 op-snap---monthly-publication-january-2026.pdf   809 2026-01 Car Nissan X Trail White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Leopold Street Leopold Street Birmingham Birmingham NFA No Independent Evidence Available   52.4673764 -1.8862823
11338 op-snap---monthly-publication-january-2026.pdf   799 2026-01 Car Nissan Note Beige Contravening a Red Traffic Light None Bescot Road Bescot Road Walsall Walsall Education N/A   52.5707373 -2.0014215
11332 op-snap---monthly-publication-january-2026.pdf   793 2026-01 Car Nissan X Trail Green Contravening a Red Traffic Light None Wednesbury Interchange Wednesbury Interchange Sandwell Sandwell Education N/A   52.5660847 -2.0041239
11318 op-snap---monthly-publication-january-2026.pdf   779 2026-01 Car Nissan ARIYA Black Contravening a Red Traffic Light None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
11235 op-snap---monthly-publication-january-2026.pdf   696 2026-01 Car Nissan Micra White Driving without Due Care and Attention None Six Ways RA, Aston Six Ways RA, Aston Birmingham Birmingham NFA No Offence      
11231 op-snap---monthly-publication-january-2026.pdf   692 2026-01 Car Nissan   Red Contravening a Red Traffic Light None Wilford Lane Wilford Lane Out of Force Area Out of Force Area NFA Out of Force      
11208 op-snap---monthly-publication-january-2026.pdf   669 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
11188 op-snap---monthly-publication-january-2026.pdf   649 2026-01 Car Nissan Juke Red Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
11161 op-snap---monthly-publication-january-2026.pdf   622 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention No Insurance Whitchurch Drive, Shawbirch Whitchurch Drive, Shawbirch Out of Force Area Out of Force Area NFA Out of Force      
11127 op-snap---monthly-publication-january-2026.pdf   588 2026-01 Car Nissan Note Red Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Island Road Island Road Birmingham Birmingham NFA Not in Public Interest   52.5095686 -1.9544485
11104 op-snap---monthly-publication-january-2026.pdf   565 2026-01 Car Nissan Note Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Birchfield Road Birchfield Road Birmingham Birmingham Fixed Penalty N/A   52.5170745 -1.9012542
11072 op-snap---monthly-publication-january-2026.pdf   533 2026-01 Car Nissan Juke White Contravening a Red Traffic Light None A449 Wolverhampton Road Wolverhampton Road Wolverhampton Wolverhampton Education N/A   52.5968709 -2.0954054
11061 op-snap---monthly-publication-january-2026.pdf   522 2026-01 Car Nissan Juke Silver Using a Mobile Phone Whilst Driving None M1 J15 Northhampton M1 J15 Northhampton Out of Force Area Out of Force Area NFA Out of Force      
11039 op-snap---monthly-publication-january-2026.pdf   500 2026-01 Car Nissan X-Trail Black Driving without Due Care and Attention None Portland Road, Smethwick Portland Road, Smethwick Sandwell Sandwell Fixed Penalty N/A      
11008 op-snap---monthly-publication-january-2026.pdf   469 2026-01 Car Nissan Juke Black Driving without Due Care and Attention None Bolton Road at Arthur Street Bolton Road at Arthur Street Birmingham Birmingham Education N/A   52.4667482 -1.8642338
10943 op-snap---monthly-publication-january-2026.pdf   404 2026-01 Car Nissan Juke Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holbrooks Lane Holbrooks Lane Coventry Coventry Warning Letter N/A   52.4423504 -1.5068606
10832 op-snap---monthly-publication-january-2026.pdf   293 2026-01 Car Nissan E-NV200 White Using a Mobile Phone Whilst Driving None Broad Lane Broad Lane Birmingham Birmingham Fixed Penalty N/A   52.4135483 -1.9035033
10686 op-snap---monthly-publication-january-2026.pdf   147 2026-01 Car Nissan Juke Red Cause vehicle to be left in a dangerous position None Washwood Heath Rd Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10648 op-snap---monthly-publication-january-2026.pdf   109 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
10585 op-snap---monthly-publication-january-2026.pdf   46 2026-01 Car Nissan Micra White Driving without Due Care and Attention No Insurance Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
5177 op-snap---monthly-publication-december-2025.pdf   1305 2025-12 Car Nissan PIXO Black Cause vehicle to be left in a dangerous position None Washwood Heath Rd Washwood Heath Road Birmingham Birmingham NFA No Independent Evidence Available   52.4929304 -1.8229092
5176 op-snap---monthly-publication-december-2025.pdf   1304 2025-12 Car Nissan X Trail Grey Cause vehicle to be left in a dangerous position None Washwood Heath Rd Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
5161 op-snap---monthly-publication-december-2025.pdf   1289 2025-12 Car Nissan Qashqai Red Driving without Due Care and Attention None Longmore Road Longmore Road Solihull Solihull Education N/A   52.4078616 -1.8211577
5123 op-snap---monthly-publication-december-2025.pdf   1251 2025-12 Car Nissan Qashqai Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sedgley Road West Sedgley Road West Sandwell Sandwell NFA N/A   52.5296941 -2.0777252
5110 op-snap---monthly-publication-december-2025.pdf   1238 2025-12 Car Nissan Qashqai Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
5069 op-snap---monthly-publication-december-2025.pdf   1197 2025-12 Car Nissan Note Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4911 op-snap---monthly-publication-december-2025.pdf   1039 2025-12 Car Nissan Micra Silver Contravening a Red Traffic Light None New Birmingham Road New Birmingham Road Dudley Dudley Warning Letter N/A   52.5123958 -2.0585145
4900 op-snap---monthly-publication-december-2025.pdf   1028 2025-12 Car Nissan Micra Blue Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
4843 op-snap---monthly-publication-december-2025.pdf   971 2025-12 Car Nissan Pulsar White Using a Mobile Phone Whilst Driving None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Fixed Penalty N/A   52.5038363 -1.8432663
4842 op-snap---monthly-publication-december-2025.pdf   970 2025-12 Car Nissan Qashqai Black Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
4802 op-snap---monthly-publication-december-2025.pdf   930 2025-12 Car Nissan Pulsar Blue Driving without Due Care and Attention None Darley Green Road Darley Green Road Solihull Solihull NFA Outside of 14 Days NIP   52.3639234 -1.7399953
4778 op-snap---monthly-publication-december-2025.pdf   906 2025-12 Car Nissan Qashqai Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
4745 op-snap---monthly-publication-december-2025.pdf   873 2025-12 Car Nissan Juke Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4724 op-snap---monthly-publication-december-2025.pdf   852 2025-12 Car Nissan Qashqai White Driving without Reasonable Consideration None Stafford Rd Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
4642 op-snap---monthly-publication-december-2025.pdf   770 2025-12 Car Nissan Note Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
4603 op-snap---monthly-publication-december-2025.pdf   731 2025-12 Car Nissan Micra White Driving without Due Care and Attention None Parson's Hill and Bells Lane, Kings Parson's Hill and Bells Lane, Kings NBoirrmtoinng.ham Nboirrmtoinng.Ham Education N/A   52.4748473 -2.0066867
4549 op-snap---monthly-publication-december-2025.pdf   677 2025-12 Car Nissan Cube White Contravening a Red Traffic Light None Longmore Road Shirley Longmore Road Shirley Solihull Solihull NFA No Independent Evidence Available   52.4044532 -1.8136222
4540 op-snap---monthly-publication-december-2025.pdf   668 2025-12 Car Nissan Juke Blue Cause vehicle to be left in a dangerous position None Junction of Eddish Rd and Loeless Junction of Eddish Road and Loeless RBdir mingham Rbdir Mingham Warning Letter N/A      
4508 op-snap---monthly-publication-december-2025.pdf   636 2025-12 Car Nissan X-trail Black Contravening a Red Traffic Light None Small Heath Highway Small Heath Highway Birmingham Birmingham NFA No Independent Evidence Available   52.4709298 -1.8722585
4496 op-snap---monthly-publication-december-2025.pdf   624 2025-12 Car Nissan Qashqai White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
4327 op-snap---monthly-publication-december-2025.pdf   455 2025-12 Car Nissan Qashqai Black Contravening a Red Traffic Light None Fletchemstead Highway A45 Fletchemstead Highway A45 Coventry Coventry Warning Letter N/A      
4279 op-snap---monthly-publication-december-2025.pdf   407 2025-12 Car Nissan qashqai Black Cause vehicle to be left in a dangerous position None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4263 op-snap---monthly-publication-december-2025.pdf   391 2025-12 Car Nissan Juke Blue Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Warning Letter N/A   52.4216321 -1.855984
4205 op-snap---monthly-publication-december-2025.pdf   333 2025-12 Car Nissan Juke Yellow 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
4202 op-snap---monthly-publication-december-2025.pdf   330 2025-12 Car Nissan Qashqai White 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
4159 op-snap---monthly-publication-december-2025.pdf   287 2025-12 Car Nissan Qashqai White Driving without Due Care and Attention None Icknield Street Icknield Street Birmingham Birmingham Education N/A   52.5709191 -1.8759339
4136 op-snap---monthly-publication-december-2025.pdf   264 2025-12 Car Nissan Micra Blue Driving without Due Care and Attention None Salford Circus Salford Circus Birmingham Birmingham NFA No Offence   52.5095071 -1.8593732
4095 op-snap---monthly-publication-december-2025.pdf   223 2025-12 Car Nissan Qashqai White Driving without Due Care and Attention none Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
4048 op-snap---monthly-publication-december-2025.pdf   176 2025-12 Car Nissan Qashqai Red Driving without Due Care and Attention None Lytton Way, Stevenage Lytton Way, Stevenage Out of Force Area Out of Force Area NFA Out of Force      
3958 op-snap---monthly-publication-december-2025.pdf   86 2025-12 Car Nissan Note Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Anne Road Anne Road Sandwell Sandwell Warning Letter N/A   52.5001925 -1.9481997
3922 op-snap---monthly-publication-december-2025.pdf   50 2025-12 Car Nissan Qashqai Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
21947 op-snap---monthly-publication-november-2025.pdf   1489 2025-11 Car Nissan Qashqai White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
21901 op-snap---monthly-publication-november-2025.pdf   1443 2025-11 Car Nissan Qashqai White Driving without Due Care and Attention None A449 at Doctors Lane (Kinver) A449 at Doctors Lane (Kinver) 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);