Winning Picks, Guaranteed

featuring the Sports Data Query Language

Create New Account --- or --- username password forgot password?

NFL SDQL Query Access - In Testing Your query timeout is 15 seconds.

For access to the NFL player-level database use the syntax: game reference:parameter.
Where game game references are any combination of t, o, p, P, n and N (for team, opponent, previous game, previous matchup, next game and next matchup respectively). Here are a few examples:
To see how players do when they have more than 35 rushes use the SDQL: 35 < t:rushes
To see how players do after rushing for more than 100 yards and 2+ TDs use the SDQL: 100 < p:rushing yards and 2 <= p:rushing touchdowns

To access the team's performance from the player-level query page use the syntax: Team:game reference:parameter.
To see players do after accounting for more than 90% of their team's rushes use the SDQL: 0.9 * Team:p:rushes < p:rushes
To find players who had a rush and a reception of over 50 yards use the SDQL: 50 < longest rush and 50 < longest reception

For data visualization queries, you need to specify the parameters to plot as well as the restrictive conditions.

Scatter Plots require the SDQL syntax: x, y @ conditions. For example:
To plot receiving yards vs rushing yards for Cowboys players in 2013 use the SDQL: rushing yards, receiving yards @ team = Cowboys and season = 2013
Tp break this down by player, just add ' and name' to the SDQL: rushing yards, receiving yards @ team = Cowboys and season = 2013 and name

Histograms require the SDQL syntax: x @ conditions. For example:
To plot the distribution of individual rushing yards for all NFL player this century use the SDQL: t:rushing yards as Rushing Yards @ 2000 <= season

Box Plots require the SDQL syntax: x @ groups . For example :
See the distribution of passing yards for each QB in 2013 use the SDQL: passing yards @ name and season = 2013

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. 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 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 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 support@KillerSports.com    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.