Table | # | Values |
---|---|---|
ambulatory_surgery_char_by_faclty_2016 | 1 |
oshpd_id: 306244032 facility_num: 244032 facility_name: ADVANCED ENDOSCOPY CENTER county_code: 24 license_type_desc: Clinic county_name: MERCED dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 control_type_desc: Investor - Corporation rural_hospital_desc: None teaching_hospital_desc: None licensed_bed_size: - senate_district_desc: District 12 assembly_district_desc: District 21 mssa_name: MERCED CENTRAL AND NORTH/MERCED SOUTHEAST mssa_designation: Urban teach_rural: NA sex_female: 701 sex_male: 524 sex_unknown_invalid: None hcount: 0 ccount: 1 license_type: Clinic age_10_19: 2 age_20_29: 24 age_30_39: 71 age_40_49: 139 age_50_59: 378 age_60_69: 377 age_70_79: 174 age_80_: 58 age_01_09: None age_under_1: 2 age_unknown: None asian_pacific_islander: 74 black: 53 hispanic: 382 other_race: 50 unknown_race: None white: 666 american_indian_alaska_native: None acute_care: None rehab: None routine: 1224 sn_ic_care: None against_medical_advice: None cah: None childrens_or_cancer: 1 home_health_service: None hospice_care: None invalid_blank_disp: None |
ambulatory_surgery_char_by_faclty_2017 | 1 |
oshpd_id: 306244032 facility_num: 244032 facility_name: ADVANCED ENDOSCOPY CENTER county_code: 24 license_type_desc: Clinic county_name: MERCED dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 control_type_desc: Investor - Corporation rural_hospital_desc: None teaching_hospital_desc: None licensed_bed_size: - senate_district_desc: District 12 assembly_district_desc: District 21 mssa_name: MERCED CENTRAL AND NORTH/MERCED SOUTHEAST mssa_designation: Urban teach_rural: NA sex_female: 1696 sex_male: 1283 sex_unknown_invalid: None hcount: 0 ccount: 1 license_type: Clinic age_10_19: 17 age_20_29: 119 age_30_39: 209 age_40_49: 303 age_50_59: 880 age_60_69: 829 age_70_79: 488 age_80_: 133 age_01_09: None age_under_1: 1 age_unknown: None asian_pacific_islander: 147 black: 101 hispanic: 936 other_race: 103 unknown_race: 1 white: 1691 american_indian_alaska_native: None acute_care: 1 against_medical_advice: None rehab: None routine: 2973 sn_ic_care: 4 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: 306244032 oshpd_id9: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_type_desc: Clinic dba_zip_code: 95348 control_type_desc: Investor - Corporation licensed_bed_size: - senate_district_desc: District 12 assembly_district_desc: District 21 mssa_name: Merced Central and North/Merced Southeast mssa_designation: Urban county_name: MERCED dba_address1: 386 W OLIVE AVE dba_city: MERCED teach_rural: NA age_0_09: None age_10_19: 26 age_20_29: 163 age_30_39: 251 age_40_49: 386 age_50_59: 898 age_60_69: 929 age_70_79: 537 age_80_: 148 age_other_unknown: 2 english: 2216 spanish: 977 chinese: 21 cantonese_yue_chinese: None vietnamese: None all_other_languages: 119 pls_other_unknown: 7 eth_hispanic: 1323 eth_nonhispanic: 1950 eth_other_unknown: 67 dx_certain_perinatal_conditions: None dx_circulatory: 60 dx_congenital: None dx_digestive: 1222 dx_diseases_of_the_blood: 86 dx_ear: None dx_endocrine: 1 dx_eye: None dx_factors_influencing_health: 921 dx_genitourinary: None dx_infectious: None dx_injury_poisoning: 1 dx_mentalhealth: None dx_musculoskeletal: None dx_neoplasms: 587 dx_nervous_system: None dx_other_unknown: 3 |
ambulatory_surgery_char_by_faclty_2022 | 1 |
oshpd_id: 306244032 oshpd_id9: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_type_desc: Clinic dba_zip_code: 95348 control_type_desc: Investor - Corporation licensed_bed_size: - senate_district_desc: District 12 assembly_district_desc: District 21 mssa_name: Merced Central and North/Merced Southeast mssa_designation: Urban county_name: MERCED dba_address1: 386 W OLIVE AVE dba_city: MERCED teach_rural: NA age_0_09: None age_10_19: 13 age_20_29: 113 age_30_39: 208 age_40_49: 476 age_50_59: 861 age_60_69: 905 age_70_79: 562 age_80_: 148 age_other_unknown: 1 english: 2049 spanish: 1098 cantonese_yue_chinese: None vietnamese: None all_other_languages: 139 pls_other_unknown: 1 eth_hispanic: 1385 eth_nonhispanic: 1895 eth_other_unknown: 7 dx_certain_perinatal_conditions: None dx_circulatory: 79 dx_congenital: None dx_digestive: 778 dx_diseases_of_the_blood: 113 dx_ear: None dx_endocrine: 1 dx_eye: None dx_factors_influencing_health: 1139 dx_genitourinary: None dx_infectious: None dx_injury_poisoning: None dx_mentalhealth: None dx_musculoskeletal: None dx_neoplasms: 559 dx_nervous_system: None dx_other_unknown: 4 dx_pregnancy_childbirth: None |
ambulatory_surgery_char_by_faclty_2023 | 1 |
oshpd_id: 306244032 oshpd_id9: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_type_desc: Clinic dba_zip_code: 95348 control_type_desc: Investor - Corporation licensed_bed_size: - senate_district_desc: District 14 assembly_district_desc: District 27 mssa_name: Merced Central and North/Merced Southeast mssa_designation: Urban county_name: MERCED dba_address1: 386 W OLIVE AVE dba_city: MERCED teach_rural: NA age_0_09: None age_10_19: 27 age_20_29: 116 age_30_39: 230 age_40_49: 519 age_50_59: 830 age_60_69: 962 age_70_79: 593 age_80_: 149 age_other_unknown: None english: 2439 spanish: 865 cantonese_yue_chinese: None vietnamese: None all_other_languages: 121 pls_other_unknown: 1 eth_hispanic: 1272 eth_nonhispanic: 2154 eth_other_unknown: None dx_certain_perinatal_conditions: None dx_circulatory: 61 dx_congenital: None dx_digestive: 861 dx_diseases_of_the_blood: 143 dx_ear: None dx_endocrine: None dx_eye: None dx_factors_influencing_health: 893 dx_genitourinary: None dx_infectious: 2 dx_injury_poisoning: None dx_mentalhealth: None dx_musculoskeletal: None dx_neoplasms: 755 dx_nervous_system: None dx_other_unknown: 11 dx_pregnancy_childbirth: None |
facility_profile_attributes | 1 |
facility_desc: ADVANCED ENDOSCOPY CENTER site_address1: 386 W OLIVE AVE site_address2: STE B site_city: MERCED site_zip: 95348 site_x_coordinate: -120.475556 site_y_coordinate: 37.318611 oshpd_id: 306244032 license_type_desc: Clinic license_category_desc: Surgical Clinic license_number: 040000497 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: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31861130 longitude: -120.47555570 |
licensed_facility_listing_02 | 2 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 12/08/1999 license_type_desc: Clinic license_category_desc: Surgical Clinic longitude: -120.47552 latitude: 37.31919 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 12/08/1999 license_type_desc: Clinic license_category_desc: Surgical Clinic longitude: -120.47552 latitude: 37.31919 |
licensed_facility_listing_03 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 40000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 12/8/1999 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919 longitude: -120.47552 |
licensed_facility_listing_04 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_05 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_06 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_07 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_08 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_09 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31861130 longitude: -120.47555570 |
licensed_facility_listing_10 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31861130 longitude: -120.47555570 |
licensed_facility_listing_11 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_12 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_13 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_14 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_15 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_16 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_17 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |
licensed_facility_listing_18 | 1 |
oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 0.00000000 longitude: 0.00000000 |
licensed_healthcare_facility_listing | 16 |
period: current oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31861130 longitude: -120.47555570 period: 2016-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2016-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2017-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 40000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2018-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2019-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2020-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2021-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2022-12-31 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2017-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2018-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2019-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W OLIVE AVE dba_city: MERCED dba_zip_code: 95348 county_code: 24 county_name: MERCED er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2020-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2021-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2022-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 period: 2023-06-30 oshpd_id: 306244032 facility_name: ADVANCED ENDOSCOPY CENTER license_num: 040000497 facility_level_desc: Parent Facility dba_address1: 386 W Olive Ave dba_city: Merced dba_zip_code: 95348 county_code: 24 county_name: Merced er_service_level_desc: Not Applicable total_number_beds: None facility_status_desc: Open facility_status_date: 1999-12-08 license_type_desc: Clinic license_category_desc: Surgical Clinic latitude: 37.31919000 longitude: -120.47552000 |