Table # Values
ambulatory_surgery_char_by_faclty_2016 1 oshpd_id: 306544086
facility_num: 544086
facility_name: HAPY BEAR SURGERY, LLC
county_code: 54
license_type_desc: Clinic
county_name: TULARE
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
control_type_desc: Investor - Limited Liability Company
rural_hospital_desc: None
teaching_hospital_desc: None
licensed_bed_size: -
senate_district_desc: District 16
assembly_district_desc: District 26
mssa_name: TIPTON/TULARE/WOODVILLE
mssa_designation: Rural
teach_rural: NA
sex_female: 1111
sex_male: 1234
sex_unknown_invalid: None
hcount: 0
ccount: 1
license_type: Clinic
age_10_19: 231
age_20_29: None
age_30_39: None
age_40_49: None
age_50_59: None
age_60_69: None
age_70_79: None
age_80_: None
age_01_09: 2107
age_under_1: 7
age_unknown: None
asian_pacific_islander: 18
black: 3
hispanic: 617
other_race: 105
unknown_race: 1501
white: 93
american_indian_alaska_native: 8
acute_care: 1
rehab: None
routine: 2344
sn_ic_care: None
against_medical_advice: None
cah: None
childrens_or_cancer: None
home_health_service: None
hospice_care: None
invalid_blank_disp: None
ambulatory_surgery_char_by_faclty_2017 1 oshpd_id: 306544086
facility_num: 544086
facility_name: HAPY BEAR SURGERY, LLC
county_code: 54
license_type_desc: Clinic
county_name: TULARE
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
control_type_desc: Investor - Limited Liability Company
rural_hospital_desc: None
teaching_hospital_desc: None
licensed_bed_size: -
senate_district_desc: District 16
assembly_district_desc: District 26
mssa_name: TIPTON/TULARE/WOODVILLE
mssa_designation: Rural
teach_rural: NA
sex_female: 1076
sex_male: 1180
sex_unknown_invalid: None
hcount: 0
ccount: 1
license_type: Clinic
age_10_19: 197
age_20_29: None
age_30_39: None
age_40_49: None
age_50_59: None
age_60_69: None
age_70_79: None
age_80_: None
age_01_09: 2032
age_under_1: 27
age_unknown: None
asian_pacific_islander: 10
black: 5
hispanic: 1602
other_race: 119
unknown_race: 460
white: 55
american_indian_alaska_native: 5
acute_care: None
against_medical_advice: None
rehab: None
routine: 2256
sn_ic_care: None
cah: None
home_health_service: None
hospice_care: None
not_defined_elsewhere: None
psychiatric_care: None
ambulatory_surgery_char_by_faclty_2021 1 oshpd_id: 306544086
oshpd_id9: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_type_desc: Clinic
dba_zip_code: 93274
control_type_desc: Investor - Limited Liability Company
licensed_bed_size: -
senate_district_desc: District 16
assembly_district_desc: District 26
mssa_name: Tipton/Tulare/Woodville
mssa_designation: Rural
county_name: TULARE
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
teach_rural: NA
age_0_09: 2271
age_10_19: 367
age_20_29: None
age_30_39: None
age_40_49: None
age_50_59: None
age_60_69: None
age_70_79: None
age_80_: None
age_other_unknown: None
english: 1907
spanish: 727
chinese: None
cantonese_yue_chinese: None
vietnamese: None
all_other_languages: None
pls_other_unknown: 4
eth_hispanic: 2553
eth_nonhispanic: 80
eth_other_unknown: 5
dx_certain_perinatal_conditions: None
dx_circulatory: None
dx_congenital: None
dx_digestive: 2638
dx_diseases_of_the_blood: None
dx_ear: None
dx_endocrine: None
dx_eye: None
dx_factors_influencing_health: None
dx_genitourinary: None
dx_infectious: None
dx_injury_poisoning: None
dx_mentalhealth: None
dx_musculoskeletal: None
dx_neoplasms: None
dx_nervous_system: None
dx_other_unknown: None
ambulatory_surgery_char_by_faclty_2022 1 oshpd_id: 306544086
oshpd_id9: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_type_desc: Clinic
dba_zip_code: 93274
control_type_desc: Investor - Limited Liability Company
licensed_bed_size: -
senate_district_desc: District 16
assembly_district_desc: District 26
mssa_name: Tipton/Tulare/Woodville
mssa_designation: Rural
county_name: TULARE
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
teach_rural: NA
age_0_09: 1898
age_10_19: 420
age_20_29: None
age_30_39: None
age_40_49: None
age_50_59: None
age_60_69: None
age_70_79: None
age_80_: None
age_other_unknown: 1
english: 1729
spanish: 589
cantonese_yue_chinese: None
vietnamese: None
all_other_languages: None
pls_other_unknown: 1
eth_hispanic: 1821
eth_nonhispanic: 396
eth_other_unknown: 102
dx_certain_perinatal_conditions: None
dx_circulatory: None
dx_congenital: None
dx_digestive: 2319
dx_diseases_of_the_blood: None
dx_ear: None
dx_endocrine: None
dx_eye: None
dx_factors_influencing_health: None
dx_genitourinary: None
dx_infectious: None
dx_injury_poisoning: None
dx_mentalhealth: None
dx_musculoskeletal: None
dx_neoplasms: None
dx_nervous_system: None
dx_other_unknown: None
dx_pregnancy_childbirth: None
ambulatory_surgery_char_by_faclty_2023 1 oshpd_id: 306544086
oshpd_id9: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_type_desc: Clinic
dba_zip_code: 93274
control_type_desc: Investor - Limited Liability Company
licensed_bed_size: -
senate_district_desc: District 12
assembly_district_desc: District 33
mssa_name: Tipton/Tulare/Woodville
mssa_designation: Rural
county_name: TULARE
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
teach_rural: NA
age_0_09: 2173
age_10_19: 498
age_20_29: None
age_30_39: None
age_40_49: None
age_50_59: None
age_60_69: None
age_70_79: None
age_80_: None
age_other_unknown: 1
english: 1970
spanish: 691
cantonese_yue_chinese: None
vietnamese: None
all_other_languages: None
pls_other_unknown: 11
eth_hispanic: 2255
eth_nonhispanic: 410
eth_other_unknown: 7
dx_certain_perinatal_conditions: None
dx_circulatory: None
dx_congenital: None
dx_digestive: 2672
dx_diseases_of_the_blood: None
dx_ear: None
dx_endocrine: None
dx_eye: None
dx_factors_influencing_health: None
dx_genitourinary: None
dx_infectious: None
dx_injury_poisoning: None
dx_mentalhealth: None
dx_musculoskeletal: None
dx_neoplasms: None
dx_nervous_system: None
dx_other_unknown: None
dx_pregnancy_childbirth: None
licensed_healthcare_facility_listing 15 period: current
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23412870
longitude: -119.33239820
period: 2016-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2017-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2018-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2019-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2020-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2021-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2022-12-31
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2017-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2018-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2019-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 HILLMAN ST
dba_city: TULARE
dba_zip_code: 93274
county_code: 54
county_name: TULARE
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2020-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2021-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2022-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000
period: 2023-06-30
oshpd_id: 306544086
facility_name: HAPY BEAR SURGERY, LLC
license_num: 550001657
facility_level_desc: Parent Facility
dba_address1: 1979 Hillman St
dba_city: Tulare
dba_zip_code: 93274
county_code: 54
county_name: Tulare
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2011-08-15
license_type_desc: Clinic
license_category_desc: Surgical Clinic
latitude: 36.23027000
longitude: -119.33098000