| team = Bruins |
|---|
| SU: |
597-488 (0.35, 55.0%) |
avg line: -130.4 / 117.2 |
on / against: -$820 / -$4,982 |
ROI: -0.5% / -4.0% |
|---|
| OU: |
458-515-112 (0.08, 47.1%) |
avg total: 5.4 |
| |
|---|
|
|
SoG |
Pens |
P-Mins |
P1 |
P2 |
P3 |
Final |
|---|
| Team |
31.5 |
4.7 |
11.9 |
0.9 |
0.9 |
1.0 |
2.9 |
|---|
| Opp |
30.3 |
4.5 |
11.4 |
0.7 |
0.9 |
0.8 |
2.6 |
|---|
|
| Date |
Day |
Season |
Team |
Opp |
Site |
P1 |
P2 |
P3 |
Final |
Line |
Total |
SUm |
SUr |
OUr |
ot |
|
Oct 27, 2018
|
Saturday
|
2018
|
Bruins
|
Canadiens
|
home
|
0-2
|
0-0
|
0-1
|
0-3
|
-185
|
5.5
|
-3
|
L
|
U
|
0
|
|
Oct 30, 2018
|
Tuesday
|
2018
|
Bruins
|
Hurricanes
|
away
|
0-1
|
2-1
|
1-0
|
3-2
|
117
|
6.0
|
1
|
W
|
U
|
0
|
|
Nov 03, 2018
|
Saturday
|
2018
|
Bruins
|
Predators
|
away
|
0-1
|
0-0
|
0-0
|
0-1
|
123
|
5.5
|
-1
|
L
|
U
|
0
|
|
Nov 05, 2018
|
Monday
|
2018
|
Bruins
|
Stars
|
home
|
1-1
|
0-0
|
0-0
|
2-1
|
-150
|
5.5
|
1
|
W
|
U
|
1
|
|
Nov 08, 2018
|
Thursday
|
2018
|
Bruins
|
Canucks
|
home
|
1-1
|
3-5
|
1-2
|
5-8
|
-254
|
5.5
|
-3
|
L
|
O
|
0
|
|
Nov 10, 2018
|
Saturday
|
2018
|
Bruins
|
Maple Leafs
|
home
|
1-0
|
2-1
|
2-0
|
5-1
|
-150
|
6.0
|
4
|
W
|
P
|
0
|
|
Nov 11, 2018
|
Sunday
|
2018
|
Bruins
|
Knights
|
home
|
2-0
|
1-1
|
1-0
|
4-1
|
-172
|
5.5
|
3
|
W
|
U
|
0
|
|
Nov 14, 2018
|
Wednesday
|
2018
|
Bruins
|
Avalanche
|
away
|
2-1
|
1-1
|
0-4
|
3-6
|
101
|
6.0
|
-3
|
L
|
O
|
0
|
|
Nov 16, 2018
|
Friday
|
2018
|
Bruins
|
Stars
|
away
|
0-0
|
0-0
|
0-0
|
0-1
|
100
|
5.5
|
-1
|
L
|
U
|
1
|
|
Nov 17, 2018
|
Saturday
|
2018
|
Bruins
|
Coyotes
|
away
|
2-0
|
0-1
|
0-0
|
2-1
|
-121
|
5.5
|
1
|
W
|
U
|
0
|
|
Nov 21, 2018
|
Wednesday
|
2018
|
Bruins
|
Red Wings
|
away
|
|
|
|
|
-131
|
5.5
|
|
|
|
|
|
Nov 23, 2018
|
Friday
|
2018
|
Bruins
|
Penguins
|
home
|
|
|
|
|
|
|
|
|
|
|
|
Nov 24, 2018
|
Saturday
|
2018
|
Bruins
|
Canadiens
|
away
|
|
|
|
|
|
|
|
|
|
|
|
Nov 26, 2018
|
Monday
|
2018
|
Bruins
|
Maple Leafs
|
away
|
|
|
|
|
|
|
|
|
|
|
|
Nov 29, 2018
|
Thursday
|
2018
|
Bruins
|
Islanders
|
home
|
|
|
|
|
|
|
|
|
|
|
|
Dec 01, 2018
|
Saturday
|
2018
|
Bruins
|
Red Wings
|
home
|
|
|
|
|
|
|
|
|
|
|
|
Dec 04, 2018
|
Tuesday
|
2018
|
Bruins
|
Panthers
|
away
|
|
|
|
|
|
|
|
|
|
|
|
Dec 06, 2018
|
Thursday
|
2018
|
Bruins
|
Lightning
|
away
|
|
|
|
|
|
|
|
|
|
|
|
Dec 08, 2018
|
Saturday
|
2018
|
Bruins
|
Maple Leafs
|
home
|
|
|
|
|
|
|
|
|
|
|
|
Dec 09, 2018
|
Sunday
|
2018
|
Bruins
|
Senators
|
away
|
|
|
|
|
|
|
|
|
|
|
|
Game Parameters: ROT, abbreviation, attendance, city, conference, conference game, date, day, division, faceoffs won, game number, goals, line, linesmen, losses, margin, matchup losses, matchup wins, month, opponents, ou margin, ou streak, overtime, penalties, penalty minutes, period scores, playoffs, 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
