{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 137, "name": "Public Health CDC Infectious Death Count", "type": "Feature Layer", "description": "
Data Source Comparison Thoughts<\/SPAN><\/P> Population<\/SPAN><\/P> Numbers Reported<\/SPAN><\/SPAN><\/P> U.S. Census Bureau (2020)<\/SPAN><\/SPAN>: <\/SPAN><\/SPAN>5,118,425<\/SPAN><\/SPAN><\/P> This estimate is pulled from the US Census Bureau Population Reporting 2020, which is in the file <\/SPAN><\/SPAN>2020_SCPop<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>Z:\\Workspace\\Projects\\SCEMD _HIRA 2023\\2023Plan\\Data\\ByHazard\\PublicHealth\\Data\\COVID<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>, a summary file from <\/SPAN><\/SPAN>DECENNIALPL2020.P1-2021-11-23T184402 <\/SPAN><\/SPAN>(Z:\\Workspace\\Projects\\SCEMD _HIRA 2023\\2023Plan\\GISReference\\Population<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN><\/P><\/LI> SC DHEC<\/SPAN><\/SPAN>: <\/SPAN><\/SPAN>5,218,040<\/SPAN><\/SPAN><\/P> This estimate is based on the SC DHEC reported population estimates in each of the county-specific dashboard table pages and in the statewide dashboard table. The county estimates and the statewide estimate had the same number. The SC DHEC population estimates are \u20182020 population estimates\u2019 from the Census\u2019 experimental 1-year American Community Survey (ACS). <\/SPAN><\/P><\/LI><\/UL> Difference<\/SPAN><\/P> 99,615<\/SPAN><\/SPAN> with a net positive for SC DHEC estimates. <\/SPAN><\/SPAN><\/P> The difference equation is SC DHEC estimates (1-year ACS) \u2013 Census (Decennial) Population = Difference. Any difference that is positive has a higher estimate in SC DHEC, and any that is negative has a higher estimate in the census population. Most counties had a greater population estimate using the SC DHEC data than with the census population. However, 10 counties had greater population estimates using the census bureau: (Chester (-62), Colleton (-1,123), Georgetown (-51), Hampton (-508), McCormick (-96), Marlboro (-1,086), Pickens (-3,421), Spartanburg (-1,792), Union (-253), and Williamsburg (-1,201). The biggest discrepancies are Horry County <\/SPAN>(+14,420)<\/SPAN><\/SPAN> and Pickens County <\/SPAN><\/SPAN>(-3,421)<\/SPAN><\/SPAN>. <\/SPAN><\/SPAN><\/P> COVID Cases and Deaths <\/SPAN><\/P> Three different sources for both COVID cases and COVID deaths were used: <\/SPAN><\/SPAN>USAFacts<\/SPAN><\/SPAN>, <\/SPAN><\/SPAN>SC DHEC Estimates<\/SPAN><\/SPAN>, and the <\/SPAN><\/SPAN>New York Times<\/SPAN><\/SPAN>. <\/SPAN><\/P> Numbers Reported<\/SPAN><\/P> USAFacts<\/SPAN> Cases: <\/SPAN><\/SPAN>975,320<\/SPAN><\/P> USAFacts<\/SPAN> Deaths: <\/SPAN><\/SPAN>14,636<\/SPAN><\/SPAN><\/P> These cases and deaths are based on the cumulative reported cases on 12/31/2021 to include all reported cases in 2020 and 2021 and all reported deaths in the same time frame. The raw data files are available in Z:\\Workspace\\Projects\\SCEMD _HIRA 2023\\2023Plan\\Data\\ByHazard\\ PublicHealth\\Data\\COVID\\Raw. The USAFacts raw files have the \u201cUSAFacts\u201d prefix. Cases are <\/SPAN>USAFACTS_covid_confirmed_usafacts 01122022<\/SPAN><\/SPAN>. Deaths are <\/SPAN><\/SPAN>USAFACTS_covid_deaths_usafacts 01122022<\/SPAN><\/SPAN>. <\/SPAN><\/SPAN><\/P> SC DHEC<\/SPAN> Cases: <\/SPAN><\/SPAN>1,000,194<\/SPAN><\/SPAN><\/P> When checked, there was a discrepancy of 70 cases in the SC DHEC data (last reported number: 1,000,264). Our thoughts are that SC DHEC is continually updating the data and it will then change the number of cases. Not every county had a discrepancy and those that did were only around 2-3. <\/SPAN><\/P> <\/SPAN>SC DHEC<\/SPAN> Deaths: <\/SPAN>14,858<\/SPAN><\/P><\/LI><\/UL><\/LI><\/UL> These cases and deaths are based on the reported values from the beginning of 2020 to 12/31/2021. The raw data files (in the form of pdfs) are available in Z:\\Workspace\\Projects\\SCEMD _HIRA 2023\\2023Plan\\Data\\ByHazard\\PublicHealth\\Data\\COVID\\SCDHEC\\PDFs. The excel files combining each county are available in Z:\\Workspace\\Projects\\SCEMD _HIRA 2023\\2023Plan\\Data\\ByHazard\\PublicHealth\\Data\\COVID\\Raw. The SC DHEC raw files have the \u201cSC DHEC\u201d prefix. Cases and deaths are combined. <\/SPAN><\/P> New York Times<\/SPAN><\/SPAN> Cases: <\/SPAN><\/SPAN>975,320<\/SPAN><\/SPAN><\/P> New York Times<\/SPAN><\/SPAN> Deaths: <\/SPAN><\/SPAN>14,636<\/SPAN><\/SPAN><\/P> These cases and deaths are based on the NYTimes updated database through GitHub. It provides yearly data for 2020, 2021, and 2022. This data is cumulative so to capture the 2020-2021 timeframe, data is from 12/31/2021. The raw data files are available in Z:\\Workspace\\Projects\\SCEMD _HIRA 2023\\2023Plan\\Data\\ByHazard\\PublicHealth\\ Data\\COVID\\NYTimes. Cases and deaths are combined in the excel sheet. <\/SPAN><\/P> Differences in Cases<\/SPAN><\/P> 24,874<\/SPAN><\/SPAN> between SC DHEC and USAFacts. <\/SPAN><\/SPAN><\/P> The difference equation is SC DHEC\u2013 USAFacts = Difference. Any difference that is positive has a higher number reported in SC DHEC, and any that is negative has a higher number reported in USAFacts. All counties reported a higher number of cases in the SC DHEC data than the USAFacts data. The range of discrepancies is from Greenville County (<\/SPAN>3,028<\/SPAN><\/SPAN>) to Allendale County (<\/SPAN><\/SPAN>26<\/SPAN><\/SPAN>). On average, there is a difference of <\/SPAN><\/SPAN>542<\/SPAN><\/SPAN> cases. <\/SPAN><\/SPAN><\/P><\/LI> 24,874<\/SPAN><\/SPAN> between SC DHEC and New York Times. <\/SPAN><\/SPAN><\/P> The difference equation is SC DHEC\u2013 NYTimes = Difference. Any difference that is positive has a higher number reported in SC DHEC, and any that is negative has a higher number reported in NYTimes. All counties reported a higher number of cases in the SC DHEC data than the NYTimes data. This data difference is the same as the SC DHEC/USAFacts Cases difference values. <\/SPAN><\/SPAN><\/P><\/LI> No difference<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>between USAFacts and New York Times. <\/SPAN><\/SPAN><\/P> The difference equation is USAFacts \u2013 NYTimes = Difference. Any difference that is positive has a higher number reported in USAFacts, and any that is negative has a higher number reported in NYTimes. All counties matched between the two sources with a net value of 0. <\/SPAN><\/SPAN><\/P> Reported data started 3/6/2022 (USAFacts and NYTimes) and 3/4/2022 (SC DHEC).<\/SPAN><\/SPAN><\/P> Differences in Deaths<\/SPAN><\/SPAN><\/P> 222<\/SPAN><\/SPAN> between SC DHEC and USAFacts. <\/SPAN><\/SPAN><\/P> The difference equation is SC DHEC \u2013 USAFacts = Difference. Any difference that is positive has a higher number reported in SC DHEC, and any that is negative has a higher number reported in USAFacts. 12 counties matched between the two sources with a net value of 0 (Bamberg, Barnwell, Berkeley, Charleston, Clarendon, Edgefield, Fairfield, Hampton, Jasper, Lee, Marion, and Union. The other counties had positive values. The range of discrepancies is from Greenville County (<\/SPAN><\/SPAN>40<\/SPAN><\/SPAN>) and Aiken and Allendale, both at <\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>. On average, there is a difference of <\/SPAN><\/SPAN>4.8<\/SPAN><\/SPAN> deaths. <\/SPAN><\/SPAN><\/P> 222<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>between SC DHEC and NYTimes. <\/SPAN><\/SPAN><\/P> See the SC DHEC and USAFacts difference description. <\/SPAN><\/P> No Difference <\/SPAN>between USAFacts and NYTimes. <\/SPAN><\/P><\/LI> The difference equation is USAFacts \u2013 NYTimes = Difference. Any difference that is positive has a higher number reported in USAFacts, and any that is negative has a higher number reported in NYTimes. All counties matched between the two sources with a net value of 0. <\/SPAN><\/P><\/LI><\/UL><\/LI><\/UL><\/LI><\/UL> Reported data started 3/16/2022 (USAFacts and NYTimes), and 3/15/2022 (DHEC). <\/SPAN><\/SPAN><\/P> Data Summary <\/SPAN><\/SPAN><\/P> NYTimes<\/SPAN><\/SPAN> data reports the cumulative number of cases for each geographic area. The case counts include lab-confirmed and probable cases. The criteria for probable cases are provided in the readme (<\/SPAN><\/SPAN>linked here<\/SPAN><\/SPAN><\/A>). The readme includes a disclaimer about the reporting variability in geographies, including some counties including confirmed and probable cases as a single total and some geographies not including probable cases. The data includes cases and deaths in the same workbook file. Deaths overall include confirmed and probable counts. They distinguished between confirmed and probable deaths, with probable deaths including deaths where COVID was listed on the death certificate as a cause of death/significant contributing condition, but not a positive lab test. Additionally, deaths among probable cases tracked by a state/local health department where a death certificate hadn\u2019t been filed were also counted. The readme notes the effort made by NYTimes to update the data to reflect the most current counts (including any possible removal/reallocation). <\/SPAN><\/SPAN><\/P><\/LI> SC DHEC<\/SPAN><\/SPAN> data reports the cases, deaths, and population estimates in South Carolina, South Carolina regions, and South Carolina counties with the option to further enhance the criteria of the data. Based on the lack of a mention of the data being cumulative and matching the data from \u201cCases\u201d and \u201cDeaths\u201d (full-time) to the combination of 2020 and 2021 data, it is assumed that the data is not cumulative. The case counts include the number of confirmed and probable cases (<\/SPAN><\/SPAN>