Home

Dataset:

Name hospital-emergency-department-encounters-by-facility
Updated 2024-10-01
Current True
Tables
Name:hospital_ed_encounters_by_facility
File:hospital-emergency-department-encounters-by-facility.csv
Count:None
Columns:[['oshpd_id2', 'varchar(9)'], ['facility_name', 'varchar(59)'], ['county_name', 'varchar(15)'], ['control_type_category_desc', 'varchar(14)'], ['dba_address1', 'varchar(30)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(10)'], ['la_county_spa_desc', 'varchar(1)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['oshpd_id', 'varchar(6)'], ['license_type', 'varchar(8)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(1)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(4)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(4)'], ['age_unknown', 'varchar(1)'], ['asian_pacific_islander', 'varchar(4)'], ['black', 'varchar(4)'], ['hispanic', 'varchar(5)'], ['american_indian_alaska_native', 'varchar(4)'], ['other_race', 'varchar(4)'], ['unknown_race', 'varchar(4)'], ['white', 'varchar(5)'], ['routine', 'varchar(5)'], ['acute_care', 'varchar(3)'], ['rehab', 'varchar(2)'], ['sn_ic_care', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['prison_jail', 'varchar(3)'], ['against_medical_advice', 'varchar(3)'], ['died', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['disaster_care_site', 'varchar(1)'], ['childrens_or_cancer', 'varchar(3)'], ['hospice_care', 'varchar(3)'], ['psychiatric_care', 'varchar(2)'], ['cah', 'varchar(1)'], ['not_defined_elsewhere', 'varchar(3)'], ['other_disp', 'varchar(3)'], ['invalid_blank_disp', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['self_pay', 'varchar(4)'], ['workers_comp', 'varchar(4)'], ['unknown_payer', 'varchar(3)'], ['all_other', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['blank_invalid', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(4)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_pulmonary', 'varchar(3)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_other', 'varchar(3)'], ['medicine_hydration', 'varchar(3)'], ['medicine_sedation_conscious', 'varchar(3)'], ['medicine_psych', 'varchar(3)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['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)'], ['chinese', 'varchar(4)'], ['vietnamese', 'varchar(4)'], ['tagalog', 'varchar(3)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['datayear', 'varchar(4)'], ['control_type_desc', 'varchar(36)'], ['licensed_bed_total', 'varchar(3)'], ['congress_dist', 'varchar(2)'], ['assembly_dist', 'varchar(2)'], ['senate_dist', 'varchar(2)'], ['ems_station', 'varchar(3)']]

Name:None
File:datapackage.json
Count:None
Columns:[['oshpd_id2', 'varchar(9)'], ['facility_name', 'varchar(59)'], ['county_name', 'varchar(15)'], ['control_type_category_desc', 'varchar(14)'], ['dba_address1', 'varchar(30)'], ['dba_city', 'varchar(19)'], ['dba_zip_code', 'varchar(10)'], ['la_county_spa_desc', 'varchar(1)'], ['mssa_name', 'varchar(153)'], ['mssa_designation', 'varchar(8)'], ['oshpd_id', 'varchar(6)'], ['license_type', 'varchar(8)'], ['sex_female', 'varchar(5)'], ['sex_male', 'varchar(5)'], ['sex_unknown_invalid', 'varchar(1)'], ['age_10_19', 'varchar(4)'], ['age_20_29', 'varchar(4)'], ['age_30_39', 'varchar(4)'], ['age_40_49', 'varchar(4)'], ['age_50_59', 'varchar(4)'], ['age_60_69', 'varchar(4)'], ['age_70_79', 'varchar(4)'], ['age_80_', 'varchar(4)'], ['age_01_09', 'varchar(4)'], ['age_under_1', 'varchar(4)'], ['age_unknown', 'varchar(1)'], ['asian_pacific_islander', 'varchar(4)'], ['black', 'varchar(4)'], ['hispanic', 'varchar(5)'], ['american_indian_alaska_native', 'varchar(4)'], ['other_race', 'varchar(4)'], ['unknown_race', 'varchar(4)'], ['white', 'varchar(5)'], ['routine', 'varchar(5)'], ['acute_care', 'varchar(3)'], ['rehab', 'varchar(2)'], ['sn_ic_care', 'varchar(3)'], ['residential_care', 'varchar(4)'], ['prison_jail', 'varchar(3)'], ['against_medical_advice', 'varchar(3)'], ['died', 'varchar(2)'], ['home_health_service', 'varchar(4)'], ['disaster_care_site', 'varchar(1)'], ['childrens_or_cancer', 'varchar(3)'], ['hospice_care', 'varchar(3)'], ['psychiatric_care', 'varchar(2)'], ['cah', 'varchar(1)'], ['not_defined_elsewhere', 'varchar(3)'], ['other_disp', 'varchar(3)'], ['invalid_blank_disp', 'varchar(2)'], ['medi_cal', 'varchar(5)'], ['medicare', 'varchar(5)'], ['other_payer', 'varchar(4)'], ['private_coverage', 'varchar(5)'], ['self_pay', 'varchar(4)'], ['workers_comp', 'varchar(4)'], ['unknown_payer', 'varchar(3)'], ['all_other', 'varchar(4)'], ['english', 'varchar(5)'], ['spanish', 'varchar(4)'], ['path_lab', 'varchar(4)'], ['radiology', 'varchar(4)'], ['blank_invalid', 'varchar(3)'], ['other_proc', 'varchar(3)'], ['eval_management', 'varchar(3)'], ['anesthesia', 'varchar(4)'], ['medicine_cardiovascular', 'varchar(4)'], ['medicine_injection_infusion', 'varchar(4)'], ['medicine_chemo_admin', 'varchar(4)'], ['medicine_physical_rehab', 'varchar(3)'], ['medicine_pulmonary', 'varchar(3)'], ['medicine_neurology_neuromuscular', 'varchar(2)'], ['medicine_ophthalmology', 'varchar(3)'], ['medicine_otorhinolaryngologic', 'varchar(3)'], ['medicine_gastroenterology', 'varchar(4)'], ['medicine_dialysis', 'varchar(2)'], ['medicine_other', 'varchar(3)'], ['medicine_hydration', 'varchar(3)'], ['medicine_sedation_conscious', 'varchar(3)'], ['medicine_psych', 'varchar(3)'], ['surgery_cardivascular', 'varchar(4)'], ['surgery_digestive', 'varchar(5)'], ['surgery_eye_ocular', 'varchar(4)'], ['surgery_genital_reproductive', 'varchar(4)'], ['surgery_hemic_lymphatic', 'varchar(3)'], ['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)'], ['chinese', 'varchar(4)'], ['vietnamese', 'varchar(4)'], ['tagalog', 'varchar(3)'], ['hcount', 'varchar(1)'], ['ccount', 'varchar(1)'], ['datayear', 'varchar(4)'], ['control_type_desc', 'varchar(36)'], ['licensed_bed_total', 'varchar(3)'], ['congress_dist', 'varchar(2)'], ['assembly_dist', 'varchar(2)'], ['senate_dist', 'varchar(2)'], ['ems_station', 'varchar(3)']]

Sources hospital-emergency-department-encounters-by-facility.csv
datapackage.json
Updates
2024-12-31 14:17:35      0
2024-12-31 14:16:21      0
2024-12-27 18:38:01      0
2024-12-12 11:07:06      None
2024-12-07 16:25:55      None
2024-12-07 16:22:16      None
2024-12-04 16:27:44      None
2024-09-18 13:03:09      None