College Basketball 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 | A text value for the record (e.g. Moneyline, Player Prop, 3rd Quarter) |
| Active | bool (32) | NULL | No | Denotes the name of the type (e.g. Betting Market Type, Betting Event Type, Betting Period Type) |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingBetTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | The list of the bet types that can be found within a market |
| BettingMarketTypes from 2021 | BettingEntityMetadata[] (32) | 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[] (32) | NULL | No | A list of the possible BettingPeriodTypes (e.g. Full Game, Regulation Time, 1st Half) |
| BettingEventTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingEventTypes (e.g. Game; Future) |
| BettingOutcomeTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingOutcomeTypes (e.g. Home; Away; Under; Over) |
| BettingResultTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingResultTypes (e.g. Win; Loss; Push; Not Resulted; Incomplete) |
| ResultedMarketMetaData from 2021 | BettingResultingMetadata[] | NULL | No | A list of the combinations of BettingMarketTypeID, BettingBetTypeID, and BettingPeriodTypeID that will be resulted |
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 associated 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 season that this betting event occurs in. Note: season is a single year that the majority of the season occurs in |
| BettingEventTypeID from 2020 | int (32) | NOT NULL | No | The ID associated with the type of betting event |
| BettingEventType from 2020 | string (32) | NOT NULL | No | Indicates the type of betting event (Game or Future) |
| StartDate from 2020 | datetime | NULL | No | The date and time a specified event is scheduled to begin. Note: For Futures, this will be the furthest forward time a book has a market set to close |
| Created from 2020 | datetime | NULL | No | The date and time when this betting event was created (in US Eastern Time) |
| Updated from 2020 | datetime | NULL | No | The timestamp of the last time this betting event was updated (in 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. This value is guaranteed to be unique across all sports/leagues |
| GameStatus from 2020 | string (32) | NULL | Yes | The status of the game in tied to this event. A list of CBB game statuses can be found here |
| AwayTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the away team tied to the event |
| HomeTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the home team tied to this event |
| AwayTeamID from 2020 | int (32) | NULL | No | The unique ID of the away team tied to the event |
| HomeTeamID from 2020 | int (32) | NULL | No | The unique ID of the home team tied to this event |
| GlobalAwayTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the away team tied to this event 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 tied to this event. This value is guaranteed to be unique across all sports/leagues |
| AwayTeamScore from 2020 | int (32) | NULL | Yes | Total number of points the away team scored in the game tied to the event (post-game) |
| HomeTeamScore from 2020 | int (32) | NULL | Yes | Total number of points the home team scored in this game (post-game) |
| TotalScore from 2020 | int (32) | NULL | Yes | The total amount of points scored in the game by both teams, posted after the conclusion of the game |
| AwayRotationNumber from 2020 | int (32) | NULL | No | Rotation number of away team in the game tied to this event. |
| HomeRotationNumber from 2020 | int (32) | NULL | No | Rotation number of home team for this game for 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 that the game started. Note: Time is in US Eastern Time |
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 identifier of this betting market |
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingMarketTypeID from 2020 | int (32) | NULL | Yes | The unique ID associated with this type of betting market |
| BettingMarketType from 2020 | string (32) | NULL | Yes | The name of the market type (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2020 | int (32) | NULL | Yes | The unique ID associated with the betting event |
| BettingBetType from 2020 | string (32) | NULL | Yes | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID from 2020 | int (32) | NULL | Yes | The BettingPeriodTypeID of this market |
| BettingPeriodType from 2020 | string (32) | NULL | Yes | The BettingPeriodType of this market (e.g. Full Game; 1st Half; 2nd Quarter; Regular Season) |
| Name from 2020 | string (32) | NULL | No | The generic name of this market |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team (if applicable) |
| TeamKey from 2020 | string (32) | NULL | Yes | The abbreviation [Key] of the team tied to this market (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO (if applicable). Note: this ID will stay with the player throughout their collegiate career |
| PlayerName from 2020 | string (32) | NULL | Yes | The full name of the player associated with this market (if applicable) |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting market was created (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this betting market was updated (in US Eastern Time) |
| AvailableSportsbooks from 2020 | Sportsbook[] (32) | NULL | No | A list of sportsbooks that have odds available in a given market |
| AnyBetsAvailable from 2020 | bool (32) | NULL | No | A field that returns "Yes" if there are any available bets to make within the market in question. If there are no bets available to make, the field returns "No" |
| 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 consensus outcomes of this market |
| IsArchived | bool | NOT NULL | No | Indicates whether a BettingOutcome has been archived or not. If Archived, that outcome is no longer available |
| ArchiveLocation | string | NOT NULL | No | Indicates the URL that can be used to retrieve archived BettingOutcomes. An API Key and Sportsbook Grouping will be required to retrieve this information |
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 name of the 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 market |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st Half; 2nd Quarter; 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 (if applicable) |
| TeamKey from 2021 | string (10) | NULL | No | The abbreviation [Key] of the team tied to this market (if applicable) |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO (if applicable). Note: this ID will stay with the player throughout their collegiate career |
| PlayerName from 2021 | string (100) | NULL | No | The full name of the player associated with 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 from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingEventID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting event |
| 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 name of the 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 market |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st Half; 2nd Quarter; Regular Season) |
| TeamID from 2021 | integer (32) | NULL | No | The unique ID of the team (if applicable) |
| TeamKey from 2021 | string (32) | NULL | No | The abbreviation [Key] of the team tied to this market (if applicable) |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO (if applicable). Note: this ID will stay with the player throughout their collegiate career |
| PlayerName from 2021 | string (100) | NULL | No | The full name of the player associated with this market |
| BettingSplits from 2021 | 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 name of the sportsbook that is offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of betting outcome type (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The payout of the bet, shown in American odds format |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The payout of the bet, shown in Decimal odds format |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the spread, game total, etc.) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically a team or player) associated with a given 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 | Indicates whether a BettingOutcome is available for betting or not |
| IsAlternate from 2020 | bool (32) | NULL | No | Is this an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting outcome was created (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this betting outcome was updated (in US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when these odds were first made unavailable to be bet on any further |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO (if applicable). Note: this ID will stay with the player throughout their collegiate career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues (where applicable) |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID from the given sportsbook when available |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID from the given sportsbook when available |
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 BettingResultType of this outcome |
| BettingResultType from 2021 | string (100) | NULL | Yes | The BettingResultTypeID of this outcome |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | No | The name of betting outcome type (e.g. Home; Away; Under; Over) |
| BetValue from 2021 | decimal (32) | NULL | Yes | The value of the given result from a sportsbook for a game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
| ActualValue from 2021 | decimal (32) | NULL | Yes | The value of the actual result that occured in game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
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 that can be resulted |
| 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 from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting split |
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingOutcomeTypeID from 2021 | integer (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2021 | string (32) | NULL | No | The name of betting outcome type (e.g. Home; Away; Under; Over) |
| BetPercentage from 2021 | integer (32) | NULL | Yes | Percentage of bets placed on a specific outcome |
| MoneyPercentage from 2021 | integer (32) | NULL | Yes | Percentage of money bet on this outcome |
| Created from 2021 | datetime (32) | NOT NULL | No | The date and time when this betting split was created (in US Eastern Time) |
| LastSeen from 2021 | datetime (32) | NOT NULL | No | Timestamp of when a specific betting split was last updated (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 | Returns the game details for a given game's box score |
| Periods | Period[] | NULL | No | The details of the periods (halves & overtime) for this game. Note: the scores are for that half/period only, not total score of game at that point. |
| PlayerGames | PlayerGame[] | NULL | No | The player game stats of this box score |
| TeamGames | TeamGame[] | NULL | No | The team game stats of this box score |
Conference
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| ConferenceID | integer (32) | NOT NULL | No | The ID of the team's conference |
| Name | string (50) | NOT NULL | No | The name of the team's conference (e.g. American Athletic, Big Ten, Conference USA) |
| Teams | Team[] | NULL | No | The college teams within this conference |
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 name of the sportsbook that is offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of betting outcome type (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The payout of the bet, shown in American odds format |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The payout of the bet, shown in Decimal odds format |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the spread, game total, etc. |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically a team or player) associated with a given 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 | Indicates whether a ConsensusOutcome is available for betting or not |
| IsAlternate from 2020 | bool (32) | NULL | No | Is this an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting consensus outcome was created (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this consensus outcome was updated (in US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when these odds were first made unavailable to be bet on any further |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO (if applicable). Note: this ID will stay with the player throughout their collegiate career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues (where applicable) |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID from the given sportsbook when available |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID from the given sportsbook when available |
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 season that the game occurs in. Note: season is a single year that the majority of the season occurs in |
| 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). |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/OT, Suspended, Postponed, Delayed, Canceled, Forfeit |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| AwayTeam | string (12) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (12) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in the 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 (in US Eastern Time) |
| Period | string (10) | NULL | No | The current period of the game (Possible Values: 1; 2; Half; OT; NULL) |
| TimeRemainingMinutes | integer (32) | NULL | No | Number of minutes remaining in the half (from 0 to 20). Note: if game is scheduled or final this field is NULL |
| TimeRemainingSeconds | integer (32) | NULL | No | Number of seconds remaining in the half (from 0 to 59). Note: if game is scheduled or final this field is NULL |
| PointSpread from 2016 | decimal (32) | NULL | Yes | The consensus Point Spread at game start from the perspective of the HomeTeam (in the Game table, the PointSpread field's negative numbers indicate the HomeTeam is favored; positive numbers indicate the AwayTeam is favored. Note that this rule does not hold in betting-related tables, where the spread is contingent on the bet line.) |
| OverUnder from 2016 | decimal (32) | NULL | Yes | The total points line (over/under) as given by the sportsbook |
| AwayTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Money line from the perspective of the away team |
| HomeTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Money line from the perspective of the home team |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| TournamentID from 2016 | integer (32) | NULL | No | The unique ID of the tournament. Note: this field is specific to the NCAA tournament & does not include other tournaments |
| Bracket from 2016 | string (50) | NULL | No | The specific bracket of the tournament (e.g. East; West; Midwest; South). Note: this is specific to the NCAA tournament |
| Round from 2016 | integer (32) | NULL | Yes | The current round of the NCAA tournament. Rounds: 1 = Round of 64, 2 = Round of 32, 3 = Sweet Sixteen, 4 = Elite Eight, 5 = Final Four, 6 = Championship Note: First Four games Round = NULL |
| AwayTeamSeed from 2016 | integer (32) | NULL | Yes | The seed of the away team (1-16). Note: this is specific to the NCAA tournament & does not include other tournaments |
| HomeTeamSeed from 2016 | integer (32) | NULL | Yes | The seed of the home team (1-16). Note: this is specific to the NCAA tournament & does not include other tournaments |
| AwayTeamPreviousGameID from 2016 | integer (32) | NULL | Yes | The Id of one of the NCAA tournament games which feeds this game. This gameid will be inaccurate/invalid in free trial as it is scrambled. Null for some Round 1 and all play-in games. Used for rendering. Does not change after tournament records have been created. |
| HomeTeamPreviousGameID from 2016 | integer (32) | NULL | Yes | The Id of one of the NCAA tournament games which feeds this game. This gameid will be inaccurate/invalid in free trial as it is scrambled. Null for some Round 1 and all play-in games. Used for rendering. Does not change after tournament records have been created. |
| AwayTeamPreviousGlobalGameID from 2016 | integer (32) | NULL | Yes | The unique global ID of the away team's previous game (This gameid will be inaccurate/invalid in free trial as it is scrambled) |
| HomeTeamPreviousGlobalGameID from 2016 | integer (32) | NULL | Yes | The unique global ID of the away team's previous game (This gameid will be inaccurate/invalid in free trial as it is scrambled) |
| TournamentDisplayOrder from 2016 | integer (32) | NULL | Yes | The display order of this game. This is used for rendering NCAA Tournament bracket. |
| TournamentDisplayOrderForHomeTeam from 2016 | string (10) | NULL | Yes | The display order of the home team for this game. This is used for rendering the NCAA Tournament bracket, and it indicates whether the home team should be displayed at the top or bottom of the game card. Possible values: Top, Bottom |
| Periods from 2016 | Period[] | NULL | No | The details of the periods (halves & overtime) for this game. Note: the scores are for that half/period only, not total score of game at that point |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| Stadium from 2016 | Stadium | NULL | No | The stadium details of where this game was played |
| 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. |
| TopTeamPreviousGameId from 2019 | integer (32) | NULL | Yes | Previous game id of the team in the top slot of an NCAA tournament game. Used for rendering. |
| BottomTeamPreviousGameId from 2019 | integer (32) | NULL | Yes | Previous game id of the team in the bottom slot of an NCAA tournament game. Used for rendering. |
| 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. Note: Neutral = True, Not Neutral = False |
| AwayPointSpreadPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team. Note: this line is a consensus |
| HomePointSpreadPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| OverPayout from 2021 | integer (32) | NULL | Yes | The odds at which the sportsbook will pay out winning over bets at |
| UnderPayout from 2021 | integer (32) | NULL | Yes | The payout when betting the Under of the Over/Under |
| DateTimeUTC from 2021 | datetime | NULL | No | The date and time of the game in UTC |
| Attendance | integer (32) | NULL | No | The attendance of the game when available |
| 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 from 2021 | integer (32) | NOT NULL | No | The unique ID of this game associate with relevant game |
| SeasonType from 2021 | 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 from 2021 | integer (32) | NOT NULL | No | The season that this betting event occurs in. Note: season is a single year that the majority of the season occurs in. |
| Day from 2021 | datetime (32) | NULL | No | The day that the game is scheduled to be played in |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the home team tied to this betting split |
| BettingMarketSplits from 2021 | 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 season that the game occurs in. Note: season is a single year that the majority of the season occurs in. |
| 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). |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| Status | string (20) | NULL | No | Indicates the game's status. 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 full name of the away team (school & mascot) (E.g. Tulane Green Wave, Memphis Tigers, Arizona State Sun Devils) |
| HomeTeamName | string (50) | NULL | No | The full name of the home team (school & mascot) (E.g. Tulane Green Wave, Memphis Tigers, Arizona State Sun Devils) |
| GlobalGameId | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamId | integer (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamId | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PregameOdds | GameOdd[] | NULL | No | List of Pregame GameOdds from different sportsbooks |
| LiveOdds | GameOdd[] | NULL | No | Shows a list of live odds from different sportsbooks |
| HomeTeamScore | integer | NULL | Yes | Total number of points the home team scored in this game (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer | NULL | Yes | Total number of points the away team scored in the game (updated after game ends to allow for resolving bets) |
| TotalScore | integer | NULL | Yes | The total amount of points scored in the game by both teams. Updated after the game ends to allow for resulting 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 | A list of Alternate Market Pregame GameOdds 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 season that the game occurs in. Note: season is a single year that the majority of the season occurs in |
| 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) |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| Status | string (25) | NULL | No | Indicates the game's status. 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 full name of the away team (school & mascot). Ex: Tulane Green Wave, Memphis Tigers, Arizona State Sun Devils) |
| HomeTeamName | string (50) | NULL | No | The full name of the home team (school & mascot). Ex: Tulane Green Wave, Memphis Tigers, Arizona State Sun Devils) |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues |
| GlobalAwayTeamID | integer (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues |
| PregameOdds | GameOddResult[] | NULL | No | List of Pregame GameOdds from different sportsbooks with results |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of points the home team scored in this game (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in the game (updated after game ends to allow for resolving bets) |
| TotalScore | integer (32) | NULL | Yes | The total amount of points scored in the game by both teams. Updated after the game ends to allow for resulting bets |
| HomeRotationNumber | integer (32) | NULL | Yes | I 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 | A list of Alternate Market Pregame GameOdds from different sportsbooks with results of the bets |
| Period | string (10) | NULL | No | The current period of the game (Possible Values: 1; 2; Half; OT; NULL) |
| TimeRemainingMinutes | integer (32) | NULL | No | Number of minutes remaining in the half (from 0 to 20). Note: if game is scheduled or final this field is NULL |
| TimeRemainingSeconds | integer (32) | NULL | No | Number of seconds remaining in the half (from 0 to 59). Note: if game is scheduled or final this field is NULL |
| Periods | Period[] | NULL | No | The details of the periods (halves & overtime) for this game. Note: the scores are for that half/period only, not total score of game at that point |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| LiveOdds | GameOddResult[] | NULL | No | Shows a 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. 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 money line for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for the away team |
| 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. Note: this line is a consensus. |
| OverUnder | decimal (32) | NULL | Yes | The total points line (over/under) as given by the sportsbook |
| OverPayout | integer (32) | NULL | Yes | The odds at which the sportsbook will pay out winning Over bets at |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookId | integer (32) | NULL | No | The unique ID associated with this sportsbook |
| OddType | string (50) | NULL | No | The market type of the odd (ex: live; pregame; 1st-half; etc.) |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| Unlisted | datetime | NULL | No | The timestamp of when these odds were first made unavailable to be bet on any further |
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 an outcome in the form of an integer |
| GameOddResultType | string (100) | NULL | No | The result/outcome of a bet (e.g. Won; Lost; Push; Not Resulted; Incomplete) |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 1st-half; etc.) |
| GameOddType | string (100) | NULL | No | The GameOddResultType of an outcome in the form of a string |
| BetValue | decimal (32) | NULL | No | The value that was bet in this outcome (if applicable) |
| ActualValue | decimal (32) | NULL | No | The value of the given result from a sportsbook for a game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
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. 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 |
| 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. Note: this line is a consensus. |
| OverUnder | decimal (32) | NULL | Yes | The total points line (over/under) as given by the sportsbook |
| OverPayout | integer (32) | NULL | Yes | The odds at which the sportsbook will pay out winning Over bets at |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookID | integer (32) | NULL | No | The unique ID associated with this sportsbook |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (50) | NULL | No | The market type of the odd (ex: live; pregame; 1st-half; etc.) |
| GameOddOutcomeResults | GameOddOutcome[] | NULL | No | List of outcomes showing results of betting markets that were bet on for the given game |
InjuredPlayer
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID from 2021 | int (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO (if applicable). Note: this ID will stay with the player throughout their collegiate career. |
| Name from 2021 | string (32) | NOT NULL | No | Injured player's full name (first and last) |
| TeamID from 2021 | int (32) | NOT NULL | No | The unique ID of the player's team |
| Team from 2021 | string (32) | NOT NULL | No | The abbreviation [Key] of the player's team |
| Position from 2021 | string (32) | NULL | No | The player's eligible position(s). Possible values: C; F; F-C; G; G-F, PG, SG, SF, PF. |
| InjuryStatus from 2021 | string (32) | NULL | Yes | Injury status used to project availability. Statuses: Probable; Questionable; Doubtful; Out. |
| InjuryBodyPart from 2021 | string (32) | NULL | Yes | The player's body part(s) that are injured (e.g. Knee; Groin; Calf; Hamstring; etc.). Note: if a player has multiple injured body parts they will appear as such - Hamstring/Ankle. |
| InjuryNotes from 2021 | string (32) | NULL | Yes | Short description of injury involving injured body part(s), game status, player name, team name, and other extra news necessary. Notes are custom and can be unique. |
| InjuryStartDate from 2021 | datetime (32) | NULL | Yes | The date that the injury occurred, was first discovered, or was freshly updated |
MatchupTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| UpcomingGame from 2020 | Game | NULL | No | Next scheduled game for the team with a specified opposing team |
| 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 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 | The unique ID for the 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 in the game (e.g. 1, 2, OT, OT2, etc.) |
| Type | string (10) | NOT NULL | No | Indicates whether this period is the first/second half or overtime (possible values: Half, Overtime) |
| AwayScore | integer (32) | NULL | Yes | The total points scored by the away team in this period only |
| HomeScore | integer (32) | NULL | Yes | The total points scored by the home team in this period only |
Player
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their 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 player's team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Jersey | integer (32) | NULL | No | The player's jersey number (0-99) |
| Position | string (10) | NULL | No | The player's eligible position(s). Possible values: C; F; F-C; G; G-F, PG, SG, SF, PF |
| Class | string (50) | NULL | No | The class of the year (e.g. Freshman; Sophomore; Junior; Senior; Graduate Student). Note: Redshirt classes available for Freshman, Sophomore, Junior, Senior |
| 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 (two letter abbreviation) |
| HighSchool | string (50) | NULL | No | The high school that the player attended |
| SportRadarPlayerID | string (50) | NULL | No | The player's cross reference PlayerID to the SportRadar API |
| RotoworldPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the Rotoworld news feed |
| RotoWirePlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the RotoWire news feed |
| FantasyAlarmPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the FantasyAlarm news feed |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| InjuryStatus from 2021 | string (32) | NULL | Yes | Injury status used to project availability. Statuses: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2021 | string (32) | NULL | Yes | The player's body part(s) that are injured (e.g. Knee; Groin; Calf; Hamstring; etc.). Note: if a player has multiple injured body parts they will appear like such: Hamstring/Ankle |
| InjuryNotes from 2021 | string (32) | NULL | Yes | Short description of injury involving injured body part(s), game status, player name, team name, and other extra news necessary. Notes are custom and can be unique |
| InjuryStartDate from 2021 | datetime (32) | NULL | Yes | The date that the injury occurred, was first discovered, or was freshly updated |
PlayerBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their 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 player's team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Jersey | integer (32) | NULL | No | The player's jersey number (0-99) |
| Position | string (10) | NULL | No | The player's eligible position(s). Possible values: C; F; F-C; G; G-F, PG, SG, SF, PF |
| Class | string (50) | NULL | No | The class of the year (e.g. Freshman; Sophomore; Junior; Senior; Graduate Student). Note: Redshirt classes available for Freshman, Sophomore, Junior, Senior |
| 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 (two letter abbreviation) |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. 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 stat |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their 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 season that the game the player is playing in occurs. Note: season is a single year that the majority of the season occurs in |
| Name | string (50) | NULL | No | Player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's eligible position(s). Possible values: C; F; F-C; G; G-F, PG, SG, SF, PF |
| FanDuelSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests. |
| DraftKingsSalary from 2016 | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests. |
| FantasyDataSalary from 2016 | integer (32) | NULL | Yes | The player's salary as calculated by SportsDataIO (formerly known as FantasyData). Based on the same salary cap as DraftKings contests ($50,000). |
| YahooSalary from 2016 | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests |
| InjuryStatus from 2016 | string (50) | NULL | No | Injury status used to project availability. Statuses: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2016 | string (50) | NULL | No | The player's body part(s) that are injured (e.g. Knee; Groin; Calf; Hamstring; etc.). Note: if a player has multiple injured body parts they will appear like such: Hamstring/Ankle |
| InjuryStartDate from 2016 | date | NULL | No | The date that the injury occurred, was first discovered, or was freshly updated |
| InjuryNotes from 2016 | string (250) | NULL | No | Short description of injury involving injured body part(s), game status, player name, team name, and other extra news necessary. Notes are custom and can be unique |
| FanDuelPosition from 2016 | string (10) | NULL | No | The player's eligible position(s) in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition from 2016 | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform. |
| YahooPosition from 2016 | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform |
| OpponentRank from 2016 | integer (32) | NULL | No | The ranking of the player's opponent with regards to fantasy points allowed. |
| OpponentPositionRank from 2016 | integer (32) | NULL | No | The ranking of the player's opponent by position with regards to fantasy points allowed. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| GameID | integer (32) | NULL | No | The unique ID of this game |
| OpponentID | integer (32) | NULL | No | The unique ID of the opponent team |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| 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 or not the player's game is over (returns true/false) |
| 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 team's opponent. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The timestamp of when this record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player. Note: if player played in game this field will = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the game |
| Minutes | integer (32) | NULL | Yes | Total number of minutes played by the player in the game |
| FieldGoalsMade | integer (32) | NULL | Yes | Total number of field goals made by the player in the game |
| FieldGoalsAttempted | integer (32) | NULL | Yes | Total number of field goals attempted by the player in the game |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goals percentage by the player in the game |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | The player's effective field goal percentage (eFG%) for the game |
| TwoPointersMade | integer (32) | NULL | Yes | Total two-pointers made by the player in the game |
| TwoPointersAttempted | integer (32) | NULL | Yes | Total two-pointers attempted by the player in the game |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two-pointer percentage by the player in the game |
| ThreePointersMade | integer (32) | NULL | Yes | Total three-pointers made by the player in the game |
| ThreePointersAttempted | integer (32) | NULL | Yes | Total three-pointers attempted by the player in the game |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three-point percentage by the player in the game |
| FreeThrowsMade | integer (32) | NULL | Yes | Total number of free throws made by the player in the game |
| FreeThrowsAttempted | integer (32) | NULL | Yes | Total number of free throws attempted by the player in the game |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the player in the game |
| OffensiveRebounds | integer (32) | NULL | Yes | Total offensive rebounds by the player in the game |
| DefensiveRebounds | integer (32) | NULL | Yes | Total defensive rebounds by player in the game |
| Rebounds | integer (32) | NULL | Yes | Total rebounds by the player in the game |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | The player's offensive rebound percentage (ORB%) for the game |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | The player's defensive rebounds percentage (DRB%) for the game |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the player in the game |
| Assists | integer (32) | NULL | Yes | Total assists by player in the game. |
| Steals | integer (32) | NULL | Yes | Total steals by the player in the game |
| BlockedShots | integer (32) | NULL | Yes | Total blocked shots by the player in the game |
| Turnovers | integer (32) | NULL | Yes | Total turnovers by player in the game |
| PersonalFouls | integer (32) | NULL | Yes | Total personal fouls by the player in the game |
| Points | integer (32) | NULL | Yes | Total points scored by player in the game |
| TrueShootingAttempts | decimal (32) | NULL | Yes | The player's true shooting attempts (TSA) for the game |
| TrueShootingPercentage | decimal (32) | NULL | Yes | The player's true shooting percentage (TS%) for the game |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The player's linear weight efficiency (PER) rating for the game |
| AssistsPercentage | decimal (32) | NULL | Yes | The player's assist percentage (AST%) for the game |
| StealsPercentage | decimal (32) | NULL | Yes | The player's steal percentage (STL%) for the game |
| BlocksPercentage | decimal (32) | NULL | Yes | The player's block percentage (BLK%) for the game |
| TurnOversPercentage | decimal (32) | NULL | Yes | The player's turnover percentage (TOV%) for the game |
| UsageRatePercentage | decimal (32) | NULL | Yes | The player's usage rate percentage (Usg%) for the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points scored by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points scored by the player in the game |
PlayerGameProjection
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their 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 season that the game the player is playing in occurs. Note: season is a single year that the majority of the season occurs in |
| Name | string (50) | NULL | No | Player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's eligible position(s). Possible values: C; F; F-C; G; G-F, PG, SG, SF, PF |
| FanDuelSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests. |
| DraftKingsSalary from 2016 | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests. |
| FantasyDataSalary from 2016 | integer (32) | NULL | Yes | The player's salary as calculated by SportsDataIO (formerly known as FantasyData). Based on the same salary cap as DraftKings contests ($50,000). |
| YahooSalary from 2016 | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests |
| InjuryStatus from 2016 | string (50) | NULL | No | Injury status used to project availability. Statuses: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2016 | string (50) | NULL | No | The player's body part(s) that are injured (e.g. Knee; Groin; Calf; Hamstring; etc.). Note: if a player has multiple injured body parts they will appear like such: Hamstring/Ankle |
| InjuryStartDate from 2016 | date | NULL | No | The date that the injury occurred, was first discovered, or was freshly updated |
| InjuryNotes from 2016 | string (250) | NULL | No | Short description of injury involving injured body part(s), game status, player name, team name, and other extra news necessary. Notes are custom and can be unique |
| FanDuelPosition from 2016 | string (10) | NULL | No | The player's eligible position(s) in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition from 2016 | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform. |
| YahooPosition from 2016 | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform |
| OpponentRank from 2016 | integer (32) | NULL | No | The ranking of the player's opponent with regards to fantasy points allowed. |
| OpponentPositionRank from 2016 | integer (32) | NULL | No | The ranking of the player's opponent by position with regards to fantasy points allowed. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| 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 name of the opponent |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| 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. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this team's opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time). |
| Games | integer (32) | NULL | No | The number of games played. |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points |
| Minutes | integer (32) | NULL | Yes | Total number of minutes played |
| FieldGoalsMade | integer (32) | NULL | Yes | Total number of field goals made |
| FieldGoalsAttempted | integer (32) | NULL | Yes | Total number of field goals attempted |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage |
| TwoPointersMade | integer (32) | NULL | Yes | Total two pointers made |
| TwoPointersAttempted | integer (32) | NULL | Yes | Total two pointers attempted |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two pointers percentage |
| ThreePointersMade | integer (32) | NULL | Yes | Total three pointers made |
| ThreePointersAttempted | integer (32) | NULL | Yes | Total three pointers attempted |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three pointers percentage |
| FreeThrowsMade | integer (32) | NULL | Yes | Total free throws made |
| FreeThrowsAttempted | integer (32) | NULL | Yes | Total free throws attempted |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throws percentage |
| OffensiveRebounds | integer (32) | NULL | Yes | Total offensive rebounds |
| DefensiveRebounds | integer (32) | NULL | Yes | Total defensive rebounds |
| Rebounds | integer (32) | NULL | Yes | Total rebounds |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | Total offensive rebounds percentage |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | Total defensive rebounds percentage |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | The player/team total rebounds percentage |
| Assists | integer (32) | NULL | Yes | Total assists |
| Steals | integer (32) | NULL | Yes | Total steals |
| BlockedShots | integer (32) | NULL | Yes | Total blocked shots |
| Turnovers | integer (32) | NULL | Yes | Total turnovers |
| PersonalFouls | integer (32) | NULL | Yes | Total personal fouls |
| Points | integer (32) | NULL | Yes | Total points |
| TrueShootingAttempts | decimal (32) | NULL | Yes | The player's true shooting attempts as defined here: http://www.basketball-reference.com/about/glossary.html |
| TrueShootingPercentage | decimal (32) | NULL | Yes | The player's true shooting percentage as defined here: http://www.basketball-reference.com/about/glossary.html |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The player's linear weight efficiency rating as defined here: http://bleacherreport.com/articles/113144-cracking-the-code-how-to-calculate-hollingers-per-without-all-the-mess |
| AssistsPercentage | decimal (32) | NULL | Yes | The player's assist percentage as defined here: http://www.basketball-reference.com/about/glossary.html |
| StealsPercentage | decimal (32) | NULL | Yes | The player's steal percentage as defined here: http://www.basketball-reference.com/about/glossary.html |
| BlocksPercentage | decimal (32) | NULL | Yes | The player's block percentage as defined here: http://www.basketball-reference.com/about/glossary.html |
| TurnOversPercentage | decimal (32) | NULL | Yes | The player's turnover percentage as defined here: http://www.basketball-reference.com/about/glossary.html |
| UsageRatePercentage | decimal (32) | NULL | Yes | The player's usage rate percentage as defined here: http://www.basketball-reference.com/about/glossary.html |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total Fan Duel daily fantasy points scored |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total Draft Kings daily fantasy points scored |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points scored |
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 stat |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their 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 season that the game the player is playing in occurs. Note: season is a single year that the majority of the season occurs in |
| Name | string (50) | NULL | No | Player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's eligible position(s). Possible values: C; F; F-C; G; G-F, PG, SG, SF, PF |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The timestamp of when this record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the season |
| Minutes | integer (32) | NULL | Yes | Total number of minutes played by the player in the season |
| FieldGoalsMade | integer (32) | NULL | Yes | Total number of field goals made by the player in the season |
| FieldGoalsAttempted | integer (32) | NULL | Yes | Total number of field goals attempted by the player in the season |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goals percentage by the player in the season |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | The player's effective field goal percentage (eFG%) for the season |
| TwoPointersMade | integer (32) | NULL | Yes | Total two-pointers made by the player in the season |
| TwoPointersAttempted | integer (32) | NULL | Yes | Total two-pointers attempted by the player in the season |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two-pointer percentage by the player in the season |
| ThreePointersMade | integer (32) | NULL | Yes | Total three-pointers made by the player in the season |
| ThreePointersAttempted | integer (32) | NULL | Yes | Total three-pointers attempted by the player in the season |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three-point percentage by the player in the season |
| FreeThrowsMade | integer (32) | NULL | Yes | Total number of free throws made by the player in the season |
| FreeThrowsAttempted | integer (32) | NULL | Yes | Total number of free throws attempted by the player in the season |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the player in the season |
| OffensiveRebounds | integer (32) | NULL | Yes | Total offensive rebounds by the player in the season |
| DefensiveRebounds | integer (32) | NULL | Yes | Total defensive rebounds by player in the season |
| Rebounds | integer (32) | NULL | Yes | Total rebounds by the player in the season |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | The player's offensive rebound percentage (ORB%) for the season |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | The player's defensive rebounds percentage (DRB%) for the season |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the player in the season |
| Assists | integer (32) | NULL | Yes | Total assists by player in the season |
| Steals | integer (32) | NULL | Yes | Total steals by the player in the season |
| BlockedShots | integer (32) | NULL | Yes | Total blocked shots by the player in the season |
| Turnovers | integer (32) | NULL | Yes | Total turnovers by player in the season |
| PersonalFouls | integer (32) | NULL | Yes | Total personal fouls by the player in the season |
| Points | integer (32) | NULL | Yes | Total points scored by player in the season |
| TrueShootingAttempts | decimal (32) | NULL | Yes | The player's true shooting attempts (TSA) for the season |
| TrueShootingPercentage | decimal (32) | NULL | Yes | The player's true shooting percentage (TS%) for the season |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The player's linear weight efficiency (PER) rating for the season |
| AssistsPercentage | decimal (32) | NULL | Yes | The player's assist percentage (AST%) for the season |
| StealsPercentage | decimal (32) | NULL | Yes | The player's steal percentage (STL%) for the season |
| BlocksPercentage | decimal (32) | NULL | Yes | The player's block percentage (BLK%) for the season |
| TurnOversPercentage | decimal (32) | NULL | Yes | The player's turnover percentage (TOV%) for the season |
| UsageRatePercentage | decimal (32) | NULL | Yes | The player's usage rate percentage (Usg%) for the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points scored by the player in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points scored 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 season that the game occurs in. Note: season is a single year that the majority of the season occurs in |
| 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) |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/OT, Suspended, Postponed, Delayed, Canceled, Forfeit |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| AwayTeam | string (10) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in the 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 (in US Eastern Time) |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| TournamentID | integer (32) | NULL | No | The unique ID of the tournament Note: this field is specific to the NCAA tournament & does not include other tournaments |
| Bracket | string (50) | NULL | No | The specific bracket of the tournament (e.g. East; West; Midwest; South) |
| Round | integer (32) | NULL | Yes | The current round of the NCAA tournament. Rounds: 1 = Round of 64, 2 = Round of 32, 3 = Sweet Sixteen, 4 = Elite Eight, 5 = Final Four, 6 = Championship Note: First Four games Round = NULL |
| AwayTeamSeed | integer (32) | NULL | Yes | The seed of the away team (1-16). Note: specific to the NCAA tournament & does not include other tournaments |
| HomeTeamSeed | integer (32) | NULL | Yes | The seed of the home team (1-16). this is specific to the NCAA tournament & does not include other tournaments |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue. Note: Neutral = True, Not Neutral = False |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. 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. This value is guaranteed to be unique across all sports/leagues. |
| 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 season that the game occurs in. Note: season is a single year that the majority of the season occurs in |
| 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). |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| AwayTeam | string (10) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| Updated | datetime | NULL | No | The timestamp of when this game was last updated (in US Eastern Time) |
| TournamentID | integer (32) | NULL | No | "The unique ID of the tournament Note: this is specific to the NCAA tournament & does not include other tournaments" |
| Bracket | string (50) | NULL | No | The specific bracket of the tournament (e.g. East; West; Midwest; South) |
| Round | integer (32) | NULL | Yes | "The current round of the NCAA tournament. Rounds: 1 = Round of 64, 2 = Round of 32, 3 = Sweet Sixteen, 4 = Elite Eight, 5 = Final Four, 6 = Championship. Note: First Four games Round = NULL" |
| AwayTeamSeed | integer (32) | NULL | Yes | The seed of the away team (1-16). Note: this is specific to the NCAA tournament & does not include other tournaments |
| HomeTeamSeed | integer (32) | NULL | Yes | The seed of the home team (1-16). This is specific to the NCAA tournament & does not include other tournaments |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue. Note: Neutral = True, Not Neutral = False |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in the game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of points the home team scored in this game |
Season
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The season that the game occurs in. Note: season is a single year that the majority of the season occurs in |
| StartYear | integer (32) | NOT NULL | No | The year in which the season started |
| EndYear | integer (32) | NOT NULL | No | The year in which the season ended |
| Description | string (10) | NULL | No | The description of this season for display purposes (e.g. 2024-25; 2025-26; etc) |
| RegularSeasonStartDate | date | NULL | No | The start date of the regular season |
| PostSeasonStartDate | date | NULL | No | The start date of the postseason |
| ApiSeason | string (50) | NULL | No | The string to pass into subsequent API calls in the season parameter (e.g. 2025REG, 2025POST, etc.) |
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 associated with this sportsbook |
| Name | string (32) | NOT NULL | Yes | The name of the sportsbook |
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. Note: Active = True & Inactive = False |
| Name | string (50) | NOT NULL | No | The full name of the stadium |
| Address | string (50) | NULL | No | The address where the stadium is located (street name). Note: some stadiums will not have an address field |
| City | string (50) | NULL | No | The city where the stadium is located |
| State | string (50) | NULL | No | The US state where the stadium is located. Note: if Stadium is outside US; this value is NULL |
| Zip | string (10) | NULL | No | The zip code of the stadium |
| Country | string (10) | NULL | No | The 3-letter country abbreviation where the stadium is located |
| Capacity | integer (32) | NULL | No | The estimated seating capacity of the stadium |
| 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. OKL; TXTECH; USC; UK; etc.). Note: Due to being selected for uniqueness; these are not always matching broadcaster abbreviations. For that use case; use ShortDisplayName. |
| Active | boolean | NOT NULL | No | Whether or not this team is active. Note: Active = True & Inactive = False |
| 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.) |
| ApRank | integer (32) | NULL | No | The AP Rank of the team (1-25) |
| Wins | integer (32) | NULL | No | The total number of wins by the team (conference & non-conference) |
| Losses | integer (32) | NULL | No | The total number of losses by the school |
| 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 this team. This value is guaranteed to be unique across all sports/leagues |
| ConferenceID | integer (32) | NULL | No | The ID of the team's conference |
| Conference | string (50) | NULL | No | The name of the team's conference (e.g. American Athletic, Big Ten, Conference USA) |
| TeamLogoUrl | string (100) | NULL | No | The url of the team logo image (png format) |
| ShortDisplayName | string (10) | NULL | No | A abbreviation of the team as seen on most broadcasts Note: This field could have the same name for multiple teams. If a completely unique name is needed use [Key] |
| Stadium | Stadium | NULL | No | The active home stadium of the team |
| 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. OKL; TXTECH; USC; UK; 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. Note: Active = True & Inactive = False |
| 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.) |
| GlobalTeamID | integer (32) | NOT NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| ConferenceID | integer (32) | NULL | No | The ID of the team's conference |
| Conference | string (50) | NULL | No | The name of the team's conference (e.g. American Athletic, Big Ten, Conference USA) |
| TeamLogoUrl | string (100) | NULL | No | The URL of the team logo image (png format) |
| ShortDisplayName | string (10) | NULL | No | A abbreviation of the team as seen on most broadcasts. Note: This field could have the same name for multiple teams. If a completely unique name is need use [Key] |
| Stadium | Stadium | NULL | No | The active home stadium of the team |
| 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 stat |
| 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 season that the game the team is playing in occurs. Note: season is a single year that the majority of the season occurs in |
| Name | string (50) | NULL | No | Team's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (32) | NULL | No | The total number of wins by the team (conference & non-conference) |
| Losses | integer (32) | NULL | No | The total number of losses by the team (conference & non-conference) |
| 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) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Possessions | decimal (32) | NULL | Yes | Total number of estimated team possessions by the team in the game |
| GameID | integer (32) | NULL | No | The unique ID of this game |
| OpponentID | integer (32) | NULL | No | The unique ID of the opponent team |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day that the game is scheduled to be played in |
| 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 or not the team's game is over (returns true/false) |
| 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 team's opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when this record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the team. Note: this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the game |
| Minutes | integer (32) | NULL | Yes | Total number of minutes played by the team in the game |
| FieldGoalsMade | integer (32) | NULL | Yes | Total number of field goals made by the team in the game |
| FieldGoalsAttempted | integer (32) | NULL | Yes | Total number of field goals attempted by the team in the game |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goals percentage by the team in the game |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | The team's effective field goal percentage (eFG%) for the game |
| TwoPointersMade | integer (32) | NULL | Yes | Total two-pointers made by the team in the game |
| TwoPointersAttempted | integer (32) | NULL | Yes | Total two-pointers attempted by the team in the game |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two-pointer percentage by the team in the game |
| ThreePointersMade | integer (32) | NULL | Yes | Total three-pointers made by the team in the game |
| ThreePointersAttempted | integer (32) | NULL | Yes | Total three-pointers attempted by the team in the game |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three-point percentage by the team in the game |
| FreeThrowsMade | integer (32) | NULL | Yes | Total number of free throws made by the team in the game |
| FreeThrowsAttempted | integer (32) | NULL | Yes | Total number of free throws attempted by the team in the game |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the team in the game |
| OffensiveRebounds | integer (32) | NULL | Yes | Total offensive rebounds by the team in the game |
| DefensiveRebounds | integer (32) | NULL | Yes | Total defensive rebounds by team in the game |
| Rebounds | integer (32) | NULL | Yes | Total rebounds by the team in the game |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | The team's offensive rebound percentage (ORB%) for the game |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | The team's defensive rebounds percentage (DRB%) for the game |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the team in the game |
| Assists | integer (32) | NULL | Yes | Total assists by team in the game |
| Steals | integer (32) | NULL | Yes | Total steals by the team in the game |
| BlockedShots | integer (32) | NULL | Yes | Total blocked shots by the team in the game |
| Turnovers | integer (32) | NULL | Yes | Total turnovers by team in the game |
| PersonalFouls | integer (32) | NULL | Yes | Total personal fouls by the team in the game |
| Points | integer (32) | NULL | Yes | Total points by team in the game |
| TrueShootingAttempts | decimal (32) | NULL | Yes | The team's true shooting attempts (TSA) for the game |
| TrueShootingPercentage | decimal (32) | NULL | Yes | The team's true shooting percentage (TS%) for the game |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The team's linear weight efficiency (PER) rating for the game |
| AssistsPercentage | decimal (32) | NULL | Yes | The team's assist percentage (AST%) for the game |
| StealsPercentage | decimal (32) | NULL | Yes | The team's steal percentage (STL%) for the game |
| BlocksPercentage | decimal (32) | NULL | Yes | The team's block percentage (BLK%) for the game |
| TurnOversPercentage | decimal (32) | NULL | Yes | The team's turnover percentage (TOV%) for the game |
| UsageRatePercentage | decimal (32) | NULL | Yes | The team's usage rate percentage (Usg%) for the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points scored by the team in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the team in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points scored 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 range in which the trend shows data for (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 opponent team |
| Opponent from 2020 | string (50) | NULL | No | The abbreviation [Key] of the opponent team |
| Wins from 2020 | integer (32) | NOT NULL | Yes | The total number of wins by the team relating to the scope (conference & non-conference) |
| Losses from 2020 | integer (32) | NOT NULL | Yes | The total number of losses by the team relating to the scope (conference & non-conference) |
| Ties from 2020 | integer (32) | NOT NULL | Yes | The total number of ties by the team relating to the scope (conference & non-conference) |
| WinsAgainstTheSpread from 2020 | integer (32) | NULL | Yes | How many games the given team has covered the spread in relating to the scope of the search |
| LossesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | The total number of losses against the point spread by the team relating to the scope (conference & non-conference |
| PushesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | The amount of times a given team's final score of their game has pushed the point spread (a push is neither a win nor a loss) |
| Overs from 2020 | integer (32) | NULL | Yes | The amount of times a given team's final score of their game has gone over the point total (Over/Under) relating to the scope |
| Unders from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes under the OverUnder |
| OverUnderPushes from 2020 | integer (32) | NULL | Yes | The amount of times a given team's final score of their game has pushed the total points line (a push is neither a win nor a loss) |
| AverageScore from 2020 | decimal (32) | NULL | Yes | The average points per game scored by the given team over a certain scope (Last 3 Games, Last 5 Games, Last 10 Games, etc.) |
| AverageOpponentScore from 2020 | decimal (32) | NULL | Yes | The average points per game scored by the opposing teams of a given team over a certain scope (Last 3 Games, Last 5 Games, Last 10 Games, etc.) |
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 stat |
| 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 season that the team is participating in. Note: season is a single year that the majority of the season occurs in |
| 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 | The total number of wins by the team (conference & non-conference) |
| Losses | integer (32) | NULL | No | The total number of losses by the team (conference & non-conference) |
| 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) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| Possessions | decimal (32) | NULL | Yes | Total number of estimated team possessions by the team in the season |
| Updated | datetime | NULL | No | The timestamp of when this record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the team in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the season |
| Minutes | integer (32) | NULL | Yes | Total number of minutes played by the team in the season |
| FieldGoalsMade | integer (32) | NULL | Yes | Total number of field goals made by the team in the season |
| FieldGoalsAttempted | integer (32) | NULL | Yes | Total number of field goals attempted by the team in the season |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goals percentage by the team in the season |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | The team's effective field goal percentage (eFG%) for the season |
| TwoPointersMade | integer (32) | NULL | Yes | Total two-pointers made by the team in the season |
| TwoPointersAttempted | integer (32) | NULL | Yes | Total two-pointers attempted by the team in the season |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two-pointer percentage by the team in the season |
| ThreePointersMade | integer (32) | NULL | Yes | Total three-pointers made by the team in the season |
| ThreePointersAttempted | integer (32) | NULL | Yes | Total three-pointers attempted by the team in the season |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three-point percentage by the team in the season |
| FreeThrowsMade | integer (32) | NULL | Yes | Total number of free throws made by the team in the season |
| FreeThrowsAttempted | integer (32) | NULL | Yes | Total number of free throws attempted by the team in the season |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the team in the season |
| OffensiveRebounds | integer (32) | NULL | Yes | Total offensive rebounds by the team in the season |
| DefensiveRebounds | integer (32) | NULL | Yes | Total defensive rebounds by team in the season |
| Rebounds | integer (32) | NULL | Yes | Total rebounds by the team in the season |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | The team's offensive rebound percentage (ORB%) for the season |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | The team's defensive rebounds percentage (DRB%) for the season |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the team in the season |
| Assists | integer (32) | NULL | Yes | Total assists by team in the season |
| Steals | integer (32) | NULL | Yes | Total steals by the team in the season |
| BlockedShots | integer (32) | NULL | Yes | Total blocked shots by the team in the season |
| Turnovers | integer (32) | NULL | Yes | Total turnovers by team in the season |
| PersonalFouls | integer (32) | NULL | Yes | Total personal fouls by the team in the season |
| Points | integer (32) | NULL | Yes | Total points by team in the season |
| TrueShootingAttempts | decimal (32) | NULL | Yes | The team's true shooting attempts (TSA) for the season |
| TrueShootingPercentage | decimal (32) | NULL | Yes | The team's true shooting percentage (TS%) for the season |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The team's linear weight efficiency (PER) rating for the season |
| AssistsPercentage | decimal (32) | NULL | Yes | The team's assist percentage (AST%) for the season |
| StealsPercentage | decimal (32) | NULL | Yes | The team's steal percentage (STL%) for the season |
| BlocksPercentage | decimal (32) | NULL | Yes | The team's block percentage (BLK%) for the season |
| TurnOversPercentage | decimal (32) | NULL | Yes | The team's turnover percentage (TOV%) for the season |
| UsageRatePercentage | decimal (32) | NULL | Yes | The team's usage rate percentage (Usg%) for the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points scored by the team in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points scored 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 next scheduled game for the team |
| TeamGameTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of game trends for this team |
Tournament
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TournamentID from 2016 | integer (32) | NOT NULL | No | The unique ID of the tournament. Note: this field is specific to March Madness tournament & does not include other tournaments |
| Season from 2016 | integer (32) | NOT NULL | No | The season that the tournament occurs in. Note: season is a single year that the majority of the season occurs in |
| Name from 2016 | string (100) | NOT NULL | No | The name of the tournament |
| Location from 2016 | string (50) | NOT NULL | No | Where the tournament in question is located/being played |
| Games from 2016 | Game[] | NULL | No | Shows a list of games that are held within a tournament for a given season |
| LeftTopBracketConference from 2016 | string (20) | NULL | No | The region that is designated to be in the top-left of the NCAA Tournament bracket |
| LeftBottomBracketConference from 2016 | string (20) | NULL | No | The region that is designated to be in the bottom-left of the NCAA Tournament bracket |
| RightTopBracketConference from 2016 | string (20) | NULL | No | The region that is designated to be in the top-right of the NCAA Tournament bracket |
| RightBottomBracketConference from 2016 | string (20) | NULL | No | The region that is designated to be in the bottom-right of the NCAA Tournament bracket |