Home

Dataset:

Name hospital-emergency-department-diagnosis-procedure-and-external-cause-codes
Updated 2024-10-01
CA Dataset link
Current True
Tables
2005_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2005_hospital_emergency_department_diagnosis_code_frequency    
2005_hospital_emergency_department_procedure_code_frequency    
2006_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2006_hospital_emergency_department_diagnosis_code_frequency    
2006_hospital_emergency_department_procedure_code_frequency    
2007_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2007_hospital_emergency_department_diagnosis_code_frequency    
2007_hospital_emergency_department_procedure_code_frequency    
2008_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2008_hospital_emergency_department_diagnosis_code_frequency    
2008_hospital_emergency_department_procedure_code_frequency    
2009_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2009_hospital_emergency_department_diagnosis_code_frequency    
2009_hospital_emergency_department_procedure_code_frequency    
2010_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2010_hospital_emergency_department_diagnosis_code_frequency    
2010_hospital_emergency_department_procedure_code_frequency    
2011_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2011_hospital_emergency_department_diagnosis_code_frequency    
2011_hospital_emergency_department_procedure_code_frequency    
2012_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2012_hospital_emergency_department_diagnosis_code_frequency     icd9cmcode - varchar(6)
totaldiag - varchar(7)
d0 - varchar(6)
d1 - varchar(6)
d2 - varchar(6)
d3 - varchar(6)
d4 - varchar(6)
d5 - varchar(5)
d6 - varchar(5)
d7 - varchar(5)
d8 - varchar(5)
d9 - varchar(5)
d10 - varchar(4)
d11 - varchar(4)
d12 - varchar(4)
d13 - varchar(4)
d14 - varchar(4)
d15 - varchar(4)
d16 - varchar(4)
d17 - varchar(4)
d18 - varchar(4)
d19 - varchar(4)
d20 - varchar(4)
d21 - varchar(4)
d22 - varchar(4)
d23 - varchar(3)
d24 - varchar(3)
2012_hospital_emergency_department_procedure_code_frequency    
2013_hospital_emergency_department_diagnosis_code_frequency     icd9cmcode - varchar(6)
totaldiag - varchar(7)
d0 - varchar(6)
d1 - varchar(6)
d2 - varchar(6)
d3 - varchar(6)
d4 - varchar(6)
d5 - varchar(5)
d6 - varchar(5)
d7 - varchar(5)
d8 - varchar(5)
d9 - varchar(5)
d10 - varchar(5)
d11 - varchar(4)
d12 - varchar(4)
d13 - varchar(4)
d14 - varchar(4)
d15 - varchar(4)
d16 - varchar(4)
d17 - varchar(4)
d18 - varchar(4)
d19 - varchar(4)
d20 - varchar(4)
d21 - varchar(4)
d22 - varchar(4)
d23 - varchar(4)
d24 - varchar(4)
2013_hospital_emergency_department_procedure_code_frequency    
2013_hospital_emergency_dept_ext_cause_of_injury_morb_code_freq     ecode - varchar(6)
totalecodes - varchar(6)
e0 - varchar(6)
e1 - varchar(6)
e2 - varchar(6)
e3 - varchar(6)
e4 - varchar(4)
2014_hospital_emergency_department_diagnosis_code_frequency     icd9cmcode - varchar(6)
totaldiag - varchar(7)
d0 - varchar(6)
d1 - varchar(6)
d2 - varchar(6)
d3 - varchar(6)
d4 - varchar(6)
d5 - varchar(5)
d6 - varchar(5)
d7 - varchar(5)
d8 - varchar(5)
d9 - varchar(5)
d10 - varchar(5)
d11 - varchar(5)
d12 - varchar(4)
d13 - varchar(4)
d14 - varchar(4)
d15 - varchar(4)
d16 - varchar(4)
d17 - varchar(4)
d18 - varchar(4)
d19 - varchar(4)
d20 - varchar(4)
d21 - varchar(4)
d22 - varchar(4)
d23 - varchar(4)
d24 - varchar(4)
2014_hospital_emergency_department_procedure_code_frequency    
2014_hospital_emergency_dept_ext_cause_of_injury_morb_code_freq     ecode - varchar(6)
totalecodes - varchar(6)
e0 - varchar(6)
e1 - varchar(6)
e2 - varchar(6)
e3 - varchar(6)
e4 - varchar(4)
2015_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2015_hospital_emergency_department_diagnosis_code_frequency    
2015_hospital_emergency_department_procedure_code_frequency    
2016_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2016_hospital_emergency_department_diagnosis_code_frequency    
2016_hospital_emergency_department_procedure_code_frequency    
2017_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2017_hospital_emergency_department_diagnosis_code_frequency    
2017_hospital_emergency_department_procedure_code_frequency    
2018_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2018_hospital_emergency_department_diagnosis_code_frequency    
2018_hospital_emergency_department_procedure_code_frequency    
2019_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2019_hospital_emergency_department_diagnosis_code_frequency    
2019_hospital_emergency_department_procedure_code_frequency    
2020_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2020_hospital_emergency_department_diagnosis_code_frequency    
2020_hospital_emergency_department_procedure_code_frequency    
2021_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2021_hospital_emergency_department_diagnosis_code_frequency    
2021_hospital_emergency_department_procedure_code_frequency    
2022_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq    
2022_hospital_emergency_department_diagnosis_code_frequency    
2022_hospital_emergency_department_procedure_code_frequency    
Sources
datapackage.json  -   
2005-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2005_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2005-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2005_hospital_emergency_department_diagnosis_code_frequency  
2005-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2005_hospital_emergency_department_procedure_code_frequency  
2006-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2006_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2006-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2006_hospital_emergency_department_diagnosis_code_frequency  
2006-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2006_hospital_emergency_department_procedure_code_frequency  
2007-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2007_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2007-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2007_hospital_emergency_department_diagnosis_code_frequency  
2007-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2007_hospital_emergency_department_procedure_code_frequency  
2008-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2008_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2008-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2008_hospital_emergency_department_diagnosis_code_frequency  
2008-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2008_hospital_emergency_department_procedure_code_frequency  
2009-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2009_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2009-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2009_hospital_emergency_department_diagnosis_code_frequency  
2009-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2009_hospital_emergency_department_procedure_code_frequency  
2010-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2010_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2010-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2010_hospital_emergency_department_diagnosis_code_frequency  
2010-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2010_hospital_emergency_department_procedure_code_frequency  
2011-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2011_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2011-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2011_hospital_emergency_department_diagnosis_code_frequency  
2011-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2011_hospital_emergency_department_procedure_code_frequency  
2012-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2012_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2012-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2012_hospital_emergency_department_diagnosis_code_frequency   Updated: 2025-06-10
2012-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2012_hospital_emergency_department_procedure_code_frequency  
2013-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2013_hospital_emergency_department_diagnosis_code_frequency   Updated: 2025-06-10
2013-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2013_hospital_emergency_department_procedure_code_frequency  
2013-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2013_hospital_emergency_dept_ext_cause_of_injury_morb_code_freq   Updated: 2025-06-10
2014-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2014_hospital_emergency_department_diagnosis_code_frequency   Updated: 2025-06-10
2014-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2014_hospital_emergency_department_procedure_code_frequency  
2014-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2014_hospital_emergency_dept_ext_cause_of_injury_morb_code_freq   Updated: 2025-06-10
2015-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2015_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2015-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2015_hospital_emergency_department_diagnosis_code_frequency  
2015-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2015_hospital_emergency_department_procedure_code_frequency  
2016-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2016_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2016-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2016_hospital_emergency_department_diagnosis_code_frequency  
2016-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2016_hospital_emergency_department_procedure_code_frequency  
2017-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2017_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2017-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2017_hospital_emergency_department_diagnosis_code_frequency  
2017-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2017_hospital_emergency_department_procedure_code_frequency  
2018-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2018_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2018-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2018_hospital_emergency_department_diagnosis_code_frequency  
2018-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2018_hospital_emergency_department_procedure_code_frequency  
2019-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2019_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2019-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2019_hospital_emergency_department_diagnosis_code_frequency  
2019-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2019_hospital_emergency_department_procedure_code_frequency  
2020-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2020_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2020-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2020_hospital_emergency_department_diagnosis_code_frequency  
2020-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2020_hospital_emergency_department_procedure_code_frequency  
2021-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2021_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2021-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2021_hospital_emergency_department_diagnosis_code_frequency  
2021-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2021_hospital_emergency_department_procedure_code_frequency  
2022-hospital-emergency-department-external-cause-of-injury-morbidity-code-frequency.xlsx  -  Table: 2022_hosp_emerg_dept_ext_cause_of_injury_morb_code_freq  
2022-hospital-emergency-department-diagnosis-code-frequency.xlsx  -  Table: 2022_hospital_emergency_department_diagnosis_code_frequency  
2022-hospital-emergency-department-procedure-code-frequency.xlsx  -  Table: 2022_hospital_emergency_department_procedure_code_frequency  
Updated