Skip to contents

Per-quarter box score lines of the players who were on court, overtimes included.

Endpoint: GET https://api.tpbl.basketball/api/games/{game_id}/stats

Usage

tpbl_box_player_periods(game_id)

Arguments

game_id

Required. TPBL game id (integer), e.g. 6; game_id in tpbl_games. Not sequential by date (2024-25 = 1-1367, 2025-26 = 1371-8641, 2026-27 = 27535-27667). Only a finished game is served.

Value

A hoopR_data tibble: Per-quarter box score lines of the players who were on court, overtimes included. An empty answer raises hoopR_no_data; the columns are always these, in this order (sportsdataverse-py tpbl_box_player_periods):

col_nametypedescription
game_idintegerTPBL game id (key space: TPBL games on api.tpbl.basketball): the {game_id} of the game routes. Not sequential by date (2024-25 = 1-1367, 2025-26 = 1371-8641, 2026-27 = 27535-27667). The box score echoes no game id, so a box frame parsed without the request stamp has a null game_id.
sidecharacterSide of the game: home or away (the API lists the home team first and never infers it from the venue).
team_idintegerTPBL team id (key space: TPBL teams = franchises, 2-8 so far; stable across seasons): the {team_id} of the division team routes. Not the GoHoops franchise id and not the squad id.
teamcharacterTeam name in Traditional Chinese with the sponsor (Kaohsiung Aquas, Formosa Dreamers, Hsinchu Lioneers, Taoyuan Leopards, New Taipei CTBC DEA, New Taipei Kings, Taipei Mars).
gohoops_squad_idintegerGoHoops squad id (key space: GoHoops squads = one team in one season: 8209-8215 in 2024-25, 11931-11937 in 2025-26, 15536-15542 in 2026-27; it changes every season).
periodintegerQuarter number of the row: 1-4 regulation, 5 = the first overtime, 6 = the second.
player_idintegerTPBL player id (key space: TPBL players; one per person across seasons and teams): the {player_id} of the player routes. Not the GoHoops person id and not the roster id.
gohoops_person_idintegerGoHoops person id (key space: GoHoops persons; one per human). Not the TPBL player id and not the roster id.
gohoops_roster_idintegerGoHoops roster id (key space: GoHoops rosters = one player registered with one squad in one season; it changes when the player changes season or team). The key of the box score players: join tpbl_box_players to tpbl_roster on it. Not the TPBL player id and not the person id.
playercharacterPlayer name (Traditional Chinese, or a transliteration for foreign players).
numbercharacterJersey number as text (so '0' and '00' stay distinct).
positioncharacterPlaying position as a PascalCase enum: PointGuard, ShootingGuard, SmallForward, PowerForward, Center, and the combinations PointGuardAndShootingGuard, ShootingGuardAndSmallForward, SmallForwardAndPowerForward and PowerForwardAndCenter; ” when unset.
statuscharacterRegistration status of the player on the squad as of the request, not at game time: 'official', or 'withdrawn' / 'WITHDRAWN' (one state in two spellings: the player left the squad later; most withdrawn players still played).
roster_statuscharacterRoster registration status as an upper-case enum: 'OFFICIAL' in the 2026-27 preseason game; null in the 2024-25 and 2025-26 box scores (an era difference in the feed).
is_startinglogicalTrue when the player was in the starting five of the game.
enteredlogicalAlways true here: only quarters in which the player was on court are rows.
time_on_courtintegerSeconds on court by the player in this quarter (436 = 7:16). A team quarter sums its five players: 3600 = 5 x 720 s (12-minute quarter), 1500 = 5 x 300 s (5-minute overtime).
scoreintegerPoints scored by the player in this quarter. The stat keys are absent for a player who did not enter the game (11 keys in all); a few players who did not play carry them with time_on_court 0.
plus_minusintegerPlus/minus: the team's point differential while the player was on court (standard definition; not independently checked).
field_goals_madeintegerField goals made by the player in this quarter.
field_goals_missedintegerField goals missed by the player in this quarter.
field_goals_attemptedintegerField goals attempted by the player in this quarter.
field_goals_percentagedoubleField goals percentage by the player in this quarter, 0-100 as a string with one decimal ('57.1'); '0.0' without attempts.
two_pointers_madeinteger2-point field goals made by the player in this quarter.
two_pointers_missedinteger2-point field goals missed by the player in this quarter.
two_pointers_attemptedinteger2-point field goals attempted by the player in this quarter.
two_pointers_percentagedouble2-point field goals percentage by the player in this quarter, 0-100 as a string with one decimal ('57.1'); '0.0' without attempts.
three_pointers_madeinteger3-point field goals made by the player in this quarter.
three_pointers_missedinteger3-point field goals missed by the player in this quarter.
three_pointers_attemptedinteger3-point field goals attempted by the player in this quarter.
three_pointers_percentagedouble3-point field goals percentage by the player in this quarter, 0-100 as a string with one decimal ('57.1'); '0.0' without attempts.
free_throws_madeintegerFree throws made by the player in this quarter.
free_throws_missedintegerFree throws missed by the player in this quarter.
free_throws_attemptedintegerFree throws attempted by the player in this quarter.
free_throws_percentagedoubleFree throws percentage by the player in this quarter, 0-100 as a string with one decimal ('57.1'); '0.0' without attempts.
reboundsintegerTotal rebounds by the player in this quarter (offensive + defensive).
defensive_reboundsintegerDefensive rebounds by the player in this quarter.
offensive_reboundsintegerOffensive rebounds by the player in this quarter.
defensive_foulsintegerFouls committed on defense by the player in this quarter.
offensive_foulsintegerFouls committed on offense by the player in this quarter.
personal_foulsintegerPersonal fouls by the player in this quarter (excludes technical, unsportsmanlike and disqualifying fouls).
foulsintegerFouls charged by the player in this quarter: personal + technical + unsportsmanlike + disqualifying; equals defensive_fouls + offensive_fouls (checked on 4,237 played player lines of 189 games).
assistsintegerAssists by the player in this quarter.
stealsintegerSteals by the player in this quarter.
blocksintegerBlocked shots by the player in this quarter.
turnoversintegerTurnovers committed by the player in this quarter; equals the sum of the *_turnovers type columns (checked on 4,237 played player lines of 189 games).
points_in_paintintegerPoints scored in the paint by the player in this quarter.
second_chance_pointsintegerPoints scored on second chances (after an offensive rebound) by the player in this quarter.
fast_break_pointsintegerPoints scored on the fast break by the player in this quarter.
efgdoubleEffective field-goal percentage by the player in this quarter, 0-100 as a string with one decimal rounded half up: (FGM + 0.5 x 3PM) / FGA; '0.0' without attempts.
tspdoubleTrue shooting percentage by the player in this quarter, 0-100 as a string with one decimal rounded half up: points / (2 x (FGA + 0.44 x FTA)); '0.0' without attempts.
pirintegerPerformance Index Rating by the player in this quarter: efficiency - fouls (verified on all 4,237 played player lines of 189 games).
field_goals_made_in_the_paintintegerField goals made in the paint by the player in this quarter.
field_goals_missed_in_the_paintintegerField goals missed in the paint by the player in this quarter.
field_goals_attempted_in_the_paintintegerField goals attempted in the paint by the player in this quarter.
field_goals_made_on_fast_breakintegerField goals made on the fast break by the player in this quarter.
field_goals_missed_on_fast_breakintegerField goals missed on the fast break by the player in this quarter.
field_goals_attempted_on_fast_breakintegerField goals attempted on the fast break by the player in this quarter.
field_goals_made_on_second_chanceintegerField goals made on a second chance (after an offensive rebound) by the player in this quarter.
field_goals_missed_on_second_chanceintegerField goals missed on a second chance (after an offensive rebound) by the player in this quarter.
field_goals_attempted_on_second_chanceintegerField goals attempted on a second chance (after an offensive rebound) by the player in this quarter.
technical_foulsintegerTechnical fouls by the player in this quarter.
unsportsmanlike_foulsintegerUnsportsmanlike fouls by the player in this quarter.
disqualifying_foulsintegerDisqualifying fouls by the player in this quarter.
bad_pass_turnoversintegerTurnovers of type 'bad pass' by the player in this quarter.
ball_handling_turnoversintegerTurnovers of type 'ball-handling error' by the player in this quarter.
out_of_bounds_turnoversintegerTurnovers of type 'out of bounds' by the player in this quarter.
travel_turnoversintegerTurnovers of type 'traveling' by the player in this quarter.
three_seconds_turnoversintegerTurnovers of type 'three-second violation' by the player in this quarter.
five_seconds_turnoversintegerTurnovers of type 'five-second violation' by the player in this quarter.
back_court_turnoversintegerTurnovers of type 'back-court violation' by the player in this quarter.
offensive_goal_tending_turnoversintegerTurnovers of type 'offensive goaltending' by the player in this quarter.
double_dribble_turnoversintegerTurnovers of type 'double dribble' by the player in this quarter.
carry_turnoversintegerTurnovers of type 'carrying' by the player in this quarter.
offensive_foul_turnoversintegerTurnovers of type 'offensive foul' by the player in this quarter.
other_turnoversintegerTurnovers of type 'other' by the player in this quarter.
points_off_turnoversintegerPoints scored off opponent turnovers by the player in this quarter.
two_pointers_jump_shot_madeinteger2-point field goals made that were a jump shot (standing or catch-and-shoot) by the player in this quarter.
two_pointers_jump_shot_missedinteger2-point field goals missed that were a jump shot (standing or catch-and-shoot) by the player in this quarter.
two_pointers_jump_shot_attemptedinteger2-point field goals attempted that were a jump shot (standing or catch-and-shoot) by the player in this quarter.
three_pointers_jump_shot_madeinteger3-point field goals made that were a jump shot (standing or catch-and-shoot) by the player in this quarter.
three_pointers_jump_shot_missedinteger3-point field goals missed that were a jump shot (standing or catch-and-shoot) by the player in this quarter.
three_pointers_jump_shot_attemptedinteger3-point field goals attempted that were a jump shot (standing or catch-and-shoot) by the player in this quarter.
two_pointers_layup_madeinteger2-point field goals made that were a layup by the player in this quarter.
two_pointers_layup_missedinteger2-point field goals missed that were a layup by the player in this quarter.
two_pointers_layup_attemptedinteger2-point field goals attempted that were a layup by the player in this quarter.
two_pointers_driving_layup_madeinteger2-point field goals made that were a driving layup by the player in this quarter.
two_pointers_driving_layup_missedinteger2-point field goals missed that were a driving layup by the player in this quarter.
two_pointers_driving_layup_attemptedinteger2-point field goals attempted that were a driving layup by the player in this quarter.
two_pointers_dunk_madeinteger2-point field goals made that were a dunk by the player in this quarter.
two_pointers_dunk_missedinteger2-point field goals missed that were a dunk by the player in this quarter.
two_pointers_dunk_attemptedinteger2-point field goals attempted that were a dunk by the player in this quarter.
two_pointers_putback_dunk_madeinteger2-point field goals made that were a putback dunk (off an offensive rebound) by the player in this quarter.
two_pointers_putback_dunk_missedinteger2-point field goals missed that were a putback dunk (off an offensive rebound) by the player in this quarter.
two_pointers_putback_dunk_attemptedinteger2-point field goals attempted that were a putback dunk (off an offensive rebound) by the player in this quarter.
two_pointers_putback_tip_in_madeinteger2-point field goals made that were a putback tip-in (off an offensive rebound) by the player in this quarter.
two_pointers_putback_tip_in_missedinteger2-point field goals missed that were a putback tip-in (off an offensive rebound) by the player in this quarter.
two_pointers_putback_tip_in_attemptedinteger2-point field goals attempted that were a putback tip-in (off an offensive rebound) by the player in this quarter.
two_pointers_alley_oop_madeinteger2-point field goals made that were a alley-oop by the player in this quarter.
two_pointers_alley_oop_missedinteger2-point field goals missed that were a alley-oop by the player in this quarter.
two_pointers_alley_oop_attemptedinteger2-point field goals attempted that were a alley-oop by the player in this quarter.
two_pointers_hook_shot_madeinteger2-point field goals made that were a hook shot by the player in this quarter.
two_pointers_hook_shot_missedinteger2-point field goals missed that were a hook shot by the player in this quarter.
two_pointers_hook_shot_attemptedinteger2-point field goals attempted that were a hook shot by the player in this quarter.
three_pointers_hook_shot_madeinteger3-point field goals made that were a hook shot by the player in this quarter.
three_pointers_hook_shot_missedinteger3-point field goals missed that were a hook shot by the player in this quarter.
three_pointers_hook_shot_attemptedinteger3-point field goals attempted that were a hook shot by the player in this quarter.
two_pointers_floating_jump_shot_madeinteger2-point field goals made that were a floating jump shot (floater) by the player in this quarter.
two_pointers_floating_jump_shot_missedinteger2-point field goals missed that were a floating jump shot (floater) by the player in this quarter.
two_pointers_floating_jump_shot_attemptedinteger2-point field goals attempted that were a floating jump shot (floater) by the player in this quarter.
three_pointers_floating_jump_shot_madeinteger3-point field goals made that were a floating jump shot (floater) by the player in this quarter.
three_pointers_floating_jump_shot_missedinteger3-point field goals missed that were a floating jump shot (floater) by the player in this quarter.
three_pointers_floating_jump_shot_attemptedinteger3-point field goals attempted that were a floating jump shot (floater) by the player in this quarter.
two_pointers_fadeaway_jump_shot_madeinteger2-point field goals made that were a fadeaway jump shot by the player in this quarter.
two_pointers_fadeaway_jump_shot_missedinteger2-point field goals missed that were a fadeaway jump shot by the player in this quarter.
two_pointers_fadeaway_jump_shot_attemptedinteger2-point field goals attempted that were a fadeaway jump shot by the player in this quarter.
three_pointers_fadeaway_jump_shot_madeinteger3-point field goals made that were a fadeaway jump shot by the player in this quarter.
three_pointers_fadeaway_jump_shot_missedinteger3-point field goals missed that were a fadeaway jump shot by the player in this quarter.
three_pointers_fadeaway_jump_shot_attemptedinteger3-point field goals attempted that were a fadeaway jump shot by the player in this quarter.
two_pointers_turnaround_jump_shot_madeinteger2-point field goals made that were a turnaround jump shot by the player in this quarter.
two_pointers_turnaround_jump_shot_missedinteger2-point field goals missed that were a turnaround jump shot by the player in this quarter.
two_pointers_turnaround_jump_shot_attemptedinteger2-point field goals attempted that were a turnaround jump shot by the player in this quarter.
three_pointers_turnaround_jump_shot_madeinteger3-point field goals made that were a turnaround jump shot by the player in this quarter.
three_pointers_turnaround_jump_shot_missedinteger3-point field goals missed that were a turnaround jump shot by the player in this quarter.
three_pointers_turnaround_jump_shot_attemptedinteger3-point field goals attempted that were a turnaround jump shot by the player in this quarter.
two_pointers_step_back_jump_shot_madeinteger2-point field goals made that were a step-back jump shot by the player in this quarter.
two_pointers_step_back_jump_shot_missedinteger2-point field goals missed that were a step-back jump shot by the player in this quarter.
two_pointers_step_back_jump_shot_attemptedinteger2-point field goals attempted that were a step-back jump shot by the player in this quarter.
three_pointers_step_back_jump_shot_madeinteger3-point field goals made that were a step-back jump shot by the player in this quarter.
three_pointers_step_back_jump_shot_missedinteger3-point field goals missed that were a step-back jump shot by the player in this quarter.
three_pointers_step_back_jump_shot_attemptedinteger3-point field goals attempted that were a step-back jump shot by the player in this quarter.
two_pointers_pull_up_jump_shot_madeinteger2-point field goals made that were a pull-up jump shot by the player in this quarter.
two_pointers_pull_up_jump_shot_missedinteger2-point field goals missed that were a pull-up jump shot by the player in this quarter.
two_pointers_pull_up_jump_shot_attemptedinteger2-point field goals attempted that were a pull-up jump shot by the player in this quarter.
three_pointers_pull_up_jump_shot_madeinteger3-point field goals made that were a pull-up jump shot by the player in this quarter.
three_pointers_pull_up_jump_shot_missedinteger3-point field goals missed that were a pull-up jump shot by the player in this quarter.
three_pointers_pull_up_jump_shot_attemptedinteger3-point field goals attempted that were a pull-up jump shot by the player in this quarter.

Details

Source, terms of use, request pacing, seasons, ids, coverage and error classes of this family: see the notes in tpbl_seasons().