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

Permission is given to quote trends found on SportsDataBase.com provided that a reference and a link to SportsDataBase.com is provided. E.g.: Trend found on SportsDataBase.com


name
password


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


H and p:margin = -1 and op:H and op:goals >= 3 and opo:goals >= 3 and 114 > line > 100
SU: 15-8 (0.65, 65.2%)   avg line: 106.7 / -116.0   on / against: +$799 / -$938   ROI: +34.7% / -35.1%
OU: 11-11-1 (0.26, 50.0%)   avg total: 5.5
SoG Pens P-Mins P1 P2 P3 Final
Team 30.0 4.5 10.3 0.7 1.0 1.3 3.2
Opp 28.3 4.9 12.2 0.7 0.8 0.9 2.6
Date Day Season Team Opp Site P1 P2 P3 Final Line Total SUm SUr OUr ot
Apr 20, 2008 Sunday 2007 Flames Sharks home 1-0 1-0 0-0 2-0 113 5.0 2 W U 0
Oct 14, 2008 Tuesday 2008 Thrashers Wild home 0-1 1-0 1-3 2-4 102 5.5 -2 L O 0
Oct 22, 2008 Wednesday 2008 Flyers Sharks home 3-4 1-1 2-1 6-7 106 5.5 -1 L O 1
Nov 03, 2008 Monday 2008 Islanders Blue Jackets home 0-0 0-0 3-3 4-3 108 5.5 1 W O 1
Nov 21, 2008 Friday 2008 Blues Ducks home 1-0 0-0 1-2 3-2 110 5.5 1 W U 1
Dec 06, 2008 Saturday 2008 Blues Coyotes home 1-1 3-2 0-0 4-3 102 5.5 1 W O 0
Nov 09, 2010 Tuesday 2010 Canadiens Canucks home 1-0 0-0 1-0 2-0 104 5.5 2 W U 0
Nov 13, 2010 Saturday 2010 Sabres Capitals home 0-1 2-0 0-1 3-2 103 5.5 1 W U 1
Nov 25, 2011 Friday 2011 Blue Jackets Sabres home 2-0 3-1 0-0 5-1 112 5.5 4 W O 0
Jan 06, 2012 Friday 2011 Hurricanes Sabres home 0-0 1-1 3-1 4-2 101 5.5 2 W O 0
Feb 01, 2012 Wednesday 2011 Maple Leafs Penguins home 0-0 0-0 1-0 1-0 108 5.5 1 W U 0
Mar 06, 2012 Tuesday 2011 Devils Rangers home 1-0 0-1 3-0 4-1 110 5.0 3 W P 0
Jan 28, 2013 Monday 2012 Blue Jackets Stars home 0-0 1-1 1-0 2-1 105 5.5 1 W U 0
Feb 16, 2013 Saturday 2012 Panthers Lightning home 1-2 2-1 2-2 5-6 108 5.5 -1 L O 1
Nov 16, 2013 Saturday 2013 Islanders Red Wings home 1-2 2-1 1-1 5-4 103 5.5 1 W O 1
Dec 23, 2013 Monday 2013 Senators Penguins home 1-0 1-0 3-0 5-0 109 5.5 5 W U 0
Dec 27, 2013 Friday 2013 Coyotes Sharks home 1-0 1-2 1-1 3-4 111 5.5 -1 L O 1
Jan 07, 2014 Tuesday 2013 Canucks Penguins home 0-1 1-1 3-2 4-5 111 5.5 -1 L O 1
Mar 16, 2014 Sunday 2013 Senators Avalanche home 0-0 0-1 1-2 1-3 102 5.5 -2 L U 0
Oct 23, 2014 Thursday 2014 Red Wings Penguins home 1-2 0-1 2-0 4-3 106 5.5 1 W O 1

Game Parameters: abbreviation, attendance, city, close line, close total, conference, date, day, division, faceoffs won, full name, game number, goals, line, linesmen, losses, margin, matchup losses, matchup wins, month, open line, open total, opponents, ou margin, ou streak, overtime, penalties, penalty minutes, percent bets, percent over bets, percent under bets, period scores, playoffs, referees, rest, season, shoot out, shots on goal, site, site streak, start time, streak, team, total, 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).