Covid-data

COVID-19 WORLD DATA collected from github.com

@kaggle.nonstochastic147_coviddata

Table List

10 tables(874.85 KB)

Countrywise Data

India Italy Us Confirmed Total

Time Series 19 Covid Combined

Time Series Covid19 Confirmed Global

Time Series Covid19 Confirmed Us

Time Series Covid19 Cumudf Global

Time Series Covid19 Dailydf Global

Time Series Covid19 Deaths Global

Time Series Covid19 Deaths Us

Time Series Covid19 Recovered Global

Time Series Covid19 Deaths Global

@kaggle.nonstochastic147_coviddata.time_series_covid19_deaths_global

74.6 KB
263 rows
81 columns

province_state Province/State	country_region Country/Region	lat Lat	long Long	n_3_4_20 3/4/20	n_3_5_20 3/5/20	n_3_6_20 3/6/20	n_3_7_20 3/7/20	n_3_8_20 3/8/20	n_3_9_20 3/9/20	n_3_10_20 3/10/20	n_3_11_20 3/11/20	n_3_12_20 3/12/20	n_3_13_20 3/13/20	n_3_14_20 3/14/20	n_3_15_20 3/15/20	n_3_16_20 3/16/20	n_3_17_20 3/17/20	n_3_18_20 3/18/20	n_3_19_20 3/19/20	n_3_20_20 3/20/20	n_3_21_20 3/21/20	n_3_22_20 3/22/20	n_3_23_20 3/23/20	n_3_24_20 3/24/20	n_3_25_20 3/25/20	n_3_26_20 3/26/20	n_3_27_20 3/27/20	n_3_28_20 3/28/20	n_3_29_20 3/29/20	n_3_30_20 3/30/20	n_3_31_20 3/31/20	n_4_1_20 4/1/20	n_4_2_20 4/2/20	n_4_3_20 4/3/20	n_4_4_20 4/4/20	n_4_5_20 4/5/20	n_4_6_20 4/6/20	n_4_7_20 4/7/20
nan	Afghanistan	33	65																			1	1	1	2	4	4	4	4	4	4	4	6	6	7	7	11	14
nan	Albania	41.1533	20.1683								1	1	1	1	1	1	1	2	2	2	2	2	4	5	5	6	8	10	10	11	15	15	16	17	20	20	21	22
nan	Algeria	28.0339	1.6596									1	2	3	4	4	4	7	9	11	15	17	17	19	21	25	26	29	31	35	44	58	86	105	130	152	173	193
nan	Andorra	42.5063	1.5218																			1	1	1	1	3	3	3	6	8	12	14	15	16	17	18	21	22
nan	Angola	-11.2027	17.8739																										2	2	2	2	2	2	2	2	2	2
nan	Antigua and Barbuda	17.0608	-61.7964																																			1
nan	Argentina	-38.4161	-63.6167					1	1	1	1	1	2	2	2	2	2	2	3	3	4	4	4	6	8	9	13	18	19	23	27	28	36	39	43	44	48	56
nan	Armenia	40.0691	45.0382																							1	1	1	3	3	3	4	7	7	7	7	8	8
Australian Capital Territory	Australia	-35.4735	149.0124																											1	1	1	1	1	2	2	2	2
New South Wales	Australia	-33.8688	151.2093	1	1	1	1	2	2	2	2	2	2	2	2	2	4	5	5	6	6	6	6	7	7	7	7	8	8	8	8	9	10	12	12	16	18	21


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