FantasyData API Solutions re-brands as SportsDataIO Learn More
FantasyData re-brands as SportsDataIO Learn More

Data Dictionary


Below you will find a list of all data points that are contained within each feed that we offer. If any of the information provided below is unclear, or if you have a specific question, please contact support.

Go to our developer portal for a full list of operations including deprecated, legacy and test endpoints.

All dates & times are in US Eastern Time.

Choose League:

  • {{ category.Name }}

Free

This table is used in the following endpoints:
LoL v3 Scores
Areas (Countries)
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
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
CompetitionId integer 32 No No Yes The unique ID of the competition/league
AreaId integer 32 No No Yes The unique ID of the area where this competition/league is played
AreaName string 50 Yes No Yes The display name of the area where this competition/league is played
Name string 50 No No Yes The display name of the competition/league
Gender string 10 Yes No Yes Indicates the gender of the players on this team (possible values: Male, Female)
Type string 10 Yes No Yes The type of this competition/league (possible values: Club, International)
Format string 50 Yes No Yes The format of the competition/league (possible values: Domestic League, International Cup)
Seasons Season[] Yes No Yes The seasons associated with this competition/league
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
MembershipId integer 32 No No Yes The unique ID for the membership
TeamId integer 32 No No Yes The unique ID for the team
PlayerId integer 32 No No Yes The player's unique PlayerID as assigned by FantasyData.
PlayerName string 100 Yes No Yes The full name of the player.
TeamName string 50 Yes No Yes Name of the team
TeamArea string 50 Yes No Yes Area of the team
Active boolean No No Yes Whether the membership is active (true/false)
StartDate datetime Yes No Yes The start date of the membership (UTC)
EndDate datetime Yes No Yes The end date of the membership (UTC)
Updated datetime Yes No Yes The updated date and time of the membership (EST/EDT)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
PlayerId integer 32 No No Yes The player's unique PlayerID as assigned by FantasyData.
FirstName string 50 Yes No Yes The player's first name.
LastName string 50 Yes No Yes The player's last name.
CommonName string 100 Yes No Yes The player's common name.
MatchName string 100 Yes No Yes The player's short name.
Position string 10 Yes No Yes The position of the player. Possible values include: ADC, Jungle, Mid, Support, Top
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.
Updated datetime Yes No Yes The date and time the player's status was updated. (EST/EDT)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
RoundId integer 32 No No Yes The unique ID of the round
SeasonId integer 32 No No Yes The unique ID of the season this round is associated with
Season integer 32 No No Yes The soccer season for which these totals apply
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Name string 50 No No Yes The display name of the round (examples: Regular Season, Semi-finals, Final, etc)
Type string 50 Yes No Yes The type of this round. Possible values include: Cup, Table
StartDate date Yes No Yes The start date of the round (UTC)
EndDate date Yes No Yes The end date of the round (UTC)
CurrentWeek integer 32 Yes No Yes The current week that this round is in
CurrentRound boolean No No Yes Indicates whether or not this round is the current round of the competition/season
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SeasonId integer 32 No No Yes The unique ID of the season
CompetitionId integer 32 No No Yes The unique ID of the competition
Season integer 32 No No Yes The soccer regular season for which these totals apply
Name string 50 No No Yes The display name of the season (example: 2017/2018, 2018-19, etc)
CompetitionName string 50 No No Yes The display name of the competition associated with this season
StartDate date Yes No Yes The start date of the season (UTC)
EndDate date Yes No Yes The end date of the season (UTC)
CurrentSeason boolean No No Yes Indicates whether or not this season is the current season of the competition
Rounds Round[] Yes No Yes The rounds associated with this season
This table is used in the following endpoints:
LoL 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: Male, Female)
Type string 10 Yes No Yes The type of this season/team (possible values: Club, National)
Team Team Yes No Yes The team details of this season/team association
This table is used in the following endpoints:
LoL v3 Scores
Standings
Name Type Size Nullable Scrambled CSV Description
StandingId int 32 No No Yes The unique ID of the standing
RoundId int 32 No No Yes The unique ID of the round
TeamId int 32 No No Yes The unique ID of the team
Name string 100 Yes No Yes The full name of the team
[Order] int 32 Yes No Yes The order of the teams in the standings
Games int 32 No No Yes The number of games played
Wins int 32 No No Yes The number of wins
Losses int 32 No No Yes The number of losses
Points int 32 No No Yes Total points accumulated
ScoreFor int 32 No No Yes The total score for the team
ScoreAgainst int 32 No No Yes The total score against the team
ScoreDifference int 32 No No Yes Total score differential
Group string 50 Yes No Yes The name of the group (when applicable)
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 area
AreaName string 50 Yes No Yes The area name of the team
[Key] string 10 Yes No Yes Abbreviation of the team
Name string 50 No No Yes The full name of the team
ShortName string 50 Yes No Yes The short name of the team
Active boolean No No Yes Whether or not this team is active
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 team (possible values: Club, National)
Website string 50 Yes No Yes The URL of the website of this team
Email string 50 Yes No Yes The email address of this team
Founded integer 32 Yes No Yes The year the team was founded
PrimaryColor string 50 Yes No Yes The primary color of this team's logo/branding
SecondaryColor string 50 Yes No Yes The secondary color of this team's logo/branding
TertiaryColor string 50 Yes No Yes The tertiary color of this team's logo/branding
QuaternaryColor string 50 Yes No Yes The quaternary color of this team's logo/branding
Facebook string 100 Yes No Yes The URL of this team's Facebook page
Twitter string 100 Yes No Yes The URL of this team's Twitter page
YouTube string 100 Yes No Yes The URL of this team's YouTube page
Instagram string 100 Yes No Yes The URL of this team's Instagram page
This table is used in the following endpoints:
LoL 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
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
GeoLat decimal 32 Yes No Yes The geographic latitude coordinate of this venue.
GeoLong decimal 32 Yes No Yes The geographic longitude coordinate of this venue.

