The History Of Baseball

year Year	league_id League Id	team_id Team Id	half Half	div_id Div Id	div_win Div Win	rank Rank	g G	w W	l L
1981	NL	ATL	1	W	N	4	54	25	29
1981	NL	ATL	2	W	N	5	52	25	27
1981	AL	BAL	1	E	N	2	54	31	23
1981	AL	BAL	2	E	N	4	51	28	23
1981	AL	BOS	1	E	N	5	56	30	26
1981	AL	BOS	2	E	N	2	52	29	23
1981	AL	CAL	1	W	N	4	60	31	29
1981	AL	CAL	2	W	N	6	50	20	30
1981	AL	CHA	1	W	N	3	53	31	22
1981	AL	CHA	2	W	N	6	53	23	30


CREATE TABLE team_half (
  "year" BIGINT,
  "league_id" VARCHAR,
  "team_id" VARCHAR,
  "half" BIGINT,
  "div_id" VARCHAR,
  "div_win" VARCHAR,
  "rank" BIGINT,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT
);