Table	#	Values
chargemasters_dirs	3	pk: 4398 full_name: 2022/Mercy Southwest Hospital oshpd_id: 106154108 year: 2022 pk: 4845 full_name: 2023/Mercy Southwest Hospital oshpd_id: 106154108 year: 2023 pk: 5182 full_name: 2024/MERCY SOUTHWEST HOSPITAL oshpd_id: 106154108 year: 2024
chargemasters_files	5	pk: 10665 dir_pk: 4398 year: 2022 full_name: 2022/Mercy Southwest Hospital/106154108_CDM_ALL_2022.xlsx oshpd_id: 106154108 file_type: CDM All file_ext: xlsx common25: 0 pk: 10666 dir_pk: 4398 year: 2022 full_name: 2022/Mercy Southwest Hospital/OSHPD Cover Letter Mercy Hospital's Bakersfield Southwest.docx oshpd_id: 106154108 file_type: Coverletter file_ext: docx common25: None pk: 11431 dir_pk: 4845 year: 2023 full_name: 2023/Mercy Southwest Hospital/106154108_CDM_ALL_2023.xlsx oshpd_id: 106154108 file_type: CDM All file_ext: xlsx common25: 51 pk: 11432 dir_pk: 4845 year: 2023 full_name: 2023/Mercy Southwest Hospital/106154108_Cover Letter Mercy Hospital's Bakersfield Southwest.docx oshpd_id: 106154108 file_type: Coverletter file_ext: docx common25: None pk: 12286 dir_pk: 5182 year: 2024 full_name: 2024/MERCY SOUTHWEST HOSPITAL/106154108_CDM_ALL.xlsx oshpd_id: 106154108 file_type: CDM All file_ext: xlsx common25: None
hospital_chars_list_for_ca_provs_in_st_fisc_yr_2019_20	1	oshpd_id: 106154108 oshpd_provider_name: MERCY SOUTHWEST HOSPITAL designated_nicu_as_defined_by_dhcs: No dph: No ndph: No oshpd_rural_hospital: No dhcs_designated_remote_rural: No sfy_2019_20_cost_to_charge_ratio_pct: 0.24102 ffy_2019_wage_index_value: 1.25 ffy_2019_wage_index_value_adjusted_for_ca_neutrality_factor: 1.2164 sfy_2019_20_unadjusted_statewide_base_rate: 6584 sfy_2019_20_wage_adjusted_statewide_base_rate: 7557 sfy_2019_20_rehab_rate: 0 sfy_2019_20_admin_2_190_rate: 1074.41 sfy_2019_20_admin_2_199_rate: 990.88
licensed_healthcare_facility_listing	15	period: current oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 85 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35153930 longitude: -119.11243920 period: 2016-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 78 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2017-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 78 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2018-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2019-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2020-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2021-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2022-12-31 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 85 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2017-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 78 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2018-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2019-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2020-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2021-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 82 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2022-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 85 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000 period: 2023-06-30 oshpd_id: 106154108 facility_name: MERCY SOUTHWEST HOSPITAL license_num: 120000184 facility_level_desc: Consolidated Facility dba_address1: 400 OLD RIVER RD dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Emergency - Basic total_number_beds: 85 facility_status_desc: Open facility_status_date: 1992-07-15 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.35496000 longitude: -119.11528000