SportsDataIO API Maintenance is Completed Read More
SportsDataIO API Maintenance is Completed Read More

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.

Choose League:

  • {{ category.Name }}
Expand All Collapse All Download CSV

Base

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
AreaId integer 32 No No Yes The unique ID of the area
CountryCode string 10 No No Yes The country code of the area
Name string 50 No No Yes The display name of the area
Competitions Competition[] Yes No Yes The competitions that are associated with and/or played in the area
This table is used in the following endpoints:
Soccer v3 Scores
Canceled Memberships
Name Type Size Nullable Scrambled CSV Description
CanceledMembershipId
from 2019 		integer 32 No No Yes Unique ID of the canceled membership.
MembershipId
from 2019 		integer 32 No No Yes 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 No No Yes The Team Id related to this canceled membership.
PlayerID
from 2019 		integer 32 No No Yes The Player Id related to this canceled membership.
Created
from 2019 		datetime No No Yes The date and time when this Canceled Membership was created.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
CompetitionId integer 32 No No Yes The unique ID of the competition/league
AreaId integer 32 No No Yes The unique ID of the area where this competition/league is played
AreaName string 50 Yes No Yes The display name of the area where this competition/league is played
Name string 50 No No Yes The display name of the competition/league
Gender string 10 Yes No Yes Indicates the gender of the players on this team (possible values: Male, Female)
Type string 10 Yes No Yes The type of this competition/league (possible values: Club, International)
Format string 50 Yes No Yes The format of the competition/league (possible values: Domestic League, International Cup)
Seasons Season[] Yes No Yes The seasons associated with this competition/league
Key string 5 Yes No Yes The unique string key of the competition/league
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
CurrentSeason Season Yes No Yes The current active season for this competition/league
Teams TeamDetail[] Yes No Yes The active teams associated with this competition/league
Games Game[] Yes No Yes The complete schedule for the current season of this competition/league
CompetitionId integer 32 No No Yes The unique ID of the competition/league
AreaId integer 32 No No Yes The unique ID of the area where this competition/league is played
AreaName string 50 Yes No Yes The display name of the area where this competition/league is played
Name string 50 No No Yes The display name of the competition/league
Gender string 10 Yes No Yes Indicates the gender of the players on this team (possible values: Male, Female)
Type string 10 Yes No Yes The type of this competition/league (possible values: Club, International)
Format string 50 Yes No Yes The format of the competition/league (possible values: Domestic League, International Cup)
Seasons Season[] Yes No Yes The seasons associated with this competition/league
Key string 5 Yes No Yes The unique string key of the competition/league
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId integer 32 No No Yes The unique ID of the game.
RoundId integer 32 No No Yes The RoundId of the round that this game is associated with.
Season integer 32 No No Yes The calendar year of the season during which this game occurs.
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Group string 50 Yes No Yes The name of the group in which this game occurs. This is used in tournaments / cups.
AwayTeamId integer 32 Yes No Yes The TeamId of the away team.
HomeTeamId integer 32 Yes No Yes The TeamId of the home team.
VenueId integer 32 Yes No Yes The VenueId of the venue.
Day date Yes No Yes The day that the game is scheduled to be played in UTC.
DateTime datetime Yes No Yes The date/time that the game is scheduled to be played in UTC.
Status string 10 Yes No Yes Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended. 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 Yes No Yes The week during the season/round in which this game occurs.
Period string 20 Yes No Yes 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 Yes No Yes The clock for the game if it is in progress. If the games hasn't started or the game is over, then this will be NULL.
Winner string 10 Yes Yes Yes The winner of the game. Possible values include: AwayTeam, HomeTeam, Draw
VenueType string 10 Yes No Yes Indicates home field advantage. Possible values include: Home Away, Neutral
AwayTeamKey string 10 Yes No Yes The abbreviation of the away team.
AwayTeamName string 50 Yes No Yes The name of the away team.
AwayTeamCountryCode string 10 Yes No Yes The country code of the away team.
AwayTeamScore integer 32 Yes Yes Yes The final score of the away team.
AwayTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the away team.
AwayTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the away team.
AwayTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the away team (if applicable).
AwayTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the away team (if applicable).
HomeTeamKey string 10 Yes No Yes The abbreviation of the home team.
HomeTeamName string 50 Yes No Yes The name of the home team.
HomeTeamCountryCode string 10 Yes No Yes The country code of the home team.
HomeTeamScore integer 32 Yes Yes Yes The final score of the home team.
HomeTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the home team.
HomeTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the home team.
HomeTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the home team (if applicable).
HomeTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the home team (if applicable).
HomeTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the home team wins.
AwayTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the away team wins.
DrawMoneyLine integer 32 Yes Yes Yes Payout on a bet that the game is a draw.
PointSpread decimal 32 Yes Yes Yes Point spread for the home team. This is updated once daily at 4:00 AM ET.
HomeTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the home team beats the spread. This is updated once daily at 4:00 AM ET.
AwayTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the away team beats the spread. This is updated once daily at 4:00 AM ET.
OverUnder decimal 32 Yes Yes Yes Over/Under total goals for the game. This is updated once daily at 4:00 AM ET.
OverPayout integer 32 Yes Yes Yes Payout for the over bet. This is updated once daily at 4:00 AM ET.
UnderPayout integer 32 Yes Yes Yes Payout for the under bet. This is updated once daily at 4:00 AM ET.
Attendance integer 32 Yes No Yes The attendance for the game.
Updated datetime Yes No Yes The timestamp of when this record was updated, based on US Eatern Time (EST/EDT).
UpdatedUtc datetime Yes No Yes The timestamp of when this record was updated, based on Universal Coordinated Time (UTC).
GlobalGameId integer 32 No No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalAwayTeamId integer 32 Yes No No A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues.
GlobalHomeTeamId integer 32 Yes No No A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues.
ClockExtra integer 32 Yes No Yes The added stoppage time minute the game is currently in. Will be null when game is not in stoppage time.
ClockDisplay string 50 Yes No Yes A convienience string display of the current clock with format Clock+ClockExtra (ex 90+3)
IsClosed boolean Yes No Yes Indicates whether the game is over and the final score and stats have been verified and closed out
HomeTeamFormation string 20 Yes No Yes The formation for the home team (4-4-2, 4-3-3, etc.).
AwayTeamFormation string 20 Yes No Yes The formation for the away team (4-4-2, 4-3-3, etc.)
PlayoffAggregateScore PlayoffAggregateScore Yes No Yes Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first leg’s home team.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
MembershipId integer 32 No No Yes The unique ID for the membership
TeamId integer 32 No No Yes The unique ID for the team
PlayerId integer 32 No No Yes The player's unique PlayerID as assigned by FantasyData.
PlayerName string 100 Yes No Yes The full name of the player.
TeamName string 50 Yes No Yes Name of the team
TeamArea string 50 Yes No Yes Area of the team
Active boolean No No Yes Whether the membership is active (true/false)
StartDate datetime Yes No Yes The start date of the membership (UTC)
EndDate datetime Yes No Yes The end date of the membership (UTC)
Updated datetime Yes No Yes The updated date and time of the membership (EST/EDT)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
PlayerId integer 32 No No Yes The player's unique PlayerID as assigned by FantasyData.
FirstName string 50 Yes No Yes The player's first name.
LastName string 50 Yes No Yes The player's last name.
CommonName string 100 Yes No Yes The player's common name.
ShortName string 50 Yes No Yes The player's short name.
Position string 10 Yes No Yes The position of the player. Possible values include: A (Attacker), M (Midfielder), D (Defender), GK (Goalkeeper)
PositionCategory string 10 Yes No Yes The player's position category. 
Jersey integer 32 Yes No Yes The player's jersey number.
Foot string 10 Yes No Yes The primary foot of the player. Possible values: left or right
Height integer 32 Yes No Yes The player's height in cm.
Weight integer 32 Yes No Yes The player's weight in kg.
Gender string 10 Yes No Yes The gender of the player.
BirthDate datetime Yes No Yes The player's date of birth.
BirthCity string 50 Yes No Yes The city in which the player was born.
BirthCountry string 50 Yes No Yes The country in which the player was born.
Nationality string 50 Yes No Yes The nationality of the player.
InjuryStatus string 50 Yes Yes Yes Indicates the player's injury status. Possible values include: Questionable, Out
InjuryBodyPart string 100 Yes Yes Yes The body part that is injured (Knee, Groin, Calf, Hamstring, etc.)
InjuryNotes string 250 Yes Yes Yes Not yet supported, will be null.
InjuryStartDate date Yes No Yes The day that the injury started or first discovered.
Updated datetime Yes No Yes The date and time the player's status was updated. (EST/EDT)
PhotoUrl string 100 Yes No Yes The url of the player's photo.
RotoWirePlayerID integer 32 Yes No Yes The player's cross reference PlayerID to the RotoWire news feed.
DraftKingsPosition string 50 Yes No Yes The position of the player according to DraftKings.
UsaTodayPlayerID integer 32 Yes No Yes The player's cross reference PlayerID to USA Today headshot data feeds.
UsaTodayHeadshotUrl string 100 Yes No Yes The player's headshot URL as provided by USA Today. License from USA Today is required.
UsaTodayHeadshotNoBackgroundUrl string 100 Yes No Yes The player's transparent background headshot URL as provided by USA Today. License from USA Today is required.
UsaTodayHeadshotUpdated datetime Yes No Yes The last updated date of the player's headshot as provided by USA Today. License from USA Today is required.
UsaTodayHeadshotNoBackgroundUpdated datetime Yes No Yes The last updated date of the player's transparent background headshot as provided by USA Today. License from USA Today is required.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
TeamA_Id
from 2020 		integer 32 No No Yes Id of one of the teams. 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 No No Yes Aggregate score of team A.
TeamB_Id
from 2020 		integer 32 No No Yes Id of one of the teams. 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 No No Yes Aggregate score of team A.
WinningTeamId
from 2020 		integer 32 No No Yes Team Id of the team which wins the home-and-home matchup.
Created
from 2020 		datetime No No Yes Date and time the record was created.
Updated
from 2020 		datetime No No Yes Date and time the record was updated.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
RoundId integer 32 No No Yes The unique ID of the round
SeasonId integer 32 No No Yes The unique ID of the season this round is associated with
Season integer 32 No No Yes The soccer season for which these totals apply
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Name string 50 No No Yes The display name of the round (examples: Regular Season, Semi-finals, Final, etc)
Type string 50 Yes No Yes The type of this round. Possible values include: Cup, Table
StartDate date Yes No Yes The start date of the round (UTC)
EndDate date Yes No Yes The end date of the round (UTC)
CurrentWeek integer 32 Yes No Yes The current week that this round is in
CurrentRound boolean No No Yes Indicates whether or not this round is the current round of the competition/season
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SeasonId integer 32 No No Yes The unique ID of the season
CompetitionId integer 32 No No Yes The unique ID of the competition
Season integer 32 No No Yes The soccer regular season for which these totals apply
Name string 50 No No Yes The display name of the season (example: 2017/2018, 2018-19, etc)
CompetitionName string 50 No No Yes The display name of the competition associated with this season
StartDate date Yes No Yes The start date of the season (UTC)
EndDate date Yes No Yes The end date of the season (UTC)
CurrentSeason boolean No No Yes Indicates whether or not this season is the current season of the competition
Rounds Round[] Yes No Yes The rounds associated with this season
This table is used in the following endpoints:
Soccer v3 Scores
Season Teams
Name Type Size Nullable Scrambled CSV Description
SeasonTeamId integer 32 No No Yes Unique ID of this season/team combination
SeasonId integer 32 No No Yes Unique ID of the season associated with this record
TeamId integer 32 No No Yes Unique ID of the team associated with this record
TeamName string 50 No No Yes The name of the team associated with this record
Active boolean No No Yes Whether this team is actively associated with this season
Gender string 10 Yes No Yes Indicates the gender of the players on this team (possible values: Make, Female)
Type string 10 Yes No Yes The type of this season/team (possible values: Club, National)
Team Team Yes No Yes The team details of this season/team association
This table is used in the following endpoints:
Soccer v3 Scores
Standings
Name Type Size Nullable Scrambled CSV Description
StandingId integer 32 No No Yes The unique ID of the standing
RoundId integer 32 No No Yes The unique ID of the round
TeamId integer 32 No No Yes The unique ID of the team
Name string 100 Yes No Yes The full name of the team
ShortName string 50 Yes No Yes The short name of the team
Scope string 20 Yes No Yes The scope of the standing (possible values: Total, Away, Home)
[Order] integer 32 Yes No Yes The order of the teams in the standing (e.g 1, 2, 3, 4, etc.)
Games integer 32 Yes No Yes Number of games played
Wins integer 32 Yes No Yes Number of wins
Losses integer 32 Yes No Yes Number of losses
Draws integer 32 Yes No Yes Number of draws
GoalsScored integer 32 Yes No Yes Number of goals scored
GoalsAgainst integer 32 Yes No Yes Number of goals against
GoalsDifferential integer 32 Yes No Yes Total goal differential
Points integer 32 Yes No Yes Total points accumulated
Group string 50 Yes No Yes The name of the group (when applicable)
GlobalTeamID integer 32 Yes No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
This table is used in the following endpoints:
Soccer v3 Scores
Teams, Season Teams
Name Type Size Nullable Scrambled CSV Description
TeamId integer 32 No No Yes The auto-generated unique ID of the Team
AreaId integer 32 Yes No Yes The unique ID of the team's current home arena
VenueId integer 32 Yes No Yes The unique ID of the team's current home venue
[Key] string 10 Yes No Yes Abbreviation of the team (e.g. LIV, ARS, etc.)
Name string 50 No No Yes The mascot of the team (e.g. The Reds, The Gunners, etc.)
FullName string 100 Yes No Yes The full name of the team (e.g. Liverpool Football Club, Arsenal Football Club, etc.)
Active boolean No No Yes Whether or not this team is active
AreaName string 50 Yes No Yes The area name of the home team
VenueName string 50 Yes No Yes The venue name of the home team
Gender string 10 Yes No Yes Indicates the gender of the players on this team (possible values: Make, Female)
Type string 10 Yes No Yes The type of this team. Possible values: Club, National
Address string 100 Yes No Yes The address of the home team
City string 50 Yes No Yes The city of the home team
Zip string 50 Yes No Yes The zip code of the home team
Phone string 50 Yes No Yes The phone number of the home team
Fax string 50 Yes No Yes The fax number of the home team
Website string 50 Yes No Yes The website address of the home team
Email string 50 Yes No Yes The email of the home team
Founded integer 32 Yes No Yes The year the team was founded (e.g. 1950, 1960, etc.)
ClubColor1 string 50 Yes No Yes The primary color of this team's logo/uniform/branding
ClubColor2 string 50 Yes No Yes The secondary color of this team's logo/uniform/branding
ClubColor3 string 50 Yes No Yes The tertiary color of this team's logo/uniform/branding
Nickname1 string 50 Yes No Yes A nickname for this team
Nickname2 string 50 Yes No Yes A nickname for this team
Nickname3 string 50 Yes No Yes A nickname for this team
WikipediaLogoUrl string 250 Yes No Yes The link to the team's logo hosted on Wikipedia. (This is not licensed for public or commercial use)
WikipediaWordMarkUrl string 250 Yes No Yes The link to the team's wordmark logo hosted on Wikipedia. (This is not licensed for public or commercial use)
GlobalTeamId integer 32 No No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
Players Player[] Yes No Yes The players who are current on this team's active roster/squad
TeamId integer 32 No No Yes The auto-generated unique ID of the Team
AreaId integer 32 Yes No Yes The unique ID of the team's current home arena
VenueId integer 32 Yes No Yes The unique ID of the team's current home venue
[Key] string 10 Yes No Yes Abbreviation of the team (e.g. LIV, ARS, etc.)
Name string 50 No No Yes The mascot of the team (e.g. The Reds, The Gunners, etc.)
FullName string 100 Yes No Yes The full name of the team (e.g. Liverpool Football Club, Arsenal Football Club, etc.)
Active boolean No No Yes Whether or not this team is active
AreaName string 50 Yes No Yes The area name of the home team
VenueName string 50 Yes No Yes The venue name of the home team
Gender string 10 Yes No Yes Indicates the gender of the players on this team (possible values: Make, Female)
Type string 10 Yes No Yes The type of this team. Possible values: Club, National
Address string 100 Yes No Yes The address of the home team
City string 50 Yes No Yes The city of the home team
Zip string 50 Yes No Yes The zip code of the home team
Phone string 50 Yes No Yes The phone number of the home team
Fax string 50 Yes No Yes The fax number of the home team
Website string 50 Yes No Yes The website address of the home team
Email string 50 Yes No Yes The email of the home team
Founded integer 32 Yes No Yes The year the team was founded (e.g. 1950, 1960, etc.)
ClubColor1 string 50 Yes No Yes The primary color of this team's logo/uniform/branding
ClubColor2 string 50 Yes No Yes The secondary color of this team's logo/uniform/branding
ClubColor3 string 50 Yes No Yes The tertiary color of this team's logo/uniform/branding
Nickname1 string 50 Yes No Yes A nickname for this team
Nickname2 string 50 Yes No Yes A nickname for this team
Nickname3 string 50 Yes No Yes A nickname for this team
WikipediaLogoUrl string 250 Yes No Yes The link to the team's logo hosted on Wikipedia. (This is not licensed for public or commercial use)
WikipediaWordMarkUrl string 250 Yes No Yes The link to the team's wordmark logo hosted on Wikipedia. (This is not licensed for public or commercial use)
GlobalTeamId integer 32 No No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
This table is used in the following endpoints:
Soccer v3 Scores
Venues
Name Type Size Nullable Scrambled CSV Description
VenueId integer 32 No No Yes The unique ID of the venue
Name string 50 No No Yes The full name of the venue
Address string 100 Yes No Yes The address where the venue is located
City string 50 Yes No Yes The city where the venue is located
Zip string 50 Yes No Yes The zip code of the venue
Country string 50 Yes No Yes The 2-digit country code where the venue is located
[Open] boolean No No Yes Indicates whether this venue is actively used
Opened integer 32 Yes No Yes The year the venue opened (e.g. 1950, 1960, etc)
Nickname1 string 100 Yes No Yes A nickname for this venue
Nickname2 string 100 Yes No Yes A nickname for this venue
Capacity integer 32 Yes No Yes The estimated seating capacity of the venue
Surface string 50 Yes No Yes The playing surface of the stadium (Grass or Artificial)
GeoLat decimal 32 Yes No Yes The geographic latitude coordinate of this venue.
GeoLong decimal 32 Yes No Yes The geographic longitude coordinate of this venue.

