Jump to content

Template talk:COVID-19 pandemic data/United States medical cases by state/Archive 1

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
Archive 1

Template-protected edit request on 26 March 2020

Update Virginia numbers, per http://www.vdh.virginia.gov/coronavirus/

cases = 391
deaths = 9
remove ref to outdated (March 20) resources — HipLibrarianship talk 02:57, 26 March 2020 (UTC)
{done} Bucketsofg 21:17, 26 March 2020 (UTC)

Template-protected edit request on 26 March 2020

The death count for New Jersey should show 62 in the states table. It currently shows 0, which is wrong. Look at the New Jersey page, it has the correct number of deaths caused by the virus. 173.63.78.194 (talk) 03:30, 26 March 2020 (UTC)

 Done Bucketsofg 16:28, 27 March 2020 (UTC)

Template-protected edit request on 26 March 2020

Switch Deaths and Recoveries in table. Puddyglum (talk) 05:07, 26 March 2020 (UTC)

I've corrected that before, but this smart guy @StayingClean: reverted my edit. Thinking it's the right thing to do.—SquidHomme (talk) 08:04, 26 March 2020 (UTC)

Oh. Did I undo your edit @SquidHomme:? Sorry about that. I didn't know you were trying to correct the deaths and recoveries chart. I just saw it as deaths first then recoveries. So I thought the IP changed it again. So I tried to revert his but I accidentally reverted yours. Sorry. StayingClean (talk) 14:45, 26 March 2020 (UTC)

Ok @StayingClean:, can you revert back again or even better to correct it? This page has been decoupled from its main article due to inaccuracies, so please fix it.—SquidHomme (talk) 20:04, 26 March 2020 (UTC)
 Done I think this is all fixed now. Bucketsofg 21:18, 26 March 2020 (UTC)

Template-protected edit request on 26 March 2020

Deaths and recoveries in Minnesota are the wrong way round. Ie There has only been 1 heath in Minnesota not 122 as is showing Graemec2 (talk) 10:21, 26 March 2020 (UTC)

I think the problem may be that the two headers are wrong. (It is not only Minnesota.) Bucketsofg 13:08, 26 March 2020 (UTC)
New York is the wrong way around, too. I'm going to swap the two headers and then work my way through the data. Bucketsofg 13:09, 26 March 2020 (UTC)
Strike that; I've started through the list, correcting the figures for deaths and recoveries, which have been swapped all the way through. I have fixe about half. I will consider later. Bucketsofg 13:37, 26 March 2020 (UTC)

>>Please see my talk "Template Death numbers incorrect" above. SWP13 (talk) 15:13, 26 March 2020 (UTC)

Template-protected edit request on 26 March 2020

Change Utah's active cases from 345 to 401 as per source. Smachable (talk) 20:15, 26 March 2020 (UTC)

Done (though 402 now). Bucketsofg 21:12, 26 March 2020 (UTC)

Semi-protected edit request on 27 March 2020

Please edit the Cases and Deaths portion of the table in regards to Tennessee. Cases should now be 1203 and Deaths should now be 6. Recoveries are not currently tracked by TNDoH so I'm unsure if it needs to be updated or not. The website for the Tennessee Department of Health's CoVID-19 public information page is [1] . Thank you. DHammon7 (talk) 19:32, 27 March 2020 (UTC)

References

  1. ^ https://www.tn.gov/health/cedep/ncov.html

 Done--Goldsztajn (talk) 22:00, 27 March 2020 (UTC)

Template-protected edit request 28 March 2020

Please update the "Current number of non-repatriated cases by state" list. Tennessee's "Active" cases does not properly reflect the actual number. The "Cases" and "Deaths" portion is correct per the TN Department of Health. Recoveries are not currently tracked but the "Active" portion is undercounting by over 900 cases even if the 15 recoveries listed are accurate. DHammon7 (talk) 11:48, 28 March 2020 (UTC)

 Done Bucketsofg 18:13, 28 March 2020 (UTC)

Thank you. DHammon7 (talk) 16:11, 29 March 2020 (UTC)

Template-protected edit request 29 March 2020

Please update the State Cases template to reflect the new numbers in Tennessee. Cases-1537 Deaths-7 Recoveries-15 (not verified by TN Doh) Active- 1515 (including the unverified 15 recoveries) Thank you very much. DHammon7 (talk) 19:29, 29 March 2020 (UTC)

 Done Bucketsofg 20:27, 29 March 2020 (UTC)

Semi-protected edit request on 31 March 2020

Please update Tennessee. The state now stands at 2239 Cases, 23 Deaths, and 121 Recoveries. This would make 2095 Active Cases. Thank you. [1] DHammon7 (talk) 19:49, 31 March 2020 (UTC)

 Done Justatrainguy (talk) 20:53, 31 March 2020 (UTC)

References

  1. ^ . Tennessee Department of Health https://www.tn.gov/health/cedep/ncov.html. Retrieved 31 March 2020. {{cite web}}: Missing or empty |title= (help)

Semi-protected edit request on 1 April 2020

