Note: This site will be discontinued as of September 1, 2021.
SDQL3 access will continue with user input data at http://s3.sportsdatabase.com.
S p o r t s D a t a b a s e . c o m
tools for the objective handicapper
|NFL Sport Data Query Language Access.||SDB Home NFL Trends NFL Query|
Kickoff Returns Parameters: average kickoff return, average kickoff return yards, kickoff return touchdowns, kickoff returns, longest kickoff return, name
Kicking Parameters: field goals, field goals attempted, kicking extra points, kicking extra points attempted, longest field goal, name
Fumbles Parameters: fumble yards, fumbles, fumbles lost, fumbles recovered, name
Passing Parameters: 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
Defense Parameters: defensive two point conversion, forced fumble, forced fumbles, fumble return touchdowns, fumble return yards, interception return touchdowns, interceptions, name, sacks, safeties, tackle assists, tackles
Punting Parameters: average punt yards, longest punt, name, punts, punts inside the twenty
Punt Returns Parameters: average punt return, average punt return yards, longest punt return, name, punt return touchdowns, punt returns
Receiving Parameters: longest reception, name, receiving conversions, receiving touchdowns, receiving yards, receptions, targets
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
|e-mail links: Content@SportsDataBase.com Support@SportsDataBase.com|
|Content for this site is generated using the Sports Data Query Language (SDQL).|