Éspoirs

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

Adam Huska

Colorado Avalanche

11

115

Brian Ferlin

Colorado Avalanche

Caleb Jones

Colorado Avalanche

11

90

Chris Calnan

Colorado Avalanche

8

83

Connor Crisp

Colorado Avalanche

Givani Smith

Colorado Avalanche

12

71

Ilya Sorokin

Colorado Avalanche

10

73

Jacob Larsson

Colorado Avalanche

11

25

Joshua Mahura

Colorado Avalanche

12

45

Kirill Kaprizov

Colorado Avalanche

11

52

Louis Belpedio

Colorado Avalanche

10

45

Lukas Vejdemo

Colorado Avalanche

11

89

Marcus Pettersson

Colorado Avalanche

10

66

Max Jones

Colorado Avalanche

12

38

Nicolas Roy

Colorado Avalanche

11

45

Otto Koivula

Colorado Avalanche

12

55

Ryan Donato

Colorado Avalanche

10

68

Ryan Fitzgerald

Colorado Avalanche

9

59

Ryan Lindgren

Colorado Avalanche

12

85

Samuel Montembeault

Colorado Avalanche

11

60

Sean Day

Colorado Avalanche

12

65

Victor Olofsson

Colorado Avalanche

10

100

Vili Saarijärvi

Colorado Avalanche

11

79

Zach Nastasiuk

Colorado Avalanche

Choix au Repêchage

Année

R1

R2

R3

R4

R5

R6

13

Col PHX

Col Cal Pit PHX

MTL

Cal

14

Col PHX

Col PHX

Col Dal

Col

15

Col

Col

Col

Col

Col

16

Col

Col

Col

Col

Col

17

Col

Col

Col

Col

Col

Col

[2018-02-08 14:28:54] - New Record for Team's Most Shots (58) in 1 Game for Colorado Avalanche![2018-01-22 17:04:04] - New Record for Team's Most Points (23) in 1 Game for Colorado Avalanche![2018-01-22 17:04:04] - New Record for Team's Most Assists (15) in 1 Game for Colorado Avalanche![2017-10-03 23:41:39] - Dan Renouf was added to Colorado Avalanche.[2017-09-24 08:11:41] - TRADE : From New York Islanders to Colorado Avalanche : Y:13-RND:5-Cal, Y:14-RND:3-Dal.[2017-09-24 08:11:41] - TRADE : From Colorado Avalanche to New York Islanders : Eric Gryba.

[2018-04-06 16:47:11] Auto Lines Partial Function has been run for Colorado Avalanche.[2018-04-06 16:47:11] Auto Roster Partial Function has been run for Colorado Avalanche.[2018-04-05 16:19:55] Game 1212 - Hampus Lindholm from Colorado Avalanche is injured (Bruised Left Shoulder) and is out for 1 week.[2018-04-05 16:17:46] Auto Lines Partial Function has been run for Colorado Avalanche.[2018-04-05 16:17:46] Auto Roster Partial Function has been run for Colorado Avalanche.[2018-04-02 14:49:43] Leon Draisaitl from Colorado Avalanche is back from Right Leg Injury.[2018-03-30 11:09:48] Game 1186 - Leon Draisaitl from Colorado Avalanche is injured (Right Leg) and is out for 1 week.[2018-03-24 20:03:30] Successfully loaded Colorado Avalanche lines done with STHS Client - 3.1.2.2[2018-03-23 12:48:08] Auto Lines Partial Function has been run for Colorado Avalanche.[2018-03-23 12:48:08] Auto Roster Partial Function has been run for Colorado Avalanche.[2018-03-21 08:52:38] Kevin Bieksa from Colorado Avalanche is back from Bruised Left Arm Injury.[2018-03-20 08:49:54] Game 1136 - Kevin Bieksa from Colorado Avalanche is injured (Bruised Left Arm) and is out for 4 days.[2018-03-19 12:04:17] Auto Lines Partial Function has been run for Colorado Avalanche.[2018-03-19 12:04:17] Auto Roster Partial Function has been run for Colorado Avalanche.[2018-03-16 07:49:59] Antti Raanta from Colorado Avalanche is back from Exhaustion.[2018-03-15 17:20:42] Antti Raanta from Colorado Avalanche injured (Exhaustion)[2018-03-14 18:27:11] Shayne Gostisbehere from Colorado Avalanche is back from Left Leg Injury.[2018-03-11 12:49:23] Sergei Bobrovsky from Colorado Avalanche is back from Exhaustion.[2018-03-11 12:49:23] Mike Fisher from Colorado Avalanche is back from Bruised Left Leg Injury.[2018-03-11 12:49:19] Game 1073 - Mike Fisher from Colorado Avalanche is injured (Bruised Left Leg) and is out for 2 days.[2018-03-11 12:48:31] Auto Lines Partial Function has been run for Colorado Avalanche.[2018-03-11 12:48:31] Auto Roster Partial Function has been run for Colorado Avalanche.[2018-03-10 12:58:58] Jeff Petry from Colorado Avalanche is back from Fractured Orbital Bone Injury.[2018-03-10 12:58:56] Sergei Bobrovsky from Colorado Avalanche injured (Exhaustion)[2018-03-09 12:22:25] Brandon Carlo from Colorado Avalanche is back from Right Leg Injury.[2018-03-09 12:22:20] Game 1058 - Brandon Carlo from Colorado Avalanche is injured (Right Leg) and is out for 2 days.[2018-03-09 12:22:13] Auto Lines Partial Function has been run for Colorado Avalanche.[2018-03-09 12:22:13] Auto Roster Partial Function has been run for Colorado Avalanche.
[2018-03-09 12:22:13] Steven Santini of Colorado Avalanche was sent to pro.[2018-03-07 16:47:23] Antti Raanta from Colorado Avalanche is back from Exhaustion.[2018-03-06 18:38:58] Luke Glendening from Colorado Avalanche is back from Bruised Left Shoulder Injury.[2018-03-06 18:38:58] Antti Raanta from Colorado Avalanche injured (Exhaustion)[2018-03-06 18:38:58] Game 1050 - Shayne Gostisbehere from Colorado Avalanche is injured (Left Leg) and is out for 1 week.