NASA: Asteroids Classification
Information on Asteroids collected from NASA API.
@kaggle.lovishbansal123_nasa_asteroids_classification
Information on Asteroids collected from NASA API.
@kaggle.lovishbansal123_nasa_asteroids_classification
CREATE TABLE nasa (
"neo_reference_id" BIGINT,
"name" BIGINT,
"absolute_magnitude" DOUBLE,
"est_dia_in_km_min" DOUBLE,
"est_dia_in_km_max" DOUBLE,
"est_dia_in_m_min" DOUBLE,
"est_dia_in_m_max" DOUBLE,
"est_dia_in_miles_min" DOUBLE,
"est_dia_in_miles_max" DOUBLE,
"est_dia_in_feet_min" DOUBLE,
"est_dia_in_feet_max" DOUBLE,
"close_approach_date" TIMESTAMP,
"epoch_date_close_approach" BIGINT,
"relative_velocity_km_per_sec" DOUBLE,
"relative_velocity_km_per_hr" DOUBLE,
"miles_per_hour" DOUBLE,
"miss_dist_astronomical" DOUBLE,
"miss_dist_lunar" DOUBLE,
"miss_dist_kilometers" DOUBLE,
"miss_dist_miles" DOUBLE,
"orbiting_body" VARCHAR,
"orbit_id" BIGINT,
"orbit_determination_date" TIMESTAMP,
"orbit_uncertainity" BIGINT,
"minimum_orbit_intersection" DOUBLE,
"jupiter_tisserand_invariant" DOUBLE,
"epoch_osculation" DOUBLE,
"eccentricity" DOUBLE,
"semi_major_axis" DOUBLE,
"inclination" DOUBLE,
"asc_node_longitude" DOUBLE,
"orbital_period" DOUBLE,
"perihelion_distance" DOUBLE,
"perihelion_arg" DOUBLE,
"aphelion_dist" DOUBLE,
"perihelion_time" DOUBLE,
"mean_anomaly" DOUBLE,
"mean_motion" DOUBLE,
"equinox" VARCHAR,
"hazardous" BOOLEAN
);
Anyone who has the link will be able to view this.