| Name |
healthcare-facility-locations |
|---|
| Updated |
2025-06-25 |
|---|
| Current |
False |
|---|
| Tables |
| across_time_summ_data_lic_and_cert_facs | |
state_fiscal_year - varchar(20)
county_name - varchar(15)
provider_type - varchar(18)
fac_fdr - varchar(44)
count_num - varchar(5)
|
| licensed_and_certified_healthcare_facility_locations | |
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(18)
approval_date - varchar(13)
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(12)
ao_trmntn_dt - varchar(12)
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(38)
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(20)
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)
hcai_id - varchar(9)
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(9)
|
| lookup_table_licensed_and_certified_healthcare_facility_lookup | |
variable - varchar(7)
description - varchar(26)
elms_value - varchar(8)
aspen_factype - varchar(3)
aspen_value - varchar(8)
ltc - varchar(9)
|
|
|---|
| Sources |
across-time-dashboard-licensed-and-certified-healthcare-facilities.tableau --> None
across-time-data-dictionary-licensed-and-certified-healthcare-facilities.xlsx --> None
counts-dashboard-licensed-and-certified-healthcare-facility.tableau --> None
facility-list-data-dictionary-licensed-and-certified-healthcare-facility-listing.xlsx --> None
preserve-leading-zero-and-import-code-guide-for-licensed-and-certified-healthcare-facility-listing-file.pdf --> None
preserve-leading-zero.pdf --> None
across-time-summary-data-licensed-and-certified-healthcare-facilities.csv --> across_time_summ_data_lic_and_cert_facs
licensed-and-certified-healthcare-facility-locations.csv --> licensed_and_certified_healthcare_facility_locations
lookup-table-licensed-and-certified-healthcare-facility-listing-lookup-table.xlsx --> lookup_table_licensed_and_certified_healthcare_facility_lookup
|
|---|
| Updates |
| 2025-06-25 13:22:45 |
|
0 |
| 2025-06-25 12:54:01 |
|
0 |
| 2025-06-06 11:37:46 |
|
0 |
| 2025-04-20 18:53:13 |
|
0 |
| 2025-04-16 09:34:36 |
|
0 |
| 2025-03-31 13:42:24 |
|
0 |
| 2025-03-31 13:39:44 |
|
1 |
| 2025-03-19 09:16:20 |
|
1 |
| 2025-03-03 10:01:30 |
|
1 |
| 2025-02-11 09:50:59 |
|
0 |
| 2025-02-02 17:57:53 |
|
0 |
| 2025-01-31 16:07:43 |
|
0 |
| 2025-01-31 14:24:23 |
|
0 |
| 2025-01-31 09:55:38 |
|
0 |
| 2025-01-23 20:01:13 |
|
0 |
| 2025-01-16 17:45:26 |
|
0 |
| 2025-01-16 17:45:25 |
|
0 |
| 2025-01-16 17:32:19 |
|
0 |
| 2025-01-16 17:32:18 |
|
0 |
| 2025-01-10 11:15:27 |
|
0 |
| 2024-12-28 21:44:44 |
|
0 |
| 2024-11-15 15:10:04 |
|
None |
| 2024-09-18 12:59:41 |
|
None |
| 2024-09-10 20:09:16 |
|
None |
| 2024-09-10 19:58:12 |
|
None |
| 2024-09-10 19:57:47 |
|
None |
| 2024-09-10 19:56:47 |
|
None |
| 2024-09-09 15:47:35 |
|
None |
| 2024-09-09 13:36:31 |
|
None |
| 2024-07-30 15:50:56 |
|
None |
| 2024-07-16 19:20:16 |
|
None |
| 2024-06-26 12:07:15 |
|
None |
| 2024-06-26 12:03:54 |
|
None |
| 2024-06-26 12:01:53 |
|
None |
|
|---|