Tier 1: Scores

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId integer 32 No No Yes The unique ID of the game.
RoundId integer 32 No No Yes The RoundId of the round that this game is associated with.
Season integer 32 No No Yes The calendar year of the season during which this game occurs.
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Group string 50 Yes No Yes The name of the group in which this game occurs. This is used in tournaments / cups.
AwayTeamId integer 32 Yes No Yes The TeamId of the away team.
HomeTeamId integer 32 Yes No Yes The TeamId of the home team.
VenueId integer 32 Yes No Yes The VenueId of the venue.
Day date Yes No Yes The day that the game is scheduled to be played in UTC.
DateTime datetime Yes No Yes The date/time that the game is scheduled to be played in UTC.
Status string 10 Yes No Yes Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended. 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 Yes No Yes The week during the season/round in which this game occurs.
Period string 20 Yes No Yes 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 Yes No Yes The clock for the game if it is in progress. If the games hasn't started or the game is over, then this will be NULL.
Winner string 10 Yes Yes Yes The winner of the game. Possible values include: AwayTeam, HomeTeam, Draw
VenueType string 10 Yes No Yes Indicates home field advantage. Possible values include: Home Away, Neutral
AwayTeamKey string 10 Yes No Yes The abbreviation of the away team.
AwayTeamName string 50 Yes No Yes The name of the away team.
AwayTeamCountryCode string 10 Yes No Yes The country code of the away team.
AwayTeamScore integer 32 Yes Yes Yes The final score of the away team.
AwayTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the away team.
AwayTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the away team.
AwayTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the away team (if applicable).
AwayTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the away team (if applicable).
HomeTeamKey string 10 Yes No Yes The abbreviation of the home team.
HomeTeamName string 50 Yes No Yes The name of the home team.
HomeTeamCountryCode string 10 Yes No Yes The country code of the home team.
HomeTeamScore integer 32 Yes Yes Yes The final score of the home team.
HomeTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the home team.
HomeTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the home team.
HomeTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the home team (if applicable).
HomeTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the home team (if applicable).
HomeTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the home team wins.
AwayTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the away team wins.
DrawMoneyLine integer 32 Yes Yes Yes Payout on a bet that the game is a draw.
PointSpread decimal 32 Yes Yes Yes Point spread for the home team. This is updated once daily at 4:00 AM ET.
HomeTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the home team beats the spread. This is updated once daily at 4:00 AM ET.
AwayTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the away team beats the spread. This is updated once daily at 4:00 AM ET.
OverUnder decimal 32 Yes Yes Yes Over/Under total goals for the game. This is updated once daily at 4:00 AM ET.
OverPayout integer 32 Yes Yes Yes Payout for the over bet. This is updated once daily at 4:00 AM ET.
UnderPayout integer 32 Yes Yes Yes Payout for the under bet. This is updated once daily at 4:00 AM ET.
Attendance integer 32 Yes No Yes The attendance for the game.
Updated datetime Yes No Yes The timestamp of when this record was updated, based on US Eatern Time (EST/EDT).
UpdatedUtc datetime Yes No Yes The timestamp of when this record was updated, based on Universal Coordinated Time (UTC).
GlobalGameId integer 32 No No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalAwayTeamId integer 32 Yes No No A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues.
GlobalHomeTeamId integer 32 Yes No No A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues.
ClockExtra integer 32 Yes No Yes The added stoppage time minute the game is currently in. Will be null when game is not in stoppage time.
ClockDisplay string 50 Yes No Yes A convienience string display of the current clock with format Clock+ClockExtra (ex 90+3)
IsClosed boolean Yes No Yes Indicates whether the game is over and the final score and stats have been verified and closed out
HomeTeamFormation string 20 Yes No Yes The formation for the home team (4-4-2, 4-3-3, etc.).
AwayTeamFormation string 20 Yes No Yes The formation for the away team (4-4-2, 4-3-3, etc.)
PlayoffAggregateScore PlayoffAggregateScore Yes No Yes Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first leg’s home team.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
TeamA_Id
from 2020 		integer 32 No No Yes Id of one of the teams. 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 No No Yes Aggregate score of team A.
TeamB_Id
from 2020 		integer 32 No No Yes Id of one of the teams. 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 No No Yes Aggregate score of team A.
WinningTeamId
from 2020 		integer 32 No No Yes Team Id of the team which wins the home-and-home matchup.
Created
from 2020 		datetime No No Yes Date and time the record was created.
Updated
from 2020 		datetime No No Yes Date and time the record was updated.

