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