Table # Values
ambulatory_surgery_char_by_faclty_2016 1 oshpd_id: 106234038
facility_num: 234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
county_code: 23
license_type_desc: Hospital
county_name: MENDOCINO
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
control_type_desc: Non-profit Corporation (incl. Church-related)
rural_hospital_desc: None
teaching_hospital_desc: None
licensed_bed_size: 1-49
senate_district_desc: District 2
assembly_district_desc: District 2
mssa_name: BROOKTRAILS/PINE MOUNTAIN/WILLITS
mssa_designation: Rural
teach_rural: NA
sex_female: 385
sex_male: 305
sex_unknown_invalid: None
hcount: 1
ccount: 0
license_type: Hospital
age_10_19: 28
age_20_29: 22
age_30_39: 70
age_40_49: 77
age_50_59: 135
age_60_69: 196
age_70_79: 118
age_80_: 37
age_01_09: 7
age_under_1: None
age_unknown: None
asian_pacific_islander: 1
black: 4
hispanic: 45
other_race: 6
unknown_race: 1
white: 611
american_indian_alaska_native: 22
acute_care: 9
rehab: None
routine: 674
sn_ic_care: 1
against_medical_advice: 1
cah: None
childrens_or_cancer: None
home_health_service: 3
hospice_care: 1
invalid_blank_disp: None

ambulatory_surgery_char_by_faclty_2017 1 oshpd_id: 106234038
facility_num: 234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
county_code: 23
license_type_desc: Hospital
county_name: MENDOCINO
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
control_type_desc: Non-profit Corporation (incl. Church-related)
rural_hospital_desc: None
teaching_hospital_desc: None
licensed_bed_size: 1-49
senate_district_desc: District 2
assembly_district_desc: District 2
mssa_name: BROOKTRAILS/PINE MOUNTAIN/WILLITS
mssa_designation: Rural
teach_rural: NA
sex_female: 392
sex_male: 333
sex_unknown_invalid: None
hcount: 1
ccount: 0
license_type: Hospital
age_10_19: 19
age_20_29: 34
age_30_39: 66
age_40_49: 70
age_50_59: 142
age_60_69: 211
age_70_79: 116
age_80_: 62
age_01_09: 5
age_under_1: None
age_unknown: None
asian_pacific_islander: 3
black: 6
hispanic: 43
other_race: 12
unknown_race: 3
white: 633
american_indian_alaska_native: 25
acute_care: 8
against_medical_advice: None
rehab: None
routine: 714
sn_ic_care: None
cah: None
home_health_service: 2
hospice_care: None
not_defined_elsewhere: None
psychiatric_care: None

ambulatory_surgery_char_by_faclty_2021 1 oshpd_id: 106234038
oshpd_id9: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_type_desc: Hospital
dba_zip_code: 95490
control_type_desc: Non-profit Corporation (incl. Church-related)
licensed_bed_size: 1-49
senate_district_desc: District 2
assembly_district_desc: District 2
mssa_name: Brooktrails/Pine Mountain/Willits
mssa_designation: Rural
county_name: MENDOCINO
dba_address1: 95490
dba_city: WILLITS
teach_rural: Small/Rural
age_0_09: None
age_10_19: 42
age_20_29: 62
age_30_39: 95
age_40_49: 140
age_50_59: 214
age_60_69: 313
age_70_79: 271
age_80_: 48
age_other_unknown: 4
english: 1145
spanish: 44
chinese: None
cantonese_yue_chinese: None
vietnamese: None
all_other_languages: None
pls_other_unknown: None
eth_hispanic: 115
eth_nonhispanic: 1034
eth_other_unknown: 40
dx_certain_perinatal_conditions: None
dx_circulatory: 3
dx_congenital: 2
dx_digestive: 290
dx_diseases_of_the_blood: 15
dx_ear: 1
dx_endocrine: 2
dx_eye: None
dx_factors_influencing_health: 197
dx_genitourinary: 20
dx_infectious: None
dx_injury_poisoning: 223
dx_mentalhealth: None
dx_musculoskeletal: 184
dx_neoplasms: 108
dx_nervous_system: 87
dx_other_unknown: 1

ambulatory_surgery_char_by_faclty_2022 1 oshpd_id: 106234038
oshpd_id9: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_type_desc: Hospital
dba_zip_code: 95490
control_type_desc: Non-profit Corporation (incl. Church-related)
licensed_bed_size: 1-49
senate_district_desc: District 2
assembly_district_desc: District 2
mssa_name: Brooktrails/Pine Mountain/Willits
mssa_designation: Rural
county_name: MENDOCINO
dba_address1: 95490
dba_city: WILLITS
teach_rural: Small/Rural
age_0_09: None
age_10_19: 28
age_20_29: 39
age_30_39: 77
age_40_49: 116
age_50_59: 178
age_60_69: 291
age_70_79: 239
age_80_: 59
age_other_unknown: 7
english: 993
spanish: 39
cantonese_yue_chinese: None
vietnamese: None
all_other_languages: None
pls_other_unknown: 2
eth_hispanic: 87
eth_nonhispanic: 908
eth_other_unknown: 39
dx_certain_perinatal_conditions: None
dx_circulatory: 1
dx_congenital: 2
dx_digestive: 247
dx_diseases_of_the_blood: 6
dx_ear: None
dx_endocrine: 6
dx_eye: None
dx_factors_influencing_health: 166
dx_genitourinary: 4
dx_infectious: 1
dx_injury_poisoning: 222
dx_mentalhealth: 1
dx_musculoskeletal: 184
dx_neoplasms: 73
dx_nervous_system: 89
dx_other_unknown: 1
dx_pregnancy_childbirth: None