Tier 2: Team Stats

This table is used in the following endpoints:
Soccer v3 Scores
Team Game Stats by Date
Name Type Size Nullable Scrambled CSV Description
StatId integer 32 No No Yes The unique ID of the stat
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Season integer 32 No No Yes The soccer season of the game
RoundId integer 32 Yes No Yes The unique ID of the round
TeamId integer 32 Yes No Yes The unique ID of the team
Name string 100 Yes No Yes Team's name
Team string 50 Yes No Yes The abbreviation of the Team
GlobalTeamId integer 32 Yes No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
Possession decimal 32 Yes No Yes Percentage of ball possession for this game
GameId integer 32 Yes No Yes The unique ID of this game
OpponentId integer 32 Yes No Yes The unique ID of the team's opponent
Opponent string 10 Yes No Yes The name of the opponent 
Day date Yes No Yes The day of the game
DateTime datetime Yes No Yes The date and time of the game (UTC)
HomeOrAway string 4 Yes No Yes Whether the team is home or away
IsGameOver boolean No No Yes Whether the game is over (true/false)
GlobalGameId integer 32 Yes No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalOpponentId integer 32 Yes No Yes A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues.
Updated datetime Yes No Yes The timestamp of when the record was last updated (US Eastern Time)
UpdatedUtc datetime Yes No Yes The timestamp of when the record was last updated (UTC Time)
Games integer 32 Yes No Yes The number of games played
FantasyPoints decimal 32 Yes Yes Yes Total fantasy points
FantasyPointsFanDuel decimal 32 Yes Yes Yes Total Fan Duel daily fantasy points scored
FantasyPointsDraftKings decimal 32 Yes Yes Yes Total Draft Kings daily fantasy points scored
FantasyPointsYahoo decimal 32 Yes Yes Yes Total Yahoo daily fantasy points scored
FantasyPointsMondogoal decimal 32 Yes Yes Yes Total Mondogoal fantasy points scored
Minutes decimal 32 Yes Yes Yes Total minutes played
Goals decimal 32 Yes Yes Yes Total goals scored
Assists decimal 32 Yes Yes Yes Total assists scored
Shots decimal 32 Yes Yes Yes Total shots attempted
ShotsOnGoal decimal 32 Yes Yes Yes Total shots on goal attempted
YellowCards decimal 32 Yes Yes Yes Total yellow cards against
RedCards decimal 32 Yes Yes Yes Total red cards against
YellowRedCards decimal 32 Yes Yes Yes Total double yellow cards against (which result in a red card)
Crosses decimal 32 Yes Yes Yes Total passes from a wide area of the field towards the center of the field near the opponent's goal
TacklesWon decimal 32 Yes Yes Yes Total tackles won
Interceptions decimal 32 Yes Yes Yes Total interceptions made
OwnGoals decimal 32 Yes Yes Yes Total goals scored against own team (accidentally)
Fouls decimal 32 Yes Yes Yes Total fouls made
Fouled decimal 32 Yes Yes Yes Total times fouled
Offsides decimal 32 Yes Yes Yes Total offsides against
Passes decimal 32 Yes Yes Yes Total passes attempted
PassesCompleted decimal 32 Yes Yes Yes Total passes completed successfully to teammate
LastManTackle decimal 32 Yes Yes Yes Total tackles made when there is no one else available to stop the opponent from scoring (this can be the goalkeeper)
CornersWon decimal 32 Yes Yes Yes Total corner kicks awarded
BlockedShots decimal 32 Yes Yes Yes Total shots blocked
Touches decimal 32 Yes Yes Yes Total times this player touched the ball
DefenderCleanSheets decimal 32 Yes Yes Yes Total defender clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperSaves decimal 32 Yes Yes Yes Total saves made by goalkeeper
GoalkeeperGoalsAgainst decimal 32 Yes Yes Yes Total goals allowed by goalkeeper
GoalkeeperSingleGoalAgainst decimal 32 Yes Yes Yes Total games where this goalkeeper allowed exactly one goal
GoalkeeperCleanSheets decimal 32 Yes Yes Yes Total goalkeeper clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperWins decimal 32 Yes Yes Yes Total goalkeeper wins (awarded when zero goals were allowed to the opponent and the player played at least 45 minutes)
PenaltyKickGoals decimal 32 Yes Yes Yes Total penalty kick goals
PenaltyKickMisses decimal 32 Yes Yes Yes Total penalty kick misses
PenaltyKickSaves decimal 32 Yes Yes Yes Total penalty kick saves
PenaltiesWon decimal 32 Yes Yes Yes Total penalties won
PenaltiesConceded decimal 32 Yes Yes Yes Total penalties conceded
Score decimal 32 Yes Yes Yes Goals scored by entire team
OpponentScore decimal 32 Yes Yes Yes Goals allowed to opponent
This table is used in the following endpoints:
Soccer v3 Scores
Team Season Stats
Name Type Size Nullable Scrambled CSV Description
StatId integer 32 No No Yes The unique ID of the stat
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Season integer 32 No No Yes The soccer regular season for which these totals apply
RoundId integer 32 Yes No Yes The unique ID of the round
TeamId integer 32 Yes No Yes The unique ID of the team
Name string 100 Yes No Yes Team name
Team string 50 Yes No Yes The abbreviation of the Team
GlobalTeamId integer 32 Yes No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
Possession decimal 32 Yes No Yes Percentage of ball possession, per game, for this season.
Updated datetime Yes No Yes The timestamp of when the record was last updated (US Eastern Time)
UpdatedUtc datetime Yes No Yes The timestamp of when the record was last updated (UTC Time)
Games integer 32 Yes No Yes The number of games played
FantasyPoints decimal 32 Yes Yes Yes Total fantasy points
FantasyPointsFanDuel decimal 32 Yes Yes Yes Total Fan Duel daily fantasy points scored
FantasyPointsDraftKings decimal 32 Yes Yes Yes Total Draft Kings daily fantasy points scored
FantasyPointsYahoo decimal 32 Yes Yes Yes Total Yahoo daily fantasy points scored
FantasyPointsMondogoal decimal 32 Yes Yes Yes Total Mondogoal fantasy points scored
Minutes decimal 32 Yes Yes Yes Total minutes played
Goals decimal 32 Yes Yes Yes Total goals scored
Assists decimal 32 Yes Yes Yes Total assists scored
Shots decimal 32 Yes Yes Yes Total shots attempted
ShotsOnGoal decimal 32 Yes Yes Yes Total shots on goal attempted
YellowCards decimal 32 Yes Yes Yes Total yellow cards against
RedCards decimal 32 Yes Yes Yes Total red cards against
YellowRedCards decimal 32 Yes Yes Yes Total double yellow cards against (which result in a red card)
Crosses decimal 32 Yes Yes Yes Total passes from a wide area of the field towards the center of the field near the opponent's goal
TacklesWon decimal 32 Yes Yes Yes Total tackles won
Interceptions decimal 32 Yes Yes Yes Total interceptions made
OwnGoals decimal 32 Yes Yes Yes Total goals scored against own team (accidentally)
Fouls decimal 32 Yes Yes Yes Total fouls made
Fouled decimal 32 Yes Yes Yes Total times fouled
Offsides decimal 32 Yes Yes Yes Total offsides against
Passes decimal 32 Yes Yes Yes Total passes attempted
PassesCompleted decimal 32 Yes Yes Yes Total passes completed successfully to teammate
LastManTackle decimal 32 Yes Yes Yes Total tackles made when there is no one else available to stop the opponent from scoring (this can be the goalkeeper)
CornersWon decimal 32 Yes Yes Yes Total corner kicks awarded
BlockedShots decimal 32 Yes Yes Yes Total shots blocked
Touches decimal 32 Yes Yes Yes Total times this player touched the ball
DefenderCleanSheets decimal 32 Yes Yes Yes Total defender clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperSaves decimal 32 Yes Yes Yes Total saves made by goalkeeper
GoalkeeperGoalsAgainst decimal 32 Yes Yes Yes Total goals allowed by goalkeeper
GoalkeeperSingleGoalAgainst decimal 32 Yes Yes Yes Total games where this goalkeeper allowed exactly one goal
GoalkeeperCleanSheets decimal 32 Yes Yes Yes Total goalkeeper clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperWins decimal 32 Yes Yes Yes Total goalkeeper wins (awarded when zero goals were allowed to the opponent and the player played at least 45 minutes)
PenaltyKickGoals decimal 32 Yes Yes Yes Total penalty kick goals
PenaltyKickMisses decimal 32 Yes Yes Yes Total penalty kick misses
PenaltyKickSaves decimal 32 Yes Yes Yes Total penalty kick saves
PenaltiesWon decimal 32 Yes Yes Yes Total penalties won
PenaltiesConceded decimal 32 Yes Yes Yes Total penalties conceded
Score decimal 32 Yes Yes Yes Goals scored by entire team
OpponentScore decimal 32 Yes Yes Yes Goals allowed to opponent

