SpaceXData

datasets.json

//  spacex.capsules.parquet, 25
[
  {
    "__v": 0,
    "_id": "5e9e2c5bf35918ed873b2664",
    "land_landings": 0,
    "last_update": "Hanging in atrium at SpaceX HQ in Hawthorne ",
    "launches": "[NULL]",
    "reuse_count": 0,
    "serial": "C101",
    "status": "retired",
    "type": "Dragon 1.0",
    "water_landings": 1
  }
]

//  spacex.companies.parquet, 1
[
  {
    "_id": "5eb75edc42fea42237d7f3ed",
    "ceo": "Elon Musk",
    "coo": "Gwynne Shotwell",
    "cto": "Elon Musk",
    "cto_propulsion": "Tom Mueller",
    "employees": 9500,
    "founded": 2002,
    "founder": "Elon Musk",
    "headquarters_address": "Rocket Road",
    "headquarters_city": "Hawthorne",
    "headquarters_state": "California",
    "launch_sites": 3,
    "links_elon_twitter": null,
    "links_flickr": "https://www.flickr.com/photos/spacex/",
    "links_twitter": "https://twitter.com/SpaceX",
    "links_website": "https://www.spacex.com/",
    "name": "SpaceX",
    "summary": "SpaceX designs, manufactures and launches advanced rockets and spacecraft. The company was founded in 2002 to revolutionize space technology, with the ultimate goal of enabling people to live on other planets.",
    "test_sites": 3,
    "valuation": 74000000000,
    "vehicles": 4
  }
]

//  spacex.cores.parquet, 83
[
  {
    "__v": 0,
    "_id": "5e9e289df35918033d3b2623",
    "asds_attempts": 0,
    "asds_landings": 0,
    "block": null,
    "last_update": "Engine failure at T+33 seconds resulted in loss of vehicle",
    "launches": "[NULL]",
    "reuse_count": 0,
    "rtls_attempts": 0,
    "rtls_landings": 0,
    "serial": "Merlin1A",
    "status": "lost"
  }
]

//  spacex.crews.parquet, 30
[
  {
    "__v": 0,
    "_id": "5ebf1a6e23a9a60006e03a7a",
    "agency": "NASA",
    "image": "https://imgur.com/0smMgMH.png",
    "launches": "[NULL]",
    "name": "Robert Behnken",
    "status": "active",
    "wikipedia": "https://en.wikipedia.org/wiki/Robert_L._Behnken"
  }
]

//  spacex.dragons.parquet, 2
[
  {
    "__v": 0,
    "_id": "5e9d058759b1ff74a7ad5f8f",
    "active": true,
    "crew_capacity": 0,
    "description": "Dragon is a reusable spacecraft developed by SpaceX, an American private space transportation company based in Hawthorne, California. Dragon is launched into space by the SpaceX Falcon 9 two-stage-to-orbit launch vehicle. The Dragon spacecraft was originally designed for human travel, but so far has only been used to deliver cargo to the International Space Station (ISS).",
    "diameter_feet": 12,
    "diameter_meters": 3.7,
    "dry_mass_kg": 4200,
    "dry_mass_lb": 9300,
    "first_flight": "2010-12-08",
    "flickr_images": "['https://i.imgur.com/9fWdwNv.jpg', 'https://live.staticflickr.com/8578/16655995541_078768dea2_b.jpg', 'https://farm3.staticflickr.com/2815/32761844973_4b55b27d3c_b.jpg', 'https://farm9.staticflickr.com/8618/16649075267_d18cbb4342_b.jpg']",
    "heat_shield_dev_partner": null,
    "heat_shield_material": null,
    "heat_shield_size_meters": null,
    "heat_shield_temp_degrees": null,
    "height_w_trunk_feet": null,
    "height_w_trunk_meters": null,
    "launch_payload_mass_kg": null,
    "launch_payload_mass_lb": null,
    "launch_payload_vol_cubic_feet": null,
    "launch_payload_vol_cubic_meters": null,
    "name": "Dragon 1",
    "orbit_duration_yr": 2,
    "pressurized_capsule_payload_volume_cubic_feet": null,
    "pressurized_capsule_payload_volume_cubic_meters": null,
    "return_payload_mass_kg": null,
    "return_payload_mass_lb": null,
    "return_payload_vol_cubic_feet": null,
    "return_payload_vol_cubic_meters": null,
    "sidewall_angle_deg": 15,
    "thrusters": "[{'amount': 18, 'fuel_1': nitrogen tetroxide, 'fuel_2': monomethylhydrazine, 'isp': 300, 'pods': 4, 'thrust': '{ \"kN\" : 0.4000000000000000222,\"lbf\" : 90}', 'type': Draco}]",
    "trunk_cargo_solar_array": null,
    "trunk_cargo_unpressurized_cargo": null,
    "trunk_trunk_volume_cubic_feet": null,
    "trunk_trunk_volume_cubic_meters": null,
    "type": "capsule",
    "wikipedia": "https://en.wikipedia.org/wiki/SpaceX_Dragon"
  }
]

