Table | # | Values |
---|---|---|
facility_profile_attributes | 1 |
facility_desc: SONOMA COUNTY HEALING CENTER site_address1: 7440 RANCHO LOS GUILICOS ROAD site_address2: None site_city: SANTA ROSA site_zip: 95409 site_x_coordinate: -122.581414 site_y_coordinate: 38.439551 oshpd_id: 106490040 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility license_number: M02016065 facility_level_desc: Parent Facility er_service_level_desc: Not Specified licensed_beds: 16 facility_status_desc: Open financial_facility_count: 1 consolidated_facility_desc_pipe: SONOMA COUNTY HEALING CENTER consolidated_facility_desc_comma: SONOMA COUNTY HEALING CENTER period_begin_date: 2022-02-15 period_end_date: 2022-12-31 net_pat_rev_medicare_traditional_ip: 0 net_pat_rev_medicare_managed_ip: 0 net_pat_rev_medi_cal_traditional_ip: 0 net_pat_rev_medi_cal_managed_ip: 0 net_pat_rev_county_indigent_traditional_ip: 4713313 net_pat_rev_county_indigent_managed_ip: 0 net_pat_rev_third_party_traditional_ip: 0 net_pat_rev_third_party_managed_ip: 0 net_pat_rev_other_indigent_ip: 0 net_pat_rev_other_payer_ip: 0 net_pat_rev_total_ip: 4713313 net_pat_rev_medicare_traditional_op: 0 net_pat_rev_medicare_managed_op: 0 net_pat_rev_medi_cal_traditional_op: 0 net_pat_rev_medi_cal_managed_op: 0 net_pat_rev_county_indigent_traditional_op: 0 net_pat_rev_county_indigent_managed_op: 0 net_pat_rev_third_party_traditional_op: 0 net_pat_rev_third_party_managed_op: 0 net_pat_rev_other_indigent_op: 0 net_pat_rev_other_payer_op: 0 net_pat_rev_total_op: 0 payer_mix_medicare_traditional_ip: .000000000000 payer_mix_medicare_traditional_ip_state: .2177 payer_mix_medicare_managed_ip: .000000000000 payer_mix_medicare_managed_ip_state: .1770 payer_mix_medi_cal_traditional_ip: .000000000000 payer_mix_medi_cal_traditional_ip_state: .1065 payer_mix_medi_cal_managed_ip: .000000000000 payer_mix_medi_cal_managed_ip_state: .2111 payer_mix_county_indigent_traditional_ip: 1.000000000000 payer_mix_county_indigent_traditional_ip_state: .0087 payer_mix_county_indigent_managed_ip: .000000000000 payer_mix_county_indigent_managed_ip_state: .0005 payer_mix_third_party_traditional_ip: .000000000000 payer_mix_third_party_traditional_ip_state: .0398 payer_mix_third_party_managed_ip: .000000000000 payer_mix_third_party_managed_ip_state: .2221 payer_mix_other_indigent_ip: .000000000000 payer_mix_other_indigent_ip_state: .0050 payer_mix_other_payer_ip: .000000000000 payer_mix_other_payer_ip_state: .0115 payer_mix_medicare_traditional_op: .000000000000 payer_mix_medicare_traditional_op_state: .2282 payer_mix_medicare_managed_op: .000000000000 payer_mix_medicare_managed_op_state: .0944 payer_mix_medi_cal_traditional_op: .000000000000 payer_mix_medi_cal_traditional_op_state: .0628 payer_mix_medi_cal_managed_op: .000000000000 payer_mix_medi_cal_managed_op_state: .2478 payer_mix_county_indigent_traditional_op: .000000000000 payer_mix_county_indigent_traditional_op_state: .0095 payer_mix_county_indigent_managed_op: .000000000000 payer_mix_county_indigent_managed_op_state: .0024 payer_mix_third_party_traditional_op: .000000000000 payer_mix_third_party_traditional_op_state: .0513 payer_mix_third_party_managed_op: .000000000000 payer_mix_third_party_managed_op_state: .2738 payer_mix_other_indigent_op: .000000000000 payer_mix_other_indigent_op_state: .0081 payer_mix_other_payer_op: .000000000000 payer_mix_other_payer_op_state: .0216 avg_stay_medicare_traditional: .0000 avg_stay_medicare_managed: .0000 avg_stay_medi_cal_traditional: .0000 avg_stay_medi_cal_managed: .0000 avg_stay_county_indigent_traditional: 25.2637 avg_stay_county_indigent_managed: .0000 avg_stay_third_party_traditional: .0000 avg_stay_third_party_managed: .0000 avg_stay_other_indigent_total: .0000 avg_stay_other_payer_total: .0000 avg_stay_total: 25.2637 active_projects: None active_project_costs: None active_projects_state: 4279 active_project_costs_state: 18558539344 spc_1: None spc_2: None spc_3: None spc_4: None spc_5: None spc_1_state: 33 spc_2_state: 655 spc_3_state: 385 spc_4_state: 781 spc_5_state: 1446 sysdate: None |
licensed_facility_listing_01 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 RANCHO LOS GUILICOS ROAD dba_city: SANTA ROSA dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43955100 longitude: -122.58141380 |
licensed_facility_listing_08 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M20016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 |
licensed_facility_listing_09 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 |
licensed_facility_listing_10 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 RANCHO LOS GUILICOS ROAD dba_city: SANTA ROSA dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43955100 longitude: -122.58141380 |
licensed_facility_listing_16 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M20016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 |
licensed_facility_listing_17 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 |
licensed_facility_listing_18 | 1 |
oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 |
licensed_healthcare_facility_listing | 4 |
period: current oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 RANCHO LOS GUILICOS ROAD dba_city: SANTA ROSA dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43955100 longitude: -122.58141380 period: 2022-12-31 oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M20016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 period: 2022-06-30 oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M20016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 period: 2023-06-30 oshpd_id: 106490040 facility_name: SONOMA COUNTY HEALING CENTER license_num: M02016065 facility_level_desc: Parent Facility dba_address1: 7440 Rancho Los Guilicos Rd dba_city: Santa Rosa dba_zip_code: 95409 county_code: 49 county_name: Sonoma er_service_level_desc: Not Applicable total_number_beds: 16 facility_status_desc: Open facility_status_date: 2022-02-01 license_type_desc: Hospital license_category_desc: Psychiatric Health Facility latitude: 38.43963000 longitude: -122.58131000 |