Home

Dataset:

Name hospital-quarterly-financial-utilization-report-complete-data-set
Updated 2024-12-20
Current True
Tables
Name:2018_quarter_4_complete_data_set_4_11_2019
File:2018-quarter-4-complete-data-set-4-11-2019.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2017_quarter_4_complete_data_set_4_13_18
File:2017-quarter-4-complete-data-set-4-13-18.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2018_quarter_2_complete_data_set_10_10_18
File:2018-quarter-2-complete-data-set-10-10-18.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2018_quarter_3_complete_data_set_1_10_19
File:2018-quarter-3-complete-data-set-1-10-19.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2019_quarter_2_complete_data_set_10_10_19
File:2019-quarter-2-complete-data-set-10-10-19.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2019_quarter_3_complete_data_set_1_10_20
File:2019-quarter-3-complete-data-set-1-10-20.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2017_quarter_1_complete_data_set_7_14_17
File:2017-quarter-1-complete-data-set-7-14-17.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2017_quarter_2_complete_data_set_11_02_17
File:2017-quarter-2-complete-data-set-11-02-17.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2019_quarter_4_complete_data_set_4_10_20
File:2019-quarter-4-complete-data-set-4-10-20.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2018_quarter_1_complete_data_set_7_13_18
File:2018-quarter-1-complete-data-set-7-13-18.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2016_quarter_4_complete_data_set_4_14_17
File:2016-quarter-4-complete-data-set-4-14-17.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2017_quarter_3_complete_data_set_1_12_18
File:2017-quarter-3-complete-data-set-1-12-18.csv
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2023_quarter_4_complete_data_set_04_16_2024
File:2023-quarter-4-complete-data-set-04-16-2024.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2022_quarter_1_complete_data_set_07_14_2022
File:2022-quarter-1-complete-data-set-07-14-2022.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2022_quarter_2_complete_data_set_10_13_2022
File:2022-quarter-2-complete-data-set-10-13-2022.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2020_quarter_3_complete_data_set_01_15_2021
File:2020-quarter-3-complete-data-set-01-15-2021.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2021_quarter_4_complete_data_set_04_15_2022
File:2021-quarter-4-complete-data-set-04-15-2022.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2020_quarter_4_complete_data_set_04_15_2021
File:2020-quarter-4-complete-data-set-04-15-2021.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2023_quarter_2_complete_data_set_10_16_2023
File:2023-quarter-2-complete-data-set-10-16-2023.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2023_quarter_3_complete_data_set_01_16_2024
File:2023-quarter-3-complete-data-set-01-16-2024.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2024_quarter_2_complete_data_set_10_30_2024
File:2024-quarter-2-complete-data-set-10-30-2024.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2020_quarter_2_complete_data_set_10_19_2020
File:2020-quarter-2-complete-data-set-10-19-2020.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2021_quarter_2_complete_data_set_10_13_2021
File:2021-quarter-2-complete-data-set-10-13-2021.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2021_quarter_3_complete_data_set_01_13_2022
File:2021-quarter-3-complete-data-set-01-13-2022.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2023_quarter_1_complete_data_set_07_14_2023
File:2023-quarter-1-complete-data-set-07-14-2023.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2024_quarter_1_complete_data_set_07_30_2024
File:2024-quarter-1-complete-data-set-07-30-2024.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2020_quarter_1_complete_data_set_9_4_20
File:2020-quarter-1-complete-data-set-9-4-20.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2022_quarter_4_complete_data_set_04_14_2023
File:2022-quarter-4-complete-data-set-04-14-2023.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2021_quarter_1_complete_data_set_07_14_2021
File:2021-quarter-1-complete-data-set-07-14-2021.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:2022_quarter_3_complete_data_set_01_13_2023
File:2022-quarter-3-complete-data-set-01-13-2023.xlsx
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:None
File:documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:None
File:documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:None
File:documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:None
File:documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:None
File:documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Name:None
File:documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Count:None
Columns:[['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)'], ['dx_respiratory', 'varchar(4)'], ['dx_skin', 'varchar(4)'], ['dx_symptoms_signs_nec', 'varchar(4)'], ['zip_ca_resident', 'varchar(5)'], ['zip_foreign', 'varchar(4)'], ['zip_homeless', 'varchar(3)'], ['zip_out_of_state', 'varchar(4)'], ['zip_other_unknown', 'varchar(4)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_other_unknown', 'varchar(2)'], ['race_aman', 'varchar(3)'], ['race_asian', 'varchar(5)'], ['race_black', 'varchar(4)'], ['race_multirace', 'varchar(4)'], ['race_nhpi', 'varchar(3)'], ['race_white', 'varchar(5)'], ['race_other', 'varchar(5)'], ['race_unknown', 'varchar(4)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['other_payer', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['childrens_or_cancer', 'varchar(2)'], ['died', 'varchar(1)'], ['disaster_care_site', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['invalid_blank_disp', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['psychiatric_care', 'varchar(2)'], ['rehab', 'varchar(2)'], ['residential_care', 'varchar(3)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['datayear', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_integumentary', 'varchar(4)'], ['surgery_maternity', 'varchar(4)'], ['surgery_musculoskeletal', 'varchar(4)'], ['surgery_nervous', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['mandarin', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['radiology', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(4)'], ['surgery_respiratory', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_hydration', 'varchar(2)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['no_procedure_grp_assigned', 'varchar(1)'], ['eval_management', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_psych', 'varchar(4)'], ['medicine__immunization_admin', 'varchar(1)']]
Sources 2018-quarter-4-complete-data-set-4-11-2019.csv
2017-quarter-4-complete-data-set-4-13-18.csv
2018-quarter-2-complete-data-set-10-10-18.csv
2018-quarter-3-complete-data-set-1-10-19.csv
2019-quarter-2-complete-data-set-10-10-19.csv
2019-quarter-3-complete-data-set-1-10-20.csv
2017-quarter-1-complete-data-set-7-14-17.csv
2017-quarter-2-complete-data-set-11-02-17.csv
2019-quarter-4-complete-data-set-4-10-20.csv
2018-quarter-1-complete-data-set-7-13-18.csv
2016-quarter-4-complete-data-set-4-14-17.csv
2017-quarter-3-complete-data-set-1-12-18.csv
2023-quarter-4-complete-data-set-04-16-2024.xlsx
2022-quarter-1-complete-data-set-07-14-2022.xlsx
2022-quarter-2-complete-data-set-10-13-2022.xlsx
2020-quarter-3-complete-data-set-01-15-2021.xlsx
2021-quarter-4-complete-data-set-04-15-2022.xlsx
2020-quarter-4-complete-data-set-04-15-2021.xlsx
2023-quarter-2-complete-data-set-10-16-2023.xlsx
2023-quarter-3-complete-data-set-01-16-2024.xlsx
2024-quarter-2-complete-data-set-10-30-2024.xlsx
2020-quarter-2-complete-data-set-10-19-2020.xlsx
2021-quarter-2-complete-data-set-10-13-2021.xlsx
2021-quarter-3-complete-data-set-01-13-2022.xlsx
2023-quarter-1-complete-data-set-07-14-2023.xlsx
2024-quarter-1-complete-data-set-07-30-2024.xlsx
2020-quarter-1-complete-data-set-9-4-20.xlsx
2022-quarter-4-complete-data-set-04-14-2023.xlsx
2021-quarter-1-complete-data-set-07-14-2021.xlsx
2022-quarter-3-complete-data-set-01-13-2023.xlsx
2011-2015-summary-trends.xlsx
2019-quarter-1-complete-data-set-7-11-19.csv
2019-quarter-1-complete-data-set-7-11-19.xls
data-importing-instructions-for-excel.docx
datapackage.json
documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf
Updates
2025-01-16 23:53:13      0
2025-01-16 23:52:45      0
2025-01-16 19:16:14      0
2025-01-16 19:15:31      0
2024-12-20 10:17:33      0
2024-12-20 09:23:13      1
2024-12-14 15:47:11      1
2024-12-04 16:28:18      None
2024-09-18 13:06:51      None