Data Elements Specification 


Field Name 


provider_location_guid 
loc_store_no 


loc_phone 
loc_name 
loc_admin_street1 
loc_admin_street2 
loc_admin_city 
loc_admin_state 
loc_admin_zip 
sunday_hours 
monday_hours 
tuesday_hours 
wednesday_hours 
thursday_hours 
friday_hours 
saturday_hours 
web_address 
pre_screen 
insurance_accepted 
walkins_accepted 
provider_notes 
ndc 


med_name 


In_stock 


supply_level 


quantity_last_updated 


Latitude 
Longitude 


Category 


free_mask_program 


min_age_months 


min_age_years 


File details 


Field Description 


Vaccine Finder Provider ID integer(36) 


Chain store number for pharmacies only 


Data Type 


integer 


Valid Values 


Pharmacies: Integer 


Non-pharmacies: Not applicable 


Location phone number 


Provider Location Display Name 


varchar (128) 
varchar (255) 


Street address 1 


varchar (255) 


Street address 2 


varchar (255) 


City 
State 


varchar (255) 


varchar (2) 


Postal Code 


varchar (10) 


Open hours for Sunday 


varchar(255) 


hh:mm:AM - hh:mm:AM 


Open hours for Monday 


Open hours for Tuesday 


varchar(255) 
varchar(255) 


hh:mm:AM - hh:mm:AM 
hh:mm:AM - hh:mm:AM 


Open hours for Wednesday 


varchar(255) 


hh:mm:AM - hh:mm:AM 


Open hours for Thursday 


varchar(255) 


hh:mm:AM - hh:mm:AM 


Open hours for Friday 


Open hours for Saturday 


varchar(255) 
varchar(255) 


hh:mm:AM - hh:mm:AM 
hh:mm:AM - hh:mm:AM 


Web address 


varchar(255) 


Allow nulls 


Web address (Pre-Screen link) 


varchar(255) 


Allow nulls 


Accepts Insurance? 


Accepts Walk-ins? 


boolean 


boolean 


Allow nulls 


Allow nulls 


Notes to display on the provider details page 


varchar (1000) 


Allow nulls 


The National Drug Code 


varchar (32) 


XXXX-XXXXX-XX 


The name of the medication 


Is this vaccine in stock for the public at this 
location? 


varchar(255) 


boolean 


True/False 


The Supply level availability code (number) 


integer 


Valid values are: 
-1: No Report 
0: No Supply 
1: <24 Hour Supply 
3: 24-48 Hour Supply 
4: >48 Hour Supply 


Date the "on hand quantity (number)" was last 
updated 


date 


YYYY-MM-DD 


latitude 


varchar(255) 


longitude 


Is this vaccine a COVID or Seasonal Flu vaccine? 


varchar(255) 


varchar(255) 


Valid values are: 
COVID, Seasonal 


Does this location participate in the federal free 
mask program? 


boolean 


Allow nulls 


Minimum age for vaccinations at this location if <1 
year or non-whole number. 


integer 


Allow nulls 


Minimum age for vaccinations at this location >1 
year if minimum age is a whole number. 


integer 


Allow nulls