|
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:
t => team's stats
o => opponent's stats
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:
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, month, 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 prefixes, 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:
ATSL - ats loss
ATSW - ats win
3DM - third downs made
3DA - third downs attempts
3DF - third down failures
3DP - third down conversion percentage
4DM - fourth downs made
4DA - fourth downs attempts
4DF - fourth down failures
4DP - fourth down conversion percentage
COMP - completions
CP - completion percentage
DIV - divisional game
FD - first downs
FDP - first down percentage
FG - number of field goals
FUM - fumbles
FUML - fumbles lost
GTGA - goal to go attempted
GTGF - goal to go failed
GTGM - goal to go made
INC - incomplete passes
INT - interceptions
M1 - margin after the first
M2 - margin at the half
M3 - margin after the third
NDIV - non-divisional game
NOTD - non-offensive TDs
OFPL - offensive plays
OT - overtime
P1 - points in the first
P2 - points in the second
P3 - points in the third
P4 - points in the fourth
PEN - penalties
PENY - penalty yards
PFD - passing first downs
PENFD - penalty first downs
PO - playoffs
PTD - passing touchdowns
PY - passing yards
RFD - rushing first downs
RTD - rushing touchdowns
REG - regular season
RTD - rushing touchdowns
RY - rushing yards
RZA - red zone attempts
RZM - red zones made
RZF - red zone failures
S1 - points in the first
S2 - total points after the second
S3 - total points after the third
STDPAPG - pass attempts per game
STDRAPG - rush attempts per game
STDRZP - red zone percentage
STDYPPA - yards per passing attempt
STDYPRA - yards per rushing attempt
SY - sack yards
TD - number of touchdowns
TO - turnovers
TOM - turnover margin
TOP - time of possession
TY - total yards
WP - winning percentage
YPC - yards per completion
YPPL - yards per play
YPPT - yards per point
YPPA - yards per pass
YPPP - yards per pass play (includes sacks)
YPRA - yards per rushing attempt
|
