SQL Playground

One MLB team. The Athletics appear twice: Oakland (OAK) through 2024, then Sacramento (ATH) in 2025.

• team_idTEXTPK

  Retrosheet team code

• franchise_idTEXT

  Franchise code; OAK and ATH share one franchise

• cityTEXT

  Home city

• nicknameTEXT

  Club nickname

• leagueTEXT

  AL or NL

• divisionTEXT

  East, Central or West

One ballpark that hosted a game, including neutral and international sites.

• venue_idTEXTPK

  Retrosheet park code

• venue_nameTEXT

  Park name

• cityTEXT

  City

• regionTEXT

  U.S. state code, or country/territory for sites outside the 50 states

• countryTEXT

  Country or territory

One MLB season.

• seasonINTEGERPK

  Season year

• first_game_dateTEXT

  Opening day (regular season)

• last_regular_dateTEXT

  Final regular-season date

• games_per_teamINTEGER

  Scheduled regular-season games per team (60 in 2020)

• postseason_teamsINTEGER

  Clubs qualifying for the postseason

One completed regular-season or postseason game.

• game_idTEXTPK

  Retrosheet game id: home team, date and game number

• seasonINTEGER→ seasons

  Season

• game_dateTEXT

  Local game date

• game_numberINTEGER

  0 for a single game, 1 or 2 for doubleheaders

• game_typeTEXT

  regular, playoff (tiebreaker), wildcard, divisionseries, lcs or worldseries

• venue_idTEXT→ venues

  Ballpark

• home_team_idTEXT→ teams

  Home club (last at bat)

• away_team_idTEXT→ teams

  Visiting club

• home_scoreINTEGER

  Runs scored by the home club

• away_scoreINTEGER

  Runs scored by the visiting club

• day_nightTEXT · nullable

  day or night

• attendanceINTEGER · nullable

  Paid attendance; NULL when not reported (most 2020 games had no fans)

• duration_minutesINTEGER · nullable

  Game time in minutes

One player who appeared in a 2025 MLB game.

• player_idTEXTPK

  Retrosheet player id

• first_nameTEXT

  Given name

• last_nameTEXT

  Family name

• batsTEXT · nullable

  L, R or B (switch)

• throwsTEXT · nullable

  L or R

• primary_positionTEXT · nullable

  Position with the most 2025 games (P, C, 1B … DH)

• birth_dateTEXT · nullable

  Date of birth

• birth_countryTEXT · nullable

  Country of birth

• debut_dateTEXT · nullable

  MLB debut date

One player’s batting stats in one 2025 game. Pitchers usually appear with zero plate appearances.

• game_idTEXTPK→ games

  Game

• player_idTEXTPK→ players

  Batter

• team_idTEXT→ teams

  Club the player batted for

• batting_orderINTEGER · nullable

  Lineup slot 1–9; NULL for some substitutes

• startedINTEGER

  1 for the starting player in the lineup slot

• plate_appearancesINTEGER

  Plate appearances

• at_batsINTEGER

  Official at-bats

• runsINTEGER

  Runs scored

• hitsINTEGER

  Hits

• doublesINTEGER

  Doubles

• triplesINTEGER

  Triples

• home_runsINTEGER

  Home runs

• rbiINTEGER

  Runs batted in

• walksINTEGER

  Walks (including intentional)

• strikeoutsINTEGER

  Strikeouts

• stolen_basesINTEGER

  Stolen bases

• hit_by_pitchINTEGER

  Times hit by a pitch

One team’s win–loss record at the end of a month (and at season end).

• seasonINTEGERPK→ seasons

  Season

• as_of_dateTEXTPK

  Snapshot date (inclusive)

• team_idTEXTPK→ teams

  Club

• winsINTEGER

  Wins to date

• lossesINTEGER

  Losses to date

• runs_scoredINTEGER

  Runs scored to date

• runs_allowedINTEGER

  Runs allowed to date