Tier 1: Scores

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
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
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.
TeamAId integer 32 Yes No Yes The TeamId of team A
TeamBId integer 32 Yes No Yes The TeamId of team B
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 on break, then the Status will be Break. Awarded is used in cases where a game is decided without completing. 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
BestOf string 10 Yes No Yes How many matches/rounds are played if this game is a best of series
Winner string 10 Yes Yes Yes The winner of the game. Possible values include: TeamA, TeamB, Draw, NULL
VenueType string 10 Yes No Yes Indicates home venue advantage. Possible values include: Home Away, Neutral
TeamAKey string 10 Yes No Yes The abbreviation of team A
TeamAName string 50 Yes No Yes The name of team A
TeamAScore integer 32 Yes Yes Yes The final score of team A
TeamBKey string 10 Yes No Yes The abbreviation of team B
TeamBName string 50 Yes No Yes The name of team B
TeamBScore integer 32 Yes Yes Yes The final score of team B
TeamAMoneyLine integer 32 Yes Yes Yes Payout on a bet that the team A wins
TeamBMoneyLine integer 32 Yes Yes Yes Payout on a bet that the team B 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 team A
TeamAPointSpreadPayout integer 32 Yes Yes Yes Payout if team A beats the spread
TeamBPointSpreadPayout integer 32 Yes Yes Yes Payout if team B beats the spread
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)
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.
MatchName string 100 Yes No Yes The player's short name.
Position string 10 Yes No Yes The position of the player. Possible values include: ADC, Jungle, Mid, Support, Top
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.
Updated datetime Yes No Yes The date and time the player's status was updated. (EST/EDT)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
RoundId integer 32 No No Yes The unique ID of the round
SeasonId integer 32 No No Yes The unique ID of the season this round is associated with
Season integer 32 No No Yes The soccer season for which these totals apply
SeasonType integer 32 No No Yes The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar).
Name string 50 No No Yes The display name of the round (examples: Regular Season, Semi-finals, Final, etc)
Type string 50 Yes No Yes The type of this round. Possible values include: Cup, Table
StartDate date Yes No Yes The start date of the round (UTC)
EndDate date Yes No Yes The end date of the round (UTC)
CurrentWeek integer 32 Yes No Yes The current week that this round is in
CurrentRound boolean No No Yes Indicates whether or not this round is the current round of the competition/season
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SeasonId integer 32 No No Yes The unique ID of the season
CompetitionId integer 32 No No Yes The unique ID of the competition
Season integer 32 No No Yes The soccer regular season for which these totals apply
Name string 50 No No Yes The display name of the season (example: 2017/2018, 2018-19, etc)
CompetitionName string 50 No No Yes The display name of the competition associated with this season
StartDate date Yes No Yes The start date of the season (UTC)
EndDate date Yes No Yes The end date of the season (UTC)
CurrentSeason boolean No No Yes Indicates whether or not this season is the current season of the competition
Rounds Round[] Yes No Yes The rounds associated with this season
This table is used in the following endpoints:
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 area
AreaName string 50 Yes No Yes The area name of the team
[Key] string 10 Yes No Yes Abbreviation of the team
Name string 50 No No Yes The full name of the team
ShortName string 50 Yes No Yes The short name of the team
Active boolean No No Yes Whether or not this team is active
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 team (possible values: Club, National)
Website string 50 Yes No Yes The URL of the website of this team
Email string 50 Yes No Yes The email address of this team
Founded integer 32 Yes No Yes The year the team was founded
PrimaryColor string 50 Yes No Yes The primary color of this team's logo/branding
SecondaryColor string 50 Yes No Yes The secondary color of this team's logo/branding
TertiaryColor string 50 Yes No Yes The tertiary color of this team's logo/branding
QuaternaryColor string 50 Yes No Yes The quaternary color of this team's logo/branding
Facebook string 100 Yes No Yes The URL of this team's Facebook page
Twitter string 100 Yes No Yes The URL of this team's Twitter page
YouTube string 100 Yes No Yes The URL of this team's YouTube page
Instagram string 100 Yes No Yes The URL of this team's Instagram page

