COVID-19: Forecast Trends For The Many Countries
Comprehensive and comparative analysis of forecasts
@kaggle.vbmokin_covid19_forecast_trends_for_the_many_countries
Comprehensive and comparative analysis of forecasts
@kaggle.vbmokin_covid19_forecast_trends_for_the_many_countries
CREATE TABLE forecast_future_dfs_2021_01_24 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_01_31 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_02_07 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_02_14 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_02_21 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_03_01 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_03_07 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_03_21 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_09_04 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_09_26 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_10_05 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_10_11 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_10_25 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_11_07 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2021_11_21 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE
);
CREATE TABLE forecast_future_dfs_2021_12_07 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE
);
CREATE TABLE forecast_future_dfs_2022_01_11 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE
);
CREATE TABLE forecast_future_dfs_2022_01_24 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2022_02_08 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
CREATE TABLE forecast_future_dfs_2022_02_22 (
"ds" TIMESTAMP,
"trend" DOUBLE,
"confirmed" BIGINT,
"yhat_lower" BIGINT,
"yhat_upper" BIGINT,
"trend_lower" DOUBLE,
"trend_upper" DOUBLE,
"additive_terms" DOUBLE,
"additive_terms_lower" DOUBLE,
"additive_terms_upper" DOUBLE,
"holidays" DOUBLE,
"holidays_lower" DOUBLE,
"holidays_upper" DOUBLE,
"multiplicative_terms" DOUBLE,
"multiplicative_terms_lower" DOUBLE,
"multiplicative_terms_upper" DOUBLE,
"weekly" DOUBLE,
"weekly_lower" DOUBLE,
"weekly_upper" DOUBLE,
"country" VARCHAR
);
Anyone who has the link will be able to view this.