The History Of Baseball

player_id Player Id	year Year	stint Stint	team_id Team Id	league_id League Id	w W	l L	g G	gs Gs	cg Cg	sho Sho	ipouts Ipouts	h H	er Er	hr Hr	bb Bb	so So	era Era	bk Bk	r R
bechtge01	1871	1	PH1	nan	1	2	3	3	2		78	43	23		11	1	7.96		42
brainas01	1871	1	WS3	nan	12	15	30	30	30		792	361	132	4	37	13	4.5		292
fergubo01	1871	1	NY2	nan			1				3	8	3				27		9
fishech01	1871	1	RC1	nan	4	16	24	24	22	1	639	295	103	3	31	15	4.35		257
fleetfr01	1871	1	NY2	nan		1	1	1	1		27	20	10		3		10		21
flowedi01	1871	1	TRO	nan			1				3	1
mackde01	1871	1	RC1	nan		1	3	1	1		39	20	5		3	1	3.46		30
mathebo01	1871	1	FW1	nan	6	11	19	19	19	1	507	261	97	5	21	17	5.17	2	243
mcbridi01	1871	1	PH1	nan	18	5	25	25	25		666	285	113	3	40	15	4.58		223
mcmuljo01	1871	1	TRO	nan	12	15	29	29	28		747	430	153	4	75	12	5.53		362


CREATE TABLE pitching (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "w" BIGINT,
  "l" BIGINT,
  "g" BIGINT,
  "gs" BIGINT,
  "cg" BIGINT,
  "sho" BIGINT,
  "sv" BIGINT,
  "ipouts" DOUBLE,
  "h" BIGINT,
  "er" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "so" BIGINT,
  "baopp" DOUBLE,
  "era" DOUBLE,
  "ibb" DOUBLE,
  "wp" DOUBLE,
  "hbp" DOUBLE,
  "bk" BIGINT,
  "bfp" DOUBLE,
  "gf" DOUBLE,
  "r" BIGINT,
  "sh" DOUBLE,
  "sf" DOUBLE,
  "g_idp" DOUBLE
);