Baselight

Covid-19 Pandemic

Check out my new Data Analysis Project on Covid-19 Pandemic.

@kaggle.willianoliveiragibin_covid_19_pandemic

Covid 19 Clean Complete New
@kaggle.willianoliveiragibin_covid_19_pandemic.covid_19_clean_complete_new

  • 379.37 KB
  • 49068 rows
  • 9 columns
country_region

Country/Region

lat

Lat

long

Long

date

Date

confirmed

Confirmed

deaths

Deaths

recovered

Recovered

active

Active

who_region

WHO Region

Afghanistan3.393.91167.709.953Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Eastern Mediterranean
Albania411.533201.683Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Europe
Algeria280.3391.6596Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Africa
Andorra425.0631.5218Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Europe
Angola-112.027178.739Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Africa
Antigua and Barbuda170.608-617.964Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Americas
Argentina-384.161-636.167Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Americas
Armenia400.691450.382Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Europe
Australia-354.7351.490.124Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Western Pacific
Australia-338.6881.512.093Wed Jan 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Western Pacific

CREATE TABLE covid_19_clean_complete_new (
  "country_region" VARCHAR,
  "lat" VARCHAR,
  "long" VARCHAR,
  "date" TIMESTAMP,
  "confirmed" BIGINT,
  "deaths" BIGINT,
  "recovered" BIGINT,
  "active" BIGINT,
  "who_region" VARCHAR
);

Share link

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