NASA Astronauts, 1959-Present

Which American astronaut has spent the most time in space?

@kaggle.nasa_astronaut_yearbook

Table List

1 table(43.69 KB)

Astronauts

@kaggle.nasa_astronaut_yearbook.astronauts

43.69 KB
357 rows
19 columns

name Name	year Year	group Group	status Status	birth_date Birth Date	birth_place Birth Place	gender Gender	alma_mater Alma Mater	undergraduate_major Undergraduate Major	graduate_major Graduate Major	military_rank Military Rank	military_branch Military Branch	space_flights Space Flights	space_flight_hr Space Flight (hr)	space_walks Space Walks	space_walks_hr Space Walks (hr)	missions Missions	death_date Death Date	death_mission Death Mission
Joseph M. Acaba	2004	19	Active	Wed May 17 1967 00:00:00 GMT+0000 (Coordinated Universal Time)	Inglewood, CA	Male	University of California-Santa Barbara; University of Arizona	Geology	Geology	nan	nan	2	3307	2	13	STS-119 (Discovery), ISS-31/32 (Soyuz)	nan	nan
Loren W. Acton			Retired	Sat Mar 07 1936 00:00:00 GMT+0000 (Coordinated Universal Time)	Lewiston, MT	Male	Montana State University; University of Colorado	Engineering Physics	Solar Physics	nan	nan	1	190			STS 51-F (Challenger)	nan	nan
James C. Adamson	1984	10	Retired	Sun Mar 03 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	Warsaw, NY	Male	US Military Academy; Princeton University	Engineering	Aerospace Engineering	Colonel	US Army (Retired)	2	334			STS-28 (Columbia), STS-43 (Atlantis)	nan	nan
Thomas D. Akers	1987	12	Retired	Sun May 20 1951 00:00:00 GMT+0000 (Coordinated Universal Time)	St. Louis, MO	Male	University of Missouri-Rolla	Applied Mathematics	Applied Mathematics	Colonel	US Air Force (Retired)	4	814	4	29	STS-41 (Discovery), STS-49 (Endeavor), STS-61 (Endeavor), STS-79 (Atlantis)	nan	nan
Buzz Aldrin	1963	3	Retired	Mon Jan 20 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Montclair, NJ	Male	US Military Academy; MIT	Mechanical Engineering	Astronautics	Colonel	US Air Force (Retired)	2	289	2	8	Gemini 12, Apollo 11	nan	nan
Andrew M. Allen	1987	12	Retired	Thu Aug 04 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	Philadelphia, PA	Male	Villanova University; University of Florida	Mechanical Engineering	Business Administration	Lieutenant Colonel	US Marine Corps (Retired)	3	906			STS-46 (Atlantis), STS-62 (Columbia), STS-75 (Columbia)	nan	nan
Joseph P. Allen	1967	6	Retired	Sun Jun 27 1937 00:00:00 GMT+0000 (Coordinated Universal Time)	Crawsfordsville, IN	Male	DePauw University; Yale University	Mathematics & Physics	Physics	nan	nan	2	313	2	12	ST-5 (Columbia), STS 51-A (Discovery)	nan	nan
Scott D. Altman	1995	15	Retired	Sat Aug 15 1959 00:00:00 GMT+0000 (Coordinated Universal Time)	Lincoln, IL	Male	University of Illinois; US Naval Postgraduate School	Aeronautical & Astronautical Engineering	Aeronautical Engineering	Captain	US Navy (Retired)	4	1236			STS-90 (Columbia), STS-106 (Atlantis), STS-109 (Columbia), STS-125 (Atlantis)	nan	nan
William A. Anders	1963	3	Retired	Tue Oct 17 1933 00:00:00 GMT+0000 (Coordinated Universal Time)	Hong Kong	Male	US Naval Academy; Air Force Institute of Technology	Nuclear Engineering	Nuclear Engineering	Major General	US Air Force Reserves (Retired)	1	147			Apollo 8	nan	nan
Clayton C. Anderson	1998	17	Retired	Mon Feb 23 1959 00:00:00 GMT+0000 (Coordinated Universal Time)	Omaha, NE	Male	Hastings College; Iowa State University	Physics	Aerospace Engineering	nan	nan	2	4005	6	38	STS-117/120 (Atlantis/Discovery), STS-131 (Discovery)	nan	nan


CREATE TABLE astronauts (
  "name" VARCHAR,
  "year" DOUBLE,
  "group" DOUBLE,
  "status" VARCHAR,
  "birth_date" TIMESTAMP,
  "birth_place" VARCHAR,
  "gender" VARCHAR,
  "alma_mater" VARCHAR,
  "undergraduate_major" VARCHAR,
  "graduate_major" VARCHAR,
  "military_rank" VARCHAR,
  "military_branch" VARCHAR,
  "space_flights" BIGINT,
  "space_flight_hr" BIGINT,
  "space_walks" BIGINT,
  "space_walks_hr" DOUBLE,
  "missions" VARCHAR,
  "death_date" VARCHAR,
  "death_mission" VARCHAR
);