Merchant Medicine Retail Clinic Address Database

Column	Description
cIDX	Record ID
Address	Street address
City	City
Zip Code	5-digit ZIP code
Phone	Phone Number
Website	URL of website
EnteredDate	Date incorporated into database
StateID	State FIPS code
StatusID	Open or closed
OperatorID	Name of the clinic
MetroAreaID	Metro area
RetailerVenueID	Store in which clinic is located
OpenDate	Date opened
CloseDate	Date closed
ClinicName	Full name of clinic
WeekDayHoursID	Weekday hours
SaturdayHoursID	Saturday hours
SundayHoursID	Sunday hours
OwnershipID	Indicator of retail pharmacy, hospital system, or private investor ownership
stID	State FIPS code
Latitude	Latitude coordinate
Longitude	Longitude coordinate