Planetary Dataset

This dataset provides detailed information about the planets in our solar system

@kaggle.prathamjyotsingh_planets_dataset

Table List

1 table(21.29 KB)

Planet1

@kaggle.prathamjyotsingh_planets_dataset.planet1

21.29 KB
8 rows
28 columns

name Name	type Type	dominant_color Dominant Color	mass_10_23kg Mass (10^23kg)	radius_10km Radius (10km)	density_g_cm_3 Density (g/cm^3)	surface_gravity_m_s_2 Surface Gravity (m/s^2)	escape_velocity_km_s Escape Velocity (km/s)	mean_temperature_c Mean Temperature (�C)	surface_pressure_pa Surface Pressure (Pa)	albedo Albedo	rotation_period_hours Rotation Period (hours)	axial_tilt_degrees Axial Tilt (degrees)	moons Moons	orbital_period_days Orbital Period (days)	orbital_distance_au Orbital Distance (AU)	eccentricity Eccentricity	inclination_degrees Inclination (degrees)	aphelion_au Aphelion (AU)	perihelion_au Perihelion (AU)	geological_activity Geological Activity	ring_system Ring System	magnetic_field_strength Magnetic Field Strength	greenhouse_effect Greenhouse Effect	maximum_wind_speed_km_h Maximum Wind Speed (km/h)	average_distance_from_the_sun_million_km Average Distance From The Sun (million Km)	surface_characteristics Surface Characteristics	most_abundant_element Most Abundant Element
Mercury	Terrestrial	Grey Brown	3.3	2439.7	5.43	3.7	4.25	167		0.12	1407.6	0.034		88	0.39	0.206	7	0.466	0.307		No	Weak	Minimal	Minimal	57.9	Rocky surface	Iron
Venus	Terrestrial	Yellow	48.7	6051.8	5.24	8.87	10.36	464	92000	0.65	5832	177.4		225	0.72	0.007	3.4	0.728	0.718	true	No	Weak	Extreme	360	108.2	Rocky surface	Carbon Dioxide
Earth	Terrestrial	Blue	59.7	6371	5.52	9.81	11.19	15	101325	0.3	23.9	23.5	1	365.25	1	0.017		1.017	0.983	true	No	Strong	Moderate	300	149.6	Diverse surface	Nitrogen
Mars	Terrestrial	Red	6.42	3389.5	3.93	3.71	5.03	-65	610	0.25	24.6	25.2	2	687	1.52	0.094	1.9	1.666	1.381		No	Weak	Weak	100	227.9	Rocky surface	Iron Oxide
Jupiter	Gas Giant	Orange Brown	19000	69911	1.33	24.79	59.5	-110		0.52	9.9	3.1	92	4333	5.2	0.049	1.3	5.46	4.95		Yes	Strong	Minimal	432	778.5	No solid surface	Hydrogen
Saturn	Gas Giant	Yellow	5680	58232	0.69	10.44	35.5	-140		0.47	10.7	26.7	83	10759	9.58	0.056	2.5	10.12	9.05		Yes	Strong	Minimal	1800	1430	No solid surface	Hydrogen
Uranus	Ice Giant	Blue Green	868	25362	1.27	8.69	21.3	-195		0.51	17.2	97.8	27	30687	19.22	0.046	0.8	20.11	18.33		Yes	Weak	Minimal	900	2870	No solid surface	Hydrogen
Neptune	Ice Giant	Blue	1020	24622	1.64	11.15	23.5	-200		0.41	16.1	28.3	14	60190	30.05	0.01	1.8	30.33	29.81		Yes	Strong	Minimal	2100	4500	No solid surface	Hydrogen


CREATE TABLE planet1 (
  "name" VARCHAR,
  "type" VARCHAR,
  "dominant_color" VARCHAR,
  "mass_10_23kg" DOUBLE,
  "radius_10km" DOUBLE,
  "density_g_cm_3" DOUBLE,
  "surface_gravity_m_s_2" DOUBLE,
  "escape_velocity_km_s" DOUBLE,
  "mean_temperature_c" BIGINT,
  "surface_pressure_pa" DOUBLE,
  "albedo" DOUBLE,
  "rotation_period_hours" DOUBLE,
  "axial_tilt_degrees" DOUBLE,
  "moons" BIGINT,
  "orbital_period_days" DOUBLE,
  "orbital_distance_au" DOUBLE,
  "eccentricity" DOUBLE,
  "inclination_degrees" DOUBLE,
  "aphelion_au" DOUBLE,
  "perihelion_au" DOUBLE,
  "geological_activity" BOOLEAN,
  "ring_system" VARCHAR,
  "magnetic_field_strength" VARCHAR,
  "greenhouse_effect" VARCHAR,
  "maximum_wind_speed_km_h" VARCHAR,
  "average_distance_from_the_sun_million_km" DOUBLE,
  "surface_characteristics" VARCHAR,
  "most_abundant_element" VARCHAR
);