HCAI

year - int
oshpd_id - varchar(9)
fac_name - varchar(83)
fac_address_one - varchar(32)
fac_address_two - varchar(15)
fac_city - varchar(19)
fac_zipcode - varchar(11)
fac_phone - varchar(18)
fac_admin_name - varchar(63)
fac_oper_curryr - varchar(15)
beg_date - date
end_date - date
parent_name - varchar(64)
parent_address_one - varchar(45)
parent_address_two - varchar(44)
parent_city - varchar(16)
parent_state - varchar(12)
parent_zip_9 - varchar(12)
report_prep_name - varchar(27)
lic_status - varchar(10)
lic_status_date - date
lic_orig_date - date
report_status - varchar(13)
mgt_company - varchar(11)
trauma_ctr - varchar(25)
teach_hosp - varchar(10)
mcal_provider_no - varchar(16)
mcare_provider_no - varchar(17)
aclaims_no - varchar(10)
assembly_dist - varchar(13)
senate_dist - varchar(11)
congress_dist - varchar(13)
cens_tract - varchar(10)
med_svc_study_area - varchar(18)
laco_svc_plan_area - varchar(19)
health_svc_area - varchar(26)
county - varchar(15)
license_no - varchar(10)
facility_level - varchar(22)
longitude - decimal(12,8)
latitude - decimal(12,8)
type_lic - varchar(37)
type_cntrl - varchar(45)
type_svc_principal - varchar(34)
measure_variable - varchar(16)
description - varchar(50)
response - varchar(560)
dates - varchar(10)
amount - varchar(10)

Sources

2012-hospital-utilization-instructions.pdf	-
2012-hospital-utilization-reporting-form.pdf	-
2013-hospital-utilization-instructions.pdf	-
2013-hospital-utilization-reporting-form.pdf	-
2014-hospital-utilization-instructions.pdf	-
2014-hospital-utilization-reporting-form.pdf	-
2015-hospital-utilization-instructions.pdf	-
2015-hospital-utilization-reporting-form.pdf	-
2016-hospital-utilization-instructions.pdf	-
2016-hospital-utilization-reporting-form.pdf	-
2017-hospital-utilization-instructions.pdf	-
2017-hospital-utilization-reporting-form.pdf	-
2018-hospital-utilization-instructions.pdf	-
2018-hospital-utilization-reporting-form.pdf	-
2019-hospital-utilization-instructions.pdf	-
2019-hospital-utilization-reporting-form.pdf	-
2020-hospital-utilization-instructions.pdf	-
2020-hospital-utilization-reporting-form.pdf	-
2021-hospital-utilization-instructions.pdf	-
2021-hospital-utilization-reporting-form.pdf	-
2022-hospital-utilization-instructions.pdf	-
2022-hospital-utilization-reporting-form.pdf	-
2023-hospital-utilization-instructions.pdf	-
2023-hospital-utilization-reporting-form.pdf	-
2024-hospital-utilization-instructions.pdf	-
2024-hospital-utilization-reporting-form.pdf	-
data-importing-instruction-for-excel.docx	-
individual-facility-report-search-tool-alirts.aspx	-
pre-2012-hospital-annual-utilization-report-pivot-tables.html	-
datapackage.json	-
2012-calendar-year-hospital-utilization.xlsx	-	Table: 2012_calendar_year_hospital_utilization	Updated: 2025-10-11
2012-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2012_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2013-calendar-year-hospital-utilization.xlsx	-	Table: 2013_calendar_year_hospital_utilization	Updated: 2025-10-11
2013-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2013_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2014-calendar-year-hospital-utilization.xlsx	-	Table: 2014_calendar_year_hospital_utilization	Updated: 2025-10-11
2014-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2014_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2015-calendar-year-hospital-utilization.xlsx	-	Table: 2015_calendar_year_hospital_utilization	Updated: 2025-10-11
2015-calendar-year-hospital-utilization-pivot-table-12-30-2016.xlsx	-	Table: 2015_calendar_year_hospital_utilization_pivot_table_12_30_2016	Updated: 2025-10-11
2016-calendar-year-hospital-utilization.xlsx	-	Table: 2016_calendar_year_hospital_utilization	Updated: 2025-10-11
2016-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2016_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2017-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2017_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2017-hospital-annual-utilization-october-2018.xlsx	-	Table: 2017_hospital_annual_utilization_october_2018	Updated: 2025-10-11
2018-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2018_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2018-hospital-annual-utilization-november-2019.xlsx	-	Table: 2018_hospital_annual_utilization_november_2019	Updated: 2025-10-11
2019-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2019_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2019-hospital-annual-utilization-november-2020.xlsx	-	Table: 2019_hospital_annual_utilization_november_2020	Updated: 2025-10-11
2020-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2020_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2020-hospital-annual-utilization-revised-06-15-2023.xlsx	-	Table: 2020_hospital_annual_utilization_revised_06_15_2023	Updated: 2025-10-11
2021-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2021_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2021-hospital-annual-utilization-revised-06-15-2023.xlsx	-	Table: 2021_hospital_annual_utilization_revised_06_15_2023	Updated: 2025-10-11
2022-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2022_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2022-hospital-annual-utilization-revised-11-28-2023.xlsx	-	Table: 2022_hospital_annual_utilization_revised_11_28_2023	Updated: 2025-10-11
2023-calendar-year-hospital-utilization-pivot-table.xlsx	-	Table: 2023_calendar_year_hospital_utilization_pivot_table	Updated: 2025-10-11
2023-hospital-annual-utilization-november-2024.xlsx	-	Table: 2023_hospital_annual_utilization_november_2024	Updated: 2025-10-11
2024-hospital-annual-utilization-preliminary.xlsx	-	Table: 2024_hospital_annual_utilization_preliminary	Updated: 2025-10-11
hospital-annual-utilization-data-machine-readable-format.csv	-	Table: hospital_annual_utilization_data_machine_readable_format	Fails: 3

Updated