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 |
facility_profile_attributes | 1 |
facility_desc: HAPY BEAR SURGERY, LLC site_address1: 1979 HILLMAN ST site_address2: None site_city: TULARE site_zip: 93274 site_x_coordinate: -119.332398 site_y_coordinate: 36.234129 oshpd_id: 306544086 license_type_desc: Clinic license_category_desc: Surgical Clinic license_number: 550001657 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: 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 |
licensed_facility_listing_02 | 1 |
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: 08/15/2011 license_type_desc: Clinic license_category_desc: Surgical Clinic longitude: -119.33098 latitude: 36.23027 |
licensed_facility_listing_03 | 1 |
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: 8/15/2011 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 36.23027 longitude: -119.33098 |
licensed_facility_listing_04 | 1 |
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 |
licensed_facility_listing_05 | 1 |
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 |
licensed_facility_listing_06 | 1 |
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 |
licensed_facility_listing_07 | 1 |
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 |
licensed_facility_listing_08 | 1 |
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 |
licensed_facility_listing_09 | 1 |
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.23416740 longitude: -119.33240370 |
licensed_facility_listing_10 | 1 |
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 |
licensed_facility_listing_11 | 1 |
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 |
licensed_facility_listing_12 | 1 |
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 |
licensed_facility_listing_13 | 1 |
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 |
licensed_facility_listing_14 | 1 |
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 |
licensed_facility_listing_15 | 1 |
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 |
licensed_facility_listing_16 | 1 |
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 |
licensed_facility_listing_17 | 1 |
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 |
licensed_facility_listing_18 | 1 |
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: 0.00000000 longitude: 0.00000000 |
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 |