Dataset: Planets & Moons

About this Dataset

Planets & Moons

Planets

The planets.csv file contains information about planets in our Solar System including dwarf planet Pluto. The source of data is Planetary Fact Sheet from NASA Jet Propulsion Laboratory.

Fields and units in the planetary dataset

See also official Planetary Fact Sheet Notes for more information about individual fields.

Mass (1024kg)
Diameter (km)
Density (kg/m3)
Gravity (m/s2)
Escape Velocity (km/s)
Rotation Period (hours)
Length of Day (hours)
Distance from Sun (106 km)
Perihelion (106 km)
Aphelion (106 km)
Orbital Period (days)
Orbital Velocity (km/s)
Orbital Inclination (degrees)
Orbital Eccentricity
Obliquity to Orbit (degrees)
Mean Temperature (C)
Surface Pressure (bars)
Number of Moons (number)
Ring System? (Yes/No)
Global Magnetic Field? (Yes/No)

Planetary satellites (moons)

The satellites.csv file contains information about planetary satellites (moons) of planets in our Solar System. Moons of dwarf planet Pluto are included as well. The source of data is Planetary Satellite Physical Parameters from NASA Jet Propulsion Laboratory.

Fields and units in the satellites dataset

planet: owning planet of the satellite
name: name of the satellite
gm: GM (km3/sec2)
radius: Mean radius (km)
density: Mean density (g/cm3)
magnitude: Magnitude V0 or R
albedo: Geometric Albedo

Tables

Planets

@kaggle.joebeachcapital_planets_and_moons.planets

16.08 KB
9 rows
21 columns


CREATE TABLE planets (
  "planet" VARCHAR,
  "mass" DOUBLE,
  "diameter" BIGINT,
  "density" BIGINT,
  "gravity" DOUBLE,
  "escape_velocity" DOUBLE,
  "rotation_period" DOUBLE,
  "length_of_day" DOUBLE,
  "distance_from_sun" DOUBLE,
  "perihelion" DOUBLE,
  "aphelion" DOUBLE,
  "orbital_period" DOUBLE,
  "orbital_velocity" DOUBLE,
  "orbital_inclination" DOUBLE,
  "orbital_eccentricity" DOUBLE,
  "obliquity_to_orbit" DOUBLE,
  "mean_temperature" BIGINT,
  "surface_pressure" VARCHAR,
  "number_of_moons" BIGINT,
  "has_ring_system" VARCHAR,
  "has_global_magnetic_field" VARCHAR
);

Satellites

@kaggle.joebeachcapital_planets_and_moons.satellites

9.97 KB
177 rows
7 columns


CREATE TABLE satellites (
  "planet" VARCHAR,
  "name" VARCHAR,
  "gm" VARCHAR,
  "radius" VARCHAR,
  "density" VARCHAR,
  "magnitude" VARCHAR,
  "albedo" VARCHAR
);