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