//  spacex.histories.parquet, 15
[
  {
    "_id": "5f6fb2cfdcfdf403df37971e",
    "details": "Falcon 1 becomes the first privately developed liquid-fuel rocket to reach Earth orbit.",
    "event_date_unix": 1222643700,
    "event_date_utc": "2008-09-28T23:15:00Z",
    "links_article": "http://www.spacex.com/news/2013/02/11/flight-4-launch-update-0",
    "title": "Falcon reaches Earth orbit"
  }
]

//  spacex.landpads.parquet, 7
[
  {
    "__v": 0,
    "_id": "5e9e3032383ecb267a34e7c7",
    "details": "SpaceX's first east coast landing pad is Landing Zone 1, where the historic first Falcon 9 landing occurred in December 2015. LC-13 was originally used as a launch pad for early Atlas missiles and rockets from Lockheed Martin. LC-1 was later expanded to include Landing Zone 2 for side booster RTLS Falcon Heavy missions, and it was first used in February 2018 for that purpose.",
    "full_name": "Landing Zone 1",
    "images_large": "['https://i.imgur.com/KHBk6jO.png']",
    "landing_attempts": 21,
    "landing_successes": 20,
    "latitude": 28.485833,
    "launches": "[NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL]",
    "locality": "Cape Canaveral",
    "longitude": -80.544444,
    "name": "LZ-1",
    "region": "Florida",
    "status": "active",
    "type": "RTLS",
    "wikipedia": "https://en.wikipedia.org/wiki/Landing_Zones_1_and_2"
  }
]

//  spacex.launches.parquet, 205
[
  {
    "__v": 0,
    "_id": "5eb87cd9ffd86e000604b32a",
    "auto_update": true,
    "capsules": "[]",
    "cores": "[{'core': 5e9e289df35918033d3b2623, 'flight': 1, 'gridfins': false, 'landing_attempt': false, 'landing_success': NULL, 'landing_type': NULL, 'landpad': NULL, 'legs': false, 'reused': false}]",
    "crew": "[]",
    "date_local": "2006-03-25T10:30:00+12:00",
    "date_precision": "hour",
    "date_unix": 1143239400,
    "date_utc": "2006-03-24T22:30:00.000Z",
    "details": "Engine failure at 33 seconds and loss of vehicle",
    "failures": "[{'altitude': NULL, 'reason': merlin engine failure, 'time': 33}]",
    "fairings": "{ \"reused\" : false,\"recovery_attempt\" : false,\"recovered\" : false,\"ships\" : [ ]}",
    "fairings_recovered": false,
    "fairings_recovery_attempt": null,
    "fairings_reused": false,
    "fairings_ships": "[]",
    "flight_number": 1,
    "launch_library_id": null,
    "launchpad": "5e9e4502f5090995de566f86",
    "links_article": "https://www.space.com/2196-spacex-inaugural-falcon-1-rocket-lost-launch.html",
    "links_flickr_original": "[]",
    "links_flickr_small": "[ ]",
    "links_patch_large": "https://images2.imgbox.com/5b/02/QcxHUb5V_o.png",
    "links_patch_small": "https://images2.imgbox.com/94/f2/NN6Ph45r_o.png",
    "links_presskit": null,
    "links_reddit_campaign": null,
    "links_reddit_launch": null,
    "links_reddit_media": null,
    "links_reddit_recovery": null,
    "links_webcast": "https://www.youtube.com/watch?v=0a_00nJ_Y88",
    "links_wikipedia": "https://en.wikipedia.org/wiki/DemoSat",
    "links_youtube_id": null,
    "name": "FalconSat",
    "net": false,
    "payloads": "[NULL]",
    "rocket": "5e9d0d95eda69955f709d1eb",
    "ships": "[]",
    "static_fire_date_unix": "1142553600",
    "static_fire_date_utc": "2006-03-17T00:00:00.000Z",
    "success": false,
    "tbd": false,
    "upcoming": false,
    "window": 0
  }
]

