chadwick

Custom SQL query

AllstarFull

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

5,291 rows

Appearances

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

105,789 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...

105,861 rows

BattingPost

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

14,354 rows

CollegePlaying

playerID, schoolID, yearID

17,350 rows

Fielding

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

140,921 rows

FieldingOF

playerID, yearID, stint, Glf, Gcf, Grf

12,028 rows

FieldingOFsplit

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

32,602 rows

FieldingPost

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

13,534 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,074 rows

Managers

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

3,504 rows

ManagersHalf

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

93 rows

Parks

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

252 rows

People

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

19,878 rows

Pitching

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

46,699 rows

PitchingPost

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

5,624 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

334 rows

Teams

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

2,895 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 29.8 MB

Powered by Datasette · Query took 33.112ms