Template talk:COVID-19 pandemic data/United States medical cases/Archive 1
![]() | This is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page. |
Archive 1 | Archive 2 |
Percentages
Not sure percentages need to go to the second decimal point. Would reduce clutter to reduce to one or none. Benzigterman (talk) 22:52, 5 March 2020 (UTC)
The percentages were removed, so I guess this is no longer relevant. Benzigterman (talk) 02:26, 6 March 2020 (UTC)
Should we have a chart like the Coronavirus cases worldwide page on the Cases in the US page?
Like a list of state by infection like the 2019–20 coronavirus outbreak by country and territory list they have on that page --HurricaneKappa (talk) 19:42, 7 March 2020 (UTC)
Overhaul
My understanding is this table was originally copied from Italy's table template and adapted for the United States. I find this table very difficult to read - everything from the European date format to the classifications of domestic v new v total cases. I've proposed a simplified version that I've copied below. Given this is such a drastic change, I wanted to include it here first. To simply matters - and to adhere to how state health departments and the CDC is reporting cases - this only includes non-repatriated cases. Tracking down the location of non-repatriated cases is nearly impossible (between Travis AFB, San Antonio, Nebraska, Spokane etc) and presents no public threat. Hypererleas (talk) 21:07, 1 March 2020 (UTC)
Date | AZ | CA | IL | MA | OR | RI | WA | WI | Total |
---|---|---|---|---|---|---|---|---|---|
Jan 21 | 1 | 1 | |||||||
Jan 24 | 1 | 1 | |||||||
Jan 25 | 1 | 1 | |||||||
Jan 26 | 1 | 1 | 2 | ||||||
Jan 30 | 1 | 1 | |||||||
Jan 31 | 1 | 1 | |||||||
Feb 1 | 1 | 1 | |||||||
Feb 2 | 3 | 3 | |||||||
Feb 5 | 1 | 1 | |||||||
Feb 20 | 2 | 2 | |||||||
Feb 26 | 1 | 1 | |||||||
Feb 28 | 1 | 1 | 2 | 4 | |||||
Feb 29 | 1 | 1 | 3 | 5 | |||||
Mar 1 | 1 | 2 | 3 | ||||||
Total | 1 | 11 | 3 | 1 | 1 | 1 | 8 | 1 | 27 |
- Tagging a few folks who are active on 2020_coronavirus_outbreak_in_the_United_States to get feedback prior to committing a drastic change. @Another Believer: @Know135: @Phoenix7777: Hypererleas (talk) 21:12, 1 March 2020 (UTC)
- I agree with your proposed overhaul. I think conceptually the usefulness of the table is mainly in tracking spread potential/actuality over time by location, and your overhaul has the essential information to support that. I suggest adding a column for references or other provision for references tied to new entries in case of new / confusing / debatable cases as they emerge. Know135 (talk) 21:37, 1 March 2020 (UTC)
- And someone needed to included a death section too, as of March 1st, there only one confirmed death in Washington. Chad The Goatman (talk) 21:39, 1 March 2020 (UTC)
- @Know135: Thanks for the feedback. And I agree, a column for sources is missing. Hypererleas (talk) 22:31, 1 March 2020 (UTC)
- @Chad The Goatman: I played around with a few ways to display the data, including whether to include a death toll or the number of cases recovered (and then possibly include the number of remaining cases). That becomes incredibly unwieldy though (3 fields per state per day). However, as Know135 pointed out, the usefulness of the table is mainly in tracking spread potential/actuality over time by location not tracking death rates or other metrics. I have another table I'm preparing to display that information but not on a time basis, just totals. Hypererleas (talk) 22:31, 1 March 2020 (UTC)
- @Hypererleas: There was a big jump today on the CA state website running total but not sure which counties it came from. Thanks whoever just updated at least the 90 total is current. I think we should move to a "significant states and significant counties" style, only break out those with more than 10 or 20 cases, group the rest as "other", then we can have room for deaths. Then every week archive the dailies and move it to weekly total. The current daily totals and full state breakdown can be moved to a linked dedicated details page for posterity. Also most of the main reporting sources now group into 4 bins: travel, personal contact, community transmission & under investigation. So something else to consider. Is there a way to work on a new table in talk and then only make the big change when stable? It's a lot of work only to have it reverted.Greenbe (talk) 00:36, 9 March 2020 (UTC)
Utah column: can't figure out how to edit a table
The Utah column is incorrect. The source cited (no. 24) indicates that the only coronavirus case in the state is from a repatriated passenger of the Diamond Princess. I cannot figure out how to delete the column, but unless there is another source indicating the existence of a non-repatriated case, the column should be deleted. Smachable (talk) 02:43, 6 March 2020 (UTC)
Also having great difficulty editing new table format that was introduced today. How do we access the wysiwyg interface? dudzcom (talk) 17:31, 9 March 2020 (UTC)(Figured it out)
Please use State Departments of Health data sources
I've been actively updating this table over the past few days, only using the official state Departments of Health sources, but I've come back this morning to many edits made without citation. Many of the states now no longer match what's listed on the official state source. I'm willing to grant exception to certain states that haven't been updating their page, such as Nevada, but many states have been providing updates 1-2 times per day, making it unnecessary to source from anywhere else. I don't have the energy to fix all of the uncited information right now, but I will include my list of sources here in an effort to get some consistency here. As the number of cases increase significantly, I would encourage maintainers of this table to continue to use state sourced numbers, as it will make it significantly easier to audit and verify edits. Also don't forget to archive these pages (using https://web.archive.org/save/) as many of them are updated frequently.--Rmaloney3 (talk) 18:08, 9 March 2020 (UTC)
Edit by 208.78.142.232 added a bunch of numbers to the table without any sources
Probably vandalism - just thought I'd give a heads up. — Preceding unsigned comment added by Isaiah (talk • contribs) 19:20, 9 March 2020 (UTC)
- @Isaiah: I noticed that as well. I attempted to undo those changes this morning when I saw them, but it was too complicated with all of the conflicts, so I gave up. I have a bit more time now though, so I may do that. I have the table mirrored in Excel with the previous data. Shall I manually revert it?--Rmaloney3 (talk) 01:10, 10 March 2020 (UTC)
- @Rmaloney3: I think that is probably a good idea to go through that IP's edits after stuff gets finished being added for the night. This table is a bear to police. I'm really just watching the numbers for Texas, OK, LA, and NM. It would be nice if we had some volunteers to watch the numbers for a few of the states to make sure things are correct going forward. Isaiah (talk) 01:22, 10 March 2020 (UTC)
- @Isaiah: @Rmaloney3: I'm watching WA mainly but also keeping an eye on the other elements of the table too. Seatto23 (talk) 19:37, 11 March 2020 (UTC)
- @Isaiah: Done. I just reverted all of 208.78.142.232's un-cited edits, and fixed the math in the whole table. There were several small errors in a few places.--Rmaloney3 (talk) 05:26, 10 March 2020 (UTC)
- @Rmaloney3: Another IP address 208.78.142.233 is adding unattributed data this morning. I removed all of their edits I think. Can you double check my work? I wonder how we can get that to stopIsaiah (talk) 13:34, 10 March 2020 (UTC)
- @Isaiah: Thanks for reverting them. There were still some mistakes in the CA table, so I fixed them. Rmaloney3 (talk) 18:01, 10 March 2020 (UTC)
- @Isaiah: @Rmaloney3: I fixed the ref for CA (at bottom) back to the CA dept of health (link in Rmaloney3's table). It was switched to a news source. Seatto23 (talk) 19:37, 11 March 2020 (UTC)
Is this table suppose to include repatriated cases?
The section title says it all. I ask because over the past 2 days 208.78.142.232 and 208.78.142.233 have made un-cited edits in CA and a few other places that seem to be adding in the repatriated bases listed on https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/nCoV2019.aspx. Perhaps they are using a different source though. Either way, there seems to be confusion somewhere as these two IP users have been continuing to make modifications all over the table that do not align with the State Departments of Public Health sources listed in the table above. My understanding is that this table is non-repatriated cases only. If that's the case, we should consider updating the title to reflect that.--Rmaloney3 (talk) 16:49, 10 March 2020 (UTC)
- I just added all the columns and rows and found that the California column was off by 24...the number of repatriated cases. I'd also like to know what is supposed to be done with those as I haven't included them in the Florida total. The California Department of Health page says:
As of March 10, 2020, 7 a.m. Pacific Time, there are a total of 157 positive cases and two deaths in California: 24 cases are from repatriation flights. The other 133 confirmed cases include 50 that are travel related, 30 due to person-to-person transmission, 29 are community acquired (map of community transmission by county in California- PDF) and 24 are from unknown sources....
- So I think it may be a misunderstanding of which figure to use. AHeneen (talk) 03:46, 11 March 2020 (UTC)
- AHeneen Yeah I think we just need to decide whether or not we would like to include repatriation cases in this table. This table use to be called Non-Repatriated COVID-19 Cases in the US by State, and I didn’t actually realize until earlier today that it was updated. If we don’t want this table to include repatriations, then I think we should update the title to reflect that, because otherwise there are going to continue to be edits that include those numbers. I’m fine with either option honestly, just letting people know why I may have gone through and undone edits here and there.Rmaloney3 (talk) 04:30, 11 March 2020 (UTC)
- AHeneen Rmaloney3 My understanding is that it is only non-repatriated cases and the numbers up to March 9 reflected that. Also I agree with Rmaloney3 that now that state departments of health are posting numbers, we need to use those. The source for CA (at bottom) got switched from the CA official page to a news source. I fixed it. Seatto23 (talk) 19:31, 11 March 2020 (UTC)
I think we should have a separate table for the repatriated cases, which would include the cruise ships. Adding those to the states by date will be a mess since a) it makes it look like a state had a big jump in numbers and b) people are being moved around (start in CA and then get moved to another state). That table won't be updated too often. Seatto23 (talk) 21:06, 11 March 2020 (UTC)
- I think the repatriated cases should have a column of their own. AHeneen (talk) 01:51, 12 March 2020 (UTC)
Collapse the references
If it's possible, the references on the right column should be collapsed down either into a single big reference containing all the cite web's, or some sort of dropdown. Right now the references break lines for each one cause the table has gotten so wide, and makes the rows extremely tall. 38.124.35.11 (talk) 17:13, 10 March 2020 (UTC)
- @38.124.35.11: Feel free to make that change. Also, the current solution isn't scalable. I'm fine with either approach, as long as the references aren't lost. Many of the references for each day are linked to a State Department of Health website, so the archives in these citations are the most important part, as they are the snapshot for that day. Rmaloney3 (talk) 17:56, 10 March 2020 (UTC)
- I don't have the wiki skills to make that change unforotunately. @Rmaloney3: 38.124.35.11 (talk) 18:20, 10 March 2020 (UTC)
- Totally agree. Don't know how to make that happen, only minor wiki skills here. Can anyone else help? dudzcom (talk) 00:06, 11 March 2020 (UTC)
- @Dudzcom: @38.124.35.11: I also don’t know how to make such edits, but I would welcome improvements to the structure. Rmaloney3 (talk) 04:32, 11 March 2020 (UTC)
- Looks like someone removed the line breaks from the table so now all line are same height. I think that's workable. This table is a documentation of cases by state by day (or more specifically what states reported by day) so having the references spill over way to the righthand side seems fine. Seatto23 (talk) 21:04, 11 March 2020 (UTC)
- There must be a way to collapse this column, which is currently way too wide. Anyone have ideas, or are line breaks the only solution? ---Another Believer (Talk) 01:53, 12 March 2020 (UTC)
Conflicting totals for Florida March 12
As of 9:43PM on March 11, there were 26 total FL cases...23 FL residents (incl. 2 deaths) & 3 non-residents tested and being treated in FL. (web archive of FL DoH Covid-19 webpage updated at 9:43pm EDT March 11). The agency's Covid-19 page includes a table of the Florida residents, but excluding non-residents that were tested and being isolated/treated in the state, so it only had 23 individuals in the table. During the day on March 12, the Fla DoH released:
- press release with 3 new FL resident cases (linked from tweet at 9:04am not including number of new cases), which added #24-26 in table....29 total, 3 announced 3/12
- tweet at 1:54pm announcing one more FL resident (webpage updated at 2:49p (web archive))....#27 in table...30 total, 4 announced 3/12
Then things get messed up:
- tweet at 10:49pm announcing 15 cases...no press release on website (maybe too late & will be released in morning?). A journalist tweeted a screenshot of 15 cases that included 12 FL residents and 3 non-residents, saying the source is a Fl. Dept. of Health press release (tweet March 11 saying screenshots were emails)...the info for individuals in the table matches the journalist's screenshot as #28-41. This should have brought the total to 45 total (39 FL res., 6 non-res.), 19 announced 3/12
- tweet at 12:45am March 13 announcing another case, saying "DOH has announced one additional positive case of COVID-19, bringing the total confirmed new cases for March 12th to 17 individuals who tested positive for #COVID19." But this one should bring the total to 46 total cases (40 FL residents and 6 non-residents) & 20 new cases for 3/12.
As of 3am EDT 3/13, the Covid-19 webpage was last updated 11:53pm March 12 (web archive) and lists 41 individuals in the FL residents table and the totals at the top say 41 FL residents and 3 non-residents. Cross-referencing with the emailed press release screenshot from the journalist, 2 in the table (#30 & #31, a 50yo male and 70yo male both in Sarasota Co.) appear to be listed as non-residents in the email press release (50yo NY resident in Sarasota Co. & 70yo MA resident in Sarasota Co.), but a 20yo TX resident isn't included in the table. The website is usually updated 30-90 minutes after the DoH tweets new cases (I set my Twitter app to receive a notification for every @HealthyFla tweet and have noticed this delay over the past few days).
Here's the conclusions I draw:
- The webpage doesn't include the case from the tweet at 12:45am 3/13 (which that tweet says it is a case from 3/12).
- The webpage doesn't include any new non-residents for 3/12 (tally still at 3). There were only 14 individuals added to table in the evening but 15 in tweet& emailed press release. The table omits the TX resident, so it definitely seems to be inaccurate by 1.
- If the last tweet was correct that there were 17 new cases on 3/12, then the first three announced in the morning may be from 3/11, but moving those three to 3/11 would be inappropriate WP:SYNTHESIS. The tweet may just refer to Florida residents, forgetting the 3 non-residents.
Anyway, I added the cases to the template to match the totals on the Covid-19 webpage (44 cases, which equals 18 added for 3/12 even though this conflicts with the 12:45am tweet) since that's the reference used for the Florida column. Hopefully, they clear things up in the morning. In that case, I'll follow up and try to figure out what the correct figures should be then correct Florida's figure in the template later today. It will probably actually be 20 new for 3/12 and 46 total. AHeneen (talk) 06:54, 13 March 2020 (UTC)
- I think we should stick with what the FL department of health puts out at the end (by midnight EST) on each day. We don't have to reflect every tweet that is posted throughout the day. At this point the states health departments are putting out daily reports so let's stick with that in this table. In the timeline narrative, it can be noted the other cases coming up during the day. Seatto23 (talk) 17:08, 13 March 2020 (UTC)
Thoughts on new layout?
Wikilucki updated the template format to deal with the overly wide source column. As Another Believer noted, the width was getting way too wide and putting in line breaks caused the row heights to be too big. While the new layout solves the too wide sources column, I find it really hard to read. What about a different format:
- Keep the table with state numbers but move the daily sources into "footnotes" with a bullet for each day. So it would look like this
BIG TABLE ONLY COUNTS by state by day. Then below the table the daily archived sources from the state public health officials.
- Mar 1 sources
- Mar 2 sources
etc.
@Rmaloney3: @Matthewberns: Since you two are doing the lion-share of the state updates right now. Seatto23 (talk) 17:03, 13 March 2020 (UTC)
- @Seatto23: I would much rather have that than what is there currently. Rmaloney3 (talk) 17:18, 13 March 2020 (UTC)
- @Rmaloney3: Ok. I will work on a new design in my sandbox and then send a link to check that out before posting on the main page. Seatto23 (talk) 17:20, 13 March 2020 (UTC)
Check out new layout proposal here: https://en.wikipedia.org/wiki/User:Seatto23/sandbox The sources are now in a 3 column list below the table. If it looks ok to another editor, I'll push it to the main page. Rmaloney3 Another Believer Matthewberns Seatto23 (talk) 18:48, 13 March 2020 (UTC)
Also check out the state abbr on Mar 12. I've had a hard time cleaning up refs to only be the official state released numbers and having the state abbr would make it easier. Seatto23 (talk) 18:48, 13 March 2020 (UTC)
- @Seatto23: I like this a lot better, but the one downside I see is that the sources will no longer be visible or as accessible when this table is being viewed from 2020 coronavirus pandemic in the United States. You could add a footer to the table similar to Template:2019–20 coronavirus pandemic data, and either link to the sources section on the Template page, or put the sources in a collapsable footer. Rmaloney3 (talk) 19:18, 13 March 2020 (UTC)
- @Rmaloney3: Good point. Let me try to do a collapseable sources at the bottom like is in that table. Seatto23 (talk) 19:20, 13 March 2020 (UTC)
- @Wikilucki: I think I made it a bit better for now. Matthewberns19:23, 13 March 2020 (UTC)
- @Matthewberns: Thanks for that. This is better, but now that sources table cell at the bottom is stretching the width of all the rows. Have you looked at @Seatto23:'s proposal, with my additional comments? I think that could further clean it up. Thoughts? Rmaloney3 (talk) 19:28, 13 March 2020 (UTC)
- @Matthewberns: @Wikilucki: @Rmaloney3: That change is even worse. The sources have to be associated with each day. See this proposal for a change. https://en.wikipedia.org/wiki/User:Seatto23/sandbox. For now, we could have the 3 col source lists under the table on the main page. I'm working on putting it in a collapsible box but that is going to take a bit. Also editting that box might be hard for others and they might tend toward not adding the reference. Seatto23 (talk) 19:34, 13 March 2020 (UTC)
- @Matthewberns: I'm going to undo your changes since we have to have the sources organized by day. Well, actually I'll use your format but try to put my 3 column sources in your notes box. Seatto23 (talk) 19:37, 13 March 2020 (UTC)
- @Seatto23: I'm okay with you making that change as long as you include a note and link to the sources at the bottom of the table. We can work on the collapsable footer later. Rmaloney3 (talk) 19:38, 13 March 2020 (UTC)
- @Seatto23:Sounds good. Matthewberns19:38, 13 March 2020 (UTC)
- @Matthewberns: @Rmaloney3: Ok. I took my 3 column source list and put it in the daily sources box at the bottom. Hopefully it is easy enough to add sources. Now I will research how to make the box collapsible. I know it's possible. Seatto23 (talk) 19:54, 13 March 2020 (UTC)
- Also what do you think of having the state abbr next to source? I've been trying to make sure all daily sources are an archive of the state official report and having the state abbr there would help. Also would help those who want to easily see where that state's daily number came from. Seatto23 (talk) 19:54, 13 March 2020 (UTC)
- @Seatto23: I'm fine with that as long as it doesn't make it too verbose. Not sure if you've tried to add a reference with the new format, but it's really challenging in the Visual Editor because the sources are embedded in a Column View. Rmaloney3 (talk) 19:57, 13 March 2020 (UTC)
- @Rmaloney3: Darn. I was worried about editing being hard. I'll futz with it. Seatto23 (talk) 19:59, 13 March 2020 (UTC)
- @Rmaloney3: I removed the collist so now it is easier to edit with the Visual Editor. I'll look into collapsing the row. I was able to do that but unfortunately that made it impossible to edit (it was blank) so will have to do more poking. Seatto23 (talk) 20:24, 13 March 2020 (UTC)
- @Seatto23: Added put the daily sources in a collapsable list. Let me know what you think. Rmaloney3 (talk) 20:31, 13 March 2020 (UTC)
- @Rmaloney3: I think that's what we want but now I can't edit sources at all with the Visual Editor. I have to use 'edit source'. Seatto23 (talk) 20:34, 13 March 2020 (UTC)
- @Seatto23: Hmmm yeah you're right. This definitely makes it harder to edit, but I think this is the best looking option we've had so far. Not sure what the right balance is to strike. Rmaloney3 (talk) 20:38, 13 March 2020 (UTC)
Anyone know how to embed an editable subpage within the table (for daily sources)
The Daily Sources at the bottom of the table is hard to edit because we can't use the Visual Editor on it because it is in a collapsable element. Maybe if the content was embedded from a subpage it would be easier to edit? But I don't know how to set something like that up or if that is even a doable strategy. Any ideas on how we can set up the Daily Sources so that we could use the Visual Editor on them? Seatto23 (talk) 03:14, 14 March 2020 (UTC)
Unexplained reverts by User:CROSSSC
This user (@CROSSSC:) has repeatedly reverted my updated totals for FL without any explanation: [1], [2], [3], [4]
I don't want to revert again and violate WP:3RR, so would someone please correct the totals. The last two reverts were to edits where I first included the bare url, then the last was to an edit I made with the summary "What part is not clear about 70 FL residents & 7 non-residents isolated in FL = 77 http://www.floridahealth.gov/diseases-and-conditions/COVID-19/". The link was updated at 12:54am and all reverts were made AFTER the webpage had been updated. AHeneen (talk) 06:01, 14 March 2020 (UTC)
- Aheneen I updated the FL numbers. Seatto23 (talk) 08:43, 14 March 2020 (UTC)
Add daily sources at bottom of table (outside table) and then we'll moving into the table at the end of the day.
It's getting really time consuming to add the daily sources inside the table since it has to be done on the raw source. So I moved the sources for the day we are working on outside the table. Add there, you can use VE, and then we'll paste those into the cases table at the end of the day. Seatto23 (talk) 17:42, 14 March 2020 (UTC)
Deaths, how to include in table?
I saw the state daily total at the bottom. That's nice. I was losing track of the state numbers. What about the deaths by day? I don't think my original suggestion of 2/1 is good as table would get too wide. We could make the rows double height and do 2 (1) so cases and then deaths. Seems like keeping track of this by state by day is good and the daily sources already have this info as part of the state dept of health reports. So we just need to add the numbers. Thoughts? I don't want to make any big layout changes to the table without other editors agreeing its a good idea to have the daily deaths by states. Rmaloney3 Matthewberns Dudzcom Rethliopuks Wwnws98 Seatto23 (talk) 15:51, 14 March 2020 (UTC)
- I initially used "\" to separate death numbers from case numbers because that avoids doubling the row height. You made a very good point that if more states start to report deaths then the table will be stretched horizontally, so I made a new table for deaths. If you'd like to use the table, my numbers may be incorrect and feel free to use yours. Some of mine were just calculated. Rethliopuks (talk) 17:03, 14 March 2020 (UTC)
- Rethliopuks Seatto23, I like the new strategy of having a second table. One thing we should keep in mind is the ability to copy/paste the table in to Excel or other spreadsheet applications. Interposed rows for deaths is not clean, and slashes between numbers does not work at at all. The separate table solution is clean and workable. dudzcom (talk) 17:32, 15 March 2020 (UTC)
- I wanted to avoid doubling the row height because that makes the rows potentially have unexpected heights (days w/ and w/o deaths), and because that would make the table unreadable a lot faster than the case-only layout. You might need to add state rows every half a month instead of a month and that would make the table unnecessarily cumbersome. Rethliopuks (talk) 17:09, 14 March 2020 (UTC)
- Yeah the doubling row looked bad. I started that and then saw your table and removed what I had done. Seatto23 (talk) 17:40, 14 March 2020 (UTC)
WikiProject COVID-19
I've created WikiProject COVID-19 as a temporary or permanent WikiProject and invite editors to use this space for discussing ways to improve coverage of the ongoing 2019–20 coronavirus pandemic. Please bring your ideas to the project/talk page. Stay safe, --Another Believer (Talk) 18:19, 15 March 2020 (UTC)
Wrong totals for NJ
User Rmaloney3 edited the total for NJ cases while ignoring my comment about it, and now I can't fix it because I don't have an account and the page has been locked.
The correct 3/19 total for NJ is 318, not 315. The counts for previous days have been adjusted, but NJ has not specified yet which total is wrong. The daily total needs to be fixed too. — Preceding unsigned comment added by 173.70.187.226 (talk) 21:10, 19 March 2020 (UTC)
Template width
This template is way too wide. Is there a way to "sideways collapse" the region so that by default the regions (West, South, etc) are collapsed and editors can elect to uncollapse to view the columns in more detail, or something similar? I'd love to see a template that doesn't stretch the entire Wikipedia article. ---Another Believer (Talk) 20:45, 10 March 2020 (UTC)
- I just want to add that Another Believer isn't alone. Something needs to be done about the template width. Bait30 Talk? 22:55, 12 March 2020 (UTC)
To start, we could reduce or eliminate the horizontal padding around the state name abbreviations in the header row. I have no idea how to do that though, wiki tables confuse me. 38.124.35.11 (talk) 00:18, 13 March 2020 (UTC)
Another thing we could do is split it into four sections, West South Midwest Northeast, have them all vertical-collapsible stacked on top of each other, then a fifth vertical-collapsible summary section with the summed stats for each region as a column. 38.124.35.11 (talk) 00:20, 13 March 2020 (UTC)
- I understand that the previous version was too wide, but in my opinion what it is changed to now is a million times worse. I would rather have a wide table, than have every row's references in a table-width long row right below it. This is very ugly looking, and I'm tempted to revert it, but maybe it's just me. If it's such a big problem to have the references ever-expanding to the right of the table, I'd much rather put each reference next to it's case number within all the table cells. Just my 2 cents. Rmaloney3 (talk) 16:55, 13 March 2020 (UTC)
- Rmaloney3 Agreed. New layout is much worse. Let's revert or how about my suggestion below to have bullet point below the table with the daily sources? So, BIG TABLE with bullets points for each days source's below. Seatto23 (talk) 17:10, 13 March 2020 (UTC) @Seatto23:
I've added horizontal scrolling which is the norm for this kind of table on mobile. {{ping|TheDJ]] do you know what the Vector equivalent of "noresize" class is?
Jdlrobson (talk) 01:31, 20 March 2020 (UTC)
Removing numbers if no source and state dept of health has not reported numbers
Rmaloney3 Someone added NY before the state health dept reported and didn't add a source. I removed those numbers for now. Seatto23 (talk) 17:26, 20 March 2020 (UTC)
- https://coronavirus.health.ny.gov/county-county-breakdown-positive-cases. Here's is the official reporting page. Should update soon. Seatto23 (talk) 17:27, 20 March 2020 (UTC)
Question about NY numbers
User:Seatto23 / User:Rmaloney3 Do you know where on the NY source the actual numbers are? I couldn't find them to verify data that I have been replicating into Template:2019–20 coronavirus pandemic data/United States medical cases when I saw they were posted early today.
Nevermind you just answered that :D MosquitoBird11 (talk) 17:31, 20 March 2020 (UTC)
- MosquitoBird11 Rmaloney3. The United States Blues just reposted those numbers with no source or info with the submit. I just posted a msg to their talk page. I'll check the NY official page again and then revert their addition if I don't find an official release of numbers. Seatto23 (talk) 18:01, 20 March 2020 (UTC)
@Seatto23: This is the official case count from Gov. Andrew Cuomo this morning. See @22:42 in video. Sorry didn't see where to put in source. The citations on the page appeared missing at the moment. https://www.youtube.com/watch?v=Q6_4VBGOSq0 The United States Blues (talk) 18:06, 20 March 2020 (UTC)
- @The United States Blues: Got it. I saw it in the news but this table is for the official reports from state health departments. Maybe add the new numbers sourcing Cuomo's briefing and news sources on the NY page in the time line section. I'm going to remove the NY numbers but I'll edit so it won't show up as a revert against you. Just for the future make sure to add the health department source for the addition below the table. The Mar 20 sources show up below the table. You can only see the sources in edit mode. Seatto23 (talk) 18:16, 20 March 2020 (UTC)
@Seatto23: Thank you, that makes sense. I have a bit of frustration in the delay between the NY health department source and the reported numbers from JHU or Gov. Cuomo. This is the official health department page that I am aware of https://coronavirus.health.ny.gov/county-county-breakdown-positive-cases. However, these figures seem way off, as they do not even match yesterday's total case count in the template. Is the NY health department source no longer being updated? If not, should we switch to another source on here to get more accurate numbers? Otherwise, I would think we have to go back to the Mar 17th number--1,374. The United States Blues (talk) 18:06, 20 March 2020 (UTC)
- @The United States Blues: There should be archived versions of https://coronavirus.health.ny.gov/county-county-breakdown-positive-cases . The table should show what was on the state dept page on each day. The NY health dept page is getting updated daily from what I have seen. Might just be a delay for today. Seatto23 (talk) 18:35, 20 March 2020 (UTC)
GA numbers need correction
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
GA numbers need correction for Mar 20-21 (Mar. 19 looks okay).
Mar. 18 - Total cases 197, total deaths 1 - https://web.archive.org/web/20200318233549/https://dph.georgia.gov/covid-19-daily-status-report
Mar. 19 - Total cases 287 (90 added), total deaths 10 (9 added) - https://web.archive.org/web/20200320070457/https://dph.georgia.gov/covid-19-daily-status-report
Mar. 20 - Total cases 485 (198 added), total deaths 14 (4 added) - https://web.archive.org/web/20200321023347/https://dph.georgia.gov/covid-19-daily-status-report
Mar. 21 - Total cases 555 (70 added), total deaths 20 (6 added) - https://web.archive.org/web/20200321233100/https://dph.georgia.gov/covid-19-daily-status-report 2601:C0:CA7F:CEC0:D58:748C:5233:AB40 (talk) 01:13, 22 March 2020 (UTC)
- Not done The linked reports were made at 7:00 pm those days, and we should probably stick with the noontime reports for consistency. cognaso (talc) 01:33, 22 March 2020 (UTC)
Semi-protected edit request on 21 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
March 20 line is out of whack. Should be 12048+5390=17235, not 174438 100.15.183.127 (talk) 16:48, 21 March 2020 (UTC)
- Not done Something's wrong with that math... cognaso (talc) 01:40, 22 March 2020 (UTC)
March 20 Cumulative Count
The cumulative count for March 20 indicates "174438." This number should actually be around 17,000. 2601:243:2200:60E:7092:F460:EB01:149C (talk) 16:40, 21 March 2020 (UTC)
- A typo that has since been fixed. cognaso (talc) 17:16, 22 March 2020 (UTC)
CA numbers off
I was just reviewing CA numbers and they appear to be off. Best I can tell everything from at least the 18th onward is off by upto 250 cases. CA looks to be reporting twice a day with the final state numbers coming in around 6 PST. They report two sets of numbers, total cases and total non-patriated. At least some of the numbers shown on the tables are total including repatriated. Other days are just flat out wrong. Anyone want to confirm?
Yes as stated in original comments on such. Totals for nation are under reported as well. Per cited source: "As of March 21, 2020 there are 1,224 positive cases and 23 deaths in California." while Wikipedia entry is showing 1,200 for same. — Preceding unsigned comment added by 45.59.207.186 (talk) 17:27, 22 March 2020 (UTC)
Semi-protected edit request on 21 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
There is no data entered in the table for March 20 for Hawaii. Hawaii has a new Coronavirus website. https://hawaiicovid19.com/ It states that as of March 20 there are 37 cases in Hawaii. So if I understand the table format correctly, the number in the Hawaii column for March 20 should be 11. (26+11=37 total) Larsonwe (talk) 13:21, 21 March 2020 (UTC)
- Already done Alucard 16❯❯❯ chat? 14:16, 23 March 2020 (UTC)
Proposal For When Column Summations Do Not Match Official State Totals
Per a conversation with Mark Taylor, I Propose: The value of highest importance to match official numbers is the per-state "summation total"; if the summation total does not match records, then it will undermine the trustworthiness of the table - people will notice. We can't realistically go back in time to figure out which day's number is wrong; so the cleanest approach is to choose a day and "eat" the delta - let the daily value be off for a day for that state... just make sure that the state totals are correct. Honestly, after a week, no one will care that the historical value isn't precise. And as for the daily summation across states, the value we have just "eaten" will generally be minimal percentage-wise; and we can henceforth be sure that the daily summation is correct. The same time-decay-of-value will apply to the daily summation, in that after a week or so, the value of that specific datapoint won't matter; however if the state summations still don't match, people will question whether to use the data at all. dudzcom (talk) 17:19, 23 March 2020 (UTC)
Semi-protected edit request on 23 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
I think there is a typo with the Mar22 case total. If you add the Mar21 total (23710) with the Mar22 new cases (8961), you should get 32671 NOT 32761. 100.34.101.67 (talk) 16:01, 23 March 2020 (UTC)
- Fixed. Thanks for the notice. Please consider getting an account - we could use some more contributors on the page, and you can fix bugs like that when you see them. dudzcom (talk) 17:24, 23 March 2020 (UTC)
Semi-protected edit request on 22 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
March 5 row is missing from the US Deaths calculation. This may be altering the cumulative numbers? JCH (talk) 15:26, 22 March 2020 (UTC)
- @JCH: Did any of the states report deaths on that date? Alucard 16❯❯❯ chat? 14:21, 23 March 2020 (UTC)
- Done JTP (talk • contribs) 01:56, 24 March 2020 (UTC)
Semi-protected edit request on 22 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
Florida has updated their Coronavirus dashboard. The total as of the 11AM update for March 22nd is 830. Source: [1] Larsonwe (talk) 18:37, 22 March 2020 (UTC)
- Done at the time, I'm sure. JTP (talk • contribs) 01:56, 24 March 2020 (UTC)
Help Needed
We need this page to be featured more prominently on the USA Covid-19 page, otherwise we are not going to get the volunteers to help. It takes 2-3 minutes to update each state each day by trolling their disparate websites for information. We need more hands on deck. dudzcom (talk) 01:54, 23 March 2020 (UTC)
- A friend tipped me off to https://covidtracking.com today, and they appear to be maintaining a very high level of accuracy, using the same sources we are. I wonder if we could leverage this work? Mark Taylor (talk) 22:46, 24 March 2020 (UTC)
- Great idea. I believe there is a section of this talk page dedicated to this strategy: "Thoughts on using https://covidtracking.com/ for the state data" dudzcom (talk) 23:38, 24 March 2020 (UTC)
How to do daily sources without breaking the allowed number of citations?
MosquitoBird11 Rmaloney3 The table was moved to its own page with a link in the main page. The number of citations was going over the allowed limits. We will run into that for this page too fairly soon. Maybe we can include the daily sources as links without it being a citation? And only have the state department of health links in the citations? Thoughts? Seatto23 (talk) 19:01, 20 March 2020 (UTC)
- I'm not a wikipedia guru yet, but it seems like the whole point of this table is to use the same consistent source for each state each day, do we need a separate source link for each day, since it's usually to the same page but more recently retrieved? MosquitoBird11 (talk) 19:09, 20 March 2020 (UTC)
- MosquitoBird11 Unfortunately the states are not issuing separate daily reports. The only way to document what they actually reported each day is to use web.archive.org/save and save an archived version of the day's report. For Italy, their CDC equivalent is posting a daily report for all regions and someone is saving that to a GitHub account. We don't have an equivalent. Seatto23 (talk) 19:24, 20 March 2020 (UTC)
- In a related topic, you should vote on this talk page (this RFC) if you want the statistics tables to stay with a link from the main page. . I choose Option B, move stats to a separate article with link to that from main page. Seatto23 (talk) 19:24, 20 March 2020 (UTC)
- Thanks for the information! I will definitely check that out. Just doing my best to keep this data cleaner, as it seemed to be getting unmaintainable MosquitoBird11 (talk) 19:33, 20 March 2020 (UTC)
- MosquitoBird11 Rmaloney3 Seatto23 Are we still supposed to be making a link to the state health department for daily updates? It looks like this has not been happening (I'll admit to being a little hit and miss myself the last few days, though I am only updating Wyoming). I don't see any discussion on the matter. Thanks for any clarification El piel (talk) 02:29, 25 March 2020 (UTC)
Thoughts on using https://covidtracking.com/ for the state data
Rmaloney3 MosquitoBird11 I've been looking at https://covidtracking.com/ and it seems really solid. They are also getting the data from the same sources we are (state health departments) but have much of the process automated. So they have crawlers that watch the state websites for updates. It's all well documented. Each day has a screenshot of the state website in order to have a record. Like https://covidtracking.com/screenshots/AK/AK-20200315-021315.png. Here is an example of the data for Alabama. https://covidtracking.com/data/state/alabama/. Using these data would save us a lot of work. They say they will archive once CDC starts pushing daily reports. Seatto23 (talk) 03:23, 21 March 2020 (UTC)
- @Seatto23: I’ve been using that site as well, but I never thought about using it to simplify our source list. I’m 100% on board with switching to this. Then we can have a single source per day, similar to what Italy has. Rmaloney3 (talk) 04:46, 21 March 2020 (UTC)
- @Seatto23: I think that's a good idea. I'm looking at the table right now and literally a bunch of the row totals are wrong. I don't feel like trying to fix it tonight, but switching sources should help us sort some of that out too. MosquitoBird11 (talk) 05:09, 21 March 2020 (UTC)
- @Rmaloney3: @MosquitoBird11: Ok, let's use https://covidtracking.com/ as the source and update table with that. For the future, I'll see if over the weekend I can code up a table that automatically pulls in the numbers. So we don't have to manually update things. Then we can paste a image of that table in daily. I think that's what someone is doing with the figures. I haven't added images before but can't bee too hard. Seatto23 (talk) 05:16, 21 March 2020 (UTC)
- Better than going through 50 websites a day. I support this. cognaso (talc) 01:44, 22 March 2020 (UTC)
@all: the Wikipedia html table of cases "By State By Date" has unique features that are not present elsewhere on the web, especially in html table form (if there is another location for this presentation, could someone please provide that link, and we can quit using Wikipedia). Additional concerns/considerations are below:
- IMAGE VS TABLE: if you use an image rather than a table it will no longer be possible to correct errors, select rows, columns, and copy, paste actual data into spreadsheets. Is it possible to use covidtracking data but generate a similar html table with tr and td tags so data can remain in HTML format rather than an image?
- LOSS OF HISTORY: much of covidtracking data is useful, however it does not provide as much history as wikipedia. For example, covidtracking goes back to 3/4/2020 whereas wikipedia goes back to 1/21/2020, that early case history is extremely valuable, especially when viewing and comparing long term history of state columns. @Sealto23 would it be possible to augment covidtracking's data with early wikipedia history?
- ERRORS WITH COVIDTRACKING: Colorado cases are presently 475 not 363 as shown at covidtracking at 9:15am MDT on 3/22 (475 is what appears at the CO website and Wikipedia). Also HI cases at covidtracking is 37, but 48 cases are shown at the HI state website and wikipedia. So some errors will be introduced if using covidtracking site. Morebits (talk) 15:31, 22 March 2020 (UTC)
- Hello @Morebits: @Seatto23: @Cognaso: I'm part of the CovidTracking effort -- would love to synchronize: both augmenting early CT data and finding ways to update more frequently. – SJ + 04:04, 27 March 2020 (UTC)
- Advantages to the CT process (a full sheet w/ notes over a wikitable) : there are ~3 pages of context and notes associated with each state: tracking the changes in practice on the official state sites, notes on source reliability and provenance where state practices differ, citing multiple sources when the state is not the most up to date, and adding new data types as they become widely available. The public website data is slower to update because we only publish once there's been peer review: a check + doublecheck + overall data-quality check before publishing. It's also a community editing effort -- I'd be delighted to show you all how to help update the CT data directly. – SJ + 04:12, 27 March 2020 (UTC)
@Seatto23: Have you managed to get the new table working yet? cognaso (talc) 01:28, 25 March 2020 (UTC)
Semi-protected edit request on 27 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
Hello. I have been watching this table regularly. Is it possible, and would it be beneficial, to bold the highest count for a single day for each state. Furthermore, to show trend, is it possible to color in the cells; for example, as the number goes higher from its peak, the more red shade the cells become, and vice versa, the shade goes towards sky blue. SEKKDS (talk) 13:45, 27 March 2020 (UTC)
- Not done for now: please establish a consensus for this alteration before using the
{{edit semi-protected}}
template. Goldsztajn (talk) 12:39, 28 March 2020 (UTC)
Semi-protected edit request on 27 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
The March 26th data shown for Florida is the midday number. The total number of new cases for Florida as of the 6PM update was 507, bringing the total number of cases in Florida to 2484. [1] Larsonwe (talk) 13:33, 27 March 2020 (UTC)
References
Semi-protected edit request on 27 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
The Florida Dashboard I've referenced in my previous edit requests has been reformatted and no longer includes non-residents that are in the state and have tested positive. To find the total number of people in the state that have the virus you need to go to the Florida Health Newsroom [1]. Larsonwe (talk) 14:23, 27 March 2020 (UTC)
References
- Already done Florida Dashboard is showing resident and non-resident totals on checking 28 March UTC12:39. Goldsztajn (talk) 12:48, 28 March 2020 (UTC)
Semi-protected edit request on 25 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
I would like to add in % change in daily cases by state to the table.
Good health, Margreth Mmpossi (talk) 02:24, 25 March 2020 (UTC)
- I would oppose that, as I think these tables are for raw data (mostly not intended for immediate consumption by the reader), and daily relative changes are calculated from the raw data. The tendency is that the calculated information becomes burdensome and gets neglected and becomes inaccurate as the raw data gets added and corrected. The daily relative changes can be found in the individual state charts (e.g. Template:2019–20 coronavirus pandemic data/United States/Washington State medical cases chart) derived from the present table.CountMacula (talk) 12:58, 25 March 2020 (UTC)
- I agree, summations are about the most we want to maintain - even summations are not easy with many editors. Things will get out of date and askew quickly. dudzcom (talk) 23:03, 28 March 2020 (UTC)
- Not done for now: please establish a consensus for this alteration before using the
{{edit semi-protected}}
template. Goldsztajn (talk) 12:30, 28 March 2020 (UTC)
Semi-protected edit request on 30 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
The Florida data for March 29th is incorrect. The number shown in the table is the number of full time Florida residents that have the virus. However, it leaves out the 182 people that are not full time residents of Florida but are here and have the virus. If you don't include the "snowbirds" to Florida in the count you are leaving out an important portion of the statistics because they won't be counted anywhere else. This link shows the full picture of Florida for March 29th. [1] Please correct this. Larsonwe (talk) 11:01, 30 March 2020 (UTC)
Semi-protected edit request on 28 March 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
The number of cases and deaths for the U.S. Territory of Puerto Rico have not been entered for the date of MArch 27, 2020. At https://estadisticas.pr/en/covid-19 , as of 2:06 AM EDT, the numbers of cases and deaths are shown as 79 and 3, respectively. Using these numbers and subtracting these from the displayed totals for PR, should yield new cases of 15 and new deaths of 1, both of which are deduced to have occurred on March 27. NStab1979 (talk) 06:13, 28 March 2020 (UTC)
Running total for deaths in Non-repatriated COVID-19 cases in the US by state correction
row: Mar 24, column: Deaths Cml = 673
row: Mar 25, column: Deaths New = 226
row: Mar 25, column: Deaths Cml = 898 (should be 899)
— Preceding unsigned comment added by 63.231.181.54 (talk) 08:50, 26 March 2020 (UTC)
- These numbers appear to be out-of-date now. If any of the individual states' data for those dates is incorrect, please point it out. Thanks. Mark Taylor (talk) 04:02, 31 March 2020 (UTC)
Death counts in the cases table leads to errors.
The daily and cumulative deaths are listed in both the cases and deaths tables, and the counts do not agree. Yesterday I took care to update Template:2019–20 coronavirus pandemic data/United States medical cases chart to match the cases table, not noticing the deaths table. Now I see that there is a table of deaths and that the two tables do not match. Why is this information duplicated (or should I say mangled or mutated)? If the death counts are not maintained correctly in the cases table, they should be removed. They are not maintained correctly, and that led to introducing errors into Template:2019–20 coronavirus pandemic data/United States medical cases chart and who knows where else. Can we remove the death counts from the cases table? CountMacula (talk) 13:22, 24 March 2020 (UTC)
- I believe the discrepancy occurs with the summation at March 20. The daily total should be 55. When the sum of 55 on that day is corrected, the cumulative numbers align correctly on the Reported Deaths table. This needs to be confirmed and reconciled with the upper template (of reported cases), which still shows a different total (51 instead of 55). --130.76.24.7 (talk) 15:33, 25 March 2020 (UTC)
- Someone has taken care of this. Mark Taylor (talk) 04:03, 31 March 2020 (UTC)
West Virginia deaths
Although no deaths have been reported from West Virginia, it is absent from the deaths template. Infinite mission (talk) 21:09, 27 March 2020 (UTC)
- Someone has taken care of this now. Mark Taylor (talk) 04:03, 31 March 2020 (UTC)
Washington State Department of Health has issued no reports for over two days
The Washington DOH web page at https://www.doh.wa.gov/Emergencies/Coronavirus states "Please note that we have shifted our reporting process to make it more accurate, timely and complete. We are reporting confirmed cases, laboratory tests and deaths as of the previous day at 11:59 pm PT." To the contrary, they have stopped all reporting of case and death numbers for over two and a half days. The last report was 4,896 cases and 195 deaths as of March 28 (Saturday) at 11:59pm PT. What is going on? Why have they stopped reporting? We can't produce an overall count for the nation without a report from Washington. Mark Taylor (talk) 20:59, 31 March 2020 (UTC)
- I see they have just posted an explanation on their page: https://www.doh.wa.gov/Portals/1/Documents/1600/coronavirus/DelayDataPosting.pdf Mark Taylor (talk) 21:07, 31 March 2020 (UTC)
Regions
Thanks for overhauling. I'd suggest removing mention of West/Midwest/South/Northeast and just displaying the states alphabetically. Region seems irrelevant. ---Another Believer (Talk) 20:52, 2 March 2020 (UTC)
I like sorting the states by region. Alphabetical is not relevant to the spatial spread and hides patterns (like more spread in West). Seatto23 (talk) 20:16, 4 March 2020 (UTC)
- Would US territories (i.e. Puerto Rico, USVI, Guam, CMNI, American Samoa) go in a separate group when/if they get their first cases? CrazyC83 (talk) 18:25, 10 March 2020 (UTC)
- Is there a wiki tool that can visualize this data in a map?Some thing (talk) 23:06, 2 April 2020 (UTC)
Recovery count
I noticed that there is currently no count of recoveries on this template, and thus no recovery count on the US pandemic page. Are there any official sources for recoveries in the US? (I can't find any count of recoveries on WHO, CDC, or local reports.) cognaso (talc) 01:43, 20 March 2020 (UTC)
- I think there should be a standard whereby recoveries should only be reported if they are tested negative because symptoms alone have been found to be false signs of recovery. A lot of states arn't reporting recoveries at all.Some thing (talk) 23:09, 2 April 2020 (UTC)
Semi-protected edit request on 5 April 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
There is a blank for the number of cases in DC on April 2, 2020. The correct entry is 104 (incorrectly posted in the April 3 cell). The correct entry for April 3 is 145 (incorrectly posted in the April 4 cell). The correct entry for April 4 is 96. Loquitur Veritatem (talk) 21:28, 5 April 2020 (UTC)\
- Partly done: See my edit and this source. {{replyto}} Can I Log In's (talk) page 16:52, 7 April 2020 (UTC)
Response
Page has been semi-protected as requested.. Captain Almighty Nutz (Contact me EMail Me Contribs) 05:09, 6 April 2020 (UTC)
Deaths
Re deaths. How about listing the numbers as cases/deaths? That's pretty compact. I think the deaths by state info is definitely important to show. So for example the 3/4/20 (as of noon) CA number would be 2/1 (2 cases/1 death). Seatto23 (talk) 20:16, 4 March 2020 (UTC)
I haven't checked the other states, but the Georgia numbers in the death chart do not match the numbers on the Georgia COVID page (https://en.wikipedia.org/wiki/2020_coronavirus_pandemic_in_Georgia_(U.S._state)). They both reference the Georgia Department of Public Health web site but only the Georgia page seems correct because the current grand total (370) matches the number on the GDPH website for April 8 (https://dph.georgia.gov/covid-19-daily-status-report) Msigmond (talk) 05:59, 9 April 2020 (UTC)
Semi-protected edit request on 8 April 2020
The entry for the "deaths" table for MA for 2020-04-08 should be 77; currently it is blank. [1] Charliepark (talk) 00:12, 9 April 2020 (UTC)
The total number of cases for 2020-04-03 adds up to 32,525(currently 32,182). The total number of cases for 2020-04-09 adds up to 34,243 (currently 34,586). Please make these corrections.2601:240:4980:24E0:6DB1:754C:7DBD:CF93 (talk) 14:25, 10 April 2020 (UTC)
- Done. Thanks for pointing this out. dudzcom (talk) 17:55, 10 April 2020 (UTC)
Semi-protected edit request on 4 April 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
Florida data for 4/3/2020 is incorrect. The total as of the 7pm EDT update last night was 10268 confirmed cases. That is an increase of 1228 over the previous day. Source as always is [2] I think what's happening is that whoever is editing the Florida number is reporting the midday total, not the full day totals which come in at about 7PM daily. Larsonwe (talk) 13:48, 4 April 2020 (UTC)
- Note: It wasn't 1228, it was 1260. Also, it's not 7 pm, it's 6 pm. This SPER is considered Done. {{replyto}} Can I Log In's (talk) page 16:38, 7 April 2020 (UTC); edited 16:39, 7 April 2020 (UTC)
- User:Can I Log In, I just fixed numerous domino-effect errors introduced by your change when you failed to also update row totals for April 3 and later. Using the screen captures at https://covidtracking.com/data/state/florida#historical I have now updated all Florida case numbers for April to reflect the final report for each day. Mark Taylor (talk) 20:11, 10 April 2020 (UTC)
Missing end tag for <div>
@Seatto23, An Oddian, Jdlrobson, Cognaso, Rmaloney3, S.A. Julio, Rpvt, MosquitoBird11, The United States Blues, El piel, Rcul4u998, Tbhotch, Wugapodes, Larry Doolittle, Chad The Goatman, Sweecoo, Mikeblas, Jokullmusic, Matthewberns, and Redditaddict69: There is a missing end tag for a <div>
tag. lintHint does not show it when you edit the template directly, but if you use Special:ExpandTemplates and in the "Input wikitext:" box, put {{2019–20 coronavirus pandemic data/United States medical cases}}
, then click OK, lintHint shows a missing end tag starting at the top with <div class="noresize">
. This might not be the real start. I am reporting this and I leave it to those who understand this template better to fix it. Please see WP:Linter for info on how to install lintHint. —Anomalocaris (talk) 06:58, 20 March 2020 (UTC)
- Anomalocaris, it's there. I've marked it in the HTML with a comment. The Template is long so I suspect something (maybe an inbalanced template?) is preventing it from applying? I'm not seeing it flagged by the w3c validator - but there is a lot of noise there due to much bigger issues with the HTML :) Jdlrobson (talk) 16:58, 20 March 2020 (UTC)
- Jdlrobson: Thank you for getting back to me. I see the markup
<!--end noresize --></div>
, but I suspect that the</div>
tag belongs earlier. The opening<div>
tag is right after<onlyinclude>
, so shouldn't the</div>
tag be just before the next</onlyinclude>
? I would do it myself, but again, I want to leave it to those who understand the template better. —Anomalocaris (talk) 18:52, 20 March 2020 (UTC)- Done. I fixed this when I saw the error in the template several weeks ago. I did not know that this talk section was created. This Talk Section can be disregarded/archived. dudzcom (talk) 23:32, 13 April 2020 (UTC)
- Jdlrobson: Thank you for getting back to me. I see the markup
Possibly. Will wait for someone to chip in... Jdlrobson (talk) 00:32, 21 March 2020 (UTC)
Region-State heading before first of each month
Is it possible to not display intermediate Region-State headings at the start of each month in the historical "By State By Date" table. Alternatively could the "By State By Date" table be displayed without intermediate first of month Region-State headings using another URL?
Reasons for this request:
- Region-State heading makes it visually harder to vertically scan columns for historical trends.
- Parsers/Post-processors of this table have a more challenging time parsing this table.
Morebits (talk) 00:11, 20 April 2020 (UTC)
Semi-protected edit request on 15 April 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
Nevada deaths for March 13 and 14 are incorrect. Per state reporting as of March 13 there were 120 deaths, March 14 there were 130 deaths. No one input the deaths for April 34 for Nevada, leading to April 14 being incorrect. 71.218.250.35 (talk) 01:24, 15 April 2020 (UTC)
- Not done: it's not clear what changes you want to be made. Please mention the specific changes in a "change X to Y" format and provide a reliable source if appropriate. Aasim 10:17, 25 April 2020 (UTC)
Semi-protected edit request on 15 April 2020
This edit request to Template:2019–20 coronavirus pandemic data/United States medical cases has been answered. Set the |answered= or |ans= parameter to no to reactivate your request. |
Florida Deaths are incorrect for April 8 and 9th. Someone forgot to input the evening update for Florida on the 8th and just added it to the 9th. Florida April 8 deaths should be 27, and April 9th should be 48.
https://floridadisaster.org/globalassets/covid19/dailies/covid-19-data---daily-report-2020-04-08-1702.pdf
https://floridadisaster.org/globalassets/covid19/dailies/covid-19-data---daily-report-2020-04-09-1654.pdf
Mid day updates from Florida should not be input since they update twice a day and should only be input after evening updates. 71.218.250.35 (talk) 01:44, 15 April 2020 (UTC)
- Not done: it's not clear what changes you want to be made. Please mention the specific changes in a "change X to Y" format and provide a reliable source if appropriate. Aasim 10:17, 25 April 2020 (UTC)
Ohio "Confirmed" or "Total" Cases/Deaths?
We have been inconsistently using Ohio's "Confirmed" or "Total" figures. We need to pick one and stick to it. Which are the more appropriate figures to use? Mark Taylor (talk) 06:32, 20 April 2020 (UTC)
- Inconsistently? I've been tracking Ohio, and we have been consistently using the "Confirmed" figure until yesterday's edit. The "Total" figure includes probably cases, which may eventually be rolled into the "Confirmed" quantity based on testing results, but isn't it premature to include it before then? Bz8x8c (talk) 11:01, 20 April 2020 (UTC)
- You're right: we have been consistently using "Confirmed Cases" and "Total Deaths" for Ohio. So I'll just correct the April 19 figure to 1353. Mark Taylor (talk) 18:31, 20 April 2020 (UTC)
Someone updated 04/22 cases for OH with "Total Cases" instead of "Confirmed Cases" earlier today. Per this discussion from 2 days ago, I changed the cases to "Confirmed" and updated the total, but another editor reverted my edit without any discussion. I'm going to change it one more time, and hopefully they will either leave it as is or contribute further to this discussion before reverting again. Bz8x8c (talk) 02:25, 23 April 2020 (UTC)
- I've added a comment next to Ohio's total confirmed cases to hopefully stop people from including probable cases in the future Poklane 02:45, 23 April 2020 (UTC)
Is this something we are doing across the board? I noticed there is a comment now for VA to put in only confirmed cases. I had previously just been putting in total cases in the past. For today, I input in the confirmed cases. The United States Blues (talk) 21:54, 24 April 2020 (UTC)
Also, the new confirmed cases of VA at Apr 26 is 586. But this table recorded 1068, which is the total cases. It's inconsistent with other numbers in VA column. — Preceding unsigned comment added by Gongminmin (talk • contribs) 16:47, 27 April 2020 (UTC)
Empty boxes in California (March 29) and Delaware (April 19)
According to Worldometers, California, on March 29, has 655 cases and 12 deaths.
Other than that, on April 19, Delaware doesn't release data and there were no cases or deaths because there was no data. Evan0512 (talk) 00:43, 28 April 2020 (UTC)
Washington State's removal of 190 cases on April 19
Today's WA total is correct at 11790, but the numbers in the WA column no longer add up to this figure, due to the numbers for April 18 and 19. Ideally we would know how many deaths on each date were reclassified so we could adjust all those past dates downward, but I doubt we will ever know those details. So if the April 18 number is to remain at 357, then the April 19 number needs to be -12. Or we could adjust the April 18 number downward to 345 and set the April 19 number to 0. But I do think the numbers should add up. Mark Taylor (talk) 06:25, 20 April 2020 (UTC)
- The third option, which I will implement shortly: We can use the known-correct number of cases for April 19, which is 178 (the April 19 total of 11,790, plus the 190 removed cases, minus the April 18 total of 11,802). Then we can subtract the 190 removed cases from the former April 18 total of 357, since that is the last date that may have been over-reported, leaving us with 167 cases for April 18. This leaves us with a known-correct total for April 19 and avoids having a negative number in the table. The Washington site has a link to table which we might be able to use to correct all the old WA case numbers through April 18, if we decide it's worth the effort: https://www.doh.wa.gov/Portals/1/Documents/1600/coronavirus/data-tables/PUBLIC-CDC-Event-Date-SARS.xlsx Mark Taylor (talk) 18:27, 20 April 2020 (UTC)
I just want to say thanks to all the editors for keeping this page as accurate as possible. This is a very helpful resource that I refer to frequently for ongoing data analysis. The daily numbers for each state are very useful. Thanks. 38.108.53.234 (talk) 03:20, 29 April 2020 (UTC)
Thousands separator in Cumulative Cases Column?
Now that the United States has passed 1m cases does it make sense to add a thousands separator to at least that column to improve legibility? — Preceding unsigned comment added by 73.17.116.158 (talk) 12:15, 30 April 2020 (UTC)
Lower total numbers than media reports
According to multiple sources, including the main wikipedia page that links to this chart, US deaths have exceeded 56,000, yet the total listed here is only ~50,000. Can this discrepancy be fixed? https://en.wikipedia.org/wiki/2020_coronavirus_pandemic_in_the_United_States https://www.cdc.gov/nchs/fastats/deaths.htm https://www.worldometers.info/coronavirus/country/us/ Craig Butz (talk) 16:47, 28 April 2020 (UTC)
- I speak only for myself but I'll give my opinion. https://www.worldometers.info/coronavirus/about/#sources states "Because national aggregates often lag behind the regional and local health departments' data, part of our work consists in monitoring thousands of daily reports released by local authorities. Our multilingual team also monitors press briefings' live streams throughout the day." I believe the same is true of the Johns Hopkins site. I don't think we have the manpower here to do anything other than track the official daily reports from state departments of health. Also, sticking with the official reports gives us some consistency which allows users to watch for trends, and for those users, a sudden change in the way we collect data would not be welcome. That necessarily means some lag in the numbers, but it also means that there is less dispute about what the numbers should be here each day, and with a distributed effort like this, I think it's the best we can do. And it's worth noting that it's basically the same philosophy used by the much larger effort at https://covidtracking.com/data/us-daily Mark Taylor (talk) 15:47, 30 April 2020 (UTC)
- Some websites and pages include probable cases because some cities or states include those, such as New York City including nearly 6,000 people who have COVID-19 as cause of death on their death certificate without ever being tested for the virus. This template only includes confirmed cases unless states don't make a separation between confirmed and probable cases. Poklane 00:30, 1 May 2020 (UTC)
Formatting
May I suggest bold-facing the entry for each state that is the high-water mark (maximum number of cases/deaths)? That would make it easier to identify where we are relative to the peak. — Preceding unsigned comment added by 23.28.238.136 (talk) 14:26, 9 May 2020 (UTC)
May 10 Indiana Case Update
In updating cases and deaths today, I ran into a question with Indiana (IN) case data. The Indiana reporting page shows a daily new case count and a total cases count, but their total cases number was higher than the previous total on this article page plus their new daily count number. I'm not sure why they didn't match up, but I entered their daily count value and their total cases value on this article. If someone has a clear view of the Indiana data, please feel free to correct the entered values appropriately. Bz8x8c (talk) 01:38, 11 May 2020 (UTC)
Here's the values I'm seeing...
Previous total on this page: 23,732
From https://www.coronavirus.in.gov/
New Positive Cases: 402 Total Positive Cases: 24,126
23,732 + 402 = 24,134 instead of 24,126 from the reference site. I treated their total cases number as correct, but I wasn't sure whether to use their daily number(which is what I did) or calculate the daily number from the old and new total cases value. (Sorry I misstated the direction of difference, as their total cases value is less than the computed total rather than more.) Bz8x8c (talk) 02:00, 11 May 2020 (UTC)
- We generally ignore state-reported "new cases" figures and just go with the total. In this case, the Indiana officials might have discovered that a few earlier cases were erroneous, so they reduced their total before adding their new cases for the day. Mark Taylor (talk) 22:42, 11 May 2020 (UTC)
Minnesota Case Counts
Just to let everyone know, the Minnesota Department of Health removed 8 cases of COVID-19 this morning(due to either counting of cases not residing in the state, duplicate cases, or false positives). I need to know how to insert notes into the graph.— Preceding unsigned comment added by Rube Dali, the DodoHorse (talk • contribs) 12:29, 13 May 2020 (UTC)
- I see you figured out how to insert the note. However, I also see you added the 8 cases back into the daily new case count. In all other previous instances where states have done this, the removed cases are subtracted from the daily count in order for the math on totals to work out, even though the MN site does not subtract them from the new case count for the day. I don't think MN should be treated any differently than how this has been handled on all other states where this has occurred. Please consider re-removing these 8 cases from today's daily count so the previous day's total plus new cases today equals the new total. Bz8x8c (talk) 02:28, 14 May 2020 (UTC)
- Now that the totals have been added to May 13, we have mismatched numbers. The total of the May 13 cases row is now shown as 20557, with a new grand total of 1380763 shown next to it and also to the right of the state's totals row. However, the sum of the state's totals row is actually 1380755, which is 8 less than the grand total shown due to the 8 removed cases in Minnesota. I think the 8 cases needs to be removed from the Minnesota daily count, changing 431 to 423 and changing the daily total from 20557 to 20549. This would bring the numbers into agreement. Anyone else have an opinion? Bz8x8c (talk) 11:36, 14 May 2020 (UTC)
- For reference, you can read my discussion with Mark Taylor in the previous section above regarding the same situation in Indiana on Monday. Bz8x8c (talk) 11:39, 14 May 2020 (UTC)
Blank cells
Do the blank cells indicate no data was released for that day, or that no cases were reported? If the former, maybe a – would be appropriate (unless that messes up off-wiki data handling)? For the latter, maybe 0 should be put in to indicate the state did issue a report for that day but the total indicated no change in case number. This would distinguish Kansas's awful MWF reporting from instances where 0 new cases were actually reported. JoelleJay (talk) 22:08, 18 May 2020 (UTC)
- I have thought the same thing, but I have just continued to use the existing convention in my updates to the data. I'd be interested in whether this has been previously discussed here or elsewhere that provides guidance on the current approach. Bz8x8c (talk) 23:34, 19 May 2020 (UTC)
Incorrect Washington state data
According to Washington state department of Health,[3] Apr 16's total confirmed case is 11152, which is 369 new cases. But in this table, 369 is separated to 280 to Apr 16, and 89 to Apr 17. — Preceding unsigned comment added by Gongminmin (talk • contribs) 23:49, 17 April 2020 (UTC)
References
More Generally, on Washington Data Issues
There seems to be an ongoing and significant discrepancy between the per-day new washington state case counts shown in the table on this page, and the data from the Washington Department of Health (WSDOH -- see the epidemiologic curves tab of this page dashboard: https://www.doh.wa.gov/Emergencies/NovelCoronavirusOutbreak2020COVID19/DataDashboard).
My guess is that the root cause of this issue is that each day that passes, WSDOH adds X new cases to the total on the site, but they assign each new case to the day the case was reported to a health provider, which is often _not_ the day that the case made it to the WSDOH web site. For example, if 50 cases were lost in a filing cabinet for 3 weeks, and then were found and made their way to the DOH site on May 23, the total case count on the WSDOH would go up by 50 "extra" cases, but the May 23rd count would not see a 50 case bump. The 50 cases would be assigned to their original days of illness reporting.
I figure the numbers on this page don't correctly account for the above, because the numbers on this page are built purely from the daily totals. (subtracting yesterday's WSDOH total from today's) This is just my assumption, as I don't fully understand the methodology being used here. (yet)
Assuming I'm right, the correct fix would be to update every day's value for washington state, every day that passes. So on May 23rd, update every day from the beginning of the epidemic through May 23rd. Then on May 24, do the same thing again. This is obviously very labor intensive, and becomes more so as time passes... but it's necessary for the data to be correct. (assuming WSDOH is the best version of correctness, which I believe it is) Ideally it could be automated.
I feel that the correctness of this data is particularly important because google is using it for the graph of cases-over-time that they show on their search results page. (when you search for "washington covid cases")
Theotayo (talk) 08:07, 24 May 2020 (UTC)
I don't think the epidemiologic curves is the one we should put into wikipedia. We record cases when they are confirmed, but epidemiologic curves is about cases when they were onset. They meant to be different. gongminmin (talk) 6 June 2020