Change Vermont cases to 321, and Vermont deaths to 16. Source: https://www.healthvermont.gov/covid CoronaVT (talk) 21:02, 1 April 2020 (UTC)

Semi-protected edit request on 2 April 2020

Change Indiana Cases count to 3,039 and Deaths to 78 Reference: https://coronavirus.in.gov/ 96.230.251.50 (talk) 14:24, 2 April 2020 (UTC)

 Done Mdaniels5757 (talk) 19:06, 2 April 2020 (UTC)

Semi-protected edit request on 2 April 2020 (Vermont info)

Change Vermont cases to 338, and Vermont deaths to 17. Source: https://www.healthvermont.gov/covid CoronaVT (talk) 18:03, 2 April 2020 (UTC)

 Done Mdaniels5757 (talk) 19:03, 2 April 2020 (UTC)

Location of table

I think this table should go at the beginning of the article; many readers who check this page are also monitoring the case load in particular states. It would also be more thematically consistent with the global pandemic page. JoelleJay (talk) 17:16, 19 March 2020 (UTC)

I agree -- @JoelleJay: could you mention this on the main article page? Bluegreenmagenta (talk) 17:22, 19 March 2020 (UTC)
I've added a short cut to this section on the main page. Hopefully that'll solve the problem. Stylteralmaldo (talk) 19:35, 20 March 2020 (UTC)

DO NOT USE worldometers.info coronavirus statistics

Please see RSN discussion and hold off on using. Instead, use officially reported cases according to the state department of health or the CDC, which are WP:MEDRS compliant. It's unclear how worldometers.info is coming up with higher numbers of cases before they're even officially reported. buidhe 19:30, 21 March 2020 (UTC)

Agreed -- this table should rely on official state numbers whenever possible, and verifiable numbers when that's not an option Bluegreenmagenta (talk) 20:07, 21 March 2020 (UTC)
The sources are at the bottom of the page. They look okay to me. This is a WP:TERTIARY source. Richard-of-Earth (talk) 23:14, 21 March 2020 (UTC)
Agreed, Ohio's "Active cases" and "recovered cases" is suspicious -- Ohio Department of Health isn't reporting either number, and the worldometers is giving the ODH as their source for the information. I think worldometers may be simply doing arithmetic, which is bogus, and if we're doing simple arithmetic too, we should stop. The Ohio department of health is only reporting cumulative confirmed cases and deaths. The reporting for Ohio as of now should be 442 cases, 6 deaths, and unknown active/recovered. --valereee (talk) 10:24, 24 March 2020 (UTC)

Questions on Official Sources for Confirmed Cases

Questions on Official Sources for Confirmed Cases

For those of us that have been updating pages with the confirmed cases (active, recovered, and deaths), should we include all official sources?

For example, I have mainly been updating 2020 coronavirus pandemic in Illinois and sticking to the Illinois Department of Public Health's official numbers that come out daily. However, their information is typically a day behind the local county health departments official numbers. Should we include both the local and the state numbers?

Thoughts? — Mr Xaero ☎️ 09:51, 25 March 2020 (UTC)

Recovery

I doubt the recovery column is paid close attention to. Either by those viewing, those updating, or official publications. Suggest deleting it. Daniel.Cardenas (talk) 13:24, 21 March 2020 (UTC)

