| F and playoffs = 1 and season = 2018 |
|---|
| SU: |
42-45 (0.08, 48.3%) |
avg line: -143.5 / 127.3 |
on / against: -$2,440 / +$1,595 |
ROI: -19.5% / +18.3% |
|---|
| OU: |
40-40-7 (0.00, 50.0%) |
avg total: 5.6 |
| |
|---|
|
|
SoG |
Pens |
P-Mins |
P1 |
P2 |
P3 |
Final |
|---|
| Team |
32.5 |
3.5 |
8.3 |
0.9 |
0.8 |
1.0 |
2.8 |
|---|
| Opp |
30.3 |
4.0 |
9.5 |
0.7 |
0.8 |
1.1 |
2.7 |
|---|
|
| Date |
Day |
Season |
Team |
Opp |
Site |
P1 |
P2 |
P3 |
Final |
Line |
Total |
SUm |
SUr |
OUr |
ot |
|
May 06, 2019
|
Monday
|
2018
|
Avalanche
|
Sharks
|
home
|
0-0
|
2-2
|
1-1
|
4-3
|
-130
|
5.5
|
1
|
W
|
O
|
1
|
|
May 07, 2019
|
Tuesday
|
2018
|
Blues
|
Stars
|
home
|
1-1
|
0-0
|
0-0
|
2-1
|
-145
|
5.0
|
1
|
W
|
U
|
1
|
|
May 08, 2019
|
Wednesday
|
2018
|
Sharks
|
Avalanche
|
home
|
2-1
|
1-0
|
0-1
|
3-2
|
-149
|
5.5
|
1
|
W
|
U
|
0
|
|
May 09, 2019
|
Thursday
|
2018
|
Bruins
|
Hurricanes
|
home
|
1-1
|
0-1
|
4-0
|
5-2
|
-156
|
5.5
|
3
|
W
|
O
|
0
|
|
May 11, 2019
|
Saturday
|
2018
|
Sharks
|
Blues
|
home
|
2-1
|
3-1
|
1-1
|
6-3
|
-129
|
5.5
|
3
|
W
|
O
|
0
|
|
May 12, 2019
|
Sunday
|
2018
|
Bruins
|
Hurricanes
|
home
|
2-0
|
2-0
|
2-2
|
6-2
|
-155
|
5.5
|
4
|
W
|
O
|
0
|
|
May 13, 2019
|
Monday
|
2018
|
Sharks
|
Blues
|
home
|
0-1
|
2-2
|
0-1
|
2-4
|
-135
|
5.5
|
-2
|
L
|
O
|
0
|
|
May 14, 2019
|
Tuesday
|
2018
|
Hurricanes
|
Bruins
|
home
|
0-0
|
1-2
|
0-0
|
1-2
|
-125
|
5.5
|
-1
|
L
|
U
|
0
|
|
May 15, 2019
|
Wednesday
|
2018
|
Blues
|
Sharks
|
home
|
0-2
|
4-1
|
0-1
|
4-5
|
-138
|
5.5
|
-1
|
L
|
O
|
1
|
|
May 16, 2019
|
Thursday
|
2018
|
Bruins
|
Hurricanes
|
away
|
0-0
|
2-0
|
2-0
|
4-0
|
-115
|
5.5
|
4
|
W
|
U
|
0
|
|
May 17, 2019
|
Friday
|
2018
|
Blues
|
Sharks
|
home
|
2-0
|
0-0
|
0-1
|
2-1
|
-135
|
5.5
|
1
|
W
|
U
|
0
|
|
May 19, 2019
|
Sunday
|
2018
|
Sharks
|
Blues
|
home
|
0-1
|
0-2
|
0-2
|
0-5
|
-138
|
5.5
|
-5
|
L
|
U
|
0
|
|
May 21, 2019
|
Tuesday
|
2018
|
Blues
|
Sharks
|
home
|
2-0
|
1-1
|
2-0
|
5-1
|
-186
|
5.5
|
4
|
W
|
O
|
0
|
|
May 27, 2019
|
Monday
|
2018
|
Bruins
|
Blues
|
home
|
0-1
|
2-1
|
2-0
|
4-2
|
-170
|
5.5
|
2
|
W
|
O
|
0
|
|
May 29, 2019
|
Wednesday
|
2018
|
Bruins
|
Blues
|
home
|
2-2
|
0-0
|
0-0
|
2-3
|
-165
|
5.5
|
-1
|
L
|
U
|
1
|
|
Jun 01, 2019
|
Saturday
|
2018
|
Blues
|
Bruins
|
home
|
0-3
|
1-2
|
1-2
|
2-7
|
-120
|
5.0
|
-5
|
L
|
O
|
0
|
|
Jun 03, 2019
|
Monday
|
2018
|
Blues
|
Bruins
|
home
|
2-1
|
0-1
|
2-0
|
4-2
|
-113
|
5.5
|
2
|
W
|
O
|
0
|
|
Jun 06, 2019
|
Thursday
|
2018
|
Bruins
|
Blues
|
home
|
0-0
|
0-1
|
1-1
|
1-2
|
-161
|
5.5
|
-1
|
L
|
U
|
0
|
|
Jun 09, 2019
|
Sunday
|
2018
|
Blues
|
Bruins
|
home
|
0-1
|
0-0
|
1-4
|
1-5
|
-115
|
5.0
|
-4
|
L
|
O
|
0
|
|
Jun 12, 2019
|
Wednesday
|
2018
|
Bruins
|
Blues
|
home
|
0-2
|
0-0
|
1-2
|
1-4
|
-179
|
5.0
|
-3
|
L
|
P
|
0
|
|
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, opponents, ou margin, ou streak, over, overtime, p1 line, penalties, penalty minutes, period scores, playoffs, referees, regulation line, rest, season, shoot out, shots on goal, site, site streak, start time, streak, team, total, under, 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
