Name: COVID-19 Dataset
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

COVID-19 Dataset

Context

Coronavirus disease (COVID-19) is an infectious disease caused by a newly discovered coronavirus. There are two datasets which are extracted from the World Meter:

covid_country.csv: This file contains COVID-19 information on the country level.
covid_19_usa_city.csv: This file contains COVID-19 information of the cities in the USA.

Content

The file contains the latest information on the COVID-19 cases and will be refreshed at the end of the day. (12 AM IST Time Zone)

Inspiration

This dataset opens the possibility of answering various questions like:

Does lockdown help in controlling the growth of COVID-19 cases? If yes, which lockdown strategy works best?
Future forecast of the cases for the country so that country can take precaution measures. And lot more . . . . . . .

Tables

Covid 19 Usa City

@kaggle.tavishaggarwal_covid_19_dataset_on_country_level.covid_19_usa_city

343.95 kB
9,660 rows
11 columns

CREATE TABLE covid_19_usa_city (
  "city" VARCHAR,
  "total_cases" BIGINT,
  "new_cases" DOUBLE,
  "total_deaths" DOUBLE,
  "new_deaths" VARCHAR,
  "active_cases" VARCHAR,
  "total_cases_1m_pop" DOUBLE  -- Total Cases /1M Pop,
  "deaths_1m_pop" DOUBLE  -- Deaths /1M Pop,
  "total_tests" DOUBLE,
  "tests_1m_pop" DOUBLE  -- Tests /1M Pop,
  "date" VARCHAR
);

Covid Country

@kaggle.tavishaggarwal_covid_19_dataset_on_country_level.covid_country

1.05 MB
34,932 rows
14 columns

CREATE TABLE covid_country (
  "country" VARCHAR,
  "total_cases" BIGINT,
  "new_cases" DOUBLE,
  "total_deaths" VARCHAR,
  "new_deaths" DOUBLE,
  "total_recovered" DOUBLE,
  "active_cases" DOUBLE,
  "serious_critical" DOUBLE,
  "total_cases_1m_pop" DOUBLE,
  "deaths_1m_pop" DOUBLE  -- Deaths /1M Pop,
  "total_tests" DOUBLE,
  "tests_1m_pop" DOUBLE  -- Tests /1M Pop,
  "continent" VARCHAR,
  "date" VARCHAR
);