Soccer 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 UTC.
Area
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| AreaId | integer (32) | NOT NULL | No | The unique ID of the area |
| CountryCode | string (10) | NOT NULL | No | The 3-digit country or continent code where the area is located |
| Name | string (50) | NOT NULL | No | The display name of the area |
| Competitions | Competition[] | NULL | No | The competitions that are associated with and/or played in the area |
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. NOTE: Unique only within the same entity type (i.e. BettingMarketType Ids overlap with BettingBetType Ids) |
| Name from 2021 | string (100) | NOT NULL | No | Denotes the name of the Type (e.g. Betting Market Type, Betting Event Type, Betting Period Type) |
| Active | bool (32) | NULL | No | Whether or not this market is currently is use |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingBetTypes from 2021 | BettingEntityMetadata[] (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 | The name of the period type of a market (e.g. Regular Season; 1st half; 90 Minutes and Stoppage Time; etc.) |
| 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) |
BettingEvent
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingEventID from 2021 | int (32) | NOT NULL | No | The unique ID assocated with the betting event |
| Name from 2021 | string (32) | NULL | No | The name of this betting event |
| Season from 2021 | int (32) | NULL | No | The soccer regular season for which these totals apply |
| BettingEventTypeID from 2021 | int (32) | NOT NULL | No | The ID associated with the type of betting event |
| BettingEventType from 2021 | string (32) | NOT NULL | No | Indicates the type of betting event - Game or Future |
| StartDate from 2021 | datetime | NULL | No | The last day for betting on this event |
| Created from 2021 | datetime | NULL | No | The created date of this betting event (in US Eastern Time) |
| Updated from 2021 | datetime | NULL | No | The timestamp of when the betting event record was last updated (US Eastern Time) |
| GameID from 2021 | int (32) | NULL | No | The unique ID of the game |
| GlobalGameID from 2021 | int (32) | NULL | No | A globally unique ID for this game tied to this event |
| GameStatus from 2021 | string (32) | NULL | Yes | The status of the game tied to this event |
| Quarter from 2021 | string (32) | NULL | Yes | The quarter of the game tied to this event |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team tied to this event |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the home team tied to this event |
| AwayTeamID from 2021 | int (32) | NULL | No | The unique ID of the away team tied to this event |
| HomeTeamID from 2021 | int (32) | NULL | No | The unique ID of the home team tied to this event |
| GlobalAwayTeamID from 2021 | int (32) | NULL | No | A globally unique ID for the away team tied to this event |
| GlobalHomeTeamID from 2021 | int (32) | NULL | No | A globally unique ID for the home team tied to this event |
| AwayTeamScore from 2021 | int (32) | NULL | Yes | The away team score of the game tied to this event (updated after game ends to allow for resolving bets) |
| HomeTeamScore from 2021 | int (32) | NULL | Yes | The home team score of the game tied to this event (updated after game ends to allow for resolving bets) |
| TotalScore from 2021 | int (32) | NULL | Yes | The total combined score of both teams in the game (updated after game ends to allow for resolving bets) |
| AwayRotationNumber from 2021 | int (32) | NULL | No | The away team rotation number of the game tied to this event |
| HomeRotationNumber from 2021 | int (32) | NULL | No | The home team rotation number of the game tied to this event |
| BettingMarkets from 2021 | BettingMarket[] (32) | NULL | No | The list of betting markets for this event |
| CompetitionId from 2021 | int (32) | NULL | No | The Id of the competition related to this betting event |
BettingMarket
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2020 | int (32) | NOT NULL | No | The unique ID of the betting market |
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID assocated with the betting event |
| BettingMarketTypeID from 2020 | int (32) | NULL | Yes | The unique ID associated with the name of the market type |
| BettingMarketType from 2020 | string (32) | NULL | Yes | The name of the market type within a betting market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the name of the bet type within a market |
| BettingBetType from 2020 | string (32) | NULL | Yes | The name of the bet type within a market (e.g. Spread, Moneyline, Total Goals, etc.) |
| BettingPeriodTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the betting period type which we can result |
| BettingPeriodType from 2020 | string (32) | NULL | Yes | The name of the period type of a market (e.g. Regular Season; 1st half; 90 Minutes and Stoppage Time; etc.) |
| Name from 2020 | string (32) | NULL | No | The name of this betting market |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team associated with betting market |
| TeamKey from 2020 | string (32) | NULL | Yes | The abbreviation [Key] of the team associated with this betting market |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| PlayerName from 2020 | string (32) | NULL | Yes | The player's full name tied to this betting market |
| Created from 2020 | datetime (32) | NULL | No | The created date of this market (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of when the betting market record was last updated (US Eastern Time) |
| AvailableSportsbooks from 2020 | Sportsbook[] (32) | NULL | No | The sportsbooks that have had odds in this market |
| AnyBetsAvailable from 2020 | bool (32) | NULL | No | Shows if any bets are currently available for betting in this market |
| BettingOutcomes from 2020 | BettingOutcome[] (32) | NULL | No | The list of betting outcomes from each sportsbook in this market |
| ConsensusOutcomes from 2020 | ConsensusOutcome[] (32) | NULL | No | The single set of consesnus outcomes of this market |
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 of the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the betting outcome type |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of the betting outcome within a betting market (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the spread, game total, etc.) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: This is provided by the sportsbook. In the case of Player odds, we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks. |
| IsAvailable from 2020 | bool (32) | NULL | No | Indicates if this outcome is available for betting as of the last update |
| IsAlternate from 2020 | bool (32) | NULL | No | Indicates if this is an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The created date of the outcome (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of when the betting outcome was last updated (US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when the outcome was no longer available for betting |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team associated with betting outcome |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team associated with this outcome (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) |
Booking
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BookingId | integer (32) | NOT NULL | No | The unique ID of the booking |
| GameId | integer (32) | NOT NULL | No | The unique ID of the game tied to this booking |
| Type | string (20) | NOT NULL | No | The type of booking. Possible values: Yellow Card, Red Card, Yellow Red Card |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team associated with this booking |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| Name | string (100) | NULL | No | The full name of the player who was booked |
| GameMinute | integer (32) | NULL | No | The minute in the game in which the booking occurred |
| GameMinuteExtra | integer (32) | NULL | No | The extra minute in the game in which the booking occurred |
BoxScore
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Game | Game | NULL | No | The game details associated with this box score |
| AwayTeamCoach | Coach | NULL | No | The coach of the away team |
| HomeTeamCoach | Coach | NULL | No | The coach of the home team |
| MainReferee | Referee | NULL | No | The main referee |
| AssistantReferee1 | Referee | NULL | No | The first assistant referee |
| AssistantReferee2 | Referee | NULL | No | The second assistant referee |
| FourthReferee | Referee | NULL | No | The information about the fourth referee working the match |
| AdditionalAssistantReferee1 | Referee | NULL | No | The first additional assistant referee |
| AdditionalAssistantReferee2 | Referee | NULL | No | The second additional assistant referee |
| Lineups | Lineup[] | NULL | No | The details of the lineups for each team |
| Goals | Goal[] | NULL | No | The details of the goals scored during this game |
| Bookings | Booking[] | NULL | No | The details of the bookings (yellow/red cards) recorded during this game |
| PenaltyShootouts | PenaltyShootout[] | NULL | No | The details of the penalty shootouts recorded during this game |
| TeamGames | TeamGame[] | NULL | No | The stats by the team in the game |
| PlayerGames | PlayerGame[] | NULL | No | The player stats for this game |
| VideoAssistantReferee | Referee | NULL | No | The name of the referee in charge of the video reviews (VAR) |
CanceledMembership
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| CanceledMembershipId from 2019 | integer (32) | NOT NULL | No | The unique ID of the canceled membership |
| MembershipId from 2019 | integer (32) | NOT NULL | No | The unique ID of the membership which is being canceled; should be used to find memberships which may be safely deleted. |
| TeamId from 2019 | integer (32) | NOT NULL | No | The unique ID of the team associated with this canceled membership |
| PlayerID from 2019 | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| Created from 2019 | datetime | NOT NULL | No | The date and time when this canceled membership was created |
Coach
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| CoachId | integer (32) | NOT NULL | No | The unique ID of the coach |
| FirstName | string (50) | NULL | No | Coach's first name |
| LastName | string (50) | NULL | No | The last name of the coach |
| ShortName | string (50) | NULL | No | The short name of the coach |
| Nationality | string (50) | NULL | No | Coach's nationality |
Competition
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| CompetitionId | integer (32) | NOT NULL | No | The unique ID of the competition/league |
| AreaId | integer (32) | NOT NULL | No | The unique ID of the area where this competition/league is played |
| AreaName | string (50) | NULL | No | The display name of the area where this competition/league is played |
| Name | string (50) | NOT NULL | No | The display name of the competition/league |
| Gender | string (10) | NULL | No | The gender of the players on the team Possible Values: Male; Female |
| Type | string (10) | NULL | No | The type of this competition/league Possible values: Club; International |
| Format | string (50) | NULL | No | The format of the competition/league. Possible values: Domestic League; International Cup |
| Seasons | Season[] | NULL | No | The seasons associated with this competition/league |
| Key | string (5) | NULL | No | The unique string key of the competition/league |
CompetitionDetail
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| CurrentSeason | Season | NULL | No | The current active season for this competition/league |
| Teams | TeamDetail[] | NULL | No | The list of active teams associated with this competition |
| Games | Game[] | NULL | No | The complete schedule for the current season of this competition/league |
| CompetitionId | integer (32) | NOT NULL | No | The unique ID of the competition/league |
| AreaId | integer (32) | NOT NULL | No | The unique ID of the area where this competition/league is played |
| AreaName | string (50) | NULL | No | The display name of the area where this competition/league is played |
| Name | string (50) | NOT NULL | No | The display name of the competition/league |
| Gender | string (10) | NULL | No | The gender of the players on the team Possible Values: Male; Female |
| Type | string (10) | NULL | No | The type of this competition/league Possible values: Club; International |
| Format | string (50) | NULL | No | The format of the competition/league. Possible values: Domestic League; International Cup |
| Seasons | Season[] | NULL | No | The seasons associated with this competition/league |
| Key | string (5) | NULL | No | The unique string key of the competition/league |
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 of the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the betting outcome type |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of the betting outcome within a betting market (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the spread, game total, etc.) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: This is provided by the sportsbook. In the case of Player odds; we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks. |
| IsAvailable from 2020 | bool (32) | NULL | No | Indicates if this outcome is available for betting as of the last update |
| IsAlternate from 2020 | bool (32) | NULL | No | Indicates if this is an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The created date of the outcome (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of when the Consensus outcome was last updated (US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when the outcome was no longer available for betting |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team associated with Consensus outcome |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team associated with this outcome (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) |
DfsSlate
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateID | integer (32) | NOT NULL | No | The unique ID of the slate as assigned by SportsDataIO |
| Operator | string (20) | NULL | No | The name of the operator who is running contests for this slate. Possible values: FanDuel; DraftKings; Yahoo; FantasyDraft; etc. |
| OperatorSlateID | integer (32) | NULL | No | Unique ID of a slate (assigned by the operator). |
| OperatorName | string (50) | NULL | No | The name of the slate (assigned by the operator). Possible values: Main, Express, Arcade, Late Night, etc. |
| OperatorDay | date | NULL | No | The day (in UTC) that the slate begins (assigned by the operator). |
| OperatorStartTime | datetime | NULL | No | The date/time (in UTC) that the slate begins (assigned by the operator). |
| NumberOfGames | integer (32) | NULL | No | The number of actual games that this slate covers |
| IsMultiDaySlate | boolean | NULL | No | Whether this slate uses games that take place on different days |
| RemovedByOperator | boolean | NULL | No | Indicates whether this slate was removed/deleted by the operator. |
| OperatorGameType | string (50) | NULL | No | The game type of the slate. Will often be null as most operators only have one game type. |
| DfsSlateGames | DfsSlateGame[] | NULL | No | The games that are included in this slate |
| DfsSlatePlayers | DfsSlatePlayer[] | NULL | No | The players that are included in this slate |
| SlateRosterSlots | string[] | NULL | No | The positions that need to be filled for this particular slate |
| SalaryCap | integer | NULL | No | The salary cap for the current slate (is null for slates with no salary cap such a Tiers gametypes) |
| CompetitionId | integer | NULL | No | The Id of the competition related to this slate (Premier League, Champions League, etc.) |
DfsSlateGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateGameID | integer (32) | NOT NULL | No | The unique ID of the SlateGame as assigned by SportsDataIO |
| SlateID | integer (32) | NOT NULL | No | The unique ID of the slate that this SlateGame refers to |
| GameID | integer (32) | NULL | No | The unique ID of the game that this SlateGame refers to |
| Game | Game | NULL | No | The details of the Game that this SlateGame refers to |
| OperatorGameID | integer (32) | NULL | No | Unique ID of a SlateGame (assigned by the operator). |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this game was removed/deleted by the operator. |
DfsSlatePlayer
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlatePlayerID | integer (32) | NOT NULL | No | The unique ID of the SlatePlayer as assigned by SportsDataIO |
| SlateID | integer (32) | NOT NULL | No | The unique ID of the slate that this SlatePlayer refers to |
| SlateGameID | integer (32) | NULL | No | The unique ID of the SlateGame that this SlatePlayer refers to |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| PlayerGameProjectionStatID | integer (32) | NULL | No | The SportsDataIO StatID that this SlatePlayer refers to. This points to data in the respective sports' projected player game stats feeds. |
| OperatorPlayerID | string (25) | NULL | No | Unique ID of the Player (assigned by the operator). |
| OperatorSlatePlayerID | string (50) | NULL | No | Unique ID of the SlatePlayer (assigned by the operator). |
| OperatorPlayerName | string (50) | NULL | No | The player's name (assigned by the operator). |
| OperatorPosition | string (10) | NULL | No | The player's eligible positions for the contest (assigned by the operator). |
| OperatorSalary | integer (32) | NULL | No | The player's salary for the contest (assigned by the operator). |
| OperatorRosterSlots | string[] | NULL | No | The player's eligible positions to be played in the contest (assigned by the operator). This would include UTIL plays for those that are eligible. |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this player was removed/deleted by the operator. |
| Team | string (12) | NULL | No | The abbreviation [Key] of the team |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this SlatePlayer record |
FantasyGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NULL | No | The unique ID of the game |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire 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 soccer regular season for which these totals apply |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| Team | string (50) | NULL | No | The abbreviation [Key] of the team |
| Opponent | string (10) | NULL | No | The name of the opponent team |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Name | string (100) | NULL | No | The player's full name |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper) |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Started | integer (32) | NULL | No | The total number of games the player started |
| FantasyPoints | decimal (32) | NULL | No | Total fantasy points |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true) or not (false) |
| FantasyPointsFanDuel | decimal (32) | NULL | No | This field is expected to be NULL |
| FantasyPointsYahoo | decimal (32) | NULL | No | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | No | Total DraftKings daily fantasy points scored by the player in the game |
| FanDuelPosition | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform. |
| YahooPosition | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. 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) |
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 the game |
| RoundId | integer (32) | NOT NULL | No | The unique ID of the round that this game is associated with. |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| 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). |
| Group | string (50) | NULL | No | The name of the group in which this game occurs. Note: This is used in tournaments & cups |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| VenueId | integer (32) | NULL | No | The unique ID of the venue |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| Status | string (10) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended, Start Delay, Rain Delay, No Result, & NotNecessary. If a game is called off before it starts, the Status is set to Postponed, until a new date/time is scheduled, at which point, the DateTime is updated, and the Status is set back to Scheduled. If a game has already started, and temporarily interrupted, it's Status is set to Suspended, until it either resumes, or gets postponed and replayed at a later date. If the game is at halftime, then the Status will be Break. Awarded is used in cases where a game is decided on the so called "green table." That means that a game was decided by the Federation/League to one team for a reason. This can include situations like riots, where the opponent team gets 3:0 win awarded as punishment. Awarded is also used when a club withdraws during the season from the competition then all the remaining matches getting awarded 3:0. |
| Week | integer (32) | NULL | No | The week during the season/round in which this game occurs |
| Period | string (20) | NULL | No | The final period of the game. Possible values: Regular = Game ended in 90 minutes of regular time; ExtraTime = Game ended in extra time / overtime; PenaltyShootout = Game finished in penalty shootout time |
| Clock | integer (32) | NULL | No | The clock for the game if it is in progress. Note: if the game hasn't started or the game is over; then this will be NULL |
| Winner | string (10) | NULL | Yes | The winner of the game. Possible values: AwayTeam; HomeTeam; Draw |
| VenueType | string (10) | NULL | No | Shows which team has home field advantage. Possible values: Home; Away; Neutral |
| AwayTeamKey | string (10) | NULL | No | The abbreviation [Key] of the away team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| AwayTeamCountryCode | string (10) | NULL | No | The country code of the away team. |
| AwayTeamScore | integer (32) | NULL | Yes | The final score of the away team |
| AwayTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the away team. |
| AwayTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the away team. |
| AwayTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the away team (if applicable). |
| AwayTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the away team (if applicable). |
| HomeTeamKey | string (10) | NULL | No | The abbreviation [Key] of the home team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| HomeTeamCountryCode | string (10) | NULL | No | The country code of the home team |
| HomeTeamScore | integer (32) | NULL | Yes | The final score of the home team |
| HomeTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the home team |
| HomeTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the home team |
| HomeTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the home team (if applicable) |
| HomeTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the home team (if applicable) |
| HomeTeamMoneyLine | integer (32) | NULL | Yes | Payout on a bet that the away home wins |
| AwayTeamMoneyLine | integer (32) | NULL | Yes | Payout on a bet that the away team wins. |
| DrawMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for a draw |
| PointSpread | decimal (32) | NULL | Yes | Point spread for the home team |
| HomeTeamPointSpreadPayout | integer (32) | NULL | Yes | Payout if the home team covers the spread |
| AwayTeamPointSpreadPayout | integer (32) | NULL | Yes | Payout if the away team covers the spread |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total goals line (over/under) for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over bet on the total goals line |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| Attendance | integer (32) | NULL | No | The attendance for the game. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when this record was updated (in UTC) |
| 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. |
| ClockExtra | integer (32) | NULL | No | The added stoppage time minute the game is currently in. Note: will be null when game is not in stoppage time |
| ClockDisplay | string (50) | NULL | No | A convenient string display of the current clock with format Clock+ClockExtra (example: 90+3) |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score and stats have been verified and closed out |
| HomeTeamFormation | string (20) | NULL | No | The formation for the home team (4-4-2; 4-3-3; etc.) |
| AwayTeamFormation | string (20) | NULL | No | The formation for the away team (4-4-2, 4-3-3, etc.) |
| PlayoffAggregateScore | PlayoffAggregateScore | NULL | No | Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first legs home team. |
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 the game |
| RoundId | integer (32) | NOT NULL | No | The unique ID of the round that this game is associated with |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Week | integer (32) | NULL | No | The week during the season/round in which this game occurs |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| Status | string (10) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended, Start Delay, Rain Delay, No Result, & NotNecessary. If a game is called off before it starts, the Status is set to Postponed, until a new date/time is scheduled, at which point, the DateTime is updated, and the Status is set back to Scheduled. If a game has already started, and temporarily interrupted, it's Status is set to Suspended, until it either resumes, or gets postponed and replayed at a later date. If the game is at halftime, then the Status will be Break. Awarded is used in cases where a game is decided on the so called "green table." That means that a game was decided by the Federation/League to one team for a reason. This can include situations like riots, where the opponent team gets 3:0 win awarded as punishment. Awarded is also used when a club withdraws during the season from the competition then all the remaining matches getting awarded 3:0. |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| GlobalGameId | integer (32) | NOT NULL | No | A globally unique ID for this game. 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 Odds from different sportsbooks |
| LiveOdds | GameOdd[] | NULL | No | List of Live Odds from different sportsbooks |
| HomeTeamScore | integer | NULL | Yes | Score of the home team (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer | NULL | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
| TotalScore | integer | NULL | Yes | The total combined score of both teams in the game (updated after game ends to allow for resolving bets) |
| AlternateMarketPregameOdds | GameOdd[] | NULL | Yes | List of Alternate Market GameOdds from different sportsbooks (such as 1st-half, 1st-qtr, etc) |
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 the game |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| 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 of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| Status | string (25) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended, Start Delay, Rain Delay, No Result, & NotNecessary. If a game is called off before it starts, the Status is set to Postponed, until a new date/time is scheduled, at which point, the DateTime is updated, and the Status is set back to Scheduled. If a game has already started, and temporarily interrupted, it's Status is set to Suspended, until it either resumes, or gets postponed and replayed at a later date. If the game is at halftime, then the Status will be Break. Awarded is used in cases where a game is decided on the so called "green table." That means that a game was decided by the Federation/League to one team for a reason. This can include situations like riots, where the opponent team gets 3:0 win awarded as punishment. Awarded is also used when a club withdraws during the season from the competition then all the remaining matches getting awarded 3:0. |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. 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 | Score of the home team (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer (32) | NULL | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
| TotalScore | integer (32) | NULL | Yes | The total combined score of both teams in the game (updated after game ends to allow for resolving bets) |
| RoundID | integer (32) | NOT NULL | No | The unique ID of the round that this game is associated with |
| Week | integer (32) | NULL | No | The week during the season/round in which this game occurs |
| AlternateMarketPregameOdds | GameOddResult[] | NULL | No | List of Alternate Market GameOdds from different sportsbooks (such as 1st-half; 1st-qtr; etc) |
| Period | string (20) | NULL | No | The final period of the game. Possible values: Regular = Game ended in 90 minutes of regular time; ExtraTime = Game ended in extra time / overtime; PenaltyShootout = Game finished in penalty shootout time |
| Clock | integer (32) | NULL | No | The clock for the game if it is in progress. Note: if the game hasn't started or the game is over; then this will be NULL |
| Winner | string (10) | NULL | Yes | The winner of the game. Possible values: AwayTeam; HomeTeam; Draw |
| AwayTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the away team. |
| AwayTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the away team. |
| AwayTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the away team (if applicable). |
| AwayTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the away team (if applicable). |
| HomeTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the home team |
| HomeTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the home team |
| HomeTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the home team (if applicable) |
| HomeTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the home team (if applicable) |
| ClockExtra | integer (32) | NULL | No | The added stoppage time minute the game is currently in. Note: will be null when game is not in stoppage time |
| ClockDisplay | string (50) | NULL | No | A convenient string display of the current clock with format Clock+ClockExtra (ex 90+3) |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score and stats have been verified and closed out |
| LiveOdds | GameOddResult[] | NULL | No | List of Live Odds from different sportsbooks with results |
GameOdd
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | The 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 the 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 Eatern Time (EST/EDT). If these are the latest odds for this game, and they have not been updated within the last few minutes, then it indicates that there were problems connecting to the sportsbook. |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for the away team |
| DrawMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for a draw |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total goals line (over/under) for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over bet on the total goals line |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under bet on the total goals line |
| SportsbookId | integer (32) | NULL | No | The unique ID of the sportsbook |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| HomeTeamAsianHandicap | decimal (32) | NULL | Yes | The sportsbook's asian handicap for the home team |
| AwayTeamAsianHandicap | decimal (32) | NULL | Yes | The sportsbook's asian handicap for the away team |
| HomeTeamAsianHandicapPayout | integer (32) | NULL | Yes | The sportsbook's Asian handicap payout for the home team |
| AwayTeamAsianHandicapPayout | integer (32) | NULL | Yes | The sportsbook's asian handicap payout for the away team covering |
| AsianTotal | decimal (32) | NULL | Yes | The sportsbook's asian total for the game |
| AsianTotalOverPayout | integer (32) | NULL | Yes | The sportsbook's payout for a result over the asian total |
| AsianTotalUnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for a result under the asian total |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 90 minutes + stoppage time; etc.) |
GameOddOutcome
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | The unique ID of this odd |
| GameOddResultTypeId | integer (32) | NULL | No | The GameOddResultType of this outcome as an integer |
| GameOddResultType | string (100) | NULL | No | The string identifier of the GameOddResultType of this outcome (e.g. Won, Lost, Push, Not Resulted, Incomplete) |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 90 minutes + stoppage time; etc.) |
| GameOddType | string (100) | NULL | No | The GameOddOutcomeType of this outcome as a string |
| BetValue | decimal (32) | NULL | No | The value that was bet in this outcome (if applicable) |
| ActualValue | decimal (32) | NULL | No | The value that actually occurred in game (if applicable) |
GameOddResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddID | integer (32) | NOT NULL | No | The 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 the 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 Eatern Time (EST/EDT). If these are the latest odds for this game, and they have not been updated within the last few minutes, then it indicates that there were problems connecting to the sportsbook. |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's 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 |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total goals line (over/under) for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over bet on the total goals line |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookID | integer (32) | NULL | No | The unique ID of the sportsbook |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (50) | NULL | No | The odd type of this specific odd |
| GameOddOutcomeResults | GameOddOutcome[] | NULL | No | List of outcomes showing results of betting markets that were bet on for the given match |
Goal
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GoalId | integer (32) | NOT NULL | No | The unique ID of the goal |
| GameId | integer (32) | NOT NULL | No | The unique ID of the game tied to this goal |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team associated with this goal |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career. |
| Name | string (100) | NULL | No | The full name of the player who scored the goal |
| Type | string (20) | NULL | No | The type of goal scored |
| AssistedByPlayerId1 | integer (32) | NULL | No | The unique ID of the first assisted player |
| AssistedByPlayerName1 | string (100) | NULL | Yes | The player's name of the first assisted player |
| AssistedByPlayerId2 | integer (32) | NULL | No | The unique ID of the second assisted player |
| AssistedByPlayerName2 | string (100) | NULL | Yes | The player's name of the second assisted player |
| GameMinute | integer (32) | NULL | Yes | The minute in the game in which the goal was scored |
| GameMinuteExtra | integer (32) | NULL | Yes | The extra minute in the game in which the goal was scored |
Headshot
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 stays with the player their entire career. |
| Name | string (100) | NULL | No | The player's full name |
| TeamID | integer (32) | NULL | No | The unique ID of the team associated with this player headshot |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper). |
| PreferredHostedHeadshotUrl | string (500) | NULL | No | The player's preferred hosted headshot URL. This returns the headshot with transparent background if available. |
| PreferredHostedHeadshotUpdated | datetime | NULL | No | The last updated date of the player's preferred hosted headshot. |
| HostedHeadshotWithBackgroundUrl | string (500) | NULL | No | The player's hosted headshot URL |
| HostedHeadshotWithBackgroundUpdated | datetime | NULL | No | The last updated timestamp of the player's hosted headshot |
| HostedHeadshotNoBackgroundUrl | string (500) | NULL | No | The player's transparent background hosted headshot URL |
| HostedHeadshotNoBackgroundUpdated | datetime | NULL | No | The last updated timestamp of the player's transparent background hosted headshot |
Lineup
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| LineupId | integer (32) | NOT NULL | No | The unique ID of this lineup |
| GameId | integer (32) | NOT NULL | No | The unique ID of the game tied to this lineup |
| Type | string (20) | NOT NULL | No | The player's status in the lineup. Possible values: Substitute In; Starter; Bench. |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team associated with this lineup |
| PlayerId | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career. |
| Name | string (100) | NOT NULL | No | The player's full name |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper). |
| ReplacedPlayerId | integer (32) | NULL | No | The unique ID of the replaced player |
| ReplacedPlayerName | string (100) | NULL | No | The name of the replaced player |
| GameMinute | integer (32) | NULL | No | The minute of the game |
| GameMinuteExtra | integer (32) | NULL | No | The extra minute of the game |
| PitchPositionHorizontal | integer (32) | NULL | No | The pitch position of where this player lined up on the field. Note: This is used for rendering an image of a soccer/football field with the players marked as such. This will be a number between 0 and 50. |
| PitchPositionVertical | integer (32) | NULL | No | The pitch position of where this player lined up on the field. Note: This is used for rendering an image of a soccer/football field with the players marked as such. This will be a number between 0 and 50. |
Membership
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| MembershipId | integer (32) | NOT NULL | No | The unique ID for the membership |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team |
| PlayerId | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career. |
| PlayerName | string (100) | NULL | No | The player's full name |
| TeamName | string (50) | NULL | No | The full name of the team |
| TeamArea | string (50) | NULL | No | The area the team is located within their home country |
| Active | boolean | NOT NULL | No | Whether the player's membership is active (true/false) |
| StartDate | datetime | NULL | No | The start date of the membership (in UTC) |
| EndDate | datetime | NULL | No | The end date of the membership (in UTC) |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Jersey | integer | NULL | Yes | The player's jersey number on this team |
PenaltyShootout
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PenaltyShootoutId | integer (32) | NOT NULL | No | The unique ID of the penalty shootout |
| GameId | integer (32) | NOT NULL | No | The unique ID of the game tied to this penalty shootout |
| Type | string (10) | NOT NULL | No | The result of this penalty shootout kick. Possible values: Goal; Miss. |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career. |
| Name | string (100) | NULL | No | The name of the player in the penalty shootout |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper). |
| Order | integer (32) | NOT NULL | No | The order of the penalty shootout |
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 stays with the player their entire career. |
| FirstName | string (50) | NULL | No | The player's first name |
| LastName | string (50) | NULL | No | The last name of the player |
| CommonName | string (100) | NULL | No | The player's common name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper). |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Foot | string (10) | NULL | No | The primary foot of the player. Possible values: left or right. |
| Height | integer (32) | NULL | No | The height of the player in centimeters (cm) |
| Weight | integer (32) | NULL | No | The player's weight in kilograms (kg) |
| Gender | string (10) | NULL | No | The gender of this player on the team. Possible Values: Male; Female. |
| BirthDate | datetime | NULL | No | The player's date of birth |
| BirthCity | string (50) | NULL | No | The city in which the player was born |
| BirthCountry | string (50) | NULL | No | The country in which the player was born |
| Nationality | string (50) | NULL | No | The nationality of the player |
| InjuryStatus | string (50) | NULL | Yes | Indicates the player's injury status. Possible values: Questionable; Out. |
| InjuryBodyPart | string (100) | NULL | Yes | The body part of the player that is injured (Knee; Groin; Calf; Hamstring; etc.) |
| InjuryNotes | string (250) | NULL | Yes | Not yet supported; will be null |
| InjuryStartDate | date | NULL | No | The date that the injury started or was first discovered |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| PhotoUrl | string (100) | NULL | No | This field is deprecated. Note: Photos are no longer available through this field. Headshots are now delivered through IMAGN. Please see our Headshots products for further information. |
| RotoWirePlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the RotoWire news feed. |
| DraftKingsPosition | string (50) | NULL | No | The position of the player according to DraftKings |
| UsaTodayPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to USA Today headshot data feeds |
| UsaTodayHeadshotUrl | string (100) | NULL | No | The player's headshot URL as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotNoBackgroundUrl | string (100) | NULL | No | The player's transparent background headshot URL as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotUpdated | datetime | NULL | No | The last updated timestamp of the player's headshot as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotNoBackgroundUpdated | datetime | NULL | No | The last updated timestamp of the player's transparent background headshot as provided by USA Today. License from USA Today is required. |
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 stays with the player their entire career. |
| FirstName | string (50) | NULL | No | The player's first name |
| LastName | string (50) | NULL | No | The last name of the player |
| CommonName | string (100) | NULL | No | The player's common name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker), M (Midfielder), D (Defender), GK (Goalkeeper). |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Foot | string (10) | NULL | No | The primary foot of the player. Possible values: left or right. |
| Height | integer (32) | NULL | No | The height of the player in centimeters (cm) |
| Weight | integer (32) | NULL | No | The player's weight in kilograms (kg) |
| Gender | string (10) | NULL | No | The gender of this player on the team. Possible Values: Male; Female. |
| BirthDate | datetime | NULL | No | The player's date of birth |
| BirthCity | string (50) | NULL | No | The city in which the player was born |
| BirthCountry | string (50) | NULL | No | The country in which the player was born |
| Nationality | string (50) | NULL | No | The nationality of the player |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
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 associated with this player |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this player is associated with |
| TeamId | integer (32) | NULL | No | The unique ID of the team |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career. |
| Name | string (100) | NULL | No | The player's full name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Team | string (50) | NULL | No | The name of the team |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper). |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Started | integer (32) | NULL | No | The total number of games the player started |
| Captain | boolean | NULL | No | Whether the player is a captain (true/false) |
| Suspension | boolean | NULL | No | Whether the player is suspended or not (true/false) |
| SuspensionReason | string (20) | NULL | No | The reason given for the player's suspension |
| FanDuelSalary | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests. |
| DraftKingsSalary | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests. |
| YahooSalary | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests |
| MondogoalSalary | integer (32) | NULL | Yes | The player's salary for Mondogoal's daily fantasy contests |
| FanDuelPosition | string (10) | NULL | Yes | The player's eligible position in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition | string (10) | NULL | Yes | The player's eligible position in DraftKings' daily fantasy sports platform. |
| YahooPosition | string (10) | NULL | Yes | The player's eligible position in Yahoo's daily fantasy sports platform |
| MondogoalPosition | string (10) | NULL | Yes | The player's eligible position in Mondogoal's daily fantasy sports platform. |
| InjuryStatus | string (50) | NULL | Yes | Indicates the player's injury status. Possible values: Questionable; Out. |
| InjuryBodyPart | string (100) | NULL | Yes | The body part of the player that is injured (Knee; Groin; Calf; Hamstring; etc.) |
| InjuryNotes | string (250) | NULL | Yes | Not yet supported; will be null |
| InjuryStartDate | date | NULL | No | The date that the injury started or was first discovered |
| GlobalTeamId | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Corners | decimal (32) | NULL | Yes | Total number of corner kicks taken by the player in the game |
| GameId | integer (32) | NULL | No | The unique ID of the game |
| OpponentId | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The name of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| HomeOrAway | string (4) | NULL | No | Whether the team is the home team or away team |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true) or not (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 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) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total number of games played by the player in the game |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsMondogoal | decimal (32) | NULL | Yes | Total Mondogoal daily fantasy points scored by the player in the game |
| Minutes | decimal (32) | NULL | Yes | Total regular time minutes played by the player in the game. Note: this excludes stoppage time minutes |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total assists scored by the player in the game |
| Shots | decimal (32) | NULL | Yes | Total shots attempted by the player in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal attempted by the player in the game |
| YellowCards | decimal (32) | NULL | Yes | Total yellow cards against the player in the game |
| RedCards | decimal (32) | NULL | Yes | Total red cards against by the player in the game |
| YellowRedCards | decimal (32) | NULL | Yes | Total double yellow cards against the player in the game. Note: A double yellow card results in a red card. |
| Crosses | decimal (32) | NULL | Yes | Total crosses by the player in the game. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal. |
| TacklesWon | decimal (32) | NULL | Yes | Total tackles won by the player in the game |
| Interceptions | decimal (32) | NULL | Yes | Total interceptions made by the player in the game |
| OwnGoals | decimal (32) | NULL | Yes | Total goals scored against own team by the player in the game |
| Fouls | decimal (32) | NULL | Yes | Total fouls made by the player in the game |
| Fouled | decimal (32) | NULL | Yes | Total times the player was fouled in the game |
| Offsides | decimal (32) | NULL | Yes | Total offsides against by the player in the game |
| Passes | decimal (32) | NULL | Yes | Total passes attempted by the player in the game |
| PassesCompleted | decimal (32) | NULL | Yes | Total passes completed by the player in the game |
| LastManTackle | decimal (32) | NULL | Yes | Total tackles made by the player when there is no one else available to stop the opponent from scoring in the game |
| CornersWon | decimal (32) | NULL | Yes | Total corner kicks awarded to the player in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total shots blocked by the player in the game |
| Touches | decimal (32) | NULL | Yes | Total times the player touched the ball in the game |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total defender clean sheets by the player in the game. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes). |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total saves made by goalkeeper in the game |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by goalkeeper in the game |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total games where the goalkeeper allowed exactly one goal in the game |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total number of clean sheets by the goalkeeper in the game. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes. |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total wins by the goalkeeper in the game |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total penalty kick goals scored by the player in the game |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total penalty kicks missed by the player in the game |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total penalty kicks saved by the player in the game |
| PenaltiesWon | decimal (32) | NULL | Yes | Total penalties won by the player in the game |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total penalties conceded by the player in the game |
| Score | decimal (32) | NULL | Yes | Total goals scored by the player's team in the game |
| OpponentScore | decimal (32) | NULL | Yes | Total goals allowed by the player's team in the game |
| Tackles | decimal (32) | NULL | Yes | Total tackles by the player in the game |
PlayerGameBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total number of games played by the player in the game |
| Minutes | decimal (32) | NULL | Yes | Total regular time minutes played by the player in the game. Note: this excludes stoppage time minutes |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total assists scored by the player in the game |
| Shots | decimal (32) | NULL | Yes | Total shots attempted by the player in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal attempted by the player in the game |
| YellowCards | decimal (32) | NULL | Yes | Total yellow cards against the player in the game |
| RedCards | decimal (32) | NULL | Yes | Total red cards against by the player in the game |
| YellowRedCards | decimal (32) | NULL | Yes | Total double yellow cards against the player in the game. Note: A double yellow card results in a red card |
| Crosses | decimal (32) | NULL | Yes | Total crosses by the player in the game. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal. |
| TacklesWon | decimal (32) | NULL | Yes | Total tackles won by the player in the game |
| Interceptions | decimal (32) | NULL | Yes | Total interceptions made by the player in the game |
| OwnGoals | decimal (32) | NULL | Yes | Total goals scored against own team (accidentally) |
| Fouls | decimal (32) | NULL | Yes | Total fouls made by the player in the game |
| Fouled | decimal (32) | NULL | Yes | Total times the player was fouled in the game |
| Offsides | decimal (32) | NULL | Yes | Total offsides against by the player in the game |
| Passes | decimal (32) | NULL | Yes | Total passes attempted by the player in the game |
| PassesCompleted | decimal (32) | NULL | Yes | Total passes completed by the player in the game |
| LastManTackle | decimal (32) | NULL | Yes | Total tackles made by the player when there is no one else available to stop the opponent from scoring in the game |
| CornersWon | decimal (32) | NULL | Yes | Total corner kicks awarded to the player in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total shots blocked by the player in the game |
| Touches | decimal (32) | NULL | Yes | Total times the player touched the ball in the game |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total defender clean sheets by the player in the game. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes). |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total saves made by goalkeeper in the game |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by goalkeeper in the game |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total games where the goalkeeper allowed exactly one goal in the game |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total number of clean sheets by the goalkeeper in the game. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total wins by the goalkeeper in the game |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total penalty kick goals scored by the player in the game |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total penalty kicks missed by the player in the game |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total penalty kicks saved by the player in the game |
| PenaltiesWon | decimal (32) | NULL | Yes | Total penalties won by the player in the game |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total penalties conceded by the player in the game |
| Score | decimal (32) | NULL | Yes | Total goals scored by the player's team in the game |
| OpponentScore | decimal (32) | NULL | Yes | Total goals scored against own team by the player in the game |
| Tackles | decimal (32) | NULL | Yes | Total tackles by the player in the game |
| GameId | integer (32) | NULL | No | The unique ID of the game |
| OpponentId | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The name of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| HomeOrAway | string (4) | NULL | No | Whether the team is the home team or away team |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true) or not (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 opponent. This value is guaranteed to be unique across all sports/leagues. |
| StatId | integer (32) | NOT NULL | No | The unique ID of the stat associated with this player |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this player is associated with |
| TeamId | integer (32) | NULL | No | The unique ID of the team |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| Name | string (100) | NULL | No | The player's full name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Team | string (50) | NULL | No | The abbreviation [Key] of the player's team |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper) |
| Jersey | integer (32) | NOT NULL | No | The player's jersey number |
| Started | integer (32) | NULL | No | The total number of games the player started |
| Captain | boolean | NULL | No | Whether the player is a captain (true/false) |
| Suspension | boolean | NULL | No | Whether the player is suspended or not (true/false) |
| SuspensionReason | string (20) | NULL | No | The reason given for the player's suspension |
| GlobalTeamId | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
PlayerGameProjection
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 associated with this player |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this player is associated with |
| TeamId | integer (32) | NULL | No | The unique ID of the team |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| Name | string (100) | NULL | No | The player's full name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Team | string (50) | NULL | No | The abbreviation [Key] of the team |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper) |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Started | integer (32) | NULL | No | The total number of games the player is projected to start |
| Captain | boolean | NULL | No | Whether the player is a captain or not |
| Suspension | boolean | NULL | No | Whether the player is suspended or not |
| SuspensionReason | string (20) | NULL | No | The reason given for the player's suspension |
| FanDuelSalary | integer (32) | NULL | Yes | This field is expected to be NULL |
| DraftKingsSalary | integer (32) | NULL | Yes | This field is expected to be NULL |
| YahooSalary | integer (32) | NULL | Yes | This field is expected to be NULL |
| MondogoalSalary | integer (32) | NULL | Yes | This field is expected to be NULL |
| FanDuelPosition | string (10) | NULL | Yes | This field is expected to be NULL |
| DraftKingsPosition | string (10) | NULL | Yes | This field is expected to be NULL |
| YahooPosition | string (10) | NULL | Yes | This field is expected to be NULL |
| MondogoalPosition | string (10) | NULL | Yes | This field is expected to be NULL |
| InjuryStatus | string (50) | NULL | Yes | Indicates the player's injury status. Possible values: Questionable; Out |
| InjuryBodyPart | string (100) | NULL | Yes | The body part of the player that is injured (Knee; Groin; Calf; Hamstring; etc.) |
| InjuryNotes | string (250) | NULL | Yes | Not yet supported; will be null |
| InjuryStartDate | date | NULL | No | The date that the injury started or was first discovered |
| GlobalTeamId | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Corners | decimal (32) | NULL | Yes | Total number of corner kicks taken by the player in the game |
| GameId | integer (32) | NULL | No | The unique ID of the game |
| OpponentId | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The name of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| HomeOrAway | string (4) | NULL | No | Whether the team is the home team or away team |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over or not |
| GlobalGameId | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentId | integer (32) | NULL | No | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total projected number of games played by the player in the game |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings daily fantasy points scored by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsMondogoal | decimal (32) | NULL | Yes | Total projected Mondogoal daily fantasy points scored by the player in the season |
| Minutes | decimal (32) | NULL | Yes | Total projected minutes played by the player in the game |
| Goals | decimal (32) | NULL | Yes | Total projected goals scored by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total projected assists scored by the player in the game |
| Shots | decimal (32) | NULL | Yes | Total projected shots attempted by the player in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total projected shots on goal attempted by the player in the game |
| YellowCards | decimal (32) | NULL | Yes | Total projected yellow cards against by the player in the game |
| RedCards | decimal (32) | NULL | Yes | Total projected red cards against by the player in the game |
| YellowRedCards | decimal (32) | NULL | Yes | Total projected double yellow cards against the player in the game. Note: A double yellow card results in a red card |
| Crosses | decimal (32) | NULL | Yes | Total projected crosses by the player in the game. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal |
| TacklesWon | decimal (32) | NULL | Yes | Total projected tackles won by the team in the game |
| Interceptions | decimal (32) | NULL | Yes | Total projected interceptions made by the player in the game |
| OwnGoals | decimal (32) | NULL | Yes | Total projected goals scored against own team by the player in the game (accidentally) |
| Fouls | decimal (32) | NULL | Yes | Total projected fouls made by the player in the game |
| Fouled | decimal (32) | NULL | Yes | Total projected times the player was to be fouled in the game |
| Offsides | decimal (32) | NULL | Yes | Total projected offsides against by the player in the game |
| Passes | decimal (32) | NULL | Yes | Total projected passes attempted by the player in the game |
| PassesCompleted | decimal (32) | NULL | Yes | Total projected passes completed by the player in the game |
| LastManTackle | decimal (32) | NULL | Yes | Total projected tackles made by the player when there is no one else available to stop the opponent from scoring in the game |
| CornersWon | decimal (32) | NULL | Yes | Total projected corner kicks awarded to the player in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total projected shots blocked by the player in the game |
| Touches | decimal (32) | NULL | Yes | Total projected times the player will touch the ball in the game |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total projected defender clean sheets by the player in the game. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total projected saves made by the goalkeeper in the game |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total projected goals allowed by goalkeeper in the game |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total projected games where the goalkeeper allowed exactly one goal in the game |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total projected number of clean sheets by the goalkeeper in the game. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total projected wins by the goalkeeper in the game |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total projected penalty kick goals scored by the player in the game |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total projected penalty kicks missed by the player in the game |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total projected penalty kicks saved by the player in the game |
| PenaltiesWon | decimal (32) | NULL | Yes | Total projected penalties won by the player in the game |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total projected penalties conceded by the player in the game |
| Score | decimal (32) | NULL | Yes | Total projected goals scored by the player's team in the game |
| OpponentScore | decimal (32) | NULL | Yes | Total projected goals allowed by the player's team in the game |
| Tackles | decimal (32) | NULL | Yes | Total projected tackles by the team in the game |
PlayerSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatId | integer (32) | NOT NULL | No | The unique ID of the stat associated with this player |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this player is associated with |
| 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 stays with the player their entire career |
| Name | string (100) | NULL | No | The player's full name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Team | string (50) | NULL | No | The abbreviation [Key] of the team |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker), M (Midfielder), D (Defender), GK (Goalkeeper) |
| Started | integer (32) | NULL | No | The total number of games the player started in the season |
| 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 the record was last updated (in US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total number of games played by the player in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsMondogoal | decimal (32) | NULL | Yes | Total Mondogoal daily fantasy points scored by the player in the season |
| Minutes | decimal (32) | NULL | Yes | Total minutes played by the player in the season |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the player in the season |
| Assists | decimal (32) | NULL | Yes | Total assists scored by the player in the season |
| Shots | decimal (32) | NULL | Yes | Total shots attempted by the player in the season |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal attempted by the player in the season |
| YellowCards | decimal (32) | NULL | Yes | Total yellow cards against the player in the season |
| RedCards | decimal (32) | NULL | Yes | Total red cards against by the player in the season |
| YellowRedCards | decimal (32) | NULL | Yes | Total double yellow cards against the player in the season. Note: A double yellow card results in a red card |
| Crosses | decimal (32) | NULL | Yes | Total crosses by the player in the season. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal |
| TacklesWon | decimal (32) | NULL | Yes | Total tackles won by the player in the season |
| Interceptions | decimal (32) | NULL | Yes | Total interceptions made by the player in the season |
| OwnGoals | decimal (32) | NULL | Yes | Total goals scored against own team by the player in the season |
| Fouls | decimal (32) | NULL | Yes | Total fouls made by the player in the season |
| Fouled | decimal (32) | NULL | Yes | Total times the player was fouled in the season |
| Offsides | decimal (32) | NULL | Yes | Total offsides against by the player in the season |
| Passes | decimal (32) | NULL | Yes | Total passes attempted by the player in the season |
| PassesCompleted | decimal (32) | NULL | Yes | Total passes completed by the player in the season |
| LastManTackle | decimal (32) | NULL | Yes | Total tackles made by the player when there is no one else available to stop the opponent from scoring in the season |
| CornersWon | decimal (32) | NULL | Yes | Total corner kicks awarded to the player in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total shots blocked by the player in the season |
| Touches | decimal (32) | NULL | Yes | Total times the player touched the ball in the season |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total defender clean sheets by the player in the season. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes) |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total saves made by goalkeeper in the season |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by goalkeeper in the season |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total games where the goalkeeper allowed exactly one goal in the season |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total number of clean sheets by the goalkeeper in the season. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total wins by the goalkeeper in the season |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total penalty kick goals scored by the player in the season |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total penalty kicks missed by the player in the season |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total penalty kicks saved by the player in the season |
| PenaltiesWon | decimal (32) | NULL | Yes | Total penalties won by the player in the season |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total penalties conceded by the player in the season |
| Score | decimal (32) | NULL | Yes | Total goals scored by the player's team in the season |
| OpponentScore | decimal (32) | NULL | Yes | Total goals allowed by the player's team in the season |
| Tackles | decimal (32) | NULL | Yes | Total tackles by the player in the season |
PlayerSeasonProjection
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatId | integer (32) | NOT NULL | No | The unique ID of the stat associated with this player |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this player is associated with |
| TeamId | integer (32) | NULL | No | The unique ID of the team |
| PlayerId | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID stays with the player their entire career |
| Name | string (100) | NULL | No | The player's full name |
| ShortName | string (50) | NULL | No | The short name of the player |
| Team | string (50) | NULL | No | The abbreviation [Key] of the team |
| PositionCategory | string (10) | NULL | No | The player's position category |
| Position | string (10) | NULL | No | The position of the player. Possible values include: A (Attacker); M (Midfielder); D (Defender); GK (Goalkeeper) |
| Started | integer (32) | NULL | No | The total number of games the player is projected to start in the season |
| 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 the record was last updated (US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total projected number of games played by the player in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings daily fantasy points scored by the team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsMondogoal | decimal (32) | NULL | Yes | Total projected Mondogoal daily fantasy points scored by the team in the season |
| Minutes | decimal (32) | NULL | Yes | Total projected minutes played by the player in the season |
| Goals | decimal (32) | NULL | Yes | Total projected goals scored by the player in the season |
| Assists | decimal (32) | NULL | Yes | Total projected assists scored by the player in the season |
| Shots | decimal (32) | NULL | Yes | Total projected shots attempted by the player in the season |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total projected shots on goal attempted by the player in the season |
| YellowCards | decimal (32) | NULL | Yes | Total projected yellow cards against by the player in the season |
| RedCards | decimal (32) | NULL | Yes | Total projected red cards against by the player in the season |
| YellowRedCards | decimal (32) | NULL | Yes | Total projected double yellow cards against the player in the season. Note: A double yellow card results in a red card |
| Crosses | decimal (32) | NULL | Yes | Total projected crosses by the player in the season. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal |
| TacklesWon | decimal (32) | NULL | Yes | Total projected tackles won by the team in the season |
| Interceptions | decimal (32) | NULL | Yes | Total projected interceptions made by the player in the season |
| OwnGoals | decimal (32) | NULL | Yes | Total projected goals scored against their own team by the player in the season (accidentally) |
| Fouls | decimal (32) | NULL | Yes | Total projected fouls made by the player in the season |
| Fouled | decimal (32) | NULL | Yes | Total projected times the player will be fouled in the season |
| Offsides | decimal (32) | NULL | Yes | Total projected offsides against by the team in the season |
| Passes | decimal (32) | NULL | Yes | Total projected passes attempted by the player in the season |
| PassesCompleted | decimal (32) | NULL | Yes | Total projected passes completed by the player in the season |
| LastManTackle | decimal (32) | NULL | Yes | Total projected tackles made by the player when there is no one else available to stop the opponent from scoring in the season |
| CornersWon | decimal (32) | NULL | Yes | Total projected corner kicks awarded to the player in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total projected shots blocked by the player in the season |
| Touches | decimal (32) | NULL | Yes | Total projected times the player will touch the ball in the season |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total projected defender clean sheets by the player in the season. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total projected saves made by the goalkeeper in the season |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total projected goals allowed by goalkeeper in the season |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total projected games where the goalkeeper allowed exactly one goal in the season |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total projected number of clean sheets by the goalkeeper in the season. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total projected wins by the goalkeeper in the season |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total projected penalty kick goals scored by the player in the season |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total projected penalty kicks missed by the player in the season |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total projected penalty kicks saved by the player in the season |
| PenaltiesWon | decimal (32) | NULL | Yes | Total projected won conceded by the team in the game |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total projected penalties conceded by the team in the game |
| Score | decimal (32) | NULL | Yes | Total projected goals scored by the player's team in the season |
| OpponentScore | decimal (32) | NULL | Yes | Total projected goals allowed by the player's team in the season |
| Tackles | decimal (32) | NULL | Yes | Total projected tackles by the team in the season |
PlayoffAggregateScore
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamA_Id from 2020 | integer (32) | NOT NULL | No | The TeamID of Team A. Note: Team A is determined by the home team in the first leg, and remains set through the life of the record |
| TeamA_AggregateScore from 2020 | integer (32) | NOT NULL | No | The score, on aggregate, of Team A in the matchup. Note: Team A is determined by the home team in the first leg, and remains set through the life of the record |
| TeamB_Id from 2020 | integer (32) | NOT NULL | No | The TeamID of Team B. Note: Team B is determined by the away team in the first leg, and remains set through the life of the record |
| TeamB_AggregateScore from 2020 | integer (32) | NOT NULL | No | The score, on aggregate, of Team B in the matchup. Note: Team B is determined by the away team in the first leg, and remains set through the life of the record |
| WinningTeamId from 2020 | integer (32) | NOT NULL | No | The ID of the team that wins the home-and-home matchup |
| Created from 2020 | datetime | NOT NULL | No | Date and time the record was created (in US Eastern Time) |
| Updated from 2020 | datetime | NOT NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
Referee
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RefereeId | integer (32) | NOT NULL | No | The last name of the referee |
| FirstName | string (50) | NULL | No | The first name of the referee |
| LastName | string (50) | NULL | No | The last name of the referee |
| ShortName | string (50) | NULL | No | The short name of the referee |
| Nationality | string (50) | NULL | No | The nationality of the referee |
Round
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RoundId | integer (32) | NOT NULL | No | The unique ID of the round |
| SeasonId | integer (32) | NOT NULL | No | The unique ID of the season this round is associated with |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| 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). |
| Name | string (50) | NOT NULL | No | The display name of the round (examples: Regular Season, Semi-finals, Final, etc) |
| Type | string (50) | NULL | No | The type of this round. Possible values: Cup; Table |
| StartDate | date | NULL | No | The start date of the round |
| EndDate | date | NULL | No | The end date of the round |
| CurrentWeek | integer (32) | NULL | No | The current week that this round is in |
| CurrentRound | boolean | NOT NULL | No | Indicates whether or not this round is the current round of the competition/season |
| Games | Game[] (32) | NULL | No | The games and their details that are apart of this round |
| Standings | Standing[] (32) | NULL | No | The standings details associated with this round of the competition |
| TeamSeasons | TeamSeason[] (32) | NULL | No | The team stat records associated with this round |
| PlayerSeasons | PlayerSeason[] (32) | NULL | No | Player Season stat records associated with this round |
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 the game |
| RoundId | integer (32) | NOT NULL | No | The unique ID of the round that this game is associated with. |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| 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). |
| Group | string (50) | NULL | No | The name of the group in which this game occurs. Note: This is used in tournaments & cups |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| VenueId | integer (32) | NULL | No | The unique ID of the venue |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| Status | string (10) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended, Start Delay, Rain Delay, No Result, & NotNecessary. If a game is called off before it starts, the Status is set to Postponed, until a new date/time is scheduled, at which point, the DateTime is updated, and the Status is set back to Scheduled. If a game has already started, and temporarily interrupted, it's Status is set to Suspended, until it either resumes, or gets postponed and replayed at a later date. If the game is at halftime, then the Status will be Break. Awarded is used in cases where a game is decided on the so called "green table." That means that a game was decided by the Federation/League to one team for a reason. This can include situations like riots, where the opponent team gets 3:0 win awarded as punishment. Awarded is also used when a club withdraws during the season from the competition then all the remaining matches getting awarded 3:0. |
| Week | integer (32) | NULL | No | The week during the season/round in which this game occurs |
| Winner | string (10) | NULL | Yes | The winner of the game. Possible values: AwayTeam; HomeTeam; Draw |
| VenueType | string (10) | NULL | No | Shows which team has home field advantage. Possible values: Home; Away; Neutral |
| AwayTeamKey | string (10) | NULL | No | The abbreviation [Key] of the away team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| AwayTeamCountryCode | string (10) | NULL | No | The country code of the away team |
| AwayTeamScore | integer (32) | NULL | Yes | The final score of the away team |
| AwayTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the away team. |
| AwayTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the away team. |
| AwayTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the away team (if applicable). |
| AwayTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the away team (if applicable). |
| HomeTeamKey | string (10) | NULL | No | The abbreviation [Key] of the home team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| HomeTeamCountryCode | string (10) | NULL | No | The country code of the home team |
| HomeTeamScore | integer (32) | NULL | Yes | The final score of the home team |
| HomeTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the home team |
| HomeTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the home team |
| HomeTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the home team (if applicable) |
| HomeTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the home team (if applicable) |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when this record was updated (in UTC) |
| 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. |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score and stats have been verified and closed out |
| PlayoffAggregateScore | PlayoffAggregateScore | NULL | No | Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first legs home team. |
ScoreBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Period | string (20) | NULL | No | The final period of the game. Possible values: Regular = Game ended in 90 minutes of regular time; ExtraTime = Game ended in extra time / overtime; PenaltyShootout = Game finished in penalty shootout time |
| Clock | integer (32) | NULL | No | The clock for the game if it is in progress. Note: if the game hasn't started or the game is over; then this will be NULL. |
| GameId | integer (32) | NOT NULL | No | The unique ID of the game |
| RoundId | integer (32) | NOT NULL | No | The unique ID of the round that this game is associated with. |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| 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). |
| Group | string (50) | NULL | No | The name of the group in which this game occurs. Note: This is used in tournaments & cups |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team. |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| VenueId | integer (32) | NULL | No | The unique ID of the venue |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in UTC) |
| Status | string (10) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended, Start Delay, Rain Delay, No Result, & NotNecessary. If a game is called off before it starts, the Status is set to Postponed, until a new date/time is scheduled, at which point, the DateTime is updated, and the Status is set back to Scheduled. If a game has already started, and temporarily interrupted, it's Status is set to Suspended, until it either resumes, or gets postponed and replayed at a later date. If the game is at halftime, then the Status will be Break. Awarded is used in cases where a game is decided on the so called "green table." That means that a game was decided by the Federation/League to one team for a reason. This can include situations like riots, where the opponent team gets 3:0 win awarded as punishment. Awarded is also used when a club withdraws during the season from the competition then all the remaining matches getting awarded 3:0. |
| Week | integer (32) | NULL | No | The week during the season/round in which this game occurs |
| Winner | string (10) | NULL | Yes | The winner of the game. Possible values: AwayTeam; HomeTeam; Draw |
| VenueType | string (10) | NULL | No | Shows which team has home field advantage. Possible values: Home; Away; Neutral |
| AwayTeamKey | string (10) | NULL | No | The abbreviation [Key] of the away team. |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| AwayTeamCountryCode | string (10) | NULL | No | The country code of the away team |
| AwayTeamScore | integer (32) | NULL | Yes | The final score of the away team |
| AwayTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the away team. |
| AwayTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the away team. |
| AwayTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the away team (if applicable). |
| AwayTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the away team (if applicable). |
| HomeTeamKey | string (10) | NULL | No | The abbreviation [Key] of the home team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| HomeTeamCountryCode | string (10) | NULL | No | The country code of the home team |
| HomeTeamScore | integer (32) | NULL | Yes | The final score of the home team |
| HomeTeamScorePeriod1 | integer (32) | NULL | Yes | The first period score of the home team |
| HomeTeamScorePeriod2 | integer (32) | NULL | Yes | The second period score of the home team |
| HomeTeamScoreExtraTime | integer (32) | NULL | Yes | The extra time (overtime) score of the home team (if applicable) |
| HomeTeamScorePenalty | integer (32) | NULL | Yes | The penalty shootout score of the home team (if applicable) |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when this record was updated (in UTC) |
| 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. |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score and stats have been verified and closed out |
| PlayoffAggregateScore | PlayoffAggregateScore | NULL | No | Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first legs home team. |
Season
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SeasonId | integer (32) | NOT NULL | No | The unique ID of the season |
| CompetitionId | integer (32) | NOT NULL | No | The unique ID of the competition |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| Name | string (50) | NOT NULL | No | The display name of the season (e.g. 2017/2018; 2018/19; etc) |
| CompetitionName | string (50) | NOT NULL | No | The display name of the competition associated with this season |
| StartDate | date | NULL | No | The start date of the season |
| EndDate | date | NULL | No | The end date of the season (UTC) |
| CurrentSeason | boolean | NOT NULL | No | Indicates whether or not this season is the current season of the competition |
| Rounds | Round[] | NULL | No | The unique ID of the round that this season is associated with |
SeasonTeam
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SeasonTeamId | integer (32) | NOT NULL | No | Unique ID of this season/team combination |
| SeasonId | integer (32) | NOT NULL | No | The unique ID of the season this record is associated with |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team |
| TeamName | string (50) | NOT NULL | No | The name of the team associated with this record |
| Active | boolean | NOT NULL | No | Whether this team is actively associated with this season (true/false) |
| Gender | string (10) | NULL | No | The gender of the players on the team. Possible Values: Male; Female |
| Type | string (10) | NULL | No | The type of season/team. Possible values: Club; National |
| Team | Team | NULL | No | The details of the team for the given season/team association |
Sportsbook
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SportsbookID | int (32) | NOT NULL | No | The unique ID of the sportsbook |
| Name | string (50) | NOT NULL | Yes | The name of the sportsbook |
Standing
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StandingId | integer (32) | NOT NULL | No | The unique ID of the standing |
| RoundId | integer (32) | NOT NULL | No | The unique ID of the round that this team is associated with |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team |
| Name | string (100) | NULL | No | The team's full name |
| ShortName | string (50) | NULL | No | The short name of the team |
| Scope | string (20) | NULL | No | The scope of the standing (possible values: Total, Away, Home) |
| [Order] | integer (32) | NULL | No | The order of the teams in the standing (e.g 1; 2; 3; 4; etc.) |
| Games | integer (32) | NULL | No | Total number of games played by the team in the season |
| Wins | integer (32) | NULL | No | Number of wins by the team in the season |
| Losses | integer (32) | NULL | No | The number of losses for the team |
| Draws | integer (32) | NULL | No | Number of draws by the team in the season |
| GoalsScored | integer (32) | NULL | No | Total number of goals scored by the team in the season |
| GoalsAgainst | integer (32) | NULL | No | Total number of goals against by the team in the season |
| GoalsDifferential | integer (32) | NULL | No | The goal differential of the team in the season. Note: GoalDifferential = GoalsScored - GoalsAgainst |
| Points | integer (32) | NULL | No | Total points accumulated by the team |
| Group | string (50) | NULL | No | The name of the group (when applicable) |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
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 |
| AreaId | integer (32) | NULL | No | The unique ID of the team's current home arena |
| VenueId | integer (32) | NULL | No | The unique ID of the team's venue |
| [Key] | string (10) | NULL | No | Abbreviation of the team (e.g. LIV; ARS; MNU; etc.) |
| Name | string (50) | NOT NULL | No | The mascot of the team (e.g. The Reds, The Gunners, etc.) |
| FullName | string (100) | NULL | No | The full name of the team (e.g. Liverpool Football Club, Arsenal Football Club, etc.) |
| Active | boolean | NOT NULL | No | Whether or not this team is active (true/false) |
| AreaName | string (50) | NULL | No | The area name of the home team |
| VenueName | string (50) | NULL | No | The name of the home team's venue |
| Gender | string (10) | NULL | No | The gender of the players on the team. Possible Values: Male; Female |
| Type | string (10) | NULL | No | The type of this team. Possible values: Club, National |
| Address | string (100) | NULL | No | The address of the home team |
| City | string (50) | NULL | No | The city of the home team |
| Zip | string (50) | NULL | No | The zip code of the team's home location |
| Phone | string (50) | NULL | No | The phone number of the home team |
| Fax | string (50) | NULL | No | The fax number of the home team |
| Website | string (50) | NULL | No | The website address of the home team |
| string (50) | NULL | No | The email of the home team | |
| Founded | integer (32) | NULL | No | The calendar year that the team was founded |
| ClubColor1 | string (50) | NULL | No | The primary color of this team's logo/uniform/branding |
| ClubColor2 | string (50) | NULL | No | The secondary color of this team's logo/uniform/branding |
| ClubColor3 | string (50) | NULL | No | The tertiary color of this team's logo/uniform/branding |
| Nickname1 | string (50) | NULL | No | A nickname for this team |
| Nickname2 | string (50) | NULL | No | A nickname for this team |
| Nickname3 | string (50) | NULL | No | A nickname for this team |
| WikipediaLogoUrl | string (250) | NULL | No | The link to the team's logo hosted on Wikipedia (This is not licensed for public or commercial use) |
| WikipediaWordMarkUrl | string (250) | NULL | No | The link to the team's wordmark logo hosted on Wikipedia (This is not licensed for public or commercial use) |
| GlobalTeamId | integer (32) | NOT NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| FifaCountryCode | string (32) | NULL | No | The official FIFA country code, for national teams only. |
TeamDetail
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Players | Player[] | NULL | No | The players who are current on this team's active roster/squad |
| TeamId | integer (32) | NOT NULL | No | The unique ID of the team |
| AreaId | integer (32) | NULL | No | The unique ID of the team's current home arena |
| VenueId | integer (32) | NULL | No | The unique ID of the team's venue |
| [Key] | string (10) | NULL | No | Abbreviation of the team (e.g. LIV; ARS; MNU; etc.) |
| Name | string (50) | NOT NULL | No | The mascot of the team (e.g. The Reds, The Gunners, etc.) |
| FullName | string (100) | NULL | No | The full name of the team (e.g. Liverpool Football Club, Arsenal Football Club, Minnesota United FC, etc.) |
| Active | boolean | NOT NULL | No | Whether or not this team is active (true/false) |
| AreaName | string (50) | NULL | No | The area name of the home team |
| VenueName | string (50) | NULL | No | The name of the home team's venue |
| Gender | string (10) | NULL | No | The gender of the players on the team. Possible Values: Male; Female |
| Type | string (10) | NULL | No | The type of this team. Possible values: Club, National |
| Address | string (100) | NULL | No | The address of the home team |
| City | string (50) | NULL | No | The city of the home team |
| Zip | string (50) | NULL | No | The zip code of the team's home location |
| Phone | string (50) | NULL | No | The phone number of the home team |
| Fax | string (50) | NULL | No | The fax number of the home team |
| Website | string (50) | NULL | No | The website address of the home team |
| string (50) | NULL | No | The email of the home team | |
| Founded | integer (32) | NULL | No | The calendar year that the team was founded |
| ClubColor1 | string (50) | NULL | No | The primary color of this team's logo/uniform/branding |
| ClubColor2 | string (50) | NULL | No | The secondary color of this team's logo/uniform/branding |
| ClubColor3 | string (50) | NULL | No | The tertiary color of this team's logo/uniform/branding |
| Nickname1 | string (50) | NULL | No | A nickname for this team |
| Nickname2 | string (50) | NULL | No | A nickname for this team |
| Nickname3 | string (50) | NULL | No | A nickname for this team |
| WikipediaLogoUrl | string (250) | NULL | No | The link to the team's logo hosted on Wikipedia (This is not licensed for public or commercial use) |
| WikipediaWordMarkUrl | string (250) | NULL | No | The link to the team's wordmark logo hosted on Wikipedia (This is not licensed for public or commercial use) |
| GlobalTeamId | integer (32) | NOT NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| FifaCountryCode | string (32) | NULL | No | The official FIFA country code, for national teams only. |
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 associated with this team |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this team is associated with |
| TeamId | integer (32) | NULL | No | The unique ID of the team |
| Name | string (100) | NULL | No | The team's full name |
| Team | string (50) | NULL | No | The abbreviation [Key] of 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. |
| Possession | decimal (32) | NULL | No | Percentage of ball possession by the team in the game |
| Corners | decimal (32) | NULL | Yes | Total number of corner kicks taken by the team in the game |
| GameId | integer (32) | NULL | No | The unique ID of the game |
| OpponentId | integer (32) | NULL | No | The unique ID of the opponent team |
| Opponent | string (10) | NULL | No | The name of the opponent team |
| 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 the home team or away team |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true) or not (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 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 (in US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total number of games played by the team in the game |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the team in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsMondogoal | decimal (32) | NULL | Yes | Total Mondogoal daily fantasy points scored by the team in the game |
| Minutes | decimal (32) | NULL | Yes | Total minutes played by the team in the game |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the team in the game |
| Assists | decimal (32) | NULL | Yes | Total assists scored by the team in the game |
| Shots | decimal (32) | NULL | Yes | Total shots attempted by the team in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal attempted by the team in the game |
| YellowCards | decimal (32) | NULL | Yes | Total yellow cards against the team in the game |
| RedCards | decimal (32) | NULL | Yes | Total red cards against by the team in the game |
| YellowRedCards | decimal (32) | NULL | Yes | Total double yellow cards against the team in the game. Note: A double yellow card results in a red card |
| Crosses | decimal (32) | NULL | Yes | Total crosses by the team in the game. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal |
| TacklesWon | decimal (32) | NULL | Yes | Total tackles won by the team in the game |
| Interceptions | decimal (32) | NULL | Yes | Total interceptions made by the team in the game |
| OwnGoals | decimal (32) | NULL | Yes | Total goals scored against own team by the team in the game |
| Fouls | decimal (32) | NULL | Yes | Total fouls made by the team in the game |
| Fouled | decimal (32) | NULL | Yes | Total times the team was fouled in the game |
| Offsides | decimal (32) | NULL | Yes | Total offsides against by the team in the game |
| Passes | decimal (32) | NULL | Yes | Total passes attempted by the team in the game |
| PassesCompleted | decimal (32) | NULL | Yes | Total passes completed by the team in the game |
| LastManTackle | decimal (32) | NULL | Yes | Total tackles made by the team when there is no one else available to stop the opponent from scoring in the game |
| CornersWon | decimal (32) | NULL | Yes | Total number of corner kicks won by the team in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total shots blocked by the team in the game |
| Touches | decimal (32) | NULL | Yes | Total times the team touched the ball in the game |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total defender clean sheets by the team in the game. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes) |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total saves made by team's goalkeeper(s) in the game |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by team's goalkeeper(s) in the game |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total games where the team's goalkeeper(s) allowed exactly one goal in the game |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total number of clean sheets by the team's goalkeeper(s) in the game. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total wins by the team's goalkeeper(s) in the game |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total penalty kick goals scored by the team in the game |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total penalty kicks missed by the team in the game |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total penalty kicks saved by the team in the game |
| PenaltiesWon | decimal (32) | NULL | Yes | Total penalties won by the team in the game |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total penalties conceded by the team in the game |
| Score | decimal (32) | NULL | Yes | Total goals scored by the team in the game |
| OpponentScore | decimal (32) | NULL | Yes | Total goals allowed by the opponent team in the game |
| Tackles | decimal (32) | NULL | Yes | Total tackles by the team in the game |
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 associated with this team |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
| Season | integer (32) | NOT NULL | No | The soccer regular season for which these totals apply |
| RoundId | integer (32) | NULL | No | The unique ID of the round that this team is associated with |
| TeamId | integer (32) | NULL | No | The unique ID of the team |
| Name | string (100) | NULL | No | The team's full name |
| Team | string (50) | NULL | No | The abbreviation [Key] of 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. |
| Possession | decimal (32) | NULL | No | Percentage of ball possession by the team in the season |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| UpdatedUtc | datetime | NULL | No | The timestamp of when the record was last updated (in UTC Time) |
| Games | integer (32) | NULL | No | Total number of games played by the team in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points scored by the team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsMondogoal | decimal (32) | NULL | Yes | Total Mondogoal daily fantasy points scored by the team in the season |
| Minutes | decimal (32) | NULL | Yes | Total minutes played by the team in the season |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the team in the season |
| Assists | decimal (32) | NULL | Yes | Total assists scored by the team in the season |
| Shots | decimal (32) | NULL | Yes | Total shots attempted by the team in the season |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal attempted by the team in the season |
| YellowCards | decimal (32) | NULL | Yes | Total yellow cards against the team in the season |
| RedCards | decimal (32) | NULL | Yes | Total red cards against by the team in the season |
| YellowRedCards | decimal (32) | NULL | Yes | Total double yellow cards against the team in the season. Note: A double yellow card results in a red card |
| Crosses | decimal (32) | NULL | Yes | Total crosses by the team in the season. Note: a cross means a pass from a wide area of the field towards the center of the field near the opponent's goal |
| TacklesWon | decimal (32) | NULL | Yes | Total tackles won by the team in the season |
| Interceptions | decimal (32) | NULL | Yes | Total interceptions made by the team in the season |
| OwnGoals | decimal (32) | NULL | Yes | Total goals scored against own team by the team in the season |
| Fouls | decimal (32) | NULL | Yes | Total fouls made by the team in the season |
| Fouled | decimal (32) | NULL | Yes | Total times the team was fouled in the season |
| Offsides | decimal (32) | NULL | Yes | Total offsides against by the team in the season |
| Passes | decimal (32) | NULL | Yes | Total passes attempted by the team in the season |
| PassesCompleted | decimal (32) | NULL | Yes | Total passes completed by the team in the season |
| LastManTackle | decimal (32) | NULL | Yes | Total tackles made by the team when there is no one else available to stop the opponent from scoring in the season |
| CornersWon | decimal (32) | NULL | Yes | Total corner kicks awarded to the team in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total shots blocked by the team in the season |
| Touches | decimal (32) | NULL | Yes | Total times the team touched the ball in the season |
| DefenderCleanSheets | decimal (32) | NULL | Yes | Total defender clean sheets by the team in the season. Note: clean sheets are awarded when zero goals were allowed to the opponent and the player played at least 60 minutes) |
| GoalkeeperSaves | decimal (32) | NULL | Yes | Total saves made by team's goalkeeper(s) in the season |
| GoalkeeperGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by team's goalkeeper(s) in the season |
| GoalkeeperSingleGoalAgainst | decimal (32) | NULL | Yes | Total games where the team's goalkeeper(s) allowed exactly one goal in the season |
| GoalkeeperCleanSheets | decimal (32) | NULL | Yes | Total number of clean sheets by the team's goalkeeper(s) in the season. Note: Awarded when zero goals were allowed to the opponent and the player played at least 60 minutes |
| GoalkeeperWins | decimal (32) | NULL | Yes | Total wins by the team's goalkeeper(s) in the season |
| PenaltyKickGoals | decimal (32) | NULL | Yes | Total penalty kick goals scored by the team in the season |
| PenaltyKickMisses | decimal (32) | NULL | Yes | Total penalty kicks missed by the team in the season |
| PenaltyKickSaves | decimal (32) | NULL | Yes | Total penalty kicks saved by the team in the season |
| PenaltiesWon | decimal (32) | NULL | Yes | Total penalties won by the team in the season |
| PenaltiesConceded | decimal (32) | NULL | Yes | Total penalties conceded by the team in the season |
| Score | decimal (32) | NULL | Yes | Total goals scored by the team in the season |
| OpponentScore | decimal (32) | NULL | Yes | Total goals allowed by the team in the season |
| Tackles | decimal (32) | NULL | Yes | Total tackles by the team in the season |
Venue
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| VenueId | integer (32) | NOT NULL | No | The unique ID of the venue |
| Name | string (50) | NOT NULL | No | The full name of the venue |
| Address | string (100) | NULL | No | The address where the venue is located |
| City | string (50) | NULL | No | The city where the venue is located |
| Zip | string (50) | NULL | No | The zip code of where the venue is located |
| Country | string (50) | NULL | No | The country name of where the venue is located |
| [Open] | boolean | NOT NULL | No | Indicates whether this venue is actively used |
| Opened | integer (32) | NULL | No | The year the venue opened (e.g. 1950; 1960; etc) |
| Nickname1 | string (100) | NULL | No | A nickname for this venue |
| Nickname2 | string (100) | NULL | No | A nickname for this venue |
| Capacity | integer (32) | NULL | No | The estimated seating capacity of the venue |
| Surface | string (50) | NULL | No | The playing surface of the stadium. Possible values: Grass; Artificial |
| GeoLat | decimal (32) | NULL | No | The geographic latitude coordinate of this venue |
| GeoLong | decimal (32) | NULL | No | The geographic latitude coordinate of this venue |