COVID-19 Daily Data

Normalized dataset from the CSSE daily Reports

@kaggle.osa4olli_covid19_data_normalized_from_csse

About this Dataset

COVID-19 Daily Data

Simple normalization of the data provided by the CSSE daily reports on github. Preparations I made:

Normalizing the Timestamp (since they provide four different formats)
Pruning the column labels (Region/Country => Region_Country, etc)
Adding a country code column

Photo by CDC on Unsplash

Tables

Covid Data Normalized

@kaggle.osa4olli_covid19_data_normalized_from_csse.covid_data_normalized

3.36 MB
155837 rows
17 columns


CREATE TABLE covid_data_normalized (
  "unnamed_0" BIGINT,
  "level_0" BIGINT,
  "index" BIGINT,
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "last_update" VARCHAR,
  "confirmed" DOUBLE,
  "deaths" DOUBLE,
  "recovered" DOUBLE,
  "tstamp" TIMESTAMP,
  "fips" DOUBLE,
  "admin2" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "active" DOUBLE,
  "combined_key" VARCHAR,
  "cc" VARCHAR
);

Share link

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