Suggest that "Cases", "Deaths", and "Recoveries" be the table entries, while getting rid of "Active" (a weird term I don't see on any other national chart).--2601:444:380:8C00:8D51:655A:9587:599 (talk) 14:14, 21 March 2020 (UTC)

As weeks pass and recoveries become a larger proportion of the number of cases (e.g. look at South Korea) the number of active cases will be the number people really want to see. This is also the number which should really be being used to compute percentages to see how actively the virus is spreading. Also, recoveries to deaths is the long term measure of lethality. Right now, in the absence of sufficient testing in many places, the recovery and death numbers are very good indications of how accurate the date are. Recoveries is also our only gauge of the duration of the illness caused by this virus. Automeris (talk) 14:22, 25 March 2020 (UTC)

Possible Error - New York state data in US case chart by State

      • Hello fyi, it's possible that the number of New York state Deceased & Recovered patients is reversed in the table which lists total cases by state for the US (specifically, 285 deceased and 108 recovered appear as 108 deceased and 285 recovered)...but pls disregard if the data is correct and I just misread the table, thx - Paul S. (end of comment) *** — Preceding unsigned comment added by 2601:403:281:1890:28FA:6F4:5E5A:AE19 (talk) 22:15, 25 March 2020 (UTC)

Cases in the US by state template total

Currently the template's cases do not add up to the total at the top (3487, the official CDC number). Should the total be the official CDC count and mismatch the rest of the template or should it be the total of every state's cases? This would bring the total to above 4200. BloopyBloop (talk) 15:33, 17 March 2020 (UTC) (Copied from Talk:2020 coronavirus pandemic in the United States by Bluegreenmagenta (talk) 16:03, 17 March 2020 (UTC))

This was my doing -- I mimicked the similar data table on the global page. They are using the WOMC figures for their totals (not the sum of the number of cases). This template is currently using the CDC stats for the totals. I would be in favor of keeping it this way since the nature of the CDC's response is to aggregate all of the state-by-state stats and thus they likely have a more accurate number than we do. As always, I'm open for discussion. Bluegreenmagenta (talk) 16:03, 17 March 2020 (UTC)
Newcomer here so apologies for any failures of custom. The current number reported for NY is 5711. This value comes from 1point3acres.com but it appears that this number is an extrapolation. The official number out of NY state testing is 4152 but it was last updated at 1:20pm EDT March 19. As a result, the tally for US total does not match the state total. Is there an established best practice here? Is it possible for us to highlight to the reader which numbers are official and which numbers are extrapolations? And for official numbers, it would be nice to make a note when they are out of date and subject to change. Toppsdown (talk) 13:49, 20 March 2020 (UTC)
83 now dead in Washington State! [1] Please open this template to editing by registered users so it can be updated more frequently. Arrecife (talk) 23:01, 20 March 2020 (UTC)
Mississippi Department of Health Website[2] shows 377 cases and 5 deaths. They do not list recoveries. Please update. DrHenley (talk) 00:59, 26 March 2020 (UTC)

References

  1. ^ https://www.doh.wa.gov/emergencies/coronavirus
  2. ^ https://msdh.ms.gov/msdhsite/_static/14,0,420.html

Deaths/recoveries are messed up

Someone decided to edit the template a day or so ago without checking what they were doing, so the numbers are messed up. Check the revert by Squeaky Clean I believe. I’m on mobile and have no time to mess with it to figure out what’s going on — Preceding unsigned comment added by 2601:601:CB7F:8B00:D2E:CDDB:9D3E:1AE7 (talk) 23:19, 25 March 2020 (UTC)

Yes, there is something wrong here. Might it be the headers for 'deaths' and 'recoveries' have been inverted? Bucketsofg 03:44, 26 March 2020 (UTC)

>>I found the error. See "Template Death numbers incorrect" below.SWP13 (talk) 04:48, 26 March 2020 (UTC)

Error: Minnesota

Both Minnesotas death count and recovery count are wildly off. Possibly flipped, although I am not able to find any sources for recovery count myself. Firestar32 (talk) 04:56, 26 March 2020 (UTC)

I've fixed this. Bucketsofg 16:06, 26 March 2020 (UTC)

Template Death numbers incorrect

Hi all, @SquidHomme:, @Bucketsofg:, @Puddyglum:, @Bluegreenmagenta:, @Another Believer:,

At first, I noticed that Washington death number at Template:2019–20 coronavirus pandemic data/United States medical cases by state is incorrect. After looking at the history, I noticed User:StayingClean changed the column order. It should be U.S. state or territory, Cases, Recov, Deaths. |See Mar 25 15:46 diff here. That means numbers entered after this time could be in the wrong column. After it is fix, please add comment to Wikipedia talk:WikiProject COVID-19

Thanks, SWP13 (talk) 04:37, 26 March 2020 (UTC)

I know right? I've corrected that before, but the smart guy @StayingClean: reverted my edit. Better read first before reverting someone's edit, don't you think?—SquidHomme (talk) 08:02, 26 March 2020 (UTC)

>>Hi all, Perhaps you can agree to revert back to the correct column title as U.S. state or territory, Cases, Recov, Deaths. Then review and update. SWP13 (talk) 16:00, 26 March 2020 (UTC)

Sorry, all, but I've been swapping all the data from the columns and am about half done. It would probably be easier to have swapped the column titles, but the data would probably soon get corrupted anyway, given that the most natural order (at least in my head) is cases, then deaths, then recoveries (which is probably the least reliable number). I'm going to finish this, but if you have strong feelings the other way and a consensus develops around it, I'm happy to be reverted. Bucketsofg 16:09, 26 March 2020 (UTC)
Just swapping the columns doesn't, unfortunately, reflow all of the data. Per world chart template precedent, the column order listing should be cases, deaths, recoveries, (then any other columns). Recovery numbers are also less timely in coming, with spotty data.--2601:444:380:8C00:1098:6BD:4FAC:7DD6 (talk) 18:02, 26 March 2020 (UTC)

>>@Bucketsofg:, Please do what you need to do, but please ensure the data is flowing correctly down to the lower level template. IMHO, I still think you want to revert the columns if it's easy enough. Thanks, I'm off doing something else. SWP13 (talk) 16:22, 26 March 2020 (UTC)

Remove recoveries and active cases, add hospitalizations and number of tested

Most states are not reporting recoveries and active cases, but people are adding them anyway despite lacking an RS for them. Many states however are reporting hospitalizations and the number of tests run, so either of those numbers could be added depending on how useful they are deemed to be. buidhe 21:40, 29 March 2020 (UTC)

Google's COVID stats sidebar, with data from Wikipedia

Hi all – wanted to give you a heads up that Google is using several template pages (as of this writing, this template and Template:2019–20_coronavirus_pandemic_data) to create a statistics table/visualization that appears at the top of Google search results for COVID-related terms. You can see a screenshot of this to the right or see it in action by Googling "covid," "corona," "coronavirus," etc. This isn't a formal partnership between the Wikimedia Foundation and Google (Google made the decision to use this data on their own), but we're communicating about the feature and their upcoming plans for it. As the community gathers more granular stats on cases, deaths, and recoveries, Google is interested in potentially making use of these additional pages to expand the feature.

I'm cross-posting this notice to the talk pages of the relevant templates and T:WikiProject COVID, and I'm watching this page and other COVID content via my volunteer account. If there's a new discussion about moving, deleting, or making major changes to the structure of this template, I'd super appreciate a quick ping either to this account or my volunteer one so I can let the folks at Google know and they can adjust where the feature points accordingly.

If you have any questions about this, please let me know! MPinchuk (WMF) (talk) 15:18, 30 March 2020 (UTC)

Archiving...

Resolved

OneClickArchiver is sending sections to Template talk:2019–20 coronavirus pandemic data/Archive 1 (see page history).

1) Is this ok?