ambulatory_surgery_char_by_faclty_2023 1 oshpd_id: 106234038
oshpd_id9: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_type_desc: Hospital
dba_zip_code: 95490
control_type_desc: Non-profit Corporation (incl. Church-related)
licensed_bed_size: 1-49
senate_district_desc: District 2
assembly_district_desc: District 2
mssa_name: Brooktrails/Pine Mountain/Willits
mssa_designation: Rural
county_name: MENDOCINO
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
teach_rural: Small/Rural
age_0_09: None
age_10_19: 34
age_20_29: 30
age_30_39: 84
age_40_49: 127
age_50_59: 215
age_60_69: 332
age_70_79: 321
age_80_: 74
age_other_unknown: 9
english: 1167
spanish: 58
cantonese_yue_chinese: None
vietnamese: None
all_other_languages: None
pls_other_unknown: 1
eth_hispanic: 116
eth_nonhispanic: 1075
eth_other_unknown: 35
dx_certain_perinatal_conditions: None
dx_circulatory: 2
dx_congenital: None
dx_digestive: 221
dx_diseases_of_the_blood: 6
dx_ear: None
dx_endocrine: 1
dx_eye: None
dx_factors_influencing_health: 181
dx_genitourinary: 5
dx_infectious: 1
dx_injury_poisoning: 207
dx_mentalhealth: None
dx_musculoskeletal: 400
dx_neoplasms: 80
dx_nervous_system: 85
dx_other_unknown: 1
dx_pregnancy_childbirth: None

chargemasters_dirs 6 pk: 2758
full_name: 2018/Adventist Health Howard Memorial
oshpd_id: 106234038
year: 2018

pk: 3118
full_name: 2019/Adventist Health Howard Memorial
oshpd_id: 106234038
year: 2019

pk: 3481
full_name: 2020/Adventist Health Howard Memorial
oshpd_id: 106234038
year: 2020

pk: 4135
full_name: 2022/Adventist Health Howard Memorial
oshpd_id: 106234038
year: 2022

pk: 4586
full_name: 2023/Adventist Health Howard Memorial
oshpd_id: 106234038
year: 2023

pk: 5028
full_name: 2024/ADVENTIST HEALTH HOWARD MEMORIAL
oshpd_id: 106234038
year: 2024

chargemasters_files 8 pk: 8269
dir_pk: 2758
year: 2018
full_name: 2018/Adventist Health Howard Memorial/106234038_CDM_2018.xlsx
oshpd_id: 106234038
file_type: CDM
file_ext: xlsx
common25: None

pk: 8270
dir_pk: 2758
year: 2018
full_name: 2018/Adventist Health Howard Memorial/106234038_Common25_2018.xlsx
oshpd_id: 106234038
file_type: Common25
file_ext: xlsx
common25: 0

pk: 8271
dir_pk: 2758
year: 2018
full_name: 2018/Adventist Health Howard Memorial/106234038_PCT_CHG_2018.xlsx
oshpd_id: 106234038
file_type: PCT CHG
file_ext: xlsx
common25: None

pk: 8952
dir_pk: 3118
year: 2019
full_name: 2019/Adventist Health Howard Memorial/106234038_CDM_All_2019.xlsx
oshpd_id: 106234038
file_type: CDM All
file_ext: xlsx
common25: 15

pk: 9657
dir_pk: 3481
year: 2020
full_name: 2020/Adventist Health Howard Memorial/106234038_CDM_All_2020.xlsx
oshpd_id: 106234038
file_type: CDM All
file_ext: xlsx
common25: 12

pk: 11063
dir_pk: 4135
year: 2022
full_name: 2022/Adventist Health Howard Memorial/106234038_CDM_All_2022.xlsx
oshpd_id: 106234038
file_type: CDM All
file_ext: xlsx
common25: 43

pk: 11814
dir_pk: 4586
year: 2023
full_name: 2023/Adventist Health Howard Memorial/106234038_CDM_All.xlsx
oshpd_id: 106234038
file_type: CDM All
file_ext: xlsx
common25: 46

pk: 11849
dir_pk: 5028
year: 2024
full_name: 2024/ADVENTIST HEALTH HOWARD MEMORIAL/106234038_CDM_All_AHHM_2024.xlsx
oshpd_id: 106234038
file_type: CDM All
file_ext: xlsx
common25: None

licensed_healthcare_facility_listing 15 period: current
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.38974480
longitude: -123.33870680

period: 2016-12-31
oshpd_id: 106234038
facility_name: FRANK R. HOWARD MEMORIAL HOSPITAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2017-12-31
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2018-12-31
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2019-12-31
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2020-12-31
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2021-12-31
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2022-12-31
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2017-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2018-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2019-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 1 MARCELA DRIVE
dba_city: WILLITS
dba_zip_code: 95490
county_code: 23
county_name: MENDOCINO
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2020-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2021-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2022-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000

period: 2023-06-30
oshpd_id: 106234038
facility_name: ADVENTIST HEALTH HOWARD MEMORIAL
license_num: 110000013
facility_level_desc: Parent Facility
dba_address1: 95490
dba_city: Willits
dba_zip_code: 95490
county_code: 23
county_name: Mendocino
er_service_level_desc: Emergency - Basic
total_number_beds: 25
facility_status_desc: Open
facility_status_date: 2015-11-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 39.39927000
longitude: -123.35486000