Vaccination Against Covid-19
COVID-19 data updates weekly, allowing retrospective corrections.
@kaggle.olaflundstrom_vaccination_against_covid_19
COVID-19 data updates weekly, allowing retrospective corrections.
@kaggle.olaflundstrom_vaccination_against_covid_19
Description: Covid-19 aggregated data sets shall be issued on the basis of data sent to the Health Information System by health service providers. The date of statistics shall be based on the time of first receipt of vaccination data by the health information system and not on the date of vaccination. Depending on the documentation of health service providers and the sending of data, there may be nearly 1 day's reference to the receipt of data. Health service providers have the right and obligation to introduce corrections in the detection of errors which may affect retrospective statistics. The datasets are available in machine-readable JSON format and in CSV format. The metadata shall be published in the JSON Schema format. The datasets are updated 1 time a week, on Tuesdays from 12:00-12:30.
CREATE TABLE opendata_covid19_vaccination_agegroup (
"statisticsdate" TIMESTAMP,
"targetdiseasecode" BIGINT,
"targetdisease" VARCHAR,
"agegroup" VARCHAR,
"vaccinationseries" BIGINT,
"measurementtype" VARCHAR,
"locationpopulation" DOUBLE,
"dailycount" BIGINT,
"totalcount" BIGINT,
"populationcoverage" DOUBLE
);CREATE TABLE opendata_covid19_vaccination_location_county (
"statisticsdate" TIMESTAMP,
"targetdiseasecode" BIGINT,
"targetdisease" VARCHAR,
"locationcountry" VARCHAR,
"locationcountryehak" BIGINT,
"locationcounty" VARCHAR,
"locationcountyehak" DOUBLE,
"locationlevel" VARCHAR,
"vaccinationseries" BIGINT,
"measurementtype" VARCHAR,
"locationpopulation" DOUBLE,
"dailycount" BIGINT,
"totalcount" BIGINT,
"populationcoverage" DOUBLE
);CREATE TABLE opendata_covid19_vaccination_location_village_agegroup_gender (
"statisticsdate" TIMESTAMP,
"targetdiseasecode" BIGINT,
"targetdisease" VARCHAR,
"locationcountry" VARCHAR,
"locationcountryehak" BIGINT,
"locationcounty" VARCHAR,
"locationcountyehak" BIGINT,
"locationcommune" VARCHAR,
"locationcommuneehak" BIGINT,
"locationvillage" VARCHAR,
"locationvillageehak" DOUBLE,
"locationlevel" VARCHAR,
"agegroup" VARCHAR,
"gender" VARCHAR,
"vaccinationseries" BIGINT,
"measurementtype" VARCHAR,
"locationpopulation" DOUBLE,
"dailycount" BIGINT,
"totalcount" BIGINT,
"populationcoverage" DOUBLE
);CREATE TABLE opendata_covid19_vaccination_providertype_doses (
"statisticsdate" TIMESTAMP,
"targetdiseasecode" BIGINT,
"targetdisease" VARCHAR,
"providerservicetypecode" DOUBLE,
"providerservicetype" VARCHAR,
"dailycount" BIGINT,
"totalcount" BIGINT
);CREATE TABLE opendata_covid19_vaccination_total (
"statisticsdate" TIMESTAMP,
"targetdiseasecode" BIGINT,
"targetdisease" VARCHAR,
"vaccinationseries" BIGINT,
"measurementtype" VARCHAR,
"locationpopulation" BIGINT,
"dailycount" BIGINT,
"totalcount" BIGINT,
"populationcoverage" DOUBLE
);Anyone who has the link will be able to view this.