Hurricanes And Typhoons, 1851-2014
Location, wind, and pressure of tropical cyclones in Atlantic and Pacific Oceans
@kaggle.noaa_hurricane_database
Location, wind, and pressure of tropical cyclones in Atlantic and Pacific Oceans
@kaggle.noaa_hurricane_database
The National Hurricane Center (NHC) conducts a post-storm analysis of each tropical cyclone in the Atlantic
basin (i.e., North Atlantic Ocean, Gulf of Mexico, and Caribbean Sea) and and the North Pacific Ocean to determine the official assessment of the cyclone's history. This analysis makes use of all available observations, including those that may not have been available in real time. In addition, NHC conducts ongoing reviews of any retrospective tropical cyclone analyses brought to its attention and on a regular basis updates the historical record to reflect
changes introduced.
The NHC publishes the tropical cyclone historical database in a format known as HURDAT, short for HURricane DATabase. These databases (Atlantic HURDAT2 and NE/NC Pacific HURDAT2) contain six-hourly information on the location, maximum winds, central pressure, and (starting in 2004) size of all known tropical cyclones and subtropical cyclones.
CREATE TABLE atlantic (
"id" VARCHAR,
"name" VARCHAR,
"date" BIGINT,
"time" BIGINT,
"event" VARCHAR,
"status" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR,
"maximum_wind" BIGINT,
"minimum_pressure" BIGINT,
"low_wind_ne" BIGINT,
"low_wind_se" BIGINT,
"low_wind_sw" BIGINT,
"low_wind_nw" BIGINT,
"moderate_wind_ne" BIGINT,
"moderate_wind_se" BIGINT,
"moderate_wind_sw" BIGINT,
"moderate_wind_nw" BIGINT,
"high_wind_ne" BIGINT,
"high_wind_se" BIGINT,
"high_wind_sw" BIGINT,
"high_wind_nw" BIGINT
);CREATE TABLE pacific (
"id" VARCHAR,
"name" VARCHAR,
"date" BIGINT,
"time" BIGINT,
"event" VARCHAR,
"status" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR,
"maximum_wind" BIGINT,
"minimum_pressure" BIGINT,
"low_wind_ne" BIGINT,
"low_wind_se" BIGINT,
"low_wind_sw" BIGINT,
"low_wind_nw" BIGINT,
"moderate_wind_ne" BIGINT,
"moderate_wind_se" BIGINT,
"moderate_wind_sw" BIGINT,
"moderate_wind_nw" BIGINT,
"high_wind_ne" BIGINT,
"high_wind_se" BIGINT,
"high_wind_sw" BIGINT,
"high_wind_nw" BIGINT
);Anyone who has the link will be able to view this.