| licensed_and_certified_healthcare_facilities |
|
x - varchar(17)
y - varchar(16)
licensed_certified - varchar(35)
flag - varchar(16)
t18_19 - varchar(13)
facid - varchar(9)
fac_status_type_code - varchar(20)
aspen_facid - varchar(16)
ccn - varchar(10)
terminat_sw - varchar(11)
participation_date - varchar(22)
approval_date - varchar(22)
npi - varchar(10)
can_be_deemed_fac_type - varchar(22)
can_be_certified_fac_type - varchar(25)
deemed - varchar(6)
ao_cd - varchar(5)
dmg_efctv_dt - varchar(18)
ao_trmntn_dt - varchar(18)
ao_name - varchar(7)
facname - varchar(100)
fac_type_code - varchar(13)
fac_fdr - varchar(44)
ltc - varchar(7)
capacity - varchar(8)
address - varchar(67)
city - varchar(21)
zip - varchar(5)
zip9 - varchar(4)
facadmin - varchar(37)
contact_email - varchar(48)
contact_fax - varchar(14)
contact_phone_number - varchar(20)
county_code - varchar(11)
county_name - varchar(15)
district_number - varchar(15)
district_name - varchar(24)
isfacmain - varchar(9)
parent_facid - varchar(12)
fac_fac_relationship_type_code - varchar(30)
start_date - varchar(10)
license_number - varchar(14)
business_name - varchar(74)
license_status_description - varchar(26)
initial_license_date - varchar(22)
license_effective_date - varchar(22)
license_expiration_date - varchar(23)
entity_type_description - varchar(25)
latitude - decimal(12,8)
longitude - decimal(12,8)
location - varchar(27)
oshpd_id - varchar(8)
cclho_code - varchar(10)
cclho_name - varchar(15)
fips_county_code - varchar(16)
birthing_facility_flag - varchar(22)
trauma_ped_ctr - varchar(14)
trauma_ctr - varchar(10)
type_of_care - varchar(26)
critical_access_hospital - varchar(24)
data_date - varchar(22)
objectid - varchar(8)
|