Context

As part of human exploration of the Moon, numerous space missions have been undertaken to study Earth's natural satellite.

Missions to the Moon have been conducted by the following nations and entities (in chronological order): the Soviet Union, the United States, Japan, the European Space Agency, China, India, Luxembourg, and Israel. The Moon has also been visited by five spacecraft not dedicated to studying it; four spacecraft have flown past it to gain gravity assistance, and a radio telescope, Explorer 49, was placed into selenocentric orbit in order to use the Moon to block interference from terrestrial radio sources.

Ideas

Here are some ideas that can be used on this dataset.

What type of spacecraft contributes the most?
How is the progress of launching spacecraft from both the country and the operator?
What obstacles often cause mission failure?

I'd love to see and learn great ideas from your work. for those of you who love astronomy or even those who want to become astronauts, of course, it will be fascinating to explore this dataset.

Tables

Missions

@kaggle.harits_missions_to_the_moon.missions

21.56 KB
136 rows
10 columns


CREATE TABLE missions (
  "spacecraft" VARCHAR,
  "payload" VARCHAR,
  "launch_date" VARCHAR,
  "carrier_rocket" VARCHAR,
  "country" VARCHAR,
  "operator" VARCHAR,
  "mission_type" VARCHAR,
  "outcome" VARCHAR,
  "description" VARCHAR,
  "references" VARCHAR
);

References

@kaggle.harits_missions_to_the_moon.references

14.17 KB
174 rows
2 columns


CREATE TABLE references (
  "id" BIGINT,
  "reference" VARCHAR
);