The History Of Baseball

player_id Player Id	year Year	stint Stint	team_id Team Id	league_id League Id	g G	ab Ab	r R	h H	double Double	triple Triple	hr Hr	rbi Rbi	sb Sb	cs Cs	bb Bb	so So
abercda01	1871	1	TRO	nan	1	4
addybo01	1871	1	RC1	nan	25	118	30	32	6			13	8	1	4
allisar01	1871	1	CL1	nan	29	137	28	40	4	5		19	3	1	2	5
allisdo01	1871	1	WS3	nan	27	133	28	44	10	2	2	27	1	1		2
ansonca01	1871	1	RC1	nan	25	120	29	39	11	3		16	6	2	2	1
armstbo01	1871	1	FW1	nan	12	49	9	11	2	1		5		1		1
barkeal01	1871	1	RC1	nan	1	4		1				2			1
barnero01	1871	1	BS1	nan	31	157	66	63	10	9		34	11	6	13	1
barrebi01	1871	1	FW1	nan	1	5	1	1	1			1
barrofr01	1871	1	BS1	nan	18	86	13	13	2	1		11	1


CREATE TABLE batting (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "g" BIGINT,
  "ab" DOUBLE,
  "r" DOUBLE,
  "h" DOUBLE,
  "double" DOUBLE,
  "triple" DOUBLE,
  "hr" DOUBLE,
  "rbi" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE,
  "bb" DOUBLE,
  "so" DOUBLE,
  "ibb" DOUBLE,
  "hbp" DOUBLE,
  "sh" DOUBLE,
  "sf" DOUBLE,
  "g_idp" DOUBLE
);