![]() |
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 |
NEB is 0-7 since Nov 11, 2017 on the road | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
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 game-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 teams do when rushing for more than 100 yards while holding their opponent to few than 100 yars use the SDQL: 100 < t:rushing yards and to:rushing yards < 100
To see how teams do after scoring more than 40 points their last four games use the SDQL: 40 < p:points and 40 < p2:points and 40 < p3:points and 40 < p4:points
To see how teams do after their opponent passed for more than 400 yards and lost use the SDQL: 400 < top:passing yards and top:points < topo:points
To see how teams do when they have a season-to-date average of less that 50 rushing yards use the SDQL: tA(rushing yards) < 50
To access an individual player's performance use the syntax: [Team:]Player Name:game reference:parameter.
Where the specification of the team is optional and the name can be abbreviated.
To see how Fresno does when DCarr throws for more than 400 yards use the SDQL: 400 < FRES:DCarr:passing yards
To see how Wisconsin does after M Gorden has more than 100 rushing yards use the SDQL: 100<WIS:MGordon:p:rushing yards
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 the opponent's points vs the team's points for all UCLA games in 2013 use the SDQL: t:points as Points, o:points as Opponent Points @ t:team=UCLA and season=2013
Histograms require the SDQL syntax: x @ conditions. For example :
To plot the distribution of points for all NCAAFB games since 2010 use the SDQL: t:points as Points @ 2010 <= season
To color this histogram by site, use the SDQL: t:points as Points @ 2010 <= season and site
Box Plots require the SDQL syntax: x @ groups . For example :
See the points scored by NCAAFB teams in 2013 use the SDQL: points @ team 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). |