//  spacex.launchpads.parquet, 6
[
  {
    "__v": 0,
    "_id": "5e9e4501f5090910d4566f83",
    "details": "SpaceX's original west coast launch pad for Falcon 1. It was used in a static fire test but was never employed for a launch, and was abandoned due to range scheduling conflicts arising from overflying other active pads.",
    "full_name": "Vandenberg Space Force Base Space Launch Complex 3W",
    "images_large": "['https://i.imgur.com/7uXe1Kv.png']",
    "latitude": 34.6440904,
    "launch_attempts": 0,
    "launch_successes": 0,
    "launches": "[]",
    "locality": "Vandenberg Space Force Base",
    "longitude": -120.5931438,
    "name": "VAFB SLC 3W",
    "region": "California",
    "rockets": "[5e9d0d95eda69955f709d1eb]",
    "status": "retired",
    "timezone": "America/Los_Angeles"
  }
]

//  spacex.payloads.parquet, 225
[
  {
    "__v": 0,
    "_id": "5eb0e4b5b6c3bb0006eeb1e1",
    "apoapsis_km": 500.0,
    "arg_of_pericenter": null,
    "customers": "[DARPA]",
    "dragon_capsule": null,
    "dragon_flight_time_sec": null,
    "dragon_land_landing": null,
    "dragon_manifest": null,
    "dragon_mass_returned_kg": null,
    "dragon_mass_returned_lbs": null,
    "dragon_water_landing": null,
    "eccentricity": null,
    "epoch": null,
    "inclination_deg": 39.0,
    "launch": "5eb87cd9ffd86e000604b32a",
    "lifespan_years": null,
    "longitude": null,
    "manufacturers": "[SSTL]",
    "mass_kg": 20,
    "mass_lbs": 43.0,
    "mean_anomaly": null,
    "mean_motion": null,
    "name": "FalconSAT-2",
    "nationalities": "[United States]",
    "norad_ids": "[]",
    "orbit": "LEO",
    "periapsis_km": 400.0,
    "period_min": null,
    "raan": null,
    "reference_system": "geocentric",
    "regime": "low-earth",
    "reused": false,
    "semi_major_axis_km": null,
    "type": "Satellite"
  }
]

