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
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