Information you need to win.
S p o r t s D a t a b a s e . c o m
agile access to sports data


name
password


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


rest = 0 and ...
gamesSU
W - L (marg, %win)
Avg Lineo:Avg Line$ On$ AgainstOn InvestedAgainst InvestedOU
W - L- P (marg, %over)
Avg Total SDQL
202 94-108 (-0.18, 46.5%) 119.4 -137.3 -$62 -$1,347 23854.0 30377.0 83-108-11 (-0.07, 43.5%) 5.7 Senators
207 70-137 (-0.77, 33.8%) 121.1 -137.7 -$5,969 +$4,638 23616.0 30498.0 88-113-6 (0.04, 43.8%) 5.8 Maple Leafs
159 57-102 (-0.51, 35.8%) 132.8 -149.4 -$3,340 +$2,314 17580.0 24905.0 66-84-9 (0.04, 44.0%) 5.6 Avalanche
173 78-95 (-0.32, 45.1%) 122.1 -138.7 -$753 -$355 19837.0 25742.0 76-82-15 (0.00, 48.1%) 5.4 Canucks
204 91-113 (-0.30, 44.6%) 101.5 -117.0 -$3,131 +$1,594 24439.0 26631.0 79-103-22 (0.04, 43.4%) 5.5 Canadiens
236 88-148 (-0.59, 37.3%) 133.5 -152.5 -$4,954 +$3,284 26407.0 37861.0 109-111-16 (-0.00, 49.5%) 5.6 Sabres
227 110-117 (-0.19, 48.5%) 107.5 -122.7 -$495 -$1,021 26718.0 30628.0 89-115-23 (-0.03, 43.6%) 5.6 Hurricanes
190 87-103 (-0.32, 45.8%) 112.8 -128.2 -$1,247 +$12 22397.0 26804.0 79-100-11 (0.12, 44.1%) 5.4 Ducks
229 109-120 (-0.23, 47.6%) 117.8 -133.2 +$324 -$1,825 25840.0 32618.0 90-111-28 (-0.12, 44.8%) 5.4 Devils
196 85-111 (-0.39, 43.4%) 137.3 -154.1 -$547 -$784 21226.0 31257.0 78-102-16 (-0.01, 43.3%) 5.6 Panthers
202 101-101 (0.12, 50.0%) -113.1 -102.3 -$1,165 -$206 26352.0 25061.0 79-110-13 (-0.20, 41.8%) 5.5 Bruins
180 82-98 (-0.10, 45.6%) 128.3 -144.1 +$340 -$1,452 20125.0 27345.0 72-90-18 (-0.09, 44.4%) 5.4 Kings
230 93-137 (-0.40, 40.4%) 132.0 -149.3 -$2,338 +$852 25451.0 36068.0 105-115-9 (0.23, 47.7%) 5.5 Blue Jackets
214 101-113 (-0.36, 47.2%) 114.5 -129.6 -$58 -$1,526 24541.0 29813.0 112-91-11 (0.51, 55.2%) 5.6 Flyers
213 99-114 (-0.15, 46.5%) 127.9 -144.3 +$393 -$1,817 24045.0 32536.0 98-102-13 (0.13, 49.0%) 5.6 Islanders
185 107-78 (0.37, 57.8%) -113.7 -100.1 +$2,566 -$3,554 23234.0 21850.0 85-85-15 (0.14, 50.0%) 5.5 Sharks
80 29-51 (-1.11, 36.2%) 141.7 -156.0 -$1,512 +$1,215 8504.0 12798.0 42-32-6 (0.51, 56.8%) 5.9 Thrashers
180 83-97 (-0.31, 46.1%) 111.7 -127.9 -$946 -$303 21367.0 25268.0 88-81-11 (0.23, 52.1%) 5.7 Lightning
182 78-104 (-0.45, 42.9%) 115.2 -129.0 -$1,400 +$312 20760.0 25336.0 90-87-4 (0.41, 50.8%) 5.5 Stars
152 57-95 (-0.74, 37.5%) 159.7 -178.7 -$1,294 +$376 16009.0 27759.0 76-69-7 (0.44, 52.4%) 5.5 Oilers
205 89-116 (-0.24, 43.4%) -107.0 -107.9 -$3,428 +$2,336 25826.0 25924.0 102-97-6 (0.32, 51.3%) 5.7 Capitals
213 105-108 (-0.01, 49.3%) -120.7 105.9 -$1,348 +$134 28305.0 25119.0 94-107-12 (0.10, 46.8%) 5.7 Penguins
173 82-91 (-0.09, 47.4%) 102.4 -116.2 -$633 -$425 20699.0 22535.0 87-74-12 (0.47, 54.0%) 5.4 Predators
200 101-99 (-0.01, 50.5%) 108.1 -124.7 +$595 -$1,715 24355.0 28009.0 85-101-14 (0.04, 45.7%) 5.5 Red Wings
193 86-107 (-0.36, 44.6%) 121.7 -137.1 -$970 -$403 21147.0 27541.0 87-84-22 (0.23, 50.9%) 5.3 Wild
226 131-95 (0.33, 58.0%) -108.9 -107.8 +$3,406 -$4,793 30154.0 29940.0 104-109-13 (0.12, 48.8%) 5.6 Blackhawks
206 104-102 (0.05, 50.5%) 111.3 -125.7 +$1,683 -$3,024 23872.0 28070.0 95-96-15 (0.28, 49.7%) 5.4 Blues
189 72-117 (-0.71, 38.1%) 149.6 -167.3 -$1,892 +$607 19795.0 32177.0 100-77-12 (0.35, 56.5%) 5.5 Coyotes
197 117-80 (0.43, 59.4%) -105.6 -109.9 +$4,016 -$5,318 24437.0 24899.0 81-99-16 (-0.04, 45.0%) 5.5 Rangers
163 71-92 (-0.44, 43.6%) 130.3 -146.1 -$372 -$523 17624.0 24689.0 71-81-11 (0.00, 46.7%) 5.5 Flames
94 40-54 (-0.50, 42.6%) 127.7 -145.5 -$414 -$203 10311.0 14194.0 40-46-7 (-0.04, 46.5%) 5.7 Jets
39 22-17 (0.36, 56.4%) -107.1 -108.8 +$428 -$635 5017.0 5006.0 19-19-1 (0.27, 50.0%) 5.9 Knights

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).