Global Health Estimates

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