featuring the Sports Data Query Language
Create New Account
--- or ---
forgot password?
   Home  |  Trend Mart   ||   NFL  |  NBA  |  MLB  |  NHL  |  NCAA FB  |  NCAA BB   ||   NFL: Home | Trends | SDQL Query  

Killersports is transitioning to a new format. Visit transition.killersports.com to learn more.

NFL SDQL Query Access Your query timeout is 15 seconds.

Content will appear here
NFL Game Parameters:
ats margin, ats streak, attendance, average net punt yards, average punt yards, biggest lead, blocked extra points, blocked field goals, blocked punts, coach, completions, conference, date, day, division, dpa, dps, drives, field goals, field goals attempted, first downs, fourth downs attempted, fourth downs made, fumble return touchdowns, fumble return yards, fumbles, fumbles lost, goal to go attempted, goal to go made, interception return yards, interception returns, interception touchdowns, interceptions, kicking extra points, kicking extra points attempted, kickoff return touchdowns, kickoff return yards, kickoff returns, kickoffs, kickoffs for touchback, kickoffs in end zone, lead changes, line, margin, margin after the first, margin after the third, margin at the half, month, ou margin, ou streak, overtime, passes, passing first downs, passing touchdowns, passing yards, penalties, penalty first downs, penalty yards, playoffs, plays, points, punt return touchdowns, punt return yards, punt returns, punts, quarter scores, red zones attempted, red zones made, regular season wins line, rest, return yards, rushes, rushes for a loss, rushing first downs, rushing touchdowns, rushing yards, rushing yards lost, sack yards, sacks, safeties, scored first, season, site, snf, start time, streak, surface, team, temperature, third downs attempted, third downs made, time of possession, times tied, total, touchdowns, turnover margin, turnovers, two point conversion attempts, two point conversions, two point conversions attempted, week

Passing Parameters: SDQL3 access to player tables coming soon.
completions, interceptions thrown, name, passes, passing conversions, passing touchdowns, passing yards

Rushing Parameters:
fumbles, fumbles lost, longest rush, name, rushes, rushing conversions, rushing touchdowns, rushing yards

Punting Parameters:
average punt yards, longest punt, name, punts, punts inside the twenty

Punt Returns Parameters:
average punt return, longest punt return, name, punt returns

Receiving Parameters:
longest reception, name, receiving conversions, receiving touchdowns, receiving yards, receptions, targets

Kicking Parameters:
field goals, field goals attempted, kicking extra points, kicking extra points attempted, longest field goal, name

Defense Parameters:
defensive two point conversion, forced fumbles, fumble return touchdowns, fumble return yards, interception return touchdowns, interceptions, name, sacks, safeties, tackle assists, tackles

Kickoff Returns Parameters:
average kickoff return, kickoff return touchdowns, kickoff returns, longest kickoff return, name

Fumbles Parameters:
fumble yards, fumbles, fumbles lost, fumbles recovered, name

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.


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.
returns games in which teams scored fewer than 10 points.

If no conditional is imposed then the results are grouped by the reference.
returns games grouped by all occurrences of previous points.

Multiple conditions can be imposed using a comma delimited format.
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


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


The query:
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.


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
AWP - Away Winning Percentage
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
DTD - defensive touchdowns
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
HWP - Home Winning Percentage
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
SIQ - scored in quarters - the team scored in this many quarters
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


The information available here is believed, but not guaranteed, to be accurate, is for recreational purposes only, and is not intended to violate any state, local, or federal laws.