| The Blue Jackets are 1-9-1 AGAINST since Nov 01, 2018 as a road dog |
|---|
| SU: |
8-6 (0.21, 57.1%) |
avg line: 122.2 / -137.2 |
on / against: +$371 / -$486 |
ROI: +26.4% / -25.2% |
|---|
| OU: |
4-9-1 (-0.96, 30.8%) |
avg total: 6.2 |
| |
|---|
|
|
SoG |
Pens |
P-Mins |
P1 |
P2 |
P3 |
Final |
|---|
| Team |
30.5 |
3.2 |
6.4 |
0.9 |
0.9 |
0.7 |
2.7 |
|---|
| Opp |
30.8 |
2.9 |
6.1 |
1.1 |
0.7 |
0.6 |
2.5 |
|---|
|
| Date |
Day |
Season |
Team |
Opp |
Site |
P1 |
P2 |
P3 |
Final |
Line |
Total |
SUm |
SUr |
OUr |
ot |
|
Nov 01, 2018
|
Thursday
|
2018
|
Blue Jackets
|
Sharks
|
away
|
1-1
|
2-0
|
1-0
|
4-1
|
145
|
6.0
|
3
|
W
|
U
|
0
|
|
Nov 04, 2018
|
Sunday
|
2018
|
Blue Jackets
|
Ducks
|
away
|
0-0
|
1-2
|
1-0
|
2-3
|
106
|
5.5
|
-1
|
L
|
U
|
1
|
|
Nov 09, 2018
|
Friday
|
2018
|
Blue Jackets
|
Capitals
|
away
|
1-0
|
0-1
|
1-0
|
2-1
|
106
|
6.0
|
1
|
W
|
U
|
0
|
|
Nov 12, 2018
|
Monday
|
2018
|
Blue Jackets
|
Stars
|
away
|
0-0
|
1-1
|
1-0
|
2-1
|
-104
|
6.0
|
1
|
W
|
U
|
0
|
|
Nov 17, 2018
|
Saturday
|
2018
|
Blue Jackets
|
Hurricanes
|
away
|
1-0
|
3-1
|
0-0
|
4-1
|
114
|
6.0
|
3
|
W
|
U
|
0
|
|
Nov 19, 2018
|
Monday
|
2018
|
Blue Jackets
|
Maple Leafs
|
away
|
2-0
|
0-2
|
0-2
|
2-4
|
121
|
6.0
|
-2
|
L
|
P
|
0
|
|
Nov 24, 2018
|
Saturday
|
2018
|
Blue Jackets
|
Penguins
|
away
|
1-3
|
1-1
|
0-0
|
2-4
|
125
|
6.5
|
-2
|
L
|
U
|
0
|
|
Jan 05, 2019
|
Saturday
|
2018
|
Blue Jackets
|
Panthers
|
away
|
1-2
|
1-0
|
1-1
|
4-3
|
104
|
6.5
|
1
|
W
|
O
|
1
|
|
Jan 08, 2019
|
Tuesday
|
2018
|
Blue Jackets
|
Lightning
|
away
|
0-2
|
0-0
|
0-2
|
0-4
|
166
|
6.5
|
-4
|
L
|
U
|
0
|
|
Jan 12, 2019
|
Saturday
|
2018
|
Blue Jackets
|
Capitals
|
away
|
1-0
|
0-0
|
0-1
|
2-1
|
140
|
6.5
|
1
|
W
|
U
|
1
|
|
Jan 19, 2019
|
Saturday
|
2018
|
Blue Jackets
|
Wild
|
away
|
0-2
|
1-0
|
0-0
|
1-2
|
110
|
6.0
|
-1
|
L
|
U
|
0
|
|
Jan 31, 2019
|
Thursday
|
2018
|
Blue Jackets
|
Jets
|
away
|
2-1
|
1-1
|
0-2
|
3-4
|
133
|
6.5
|
-1
|
L
|
O
|
0
|
|
Feb 05, 2019
|
Tuesday
|
2018
|
Blue Jackets
|
Avalanche
|
away
|
2-2
|
1-1
|
3-0
|
6-3
|
105
|
6.5
|
3
|
W
|
O
|
0
|
|
Feb 09, 2019
|
Saturday
|
2018
|
Blue Jackets
|
Knights
|
away
|
1-2
|
1-0
|
2-1
|
4-3
|
157
|
6.0
|
1
|
W
|
O
|
0
|
|
Feb 19, 2019
|
Tuesday
|
2018
|
Blue Jackets
|
Canadiens
|
away
|
|
|
|
|
105
|
|
|
|
|
|
|
Game Parameters: ROT, abbreviation, attendance, city, conference, conference game, date, day, division, faceoffs won, full name, game number, goals, line, linesmen, losses, margin, matchup losses, matchup wins, month, open total, opponents, ou margin, ou streak, overtime, penalties, penalty minutes, period scores, playoffs, points, referees, rest, season, shoot out, shots on goal, site, site streak, start time, streak, team, total, winsSkater Parameters: assists, faceoffs lost, faceoffs won, goals, minutes, minutes even, minutes power play, minutes short handed, name, number, penalty minutes, plus minus, points, position, power play goals, shifts, short handed goals, shots on goal
How to Query:The basic SDQL syntax is: fields @ conditions .
fields is a comma delimited list of one or more sql-like `select` terms.These can be built out of database parameters, constants, and python functions.
conditions is a conjunction (`and` / `or`) delimited list of one or more sql-like `where` terms.As with fields, each condition can be built out of database parameters, constants, and python functions.
The full SDQL query for average margin for each team is:A(margin) @ team
