The History Of Baseball

year Year	league_id League Id	team_id Team Id	franchise_id Franchise Id	div_id Div Id	rank Rank	g G	w W	l L	div_win Div Win	wc_win Wc Win	lg_win Lg Win	ws_win Ws Win	r R	ab Ab	h H	double Double	triple Triple	hr Hr	bb Bb	so So	sb Sb	cs Cs	ra Ra	er Er	era Era	cg Cg	sho Sho	sv Sv	ipouts Ipouts	ha Ha	hra Hra	bba Bba	soa Soa	e E	fp Fp	name Name	park Park	bpf Bpf	ppf Ppf	team_id_br Team Id Br	team_id_lahman45 Team Id Lahman45	team_id_retro Team Id Retro
1871	nan	BS1	BNA	nan	3	31	20	10	nan	nan	N	nan	401	1372	426	70	37	3	60	19	73		303	109	3.55	22	1	3	828	367	2	42	23	225	0.83	Boston Red Stockings	South End Grounds I	103	98	BOS	BS1	BS1
1871	nan	CH1	CNA	nan	2	28	19	9	nan	nan	N	nan	302	1196	323	52	21	10	60	22	69		241	77	2.76	25		1	753	308	6	28	22	218	0.82	Chicago White Stockings	Union Base-Ball Grounds	104	102	CHI	CH1	CH1
1871	nan	CL1	CFC	nan	8	29	10	19	nan	nan	N	nan	249	1186	328	35	40	7	26	25	18		341	116	4.11	23			762	346	13	53	34	223	0.81	Cleveland Forest Citys	National Association Grounds	96	100	CLE	CL1	CL1
1871	nan	FW1	KEK	nan	7	19	7	12	nan	nan	N	nan	137	746	178	19	8	2	33	9	16		243	97	5.17	19	1		507	261	5	21	17	163	0.8	Fort Wayne Kekiongas	Hamilton Field	101	107	KEK	FW1	FW1
1871	nan	NY2	NNA	nan	5	33	16	17	nan	nan	N	nan	302	1404	403	43	21	1	33	15	46		313	121	3.72	32	1		879	373	7	42	22	227	0.83	New York Mutuals	Union Grounds (Brooklyn)	90	88	NYU	NY2	NY2
1871	nan	PH1	PNA	nan	1	28	21	7	nan	nan	Y	nan	376	1281	410	66	27	9	46	23	56		266	137	4.95	27			747	329	3	53	16	194	0.84	Philadelphia Athletics	Jefferson Street Grounds	102	98	ATH	PH1	PH1
1871	nan	RC1	ROK	nan	9	25	4	21	nan	nan	N	nan	231	1036	274	44	25	3	38	30	53		287	108	4.3	23	1		678	315	3	34	16	220	0.82	Rockford Forest Citys	Agricultural Society Fair Grounds	97	99	ROK	RC1	RC1
1871	nan	TRO	TRO	nan	6	29	13	15	nan	nan	N	nan	351	1248	384	51	34	6	49	19	62		362	153	5.51	28			750	431	4	75	12	198	0.84	Troy Haymakers	Haymakers' Grounds	101	100	TRO	TRO	TRO
1871	nan	WS3	OLY	nan	4	32	15	15	nan	nan	N	nan	310	1353	375	54	26	6	48	13	48		303	137	4.37	32			846	371	4	45	13	217	0.85	Washington Olympics	Olympics Grounds	94	98	OLY	WS3	WS3
1872	nan	BL1	BLC	nan	2	58	35	19	nan	nan	N	nan	617	2576	747	94	35	14	27	28	35	15	434	173	3.02	48	1	1	1545	566	3	63		432	0.82	Baltimore Canaries	Newington Park	106	102	BAL	BL1	BL1


CREATE TABLE team (
  "year" BIGINT,
  "league_id" VARCHAR,
  "team_id" VARCHAR,
  "franchise_id" VARCHAR,
  "div_id" VARCHAR,
  "rank" BIGINT,
  "g" BIGINT,
  "ghome" DOUBLE,
  "w" BIGINT,
  "l" BIGINT,
  "div_win" VARCHAR,
  "wc_win" VARCHAR,
  "lg_win" VARCHAR,
  "ws_win" VARCHAR,
  "r" BIGINT,
  "ab" BIGINT,
  "h" BIGINT,
  "double" BIGINT,
  "triple" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "so" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE,
  "hbp" DOUBLE,
  "sf" DOUBLE,
  "ra" BIGINT,
  "er" BIGINT,
  "era" DOUBLE,
  "cg" BIGINT,
  "sho" BIGINT,
  "sv" BIGINT,
  "ipouts" BIGINT,
  "ha" BIGINT,
  "hra" BIGINT,
  "bba" BIGINT,
  "soa" BIGINT,
  "e" BIGINT,
  "dp" DOUBLE,
  "fp" DOUBLE,
  "name" VARCHAR,
  "park" VARCHAR,
  "attendance" DOUBLE,
  "bpf" BIGINT,
  "ppf" BIGINT,
  "team_id_br" VARCHAR,
  "team_id_lahman45" VARCHAR,
  "team_id_retro" VARCHAR
);