| Table | # | Values |
|---|---|---|
| chargemasters_dirs | 2 |
pk: 4896 full_name: 2023/Providence Santa Rosa Memorial Hospital-Sotoyome oshpd_id: 106490907 year: 2023 pk: 5101 full_name: 2024/PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL - SOTOYOME oshpd_id: 106490907 year: 2024 |
| chargemasters_files | 2 |
pk: 11554 dir_pk: 4896 year: 2023 full_name: 2023/Providence Santa Rosa Memorial Hospital-Sotoyome/106490907_CDM_ALL.xlsx oshpd_id: 106490907 file_type: CDM All file_ext: xlsx common25: 55 pk: 12352 dir_pk: 5101 year: 2024 full_name: 2024/PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL - SOTOYOME/106490907_CDM_ALL.xlsx oshpd_id: 106490907 file_type: CDM All file_ext: xlsx common25: None |
| hospital_chars_list_for_ca_provs_in_st_fisc_yr_2019_20 | 1 |
oshpd_id: 106490907 oshpd_provider_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME 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.19926 ffy_2019_wage_index_value: 1.7282 ffy_2019_wage_index_value_adjusted_for_ca_neutrality_factor: 1.6817 sfy_2019_20_unadjusted_statewide_base_rate: 6584 sfy_2019_20_wage_adjusted_statewide_base_rate: 9650 sfy_2019_20_rehab_rate: 1513 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: 106490907 facility_name: PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44151570 longitude: -122.70232000 period: 2016-12-31 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 60 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2017-12-31 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 60 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2018-12-31 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2019-12-31 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2020-12-31 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2021-12-31 oshpd_id: 106490907 facility_name: PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2022-12-31 oshpd_id: 106490907 facility_name: PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2017-06-30 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 60 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2018-06-30 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 60 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2019-06-30 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 SOTOYOME STREET dba_city: SANTA ROSA dba_zip_code: 95405 county_code: 49 county_name: SONOMA er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2020-06-30 oshpd_id: 106490907 facility_name: SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2021-06-30 oshpd_id: 106490907 facility_name: PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2022-06-30 oshpd_id: 106490907 facility_name: PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 period: 2023-06-30 oshpd_id: 106490907 facility_name: PROVIDENCE SANTA ROSA MEMORIAL HOSPITAL-SOTOYOME license_num: 140000648 facility_level_desc: Consolidated Facility dba_address1: 151 Sotoyome St dba_city: Santa Rosa dba_zip_code: 95405 county_code: 49 county_name: Sonoma er_service_level_desc: None total_number_beds: 46 facility_status_desc: Open facility_status_date: 1962-02-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.44204000 longitude: -122.70136000 |