Dataset: Covid-data

About this Dataset

Covid-data

Context

For the last few months the World is facing a terrible threat named COVID-19. This microscopic object has changed the world in a snap.WHO declared this situation as a Pandemic. This data is mainly the worldwide data of the COVID-19 cases for different counries

Content

This Data set contains 7 .csv files which contains some time series data for the cases since 22/01/2020.

Acknowledgements

First of all I would like to thank John Hopkings University for collecting such beautiful amount of data. I would like to also thank
my friends Mr.Sagarnil Bose, Mr. Soham Mukharjee and Mr. Souptik Sarkar for the help .

Inspiration

Hopefully these data frames will be useful for the visualization of the time series data and also for forecasting.

Tables

Countrywise Data

@kaggle.nonstochastic147_coviddata.countrywise_data

7.23 KB
184 rows
4 columns


CREATE TABLE countrywise_data (
  "country" VARCHAR,
  "confirmed" BIGINT,
  "deaths" BIGINT,
  "recovered" BIGINT
);

India Italy Us Confirmed Total

@kaggle.nonstochastic147_coviddata.india_italy_us_confirmed_total

6.36 KB
60 rows
7 columns


CREATE TABLE india_italy_us_confirmed_total (
  "italy" BIGINT,
  "us" BIGINT,
  "india" BIGINT,
  "italy_lag_12" DOUBLE,
  "us_lag_9" DOUBLE,
  "italy_lag_13" DOUBLE,
  "us_lag_11" DOUBLE
);

Time Series 19 Covid Combined

@kaggle.nonstochastic147_coviddata.time_series_19_covid_combined

41.73 KB
17204 rows
8 columns


CREATE TABLE time_series_19_covid_combined (
  "date" TIMESTAMP,
  "country_region" VARCHAR,
  "province_state" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "confirmed" DOUBLE,
  "recovered" DOUBLE,
  "deaths" DOUBLE
);

Time Series Covid19 Confirmed Global

@kaggle.nonstochastic147_coviddata.time_series_covid19_confirmed_global

103.14 KB
263 rows
81 columns


CREATE TABLE time_series_covid19_confirmed_global (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT,
  "n_1_23_20" BIGINT,
  "n_1_24_20" BIGINT,
  "n_1_25_20" BIGINT,
  "n_1_26_20" BIGINT,
  "n_1_27_20" BIGINT,
  "n_1_28_20" BIGINT,
  "n_1_29_20" BIGINT,
  "n_1_30_20" BIGINT,
  "n_1_31_20" BIGINT,
  "n_2_1_20" BIGINT,
  "n_2_2_20" BIGINT,
  "n_2_3_20" BIGINT,
  "n_2_4_20" BIGINT,
  "n_2_5_20" BIGINT,
  "n_2_6_20" BIGINT,
  "n_2_7_20" BIGINT,
  "n_2_8_20" BIGINT,
  "n_2_9_20" BIGINT,
  "n_2_10_20" BIGINT,
  "n_2_11_20" BIGINT,
  "n_2_12_20" BIGINT,
  "n_2_13_20" BIGINT,
  "n_2_14_20" BIGINT,
  "n_2_15_20" BIGINT,
  "n_2_16_20" BIGINT,
  "n_2_17_20" BIGINT,
  "n_2_18_20" BIGINT,
  "n_2_19_20" BIGINT,
  "n_2_20_20" BIGINT,
  "n_2_21_20" BIGINT,
  "n_2_22_20" BIGINT,
  "n_2_23_20" BIGINT,
  "n_2_24_20" BIGINT,
  "n_2_25_20" BIGINT,
  "n_2_26_20" BIGINT,
  "n_2_27_20" BIGINT,
  "n_2_28_20" BIGINT,
  "n_2_29_20" BIGINT,
  "n_3_1_20" BIGINT,
  "n_3_2_20" BIGINT,
  "n_3_3_20" BIGINT,
  "n_3_4_20" BIGINT,
  "n_3_5_20" BIGINT,
  "n_3_6_20" BIGINT,
  "n_3_7_20" BIGINT,
  "n_3_8_20" BIGINT,
  "n_3_9_20" BIGINT,
  "n_3_10_20" BIGINT,
  "n_3_11_20" BIGINT,
  "n_3_12_20" BIGINT,
  "n_3_13_20" BIGINT,
  "n_3_14_20" BIGINT,
  "n_3_15_20" BIGINT,
  "n_3_16_20" BIGINT,
  "n_3_17_20" BIGINT,
  "n_3_18_20" BIGINT,
  "n_3_19_20" BIGINT,
  "n_3_20_20" BIGINT,
  "n_3_21_20" BIGINT,
  "n_3_22_20" BIGINT,
  "n_3_23_20" BIGINT,
  "n_3_24_20" BIGINT,
  "n_3_25_20" BIGINT,
  "n_3_26_20" BIGINT,
  "n_3_27_20" BIGINT,
  "n_3_28_20" BIGINT,
  "n_3_29_20" BIGINT,
  "n_3_30_20" BIGINT,
  "n_3_31_20" BIGINT,
  "n_4_1_20" BIGINT,
  "n_4_2_20" BIGINT,
  "n_4_3_20" BIGINT,
  "n_4_4_20" BIGINT,
  "n_4_5_20" BIGINT,
  "n_4_6_20" BIGINT,
  "n_4_7_20" BIGINT
);

