The History Of Baseball

year Year	team_id Team Id	league_id League Id	player_id Player Id	g_all G All	g_batting G Batting	g_defense G Defense	g_p G P	g_c G C	g_1b G 1b	g_2b G 2b	g_3b G 3b	g_ss G Ss	g_lf G Lf	g_cf G Cf	g_rf G Rf	g_of G Of
1871	BS1	nan	barnero01	31	31	31				16		15
1871	BS1	nan	barrofr01	18	18	18				1			13		4	17
1871	BS1	nan	birdsda01	29	29	29		7							27	27
1871	BS1	nan	conefr01	19	19	19							18		1	18
1871	BS1	nan	gouldch01	31	31	31			30						1	1
1871	BS1	nan	jackssa01	16	16	16				14		1		1		1
1871	BS1	nan	mcveyca01	29	29	29		29			1				5	5
1871	BS1	nan	schafha01	31	31	31					31
1871	BS1	nan	spaldal01	31	31	31	31							9		9
1871	BS1	nan	wrighge01	16	16	16			1			15


CREATE TABLE appearances (
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "player_id" VARCHAR,
  "g_all" DOUBLE,
  "gs" DOUBLE,
  "g_batting" BIGINT,
  "g_defense" DOUBLE,
  "g_p" BIGINT,
  "g_c" BIGINT,
  "g_1b" BIGINT,
  "g_2b" BIGINT,
  "g_3b" BIGINT,
  "g_ss" BIGINT,
  "g_lf" BIGINT,
  "g_cf" BIGINT,
  "g_rf" BIGINT,
  "g_of" BIGINT,
  "g_dh" DOUBLE,
  "g_ph" DOUBLE,
  "g_pr" DOUBLE
);