Asteroid Impacts

Asteroid Impact probability and classification

@kaggle.shrushtijoshi_asteroid_impacts

Table List

1 table(965.48 KB)

Orbits Orbits

@kaggle.shrushtijoshi_asteroid_impacts.orbits_orbits

965.48 KB
15635 rows
16 columns

object_name Object Name	epoch_tdb Epoch (TDB)	orbit_axis_au Orbit Axis (AU)	orbit_eccentricity Orbit Eccentricity	orbit_inclination_deg Orbit Inclination (deg)	perihelion_argument_deg Perihelion Argument (deg)	node_longitude_deg Node Longitude (deg)	mean_anomoly_deg Mean Anomoly (deg)	perihelion_distance_au Perihelion Distance (AU)	aphelion_distance_au Aphelion Distance (AU)	orbital_period_yr Orbital Period (yr)	minimum_orbit_intersection_distance_au Minimum Orbit Intersection Distance (AU)	orbital_reference Orbital Reference	asteroid_magnitude Asteroid Magnitude	classification Classification	hazardous Hazardous
433 Eros	57800	1.4579	0.2226	10.8277	178.805	304.3265	319.3111	1.1335	1.78	1.76	0.1492	598	11.16	Amor Asteroid
719 Albert	57800	2.6385	0.5479	11.5822	156.1409	183.9204	224.5535	1.1928	4.08	4.29	0.2004	78	15.5	Amor Asteroid
887 Alinda	57800	2.4787	0.5671	9.3561	350.3482	110.5444	351.373	1.0731	3.88	3.9	0.0925	188	13.4	Amor Asteroid
1036 Ganymed	57800	2.6628	0.5338	26.6929	132.469	215.5551	92.564	1.2413	4.08	4.35	0.3421	597	9.45	Amor Asteroid
1221 Amor	57800	1.9191	0.4356	11.8795	26.6572	171.3448	313.7379	1.0832	2.76	2.66	0.1068	70	17.7	Amor Asteroid
1566 Icarus	57800	1.0781	0.8269	22.8255	31.383	88.0107	215.5288	0.1867	1.97	1.12	0.0345	100	16.9	Apollo Asteroid	true
1580 Betulia	57800	2.1973	0.4875	52.0908	159.4852	62.2921	191.9105	1.126	3.27	3.26	0.1361	191	14.8	Amor Asteroid
1620 Geographos	57800	1.2453	0.3353	13.3375	276.893	337.208	104.1556	0.8277	1.66	1.39	0.0307	449	15.6	Apollo Asteroid	true
1627 Ivar	57800	1.8628	0.3966	8.4512	167.773	133.1445	151.4603	1.1241	2.6	2.54	0.1124	635	13.2	Amor Asteroid
1685 Toro	54520	1.3673	0.4359	9.3807	127.0826	274.3396	48.6229	0.7713	1.96	1.6	0.0504	355	14.23	Apollo Asteroid


CREATE TABLE orbits_orbits (
  "object_name" VARCHAR,
  "epoch_tdb" BIGINT,
  "orbit_axis_au" DOUBLE,
  "orbit_eccentricity" DOUBLE,
  "orbit_inclination_deg" DOUBLE,
  "perihelion_argument_deg" DOUBLE,
  "node_longitude_deg" DOUBLE,
  "mean_anomoly_deg" DOUBLE,
  "perihelion_distance_au" DOUBLE,
  "aphelion_distance_au" DOUBLE,
  "orbital_period_yr" DOUBLE,
  "minimum_orbit_intersection_distance_au" DOUBLE,
  "orbital_reference" BIGINT,
  "asteroid_magnitude" DOUBLE,
  "classification" VARCHAR,
  "hazardous" BOOLEAN
);