Baselight
Sign In

Coronavirus Lat/Lon Dataset

no nulls, added latitude and longitude

@kaggle.grebublin_coronavirus_latlon_dataset

Loading...
Loading...

About this Dataset

Coronavirus Lat/Lon Dataset

Context

This is the processed version of this dataset: https://www.kaggle.com/brendaso/2019-coronavirus-dataset-01212020-01262020
I have filled NAs with 0, added longitude and latitude columns for easier geospatial analysis.

Tables

Cv Latlon 21jan 12mar

@kaggle.grebublin_coronavirus_latlon_dataset.cv_latlon_21jan_12mar
  • 163.99 kB
  • 20,706 rows
  • 9 columns
Loading... 
CREATE TABLE cv_latlon_21jan_12mar (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "state" VARCHAR,
  "country" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "date" TIMESTAMP,
  "confirmed" BIGINT,
  "recovered" BIGINT,
  "death" BIGINT
);

Time Series 19 Covid Confirmed

@kaggle.grebublin_coronavirus_latlon_dataset.time_series_19_covid_confirmed
  • 66.86 kB
  • 406 rows
  • 55 columns
Loading... 
CREATE TABLE time_series_19_covid_confirmed (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20
);

Time Series 19 Covid Deaths

@kaggle.grebublin_coronavirus_latlon_dataset.time_series_19_covid_deaths
  • 53.46 kB
  • 406 rows
  • 55 columns
Loading... 
CREATE TABLE time_series_19_covid_deaths (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20
);

Time Series 19 Covid Recovered

@kaggle.grebublin_coronavirus_latlon_dataset.time_series_19_covid_recovered
  • 60.08 kB
  • 406 rows
  • 55 columns
Loading... 
CREATE TABLE time_series_19_covid_recovered (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20
);

Share link

Anyone who has the link will be able to view this.