Coronavirus Lat/Lon Dataset by Kaggle | Finance and Economics

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

160.15 KB
20706 rows
9 columns


CREATE TABLE cv_latlon_21jan_12mar (
  "unnamed_0" BIGINT,
  "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

65.29 KB
406 rows
55 columns


CREATE TABLE time_series_19_covid_confirmed (
  "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
);

Time Series 19 Covid Deaths

@kaggle.grebublin_coronavirus_latlon_dataset.time_series_19_covid_deaths

52.21 KB
406 rows
55 columns


CREATE TABLE time_series_19_covid_deaths (
  "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
);

Time Series 19 Covid Recovered

@kaggle.grebublin_coronavirus_latlon_dataset.time_series_19_covid_recovered

58.68 KB
406 rows
55 columns


CREATE TABLE time_series_19_covid_recovered (
  "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
);