Solar System Objects

The 25 largest objects in the solar system

@kaggle.tgamsjaeger_solar_system_objects

Table List

2 tables(17.48 KB)

N 210424 Solar System Objects

@kaggle.tgamsjaeger_solar_system_objects.n_210424_solar_system_objects

9.65 KB
25 rows
11 columns

object Object	radius_km Radius (km)	mass_10e24_kg Mass (10e24 Kg)	density_g_cm3 Density (g/cm3)	gravity_m_s2 Gravity (m/s2)	semi_major_axis_km Semi-major Axis (km)	orbital_period_days Orbital Period (days)	type Type	moon_of Moon Of	year_of_discovery Year Of Discovery	position Position
Sun	696342	1988500	1.408	274			star	nan		nan
Jupiter	69911	1898.2	1.326	24.79	778570000	4332.59	planet (gas giant)	nan		outer solar system
Saturn	58232	568.34	0.687	10	1433530000	10759.22	planet (gas giant)	nan		outer solar system
Uranus	25362	86.813	1.27	8.69	2875040000	30688.5	planet (gas giant)	nan	1781	outer solar system
Neptune	24622	102.413	1.638	11.15	4500000000	60182	planet (gas giant)	nan	1846	outer solar system
Earth	6371	5.9724	5.514	9.80665	149598023	365.256	planet (terrestrial)	nan		inner solar system
Venus	6051.8	4.8675	5.243	8.872	108208000	224.701	planet (terrestrial)	nan		inner solar system
Mars	3389.5	0.6417	3.9335	3.721	227939200	686.971	planet (terrestrial)	nan		inner solar system
Ganymede	2634.1	0.1482	1.936	1.428	1070400	7.154	moon	Jupiter	1610	outer solar system
Titan	2574.73	0.1345	1.8798	1.354	1221870	15.945	moon	Saturn	1655	outer solar system


CREATE TABLE n_210424_solar_system_objects (
  "object" VARCHAR,
  "radius_km" DOUBLE,
  "mass_10e24_kg" DOUBLE,
  "density_g_cm3" DOUBLE,
  "gravity_m_s2" DOUBLE,
  "semi_major_axis_km" DOUBLE,
  "orbital_period_days" DOUBLE,
  "type" VARCHAR,
  "moon_of" VARCHAR,
  "year_of_discovery" DOUBLE,
  "position" VARCHAR
);