Data dictionary¶
Every column in every dataset.
schedule¶
722 rows, 24 columns.
| Column | Type | Description |
|---|---|---|
season |
int16 |
Season the game was played in. |
fiba_game_id |
string |
Unique game identifier and the join key across all five datasets. |
cebl_game_id |
string |
The league's own game identifier, distinct from fiba_game_id. |
start_time_utc |
datetime64[ns, UTC] |
Scheduled tip-off time in UTC. |
game_type |
string |
REGULAR for regular season or FINALS for the postseason. |
status |
string |
Game status. |
period |
Int8 |
The period a game was abandoned in, populated only for a cancelled game that had already tipped off. |
venue_name |
string |
Arena the game was played in. |
home_team_id |
string |
Team identifier for the home team. |
home_team_name |
string |
Full name of the home team at the time of the game. |
home_team_score |
Int16 |
Final score for the home team. |
away_team_id |
string |
Team identifier for the away team. |
away_team_name |
string |
Full name of the away team at the time of the game. |
away_team_score |
Int16 |
Final score for the away team. |
home_team_stats_url_en |
string |
English league stats page for the home team. |
home_team_stats_url_fr |
string |
French league stats page for the home team. |
away_team_stats_url_en |
string |
English league stats page for the away team. |
away_team_stats_url_fr |
string |
French league stats page for the away team. |
fiba_stats_url_en |
string |
English FIBA LiveStats page for this game. |
fiba_stats_url_fr |
string |
French FIBA LiveStats page for this game. |
cebl_stats_url_en |
string |
English game page on cebl.ca. |
cebl_stats_url_fr |
string |
French game page on cebl.ca. |
tickets_url_en |
string |
English ticketing page. |
tickets_url_fr |
string |
French ticketing page. |
team-boxscore¶
1,442 rows, 60 columns.
| Column | Type | Description |
|---|---|---|
fiba_game_id |
string |
Unique game identifier and the join key across all five datasets. |
season |
int16 |
Season the game was played in. |
is_home |
boolean |
True for the home team, false for the away team. |
team_id |
string |
Team identifier. |
team_name |
string |
Full team name as published for this game. |
team_code |
string |
Three-letter team abbreviation as published for this game. |
coach |
string |
Head coach name. Null if the source recorded none. |
assistant_coach_1 |
string |
First assistant coach name. |
assistant_coach_2 |
string |
Second assistant coach name. |
minutes |
Float64 |
Total player minutes for the team, in decimal minutes. |
points |
Int16 |
Total points scored. |
period_1_score |
Int16 |
Points scored in the first quarter. |
period_2_score |
Int16 |
Points scored in the second quarter. |
period_3_score |
Int16 |
Points scored in the third quarter. |
period_4_score |
Int16 |
Points scored in the fourth quarter. |
overtime_score |
Int16 |
Points scored across overtime. Null for games that finish in regulation. |
field_goals_made |
Int16 |
Field goals made, two-pointers plus three-pointers. |
field_goals_attempted |
Int16 |
Field goals attempted. |
field_goal_percentage |
Int16 |
Field goal percentage as a whole number, already rounded by the source. |
two_pointers_made |
Int16 |
Two-point field goals made. |
two_pointers_attempted |
Int16 |
Two-point field goals attempted. |
two_point_percentage |
Int16 |
Two-point percentage as a whole number, already rounded by the source. |
three_pointers_made |
Int16 |
Three-point field goals made. |
three_pointers_attempted |
Int16 |
Three-point field goals attempted. |
three_point_percentage |
Int16 |
Three-point percentage as a whole number, already rounded by the source. |
free_throws_made |
Int16 |
Free throws made. |
free_throws_attempted |
Int16 |
Free throws attempted. |
free_throw_percentage |
Int16 |
Free throw percentage as a whole number, already rounded by the source. |
offensive_rebounds |
Int16 |
Offensive rebounds. |
defensive_rebounds |
Int16 |
Defensive rebounds. |
total_rebounds |
Int16 |
Total rebounds. Always equals offensive plus defensive rebounds. |
team_offensive_rebounds |
Int16 |
Offensive rebounds credited to the team rather than to any individual player. |
team_defensive_rebounds |
Int16 |
Defensive rebounds credited to the team rather than to any individual player. |
team_rebounds |
Int16 |
Rebounds credited to the team rather than to a player. Equals team_offensive_rebounds plus team_defensive_rebounds, and is separate from total_rebounds rather than a subtotal of it. |
assists |
Int16 |
Assists. |
steals |
Int16 |
Steals. |
blocks |
Int16 |
Shots blocked by this team or player. |
blocks_against |
Int16 |
Shots by this team or player that were blocked by an opponent. |
turnovers |
Int16 |
Turnovers committed. |
team_turnovers |
Int16 |
Turnovers charged to the team rather than to a player, such as a shot clock violation. |
personal_fouls |
Int16 |
Personal fouls committed. |
fouls_drawn |
Int16 |
Fouls drawn from opponents. |
total_fouls |
Int16 |
All fouls charged to the team. Always equals personal_fouls plus team_fouls. |
bonus_fouls |
Int16 |
Fouls committed while in the bonus. |
team_fouls |
Int16 |
Fouls charged to the bench or the team rather than to a player. |
points_off_turnovers |
Int16 |
Points scored on possessions that began with an opponent turnover. |
second_chance_points |
Int16 |
Points scored on a possession that followed an offensive rebound. |
fast_break_points |
Int16 |
Points scored in transition. |
points_in_paint |
Int16 |
Points scored inside the paint. |
bench_points |
Int16 |
Points scored by non-starters. |
minutes_leading |
Float64 |
Decimal minutes this team spent ahead on the scoreboard. |
biggest_lead |
Int16 |
Largest lead held at any point. Null when the team never led. |
biggest_scoring_run |
Int16 |
Longest unanswered scoring run. |
lead_changes |
Int16 |
Lead changes in the game. Identical for both teams in a game. |
times_scores_level |
Int16 |
Times the score was tied. Identical for both teams in a game. |
team_efficiency_rating_1 |
Float64 |
Undocumented |
team_efficiency_rating_2 |
Float64 |
Undocumented |
team_efficiency_rating_3 |
Float64 |
Undocumented |
team_efficiency_rating_4 |
Float64 |
Undocumented |
team_efficiency_rating_5 |
Float64 |
Undocumented |
player-boxscore¶
15,023 rows, 47 columns.
| Column | Type | Description |
|---|---|---|
fiba_game_id |
string |
Unique game identifier and the join key across all five datasets. |
season |
int16 |
Season the game was played in. |
is_home |
boolean |
True for the home team, false for the away team. |
team_id |
string |
Team identifier. |
game_player_number |
string |
The player's slot in the game roster. Not a jersey number. |
shirt_number |
string |
Jersey number worn in this game. |
player_name |
string |
Abbreviated display name as published, in F. Lastname form. |
first_name |
string |
Given name. |
family_name |
string |
Surname. |
international_first_name |
string |
Given name in the source's international-transliteration field. |
international_family_name |
string |
Surname in the source's international-transliteration field. |
playing_position |
string |
Listed position. Null where the source recorded none. |
starter |
boolean |
True if the player was in the starting five. |
captain |
boolean |
True if the player was listed as a captain for this game. |
minutes |
Float64 |
Minutes played, in decimal minutes. |
points |
Int16 |
Total points scored. |
field_goals_made |
Int16 |
Field goals made, two-pointers plus three-pointers. |
field_goals_attempted |
Int16 |
Field goals attempted. |
field_goal_percentage |
Int16 |
Field goal percentage as a whole number, already rounded by the source. |
two_pointers_made |
Int16 |
Two-point field goals made. |
two_pointers_attempted |
Int16 |
Two-point field goals attempted. |
two_point_percentage |
Int16 |
Two-point percentage as a whole number, already rounded by the source. |
three_pointers_made |
Int16 |
Three-point field goals made. |
three_pointers_attempted |
Int16 |
Three-point field goals attempted. |
three_point_percentage |
Int16 |
Three-point percentage as a whole number, already rounded by the source. |
free_throws_made |
Int16 |
Free throws made. |
free_throws_attempted |
Int16 |
Free throws attempted. |
free_throw_percentage |
Int16 |
Free throw percentage as a whole number, already rounded by the source. |
offensive_rebounds |
Int16 |
Offensive rebounds. |
defensive_rebounds |
Int16 |
Defensive rebounds. |
total_rebounds |
Int16 |
Total rebounds. Always equals offensive plus defensive rebounds. |
assists |
Int16 |
Assists. |
steals |
Int16 |
Steals. |
blocks |
Int16 |
Shots blocked by this team or player. |
blocks_against |
Int16 |
Shots by this team or player that were blocked by an opponent. |
turnovers |
Int16 |
Turnovers committed. |
personal_fouls |
Int16 |
Personal fouls committed. |
fouls_drawn |
Int16 |
Fouls drawn from opponents. |
second_chance_points |
Int16 |
Points scored on a possession that followed an offensive rebound. |
fast_break_points |
Int16 |
Points scored in transition. |
points_in_paint |
Int16 |
Points scored inside the paint. |
plus_minus_points |
Int16 |
Team point differential while this player was on the floor. |
efficiency_rating_1 |
Float64 |
Undocumented |
efficiency_rating_2 |
Float64 |
Undocumented |
efficiency_rating_3 |
Float64 |
Undocumented |
efficiency_rating_4 |
Float64 |
Undocumented |
efficiency_rating_5 |
Float64 |
Undocumented |
pbp¶
411,022 rows, 27 columns.
| Column | Type | Description |
|---|---|---|
fiba_game_id |
string |
Unique game identifier and the join key across all five datasets. |
season |
int16 |
Season the game was played in. |
action_number |
Int16 |
The source's sequence number for the event within the game. |
previous_action_number |
Int16 |
The action_number of the event this one is linked to, such as the shot an assist belongs to. |
period |
Int8 |
Period number within its period_type. Overtime restarts the count at 1, so sort on period_type and period together or overtime events will sort in among the first quarter. |
period_type |
string |
REGULAR for quarters one through four, OVERTIME for extra periods. |
game_time |
string |
Clock remaining in the period as MM:SS, counting down from 10:00. |
game_clock |
string |
Clock remaining as MM:SS:CC including hundredths. |
is_home |
boolean |
True if the event belongs to the home team. Null on events that belong to neither team, such as period markers. |
team_id |
string |
Team the event belongs to. Null on events that belong to neither team. |
game_player_number |
string |
Roster slot of the player involved. |
shirt_number |
string |
Jersey number of the player involved. |
player_name |
string |
Abbreviated display name as published, in F. Lastname form. |
first_name |
string |
Given name. |
family_name |
string |
Surname. |
international_first_name |
string |
Given name in the source's international-transliteration field. |
international_family_name |
string |
Surname in the source's international-transliteration field. |
action_type |
string |
Action that occurred. |
sub_type |
string |
Detail within action_type. |
qualifier |
string |
Comma-separated tags on the event. |
shot_attempt |
boolean |
True if the event is a field goal or free throw attempt. |
success |
boolean |
Whether the attempt went in. Set to true on every row where shot_attempt is false, so filter on shot_attempt first. |
home_score |
Int16 |
Home score after this event. |
away_score |
Int16 |
Away score after this event. |
home_lead |
Int16 |
Home score minus away score after this event. Negative when the away team leads. |
x |
Float64 |
Shot location along the length of the court, 0 to 100. Present only on 2pt and 3pt events. |
y |
Float64 |
Shot location across the width of the court, 0 to 100. Present only on 2pt and 3pt events. |
officials¶
2,243 rows, 8 columns.
| Column | Type | Description |
|---|---|---|
fiba_game_id |
string |
Unique game identifier and the join key across all five datasets. |
season |
int16 |
Season the game was played in. |
official_type |
string |
Crew role, one of referee1, referee2, referee3, commissioner. |
official_name |
string |
Full name as published. |
first_name |
string |
Given name. |
family_name |
string |
Surname. |
international_first_name |
string |
Given name in the source's international-transliteration field. |
international_family_name |
string |
Surname in the source's international-transliteration field. |