Template talk:COVID-19 pandemic data/Archive 14

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.

@Jirka.h23:: This edit included the serology–confirmed cases for Spain, which should be excluded. I will try and fix it. Agathoclea (talk) 09:24, 14 May 2020 (UTC)

@Agathoclea: Why should be excluded only in Spain? Jirka.h23 (talk) 10:09, 14 May 2020 (UTC)

Jirka.h23, please read this for why we exclude serology-confirmed cases for Spain: [[1]]. Tentative ping to Agathoclea for notification of archived talk page topic as well. Cheers, u|RayDeeUx (contribs | talk page) 17:04, 14 May 2020 (UTC)

Hello RayDeeUx, as has been said in your link, "it is great that a note has been added, but the mismatch between the figures should be corrected". Again, why should be serology-confirmed cases excluded only in Spain, if in other countries are included? It brings quite chaos to it. Jirka.h23 (talk) 06:50, 15 May 2020 (UTC)

That is a good question to talk about. What I found though, when I followed the link of the given reference it gave the lower number as the figure for Spain. Any higher number if it did exist was burried somewhere in the blurb, but the reference was headlining with the lower number. Agathoclea (talk) 11:08, 15 May 2020 (UTC)

What is in the headline and what is in the text is not important. RTVE is a state-owned public corporation, therefore, it seeks to alleviate panic, for example by emphasizing smaller numbers. However, in the text is clearly written that "hasta el 15 de mayo se han registrado un total de 274.367 casos en España." (until May 15 a total of 274,367 cases have been registered in Spain). Why should be serology-confirmed cases excluded only in Spain, if in other countries are included? Jirka.h23 (talk) 11:43, 15 May 2020 (UTC)

Jirka.h23, as in my earlier link, MarioGom says:

RayDeeUx, these are not confirmed cases by the official Spanish, European Union or World Health Organization definitions. So I'd say they should not be included in this table.

Until these definitions/guidelines change, we are not including them in the figures. If you want serology–confirmed case figures to be included in the footnote, I can agree to that for the moment. Cheers, u|RayDeeUx (contribs | talk page) 13:32, 15 May 2020 (UTC)

Jirka.h23: I can confirm that, as of 15 May 2020, the World Health Organization still includes PCR-tested cases only in the confirmed cases figures for Spain. The infobox at COVID-19 pandemic in Spain receives more detailed updates with both PCR and serology tests. --MarioGom (talk) 21:12, 15 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The death statistics for Zambia are not accurate according to the official website. The entry indicates 42 and cites https://web.facebook.com/mohzambia/posts/1588035541371097 as the source. The correct death toll is 7 as indicated here> https://web.facebook.com/mohzambia/photos/a.773733439467982/1588862461288405/?type=3&theater Gildxxc (talk) 15:11, 15 May 2020 (UTC)

 Not done: Please provide a link directly to the official website, not to facebook posts... Additionally, don't be worried, this will be updated to the correct information as soon as one of the editors who normally updates the template gets around to doing so. RandomCanadian (talk | contribs) 15:24, 15 May 2020 (UTC)

RandomCanadian, do not worry if a Facebook post is cited as a source as long as the post is associated with a location's government in some way, shape, or form. This is why we also allow Twitter tweets as sources for this template as long as those tweets are made by accounts that have been confirmed to belong to either a location's government or a location's government official. Cheers, u|RayDeeUx (contribs | talk page) 15:44, 15 May 2020 (UTC)

@RayDeeUx: Although the page appears official, the accounts does not have the usual check mark indicating it is verified... RandomCanadian (talk | contribs) 15:47, 15 May 2020 (UTC)

RandomCanadian, see this: https://imgur.com/a/VfIqM9J. Now, will you please make the edits yourself? Cheers, u|RayDeeUx (contribs | talk page) 16:52, 15 May 2020 (UTC)

I looked at the page. Anyway,  Done RandomCanadian (talk | contribs) 16:58, 15 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Brasil References:

"Painel COVID-19 - Estatísticas do Coronavírus" (in Portuguese) - www.giscard.com.br/coronavirus Giscardstephanou (talk) 18:24, 16 May 2020 (UTC)

 Not done: Redundant to what is already there. The Brazilian Ministry of Health is linked and that seems sufficient. RandomCanadian (talk | contribs) 03:47, 17 May 2020 (UTC)

Moved to Talk:COVID-19 pandemic in South Africa § South africa daily covid19 cases chart not matching the total number in header

 – u|RayDeeUx (contribs | talk page) 14:11, 18 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

I would like to suggest that a column (population) be added to the table. In this way it is possible to measure the estimates. 177.79.104.124 (talk) 05:24, 18 May 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. JTP ^{(talk • contribs)} 06:26, 18 May 2020 (UTC)

 Not done. No new columns. Cheers, u|RayDeeUx (contribs | talk page) 14:15, 18 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

I believe that adding a line showing number of identified cases per 1 mln of population is required. This could be a good indicator of a situation in the country.

