Custom SQL query

AllstarFull

playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos

5,375 rows

Appearances

yearID, teamID, lgID, playerID, G_all, GS, G_batting, G_defense, G_p...

107,357 rows

AwardsManagers

playerID, awardID, yearID, lgID, tie, notes

179 rows

AwardsPlayers

playerID, awardID, yearID, lgID, tie, notes

6,236 rows

AwardsShareManagers

awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst

425 rows

AwardsSharePlayers

awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst

6,879 rows

Batting

playerID, yearID, stint, teamID, lgID, G, AB, R, H...

107,429 rows

BattingPost

yearID, round, playerID, teamID, lgID, G, AB, R, H...

14,750 rows

CollegePlaying

playerID, schoolID, yearID

17,350 rows

Fielding

playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts...

143,046 rows

FieldingOF

playerID, yearID, stint, Glf, Gcf, Grf

12,028 rows

FieldingOFsplit

playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts...

33,279 rows

FieldingPost

playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts...

13,938 rows

HallOfFame

playerID, yearID, votedBy, ballots, needed, votes, inducted, category, needed_note

4,191 rows

HomeGames

year.key, league.key, team.key, park.key, span.first, span.last, games, openings, attendance

3,108 rows

Managers

playerID, yearID, teamID, lgID, inseason, G, W, L, rank...

3,536 rows

ManagersHalf

playerID, yearID, teamID, lgID, inseason, half, G, W, L...

93 rows

Parks

park.key, park.name, park.alias, city, state, country

255 rows

People

playerID, birthYear, birthMonth, birthDay, birthCountry, birthState, birthCity, deathYear, deathMonth...

20,090 rows

Pitching

playerID, yearID, stint, teamID, lgID, W, L, G, GS...

47,628 rows

PitchingPost

playerID, yearID, round, teamID, lgID, W, L, G, GS...

5,798 rows

Salaries

yearID, teamID, lgID, playerID, salary

26,428 rows

Schools

schoolID, name_full, city, state, country

1,207 rows

SeriesPost

yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, ties

343 rows

Teams

yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W...

2,925 rows

TeamsFranchises

franchID, franchName, active, NAassoc

120 rows

TeamsHalf

yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W...

52 rows

Download SQLite DB: chadwick.db 30.3 MB