Name: US Solar Eclipses 2023-2024
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Solar Eclipses 2023-2024

2023 & 2024 US Solar Eclipses

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?

Data Dictionary

`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

Tables

Eclipse Annular 2023

@kaggle.joebeachcapital_us_solar_eclipses_2023_2024.eclipse_annular_2023

43.21 KB
811 rows
10 columns


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
);

Eclipse Partial 2023

@kaggle.joebeachcapital_us_solar_eclipses_2023_2024.eclipse_partial_2023

1.02 MB
31363 rows
9 columns


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
);

Eclipse Partial 2024

@kaggle.joebeachcapital_us_solar_eclipses_2023_2024.eclipse_partial_2024

966.79 KB
28844 rows
9 columns


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
);

Eclipse Total 2024

@kaggle.joebeachcapital_us_solar_eclipses_2023_2024.eclipse_total_2024

143.32 KB
3330 rows
10 columns


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
);