Dataset: Covid19 Forecasting Metadata

About this Dataset

Covid19 Forecasting Metadata

Context

There are plenty of datasets that are being explored for forecasting Covid-19. This is my version compiled from various sources and cleaned for easy use.

Content

The data contains metadata of regions.

Country + State

lat
lon
continent
population
area
density

Country + State + Date

Recoveries up to 2020-05-08

Acknowledgements

All the data is compiled from Wikipedia and John Hopkins University. They are restructured to be aligned with the Covid-19 Forecasting Competitions.

Wikipedia: https://www.wikipedia.org/
JHU GitHub: https://github.com/CSSEGISandData/COVID-19

Tables

Region Date Metadata

@kaggle.rohanrao_covid19_forecasting_metadata.region_date_metadata

39.23 KB
27720 rows
4 columns


CREATE TABLE region_date_metadata (
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "date" TIMESTAMP,
  "recoveries" BIGINT
);

Region Metadata

@kaggle.rohanrao_covid19_forecasting_metadata.region_metadata

21.08 KB
320 rows
8 columns


CREATE TABLE region_metadata (
  "country_region" VARCHAR,
  "province_state" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "continent" VARCHAR,
  "population" BIGINT,
  "area" BIGINT,
  "density" DOUBLE
);