Talk:COVID-19 pandemic in Indiana

Where/when to get the numbers?
(Especially interested in input from, , and as most active recent editors...but also others as well...)

The recent change in the data visualization at the ISDH's coronavirus.in.gov page made getting county-level details from there much more of a challenge. So, I changed the cited source for that table to be the Johns Hopkins data being released through GitHub...and wrote some Excel magic to make pulling the data and formatting it into a wiki table easy.

But...that data comes in two forms, daily files (https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_reports) and a more real-time "web-data" stream (https://github.com/CSSEGISandData/COVID-19/tree/web-data). Neither updates on exactly the same cycle as the ISDH page. So, it's easy for the numbers in the info box and the graph at the top of the page to get out of sync with the numbers down in the county table.

On one hand, I'm mostly OK with that, so long as we can make it obvious _why_ the numbers might not match. On the other hand, I'm inclined to think that Wikipedia is not necessarily supposed to be up-to-the-minute, and maybe it would be sufficient to use the Johns Hopkins data for all the counts on the page and just be OK with not always matching the ISDH page.

(Alternately, if we can find an ISDH source for the county-level data that is easy to get numbers from and stays more in sync with the big numbers at coronavirus.in.gov, that would probably work too.)

Your thoughts? 3Todd (talk) 19:26, 3 April 2020 (UTC)
 * Great news! The ISDH added a link to download the day's county by country breakdown just under the map at in.gov/coronavirus (File download here). I'm setting up an excel sheet to automate this, but we'll just go with that since it will be the most up to date in all likelihood, unless you have any objections? Cerebral726 (talk) 16:27, 7 April 2020 (UTC)
 * Good find ! I'll keep an eye on that file for a bit. If it's stable and reasonable, I agree that it'll be an easier data source to use for all of the numbers. I might also see what it would take to use it in the tool I wrote to pull numbers from the Johns Hopkins data and output formatted rows for the tables we keep updating: https://github.com/trimble/wiki_covid_tables 3Todd (talk) 20:44, 7 April 2020 (UTC)
 * After a few days of watching and some script updates (https://github.com/trimble/wiki_covid_tables), I think we can consider the state's new county-level CSV data source usable. The state-level numbers are still a little tricky without a download option...and they change day-to-day as records get sorted out and data updated. But, we're probably to the point now where one daily update after ISDH updates the official web site is OK. 3Idiot (talk) 15:34, 12 April 2020 (UTC)

To close this loop...shortly after the discussion above, ISDH added considerably to the data that can be downloaded. We're now regularly updating numbers on this page using the resources from the "Indiana Data Hub" here: https://hub.mph.in.gov/dataset?q=COVID. We can probably archive this discussion at some point to clean up the talk page. 3Todd (talk) 17:50, 10 May 2020 (UTC)

Remove empty "recovered cases" column from county data table?
Soliciting input from and  as most active recent editors...but also others as well...

I'm not in love with having the entirely empty "Recovered Cases" column in the table of county data. Since it would be exceedingly difficult to measure/quantify that, I don't suspect that ISDH (or anyone) will be providing data to put in that column any time soon.

I propose we remove that column for now, with the option of adding it back if ISDH comes up with some way to count recoveries. Your thoughts? 3Todd (talk) 20:57, 2 May 2020 (UTC)
 * , I am creating all of the templates the same. Some states are posting the recovery data and some are not. On the ones that are not posting that data such as Illinois, some of the counties are reporting this data.  Since there over 3400 counties in the states and territories, I have not looked at each county to get the recovery data. I would imagine that if we crowdsourced for this data, there would be information to show in these columns. Maybe when I get done with the other templates I'll look at those counties. —  Mr Xaero   ☎️ 21:05, 2 May 2020 (UTC)

Medical Cases Chart Cleanup Proposal
Paging for input... (also others, but they has been actively involved most recently)

See a mock-up in my sandbox for some proposed cleanups to the medical cases chart. I did a little work to catch up our use of the template with new features that have been added to the template recently. Please take a look and let me know what you think. (Spoiler: the data rows can be a lot shorter and less error-prone...) 3Todd (talk) 02:30, 10 May 2020 (UTC)
 * Just wanted to let you know I updated "Active Cases" to "Total Confirmed Cases", as that is a part of the chart that was actively wrong at the moment. The rest of the changes were also great additions, so I look forward to you integrating those into the chart. Cerebral726 (talk) 16:53, 13 May 2020 (UTC)

Bar chart data
The bar chart data includes numbers for every day of the week. Beginning on June 25, 2021, the Indiana State Department of Health stopped reporting numbers for two days a week. Rather than repeating Thursday's numbers for Friday and Saturday (and giving a false impression, in my opinion), I think Friday and Saturday should be left empty. As a result, Sunday's numbers would not have a percentage increase, since the 3-day increase is not comparable to the other one-day increases. This is the way the bar chart is displayed for Iowa, which stopped providing daily numbers on July 22, 2021, and Michigan, which stopped providing daily numbers in on July 3, 2021. --Spiffy sperry (talk) 20:35, 24 August 2021 (UTC)