DEV Community

Erlan Akbaraliev
Erlan Akbaraliev

Posted on

Финальный проект 2

CREATE TABLE covid (
    iso_code TEXT,
    continent TEXT,
    location TEXT,
    date DATE,
    total_case NUMERIC,
    new_cases NUMERIC,
    new_cases_smoothed REAL,
    total_deaths NUMERIC,
    new_deaths NUMERIC,
    new_deaths_smoothed REAL,
    total_cases_per_million REAL,
    new_cases_per_million REAL,
    new_cases_smoothed_per_million REAL,
    total_deaths_per_million REAL,
    new_deaths_per_million REAL,
    new_deaths_smoothed_per_million REAL,
    reproduction_rate REAL,
    icu_patients NUMERIC,
    icu_patients_per_million REAL,
    hosp_patients NUMERIC,
    hosp_patients_per_million REAL,
    weekly_icu_admissions REAL,
    weekly_icu_admissions_per_million REAL,
    weekly_hosp_admissions REAL,
    weekly_hosp_admissions_per_million REAL,
    new_tests NUMERIC,
    total_tests NUMERIC,
    total_tests_per_thousand REAL,
    new_tests_per_thousand REAL,
    new_tests_smoothed NUMERIC,
    new_tests_smoothed_per_thousand REAL,
    positive_rate REAL,
    tests_per_case REAL,
    tests_units TEXT,
    total_vaccinations NUMERIC,
    people_vaccinated NUMERIC,
    people_fully_vaccinated NUMERIC,
    new_vaccinations NUMERIC,
    new_vaccinations_smoothed NUMERIC,
    total_vaccinations_per_hundred REAL,
    people_vaccinated_per_hundred REAL,
    people_fully_vaccinated_per_hundred REAL,
    new_vaccinations_smoothed_per_million NUMERIC,
    stringency_index REAL,
    population NUMERIC,
    population_density REAL,
    median_age REAL,
    aged_65_older REAL,
    aged_70_older REAL,
    gdp_per_capita REAL,
    extreme_poverty REAL,
    cardiovasc_death_rate REAL,
    diabetes_prevalence REAL,
    female_smokers REAL,
    male_smokers REAL,
    handwashing_facilities REAL,
    hospital_beds_per_thousand REAL,
    life_expectancy REAL,
    human_development_index REAL
);
Enter fullscreen mode Exit fullscreen mode

Top comments (0)