Table | # | Values |
---|---|---|
ambulatory_surgery_char_by_faclty_2021 | 1 |
oshpd_id: 306150421 oshpd_id9: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_type_desc: Clinic dba_zip_code: 93311 control_type_desc: Investor - Limited Liability Company licensed_bed_size: - senate_district_desc: District 16 assembly_district_desc: District 34 mssa_name: Bakersfield Northwest/Rosedale mssa_designation: Urban county_name: KERN dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD teach_rural: NA age_0_09: 28 age_10_19: 161 age_20_29: 189 age_30_39: 261 age_40_49: 295 age_50_59: 408 age_60_69: 290 age_70_79: 96 age_80_: 34 age_other_unknown: None english: 1501 spanish: 243 chinese: None cantonese_yue_chinese: None vietnamese: None all_other_languages: 17 pls_other_unknown: 1 eth_hispanic: 888 eth_nonhispanic: 807 eth_other_unknown: 67 dx_certain_perinatal_conditions: None dx_circulatory: 4 dx_congenital: 15 dx_digestive: 20 dx_diseases_of_the_blood: None dx_ear: 13 dx_endocrine: 44 dx_eye: None dx_factors_influencing_health: 55 dx_genitourinary: 139 dx_infectious: 7 dx_injury_poisoning: 407 dx_mentalhealth: 2 dx_musculoskeletal: 658 dx_neoplasms: 56 dx_nervous_system: 220 dx_other_unknown: 3 |
ambulatory_surgery_char_by_faclty_2022 | 1 |
oshpd_id: 306150421 oshpd_id9: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_type_desc: Clinic dba_zip_code: 93311 control_type_desc: Investor - Limited Liability Company licensed_bed_size: - senate_district_desc: District 16 assembly_district_desc: District 34 mssa_name: Bakersfield Northwest/Rosedale mssa_designation: Urban county_name: KERN dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD teach_rural: NA age_0_09: 35 age_10_19: 140 age_20_29: 150 age_30_39: 269 age_40_49: 385 age_50_59: 485 age_60_69: 388 age_70_79: 152 age_80_: 44 age_other_unknown: None english: 1639 spanish: 385 cantonese_yue_chinese: None vietnamese: None all_other_languages: 23 pls_other_unknown: 1 eth_hispanic: 1099 eth_nonhispanic: 940 eth_other_unknown: 9 dx_certain_perinatal_conditions: None dx_circulatory: 13 dx_congenital: 6 dx_digestive: 124 dx_diseases_of_the_blood: 2 dx_ear: 24 dx_endocrine: 27 dx_eye: 2 dx_factors_influencing_health: 165 dx_genitourinary: 151 dx_infectious: 10 dx_injury_poisoning: 393 dx_mentalhealth: None dx_musculoskeletal: 727 dx_neoplasms: 87 dx_nervous_system: 236 dx_other_unknown: 1 dx_pregnancy_childbirth: None |
ambulatory_surgery_char_by_faclty_2023 | 1 |
oshpd_id: 306150421 oshpd_id9: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_type_desc: Clinic dba_zip_code: 93311 control_type_desc: Investor - Limited Liability Company licensed_bed_size: - senate_district_desc: District 12 assembly_district_desc: District 32 mssa_name: Bakersfield Northwest/Rosedale mssa_designation: Urban county_name: KERN dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD teach_rural: NA age_0_09: 27 age_10_19: 153 age_20_29: 177 age_30_39: 266 age_40_49: 449 age_50_59: 665 age_60_69: 425 age_70_79: 148 age_80_: 34 age_other_unknown: None english: 1732 spanish: 575 cantonese_yue_chinese: None vietnamese: None all_other_languages: 34 pls_other_unknown: 3 eth_hispanic: 1391 eth_nonhispanic: 949 eth_other_unknown: 4 dx_certain_perinatal_conditions: None dx_circulatory: 5 dx_congenital: 8 dx_digestive: 251 dx_diseases_of_the_blood: 2 dx_ear: 30 dx_endocrine: 31 dx_eye: None dx_factors_influencing_health: 367 dx_genitourinary: 129 dx_infectious: 15 dx_injury_poisoning: 426 dx_mentalhealth: 2 dx_musculoskeletal: 600 dx_neoplasms: 169 dx_nervous_system: 217 dx_other_unknown: 1 dx_pregnancy_childbirth: None |
facility_profile_attributes | 1 |
facility_desc: KERN MEDICAL SURGERY CENTER, LLC. site_address1: 9300 STOCKDALE HWY site_address2: SUITE 200 site_city: BAKERSFIELD site_zip: 93311 site_x_coordinate: -119.105412 site_y_coordinate: 35.355289 oshpd_id: 306150421 license_type_desc: Clinic license_category_desc: Surgical Clinic license_number: 550004422 facility_level_desc: Parent Facility er_service_level_desc: Not Specified licensed_beds: None facility_status_desc: Open financial_facility_count: 0 consolidated_facility_desc_pipe: None consolidated_facility_desc_comma: None period_begin_date: None period_end_date: None net_pat_rev_medicare_traditional_ip: None net_pat_rev_medicare_managed_ip: None net_pat_rev_medi_cal_traditional_ip: None net_pat_rev_medi_cal_managed_ip: None net_pat_rev_county_indigent_traditional_ip: None net_pat_rev_county_indigent_managed_ip: None net_pat_rev_third_party_traditional_ip: None net_pat_rev_third_party_managed_ip: None net_pat_rev_other_indigent_ip: None net_pat_rev_other_payer_ip: None net_pat_rev_total_ip: None net_pat_rev_medicare_traditional_op: None net_pat_rev_medicare_managed_op: None net_pat_rev_medi_cal_traditional_op: None net_pat_rev_medi_cal_managed_op: None net_pat_rev_county_indigent_traditional_op: None net_pat_rev_county_indigent_managed_op: None net_pat_rev_third_party_traditional_op: None net_pat_rev_third_party_managed_op: None net_pat_rev_other_indigent_op: None net_pat_rev_other_payer_op: None net_pat_rev_total_op: None payer_mix_medicare_traditional_ip: .000000000000 payer_mix_medicare_traditional_ip_state: None payer_mix_medicare_managed_ip: .000000000000 payer_mix_medicare_managed_ip_state: None payer_mix_medi_cal_traditional_ip: .000000000000 payer_mix_medi_cal_traditional_ip_state: None payer_mix_medi_cal_managed_ip: .000000000000 payer_mix_medi_cal_managed_ip_state: None payer_mix_county_indigent_traditional_ip: .000000000000 payer_mix_county_indigent_traditional_ip_state: None payer_mix_county_indigent_managed_ip: .000000000000 payer_mix_county_indigent_managed_ip_state: None payer_mix_third_party_traditional_ip: .000000000000 payer_mix_third_party_traditional_ip_state: None payer_mix_third_party_managed_ip: .000000000000 payer_mix_third_party_managed_ip_state: None payer_mix_other_indigent_ip: .000000000000 payer_mix_other_indigent_ip_state: None payer_mix_other_payer_ip: .000000000000 payer_mix_other_payer_ip_state: None payer_mix_medicare_traditional_op: .000000000000 payer_mix_medicare_traditional_op_state: None payer_mix_medicare_managed_op: .000000000000 payer_mix_medicare_managed_op_state: None payer_mix_medi_cal_traditional_op: .000000000000 payer_mix_medi_cal_traditional_op_state: None payer_mix_medi_cal_managed_op: .000000000000 payer_mix_medi_cal_managed_op_state: None payer_mix_county_indigent_traditional_op: .000000000000 payer_mix_county_indigent_traditional_op_state: None payer_mix_county_indigent_managed_op: .000000000000 payer_mix_county_indigent_managed_op_state: None payer_mix_third_party_traditional_op: .000000000000 payer_mix_third_party_traditional_op_state: None payer_mix_third_party_managed_op: .000000000000 payer_mix_third_party_managed_op_state: None payer_mix_other_indigent_op: .000000000000 payer_mix_other_indigent_op_state: None payer_mix_other_payer_op: .000000000000 payer_mix_other_payer_op_state: None avg_stay_medicare_traditional: None avg_stay_medicare_managed: None avg_stay_medi_cal_traditional: None avg_stay_medi_cal_managed: None avg_stay_county_indigent_traditional: None avg_stay_county_indigent_managed: None avg_stay_third_party_traditional: None avg_stay_third_party_managed: None avg_stay_other_indigent_total: None avg_stay_other_payer_total: None avg_stay_total: None 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: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35528890 longitude: -119.10541200 |
licensed_facility_listing_05 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_06 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_07 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_08 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_09 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35527670 longitude: -119.10538410 |
licensed_facility_listing_10 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35528890 longitude: -119.10541200 |
licensed_facility_listing_13 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_14 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_15 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_16 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_17 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |
licensed_facility_listing_18 | 1 |
oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 0.00000000 longitude: 0.00000000 |
licensed_healthcare_facility_listing | 10 |
period: current oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35528890 longitude: -119.10541200 period: 2019-12-31 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2020-12-31 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2021-12-31 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2022-12-31 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2019-06-30 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 STOCKDALE HWY dba_city: BAKERSFIELD dba_zip_code: 93311 county_code: 15 county_name: KERN er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2020-06-30 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2021-06-30 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2022-06-30 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 period: 2023-06-30 oshpd_id: 306150421 facility_name: KERN MEDICAL SURGERY CENTER, LLC. license_num: 550004422 facility_level_desc: Parent Facility dba_address1: 9300 Stockdale Hwy dba_city: Bakersfield dba_zip_code: 93311 county_code: 15 county_name: Kern er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 2018-11-02 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 35.35451000 longitude: -119.10479000 |