Time Series Covid19 Confirmed Us

@kaggle.nonstochastic147_coviddata.time_series_covid19_confirmed_us

294 KB
3253 rows
88 columns


CREATE TABLE time_series_covid19_confirmed_us (
  "uid" BIGINT,
  "iso2" VARCHAR,
  "iso3" VARCHAR,
  "code3" BIGINT,
  "fips" DOUBLE,
  "admin2" VARCHAR,
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "combined_key" VARCHAR,
  "n_1_22_20" BIGINT,
  "n_1_23_20" BIGINT,
  "n_1_24_20" BIGINT,
  "n_1_25_20" BIGINT,
  "n_1_26_20" BIGINT,
  "n_1_27_20" BIGINT,
  "n_1_28_20" BIGINT,
  "n_1_29_20" BIGINT,
  "n_1_30_20" BIGINT,
  "n_1_31_20" BIGINT,
  "n_2_1_20" BIGINT,
  "n_2_2_20" BIGINT,
  "n_2_3_20" BIGINT,
  "n_2_4_20" BIGINT,
  "n_2_5_20" BIGINT,
  "n_2_6_20" BIGINT,
  "n_2_7_20" BIGINT,
  "n_2_8_20" BIGINT,
  "n_2_9_20" BIGINT,
  "n_2_10_20" BIGINT,
  "n_2_11_20" BIGINT,
  "n_2_12_20" BIGINT,
  "n_2_13_20" BIGINT,
  "n_2_14_20" BIGINT,
  "n_2_15_20" BIGINT,
  "n_2_16_20" BIGINT,
  "n_2_17_20" BIGINT,
  "n_2_18_20" BIGINT,
  "n_2_19_20" BIGINT,
  "n_2_20_20" BIGINT,
  "n_2_21_20" BIGINT,
  "n_2_22_20" BIGINT,
  "n_2_23_20" BIGINT,
  "n_2_24_20" BIGINT,
  "n_2_25_20" BIGINT,
  "n_2_26_20" BIGINT,
  "n_2_27_20" BIGINT,
  "n_2_28_20" BIGINT,
  "n_2_29_20" BIGINT,
  "n_3_1_20" BIGINT,
  "n_3_2_20" BIGINT,
  "n_3_3_20" BIGINT,
  "n_3_4_20" BIGINT,
  "n_3_5_20" BIGINT,
  "n_3_6_20" BIGINT,
  "n_3_7_20" BIGINT,
  "n_3_8_20" BIGINT,
  "n_3_9_20" BIGINT,
  "n_3_10_20" BIGINT,
  "n_3_11_20" BIGINT,
  "n_3_12_20" BIGINT,
  "n_3_13_20" BIGINT,
  "n_3_14_20" BIGINT,
  "n_3_15_20" BIGINT,
  "n_3_16_20" BIGINT,
  "n_3_17_20" BIGINT,
  "n_3_18_20" BIGINT,
  "n_3_19_20" BIGINT,
  "n_3_20_20" BIGINT,
  "n_3_21_20" BIGINT,
  "n_3_22_20" BIGINT,
  "n_3_23_20" BIGINT,
  "n_3_24_20" BIGINT,
  "n_3_25_20" BIGINT,
  "n_3_26_20" BIGINT,
  "n_3_27_20" BIGINT,
  "n_3_28_20" BIGINT,
  "n_3_29_20" BIGINT,
  "n_3_30_20" BIGINT,
  "n_3_31_20" BIGINT,
  "n_4_1_20" BIGINT,
  "n_4_2_20" BIGINT,
  "n_4_3_20" BIGINT,
  "n_4_4_20" BIGINT,
  "n_4_5_20" BIGINT,
  "n_4_6_20" BIGINT,
  "n_4_7_20" BIGINT
);

