empty tables in some datasets when the spreadsheets are not empty #32
Description
This is in hospital-inpatient-diagnosis-procedure-and-external-cause-codes but it may be elsewhere as well.
Why is there a table down here getting 0 rows? I am looking at the spreadsheets and there is data. And there is no error. Yet there is no data going to the table? Why?
file: 2005-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2005_hospital_inpatient_diagnosis_code_frequency...
file: 2005-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2005_hospital_inpatient_procedure_code_frequency...
file: 2006-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2006_hospital_inpatient_diagnosis_code_frequency...
file: 2006-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2006_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2006-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2006_hospital_inpatient_procedure_code_frequency...
file: 2007-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2007_hospital_inpatient_diagnosis_code_frequency...
file: 2007-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2007_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2007-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2007_hospital_inpatient_procedure_code_frequency...
file: 2008-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2008_hospital_inpatient_diagnosis_code_frequency...
file: 2008-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2008_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2008-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2008_hospital_inpatient_procedure_code_frequency...
file: 2009-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2009_hospital_inpatient_diagnosis_code_frequency...
file: 2009-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2009_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2009-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2009_hospital_inpatient_procedure_code_frequency...
file: 2010-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2010_hospital_inpatient_diagnosis_code_frequency...
file: 2010-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2010_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2010-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2010_hospital_inpatient_procedure_code_frequency...
file: 2011-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2011_hospital_inpatient_diagnosis_code_frequency...
file: 2011-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2011_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2011-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM
creating table 2011_hospital_inpatient_procedure_code_frequency...
file: 2012-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: 2012 DX
creating table 2012_hospital_inpatient_diagnosis_code_frequency...
file: 2012-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: 2012 E-Codes
creating table 2012_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2012-hospital-inpatient-procedure-code-frequency.xlsx, sheet: 2012 Procedures
creating table 2012_hospital_inpatient_procedure_code_frequency...
file: 2013-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: 2013 R-Codes
creating table 2013_hosp_inpatient_ext_cause_of_injury_morb_code_freq...
file: 2013-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: 2013 Diagnosis Codes
creating table 2013_hospital_inpatient_diagnosis_code_frequency...
file: 2013-hospital-inpatient-procedure-code-frequency.xlsx, sheet: 2013 Procedure Codes
creating table 2013_hospital_inpatient_procedure_code_frequency...
file: 2014-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: 2014 Diagnosis Codes
creating table 2014_hospital_inpatient_diagnosis_code_frequency...
file: 2014-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: 2014 E-Codes
creating table 2014_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2014-hospital-inpatient-procedure-code-frequency.xlsx, sheet: 2014 Procedure Codes
creating table 2014_hospital_inpatient_procedure_code_frequency...
file: 2015-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: Q4_ICD-10-CM
creating table 2015_hosp_inpat_external_cause_of_injury_morb_code_freq_icd_10...
file: 2015-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: Q1-A3_ICD-9-CM
creating table 2015_hosp_inpat_external_cause_of_injury_morb_code_freq_icd_9...
file: 2015-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: Q4_ICD-10-CM
creating table 2015_hospital_inpatient_diagnosis_code_frequency_icd_10...
file: 2015-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: Q1-Q3_ICD-9-CM
creating table 2015_hospital_inpatient_diagnosis_code_frequency_icd_9...
file: 2015-hospital-inpatient-procedure-code-frequency.xlsx, sheet: Q4_ICD-10-PCS
creating table 2015_hospital_inpatient_procedure_code_frequency_icd_10...
file: 2015-hospital-inpatient-procedure-code-frequency.xlsx, sheet: Q1-Q3_ICD-9-CM
creating table 2015_hospital_inpatient_procedure_code_frequency_icd_9...
file: 2016-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2016_hospital_inpatient_diagnosis_code_frequency...
file: 2016-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2016_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2016-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS
creating table 2016_hospital_inpatient_procedure_code_frequency...
file: 2017-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2017_hospital_inpatient_diagnosis_code_frequency...
file: 2017-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2017_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2017-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS
creating table 2017_hospital_inpatient_procedure_code_frequency...
file: 2018-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2018_hospital_inpatient_diagnosis_code_frequency...
file: 2018-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2018_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2018-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS
creating table 2018_hospital_inpatient_procedure_code_frequency...
file: 2019-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2019_hospital_inpatient_diagnosis_code_frequency...
file: 2019-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2019_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2019-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS
creating table 2019_hospital_inpatient_procedure_code_frequency...
file: 2020-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2020_hospital_inpatient_diagnosis_code_frequency...
file: 2020-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2020_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2020-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2020_hospital_inpatient_procedure_code_frequency...
file: 2021-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2021_hospital_inpatient_diagnosis_code_frequency...
file: 2021-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2021_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2021-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS
creating table 2021_hospital_inpatient_procedure_code_frequency...
file: 2022-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2022_hospital_inpatient_diagnosis_code_frequency...
file: 2022-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM
creating table 2022_hospital_inpatient_external_cause_of_injury_morb_code_freq...
file: 2022-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS
creating table 2022_hospital_inpatient_procedure_code_frequency...
file: 2005-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2005_hospital_inpatient_diagnosis_code_frequency # 10643
file: 2005-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2005_hospital_inpatient_procedure_code_frequency # 3423
file: 2006-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2006_hospital_inpatient_diagnosis_code_frequency # 10840
file: 2006-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2006_hospital_inpatient_external_cause_of_injury_morb_code_freq # 918
file: 2006-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2006_hospital_inpatient_procedure_code_frequency # 3404
file: 2007-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2007_hospital_inpatient_diagnosis_code_frequency # 10869
file: 2007-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2007_hospital_inpatient_external_cause_of_injury_morb_code_freq # 932
file: 2007-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2007_hospital_inpatient_procedure_code_frequency # 3428
file: 2008-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2008_hospital_inpatient_diagnosis_code_frequency # 11230
file: 2008-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2008_hospital_inpatient_external_cause_of_injury_morb_code_freq # 933
file: 2008-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2008_hospital_inpatient_procedure_code_frequency # 3484
file: 2009-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2009_hospital_inpatient_diagnosis_code_frequency # 11306
file: 2009-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2009_hospital_inpatient_external_cause_of_injury_morb_code_freq # 1031
file: 2009-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2009_hospital_inpatient_procedure_code_frequency # 3487
file: 2010-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2010_hospital_inpatient_diagnosis_code_frequency # 11465
file: 2010-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2010_hospital_inpatient_external_cause_of_injury_morb_code_freq # 1034
file: 2010-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2010_hospital_inpatient_procedure_code_frequency # 3491
file: 2011-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2011_hospital_inpatient_diagnosis_code_frequency # 11628
file: 2011-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2011_hospital_inpatient_external_cause_of_injury_morb_code_freq # 1032
file: 2011-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-9-CM -> table: 2011_hospital_inpatient_procedure_code_frequency # 3512
file: 2012-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: 2012 DX -> table: 2012_hospital_inpatient_diagnosis_code_frequency # 11639
file: 2012-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: 2012 E-Codes -> table: 2012_hospital_inpatient_external_cause_of_injury_morb_code_freq # 1048
file: 2012-hospital-inpatient-procedure-code-frequency.xlsx, sheet: 2012 Procedures -> table: 2012_hospital_inpatient_procedure_code_frequency # 3501
file: 2013-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: 2013 R-Codes -> table: 2013_hosp_inpatient_ext_cause_of_injury_morb_code_freq # 1029
file: 2013-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: 2013 Diagnosis Codes -> table: 2013_hospital_inpatient_diagnosis_code_frequency # 11631
file: 2013-hospital-inpatient-procedure-code-frequency.xlsx, sheet: 2013 Procedure Codes -> table: 2013_hospital_inpatient_procedure_code_frequency # 3511
file: 2014-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: 2014 Diagnosis Codes -> table: 2014_hospital_inpatient_diagnosis_code_frequency # 11651
file: 2014-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: 2014 E-Codes -> table: 2014_hospital_inpatient_external_cause_of_injury_morb_code_freq # 1024
file: 2014-hospital-inpatient-procedure-code-frequency.xlsx, sheet: 2014 Procedure Codes -> table: 2014_hospital_inpatient_procedure_code_frequency # 3487
file: 2015-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: Q4_ICD-10-CM -> table: 2015_hosp_inpat_external_cause_of_injury_morb_code_freq_icd_10 # 1678
file: 2015-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: Q1-A3_ICD-9-CM -> table: 2015_hosp_inpat_external_cause_of_injury_morb_code_freq_icd_9 # 0
file: 2015-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: Q4_ICD-10-CM -> table: 2015_hospital_inpatient_diagnosis_code_frequency_icd_10 # 25492
file: 2015-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: Q1-Q3_ICD-9-CM -> table: 2015_hospital_inpatient_diagnosis_code_frequency_icd_9 # 11452
file: 2015-hospital-inpatient-procedure-code-frequency.xlsx, sheet: Q4_ICD-10-PCS -> table: 2015_hospital_inpatient_procedure_code_frequency_icd_10 # 20872
file: 2015-hospital-inpatient-procedure-code-frequency.xlsx, sheet: Q1-Q3_ICD-9-CM -> table: 2015_hospital_inpatient_procedure_code_frequency_icd_9 # 3428
file: 2016-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2016_hospital_inpatient_diagnosis_code_frequency # 34050
file: 2016-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2016_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2441
file: 2016-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS -> table: 2016_hospital_inpatient_procedure_code_frequency # 29784
file: 2017-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2017_hospital_inpatient_diagnosis_code_frequency # 34040
file: 2017-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2017_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2440
file: 2017-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS -> table: 2017_hospital_inpatient_procedure_code_frequency # 29517
file: 2018-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2018_hospital_inpatient_diagnosis_code_frequency # 34140
file: 2018-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2018_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2407
file: 2018-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS -> table: 2018_hospital_inpatient_procedure_code_frequency # 29024
file: 2019-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2019_hospital_inpatient_diagnosis_code_frequency # 34342
file: 2019-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2019_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2317
file: 2019-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS -> table: 2019_hospital_inpatient_procedure_code_frequency # 28767
file: 2020-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2020_hospital_inpatient_diagnosis_code_frequency # 33654
file: 2020-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2020_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2240
file: 2020-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2020_hospital_inpatient_procedure_code_frequency # 0
file: 2021-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2021_hospital_inpatient_diagnosis_code_frequency # 33986
file: 2021-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2021_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2261
file: 2021-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS -> table: 2021_hospital_inpatient_procedure_code_frequency # 28193
file: 2022-hospital-inpatient-diagnosis-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2022_hospital_inpatient_diagnosis_code_frequency # 34110
file: 2022-hospital-inpatient-external-cause-of-injury-morbidity-code-frequency.xlsx, sheet: ICD-10-CM -> table: 2022_hospital_inpatient_external_cause_of_injury_morb_code_freq # 2364
file: 2022-hospital-inpatient-procedure-code-frequency.xlsx, sheet: ICD-10-PCS -> table: 2022_hospital_inpatient_procedure_code_frequency # 28091