Weather Data For COVID-19 Data Analysis
Weather information from the NOAA GSOD dataset joined with COVID-19 dataset
@kaggle.davidbnn92_weather_data_for_covid19_data_analysis
Weather information from the NOAA GSOD dataset joined with COVID-19 dataset
@kaggle.davidbnn92_weather_data_for_covid19_data_analysis
The context of this dataset is that of the COVID-19 forecasting competition. By enriching the original dataset with metereological features I hope to help other researchers in their job.
In this dataset I have added weather informations, such as temperature and precipitations, to the training set of the COVID-19 forecasting competition, in order to determine whether there is any correlation with the growth of confirmed cases. Weather data is imported from the NOAA GSOD dataset, continuously updated to include recent measurments.
My gratitude goes to all who worked to both the NOAA GSOD dataset and the COVID-19 forecasting competition.
This dataset was built in order to investigate possible relationships between the spread and resistance of COVID-19, and climatical features such as temperature and humidity.
CREATE TABLE training_data_with_weather_info_week_1 (
"id" BIGINT,
"province_state" VARCHAR,
"country_region" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"date" TIMESTAMP,
"confirmedcases" DOUBLE,
"fatalities" DOUBLE,
"day_from_jan_first" BIGINT,
"temp" DOUBLE,
"min" DOUBLE,
"max" DOUBLE,
"stp" DOUBLE,
"slp" DOUBLE,
"dewp" DOUBLE,
"rh" DOUBLE,
"ah" DOUBLE,
"wdsp" DOUBLE,
"prcp" DOUBLE,
"fog" BIGINT
);CREATE TABLE training_data_with_weather_info_week_4 (
"id" BIGINT,
"country_region" VARCHAR,
"province_state" VARCHAR,
"date" TIMESTAMP,
"confirmedcases" DOUBLE,
"fatalities" DOUBLE,
"country_province" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"day_from_jan_first" BIGINT,
"temp" DOUBLE,
"min" DOUBLE,
"max" DOUBLE,
"stp" DOUBLE,
"slp" DOUBLE,
"dewp" DOUBLE,
"rh" DOUBLE,
"ah" DOUBLE,
"wdsp" DOUBLE,
"prcp" DOUBLE,
"fog" BIGINT
);Anyone who has the link will be able to view this.