Tier 2: Stats

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
Game Game Yes No Yes The information on the entire game
Matches Match[] Yes No Yes The information on the individual matches
PlayerGames PlayerGame[] Yes No Yes The stats for players across all matches
TeamGames TeamGame[] Yes No Yes The stats for teams across all matches
This table is used in the following endpoints:
LoL v3 Stats
Champions
Name Type Size Nullable Scrambled CSV Description
Attack decimal 32 No No Yes The attack of the champion
Defense decimal 32 No No Yes The defense of the champion
Magic decimal 32 No No Yes The magic of the champion
Difficulty decimal 32 No No Yes The difficulty of the champion
Hp decimal 32 No No Yes The health points of the champion
HpUpPerLevel decimal 32 No No Yes The health points gained per level of the champion
Mp decimal 32 No No Yes The magic points of the champion
MpUpPerLevel decimal 32 No No Yes The magic points gained per level of the champion
MoveSpeed decimal 32 No No Yes The move speed of the champion
Armor decimal 32 No No Yes The armor of the champion
ArmorPerLevel decimal 32 No No Yes The armor gained per level of the champion
SpellBlock decimal 32 No No Yes The spell blocking power of the champion
SpellBlockPerLevel decimal 32 No No Yes The spell blocking power gained per level of the champion
AttackRange decimal 32 No No Yes The attack range of the champion
HpRegen decimal 32 No No Yes The health regeneration of the champion
HpRegenPerLevel decimal 32 No No Yes The health regeneration gained per level of the champion
MpRegen decimal 32 No No Yes The magic regeneration of the champion
MpRegenPerLevel decimal 32 No No Yes The magic regeneration gained per level of the champion
AttackDamage decimal 32 No No Yes The attack damage of the champion
AttackDamagePerLevel decimal 32 No No Yes The attack damage gained per level of the champion
AttackSpeedOffset decimal 32 No No Yes The attack speed of the champion
ChampionId int 32 No No Yes The unique id of the champion
Name string 50 No No Yes The name of the champion
Title string 50 No No Yes The title of the champion
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
ChampionId int 32 No No Yes The unique id of the champion
Name string 50 No No Yes The name of the champion
Title string 50 No No Yes The title of the champion
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.
TeamAId integer 32 Yes No Yes The TeamId of team A
TeamBId integer 32 Yes No Yes The TeamId of team B
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 on break, then the Status will be Break. Awarded is used in cases where a game is decided without completing. 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
BestOf string 10 Yes No Yes How many matches/rounds are played if this game is a best of series
Winner string 10 Yes Yes Yes The winner of the game. Possible values include: TeamA, TeamB, Draw, NULL
VenueType string 10 Yes No Yes Indicates home venue advantage. Possible values include: Home Away, Neutral
TeamAKey string 10 Yes No Yes The abbreviation of team A
TeamAName string 50 Yes No Yes The name of team A
TeamAScore integer 32 Yes Yes Yes The final score of team A
TeamBKey string 10 Yes No Yes The abbreviation of team B
TeamBName string 50 Yes No Yes The name of team B
TeamBScore integer 32 Yes Yes Yes The final score of team B
TeamAMoneyLine integer 32 Yes Yes Yes Payout on a bet that the team A wins
TeamBMoneyLine integer 32 Yes Yes Yes Payout on a bet that the team B 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 team A
TeamAPointSpreadPayout integer 32 Yes Yes Yes Payout if team A beats the spread
TeamBPointSpreadPayout integer 32 Yes Yes Yes Payout if team B beats the spread
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)
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
ItemId int 32 No No Yes The unique id of the item
Name string 50 No No Yes The name of the item
GoldBase int 32 No No Yes The base gold of the item
GoldTotal int 32 No No Yes The total gold of the item
GoldSell int 32 No No Yes The sell price in gold of the item
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId int 32 No No Yes The Unique ID of the Game the match is from.
Number int 32 No No Yes The match number (starts from 1)
MapName string 50 Yes No Yes The name of the league of legends map
WinningTeamId int 32 Yes No Yes The TeamId of the winning Team (once a winner is found)
GameVersion string 50 No No Yes The LoL version number as of the playing of this match
MatchBans MatchBan[] No No Yes The list of banned champions for each team (if shows champion x banned by team y then their opponent cannot select that champion)
PlayerMatches PlayerMatch[] No No Yes The list of player match stats for the given match
TeamMatches TeamMatch[] No No Yes The list of team match stats for the given match
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
MatchId int 32 No No Yes The unique id of the match
TeamId int 32 No No Yes The unique id of the team doing the banning
ChampionId int 32 Yes No Yes The unique id of the champion who is banned
Champion ChampionInfo Yes No Yes The basic info of the champion who is banned
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId int 32 No No Yes The Unique ID of the Game
OpponentId int 32 No No Yes The Unique ID of the opposing team
Opponent string 20 No No Yes The team key of the opposing team
Day datetime Yes No Yes The date of the event
DateTime datetime Yes No Yes The date and time of the event
PlayerId int 32 No No Yes The Unique Id of the player
TeamId int 32 Yes No Yes The unique Id of the team the player played for this match
Team string 20 Yes No Yes The team key of the team the player played for this match
Name string 50 No No Yes The player's name
Kills decimal 32 Yes Yes Yes The total number of Kills by the player
Assists decimal 32 Yes Yes Yes The total number of Assists by the player
Deaths decimal 32 Yes Yes Yes The total number of Deaths by the player
LargestKillingSpree decimal 32 Yes Yes Yes The longest killing spree achieved by the player
LargestMultiKill decimal 32 Yes Yes Yes The largest multikill achieved by the player
KillingSpree decimal 32 Yes Yes Yes The current killing spree the player is on by the player
LongestTimeSpentLiving decimal 32 Yes Yes Yes The longest time spent alive by the player
DoubleKills decimal 32 Yes Yes Yes The total number of Double Kills by the player
TripleKills decimal 32 Yes Yes Yes The total number of Triple Kills by the player
QuadraKills decimal 32 Yes Yes Yes The total number of Quadra Kills by the player
PentaKills decimal 32 Yes Yes Yes The total number of Penta Kills by the player
UnrealKills decimal 32 Yes Yes Yes The total number of Unreal Kills by the player
TotalDamageDealt decimal 32 Yes Yes Yes The total damage dealt by the player
MagicDamageDealt decimal 32 Yes Yes Yes The total magical damage dealt by the player
PhysicalDamageDealt decimal 32 Yes Yes Yes The total physical damage dealt by the player
TrueDamageDealt decimal 32 Yes Yes Yes The total true damage dealt by the player
LargestCriticalStrike decimal 32 Yes Yes Yes The largest single critical strike damage by the player
TotalDamageDealtToChampions decimal 32 Yes Yes Yes The total damage dealt to opposing champions by the player
MagicDamageDealtToChampions decimal 32 Yes Yes Yes The total magical damage dealt to opposing champions by the player
PhysicalDamageDealtToChampions decimal 32 Yes Yes Yes The total physical damage dealt to opposing champions by the player
TrueDamageDealtToChampions decimal 32 Yes Yes Yes The total true damage dealt to opposing champions by the player
TotalHeal decimal 32 Yes Yes Yes The total amount of heal by the player
TotalUnitsHealed decimal 32 Yes Yes Yes The total number of units healed by the player
TotalDamageTaken decimal 32 Yes Yes Yes The total amount of damage taken by the player
MagicDamageTaken decimal 32 Yes Yes Yes The total amount of magical damage taken by the player
PhysicalDamageTaken decimal 32 Yes Yes Yes The total amount of physical damage taken by the player
TrueDamageTaken decimal 32 Yes Yes Yes The total amount of true damage taken by the player
GoldEarned decimal 32 Yes Yes Yes The total gold earned by the player
GoldSpent decimal 32 Yes Yes Yes The total gold spent by the player
TurretKills decimal 32 Yes Yes Yes The total number of turrets killed by the player
InhibitorKills decimal 32 Yes Yes Yes The total number of inhibitors killed by the player
TotalMinionsKilled decimal 32 Yes Yes Yes The total number of minions killed by the player
NeutralMinionsKIlled decimal 32 Yes Yes Yes The total number of neutral minions killed by the player
NeutralMinionsKIlledTeamJungle decimal 32 Yes Yes Yes The total number of neutral minions killed by the player in their own jungle
NeutralMinionsKilledEnemyJungle decimal 32 Yes Yes Yes The total number of neutral minions killed by the player in the enemy jungle
TotalTimeCrowdControlDealt decimal 32 Yes Yes Yes The total time enemies were crowd controlled by the player
VisionWardsBoughtInGame decimal 32 Yes Yes Yes The total number of vision wards bought by the player
SightWardsBoughtInGame decimal 32 Yes Yes Yes The total number of sight wards bought by the player
WardsPlaced decimal 32 Yes Yes Yes The total number of wards placed by the player
WardsKilled decimal 32 Yes Yes Yes The total number of wards killed by the player
CombatPlayerScore decimal 32 Yes Yes Yes The player's combat player score
ObjectivePlayerScore decimal 32 Yes Yes Yes The player's objective player score
TotalPlayerScore decimal 32 Yes Yes Yes The player's total player score
FantasyPoints decimal 32 Yes Yes Yes The total number of fantasy points scored by the player
TenKillsOrAssists decimal 32 Yes Yes Yes Did player reach either 10 kills or 10 assists in a single match
Updated datetime Yes No Yes The last update time of the record
Games int 32 No No Yes The number of games played
Matches int 32 No No Yes The number of matches played
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
MatchId int 32 No No Yes The Unique Id of the match
Position string 10 Yes No Yes The position or role the player played
ChampionId int 32 Yes No Yes The Id of the champion used
ChampionLevel int 32 Yes Yes Yes The level of the champion
Champion ChampionInfo Yes No Yes The name and basic information of the champion
Items Item[] Yes No Yes The list of items held by the player
Spells Spell[] Yes No Yes The list of spells of the player
GameId int 32 No No Yes The Unique ID of the Game
OpponentId int 32 No No Yes The Unique ID of the opposing team
Opponent string 20 No No Yes The team key of the opposing team
Day datetime Yes No Yes The date of the event
DateTime datetime Yes No Yes The date and time of the event
PlayerId int 32 No No Yes The Unique Id of the player
TeamId int 32 Yes No Yes The unique Id of the team the player played for this match
Team string 20 Yes No Yes The team key of the team the player played for this match
Name string 50 No No Yes The player's name
Kills decimal 32 Yes Yes Yes The total number of Kills by the player
Assists decimal 32 Yes Yes Yes The total number of Assists by the player
Deaths decimal 32 Yes Yes Yes The total number of Deaths by the player
LargestKillingSpree decimal 32 Yes Yes Yes The longest killing spree achieved by the player
LargestMultiKill decimal 32 Yes Yes Yes The largest multikill achieved by the player
KillingSpree decimal 32 Yes Yes Yes The current killing spree the player is on by the player
LongestTimeSpentLiving decimal 32 Yes Yes Yes The longest time spent alive by the player
DoubleKills decimal 32 Yes Yes Yes The total number of Double Kills by the player
TripleKills decimal 32 Yes Yes Yes The total number of Triple Kills by the player
QuadraKills decimal 32 Yes Yes Yes The total number of Quadra Kills by the player
PentaKills decimal 32 Yes Yes Yes The total number of Penta Kills by the player
UnrealKills decimal 32 Yes Yes Yes The total number of Unreal Kills by the player
TotalDamageDealt decimal 32 Yes Yes Yes The total damage dealt by the player
MagicDamageDealt decimal 32 Yes Yes Yes The total magical damage dealt by the player
PhysicalDamageDealt decimal 32 Yes Yes Yes The total physical damage dealt by the player
TrueDamageDealt decimal 32 Yes Yes Yes The total true damage dealt by the player
LargestCriticalStrike decimal 32 Yes Yes Yes The largest single critical strike damage by the player
TotalDamageDealtToChampions decimal 32 Yes Yes Yes The total damage dealt to opposing champions by the player
MagicDamageDealtToChampions decimal 32 Yes Yes Yes The total magical damage dealt to opposing champions by the player
PhysicalDamageDealtToChampions decimal 32 Yes Yes Yes The total physical damage dealt to opposing champions by the player
TrueDamageDealtToChampions decimal 32 Yes Yes Yes The total true damage dealt to opposing champions by the player
TotalHeal decimal 32 Yes Yes Yes The total amount of heal by the player
TotalUnitsHealed decimal 32 Yes Yes Yes The total number of units healed by the player
TotalDamageTaken decimal 32 Yes Yes Yes The total amount of damage taken by the player
MagicDamageTaken decimal 32 Yes Yes Yes The total amount of magical damage taken by the player
PhysicalDamageTaken decimal 32 Yes Yes Yes The total amount of physical damage taken by the player
TrueDamageTaken decimal 32 Yes Yes Yes The total amount of true damage taken by the player
GoldEarned decimal 32 Yes Yes Yes The total gold earned by the player
GoldSpent decimal 32 Yes Yes Yes The total gold spent by the player
TurretKills decimal 32 Yes Yes Yes The total number of turrets killed by the player
InhibitorKills decimal 32 Yes Yes Yes The total number of inhibitors killed by the player
TotalMinionsKilled decimal 32 Yes Yes Yes The total number of minions killed by the player
NeutralMinionsKIlled decimal 32 Yes Yes Yes The total number of neutral minions killed by the player
NeutralMinionsKIlledTeamJungle decimal 32 Yes Yes Yes The total number of neutral minions killed by the player in their own jungle
NeutralMinionsKilledEnemyJungle decimal 32 Yes Yes Yes The total number of neutral minions killed by the player in the enemy jungle
TotalTimeCrowdControlDealt decimal 32 Yes Yes Yes The total time enemies were crowd controlled by the player
VisionWardsBoughtInGame decimal 32 Yes Yes Yes The total number of vision wards bought by the player
SightWardsBoughtInGame decimal 32 Yes Yes Yes The total number of sight wards bought by the player
WardsPlaced decimal 32 Yes Yes Yes The total number of wards placed by the player
WardsKilled decimal 32 Yes Yes Yes The total number of wards killed by the player
CombatPlayerScore decimal 32 Yes Yes Yes The player's combat player score
ObjectivePlayerScore decimal 32 Yes Yes Yes The player's objective player score
TotalPlayerScore decimal 32 Yes Yes Yes The player's total player score
FantasyPoints decimal 32 Yes Yes Yes The total number of fantasy points scored by the player
TenKillsOrAssists decimal 32 Yes Yes Yes Did player reach either 10 kills or 10 assists in a single match
Updated datetime Yes No Yes The last update time of the record
Games int 32 No No Yes The number of games played
Matches int 32 No No Yes The number of matches played
This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
SpellId int 32 No No Yes The unique id of the spell
Name string 50 No No Yes The name of the spell

