Snowflake 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

• Hep A Vaccine Recipients​​​ Data 
  
• Hep B Vaccine Recipients (updated 2/8/2024)​​
  
• COVID-19 Vaccine Doses (updated 7/19/2024) 
  
• COVID-19 Vaccine Recipients (updated 5/19/2023) 
  
• Influenza Vaccine  Recipients ​(updated ​​4/17/2023)
  
• HPV Vaccine Recipients ​(updated 6/19/2023)
  
• MMR Vaccine Recipients​ (updated 7/12/2023)
  
• MPX Vaccine Doses (updated 8/19/2022) 
  
• MPX Vaccine Recipients (updated 8/19/2022)
• Pertussis Vaccine Recipients ​(updated 11/28/2023)
  
• RSV Vaccine Recipients​ (updated 2/8/2024)
  
• Varicella Vaccine Recipients​ (updated 5/3/2024)​
• All Vaccine Doses (updated ​​2/21/2023) 

Connection Tools 

• Download and Install the ODBC Driver 
• Snowflake REST API: data file ingestion and loading history reports 
• Snowflake Copy Into Command: allows data to be copied out to a cloud data bucket like AWS S3 or Azure BLOB 
• Load Snowflake data to Excel 
  

Other Resources 

• CAIR Data Analysis Considerations (PDF) 
• Snowflake Job Aid – How to Access (updated 10/19/2021) 
• Snowflake Job Aid – Frequently Used SQL Queries (updated 10/26/2022) (PDF)  ​