The History Of Baseball

player_id Player Id	year Year	stint Stint	team_id Team Id	league_id League Id	pos Pos	g G	po Po	a A	e E	dp Dp
abercda01	1871	1	TRO	nan	SS	1	1	3	2
addybo01	1871	1	RC1	nan	2B	22	67	72	42	5
addybo01	1871	1	RC1	nan	SS	3	8	14	7
allisar01	1871	1	CL1	nan	2B	2	1	4
allisar01	1871	1	CL1	nan	OF	29	51	3	7	1
allisdo01	1871	1	WS3	nan	C	27	68	15	20	4
ansonca01	1871	1	RC1	nan	1B	1	7
ansonca01	1871	1	RC1	nan	2B	2	3	4	1
ansonca01	1871	1	RC1	nan	3B	20	38	52	28	2
ansonca01	1871	1	RC1	nan	C	5	10		8


CREATE TABLE fielding (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "pos" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "inn_outs" DOUBLE,
  "po" DOUBLE,
  "a" DOUBLE,
  "e" DOUBLE,
  "dp" DOUBLE,
  "pb" DOUBLE,
  "wp" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE,
  "zr" DOUBLE
);