Health Care Personnel Influenza Vaccination
State of California
@usgov.ca_gov_health_care_personnel_influenza_vaccination_026e8
State of California
@usgov.ca_gov_health_care_personnel_influenza_vaccination_026e8
CREATE TABLE hcp_influenza_vaccination_by_county_2016_2017 (
"influenza_season" VARCHAR,
"state" VARCHAR,
"cdph_hai_hcp_flu_vax" VARCHAR,
"county" VARCHAR,
"mask_required" VARCHAR,
"all_health_care_personnel_hcp_percent_vaccinated" BIGINT,
"on_track_to_achieve_90_by_2020_81_in_2016_2017" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR
);
CREATE TABLE hcp_influenza_vaccination_by_county_2017_2018 (
"influenza_season" VARCHAR,
"state" VARCHAR,
"cdph_hai_hcp_flu_vax" VARCHAR,
"county" VARCHAR,
"mask_required" VARCHAR,
"hcp_percent_vaccinated" BIGINT,
"on_track_to_achieve_90_by_2020_84_in_2017_18" VARCHAR
);
CREATE TABLE hcp_influenza_vaccination_by_hosp_county_2016_2017 (
"influenza_season" VARCHAR,
"state" VARCHAR,
"cdph_hai_hcp_flu_vax" VARCHAR,
"county" VARCHAR,
"facility_id" DOUBLE,
"facility_name" VARCHAR,
"all_health_care_personnel_hcp_percent_vaccinated" VARCHAR,
"on_track_to_achieve_90_by_2020_81_in_2016_2017" VARCHAR
);
CREATE TABLE hcp_influenza_vaccination_by_hosp_county_2017_2018 (
"influenza_season" VARCHAR,
"state" VARCHAR,
"cdph_hai_hcp_flu_vax" VARCHAR,
"county" VARCHAR,
"facility_id" BIGINT,
"facility_name" VARCHAR,
"hcp_percent_vaccinated" VARCHAR,
"on_track_to_achieve_90_by_2020_84_in_2017_18" VARCHAR
);
CREATE TABLE hcp_influenza_vaccination_by_hosp_county_2018_2019 (
"influenza_season" VARCHAR,
"state" VARCHAR,
"cdph_hai_hcp_flu_vaccination" VARCHAR,
"county" VARCHAR,
"facility_id" BIGINT,
"facility_name" VARCHAR,
"hospital_type" VARCHAR,
"hcp_total_number_vaccinated" DOUBLE,
"hcp_total_number_working" DOUBLE,
"hcp_percent_vaccinated" DOUBLE,
"emp_number_vaccinated" DOUBLE,
"emp_number_working" DOUBLE,
"emp_percent_vaccinated" DOUBLE,
"lip_number_vaccinated" DOUBLE,
"lip_number_working" DOUBLE,
"lip_percent_vaccinated" DOUBLE,
"cont_number_vaccinated" DOUBLE,
"cont_number_working" DOUBLE,
"cont_percent_vaccinated" DOUBLE,
"studvol_number_vaccinated" DOUBLE,
"studvol_number_working" DOUBLE,
"studvol_percent_vaccinated" DOUBLE,
"on_track_to_achieve_90_by_2020_87_in_2018_19" VARCHAR,
"notes" VARCHAR
);
Anyone who has the link will be able to view this.