Thanks. 212.49.186.198 (talk) 10:00, 18 May 2020 (UTC)

 Not done. No new columns. Cheers, u|RayDeeUx (contribs | talk page) 14:01, 18 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The commonwealth of Dominica total recovered from COVID-19 is at 16 http://dominica.gov.dm/updates 209.59.104.5 (talk) 14:12, 18 May 2020 (UTC)

 Already done. Cheers, u|RayDeeUx (contribs | talk page) 14:15, 18 May 2020 (UTC)

Please correct the numbers. It is 52, not 452. 142.184.186.174 (talk) 07:47, 19 May 2020 (UTC)

Done. Cheers, u|RayDeeUx (contribs | talk page) 13:28, 19 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The total recovered from COVID-19 in the Commonwealth of Dominica is 16. See linsk below from the Government of Dominica http://dominica.gov.dm/corona http://dominica.gov.dm/images/may-17-dominica-coronavirus-update.jpg 162.213.170.217 (talk) 11:59, 20 May 2020 (UTC)

 Done. Cheers, u|RayDeeUx (contribs | talk page) 14:29, 20 May 2020 (UTC)

Hello, the template is displaying 5,000,561 confirmed cases for the total, data collected from the CSSE of the Johns-Hopkins University ({{Cases in the COVID-19 pandemic}}). I am using their datasets for weeks on frwiki to update five wikitables, and I was wondering why the template is using a lot of references but display what it seems to be a wrong total from one reference.

Currently, JHU is making a mix of confirmed and possible cases for France. JHU displays 181,700 confirmed cases when the French authorities share the number... 143,845. That's a difference of almost 40,000 cases. I don't know if this has been discussed here before, hence this message. The university explains its choice on this ticket.

On frwiki, we no longer use JHU data for France since several French media have also dropped the university data for France because of this difference. The data for the other countries and territories are generally correct, although some corrections are made. Lofhi (talk) 10:14, 21 May 2020 (UTC)

Hmmm? Lofhi (talk) 16:43, 22 May 2020 (UTC)

Lofhi, it seems like this issue is more of English Wikipedia's COVID–19 WikiProject having a different consensus than that of French Wikipedia's COVID–19 WikiProject. As I'm not a sysop nor a veteran Wikipedia editor, the most I can say is that different Wikipedias most likely have different standards for which sources to use. English Wikipedia, for example, only uses aggregate sources for a location if government sources or the location's news media sources aren't as updated as often. Obviously, such selection of sources comes with some trade-offs, and it appears that you have found one of them. Heck, Chinese Wikipedia doesn't even have a template to store CCF for COVID–19 cases worldwide.

It appears that I am about to ramble on, so I must stop myself here before it is too late to do so. Cheers, u|RayDeeUx (contribs | talk page) 15:21, 23 May 2020 (UTC)

@Lofhi: I think it has to do with JHU giving a single number for all French territories (not only France) under the name "France". And in that process some duplication might occur (I know it did in the past, I don't how it is today). There was a lot of discussion in this regard maybe a month ago (in the Talk:COVID-19 pandemic if I'm not mistaken). Feelthhis (talk) 14:47, 24 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Qatar case number: change 30,481 to 40,481 108.52.207.45 (talk) 19:38, 22 May 2020 (UTC)

 Not done: please provide reliable sources that support the change you want to be made. Jack Frost (talk) 05:35, 23 May 2020 (UTC)

