The History Of Baseball

year Year	league_id League Id	team_id Team Id	park_id Park Id	span_first Span First	span_last Span Last	games Games	openings Openings	attendance Attendance
1871	nan	BS1	BOS01	Tue May 16 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 07 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	16	16	32600
1871	nan	BS1	NYC01	Sat May 27 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat May 27 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	3000
1871	nan	CH1	CHI01	Mon May 08 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 29 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	16	15	85500
1871	nan	CH1	NYC01	Mon Oct 30 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 30 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	600
1871	nan	CL1	CIN01	Sat May 13 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 22 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2	2200
1871	nan	CL1	CLE01	Thu May 11 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 27 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	11	6	9500
1871	nan	FW1	FOR01	Thu May 04 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Aug 29 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	9	4	2350
1871	nan	NY2	NYC01	Thu May 25 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 22 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	19	18	42050
1871	nan	PH1	PHI01	Sat Jun 03 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 18 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	14	14	52000
1871	nan	RC1	CHI01	Tue Aug 08 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Aug 08 1871 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	1000


CREATE TABLE home_game (
  "year" BIGINT,
  "league_id" VARCHAR,
  "team_id" VARCHAR,
  "park_id" VARCHAR,
  "span_first" TIMESTAMP,
  "span_last" TIMESTAMP,
  "games" BIGINT,
  "openings" BIGINT,
  "attendance" BIGINT
);