College Football Data Dictionary
Below you will find a list of all data points that are contained within each feed that we offer. If any of the information provided below is unclear, or if you have a specific question, please contact support.
Go to our developer portal for a full list of operations including deprecated, legacy and test endpoints.
All dates & times are in US Eastern Time.
BettingEntityMetadata
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RecordId from 2021 | integer (32) | NOT NULL | No | The id of the record. Unique only within the same entity type (i.e. BettingMarketType Ids overlap with BettingBetType Ids) |
| Name from 2021 | string (100) | NOT NULL | No | Denotes the name of the *Type (e.g. Betting Market Type, Betting Event Type, Betting Period Type) |
| Active | bool (32) | NULL | No | Whether or not this market is currently is use |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingBetTypes from 2021 | BettingEntityMetadata[] | NULL | No | The list of the bet types that can be found within a market |
| BettingMarketTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible Market Types within a Betting Event (e.g. Game Line, Team prop, Player Future, etc.) |
| BettingPeriodTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingPeriodTypes (e.g. Full Game; Regulation; 1st Quarter) |
| BettingEventTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingEventTypes - Game or Future |
| BettingOutcomeTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingOutcomeTypes (e.g. Home; Away; Under; Over) |
| ResultedMarketMetaData from 2021 | BettingResultingMetadata[] | NULL | No | A list of the combinations of BettingMarketTypeID, BettingBetTypeID, and BettingPeriodTypeID that will be resulted |
| BettingResultTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingResultTypes (e.g. Win; Loss; Push; Not Resulted; Incomplete) |
BettingEvent
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID assocated with the betting event |
| Name from 2020 | string (32) | NULL | No | The name of this betting event |
| Season from 2020 | int (32) | NULL | No | The college football season of the game |
| BettingEventTypeID from 2020 | int (32) | NOT NULL | No | The ID associated with the type of betting event - Game or Future |
| BettingEventType from 2020 | string (32) | NOT NULL | No | Indicates the type of betting event - Game or Future |
| StartDate from 2020 | datetime | NULL | No | The furthest forward time any book has a market set to close for this betting event |
| Created from 2020 | datetime | NULL | No | The created date of this betting event |
| Updated from 2020 | datetime | NULL | No | The last updated timestamp of this betting event (US Eastern Time) |
| GameID from 2020 | int (32) | NULL | No | The unique ID of this game tied to this event |
| GlobalGameID from 2020 | int (32) | NULL | No | A globally unique ID for this game tied to this event. Note: This value is guaranteed to be unique across all sports/leagues |
| GameStatus from 2020 | string (32) | NULL | Yes | The status of the game tied to this event |
| AwayTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the away team tied to this event |
| HomeTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID from 2020 | int (32) | NULL | No | The unique ID of the away team tied to this event |
| HomeTeamID from 2020 | int (32) | NULL | No | The unique ID of the home team |
| GlobalAwayTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the away team tied this event. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the home team. Note: This value is guaranteed to be unique across all sports/leagues |
| AwayTeamScore from 2020 | int (32) | NULL | Yes | The away team score of the game tied to this event (post-game) |
| HomeTeamScore from 2020 | int (32) | NULL | Yes | The home team score of the game tied to this event (postgame) |
| TotalScore from 2020 | int (32) | NULL | Yes | The total points scored by both teams in the game tied to this event (updated after game ends to allow for resolving bets) |
| AwayRotationNumber from 2020 | int (32) | NULL | No | The away team rotation number of the game tied to this event |
| HomeRotationNumber from 2020 | int (32) | NULL | No | Rotation number of home team tied to this event |
| BettingMarkets from 2020 | BettingMarket[] (32) | NULL | No | The list of betting markets for this event |
| GameStartTime from 2020 | datetime (32) | NULL | No | The date and time the connected game starts, where applicable |
BettingMarket
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2020 | int (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID assocated with the betting event |
| BettingMarketTypeID from 2020 | int (32) | NULL | No | ID that distinguishes the different types of Market Types |
| BettingMarketType from 2020 | string (32) | NULL | No | The type of Market Type (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2020 | int (32) | NULL | No | The ID associated with the name of the bet type within a market |
| BettingBetType from 2020 | string (32) | NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID from 2020 | int (32) | NULL | No | The BettingPeriodTypeID of this type of market which we can result |
| BettingPeriodType from 2020 | string (32) | NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st Quarter; Overtime; Regular Season) |
| Name from 2020 | string (32) | NULL | No | The generic name of this market |
| TeamID from 2020 | int (32) | NULL | No | The unique ID of the team associated with this betting market |
| TeamKey from 2020 | string (32) | NULL | No | The key of the team tied to this market (if applicable) |
| PlayerID from 2020 | int (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO tied this market (if applicable). Note: this ID remains with the player their entire collegiate career |
| PlayerName from 2020 | string (32) | NULL | No | The name of the player tied to this market (if applicable) |
| Created from 2020 | datetime (32) | NULL | No | The created date of this market |
| Updated from 2020 | datetime (32) | NULL | No | The last updated timestamp of this market (US Eastern Time) |
| AvailableSportsbooks from 2020 | Sportsbook[] (32) | NULL | No | The sportsbooks that have published odds within this market |
| AnyBetsAvailable from 2020 | bool (32) | NULL | No | A field that returns "True" if there are any available bets to make within the market in question. If there are no bets available to make, the field returns "False" |
| BettingOutcomes from 2020 | BettingOutcome[] (32) | NULL | No | The list of betting outcomes from each sportsbook in this market |
| ConsensusOutcomes from 2020 | ConsensusOutcome[] (32) | NULL | No | The single set of consesnus outcomes of this market |
| IsArchived | bool | NOT NULL | No | Indicates if the BettingOutcomes have been moved to the archives |
| ArchiveLocation | string (250) | NOT NULL | No | If IsArchived is true, this returns the URL that can be used to retrieve the archived BettingOutcomes. An API Key and Sportsbook Grouping will be required to retrieve this information. If IsArchived is false, this returns an emtpy string |
BettingMarketResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingMarketTypeID from 2021 | integer (32) | NOT NULL | No | ID that distinguishes the different types of Market Types |
| BettingMarketType from 2021 | string (100) | NOT NULL | No | The type of Market Type (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingBetType from 2021 | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID from 2021 | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this type of market which we can result |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st Quarter; Overtime; Regular Season) |
| Name from 2021 | string (100) | NULL | No | The generic name of this market |
| TeamID from 2021 | integer (32) | NULL | No | The unique ID of the team associated with this betting market result |
| TeamKey from 2021 | string (10) | NULL | No | The key of the team tied to this market (if applicable) |
| PlayerID from 2021 | integer (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO tied this market result (if applicable). Note: this ID remains with the player their entire collegiate career |
| PlayerName from 2021 | string (100) | NULL | No | The name of the player tied to this market (if applicable) |
| BettingOutcomeResults from 2021 | BettingOutcomeResult[] | NULL | No | The list of outcomes under this market with results |
| IsMarketResultingSupported | bool (32) | NOT NULL | No | Indicates whether resulting is supported for this kind of BettingMarket |
BettingMarketSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingEventID | integer (32) | NOT NULL | No | The unique ID assocated with the betting event |
| BettingMarketTypeID | integer (32) | NOT NULL | No | ID that distinguishes the different types of Market Types |
| BettingMarketType | string (100) | NOT NULL | No | The type of Market Type (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingBetType | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this type of market which we can result |
| BettingPeriodType | string (100) | NOT NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st Quarter; Overtime; Regular Season) |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this betting market split |
| TeamKey | string (32) | NULL | No | The key of the team tied to this market (if applicable) |
| PlayerID | integer (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO tied this split (if applicable). Note: this ID remains with the player their entire collegiate career |
| PlayerName | string (100) | NULL | No | The full name of the player associated (where applicable) |
| BettingSplits | BettingSplit[] (32) | NOT NULL | No | A list of betting splits for a given game |
BettingOutcome
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingOutcomeID from 2020 | int (32) | NULL | No | The unique ID associated with this specific outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID associated with the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | No | Name of Betting Outcome Type (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome (spread, total, etc) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: This is provided by the sportsbook. In the case of Player odds; we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks. |
| IsAvailable from 2020 | bool (32) | NULL | No | Denotes whether or not the betting outcome is currently available |
| IsAlternate from 2020 | bool (32) | NULL | No | Denotes whether or not the betting outcome is an alternate line |
| Created from 2020 | datetime (32) | NULL | No | The created date of the outcome |
| Updated from 2020 | datetime (32) | NULL | No | The last updated timestamp of this outcome (US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when this outcome was unlisted (no longer available for bets) |
| TeamID from 2020 | int (32) | NULL | No | The unique ID of the team associated with this betting outcome |
| PlayerID from 2020 | int (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO tied this outcome (if applicable). Note: this ID remains with the player their entire collegiate career |
| GlobalTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the team tied this outcome. Note: This value is guaranteed to be unique across all sports/leagues |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Denotes whether the betting outcome is a live line (i.e. the outcome was created after the start of the game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID of a given sportsbook when available for deep links |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID of a given sportsbook when available for deep links |
BettingOutcomeResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingOutcomeID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with this specific outcome |
| BettingResultTypeID from 2021 | integer (32) | NULL | Yes | The BettingResultTypeID of this outcome |
| BettingResultType from 2021 | string (100) | NULL | Yes | A list of the possible BettingResultTypes (e.g. Win; Loss; Push; Not Resulted; Incomplete) |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | No | Name of Betting Outcome Type (e.g. Home; Away; Under; Over) |
| BetValue from 2021 | decimal (32) | NULL | Yes | The value that was bet in this outcome (if applicable) |
| ActualValue from 2021 | decimal (32) | NULL | Yes | The value that actually occurred in game (if applicable) |
BettingResultingMetadata
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketTypeId from 2021 | integer (32) | NOT NULL | No | ID that distinguishes the different types of Market Types |
| BettingBetTypeId from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingPeriodTypeId from 2021 | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this type of market which we can result |
BettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketSplitID | integer (32) | NOT NULL | No | The unique ID assciated with the betting split |
| BettingMarketID | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingOutcomeTypeID | integer (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType | string (32) | NULL | No | Name of Betting Outcome Type (e.g. Home; Away; Under; Over) |
| BetPercentage | integer (32) | NULL | Yes | The percentage of the bets on this market taken by this type of bet |
| MoneyPercentage | integer (32) | NULL | Yes | The percentage of the money placed in wagers on this market taken by this type of bet |
| Created | datetime (32) | NOT NULL | No | The timestamp this set of values was first seen |
| LastSeen | datetime (32) | NOT NULL | No | The timestamp this set of values was last seen (in US Eastern Time) |
BoxScore
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Game | Game | NULL | No | The game details of this box score |
| Periods | Period[] | NULL | No | The details of the periods (quarters & overtime) for this box score |
| PlayerGames | PlayerGame[] | NULL | No | The player game stats of this box score |
| TeamGames | TeamGame[] | NULL | No | The team game stats of this box score |
| ScoringPlays | ScoringPlay[] | NULL | No | The plays in which either team scoring during the game |
Conference
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| ConferenceID | integer (32) | NOT NULL | No | The unique ID of the team's conference |
| Name | string (50) | NOT NULL | No | The name of the team's conference |
| Teams | Team[] | NULL | No | The teams that play within this conference |
| ConferenceName | string (50) | NULL | No | The name of the team's parent conference (e.g. SEC, Big Ten, etc) |
| DivisionName | string (50) | NULL | No | The name of the team's division (e.g. East; West; Atlantic; etc). Note: Not all conferences have divisons |
ConsensusOutcome
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| NumberOfSportsbooks from 2020 | int (32) | NOT NULL | Yes | The number of sportsbooks odds that went into creating this consensus outcome |
| BettingOutcomeID from 2020 | int (32) | NULL | No | The unique ID associated with this specific outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID associated with the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | No | The name of the Betting Outcome Type (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome (spread, total, etc.) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: This is provided by the sportsbook. In the case of Player odds; we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks. |
| IsAvailable from 2020 | bool (32) | NULL | No | Denotes whether or not the betting outcome is currently available |
| IsAlternate from 2020 | bool (32) | NULL | No | Denotes whether or not the betting outcome is an alternate line |
| Created from 2020 | datetime (32) | NULL | No | The created date of the outcome |
| Updated from 2020 | datetime (32) | NULL | No | The last updated timestamp of this outcome (US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when this outcome was unlisted (no longer available for bets) |
| TeamID from 2020 | int (32) | NULL | No | The unique ID of the team associated with this Consensus outcome |
| PlayerID from 2020 | int (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO tied this consensus outcome (if applicable). Note: this ID remains with the player their entire collegiate career. |
| GlobalTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the team tied to this consensus outcome. Note: This value is guaranteed to be unique across all sports/leagues. |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Denotes whether the betting outcome is a live line (i.e. the outcome was created after the start of the game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID of a given sportsbook when available for deep links |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID of a given sportsbook when available for deep links |
DfsSlate
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateID | integer (32) | NOT NULL | No | The unique ID of the slate |
| Operator | string (20) | NULL | No | The name of the operator who is running contests for this slate. Possible values: FanDuel; DraftKings; Yahoo; FantasyDraft; etc. |
| OperatorSlateID | integer (32) | NULL | No | Unique ID of a slate (assigned by the operator). |
| OperatorName | string (50) | NULL | No | The name of the slate (assigned by the operator). Possible values: Main, Express, Arcade, Late Night, etc. |
| OperatorDay | date | NULL | No | The day (in EST/EDT) that the slate begins (assigned by the operator). |
| OperatorStartTime | datetime | NULL | No | The date/time (in EST/EDT) that the slate begins (assigned by the operator). |
| NumberOfGames | integer (32) | NULL | No | The number of actual games that this slate covers. |
| IsMultiDaySlate | boolean | NULL | No | Whether this slate uses games that take place on different days |
| RemovedByOperator | boolean | NULL | No | Indicates whether this slate was removed/deleted by the operator |
| OperatorGameType | string (50) | NULL | No | The game type of the slate. Will often be null as most operators only have one game type. |
| DfsSlateGames | DfsSlateGame[] | NULL | No | The games that are included in this slate |
| DfsSlatePlayers | DfsSlatePlayer[] | NULL | No | The players that are included in this slate |
| SlateRosterSlots | string[] | NULL | No | The positions that need to be filled for this particular slate |
| SalaryCap | integer | NULL | No | The salary cap for the current slate (is null for slates with no salary cap such a Tiers gametypes) |
DfsSlateGame
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateGameID | integer (32) | NOT NULL | No | The unique ID of a SlateGame as assigned by SportsDataIO |
| SlateID | integer (32) | NOT NULL | No | The unique ID of the slate that this SlateGame refers to |
| GameID | integer (32) | NULL | No | The unique ID of this game that this SlateGame refers to |
| Game | Game | NULL | No | The details of the game that this SlateGame refers to |
| OperatorGameID | integer (32) | NULL | No | Unique ID of a SlateGame (assigned by the operator) |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this slate was removed/deleted by the operator |
DfsSlatePlayer
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlatePlayerID | integer (32) | NOT NULL | No | The unique ID of a SlatePlayer as assigned by SportsDataIO |
| SlateID | integer (32) | NOT NULL | No | The unique ID of the slate that this SlateGame refers to |
| SlateGameID | integer (32) | NULL | No | The unique ID of the SlateGame that this SlatePlayer refers to as assigned by SportsDataIO |
| PlayerID | integer (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO that this slate player refers to. Note: this ID remains with the player their entire collegiate career |
| PlayerGameProjectionStatID | integer (32) | NULL | No | The SportsDataIO StatID that this SlatePlayer refers to. This points to data in the respective sports' projected player game stats feeds. |
| OperatorPlayerID | string (25) | NULL | No | Unique ID of the Player (assigned by the operator). |
| OperatorSlatePlayerID | string (50) | NULL | No | Unique ID of the SlatePlayer (assigned by the operator). |
| OperatorPlayerName | string (50) | NULL | No | The player's name (assigned by the operator). |
| OperatorPosition | string (10) | NULL | No | The player's eligible positions for the contest (assigned by the operator). |
| OperatorSalary | integer (32) | NULL | No | The player's salary for the contest (assigned by the operator). |
| OperatorRosterSlots | string[] | NULL | No | The player's eligible positions to be played in the contest (assigned by the operator). This would include UTIL, etc plays for those that are eligible. |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this slate was removed/deleted by the operator |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that the player is on. Note: If this player is a free agent; this field is NULL |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this player |
Game
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The College Football season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Week | integer (32) | NULL | No | The week of the game |
| Status | string (20) | NULL | No | The status of the game. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| AwayTeamName | string (100) | NULL | No | The name of the away team |
| HomeTeamName | string (100) | NULL | No | The name of the home team |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in this game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of points the home team scored in this game |
| Period | string (10) | NULL | No | The current quarter in the game (Possible Values: 1; 2; 3; 4; Half; OT; F; F/OT; NULL) |
| TimeRemainingMinutes | integer (32) | NULL | No | Total number of minutes remaining in the quarter |
| TimeRemainingSeconds | integer (32) | NULL | No | Total number of seconds remaining in the quarter |
| PointSpread from 2016 | decimal (32) | NULL | Yes | The oddsmaker Point Spread at game start from the perspective of the HomeTeam. Note: negative numbers indicate the HomeTeam is favored; positive numbers indicate the AwayTeam is favored |
| OverUnder from 2016 | decimal (32) | NULL | Yes | The sportsbook's total points line at game start |
| AwayTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| HomeTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| Updated | datetime | NULL | No | The timestamp of when this game was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The timestamp of when this game was first created (in US Eastern Time) |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. Note: This value is guaranteed to be unique across all sports/leagues |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium/venue where this game was played |
| Stadium | Stadium | NULL | No | The details of the stadium where this game is played |
| YardLine | integer (32) | NULL | Yes | The yard line that the ball is on at the current state of the game |
| YardLineTerritory | string (10) | NOT NULL | Yes | The team's side of the field that the ball is on |
| Down | integer (32) | NULL | Yes | The current down |
| Distance | integer (32) | NULL | Yes | The current distance to a first down |
| Possession | string (10) | NOT NULL | Yes | Which team currently has possession of the ball |
| Periods | Period[] | NULL | No | The details of the periods (quarters & overtime) for this game |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| Title from 2018 | string (50) | NULL | No | The title of the game (e.g. Rose Bowl, Citrus Bowl, etc) |
| HomeRotationNumber | integer (32) | NULL | Yes | Rotation number of home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | Rotation number of away team for this game |
| Channel | string (10) | NULL | No | The television station broadcasting the game |
| NeutralVenue from 2020 | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| AwayPointSpreadPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| HomePointSpreadPayout from 2021 | integer (32) | NULL | Yes | The point spread payout for the home team |
| OverPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the over in the total points line |
| UnderPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| DateTimeUTC from 2021 | datetime | NULL | Yes | The date and time of the game (in UTC) |
| Attendance | integer (32) | NULL | No | The total number of people who attended the game |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
GameBettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game tied to this split |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The college football season of the game |
| Week | integer (32) | NOT NULL | No | The week of the game related to this betting split |
| Day | datetime (32) | NULL | No | The date of the game |
| AwayTeam | string (32) | NULL | No | The abbreviation [Key] of the away team tied to this split |
| HomeTeam | string (32) | NULL | No | The abbreviation [Key] of the home team |
| BettingMarketSplits | BettingMarketSplit[] (32) | NOT NULL | No | Shows the Market Types that have splits included for them in a given game |
GameInfo
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameId | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The college football season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Week | integer (32) | NULL | No | The week of the game |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| Status | string (10) | NULL | No | The status of the game. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| GlobalGameId | integer (32) | NOT NULL | No | A globally unique ID for this game. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalAwayTeamId | integer (32) | NULL | No | A globally unique ID for the away team. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamId | integer (32) | NULL | No | A globally unique ID for the home team. Note: This value is guaranteed to be unique across all sports/leagues |
| PregameOdds | GameOdd[] | NULL | No | List of Pregame Odds from different sportsbooks |
| LiveOdds | GameOdd[] | NULL | No | List of Live Odds from different sportsbooks |
| HomeTeamScore | integer | NULL | Yes | Score of the home team (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer | NULL | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
| TotalScore | integer | NULL | Yes | The total points scored by both teams in the game tied to this event (updated after game ends to allow for resolving bets) |
| HomeRotationNumber | integer (32) | NULL | Yes | Rotation number of home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | Rotation number of away team for this game |
| AlternateMarketPregameOdds | GameOdd[] | NULL | No | List of Alternate Market Pregame Odds from different sportsbooks |
GameInfoResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The college football season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Week | integer (32) | NULL | No | The week of the game related to this result |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| Status | string (25) | NULL | No | The status of the game. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalAwayTeamID | integer (32) | NULL | No | A globally unique ID for the away team. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID | integer (32) | NULL | No | A globally unique ID for the home team. Note: This value is guaranteed to be unique across all sports/leagues |
| PregameOdds | GameOddResult[] | NULL | No | List of Pregame Odds from different sportsbooks with results |
| HomeTeamScore | integer (32) | NULL | Yes | Score of the home team (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer (32) | NULL | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
| TotalScore | integer (32) | NULL | Yes | The total points scored by both teams in the game tied to this event (updated after game ends to allow for resolving bets) |
| HomeRotationNumber | integer (32) | NULL | Yes | Rotation number of home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | Rotation number of away team for this game |
| AlternateMarketPregameOdds | GameOddResult[] | NULL | No | List of Alternate Market Pregame Odds from different sportsbooks with results |
| Period | string (10) | NULL | No | The current quarter in the game (Possible Values: 1; 2; 3; 4; Half; OT; F; F/OT; NULL) |
| TimeRemainingMinutes | integer (32) | NULL | No | Total number of minutes remaining in the quarter |
| TimeRemainingSeconds | integer (32) | NULL | No | Total number of seconds remaining in the quarter |
| Periods | Period[] | NULL | No | The details of the periods (quarters & overtime) for this game |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified |
| LiveOdds | GameOddResult[] | NULL | No | List of Live Odds from different sportsbooks with results |
GameOdd
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | Unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | The name of the sportsbook |
| GameId | integer (32) | NOT NULL | No | The unique ID of this game |
| Created | datetime | NOT NULL | No | The timestamp of when these odds were first created (in US Eastern Time) |
| Updated | datetime | NOT NULL | No | The timestamp of when these odds were last updated, based on US Eastern Time (EST/EDT). If these are the latest odds for this game, and they have not been updated within the last few minutes, then it indicates that there were problems connecting to the sportsbook |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| DrawMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for a draw |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total points line at game start |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over in the total points line |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookId | integer (32) | NULL | No | The unique ID of the sportsbook |
| OddType | string (32) | NULL | No | The market type of the odd (ex: live; pregame; etc) |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| Unlisted | datetime | NULL | No | The timestamp of when these odds were no longer seen (US Eastern Time) |
GameOddOutcome
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | Unique ID of this odd |
| GameOddResultTypeId | integer (32) | NULL | No | The GameOddResultType of this outcome as an integer |
| GameOddResultType | string (100) | NULL | No | The string identifier of the GameOddResultType of this outcome (e.g. Won, Lost, Push, Not Resulted, Incomplete) |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live, pregame, 1st-5th Inning, etc) |
| GameOddType | string (100) | NULL | No | The GameOddOutcomeType of this outcome as a string |
| BetValue | decimal (32) | NULL | No | The value that was bet in this outcome (if applicable) |
| ActualValue | decimal (32) | NULL | No | The value that actually occurred in game (if applicable) |
GameOddResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddID | integer (32) | NOT NULL | No | Unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | The name of the sportsbook |
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Created | datetime | NOT NULL | No | The timestamp of when these odds were first created (in US Eastern Time) |
| Updated | datetime | NOT NULL | No | The timestamp of when these odds were last updated, based on US Eastern Time (EST/EDT). If these are the latest odds for this game, and they have not been updated within the last few minutes, then it indicates that there were problems connecting to the sportsbook |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| DrawMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for a draw |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total points line at game start |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over in the total points line |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookID | integer (32) | NULL | No | The unique ID of the sportsbook |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (32) | NULL | No | The market type of the odd (ex: live; pregame; 1st-5th Inning; etc) |
| GameOddOutcomeResults | GameOddOutcome[] | NULL | No | The list of outcomes under this Game Odd Record with results |
MatchupTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| UpcomingGame from 2020 | Game | NULL | No | The most recent future game for the team and their opponent |
| TeamTrends from 2020 | TeamTrends[] | NULL | No | The collection of team trends between each team |
| TeamMatchupTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of team game trends against the opponent |
| OpponentMatchupTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of opponent game trends against team |
| PreviousGames from 2020 | Game[] | NULL | No | The collection of last 10 game scores between each team |
Period
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PeriodID | integer (32) | NOT NULL | No | Unique ID for each period |
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Number | integer (32) | NOT NULL | No | The Number (Order) of the Period in the scope of the Game. |
| Name | string (10) | NOT NULL | No | The name of the period (possible values: 1; 2; 3; 4; OT; Final, F/OT) |
| AwayScore | integer (32) | NULL | Yes | The total points scored by the away team in this period |
| HomeScore | integer (32) | NULL | Yes | The total points scored by the home team in this period |
Player
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The unique ID of the player as assigned by SportsDataIO. Note: this ID remains with the player their entire collegiate career |
| FirstName | string (50) | NULL | No | The player's first name |
| LastName | string (50) | NULL | No | The player's last name |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this player |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that the player is on. Note: If this player is a free agent; this field is NULL |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; CB; DB; DE; DL; DT; FB; G; K; KR; LB; LS; NT; OL; OLB; OT; P; PR; QB; RB; S; SS; TE; WR |
| PositionCategory | string (3) | NULL | No | The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST) |
| Class | string (50) | NULL | No | The class of the player. Possible values: Freshman; Sophomore; Junior; Senior; Graduate Student; as well as Redshirt for all classes |
| Height | integer (32) | NULL | No | The player's height in inches |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs) |
| BirthCity | string (50) | NULL | No | The city in which the player was born |
| BirthState | string (50) | NULL | No | The state in which the player was born |
| Updated | datetime | NULL | No | The timestamp of when this player was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The updated date and time of the player |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for the player's team. Note: This value is guaranteed to be unique across all sports/leagues |
| InjuryStatus from 2018 | string (50) | NULL | No | Indicates the player's injury status (possible values include: Probable, Questionable, Doubtful, Out) |
| InjuryBodyPart from 2018 | string (50) | NULL | No | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
| InjuryStartDate from 2018 | date | NULL | No | The day that the injury started or first discovered |
| InjuryNotes from 2018 | string (250) | NULL | No | Brief description of the player's injury and expected availability |
PlayerBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The unique ID of the player as assigned by SportsDataIO. Note: this ID remains with the player their entire collegiate career |
| FirstName | string (50) | NULL | No | The player's first name |
| LastName | string (50) | NULL | No | The player's last name |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this player |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that the player is on Note: If this player is a free agent; this field is NULL |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; CB; DB; DE; DL; DT; FB; G; K; KR; LB; LS; NT; OL; OLB; OT; P; PR; QB; RB; S; SS; TE; WR |
| PositionCategory | string (3) | NULL | No | The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST) |
| Class | string (50) | NULL | No | The class of the player. Possible values: Freshman; Sophomore; Junior; Senior; Graduate Student; as well as Redshirt for all classes |
| Height | integer (32) | NULL | No | The player's height in inches |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs) |
| BirthCity | string (50) | NULL | No | The city in which the player was born |
| BirthState | string (50) | NULL | No | The state in which the player was born |
| Updated | datetime | NULL | No | The timestamp of when this player was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The date and time the player was created (US Eastern Time) |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for the player's team. Note: This value is guaranteed to be unique across all sports/leagues |
PlayerGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stats associated with the player in this game |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this player |
| PlayerID | integer (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO. Note: this ID remains with the player their entire collegiate career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NULL | No | The college football season of the game |
| Name | string (50) | NULL | No | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that the player is on |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; CB; DB; DE; DL; DT; FB; G; K; KR; LB; LS; NT; OL; OLB; OT; P; PR; QB; RB; S; SS; TE; WR |
| PositionCategory | string (10) | NULL | No | The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST) |
| InjuryStatus from 2018 | string (50) | NULL | No | Indicates the player's injury status (possible values include: Probable, Questionable, Doubtful, Out) |
| InjuryBodyPart from 2018 | string (50) | NULL | No | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
| InjuryStartDate from 2018 | date | NULL | No | The day that the injury started or was first discovered. |
| InjuryNotes from 2018 | string (250) | NULL | No | Brief description of the player's injury and expected availability. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this player's team. This value is guaranteed to be unique across all sports/leagues. |
| DraftKingsPosition from 2018 | string (10) | NULL | No | The DraftKings player position for this game. |
| DraftKingsSalary from 2018 | integer (32) | NULL | Yes | A DraftKings salary for the next "standard" slate this game is in. NOTE: this may change as slates start & this value changes to the next slate's salary. |
| Week | integer (32) | NULL | No | The week of the game related to this player's PlayerGame record |
| GameID | integer (32) | NULL | No | The unique ID of this game |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when this player was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The date and time this stat record was created for the player in the game |
| Games | integer (32) | NULL | No | Indicates whether or not a player has recorded any stats for a given game. If the player did, this field will be 1. If the player did not record stats, a record will not exist for them in that game |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points scored by the player in the game |
| PassingAttempts | decimal (32) | NULL | Yes | Total passing attempts by the player in the game |
| PassingCompletions | decimal (32) | NULL | Yes | Total passing completions by the player in the game |
| PassingYards | decimal (32) | NULL | Yes | Total passing yards by the player in the game |
| PassingCompletionPercentage | decimal (32) | NULL | Yes | Total passing completion percentage by the player in the game |
| PassingYardsPerAttempt | decimal (32) | NULL | Yes | Total passing yards per attempt by the player in the game |
| PassingYardsPerCompletion | decimal (32) | NULL | Yes | Total passing yards per completion by the player in the game |
| PassingTouchdowns | decimal (32) | NULL | Yes | Total passing touchdowns by the player in the game |
| PassingInterceptions | decimal (32) | NULL | Yes | Total passing interceptions by the player in the game |
| PassingRating | decimal (32) | NULL | Yes | Total passing rating by the player in the game |
| RushingAttempts | decimal (32) | NULL | Yes | Total rushing attempts by the player in the game |
| RushingYards | decimal (32) | NULL | Yes | Total rushing yards by the player in the game |
| RushingYardsPerAttempt | decimal (32) | NULL | Yes | Total rushing yards per attempt by the player in the game |
| RushingTouchdowns | decimal (32) | NULL | Yes | Total rushing touchdowns by the player in the game |
| RushingLong | decimal (32) | NULL | Yes | Longest rushing attempt by the player in the game |
| Receptions | decimal (32) | NULL | Yes | Total receptions by the player in the game |
| ReceivingYards | decimal (32) | NULL | Yes | Total receiving yards by the player in the game |
| ReceivingYardsPerReception | decimal (32) | NULL | Yes | Total receiving yards per reception by the player in the game |
| ReceivingTouchdowns | decimal (32) | NULL | Yes | Total receiving touchdowns by the player in the game |
| ReceivingLong | decimal (32) | NULL | Yes | Longest reception by the player in the game |
| PuntReturns | decimal (32) | NULL | Yes | Total punt returns by the player in the game |
| PuntReturnYards | decimal (32) | NULL | Yes | Total punt return yards by the player in the game |
| PuntReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total punt return yards per attempt by the player in the game |
| PuntReturnTouchdowns | decimal (32) | NULL | Yes | Total punt return touchdowns by the player in the game |
| PuntReturnLong | decimal (32) | NULL | Yes | Longest punt return by the player in the game |
| KickReturns | decimal (32) | NULL | Yes | Total kick returns by the player in the game |
| KickReturnYards | decimal (32) | NULL | Yes | Total kick return yards by the player in the game |
| KickReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total kick return yards per attempt by the player in the game |
| KickReturnTouchdowns | decimal (32) | NULL | Yes | Total kick return touchdowns by the player in the game |
| KickReturnLong | decimal (32) | NULL | Yes | The longest kick return by the player in the game |
| Punts | decimal (32) | NULL | Yes | Total punts by the player in the game |
| PuntYards | decimal (32) | NULL | Yes | Total punt yards by the player in the game |
| PuntAverage | decimal (32) | NULL | Yes | Total average punt yards by the player in the game |
| PuntLong | decimal (32) | NULL | Yes | Longest punt by the player in the game |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the player in the game |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the player in the game |
| FieldGoalPercentage | decimal (32) | NULL | Yes | Total field goal percentage by the player in the game |
| FieldGoalsLongestMade | decimal (32) | NULL | Yes | The longest field goal made by the player in the game |
| ExtraPointsAttempted | decimal (32) | NULL | Yes | Total extra points attempted by the player in the game |
| ExtraPointsMade | decimal (32) | NULL | Yes | Total extra points made by the player in the game |
| Interceptions | decimal (32) | NULL | Yes | Total defensive interceptions by the player in the game |
| InterceptionReturnYards | decimal (32) | NULL | Yes | Total interception return yards for the player in the game |
| InterceptionReturnTouchdowns | decimal (32) | NULL | Yes | Total interception return touchdowns for the player in the game |
| SoloTackles from 2018 | decimal (32) | NULL | Yes | Total solo tackles by the player in the game |
| AssistedTackles from 2018 | decimal (32) | NULL | Yes | Total assisted tackles by the player in the game |
| TacklesForLoss from 2018 | decimal (32) | NULL | Yes | Total tackles for a loss by the player in the game |
| Sacks from 2018 | decimal (32) | NULL | Yes | Total sacks by the player in the game |
| PassesDefended from 2018 | decimal (32) | NULL | Yes | Total passes defended by the player in the game |
| FumblesRecovered from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles recoveries by the player in the game |
| FumbleReturnTouchdowns from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles returned for a touchdown by the player in the game |
| QuarterbackHurries from 2018 | decimal (32) | NULL | Yes | This field is deprecated. |
| Fumbles from 2018 | decimal (32) | NULL | Yes | Total fumbles by the player in the game |
| FumblesLost from 2018 | decimal (32) | NULL | Yes | Total fumbles lost by the player in the game |
PlayerSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stats associated with the player in this season |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this player |
| PlayerID | integer (32) | NULL | No | The unique ID of the player as assigned by SportsDataIO. Note: this ID remains with the player their entire collegiate career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NULL | No | The college football season of the game |
| Name | string (50) | NULL | No | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that the player is on |
| Position | string (10) | NULL | No | Player's position in the starting lineup (if started), otherwise the position he substituted for |
| PositionCategory | string (10) | NULL | No | The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST) |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for the player's team. Note: This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when this player was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The date and time this stat record was created for the player in the season |
| Games | integer (32) | NULL | No | Total number of games the player recorded stats in during the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points scored by the player in the season |
| PassingAttempts | decimal (32) | NULL | Yes | Total passing attempts by the player in the season |
| PassingCompletions | decimal (32) | NULL | Yes | Total passing completions by the player in the season |
| PassingYards | decimal (32) | NULL | Yes | Total passing yards by the player in the season |
| PassingCompletionPercentage | decimal (32) | NULL | Yes | Total passing completion percentage by the player in the season |
| PassingYardsPerAttempt | decimal (32) | NULL | Yes | Total passing yards per attempt by the player in the season |
| PassingYardsPerCompletion | decimal (32) | NULL | Yes | Total passing yards per completion by the player in the season |
| PassingTouchdowns | decimal (32) | NULL | Yes | Total passing touchdowns by the player in the season |
| PassingInterceptions | decimal (32) | NULL | Yes | Total passing interceptions by the player in the season |
| PassingRating | decimal (32) | NULL | Yes | Total passing rating by the player in the season |
| RushingAttempts | decimal (32) | NULL | Yes | Total rushing attempts by the player in the season |
| RushingYards | decimal (32) | NULL | Yes | Total rushing yards by the player in the season |
| RushingYardsPerAttempt | decimal (32) | NULL | Yes | Total rushing yards per attempt by the player in the season |
| RushingTouchdowns | decimal (32) | NULL | Yes | Total rushing touchdowns by the player in the season |
| RushingLong | decimal (32) | NULL | Yes | Longest rushing attempt by the player in the season |
| Receptions | decimal (32) | NULL | Yes | Total receptions by the player in the season |
| ReceivingYards | decimal (32) | NULL | Yes | Total receiving yards by the player in the season |
| ReceivingYardsPerReception | decimal (32) | NULL | Yes | Total receiving yards per reception by the player in the season |
| ReceivingTouchdowns | decimal (32) | NULL | Yes | Total receiving touchdowns by the player in the season |
| ReceivingLong | decimal (32) | NULL | Yes | Longest reception by the player in the season |
| PuntReturns | decimal (32) | NULL | Yes | Total punt returns by the player in the season |
| PuntReturnYards | decimal (32) | NULL | Yes | Total punt return yards by the player in the season |
| PuntReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total punt return yards per attempt by the player in the season |
| PuntReturnTouchdowns | decimal (32) | NULL | Yes | Total punt return touchdowns by the player in the season |
| PuntReturnLong | decimal (32) | NULL | Yes | Longest punt return by the player in the season |
| KickReturns | decimal (32) | NULL | Yes | Total kick returns by the player in the season |
| KickReturnYards | decimal (32) | NULL | Yes | Total kick return yards by the player in the season |
| KickReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total yards per kick return by the player in the season |
| KickReturnTouchdowns | decimal (32) | NULL | Yes | Total kick return touchdowns by the player in the season |
| KickReturnLong | decimal (32) | NULL | Yes | The longest kick return by the player in the season |
| Punts | decimal (32) | NULL | Yes | Total punts by the player in the season |
| PuntYards | decimal (32) | NULL | Yes | Total punt yards by the player in the season |
| PuntAverage | decimal (32) | NULL | Yes | Total average punt yards by the player in the season |
| PuntLong | decimal (32) | NULL | Yes | Longest punt by the player in the season |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the player in the season |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the player in the season |
| FieldGoalPercentage | decimal (32) | NULL | Yes | Total field goal percentage by the player in the season |
| FieldGoalsLongestMade | decimal (32) | NULL | Yes | The longest field goal made by the player in the season |
| ExtraPointsAttempted | decimal (32) | NULL | Yes | Total extra points attempted by the player in the season |
| ExtraPointsMade | decimal (32) | NULL | Yes | Total extra points made by the player in the season |
| Interceptions | decimal (32) | NULL | Yes | Total defensive interceptions by the player in the season |
| InterceptionReturnYards | decimal (32) | NULL | Yes | Total interception return yards for the player in the season |
| InterceptionReturnTouchdowns | decimal (32) | NULL | Yes | Total interception return touchdowns for the player in the season |
| SoloTackles from 2018 | decimal (32) | NULL | Yes | Total solo tackles by the player in the season |
| AssistedTackles from 2018 | decimal (32) | NULL | Yes | Total assisted tackles by the player in the season |
| TacklesForLoss from 2018 | decimal (32) | NULL | Yes | Total tackles for a loss by the player in the season |
| Sacks from 2018 | decimal (32) | NULL | Yes | Total sacks by the player in the season |
| PassesDefended from 2018 | decimal (32) | NULL | Yes | Total passes defended by the player in the season |
| FumblesRecovered from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles recoveries by the player in the season |
| FumbleReturnTouchdowns from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles returned for a touchdown by the player in the season |
| QuarterbackHurries from 2018 | decimal (32) | NULL | Yes | This field is deprecated. |
| Fumbles from 2018 | decimal (32) | NULL | Yes | Total fumbles by the player in the season |
| FumblesLost from 2018 | decimal (32) | NULL | Yes | Total fumbles lost by the player in the season |
ScheduleBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The College Football season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Week | integer (32) | NULL | No | The week of the game |
| Status | string (20) | NULL | No | The status of the game. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| AwayTeamName | string (100) | NULL | No | The name of the away team |
| HomeTeamName | string (100) | NULL | No | The name of the home team |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in this game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of points the home team scored in this game |
| Updated | datetime | NULL | No | The timestamp of when this game was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The timestamp of when this game was first created (in US Eastern Time) |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. Note: This value is guaranteed to be unique across all sports/leagues |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium/venue where this game was played |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| Title | string (50) | NULL | No | The title of the game (e.g. Rose Bowl, Citrus Bowl, etc) |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| DateTimeUTC | datetime | NULL | Yes | The date and time of the game (in UTC) |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
ScoreBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The College Football season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Week | integer (32) | NULL | No | The week of the game |
| Status | string (20) | NULL | No | The status of the game. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| AwayTeamName | string (100) | NULL | No | The name of the away team |
| HomeTeamName | string (100) | NULL | No | The name of the home team |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in this game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of points the home team scored in this game |
| Updated | datetime | NULL | No | The timestamp of when this game was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The timestamp of when this game was first created (in US Eastern Time) |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. Note: This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. Note: This value is guaranteed to be unique across all sports/leagues |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium/venue where this game was played |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| Title | string (50) | NULL | No | The title of the game (e.g. Rose Bowl, Citrus Bowl, etc) |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| DateTimeUTC | datetime | NULL | Yes | The date and time of the game (in UTC) |
ScoringPlay
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| ScoringPlayID from 2018 | integer (32) | NOT NULL | No | The unique id of the scoring play |
| GameID from 2018 | integer (32) | NOT NULL | No | The unique ID of this game |
| Period from 2018 | string (10) | NOT NULL | No | The period of the score |
| TimeRemainingMinutes from 2018 | integer (32) | NULL | Yes | Total number of minutes remaining in the quarter when the scoring play happened |
| TimeRemainingSeconds from 2018 | integer (32) | NULL | Yes | Total number of seconds remaining in the quarter when the scoring play happened |
| Description from 2018 | string (500) | NOT NULL | Yes | The description of the play |
| DriveSummary from 2018 | string (100) | NOT NULL | Yes | The summary of the drive in plays, yards and time elapsed |
| HomeTeamScore from 2018 | integer (32) | NULL | Yes | The score of the home team after the play |
| AwayTeamScore from 2018 | integer (32) | NULL | Yes | Total number of points of the away team after the play |
| ScoringTeamID from 2018 | integer (32) | NULL | No | The ID of the team who scord on the play |
| ScoringType from 2018 | string (20) | NOT NULL | Yes | The type of score on the play (ex. TD; FG; SF; D2P for Touchdown; Field Goal; Safety; Defensive 2pt conversion respectively) |
| Sequence from 2018 | integer (20) | NOT NULL | Yes | The order in which the scoring plays happened |
Sportsbook
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SportsbookID | int (32) | NOT NULL | No | The unique ID of the sportsbook |
| Name | string (32) | NOT NULL | Yes | The name of the sportsbooks |
Stadium
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StadiumID | integer (32) | NOT NULL | No | The unique ID of the stadium |
| Active | boolean | NOT NULL | No | Whether or not this stadium is the home venue for an active team |
| Name | string (50) | NOT NULL | No | The full name of the stadium |
| Dome | boolean | NOT NULL | No | Indicates whether this stadium is a dome |
| City | string (50) | NULL | No | The city where the stadium is located |
| State | string (10) | NULL | No | The US state where the stadium is located Note: if stadium is outside United States; this value is NULL |
| GeoLat | decimal (32) | NULL | No | The geographic latitude coordinate of this venue |
| GeoLong | decimal (32) | NULL | No | The geographic longitude coordinate of this venue |
Team
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
| [Key] | string (10) | NOT NULL | No | A unique abbreviation of the team (e.g. OAE; TAS; UAD; KAF; etc.) Note: Due to being selected for uniqueness; these are not always a match with broadcaster abbreviations. For that use case; use ShortDisplayName |
| Active | boolean | NOT NULL | No | Whether or not this team is active |
| School | string (50) | NULL | No | The name of the school as used in college sports (e.g. SMU, South Florida, Stony Brook, UCLA, etc.) |
| Name | string (50) | NULL | No | The mascot of the team (e.g. Sooners, Red Raiders, Trojans, Wildcats, etc.) |
| StadiumID | integer (32) | NOT NULL | No | The unique ID of the stadium that the team plays its home games at |
| ApRank | integer (32) | NULL | No | The rank of the team assigned to them by the Associated Press (AP) |
| Wins | integer (32) | NULL | No | Total number of wins by the team |
| Losses | integer (32) | NULL | No | The total number of losses by the team in the current season |
| ConferenceWins | integer (32) | NULL | No | The total number of conference wins by the team |
| ConferenceLosses | integer (32) | NULL | No | The total number of conference losses by the team |
| GlobalTeamID | integer (32) | NOT NULL | No | A globally unique ID for the team. Note: This value is guaranteed to be unique across all sports/leagues |
| CoachesRank | integer (32) | NULL | No | The Coaches Rank of the team |
| PlayoffRank | integer (32) | NULL | No | The CFP Rank of the team |
| TeamLogoUrl | string (100) | NULL | No | The url of the team logo image |
| ConferenceID | integer (32) | NULL | No | The unique ID of the team's conference |
| Conference | string (50) | NULL | No | The name of the team's parent conference (e.g. SEC; Big Ten; etc) |
| ShortDisplayName | string (10) | NULL | No | The shortened name of the team |
| RankWeek | integer (32) | NULL | No | The week that the AP Rank/CoachesRank was last updated |
| RankSeason | integer (32) | NULL | No | The season that the AP Rank/CoachesRank was last updated |
| RankSeasonType | integer (32) | NULL | No | The season type that the AP Rank/CoachesRank was last updated |
| PrimaryColor | string (6) | NULL | No | The team's primary color. (This is not licensed for public or commercial use) |
| SecondaryColor | string (6) | NULL | No | The team's secondary color. (This is not licensed for public or commercial use) |
| TertiaryColor | string (6) | NULL | No | The team's tertiary color. (This is not licensed for public or commercial use) |
| QuaternaryColor | string (6) | NULL | No | The team's quaternary color. (This is not licensed for public or commercial use) |
TeamBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
| Key | string (10) | NOT NULL | No | A unique abbreviation of the team (e.g. OAE; TAS; UAD; KAF; etc.) These are not recommended for front end use as they may not match common usage; see the ShortDisplayName instead. |
| Active | boolean | NOT NULL | No | Whether or not this team is active |
| School | string (50) | NULL | No | The name of the school as used in college sports (e.g. SMU; South Florida; Stony Brook; UCLA; etc.) |
| Name | string (50) | NULL | No | The full name of the stadium |
| StadiumID | integer (32) | NOT NULL | No | The unique ID of the stadium that the team plays its home games at |
| GlobalTeamID | integer (32) | NOT NULL | No | A globally unique ID for the team. Note: This value is guaranteed to be unique across all sports/leagues |
| TeamLogoUrl | string (100) | NULL | No | The url of the team logo image |
| ConferenceID | integer (32) | NULL | No | The unique ID of the team's conference |
| Conference | string (50) | NULL | No | The name of the team's parent conference (e.g. SEC; Big Ten; etc) |
| ShortDisplayName | string (10) | NULL | No | The shortened name of the team - recommended for front end applications. May not be unique; if you need a 100% unique letter identifier see the Key field in this table. |
| PrimaryColor | string (6) | NULL | No | The team's primary color. (This is not licensed for public or commercial use) |
| SecondaryColor | string (6) | NULL | No | The team's secondary color. (This is not licensed for public or commercial use) |
| TertiaryColor | string (6) | NULL | No | The team's tertiary color. (This is not licensed for public or commercial use) |
| QuaternaryColor | string (6) | NULL | No | The team's quaternary color. (This is not licensed for public or commercial use) |
TeamGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stats associated with the team in this game |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NULL | No | The college football season of the game |
| Name | string (50) | NULL | No | The team's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Score | integer (32) | NULL | Yes | Total points scored by the team in the game |
| OpponentScore | integer (32) | NULL | Yes | Total points scored by the opponent team |
| FirstDowns | integer (32) | NULL | Yes | Total first downs converted by the team in the game |
| ThirdDownConversions | integer (32) | NULL | Yes | Total third down conversions by the team in the game |
| ThirdDownAttempts | integer (32) | NULL | Yes | Total third down attempts by the team in the game |
| FourthDownConversions | integer (32) | NULL | Yes | Total fourth down conversions by the team in the game |
| FourthDownAttempts | integer (32) | NULL | Yes | Total fourth down attempts by the team in the game |
| Penalties | integer (32) | NULL | Yes | Total penalties committed by the team in the game |
| PenaltyYards | integer (32) | NULL | Yes | Total penalties yards enforced against the team in the game |
| TimeOfPossessionMinutes | integer (32) | NULL | Yes | Total number of minutes the team possessed the ball for in the game |
| TimeOfPossessionSeconds | integer (32) | NULL | Yes | Total number of seconds the team possessed the ball for in the game |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for the team. Note: This value is guaranteed to be unique across all sports/leagues. |
| Week | integer (32) | NULL | No | The week of the game related to this team |
| GameID | integer (32) | NULL | No | The unique ID of this game |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true/false) |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. Note: This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | "A globally unique ID for the opponent team. Note: This value is guaranteed to be unique across all sports/leagues." |
| Updated | datetime | NULL | No | The timestamp of when this team was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The date and time this stat record was created for the team in the game |
| Games | integer (32) | NULL | No | Total number of games the team recorded stats in. Note: this should always be 1 when referring to teams |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points scored by the team in the game |
| PassingAttempts | decimal (32) | NULL | Yes | Total passing attempts by the team in the game |
| PassingCompletions | decimal (32) | NULL | Yes | Total passing completions by the team in the game |
| PassingYards | decimal (32) | NULL | Yes | Total passing yards by the team in the game |
| PassingCompletionPercentage | decimal (32) | NULL | Yes | Total passing completion percentage by the team in the game |
| PassingYardsPerAttempt | decimal (32) | NULL | Yes | Total passing yards per attempt by the team in the game |
| PassingYardsPerCompletion | decimal (32) | NULL | Yes | Total passing yards per completion by the team in the game |
| PassingTouchdowns | decimal (32) | NULL | Yes | Total passing touchdowns by the team in the game |
| PassingInterceptions | decimal (32) | NULL | Yes | Total passing interceptions by the team in the game |
| PassingRating | decimal (32) | NULL | Yes | Total passing rating by the team in the game |
| RushingAttempts | decimal (32) | NULL | Yes | Total rushing attempts by the team in the game |
| RushingYards | decimal (32) | NULL | Yes | Total rushing yards by the team in the game |
| RushingYardsPerAttempt | decimal (32) | NULL | Yes | Total rushing yards per attempt by the team in the game |
| RushingTouchdowns | decimal (32) | NULL | Yes | Total rushing touchdowns by the team in the game |
| RushingLong | decimal (32) | NULL | Yes | Longest rushing attempt by the team in the game |
| Receptions | decimal (32) | NULL | Yes | Total receptions by the team in the game |
| ReceivingYards | decimal (32) | NULL | Yes | Total receiving yards by the team in the game |
| ReceivingYardsPerReception | decimal (32) | NULL | Yes | Total receiving yards per reception by the team in the game |
| ReceivingTouchdowns | decimal (32) | NULL | Yes | Total receiving touchdowns by the team in the game |
| ReceivingLong | decimal (32) | NULL | Yes | Longest reception by the team in the game |
| PuntReturns | decimal (32) | NULL | Yes | Total punt returns by the team in the game |
| PuntReturnYards | decimal (32) | NULL | Yes | Total punt return yards by the team in the game |
| PuntReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total punt return yards per attempt by the team in the game |
| PuntReturnTouchdowns | decimal (32) | NULL | Yes | Total punt return touchdowns by the team in the game |
| PuntReturnLong | decimal (32) | NULL | Yes | Longest punt return by the team in the game |
| KickReturns | decimal (32) | NULL | Yes | Total kick returns by the team in the game |
| KickReturnYards | decimal (32) | NULL | Yes | Total kick return yards by the team in the game |
| KickReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total yards per kick return by the team in the game |
| KickReturnTouchdowns | decimal (32) | NULL | Yes | Total kick return touchdowns by the team in the game |
| KickReturnLong | decimal (32) | NULL | Yes | The longest kick return by the team in the game |
| Punts | decimal (32) | NULL | Yes | Total punts by the team in the game |
| PuntYards | decimal (32) | NULL | Yes | Total punt yards by the team in the game |
| PuntAverage | decimal (32) | NULL | Yes | Total average punt yards by the team in the game |
| PuntLong | decimal (32) | NULL | Yes | Longest punt by the team in the game |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the team in the game |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the team in the game |
| FieldGoalPercentage | decimal (32) | NULL | Yes | Total field goal percentage by the team in the game |
| FieldGoalsLongestMade | decimal (32) | NULL | Yes | The longest field goal made by the team in the game |
| ExtraPointsAttempted | decimal (32) | NULL | Yes | Total extra points attempted by the team in the game |
| ExtraPointsMade | decimal (32) | NULL | Yes | Total extra points made by the team in the game |
| Interceptions | decimal (32) | NULL | Yes | Total defensive interceptions by the team in the game |
| InterceptionReturnYards | decimal (32) | NULL | Yes | Total interception return yards for the team in the game |
| InterceptionReturnTouchdowns | decimal (32) | NULL | Yes | Total interception return touchdowns for the team in the game |
| SoloTackles from 2018 | decimal (32) | NULL | Yes | Total solo tackles by the team in the game |
| AssistedTackles from 2018 | decimal (32) | NULL | Yes | Total assisted tackles by the team in the game |
| TacklesForLoss from 2018 | decimal (32) | NULL | Yes | Total tackles for a loss by the team in the game |
| Sacks from 2018 | decimal (32) | NULL | Yes | Total sacks by the team in the game |
| PassesDefended from 2018 | decimal (32) | NULL | Yes | Total passes defended by the team in the game |
| FumblesRecovered from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles recoveries by the team in the game |
| FumbleReturnTouchdowns from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles returned for a touchdown by the team in the game |
| QuarterbackHurries from 2018 | decimal (32) | NULL | Yes | This field is deprecated. |
| Fumbles from 2018 | decimal (32) | NULL | Yes | Total fumbles by the team in the game |
| FumblesLost from 2018 | decimal (32) | NULL | Yes | Total fumbles lost by the team in the game |
TeamGameTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Scope from 2020 | string (50) | NOT NULL | No | The type of Trend (e.g. Last 5 games, Last 10 games, Last 5 home games, etc.) |
| TeamID from 2020 | integer (32) | NOT NULL | No | The unique ID of the team |
| Team from 2020 | string (50) | NOT NULL | No | The abbreviation [Key] of the team |
| OpponentID from 2020 | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent from 2020 | string (50) | NULL | No | The abreviation [Key] of the opponent team |
| Wins from 2020 | integer (32) | NOT NULL | Yes | Total number of wins by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| Losses from 2020 | integer (32) | NOT NULL | Yes | The total number of losses by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| Ties from 2020 | integer (32) | NOT NULL | Yes | Total number of ties by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| WinsAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Total number of wins against the spread relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| LossesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Losses by the team against the spread relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| PushesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Total number of pushes against the spread relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| Overs from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes over the total points line |
| Unders from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes under the total points line |
| OverUnderPushes from 2020 | integer (32) | NULL | Yes | Amount of times the total score pushes the total points line |
| AverageScore from 2020 | decimal (32) | NULL | Yes | The average points scored by the team |
| AverageOpponentScore from 2020 | decimal (32) | NULL | Yes | The average points scored by the opposing team |
TeamSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stats associated with the team in this season |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NULL | No | The college football season of the game |
| Name | string (50) | NULL | No | The team's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (32) | NULL | No | Total number of wins by the team in the season |
| Losses | integer (32) | NULL | No | The total number of losses by the team in the season |
| PointsFor | integer (32) | NULL | No | Total points scored by the team in the season |
| PointsAgainst | integer (32) | NULL | No | Total points scored against the team in the season |
| ConferenceWins | integer (32) | NULL | No | The total number of conference wins by the team |
| ConferenceLosses | integer (32) | NULL | No | The total number of conference losses by the team |
| ConferencePointsFor | integer (32) | NULL | No | Total conference points scored by the team |
| ConferencePointsAgainst | integer (32) | NULL | No | Total conference points against the team |
| HomeWins | integer (32) | NULL | No | Total home wins by the team in the season |
| HomeLosses | integer (32) | NULL | No | Total home losses by the team in the season |
| RoadWins | integer (32) | NULL | No | Total road wins by the team in the season |
| RoadLosses | integer (32) | NULL | No | Total road losses by the team in the season |
| Streak | integer (32) | NULL | No | The current winning or losing streak of the team in the season. A positive number indicates a winning streak, and a negative number indicates a losing streak. |
| Score | integer (32) | NULL | No | Total points scored by the team in the season |
| OpponentScore | integer (32) | NULL | No | Total points scored by the opponent team |
| FirstDowns | integer (32) | NULL | Yes | Total first downs converted by the team in the season |
| ThirdDownConversions | integer (32) | NULL | Yes | Total third down conversions by the team in the season |
| ThirdDownAttempts | integer (32) | NULL | Yes | Total third down attempts by the team in the season |
| FourthDownConversions | integer (32) | NULL | Yes | Total fourth down conversions by the team in the season |
| FourthDownAttempts | integer (32) | NULL | Yes | Total fourth down attempts by the team in the season |
| Penalties | integer (32) | NULL | Yes | Total penalties committed by the team in the season |
| PenaltyYards | integer (32) | NULL | Yes | Total penalties yards enforced against the team in the season |
| TimeOfPossessionMinutes | integer (32) | NULL | Yes | Total number of minutes the team possessed the ball for in the season |
| TimeOfPossessionSeconds | integer (32) | NULL | Yes | Total number of seconds the team possessed the ball for in the season |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for the team. Note: This value is guaranteed to be unique across all sports/leagues. |
| ConferenceRank | integer (32) | NULL | No | This field is deprecated. |
| DivisionRank | integer (32) | NULL | No | This field is deprecated. |
| Updated | datetime | NULL | No | The timestamp of when this team was last updated (US Eastern Time) |
| Created | datetime | NULL | No | The date and time this stat record was created for the team in the season |
| Games | integer (32) | NULL | No | Total number of games the team recorded stats in during the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points scored by the team in the season |
| PassingAttempts | decimal (32) | NULL | Yes | Total passing attempts by the team in the season |
| PassingCompletions | decimal (32) | NULL | Yes | Total passing completions by the team in the season |
| PassingYards | decimal (32) | NULL | Yes | Total passing yards by the team in the season |
| PassingCompletionPercentage | decimal (32) | NULL | Yes | Total passing completion percentage by the team in the season |
| PassingYardsPerAttempt | decimal (32) | NULL | Yes | Total passing yards per attempt by the team in the season |
| PassingYardsPerCompletion | decimal (32) | NULL | Yes | Total passing yards per completion by the team in the season |
| PassingTouchdowns | decimal (32) | NULL | Yes | Total passing touchdowns by the team in the season |
| PassingInterceptions | decimal (32) | NULL | Yes | Total passing interceptions by the team in the season |
| PassingRating | decimal (32) | NULL | Yes | Total passing rating by the team in the season |
| RushingAttempts | decimal (32) | NULL | Yes | Total rushing attempts by the team in the season |
| RushingYards | decimal (32) | NULL | Yes | Total rushing yards by the team in the season |
| RushingYardsPerAttempt | decimal (32) | NULL | Yes | Total rushing yards per attempt by the team in the season |
| RushingTouchdowns | decimal (32) | NULL | Yes | Total rushing touchdowns by the team in the season |
| RushingLong | decimal (32) | NULL | Yes | Longest rushing attempt by the team in the season |
| Receptions | decimal (32) | NULL | Yes | Total receptions by the team in the season |
| ReceivingYards | decimal (32) | NULL | Yes | Total receiving yards by the team in the season |
| ReceivingYardsPerReception | decimal (32) | NULL | Yes | Total receiving yards per reception by the team in the season |
| ReceivingTouchdowns | decimal (32) | NULL | Yes | Total receiving touchdowns by the team in the season |
| ReceivingLong | decimal (32) | NULL | Yes | Longest reception by the team in the season |
| PuntReturns | decimal (32) | NULL | Yes | Total punt returns by the team in the season |
| PuntReturnYards | decimal (32) | NULL | Yes | Total punt return yards by the team in the season |
| PuntReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total punt return yards per attempt by the team in the season |
| PuntReturnTouchdowns | decimal (32) | NULL | Yes | Total punt return touchdowns by the team in the season |
| PuntReturnLong | decimal (32) | NULL | Yes | Longest punt return by the team in the season |
| KickReturns | decimal (32) | NULL | Yes | Total kick returns by the team in the season |
| KickReturnYards | decimal (32) | NULL | Yes | Total kick return yards by the team in the season |
| KickReturnYardsPerAttempt | decimal (32) | NULL | Yes | Total yards per kick return by the team in the season |
| KickReturnTouchdowns | decimal (32) | NULL | Yes | Total kick return touchdowns by the team in the season |
| KickReturnLong | decimal (32) | NULL | Yes | The longest kick return by the team in the season |
| Punts | decimal (32) | NULL | Yes | Total punts by the team in the season |
| PuntYards | decimal (32) | NULL | Yes | Total punt yards by the team in the season |
| PuntAverage | decimal (32) | NULL | Yes | Total average punt yards by the team in the season |
| PuntLong | decimal (32) | NULL | Yes | Longest punt by the team in the season |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the team in the season |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the team in the season |
| FieldGoalPercentage | decimal (32) | NULL | Yes | Total field goal percentage by the team in the season |
| FieldGoalsLongestMade | decimal (32) | NULL | Yes | The longest field goal made by the team in the season |
| ExtraPointsAttempted | decimal (32) | NULL | Yes | Total extra points attempted by the team in the season |
| ExtraPointsMade | decimal (32) | NULL | Yes | Total extra points made by the team in the season |
| Interceptions | decimal (32) | NULL | Yes | Total defensive interceptions by the team in the season |
| InterceptionReturnYards | decimal (32) | NULL | Yes | Total interception return yards for the team in the season |
| InterceptionReturnTouchdowns | decimal (32) | NULL | Yes | Total interception return touchdowns for the team in the season |
| SoloTackles from 2018 | decimal (32) | NULL | Yes | Total solo tackles by the team in the season |
| AssistedTackles from 2018 | decimal (32) | NULL | Yes | Total assisted tackles by the team in the season |
| TacklesForLoss from 2018 | decimal (32) | NULL | Yes | Total tackles for a loss by the team in the season |
| Sacks from 2018 | decimal (32) | NULL | Yes | Total sacks by the team in the season |
| PassesDefended from 2018 | decimal (32) | NULL | Yes | Total passes defended by the team in the season |
| FumblesRecovered from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles recoveries by the team in the season |
| FumbleReturnTouchdowns from 2018 | decimal (32) | NULL | Yes | Total defensive fumbles returned for a touchdown by the team in the season |
| QuarterbackHurries from 2018 | decimal (32) | NULL | Yes | This field is deprecated. |
| Fumbles from 2018 | decimal (32) | NULL | Yes | Total fumbles by the team in the season |
| FumblesLost from 2018 | decimal (32) | NULL | Yes | Total fumbles lost by the team in the season |
TeamTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Team from 2020 | string (50) | NULL | No | The abbreviation [Key] of the team |
| TeamID from 2020 | integer (32) | NULL | No | The unique ID of the team |
| UpcomingGame from 2020 | Game | NULL | No | The most recent future game for the team |
| TeamGameTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of Game Trends for this team |