The History Of Baseball

player_id Player Id	birth_year Birth Year	birth_month Birth Month	birth_day Birth Day	birth_country Birth Country	birth_state Birth State	birth_city Birth City	death_year Death Year	death_month Death Month	death_day Death Day	death_country Death Country	death_state Death State	death_city Death City	name_first Name First	name_last Name Last	name_given Name Given	weight Weight	height Height	bats Bats	throws Throws	debut Debut	final_game Final Game	retro_id Retro Id	bbref_id Bbref Id
aardsda01	1981	12	27	USA	CO	Denver				nan	nan	nan	David	Aardsma	David Allan	220	75	R	R	Tue Apr 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	aardd001	aardsda01
aaronha01	1934	2	5	USA	AL	Mobile				nan	nan	nan	Hank	Aaron	Henry Louis	180	72	R	R	Tue Apr 13 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 03 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	aaroh101	aaronha01
aaronto01	1939	8	5	USA	AL	Mobile	1984	8	16	USA	GA	Atlanta	Tommie	Aaron	Tommie Lee	190	75	R	R	Tue Apr 10 1962 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 26 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	aarot101	aaronto01
aasedo01	1954	9	8	USA	CA	Orange				nan	nan	nan	Don	Aase	Donald William	190	75	R	R	Tue Jul 26 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 03 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	aased001	aasedo01
abadan01	1972	8	25	USA	FL	Palm Beach				nan	nan	nan	Andy	Abad	Fausto Andres	184	73	L	L	Mon Sep 10 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	abada001	abadan01
abadfe01	1985	12	17	D.R.	La Romana	La Romana				nan	nan	nan	Fernando	Abad	Fernando Antonio	220	73	L	L	Wed Jul 28 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	abadf001	abadfe01
abadijo01	1854	11	4	USA	PA	Philadelphia	1905	5	17	USA	NJ	Pemberton	John	Abadie	John W.	192	72	R	R	Mon Apr 26 1875 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 10 1875 00:00:00 GMT+0000 (Coordinated Universal Time)	abadj101	abadijo01
abbated01	1877	4	15	USA	PA	Latrobe	1957	1	6	USA	FL	Fort Lauderdale	Ed	Abbaticchio	Edward James	170	71	R	R	Sat Sep 04 1897 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 15 1910 00:00:00 GMT+0000 (Coordinated Universal Time)	abbae101	abbated01
abbeybe01	1869	11	11	USA	VT	Essex	1962	6	11	USA	VT	Colchester	Bert	Abbey	Bert Wood	175	71	R	R	Tue Jun 14 1892 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 1896 00:00:00 GMT+0000 (Coordinated Universal Time)	abbeb101	abbeybe01
abbeych01	1866	10	14	USA	NE	Falls City	1926	4	27	USA	CA	San Francisco	Charlie	Abbey	Charles S.	169	68	L	L	Wed Aug 16 1893 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 19 1897 00:00:00 GMT+0000 (Coordinated Universal Time)	abbec101	abbeych01


CREATE TABLE player (
  "player_id" VARCHAR,
  "birth_year" DOUBLE,
  "birth_month" DOUBLE,
  "birth_day" DOUBLE,
  "birth_country" VARCHAR,
  "birth_state" VARCHAR,
  "birth_city" VARCHAR,
  "death_year" DOUBLE,
  "death_month" DOUBLE,
  "death_day" DOUBLE,
  "death_country" VARCHAR,
  "death_state" VARCHAR,
  "death_city" VARCHAR,
  "name_first" VARCHAR,
  "name_last" VARCHAR,
  "name_given" VARCHAR,
  "weight" DOUBLE,
  "height" DOUBLE,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "debut" TIMESTAMP,
  "final_game" TIMESTAMP,
  "retro_id" VARCHAR,
  "bbref_id" VARCHAR
);