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.

Game Parameters: ats margin, ats streak, cdivision, coach, completions, conference, date, day, division, dpa, dps, first downs, fourth downs attempted, fourth downs made, full name, fumbles, fumbles lost, game number, game type, interceptions, line, losses, margin, margin after the first, margin after the third, margin at the half, matchup losses, matchup wins, month, opponents, ou margin, ou streak, overtime, passes, passing yards, penalties, penalties yards, penalty yards, playoffs, points, quarter scores, rank, rest, rot, round, rushes, rushing yards, school, season, seed, site, site streak, start time, streak, team, third downs attempted, third downs made, time of possession, total, turnover margin, turnovers, week, wins

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

How to Query:

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).