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
|NCAAFB Sport Data Query Language Access.||SDB Home NCAAFB Trends NCAAFB Query|
Kickoff Return Parameters: kickoff return yards, kickoff returns, longest kickoff return, name
Passing Parameters: completions, interceptions thrown, name, passes, passing touchdowns, passing yards
Rushing Parameters: name, rushes, rushing touchdowns, rushing yards
Interception Parameters: interception touchdowns, interception yards, interceptions, name
Punting Parameters: longest punt, name, punt yards, punts
Punt Return Parameters: longest punt return, name, punt return yards, punt returns
Receiving Parameters: name, receiving touchdowns, receiving yards, receptions
For access to the NCAAFB 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 how players do after accounting for more than 90% of their team's rushes use the SDQL: 0.9 * Team:p:rushes < p:rushes
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 NCAAFB players since 2006 use the SDQL: t:rushing yards as Rushing Yards @ 2006 <= 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).|