A crowd-sourced stats provider.
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


The Coyotes are 7-16 AGAINST since Dec 01, 2011 as a road favorite
SU: 7-16 (-0.74, 30.4%)   avg line: -125.4 / 115.0   on / against: -$1,330 / +$1,158   ROI: -46.1% / +50.3%
OU: 8-12-3 (-0.30, 40.0%)   avg total: 5.4
SoG Pens P-Mins P1 P2 P3 Final
Team 30.5 4.4 10.3 0.7 0.7 0.6 2.2
Opp 32.1 4.1 9.6 1.0 1.0 0.7 2.9
Date Day Season Team Opp Site P1 P2 P3 Final Line Total SUm SUr OUr ot
Mar 06, 2012 Tuesday 2011 Coyotes Blue Jackets away 1-2 1-1 0-0 2-3 -133 5.5 -1 L U 0
Mar 18, 2012 Sunday 2011 Coyotes Oilers away 0-0 0-2 2-0 3-2 -125 5.5 1 W U 1
Apr 07, 2012 Saturday 2011 Coyotes Wild away 2-0 1-1 1-0 4-1 -142 5.0 3 W P 0
Feb 11, 2013 Monday 2012 Coyotes Avalanche away 1-0 0-2 1-0 3-2 -113 5.5 1 W U 1
Feb 23, 2013 Saturday 2012 Coyotes Oilers away 1-0 1-1 0-1 2-3 -127 5.0 -1 L P 1
Apr 12, 2013 Friday 2012 Coyotes Flames away 1-1 0-1 1-0 2-3 -159 5.0 -1 L P 1
Nov 25, 2013 Monday 2013 Coyotes Predators away 0-3 2-0 0-1 2-4 -112 5.5 -2 L O 0
Dec 03, 2013 Tuesday 2013 Coyotes Oilers away 1-1 2-1 3-0 6-2 -119 5.5 4 W O 0
Dec 04, 2013 Wednesday 2013 Coyotes Flames away 1-1 0-2 0-1 1-4 -125 5.5 -3 L U 0
Dec 19, 2013 Thursday 2013 Coyotes Maple Leafs away 0-1 0-0 1-0 1-2 -110 5.5 -1 L U 1
Dec 23, 2013 Monday 2013 Coyotes Sabres away 0-0 1-0 0-1 1-2 -144 5.0 -1 L U 1
Jan 13, 2014 Monday 2013 Coyotes Jets away 1-2 0-1 0-2 1-5 -117 5.5 -4 L O 0
Jan 22, 2014 Wednesday 2013 Coyotes Flames away 0-1 1-2 1-0 2-3 -135 5.5 -1 L U 0
Jan 24, 2014 Friday 2013 Coyotes Oilers away 3-0 1-1 0-2 4-3 -132 5.5 1 W O 0
Mar 11, 2014 Tuesday 2013 Coyotes Panthers away 1-0 1-0 1-1 3-1 -110 5.5 2 W U 0
Nov 01, 2014 Saturday 2014 Coyotes Hurricanes away 0-2 0-1 0-0 0-3 -119 5.5 -3 L U 0
Mar 26, 2015 Thursday 2014 Coyotes Sabres away 1-1 2-1 0-1 4-3 -114 5.0 1 W O 1
Apr 05, 2018 Thursday 2017 Coyotes Canucks away 1-0 2-1 0-2 3-4 -117 5.5 -1 L O 1
Nov 13, 2018 Tuesday 2018 Coyotes Red Wings away 0-3 0-1 1-2 1-6 -120 5.5 -5 L O 0
Mar 23, 2019 Saturday 2018 Coyotes Devils away 1-1 0-0 0-0 1-2 -160 5.5 -1 L U 1

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, open total, opponents, ou margin, ou streak, over, overtime, p1 line, penalties, penalty minutes, period scores, playoffs, points, 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).