2) How can this be fixed, if needed?

Thanks, ---Another Believer (Talk) 15:10, 28 March 2020 (UTC)

Another Believer, this was ok but not ideal, it should be fixed now. Mdaniels5757 (talk) 19:12, 2 April 2020 (UTC)
Mdaniels5757, Thanks! ---Another Believer (Talk) 20:46, 2 April 2020 (UTC)

Recovered cases not always reported

In Massachusetts, at least, the daily state reports at mass.gov do not include a number for recovered cases. The table currently shows 1, but that is misleading. Given how many zeros are in that column, I suspect many other states are not reporting this data as well. Also there is a footnote iii ' "–" denotes that no data is currently available for that state, not that the value is zero.' which is obsolete. The symbol "–" does not appear in the chart anymore. Maybe we should replace that footnote with a symbol that could be added after each state's recovery number if that number is not being regularly reported. --agr (talk) 15:14, 25 March 2020 (UTC)

Yet another reason that Recoveries should be relegated to the third column.--2601:444:380:8C00:4C68:90B4:F64F:46B6 (talk) 21:06, 25 March 2020 (UTC)
"Total of individuals who have completed monitoring (no longer in quarantine)" isn't a count of "recovered" positive cases. — Preceding unsigned comment added by 73.249.134.186 (talk) 22:12, 31 March 2020 (UTC)
Massachusetts is reporting number hospitalized. That might be more useful than recovered if other states are reporting that too.--agr (talk) 22:07, 25 March 2020 (UTC)

Any major objections to remove active cases, and replace with hospitalizations?

Data for hospitalizations is available for 8 out of 14 states where I have checked the state's official data page. 

Zygerth 02:40, 1 April 2020 (UTC)

Remove active cases, and replace with hospitalizations

Most states are not reporting active cases, but people are adding them anyway despite lack of a primary source. Many states are reporting hospitalizations so those numbers should be added. A major goal of the lock down orders is to prevent the hospitals from being overwhelmed. Recommend recoveries or total released be kept as there are states that still report this. If state data has multiple fields for hospitalizations, it is recommended to use the Cumulative Number of Hospitalized Cases of COVID-19Zygerth 22:40, 30 March 2020 (UTC)

Zygerth, Go a head and do it! No one has objected yet. buidhe 05:45, 1 April 2020 (UTC)

I also posted the above on the US cases talk page. There was one objection of removing Active cases, but none to add the new column. So the hospital column has been added. This tracks state reported hospitalizations, and cumulative hospitalization are preferred if that data is provided. Zygerth 23:58, 1 April 2020 (UTC)

Recovered cases not sorting properly

"Recovered cases" is not sorting properly; Massachusetts' 1,655 recoveries seems to be sorting as 1.655. The coding of this table is beyond me, so I don't know how to fix it... Grutness...wha? 16:32, 1 April 2020 (UTC)

Recovered, Hospital, and Active columns when sorted are treating a comma as a decimal point. How to fix it is also beyond what I know about the coding. Edknol (talk) 04:00, 3 April 2020 (UTC)

Data on most-trafficked COVID stats in Google + sneak peek at stats card roadmap

tl;dr, Google is sharing some data with the community about which stats they're showing/planning to show, and which stats Google searchers are looking for most. Please see Wikipedia_talk:WikiProject_COVID-19#Data_on_most-trafficked_COVID_stats_in_Google_+_sneak_peek_at_stats_card_roadmap for more details if you're interested! MPinchuk (WMF) (talk) 17:07, 3 April 2020 (UTC)

Hospitalization column

Someone just added a new Hospital column to record number of hospitalizations. I have a couple concerns with this:

  • Does it refer to total hospitalizations or current hospitalizations? Are the state websites clear about which one they are reporting?
  • We seem to be struggling to keep this table up to date as it is. Adding a new column to maintain may make that worse.

Kaldari (talk) 02:51, 2 April 2020 (UTC)

I agree. What agency would supply these up-to-date numbers of hospitalization for every state? I doubt each state tracks this info. This would be erratically updated. It should be removed. Liz Read! Talk! 02:59, 2 April 2020 (UTC)

