| Tables |
| Name: | hospital_inpatient_characteristics_expected_payer_by_pa_44918e82 |
|---|
| File: | hospital-inpatient-characteristics-expected-payer-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_mdc_by_patient_count_481a6c1d |
|---|
| File: | hospital-inpatient-characteristics-mdc-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_race_group_by_patien_8fafca4c |
|---|
| File: | hospital-inpatient-characteristics-race-group-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_ms_drg_by_patient_co_fb872b63 |
|---|
| File: | hospital-inpatient-characteristics-ms-drg-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_type_of_care_by_pati_18db01dc |
|---|
| File: | hospital-inpatient-characteristics-type-of-care-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_admission_source_by__f82e8de9 |
|---|
| File: | hospital-inpatient-characteristics-admission-source-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_sex_by_patient_count_4f631a3c |
|---|
| File: | hospital-inpatient-characteristics-sex-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | hospital_inpatient_characteristics_disposition_by_patie_8cc398e6 |
|---|
| File: | hospital-inpatient-characteristics-disposition-by-patient-county-of-residence.csv |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | None |
|---|
| File: | hospital-inpatient-notes.docx |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
| Name: | None |
|---|
| File: | hospital-inpatient-notes.docx |
|---|
| Count: | None |
|---|
| Columns: | [['oshpd_id2', 'varchar(9)'], ['facility_num', 'varchar(6)'], ['facility_name', 'varchar(79)'], ['license_type_desc', 'varchar(8)'], ['county_name', 'varchar(15)'], ['dba_address1', 'varchar(27)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(5)'], ['control_type_desc', 'varchar(45)'], ['licensed_bed_size', 'varchar(7)'], ['senate_district_desc', 'varchar(11)'], ['assembly_district_desc', 'varchar(11)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['teach_rural', 'varchar(11)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(2)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['license_type', 'varchar(8)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(5)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(3)'], ['age_unknown', 'varchar(1)'], ['racegrp_aman', 'varchar(4)'], ['racegrp_asian', 'varchar(4)'], ['racegrp_black', 'varchar(4)'], ['racegrp_multirace', 'varchar(4)'], ['racegrp_nhpi', 'varchar(3)'], ['racegrp_other', 'varchar(5)'], ['racegrp_unknown', 'varchar(4)'], ['racegrp_white', 'varchar(5)'], ['racegrp_inv_blank', 'varchar(2)'], ['eth_hispanic', 'varchar(5)'], ['eth_nonhispanic', 'varchar(5)'], ['eth_unknown', 'varchar(4)'], ['eth_blank_invalid', 'varchar(2)'], ['other_disp', 'varchar(2)'], ['psychiatric_care', 'varchar(2)'], ['routine', 'varchar(5)'], ['sn_ic_care', 'varchar(3)'], ['acute_care', 'varchar(4)'], ['against_medical_advice', 'varchar(3)'], ['cah', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['hospice_care', 'varchar(2)'], ['not_defined_elsewhere', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['invalid_blank_disp', 'varchar(2)'], ['prison_jail', 'varchar(4)'], ['rehab', 'varchar(2)'], ['died', 'varchar(1)'], ['childrens_or_cancer', 'varchar(2)'], ['disaster_care_site', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['selfpay', 'varchar(4)'], ['unknown_inv_payer', 'varchar(2)'], ['a_dx_circulatory', 'varchar(4)'], ['a_dx_congenital', 'varchar(4)'], ['a_dx_digestive', 'varchar(4)'], ['a_dx_endocrine', 'varchar(4)'], ['a_dx_genitourinary', 'varchar(4)'], ['a_dx_infections', 'varchar(3)'], ['a_dx_injury_poisoning', 'varchar(4)'], ['a_dx_muscoloskeletal', 'varchar(4)'], ['a_dx_neoplasms', 'varchar(4)'], ['a_dx_nervous_sense', 'varchar(4)'], ['a_dx_pregnancy', 'varchar(4)'], ['a_dx_residual', 'varchar(3)'], ['a_dx_respiratory', 'varchar(4)'], ['a_dx_skin', 'varchar(4)'], ['a_dx_symptoms', 'varchar(4)'], ['a_dx_blood_forming', 'varchar(3)'], ['a_dx_mental_illness', 'varchar(4)'], ['a_dx_no_grouper_assigned', 'varchar(3)'], ['a_dx_perinatal', 'varchar(3)'], ['all_other_languages', 'varchar(4)'], ['cantonese_yue_chinese', 'varchar(4)'], ['chinese', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['unknown_lang', 'varchar(3)'], ['vietnamese', 'varchar(4)'], ['blank_inv_lang', 'varchar(3)'], ['a_zip_blank_invalid', 'varchar(2)'], ['a_zip_ca_resident', 'varchar(5)'], ['a_zip_out_of_state', 'varchar(4)'], ['a_zip_foreign', 'varchar(3)'], ['a_zip_homeless', 'varchar(3)'], ['a_zip_unknown', 'varchar(3)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['no_procedure_grp_assigned', 'varchar(2)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_chemo_admin', 'varchar(3)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine__moderate_conscious', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(3)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_hydration', 'varchar(3)'], ['medicine_other', 'varchar(3)'], ['medicine_psych', 'varchar(4)'], ['medicine_pulmonary', 'varchar(3)'], ['surgery_cardivascular', '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_respiratory', 'varchar(4)'], ['surgery_urinary', 'varchar(4)'], ['surgery_auditory', 'varchar(4)'], ['surgery_endocrine', 'varchar(3)'], ['surgery_general_other', 'varchar(3)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['datayear', 'varchar(4)']] |
|---|
|
|---|