Database Queries – With Microsoft Access

maladam
NHL-Solution.accdb
Home>Information Systems homework help>Database Queries – With Microsoft Access
PID PFname PLname Team_ID Position_ID GP Goals Assists Points PlusMinus Penalties GameWinners OTGoals Shots Shifts FaceOffWinPct Salary
1 Spencer Abbott CHI LW 1 0 0 0 0 0 0 0 1 12.0 0.0 ¤ 575,000.00
2 Justin Abdelkader DET LW 64 7 14 21 -20 50 1 1 104 1397.0 0.29411764705882354 ¤ 5,500,000.00
3 Pontus Aberg NSH LW 15 1 1 2 -2 4 0 0 12 256.0 1.0 ¤ 842,500.00
4 Noel Acciari BOS C 29 2 3 5 3 16 0 0 24 431.0 0.3793103448275862 ¤ 892,500.00
5 Kenny Agostino STL LW 7 1 2 3 0 2 0 0 17 117.0 0.0 ¤ 625,000.00
6 Sebastian Aho CAR RW 82 24 25 49 -1 26 4 1 214 1814.0 0.4857142857142857 ¤ 925,000.00
7 Karl Alzner WSH D 82 3 10 13 23 28 0 0 81 2095.0 0.0 ¤ 2,800,000.00
8 Josh Anderson CBJ RW 78 17 12 29 12 89 3 0 119 1364.0 0.27586206896551724 ¤ 700,000.00
9 Rasmus Andersson CGY D 1 0 0 0 -1 0 0 0 0 23.0 0.0 ¤ 742,500.00
10 Andy Andreoff LAK LW 36 0 2 2 -2 70 0 0 38 527.0 0.5942028985507246 ¤ 600,000.00
11 Sven Andrighetto COL RW 46 7 17 24 1 12 0 0 68 845.0 0.7 ¤ 650,000.00
12 Artem Anisimov CHI C 64 22 23 45 9 30 7 1 105 1401.0 0.4511930585683297 ¤ 5,750,000.00
13 Josh Archibald PIT RW 10 3 0 3 3 4 0 0 11 163.0 0.0 ¤ 667,500.00
14 Joel Armia WPG RW 57 10 9 19 -8 20 1 0 111 1226.0 0.42857142857142855 ¤ 875,000.00
15 Viktor Arvidsson NSH LW 80 31 30 61 16 28 6 1 246 1906.0 0.25 ¤ 640,000.00
16 Andreas Athanasiou DET C 64 18 11 29 -7 28 3 2 120 1204.0 0.4457831325301205 ¤ 575,000.00
17 Cam Atkinson CBJ RW 82 35 27 62 13 22 9 3 240 1966.0 0.6666666666666666 ¤ 3,500,000.00
18 Brady Austin BUF D 5 0 0 0 0 4 0 0 8 126.0 0.0 ¤ 635,000.00
19 Yohann Auvitu NJD D 25 2 2 4 1 2 0 0 54 505.0 0.0 ¤ 792,500.00
20 David Backes BOS RW 74 17 21 38 2 69 2 0 175 1571.0 0.4878048780487805 ¤ 8,000,000.00
21 Mikael Backlund CGY C 81 22 31 53 9 36 7 2 197 1914.0 0.48073022312373226 ¤ 3,575,000.00
22 Nicklas Backstrom WSH C 82 23 63 86 17 38 5 2 162 1842.0 0.5138784696174044 ¤ 7,000,000.00
23 Sven Baertschi VAN LW 68 18 17 35 -6 8 5 0 114 1461.0 1.0 ¤ 1,700,000.00
24 Casey Bailey OTT RW 7 0 0 0 -1 0 0 0 10 78.0 0.0 ¤ 874,125.00
25 Josh Bailey NYI RW 82 13 43 56 5 12 1 1 173 1840.0 0.5333333333333333 ¤ 3,700,000.00
26 Justin Bailey BUF RW 32 2 2 4 0 4 1 0 36 468.0 0.0 ¤ 692,500.00
27 Nicholas Baptiste BUF RW 14 3 1 4 1 6 0 0 17 190.0 0.3333333333333333 ¤ 740,000.00
28 Ivan Barbashev STL C 30 5 7 12 5 2 1 0 20 489.0 0.40096618357487923 ¤ 742,500.00
29 Riley Barber WSH RW 3 0 0 0 0 0 0 0 2 37.0 0.0 ¤ 667,500.00
30 Mark Barberio COL D 60 2 11 13 -5 14 0 0 80 1330.0 0.0 ¤ 800,000.00
31 Aleksander Barkov FLA C 61 21 31 52 13 10 5 2 142 1469.0 0.46529814271749753 ¤ 4,500,000.00
32 Tyson Barrie COL D 74 7 31 38 -34 18 2 0 182 2050.0 0.0 ¤ 5,000,000.00
33 Matt Bartkowski CGY D 24 1 1 2 -4 26 0 0 16 523.0 0.0 ¤ 575,000.00
34 Mathew Barzal NYI C 2 0 0 0 -2 6 0 0 0 32.0 0.46153846153846156 ¤ 925,000.00
35 Cody Bass NSH C 9 0 0 0 -1 19 0 0 1 99.0 0.0 ¤ 575,000.00
36 Jay Beagle WSH C 81 13 17 30 20 22 4 1 100 1587.0 0.5636856368563685 ¤ 1,750,000.00
37 Francois Beauchemin COL D 81 5 13 18 -14 32 1 0 132 2157.0 0.0 ¤ 4,500,000.00
38 Nathan Beaulieu MTL D 74 4 24 28 8 44 1 0 118 1742.0 0.0 ¤ 1,000,000.00
39 Anthony Beauvillier NYI C 66 9 15 24 1 10 2 0 101 1135.0 0.41414141414141414 ¤ 925,000.00
40 Taylor Beck EDM LW 5 0 0 0 -3 4 0 0 5 70.0 0.0 ¤ 650,000.00
41 Matt Beleskey BOS LW 49 3 5 8 -10 47 0 0 79 880.0 0.4142857142857143 ¤ 4,000,000.00
42 Pierre-Edouard Bellemare PHI LW 82 4 4 8 -1 20 0 0 90 1552.0 0.48375451263537905 ¤ 725,000.00
43 Jamie Benn DAL LW 77 26 43 69 -9 66 4 2 201 2085.0 0.5145631067961165 ¤ 5,750,000.00
44 Jordie Benn DAL D 71 4 13 17 -4 28 1 0 68 1812.0 0.0 ¤ 1,100,000.00
45 Beau Bennett NJD RW 65 8 11 19 -3 20 1 0 101 1152.0 0.1875 ¤ 725,000.00
46 Sam Bennett CGY C 81 13 13 26 -16 75 0 0 122 1613.0 0.46115906288532676 ¤ 925,000.00
47 Matthew Benning EDM D 62 3 12 15 8 29 0 0 69 1399.0 0.0 ¤ 925,000.00
48 Patrice Bergeron BOS C 79 21 32 53 12 24 7 0 302 1939.0 0.6009933774834437 ¤ 8,750,000.00
49 Patrik Berglund STL C 82 23 11 34 -7 32 5 1 153 1912.0 0.49957228400342174 ¤ 3,700,000.00
50 Christoph Bertschy MIN C 5 0 1 1 0 4 0 0 5 65.0 0.0 ¤ 742,500.00
51 Tyler Bertuzzi DET LW 7 0 0 0 -1 0 0 0 3 90.0 0.5 ¤ 667,500.00
52 Bryan Bickell CAR LW 11 1 0 1 -4 4 1 0 8 160.0 0.0
53 Alex Biega VAN D 36 0 3 3 -4 18 0 0 37 701.0 0.0 ¤ 700,000.00
54 Kevin Bieksa ANA D 81 3 11 14 0 63 1 0 94 1802.0 0.0 ¤ 4,000,000.00
55 Anthony Bitetto NSH D 29 0 7 7 -1 25 0 0 17 513.0 0.0 ¤ 575,000.00
56 Oliver Bjorkstrand CBJ RW 26 6 7 13 4 6 2 0 55 483.0 1.0 ¤ 600,000.00
57 Nick Bjugstad FLA C 54 7 7 14 -19 22 1 0 91 984.0 0.47570332480818417 ¤ 3,350,000.00
58 Joseph Blandisi NJD LW 27 3 6 9 -10 26 2 1 24 490.0 0.44970414201183434 ¤ 715,000.00
59 Anton Blidh BOS LW 19 1 1 2 -2 7 0 0 26 237.0 0.0 ¤ 792,500.00
60 Mike Blunden OTT RW 2 0 0 0 0 4 0 0 1 22.0 0.0 ¤ 725,000.00
61 Mikkel Boedker SJS LW 81 10 16 26 0 10 2 0 122 1713.0 0.2777777777777778 ¤ 5,200,000.00
62 Brock Boeser VAN RW 9 4 1 5 0 0 1 0 25 188.0 0.0 ¤ 925,000.00
63 Zach Bogosian BUF D 56 2 9 11 -17 46 1 1 73 1424.0 0.0 ¤ 5,250,000.00
64 Jared Boll ANA RW 51 0 3 3 -3 87 0 0 13 495.0 0.0 ¤ 900,000.00
65 Nick Bonino PIT C 80 18 19 37 -5 16 1 0 142 1883.0 0.47980214344600164 ¤ 2,100,000.00
66 Mark Borowiecki OTT D 70 1 2 3 -3 154 0 0 50 1559.0 1.0 ¤ 1,100,000.00
67 Robert Bortuzzo STL D 38 1 3 4 11 15 0 0 45 865.0 0.0 ¤ 1,050,000.00
68 Reid Boucher VAN C 39 6 4 10 -6 8 0 0 70 621.0 0.0 ¤ 715,000.00
69 Lance Bouma CGY C 61 3 4 7 -2 35 1 0 53 1044.0 0.3333333333333333 ¤ 2,200,000.00
70 Michael Bournival TBL LW 19 2 1 3 -3 2 0 0 25 287.0 0.3333333333333333 ¤ 575,000.00
71 Gabriel Bourque COL LW 6 0 0 0 0 0 0 0 4 103.0 0.0 ¤ 800,000.00
72 Rene Bourque COL RW 65 12 6 18 -19 56 2 1 112 1229.0 0.0 ¤ 650,000.00
73 Jay Bouwmeester STL D 81 1 14 15 6 28 0 0 106 2366.0 0.0 ¤ 5,600,000.00
74 Johnny Boychuk NYI D 66 6 17 23 11 19 2 0 155 1576.0 1.0 ¤ 7,000,000.00
75 Brian Boyle TOR C 75 13 12 25 3 66 2 0 131 1386.0 0.5215146299483648 ¤ 2,000,000.00
76 Tyler Bozak TOR C 78 18 37 55 -1 30 1 0 145 1772.0 0.5666178623718887 ¤ 4,500,000.00
77 Derick Brassard OTT C 81 14 25 39 12 24 3 0 195 1822.0 0.4995918367346939 ¤ 5,000,000.00
78 Justin Braun SJS D 81 4 9 13 1 28 0 0 95 2108.0 0.0 ¤ 3,800,000.00
79 T.J. Brodie CGY D 82 6 30 36 -16 24 2 1 78 2379.0 0.0 ¤ 4,838,000.00
80 Jonas Brodin MIN D 68 3 22 25 5 20 2 0 85 1694.0 0.0 ¤ 4,000,000.00
81 Kyle Brodziak STL C 69 8 7 15 2 27 2 0 55 1241.0 0.4946401225114854 ¤ 1,000,000.00
82 Jonny Brodzinski LAK C 6 0 2 2 2 2 0 0 17 98.0 0.0 ¤ 925,000.00
83 Troy Brouwer CGY RW 74 13 12 25 -11 31 2 0 87 1610.0 0.3125 ¤ 4,500,000.00
84 Connor Brown TOR RW 82 20 16 36 3 10 4 0 139 1940.0 0.25 ¤ 650,000.00
85 Dustin Brown LAK RW 80 14 22 36 -4 22 1 0 175 1729.0 0.4 ¤ 7,000,000.00
86 J.T. Brown TBL RW 64 3 3 6 -7 73 1 0 67 962.0 0.3157894736842105 ¤ 1,250,000.00
87 Patrick Brown CAR C 14 0 0 0 -6 0 0 0 12 189.0 0.6 ¤ 650,000.00
88 Pavel Buchnevich NYR RW 41 8 12 20 6 13 0 0 55 773.0 0.14285714285714285 ¤ 925,000.00
89 Andre Burakovsky WSH LW 64 12 23 35 13 14 1 0 111 1054.0 0.2857142857142857 ¤ 832,500.00
90 Erik Burgdoerfer BUF D 2 0 0 0 -1 0 0 0 2 34.0 0.0 ¤ 575,000.00
91 Alex Burmistrov WPG C 49 5 11 16 -7 12 0 0 45 834.0 0.4073226544622426 ¤ 1,600,000.00
92 Brent Burns SJS D 82 29 47 76 19 40 6 3 321 2295.0 0.0 ¤ 5,760,000.00
93 Alex Burrows VAN LW 75 15 16 31 3 62 2 0 143 1587.0 0.35714285714285715 ¤ 3,000,000.00
94 Chris Butler STL D 1 0 0 0 0 0 0 0 1 26.0 0.0 ¤ 600,000.00
95 Dustin Byfuglien WPG D 80 13 39 52 10 117 1 0 241 2327.0 0.0 ¤ 8,000,000.00
96 Paul Byron MTL LW 81 22 21 43 21 29 6 1 96 1849.0 0.6666666666666666 ¤ 1,300,000.00
97 Drake Caggiula EDM LW 60 7 11 18 3 16 2 0 93 1091.0 0.4119718309859155 ¤ 925,000.00
98 Mitch Callahan DET RW 4 0 0 0 0 0 0 0 2 42.0 0.0 ¤ 600,000.00
99 Ryan Callahan TBL RW 18 2 2 4 -4 23 1 0 22 351.0 0.5555555555555556 ¤ 6,500,000.00
100 Matt Calvert CBJ LW 65 10 5 15 -4 48 1 0 92 1230.0 0.125 ¤ 2,200,000.00
101 Mike Cammalleri NJD LW 61 10 21 31 -9 21 3 1 142 1282.0 0.6071428571428571 ¤ 5,000,000.00
102 Brian Campbell CHI D 80 5 12 17 12 24 1 0 75 1896.0 0.0 ¤ 1,500,000.00
103 Patrick Cannone MIN C 3 0 0 0 0 0 0 0 2 35.0 0.5238095238095238 ¤ 600,000.00
104 Paul Carey WSH C 6 0 0 0 -2 0 0 0 8 82.0 0.0 ¤ 575,000.00
105 Matt Carle NSH D 6 0 1 1 -1 0 0 0 2 107.0 0.0
106 Brandon Carlo BOS D 82 6 10 16 9 59 0 0 88 2080.0 0.0 ¤ 717,500.00
107 John Carlson WSH D 72 9 28 37 7 10 3 0 180 1916.0 0.0 ¤ 4,000,000.00
108 Gabriel Carlsson CBJ D 2 0 1 1 -2 0 0 0 3 46.0 0.0 ¤ 925,000.00
109 Ryan Carpenter SJS C 11 2 2 4 5 4 0 0 20 179.0 0.4533333333333333 ¤ 600,000.00
110 Daniel Carr MTL LW 33 2 7 9 4 6 1 0 44 511.0 0.6666666666666666 ¤ 725,000.00
111 Connor Carrick TOR D 67 2 6 8 8 51 0 0 89 1493.0 0.0 ¤ 650,000.00
112 Alex Carrier NSH D 2 0 0 0 1 0 0 0 1 33.0 0.0 ¤ 640,000.00
113 William Carrier BUF LW 41 5 3 8 -1 21 1 0 50 583.0 0.5 ¤ 650,000.00
114 Jeff Carter LAK C 82 32 34 66 2 41 9 4 250 1920.0 0.519434628975265 ¤ 7,000,000.00
115 Cody Ceci OTT D 79 2 15 17 -11 20 0 0 143 2418.0 1.0 ¤ 2,250,000.00
116 Peter Cehlarik BOS LW 11 0 2 2 0 0 0 0 8 197.0 0.6666666666666666 ¤ 692,500.00
117 Thomas Chabot OTT D 1 0 0 0 -2 0 0 0 1 13.0 0.0 ¤ 925,000.00
118 Michael Chaput VAN C 68 4 5 9 -12 29 0 0 64 1115.0 0.5272727272727272 ¤ 600,000.00
119 Zdeno Chara BOS D 75 9 19 29 18 59 0 0 135 1958.0 0.0 ¤ 5,000,000.00
120 Ben Chiarot WPG D 59 2 10 12 2 33 0 0 49 1166.0 0.0 ¤ 850,000.00
121 Alex Chiasson CGY RW 81 12 12 24 -6 46 1 0 104 1501.0 0.2413793103448276 ¤ 800,000.00
122 Jason Chimera NYI LW 82 20 13 33 1 40 2 0 121 1545.0 0.47058823529411764 ¤ 2,000,000.00
123 Taylor Chorney WSH D 18 1 4 5 8 11 1 0 19 346.0 0.0 ¤ 775,000.00
124 Jakob Chychrun ARI D 68 7 13 20 -14 47 0 0 86 1470.0 0.0 ¤ 925,000.00
125 Casey Cizikas NYI C 59 8 17 25 9 30 1 0 82 1254.0 0.49645390070921985 ¤ 2,500,000.00
126 Fredrik Claesson OTT D 33 3 8 11 5 4 0 0 25 615.0 0.0 ¤ 700,000.00
127 Adam Clendening NYR D 31 2 9 11 3 17 0 0 38 658.0 0.0 ¤ 600,000.00
128 Kyle Clifford LAK LW 73 6 6 12 -2 92 0 0 122 1101.0 0.4 ¤ 1,250,000.00
129 Cal Clutterbuck NYI RW 66 5 15 20 2 28 1 0 115 1395.0 0.375 ¤ 3,500,000.00
130 Braydon Coburn TBL D 80 5 7 12 -1 50 0 0 102 1757.0 0.0 ¤ 3,700,000.00
131 Andrew Cogliano ANA LW 82 16 19 35 11 26 2 0 179 1883.0 0.4444444444444444 ¤ 3,100,000.00
132 Joe Colborne COL C 62 4 4 8 -21 34 0 0 48 942.0 0.38461538461538464 ¤ 2,500,000.00
133 Ian Cole PIT D 81 5 21 26 26 72 1 0 89 2109.0 0.0 ¤ 2,300,000.00
134 Blake Coleman NJD C 23 1 1 2 -7 27 0 0 29 398.0 0.4247787610619469 ¤ 692,500.00
135 Blake Comeau COL LW 77 8 12 20 -19 58 1 0 103 1585.0 0.4634146341463415 ¤ 2,400,000.00
136 J.T. Compher COL LW 21 3 2 5 0 4 1 0 30 415.0 0.47560975609756095 ¤ 925,000.00
137 Cory Conacher TBL C 11 1 3 4 0 4 0 0 16 194.0 0.5 ¤ 575,000.00
138 Erik Condra TBL RW 13 0 0 0 -4 4 0 0 8 174.0 1.0 ¤ 1,250,000.00
139 Kevin Connauton ARI D 24 0 1 1 -1 24 0 0 21 443.0 0.0 ¤ 950,000.00
140 Brett Connolly WSH RW 66 15 8 23 20 40 3 0 81 964.0 0.2857142857142857 ¤ 850,000.00
141 Kyle Connor WPG LW 20 2 3 5 -7 4 1 0 24 327.0 0.5 ¤ 925,000.00
142 Andrew Copp WPG C 64 9 8 17 8 18 1 0 77 1198.0 0.4947916666666667 ¤ 925,000.00
143 Frank Corrado TOR D 4 0 0 0 -1 8 0 0 3 67.0 0.0 ¤ 600,000.00
144 Nick Cousins PHI C 60 6 10 16 -6 31 0 0 99 1006.0 0.41013824884792627 ¤ 840,000.00
145 Logan Couture SJS C 73 25 27 52 11 12 3 0 174 1780.0 0.3944223107569721 ¤ 6,000,000.00
146 Sean Couturier PHI C 66 14 20 34 12 33 2 0 120 1635.0 0.550656660412758 ¤ 3,750,000.00
147 Charlie Coyle MIN C 82 18 38 56 13 36 5 0 159 1721.0 0.4596774193548387 ¤ 2,600,000.00
148 Adam Cracknell DAL RW 69 10 6 16 9 12 2 0 87 1091.0 0.4576271186440678 ¤ 600,000.00
149 Joseph Cramarossa VAN C 59 4 6 10 0 60 1 0 36 882.0 0.8571428571428571 ¤ 724,500.00
150 Sidney Crosby PIT C 75 44 45 89 17 24 5 1 255 1852.0 0.4816933638443936 ¤ 10,900,000.00
151 Lawson Crouse ARI LW 72 5 7 12 -20 48 2 0 84 1212.0 0.5 ¤ 925,000.00
152 Matt Cullen PIT C 72 13 18 31 4 30 2 0 95 1523.0 0.5122235157159488 ¤ 1,000,000.00
153 Austin Czarnik BOS C 49 5 8 13 -10 12 1 0 66 909.0 0.42857142857142855 ¤ 842,500.00
154 Klas Dahlbeck CAR D 43 2 4 6 -12 30 0 0 37 813.0 0.0 ¤ 750,000.00
155 Trevor Daley PIT D 56 5 14 19 7 37 0 0 84 1577.0 0.0 ¤ 2,700,000.00
156 Zac Dalpe MIN C 9 1 2 3 0 9 0 0 8 121.0 0.4576271186440678 ¤ 600,000.00
157 Phillip Danault MTL LW 82 13 27 40 5 35 3 1 133 1799.0 0.5169738118331717 ¤ 875,000.00
158 Marko Dano WPG C 38 4 7 11 0 10 0 0 44 589.0 0.25 ¤ 925,000.00
159 Laurent Dauphin ARI C 24 2 1 3 -2 12 1 0 32 384.0 0.45121951219512196 ¤ 767,500.00
160 Brandon Davidson MTL D 38 0 3 3 -2 20 0 0 42 822.0 0.0 ¤ 1,300,000.00
161 Calvin de Haan NYI D 82 5 20 25 15 36 1 0 116 1866.0 0.0 ¤ 2,900,000.00
162 Jacob De la Rose MTL LW 9 0 0 0 -3 4 0 0 4 156.0 0.5 ¤ 925,000.00
163 Jean-Sebastien Dea PIT C 1 0 0 0 0 2 0 0 1 21.0 0.5 ¤ 575,000.00
164 Anthony Deangelo ARI D 39 5 9 14 -13 37 1 0 60 815.0 0.0 ¤ 925,000.00
165 Danny DeKeyser DET D 82 4 8 12 -22 33 2 1 85 2344.0 0.0 ¤ 4,000,000.00
166 Michael Del Zotto PHI D 51 6 12 18 -5 28 0 0 92 1314.0 0.0 ¤ 4,000,000.00
167 Dylan Demelo SJS D 25 1 7 8 2 14 0 0 32 537.0 0.0 ¤ 600,000.00
168 Jason Demers FLA D 81 9 19 28 -14 53 2 0 98 2019.0 0.0 ¤ 5,500,000.00
169 David Desharnais MTL C 49 6 8 14 4 12 1 0 46 860.0 0.5120481927710844 ¤ 3,500,000.00
170 Andrew Desjardins CHI LW 46 0 1 1 -6 22 0 0 46 607.0 0.5652173913043478 ¤ 800,000.00
171 Nicolas Deslauriers BUF LW 42 0 2 2 -6 38 0 0 26 420.0 0.0 ¤ 775,000.00
172 Simon Despres ANA D 1 0 0 0 0 0 0 0 1 19.0 0.0 ¤ 2,600,000.00
173 Phillip Di Giuseppe CAR LW 36 1 6 7 -12 15 1 1 68 621.0 0.0 ¤ 867,500.00
174 Jason Dickinson DAL C 10 2 0 2 -3 0 0 0 9 173.0 0.3076923076923077 ¤ 925,000.00
175 Chris Didomenico OTT C 3 0 0 0 0 6 0 0 5 47.0 0.6666666666666666 ¤ 575,000.00
176 Brenden Dillon SJS D 81 2 8 10 -2 60 0 0 86 1795.0 0.0 ¤ 2,750,000.00
177 Shane Doan ARI RW 74 6 21 27 -3 48 0 0 144 1392.0 0.4723618090452261 ¤ 3,876,134.00
178 Max Domi ARI LW 59 9 29 38 -9 40 1 0 108 1233.0 0.5 ¤ 832,500.00
179 Joonas Donskoi SJS RW 61 6 11 17 -5 10 0 0 95 1204.0 0.5 ¤ 925,000.00
180 Derek Dorsett VAN RW 14 1 3 4 -6 33 0 0 24 221.0 1.0 ¤ 2,500,000.00
181 Jake Dotchin TBL D 35 0 11 11 10 35 0 0 50 813.0 0.0 ¤ 615,000.00
182 Drew Doughty LAK D 82 12 32 44 8 46 1 1 181 2657.0 1.0 ¤ 7,450,000.00
183 Nic Dowd LAK C 70 6 16 22 -15 25 2 1 78 1230.0 0.4780763790664781 ¤ 630,000.00
184 Justin Dowling DAL C 9 0 2 2 0 2 0 0 11 144.0 0.5507246376811594 ¤ 625,000.00
185 Leon Draisaitl EDM C 82 29 48 77 7 20 5 3 173 1865.0 0.4897119341563786 ¤ 925,000.00
186 Jonathan Drouin TBL LW 73 21 32 53 -13 16 6 1 183 1538.0 0.43636363636363634 ¤ 832,500.00
187 Brandon Dubinsky CBJ C 80 12 29 41 16 91 5 1 115 1954.0 0.5174731182795699 ¤ 5,850,000.00
188 Matt Duchene COL C 77 18 23 41 -34 12 3 1 160 1797.0 0.6256830601092896 ¤ 6,000,000.00
189 Anthony Duclair ARI LW 58 5 10 15 -7 14 1 0 76 1049.0 0.5 ¤ 832,500.00
190 Matt Dumba MIN D 76 11 23 34 15 59 1 1 131 1855.0 0.0 ¤ 2,350,000.00
191 Gabriel Dumont TBL C 39 2 2 4 1 29 0 0 34 572.0 0.5495867768595041 ¤ 575,000.00
192 Brian Dumoulin PIT D 70 1 14 15 0 14 0 0 78 1959.0 0.0 ¤ 800,000.00
193 Christian Dvorak ARI C 78 15 18 33 7 22 1 0 88 1533.0 0.46819085487077533 ¤ 792,500.00
194 Ryan Dzingel OTT LW 81 14 18 32 7 30 1 0 123 1562.0 0.3 ¤ 750,000.00
195 Cody Eakin DAL C 60 3 9 12 -7 49 1 0 82 1470.0 0.5234765234765235 ¤ 3,850,000.00
196 Patrick Eaves DAL RW 79 32 19 51 -2 24 2 0 209 1830.0 0.5 ¤ 1,000,000.00
197 Jordan Eberle EDM RW 82 20 31 51 3 16 0 0 208 1781.0 0.5 ¤ 6,000,000.00
198 Alex Edler VAN D 68 6 15 21 -20 36 0 0 138 1931.0 0.6666666666666666 ¤ 6,000,000.00
199 Joel Edmundson STL D 69 3 12 15 11 60 1 0 81 1777.0 0.0 ¤ 900,000.00
200 Nikolaj Ehlers WPG LW 82 25 39 64 1 38 4 0 204 1845.0 0.0 ¤ 925,000.00
201 Jack Eichel BUF C 61 24 33 57 -13 22 4 1 249 1343.0 0.38944723618090454 ¤ 925,000.00
202 Aaron Ekblad FLA D 68 10 11 21 -23 58 2 1 225 1618.0 0.0 ¤ 925,000.00
203 Mattias Ekholm NSH D 82 3 20 23 4 34 1 0 120 2330.0 0.0 ¤ 3,000,000.00
204 Oliver Ekman-Larsson ARI D 79 12 27 39 -25 48 1 1 145 2332.0 0.0 ¤ 6,000,000.00
205 Remi Elie DAL LW 18 1 6 7 5 8 0 0 15 396.0 1.0 ¤ 767,500.00
206 Lars Eller WSH C 81 12 13 25 15 36 2 0 115 1501.0 0.4711211778029445 ¤ 4,250,000.00
207 Ryan Ellis NSH D 71 16 22 38 17 29 3 0 140 2028.0 0.0 ¤ 2,500,000.00
208 Alexei Emelin MTL D 76 2 8 10 1 71 0 0 82 1980.0 0.0 ¤ 4,200,000.00
209 Deryk Engelland CGY D 81 4 12 16 2 85 2 0 107 1943.0 1.0 ¤ 2,750,000.00
210 Andreas Englund OTT D 5 0 0 0 -3 2 0 0 3 85.0 0.0 ¤ 742,500.00
211 Tyler Ennis BUF LW 51 5 8 13 -10 12 1 0 89 809.0 0.1875 ¤ 3,650,000.00
212 Tobias Enstrom WPG D 60 1 13 14 -7 42 0 0 46 1645.0 0.0 ¤ 5,750,000.00
213 Jonathan Ericsson DET D 51 1 8 9 -2 63 0 0 43 1338.0 0.0 ¤ 4,250,000.00
214 Loui Eriksson VAN LW 65 11 13 24 -9 8 1 0 132 1588.0 0.0 ¤ 8,000,000.00
215 Joel Eriksson Ek MIN C 15 3 4 7 1 4 1 0 15 244.0 0.41284403669724773 ¤ 925,000.00
216 Adam Erne TBL LW 26 3 0 3 -9 11 0 0 40 441.0 0.0 ¤ 925,000.00
217 Emerson Etem ANA LW 3 0 0 0 1 2 0 0 0 45.0 0.0 ¤ 775,000.00
218 Robby Fabbri STL C 51 11 18 29 -16 27 0 0 91 1101.0 0.5416666666666666 ¤ 925,000.00
219 Radek Faksa DAL C 80 12 21 33 -6 67 0 0 132 1937.0 0.4828150572831424 ¤ 832,500.00
220 Justin Falk BUF D 52 0 8 8 -3 29 0 0 33 1079.0 0.0 ¤ 650,000.00
221 Bobby Farnham MTL RW 3 0 0 0 0 17 0 0 4 43.0 1.0 ¤ 575,000.00
222 Hudson Fasching BUF RW 10 0 1 1 -1 2 0 0 6 145.0 0.0 ¤ 925,000.00
223 Jesper Fast NYR RW 68 6 15 21 6 16 1 0 56 1409.0 0.38636363636363635 ¤ 1,000,000.00
224 Justin Faulk CAR D 75 17 20 37 -18 32 2 0 225 1987.0 0.0 ¤ 5,500,000.00
225 Mark Fayne EDM D 4 0 2 2 1 0 0 0 4 56.0 0.0 ¤ 3,500,000.00
226 Taylor Fedun BUF D 27 0 7 7 3 16 0 0 24 528.0 0.0 ¤ 600,000.00
227 Eric Fehr TOR C 53 6 5 11 2 14 3 0 62 897.0 0.512987012987013 ¤ 2,000,000.00
228 Micheal Ferland CGY LW 76 15 10 25 -1 50 1 0 106 1291.0 0.42857142857142855 ¤ 900,000.00
229 Kevin Fiala NSH LW 54 11 5 16 1 18 1 0 114 1016.0 0.0 ¤ 925,000.00
230 Vernon Fiddler NSH C 59 2 2 4 -15 66 0 0 48 1070.0 0.5370101596516691 ¤ 1,250,000.00
231 Valtteri Filppula TBL C 79 12 30 42 -1 26 1 0 97 1773.0 0.4784853700516351 ¤ 5,000,000.00
232 Christian Fischer ARI RW 7 3 0 3 0 0 1 0 10 115.0 0.0 ¤ 817,500.00
233 Mike Fisher NSH C 72 18 24 42 1 55 3 0 120 1688.0 0.54921875 ¤ 4,000,000.00
234 Brian Flynn MTL C 51 6 4 10 2 4 0 0 47 966.0 0.46308724832214765 ¤ 950,000.00
235 Marcus Foligno BUF LW 80 13 10 23 -1 73 0 0 97 1592.0 0.2 ¤ 2,250,000.00
236 Nick Foligno CBJ LW 79 26 25 51 -4 55 5 1 185 1854.0 0.4606741573033708 ¤ 5,500,000.00
237 Christian Folin MIN D 51 2 6 8 10 26 0 0 39 1034.0 0.0 ¤ 850,000.00
238 Derek Forbort LAK D 82 2 16 18 8 54 0 0 100 2221.0 1.0 ¤ 650,000.00
239 Jakob Forsbacka Karlsson BOS C 1 0 0 0 0 0 0 0 0 13.0 0.5 ¤ 900,000.00
240 Filip Forsberg NSH LW 82 31 27 58 -4 32 9 1 234 2080.0 0.2777777777777778 ¤ 6,000,000.00
241 Gustav Forsling CHI D 38 2 3 5 3 4 0 0 48 734.0 0.0 ¤ 767,500.00
242 Cam Fowler ANA D 80 11 28 39 7 20 3 0 186 2258.0 0.0 ¤ 4,000,000.00
243 Cody Franson BUF D 68 3 16 19 -5 34 0 0 93 1648.0 0.0 ¤ 2,650,000.00
244 Martin Frk CAR RW 2 0 0 0 -3 0 0 0 1 26.0 0.0 ¤ 650,000.00
245 Byron Froese TOR C 6 0 0 0 -3 5 0 0 6 95.0 0.4642857142857143 ¤ 575,000.00
246 Michael Frolik CGY RW 82 17 27 44 13 58 1 1 202 1863.0 0.4482758620689655 ¤ 5,000,000.00
247 Marian Gaborik LAK RW 56 10 11 21 -4 18 3 0 123 1072.0 0.0 ¤ 6,075,000.00
248 Kurtis Gabriel MIN RW 13 0 1 1 0 29 0 0 3 118.0 0.0 ¤ 725,000.00
249 Sam Gagner CBJ C 81 18 32 50 10 22 1 0 179 1428.0 0.4752941176470588 ¤ 650,000.00
250 Alex Galchenyuk MTL C 61 17 27 44 -5 24 6 5 104 1276.0 0.42679127725856697 ¤ 3,100,000.00
251 Brendan Gallagher MTL RW 64 10 19 29 7 39 2 0 187 1353.0 0.40540540540540543 ¤ 4,500,000.00
252 Ryan Garbutt ANA C 27 2 1 3 -3 20 1 0 26 407.0 0.6363636363636364 ¤ 2,000,000.00
253 Jake Gardiner TOR D 82 9 34 43 24 34 2 2 127 2183.0 0.0 ¤ 4,050,000.00
254 Jason Garrison TBL D 70 1 8 9 -8 14 0 0 96 1685.0 0.0 ¤ 3,600,000.00
255 Tyler Gaudet ARI C 4 0 1 1 0 0 0 0 3 71.0 0.4 ¤ 874,125.00
256 Frederick Gaudreau NSH C 9 0 1 1 1 0 0 0 8 118.0 0.3333333333333333 ¤ 595,000.00
257 Johnny Gaudreau CGY LW 72 18 43 61 -7 4 3 1 182 1595.0 0.0 ¤ 6,750,000.00
258 Brendan Gaunce VAN C 57 0 5 5 -2 33 0 0 51 821.0 0.5121951219512195 ¤ 832,500.00
259 Cameron Gaunce PIT D 12 1 3 4 1 13 0 0 8 215.0 0.0 ¤ 575,000.00
260 Frederik Gauthier TOR C 21 2 1 3 2 23 0 0 15 349.0 0.5106382978723404 ¤ 832,500.00
261 Luke Gazdic NJD LW 11 0 0 0 -2 12 0 0 3 113.0 0.0 ¤ 700,000.00
262 Eric Gelinas COL D 27 0 1 1 -4 12 0 0 29 447.0 0.0 ¤ 1,650,000.00
263 Ryan Getzlaf ANA C 74 15 58 73 7 49 3 0 138 1973.0 0.5029644268774703 ¤ 9,250,000.00
264 Tom Gilbert LAK D 18 1 4 5 -4 6 0 0 12 393.0 0.0 ¤ 1,400,000.00
265 Brian Gionta BUF RW 82 15 20 35 -11 22 3 0 149 1687.0 0.4339622641509434 ¤ 3,250,000.00
266 Stephen Gionta NYI RW 26 1 5 6 9 2 0 0 17 432.0 0.4666666666666667 ¤ 575,000.00
267 Mark Giordano CGY D 81 12 27 39 22 59 4 1 151 2364.0 0.0 ¤ 6,750,000.00
268 Dan Girardi NYR D 63 4 11 15 8 16 3 0 56 1669.0 0.0 ¤ 6,000,000.00
269 Zemgus Girgensons BUF C 75 7 9 16 -7 18 0 0 112 1366.0 0.47150259067357514 ¤ 1,150,000.00
270 Claude Giroux PHI C 82 14 44 58 -15 38 3 2 199 2048.0 0.5589244851258581 ¤ 9,000,000.00
271 Tanner Glass NYR LW 11 1 1 2 0 17 0 0 8 187.0 1.0 ¤ 1,000,000.00
272 Luke Glendening DET C 74 3 11 14 -10 26 0 0 76 1459.0 0.5404929577464789 ¤ 675,000.00
273 Nikolay Goldobin VAN RW 14 3 0 3 0 0 1 0 14 226.0 0.0 ¤ 925,000.00
274 Alex Goligoski ARI D 82 6 30 36 -9 28 0 0 112 2356.0 0.0 ¤ 5,375,000.00
275 Cody Goloubef COL D 33 0 5 5 -11 25 0 0 35 760.0 0.0 ¤ 800,000.00
276 Barclay Goodrow SJS RW 3 0 1 1 0 0 0 0 3 54.0 0.0 ¤ 635,000.00
277 Boyd Gordon PHI C 13 1 0 1 -5 2 0 0 8 184.0 0.5581395348837209 ¤ 950,000.00
278 Josh Gorges BUF D 66 1 5 6 -3 50 0 0 40 1723.0 0.0 ¤ 3,900,000.00
279 Shayne Gostisbehere PHI D 76 7 32 39 -21 32 1 0 198 1854.0 0.0 ¤ 925,000.00
280 Yanni Gourde TBL C 20 6 2 8 -1 8 1 1 30 421.0 0.36809815950920244 ¤ 575,000.00
281 Michael Grabner NYR RW 76 27 13 40 22 10 3 0 162 1698.0 0.5384615384615384 ¤ 1,650,000.00
282 Petter Granberg NSH D 10 0 0 0 0 10 0 0 4 131.0 0.0 ¤ 575,000.00
283 Markus Granlund VAN C 69 19 13 32 -19 14 3 1 122 1621.0 0.39603960396039606 ¤ 850,000.00
284 Mikael Granlund MIN C 81 26 43 69 23 12 4 1 177 1919.0 0.48484848484848486 ¤ 3,200,000.00
285 Derek Grant NSH C 46 0 4 4 -5 24 0 0 40 692.0 0.5234375 ¤ 650,000.00
286 Tyler Graovac MIN C 52 7 2 9 7 10 2 0 48 739.0 0.4752186588921283 ¤ 600,000.00
287 Kevin Gravel LAK D 49 1 6 7 3 6 0 0 52 997.0 0.0 ¤ 667,500.00
288 Mike Green DET D 72 14 22 36 -20 40 2 1 125 2042.0 0.0 ¤ 6,000,000.00
289 Andy Greene NJD D 66 4 9 13 -16 8 1 1 83 1875.0 0.0 ¤ 5,000,000.00
290 Matt Greene LAK D 26 1 1 2 3 19 0 0 14 537.0 0.0 ¤ 2,500,000.00
291 A.J. Greer COL LW 5 0 1 1 -2 4 0 0 8 102.0 0.0 ¤ 725,000.00
292 Alex Grenier VAN RW 3 0 0 0 -1 0 0 0 1 29.0 1.0 ¤ 600,000.00
293 Seth Griffith TOR C 24 0 5 5 6 8 0 0 21 421.0 0.25 ¤ 625,000.00
294 Mikhail Grigorenko COL C 75 10 13 23 -14 18 0 0 85 1432.0 0.578125 ¤ 1,300,000.00
295 Rocco Grimaldi COL C 4 0 1 1 -3 2 0 0 11 57.0 0.0 ¤ 925,000.00
296 Nicklas Grossmann CGY D 3 0 0 0 -4 2 0 0 3 66.0 0.0
297 Eric Gryba EDM D 40 2 4 6 -5 65 2 0 45 868.0 0.0 ¤ 950,000.00
298 Matt Grzelcyk BOS D 2 0 0 0 0 2 0 0 4 44.0 0.0 ¤ 792,500.00
299 Radko Gudas PHI D 67 6 17 23 8 93 0 0 113 1739.0 0.0 ¤ 4,000,000.00
300 Erik Gudbranson VAN D 30 1 5 6 -14 18 1 0 40 765.0 0.0 ¤ 3,500,000.00
301 Jake Guentzel PIT C 40 16 17 33 7 10 0 0 81 820.0 0.47058823529411764 ¤ 667,500.00
302 Brendan Guhle BUF D 3 0 0 0 1 0 0 0 4 71.0 0.0 ¤ 667,500.00
303 Carl Gunnarsson STL D 56 0 6 6 -5 4 0 0 32 1159.0 0.0 ¤ 2,900,000.00
304 Denis Gurianov DAL RW 1 0 0 0 -1 0 0 0 0 17.0 0.0
305 Carl Hagelin PIT LW 61 6 16 22 10 16 2 0 128 1334.0 0.5 ¤ 3,667,000.00
306 Robert Hagg PHI D 1 0 0 0 0 0 0 0 5 27.0 0.0 ¤ 925,000.00
307 Ron Hainsey PIT D 72 4 13 17 -8 21 1 1 71 1925.0 0.0 ¤ 2,500,000.00
308 Micheal Haley SJS C 58 2 10 12 6 128 1 0 38 809.0 0.4429530201342282 ¤ 625,000.00
309 Taylor Hall NJD LW 72 20 33 53 -9 32 4 2 238 1628.0 0.4444444444444444 ¤ 6,000,000.00
310 Dan Hamhuis DAL D 79 1 15 16 -7 23 0 0 83 2035.0 0.0 ¤ 4,500,000.00
311 Dougie Hamilton CGY D 81 13 37 50 12 64 5 1 222 2131.0 0.0 ¤ 5,500,000.00
312 Freddie Hamilton CGY C 26 2 0 2 -3 8 1 0 30 365.0 0.5952380952380952 ¤ 575,000.00
313 Travis Hamonic NYI D 49 3 11 14 -21 60 0 0 74 1113.0 0.0 ¤ 4,875,000.00
314 Noah Hanifin CAR D 81 4 25 29 -19 26 1 1 108 1785.0 0.0 ¤ 925,000.00
315 Joel Hanley MTL D 7 0 0 0 -3 4 0 0 5 105.0 0.0 ¤ 600,000.00
316 Markus Hannikainen CBJ LW 10 1 1 2 0 6 0 0 8 135.0 0.0 ¤ 742,500.00
317 Jannik Hansen VAN RW 43 8 12 20 2 34 1 0 73 976.0 0.0 ¤ 3,000,000.00
318 Martin Hanzal MIN C 71 20 19 39 -17 53 2 1 169 1651.0 0.5639705882352941 ¤ 3,500,000.00
319 Shane Harper FLA RW 14 2 1 3 -1 18 0 0 13 193.0 0.0 ¤ 650,000.00
320 Ben Harpur OTT D 6 0 0 0 -1 0 0 0 3 151.0 0.0 ¤ 655,000.00
321 Scott Harrington CBJ D 22 1 2 3 3 10 0 0 16 404.0 0.0 ¤ 632,500.00
322 Ryan Hartman CHI LW 76 19 12 31 13 70 4 1 170 1296.0 0.4032258064516129 ¤ 832,500.00
323 Scott Hartnell CBJ LW 78 13 24 37 14 63 1 0 104 1361.0 0.5 ¤ 5,000,000.00
324 Garnet Hathaway CGY RW 26 1 4 5 0 44 0 0 22 350.0 0.5263157894736842 ¤ 722,500.00
325 Erik Haula MIN C 72 15 11 26 5 28 4 0 134 1389.0 0.5386666666666666 ¤ 1,050,000.00
326 John Hayden CHI LW 12 1 3 4 3 4 0 0 22 208.0 0.0 ¤ 925,000.00
327 Jimmy Hayes BOS RW 58 2 3 5 -3 29 1 0 74 770.0 0.2545454545454545 ¤ 2,300,000.00
328 Kevin Hayes NYR C 76 17 32 49 10 18 4 0 143 1797.0 0.45661157024793386 ¤ 2,600,000.00
329 Victor Hedman TBL D 79 16 56 72 3 47 5 2 166 2201.0 0.0 ¤ 4,250,000.00
330 Tim Heed SJS D 1 0 0 0 0 0 0 0 1 19.0 0.0 ¤ 775,000.00
331 Danton Heinen BOS C 8 0 0 0 -3 2 0 0 7 129.0 0.0 ¤ 767,500.00
332 Seth Helgeson NJD D 9 1 0 1 2 15 0 0 3 177.0 0.0 ¤ 600,000.00
333 Darren Helm DET C 50 8 9 17 -6 20 1 0 98 1089.0 0.5142857142857142 ¤ 5,000,000.00
334 Ales Hemsky DAL RW 15 4 3 7 -1 0 0 0 30 334.0 0.0 ¤ 4,000,000.00
335 Matt Hendricks EDM LW 42 4 3 7 -3 29 1 0 42 684.0 0.5689655172413793 ¤ 1,850,000.00
336 Samuel Henley COL C 1 1 0 1 1 2 0 0 1 10.0 0.0 ¤ 590,000.00
337 Adam Henrique NJD C 82 20 20 40 -20 38 2 1 142 1928.0 0.4818780889621087 ¤ 4,500,000.00
338 Tomas Hertl SJS C 49 10 12 22 -8 14 4 0 100 1170.0 0.5168776371308017 ¤ 2,800,000.00
339 Thomas Hickey NYI D 76 4 16 20 -1 35 2 2 87 1647.0 0.0 ¤ 2,250,000.00
340 Vinnie Hinostroza CHI LW 49 6 8 14 -1 17 2 0 76 766.0 0.39766081871345027 ¤ 667,500.00
341 Niklas Hjalmarsson CHI D 73 5 13 18 12 20 0 0 61 2061.0 0.0 ¤ 4,100,000.00
342 Joshua Ho-Sang NYI RW 21 4 6 10 1 12 0 0 22 395.0 0.0 ¤ 925,000.00
343 Mike Hoffman OTT LW 74 26 35 61 17 51 8 1 224 1585.0 0.5714285714285714 ¤ 3,800,000.00
344 Nick Holden NYR D 80 11 23 34 13 35 2 1 84 2232.0 0.0 ¤ 1,650,000.00
345 Peter Holland TOR C 48 5 7 12 -16 22 0 0 79 793.0 0.4541832669322709 ¤ 1,300,000.00
346 Korbinian Holzer ANA D 32 2 5 7 0 23 0 0 14 577.0 0.0 ¤ 700,000.00
347 Julius Honka DAL D 16 1 4 5 -4 4 1 1 34 346.0 0.0 ¤ 925,000.00
348 Patric Hornqvist PIT RW 70 21 23 44 16 28 6 0 223 1495.0 0.2727272727272727 ¤ 4,750,000.00
349 Bo Horvat VAN C 81 20 32 52 -7 27 1 0 158 2056.0 0.5046728971962616 ¤ 832,500.00
350 Marian Hossa CHI RW 73 26 19 45 7 8 7 3 167 1657.0 0.35714285714285715 ¤ 4,000,000.00
351 Quinton Howden WPG C 5 0 0 0 1 0 0 0 5 71.0 0.0 ¤ 650,000.00
352 Marek Hrivik NYR LW 16 0 2 2 -3 2 0 0 15 241.0 0.4 ¤ 600,000.00
353 Jonathan Huberdeau FLA LW 31 10 16 26 -2 13 2 1 86 697.0 0.4444444444444444 ¤ 4,000,000.00
354 Jiri Hudler DAL RW 32 3 8 11 -3 4 1 0 27 552.0 0.6 ¤ 2,000,000.00
355 Charles Hudon MTL LW 3 0 2 2 1 2 0 0 3 48.0 0.0 ¤ 575,000.00
356 Brad Hunt STL D 12 1 5 6 -1 2 0 0 14 255.0 0.0 ¤ 600,000.00
357 Matt Hunwick TOR D 72 1 18 19 8 18 0 0 73 1770.0 0.0 ¤ 1,200,000.00
358 Ben Hutton VAN D 71 5 14 19 -22 31 1 1 130 1780.0 0.0 ¤ 925,000.00
359 Zach Hyman TOR C 82 10 18 28 2 30 3 0 156 1950.0 0.3793103448275862 ¤ 900,000.00
360 Jarome Iginla LAK RW 80 14 13 27 -30 70 4 1 154 1558.0 0.5333333333333333 ¤ 5,000,000.00
361 Matt Irwin NSH D 74 3 11 14 15 26 1 0 98 1637.0 0.0 ¤ 575,000.00
362 Jaromir Jagr FLA RW 82 16 30 46 2 56 2 0 181 1727.0 0.5 ¤ 4,000,000.00
363 Mark Jankowski CGY C 1 0 0 0 0 0 0 0 0 13.0 0.625 ¤ 925,000.00
364 Calle Jarnkrok NSH C 81 15 16 31 -1 25 1 1 134 1878.0 0.49398907103825135 ¤ 1,700,000.00
365 Dmitrij Jaskin STL RW 51 1 10 11 5 18 0 0 55 830.0 0.5 ¤ 1,000,000.00
366 Boone Jenner CBJ C 82 18 16 34 14 52 4 0 211 1780.0 0.5 ¤ 2,900,000.00
367 Nick Jensen DET D 49 4 9 13 -7 12 0 0 59 1166.0 0.0 ¤ 600,000.00
368 Nicklas Jensen NYR RW 7 0 0 0 -2 0 0 0 8 96.0 0.0 ¤ 600,000.00
369 Ryan Johansen NSH C 82 14 47 61 1 60 3 0 154 1998.0 0.545516304347826 ¤ 6,000,000.00
370 Marcus Johansson WSH LW 82 24 34 58 25 10 5 2 129 1613.0 0.4642857142857143 ¤ 4,250,000.00
371 Stephen Johns DAL D 61 4 6 10 -10 36 1 0 91 1496.0 0.0 ¤ 650,000.00
372 Erik Johnson COL D 46 2 15 17 -6 9 1 1 96 1351.0 0.0 ¤ 6,000,000.00
373 Jack Johnson CBJ D 82 5 18 23 23 32 1 0 116 2296.0 1.0 ¤ 5,000,000.00
374 Tyler Johnson TBL C 66 19 26 45 -5 28 3 1 130 1573.0 0.5196078431372549 ¤ 4,000,000.00
375 Ryan Johnston MTL D 7 0 0 0 -3 4 0 0 3 102.0 0.0 ¤ 692,500.00
376 Jussi Jokinen FLA LW 69 11 17 28 -15 39 2 0 118 1598.0 0.5208333333333334 ¤ 4,000,000.00
377 Jyrki Jokipakka OTT D 41 1 5 6 -4 12 0 0 29 818.0 0.0 ¤ 900,000.00
378 Connor Jones NYI C 4 0 0 0 1 2 0 0 2 65.0 0.6153846153846154 ¤ 575,000.00
379 Seth Jones CBJ D 75 12 30 42 6 24 3 3 152 2247.0 0.0 ¤ 5,400,000.00
380 Josh Jooris NYR RW 54 4 8 12 -2 16 0 0 75 949.0 0.49333333333333335 ¤ 600,000.00
381 Jacob Josefson NJD C 38 1 9 10 -1 16 1 0 44 642.0 0.5175718849840255 ¤ 1,100,000.00
382 Roman Josi NSH D 72 12 37 49 7 18 1 0 218 2076.0 0.0 ¤ 4,250,000.00
383 Tyson Jost COL C 6 1 0 1 -5 0 0 0 9 121.0 0.4 ¤ 900,000.00
384 Tomas Jurco DET LW 29 1 0 1 -12 4 0 0 35 450.0 0.0 ¤ 950,000.00
385 Nazem Kadri TOR C 82 32 29 61 -7 95 6 2 236 1882.0 0.47971781305114636 ¤ 5,000,000.00
386 Sergey Kalinin NJD C 43 2 2 4 -14 15 0 0 38 800.0 0.41379310344827586 ¤ 800,000.00
387 Vladislav Kamenev NSH LW 2 0 0 0 -1 2 0 0 1 27.0 0.46153846153846156 ¤ 742,500.00
388 Steven Kampfer NYR D 11 1 1 2 -2 6 0 0 10 215.0 0.0 ¤ 625,000.00
389 Evander Kane BUF LW 70 28 15 43 -17 113 5 1 260 1574.0 0.45081967213114754 ¤ 6,000,000.00
390 Patrick Kane CHI RW 82 34 55 89 11 32 5 1 292 1910.0 0.13725490196078433 ¤ 13,800,000.00
391 Kasperi Kapanen TOR RW 8 1 0 1 -2 0 0 0 11 137.0 0.0 ¤ 925,000.00
392 Michael Kapla NJD D 5 0 0 0 -1 0 0 0 4 109.0 0.0 ¤ 925,000.00
393 Erik Karlsson OTT D 77 17 54 71 10 28 5 1 218 2425.0 0.0 ¤ 7,000,000.00
394 Melker Karlsson SJS C 67 11 11 22 7 22 1 0 73 1337.0 0.16666666666666666 ¤ 1,850,000.00
395 William Karlsson CBJ C 81 6 19 25 10 10 3 0 96 1587.0 0.453125 ¤ 1,000,000.00
396 Ondrej Kase ANA RW 53 5 10 15 -1 18 2 1 77 935.0 0.14285714285714285 ¤ 645,000.00
397 Zack Kassian EDM RW 79 7 17 24 4 101 0 0 110 1412.0 0.36363636363636365 ¤ 1,500,000.00
398 Bracken Kearns NYI C 2 0 0 0 -1 2 0 0 3 31.0 0.5882352941176471 ¤ 800,000.00
399 Duncan Keith CHI D 80 6 47 53 22 16 2 1 183 2379.0 0.0 ¤ 6,000,000.00
400 Clayton Keller ARI C 3 0 2 2 -3 0 0 0 0 51.0 0.0 ¤ 900,000.00
401 Chris Kelly OTT C 82 5 7 12 -17 23 2 0 86 1445.0 0.44510978043912175 ¤ 900,000.00
402 Adrian Kempe LAK LW 25 2 4 6 -3 6 1 0 32 433.0 0.43790849673202614 ¤ 925,000.00
403 Michal Kempny CHI D 50 2 6 8 1 22 0 0 67 997.0 0.0
404 Nicolas Kerdiles ANA LW 1 0 0 0 1 0 0 0 0 17.0 1.0 ¤ 925,000.00
405 Tanner Kero CHI C 47 6 10 16 15 8 0 0 60 893.0 0.4437367303609342 ¤ 667,500.00
406 Ryan Kesler ANA C 82 22 36 58 8 83 2 0 186 2258.0 0.5738984941438929 ¤ 7,875,000.00
407 Phil Kessel PIT RW 82 23 47 70 3 20 4 1 229 1797.0 0.3333333333333333 ¤ 9,000,000.00
408 Jujhar Khaira EDM LW 10 1 0 1 1 2 1 0 10 137.0 0.3684210526315789 ¤ 832,500.00
409 Alex Killorn TBL LW 81 19 17 36 -9 66 4 0 177 1833.0 0.3333333333333333 ¤ 4,450,000.00
410 Jakub Kindl FLA D 39 0 4 4 -11 28 0 0 41 749.0 0.0 ¤ 3,000,000.00
411 Dwight King MTL LW 80 9 7 16 -2 12 1 0 110 1517.0 0.25 ¤ 2,100,000.00
412 Oscar Klefbom EDM D 82 12 26 38 7 6 3 0 201 2197.0 0.0 ¤ 3,000,000.00
413 Kevin Klein NYR D 60 3 11 14 5 31 0 0 54 1437.0 0.0 ¤ 2,750,000.00
414 John Klingberg DAL D 80 13 36 49 2 34 3 0 124 2209.0 1.0 ¤ 2,750,000.00
415 Slater Koekkoek TBL D 29 0 4 4 -4 8 0 0 27 519.0 0.0 ¤ 832,500.00
416 Mikko Koivu MIN C 80 18 40 58 27 34 4 1 140 2012.0 0.5520894643908181 ¤ 5,400,000.00
417 Leo Komarov TOR C 82 14 18 32 6 31 1 0 114 2067.0 0.4504950495049505 ¤ 2,950,000.00
418 Travis Konecny PHI C 70 11 17 28 -2 49 0 0 133 1330.0 0.0 ¤ 925,000.00
419 Anze Kopitar LAK C 76 12 40 52 -10 28 0 0 150 1877.0 0.5268753691671589 ¤ 14,000,000.00
420 Lauri Korpikoski DAL LW 69 8 12 20 5 10 0 0 108 1324.0 0.0 ¤ 1,000,000.00
421 Kalle Kossila ANA LW 1 0 0 0 0 0 0 0 1 11.0 0.42857142857142855 ¤ 925,000.00
422 Chris Kreider NYR LW 75 28 25 53 6 58 4 1 186 1685.0 0.5555555555555556 ¤ 5,000,000.00
423 David Krejci BOS C 82 23 31 54 -12 26 3 0 158 1794.0 0.5152462861610634 ¤ 7,250,000.00
424 Niklas Kronwall DET D 57 2 11 13 -7 32 0 0 67 1466.0 0.0 ¤ 5,500,000.00
425 Torey Krug BOS D 81 8 43 51 -10 37 1 0 208 2126.0 0.0 ¤ 5,000,000.00
426 Marcus Kruger CHI C 70 5 12 17 7 34 0 0 83 1525.0 0.49105914718019256 ¤ 3,475,000.00
427 Nikita Kucherov TBL RW 74 40 45 85 13 38 7 1 246 1735.0 0.0 ¤ 4,250,000.00
428 Tom Kuhnhackl PIT RW 57 4 12 16 8 18 0 0 49 970.0 0.5 ¤ 590,000.00
429 Brett Kulak CGY D 21 0 3 3 -3 12 0 0 19 415.0 0.0 ¤ 680,000.00
430 Nikolay Kulemin NYI LW 72 12 11 23 3 18 4 0 74 1472.0 0.5185185185185185 ¤ 4,250,000.00
431 Dmitry Kulikov BUF D 47 2 3 5 -26 26 0 0 42 1315.0 0.0 ¤ 4,500,000.00
432 Chris Kunitz PIT LW 71 9 20 29 0 36 3 0 134 1511.0 0.23076923076923078 ¤ 3,550,000.00
433 Sean Kuraly BOS C 8 0 1 1 -1 2 0 0 11 115.0 0.3333333333333333 ¤ 692,500.00
434 Evgeny Kuznetsov WSH C 82 19 40 59 18 46 4 0 170 1667.0 0.43972999035679844 ¤ 3,400,000.00
435 Kevin Labanc SJS RW 55 8 12 20 9 22 2 1 70 1055.0 0.5 ¤ 667,500.00
436 Joseph Labate VAN C 13 0 0 0 -2 21 0 0 5 147.0 1.0 ¤ 680,000.00
437 Andrew Ladd NYI LW 78 23 8 31 -14 45 4 1 142 1656.0 0.4 ¤ 8,000,000.00
438 Paul Ladue LAK D 22 0 8 8 -5 4 0 0 27 472.0 0.0 ¤ 925,000.00
439 Patrik Laine WPG RW 73 36 28 64 7 26 5 1 204 1633.0 0.0 ¤ 925,000.00
440 Anton Lander EDM C 22 1 3 4 2 6 0 0 12 351.0 0.5602836879432624 ¤ 1,050,000.00
441 Gabriel Landeskog COL LW 72 18 15 33 -25 62 2 1 169 1729.0 0.496 ¤ 5,500,000.00
442 Nick Lappin NJD RW 43 4 3 7 -17 17 0 0 57 696.0 0.2857142857142857 ¤ 842,500.00
443 Dylan Larkin DET C 80 17 15 32 -28 37 1 0 178 1715.0 0.4537037037037037 ¤ 925,000.00
444 Philip Larsen VAN D 26 1 5 6 -8 4 0 0 32 546.0 0.0 ¤ 1,025,000.00
445 Adam Larsson EDM D 79 4 15 19 21 55 0 0 85 2055.0 0.0 ¤ 3,000,000.00
446 Jacob Larsson ANA D 4 0 0 0 -1 2 0 0 2 85.0 0.0 ¤ 925,000.00
447 Johan Larsson BUF C 36 6 5 11 -7 20 2 0 49 762.0 0.4896810506566604 ¤ 950,000.00
448 Brian Lashoff DET D 5 0 0 0 -3 0 0 0 1 93.0 0.0 ¤ 650,000.00
449 Scott Laughton PHI C 2 0 0 0 0 0 0 0 4 33.0 0.55 ¤ 832,500.00
450 Curtis Lazar OTT C 37 1 3 4 -8 4 0 0 26 506.0 0.3939393939393939 ¤ 832,500.00
451 Nick Leddy NYI D 81 11 35 46 -3 12 1 0 137 1912.0 0.0 ¤ 4,500,000.00
452 Anders Lee NYI LW 81 34 18 52 9 56 6 0 191 1649.0 0.3888888888888889 ¤ 3,500,000.00
453 Artturi Lehkonen MTL LW 73 18 10 28 -1 8 3 0 158 1488.0 0.5 ¤ 667,500.00
454 Jori Lehtera STL C 64 7 15 22 -6 34 1 0 67 1424.0 0.49158653846153844 ¤ 4,400,000.00
455 Taylor Leier PHI LW 10 1 1 2 -1 4 0 0 7 138.0 0.0 ¤ 768,150.00
456 Josh Leivo TOR LW 13 2 8 10 2 4 0 0 27 246.0 0.5 ¤ 575,000.00
457 Brett Lernout MTL D 2 0 0 0 -1 0 0 0 3 45.0 0.0 ¤ 660,000.00
458 Kris Letang PIT D 41 5 29 34 2 32 2 1 122 1207.0 0.0 ¤ 7,250,000.00
459 Mark Letestu EDM C 78 16 19 35 -2 17 6 1 121 1619.0 0.5044642857142857 ¤ 1,800,000.00
460 Trevor Lewis LAK C 82 12 12 24 -6 30 3 0 145 1567.0 0.4 ¤ 2,000,000.00
461 Mike Liambas NSH LW 1 0 0 0 -1 0 0 0 0 8.0 0.0 ¤ 575,000.00
462 John-Michael Liles BOS D 36 0 5 5 1 4 0 0 36 776.0 1.0 ¤ 2,000,000.00
463 Oscar Lindberg NYR C 65 8 12 20 2 32 1 0 86 1068.0 0.52 ¤ 700,000.00
464 Petteri Lindbohm STL D 7 0 0 0 -4 4 0 0 10 134.0 0.0 ¤ 645,000.00
465 Esa Lindell DAL D 73 6 12 18 8 22 2 1 99 1981.0 0.0 ¤ 802,500.00
466 Anton Lindholm COL D 12 0 0 0 -8 2 0 0 7 245.0 0.0 ¤ 667,500.00
467 Elias Lindholm CAR C 72 11 34 45 -2 16 0 0 151 1743.0 0.5559055118110237 ¤ 2,500,000.00
468 Hampus Lindholm ANA D 66 6 14 20 13 36 2 0 94 1786.0 1.0 ¤ 3,000,000.00
469 Bryan Little WPG C 59 21 26 47 -7 18 3 1 119 1455.0 0.5560619872379216 ¤ 5,000,000.00
470 Matt Lorito DET LW 2 0 1 1 0 0 0 0 6 37.0 0.0
471 Ben Lovejoy NJD D 82 1 6 7 -7 39 1 0 84 2241.0 0.0 ¤ 2,500,000.00
472 Adam Lowry WPG C 82 15 14 29 1 52 1 0 122 1935.0 0.5081081081081081 ¤ 1,000,000.00
473 Milan Lucic EDM LW 82 23 27 50 -3 50 3 0 175 1769.0 0.5714285714285714 ¤ 8,000,000.00
474 Roman Lyubimov PHI LW 47 4 2 6 -2 8 1 0 41 682.0 0.14285714285714285
475 Olli Maatta PIT D 55 1 6 7 17 12 0 0 66 1386.0 0.0 ¤ 4,083,300.00
476 Clarke MacArthur OTT LW 4 0 0 0 -1 0 0 0 5 69.0 0.0 ¤ 4,500,000.00
477 Andrew MacDonald PHI D 73 2 16 18 -5 26 0 0 65 1947.0 0.0 ¤ 4,750,000.00
478 Derek MacKenzie FLA C 82 6 10 16 -7 50 1 0 91 1559.0 0.5 ¤ 1,300,000.00
479 Nathan MacKinnon COL C 82 16 37 53 -14 16 4 2 251 2097.0 0.5055884286653517 ¤ 5,000,000.00
480 Denis Malgin FLA C 47 6 4 10 -5 8 1 1 67 720.0 0.3641304347826087 ¤ 640,000.00
481 Evgeni Malkin PIT C 62 33 39 72 18 77 6 1 192 1416.0 0.4314420803782506 ¤ 9,500,000.00
482 Sean Malone BUF C 1 0 0 0 0 0 0 0 1 15.0 0.625 ¤ 925,000.00
483 Brandon Manning PHI D 65 3 9 12 -12 83 1 0 84 1657.0 0.0 ¤ 950,000.00
484 Josh Manson ANA D 82 5 12 17 14 82 1 0 88 1911.0 0.0 ¤ 825,000.00
485 Anthony Mantha DET RW 60 17 19 36 10 53 3 2 133 1210.0 0.45454545454545453 ¤ 832,500.00
486 Brad Marchand BOS LW 80 39 46 85 18 81 8 1 226 1942.0 0.3611111111111111 ¤ 5,000,000.00
487 Alexey Marchenko TOR D 41 1 7 8 7 12 0 0 36 964.0 0.0 ¤ 1,300,000.00
488 Jonathan Marchessault FLA C 75 30 21 51 -21 38 6 1 193 1567.0 0.45185185185185184 ¤ 750,000.00
489 Martin Marincin TOR D 25 1 6 7 3 16 0 0 22 625.0 0.0 ¤ 1,200,000.00
490 Andrei Markov MTL D 62 6 30 36 18 16 1 0 98 1652.0 0.0 ¤ 4,250,000.00
491 Patrick Marleau SJS LW 82 27 19 46 4 28 6 0 190 1851.0 0.5348837209302325 ¤ 6,500,000.00
492 Mitchell Marner TOR C 77 19 42 61 0 38 5 0 176 1690.0 0.3783783783783784 ¤ 925,000.00
493 Patrick Maroon EDM LW 81 27 15 42 13 95 5 0 178 1715.0 0.4 ¤ 2,000,000.00
494 Matt Martin TOR LW 82 5 4 9 0 123 0 0 66 1117.0 0.0 ¤ 3,500,000.00
495 Paul Martin SJS D 81 4 22 26 10 20 1 0 57 2021.0 0.0 ¤ 5,000,000.00
496 Alec Martinez LAK D 82 9 30 39 -17 24 3 2 144 2431.0 0.0 ¤ 3,900,000.00
497 Jordan Martinook ARI LW 77 11 14 25 -8 40 2 0 109 1686.0 0.44358727097396333 ¤ 625,000.00
498 Andreas Martinsen MTL LW 64 3 4 7 -14 32 0 0 73 955.0 0.75 ¤ 640,000.00
499 Michael Matheson FLA D 81 7 10 17 -5 36 0 0 179 1952.0 1.0 ¤ 925,000.00
500 Auston Matthews TOR C 82 40 29 69 2 14 8 1 279 1894.0 0.46819787985865724 ¤ 925,000.00
501 Shawn Matthias WPG LW 45 8 4 12 0 13 1 0 51 882.0 0.3125 ¤ 2,125,000.00
502 Scott Mayfield NYI D 25 2 7 9 -1 35 0 0 39 430.0 0.0 ¤ 575,000.00
503 Jamie McBain ARI D 3 0 0 0 -1 0 0 0 3 61.0 0.0 ¤ 650,000.00
504 Jake McCabe BUF D 76 3 17 20 -7 26 1 0 79 2036.0 0.0 ¤ 1,250,000.00
505 Jared McCann FLA C 29 1 6 7 -1 4 0 0 44 465.0 0.3904761904761905 ¤ 925,000.00
506 Michael McCarron MTL RW 31 1 4 5 -4 41 0 0 31 453.0 0.4342857142857143 ¤ 832,500.00
507 Jay McClement CAR C 65 5 3 8 -8 18 1 0 37 1120.0 0.4819047619047619 ¤ 1,100,000.00
508 Max McCormick OTT RW 7 0 0 0 -3 0 0 0 7 72.0 0.625 ¤ 650,000.00
509 Ian McCoshen FLA D 3 0 1 1 0 0 0 0 0 52.0 0.0 ¤ 925,000.00
510 Connor McDavid EDM C 82 30 70 100 27 26 6 1 252 1998.0 0.4317617866004963 ¤ 925,000.00
511 Ryan McDonagh NYR D 77 6 36 42 20 37 1 0 153 2275.0 0.0 ¤ 5,000,000.00
512 Colin McDonald PHI RW 3 1 0 1 1 0 0 0 5 37.0 0.0 ¤ 625,000.00
513 Evan McEneny VAN D 1 0 0 0 -1 0 0 0 1 23.0 0.0 ¤ 575,000.00
514 Brock McGinn CAR LW 57 7 9 16 -11 6 1 0 74 1017.0 0.25 ¤ 800,000.00
515 Jamie McGinn ARI LW 72 9 8 17 -23 23 2 0 116 1284.0 0.3333333333333333 ¤ 3,000,000.00
516 Dylan McIlrath NYR D 6 1 0 1 -2 14 0 0 3 76.0 0.0 ¤ 800,000.00
517 Greg McKegg TBL C 46 3 4 7 -3 22 0 0 36 669.0 0.5 ¤ 700,000.00
518 Curtis McKenzie DAL LW 53 6 10 16 5 72 3 0 66 863.0 0.5 ¤ 700,000.00
519 Cody McLeod NSH LW 59 5 1 6 -3 145 0 0 30 662.0 0.0 ¤ 1,250,000.00
520 Brayden McNabb LAK D 49 2 2 4 1 54 0 0 47 1056.0 0.0 ¤ 1,600,000.00
521 Mark McNeill DAL C 1 0 0 0 -1 0 0 0 1 17.0 0.0 ¤ 600,000.00
522 Adam Mcquaid BOS D 77 2 8 10 4 71 1 0 64 1936.0 0.0 ¤ 3,000,000.00
523 Wade Megan STL C 3 1 0 1 1 0 0 0 6 41.0 0.48148148148148145
524 Jaycob Megna ANA D 1 0 0 0 1 0 0 0 0 18.0 0.0 ¤ 925,000.00
525 Jayson Megna VAN C 58 4 4 8 -4 6 0 0 72 1013.0 0.125 ¤ 600,000.00
526 Timo Meier SJS RW 34 3 3 6 1 10 1 0 85 626.0 0.2 ¤ 925,000.00
527 Julian Melchiori WPG D 18 0 2 2 0 8 0 0 15 411.0 0.0 ¤ 600,000.00
528 Jon Merrill NJD D 51 1 5 6 -9 24 0 0 48 1273.0 0.0 ¤ 1,000,000.00
529 Marc Methot OTT D 68 0 12 12 13 24 0 0 69 1878.0 0.0 ¤ 4,900,000.00
530 Milan Michalek TOR LW 5 1 1 2 -2 2 0 0 6 105.0 0.0 ¤ 4,000,000.00
531 Zbynek Michalek ARI D 3 0 0 0 1 0 0 0 3 68.0 0.0 ¤ 3,200,000.00
532 Sonny Milano CBJ LW 4 0 0 0 -3 0 0 0 2 63.0 0.0 ¤ 925,000.00
533 Colin Miller BOS D 61 6 7 13 0 55 0 0 85 1296.0 0.0 ¤ 900,000.00
534 Drew Miller DET LW 55 5 2 7 -12 18 1 0 43 835.0 0.6666666666666666 ¤ 1,025,000.00
535 J.T. Miller NYR LW 82 22 34 56 17 21 6 1 132 1896.0 0.43977591036414565 ¤ 2,750,000.00
536 Kevan Miller BOS D 58 3 10 13 1 50 1 0 49 1354.0 0.0 ¤ 2,500,000.00
537 Garrett Mitchell WSH RW 1 0 0 0 0 0 0 0 0 13.0 0.0 ¤ 600,000.00
538 John Mitchell COL C 65 3 4 7 -12 45 1 0 57 1121.0 0.5539033457249071 ¤ 1,900,000.00
539 Torrey Mitchell MTL C 78 8 9 17 5 38 1 0 68 1542.0 0.5452127659574468 ¤ 1,300,000.00
540 Zack Mitchell MIN RW 11 0 0 0 -1 0 0 0 10 136.0 0.5789473684210527 ¤ 640,000.00
541 Griffen Molino VAN C 5 0 0 0 -2 0 0 0 3 75.0 0.0 ¤ 925,000.00
542 Sean Monahan CGY C 82 27 31 58 -1 20 4 2 199 1835.0 0.5145429362880887 ¤ 6,500,000.00
543 Brandon Montour ANA D 27 2 4 6 11 14 0 0 50 537.0 0.0 ¤ 925,000.00
544 Dominic Moore BOS C 82 11 14 25 2 44 1 0 96 1524.0 0.5458715596330275 ¤ 900,000.00
545 John Moore NJD D 63 12 10 22 -7 39 1 1 102 1673.0 0.0 ¤ 1,750,000.00
546 Samuel Morin PHI D 1 0 0 0 0 0 0 0 2 24.0 0.0 ¤ 832,500.00
547 Josh Morrissey WPG D 82 6 14 20 6 38 3 0 99 2066.0 0.0 ¤ 832,500.00
548 Joe Morrow BOS D 17 0 1 1 -4 8 0 0 19 340.0 0.0 ¤ 800,000.00
549 Tyler Motte CHI LW 33 4 3 7 2 14 0 0 46 579.0 0.4 ¤ 925,000.00
550 Matt Moulson BUF LW 81 14 18 32 -4 10 2 0 134 1162.0 0.25 ¤ 5,000,000.00
551 Mirco Mueller SJS D 4 1 1 2 2 0 0 0 3 56.0 0.0 ¤ 832,500.00
552 Connor Murphy ARI D 77 2 15 17 -13 45 1 1 81 1971.0 0.0 ¤ 2,400,000.00
553 Ryan Murphy CAR D 27 0 2 2 -11 8 0 0 17 453.0 0.0 ¤ 750,000.00
554 Ryan Murray CBJ D 60 2 9 11 3 24 0 0 52 1463.0 0.0 ¤ 2,825,000.00
555 Jake Muzzin LAK D 82 9 19 28 -21 46 1 0 184 2472.0 0.0 ¤ 4,000,000.00
556 Tyler Myers WPG D 11 2 3 5 5 13 0 0 16 294.0 0.0 ¤ 4,000,000.00
557 Jakub Nakladal CAR D 3 0 0 0 -4 0 0 0 3 53.0 0.0
558 Vladislav Namestnikov TBL C 74 10 18 28 -4 31 0 0 115 1398.0 0.4354166666666667 ¤ 1,900,000.00
559 Rick Nash NYR RW 67 23 15 38 9 26 3 0 195 1656.0 0.0 ¤ 8,000,000.00
560 Riley Nash BOS C 81 7 10 17 -1 14 2 0 125 1584.0 0.49110320284697506 ¤ 900,000.00
561 James Neal NSH RW 70 23 18 41 -10 35 5 1 202 1599.0 0.5 ¤ 5,000,000.00
562 Chris Neil OTT RW 53 1 3 4 -11 63 0 0 42 616.0 0.0 ¤ 1,500,000.00
563 Brock Nelson NYI C 81 20 25 45 -6 36 4 1 173 1730.0 0.43742098609355246 ¤ 2,500,000.00
564 Casey Nelson BUF D 11 0 0 0 -3 4 0 0 10 217.0 0.0 ¤ 650,000.00
565 Patrik Nemeth DAL D 40 0 3 3 -4 14 0 0 46 839.0 0.0 ¤ 900,000.00
566 Aaron Ness WSH D 2 0 0 0 -1 0 0 0 0 33.0 0.0 ¤ 575,000.00
567 Nikita Nesterov TBL D 48 4 13 17 0 24 0 0 63 959.0 0.0 ¤ 725,000.00
568 Andrej Nestrasil CAR C 19 1 4 5 -3 2 0 0 27 290.0 0.3 ¤ 950,000.00
569 Nino Niederreiter MIN RW 82 25 32 57 17 53 3 0 186 1617.0 0.0 ¤ 3,500,000.00
570 Frans Nielsen DET C 79 17 24 41 -19 18 0 0 162 1927.0 0.5378912685337727 ¤ 6,000,000.00
571 Matt Nieto SJS LW 59 7 6 13 -12 8 1 0 85 1213.0 0.3333333333333333 ¤ 735,000.00
572 Cristoval Nieves NYR C 1 0 0 0 -1 0 0 0 0 17.0 0.3 ¤ 742,500.00
573 Matt Niskanen WSH D 78 5 34 39 20 32 2 0 154 2030.0 0.0 ¤ 5,750,000.00
574 Stefan Noesen NJD RW 44 8 2 10 6 24 0 0 63 701.0 0.3880597014925373 ¤ 600,000.00
575 Nelson Nogier WPG D 10 0 0 0 -1 5 0 0 8 166.0 0.0 ¤ 650,000.00
576 Jordan Nolan LAK C 46 4 4 8 -3 44 0 0 39 685.0 0.3333333333333333 ¤ 1,000,000.00
577 Joakim Nordstrom CAR LW 82 7 5 12 -12 17 2 0 104 1564.0 0.3103448275862069 ¤ 1,250,000.00
578 Tomas Nosek DET LW 11 1 0 1 -1 2 0 0 19 162.0 0.5441176470588235 ¤ 575,000.00
579 Ryan Nugent-Hopkins EDM C 82 18 25 43 -10 29 4 1 200 1964.0 0.4384858044164038 ¤ 6,000,000.00
580 Darnell Nurse EDM D 44 5 6 11 0 33 0 0 85 962.0 0.0 ¤ 832,500.00
581 Markus Nutivaara CBJ D 66 2 5 7 7 6 0 0 66 1187.0 0.0 ¤ 792,500.00
582 Alex Nylander BUF RW 4 0 1 1 -2 0 0 0 4 62.0 0.0 ¤ 925,000.00
583 William Nylander TOR C 81 22 39 61 -3 32 2 0 205 1766.0 0.4016393442622951 ¤ 925,000.00
584 Gustav Nyquist DET RW 76 12 36 48 0 18 2 0 165 1675.0 0.8 ¤ 4,250,000.00
585 Liam O'Brien WSH C 1 0 0 0 0 0 0 0 0 8.0 0.0 ¤ 630,000.00
586 Rob O'Gara BOS D 3 0 0 0 1 0 0 0 2 68.0 0.0 ¤ 925,000.00
587 Daniel O'Regan SJS C 3 1 0 1 -2 0 0 0 5 46.0 0.46875 ¤ 792,500.00
588 Cal O'Reilly BUF C 11 0 1 1 -6 0 0 0 3 114.0 0.48484848484848486 ¤ 700,000.00
589 Ryan O'Reilly BUF C 72 20 35 55 -1 10 3 0 189 1833.0 0.5801228364042434 ¤ 11,000,000.00
590 Johnny Oduya DAL D 52 2 7 9 -4 18 0 0 37 1333.0 0.0 ¤ 3,750,000.00
591 Jordan Oesterle EDM D 2 0 0 0 -1 0 0 0 2 43.0 0.0 ¤ 585,000.00
592 Kyle Okposo BUF RW 65 19 26 45 -7 24 2 1 156 1443.0 0.5454545454545454 ¤ 8,000,000.00
593 Jamie Oleksiak DAL D 41 5 2 7 -4 37 1 0 33 895.0 0.0 ¤ 918,750.00
594 Steve Oleksy PIT D 11 0 1 1 2 24 0 0 11 215.0 0.0 ¤ 575,000.00
595 Gustav Olofsson MIN D 13 0 3 3 -1 2 0 0 7 221.0 0.0 ¤ 925,000.00
596 Dmitry Orlov WSH D 82 6 27 33 30 51 0 0 125 1917.0 0.0 ¤ 2,570,000.00
597 Brooks Orpik WSH D 79 0 14 14 32 48 0 0 93 1748.0 0.0 ¤ 5,500,000.00
598 T.J. Oshie WSH RW 68 33 23 56 28 36 4 1 143 1490.0 0.48333333333333334 ¤ 4,500,000.00
599 Steve Ott MTL C 53 3 4 7 -8 80 0 0 45 844.0 0.5503597122302158 ¤ 800,000.00
600 Xavier Ouellet DET D 66 3 9 12 2 51 0 0 89 1519.0 0.0 ¤ 715,000.00
601 Alex Ovechkin WSH LW 82 33 36 69 6 50 7 2 313 1737.0 0.0 ¤ 10,000,000.00
602 Magnus Paajarvi STL LW 32 8 5 13 9 6 3 0 51 582.0 0.3333333333333333 ¤ 700,000.00
603 Max Pacioretty MTL LW 81 35 32 67 15 38 7 2 268 2005.0 0.54 ¤ 5,000,000.00
604 Jean-Gabriel Pageau OTT C 82 12 21 33 13 24 2 0 169 1878.0 0.5481335952848723 ¤ 1,100,000.00
605 Iiro Pakarinen EDM RW 14 2 2 4 2 2 1 0 15 205.0 0.0 ¤ 725,000.00
606 Ondrej Palat TBL LW 75 17 35 52 8 39 3 0 162 1807.0 0.2647058823529412 ¤ 4,000,000.00
607 Kyle Palmieri NJD RW 80 26 27 53 2 46 3 0 192 1768.0 0.41379310344827586 ¤ 4,500,000.00
608 Artemi Panarin CHI LW 82 31 43 74 18 21 5 1 211 1817.0 0.2 ¤ 925,000.00
609 Richard Panik CHI RW 82 22 22 44 14 58 5 0 155 1574.0 0.2857142857142857 ¤ 875,000.00
610 Cedric Paquette TBL C 58 4 6 10 -6 80 0 0 68 950.0 0.4608294930875576 ¤ 800,000.00
611 Colton Parayko STL D 81 4 31 35 7 32 2 0 188 2365.0 0.0 ¤ 925,000.00
612 Adam Pardy NSH D 4 0 0 0 -1 6 0 0 4 64.0 0.0 ¤ 575,000.00
613 PA Parenteau NSH RW 67 13 15 28 -18 35 2 0 123 1312.0 0.3 ¤ 1,250,000.00
614 Zach Parise MIN LW 69 19 23 42 -3 30 4 0 194 1541.0 0.6153846153846154 ¤ 9,000,000.00
615 David Pastrnak BOS RW 75 34 36 70 11 34 6 2 262 1597.0 0.6666666666666666 ¤ 925,000.00
616 Greg Pateryn MTL D 36 1 8 9 -1 10 0 0 42 720.0 0.0 ¤ 750,000.00
617 Nick Paul OTT LW 1 0 0 0 -2 0 0 0 4 20.0 0.38461538461538464 ¤ 692,500.00
618 Joe Pavelski SJS C 81 29 39 68 11 34 7 0 233 1964.0 0.5245327102803738 ¤ 6,000,000.00
619 Tanner Pearson LAK LW 80 24 20 44 5 13 5 2 187 1784.0 0.4166666666666667 ¤ 1,550,000.00
620 Matthew Peca TBL C 10 1 1 2 -3 2 0 0 9 159.0 0.4444444444444444 ¤ 925,000.00
621 Adam Pelech NYI D 44 3 7 10 -5 6 0 0 40 868.0 0.0 ¤ 925,000.00
622 Brendan Perlini ARI LW 57 14 7 21 -4 20 2 0 92 1034.0 0.5 ¤ 925,000.00
623 Mathieu Perreault WPG C 65 13 32 45 -11 30 3 0 134 1356.0 0.5132275132275133 ¤ 3,000,000.00
624 David Perron STL LW 82 18 28 46 -2 54 3 1 151 2019.0 0.48484848484848486 ¤ 3,750,000.00
625 Corey Perry ANA RW 82 19 34 53 2 76 3 0 215 1812.0 0.35 ¤ 10,000,000.00
626 Brett Pesce CAR D 82 2 18 20 23 20 0 0 108 2062.0 0.0 ¤ 792,500.00
627 Nic Petan WPG LW 54 1 12 13 -13 12 0 0 57 805.0 0.4603174603174603 ¤ 750,000.00
628 Alex Petrovic FLA D 49 1 13 14 -1 79 0 0 55 1055.0 0.0 ¤ 1,200,000.00
629 Jeff Petry MTL D 80 8 20 28 3 22 1 0 172 2177.0 0.0 ¤ 7,000,000.00
630 Dion Phaneuf OTT D 81 9 21 30 -6 100 2 0 156 2476.0 0.0 ¤ 7,500,000.00
631 Blake Pietila NJD LW 10 0 1 1 -5 4 0 0 9 168.0 0.5111111111111111 ¤ 675,000.00
632 Alex Pietrangelo STL D 80 14 34 48 3 24 4 0 181 2468.0 0.0 ¤ 7,000,000.00
633 Brandon Pirri NYR RW 60 8 10 18 -8 25 3 0 96 1010.0 0.5761316872427984 ¤ 1,100,000.00
634 Tyler Pitlick EDM RW 31 8 3 11 0 6 1 0 54 455.0 0.5333333333333333 ¤ 725,000.00
635 Tomas Plekanec MTL C 78 10 18 28 10 24 3 0 139 1945.0 0.5118343195266272 ¤ 7,000,000.00
636 Brayden Point TBL C 68 18 22 40 4 14 2 0 122 1417.0 0.4473684210526316 ¤ 667,500.00
637 Roman Polak TOR D 75 4 7 11 10 65 1 0 64 1817.0 0.0 ¤ 2,250,000.00
638 Jason Pominville MIN RW 78 13 34 47 2 4 2 0 176 1556.0 0.5 ¤ 6,250,000.00
639 Kevin Porter PIT C 2 0 0 0 -1 0 0 0 0 37.0 0.3684210526315789 ¤ 575,000.00
640 Paul Postma WPG D 65 1 13 14 3 15 0 0 50 995.0 0.0 ¤ 925,000.00
641 Andrew Poturalski CAR C 2 0 0 0 -3 0 0 0 1 34.0 0.5 ¤ 792,500.00
642 Benoit Pouliot EDM LW 67 8 6 14 -5 34 1 0 77 1362.0 0.25 ¤ 4,000,000.00
643 Derrick Pouliot PIT D 11 0 0 0 -4 4 0 0 11 230.0 0.0 ¤ 832,500.00
644 Shane Prince NYI LW 50 5 13 18 -9 18 2 0 71 862.0 0.5714285714285714 ¤ 800,000.00
645 Nate Prosser MIN D 39 2 5 7 0 12 0 0 20 685.0 0.0 ¤ 650,000.00
646 Dalton Prout NJD D 29 0 6 6 -1 44 0 0 13 570.0 0.0 ¤ 1,250,000.00
647 Ivan Provorov PHI D 82 6 24 30 -7 34 1 0 161 2337.0 0.0 ¤ 925,000.00
648 Matt Puempel OTT LW 40 6 3 9 -11 11 1 0 44 583.0 0.0 ¤ 900,000.00
649 Jesse Puljujarvi EDM RW 28 1 7 8 5 10 0 0 41 439.0 0.0 ¤ 925,000.00
650 Teemu Pulkkinen MIN LW 13 2 0 2 -2 6 0 0 10 179.0 0.0 ¤ 812,500.00
651 Ryan Pulock NYI D 1 0 0 0 1 0 0 0 0 5.0 0.0 ¤ 832,500.00
652 Teddy Purcell LAK LW 12 0 2 2 0 0 0 0 10 215.0 1.0 ¤ 1,600,000.00
653 Tom Pyatt OTT LW 82 9 14 23 9 16 1 0 95 1826.0 0.42857142857142855 ¤ 800,000.00
654 Mark Pysyk FLA D 82 4 13 17 0 10 0 0 86 1896.0 0.0 ¤ 1,250,000.00
655 John Quenneville NJD C 12 1 3 4 1 2 0 0 21 224.0 0.0 ¤ 842,500.00
656 Kyle Quincey NJD D 73 6 9 15 4 51 0 0 79 1794.0 0.0 ¤ 1,250,000.00
657 Alan Quine NYI C 61 5 13 18 -2 8 1 0 82 1061.0 0.48 ¤ 575,000.00
658 Alex Radulov MTL RW 76 18 36 54 10 62 2 1 148 1728.0 0.5 ¤ 5,750,000.00
659 Michael Raffl PHI LW 52 8 3 11 -7 20 3 0 63 986.0 0.3 ¤ 2,350,000.00
660 Rickard Rakell ANA C 71 33 18 51 10 12 10 1 177 1574.0 0.4217687074829932 ¤ 3,800,000.00
661 Mikko Rantanen COL RW 75 20 18 38 -25 22 2 1 133 1667.0 0.58 ¤ 925,000.00
662 Victor Rask CAR C 82 16 29 45 -10 16 3 0 186 1863.0 0.49782135076252726 ¤ 4,000,000.00
663 Dennis Rasmussen CHI C 68 4 4 8 -4 12 0 0 77 1256.0 0.44594594594594594 ¤ 575,000.00
664 Ty Rattie STL RW 9 0 2 2 -2 0 0 0 10 139.0 0.0 ¤ 650,000.00
665 Kyle Rau FLA C 24 2 1 3 -3 4 0 0 21 324.0 0.6666666666666666 ¤ 925,000.00
666 Mason Raymond ANA LW 4 0 0 0 -2 0 0 0 3 53.0 0.0
667 Matt Read PHI RW 63 10 9 19 3 8 2 0 92 1219.0 0.3333333333333333 ¤ 4,000,000.00
668 Ryan Reaves STL RW 80 7 6 13 4 104 1 0 58 1078.0 0.0 ¤ 1,125,000.00
669 Zach Redmond MTL D 16 0 5 5 6 2 0 0 12 260.0 0.0 ¤ 575,000.00
670 Mike Reilly MIN D 17 1 0 1 1 2 0 0 19 270.0 0.0 ¤ 925,000.00
671 Sam Reinhart BUF C 79 17 30 47 -11 8 3 0 178 1592.0 0.4095238095238095 ¤ 925,000.00
672 Borna Rendulic VAN RW 1 0 0 0 0 0 0 0 1 7.0 0.0 ¤ 575,000.00
673 Dan Renouf DET D 1 0 0 0 0 0 0 0 1 18.0 0.0 ¤ 692,500.00
674 Mike Ribeiro NSH C 46 4 21 25 -5 14 0 0 38 927.0 0.41216216216216217 ¤ 3,500,000.00
675 Tanner Richard TBL C 3 0 0 0 -2 2 0 0 1 49.0 0.43333333333333335 ¤ 575,000.00
676 Brad Richardson ARI RW 16 5 4 9 -1 15 0 0 25 339.0 0.5260869565217391 ¤ 2,250,000.00
677 Tobias Rieder ARI RW 80 16 18 34 -8 6 1 1 155 1825.0 0.3076923076923077 ¤ 2,000,000.00
678 Morgan Rielly TOR D 76 6 21 27 -20 21 1 1 171 2335.0 0.0 ¤ 5,000,000.00
679 Rasmus Ristolainen BUF D 79 6 39 45 -9 58 2 2 186 2341.0 0.0 ¤ 5,400,000.00
680 Brett Ritchie DAL RW 78 16 8 24 11 38 2 0 167 1484.0 0.5 ¤ 875,000.00
681 Nick Ritchie ANA LW 77 14 14 28 4 62 3 0 149 1456.0 0.5 ¤ 925,000.00
682 Buddy Robinson OTT RW 4 0 0 0 0 2 0 0 4 49.0 0.0 ¤ 750,000.00
683 Anton Rodin VAN RW 3 0 1 1 1 0 0 0 2 40.0 0.0 ¤ 950,000.00
684 Evan Rodrigues BUF LW 30 4 2 6 -7 4 0 0 51 506.0 0.416 ¤ 842,500.00
685 Kevin Rooney NJD C 4 0 0 0 -3 4 0 0 2 56.0 0.37037037037037035 ¤ 625,000.00
686 Jack Roslovic WPG C 1 0 0 0 -1 0 0 0 1 14.0 0.16666666666666666
687 Antoine Roussel DAL LW 60 12 15 27 1 115 3 0 82 1427.0 0.4375 ¤ 2,200,000.00
688 Carter Rowney PIT RW 27 3 4 7 2 4 1 0 24 441.0 0.4797979797979798 ¤ 575,000.00
689 Michal Rozsival CHI D 22 1 2 3 -3 14 1 0 16 464.0 0.0 ¤ 600,000.00
690 Chad Ruhwedel PIT D 34 2 8 10 9 8 0 0 45 806.0 0.0 ¤ 575,000.00
691 Kris Russell EDM D 68 1 12 13 5 23 1 0 68 1862.0 0.0 ¤ 3,100,000.00
692 Robbie Russo DET D 19 0 0 0 2 2 0 0 18 379.0 0.0 ¤ 692,500.00
693 Bryan Rust PIT RW 57 15 13 28 4 8 1 1 110 1131.0 0.4 ¤ 620,000.00
694 Bobby Ryan OTT RW 62 13 12 25 -3 24 0 0 111 1242.0 0.6666666666666666 ¤ 7,000,000.00
695 Derek Ryan CAR C 67 11 18 29 -8 22 3 0 73 1369.0 0.553041018387553 ¤ 600,000.00
696 Brandon Saad CBJ LW 82 24 29 53 23 8 4 0 210 1888.0 0.4444444444444444 ¤ 5,750,000.00
697 Miikka Salomaki NSH RW 5 0 0 0 -1 2 0 0 3 84.0 0.0 ¤ 575,000.00
698 Zach Sanford WSH LW 39 4 4 8 2 10 2 0 36 601.0 0.4358974358974359 ¤ 875,000.00
699 Steven Santini NJD D 38 2 5 7 -6 14 0 0 46 854.0 0.0 ¤ 925,000.00
700 David Savard CBJ D 74 6 17 23 33 44 0 0 135 2056.0 0.0 ¤ 3,500,000.00
701 Luca Sbisa VAN D 82 2 11 13 -1 40 1 0 75 2011.0 0.0 ¤ 3,600,000.00
702 Marco Scandella MIN D 71 4 9 13 -2 25 0 0 88 1677.0 0.0 ¤ 3,750,000.00
703 Colton Sceviour FLA C 80 9 15 24 -16 25 1 0 172 1596.0 0.5344827586206896 ¤ 950,000.00
704 Tim Schaller BOS C 59 7 7 14 -6 23 2 0 89 1035.0 0.49122807017543857 ¤ 600,000.00
705 Mark Scheifele WPG C 79 32 50 82 18 38 5 2 160 1969.0 0.4346338124572211 ¤ 5,000,000.00
706 Brayden Schenn PHI C 79 25 30 55 -13 38 7 2 178 1767.0 0.46963562753036436 ¤ 6,000,000.00
707 Luke Schenn ARI D 78 1 7 8 -9 85 0 0 94 1919.0 0.0 ¤ 1,000,000.00
708 Nikita Scherbak MTL RW 3 1 0 1 1 0 0 0 3 50.0 0.0 ¤ 925,000.00
709 David Schlemko SJS D 62 2 16 18 4 14 1 1 118 1391.0 0.0 ¤ 2,500,000.00
710 Jordan Schmaltz STL D 9 0 2 2 0 4 0 0 5 197.0 0.0 ¤ 925,000.00
711 Nick Schmaltz CHI C 61 6 22 28 10 6 0 0 66 1070.0 0.3088235294117647 ¤ 925,000.00
712 Nate Schmidt WSH D 60 3 14 17 22 16 0 0 60 1188.0 0.0 ¤ 875,000.00
713 Cole Schneider BUF LW 4 0 1 1 2 0 0 0 6 45.0 0.0 ¤ 600,000.00
714 Jordan Schroeder MIN C 37 6 7 13 5 0 0 0 37 483.0 0.475 ¤ 650,000.00
715 Justin Schultz PIT D 78 12 39 51 27 34 1 0 155 2033.0 0.0 ¤ 1,400,000.00
716 Nick Schultz PHI D 28 0 4 4 1 10 0 0 25 636.0 0.0 ¤ 2,250,000.00
717 Jaden Schwartz STL LW 78 19 36 55 14 18 4 1 179 2032.0 0.4785714285714286 ¤ 5,250,000.00
718 Brent Seabrook CHI D 79 3 36 39 5 26 0 0 131 2239.0 0.0 ¤ 9,000,000.00
719 Daniel Sedin VAN LW 82 15 29 44 -16 32 3 1 216 1924.0 0.5 ¤ 7,000,000.00
720 Henrik Sedin VAN C 82 15 35 50 -27 28 4 2 99 1928.0 0.49036918138041735 ¤ 7,000,000.00
721 Lukas Sedlak CBJ C 62 7 6 13 10 25 0 0 57 893.0 0.5237020316027088 ¤ 600,000.00
722 Tyler Seguin DAL C 82 26 46 72 -15 22 4 1 302 1990.0 0.510178117048346 ¤ 6,000,000.00
723 Dennis Seidenberg NYI D 73 5 17 22 25 32 0 0 89 1612.0 0.0 ¤ 1,000,000.00
724 Andrej Sekera EDM D 80 8 27 35 14 18 1 0 128 2160.0 0.0 ¤ 6,500,000.00
725 Mikhail Sergachev MTL D 4 0 0 0 1 0 0 0 2 68.0 0.0 ¤ 925,000.00
726 Tom Sestito PIT LW 13 0 2 2 0 48 0 0 3 126.0 0.0 ¤ 575,000.00
727 Devin Setoguchi LAK RW 45 4 8 12 -5 14 0 0 60 784.0 0.5 ¤ 575,000.00
728 Damon Severson NJD D 80 3 28 31 -31 58 1 0 125 2091.0 0.0 ¤ 600,000.00
729 Michael Sgarbossa FLA C 38 2 7 9 -5 9 0 0 33 626.0 0.4394904458598726 ¤ 600,000.00
730 Patrick Sharp DAL LW 48 8 10 18 -22 31 0 0 146 1073.0 0.47540983606557374 ¤ 5,000,000.00
731 Kevin Shattenkirk WSH D 80 13 43 56 -7 47 2 0 161 2015.0 0.0 ¤ 5,200,000.00
732 Andrew Shaw MTL C 68 12 17 29 4 110 1 1 127 1357.0 0.545662100456621 ¤ 5,500,000.00
733 Logan Shaw ANA C 55 3 7 10 3 10 1 0 59 848.0 0.3793103448275862 ¤ 660,000.00
734 Riley Sheahan DET C 80 2 11 13 -29 14 0 0 109 1575.0 0.5064377682403434 ¤ 2,075,000.00
735 Conor Sheary PIT LW 61 23 30 53 24 22 6 1 156 1290.0 0.0 ¤ 667,500.00
736 Hunter Shinkaruk CGY C 7 0 1 1 -3 2 0 0 5 96.0 0.0 ¤ 832,500.00
737 Devin Shore DAL C 82 13 20 33 -4 14 0 0 115 1664.0 0.4702127659574468 ¤ 867,500.00
738 Drew Shore VAN C 14 0 2 2 -3 4 0 0 11 235.0 0.5352112676056338 ¤ 600,000.00
739 Nick Shore LAK C 70 6 11 17 -2 20 1 0 79 1258.0 0.5020804438280166 ¤ 600,000.00
740 Duncan Siemens COL D 3 0 0 0 -2 2 0 0 2 57.0 0.0 ¤ 874,125.00
741 Jakob Silfverberg ANA RW 79 23 26 49 10 20 5 0 227 1998.0 0.14285714285714285 ¤ 3,000,000.00
742 Wayne Simmonds PHI RW 82 31 23 54 -18 122 4 1 224 2049.0 0.47058823529411764 ¤ 4,300,000.00
743 Dominik Simon PIT C 2 0 1 1 -1 0 0 0 2 41.0 0.0 ¤ 667,500.00
744 Dillon Simpson EDM D 3 0 0 0 0 2 0 0 2 50.0 0.0 ¤ 925,000.00
745 Colton Sissons NSH C 58 8 2 10 11 12 1 0 42 981.0 0.5 ¤ 575,000.00
746 Jack Skille VAN RW 55 5 4 9 0 12 0 0 73 733.0 1.0 ¤ 700,000.00
747 Jeff Skinner CAR LW 79 37 26 63 -3 28 4 0 281 1724.0 0.37037037037037035 ¤ 6,000,000.00
748 Brady Skjei NYR D 80 5 34 39 11 42 0 0 127 1885.0 0.0 ¤ 925,000.00
749 Jaccob Slavin CAR D 82 5 29 34 23 12 0 0 99 2135.0 0.0 ¤ 742,500.00
750 Anton Slepyshev EDM LW 41 4 6 10 5 4 0 0 55 635.0 0.4 ¤ 925,000.00
751 Ben Smith TOR RW 40 2 2 4 -7 4 0 0 30 712.0 0.5149572649572649 ¤ 675,000.00
752 Brendan Smith NYR D 51 3 6 9 1 63 1 0 62 1319.0 0.0 ¤ 3,250,000.00
753 C.J. Smith BUF LW 2 0 1 1 -1 0 0 0 2 30.0 0.0
754 Craig Smith NSH RW 78 12 17 29 7 30 1 0 155 1505.0 0.4594594594594595 ¤ 4,000,000.00
755 Gemel Smith DAL C 17 3 3 6 -1 21 0 0 19 342.0 0.423728813559322 ¤ 670,000.00
756 Reilly Smith FLA RW 80 15 22 37 -13 17 3 0 160 1948.0 0.5 ¤ 3,500,000.00
757 Trevor Smith NSH C 1 0 0 0 0 0 0 0 0 12.0 0.0 ¤ 575,000.00
758 Zack Smith OTT C 74 16 16 32 6 61 1 0 137 1638.0 0.5205254515599343 ¤ 2,350,000.00
759 Devante Smith-Pelly NJD RW 53 4 5 9 -19 12 0 0 76 975.0 0.4084507042253521 ¤ 1,250,000.00
760 Vladimir Sobotka STL LW 1 1 0 1 0 0 0 0 2 22.0 0.5 ¤ 2,725,000.00
761 Carl Soderberg COL C 80 6 8 14 -26 22 0 0 128 1472.0 0.51994301994302 ¤ 4,750,000.00
762 Marcus Sorensen SJS RW 19 1 3 4 -1 4 1 0 27 317.0 0.75
763 Nick Sorensen ANA RW 5 0 1 1 -1 2 0 0 7 82.0 1.0 ¤ 925,000.00
764 Nikita Soshnikov TOR RW 56 5 4 9 1 16 0 0 70 933.0 0.11764705882352941 ¤ 742,500.00
765 Blake Speers NJD C 3 0 0 0 0 0 0 0 3 43.0 0.0 ¤ 667,500.00
766 Jason Spezza DAL C 68 15 35 50 -18 29 4 0 149 1530.0 0.5221238938053098 ¤ 7,500,000.00
767 Ryan Spooner BOS C 78 12 28 39 -8 14 3 1 146 1440.0 0.3891625615763547 ¤ 1,100,000.00
768 Ryan Sproul DET D 27 1 6 7 -8 6 0 0 46 553.0 0.0 ¤ 600,000.00
769 Jared Spurgeon MIN D 76 10 28 38 33 20 2 1 144 2084.0 0.0 ¤ 4,250,000.00
770 Eric Staal MIN C 82 28 37 65 17 34 8 0 211 1926.0 0.49148211243611584 ¤ 3,500,000.00
771 Jordan Staal CAR C 75 16 29 45 -1 38 3 0 164 1927.0 0.5909090909090909 ¤ 6,000,000.00
772 Marc Staal NYR D 72 3 7 10 9 34 0 0 70 1907.0 0.0 ¤ 6,000,000.00
773 Drew Stafford WPG RW 58 8 13 21 6 24 3 0 109 1063.0 0.3181818181818182 ¤ 4,350,000.00
774 Matt Stajan CGY C 81 6 17 23 3 40 3 0 59 1473.0 0.5013020833333334 ¤ 3,000,000.00
775 Viktor Stalberg OTT LW 75 11 5 16 -9 41 2 0 101 1366.0 0.0 ¤ 1,500,000.00
776 Steven Stamkos TBL C 17 9 11 20 3 14 1 0 58 366.0 0.5353535353535354 ¤ 9,500,000.00
777 Paul Stastny STL C 66 18 22 40 4 36 5 0 112 1747.0 0.5574468085106383 ¤ 7,000,000.00
778 Troy Stecher VAN D 71 3 21 24 -16 25 0 0 125 1719.0 0.0 ¤ 925,000.00
779 Alex Steen STL LW 76 16 35 51 -2 53 2 0 117 2047.0 0.4089068825910931 ¤ 6,500,000.00
780 Lee Stempniak CAR RW 82 16 24 40 2 32 2 0 131 1705.0 0.375 ¤ 2,500,000.00
781 Derek Stepan NYR C 81 17 38 55 19 16 2 0 209 2057.0 0.4704336399474376 ¤ 8,000,000.00
782 Chandler Stephenson WSH C 4 0 0 0 0 0 0 0 3 46.0 0.48 ¤ 842,500.00
783 Chris Stewart MIN RW 79 13 8 21 3 94 0 0 82 1129.0 0.18181818181818182 ¤ 1,200,000.00
784 Karl Stollery NJD D 11 0 3 3 -5 13 0 0 11 245.0 0.0 ¤ 575,000.00
785 Mark Stone OTT RW 71 22 32 54 12 25 5 0 134 1610.0 0.4 ¤ 3,750,000.00
786 Michael Stone CGY D 64 3 12 15 0 32 0 0 81 1705.0 1.0 ¤ 4,000,000.00
787 Clayton Stoner ANA D 14 1 2 3 0 28 0 0 16 325.0 0.0 ¤ 3,250,000.00
788 Brian Strait WPG D 5 0 2 2 -1 0 0 0 3 113.0 0.0 ¤ 600,000.00
789 Anton Stralman TBL D 73 5 17 22 1 20 0 0 130 1963.0 0.0 ¤ 4,500,000.00
790 Ben Street DET C 6 0 1 1 1 0 0 0 8 77.0 0.0 ¤ 600,000.00
791 Mark Streit PIT D 68 6 21 27 -12 28 2 0 114 1691.0 0.0 ¤ 4,000,000.00
792 Dylan Strome ARI C 7 0 1 1 -5 0 0 0 6 130.0 0.4025974025974026 ¤ 925,000.00
793 Ryan Strome NYI RW 69 13 17 30 -8 40 2 0 114 1265.0 0.4273255813953488 ¤ 2,000,000.00
794 Mark Stuart WPG D 42 2 2 4 4 27 1 0 24 749.0 0.0 ¤ 2,700,000.00
795 P.K. Subban NSH D 66 10 30 40 -8 44 2 0 142 1860.0 0.0 ¤ 11,000,000.00
796 Oskar Sundqvist PIT C 10 0 0 0 -4 2 0 0 9 138.0 0.36363636363636365 ¤ 792,500.00
797 Andrej Sustr TBL D 80 3 11 14 -10 43 1 0 93 1813.0 0.0 ¤ 1,600,000.00
798 Ryan Suter MIN D 82 9 31 40 34 36 1 0 164 2319.0 0.0 ¤ 9,000,000.00
799 Brandon Sutter VAN C 81 17 17 34 -20 12 1 1 160 2069.0 0.5426997245179064 ¤ 4,250,000.00
800 Evgeny Svechnikov DET RW 2 0 0 0 0 0 0 0 4 43.0 0.0 ¤ 925,000.00
801 Brandon Tanev WPG LW 51 2 2 4 -6 26 1 0 54 877.0 1.0 ¤ 874,125.00
802 Chris Tanev VAN D 53 2 8 10 3 14 1 1 39 1435.0 0.0 ¤ 3,500,000.00
803 Vladimir Tarasenko STL RW 82 39 36 75 -1 12 8 3 286 2064.0 0.5 ¤ 8,000,000.00
804 Tomas Tatar DET LW 82 25 21 46 -8 26 5 0 166 1922.0 0.6153846153846154 ¤ 2,750,000.00
805 John Tavares NYI C 77 28 38 66 4 38 3 1 260 1906.0 0.5061425061425061 ¤ 6,000,000.00
806 Matt Tennyson CAR D 45 0 6 6 -13 6 0 0 36 826.0 0.0 ¤ 675,000.00
807 Teuvo Teravainen CAR LW 81 15 27 42 -6 16 2 1 169 1710.0 0.46731234866828086 ¤ 832,500.00
808 Chris Terry MTL LW 14 2 2 4 -1 4 0 0 15 213.0 0.5 ¤ 600,000.00
809 Shea Theodore ANA D 34 2 7 9 -6 28 1 1 60 738.0 0.0 ¤ 832,500.00
810 Nate Thompson ANA C 30 1 1 2 4 14 0 0 19 484.0 0.5306122448979592 ¤ 1,700,000.00
811 Paul Thompson FLA RW 21 0 3 3 -4 22 0 0 19 255.0 0.0 ¤ 575,000.00
812 Ben Thomson NJD LW 3 0 0 0 -4 4 0 0 7 47.0 0.0 ¤ 635,000.00
813 Chris Thorburn WPG RW 64 3 1 4 -7 95 0 0 36 735.0 0.5 ¤ 1,200,000.00
814 Joe Thornton SJS C 79 7 43 50 7 51 0 0 82 1835.0 0.508819538670285 ¤ 6,750,000.00
815 Shawn Thornton FLA LW 50 2 2 4 -7 67 0 0 42 565.0 0.3333333333333333
816 Chris Tierney SJS C 80 11 12 23 0 6 2 0 90 1722.0 0.4854721549636804 ¤ 700,000.00
817 Matthew Tkachuk CGY LW 76 13 35 48 14 105 2 0 142 1468.0 0.34782608695652173 ¤ 925,000.00
818 Jonathan Toews CHI C 72 21 37 58 7 35 5 1 199 1772.0 0.5489690721649485 ¤ 13,800,000.00
819 Tyler Toffoli LAK C 63 16 18 34 6 22 2 1 165 1380.0 0.4 ¤ 3,900,000.00
820 Sergey Tolchinsky CAR LW 2 0 1 1 0 0 0 0 2 29.0 0.0 ¤ 575,000.00
821 Jordin Tootoo CHI RW 50 2 1 3 -6 28 0 0 43 509.0 1.0 ¤ 750,000.00
822 Vincent Trocheck FLA C 82 23 31 54 -13 43 2 1 230 2101.0 0.5018028846153846 ¤ 3,750,000.00
823 Corey Tropp ANA RW 1 0 0 0 -1 0 0 0 0 16.0 0.0 ¤ 600,000.00
824 Jacob Trouba WPG D 60 8 25 33 4 54 1 0 154 1716.0 0.0 ¤ 2,500,000.00
825 Nikita Tryamkin VAN D 66 2 7 9 -7 64 0 0 65 1517.0 0.0 ¤ 925,000.00
826 Alex Tuch MIN RW 6 0 0 0 -3 0 0 0 8 86.0 0.0 ¤ 925,000.00
827 Kyle Turris OTT C 78 27 28 55 -3 47 6 2 185 1902.0 0.5306122448979592 ¤ 4,000,000.00
828 T.J. Tynan CBJ C 3 0 0 0 -1 0 0 0 3 34.0 0.0 ¤ 600,000.00
829 Fedor Tyutin COL D 69 1 12 13 -25 38 0 0 46 1757.0 0.0 ¤ 2,000,000.00
830 Scottie Upshall STL RW 73 10 8 18 -1 45 1 0 86 1296.0 0.25 ¤ 900,000.00
831 James van Riemsdyk TOR LW 82 29 33 62 -2 37 5 0 238 1771.0 0.2 ¤ 5,000,000.00
832 Trevor van Riemsdyk CHI D 58 5 11 16 17 29 2 0 73 1392.0 0.0 ¤ 750,000.00
833 Chris VandeVelde PHI C 81 6 9 15 -5 16 0 0 69 1372.0 0.5238095238095238 ¤ 725,000.00
834 Thomas Vanek FLA LW 68 17 31 48 -5 22 2 0 133 1283.0 0.4 ¤ 2,600,000.00
835 Phil Varone OTT C 7 0 0 0 -3 2 0 0 1 82.0 0.5555555555555556 ¤ 700,000.00
836 Sami Vatanen ANA D 71 3 21 24 3 30 0 0 117 1806.0 0.0 ¤ 5,000,000.00
837 Frank Vatrano BOS C 44 10 8 18 -3 14 1 0 116 817.0 0.2857142857142857 ¤ 792,500.00
838 Mike Vecchione PHI C 2 0 0 0 -1 0 0 0 1 21.0 0.6666666666666666 ¤ 925,000.00
839 Antoine Vermette ANA C 72 9 19 28 -7 42 1 0 88 1749.0 0.6225941422594142 ¤ 1,750,000.00
840 Joel Vermin TBL RW 18 0 3 3 2 4 0 0 12 280.0 0.6666666666666666 ¤ 575,000.00
841 Kris Versteeg CGY RW 69 15 22 37 -3 46 1 0 136 1281.0 0.5196078431372549 ¤ 950,000.00
842 Jimmy Vesey NYR LW 80 16 11 27 -13 26 6 0 116 1508.0 0.2857142857142857 ¤ 925,000.00
843 Linden Vey CGY RW 4 0 0 0 -2 0 0 0 1 60.0 0.375 ¤ 700,000.00
844 Jake Virtanen VAN RW 10 0 1 1 1 2 0 0 13 157.0 1.0 ¤ 925,000.00
845 Marc-Edouard Vlasic SJS D 75 6 22 28 4 35 2 1 144 1982.0 0.0 ¤ 4,250,000.00
846 Jakub Voracek PHI RW 82 20 41 61 -24 56 3 2 253 1995.0 0.21428571428571427 ¤ 10,000,000.00
847 Jakub Vrana WSH LW 21 3 3 6 2 2 2 0 32 291.0 0.0 ¤ 925,000.00
848 Radim Vrbata ARI RW 81 20 35 55 -18 16 4 0 233 1732.0 0.3617021276595745 ¤ 1,000,000.00
849 Chris Wagner ANA C 43 6 1 7 2 6 0 0 40 619.0 0.4189189189189189 ¤ 625,000.00
850 Lucas Wallmark CAR C 8 0 2 2 1 2 0 0 11 128.0 0.5344827586206896 ¤ 675,000.00
851 Joel Ward SJS RW 78 10 19 29 -2 30 2 0 105 1745.0 0.48903508771929827 ¤ 3,275,000.00
852 David Warsofsky PIT D 7 0 1 1 -3 6 0 0 14 158.0 0.0 ¤ 575,000.00
853 Austin Watson NSH LW 77 5 12 17 14 99 0 0 90 1380.0 0.40476190476190477 ¤ 575,000.00
854 Jordan Weal PHI C 23 8 4 12 5 10 1 0 49 453.0 0.5 ¤ 650,000.00
855 Shea Weber MTL D 78 17 25 42 20 38 4 0 183 2218.0 0.0 ¤ 12,000,000.00
856 Yannick Weber NSH D 73 1 7 8 1 25 1 0 72 1245.0 0.0 ¤ 575,000.00
857 Mackenzie Weegar FLA D 3 0 0 0 0 4 0 0 3 62.0 0.0 ¤ 705,000.00
858 Dale Weise PHI RW 64 8 7 15 1 39 2 0 94 1122.0 1.0 ¤ 2,750,000.00
859 Alex Wennberg CBJ C 80 13 46 59 9 21 5 0 109 1893.0 0.47392996108949415 ¤ 925,000.00
860 Zach Werenski CBJ D 78 11 36 47 17 14 1 1 188 2069.0 0.0 ¤ 925,000.00
861 Blake Wheeler WPG RW 82 26 48 74 6 47 4 0 259 2150.0 0.4574468085106383 ¤ 5,800,000.00
862 Colin White OTT C 2 0 0 0 0 0 0 0 1 34.0 0.3333333333333333 ¤ 925,000.00
863 Ryan White MIN C 65 9 7 16 -16 84 1 0 60 948.0 0.42857142857142855 ¤ 1,000,000.00
864 Chris Wideman OTT D 76 5 12 17 7 46 1 0 123 1597.0 0.0 ¤ 800,000.00
865 Dennis Wideman CGY D 57 5 13 18 -6 32 1 0 87 1500.0 0.0 ¤ 6,000,000.00
866 Patrick Wiercioch COL D 57 4 8 12 -18 23 0 0 63 1286.0 0.0 ¤ 800,000.00
867 Justin Williams WSH RW 80 24 24 48 14 50 4 0 167 1538.0 0.5470085470085471 ¤ 3,250,000.00
868 Colin Wilson NSH LW 70 12 23 35 7 18 0 0 113 1446.0 0.41025641025641024 ¤ 4,000,000.00
869 Scott Wilson PIT LW 78 8 18 26 0 32 1 0 127 1253.0 1.0 ¤ 590,000.00
870 Tom Wilson WSH RW 82 7 12 19 9 133 0 0 95 1453.0 0.3 ¤ 1,750,000.00
871 Tommy Wingels SJS C 73 7 5 12 -11 27 2 0 81 1150.0 0.4269230769230769 ¤ 2,600,000.00
872 Daniel Winnik WSH LW 72 12 13 25 15 49 3 0 82 1284.0 0.42857142857142855 ¤ 1,800,000.00
873 Luke Witkowski TBL D 34 0 4 4 -1 39 0 0 24 479.0 0.0 ¤ 575,000.00
874 Miles Wood NJD LW 60 8 9 17 -21 86 0 0 105 1038.0 0.5 ¤ 925,000.00
875 Tyler Wotherspoon CGY D 4 0 0 0 -2 0 0 0 4 62.0 0.0 ¤ 625,000.00
876 Nail Yakupov STL RW 40 3 6 9 -3 14 0 0 35 616.0 0.0 ¤ 2,500,000.00
877 Keith Yandle FLA D 82 5 36 41 -6 39 0 0 178 2105.0 0.0 ¤ 7,500,000.00
878 Pavel Zacha NJD C 70 8 16 24 -17 19 2 0 83 1299.0 0.4026258205689278 ¤ 925,000.00
879 Nikita Zadorov COL D 56 0 10 10 -20 73 0 0 61 1432.0 0.0 ¤ 832,500.00
880 Nikita Zaitsev TOR D 82 4 32 36 -22 38 0 0 106 2438.0 0.0 ¤ 925,000.00
881 Travis Zajac NJD C 80 14 31 45 -8 33 1 0 126 1971.0 0.546691403834261 ¤ 6,500,000.00
882 Michael Zalewski VAN LW 1 0 0 0 -1 0 0 0 0 13.0 0.0 ¤ 632,500.00
883 Henrik Zetterberg DET LW 82 17 51 68 15 22 0 0 195 1973.0 0.5176211453744494 ¤ 7,500,000.00
884 Mika Zibanejad NYR C 56 14 23 37 9 16 2 2 119 1349.0 0.52 ¤ 3,250,000.00
885 Harry Zolnierczyk NSH LW 24 2 2 4 -2 10 0 0 19 309.0 0.42105263157894735 ¤ 575,000.00
886 Mats Zuccarello NYR RW 80 15 44 59 15 26 3 0 189 1922.0 0.46153846153846156 ¤ 4,500,000.00
887 Jason Zucker MIN LW 79 22 25 47 34 30 3 0 172 1600.0 0.2 ¤ 2,000,000.00
888 Valentin Zykov CAR LW 2 1 0 1 1 0 0 0 3 16.0 0.0 ¤ 727,500.00
position_id position_desc
C Center
D Defenseman
GK Goalie
LW Left Wing
RW Right Wing
SeasonID Season
1 2012-2013
2 2013-2014
3 2014-2015
4 2015-2016
5 2016-2017
6 2017-2018
team_id team_name team_conference team_division team_coach team_create_date
ANA Anaheim Mighty Ducks Western Pacific Randy Carlyle 8/1/97
ARI Arizona Coyotes Western Pacific Rick Tocchet 9/1/55
BOS Boston Bruins Eastern Atlantic Bruce Cassidy 8/15/01
BUF Buffalo Sabres Eastern Atlantic Phil Housley 9/15/05
CAR Carolina Hurricanes Eastern Metro Bill Peters 7/26/99
CBJ Columbus Blue Jackets Eastern Metro John Tortorella 5/5/74
CGY Calgary Flames Western Pacific Glen Gulutzan 6/7/64
CHI Chicago Blackhawks Western Central Joel Quenneville 3/5/03
COL Colorado Avalanche Western Central Jared Bednar 1/1/86
DAL Dallas Stars Western Central Ken Hitchcock 1/9/13
DET Detroit Red Wings Eastern Atlantic Jeff Blashill 2/15/11
EDM Edmonton Oilers Western Pacific Todd McLellan 7/9/69
FLA Florida Panthers Eastern Atlantic Bob Boughner 6/6/51
LAK LA Kings Western Pacific John Stevents 4/29/76
LAS Vegas Golden Knights Western Pacific Gerard Gallant 6/1/18
MIN Minnesota Wild Western Central Bruce Boudreau 1/23/02
MTL Montreal Cunucks Eastern Atlantic Claude Julien 6/9/92
NJD New Jersey Devils Eastern Metro John Hynes 5/26/71
NSH Nashville Predators Western Central Peter Laviolette 11/24/08
NYI New York Islanders Eastern Metro Doug Weight 12/31/99
NYR New York Rangers Eastern Metro Alain Vigneault 10/12/31
OTT Ottawa Senators Eastern Atlantic Guy Boucher 2/3/05
PHI Philadelphia Flyers Eastern Metro Dave Hakstol 3/15/49
PIT Pittsburgh Penguins Eastern Metro Mike Sullivan 5/7/79
SJS San Jose Sharks Western Pacific Peter DeBoer 8/17/10
STL St. Louis Blues Western Central Mike Yeo 10/2/98
TBL Tampa Bay Lightening Eastern Atlantic Jon Cooper 6/1/97
TOR Toronto Maple Leafs Eastern Atlantic Mike Babcock 9/6/17
VAN Vancouver Canucks Western Pacific Travis Green 2/1/44
WPG Winnepeg Jets Western Central Paul Maurice 4/4/02
WSH Washington Capitals Eastern Metro Berry Trotz 10/5/69
team_ID seasonID GP Wins Loss OT Points GF GA
ANA 1 48 30 12 6 66 134 115
ANA 2 82 54 20 8 116 263 203
ANA 3 82 51 24 7 109 228 221
ANA 4 70 39 22 9 87 176 158
ANA 5 82 46 23 13 105 223 200
ARI 1 48 21 18 9 51 121 125
ARI 2 82 37 30 15 89 210 224
ARI 3 82 24 50 8 56 165 267
ARI 4 70 31 32 7 69 187 211
ARI 5 82 30 42 10 70 197 260
BOS 1 48 28 14 6 62 127 106
BOS 2 82 54 19 9 117 258 171
BOS 3 82 41 27 14 96 209 201
BOS 4 72 39 25 8 86 211 194
BOS 5 82 44 31 7 95 234 212
BUF 1 48 21 21 6 48 118 139
BUF 2 82 21 51 10 52 150 243
BUF 3 82 23 51 8 54 153 269
BUF 4 72 29 33 10 68 170 188
BUF 5 82 33 37 12 78 201 237
CAR 1 48 19 25 4 42 127 159
CAR 2 82 36 35 11 83 205 226
CAR 3 82 30 41 11 71 183 219
CAR 4 71 31 27 13 75 172 189
CAR 5 82 36 31 15 87 215 236
CBJ 1 48 24 17 7 55 115 115
CBJ 2 82 43 32 7 93 226 214
CBJ 3 82 42 35 5 89 227 248
CBJ 4 70 28 34 8 64 176 214
CBJ 5 82 50 24 8 108 249 195
CGY 1 48 19 25 4 42 128 157
CGY 2 82 35 40 7 77 202 238
CGY 3 82 45 30 7 97 237 213
CGY 4 71 30 35 6 66 194 219
CGY 5 82 45 33 4 94 226 221
CHI 1 48 36 7 5 77 149 97
CHI 2 82 46 21 15 107 261 212
CHI 3 82 48 28 6 102 220 186
CHI 4 72 42 24 6 90 200 175
CHI 5 82 50 23 9 109 244 213
COL 1 48 16 25 7 39 114 150
COL 2 82 52 22 8 112 245 216
COL 3 82 39 31 12 90 209 223
COL 4 72 37 31 4 78 191 202
COL 5 82 22 56 4 48 166 278
DAL 1 48 22 22 4 48 128 141
DAL 2 82 40 31 11 91 231 223
DAL 3 82 41 31 10 92 257 257
DAL 4 72 42 21 9 93 231 209
DAL 5 82 34 37 11 79 223 262
DET 1 48 24 16 8 56 122 110
DET 2 82 39 28 15 93 217 221
DET 3 82 43 25 14 100 231 211
DET 4 71 35 25 11 81 177 182
DET 5 82 33 36 13 79 207 244
EDM 1 48 19 22 7 45 123 131
EDM 2 82 29 44 9 67 199 267
EDM 3 82 24 44 14 62 193 276
EDM 4 74 29 38 7 65 175 214
EDM 5 82 47 26 9 103 247 212
FLA 1 48 15 27 6 36 109 170
FLA 2 82 29 45 8 66 188 262
FLA 3 82 38 29 15 91 198 213
FLA 4 71 40 22 9 89 195 169
FLA 5 82 35 36 11 81 210 237
LAK 1 48 27 16 5 59 131 114
LAK 2 82 46 28 8 100 198 168
LAK 3 82 40 27 15 95 218 197
LAK 4 70 43 22 5 91 192 157
LAK 5 82 39 35 8 86 201 205
MIN 1 48 26 19 3 55 118 125
MIN 2 82 43 27 12 98 199 198
MIN 3 82 46 28 8 100 227 198
MIN 4 71 32 28 11 75 187 180
MIN 5 82 49 25 8 106 266 208
MTL 1 48 29 14 5 63 146 124
MTL 2 82 46 28 8 100 209 201
MTL 3 82 50 22 10 110 214 184
MTL 4 71 33 32 6 72 186 197
MTL 5 82 47 26 9 103 226 200
NJD 1 48 19 19 10 48 110 122
NJD 2 82 35 29 18 88 197 195
NJD 3 82 32 36 14 78 176 209
NJD 4 71 34 30 7 75 159 176
NSH 1 48 16 23 9 41 109 133
NSH 2 82 38 32 12 88 214 233
NSH 3 82 47 25 10 104 226 202
NSH 4 72 36 23 13 85 194 184
NSH 5 82 41 29 12 94 240 224
NYI 1 48 24 17 7 55 135 136
NYI 2 82 34 37 11 79 216 261
NYI 3 82 47 28 7 101 245 224
NYI 4 69 38 22 9 85 192 169
NYI 5 82 41 29 12 94 241 242
NYR 1 48 26 18 4 56 126 108
NYR 2 82 45 31 6 96 214 190
NYR 3 82 53 22 7 113 248 187
NYR 4 71 40 23 8 88 199 184
NYR 5 82 48 28 6 102 256 220
OTT 1 48 25 17 6 56 112 100
OTT 2 82 37 31 14 88 229 258
OTT 3 82 43 26 13 99 232 208
OTT 4 72 33 31 8 74 200 217
OTT 5 82 44 28 10 98 212 214
PHI 1 48 23 22 3 49 132 139
PHI 2 82 42 30 10 94 233 227
PHI 3 82 33 31 18 84 212 223
PHI 4 69 34 23 12 80 179 178
PHI 5 82 39 33 10 88 219 236
PIT 1 48 36 12 0 72 162 119
PIT 2 82 51 24 7 109 242 204
PIT 3 82 43 27 12 98 217 204
PIT 4 70 38 24 8 84 191 172
PIT 5 82 50 21 11 111 282 234
SJS 1 48 25 16 7 57 116 112
SJS 2 82 51 22 9 111 239 193
SJS 3 82 40 33 9 89 224 226
SJS 4 70 39 25 6 84 204 181
SJS 5 82 46 29 7 99 221 201
STL 1 48 29 17 2 60 124 114
STL 2 82 52 23 7 111 239 188
STL 3 82 51 24 7 109 239 197
STL 4 72 41 22 9 91 186 181
STL 5 82 46 29 7 99 235 218
TBL 1 48 18 26 4 40 147 147
TBL 2 82 46 27 9 101 232 209
TBL 3 82 50 24 8 108 259 206
TBL 4 71 40 26 5 85 191 168
TBL 5 82 42 30 10 94 234 227
TOR 1 48 26 17 5 57 145 128
TOR 2 82 38 36 8 84 222 252
TOR 3 82 30 44 8 68 206 257
TOR 4 70 24 35 11 59 159 200
TOR 5 82 40 27 15 95 251 242
VAN 1 48 26 15 7 59 122 115
VAN 2 82 36 35 11 83 191 216
VAN 3 82 48 29 5 101 236 220
VAN 4 70 27 31 12 66 163 199
VAN 5 82 30 43 9 69 182 243
WPG 1 48 24 21 3 51 126 141
WPG 2 82 37 35 10 84 219 231
WPG 3 82 43 26 13 99 223 204
WPG 4 71 29 37 5 63 180 210
WPG 5 82 40 35 7 87 249 256
WSH 1 48 27 18 3 57 146 130
WSH 2 82 38 30 14 90 225 229
WSH 3 82 45 26 11 101 237 199
WSH 4 70 51 14 5 107 221 161
WSH 5 82 55 19 8 118 263 182
SELECT team.team_name, team.team_conference, team.team_coach FROM team ORDER BY team.team_name;
SELECT TOP 3 team.team_name, team.team_division, Sum(player.Penalties) AS SumOfPenalties FROM team INNER JOIN player ON team.team_id = player.Team_ID GROUP BY team.team_name, team.team_division HAVING (((team.team_division)="Atlantic")) ORDER BY Sum(player.Penalties) DESC;
SELECT team.team_name, position.position_desc, player.[PLname], player.[PFname] FROM position INNER JOIN (team INNER JOIN player ON team.team_id = player.Team_ID) ON position.position_id = player.Position_ID WHERE (((team.team_name) Like "*Boston*") AND ((player.[Team_ID]) In (SELECT [Team_ID] FROM [player] As Tmp GROUP BY [Team_ID],[Position_ID] HAVING Count(*)>1 And [Position_ID] = [player].[Position_ID]))) ORDER BY player.[Team_ID], player.[Position_ID];
SELECT team.team_name, team.team_conference, team.team_division, team.team_create_date FROM team LEFT JOIN player ON team.[team_id] = player.[Team_ID] WHERE (((player.Team_ID) Is Null));
SELECT player.PLname, player.PFname, player.Salary FROM player WHERE (((player.Salary)<5000000)) ORDER BY player.Salary DESC;
SELECT player.PLname, player.PFname, team.team_name FROM team INNER JOIN player ON team.team_id = player.Team_ID WHERE (((team.team_name)="Boston Bruins")) ORDER BY player.PLname;
SELECT player.PLname, player.PFname, team.team_name FROM team INNER JOIN player ON team.team_id = player.Team_ID WHERE (((team.team_name) Like "*Carolina*")) ORDER BY player.PLname;
SELECT team.team_name, team.team_create_date FROM team WHERE (((team.team_create_date) Between #1/1/1990# And #12/31/1999#)) ORDER BY team.team_create_date;
SELECT player.PLname, player.PFname, player.Goals, player.Assists, player.Penalties FROM player WHERE (((player.PLname)="Smith") AND ((player.Goals)=0) AND ((player.Penalties)=0));
SELECT player.PLname, player.PFname, position.position_desc FROM position INNER JOIN player ON position.position_id = player.Position_ID WHERE (((position.position_desc)="Right Wing")) OR (((position.position_desc)="Left Wing")) ORDER BY position.position_desc;
SELECT Sum(player.Points) AS SumOfPoints FROM player;
SELECT position.position_desc, Count(player.PID) AS CountOfPID, Avg(player.Assists) AS AvgOfAssists FROM position INNER JOIN player ON position.position_id = player.Position_ID GROUP BY position.position_desc ORDER BY Avg(player.Assists) DESC;