This tracks the state reported cumulative covid-19 hospitalizations. Hardy any State report Active cases and far less than half report recovered. More than half of the states report cumulative hospitalizations. Most the data is already pulled from official state websites as primary sources. See references. Updating is a valid concern. I ask that you give it 48 hours from now, and see how it does. As its new, folks will catch on quick. Zygerth 04:55, 2 April 2020 (UTC)

The column doesn't sort on a numeric value, it seems to be alphabetically sorted. Phecht7 (talk) 16:40, 2 April 2020 (UTC)

Yes. Recovered and Active have been broken for quite a while too. Looks like an issue in the parent template. We could remove the commas from those column until the master template is fixed or changed. Anyone else know how to fix these 3 columns? Zygerth 21:01, 2 April 2020 (UTC) — Preceding unsigned comment added by Zygerth (talk • contribs)

Sorting now working by using nts on large numbers with commas. To have it sort like cases does would require a change to the base template. Zygerth 23:38, 4 April 2020 (UTC)

Flags

Can we please leave the flags in place? It is much easier to read/access on a mobile device this way. - Knowledgekid87 (talk) 03:50, 5 April 2020 (UTC)

Font size

Should we have it big or small? I've seen it fluctuate back and forth in the past few days and it's rather annoying. -- Veggies (talk) 01:41, 7 April 2020 (UTC)

I prefer small. Every time I load the page, I think I've accidentally zoomed in. Justatrainguy (talk) 21:12, 7 April 2020 (UTC)
Furthermore, the people at the parent template seem to have consensus. Justatrainguy (talk) 21:29, 7 April 2020 (UTC)

Massachusetts Recoveries

Massachusetts is not reporting recoveries. The data that is being put into the template is from a wrong interpretation of Massachusett's COVID website. The data is coming from the "Total of individuals who have completed monitoring (no longer in quarantine)" section of https://www.mass.gov/info-details/covid-19-cases-quarantine-and-monitoring but this number reflects the DPH's tracking of individuals that they ordered to be quarantined and monitored, regardless of testing status, and who are no longer subject to that order. — Preceding unsigned comment added by 73.249.134.186 (talk) 20:17, 10 April 2020 (UTC)

Column totals do not equal the sums of the columns

Why? Does this template not autosum? Oltemative (talk) 23:57, 10 April 2020 (UTC)

edit conflict

@Zygerth sorry for the edit conflict; I had tabulated all the new values and was ready to publish when your edits started coming in. I can go through and make the changes you made from your history (I think mostly cleaning up/updating hospitalizations?). JoelleJay (talk) 01:16, 13 April 2020 (UTC)

Semi-protected edit request on 16 April 2020

Please change Iowa Confirmed Cases from 1,849 to 1,995, and Deaths from 43 to 53, per the released data of 4/15/2020 by Iowa Dept Public Health: https://idph.iowa.gov/Emerging-Health-Issues/Novel-Coronavirus 216.248.100.66 (talk) 14:29, 16 April 2020 (UTC)

 Done. Numbers have risen since this request and have been updated to reflect as such. —Tenryuu 🐲 ( 💬 • 📝 ) 16:47, 17 April 2020 (UTC)

Semi-protected edit request on 17 April 2020

Iowa TechnicallyIA (talk) 15:54, 17 April 2020 (UTC)

TechnicallyIA,  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. —Tenryuu 🐲 ( 💬 • 📝 ) 16:43, 17 April 2020 (UTC)

Semi-protected edit request on 13 April 2020

Is there an ability to add a new column to the "2020 coronavirus pandemic in the United States by state and territory" table with the case fatality rate per State? 66.219.247.222 (talk) 16:36, 13 April 2020 (UTC)

