|
Query Fundamentals:
A query consists of one or more clauses joined by and or or.
The full format for reference to the NFL SportsDataBase is game reference:parameter.
Examples:
The query:
team=Bears and site=home
returns home games for the Bears
If no team is given then results for any team are checked.
p:points<10 and pp:points<10
returns games after a team scored fewer than 10 points the past two games.
If no game reference is given then results for the current game are checked.
points<10
returns games in which teams scored fewer than 10 points.
If no conditional is imposed then the results are grouped by the reference.
p:points
returns games grouped by all occurrences of previous points.
Multiple conditions can be imposed using a comma delimited format.
p:points<7,10,14
gives results grouped by previous points < 7, previous points < 10, and previous points < 14.
Game Reference:
p => team's previous game
op => opp's previous game
P => previous match up
n => team's next game
on => opp's next game
N => next match up
Examples:
The query:
site=home and P:points<10 and PP:points<10
returns home games where team scored fewer than 10 point the past two head-to-head match ups
Parameters:
Prest, ats margin, ats streak, average punt yards, completions, conference, date, day, division, dpa, dps, drives, field goals, field goals attempted, first downs, fourth downs attempted, fourth downs made, fumbles, fumbles lost, goal to go attempted, goal to go made, interceptions, line, losses, margin, margin after the first, margin after the third, margin at the half, opponents, ou margin, ou streak, overtime, passes, passing first downs, passing touchdowns, passing yards, penalties, penalty first downs, penalty yards, playoffs, plays, points, punts, quarter scores, red zones attempted, red zones made, rest, return yards, rushes, rushing first downs, rushing touchdowns, rushing yards, sack yards, sacks, season, site, site streak, snf, streak, surface, team, third downs attempted, third downs made, time of possession, time zone, total, touchdowns, turnover margin, turnovers, week, wins
Examples:
The query:
p:punts=3
returns games after a team punts 3 times
Short Cuts:
H, A, W, L, F, D, O, U, C are short cuts for home,away,win,loss,favorite,dog,over the total,under the total, and conference. As with the parameter prefixex, these can be strung together without limit.
Examples:
The query:
HF and p:HFL and pp:HFL
returns home favorites after they just lost as home favorites their last two games.
The query:
P:O and PP:O and PPP:O and PPPP:O and PPPPP:O and PPPPPP:O
returns games where teams have gone over the total their last six matchups.
In addition to the above single letter short cuts the following abbreviations are available:
M1 - margin after the first
M2 - margin at the half
M3 - margin after the third
P1 - points in the first
P2 - points in the second
P3 - points in the third
P4 - points in the fourth
WP - winning percentage
YPPT - yards per point
YPPL - yards per play
|