Time Series Covid19 Cumudf Global

@kaggle.nonstochastic147_coviddata.time_series_covid19_cumudf_global

6.19 KB
77 rows
5 columns


CREATE TABLE time_series_covid19_cumudf_global (
  "days" BIGINT,
  "confirmed" BIGINT,
  "deaths" BIGINT,
  "recoveries" BIGINT,
  "active" BIGINT
);

Time Series Covid19 Dailydf Global

@kaggle.nonstochastic147_coviddata.time_series_covid19_dailydf_global

4.96 KB
76 rows
4 columns


CREATE TABLE time_series_covid19_dailydf_global (
  "days" BIGINT,
  "confirmed" BIGINT,
  "deaths" BIGINT,
  "recovered" BIGINT
);

Time Series Covid19 Deaths Global

@kaggle.nonstochastic147_coviddata.time_series_covid19_deaths_global

74.6 KB
263 rows
81 columns


CREATE TABLE time_series_covid19_deaths_global (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT,
  "n_1_23_20" BIGINT,
  "n_1_24_20" BIGINT,
  "n_1_25_20" BIGINT,
  "n_1_26_20" BIGINT,
  "n_1_27_20" BIGINT,
  "n_1_28_20" BIGINT,
  "n_1_29_20" BIGINT,
  "n_1_30_20" BIGINT,
  "n_1_31_20" BIGINT,
  "n_2_1_20" BIGINT,
  "n_2_2_20" BIGINT,
  "n_2_3_20" BIGINT,
  "n_2_4_20" BIGINT,
  "n_2_5_20" BIGINT,
  "n_2_6_20" BIGINT,
  "n_2_7_20" BIGINT,
  "n_2_8_20" BIGINT,
  "n_2_9_20" BIGINT,
  "n_2_10_20" BIGINT,
  "n_2_11_20" BIGINT,
  "n_2_12_20" BIGINT,
  "n_2_13_20" BIGINT,
  "n_2_14_20" BIGINT,
  "n_2_15_20" BIGINT,
  "n_2_16_20" BIGINT,
  "n_2_17_20" BIGINT,
  "n_2_18_20" BIGINT,
  "n_2_19_20" BIGINT,
  "n_2_20_20" BIGINT,
  "n_2_21_20" BIGINT,
  "n_2_22_20" BIGINT,
  "n_2_23_20" BIGINT,
  "n_2_24_20" BIGINT,
  "n_2_25_20" BIGINT,
  "n_2_26_20" BIGINT,
  "n_2_27_20" BIGINT,
  "n_2_28_20" BIGINT,
  "n_2_29_20" BIGINT,
  "n_3_1_20" BIGINT,
  "n_3_2_20" BIGINT,
  "n_3_3_20" BIGINT,
  "n_3_4_20" BIGINT,
  "n_3_5_20" BIGINT,
  "n_3_6_20" BIGINT,
  "n_3_7_20" BIGINT,
  "n_3_8_20" BIGINT,
  "n_3_9_20" BIGINT,
  "n_3_10_20" BIGINT,
  "n_3_11_20" BIGINT,
  "n_3_12_20" BIGINT,
  "n_3_13_20" BIGINT,
  "n_3_14_20" BIGINT,
  "n_3_15_20" BIGINT,
  "n_3_16_20" BIGINT,
  "n_3_17_20" BIGINT,
  "n_3_18_20" BIGINT,
  "n_3_19_20" BIGINT,
  "n_3_20_20" BIGINT,
  "n_3_21_20" BIGINT,
  "n_3_22_20" BIGINT,
  "n_3_23_20" BIGINT,
  "n_3_24_20" BIGINT,
  "n_3_25_20" BIGINT,
  "n_3_26_20" BIGINT,
  "n_3_27_20" BIGINT,
  "n_3_28_20" BIGINT,
  "n_3_29_20" BIGINT,
  "n_3_30_20" BIGINT,
  "n_3_31_20" BIGINT,
  "n_4_1_20" BIGINT,
  "n_4_2_20" BIGINT,
  "n_4_3_20" BIGINT,
  "n_4_4_20" BIGINT,
  "n_4_5_20" BIGINT,
  "n_4_6_20" BIGINT,
  "n_4_7_20" BIGINT
);