//  spacex.roadsters.parquet, 1
[
  {
    "_id": "5eb75f0842fea42237d7f3f4",
    "apoapsis_au": 1.664332332453025,
    "details": "Elon Musk's Tesla Roadster is an electric sports car that served as the dummy payload for the February 2018 Falcon Heavy test flight and is now an artificial satellite of the Sun. Starman, a mannequin dressed in a spacesuit, occupies the driver's seat. The car and rocket are products of Tesla and SpaceX. This 2008-model Roadster was previously used by Musk for commuting, and is the only consumer car sent into space.",
    "earth_distance_km": 320593735.82924163,
    "earth_distance_mi": 199207650.2259517,
    "eccentricity": 0.2559348215918733,
    "epoch_jd": 2459914.263888889,
    "flickr_images": "['https://farm5.staticflickr.com/4615/40143096241_11128929df_b.jpg', 'https://farm5.staticflickr.com/4702/40110298232_91b32d0cc0_b.jpg', 'https://farm5.staticflickr.com/4676/40110297852_5e794b3258_b.jpg', 'https://farm5.staticflickr.com/4745/40110304192_6e3e9a7a1b_b.jpg']",
    "inclination": 1.075052357364693,
    "launch_date_unix": 1517949900,
    "launch_date_utc": "2018-02-06T20:45:00.000Z",
    "launch_mass_kg": 1350,
    "launch_mass_lbs": 2976,
    "longitude": 316.9112133411523,
    "mars_distance_km": 395640511.90355814,
    "mars_distance_mi": 245839540.52202582,
    "name": "Elon Musk's Tesla Roadster",
    "norad_id": 43205,
    "orbit_type": "heliocentric",
    "periapsis_arg": 177.75981116285,
    "periapsis_au": 0.986015924224046,
    "period_days": 557.1958197697352,
    "semi_major_axis_au": 57.70686413577451,
    "speed_kph": 9520.88362029108,
    "speed_mph": 5916.000976023889,
    "video": "https://youtu.be/wbSwFU6tY1c",
    "wikipedia": "https://en.wikipedia.org/wiki/Elon_Musk%27s_Tesla_Roadster"
  }
]

//  spacex.rockets.parquet, 4
[
  {
    "__v": 0,
    "_id": "5e9d0d95eda69955f709d1eb",
    "active": false,
    "boosters": 0,
    "company": "SpaceX",
    "cost_per_launch": 6700000,
    "country": "Republic of the Marshall Islands",
    "description": "The Falcon 1 was an expendable launch system privately developed and manufactured by SpaceX during 2006-2009. On 28 September 2008, Falcon 1 became the first privately-developed liquid-fuel launch vehicle to go into orbit around the Earth.",
    "diameter_feet": 5.5,
    "diameter_meters": 1.68,
    "engines_engine_loss_max": null,
    "engines_isp_sea_level": null,
    "engines_isp_vacuum": 304,
    "engines_layout": "single",
    "engines_number": 1,
    "engines_propellant_1": null,
    "engines_propellant_2": null,
    "engines_thrust_sea_level_kN": null,
    "engines_thrust_sea_level_lbf": null,
    "engines_thrust_to_weight": null,
    "engines_thrust_vacuum_kN": null,
    "engines_thrust_vacuum_lbf": null,
    "engines_type": "merlin",
    "engines_version": "1C",
    "first_flight": "2006-03-24",
    "first_stage_burn_time_sec": null,
    "first_stage_engines": null,
    "first_stage_fuel_amount_tons": null,
    "first_stage_reusable": null,
    "first_stage_thrust_sea_level_kN": null,
    "first_stage_thrust_sea_level_lbf": null,
    "first_stage_thrust_vacuum_kN": null,
    "first_stage_thrust_vacuum_lbf": null,
    "flickr_images": "['https://imgur.com/DaCfMsj.jpg', 'https://imgur.com/azYafd8.jpg']",
    "height_feet": 73.0,
    "height_meters": 22.25,
    "landing_legs_material": null,
    "landing_legs_number": null,
    "mass_kg": 30146,
    "mass_lb": 66460,
    "name": "Falcon 1",
    "payload_weights": "[{'id': leo, 'kg': 450, 'lb': 992, 'name': Low Earth Orbit}]",
    "second_stage_burn_time_sec": null,
    "second_stage_engines": null,
    "second_stage_fuel_amount_tons": null,
    "second_stage_payloads_composite_fairing_diameter_feet": null,
    "second_stage_payloads_composite_fairing_diameter_meters": null,
    "second_stage_payloads_composite_fairing_height_feet": null,
    "second_stage_payloads_composite_fairing_height_meters": null,
    "second_stage_payloads_option_1": null,
    "second_stage_reusable": null,
    "second_stage_thrust_kN": null,
    "second_stage_thrust_lbf": null,
    "stages": 2,
    "success_rate_pct": 40,
    "type": "rocket",
    "wikipedia": "https://en.wikipedia.org/wiki/Falcon_1"
  }
]

