Home

Dataset:

Name ambulatory-surgery-characteristics-by-facility-pivot-profile
Updated 2024-10-01
CA Dataset link
Current True
Tables
ambulatory_surgery_char_by_faclty_2014     oshpd_id2 - varchar(9)
facility_name - varchar(59)
county_name - varchar(15)
control_type_desc - varchar(36)
dba_address1 - varchar(30)
dba_city - varchar(19)
dba_zip_code - varchar(10)
mssa_name - varchar(153)
mssa_designation - varchar(8)
oshpd_id - varchar(6)
license_type - varchar(8)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(1)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(4)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(4)
age_unknown - varchar(1)
asian_pacific_islander - varchar(4)
black - varchar(4)
hispanic - varchar(5)
american_indian_alaska_native - varchar(4)
other_race - varchar(4)
unknown_race - varchar(4)
white - varchar(5)
routine - varchar(5)
sn_ic_care - varchar(3)
acute_care - varchar(3)
against_medical_advice - varchar(3)
home_health_service - varchar(3)
hospice_care - varchar(2)
not_defined_elsewhere - varchar(3)
other_unknown - varchar(2)
prison_jail - varchar(3)
psychiatric_care - varchar(3)
residential_care_facility - varchar(4)
inpatient_rehab_care - varchar(2)
died - varchar(1)
critical_access_hospital - varchar(2)
childrens_or_cancer_center - varchar(3)
medi_cal - varchar(5)
medicare - varchar(5)
other_payer - varchar(4)
private_coverage - varchar(5)
self_pay - varchar(4)
ambulatory_surgery_char_by_faclty_2015     oshpd_id2 - varchar(9)
facility_name - varchar(59)
county_name - varchar(15)
control_type_category_desc - varchar(14)
dba_address1 - varchar(30)
dba_city - varchar(19)
dba_zip_code - varchar(10)
la_county_spa_desc - varchar(1)
mssa_name - varchar(153)
mssa_designation - varchar(8)
oshpd_id - varchar(6)
license_type - varchar(8)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(1)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(4)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(4)
age_unknown - varchar(1)
asian_pacific_islander - varchar(4)
black - varchar(4)
hispanic - varchar(5)
american_indian_alaska_native - varchar(4)
other_race - varchar(4)
unknown_race - varchar(4)
white - varchar(5)
routine - varchar(5)
acute_care - varchar(3)
rehab - varchar(2)
sn_ic_care - varchar(3)
residential_care - varchar(4)
prison_jail - varchar(3)
against_medical_advice - varchar(3)
died - varchar(2)
home_health_service - varchar(4)
disaster_care_site - varchar(1)
childrens_or_cancer - varchar(3)
hospice_care - varchar(3)
psychiatric_care - varchar(2)
cah - varchar(1)
not_defined_elsewhere - varchar(3)
other_disp - varchar(3)
invalid_blank_disp - varchar(2)
medi_cal - varchar(5)
medicare - varchar(5)
ambulatory_surgery_char_by_faclty_2016     oshpd_id - varchar(9)
facility_num - varchar(6)
facility_name - varchar(79)
county_code - varchar(2)
license_type_desc - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(30)
dba_city - varchar(19)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
rural_hospital_desc - varchar(11)
teaching_hospital_desc - varchar(8)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(100)
mssa_designation - varchar(8)
teach_rural - varchar(11)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(1)
hcount - varchar(1)
ccount - varchar(1)
license_type - varchar(8)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(4)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(3)
age_unknown - varchar(1)
asian_pacific_islander - varchar(4)
black - varchar(4)
hispanic - varchar(5)
other_race - varchar(4)
unknown_race - varchar(4)
white - varchar(5)
american_indian_alaska_native - varchar(3)
acute_care - varchar(3)
rehab - varchar(2)
routine - varchar(5)
sn_ic_care - varchar(3)
against_medical_advice - varchar(3)
cah - varchar(1)
childrens_or_cancer - varchar(2)
home_health_service - varchar(3)
hospice_care - varchar(2)
invalid_blank_disp - varchar(2)
ambulatory_surgery_char_by_faclty_2017     oshpd_id - varchar(9)
facility_num - varchar(6)
facility_name - varchar(79)
county_code - varchar(2)
license_type_desc - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(30)
dba_city - varchar(19)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
rural_hospital_desc - varchar(11)
teaching_hospital_desc - varchar(8)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(100)
mssa_designation - varchar(8)
teach_rural - varchar(11)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(1)
hcount - varchar(1)
ccount - varchar(1)
license_type - varchar(8)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(4)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(3)
age_unknown - varchar(1)
asian_pacific_islander - varchar(4)
black - varchar(4)
hispanic - varchar(5)
other_race - varchar(5)
unknown_race - varchar(4)
white - varchar(5)
american_indian_alaska_native - varchar(3)
acute_care - varchar(3)
against_medical_advice - varchar(3)
rehab - varchar(2)
routine - varchar(5)
sn_ic_care - varchar(3)
cah - varchar(1)
home_health_service - varchar(3)
hospice_care - varchar(2)
not_defined_elsewhere - varchar(3)
psychiatric_care - varchar(2)
ambulatory_surgery_char_by_faclty_2018     oshpd_id2 - varchar(9)
facility_num - varchar(6)
facility_name - varchar(79)
county_code - varchar(2)
license_type_desc - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(30)
dba_city - varchar(19)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(100)
mssa_designation - varchar(8)
teach_rural - varchar(11)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(1)
hcount - varchar(1)
ccount - varchar(1)
license_type - varchar(8)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(4)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(3)
age_unknown - varchar(1)
asian_pacific_islander - varchar(4)
black - varchar(4)
other_race - varchar(5)
unknown_race - varchar(4)
white - varchar(5)
american_indian_alaska_native - varchar(3)
invalid_blank_race - varchar(2)
eth_hispanicl - varchar(5)
eth_nonhispanicl - varchar(5)
eth_unknown - varchar(4)
eth_invalid_blank - varchar(2)
against_medical_advice - varchar(3)
routine - varchar(5)
sn_ic_care - varchar(3)
acute_care - varchar(4)
cah - varchar(2)
home_health_service - varchar(4)
hospice_care - varchar(2)
not_defined_elsewhere - varchar(3)
ambulatory_surgery_char_by_faclty_2019     oshpd_id2 - varchar(9)
facility_num - varchar(6)
facility_name - varchar(79)
license_type_desc - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(27)
dba_city - varchar(19)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(153)
mssa_designation - varchar(8)
teach_rural - varchar(11)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(2)
hcount - varchar(1)
ccount - varchar(1)
license_type - varchar(8)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(5)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(3)
age_unknown - varchar(1)
racegrp_aman - varchar(4)
racegrp_asian - varchar(4)
racegrp_black - varchar(4)
racegrp_multirace - varchar(4)
racegrp_nhpi - varchar(3)
racegrp_other - varchar(5)
racegrp_unknown - varchar(4)
racegrp_white - varchar(5)
racegrp_inv_blank - varchar(2)
eth_hispanic - varchar(5)
eth_nonhispanic - varchar(5)
eth_unknown - varchar(4)
eth_blank_invalid - varchar(2)
other_disp - varchar(2)
psychiatric_care - varchar(2)
routine - varchar(5)
sn_ic_care - varchar(3)
acute_care - varchar(4)
against_medical_advice - varchar(3)
cah - varchar(2)
ambulatory_surgery_char_by_faclty_2020     oshpd_id2 - varchar(9)
facility_num - varchar(6)
facility_name - varchar(79)
license_type_desc - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(27)
dba_city - varchar(19)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(153)
mssa_designation - varchar(8)
teach_rural - varchar(11)
sex_female - varchar(5)
sex_male - varchar(5)
sex_unknown_invalid - varchar(2)
hcount - varchar(1)
ccount - varchar(1)
license_type - varchar(8)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(4)
age_60_69 - varchar(5)
age_70_79 - varchar(4)
age_80_ - varchar(4)
age_01_09 - varchar(4)
age_under_1 - varchar(3)
age_unknown - varchar(1)
racegrp_aman - varchar(3)
racegrp_asian - varchar(4)
racegrp_black - varchar(4)
racegrp_multirace - varchar(4)
racegrp_nhpi - varchar(3)
racegrp_other - varchar(4)
racegrp_unknown - varchar(4)
racegrp_white - varchar(5)
racegrp_inv_blank - varchar(2)
eth_hispanic - varchar(5)
eth_nonhispanic - varchar(5)
eth_unknown - varchar(4)
eth_blank_invalid - varchar(2)
acute_care - varchar(4)
not_defined_elsewhere - varchar(3)
routine - varchar(5)
sn_ic_care - varchar(3)
cah - varchar(2)
home_health_service - varchar(4)
psychiatric_care - varchar(2)
ambulatory_surgery_char_by_faclty_2021     oshpd_id - varchar(9)
oshpd_id9 - varchar(9)
facility_name - varchar(79)
license_type_desc - varchar(8)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(153)
mssa_designation - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(27)
dba_city - varchar(19)
teach_rural - varchar(11)
age_0_09 - varchar(4)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(5)
age_60_69 - varchar(5)
age_70_79 - varchar(5)
age_80_ - varchar(4)
age_other_unknown - varchar(2)
english - varchar(5)
spanish - varchar(4)
chinese - varchar(4)
cantonese_yue_chinese - varchar(4)
vietnamese - varchar(4)
all_other_languages - varchar(4)
pls_other_unknown - varchar(3)
eth_hispanic - varchar(5)
eth_nonhispanic - varchar(5)
eth_other_unknown - varchar(4)
dx_certain_perinatal_conditions - varchar(3)
dx_circulatory - varchar(4)
dx_congenital - varchar(4)
dx_digestive - varchar(4)
dx_diseases_of_the_blood - varchar(3)
dx_ear - varchar(3)
dx_endocrine - varchar(4)
dx_eye - varchar(4)
dx_factors_influencing_health - varchar(5)
dx_genitourinary - varchar(4)
dx_infectious - varchar(4)
dx_injury_poisoning - varchar(4)
dx_mentalhealth - varchar(3)
dx_musculoskeletal - varchar(4)
dx_neoplasms - varchar(4)
dx_nervous_system - varchar(4)
dx_other_unknown - varchar(2)
ambulatory_surgery_char_by_faclty_2022     oshpd_id - varchar(9)
oshpd_id9 - varchar(9)
facility_name - varchar(79)
license_type_desc - varchar(8)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(153)
mssa_designation - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(27)
dba_city - varchar(19)
teach_rural - varchar(11)
age_0_09 - varchar(4)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(5)
age_60_69 - varchar(5)
age_70_79 - varchar(5)
age_80_ - varchar(4)
age_other_unknown - varchar(2)
english - varchar(5)
spanish - varchar(4)
cantonese_yue_chinese - varchar(4)
vietnamese - varchar(4)
all_other_languages - varchar(4)
pls_other_unknown - varchar(3)
eth_hispanic - varchar(5)
eth_nonhispanic - varchar(5)
eth_other_unknown - varchar(4)
dx_certain_perinatal_conditions - varchar(3)
dx_circulatory - varchar(4)
dx_congenital - varchar(4)
dx_digestive - varchar(4)
dx_diseases_of_the_blood - varchar(3)
dx_ear - varchar(4)
dx_endocrine - varchar(4)
dx_eye - varchar(4)
dx_factors_influencing_health - varchar(5)
dx_genitourinary - varchar(4)
dx_infectious - varchar(3)
dx_injury_poisoning - varchar(4)
dx_mentalhealth - varchar(4)
dx_musculoskeletal - varchar(5)
dx_neoplasms - varchar(4)
dx_nervous_system - varchar(4)
dx_other_unknown - varchar(3)
dx_pregnancy_childbirth - varchar(4)
ambulatory_surgery_char_by_faclty_2023     oshpd_id - varchar(9)
oshpd_id9 - varchar(9)
facility_name - varchar(79)
license_type_desc - varchar(8)
dba_zip_code - varchar(5)
control_type_desc - varchar(45)
licensed_bed_size - varchar(7)
senate_district_desc - varchar(11)
assembly_district_desc - varchar(11)
mssa_name - varchar(153)
mssa_designation - varchar(8)
county_name - varchar(15)
dba_address1 - varchar(30)
dba_city - varchar(19)
teach_rural - varchar(11)
age_0_09 - varchar(5)
age_10_19 - varchar(4)
age_20_29 - varchar(4)
age_30_39 - varchar(4)
age_40_49 - varchar(4)
age_50_59 - varchar(5)
age_60_69 - varchar(5)
age_70_79 - varchar(5)
age_80_ - varchar(4)
age_other_unknown - varchar(2)
english - varchar(5)
spanish - varchar(4)
cantonese_yue_chinese - varchar(4)
vietnamese - varchar(3)
all_other_languages - varchar(4)
pls_other_unknown - varchar(3)
eth_hispanic - varchar(5)
eth_nonhispanic - varchar(5)
eth_other_unknown - varchar(4)
dx_certain_perinatal_conditions - varchar(3)
dx_circulatory - varchar(4)
dx_congenital - varchar(4)
dx_digestive - varchar(4)
dx_diseases_of_the_blood - varchar(3)
dx_ear - varchar(4)
dx_endocrine - varchar(4)
dx_eye - varchar(4)
dx_factors_influencing_health - varchar(5)
dx_genitourinary - varchar(4)
dx_infectious - varchar(3)
dx_injury_poisoning - varchar(4)
dx_mentalhealth - varchar(4)
dx_musculoskeletal - varchar(5)
dx_neoplasms - varchar(4)
dx_nervous_system - varchar(4)
dx_other_unknown - varchar(2)
dx_pregnancy_childbirth - varchar(4)
Sources
datapackage.json  -   
2014-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2014 Sheet: ambulatory_surgery_char_by_faclty_2014 Updated: 2025-06-10
2015-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2015 Sheet: ambulatory_surgery_char_by_faclty_2015 Updated: 2025-06-10
2016-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2016 Sheet: ambulatory_surgery_char_by_faclty_2016 Updated: 2025-06-10
2017-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2017 Sheet: ambulatory_surgery_char_by_faclty_2017 Updated: 2025-06-10
2018-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2018 Sheet: ambulatory_surgery_char_by_faclty_2018 Updated: 2025-06-10
2019-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2019 Sheet: ambulatory_surgery_char_by_faclty_2019 Updated: 2025-06-10
2020-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2020 Sheet: ambulatory_surgery_char_by_faclty_2020 Updated: 2025-06-10
2021-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2021 Sheet: ambulatory_surgery_char_by_faclty_2021 Updated: 2025-06-10
2022-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2022 Sheet: ambulatory_surgery_char_by_faclty_2022 Updated: 2025-06-10
2023-ambulatory-surgery-characteristics-by-facility-pivot-profile.xlsx  -  Table: ambulatory_surgery_char_by_faclty_2023 Sheet: ambulatory_surgery_char_by_faclty_2023 Updated: 2025-06-10
Updated