A crowd-sourced stats provider.
S p o r t s D a t a b a s e . c o m
tools for the objective handicapper


name
password


NHL Sport Data Query Language Access. SDB Home     NHL Trends     NHL Query


F and playoffs = 1 and ...
gamesSU
W - L (marg, %win)
Avg Lineo:Avg Line$ On$ AgainstOn InvestedAgainst InvestedOU
W - L- P (marg, %over)
Avg Total SDQL
79 51-28 (0.72, 64.6%) -164.6 152.2 +$805 -$1,130 13000.0 7902.0 28-39-12 (-0.35, 41.8%) 5.2 season = 2006
86 53-33 (0.64, 61.6%) -159.8 146.9 +$274 -$673 13742.0 8623.0 38-31-17 (0.27, 55.1%) 5.1 season = 2007
87 57-30 (0.79, 65.5%) -164.8 148.8 +$984 -$1,462 14340.0 8700.0 34-42-11 (0.17, 44.7%) 5.3 season = 2008
88 53-35 (0.51, 60.2%) -170.9 156.8 -$996 +$465 15043.0 8802.0 45-31-12 (0.62, 59.2%) 5.4 season = 2009
87 52-35 (0.21, 59.8%) -146.6 135.1 +$91 -$489 12757.0 8702.0 45-34-8 (0.30, 57.0%) 5.2 season = 2010
85 44-41 (-0.06, 51.8%) -141.7 124.0 -$1,657 +$833 12042.0 8590.0 26-44-15 (-0.19, 37.1%) 5.0 season = 2011
86 52-34 (0.71, 60.5%) -161.0 148.1 -$278 -$192 13844.0 8605.0 31-47-8 (-0.47, 39.7%) 5.9 season = 2012
93 63-30 (0.75, 67.7%) -150.3 135.9 +$1,923 -$2,399 13975.0 9342.0 42-34-17 (0.34, 55.3%) 5.3 season = 2013
89 53-36 (0.25, 59.6%) -145.6 128.1 +$287 -$1,014 12958.0 8930.0 37-40-12 (0.01, 48.1%) 5.1 season = 2014
92 53-39 (0.62, 57.6%) -145.6 127.7 -$319 -$451 13396.0 9295.0 34-35-23 (0.14, 49.3%) 5.0 season = 2015
86 42-44 (0.27, 48.8%) -142.5 131.0 -$1,970 +$1,466 12251.0 8628.0 33-38-15 (0.01, 46.5%) 5.2 season = 2016
82 41-41 (0.35, 50.0%) -162.0 144.0 -$2,270 +$1,486 13282.0 8223.0 34-37-11 (0.23, 47.9%) 5.7 season = 2017
87 42-45 (0.08, 48.3%) -143.5 127.3 -$2,440 +$1,595 12487.0 8713.0 40-40-7 (0.00, 50.0%) 5.6 season = 2018
130 70-60 (0.37, 53.8%) -146.1 129.0 -$1,577 +$547 18999.0 13069.0 52-66-12 (0.07, 44.1%) 5.4 season = 2019

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, wins

Skater 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
e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Content for this site is generated using the Sports Data Query Language (SDQL).