Possible Asteroid Impacts With Earth

Name, orbit, and year range for impacts predicted by Sentry system

@kaggle.nasa_asteroid_impacts

Table List

2 tables(996.2 KB)

Impacts

@kaggle.nasa_asteroid_impacts.impacts

31.34 KB
683 rows
11 columns

object_name Object Name	period_start Period Start	period_end Period End	possible_impacts Possible Impacts	cumulative_impact_probability Cumulative Impact Probability	asteroid_velocity Asteroid Velocity	asteroid_magnitude Asteroid Magnitude	asteroid_diameter_km Asteroid Diameter (km)	cumulative_palermo_scale Cumulative Palermo Scale	maximum_palermo_scale Maximum Palermo Scale
2006 WP1	2017	2017	1	5.2e-9	17.77	28.3	0.007	-8.31	-8.31
2013 YB	2017	2046	23	0.000076	8.98	31.4	0.002	-6.6	-6.96
2008 US	2017	2062	30	0.000016	18.33	31.4	0.002	-6.48	-6.87
2010 VR139	2017	2076	24	2e-7	4.99	26.7	0.016	-6.83	-6.95
2015 ME131	2017	2096	85	2.3e-8	19.46	19.2	0.497	-3.85	-4.3
2010 XB73	2017	2110	55	2.8e-7	5.98	22.5	0.11	-5.03	-5.51
2005 TM173	2017	2111	123	9e-7	8.79	24.1	0.052	-5.41	-6.42
2006 SF281	2017	2111	514	0.0000019	4.49	26.2	0.02	-5.91	-7.58
2010 VP139	2017	2112	350	0.000018	2.04	28.5	0.007	-6.51	-7.54
2014 HR197	2017	2112	187	7.9e-8	17.02	26.9	0.014	-7.18	-7.97


CREATE TABLE impacts (
  "object_name" VARCHAR,
  "period_start" BIGINT,
  "period_end" BIGINT,
  "possible_impacts" BIGINT,
  "cumulative_impact_probability" DOUBLE,
  "asteroid_velocity" DOUBLE,
  "asteroid_magnitude" DOUBLE,
  "asteroid_diameter_km" DOUBLE,
  "cumulative_palermo_scale" DOUBLE,
  "maximum_palermo_scale" DOUBLE,
  "maximum_torino_scale" VARCHAR
);