| 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 |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alain Vigneault | COQUITLAM KNIGHTS | 99 | 67 | 88 | 87 | 99 | 99 | 58 | CAN | 55 | 1 | 1,773,200$ |
| Andy Murray | DETROIT RED WINGS | 74 | 88 | 88 | 83 | 99 | 99 | 37 | CAN | 65 | 1 | 1,554,300$ |
| Barry Trotz | CHICAGO CRUSHERS | 93 | 90 | 99 | 85 | 99 | 99 | 55 | CAN | 53 | 1 | 1,975,000$ |
| Brian McCutcheon | VANCOUVER MILLIONAIRES | 77 | 84 | 72 | 66 | 94 | 95 | 45 | CAN | 66 | 1 | 750,000$ |
| Darryl Sutter | COLORADO WOLVES | 74 | 89 | 73 | 86 | 89 | 89 | 61 | CAN | 56 | 2 | 1,132,000$ |
| Dave King | HAWAII TYPHOON | 74 | 92 | 81 | 87 | 99 | 99 | 67 | CAN | 68 | 3 | 1,725,000$ |
| Doug Risebrough | PHILADELPHIA MADMEN | 72 | 82 | 87 | 81 | 99 | 99 | 49 | CAN | 63 | 3 | 1,846,000$ |
| JJ Daigneault | PENSACOLA BADGERS | 76 | 72 | 77 | 68 | 93 | 93 | 57 | CAN | 51 | 2 | 897,600$ |
| Jacques Martin | HALIFAX HIGHLANDERS | 95 | 99 | 99 | 96 | 99 | 99 | 50 | CAN | 63 | 4 | 1,000,000$ |
| Jim Playfair | SAN JOSE BLASPHEMERS | 89 | 80 | 89 | 78 | 86 | 86 | 64 | CAN | 52 | 1 | 2,157,000$ |
| Joe Sacco | NORTH VAN ROCKERS | 98 | 90 | 96 | 93 | 99 | 99 | 45 | USA | 47 | 1 | 960,000$ |
| John Stevens | CAPE FEAR PROWLERS | 91 | 89 | 90 | 75 | 92 | 89 | 29 | CAN | 50 | 1 | 800,000$ |
| Ken Hitchcock | LAS CRUCES SPURS | 87 | 81 | 93 | 90 | 99 | 99 | 52 | CAN | 64 | 3 | 1,100,000$ |
| Martin Skoula | BROOKLYN BLAZERS | 77 | 80 | 81 | 81 | 84 | 84 | 66 | CZE | 40 | 2 | 1,000,000$ |
| Marty St Louis | SYRACUSE BULLDOGS | 71 | 76 | 92 | 89 | 90 | 90 | 60 | CAN | 44 | 1 | 1,200,000$ |
| Mike Bossy | MANHATTAN ISLANDERS | 73 | 87 | 93 | 79 | 97 | 97 | 53 | CAN | 60 | 3 | 1,808,000$ |
| Peter Laviolette | PINCHER CREEK PREDATORS | 88 | 78 | 82 | 76 | 99 | 98 | 19 | USA | 51 | 3 | 1,000,000$ |
| Randy Carlyle | CALGARY COWBOYS | 81 | 79 | 99 | 79 | 92 | 92 | 58 | CAN | 60 | 2 | 1,561,000$ |
| Sergei Federov | EDMONTON BUSCHWACKERS | 77 | 65 | 84 | 83 | 82 | 82 | 68 | RUS | 47 | 3 | 1,124,000$ |
| Todd McLellan | BANGOR BEAGLES | 90 | 99 | 92 | 84 | 99 | 99 | 44 | CAN | 48 | 3 | 1,100,000$ |
| Trevor Linden | NEWTON NIGHTMARES | 77 | 77 | 80 | 74 | 85 | 85 | 65 | CAN | 46 | 1 | 1,450,000$ |
| Ulf Samuelsson | CAPE BRETON CELTS | 86 | 82 | 93 | 73 | 90 | 90 | 60 | SWE | 52 | 2 | 3,108,000$ |
| 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 |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bill Stewart |  HALIFAX HELL | 73 | 74 | 92 | 69 | 98 | 98 | 52 | USA | 59 | 3 | 1,249,400$ |
| Brad Shaw |  SYRACUSE BABY BULLS | 76 | 88 | 74 | 68 | 95 | 95 | 55 | CAN | 52 | 1 | 870,000$ |
| Brent Sutter |  MANHATTAN SWEDES | 76 | 78 | 81 | 82 | 81 | 76 | 71 | CAN | 54 | 1 | 1,411,000$ |
| Brian Sutter |  BROOKLYN GRINDERS | 76 | 96 | 78 | 87 | 95 | 95 | 55 | CAN | 60 | 2 | 829,400$ |
| Cory Clouston |  HAWAII PUNCH | 75 | 95 | 92 | 80 | 88 | 92 | 57 | CAN | 46 | 3 | 1,100,000$ |
| Curtis Hunt |  CAPE FEAR WILDCATS | 80 | 83 | 84 | 77 | 92 | 92 | 58 | USA | 49 | 3 | 1,300,000$ |
| Dave Tippett |  LAS CRUCES MESCALEROS | 71 | 76 | 82 | 78 | 84 | 84 | 66 | CAN | 54 | 3 | 1,742,400$ |
| Doug MacLean |  PHILADELPHIA PHANTOMS | 71 | 73 | 87 | 70 | 90 | 90 | 60 | CAN | 62 | 2 | 673,000$ |
| Duane Sutter |  EDMONTON OILERS | 86 | 64 | 90 | 81 | 88 | 88 | 62 | CAN | 56 | 3 | 1,302,000$ |
| Glen Murray |  PENSACOLA BLACK BEARS | 54 | 63 | 78 | 73 | 82 | 77 | 68 | CAN | 48 | 2 | 1,250,000$ |
| Greg Ireland |  BANGOR PUPPIES | 75 | 83 | 91 | 74 | 89 | 89 | 61 | CAN | 50 | 3 | 1,176,000$ |
| Hayley Wickenheiser |  NEWTON NIGHTHAWKS | 56 | 79 | 82 | 75 | 86 | 86 | 64 | CAN | 42 | 2 | 850,000$ |
| Jeremy Roenick |  COLORADO CUBS | 73 | 85 | 85 | 79 | 73 | 83 | 57 | USA | 49 | 1 | 1,595,000$ |
| John Tortorella |  PINCHER CREEK WOLVERINES | 85 | 93 | 84 | 90 | 99 | 93 | 64 | USA | 57 | 3 | 1,760,000$ |
| Kevin Lowe |  VANCOUVER THOUSANDAIRES | 81 | 74 | 91 | 69 | 96 | 96 | 54 | CAN | 57 | 2 | 570,000$ |
| Larry Robinson |  CAPE BRETON LEPRECHAUNS | 76 | 93 | 78 | 74 | 97 | 97 | 53 | CAN | 66 | 1 | 1,266,000$ |
| Lindy Ruff |  DETROIT STEELERS | 75 | 81 | 64 | 79 | 87 | 87 | 63 | CAN | 56 | 1 | 1,001,000$ |
| Mike Babcock |  NORTH VAN ROCKERS | 77 | 85 | 99 | 85 | 88 | 88 | 62 | CAN | 53 | 3 | 1,747,000$ |
| Mike Haviland |  SAN JOSE AVACADOES | 80 | 89 | 76 | 82 | 87 | 87 | 63 | USA | 49 | 1 | 784,000$ |
| Nicklas Lidstrom |  COQUITLAM EXPRESS | 70 | 79 | 77 | 63 | 75 | 75 | 65 | SWE | 50 | 2 | 1,500,000$ |
| Ron Wilson |  CHICAGO UNDERTAKERS | 97 | 93 | 89 | 87 | 99 | 97 | 56 | CAN | 61 | 1 | 1,000,000$ |
| Wayne Gretzky |  CALGARY WRANGLERS | 80 | 78 | 70 | 70 | 92 | 92 | 58 | CAN | 55 | 1 | 1,419,000$ |
| 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 |
| Coaches Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Alex Tanguay | 70 | 70 | 75 | 70 | 75 | 75 | 70 | CAN | 40 | 2 | 1,200,000$ |
| Bill Barber | 83 | 67 | 79 | 82 | 90 | 90 | 60 | USA | 64 | 0 | 823,000$ |
| Bob Boughner | 80 | 70 | 70 | 65 | 75 | 70 | 70 | CAN | 49 | 2 | 875,000$ |
| Bob Gainey | 81 | 74 | 70 | 75 | 91 | 91 | 59 | CAN | 63 | 0 | 874,000$ |
| Bob Hartley | 76 | 76 | 74 | 70 | 75 | 75 | 65 | CAN | 60 | 1 | 1,250,000$ |
| Brent Johnson | 52 | 83 | 63 | 81 | 72 | 72 | 68 | USA | 43 | 0 | 780,000$ |
| Bruce Boudreau | 73 | 64 | 78 | 72 | 88 | 88 | 62 | CAN | 61 | 0 | 1,000,000$ |
| Bruce Cassidy | 70 | 75 | 70 | 65 | 65 | 70 | 70 | CAN | 55 | 3 | 1,000,000$ |
| Charlie Huddy | 56 | 63 | 66 | 64 | 74 | 64 | 37 | CAN | 57 | 4 | 1,230,000$ |
| Chris Phillips | 70 | 80 | 70 | 70 | 60 | 70 | 70 | USA | 41 | 2 | 800,000$ |
| Claude Noel | 73 | 66 | 74 | 74 | 99 | 95 | 1 | CAN | 60 | 1 | 1,117,500$ |
| Corey Hirsch | 77 | 79 | 69 | 77 | 76 | 76 | 74 | CAN | 44 | 2 | 1,229,000$ |
| Craig MacTavish | 56 | 63 | 62 | 62 | 60 | 58 | 35 | CAN | 57 | 4 | 1,457,000$ |
| Dan Bylsma | 75 | 69 | 71 | 81 | 77 | 77 | 73 | USA | 46 | 0 | 1,661,000$ |
| Dan Cleary | 60 | 75 | 65 | 65 | 75 | 70 | 70 | CAN | 41 | 1 | 750,000$ |
| Daniel Alfredsson | 60 | 70 | 80 | 70 | 75 | 75 | 70 | SWE | 47 | 2 | 1,200,000$ |
| Dave Barr | 62 | 65 | 69 | 69 | 61 | 55 | 39 | CAN | 55 | 2 | 900,000$ |
| Dave Hakstol | 75 | 70 | 70 | 65 | 65 | 65 | 70 | CAN | 52 | 2 | 925,000$ |
| Davis Payne | 80 | 79 | 73 | 70 | 68 | 64 | 76 | CAN | 45 | 2 | 525,000$ |
| Dean Chynoweth | 55 | 62 | 61 | 64 | 57 | 52 | 60 | CAN | 47 | 3 | 777,400$ |
| Dean Evason | 66 | 62 | 75 | 68 | 67 | 61 | 60 | CAN | 51 | 1 | 780,000$ |
| Denis Savard | 63 | 64 | 69 | 67 | 72 | 70 | 48 | CAN | 55 | 2 | 800,000$ |
| Doug Houda | 59 | 73 | 62 | 65 | 62 | 57 | 54 | CAN | 50 | 1 | 750,000$ |
| Doug Sulliman | 65 | 77 | 75 | 72 | 73 | 68 | 43 | CAN | 56 | 1 | 525,000$ |
| Ed Olcyzk | 74 | 71 | 67 | 76 | 77 | 77 | 73 | USA | 50 | 0 | 1,010,000$ |
| Gary Agnew | 61 | 70 | 71 | 68 | 71 | 63 | 32 | CAN | 56 | 1 | 600,000$ |
| Geoff Ward | 63 | 77 | 66 | 69 | 69 | 65 | 42 | CAN | 54 | 1 | 600,000$ |
| Gerard Gallant | 65 | 70 | 70 | 65 | 70 | 70 | 70 | CAN | 57 | 3 | 1,100,000$ |
| Glen Gulutzan | 62 | 67 | 67 | 70 | 72 | 72 | 68 | CAN | 49 | 0 | 900,000$ |
| Guy Boucher | 57 | 56 | 72 | 64 | 56 | 53 | 53 | CAN | 49 | 2 | 525,000$ |
| Guy Carbonneau | 75 | 75 | 69 | 75 | 75 | 75 | 75 | CAN | 56 | 0 | 1,611,000$ |
| Jack Capuano | 75 | 64 | 81 | 73 | 65 | 69 | 77 | USA | 52 | 2 | 1,385,000$ |
| James Patrick | 58 | 72 | 64 | 65 | 61 | 56 | 49 | CAN | 53 | 2 | 828,000$ |
| Jamie Langenbrunner | 65 | 70 | 75 | 75 | 70 | 70 | 70 | USA | 45 | 3 | 1,250,000$ |
| Jeff Blashill | 60 | 65 | 70 | 65 | 60 | 65 | 65 | USA | 47 | 1 | 800,000$ |
| Jim Johnson | 57 | 64 | 67 | 62 | 59 | 54 | 54 | USA | 53 | 1 | 500,000$ |
| Joe Juneau | 70 | 75 | 75 | 70 | 60 | 70 | 70 | CAN | 51 | 3 | 900,000$ |
| Joe Mullen | 60 | 68 | 76 | 61 | 71 | 60 | 28 | USA | 59 | 1 | 1,000,000$ |
| Joel Quenneville | 74 | 85 | 72 | 74 | 83 | 83 | 67 | CAN | 57 | 1 | 1,409,000$ |
| John Anderson | 73 | 73 | 74 | 74 | 68 | 65 | 72 | CAN | 59 | 1 | 525,000$ |
| John Hynes | 55 | 75 | 65 | 80 | 60 | 65 | 65 | USA | 45 | 1 | 575,000$ |
| John Paddock | 64 | 73 | 74 | 70 | 78 | 66 | 66 | USA | 61 | 1 | 1,000,000$ |
| John Torchetti | 75 | 78 | 71 | 72 | 75 | 68 | 59 | USA | 51 | 4 | 525,000$ |
| Jon Cooper | 64 | 68 | 69 | 78 | 52 | 62 | 78 | CAN | 51 | 1 | 950,000$ |
| Kelly Buchberger | 75 | 77 | 71 | 75 | 75 | 75 | 75 | CAN | 49 | 0 | 1,269,000$ |
| Kevin Constantine | 75 | 70 | 73 | 75 | 75 | 75 | 75 | USA | 58 | 0 | 1,123,000$ |
| Kevin Weekes | 50 | 80 | 60 | 70 | 80 | 80 | 70 | CAN | 45 | 2 | 970,000$ |
| Kirk Muller | 76 | 77 | 74 | 77 | 68 | 74 | 55 | CAN | 50 | 1 | 525,000$ |
| Lane Lambert | 75 | 75 | 70 | 75 | 75 | 75 | 75 | USA | 52 | 0 | 1,226,000$ |
| Marc Crawford | 79 | 73 | 69 | 80 | 77 | 77 | 73 | CAN | 55 | 0 | 1,186,000$ |
| Mario Tremblay | 62 | 70 | 76 | 70 | 78 | 71 | 37 | CAN | 59 | 4 | 1,000,000$ |
| Mark Hardy | 56 | 64 | 70 | 64 | 67 | 53 | 38 | CAN | 57 | 2 | 1,000,000$ |
| Michel Therrien | 67 | 64 | 80 | 74 | 75 | 75 | 74 | CAN | 54 | 3 | 1,437,500$ |
| Mike Kitchen | 77 | 71 | 68 | 74 | 79 | 79 | 71 | CAN | 60 | 0 | 816,000$ |
| Mike Komisarek | 80 | 75 | 60 | 65 | 70 | 70 | 70 | USA | 38 | 1 | 500,000$ |
| Mike Ramsey | 56 | 66 | 68 | 68 | 71 | 54 | 69 | USA | 55 | 2 | 1,000,000$ |
| Mike Sullivan | 59 | 66 | 64 | 61 | 60 | 52 | 61 | USA | 48 | 1 | 645,000$ |
| Mike Yeo | 67 | 72 | 77 | 63 | 71 | 67 | 80 | CAN | 42 | 1 | 500,000$ |
| Nelson Emerson | 75 | 65 | 75 | 75 | 75 | 75 | 75 | USA | 49 | 1 | 901,000$ |
| Newell Brown | 61 | 68 | 75 | 66 | 80 | 64 | 43 | CAN | 54 | 2 | 1,000,000$ |
| Patrick Roy | 77 | 71 | 72 | 81 | 52 | 87 | 73 | CAN | 53 | 1 | 1,750,000$ |
| Paul MacLean | 65 | 76 | 74 | 73 | 77 | 69 | 34 | CAN | 58 | 2 | 1,000,000$ |
| Paul Maurice | 81 | 82 | 71 | 73 | 98 | 87 | 1 | CAN | 49 | 2 | 1,000,000$ |
| Peter DeBoer | 73 | 76 | 72 | 78 | 74 | 73 | 58 | CAN | 48 | 2 | 525,000$ |
| Peter Horachek | 66 | 66 | 78 | 75 | 78 | 72 | 42 | CAN | 56 | 1 | 1,000,000$ |
| Phil Housley | 60 | 75 | 70 | 70 | 75 | 75 | 70 | USA | 56 | 2 | 1,000,000$ |
| Rick Tocchet | 79 | 68 | 76 | 71 | 66 | 60 | 65 | CAN | 52 | 2 | 1,000,000$ |
| Rick Wamsley | 58 | 71 | 65 | 63 | 70 | 60 | 65 | CAN | 57 | 1 | 600,000$ |
| Rod Brind'Amour | 67 | 74 | 76 | 77 | 79 | 79 | 71 | CAN | 44 | 0 | 1,009,000$ |
| Ron Rolston | 60 | 82 | 64 | 72 | 57 | 64 | 66 | USA | 52 | 2 | 1,078,500$ |
| Ryan McGill | 77 | 68 | 68 | 73 | 84 | 84 | 66 | USA | 47 | 0 | 1,255,000$ |
| Scott Arniel | 64 | 75 | 75 | 66 | 64 | 57 | 53 | CAN | 53 | 1 | 525,000$ |
| Scott Gordon | 73 | 74 | 73 | 74 | 72 | 68 | 37 | USA | 53 | 3 | 525,000$ |
| Scott Stevens | 70 | 71 | 71 | 73 | 66 | 72 | 60 | CAN | 55 | 3 | 750,000$ |
| Shane Doan | 83 | 76 | 78 | 74 | 81 | 81 | 69 | CAN | 43 | 2 | 1,000,000$ |
| Steve Konowalchuk | 63 | 71 | 71 | 69 | 62 | 60 | 78 | CAN | 43 | 2 | 525,000$ |
| Stu Barnes | 58 | 65 | 68 | 66 | 58 | 54 | 69 | CAN | 45 | 2 | 700,000$ |
| Todd Richards | 73 | 74 | 76 | 73 | 65 | 60 | 57 | USA | 49 | 1 | 525,000$ |
| Tommy Albelin | 58 | 68 | 66 | 66 | 62 | 61 | 57 | SWE | 52 | 3 | 1,250,000$ |
| Tony Granato | 61 | 73 | 73 | 64 | 70 | 62 | 57 | USA | 51 | 2 | 1,000,000$ |
| Travis Green | 60 | 65 | 65 | 75 | 65 | 65 | 70 | CAN | 50 | 2 | 900,000$ |
| Trent Yawney | 63 | 75 | 76 | 67 | 69 | 63 | 62 | CAN | 50 | 2 | 1,000,000$ |
| Vincent Lecavalier | 75 | 75 | 75 | 65 | 75 | 70 | 70 | CAN | 40 | 2 | 800,000$ |
| Wayne Fleming | 55 | 62 | 63 | 62 | 66 | 53 | 55 | CAN | 61 | 0 | 600,000$ |
| Willie Desjardins | 65 | 65 | 75 | 65 | 80 | 75 | 70 | CAN | 63 | 3 | 1,100,000$ |