| Priority | Description | |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| # | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | of 63,500,000$ | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Avalanche | 2000 | 4000 | 5000 | 6000 | 1000 | 190 | 130 | 85 | 44 | 283 | 5256 | 11688 | 14381 | 17802 | 2886 | 87.60% | 97.40% | 95.87% | 98.90% | 96.20% | 38 | 17338 - 96.32% | 2,652,444$ | 7,957,332$ | 18000 | 95 | 75,991,333$ | 75,991,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 61,892,733$ | 61,892,733$ |
| 2 | Blackhawks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 73,529,636$ | 71,654,638$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 90,147,360$ | 90,147,360$ |
| 3 | Blue Jackets | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 10000 | 20000 | 25000 | 30000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 2,963,610$ | 14,818,050$ | 18000 | 100 | 81,211,071$ | 81,211,071$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 67,762,907$ | 67,762,907$ |
| 4 | Blues | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 7840 | 15680 | 19600 | 23520 | 3920 | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 37 | 17640 - 98.00% | 2,904,338$ | 11,617,352$ | 18000 | 90 | 82,590,623$ | 82,590,623$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 52,172,052$ | 52,172,052$ |
| 5 | Bruins | 2000 | 4000 | 5000 | 6000 | 1000 | 100 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 40 | 74,624,150$ | 73,499,148$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 989,851$ | 989,851$ |
| 6 | Canadiens | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 6000 | 12000 | 15000 | 18000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,963,610$ | 8,890,830$ | 18000 | 45 | 73,057,512$ | 73,057,512$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 119,046,343$ | 119,046,343$ |
| 7 | Canucks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 12000 | 24000 | 30000 | 36000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18000 - 100.00% | 2,963,610$ | 17,781,660$ | 18000 | 65 | 80,519,999$ | 74,895,005$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 168,824,258$ | 168,824,258$ |
| 8 | Capitals | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 50 | 76,613,258$ | 76,613,259$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 9,542,101$ | 9,542,101$ |
| 9 | Devils | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 6000 | 12000 | 15000 | 18000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,963,610$ | 8,890,830$ | 18000 | 100 | 83,196,500$ | 83,196,500$ | 410,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 64,905,707$ | 64,905,707$ |
| 10 | Ducks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 15 | 72,090,166$ | 70,190,168$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 88,235,987$ | 88,235,987$ |
| 11 | Flames | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 90 | 71,438,950$ | 70,313,950$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 23,844,619$ | 23,844,619$ |
| 12 | Flyers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 65,633,753$ | 63,383,753$ | 232,500$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 38,463,789$ | 38,463,789$ |
| 13 | Golden Knights | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,615,867$ | 71,615,867$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 126,986,523$ | 126,986,523$ |
| 14 | Hockey Club | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 73,377,143$ | 73,377,143$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 79,518,261$ | 79,518,261$ |
| 15 | Hurricanes | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 135 | 85 | 45 | 285 | 6000 | 12000 | 15000 | 18000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,845,900$ | 8,537,700$ | 18000 | 75 | 79,566,376$ | 77,316,376$ | 2,368,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 60,841,093$ | 60,841,093$ |
| 16 | Islanders | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 8000 | 16000 | 20000 | 24000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 2,963,610$ | 11,854,440$ | 18000 | 100 | 82,812,502$ | 82,812,502$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 143,584,368$ | 143,584,368$ |
| 17 | Jets | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 63,558,848$ | 63,558,848$ | 7,975,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 122,693,280$ | 122,693,280$ |
| 18 | Kings | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 6000 | 12000 | 15000 | 18000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,963,610$ | 8,890,830$ | 18000 | 70 | 87,473,873$ | 82,973,872$ | 377,150$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 72,698,685$ | 72,698,685$ |
| 19 | Kraken | 2000 | 4000 | 5000 | 6000 | 1000 | 100 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 64,420,759$ | 58,795,761$ | 9,575,000$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 49,357,058$ | 49,357,058$ |
| 20 | Lightning | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 60,881,962$ | 60,881,962$ | 5,708,750$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 95,532,888$ | 95,532,888$ |
| 21 | Maple Leafs | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 84,492,143$ | 84,492,143$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 32,111,584$ | 32,111,584$ |
| 22 | Oilers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 4000 | 8000 | 10000 | 12000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 2,963,610$ | 5,927,220$ | 18000 | 90 | 84,791,902$ | 83,666,904$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 107,889,912$ | 107,889,912$ |
| 23 | Panthers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 50 | 82,066,750$ | 82,066,750$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 17,100,502$ | 17,100,502$ |
| 24 | Penguins | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 50 | 68,283,875$ | 67,158,875$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 53,315,092$ | 53,315,092$ |
| 25 | Predators | 2000 | 4000 | 5000 | 6000 | 1000 | 160 | 100 | 40 | 23 | 220 | 2840 | 5680 | 7100 | 8549 | 1420 | 71.00% | 71.00% | 71.00% | 71.24% | 71.00% | 39 | 12795 - 71.08% | 1,352,493$ | 2,704,986$ | 18000 | 55 | 80,744,835$ | 79,619,840$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | -21,387,807$ | -21,387,807$ |
| 26 | Rangers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 65 | 68,842,562$ | 68,842,562$ | 2,887,125$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 29,359,586$ | 29,359,586$ |
| 27 | Red Wings | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 4000 | 8000 | 10000 | 12000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 2,963,610$ | 5,927,220$ | 18000 | 100 | 72,399,189$ | 71,274,188$ | 2,250,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 103,852,586$ | 103,852,586$ |
| 28 | Sabres | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 8000 | 16000 | 20000 | 24000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 2,963,610$ | 11,854,440$ | 18000 | 100 | 86,346,532$ | 84,446,530$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 74,162,810$ | 74,162,810$ |
| 29 | Senators | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 4000 | 8000 | 10000 | 12000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 2,963,610$ | 5,927,220$ | 18000 | 100 | 74,063,734$ | 72,938,736$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 45,763,823$ | 45,763,823$ |
| 30 | Sharks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 6000 | 12000 | 15000 | 18000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,963,610$ | 8,890,830$ | 18000 | 100 | 82,761,350$ | 82,761,350$ | 390,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 70,364,722$ | 70,364,722$ |
| 31 | Stars | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 64,101,848$ | 64,101,848$ | 3,937,500$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 98,362,490$ | 98,362,490$ |
| 32 | Wild | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 6160 | 12320 | 15400 | 18480 | 3080 | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 37 | 13860 - 77.00% | 2,281,980$ | 9,127,920$ | 18000 | 80 | 87,327,916$ | 82,827,920$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -63,500,000$ | 83,500,000$ | 83,500,000$ | 6,769,790$ | 6,769,790$ |
Americans
Bears
Bruins
Checkers
Comets
Crunch
Griffins
Islanders
Marlies
Monsters
Penguins
Phantoms
Rocket
Senators
Wolf Pack
Wolves
Admirals
Barracuda
Canucks
Condors
Eagles
Firebirds
Gulls
IceHogs
Moose
Reign
Roadrunners
Silver Knights
Stars
Thunderbirds
Wild
Wranglers