Time Series Covid19 Deaths Us

@kaggle.nonstochastic147_coviddata.time_series_covid19_deaths_us

249.62 KB
3253 rows
89 columns


CREATE TABLE time_series_covid19_deaths_us (
  "uid" BIGINT,
  "iso2" VARCHAR,
  "iso3" VARCHAR,
  "code3" BIGINT,
  "fips" DOUBLE,
  "admin2" VARCHAR,
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "combined_key" VARCHAR,
  "population" BIGINT,
  "n_1_22_20" BIGINT,
  "n_1_23_20" BIGINT,
  "n_1_24_20" BIGINT,
  "n_1_25_20" BIGINT,
  "n_1_26_20" BIGINT,
  "n_1_27_20" BIGINT,
  "n_1_28_20" BIGINT,
  "n_1_29_20" BIGINT,
  "n_1_30_20" BIGINT,
  "n_1_31_20" BIGINT,
  "n_2_1_20" BIGINT,
  "n_2_2_20" BIGINT,
  "n_2_3_20" BIGINT,
  "n_2_4_20" BIGINT,
  "n_2_5_20" BIGINT,
  "n_2_6_20" BIGINT,
  "n_2_7_20" BIGINT,
  "n_2_8_20" BIGINT,
  "n_2_9_20" BIGINT,
  "n_2_10_20" BIGINT,
  "n_2_11_20" BIGINT,
  "n_2_12_20" BIGINT,
  "n_2_13_20" BIGINT,
  "n_2_14_20" BIGINT,
  "n_2_15_20" BIGINT,
  "n_2_16_20" BIGINT,
  "n_2_17_20" BIGINT,
  "n_2_18_20" BIGINT,
  "n_2_19_20" BIGINT,
  "n_2_20_20" BIGINT,
  "n_2_21_20" BIGINT,
  "n_2_22_20" BIGINT,
  "n_2_23_20" BIGINT,
  "n_2_24_20" BIGINT,
  "n_2_25_20" BIGINT,
  "n_2_26_20" BIGINT,
  "n_2_27_20" BIGINT,
  "n_2_28_20" BIGINT,
  "n_2_29_20" BIGINT,
  "n_3_1_20" BIGINT,
  "n_3_2_20" BIGINT,
  "n_3_3_20" BIGINT,
  "n_3_4_20" BIGINT,
  "n_3_5_20" BIGINT,
  "n_3_6_20" BIGINT,
  "n_3_7_20" BIGINT,
  "n_3_8_20" BIGINT,
  "n_3_9_20" BIGINT,
  "n_3_10_20" BIGINT,
  "n_3_11_20" BIGINT,
  "n_3_12_20" BIGINT,
  "n_3_13_20" BIGINT,
  "n_3_14_20" BIGINT,
  "n_3_15_20" BIGINT,
  "n_3_16_20" BIGINT,
  "n_3_17_20" BIGINT,
  "n_3_18_20" BIGINT,
  "n_3_19_20" BIGINT,
  "n_3_20_20" BIGINT,
  "n_3_21_20" BIGINT,
  "n_3_22_20" BIGINT,
  "n_3_23_20" BIGINT,
  "n_3_24_20" BIGINT,
  "n_3_25_20" BIGINT,
  "n_3_26_20" BIGINT,
  "n_3_27_20" BIGINT,
  "n_3_28_20" BIGINT,
  "n_3_29_20" BIGINT,
  "n_3_30_20" BIGINT,
  "n_3_31_20" BIGINT,
  "n_4_1_20" BIGINT,
  "n_4_2_20" BIGINT,
  "n_4_3_20" BIGINT,
  "n_4_4_20" BIGINT,
  "n_4_5_20" BIGINT,
  "n_4_6_20" BIGINT,
  "n_4_7_20" BIGINT
);