Yes. Simply it's Deaths/Cases for each one. I'd say this suggestion would need [[WP:CONSENSUS|consensus]. {{replyto}} Can I Log In's (talk) page 19:02, 13 April 2020 (UTC)
Yes we could add it. No we should not add it. At this point it is NOT just deaths/cases. See https://en.wikipedia.org/wiki/Template_talk:2019%E2%80%9320_coronavirus_pandemic_data/Archive_1#Ratios for a previous discussion and, as I said in that discussion, see https://academic.oup.com/aje/article/162/5/479/82647 to get an idea of the math involved to get a real rate, but if you did that math, it would be original research. Leave it to experts to come up with mortality/fatality rates. Richard-of-Earth (talk) 20:19, 14 April 2020 (UTC)

Window size

Why is this shown in a relatively short window with vertical scroll bars? This can be expanded based on the page it sits on. In addition why is the data tightly linked with the presentation? Locking this template means both data and presentation cannot be edited without permission when the data is the important thing that is being protected. 203.56.2.254 (talk) 06:33, 20 April 2020 (UTC)

John Hopkins Recovered Cases

I was just curious why the statistics on recoveries for each State are not being applied to the chart. The reference to John Hopkins has statistics for total recoveries for many of the States that are blank on the chart regarding their known recoveries.

https://coronavirus.jhu.edu/map.html

E.g. New York is blank even though John Hopkins lists 57,180 people as recovered. Thanks. — Preceding unsigned comment added by 2600:1700:3A60:E0C0:2D90:C861:6375:2D3 (talk) 06:14, 10 May 2020 (UTC)

Semi-protected edit request on 14 May 2020

The "Cases/100,000" Column should simply be = (Numbers of Cases)/(Population/100,000). 

 This column seems to be calculated separately, and is not up to date, creating a static statistic of how many cases the states or the nation has currently confirmed. For example, the entire U.S. is listed as having 354 cases/100,000 at the top of the column, when in reality the Case number and Population in the table yield about 405 on this date.  
  For both the sake of updating and proper comparisons, making the table accurate will make this great entry even better. Thanks for considering this feedback.

(Redacted) 174.83.107.82 (talk) 19:38, 14 May 2020 (UTC)

@174.83.107.82: note the discussion above at #New columns that add in each jurisdiction's cases per 100,000 people. I'll try to get around to updating this later today but we're currently very busy at work so I'm not sure exactly when I'll get around to doing it (someone else might beat me to it).
Honestly though, if keeping the information up-to-date is going to be problematic (some of the numbers haven't been updated in about a week, and the user who originally added the cases/100,000 columns to the template has not updated the numbers since they originally added the columns), it would probably be prudent to remove the columns instead of providing outdated or inaccurate information. Aoi (青い) (talk) 19:54, 14 May 2020 (UTC)
 Not done for now: please establish a consensus for this alteration before using the {{edit semi-protected}} template. An edit request is not for extended discussion on a topic. Reopen this only when the matter is resolved and if nobody implements suggested changes RandomCanadian (talk | contribs) 21:11, 14 May 2020 (UTC)

New columns that add in each jurisdiction's cases per 100,000 people

I just noticed that someone added in new columns that add in each jurisdiction's population and cases per 100,000 people. I appreciate the intent of these edits, but I have concerns that these new columns will make keeping this table up-to-date (which is already time consuming enough) even harder than it already is, especially since the table is not capable of calculating numbers by itself, meaning the numbers will have to be recalculated by a user every time the template is updated. I do think the numbers are a valuable addition, but as I think we need to reflect whether its benefit outweighs the negatives I noted above. I'm opening a discussion here to see if anyone has any thoughts on this addition. Aoi (青い) (talk) 07:22, 5 May 2020 (UTC)

The equivalent Canadian chart has columns for cases per million AND deaths per million. It is easy to calculate these things, I was considering adding deaths per million (which is more meaningful than cases, since many cases must go unreported).Arrecife (talk) 16:09, 5 May 2020 (UTC)
I think it's important to note the Canadian table has under 15 jurisdictions, around a quarter of the US's, so it's much easier to keep track. The individual sources also seem way more user-friendly (static, fast-loading pages as opposed to RAM-gobbling "dashboards") and can provide more detailed information due to the much lower case counts. I'm also uncertain we should be doing "original" calculations like determining the cases per 100k; that info isn't in the cited sources, so we'd have to be adding even further references that might be decoupled from the numbers each state is reporting. JoelleJay (talk) 03:58, 6 May 2020 (UTC)
I agree with everything JoelleJay said – going through each US jurisdiction's health authority is really time consuming, especially when some figures are buried a dozen or more pages in a PDF document. The OR concern is also valid; the calculation is easy but given differences in how states report their case numbers (confirmed cases only versus confirmed+probable), I'm not really sure if we want to be making this calculation on the states' behalf given we're almost certainly not always comparing apples to apples. I also note that many people who've updated specific states over the past three days haven't updated the "number per 100k population" figure. Aoi (青い) (talk) 07:49, 8 May 2020 (UTC)
Several weeks ago I modified NYS with additional columns, including county populations, ppm per cases, ppm per deaths, % death for cases. Not knowing how to create an Excel-like simple numerical ops processing for these, I left the values as "hardwired", with the specific date of the edit. I also made some edits for Massachusetts, for the all US states, and more. I don't know (haven't paid attention to) how the data is imported every day, whether by an automatic fill-in from an external source data base, or somebody's actual sweat, number by number. If the latter, I'm very disappointed and will leave the conversation right here! If an automatic data infusion is the mechanism for daily updates, all I was begging for is that that data be ADDRESSABLE as "variables" and be used in simple further numerical ops. (The Template I found is specific to a 3 variables data set, and division between 2 - with no other variability in inputs, size of data set, etc - so it doesn't lead anywhere without knowing the programming rules for creating Templates, etc; I think in subroutines, or in Excel, or a dozen other programming languages). But I'm very negatively intrigued by the position stated above the essntially it's not worth doing any further re-representation of the data, because of a questionable origin (just interpreting!). The data is the data, whether true or not. And if the reported number of cases and deaths and recoveries are not true, then why would it be worthwhile tabulating them but not other values STRICTLY derived from them, like ppm's or /100k or percents. So, does anybody know how to automatically perform Excel-like ops in a Wikipedia table that's already there, or not?
I'll present an antique method of the mid-70's, where we used to have a data acquisition computer (a PDP-11 of course), with follow-up analysis, like FFT's and further complex computations, but with no externally cnnected I/O device. So, in order to publish and move the results on our network-connected computer, someone had to read primary PDP-11 results and type them on the network-connected computer (Yes, a linking device was not affordable in the Federal budget!). That sounds to me like what happens to the daily COVID data with respect to the dozens of very interesting Wikipedia sites, generically related to "COVID-19_pandemic_in_New_York_(state)", or any other. So, how does one Excel, or Template? — Preceding unsigned comment added by Dan Arthur Gross (talk • contribs) 19:03, 12 May 2020 (UTC)
@Dan Arthur Gross: The tables do not calculate automatically. I am not sure if this is technically possible within the current MediaWiki software; in addition, I don't think it's possible to automatically pull data in from other templates (if someone out there who's familiar with the technical side of the project can help answer, please chime in). The numbers in this table are updated manually. Each time someone updates it, the process involves going to each reference listed (there's 67 of them listed right now) and getting the numbers from each jurisdiction's health authority. Some users then copy the data into an spreadsheet off-wiki, which which calculates the totals and number of cases per 100,000, but then these numbers need to be copied and pasted one-by-one into this template.
The process can literally takes 1-2 hours. It's not hard, but it is tedious and that's why the table is not updated as frequently as others might like. I myself have updated it three times since you've added the new columns; I'd update it daily if I could but between work and family obligations, I just don't have the time. JoelleJay has also been working hard trying to keep the table updated, which is much appreciated (just take a look at the main U.S. COVID-19 article talk page; people actively look for updates to this table and the other charts on the article).
WP:OR concerns aside, I do appreciate the n/100k values; it's definitely more meaningful than just the raw numbers. However, at some point we need to draw the line for the sake of expediency. Much thanks, Aoi (青い) (talk) 19:37, 12 May 2020 (UTC)
On the question of technical feasibility: there are templates which convert numbers from one system of units to another. Given that, on the face of it, it should be possibly to produce a template that takes the case count and the population and generates the cases per capita. Then it becomes a matter of entering the new value for the case count into two places. Make a template for a whole row (input - population, case count, death count) and it would seem to no more effort than adding the new numbers, and you can have whatever columns you want. Lavateraguy (talk) 17:27, 20 May 2020 (UTC)
I agree that the new columns, while useful in theory, are unmanageable, as we're already seeing from other complaints on the talk page. I would favor removing them, as seems to be the consensus here. Kaldari (talk) 18:50, 18 May 2020 (UTC)
I went ahead and removed them. Kaldari (talk) 18:57, 18 May 2020 (UTC)
Sorting in the Recoveries column doesn't work - the result is two groups of increasing/decreasing numbers. 69.12.251.25 (talk) 03:38, 19 May 2020 (UTC)
69.12.251.25 Someone (Spencer1594?) added a bunch of recoveries and hospitalizations without using the nts tag for the ones that were ≥1,000, so those aren't getting sorted. I'll go through and deal with those, although they also aren't sourced so I'll probably just delete them. JoelleJay (talk) 00:48, 20 May 2020 (UTC)

California Recoveries

Hey there. As we know, the state of California doesn't currently report recoveries. However, I found that some counties do report recoveries. Should we calculate sum of recoveries from the counties that report it? For example, here is the data for Riverside county. One county I found doesn't exactly report recoveries, but reports active cases, which clearly includes recoveries. So far, I found these counties that report recoveries:

Sorry for the messy list. Chopanero77 (talk) 14:52, 3 June 2020 (UTC)

EDIT: I also found a lot of counties in the state of Washington that report recoveries. Chopanero77 (talk) 23:13, 4 June 2020 (UTC)

Sorry, I disagree. In the metrics such as this, it's "all-or-nothing" approach. It reports state as a whole, not counties. Such data collection will be inconsistent with the comprehensive reporting from other states. Remember, a partial state data will be further exacerbated by the intrinsic disproportionality in population, cases, and deaths between the counties, and thus is not representative statistically. Is partial data ever used in statistics? Yes. But this isn't the case for it. You have very good intentions, and I applaud you for that and for your persistence. Perhaps your suggestion will be more appropriate if implemented here: COVID-19 pandemic in California. Good luck! Maksdo (talk · contribs) 13:48:58, 5 June 2020 (UTC) 

New Jersey case numbers

Change New Jersey's numbers to cases: 172,356, deaths: 13,251. The numbers currently in the table are off by thousands it seems. The source on the page for New Jersey is https://www.nj.gov/health/cd/topics/covid2019_dashboard.shtml which provided the numbers I've shared. Thanks! Techkid6 (talk) 00:38, 3 July 2020 (UTC)

Anyway to have the totals generated at the top?

Hello,

I want to help. I noticed the FL numbers off by a few days. I wanted to put in the new numbers but then I saw I needed to also have the increases added to the top as well. Is there any tutorial or method people use to update this table/template? — Preceding unsigned comment added by Phecht7 (talk • contribs) 17:06, 7 July 2020 (UTC)

Phecht7, people just manually edit the numbers as the sources get updated. —Tenryuu 🐲 ( 💬 • 📝 ) 22:41, 20 July 2020 (UTC)

Texas hospitalizations

There seems to be some confusion about whether or not Texas reports hospitalizations. Using the 2nd reference and clicking on the "Hospitals - Statewide" tab, you can get the current number of hospitalizations. This isn't what the column seems describe (it is supposed to be cumulative hospitalizations), but that is the number that has been used. Someone should either dash out the number and remove the reference, or put a comment in stating how to get the number and explain why it's ok to use it (maybe in the column footnote?). I have no preference, but there seem to be several comments in the edit notes stating that TX doesn't report hospitalizations... it does, but maybe not the number we are looking for. Thoughts? Oltemative (talk) 08:21, 25 July 2020 (UTC)

American Samoa

COVID-19 pandemic in American Samoa. American Samoa reported its first three cases. --190.90.140.176 (talk) 14:24, 13 November 2020 (UTC)

@190.90.140.176: Can you provide me a source? I couldn't find one myself. Thanks, EDG 543 (message me) 20:59, 17 November 2020 (UTC)
An edit request was made at Template talk:COVID-19 pandemic data and was responded to. —Tenryuu 🐲 ( 💬 • 📝 ) 21:15, 17 November 2020 (UTC)

Texas data has been quite behind from the linked source or any other data, compared to other states.

As of Oct 14, Texas total death is 16,717 according to the linked source, and 16,622 according to CDC. However the table has 16,558, this is bigger Oct 13 data of the linked source. Other state numbers don't seem too far. e.g. California is 16,639 according to the linked source and 16,581 according to CDC and the table has 16,572. — Preceding unsigned comment added by 67.164.96.191 (talk) 20:40, 14 October 2020 (UTC)

Totals

Is it useful to have the US totals as usm in this tab? Usually the figures are dated, i.e., even if the total equals the sum of the states and territories it is rarely an accurate number. Furthermore, the article on COVID19 in the US has the total itself and sourced in three variations. Wouldn't it be much better and more realistic to use those numbers or rather to delete the totals line in this template? --Qumranhöhle (talk) 12:35, 18 November 2020 (UTC)

Qumranhöhle, you make a good point. I'm not sure what to do about it- if the state totals don't add up to our unofficial total, it wouldn't make much sense. But if our total doesn't add up to the "official" totals, it wouldn't make much sense either. I think we should just keep it as up-to-date as we can. Thanks, EDG 543 (message me) 13:31, 18 November 2020 (UTC)
Thanks for your answer. I would, however, draw a different conclusions from your arguments. I would prefer to skip it completely. Instead of counting our own numbers (which is problematic in light of wikipedia principles), we should better refer to the official numbers. And see the problem with Florida in the section above. --Qumranhöhle (talk) 19:11, 19 November 2020 (UTC)
Qumranhöhle, I have found that the total is lower due to some of the state's numbers being a week or more behind. The number is a bit closer to where it should be now that I have made some updates, but there is still much work to be done. I will try to update every state's totals later today, and we will see if that gets us close to what the overall total should be. If not, we may have to try your suggestions. Thanks, EDG 543 (message me) 15:27, 20 November 2020 (UTC)
Good luck then, because this is endless... --Qumranhöhle (talk) 15:59, 20 November 2020 (UTC)

Florida

Are we listing the counts for residents, or residents and non-residents? Infinite mission (talk) 18:15, 21 August 2020 (UTC)

Infinite mission, sorry for the delayed response. Yes, we are including both resident and non-resident deaths in the Florida totals. Thanks, EDG 543 (message me) 14:20, 19 November 2020 (UTC)
EDG 543, what are we doing about cases? Infinite mission (talk) 18:53, 19 November 2020 (UTC)
Infinite mission, my apologies. We are including resident and non-resident deaths as well as cases. Sorry for the confusion. Is there an issue with the data? Thanks, EDG 543 (message me) 18:59, 19 November 2020 (UTC)
For a while we had only resident cases listed. As long as it is clearly stated which is the case I do not see a big problem. I assume the number of non-resident case is considerably higher in Florida than in other states. This should give us a pause, however, concerning the totals in this template. Non-resident cases from Florida might be double counted, which skews the data. --Qumranhöhle (talk) 19:10, 19 November 2020 (UTC)
@Infinite mission and Qumranhöhle: To avoid double counting, we just have to be careful to get the "Total Cases" number from the dashboard and avoid anything else in relation to the cases. No math necessary on our part. Deaths do have to be manually added together, however (Florida Resident Deaths and Non-Resident Deaths). Thanks, EDG 543 (message me) 15:19, 20 November 2020 (UTC)
I may misunderstand something, but the total cases include non-residents. If those Florida non-residents are counted by other states as "their" residents, there is double counting. --Qumranhöhle (talk) 16:01, 20 November 2020 (UTC)
Qumranhöhle, you would be correct in saying that, but I am not sure what we would do about that. Exclude non-resident cases/deaths? Thanks, EDG 543 (message me) 21:02, 8 December 2020 (UTC)
Retrieved from "https://en.wikipedia.org/w/index.php?title=Template_talk:COVID-19_pandemic_data/United_States_medical_cases_by_state/Archive_1&oldid=1193235904"