Fantasy

This table is used in the following endpoints:
Name Type Size Nullable Scrambled CSV Description
GameId int 32 No No Yes The Unique ID of the Game
OpponentId int 32 No No Yes The Unique ID of the opposing team
Opponent string 20 No No Yes The team key of the opposing team
Day datetime Yes No Yes The date of the event
DateTime datetime Yes No Yes The date and time of the event
PlayerId int 32 No No Yes The Unique Id of the player
TeamId int 32 Yes No Yes The unique Id of the team the player played for this match
Team string 20 Yes No Yes The team key of the team the player played for this match
Name string 50 No No Yes The player's name
Kills decimal 32 Yes Yes Yes The total number of Kills by the player
Assists decimal 32 Yes Yes Yes The total number of Assists by the player
Deaths decimal 32 Yes Yes Yes The total number of Deaths by the player
LargestKillingSpree decimal 32 Yes Yes Yes The longest killing spree achieved by the player
LargestMultiKill decimal 32 Yes Yes Yes The largest multikill achieved by the player
KillingSpree decimal 32 Yes Yes Yes The current killing spree the player is on by the player
LongestTimeSpentLiving decimal 32 Yes Yes Yes The longest time spent alive by the player
DoubleKills decimal 32 Yes Yes Yes The total number of Double Kills by the player
TripleKills decimal 32 Yes Yes Yes The total number of Triple Kills by the player
QuadraKills decimal 32 Yes Yes Yes The total number of Quadra Kills by the player
PentaKills decimal 32 Yes Yes Yes The total number of Penta Kills by the player
UnrealKills decimal 32 Yes Yes Yes The total number of Unreal Kills by the player
TotalDamageDealt decimal 32 Yes Yes Yes The total damage dealt by the player
MagicDamageDealt decimal 32 Yes Yes Yes The total magical damage dealt by the player
PhysicalDamageDealt decimal 32 Yes Yes Yes The total physical damage dealt by the player
TrueDamageDealt decimal 32 Yes Yes Yes The total true damage dealt by the player
LargestCriticalStrike decimal 32 Yes Yes Yes The largest single critical strike damage by the player
TotalDamageDealtToChampions decimal 32 Yes Yes Yes The total damage dealt to opposing champions by the player
MagicDamageDealtToChampions decimal 32 Yes Yes Yes The total magical damage dealt to opposing champions by the player
PhysicalDamageDealtToChampions decimal 32 Yes Yes Yes The total physical damage dealt to opposing champions by the player
TrueDamageDealtToChampions decimal 32 Yes Yes Yes The total true damage dealt to opposing champions by the player
TotalHeal decimal 32 Yes Yes Yes The total amount of heal by the player
TotalUnitsHealed decimal 32 Yes Yes Yes The total number of units healed by the player
TotalDamageTaken decimal 32 Yes Yes Yes The total amount of damage taken by the player
MagicDamageTaken decimal 32 Yes Yes Yes The total amount of magical damage taken by the player
PhysicalDamageTaken decimal 32 Yes Yes Yes The total amount of physical damage taken by the player
TrueDamageTaken decimal 32 Yes Yes Yes The total amount of true damage taken by the player
GoldEarned decimal 32 Yes Yes Yes The total gold earned by the player
GoldSpent decimal 32 Yes Yes Yes The total gold spent by the player
TurretKills decimal 32 Yes Yes Yes The total number of turrets killed by the player
InhibitorKills decimal 32 Yes Yes Yes The total number of inhibitors killed by the player
TotalMinionsKilled decimal 32 Yes Yes Yes The total number of minions killed by the player
NeutralMinionsKIlled decimal 32 Yes Yes Yes The total number of neutral minions killed by the player
NeutralMinionsKIlledTeamJungle decimal 32 Yes Yes Yes The total number of neutral minions killed by the player in their own jungle
NeutralMinionsKilledEnemyJungle decimal 32 Yes Yes Yes The total number of neutral minions killed by the player in the enemy jungle
TotalTimeCrowdControlDealt decimal 32 Yes Yes Yes The total time enemies were crowd controlled by the player
VisionWardsBoughtInGame decimal 32 Yes Yes Yes The total number of vision wards bought by the player
SightWardsBoughtInGame decimal 32 Yes Yes Yes The total number of sight wards bought by the player
WardsPlaced decimal 32 Yes Yes Yes The total number of wards placed by the player
WardsKilled decimal 32 Yes Yes Yes The total number of wards killed by the player
CombatPlayerScore decimal 32 Yes Yes Yes The player's combat player score
ObjectivePlayerScore decimal 32 Yes Yes Yes The player's objective player score
TotalPlayerScore decimal 32 Yes Yes Yes The player's total player score
FantasyPoints decimal 32 Yes Yes Yes The total number of fantasy points scored by the player
TenKillsOrAssists decimal 32 Yes Yes Yes Did player reach either 10 kills or 10 assists in a single match
Updated datetime Yes No Yes The last update time of the record
Games int 32 No No Yes The number of games played
Matches int 32 No No Yes The number of matches played