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 }}
-
{{ note }}
Base
Area
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 |
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:
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:
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 |
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 |
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:
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:
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 | 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) |
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:
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:
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:
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:
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:
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 |