| F and playoffs = 1 and season = 2017 |
|---|
| SU: |
41-41 (0.35, 50.0%) |
avg line: -162.0 / 144.0 |
on / against: -$2,270 / +$1,486 |
ROI: -17.1% / +18.1% |
|---|
| OU: |
34-37-11 (0.23, 47.9%) |
avg total: 5.7 |
| |
|---|
|
|
SoG |
Pens |
P-Mins |
P1 |
P2 |
P3 |
Final |
|---|
| Team |
33.2 |
0.0 |
10.1 |
0.9 |
1.1 |
1.0 |
3.1 |
|---|
| Opp |
28.8 |
0.0 |
11.1 |
0.7 |
1.0 |
1.0 |
2.8 |
|---|
|
| Date |
Day |
Season |
Team |
Opp |
Site |
P1 |
P2 |
P3 |
Final |
Line |
Total |
SUm |
SUr |
OUr |
ot |
|
May 07, 2018
|
Monday
|
2017
|
Penguins
|
Capitals
|
home
|
0-0
|
1-1
|
0-0
|
1-2
|
-190
|
6.0
|
-1
|
L
|
U
|
1
|
|
May 07, 2018
|
Monday
|
2017
|
Jets
|
Predators
|
home
|
0-1
|
0-1
|
0-2
|
0-4
|
-147
|
6.0
|
-4
|
L
|
U
|
0
|
|
May 10, 2018
|
Thursday
|
2017
|
Predators
|
Jets
|
home
|
1-2
|
0-1
|
0-2
|
1-5
|
-152
|
5.5
|
-4
|
L
|
O
|
0
|
|
May 11, 2018
|
Friday
|
2017
|
Lightning
|
Capitals
|
home
|
0-2
|
0-2
|
2-0
|
2-4
|
-200
|
6.0
|
-2
|
L
|
P
|
0
|
|
May 12, 2018
|
Saturday
|
2017
|
Jets
|
Knights
|
home
|
3-1
|
1-1
|
0-0
|
4-2
|
-140
|
6.0
|
2
|
W
|
P
|
0
|
|
May 13, 2018
|
Sunday
|
2017
|
Lightning
|
Capitals
|
home
|
2-1
|
0-3
|
0-2
|
2-6
|
-200
|
6.0
|
-4
|
L
|
O
|
0
|
|
May 14, 2018
|
Monday
|
2017
|
Jets
|
Knights
|
home
|
0-2
|
0-0
|
1-1
|
1-3
|
-150
|
6.0
|
-2
|
L
|
U
|
0
|
|
May 15, 2018
|
Tuesday
|
2017
|
Capitals
|
Lightning
|
home
|
0-1
|
1-3
|
1-0
|
2-4
|
-125
|
6.0
|
-2
|
L
|
P
|
0
|
|
May 16, 2018
|
Wednesday
|
2017
|
Knights
|
Jets
|
home
|
1-0
|
2-1
|
1-1
|
4-2
|
-135
|
5.5
|
2
|
W
|
O
|
0
|
|
May 17, 2018
|
Thursday
|
2017
|
Capitals
|
Lightning
|
home
|
1-2
|
1-0
|
0-2
|
2-4
|
-120
|
6.0
|
-2
|
L
|
P
|
0
|
|
May 18, 2018
|
Friday
|
2017
|
Knights
|
Jets
|
home
|
1-0
|
1-1
|
1-1
|
3-2
|
-120
|
5.5
|
1
|
W
|
U
|
0
|
|
May 19, 2018
|
Saturday
|
2017
|
Lightning
|
Capitals
|
home
|
2-0
|
1-1
|
0-1
|
3-2
|
-145
|
6.0
|
1
|
W
|
U
|
0
|
|
May 20, 2018
|
Sunday
|
2017
|
Jets
|
Knights
|
home
|
1-1
|
0-1
|
0-0
|
1-2
|
-170
|
6.0
|
-1
|
L
|
U
|
0
|
|
May 21, 2018
|
Monday
|
2017
|
Capitals
|
Lightning
|
home
|
0-0
|
1-0
|
2-0
|
3-0
|
-135
|
6.0
|
3
|
W
|
U
|
0
|
|
May 23, 2018
|
Wednesday
|
2017
|
Lightning
|
Capitals
|
home
|
0-1
|
0-2
|
0-1
|
0-4
|
-135
|
5.5
|
-4
|
L
|
U
|
0
|
|
May 28, 2018
|
Monday
|
2017
|
Knights
|
Capitals
|
home
|
2-2
|
1-1
|
3-1
|
6-4
|
-155
|
5.5
|
2
|
W
|
O
|
0
|
|
May 30, 2018
|
Wednesday
|
2017
|
Knights
|
Capitals
|
home
|
1-1
|
1-2
|
0-0
|
2-3
|
-140
|
5.5
|
-1
|
L
|
U
|
0
|
|
Jun 02, 2018
|
Saturday
|
2017
|
Capitals
|
Knights
|
home
|
0-0
|
2-0
|
1-1
|
3-1
|
-130
|
5.5
|
2
|
W
|
U
|
0
|
|
Jun 04, 2018
|
Monday
|
2017
|
Capitals
|
Knights
|
home
|
3-0
|
1-0
|
2-2
|
6-2
|
-125
|
5.5
|
4
|
W
|
O
|
0
|
|
Jun 07, 2018
|
Thursday
|
2017
|
Knights
|
Capitals
|
home
|
0-0
|
3-2
|
0-2
|
3-4
|
-161
|
5.5
|
-1
|
L
|
O
|
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
