US Solar Eclipses 2023-2024
Which places are in both the 2023 path of annularity & 2024 path of totality?
@kaggle.joebeachcapital_us_solar_eclipses_2023_2024
Which places are in both the 2023 path of annularity & 2024 path of totality?
@kaggle.joebeachcapital_us_solar_eclipses_2023_2024
This dataset explores the paths of solar eclipses in the United States. The data comes from NASA's Scientific Visualization Studio.
On October 14, 2023, an annular solar eclipse [crossed] North, Central, and South America creating a path of annularity. An annular solar eclipse occurs when the Moon passes between the Sun and Earth while at its farthest point from Earth. Because the Moon is farther away from Earth, it does not completely block the Sun. This create[d] a “ring of fire” effect in the sky for those standing in the path of annularity. On April 8, 2024, a total solar eclipse will cross North and Central America creating a path of totality. During a total solar eclipse, the Moon completely blocks the Sun while it passes between the Sun and Earth. The sky will darken as if it were dawn or dusk and those standing in the path of totality may see the Sun’s outer atmosphere (the corona) if weather permits.
Which places are in both the 2023 path of annularity and the 2024 path of totality?
Which place has the longest duration of totality in 2024?
eclipse_annular_2023.csv| variable | class | description |
|---|---|---|
| state | character | 2-letter state abbreviation |
| name | character | city name |
| lat | double | latitude |
| lon | double | longitude |
| eclipse_1 | hms | time at which the moon first contacts the sun in this location |
| eclipse_2 | hms | time at which the eclipse is at 50% in this location |
| eclipse_3 | hms | time at which annularity begins in this location |
| eclipse_4 | hms | time at which annularity ends in this location |
| eclipse_5 | hms | time at which the eclipse is back to 50% in this location |
| eclipse_6 | hms | time at which the moon last contacts the sun in this location |
eclipse_total_2024.csv| variable | class | description |
|---|---|---|
| state | character | 2-letter state abbreviation |
| name | character | city name |
| lat | double | latitude |
| lon | double | longitude |
| eclipse_1 | hms | time at which the moon first contacts the sun in this location |
| eclipse_2 | hms | time at which the eclipse is at 50% in this location |
| eclipse_3 | hms | time at which totality begins in this location |
| eclipse_4 | hms | time at which totality ends in this location |
| eclipse_5 | hms | time at which the eclipse is back to 50% in this location |
| eclipse_6 | hms | time at which the moon last contacts the sun in this location |
eclipse_partial_2023.csv| variable | class | description |
|---|---|---|
| state | character | 2-letter state abbreviation |
| name | character | city name |
| lat | double | latitude |
| lon | double | longitude |
| eclipse_1 | hms | time at which the moon first contacts the sun in this location |
| eclipse_2 | hms | time at which the eclipse is at 50% of this location's maximum |
| eclipse_3 | hms | time at which the eclipse reaches 100% of this location's maximum |
| eclipse_4 | hms | time at which the eclipse is again at 50% of this location's maximum |
| eclipse_5 | hms | time at which the moon last contacts the sun in this location |
eclipse_partial_2024.csv| variable | class | description |
|---|---|---|
| state | character | 2-letter state abbreviation |
| name | character | city name |
| lat | double | latitude |
| lon | double | longitude |
| eclipse_1 | hms | time at which the moon first contacts the sun in this location |
| eclipse_2 | hms | time at which the eclipse is at 50% of this location's maximum |
| eclipse_3 | hms | time at which the eclipse reaches 100% of this location's maximum |
| eclipse_4 | hms | time at which the eclipse is again at 50% of this location's maximum |
| eclipse_5 | hms | time at which the moon last contacts the sun in this location |
CREATE TABLE eclipse_annular_2023 (
"state" VARCHAR,
"name" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"eclipse_1" VARCHAR,
"eclipse_2" VARCHAR,
"eclipse_3" VARCHAR,
"eclipse_4" VARCHAR,
"eclipse_5" VARCHAR,
"eclipse_6" VARCHAR
);CREATE TABLE eclipse_partial_2023 (
"state" VARCHAR,
"name" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"eclipse_1" VARCHAR,
"eclipse_2" VARCHAR,
"eclipse_3" VARCHAR,
"eclipse_4" VARCHAR,
"eclipse_5" VARCHAR
);CREATE TABLE eclipse_partial_2024 (
"state" VARCHAR,
"name" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"eclipse_1" VARCHAR,
"eclipse_2" VARCHAR,
"eclipse_3" VARCHAR,
"eclipse_4" VARCHAR,
"eclipse_5" VARCHAR
);CREATE TABLE eclipse_total_2024 (
"state" VARCHAR,
"name" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"eclipse_1" VARCHAR,
"eclipse_2" VARCHAR,
"eclipse_3" VARCHAR,
"eclipse_4" VARCHAR,
"eclipse_5" VARCHAR,
"eclipse_6" VARCHAR
);Anyone who has the link will be able to view this.