Time Series Covid19 Recovered Global

@kaggle.nonstochastic147_coviddata.time_series_covid19_recovered_global

87.02 KB
249 rows
81 columns


CREATE TABLE time_series_covid19_recovered_global (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT,
  "n_1_23_20" BIGINT,
  "n_1_24_20" BIGINT,
  "n_1_25_20" BIGINT,
  "n_1_26_20" BIGINT,
  "n_1_27_20" BIGINT,
  "n_1_28_20" BIGINT,
  "n_1_29_20" BIGINT,
  "n_1_30_20" BIGINT,
  "n_1_31_20" BIGINT,
  "n_2_1_20" BIGINT,
  "n_2_2_20" BIGINT,
  "n_2_3_20" BIGINT,
  "n_2_4_20" BIGINT,
  "n_2_5_20" BIGINT,
  "n_2_6_20" BIGINT,
  "n_2_7_20" BIGINT,
  "n_2_8_20" BIGINT,
  "n_2_9_20" BIGINT,
  "n_2_10_20" BIGINT,
  "n_2_11_20" BIGINT,
  "n_2_12_20" BIGINT,
  "n_2_13_20" BIGINT,
  "n_2_14_20" BIGINT,
  "n_2_15_20" BIGINT,
  "n_2_16_20" BIGINT,
  "n_2_17_20" BIGINT,
  "n_2_18_20" BIGINT,
  "n_2_19_20" BIGINT,
  "n_2_20_20" BIGINT,
  "n_2_21_20" BIGINT,
  "n_2_22_20" BIGINT,
  "n_2_23_20" BIGINT,
  "n_2_24_20" BIGINT,
  "n_2_25_20" BIGINT,
  "n_2_26_20" BIGINT,
  "n_2_27_20" BIGINT,
  "n_2_28_20" BIGINT,
  "n_2_29_20" BIGINT,
  "n_3_1_20" BIGINT,
  "n_3_2_20" BIGINT,
  "n_3_3_20" BIGINT,
  "n_3_4_20" BIGINT,
  "n_3_5_20" BIGINT,
  "n_3_6_20" BIGINT,
  "n_3_7_20" BIGINT,
  "n_3_8_20" BIGINT,
  "n_3_9_20" BIGINT,
  "n_3_10_20" BIGINT,
  "n_3_11_20" BIGINT,
  "n_3_12_20" BIGINT,
  "n_3_13_20" BIGINT,
  "n_3_14_20" BIGINT,
  "n_3_15_20" BIGINT,
  "n_3_16_20" BIGINT,
  "n_3_17_20" BIGINT,
  "n_3_18_20" BIGINT,
  "n_3_19_20" BIGINT,
  "n_3_20_20" BIGINT,
  "n_3_21_20" BIGINT,
  "n_3_22_20" BIGINT,
  "n_3_23_20" BIGINT,
  "n_3_24_20" BIGINT,
  "n_3_25_20" BIGINT,
  "n_3_26_20" BIGINT,
  "n_3_27_20" BIGINT,
  "n_3_28_20" BIGINT,
  "n_3_29_20" BIGINT,
  "n_3_30_20" BIGINT,
  "n_3_31_20" BIGINT,
  "n_4_1_20" BIGINT,
  "n_4_2_20" BIGINT,
  "n_4_3_20" BIGINT,
  "n_4_4_20" BIGINT,
  "n_4_5_20" BIGINT,
  "n_4_6_20" BIGINT,
  "n_4_7_20" BIGINT
);