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
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
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
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
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
Claude Giroux, Jakob Silfverberg, Justin Williams, Chris Kreider, Morgan Rielly
Gardien
#1 : Antti Niemi, #2 : Jake Allen
Lignes d'Attaque Perso. en Prol.
, , , , , , , , , ,
Lignes de Défense Perso. en Prol.
, , , ,
Astuces sur les Filtres (Anglais seulement)
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
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
Capacité de l'Aréna - Tendance du Prix des Billets - %
Niveau 1
Niveau 2
Niveau 3
Niveau 4
Luxe
Capacité de l'Aréna
7500
6000
2000
5000
1500
Prix des Billets
150
100
99
98
400
Assistance
185066
136233
46456
82000
29879
Attendance PCT
60.18%
55.38%
56.65%
40.00%
48.58%
Revenus
Matchs à domicile Restants
Assistance Moyenne - %
Revenus Moyen par Match
Revenus Annuels à ce Jour
Capacité de l'Aréna
Popularité de l'Équipe
0
11698 - 53.17%
1,609,023$
65,969,944$
22000
100
Dépenses
Salaire Total des Joueurs
Salaire Total Moyen des Joueurs
Salaire des Coachs
Valeur du Cap Salarial Spécial
56,169,048$
56,769,048$
0$
0$
Dépenses Annuelles à Ce Jour
Cap Salarial Par Jour
Cap salarial à ce jour
Taxe de Luxe Totale
54,956,110$
305,978$
54,409,822$
0$
Éstimation
Revenus de la Saison Éstimés
Jours Restants de la Saison
Dépenses Par Jour
Dépenses de la Saison Éstimées
0$
0
313,089$
0$
Total de l'Équipe Éstimé
Dépenses de la Saison Éstimées
Cap Salarial de la Saison Éstimé
Compte Bancaire Actuel
Compte Bancaire Projeté
0$
59,012,428$
205,228,976$
205,228,976$
Charte de Profondeur
Ailier Gauche
Centre
Ailier Droit
Alex Tanguay
AGE:35
PO:0
OV:69
Carl Soderberg
AGE:29
PO:0
OV:68
Chris Kreider
AGE:24
PO:0
OV:66
Jakob Silfverberg
AGE:24
PO:0
OV:66
Shawn Horcoff
AGE:37
PO:0
OV:64
Brett Connolly
AGE:23
PO:0
OV:61
Jason Zucker
AGE:23
PO:0
OV:61
Calle Jarnkrok
AGE:24
PO:0
OV:61
Sven Baertschi
AGE:22
PO:0
OV:59
Sam Bennett
AGE:19
PO:0
OV:59
Dmitrij Jaskin
AGE:22
PO:0
OV:57
Tomas Jurco
AGE:22
PO:0
OV:56
*Shane Prince
AGE:22
PO:0
OV:55
Connor Brickley
AGE:23
PO:0
OV:54
Matt Puempel
AGE:22
PO:0
OV:54
*Nic Petan
AGE:20
PO:0
OV:54
Max McCormick
AGE:23
PO:0
OV:53
Tanner Kero
AGE:23
PO:0
OV:53
Jujhar Khaira
AGE:21
PO:0
OV:51
Liam O'Brien
AGE:21
PO:0
OV:50
*Adrian Kempe
AGE:19
PO:0
OV:49
*Buddy Robinson
AGE:24
PO:0
OV:49
Daniil Tarasov
AGE:24
PO:0
OV:49
*Artturi Lehkonen
AGE:20
PO:0
OV:45
*Vaclav Karabacek
AGE:19
PO:0
OV:45
*Tim Bozon
AGE:21
PO:0
OV:44
*Tyrell Goulbourne
AGE:21
PO:0
OV:44
*Troy Bourke
AGE:21
PO:0
OV:43
Anze Kopitar
AGE:28
PO:0
OV:74
Claude Giroux
AGE:27
PO:0
OV:72
Carl Soderberg
AGE:29
PO:0
OV:68
Jean-Gabriel Pageau
AGE:22
PO:0
OV:65
Shawn Horcoff
AGE:37
PO:0
OV:64
Sam Reinhart
AGE:19
PO:0
OV:61
Calle Jarnkrok
AGE:24
PO:0
OV:61
Sam Bennett
AGE:19
PO:0
OV:59
*Shane Prince
AGE:22
PO:0
OV:55
Connor Brickley
AGE:23
PO:0
OV:54
Nick Shore
AGE:23
PO:0
OV:54
*Nic Petan
AGE:20
PO:0
OV:54
Max McCormick
AGE:23
PO:0
OV:53
Tanner Kero
AGE:23
PO:0
OV:53
Jujhar Khaira
AGE:21
PO:0
OV:51
Chris Brown
AGE:24
PO:0
OV:47
*Cole Cassels
AGE:20
PO:0
OV:44
*Steven Fogarty
AGE:22
PO:0
OV:44
Justin Williams
AGE:34
PO:0
OV:70
Alex Tanguay
AGE:35
PO:0
OV:69
Jakob Silfverberg
AGE:24
PO:0
OV:66
Brett Connolly
AGE:23
PO:0
OV:61
Jason Zucker
AGE:23
PO:0
OV:61
Sam Reinhart
AGE:19
PO:0
OV:61
Calle Jarnkrok
AGE:24
PO:0
OV:61
David Moss
AGE:33
PO:0
OV:59
Dmitrij Jaskin
AGE:22
PO:0
OV:57
Devin Setoguchi
AGE:28
PO:0
OV:56
Tomas Jurco
AGE:22
PO:0
OV:56
Connor Brickley
AGE:23
PO:0
OV:54
Joel Armia
AGE:22
PO:0
OV:54
Matt Puempel
AGE:22
PO:0
OV:54
*Garnet Hathaway
AGE:23
PO:0
OV:52
*Adrian Kempe
AGE:19
PO:0
OV:49
*Buddy Robinson
AGE:24
PO:0
OV:49
Daniil Tarasov
AGE:24
PO:0
OV:49
Chris Brown
AGE:24
PO:0
OV:47
*Kyle Baun
AGE:23
PO:0
OV:47
*Hunter Smith
AGE:20
PO:0
OV:46
*Artturi Lehkonen
AGE:20
PO:0
OV:45
*Vaclav Karabacek
AGE:19
PO:0
OV:45
*Alex Schoenborn
AGE:19
PO:0
OV:44
Tomas Kubalik
AGE:25
PO:0
OV:42
Défense #1
Défense #2
Gardien
Ryan McDonagh
AGE:26
PO:0
OV:71
Anton Stralman
AGE:29
PO:0
OV:70
Justin Faulk
AGE:23
PO:0
OV:70
Morgan Rielly
AGE:21
PO:0
OV:67
Cody Ceci
AGE:21
PO:0
OV:66
Jacob Trouba
AGE:21
PO:0
OV:66
*Colton Parayko
AGE:22
PO:0
OV:61
Luca Sbisa
AGE:25
PO:0
OV:61
Brandon Davidson
AGE:24
PO:0
OV:60
Josh Manson
AGE:23
PO:0
OV:60
*Klas Dahlbeck
AGE:24
PO:0
OV:59
Ryan Murphy
AGE:22
PO:0
OV:57
*Dylan McIlrath
AGE:23
PO:0
OV:57
Jamie McBain
AGE:27
PO:0
OV:56
*Philip Samuelsson
AGE:24
PO:0
OV:55
Taylor Fedun
AGE:27
PO:0
OV:54
*Scott Mayfield
AGE:22
PO:0
OV:54
Chris Bigras
AGE:20
PO:0
OV:53
Mirco Mueller
AGE:20
PO:0
OV:52
Keegan Lowe
AGE:22
PO:0
OV:50
*Dylan Blujus
AGE:21
PO:0
OV:46
*Jack Dougherty
AGE:19
PO:0
OV:45
*Linus Arnesson
AGE:21
PO:0
OV:45
Jake Allen
AGE:25
PO:0
OV:77
Antti Niemi
AGE:32
PO:0
OV:76
Antti Raanta
AGE:26
PO:0
OV:63
Niklas Svedberg
AGE:26
PO:0
OV:50
Jason Kasdorf
AGE:23
PO:0
OV:48
Sami Aittokallio
AGE:23
PO:0
OV:45
*Vitek Vanecek
AGE:19
PO:0
OV:45
*Sam Brittain
AGE:23
PO:0
OV:43
*Sean Maguire
AGE:22
PO:0
OV:43
*Niklas Lundstrom
AGE:22
PO:0
OV:40
*Adam Wilcox
AGE:22
PO:0
OV:39
Éspoirs
Astuces sur les Filtres (Anglais seulement)
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
Éspoir
Nom de l'Équipe
Année de Repêchage
Choix Total
Information
Lien
Alex Dostie
Detroit
2016
171
Damir Sharipzyanov
Detroit
2016
157
Daniel Pribyl
Detroit
2016
95
Denis Gurianov
Detroit
2015
36
Dennis Gilbert
Detroit
2015
181
Doyle Somerby
Detroit
2016
127
Evan Cormier
Detroit
2016
155
Giorgio Estephan
Detroit
2016
140
Guillaume Brisebois
Detroit
2015
111
Jakob Forsbacka-Karlsson
Detroit
2015
47
Janne Kuokkanen
Detroit
2016
60
Lars Johansson
Detroit
2016
182
Matt Filipe
Detroit
2016
88
Michael McLeod
Detroit
2016
12
Mikhail Vorobyov
Detroit
2015
206
Troy Stecher
Detroit
2016
72
Vladimir Sobotka
Detroit
2016
207
William Borgen
Detroit
2016
86
Choix au Repêchage
Année
R1
R2
R3
R4
R5
R6
R7
2017
Pit Det LA
Det
Det Que
Det
Det Atl Edm Ran
Det
2018
Que Det Pit
Det
Det
Det
Det
Det
2019
Det
Det
Det
Det
Det
Det
2020
Det
Det
Det
Det
Det
Det
Det
2021
Det
Det
Det
Det
Det
Det
Det
[2016-09-11 15:32:51] - Detroit drafts Vladimir Sobotka as the #207 overall pick in the Entry Draft of year 2016. [2016-09-16 21:11:46] - Garnet Hathaway was added to Detroit. [2016-09-16 21:11:49] - Devin Setoguchi was added to Detroit. [2016-09-25 19:26:59] - TRADE : From Detroit to Las Vegas : Dan Ellis (53). [2016-09-25 23:57:11] - Manchots fired Paul Maurice. [2016-09-25 23:57:11] - Detroit fired John Hynes. [2016-09-25 23:57:12] - Detroit hired Paul Maurice for 500 000 $ for 3 year(s). [2016-10-08 09:48:59] - TRADE : From Detroit to San Jose : Scott Gomez (61), 400 000 $ (Money). [2016-10-08 09:48:59] - TRADE : From San Jose to Detroit : 1 $ (Money). [2016-10-27 20:00:14] - New Record for Team's Most Shots Blocked (17) in 1 Game for Detroit! [2016-11-26 20:00:18] - Unknown Player is no longer as assistant for Detroit. [2016-11-26 20:00:18] - Justin Faulk has been selected as assistant for Detroit. [2016-12-23 09:49:51] - Carl Soderberg was added to Detroit. [2016-12-23 09:49:52] - TRADE : From Detroit to Kansas City : Y:2017-RND:2-Det, Y:2017-RND:5-Phi. [2016-12-23 09:49:52] - TRADE : From Kansas City to Detroit : Carl Soderberg (68). [2017-01-31 20:00:19] - New Record for Team's Most Hits (32) in 1 Game for Detroit! [2017-02-04 14:30:45] - Aaron Ekblad was added to Detroit. [2017-02-04 14:30:45] - Antti Raanta was added to Detroit. [2017-02-04 14:30:45] - Cody Ceci was added to Detroit. [2017-02-04 14:30:45] - Sam Bennett was added to Detroit. [2017-02-04 14:30:46] - TRADE : From Detroit to Caroline : Juuse Saros (48), Ryan Ellis (65), Dylan Strome (P), Olli Juolevi (P). [2017-02-04 14:30:46] - TRADE : From Caroline to Detroit : Aaron Ekblad (66), Antti Raanta (63), Cody Ceci (66), Sam Bennett (59). [2017-02-19 10:17:40] - Morgan Rielly was added to Detroit. [2017-02-19 10:17:40] - Sam Reinhart was added to Detroit. [2017-02-19 10:17:42] - TRADE : From Quebec to Detroit : Morgan Rielly (67), Sam Reinhart (61), Y:2018-RND:1-Que, Y:2017-RND:4-Que. [2017-02-19 10:17:42] - TRADE : From Detroit to Quebec : Aaron Ekblad (66), Zachary Werenski (P), Y:2019-RND:2-Det. [2017-03-02 00:02:15] - Shawn Horcoff was added to Detroit. [2017-03-02 00:02:16] - TRADE : From Caroline to Detroit : Shawn Horcoff (63). [2017-03-02 00:02:16] - TRADE : From Detroit to Caroline : Y:2017-RND:7-Edm. [2017-03-08 00:50:36] - New Record for Team's Most Goals (10) in 1 Game for Detroit! [2017-03-08 00:50:36] - New Record for Team's Most Assists (18) in 1 Game for Detroit! [2017-03-08 00:50:36] - New Record for Team's Most Points (28) in 1 Game for Detroit!