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

Covid

CREATE TABLE covid2 (
    iso_code TEXT,
    continent TEXT,
    location TEXT,
    date TEXT,
    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
);

---

Vaccinations

CREATE TABLE vaccinations (
    iso_code TEXT,
    continent TEXT,
    location TEXT,
    date DATE,
    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_density REAL,
    median_age NUMERIC,
    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
);

---

Запрос для создании таблицы covid (2020-2024):

CREATE TABLE covid3 (
    iso_code TEXT,
    continent TEXT,
    location TEXT,
    date DATE,
    total_cases 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 NUMERIC,
    weekly_icu_admissions_per_million REAL,
    weekly_hosp_admissions NUMERIC,
    weekly_hosp_admissions_per_million REAL,
    total_tests NUMERIC,
    new_tests NUMERIC,
    total_tests_per_thousand REAL,
    new_tests_per_thousand REAL,
    new_tests_smoothed REAL,
    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,
    total_boosters NUMERIC,
    new_vaccinations NUMERIC,
    new_vaccinations_smoothed REAL, 
    total_vaccinations_per_hundred REAL,
    people_vaccinated_per_hundred REAL,
    people_fully_vaccinated_per_hundred REAL,
    total_boosters_per_hundred REAL,
    new_vaccinations_smoothed_per_million REAL,
    new_people_vaccinated_smoothed REAL,
    new_people_vaccinated_smoothed_per_hundred REAL,    
    stringency_index REAL,
    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,
    population NUMERIC,
    excess_mortality_cumulative_absolute REAL,
    excess_mortality_cumulative REAL,
    excess_mortality REAL,
    excess_mortality_cumulative_per_million REAL
);