//  spacex.ships.parquet, 29
[
  {
    "__v": 0,
    "_id": "5ea6ed2d080df4000697c901",
    "abs": 571252,
    "active": false,
    "class": 7604342,
    "course_deg": null,
    "home_port": "Port of Los Angeles",
    "image": "https://i.imgur.com/woCxpkj.jpg",
    "imo": 7434016,
    "latitude": null,
    "launches": "[NULL, NULL]",
    "legacy_id": "AMERICANCHAMPION",
    "link": "https://www.marinetraffic.com/en/ais/details/ships/shipid:434663/mmsi:367020820/imo:7434016/vessel:AMERICAN_CHAMPION",
    "longitude": null,
    "mass_kg": 266712,
    "mass_lbs": 588000,
    "mmsi": 367020820,
    "model": null,
    "name": "American Champion",
    "roles": "[Support Ship, Barge Tug]",
    "speed_kn": null,
    "status": "",
    "type": "Tug",
    "year_built": 1976
  }
]

//  spacex.starlinks.parquet, 3526
[
  {
    "__v": 0,
    "_id": "5eed770f096e59000698560d",
    "height_km": null,
    "latitude": null,
    "launch": "5eb87d30ffd86e000604b378",
    "longitude": null,
    "spaceTrack_APOAPSIS": 159.809,
    "spaceTrack_ARG_OF_PERICENTER": null,
    "spaceTrack_BSTAR": 0.0022139,
    "spaceTrack_CCSDS_OMM_VERS": null,
    "spaceTrack_CENTER_NAME": null,
    "spaceTrack_CLASSIFICATION_TYPE": null,
    "spaceTrack_COMMENT": "GENERATED VIA SPACE-TRACK.ORG API",
    "spaceTrack_COUNTRY_CODE": null,
    "spaceTrack_CREATION_DATE": null,
    "spaceTrack_DECAYED": 1,
    "spaceTrack_DECAY_DATE": null,
    "spaceTrack_ECCENTRICITY": 0.0003711,
    "spaceTrack_ELEMENT_SET_NO": null,
    "spaceTrack_EPHEMERIS_TYPE": null,
    "spaceTrack_EPOCH": "2020-10-13T02:56:59.566560",
    "spaceTrack_FILE": 2850561,
    "spaceTrack_GP_ID": null,
    "spaceTrack_INCLINATION": 52.9708,
    "spaceTrack_LAUNCH_DATE": null,
    "spaceTrack_MEAN_ANOMALY": null,
    "spaceTrack_MEAN_ELEMENT_THEORY": null,
    "spaceTrack_MEAN_MOTION": null,
    "spaceTrack_MEAN_MOTION_DDOT": null,
    "spaceTrack_MEAN_MOTION_DOT": null,
    "spaceTrack_NORAD_CAT_ID": null,
    "spaceTrack_OBJECT_ID": null,
    "spaceTrack_OBJECT_NAME": null,
    "spaceTrack_OBJECT_TYPE": null,
    "spaceTrack_ORIGINATOR": "18 SPCS",
    "spaceTrack_PERIAPSIS": 154.958,
    "spaceTrack_PERIOD": 87.635,
    "spaceTrack_RA_OF_ASC_NODE": null,
    "spaceTrack_RCS_SIZE": null,
    "spaceTrack_REF_FRAME": null,
    "spaceTrack_REV_AT_EPOCH": null,
    "spaceTrack_SEMIMAJOR_AXIS": null,
    "spaceTrack_SITE": "AFETR",
    "spaceTrack_TIME_SYSTEM": null,
    "spaceTrack_TLE_LINE0": null,
    "spaceTrack_TLE_LINE1": null,
    "spaceTrack_TLE_LINE2": null,
    "velocity_kms": null,
    "version": "v0.9"
  }
]