S p o r t s D a t a B a s e . c o m
a sports data query language (SDQL ©) consultancy

Permission is given to quote trends found on SportsDataBase.com provided that a reference and a link to SportsDataBase.com is provided. E.g.: Trend found on SportsDataBase.com


Information you need to win
NCAA Football Query

season=2009
ATS OU SU team
10-2-1 (5.8) 8-4-0 (6.1) 8-5-0 (7.54) 'CON'
2-9-0 (-4.8) 3-7-1 (-7.2) 4-8-0 (-0.58) 'AKST'
2-9-1 (-8.3) 6-5-0 (-1.8) 2-10-0 (-20.75) 'SJST'
2-9-0 (-6.6) 4-6-1 (1.2) 1-10-0 (-16.64) 'MEM'
10-3-1 (5.4) 6-7-0 (-2.1) 12-2-0 (15.00) 'CMCH'
10-3-0 (6.6) 8-5-0 (1.8) 10-3-0 (8.31) 'MTEN'
10-3-0 (0.5) 7-5-0 (-4.2) 7-6-0 (-9.00) 'WYO'
3-9-0 (-3.1) 4-7-0 (0.5) 5-7-0 (-2.42) 'WMCH'
3-9-0 (-5.0) 5-5-1 (-0.6) 3-9-0 (-8.17) 'COST'
9-3-1 (2.8) 3-9-1 (-5.0) 11-2-0 (16.46) 'OHST'
8-3-1 (0.8) 5-5-1 (1.7) 4-8-0 (-4.92) 'UTST'
9-4-0 (1.7) 3-9-0 (-9.0) 7-6-0 (-1.31) 'IWST'
9-4-0 (4.2) 5-6-1 (-0.3) 8-5-0 (3.62) 'CFL'
9-4-0 (1.8) 4-7-1 (-5.3) 11-2-0 (7.77) 'IOWA'
4-9-0 (-3.0) 5-7-0 (4.2) 8-5-0 (3.00) 'GEO'
4-9-0 (-1.3) 7-5-0 (-2.5) 6-7-0 (-2.85) 'MIN'
4-9-0 (-8.1) 5-8-0 (-3.0) 9-4-0 (6.62) 'USC'
4-9-0 (-2.8) 8-4-0 (8.3) 7-6-0 (0.08) 'FLST'
4-8-0 (-6.8) 3-8-0 (-2.6) 3-9-0 (-20.58) 'TLN'
4-8-0 (-6.8) 6-5-1 (2.3) 0-12-0 (-21.83) 'EMCH'
4-8-0 (-3.2) 3-8-0 (-5.5) 5-7-0 (-6.58) 'ARMY'
4-8-0 (-4.5) 4-7-0 (0.1) 3-9-0 (-6.00) 'ILL'
4-8-0 (-4.8) 7-4-0 (2.2) 5-7-0 (1.08) 'KAN'
4-8-0 (-2.1) 6-6-0 (-0.7) 6-6-0 (4.17) 'NOTD'
4-8-0 (-5.0) 5-5-1 (-0.0) 3-9-0 (-9.50) 'AKR'
4-8-0 (-9.8) 7-5-0 (1.4) 2-10-0 (-24.83) 'RICE'
4-8-0 (-3.0) 5-6-0 (2.1) 5-7-0 (-7.58) 'UNLV'
8-4-0 (5.6) 9-3-0 (7.0) 9-4-0 (7.23) 'TEM'
8-4-1 (7.9) 6-6-0 (-3.8) 8-5-0 (14.00) 'AIR'
8-4-0 (4.6) 6-5-0 (3.0) 4-8-0 (3.42) 'LTCH'
8-4-1 (5.9) 8-5-0 (8.7) 8-5-0 (8.92) 'STAN'
9-5-0 (3.1) 7-6-0 (2.8) 14-0-0 (25.07) 'BOIS'
9-5-0 (3.0) 5-7-1 (6.4) 11-3-0 (9.00) 'GTCH'
9-5-0 (5.8) 3-11-0 (-13.2) 10-4-0 (14.71) 'NEB'
9-5-0 (3.5) 6-7-0 (-1.0) 9-5-0 (3.50) 'OHU'
9-5-0 (4.2) 6-5-2 (-1.8) 14-0-0 (20.36) 'ALA'
2-0-0 (10.0) 0-0-0 (0.0) 0-2-0 (-15.50) 'EKY'
0-2-0 (-23.2) 0-0-0 (0.0) 0-2-0 (-53.50) 'NICH'
0-2-0 (-9.5) 0-0-0 (0.0) 0-2-0 (-55.50) 'IDST'
2-0-0 (21.8) 0-0-0 (0.0) 0-2-0 (-15.00) 'JVST'
2-0-0 (15.8) 0-0-0 (0.0) 1-1-0 (8.00) 'CARK'
0-2-0 (-14.0) 0-0-0 (0.0) 0-2-0 (-51.50) 'NOST'
0-2-0 (-10.8) 0-0-0 (0.0) 0-2-0 (-31.50) 'WOF'
0-2-0 (-7.8) 0-0-0 (0.0) 0-2-0 (-50.00) 'ALCO'
2-0-0 (8.8) 0-0-0 (0.0) 0-2-0 (-20.50) 'NAZ'
0-2-0 (-5.8) 0-0-0 (0.0) 0-2-0 (-41.00) 'FUR'
0-2-0 (-6.8) 0-0-0 (0.0) 0-2-0 (-14.00) 'CPOL'
4-7-0 (-1.0) 6-5-0 (-2.2) 4-7-0 (-3.00) 'BUF'
4-7-1 (-2.4) 7-5-0 (1.7) 3-9-0 (-12.42) 'FINT'
7-4-2 (-0.6) 9-4-0 (4.0) 9-4-0 (3.92) 'TROY'
7-4-0 (-0.3) 4-7-0 (-4.0) 5-7-0 (-3.17) 'KEST'
7-4-3 (1.9) 8-5-0 (4.5) 10-4-0 (12.14) 'HOU'
7-4-2 (4.1) 4-8-0 (2.8) 10-3-0 (12.31) 'PIT'
5-8-0 (-1.8) 4-8-0 (0.1) 8-5-0 (3.62) 'MIZ'
5-8-1 (0.8) 7-7-0 (0.8) 13-1-0 (22.57) 'TEX'
5-8-0 (-0.5) 4-8-1 (-6.1) 9-4-0 (8.62) 'LSU'
5-8-0 (-3.1) 6-6-0 (-3.9) 9-4-0 (4.46) 'WVA'
8-5-0 (6.2) 6-6-0 (2.3) 8-5-0 (10.92) 'ARK'
8-5-1 (1.2) 8-5-0 (3.4) 9-5-0 (10.71) 'CLEM'
8-5-0 (3.8) 9-4-0 (8.8) 8-5-0 (-3.31) 'IDA'
8-5-0 (5.5) 6-7-0 (0.0) 10-3-0 (16.23) 'VTCH'
8-5-0 (4.5) 6-5-1 (-0.5) 12-1-0 (25.54) 'TCU'
4-6-2 (-4.2) 4-7-0 (-4.6) 4-8-0 (-8.17) 'LOU'
4-6-2 (-3.2) 5-6-0 (2.0) 4-8-0 (-7.17) 'SDST'
5-7-0 (-1.9) 8-4-0 (4.7) 2-10-0 (-9.00) 'NTX'
5-7-0 (-2.8) 4-7-0 (0.2) 2-10-0 (-9.92) 'MARY'
5-7-0 (1.5) 5-4-1 (2.9) 5-7-0 (-3.17) 'DUKE'
5-7-0 (-3.7) 4-8-0 (-1.3) 1-11-0 (-18.58) 'MIAO'
5-7-0 (0.4) 6-6-0 (1.1) 5-7-0 (-6.00) 'FATL'
5-7-1 (-2.5) 4-8-0 (-6.4) 3-10-0 (-20.15) 'NMST'
5-7-0 (-5.2) 8-4-0 (8.4) 5-7-0 (-8.00) 'TOL'
5-7-0 (-1.9) 5-5-1 (-2.6) 6-6-0 (-1.75) 'LMON'
5-7-0 (-2.6) 6-6-0 (-0.2) 1-11-0 (-19.58) 'NMX'
5-7-0 (0.0) 8-4-0 (0.7) 5-7-0 (-4.92) 'UAB'
5-7-0 (-0.9) 7-5-0 (2.2) 4-8-0 (-3.67) 'UTEP'
5-7-0 (-2.1) 4-8-0 (-4.8) 1-11-0 (-26.50) 'WAST'
7-5-0 (1.5) 6-3-2 (3.2) 4-8-0 (-6.00) 'IND'
7-5-1 (-0.9) 7-5-0 (4.4) 8-5-0 (5.46) 'FRES'
7-5-0 (1.2) 3-7-0 (-4.6) 6-6-0 (-0.33) 'KAST'
7-5-0 (3.8) 6-5-0 (2.4) 5-7-0 (-1.17) 'MSST'
7-5-1 (1.0) 5-6-0 (-4.9) 8-5-0 (6.69) 'NCAR'
7-5-1 (1.5) 6-5-0 (-3.5) 8-5-0 (6.69) 'SFL'
7-5-1 (-1.4) 5-7-0 (4.9) 7-6-0 (7.08) 'SMIS'
7-5-1 (2.6) 4-8-0 (-1.6) 8-5-0 (13.38) 'TXT'
7-5-0 (4.0) 6-6-0 (-1.2) 5-7-0 (-0.58) 'WAS'
7-5-0 (-0.0) 7-5-0 (-0.1) 3-9-0 (-6.58) 'COLO'
7-5-0 (5.2) 6-6-0 (-0.6) 7-5-0 (1.08) 'SMU'
0-1-0 (-2.5) 0-0-0 (0.0) 0-1-0 (-38.00) 'SWMS'
0-1-0 (-20.0) 0-0-0 (0.0) 0-1-0 (-54.00) 'NEAS'
1-0-0 (15.0) 0-0-0 (0.0) 0-1-0 (-4.00) 'SAMF'
1-0-0 (11.0) 0-0-0 (0.0) 1-0-0 (8.00) 'RICH'
1-0-0 (8.0) 0-0-0 (0.0) 0-1-0 (-5.00) 'APP'
1-0-0 (23.0) 0-0-0 (0.0) 0-1-0 (-1.00) 'NIWA'
0-1-0 (-3.5) 0-0-0 (0.0) 0-1-0 (-46.00) 'NCOL'
1-0-0 (14.0) 0-0-0 (0.0) 0-1-0 (-4.00) 'MAS'
1-0-0 (21.5) 0-0-0 (0.0) 0-1-0 (-20.00) 'INST'
0-1-0 (-6.0) 0-0-0 (0.0) 0-1-0 (-41.00) 'MONS'
1-0-0 (4.0) 0-0-0 (0.0) 0-1-0 (-3.00) 'SIL'
0-1-0 (-2.5) 0-0-0 (0.0) 0-1-0 (-38.00) 'JAST'
0-1-0 (-2.0) 0-0-0 (0.0) 0-1-0 (-34.00) 'CIT'
1-0-0 (1.0) 0-0-0 (0.0) 0-1-0 (-33.00) 'TWSU'
1-0-0 (15.0) 0-0-0 (0.0) 0-1-0 (-27.00) 'POST'
0-1-0 (-4.0) 0-0-0 (0.0) 0-1-0 (-35.00) 'YST'
0-1-0 (-12.5) 0-0-0 (0.0) 0-1-0 (-35.00) 'CSAC'
0-1-0 (-11.0) 0-0-0 (0.0) 0-1-0 (-45.00) 'WCAR'
1-0-0 (29.5) 0-0-0 (0.0) 1-0-0 (12.00) 'WAM'
1-0-0 (19.0) 0-0-0 (0.0) 0-1-0 (-13.00) 'LIB'
0-1-0 (-14.0) 0-0-0 (0.0) 0-1-0 (-41.00) 'MORG'
1-0-0 (14.0) 0-0-0 (0.0) 1-0-0 (7.00) 'NHAM'
0-1-0 (-19.5) 0-0-0 (0.0) 0-1-0 (-52.00) 'EWA'
0-1-0 (-20.0) 0-0-0 (0.0) 0-1-0 (-69.00) 'SEMS'
1-0-0 (7.0) 0-0-0 (0.0) 0-1-0 (-28.00) 'ILST'
1-0-0 (6.5) 0-0-0 (0.0) 0-1-0 (-3.00) 'JMAD'
0-1-0 (-16.0) 0-0-0 (0.0) 0-1-0 (-58.00) 'MUR'
0-1-0 (-20.0) 0-0-0 (0.0) 0-1-0 (-34.00) 'WIL'
1-0-0 (12.0) 0-0-0 (0.0) 0-1-0 (-3.00) 'PVAM'
1-0-0 (9.0) 0-0-0 (0.0) 0-1-0 (-38.00) 'HOW'
1-0-1 (2.0) 0-0-0 (0.0) 0-2-0 (-17.50) 'SUT'
0-1-0 (-5.0) 0-0-0 (0.0) 0-1-0 (-46.00) 'SELA'
1-0-0 (5.5) 0-0-0 (0.0) 0-1-0 (-35.00) 'TXST'
0-1-0 (-8.0) 0-0-0 (0.0) 0-1-0 (-28.00) 'ELON'
0-1-0 (-7.0) 0-0-0 (0.0) 0-1-0 (-42.00) 'RISL'
1-0-0 (6.0) 0-0-0 (0.0) 0-1-0 (-35.00) 'NCCU'
0-1-0 (-10.0) 0-0-0 (0.0) 0-1-0 (-50.00) 'GRA'
1-0-0 (5.0) 0-0-0 (0.0) 0-1-0 (-17.00) 'MAIN'
0-1-0 (-8.0) 0-0-0 (0.0) 0-1-0 (-10.00) 'MNEE'
0-1-0 (-16.0) 0-0-0 (0.0) 0-1-0 (-53.00) 'SHST'
1-0-0 (9.0) 0-0-0 (0.0) 0-1-0 (-14.00) 'HOF'
1-0-0 (11.0) 0-0-0 (0.0) 0-1-0 (-24.00) 'SCST'
1-0-0 (5.5) 0-0-0 (0.0) 0-1-0 (-32.00) 'FAM'
0-1-0 (-3.5) 0-0-0 (0.0) 0-1-0 (-30.00) 'GSOU'
0-1-0 (-9.5) 0-0-0 (0.0) 0-1-0 (-49.00) 'EIL'
1-0-0 (19.5) 0-0-0 (0.0) 0-1-0 (-5.00) 'VMI'
1-0-0 (14.5) 0-0-0 (0.0) 0-1-0 (-3.00) 'SDSU'
1-0-0 (1.5) 0-0-0 (0.0) 0-1-0 (-45.00) 'TCHA'
5-6-0 (-5.4) 8-2-0 (7.8) 4-7-0 (-3.73) 'NCST'
5-6-1 (-5.6) 4-7-0 (-1.7) 5-7-0 (1.92) 'TLS'
5-6-2 (-1.9) 5-7-0 (1.0) 8-5-0 (3.46) 'ARZ'
5-6-0 (-2.7) 4-6-1 (-2.3) 6-6-0 (-8.17) 'LLAF'
5-6-1 (-3.8) 6-5-0 (4.2) 5-7-0 (2.00) 'MICH'
5-6-2 (0.8) 3-9-0 (-9.2) 8-5-0 (16.54) 'OKLA'
5-6-1 (-1.5) 3-8-0 (-6.2) 5-7-0 (-5.33) 'BAY'
6-5-1 (-1.3) 1-9-1 (-4.9) 4-8-0 (1.25) 'AZST'
6-7-0 (1.2) 4-8-1 (-0.3) 10-3-0 (9.62) 'UTAH'
6-7-0 (-5.9) 6-6-0 (-0.5) 8-5-0 (3.62) 'CAL'
6-7-0 (-1.7) 6-6-0 (-4.5) 6-7-0 (-6.69) 'HAW'
6-7-0 (-2.6) 8-4-0 (4.9) 6-7-0 (3.00) 'MCST'
6-7-0 (3.3) 7-5-0 (-0.3) 7-6-0 (3.38) 'KTKY'
6-7-0 (0.9) 5-6-1 (-1.1) 8-5-0 (1.46) 'NORW'
6-7-1 (4.4) 5-8-0 (-3.1) 10-4-0 (8.57) 'NAVY'
6-7-0 (2.7) 5-7-0 (0.1) 7-6-0 (7.00) 'NIL'
6-7-0 (0.5) 5-7-0 (2.0) 9-4-0 (8.15) 'MIAF'
6-7-0 (0.8) 5-6-0 (1.3) 9-4-0 (10.92) 'RUT'
7-6-0 (4.7) 9-4-0 (5.0) 10-3-0 (12.31) 'ORE'
7-6-0 (2.6) 6-7-0 (-0.7) 7-6-0 (1.00) 'BOWL'
7-6-0 (-1.0) 5-7-0 (-6.2) 7-6-0 (0.23) 'SCAR'
7-6-0 (-1.2) 7-4-1 (5.6) 8-5-0 (6.54) 'AUB'
7-6-0 (2.3) 5-7-0 (-1.7) 8-5-0 (5.00) 'BCOL'
7-6-0 (0.5) 3-9-0 (-4.2) 7-6-0 (-2.54) 'MRSH'
7-6-0 (1.8) 6-7-0 (3.0) 8-5-0 (9.69) 'NEV'
7-6-0 (3.7) 8-5-0 (1.1) 11-2-0 (13.92) 'BYU'
7-6-0 (1.8) 6-6-0 (3.9) 8-5-0 (6.46) 'ORST'
7-6-0 (0.3) 2-9-1 (-7.5) 11-2-0 (16.62) 'PNST'
7-6-0 (2.3) 8-4-1 (4.3) 7-6-0 (7.08) 'TEN'
7-6-0 (4.3) 7-5-0 (1.0) 10-3-0 (10.00) 'WIS'
7-6-0 (0.3) 6-5-0 (-3.5) 9-4-0 (11.85) 'MIS'
7-7-0 (2.8) 7-6-0 (-3.6) 9-5-0 (5.07) 'ECAR'
7-7-0 (-1.8) 5-8-0 (-4.7) 13-1-0 (23.86) 'FLA'
6-6-0 (-1.8) 3-8-0 (-3.4) 2-10-0 (-9.00) 'BALL'
6-6-1 (-2.6) 4-8-0 (-7.0) 9-4-0 (6.69) 'OKST'
6-6-0 (-0.5) 5-6-1 (2.9) 5-7-0 (-1.25) 'PUR'
6-6-0 (0.5) 3-8-0 (-0.8) 4-8-0 (-6.75) 'SYR'
6-6-0 (-3.0) 5-5-1 (6.5) 0-12-0 (-19.17) 'WKY'
6-6-1 (-0.2) 8-5-0 (5.3) 6-7-0 (-0.69) 'TXAM'
6-6-1 (0.1) 3-10-0 (-2.8) 7-6-0 (0.77) 'UCLA'
6-6-0 (-2.6) 2-8-1 (-5.8) 2-10-0 (-7.00) 'VAN'
6-6-0 (-1.7) 6-5-0 (1.0) 3-9-0 (-7.00) 'VIR'
6-6-0 (-1.7) 6-5-0 (3.1) 5-7-0 (0.08) 'WAKE'
6-6-1 (3.1) 6-6-0 (5.8) 12-1-0 (15.23) 'CIN'
1-1-0 (8.5) 0-0-0 (0.0) 0-2-0 (-21.00) 'NDST'
1-1-0 (-10.5) 0-0-0 (0.0) 0-2-0 (-59.00) 'CHSO'
1-1-0 (-0.2) 0-0-0 (0.0) 0-2-0 (-34.50) 'CDAV'
1-1-0 (5.8) 0-0-0 (0.0) 0-2-0 (-4.00) 'WEB'
1-1-0 (-3.8) 0-0-0 (0.0) 0-2-0 (-50.00) 'TXSO'
1-1-0 (-1.2) 0-0-0 (0.0) 0-2-0 (-40.00) 'TENT'
1-1-0 (-7.8) 0-0-0 (0.0) 0-2-0 (-37.00) 'DEL'
0-0-1 (0.0) 0-0-0 (0.0) 0-2-0 (-32.00) 'CCU'
0-0-0 (0.0) 0-0-0 (0.0) 1-0-0 (3.00) 'VIL'
0-0-0 (0.0) 0-0-0 (0.0) 0-1-0 (-61.00) 'MSVT'
0-0-0 (0.0) 0-0-0 (0.0) 0-1-0 (-23.00) 'SOU'
Query Fundamentals:

A query consists of one or more clauses joined by and or or.
The full format for reference to the NCAA Football SportsDataBase is game reference:parameter.

The simplest game reference is 'p' which stands for previous game. Also useful is 'o' which stands for opponent. You can combine any number of 'p's and 'o's. If a game reference is not given then the results for the current game are checked.

See below for the current list of parameters and examples.

Examples:

The query:
team and site=home
returns the results of home games for each


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:

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

Parameters: (point your mouse on a parameter for additional information)

Prest, ats margin, conference, date, day, division, full name, game number, game type, line, losses, margin, opponents, ou margin, overtime, points, rest, season, site, team, total, wins

Short Cuts

H,A,W,L,F,D are allowed short cuts for home,away,win,loss,favorite, and dog.

Examples:

The query:
p:WD and pp:WD and HF
returns home favorites after they won their last two as dogs.

e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Content for this is generated using the Sports Data Query Language (SDQL).
Google Groups
Subscribe to SportsDataBase
Email:
Visit this group