Jack Frost, that is not the most ideal way to handle edit requests specifically for this template. Many of the edit requests are made by IP editors or accounts less than a week old (and as such aren't fully familiar with the details in making an edit request), and involve simple updating with figures. As such, use current sources a location cites for its case figures before assuming an edit request cannot be done.

As for the Qatar figures, they have already been updated as of the time of this reply. Cheers, u|RayDeeUx (contribs | talk page) 15:11, 23 May 2020 (UTC)

The Russia footnote (f) currently says that this excludes the Diamond Princess. This appears to be in error. The Diamond Princess has little to no connection to Russia. This ship is already mentioned in a footnote on Japan's row. --LukeSurl ^{t c} 17:19, 24 May 2020 (UTC)

LukeSurl, do you have a source saying there were zero Russian passengers on the Diamond Princess? Cheers, u|RayDeeUx (contribs | talk page) 01:07, 25 May 2020 (UTC)

Russia is not mentioned once on COVID-19 pandemic on Diamond Princess. This is a British-flagged ship which docked in Japan. I am not aware that a full breakdown of the nationalities of the persons aboard exists, but there is just as much reason to associate this vessel with Cambodia, Peru etc. as there is with Russia. --LukeSurl ^{t c} 11:34, 25 May 2020 (UTC)

@LukeSurl: See [2] which can be found with a simple Google search. --17jiangz1 (talk) 12:30, 25 May 2020 (UTC)

This is a British flagged ship docked in Japan. There were nationals of many different countries aboard (50 according to the link you shared). There is no particular reason to highlight 8 Russians among the 3700 persons aboard. --LukeSurl ^{t c} 12:55, 25 May 2020 (UTC)

LukeSurl, that goes against the very nature of this template: to document as many cases of COVID–19 as possible while using reliable sources. Cheers, u|RayDeeUx (contribs | talk page) 13:07, 25 May 2020 (UTC)

The purpose of the template is to succinctly overview the locations of cases, not nationalities of persons affected. Having a footnote for every verifiable case of people of one nationality contracting the disease in the territory of a different country would be utterly implausible. Even doing this just for the 50 nationalities on the Diamond Princess and the other vessels on this list would lead to a huge number of unhelpful footnotes that would obscure useful information. --LukeSurl ^{t c} 16:46, 25 May 2020 (UTC)

LukeSurl, I believe you meant locations where a case was diagnosed. Those 8 Russian passengers were diagnosed on the Diamond Princess, as such they belong with the row for said cruise ship. This is how most cases on cruise ships have been listed, and it will remain that way since many of the editors for this template are far more dedicated to splitting cases based on location of diagnosis than you would think. Cheers, u|RayDeeUx (contribs | talk page) 17:22, 25 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Take a look at the US recovered statistic. It is in the 3 millions, while the source I went to for that number was in the 300,000. I believe it is a simple typo. The only thing that alerted me to it was that there were more recovered than people who tested positive. Please change this as quickly as possible to help others get the correct info.

Short: for US recovered, change 3,000,000 to 372,794 as of 5/27/2020 2606:A000:42CE:A500:AD7C:8BE:8A46:A448 (talk) 00:52, 28 May 2020 (UTC)

Done. Thanks for letting us know! Cheers, u|RayDeeUx (contribs | talk page) 01:15, 28 May 2020 (UTC)

Please could someone fix the case numbers, they should be on the order of 5.6 million. Thank you. Pablothepenguin (talk) 20:38, 28 May 2020 (UTC)

You have an up to date source for that figure? ϢereSpielChequers 07:51, 29 May 2020 (UTC)

We are citing what JHU has, which updates more frequently than WHO Situation Reports. As the template says, totals may not necessarily be accurate since they are based off of JHU figures, not off of what the template has for each listed location. Cheers, u|RayDeeUx (contribs | talk page) 12:54, 29 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Change Nepal Statistics in death section which is 6 not 56 43.231.208.94 (talk) 02:44, 30 May 2020 (UTC)

 Done by another editor. Capewearer (talk) 04:02, 30 May 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Laga yaabo in taasi dhacdo Yeysan dhicin Mar naba 197.157.0.18 (talk) 04:58, 1 June 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. JTP ^{(talk • contribs)} 05:24, 1 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Add following columns to data (In order of preference): 1) Net active cases : This is most relevant number for any analysis 2) %age date of total cases 3) %age recovery

And give an option to download data in excel or CSV format

 Not done: See item #3 in #Current consensus. —Tenryuu 🐲 ( 💬 • 📝 ) 15:32, 1 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

177.142.216.181 (talk) 14:38, 1 June 2020 (UTC)

