Baselight

COVID-19 Data From World

Number of Confirmed, Death and Recovered cases every day across the World

@kaggle.arslanali4343_covid19_data_from_world

Loading...
Loading...

About this Dataset

COVID-19 Data From World

I need a small help, if you vist and subscribe my website codetechguru

Covid-19 complete dataset updated daily from Our World in Data

SUMMARY👇

Source and more information: https://github.com/owid/covid-19-data/tree/master/public/data

💯Data is synced hourly

Metrics:

✔️ Vaccinations
✔️ Tests & positivity
✔️ Hospital & ICU
✔️ Confirmed cases
✔️ Confirmed deaths
✔️ Reproduction rate
✔️ Policy responses
✔️ Other variables of interest

Tables

Owid Covid Data

@kaggle.arslanali4343_covid19_data_from_world.owid_covid_data
  • 14.8 MB
  • 220343 rows
  • 67 columns
Loading...

CREATE TABLE owid_covid_data (
  "iso_code" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "date" TIMESTAMP,
  "total_cases" DOUBLE,
  "new_cases" DOUBLE,
  "new_cases_smoothed" DOUBLE,
  "total_deaths" DOUBLE,
  "new_deaths" DOUBLE,
  "new_deaths_smoothed" DOUBLE,
  "total_cases_per_million" DOUBLE,
  "new_cases_per_million" DOUBLE,
  "new_cases_smoothed_per_million" DOUBLE,
  "total_deaths_per_million" DOUBLE,
  "new_deaths_per_million" DOUBLE,
  "new_deaths_smoothed_per_million" DOUBLE,
  "reproduction_rate" DOUBLE,
  "icu_patients" DOUBLE,
  "icu_patients_per_million" DOUBLE,
  "hosp_patients" DOUBLE,
  "hosp_patients_per_million" DOUBLE,
  "weekly_icu_admissions" DOUBLE,
  "weekly_icu_admissions_per_million" DOUBLE,
  "weekly_hosp_admissions" DOUBLE,
  "weekly_hosp_admissions_per_million" DOUBLE,
  "total_tests" DOUBLE,
  "new_tests" DOUBLE,
  "total_tests_per_thousand" DOUBLE,
  "new_tests_per_thousand" DOUBLE,
  "new_tests_smoothed" DOUBLE,
  "new_tests_smoothed_per_thousand" DOUBLE,
  "positive_rate" DOUBLE,
  "tests_per_case" DOUBLE,
  "tests_units" VARCHAR,
  "total_vaccinations" DOUBLE,
  "people_vaccinated" DOUBLE,
  "people_fully_vaccinated" DOUBLE,
  "total_boosters" DOUBLE,
  "new_vaccinations" DOUBLE,
  "new_vaccinations_smoothed" DOUBLE,
  "total_vaccinations_per_hundred" DOUBLE,
  "people_vaccinated_per_hundred" DOUBLE,
  "people_fully_vaccinated_per_hundred" DOUBLE,
  "total_boosters_per_hundred" DOUBLE,
  "new_vaccinations_smoothed_per_million" DOUBLE,
  "new_people_vaccinated_smoothed" DOUBLE,
  "new_people_vaccinated_smoothed_per_hundred" DOUBLE,
  "stringency_index" DOUBLE,
  "population" DOUBLE,
  "population_density" DOUBLE,
  "median_age" DOUBLE,
  "aged_65_older" DOUBLE,
  "aged_70_older" DOUBLE,
  "gdp_per_capita" DOUBLE,
  "extreme_poverty" DOUBLE,
  "cardiovasc_death_rate" DOUBLE,
  "diabetes_prevalence" DOUBLE,
  "female_smokers" DOUBLE,
  "male_smokers" DOUBLE,
  "handwashing_facilities" DOUBLE,
  "hospital_beds_per_thousand" DOUBLE,
  "life_expectancy" DOUBLE,
  "human_development_index" DOUBLE,
  "excess_mortality_cumulative_absolute" DOUBLE,
  "excess_mortality_cumulative" DOUBLE,
  "excess_mortality" DOUBLE,
  "excess_mortality_cumulative_per_million" DOUBLE
);

Share link

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