Priority | Type | 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 |
# | Team | GP | W | L | T | OTW | OTL | SOW | SOL | GF | GA | Diff | P | PCT | G | A | TP | SO | EG | GP1 | GP2 | GP3 | GP4 | SHF | SH1 | SP2 | SP3 | SP4 | SHA | SHB | Pim | Hit | PPA | PPG | PP% | PKA | PK GA | PK% | PK GF | W OF FO | T OF FO | OF FO% | W DF FO | T DF FO | DF FO% | W NT FO | T NT FO | NT FO% | PZ DF | PZ OF | PZ NT | PC DF | PC OF | PC NT | GF% | SH% | SV% | PDO | PDOBRK |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Canada A | 8 | 3 | 3 | 0 | 0 | 1 | 1 | 0 | 24 | 24 | 0 | 9 | 0.000 | 24 | 42 | 66 | 0 | 1 | 13 | 5 | 5 | 1 | 255 | 102 | 76 | 72 | 8 | 271 | 78 | 74 | 184 | 26 | 4 | 15.38% | 26 | 8 | 69.23% | 0 | 149 | 291 | 51.20% | 141 | 278 | 50.72% | 68 | 127 | 53.54% | 200 | 143 | 186 | 54 | 100 | 52 | 55.6% | 9.4% | 91.1% | 100.6 | Unlucky |
2 | Canada B | 8 | 6 | 2 | 0 | 0 | 0 | 0 | 0 | 27 | 16 | 11 | 12 | 0.000 | 27 | 49 | 76 | 1 | 1 | 11 | 3 | 13 | 0 | 243 | 91 | 76 | 76 | 0 | 246 | 69 | 52 | 192 | 27 | 6 | 22.22% | 23 | 1 | 95.65% | 0 | 133 | 271 | 49.08% | 145 | 280 | 51.79% | 57 | 115 | 49.57% | 197 | 143 | 188 | 56 | 93 | 47 | 58.3% | 11.1% | 93.5% | 104.6 | LUCKY |
3 | Czech Republic | 8 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 24 | 23 | 1 | 10 | 0.000 | 24 | 43 | 67 | 0 | 1 | 7 | 9 | 7 | 1 | 290 | 105 | 87 | 96 | 2 | 281 | 86 | 55 | 185 | 25 | 6 | 24.00% | 21 | 5 | 76.19% | 0 | 148 | 288 | 51.39% | 157 | 308 | 50.97% | 64 | 131 | 48.85% | 189 | 135 | 196 | 60 | 98 | 47 | 50.0% | 8.3% | 91.8% | 100.1 | DULL |
4 | Europe | 8 | 4 | 0 | 0 | 1 | 1 | 0 | 2 | 31 | 26 | 5 | 13 | 0.000 | 31 | 56 | 87 | 0 | 0 | 5 | 15 | 10 | 2 | 250 | 95 | 66 | 77 | 20 | 251 | 74 | 63 | 190 | 24 | 8 | 33.33% | 27 | 5 | 81.48% | 0 | 131 | 254 | 51.57% | 159 | 289 | 55.02% | 68 | 124 | 54.84% | 192 | 134 | 201 | 57 | 103 | 50 | 52.3% | 12.4% | 89.6% | 102.0 | FUN |
5 | Finland | 8 | 1 | 6 | 0 | 1 | 0 | 0 | 0 | 18 | 28 | -10 | 4 | 0.000 | 18 | 31 | 49 | 1 | 0 | 7 | 6 | 4 | 1 | 271 | 91 | 92 | 86 | 2 | 249 | 67 | 73 | 152 | 22 | 3 | 13.64% | 26 | 7 | 73.08% | 0 | 147 | 301 | 48.84% | 134 | 281 | 47.69% | 69 | 124 | 55.65% | 192 | 138 | 193 | 56 | 96 | 45 | 41.7% | 6.6% | 88.8% | 95.4 | Unlucky |
6 | North America U23 | 8 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 24 | 33 | -9 | 4 | 0.000 | 24 | 42 | 66 | 0 | 0 | 11 | 6 | 7 | 0 | 238 | 74 | 79 | 85 | 0 | 257 | 87 | 68 | 204 | 19 | 2 | 10.53% | 32 | 10 | 68.75% | 1 | 131 | 277 | 47.29% | 142 | 280 | 50.71% | 61 | 133 | 45.86% | 185 | 129 | 197 | 55 | 96 | 46 | 48.9% | 10.1% | 87.2% | 97.2 | FUN |
7 | Russia | 8 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 28 | 14 | 14 | 14 | 0.000 | 28 | 51 | 79 | 0 | 0 | 12 | 7 | 9 | 0 | 274 | 82 | 89 | 103 | 0 | 234 | 67 | 40 | 203 | 36 | 7 | 19.44% | 17 | 2 | 88.24% | 0 | 148 | 300 | 49.33% | 130 | 286 | 45.45% | 54 | 110 | 49.09% | 191 | 136 | 194 | 56 | 94 | 48 | 63.6% | 10.2% | 94.0% | 104.2 | LUCKY |
8 | Sweden | 8 | 3 | 4 | 0 | 0 | 0 | 1 | 0 | 24 | 21 | 3 | 8 | 0.000 | 24 | 43 | 67 | 0 | 0 | 8 | 11 | 4 | 2 | 277 | 102 | 93 | 80 | 7 | 250 | 71 | 46 | 196 | 34 | 11 | 32.35% | 22 | 3 | 86.36% | 0 | 146 | 319 | 45.77% | 141 | 274 | 51.46% | 66 | 131 | 50.38% | 198 | 140 | 185 | 56 | 100 | 51 | 41.9% | 8.7% | 91.6% | 100.3 | DULL |
9 | The Rest | 8 | 1 | 6 | 0 | 1 | 0 | 0 | 0 | 21 | 29 | -8 | 4 | 0.000 | 21 | 35 | 56 | 0 | 0 | 2 | 9 | 9 | 1 | 227 | 64 | 82 | 80 | 1 | 231 | 77 | 64 | 197 | 22 | 4 | 18.18% | 28 | 10 | 64.29% | 1 | 142 | 280 | 50.71% | 130 | 258 | 50.39% | 51 | 114 | 44.74% | 195 | 141 | 190 | 52 | 94 | 46 | 47.2% | 9.3% | 87.4% | 96.7 | FUN |
10 | USA | 8 | 3 | 3 | 0 | 0 | 2 | 0 | 0 | 19 | 26 | -7 | 8 | 0.000 | 19 | 34 | 53 | 0 | 0 | 10 | 2 | 7 | 0 | 214 | 77 | 66 | 69 | 2 | 269 | 83 | 64 | 202 | 17 | 3 | 17.65% | 30 | 3 | 90.00% | 0 | 137 | 252 | 54.37% | 160 | 299 | 53.51% | 64 | 125 | 51.20% | 187 | 129 | 196 | 53 | 98 | 49 | 41.0% | 8.9% | 90.3% | 99.2 | Unlucky |
Average | 8 | 3.4 | 3.4 | 0 | 0.4 | 0.4 | 0.2 | 0.2 | 24 | 24 | 0 | 8.6 | 0.000 | 24 | 42.6 | 66.6 | 0.2 | 0.3 | 8.6 | 7.3 | 7.5 | 0.8 | 253.9 | 88.3 | 80.6 | 82.4 | 4.2 | 253.9 | 75.9 | 59.9 | 190.5 | 25.2 | 5.4 | 21.43% | 25.2 | 5.4 | 78.57% | 0.2 | 141.2 | 283.3 | 49.84% | 143.9 | 283.3 | 50.79% | 62.2 | 123.4 | 50.41% | 193 | 137 | 193 | 55 | 97 | 48 | 50.0% | 9.5% | 90.5% | 100.0 | FUN |