| Table | # | Values |
|---|---|---|
| chargemasters_dirs | 1 |
pk: 4175 full_name: 2022/Bella Sera oshpd_id: 206154001 year: 2022 |
| chargemasters_files | 1 |
pk: 11013 dir_pk: 4175 year: 2022 full_name: 2022/Bella Sera/206154001_CDM_ALL_2022.xls oshpd_id: 206154001 file_type: CDM All file_ext: xls common25: 0 |
| licensed_healthcare_facility_listing | 10 |
period: current oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 NO. CHINA LAKE BOULEVARD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64096070 longitude: -117.67268100 period: 2020-12-31 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2021-12-31 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2022-12-31 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2018-06-30 oshpd_id: 206154001 facility_name: RIDGECREST REGIONAL HOSPITAL TRANSITIONAL CARE & REHABILITATION UNIT D/P SNF license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 NO. CHINA LAKE BOULEVARD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: KERN er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2019-06-30 oshpd_id: 206154001 facility_name: RIDGECREST REGIONAL HOSPITAL TRANSITIONAL CARE & REHABILITATION UNIT D/P SNF license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 NO. CHINA LAKE BOULEVARD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: KERN er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2020-06-30 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2021-06-30 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2022-06-30 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 period: 2023-06-30 oshpd_id: 206154001 facility_name: BELLA SERA license_num: 120000186 facility_level_desc: Distinct Part Facility dba_address1: 1131 N CHINA LAKE BLVD dba_city: RIDGECREST dba_zip_code: 93555 county_code: 15 county_name: Kern er_service_level_desc: None total_number_beds: 99 facility_status_desc: Open facility_status_date: 2015-03-04 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 35.64127000 longitude: -117.67006800 |
| long_term_care_facilities_utilization_data_2012 | 1 |
oshpd_id: 206154001 fac_name: RIDGECREST HEALTHCARE CENTER fac_address_one: 1131 NO. CHINA LAKE BOULEVARD fac_address_two: None fac_city: RIDGECREST fac_zipcode: 93555 fac_phone: 760-446-3591 fac_admin_name: ROBERT AGUILOS fac_oper_curryr: Yes beg_date: 2012-01-01 00:00:00 end_date: 2012-12-31 00:00:00 parent_name: RIDGECREST HEALTHCARE CENTER, INC. parent_address_one: PO BOX 39696 parent_address_two: None parent_city: LOS ANGELES parent_state: CA parent_zip_9: 90039 report_prep_name: Robert Aguilos lic_status: Open lic_status_date: 1986-12-10 00:00:00 lic_orig_date: 1986-12-10 00:00:00 report_status: None mcal_provider_no: None mcare_provider_no: None aclaims_no: 120000323 assembly_dist: 32 senate_dist: 18 congress_dist: 22 cens_tract: 6029005401 med_svc_study_area: 64 laco_svc_plan_area: None health_svc_area: 09 - Central county: Kern license_no: 120000150 longitude: -117.670068 latitude: 35.64127 type_lic: Skilled Nursing Facility type_cntrl: Investor - Corporation cert_mcar_sn: YES cert_mcal_sn: YES cert_mcal_sn_md: None cert_mcal_ic: None cert_mcal_icdd: None cert_mcal_sub_or_sub_ped: None sn_gen_ltc_cens_py: 76 sn_md_ltc_cens_py: 0 ic_gen_ltc_cens_py: 0 ic_dd_ltc_cens_py: 0 cl_ltc_cens_py: 0 ltc_cens_py_totl: 76 sn_gen_ltc_adm: 169 sn_md_ltc_adm: 0 |
| long_term_care_facilities_utilization_data_2012_sec_5 | 1 |
oshpd_id: 206154001 fac_name: RIDGECREST HEALTHCARE CENTER equip_acq_over_500k: No equip_01_descrip: None equip_01_value: None equip_01_acqui_dt: None equip_01_acqui_means: None equip_02_descrip: None equip_02_value: None equip_02_acqui_dt: None equip_02_acqui_means: None equip_03_descrip: None equip_03_value: None equip_03_acqui_dt: None equip_03_acqui_means: None equip_04_descrip: None equip_04_value: None equip_04_acqui_dt: None equip_04_acqui_means: None equip_05_descrip: None equip_05_value: None equip_05_acqui_dt: None equip_05_acqui_means: None equip_06_descrip: None equip_06_value: None equip_06_acqui_dt: None equip_06_acqui_means: None equip_07_descrip: None equip_07_value: None equip_07_acqui_dt: None equip_07_acqui_means: None equip_08_descrip: None equip_08_value: None equip_08_acqui_dt: None equip_08_acqui_means: None equip_09_descrip: None equip_09_value: None equip_09_acqui_dt: None equip_09_acqui_means: None equip_10_descrip: None equip_10_value: None equip_10_acqui_dt: None equip_10_acqui_means: None cap_exp_over_1mil: No proj_01_descrip_cap_exp: None proj_01_projtd_cap_exp: None proj_01_oshpd_proj_no: None proj_02_descrip_cap_exp: None proj_02_projtd_cap_exp: None proj_02_oshpd_proj_no: None proj_03_descrip_cap_exp: None proj_03_projtd_cap_exp: None |
| long_term_care_faclts_util_data_2013 | 1 |
oshpd_id: 206154001 fac_name: RIDGECREST HEALTHCARE CENTER fac_address_one: 1131 NO. CHINA LAKE BOULEVARD fac_address_two: None fac_city: RIDGECREST fac_zipcode: 93555 fac_phone: 760-446-3591 fac_admin_name: ROBERT AGUILOS fac_oper_curryr: Yes beg_date: 2013-01-01 00:00:00 end_date: 2013-12-31 00:00:00 parent_name: RIDGECREST HEALTHCARE CENTER,INC parent_address_one: PO BOX 396 parent_address_two: None parent_city: LOS ANGELES parent_state: CA parent_zip_9: 90039 report_prep_name: Robert Aguilos lic_status: Open lic_status_date: 1986-12-10 00:00:00 lic_orig_date: 1986-12-10 00:00:00 report_status: None mcal_provider_no: None mcare_provider_no: None aclaims_no: 120000323 assembly_dist: 34 senate_dist: 16 congress_dist: 23 cens_tract: 6029005401 med_svc_study_area: 64 laco_svc_plan_area: None health_svc_area: 09 - Central county: Kern license_no: 120000150 longitude: -117.670068 latitude: 35.64127 type_lic: Skilled Nursing Facility type_cntrl: Investor - Corporation cert_mcar_sn: YES cert_mcal_sn: YES cert_mcal_sn_md: None cert_mcal_ic: None cert_mcal_icdd: None cert_mcal_sub_or_sub_ped: None sn_gen_ltc_cens_py: 77 sn_md_ltc_cens_py: 0 ic_gen_ltc_cens_py: 0 ic_dd_ltc_cens_py: 0 cl_ltc_cens_py: 0 ltc_cens_py_totl: 77 sn_gen_ltc_adm: 205 sn_md_ltc_adm: 0 |
| long_term_care_faclts_util_data_2013_sec_5 | 1 |
oshpd_id: 206154001 fac_name: RIDGECREST HEALTHCARE CENTER equip_acq_over_500k: No equip_01_descrip: None equip_01_value: None equip_01_acqui_dt: None equip_01_acqui_means: None equip_02_descrip: None equip_02_value: None equip_02_acqui_dt: None equip_02_acqui_means: None equip_03_descrip: None equip_03_value: None equip_03_acqui_dt: None equip_03_acqui_means: None equip_04_descrip: None equip_04_value: None equip_04_acqui_dt: None equip_04_acqui_means: None equip_05_descrip: None equip_05_value: None equip_05_acqui_dt: None equip_05_acqui_means: None equip_06_descrip: None equip_06_value: None equip_06_acqui_dt: None equip_06_acqui_means: None equip_07_descrip: None equip_07_value: None equip_07_acqui_dt: None equip_07_acqui_means: None equip_08_descrip: None equip_08_value: None equip_08_acqui_dt: None equip_08_acqui_means: None equip_09_descrip: None equip_09_value: None equip_09_acqui_dt: None equip_09_acqui_means: None equip_10_descrip: None equip_10_value: None equip_10_acqui_dt: None equip_10_acqui_means: None cap_exp_over_1mil: No proj_01_descrip_cap_exp: None proj_01_projtd_cap_exp: None proj_01_oshpd_proj_no: None proj_02_descrip_cap_exp: None proj_02_projtd_cap_exp: None proj_02_oshpd_proj_no: None proj_03_descrip_cap_exp: None proj_03_projtd_cap_exp: None |
| long_term_care_faclts_util_data_2014 | 1 |
oshpd_id: 206154001 fac_name: RIDGECREST HEALTHCARE CENTER fac_address_one: 1131 NO. CHINA LAKE BOULEVARD fac_address_two: None fac_city: RIDGECREST fac_zipcode: 93555 fac_phone: 760-446-3591 fac_admin_name: Michelle Lemke fac_oper_curryr: Yes beg_date: 2014-01-01 00:00:00 end_date: 2014-12-31 00:00:00 parent_name: Ridgecrest Regional Hospital parent_address_one: 1081 N. China Lake Blvd. parent_address_two: None parent_city: Ridgecrest parent_state: CA parent_zip_9: 93555 report_prep_name: Michelle Lemke lic_status: Open lic_status_date: 2015-03-04 00:00:00 lic_orig_date: 1986-12-10 00:00:00 report_status: None mcal_provider_no: None mcare_provider_no: None aclaims_no: 120000323 assembly_dist: 34 senate_dist: 16 congress_dist: 23 cens_tract: 6029005401 med_svc_study_area: 64 laco_svc_plan_area: None health_svc_area: 09 - Central county: Kern license_no: 120000186 longitude: -117.669853 latitude: 35.641971 type_lic: Skilled Nursing Facility type_cntrl: Non-Profit Corporation (incl. Church-related) cert_mcar_sn: YES cert_mcal_sn: YES cert_mcal_sn_md: None cert_mcal_ic: None cert_mcal_icdd: None cert_mcal_sub_or_sub_ped: None sn_gen_ltc_cens_py: 86 sn_md_ltc_cens_py: 0 ic_gen_ltc_cens_py: 0 ic_dd_ltc_cens_py: 0 cl_ltc_cens_py: 0 hofa_ltc_cens_py: 0 ltc_cens_py_totl: 86 sn_gen_ltc_adm: 124 |
| long_term_care_faclts_util_data_2014_sec_5 | 1 |
oshpd_id: 206154001 fac_name: RIDGECREST HEALTHCARE CENTER equip_acq_over_500k: No equip_01_descrip: None equip_01_value: None equip_01_acqui_dt: None equip_01_acqui_means: None equip_02_descrip: None equip_02_value: None equip_02_acqui_dt: None equip_02_acqui_means: None equip_03_descrip: None equip_03_value: None equip_03_acqui_dt: None equip_03_acqui_means: None equip_04_descrip: None equip_04_value: None equip_04_acqui_dt: None equip_04_acqui_means: None equip_05_descrip: None equip_05_value: None equip_05_acqui_dt: None equip_05_acqui_means: None equip_06_descrip: None equip_06_value: None equip_06_acqui_dt: None equip_06_acqui_means: None equip_07_descrip: None equip_07_value: None equip_07_acqui_dt: None equip_07_acqui_means: None equip_08_descrip: None equip_08_value: None equip_08_acqui_dt: None equip_08_acqui_means: None equip_09_descrip: None equip_09_value: None equip_09_acqui_dt: None equip_09_acqui_means: None equip_10_descrip: None equip_10_value: None equip_10_acqui_dt: None equip_10_acqui_means: None cap_exp_over_1mil: No proj_01_descrip_cap_exp: None proj_01_projtd_cap_exp: None proj_01_oshpd_proj_no: None proj_02_descrip_cap_exp: None proj_02_projtd_cap_exp: None proj_02_oshpd_proj_no: None proj_03_descrip_cap_exp: None proj_03_projtd_cap_exp: None |