Coronavirus (COVID-19) Vaccinations
Complete Vaccination Data of People in the World (Updated Weekly)
@kaggle.pavan9065_coronavirus_covid19_vaccinations
Complete Vaccination Data of People in the World (Updated Weekly)
@kaggle.pavan9065_coronavirus_covid19_vaccinations
43.5% of the world population has received at least one dose of a COVID-19 vaccine.
5.98 billion doses have been administered globally, and 28.8 million are now administered each day.
Only 2% of people in low-income countries have received at least one dose.
| Variable | Description |
|---|---|
| total_vaccinations | Total number of COVID-19 vaccination doses administered |
| people_vaccinated | Total number of people who received at least one vaccine dose |
| people_fully_vaccinated | Total number of people who received all doses prescribed by the vaccination protocol |
| total_boosters | Total number of COVID-19 vaccination booster doses administered (doses administered beyond the number prescribed by the vaccination protocol) |
| new_vaccinations | New COVID-19 vaccination doses administered (only calculated for consecutive days) |
| new_vaccinations_smoothed | New COVID-19 vaccination doses administered (7-day smoothed). For countries that don't report vaccination data on a daily basis, we assume that vaccination changed equally on a daily basis over any periods in which no data was reported. This produces a complete series of daily figures, which is then averaged over a rolling 7-day window |
| total_vaccinations_per_hundred | Total number of COVID-19 vaccination doses administered per 100 people in the total population |
| people_vaccinated_per_hundred | Total number of people who received at least one vaccine dose per 100 people in the total population |
| people_fully_vaccinated_per_hundred | Total number of people who received all doses prescribed by the vaccination protocol per 100 people in the total population |
| total_boosters_per_hundred | Total number of COVID-19 vaccination booster doses administered per 100 people in the total population |
| new_vaccinations_smoothed_per_million | New COVID-19 vaccination doses administered (7-day smoothed) per 1,000,000 people in the total population |
The mission is to make data and research on the world's largest problems understandable and accessible.
CREATE TABLE india (
"location" VARCHAR,
"date" TIMESTAMP,
"vaccine" VARCHAR,
"total_vaccinations" BIGINT,
"people_vaccinated" BIGINT,
"people_fully_vaccinated" BIGINT,
"source_url" VARCHAR,
"total_boosters" VARCHAR
);CREATE TABLE vaccine (
"date" TIMESTAMP,
"location" 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
);CREATE TABLE vaccine_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
);Anyone who has the link will be able to view this.