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 }}
{{ group.DisplayName }} {{ note }}

Expand All Collapse All Download CSV

Base

Area

This table is used in the following endpoints:

Soccer v3 Scores

Areas (Countries), Competition Hierarchy (League Hierarchy)

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

CanceledMembership

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.

Competition

This table is used in the following endpoints:

Soccer v3 Scores

Competitions (Leagues), Areas (Countries), Competition Hierarchy (League Hierarchy)

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

CompetitionDetail

This table is used in the following endpoints:

Soccer v3 Scores

Competition Fixtures (League Details)

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

Game

This table is used in the following endpoints:

Soccer v3 Scores

Competition Fixtures (League Details)

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.

Membership

This table is used in the following endpoints:

Soccer v3 Scores

Memberships (Active), Memberships (Historical), Memberships by Team (Active), Memberships by Team (Historical), Memberships (Recently Changed), Memberships by Competition (Active), Memberships by Competition (Historical)

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)

Player

This table is used in the following endpoints:

Soccer v3 Scores

Player, Players, Players by Team, Competition Fixtures (League Details)

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.

PlayoffAggregateScore

This table is used in the following endpoints:

Soccer v3 Scores

Competition Fixtures (League Details)

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.

Round

This table is used in the following endpoints:

Soccer v3 Scores

Competitions (Leagues), Areas (Countries), Competition Hierarchy (League Hierarchy), Competition Fixtures (League Details)

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

Season

This table is used in the following endpoints:

Soccer v3 Scores

Competitions (Leagues), Areas (Countries), Competition Hierarchy (League Hierarchy), Competition Fixtures (League Details)

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

SeasonTeam

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

Standing

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.

Team

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.

TeamDetail

This table is used in the following endpoints:

Soccer v3 Scores

Competition Fixtures (League Details)

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.

Venue

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

Game

This table is used in the following endpoints:

Soccer v3 Scores

Games by Date, Schedule, Upcoming Schedule By Player

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.

PlayoffAggregateScore

This table is used in the following endpoints:

Soccer v3 Scores

Games by Date, Schedule, Upcoming Schedule By Player

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

TeamGame

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

TeamSeason

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

Booking

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

BoxScore

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

Name	Type	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)

Coach

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

Game

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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.

Goal

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

Lineup

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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.

PenaltyShootout

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

PlayerGame

This table is used in the following endpoints:

Soccer v3 Stats

Player Game Stats by Date, Player Game Stats by Player, Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

PlayerSeason

This table is used in the following endpoints:

Soccer v3 Stats

Player Season Stats, Player Season Stats by Player, Player Season Stats by Team

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

PlayoffAggregateScore

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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.

Referee

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

TeamGame

This table is used in the following endpoints:

Soccer v3 Stats

Box Score, Box Scores by Date, Box Scores by Date by Competition, Box Scores by Date Delta, Box Scores Delta by Date by Competition

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

DfsSlate

This table is used in the following endpoints:

Soccer v3 Projections

Dfs Slates By Date, Upcoming Dfs Slates By Competition

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.)

DfsSlateGame

This table is used in the following endpoints:

Soccer v3 Projections

Dfs Slates By Date, Upcoming Dfs Slates By Competition

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.

DfsSlatePlayer

This table is used in the following endpoints:

Soccer v3 Projections

Dfs Slates By Date, Upcoming Dfs Slates By Competition

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.

Game

This table is used in the following endpoints:

Soccer v3 Projections

Dfs Slates By Date, Upcoming Dfs Slates By Competition

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.

PlayerGameProjection

This table is used in the following endpoints:

Soccer v3 Projections

Projected Player Game Stats by Competition (w/ DFS Salaries), Projected Player Game Stats by Date (w/ DFS Salaries), Projected Player Game Stats by Player (w/ DFS Salaries)

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

SPORTS DATA

Solutions

DEVELOPERS

API Documentation

Data Dictionary

Data Dictionary

Choose League:

Base

Tier 1: Scores

Tier 2: Team Stats

Tier 3: Player Stats

Fantasy