Dataset: Space Exploration And Satellites (AKA @Elon)

About this Dataset

Space Exploration And Satellites (AKA @Elon)

Space exploration satellites are not really satellites at all; they are properly known as space probes. A satellite is defined as something that's orbiting something else, but space probes instead travel deep into the solar system. However, they are similar to orbiting satellites in design and function.

@article{owidspaceexplorationsatellites,
author = {Edouard Mathieu and Max Roser},
title = {Space Exploration and Satellites},
journal = {Our World in Data},
year = {2022},
note = {https://ourworldindata.org/space-exploration-satellites}
}

Tables

Annual Space Visits

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.annual_space_visits

4.87 KB
306 rows
4 columns


CREATE TABLE annual_space_visits (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "annual_visits" BIGINT
);

Cost Space Launches Low Earth Orbit

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.cost_space_launches_low_earth_orbit

4.91 KB
61 rows
5 columns


CREATE TABLE cost_space_launches_low_earth_orbit (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cost_per_kg" BIGINT,
  "launch_class" VARCHAR
);

Cumulative Exoplanets By Method

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.cumulative_exoplanets_by_method

3.95 KB
116 rows
4 columns


CREATE TABLE cumulative_exoplanets_by_method (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cumulative_exoplanets" BIGINT
);

Cumulative Number Of Objects Launched Into Outer Space

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.cumulative_number_of_objects_launched_into_outer_space

8.91 KB
1082 rows
4 columns


CREATE TABLE cumulative_number_of_objects_launched_into_outer_space (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cumulative_launches" BIGINT
);

Cumulative People Space

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.cumulative_people_space

5.33 KB
248 rows
4 columns


CREATE TABLE cumulative_people_space (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cumulative_individuals" BIGINT
);

Cumulative Space Visits

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.cumulative_space_visits

5.49 KB
306 rows
4 columns


CREATE TABLE cumulative_space_visits (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cumulative_visits" BIGINT
);

Largest Impact Craters

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.largest_impact_craters

3.9 KB
20 rows
4 columns


CREATE TABLE largest_impact_craters (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "crater_diameter" BIGINT
);

Low Earth Orbits Objects

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.low_earth_orbits_objects

5.82 KB
435 rows
4 columns


CREATE TABLE low_earth_orbits_objects (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "number_of_objects" BIGINT
);

Nasa Annual Budget

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.nasa_annual_budget

4.1 KB
64 rows
4 columns


CREATE TABLE nasa_annual_budget (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "budget" DOUBLE
);

Near Earth Asteroids Discovered Over Time

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.near_earth_asteroids_discovered_over_time

5.3 KB
32 rows
6 columns


CREATE TABLE near_earth_asteroids_discovered_over_time (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "smaller_than_140m" BIGINT,
  "between_140m_and_1km" BIGINT,
  "larger_than_1km" BIGINT
);

Space Objects By Orbit

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.space_objects_by_orbit

5.82 KB
435 rows
4 columns


CREATE TABLE space_objects_by_orbit (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "number_of_objects" BIGINT
);

Yearly Number Of Objects Launched Into Outer Space

@kaggle.programmerrdai_space_exploration_and_satellites_aka_elon.yearly_number_of_objects_launched_into_outer_space

7.71 KB
1082 rows
4 columns


CREATE TABLE yearly_number_of_objects_launched_into_outer_space (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "yearly_launches" BIGINT
);