O Brasil não é o 2 ligar e sim o pai meiro

 Not done Please provide a reference for your claim that Brazil is in the wrong position. Capewearer (talk) 14:47, 1 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Please add a column showing the "percentage population infected" (by dividing the infected cases # by the country's population #), because then viewers can understand the scale more effectively. For many viewers, the magnitudes of the case values can be difficult to contextualize without considering the size of the countries' populations. This change will make the data more informative. Thank you! Briggsinator22 (talk) 21:56, 1 June 2020 (UTC)

 Not done See item #3 in #Current consensus. Capewearer (talk) 22:23, 1 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The recovered cases entry for Morocco is grossly incorrect. As of today, the first of June, their site reads 5,893 recovered individuals, as compared to this page's claim of "5,7893"(sic). Considering that there are four digits to the left of the comma, a simple typo occurred which should be fixed to avoid undue confusion. ^[1] 172.97.248.129 (talk) 22:30, 1 June 2020 (UTC)

 Done —Tenryuu 🐲 ( 💬 • 📝 ) 22:40, 1 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The recovered cases entry for Rwanda is also quite incorrect. As of today, the first of June, the Twitter post reads 262 recovered individuals, as compared to this page's claim of "2562"(sic). Another minor typo that really should be fixed. ^[1] 172.97.248.129 (talk) 22:45, 1 June 2020 (UTC)

 Done —Tenryuu 🐲 ( 💬 • 📝 ) 23:44, 1 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

COVID-19 fatalities in Estonia, listed on https://en.wikipedia.org/wiki/Template:COVID-19_pandemic_data table, is wildly inaccurate by several orders of magnitude. It currently lists 6981 deaths. Official sources by Republic of Estonia Health Board(https://www.terviseamet.ee/en/covid19)and WHO(https://covid19.who.int/region/euro/country/ee) peg the number of deaths at 69 fatalities as of 7 June 2020. Gunnarrr (talk) 10:01, 7 June 2020 (UTC)

 Done This was the result of a typo in a recent edit, which has now been fixed. Thanks, Capewearer (talk) 10:22, 7 June 2020 (UTC)

Hi. I have noticed that the number of recoveries mention for UAE is wrong. it is mentioned as 210,806 recoveries but it is actually 21,806 as per Gulf News and other sources. Sources: https://gulfnews.com/uae/uae-covid-19-recoveries-outnumber-infections-for-third-day-in-a-row-1.1591522687581, https://www.khaleejtimes.com/coronavirus-pandemic/coronavirus-uae-reports-540-new-covid-19-cases-745-recoveries-one-death 92.96.87.97 (talk) 16:50, 7 June 2020 (UTC)

 Done. Thanks for catching that! —Tenryuu 🐲 ( 💬 • 📝 ) 17:07, 7 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The number of US Deaths is wrong, off by an order of magnitude. Source: https://coronavirus.jhu.edu/map.html 2601:249:8C80:EC50:942D:D711:28D5:2470 (talk) 19:46, 7 June 2020 (UTC)

 Done Fixed, thanks. Capewearer (talk) 19:51, 7 June 2020 (UTC)

Yes, teh caculation must be wrong. According to the same source cited in the table https://coronavirus.1point3acres.com/en thare are just ~111000 SkZ (talk) 19:53, 7 June 2020 (UTC) In the while it has been fixed, it seems. SOLVED SkZ (talk) 19:55, 7 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Good evening, I am Samuel Nqakwana a South African citizen, I Would like to help edit about Covid-19 since it's a global pandemic and further explain how do we deal with the virus in our country. The data i will be availing will be from the National Department of Health and would be the true. I would like to take a part in adding to the global pool of knowledge 41.13.88.125 (talk) 20:39, 5 June 2020 (UTC)

Hello, and thanks for your offer of help. Could you please specify the exact changes you propose to make? Capewearer (talk) 20:57, 5 June 2020 (UTC)

May I also suggest that you create a Wikipedia account? You'll find this very helpful in your work on COVID-19 articles, including the ability to edit semi-protected pages like this template. Please see Wikipedia:Why create an account? for more info about that. Thanks again. Capewearer (talk) 09:24, 6 June 2020 (UTC)

 Note: As Capewearer mentioned you can do one of either two things:

• Submit the changes that you want to request with edit requests like this. Make sure the changes are as specific as possible backed up with sources like the National Department of Health (provide a link to the page as well).
• Make an account and wait for it to get autoconfirmed (been registered 4 days and made at least 10 edits). —Tenryuu 🐲 ( 💬 • 📝 ) 15:17, 6 June 2020 (UTC)

Why does the table hang to the right side of the page? I'm genuinely curious, looked at the markup and couldn't figure it out. Please help! Thank you! Kvwiki1234 (talk) 07:09, 8 June 2020 (UTC)

Kvwiki1234, Answer is at Template:COVID-19 pandemic data/styles.css. Table is contained within html div tag with class name"covid19-container". CSS style value for this class has float parameter, which is set to right. - Timbaaa -> ping me 12:23, 8 June 2020 (UTC)

COVID–19 pandemic

to prevent edit conflicts. Since the creation of the template, it has always been stuck to the right side of the page.

And as Timbaaa said, the .css file of this template forces the template to stick to the right side. Cheers, u|RayDeeUx (contribs | talk page) 13:50, 8 June 2020 (UTC)

Thanks for the replies! Anyone mind if I change it so it's placed centered or left-side of page like a default table? I feel it looks really ugly hanging to the right in the parent article COVID-19 pandemic by country and territory - Kvwiki1234 (talk) 14:29, 8 June 2020 (UTC)

Kvwiki1234, could you explain what you mean by "looks really ugly"? It's on the same line as the other table that tabulates by capita, which balances them out and causes both of them to stick out from the prose. —Tenryuu 🐲 ( 💬 • 📝 ) 15:29, 8 June 2020 (UTC)

COVID–19 pandemic has always placed the table on the right side of the screen since the creation of the template. Personal preference is often the weakest basis for an edit. Cheers, u|RayDeeUx (contribs | talk page

) 22:12, 8 June 2020 (UTC)

• other tall tables in Wikipedia?
• tall tables in other Wikis (would be v. useful for meta:Wikipedian in residence)?

T.Shafee(Evo&Evo)^talk 10:58, 8 June 2020 (UTC)

Evolution and evolvability, you can look at the .css file associated with the template for starters. Cheers, u|RayDeeUx (contribs | talk page) 13:48, 8 June 2020 (UTC)

Ah yes, I more meant "Do people think it could be refactored to be included in the common css across WP". The current css is specific to this template (link for the record), so would need to be copied for every table thinking of doing something similar. Could something be written for the WP-wide commons css so that all that would be needed in the class section would be {| class="wikitable sortable scrollable". That's beyond my current css abilities! T.Shafee(Evo&Evo)^talk 04:51, 9 June 2020 (UTC)

So Brazil has recently stopped reporting its cumulative COVID-19 numbers, are we going to wait until a new data source can be found before updating it's numbers? — Preceding unsigned comment added by Jackhannah123456 (talk • contribs) 14:26, 8 June 2020 (UTC)

Dellux mkd has already added another reliable Brazilian source [3], the Conselho Nacional de Secretários de Saúde (CONASS, "National Council of Secretaries of Health") which is continuing to publish updated data. And Jvbignacio9 has added a helpful explanatory note about this [4]. Thank you both: I was wondering the same thing.

There's some useful background about CONASS here [5]. Capewearer (talk) 17:09, 8 June 2020 (UTC)

 You are invited to join the discussion at Wikipedia_talk:WikiProject_COVID-19#COVID-19_pandemic_data_updating. {{u|Sdkb}} ^talk 06:38, 3 June 2020 (UTC)

Hi, I daily update the case numbers for India here and on Wikidata simulatneously. I recommend auto-updating it from using a auto-fetch code after which no manual update will be required for India on this template as it will fetch data directly from linked Wikidata page of India. This fetch code is currently used in COVID-19 pandemic in India and also in Template:COVID-19 testing by country. If any other countries are regularly updated on Wikidata, then fetch code for them could also be used to reduce manual efforts. Thanks - Mayankj429 (talk) 15:27, 3 June 2020 (UTC)

Mayankj429, would you like to show us a sample of the automation process with updating figures? Additionally, some locations listed on the template here cite news sources–those would still require manual edits, right? Cheers, u|RayDeeUx (contribs | talk page) 17:46, 3 June 2020 (UTC)

Hi RayDeeUx, Here is the code to get last value of a multi-value Wikidata property (array), in this case for India which have qid=Q84055514 :-

For Confirmed cases -

{{wdib|ps=1|P1603|qid=Q84055514|list=p-1}}

33,766,707

For Recoveries -

{{wdib|ps=1|P8010|qid=Q84055514|list=p-1}}

33,043,144

Deaths -

{{wdib|ps=1|P1120|qid=Q84055514|list=p-1}}

448,339

If the source is constant like any government source or a dashboard than only access date needs to be changed and that can be automated as well with following template

{{TODAY}}

28 April 2024

But for variable news sources, either they will be manually updated or their Wikidata page can be linked as source like in Template:COVID-19 testing by country subdivision all the Indian subdivisons/states are auto-updated and in source their wikidata page is linked. Mayankj429 (talk) 21:38, 3 June 2020 (UTC)

Or the date can also be taken from Wikidata, since the values are being updated with date qualifiers. This script will do the job

{{wdib|ps=1|P1603|qid=Q84055514|qual=P585|qo=1|df=dmy|list=p-1}}

1 October 2021

Above said Wikidata reference will be like this.^[1]

- Timbaaa -> ping me 01:38, 4 June 2020 (UTC)

RayDeeUx and Timbaaa, I have made the changes in the template with the code written above, you may check that. Thanks. - Mayankj429 (talk) 03:45, 4 June 2020 (UTC)

Mayankj429 and Timbaaa, sweet! That certainly works for countries like Canada, who don't have overseas territories and/or overseas departments.

Now, how would we apply this form of automation to places such as the United States, where its territories (Northern Mariana Islands, Puerto Rico, Guam, and U.S. Virgin Islands) are listed separately? Would the sum template work with Wikidata? Cheers, u|RayDeeUx (contribs | talk page) 13:57, 5 June 2020 (UTC)

RayDeeUx, What do you mean by 0 template?

If the wikidata items are updated regularly, it can be linked.

Formula can be applied over the link like this example for active cases in India.

{{round|
  {{#expr:
  {{formatnum: {{wdib|ps=1|P1603|qid=Q84055514|list=p-1}}|R}} -
  {{formatnum: {{wdib|ps=1|P8010|qid=Q84055514|list=p-1}}|R}} -
  {{formatnum: {{wdib|ps=1|P1120|qid=Q84055514|list=p-1}}|R}}
 }} }}

275,224

COVID-19 pandemic in India (Q84055514) is regularly updated by Wikidata:WikiProject India/COVID-19 task force. But, COVID-19 pandemic in the United States (Q83873577) seems not up to date. - Timbaaa -> ping me 14:20, 5 June 2020 (UTC)

Timbaaa and Mayankj429, I'm super glad to see this — I think centralizing the data at Wikidata is the right way to go, since that's basically what it's designed for, and that allows us to coordinate better with other language editions (which is more of a benefit for them than us, but a net positive for everyone). I've been struggling over there for the past few days to figure out how to automatically retrieve the most recent value for the case count, and it looks like this may solve it. (The solution I'm pursuing there, getting the most recent value automatically ranked as preferred, should probably still happen, and would allow us to use e.g. {{wikidata|property|normal+|Q87768605|P1603}}. {{u|Sdkb}} ^talk 07:45, 6 June 2020 (UTC)

Yes Sdkb, I completely agree with you. Currently same procedure is being adopted to retrieve data for COVID-19 articles on multilanguage editions of Wikipedia for India and all the Indian States from Wikidata with the help of Wikidata:WikiProject India/COVID-19 task force, you can have a look at it. - Mayankj429 (talk) 08:46, 6 June 2020 (UTC)

Mayankj429, I'm testing it out at Template:COVID-19 pandemic data/Per capita/sandbox before applying it to the whole per capita table. It seems a bit finicky — for Canada, an erroneous designation of an entry from back in March as "preferred" rank was overriding the country's more recent count until I just fixed it, making the count seem super low. {{u|Sdkb}} ^talk 09:18, 6 June 2020 (UTC)

Sdkb, Ranking should not be used for this kind of data. Even better approach then above method is to sort through values over date qualifiers ( point in time (P585) is being used ) and get the last value. This way you can add claims in any order in wikidata, you will still get recent value.

{{wdib|ps=1|P1603|qid=Q84055514|qual=P585|qsorted=1|list=p-1}}

You can check the Module doc here. - Timbaaa -> ping me 11:06, 6 June 2020 (UTC)

Timbaaa, that sounds fine. The templates I'm using to generate Template:COVID-19 pandemic data/Per capita/sandbox2 are Template:COVID-19 pandemic data/Per capita/case calculator and Template:COVID-19 pandemic data/Per capita/death calculator. They're not live on anything right now, so feel free to tinker with them. {{u|Sdkb}} ^talk 11:18, 6 June 2020 (UTC)

Sdkb, I'll see what I can do. I'll ping you if I made any progress. - Timbaaa -> ping me 11:32, 6 June 2020 (UTC)

Per capita table set up to use Wikidata, but running out of memory

@Mayankj429, Timbaaa, and RayDeeUx: Okay, so I've set up Template:COVID-19 pandemic data/Per capita/sandbox2 so that it's fetching data from Wikidata automatically. It seems to be working fine, except that it gets through only a dozen entries or so before running out of memory. I think part of the issue might be that I'm fetching the Wikidata Q identifiers from the Wikipedia page names, which is apparently an expensive way to do it. Do any of you feel qualified to help out with this? The per capita table is not being updated by anyone right now, so it's drifting increasingly out of date. {{u|Sdkb}} ^talk 11:07, 6 June 2020 (UTC)

Sdkb, Maybe instead of going through Template:COVID-19 pandemic data/Per capita/case calculator, why not code calculations in Template:COVID-19 pandemic data/Per capita/sandbox2 (which I know how to do).

Or if you are looking for other use cases for Template:COVID-19 pandemic data/Per capita/case calculator code in all countries calculations with unique Qid's in the template and make it selectable using params, instead of searching through billion article labels and getting Qid's twice(which I know vaguely how to do). - Timbaaa -> ping me 12:26, 6 June 2020 (UTC)

Sdkb, Made little bit progress using second method said above. Ran into different error this time.- Timbaaa -> ping me 14:23, 6 June 2020 (UTC)

Timbaaa, looks like we made it to Eritrea before we ran into another overflow; that's an improvement! I'm curious, how did you generate the list of countries? It looks like it's missing a few (mostly ones where the pandemic article has a "the" before the country name), but those can be fixed if we get the system as a whole to work. {{u|Sdkb}} ^talk 17:17, 6 June 2020 (UTC)

So I just tried the first method by substing the calculator, but that only got us an extra line or two, so it's not worth it. I'm not sure where the expensive element is at this point or how we might deal with it; let me know if you want to continue playing with it; otherwise we should probably ask at

WP:VPT. {{u|Sdkb}} ^talk

17:32, 6 June 2020 (UTC)

WP:VPT to rescue. - Timbaaa -> ping me

00:39, 7 June 2020 (UTC)

Sdkb, I used SPARQL query on Wikidata, to get values in "has part" property in COVID-19 pandemic by country and territory (Q83741704). It's at User:Timbaaa/sandbox/6. The query is at the top above the table. - Timbaaa -> ping me 00:36, 7 June 2020 (UTC)

Sdkb, Tried something at Template:COVID-19 pandemic data/Per capita/sandbox2 worked in preview(showed values for every country, except some with rounding errors), not after submitting. - Timbaaa -> ping me 03:00, 7 June 2020 (UTC)

Sdkb, Tried something with ListeriaBot at User:Timbaaa/sandbox/5. Have a look at it.- Timbaaa -> ping me 12:35, 7 June 2020 (UTC)

That's a nice Proof of Concept, well done! But the numbers seems to be severely lagging behind. Raphaël Dunant (talk) 07:29, 9 June 2020 (UTC)

Pinging the major participants of this discussion, apologies in advance: Sdkb Timbaaa Mayankj429: Have we finished discussing how to automate numbers with Wikidata items yet? Curious. Cheers, u|RayDeeUx (contribs | talk page) 18:02, 11 June 2020 (UTC)

RayDeeUx, yes, it's live at Template:COVID-19_pandemic_data/Per_capita thanks to some incredible technowizardry from Naypta. The way the information gets there is still a little complex, though. It comes from User:Yapperbot/COVIDdata, based on the Wikidata items specified at User:Yapperbot/COVIDdata/countries.json and the design at User:Yapperbot/COVIDdata/template. The discussion between us started at VPT and then moved to here. {{u|Sdkb}} ^talk 23:16, 11 June 2020 (UTC)

Sdkb, I guess I can archive this then? Cheers, u|RayDeeUx (contribs | talk page) 16:16, 12 June 2020 (UTC)

RayDeeUx, yeah, feel free to archive this discussion since it's fairly unwieldy. Some follow-up is warranted, though, both for finishing the implementation at the per capita table and for bringing the functionality to the main table. {{u|Sdkb}} ^talk 16:18, 12 June 2020 (UTC)

Now that we've moved from a numerical count of locations to "Worldwide", I was wondering if it would be too absurd to place a .svg of a globe next to the text "Worldwide" in the same row in the template to be consistent with the listings of other locations on the template. Thoughts? Cheers, u|RayDeeUx (contribs | talk page) 22:09, 8 June 2020 (UTC)

​Neutral. While I don't mind the addition of an image next to it, what is its purpose? Pure aesthetics or to differentiate it from the header row, which is also emboldened? —Tenryuu 🐲 ( 💬 • 📝 ) 05:46, 9 June 2020 (UTC)

Tenryuu, pure aesthetics motivated me to make the suggestion, but differentiating it from the header would be nice. Cheers, u|RayDeeUx (contribs | talk page) 16:36, 9 June 2020 (UTC)

RayDeeUx, if you're going to place an image, perhaps it'd be better to use one that's "square" in terms of dimensions: I like the current offset "Worldwide" has from the reporting nations. but if "Worldwide" can maintain any offset from the nations I'm down for it. —Tenryuu 🐲 ( 💬 • 📝 ) 17:22, 9 June 2020 (UTC)

Support: 'Worldwide' does look like a second header at the moment. Adding a globe, and removing the bolding (as another editor tried earlier) would help with this. Capewearer (talk) 16:45, 9 June 2020 (UTC)

Capewearer and Tenryuu, would you both like to check out the Globe.svg photo I added and comment on it? TIA! Cheers, u|RayDeeUx (contribs | talk page) 17:56, 11 June 2020 (UTC)

Looks good, thanks. I've just centred it in the column - what do you both think? Capewearer (talk) 18:35, 11 June 2020 (UTC)

@Capewearer and RayDeeUx: Looks good to me. Are we leaving the numbers in bold? It looks like they could be standardised as well without formatting. —Tenryuu 🐲 ( 💬 • 📝 ) 19:07, 11 June 2020 (UTC)

Good idea. I've just un-bolded that row, how does that look now? Capewearer (talk) 19:53, 11 June 2020 (UTC)

Capewearer, excellent. Cheers, u|RayDeeUx (contribs | talk page) 20:50, 11 June 2020 (UTC)

Capewearer, looks good! 👍 —Tenryuu 🐲 ( 💬 • 📝 ) 22:06, 11 June 2020 (UTC)

Just noticed this — add my full support as well. Cheers, {{u|Sdkb}} ^talk 02:35, 12 June 2020 (UTC)

Sdkb, already added the globe, but thanks anyways. Cheers, u|RayDeeUx (contribs | talk page) 16:19, 12 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

14joaogabriel14 (talk) 03:35, 17 June 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. JTP ^{(talk • contribs)} 04:27, 17 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

10.00000 14joaogabriel14 (talk) 03:37, 17 June 2020 (UTC)

 Not done it's not not clear what changes you want to be made. Please say exactly what change you want to make, and provide a reliable source if appropriate. Capewearer (talk) 08:31, 17 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

I request to re-establish the code's grammar of noinclude because current <noginclude> tag from top fragment of template is incorrect and needs to be fixed. 2A02:2F01:6504:6200:50CA:B598:9409:2D50 (talk) 08:01, 17 June 2020 (UTC)

 Done by Timbaaa. Thanks! Capewearer (talk) 08:29, 17 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

85.221.140.109 (talk) 10:00, 17 June 2020 (UTC)in Ukraine recover is 14 943 not 145 943 according to the source.

 Done, thanks! Capewearer (talk) 11:27, 17 June 2020 (UTC)

I just noticed that this chart leaves out North Korea, etc. Since we're listing almost every country on earth here and COVID-19 pandemic in North Korea exists as an article, I think we may as well round out the chart by listing the remaining countries, perhaps with a note about the ones whose claims are dubious. {{u|Sdkb}} ^talk 03:12, 12 June 2020 (UTC)

Sdkb, maybe note that in a footnote–the template seems to be for confimed cases only since creation of template. Cheers, u|RayDeeUx (contribs | talk page) 16:15, 12 June 2020 (UTC)

As I can't do it myself, I would ask someone to remove "Guayana Esequiba" from the template. This "country" was added only a day ago, in an edit by User:MusicologoVzla. Guyana Esequiba is a part of the South American country Guayana, which is disputed by Venezuela, but controlled and administered by Guayana. The entry for Guayana itself lists 159 cases as of now, which is consistent with the figure that the Guayana Health Department publishes for the whole country (including the Esequiba part). The entry for Guayana Esequiba lists 28 cases.
But as I said: First of all this cases are already included in the Guayana data itself. Second of all the 28 cases is not even backed by the two sources that are given, which are also not valid.

• https://health.gov.gy/index.php/component/k2/item/130-10apr (which does not exist, gives a 404 error, and seems to be from 10-Apr, would therefore be outdated anyway by a long time).
• https://www.stlucianewsonline.com/guyana-33-test-positive-for-covid-19/ (This is a newspaper article from April 8th (!), completely outdated and it does not even back the 28 cases for Esequiba)

So the criteria for which countries should be listed (https://en.wikipedia.org/w/index.php?oldid=952240225#RfC:_Criteria_for_territory_listing) is not met and in addition the given figure is not even backed by the sources and is not even reliable. So I would ask for the removal. --Deconstruct (talk) 07:39, 16 June 2020 (UTC)

I have to agree. I tagged two of the references as failed links yesterday (they seem to have been pasted unchanged from Spanish-language Wikipedia [6]), and since then have been unable to find current references to verify the numbers shown. And if the numbers are already included in the Guyana entry, then as Deconstruct points out, accuracy isn't the main problem. Capewearer (talk) 08:52, 16 June 2020 (UTC)

 Done no objections made, so I've removed that entry. Capewearer (talk) 07:18, 17 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

The correct information for Panama's deaths for COVID-19 is 457, no 4570. Lcolladoc201 (talk) 04:39, 18 June 2020 (UTC)

 Done, thanks. Confirmed cases was also wrong according to the cited source. Capewearer (talk) 04:57, 18 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Medar10 (talk) 19:08, 18 June 2020 (UTC)

 Not done empty edit request. ◊PRAHLAD^balaji (M•T•A•C) This message was left at 19:10, 18 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

From the Kuwait's recovery table. change 289,512 to 29,512 Source: https://corona.e.gov.kw/En/ DragonHmd (talk) 23:11, 18 June 2020 (UTC)

 Done Thanks for catching the typo! —Tenryuu 🐲 ( 💬 • 📝 ) 00:29, 19 June 2020 (UTC)

This edit request to Template:COVID-19 pandemic data has been answered. Set the |answered= or |ans= parameter to no to reactivate your request.

Turbonerfs101e (talk) 13:10, 21 June 2020 (UTC)

Dos Madagascar death pas from 13 to 134 deaths over night!? Or it is 14 confirmed Deaths like other site!? I think of a error because 121 deaths over night will be really alarming for this little island!?!?!?!?

 Done RandomCanadian (talk / contribs) 13:41, 21 June 2020 (UTC)

I've reverted the second re-addition today by

Guayana Esequiba data is provided by the government of Guyana, however the area is included on the map with the reports from Venezuela as well (link). It must be remembered that said area is in demand by both countries.--MusicologoVzla (talk) 18:07, 19 June 2020 (UTC)

Whether we include Guayana Esequiba's numbers in Guyana's numbers here, or Venezuela's, is another discussion we may need to have. Capewearer (talk) 18:12, 19 June 2020 (UTC)

This is not a list of disputed territories. Sladnick (talk) 18:57, 19 June 2020 (UTC)

You can include the numbers in both countries and make the exception in a note, when the cases are reported separately from Guyana Esequiba.--MusicologoVzla (talk) 01:04, 20 June 2020 (UTC)

There are many territorial disputes in the world, but for none of them is that system used here – the numbers are included under the country/dependency which actually administers the territory. Sladnick (talk) 01:52, 20 June 2020 (UTC)

Sladnick, It seems to me that your deletion query (link) for the Guayana Esequiba article was not the most convenient. Because obviously it was being discussed here and apart it has its encyclopedic relevance.--MusicologoVzla (talk) 02:45, 20 June 2020 (UTC)

MusicologoVzla, this is the talk page for the Covid-19 pandemic data template. It is not the appropriate place to discuss another article. Sladnick (talk) 02:58, 20 June 2020 (UTC)

Sladnick, that is why I tell you, you sent to nominate the article for deletion, knowing that here there was before an open discussion involving the main article of COVID-19 in Guayana Esequiba.--MusicologoVzla (talk) 03:07, 20 June 2020 (UTC)

COVID-19 pandemic in the Åland Islands). The deletion discussion for the article is a separate issue. Sladnick (talk

) 03:40, 20 June 2020 (UTC)