Snowflake COVID-19 Vaccination Data Repository
Local Health Department Access
California local health departments can access the vaccination data reported to the California Immunization Registry (CAIR) in a Snowflake data repository. To request access to the vaccine data in Snowflake, send an email to michael.powell@cdph.ca.gov with your full name, email address, local health department, job title, and your supervisor's full name.āā
Data Dictionaries
Connection Tools
Other Resources
Health Plan Access
Health plans registered with CAIR2 to run HEDIS reports will now be eligible to run COVID-19 patient match reports and receive back CAIR2 COVID-19 vaccine doses received by their members. Input file formatting will be the same as for
HEDIS Patient Match Reportā (PDF) and output files will be in comma-delimited format (.csv) and adhere to the
Snowflake COVID-19 Vaccination Data Dictionary (updated 1/18/2023) format.
Steps/rules are:
- Place COVID input file in your assigned HEDIS sFTP folder. Make sure to name file: HealthPlanName_COVID_YYYYMMDD to distinguish it from regular HEDIS input files. Only one file per health plan per week will be allowed and the file size must not exceed 2M rows.
- Health plan contact will send email to
Kavitha.Perumal@cdph.ca.gov with āCOVID file uploadedā in the subject line and include file name in body of email to indicate new file has been uploaded.
- Health plan contact will receive email when output file is ready for retrieval (48-72 hrs). The COVID output file will be named: HealthPlanName_COVID_OUTPUT_YYYYMMDD.
- Patients who have chosen to lock their record in accordance with California Health and Safety Code 120440 will not be returned in the COVID output file for Health Plans.ā