Table | # | Values |
---|---|---|
licensed_healthcare_facility_listing | 4 |
period: current oshpd_id: 206074192 facility_name: SHADELANDS POST ACUTE license_num: 550007994 facility_level_desc: Parent Facility dba_address1: 2765 MITCHELL DRIVE dba_city: WALNUT CREEK dba_zip_code: 94598 county_code: 07 county_name: Contra Costa er_service_level_desc: Not Applicable total_number_beds: 59 facility_status_desc: Open facility_status_date: 2022-04-28 license_type_desc: Long Term Care Facility license_category_desc: Skilled Nursing Facility latitude: 37.92957400 longitude: -122.02378720 period: 2022-12-31 oshpd_id: 206074192 facility_name: SHADELANDS POST ACUTE license_num: 550007994 facility_level_desc: Parent Facility dba_address1: 2765 Mitchell Dr dba_city: Walnut Creek dba_zip_code: 94598 county_code: 07 county_name: Contra Costa er_service_level_desc: Not Applicable total_number_beds: 50 facility_status_desc: Open facility_status_date: 2022-04-28 license_type_desc: Long Term Care Facility license_category_desc: Skilled Nursing Facility latitude: 37.92970000 longitude: -122.02391000 period: 2022-06-30 oshpd_id: 206074192 facility_name: SHADELANDS POST ACUTE license_num: 550007994 facility_level_desc: Parent Facility dba_address1: 2765 Mitchell Dr dba_city: Walnut Creek dba_zip_code: 94598 county_code: 07 county_name: Contra Costa er_service_level_desc: Not Applicable total_number_beds: 50 facility_status_desc: Open facility_status_date: 2022-04-28 license_type_desc: Long Term Care Facility license_category_desc: Skilled Nursing Facility latitude: 37.92970000 longitude: -122.02391000 period: 2023-06-30 oshpd_id: 206074192 facility_name: SHADELANDS POST ACUTE license_num: 550007994 facility_level_desc: Parent Facility dba_address1: 2765 Mitchell Dr dba_city: Walnut Creek dba_zip_code: 94598 county_code: 07 county_name: Contra Costa er_service_level_desc: Not Applicable total_number_beds: 50 facility_status_desc: Open facility_status_date: 2022-04-28 license_type_desc: Long Term Care Facility license_category_desc: Skilled Nursing Facility latitude: 37.92970000 longitude: -122.02391000 |
pivot_table_long_term_care_faclts_util_data_2022 | 1 |
oshpd_id: 206074192 fac_no: 206074192 fac_name: SHADELANDS POST ACUTE fac_str_addr: 2765 MITCHELL DRIVE fac_city: WALNUT CREEK fac_zip: 94598 fac_operated_this_yr: Yes fac_op_per_begin_dt: 2022-08-01 00:00:00 fac_op_per_end_dt: 2022-12-31 00:00:00 license_no: 550007994 license_status: Open facility_level: Parent Facility longitude: -122.024213 latitude: 37.929527 assembly_dist: District 14 senate_dist: District 7 congress_dist: District 11 census_key: 06013338201 la_county_svc_plan_area: None health_svc_area: 05 - East Bay county: Contra Costa lic_cat: Skilled Nursing Facility licee_toc: Investor - Limited Liability Company cert_medi_cal_sn_mentally_disord: None cert_fac_medi_cal_ic_gen: None cert_fac_medi_cal_ic_dev_dis: None cert_medi_cal_subacute_pediatric: None sn_dec_31_py_cen: 0 sn_nursing_plus_adm: 202 sn_minus_dsch: 165 sn_dec_31_cen: 37 sn_pat_days_for: 5797 sn_lic_beds: 50 sn_lic_bed_days: 7650 pats_adm_from_home: 0 pats_adm_from_hsp: 195 pats_adm_from_other_ltc: 7 pats_adm_from_res_board_and_care: 0 pats_adm_from_other: 0 tot_pats_adm: 202 medicare_pats: 35 medi_cal_pats: None managed_care_pats: None private_insurance_pats: None self_pay_pats: 2 all_other_pats: None tot_pats: 37 dsch_lt_2_wks: 40 dsch_2_wks_and_lt_1_month: 41 dsch_1_month_and_lt_3_months: 83 dsch_3_months_and_lt_7_months: 1 dsch_7_months_and_lt_1_yr: None |