Tier 3: Player Stats

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
BookingId integer 32 No No Yes The unique ID of the booking
GameId integer 32 No No Yes The unique ID of the game
Type string 20 No No Yes The type of booking. Possible values: Yellow Card, Red Card, Yellow Red Card
TeamId integer 32 No No Yes The unique ID of the team
PlayerId integer 32 Yes No Yes The player's unique PlayerID as assigned by FantasyData
Name string 100 Yes No Yes The name of the player who was booked 
GameMinute integer 32 Yes No Yes The minute in the game in which the booking occurred
GameMinuteExtra integer 32 Yes No Yes The extra minute in the game in which the booking occurred
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
Game Game Yes No Yes The game details associated with this box score
AwayTeamCoach Coach Yes No Yes The coach of the away team
HomeTeamCoach Coach Yes No Yes The coach of the home team
MainReferee Referee Yes No Yes The main referee
AssistantReferee1 Referee Yes No Yes The first assistant referee
AssistantReferee2 Referee Yes No Yes The second assistant referee
FourthReferee Referee Yes No Yes The fourth referee
AdditionalAssistantReferee1 Referee Yes No Yes The first additional assistant referee
AdditionalAssistantReferee2 Referee Yes No Yes The second additional assistant referee
Lineups Lineup[] Yes No Yes The details of the lineups for each team
Goals Goal[] Yes No Yes The details of the goals scored during this game
Bookings Booking[] Yes No Yes The details of the bookings (yellow/red cards) recorded during this game
PenaltyShootouts PenaltyShootout[] Yes No Yes The details of the penalty shootouts recorded during this game
TeamGames TeamGame[] Yes No Yes The team stats for this game
PlayerGames PlayerGame[] Yes No Yes The player stats for this game
VideoAssistantReferee Referee Yes No Yes The referee in charge of the video reviews (VAR)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
CoachId integer 32 No No Yes The unique ID of the coach
FirstName string 50 Yes No Yes Coach's first name
LastName string 50 Yes No Yes Coach's last name
ShortName string 50 Yes No Yes Coach's short name
Nationality string 50 Yes No Yes Coach's nationality
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId integer 32 No No Yes The unique ID of the game.
RoundId integer 32 No No Yes The RoundId of the round that this game is associated with.
Season integer 32 No No Yes The calendar year of the season during which this game occurs.
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Group string 50 Yes No Yes The name of the group in which this game occurs. This is used in tournaments / cups.
AwayTeamId integer 32 Yes No Yes The TeamId of the away team.
HomeTeamId integer 32 Yes No Yes The TeamId of the home team.
VenueId integer 32 Yes No Yes The VenueId of the venue.
Day date Yes No Yes The day that the game is scheduled to be played in UTC.
DateTime datetime Yes No Yes The date/time that the game is scheduled to be played in UTC.
Status string 10 Yes No Yes Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended. 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 Yes No Yes The week during the season/round in which this game occurs.
Period string 20 Yes No Yes 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 Yes No Yes The clock for the game if it is in progress. If the games hasn't started or the game is over, then this will be NULL.
Winner string 10 Yes Yes Yes The winner of the game. Possible values include: AwayTeam, HomeTeam, Draw
VenueType string 10 Yes No Yes Indicates home field advantage. Possible values include: Home Away, Neutral
AwayTeamKey string 10 Yes No Yes The abbreviation of the away team.
AwayTeamName string 50 Yes No Yes The name of the away team.
AwayTeamCountryCode string 10 Yes No Yes The country code of the away team.
AwayTeamScore integer 32 Yes Yes Yes The final score of the away team.
AwayTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the away team.
AwayTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the away team.
AwayTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the away team (if applicable).
AwayTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the away team (if applicable).
HomeTeamKey string 10 Yes No Yes The abbreviation of the home team.
HomeTeamName string 50 Yes No Yes The name of the home team.
HomeTeamCountryCode string 10 Yes No Yes The country code of the home team.
HomeTeamScore integer 32 Yes Yes Yes The final score of the home team.
HomeTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the home team.
HomeTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the home team.
HomeTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the home team (if applicable).
HomeTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the home team (if applicable).
HomeTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the home team wins.
AwayTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the away team wins.
DrawMoneyLine integer 32 Yes Yes Yes Payout on a bet that the game is a draw.
PointSpread decimal 32 Yes Yes Yes Point spread for the home team. This is updated once daily at 4:00 AM ET.
HomeTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the home team beats the spread. This is updated once daily at 4:00 AM ET.
AwayTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the away team beats the spread. This is updated once daily at 4:00 AM ET.
OverUnder decimal 32 Yes Yes Yes Over/Under total goals for the game. This is updated once daily at 4:00 AM ET.
OverPayout integer 32 Yes Yes Yes Payout for the over bet. This is updated once daily at 4:00 AM ET.
UnderPayout integer 32 Yes Yes Yes Payout for the under bet. This is updated once daily at 4:00 AM ET.
Attendance integer 32 Yes No Yes The attendance for the game.
Updated datetime Yes No Yes The timestamp of when this record was updated, based on US Eatern Time (EST/EDT).
UpdatedUtc datetime Yes No Yes The timestamp of when this record was updated, based on Universal Coordinated Time (UTC).
GlobalGameId integer 32 No No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalAwayTeamId integer 32 Yes No No A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues.
GlobalHomeTeamId integer 32 Yes No No A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues.
ClockExtra integer 32 Yes No Yes The added stoppage time minute the game is currently in. Will be null when game is not in stoppage time.
ClockDisplay string 50 Yes No Yes A convienience string display of the current clock with format Clock+ClockExtra (ex 90+3)
IsClosed boolean Yes No Yes Indicates whether the game is over and the final score and stats have been verified and closed out
HomeTeamFormation string 20 Yes No Yes The formation for the home team (4-4-2, 4-3-3, etc.).
AwayTeamFormation string 20 Yes No Yes The formation for the away team (4-4-2, 4-3-3, etc.)
PlayoffAggregateScore PlayoffAggregateScore Yes No Yes Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first leg’s home team.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GoalId integer 32 No No Yes The unique ID of the goal
GameId integer 32 No No Yes The unique ID of the game
TeamId integer 32 No No Yes The unique ID of the team that scored the goal
PlayerId integer 32 Yes No Yes The player's unique PlayerID as assigned by FantasyData
Name string 100 Yes No Yes The name of the player
Type string 20 Yes No Yes The type of goal scored
AssistedByPlayerId1 integer 32 Yes No Yes The unique ID of the first assisted player
AssistedByPlayerName1 string 100 Yes Yes Yes The player's name of the first assisted player
AssistedByPlayerId2 integer 32 Yes No Yes The unique ID of the second assisted player
AssistedByPlayerName2 string 100 Yes Yes Yes The player's name of the second assisted player
GameMinute integer 32 Yes Yes Yes The minute in the game in which the goal was scored
GameMinuteExtra integer 32 Yes Yes Yes The extra minute in the game in which the goal was scored
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
LineupId integer 32 No No Yes The unique ID of the lineup 
GameId integer 32 No No Yes The unique ID of the game
Type string 20 No No Yes The player's status in the lineup. Possible values: Substitute In, Starter, Bench
TeamId integer 32 No No Yes The unique ID of the team
PlayerId integer 32 No No Yes The player's unique PlayerID as assigned by FantasyData
Name string 100 No No Yes The name of the player in the lineup
Position string 10 Yes No Yes The position of the player
ReplacedPlayerId integer 32 Yes No Yes The unique ID of the replaced player
ReplacedPlayerName string 100 Yes No Yes The name of the replaced player
GameMinute integer 32 Yes No Yes The minute of the game
GameMinuteExtra integer 32 Yes No Yes The extra minute of the game
PitchPositionHorizontal integer 32 Yes No Yes The pitch position of where this player lined up on the field. 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 Yes No Yes The pitch position of where this player lined up on the field. 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.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
PenaltyShootoutId integer 32 No No Yes The unique ID of the penalty shootout
GameId integer 32 No No Yes The unique ID of the game
Type string 10 No No Yes The result of this penalty shootout kick. Possible values: Goal, Miss
TeamId integer 32 No No Yes The unique ID of the team
PlayerId integer 32 Yes No Yes The player's unique PlayerID as assigned by FantasyData
Name string 100 Yes No Yes The name of the player in the penalty shootout
Position string 10 Yes No Yes The position of the player in the penalty shootout
Order integer 32 No No Yes The order of the penalty shootout
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
StatId integer 32 No No Yes The unique ID of the stat
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Season integer 32 No No Yes The soccer season of the game
RoundId integer 32 Yes No Yes The unique ID of the round
TeamId integer 32 Yes No Yes The unique ID of the team
PlayerId integer 32 Yes No Yes Unique ID assigned to each player that stays with them throughout their career
Name string 100 Yes No Yes Player's name
ShortName string 50 Yes No Yes The short name of the player
Team string 50 Yes No Yes The abbreviation of the Team
PositionCategory string 10 Yes No Yes The player's position category. 
Position string 10 Yes No Yes The position of the player. Possible values include: A (Attacker), M (Midfielder), D (Defender), GK (Goalkeeper)
Jersey integer 32 Yes No Yes The player's jersey number.
Started integer 32 Yes No Yes Number of games the player started
Captain boolean Yes No Yes Whether the player is a captain (true/false
Suspension boolean Yes No Yes Whether the player is suspended (true/false)
SuspensionReason string 20 Yes No Yes The reason for the suspension
FanDuelSalary integer 32 Yes Yes Yes The player's salary for FanDuel daily fantasy contests.
DraftKingsSalary integer 32 Yes Yes Yes The player's salary for DraftKings daily fantasy contests.
YahooSalary integer 32 Yes Yes Yes The player's salary for Yahoo daily fantasy contests.
MondogoalSalary integer 32 Yes Yes Yes The player's salary for Mondogoal daily fantasy contests.
FanDuelPosition string 10 Yes Yes Yes The player's eligible position in FanDuel's daily fantasy sports platform.
DraftKingsPosition string 10 Yes Yes Yes The player's eligible position in DraftKings' daily fantasy sports platform.
YahooPosition string 10 Yes Yes Yes The player's eligible position in Yahoo's daily fantasy sports platform.
MondogoalPosition string 10 Yes Yes Yes The player's eligible position in Mondogoal's daily fantasy sports platform.
InjuryStatus string 50 Yes Yes Yes Indicates the player's injury status. Possible values include: Questionable, Out
InjuryBodyPart string 100 Yes Yes Yes The body part that is injured (Knee, Groin, Calf, Hamstring, etc.)
InjuryNotes string 250 Yes Yes Yes Not yet supported, will be null.
InjuryStartDate date Yes No Yes The day that the injury started or first discovered.
GlobalTeamId integer 32 Yes No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
GameId integer 32 Yes No Yes The unique ID of this game
OpponentId integer 32 Yes No Yes The unique ID of the team's opponent
Opponent string 10 Yes No Yes The name of the opponent 
Day date Yes No Yes The day of the game
DateTime datetime Yes No Yes The date and time of the game (UTC)
HomeOrAway string 4 Yes No Yes Whether the team is home or away
IsGameOver boolean No No Yes Whether the game is over (true/false)
GlobalGameId integer 32 Yes No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalOpponentId integer 32 Yes No Yes A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues.
Updated datetime Yes No Yes The timestamp of when the record was last updated (US Eastern Time)
UpdatedUtc datetime Yes No Yes The timestamp of when the record was last updated (UTC Time)
Games integer 32 Yes No Yes The number of games played
FantasyPoints decimal 32 Yes Yes Yes Total fantasy points
FantasyPointsFanDuel decimal 32 Yes Yes Yes Total Fan Duel daily fantasy points scored
FantasyPointsDraftKings decimal 32 Yes Yes Yes Total Draft Kings daily fantasy points scored
FantasyPointsYahoo decimal 32 Yes Yes Yes Total Yahoo daily fantasy points scored
FantasyPointsMondogoal decimal 32 Yes Yes Yes Total Mondogoal fantasy points scored
Minutes decimal 32 Yes Yes Yes Total minutes played
Goals decimal 32 Yes Yes Yes Total goals scored
Assists decimal 32 Yes Yes Yes Total assists scored
Shots decimal 32 Yes Yes Yes Total shots attempted
ShotsOnGoal decimal 32 Yes Yes Yes Total shots on goal attempted
YellowCards decimal 32 Yes Yes Yes Total yellow cards against
RedCards decimal 32 Yes Yes Yes Total red cards against
YellowRedCards decimal 32 Yes Yes Yes Total double yellow cards against (which result in a red card)
Crosses decimal 32 Yes Yes Yes Total passes from a wide area of the field towards the center of the field near the opponent's goal
TacklesWon decimal 32 Yes Yes Yes Total tackles won
Interceptions decimal 32 Yes Yes Yes Total interceptions made
OwnGoals decimal 32 Yes Yes Yes Total goals scored against own team (accidentally)
Fouls decimal 32 Yes Yes Yes Total fouls made
Fouled decimal 32 Yes Yes Yes Total times fouled
Offsides decimal 32 Yes Yes Yes Total offsides against
Passes decimal 32 Yes Yes Yes Total passes attempted
PassesCompleted decimal 32 Yes Yes Yes Total passes completed successfully to teammate
LastManTackle decimal 32 Yes Yes Yes Total tackles made when there is no one else available to stop the opponent from scoring (this can be the goalkeeper)
CornersWon decimal 32 Yes Yes Yes Total corner kicks awarded
BlockedShots decimal 32 Yes Yes Yes Total shots blocked
Touches decimal 32 Yes Yes Yes Total times this player touched the ball
DefenderCleanSheets decimal 32 Yes Yes Yes Total defender clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperSaves decimal 32 Yes Yes Yes Total saves made by goalkeeper
GoalkeeperGoalsAgainst decimal 32 Yes Yes Yes Total goals allowed by goalkeeper
GoalkeeperSingleGoalAgainst decimal 32 Yes Yes Yes Total games where this goalkeeper allowed exactly one goal
GoalkeeperCleanSheets decimal 32 Yes Yes Yes Total goalkeeper clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperWins decimal 32 Yes Yes Yes Total goalkeeper wins (awarded when zero goals were allowed to the opponent and the player played at least 45 minutes)
PenaltyKickGoals decimal 32 Yes Yes Yes Total penalty kick goals
PenaltyKickMisses decimal 32 Yes Yes Yes Total penalty kick misses
PenaltyKickSaves decimal 32 Yes Yes Yes Total penalty kick saves
PenaltiesWon decimal 32 Yes Yes Yes Total penalties won
PenaltiesConceded decimal 32 Yes Yes Yes Total penalties conceded
Score decimal 32 Yes Yes Yes Goals scored by entire team
OpponentScore decimal 32 Yes Yes Yes Goals allowed to opponent
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
StatId integer 32 No No Yes The unique ID of the stat
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Season integer 32 No No Yes The soccer regular season for which these totals apply
RoundId integer 32 Yes No Yes The unique ID of the round
TeamId integer 32 Yes No Yes The unique ID of the player's team
PlayerId integer 32 Yes No Yes Unique ID assigned to each player that stays with them throughout their career
Name string 100 Yes No Yes Player's name
ShortName string 50 Yes No Yes The short name of the player
Team string 50 Yes No Yes The abbreviation of the Team
PositionCategory string 10 Yes No Yes The player's position category. 
Position string 10 Yes No Yes The position of the player. Possible values include: A (Attacker), M (Midfielder), D (Defender), GK (Goalkeeper)
Started integer 32 Yes No Yes Number of games started
GlobalTeamId integer 32 Yes No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
Updated datetime Yes No Yes The timestamp of when the record was last updated (US Eastern Time)
UpdatedUtc datetime Yes No Yes The timestamp of when the record was last updated (UTC Time)
Games integer 32 Yes No Yes The number of games played
FantasyPoints decimal 32 Yes Yes Yes Total fantasy points
FantasyPointsFanDuel decimal 32 Yes Yes Yes Total Fan Duel daily fantasy points scored
FantasyPointsDraftKings decimal 32 Yes Yes Yes Total Draft Kings daily fantasy points scored
FantasyPointsYahoo decimal 32 Yes Yes Yes Total Yahoo daily fantasy points scored
FantasyPointsMondogoal decimal 32 Yes Yes Yes Total Mondogoal fantasy points scored
Minutes decimal 32 Yes Yes Yes Total minutes played
Goals decimal 32 Yes Yes Yes Total goals scored
Assists decimal 32 Yes Yes Yes Total assists scored
Shots decimal 32 Yes Yes Yes Total shots attempted
ShotsOnGoal decimal 32 Yes Yes Yes Total shots on goal attempted
YellowCards decimal 32 Yes Yes Yes Total yellow cards against
RedCards decimal 32 Yes Yes Yes Total red cards against
YellowRedCards decimal 32 Yes Yes Yes Total double yellow cards against (which result in a red card)
Crosses decimal 32 Yes Yes Yes Total passes from a wide area of the field towards the center of the field near the opponent's goal
TacklesWon decimal 32 Yes Yes Yes Total tackles won
Interceptions decimal 32 Yes Yes Yes Total interceptions made
OwnGoals decimal 32 Yes Yes Yes Total goals scored against own team (accidentally)
Fouls decimal 32 Yes Yes Yes Total fouls made
Fouled decimal 32 Yes Yes Yes Total times fouled
Offsides decimal 32 Yes Yes Yes Total offsides against
Passes decimal 32 Yes Yes Yes Total passes attempted
PassesCompleted decimal 32 Yes Yes Yes Total passes completed successfully to teammate
LastManTackle decimal 32 Yes Yes Yes Total tackles made when there is no one else available to stop the opponent from scoring (this can be the goalkeeper)
CornersWon decimal 32 Yes Yes Yes Total corner kicks awarded
BlockedShots decimal 32 Yes Yes Yes Total shots blocked
Touches decimal 32 Yes Yes Yes Total times this player touched the ball
DefenderCleanSheets decimal 32 Yes Yes Yes Total defender clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperSaves decimal 32 Yes Yes Yes Total saves made by goalkeeper
GoalkeeperGoalsAgainst decimal 32 Yes Yes Yes Total goals allowed by goalkeeper
GoalkeeperSingleGoalAgainst decimal 32 Yes Yes Yes Total games where this goalkeeper allowed exactly one goal
GoalkeeperCleanSheets decimal 32 Yes Yes Yes Total goalkeeper clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperWins decimal 32 Yes Yes Yes Total goalkeeper wins (awarded when zero goals were allowed to the opponent and the player played at least 45 minutes)
PenaltyKickGoals decimal 32 Yes Yes Yes Total penalty kick goals
PenaltyKickMisses decimal 32 Yes Yes Yes Total penalty kick misses
PenaltyKickSaves decimal 32 Yes Yes Yes Total penalty kick saves
PenaltiesWon decimal 32 Yes Yes Yes Total penalties won
PenaltiesConceded decimal 32 Yes Yes Yes Total penalties conceded
Score decimal 32 Yes Yes Yes Goals scored by entire team
OpponentScore decimal 32 Yes Yes Yes Goals allowed to opponent
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
TeamA_Id
from 2020 		integer 32 No No Yes Id of one of the teams. 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 No No Yes Aggregate score of team A.
TeamB_Id
from 2020 		integer 32 No No Yes Id of one of the teams. 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 No No Yes Aggregate score of team A.
WinningTeamId
from 2020 		integer 32 No No Yes Team Id of the team which wins the home-and-home matchup.
Created
from 2020 		datetime No No Yes Date and time the record was created.
Updated
from 2020 		datetime No No Yes Date and time the record was updated.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
RefereeId integer 32 No No Yes The unique ID of the referee
FirstName string 50 Yes No Yes Referee's first name
LastName string 50 Yes No Yes Referee's last name
ShortName string 50 Yes No Yes Referee's short name
Nationality string 50 Yes No Yes Referee's nationality
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
StatId integer 32 No No Yes The unique ID of the stat
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Season integer 32 No No Yes The soccer season of the game
RoundId integer 32 Yes No Yes The unique ID of the round
TeamId integer 32 Yes No Yes The unique ID of the team
Name string 100 Yes No Yes Team's name
Team string 50 Yes No Yes The abbreviation of the Team
GlobalTeamId integer 32 Yes No No A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues.
Possession decimal 32 Yes No Yes Percentage of ball possession for this game
GameId integer 32 Yes No Yes The unique ID of this game
OpponentId integer 32 Yes No Yes The unique ID of the team's opponent
Opponent string 10 Yes No Yes The name of the opponent 
Day date Yes No Yes The day of the game
DateTime datetime Yes No Yes The date and time of the game (UTC)
HomeOrAway string 4 Yes No Yes Whether the team is home or away
IsGameOver boolean No No Yes Whether the game is over (true/false)
GlobalGameId integer 32 Yes No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalOpponentId integer 32 Yes No Yes A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues.
Updated datetime Yes No Yes The timestamp of when the record was last updated (US Eastern Time)
UpdatedUtc datetime Yes No Yes The timestamp of when the record was last updated (UTC Time)
Games integer 32 Yes No Yes The number of games played
FantasyPoints decimal 32 Yes Yes Yes Total fantasy points
FantasyPointsFanDuel decimal 32 Yes Yes Yes Total Fan Duel daily fantasy points scored
FantasyPointsDraftKings decimal 32 Yes Yes Yes Total Draft Kings daily fantasy points scored
FantasyPointsYahoo decimal 32 Yes Yes Yes Total Yahoo daily fantasy points scored
FantasyPointsMondogoal decimal 32 Yes Yes Yes Total Mondogoal fantasy points scored
Minutes decimal 32 Yes Yes Yes Total minutes played
Goals decimal 32 Yes Yes Yes Total goals scored
Assists decimal 32 Yes Yes Yes Total assists scored
Shots decimal 32 Yes Yes Yes Total shots attempted
ShotsOnGoal decimal 32 Yes Yes Yes Total shots on goal attempted
YellowCards decimal 32 Yes Yes Yes Total yellow cards against
RedCards decimal 32 Yes Yes Yes Total red cards against
YellowRedCards decimal 32 Yes Yes Yes Total double yellow cards against (which result in a red card)
Crosses decimal 32 Yes Yes Yes Total passes from a wide area of the field towards the center of the field near the opponent's goal
TacklesWon decimal 32 Yes Yes Yes Total tackles won
Interceptions decimal 32 Yes Yes Yes Total interceptions made
OwnGoals decimal 32 Yes Yes Yes Total goals scored against own team (accidentally)
Fouls decimal 32 Yes Yes Yes Total fouls made
Fouled decimal 32 Yes Yes Yes Total times fouled
Offsides decimal 32 Yes Yes Yes Total offsides against
Passes decimal 32 Yes Yes Yes Total passes attempted
PassesCompleted decimal 32 Yes Yes Yes Total passes completed successfully to teammate
LastManTackle decimal 32 Yes Yes Yes Total tackles made when there is no one else available to stop the opponent from scoring (this can be the goalkeeper)
CornersWon decimal 32 Yes Yes Yes Total corner kicks awarded
BlockedShots decimal 32 Yes Yes Yes Total shots blocked
Touches decimal 32 Yes Yes Yes Total times this player touched the ball
DefenderCleanSheets decimal 32 Yes Yes Yes Total defender clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperSaves decimal 32 Yes Yes Yes Total saves made by goalkeeper
GoalkeeperGoalsAgainst decimal 32 Yes Yes Yes Total goals allowed by goalkeeper
GoalkeeperSingleGoalAgainst decimal 32 Yes Yes Yes Total games where this goalkeeper allowed exactly one goal
GoalkeeperCleanSheets decimal 32 Yes Yes Yes Total goalkeeper clean sheets (awarded when zero goals were allowed to the opponent and the player played at least 60 minutes)
GoalkeeperWins decimal 32 Yes Yes Yes Total goalkeeper wins (awarded when zero goals were allowed to the opponent and the player played at least 45 minutes)
PenaltyKickGoals decimal 32 Yes Yes Yes Total penalty kick goals
PenaltyKickMisses decimal 32 Yes Yes Yes Total penalty kick misses
PenaltyKickSaves decimal 32 Yes Yes Yes Total penalty kick saves
PenaltiesWon decimal 32 Yes Yes Yes Total penalties won
PenaltiesConceded decimal 32 Yes Yes Yes Total penalties conceded
Score decimal 32 Yes Yes Yes Goals scored by entire team
OpponentScore decimal 32 Yes Yes Yes Goals allowed to opponent

Fantasy

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SlateID integer 32 No No Yes Unique ID of a Slate (assigned by FantasyData).
Operator string 20 Yes No Yes The name of the operator who is running contests for this slate. Possible values: FanDuel, DraftKings, Yahoo, FantasyDraft, etc.
OperatorSlateID integer 32 Yes No Yes Unique ID of a slate (assigned by the operator).
OperatorName string 50 Yes No Yes The name of the slate (assigned by the operator). Possible values: Main, Express, Arcade, Late Night, etc.
OperatorDay date Yes No Yes The day (in UTC) that the slate begins (assigned by the operator).
OperatorStartTime datetime Yes No Yes The date/time (in UTC) that the slate begins (assigned by the operator).
NumberOfGames integer 32 Yes No Yes The number of actual games that this slate covers.
IsMultiDaySlate boolean Yes No Yes Whether this slate uses games that take place on different days.
RemovedByOperator boolean Yes No Yes Indicates whether this slate was removed/deleted by the operator.
OperatorGameType string 50 Yes No Yes The game type of the slate. Will often be null as most operators only have one game type.
DfsSlateGames DfsSlateGame[] Yes No Yes The games that are included in this slate
DfsSlatePlayers DfsSlatePlayer[] Yes No Yes The players that are included in this slate
SlateRosterSlots string[] Yes No Yes The positions that need to be filled for this particular slate
SalaryCap integer Yes No Yes The salary cap for the current slate (is null for slates with no salary cap such a Tiers gametypes)
CompetitionId integer Yes No Yes The Id of the competition related to this slate (Premier League, Champions League, etc.)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SlateGameID integer 32 No No Yes Unique ID of a SlateGame (assigned by FantasyData).
SlateID integer 32 No No Yes The SlateID that this SlateGame refers to.
GameID integer 32 Yes No Yes The FantasyData GameID that this SlateGame refers to. This points to data in the respective sports' schedule/game/box score feeds.
Game Game Yes No Yes The details of the Game that this SlateGame refers to.
OperatorGameID integer 32 Yes No Yes Unique ID of a SlateGame (assigned by the operator).
RemovedByOperator boolean Yes Yes Yes Indicates whether this game was removed/deleted by the operator.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SlatePlayerID integer 32 No No Yes Unique ID of a SlatePlayer (assigned by FantasyData).
SlateID integer 32 No No Yes The SlateID that this SlatePlayer refers to.
SlateGameID integer 32 Yes No Yes The SlateGameID that this SlatePlayer refers to.
PlayerID integer 32 Yes No Yes The FantasyData PlayerID that this SlatePlayer refers to. This points to data in the respective sports' player feeds.
PlayerGameProjectionStatID integer 32 Yes No Yes The FantasyData StatID that this SlatePlayer refers to. This points to data in the respective sports' projected player game stats feeds.
OperatorPlayerID string 25 Yes No Yes Unique ID of the Player (assigned by the operator).
OperatorSlatePlayerID string 50 Yes No Yes Unique ID of the SlatePlayer (assigned by the operator).
OperatorPlayerName string 50 Yes No Yes The player's name (assigned by the operator).
OperatorPosition string 10 Yes No Yes The player's eligible positions for the contest (assigned by the operator).
OperatorSalary integer 32 Yes No Yes The player's salary for the contest (assigned by the operator).
OperatorRosterSlots string[] Yes No Yes The player's eligible positions to be played in the contest (assigned by the operator). This would include UTIL, etc plays for those that are eligible.
RemovedByOperator boolean Yes Yes Yes Indicates whether this player was removed/deleted by the operator.
Team string 12 Yes No Yes Name of the team to which the player is associated.
TeamID integer 32 Yes No Yes Unique ID of the Team to which the player is associated.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId integer 32 No No Yes The unique ID of the game.
RoundId integer 32 No No Yes The RoundId of the round that this game is associated with.
Season integer 32 No No Yes The calendar year of the season during which this game occurs.
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Group string 50 Yes No Yes The name of the group in which this game occurs. This is used in tournaments / cups.
AwayTeamId integer 32 Yes No Yes The TeamId of the away team.
HomeTeamId integer 32 Yes No Yes The TeamId of the home team.
VenueId integer 32 Yes No Yes The VenueId of the venue.
Day date Yes No Yes The day that the game is scheduled to be played in UTC.
DateTime datetime Yes No Yes The date/time that the game is scheduled to be played in UTC.
Status string 10 Yes No Yes Indicates the game's status. Possible values include: Scheduled, InProgress, Break, Final, Awarded, Postponed, Canceled, Suspended. 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 Yes No Yes The week during the season/round in which this game occurs.
Period string 20 Yes No Yes 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 Yes No Yes The clock for the game if it is in progress. If the games hasn't started or the game is over, then this will be NULL.
Winner string 10 Yes Yes Yes The winner of the game. Possible values include: AwayTeam, HomeTeam, Draw
VenueType string 10 Yes No Yes Indicates home field advantage. Possible values include: Home Away, Neutral
AwayTeamKey string 10 Yes No Yes The abbreviation of the away team.
AwayTeamName string 50 Yes No Yes The name of the away team.
AwayTeamCountryCode string 10 Yes No Yes The country code of the away team.
AwayTeamScore integer 32 Yes Yes Yes The final score of the away team.
AwayTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the away team.
AwayTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the away team.
AwayTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the away team (if applicable).
AwayTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the away team (if applicable).
HomeTeamKey string 10 Yes No Yes The abbreviation of the home team.
HomeTeamName string 50 Yes No Yes The name of the home team.
HomeTeamCountryCode string 10 Yes No Yes The country code of the home team.
HomeTeamScore integer 32 Yes Yes Yes The final score of the home team.
HomeTeamScorePeriod1 integer 32 Yes Yes Yes The first period score of the home team.
HomeTeamScorePeriod2 integer 32 Yes Yes Yes The second period score of the home team.
HomeTeamScoreExtraTime integer 32 Yes Yes Yes The extra time (overtime) score of the home team (if applicable).
HomeTeamScorePenalty integer 32 Yes Yes Yes The penalty shootout score of the home team (if applicable).
HomeTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the home team wins.
AwayTeamMoneyLine integer 32 Yes Yes Yes Payout on a bet that the away team wins.
DrawMoneyLine integer 32 Yes Yes Yes Payout on a bet that the game is a draw.
PointSpread decimal 32 Yes Yes Yes Point spread for the home team. This is updated once daily at 4:00 AM ET.
HomeTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the home team beats the spread. This is updated once daily at 4:00 AM ET.
AwayTeamPointSpreadPayout integer 32 Yes Yes Yes Payout if the away team beats the spread. This is updated once daily at 4:00 AM ET.
OverUnder decimal 32 Yes Yes Yes Over/Under total goals for the game. This is updated once daily at 4:00 AM ET.
OverPayout integer 32 Yes Yes Yes Payout for the over bet. This is updated once daily at 4:00 AM ET.
UnderPayout integer 32 Yes Yes Yes Payout for the under bet. This is updated once daily at 4:00 AM ET.
Attendance integer 32 Yes No Yes The attendance for the game.
Updated datetime Yes No Yes The timestamp of when this record was updated, based on US Eatern Time (EST/EDT).
UpdatedUtc datetime Yes No Yes The timestamp of when this record was updated, based on Universal Coordinated Time (UTC).
GlobalGameId integer 32 No No No A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues.
GlobalAwayTeamId integer 32 Yes No No A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues.
GlobalHomeTeamId integer 32 Yes No No A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues.
ClockExtra integer 32 Yes No Yes The added stoppage time minute the game is currently in. Will be null when game is not in stoppage time.
ClockDisplay string 50 Yes No Yes A convienience string display of the current clock with format Clock+ClockExtra (ex 90+3)
IsClosed boolean Yes No Yes Indicates whether the game is over and the final score and stats have been verified and closed out
HomeTeamFormation string 20 Yes No Yes The formation for the home team (4-4-2, 4-3-3, etc.).
AwayTeamFormation string 20 Yes No Yes The formation for the away team (4-4-2, 4-3-3, etc.)
PlayoffAggregateScore PlayoffAggregateScore Yes No Yes Aggregate scoring information for 2-leg/home-and-home games (i.e. Champions League Round of 16). Team A is determined by the first leg’s home team.
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
StatId integer 32 No No Yes The unique ID of the stat
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Season integer 32 No No Yes The soccer season of the game
RoundId integer 32 Yes No Yes The unique ID of the round