Jump to content

User talk:Anguswalker: Difference between revisions

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
Content deleted Content added
Line 489: Line 489:
== Updates for August 1 ==
== Updates for August 1 ==
Hi. Thank you for your great work updating [[COVID-19 pandemic cases]] and [[COVID-19 pandemic deaths]]. Will you have time soon to add data for August 1? Many thanks! ([[User talk:NoWikiNoLife|talk]]) 7:50, 9 August 2021 (UTC)
Hi. Thank you for your great work updating [[COVID-19 pandemic cases]] and [[COVID-19 pandemic deaths]]. Will you have time soon to add data for August 1? Many thanks! ([[User talk:NoWikiNoLife|talk]]) 7:50, 9 August 2021 (UTC)
: Now added, sorry for the delay. Although someone's changed the format so I have probably partly reverted to the previous format [[User:Anguswalker|Anguswalker]] ([[User talk:Anguswalker#top|talk]]) 14:41, 9 August 2021 (UTC)

Revision as of 14:41, 9 August 2021

Welcome!

Hello, Anguswalker, and welcome to Wikipedia! Thank you for your contributions. I hope you like the place and decide to stay. Here are some pages that you might find helpful:

I hope you enjoy editing here and being a Wikipedian! Please sign your name on talk pages using four tildes (~~~~); this will automatically produce your name and the date. If you need help, check out Wikipedia:Questions, ask me on my talk page, or ask your question and then place {{helpme}} after the question on your talk page. Again, welcome!  Davewild 12:07, 4 May 2007 (UTC)[reply]

Election results graph

I like the graph you added to United States presidential election, 2008, but please see commons:Image talk:Election-state-04-08.png for some suggestions on how to make it even better. - dcljr (talk) 06:36, 9 November 2008 (UTC)[reply]

Thanks for the comments and for pointing me towards them! Anguswalker (talk) 10:03, 10 November 2008 (UTC)[reply]

Hi Anguswalker,

In case you don't see my response to your discussion on The Apprentice discussion page, I thought I would copy my message here:

Many thanks for your contribution. Historically, all the series weekly results tables have been determined by team. Now you are suggesting to determine results by winning or losing. IMHO the table is a summary of the events that occurred. Looking at your new way of colouring confuses how you look at the table. I am sorry but I will revert your changes until there is a consensus about changing colours for ALL the series tables. If there is strong support for the change then by all means make the changes.

Many thanks, δ²(Talk) 11:55, 22 April 2009 (UTC)[reply]

Hi, some idiot seemed to have reverted my comments on the discussion page, so I have now put them back so that a discussion can be started. I understand your point of view and appreciate that any efforts to improve an article are welcome, however I think that such a decision needs to be reached via consensus. I shall continue my comments on the discussion page. Many thanks, δ²(Talk) 12:46, 23 April 2009 (UTC)[reply]

Proposed deletion of 2009 flu pandemic table

A proposed deletion template has been added to the article 2009 flu pandemic table, suggesting that it be deleted according to the proposed deletion process because of the following concern:

This article fails Wikipedia guideline: "Wikipedia is not an indiscriminate collection of information" with the reason falling under "Excessive listing of statistics".

All contributions are appreciated, but this article may not satisfy Wikipedia's criteria for inclusion, and the deletion notice should explain why (see also "What Wikipedia is not" and Wikipedia's deletion policy). You may prevent the proposed deletion by removing the {{dated prod}} notice, but please explain why you disagree with the proposed deletion in your edit summary or on its talk page.

Please consider improving the article to address the issues raised because, even though removing the deletion notice will prevent deletion through the proposed deletion process, the article may still be deleted if it matches any of the speedy deletion criteria or it can be sent to Articles for Deletion, where it may be deleted if consensus to delete is reached. Douglasr007 (talk) 20:38, 12 June 2009 (UTC)[reply]

I have nominated 2009 flu pandemic table, an article that you created, for deletion. I do not think that this article satisfies Wikipedia's criteria for inclusion, and have explained why at Wikipedia:Articles for deletion/2009 flu pandemic table. Your opinions on the matter are welcome at that same discussion page; also, you are welcome to edit the article to address these concerns. Thank you for your time.

Please contact me if you're unsure why you received this message. Douglasr007 (talk) 18:52, 14 June 2009 (UTC)[reply]

Thank you. I have given more detail in defence of the article under its talk page and the AfD page.Anguswalker (talk) 11:19, 15 June 2009 (UTC)[reply]

Hi, when you update the Flu pandemic page, can you please make it a habit to not link to Macedonia directly, but to [[Republic of Macedonia|Macedonia]] or [[Macedonia (country)|]]? "Macedonia" is a disambiguation page, not the country article. I've now corrected that link four times on this single page, but you keep changing it back. Fut.Perf. 17:17, 16 July 2009 (UTC)[reply]

Sorry, I am updating from a spreadsheet, so will change the spreadsheet. Regards Anguswalker (talk) 18:30, 16 July 2009 (UTC)[reply]

Bizarre edit

Your edit for deaths due to flu [1] contain some bizarre numbers, like hundreds of people resurrected in the U.S. Did you switch the U.S. and Uruguay? Please correct it. Thanks. Edison (talk) 18:41, 23 July 2009 (UTC)[reply]

Sorry, got USA and Uruguay the wrong way round. Now corrected. Anguswalker (talk) 19:12, 6 August 2009 (UTC)[reply]

Latvia

Hi Anguswalker, Latvia's joining of the Eurozone is still depending on the final verdict of the ECOFIN-meeting on July 9th, 2013. --Gerd.Seyffert (talk) 19:05, 10 June 2013 (UTC)[reply]

Hi,
You appear to be eligible to vote in the current Arbitration Committee election. The Arbitration Committee is the panel of editors responsible for conducting the Wikipedia arbitration process. It has the authority to enact binding solutions for disputes between editors, primarily related to serious behavioural issues that the community has been unable to resolve. This includes the ability to impose site bans, topic bans, editing restrictions, and other measures needed to maintain our editing environment. The arbitration policy describes the Committee's roles and responsibilities in greater detail. If you wish to participate, you are welcome to review the candidates' statements and submit your choices on the voting page. For the Election committee, MediaWiki message delivery (talk) 16:21, 23 November 2015 (UTC)[reply]

ArbCom Elections 2016: Voting now open!

Hello, Anguswalker. Voting in the 2016 Arbitration Committee elections is open from Monday, 00:00, 21 November through Sunday, 23:59, 4 December to all unblocked users who have registered an account before Wednesday, 00:00, 28 October 2016 and have made at least 150 mainspace edits before Sunday, 00:00, 1 November 2016.

The Arbitration Committee is the panel of editors responsible for conducting the Wikipedia arbitration process. It has the authority to impose binding solutions to disputes between editors, primarily for serious conduct disputes the community has been unable to resolve. This includes the authority to impose site bans, topic bans, editing restrictions, and other measures needed to maintain our editing environment. The arbitration policy describes the Committee's roles and responsibilities in greater detail.

If you wish to participate in the 2016 election, please review the candidates' statements and submit your choices on the voting page. MediaWiki message delivery (talk) 22:08, 21 November 2016 (UTC)[reply]

ArbCom 2017 election voter message

Hello, Anguswalker. Voting in the 2017 Arbitration Committee elections is now open until 23.59 on Sunday, 10 December. All users who registered an account before Saturday, 28 October 2017, made at least 150 mainspace edits before Wednesday, 1 November 2017 and are not currently blocked are eligible to vote. Users with alternate accounts may only vote once.

The Arbitration Committee is the panel of editors responsible for conducting the Wikipedia arbitration process. It has the authority to impose binding solutions to disputes between editors, primarily for serious conduct disputes the community has been unable to resolve. This includes the authority to impose site bans, topic bans, editing restrictions, and other measures needed to maintain our editing environment. The arbitration policy describes the Committee's roles and responsibilities in greater detail.

If you wish to participate in the 2017 election, please review the candidates and submit your choices on the voting page. MediaWiki message delivery (talk) 18:42, 3 December 2017 (UTC)[reply]

ArbCom 2018 election voter message

Hello, Anguswalker. Voting in the 2018 Arbitration Committee elections is now open until 23.59 on Sunday, 2 December. All users who registered an account before Sunday, 28 October 2018, made at least 150 mainspace edits before Thursday, 1 November 2018 and are not currently blocked are eligible to vote. Users with alternate accounts may only vote once.

The Arbitration Committee is the panel of editors responsible for conducting the Wikipedia arbitration process. It has the authority to impose binding solutions to disputes between editors, primarily for serious conduct disputes the community has been unable to resolve. This includes the authority to impose site bans, topic bans, editing restrictions, and other measures needed to maintain our editing environment. The arbitration policy describes the Committee's roles and responsibilities in greater detail.

If you wish to participate in the 2018 election, please review the candidates and submit your choices on the voting page. MediaWiki message delivery (talk) 18:42, 19 November 2018 (UTC)[reply]

ArbCom 2018 election voter message

Hello, Anguswalker. Voting in the 2018 Arbitration Committee elections is now open until 23.59 on Sunday, 3 December. All users who registered an account before Sunday, 28 October 2018, made at least 150 mainspace edits before Thursday, 1 November 2018 and are not currently blocked are eligible to vote. Users with alternate accounts may only vote once.

The Arbitration Committee is the panel of editors responsible for conducting the Wikipedia arbitration process. It has the authority to impose binding solutions to disputes between editors, primarily for serious conduct disputes the community has been unable to resolve. This includes the authority to impose site bans, topic bans, editing restrictions, and other measures needed to maintain our editing environment. The arbitration policy describes the Committee's roles and responsibilities in greater detail.

If you wish to participate in the 2018 election, please review the candidates and submit your choices on the voting page. MediaWiki message delivery (talk) 18:42, 19 November 2018 (UTC)[reply]

File:Coronavirus increase from 1000 cases for six countries.png

Hi. First of all, thanks for your outstanding contributions. I was wondering if you could please send me the source for this graph you made. Thanks. --Mazewaxie (talkcontribs) 17:45, 26 March 2020 (UTC)[reply]

Hi Mazewaxie, I made it myself in Excel using the data from the WHO situation reports.

2019–20 coronavirus pandemic cases (Data Corrections and Data Entry)

On 2019–20 coronavirus pandemic cases I have found some data mistakes. As I don't know your process (ie possibly you are maintaining a separate offline source file), I am giving you the info here.

I have written some parsers (shell scripts) that parse the first 2 columns from WHO situation reports and the Wikipedia table. I maybe able to help you with entering the data (or at least checking it).


--Wpliu (talk) 05:54, 10 April 2020 (UTC)[reply]

Hi Wpliu, thank you for spotting these errors. I do check that the entries add up to the correct total, but I'm clearly sometimes getting individual entries the wrong way round. You're right that I am using a spreadsheet that I then copy over, so would overwrite your corrections if you made them - at least until the end of the half month. I don't have the skills to grab the data automatically but don't mind doing it each day - I am in isolation myself so it's something to do! Anguswalker (talk) 09:17, 10 April 2020 (UTC)[reply]

I am sharing my parsing results from the WHO Situation Reports at

 https://my.owndrive.com/index.php/s/NzzSJtzxTM6rfbX

It takes me <10min to do 1 day. You can use it if you want. --Wpliu (talk) 19:41, 12 April 2020 (UTC)[reply]

Thanks, that did save time! Are you planning on parsing the death figures too?


I can only do the first 2 columns. This is entirely technical.

When the table is copied from the pdf it doesn't copy over as a table as spaces are used for delimiting fields. The problem is that there are spaces in the data values and specifically some of the numbers. So I cannot differentiate whether a number has an embedded space or if it is two numbers in two different columns.

I am getting by because the country names don't have numbers, the numbers are only characters [0-9] (possibly with embedded spaces) and there are only 2 columns. My field separator is actually [non-number][space][number]. I am already manually fixing situations where multi-line country names are split across pages.

I am using Foxit Reader rather than Acrobat Reader because Acrobat Reader has completely unusable output (everything ends up in 1 column).


Found inconsistencies. If this is errata, then it should probably be footnoted.

Country Date Wiki Value Who Value
Indonesia 2020-04-11 3842 3512

--Wpliu (talk) 01:29, 14 April 2020 (UTC)[reply]

OK, fair enough, thanks for letting me know. Someone else changed that Indonesia figure but it does look more likely. Anguswalker (talk) 09:25, 14 April 2020 (UTC)[reply]


You may be interested in my charts. (The whole reason I am interested in the raw data)

 https://my.owndrive.com/index.php/s/WiXkG4gEgHp2ypT

--Wpliu (talk) 06:13, 15 April 2020 (UTC)[reply]


I have a partial solution for the Who Situation Report death figures. I have parsed the entire table from the situation reports, but eliminated the lines with the subtotal and the total.

 https://my.owndrive.com/index.php/s/xkcjLWHToqatMrr

--Wpliu (talk) 20:26, 22 April 2020 (UTC)[reply]

It's in a different format today, can your software cope? Anguswalker (talk) 18:48, 1 May 2020 (UTC)[reply]

That looks great, thanks! Anguswalker (talk) 21:45, 22 April 2020 (UTC)[reply]

Pandemic data reverts

You have reverted my edits by changing US->USA in one of the tables twice now, without any comment. Please stop. https://en.wikipedia.org/w/index.php?title=2019%E2%80%9320_coronavirus_pandemic_cases&oldid=952543847

I personally don't care if it's US or USA, I am editing for consistency across tables. Kirils (talk) 09:11, 23 April 2020 (UTC)[reply]

I have changed it to US, it was happening because I replace the whole table each time. Not sure why US is preferable to USA?
And now seems that someone has edited all the other tables so it's "USA" everywhere except the newest table. Could you please used that now. I personally think USA is preferable however what's most important for the reader is to have consistency between tables. Your work is much appreciated. Kirils (talk) 08:48, 25 April 2020 (UTC)[reply]
OK!

Covid-19 Days to Double Metric Calculation

I was updating the Cov-19 cases and you beat me to it by 8 mins.

Ah sorry, the situation report came out late and your figures came out after I'd retired for the night Anguswalker (talk) 07:27, 30 April 2020 (UTC)[reply]

Don't worry about it. I just thought you might need some help. Updating 200 numbers accurately every day is a substantial amount of work.

FYI, I might be able to give you the data part of the wiki table based on the existing table and appending the new numbers. The table needs to exist already though. This may not be a benefit to you since you are maintaining your own data files.

--Wpliu (talk) 19:31, 30 April 2020 (UTC)[reply]


I have a question about the "Days to double".

I have not found this value in the situation reports. It appears that you are looking back for the day that had a World total less than half of the current day and counting the number of days in between.

Yes Anguswalker (talk) 07:27, 30 April 2020 (UTC)[reply]

I am not sure if this is the normal convention. As, this methods tells what was, rather than what will be. The doubling time (kind of the opposite of half life) is only useful in the early stage of the pandemic where exponential growth is occurring. Consequently, taking a local slope and extrapolating forward in time is probably more appropriate.

Maybe not and perhaps I should call it something else - 'days since half', or something? Anguswalker (talk) 07:27, 30 April 2020 (UTC)[reply]

I think 'days since half' is a better label.

However, thinking more about this. Consider SARS 1. The current 'days since half' would be about 17 years. Not exactly a good metric indicative that the pandemic is over.

--Wpliu (talk) 19:31, 30 April 2020 (UTC)[reply]


I don't know what the definition is for this value. Have you found a definition for this?

I should say, I don't like this value beyond the exponential stage. Pretty much all the 2nd wave countries are out of the exponential growth stage now. Any metrics that only uses a single value of the total number of cases are not that useful long term (differences are ok). If you want a better value for the doubling time, just wait. Wait 10 years then the doubling time will be 5 years (backwards difference, 10 years forward difference).

FYI. The best metric is daily increase per capita. That is what I plotted on my charts.

--Wpliu (talk) 07:18, 30 April 2020 (UTC)[reply]

2019–20 coronavirus pandemic raw data (cases and sitrep table) (2020-06-11 to 2020-06-15)

(Changed title)

I am probably going to be late or may miss the day entirely.

I will only do the full table for there days as it is easier for me to do that remotely and it has both sets of data that you use.

--Wpliu (talk) 17:35, 11 June 2020 (UTC)[reply]

OK, thanks for letting me know, I only use the full table, in fact. There were some issues with yesterday's one (WHO's table, that is), e.g French Guiana appearing twice and Puerto Rico missing Anguswalker (talk) 19:02, 11 June 2020 (UTC)[reply]


The WHO updated data for

 Date:          2020-06-10
 File:          20200610-covid-19-sitrep-142.pdf
 New File Date: 2020-06-11_11:23:45 UTC

This has been parsed and re-uploaded

 File:  raw_all_who_data_20200610.txt

Changes to:

 * Puerto Rico
 * Kosovo
 * Isle of Man

--Wpliu (talk) 05:55, 12 June 2020 (UTC)[reply]

Reminder about 2020-06-10 (above) --Wpliu (talk) 07:25, 14 June 2020 (UTC)[reply]



2020-06-11 up Wpliu (talk) 04:34, 12 June 2020 (UTC)[reply]

2020-06-13 up Wpliu (talk) 07:25, 14 June 2020 (UTC)[reply]

2020-06-14 up Wpliu (talk) 22:33, 14 June 2020 (UTC)[reply]

2020-06-15 up Wpliu (talk) 01:08, 16 June 2020 (UTC)[reply]

2020-06-16 up Wpliu (talk) 20:04, 16 June 2020 (UTC)[reply]

2020-06-17 up Wpliu (talk) 20:05, 17 June 2020 (UTC)[reply]

2020-06-18 up Wpliu (talk) 19:49, 18 June 2020 (UTC)[reply]

2020-06-19 up Wpliu (talk) 18:29, 19 June 2020 (UTC)[reply]

2020-06-20 up Wpliu (talk) 16:52, 20 June 2020 (UTC)[reply]

2020-06-21 up Wpliu (talk) 19:47, 21 June 2020 (UTC)[reply]

2020-06-22 up Wpliu (talk) 18:02, 22 June 2020 (UTC)[reply]

2020-06-23 up Wpliu (talk) 18:48, 23 June 2020 (UTC)[reply]

2020-06-24 up Wpliu (talk) 18:33, 24 June 2020 (UTC)[reply]

2020-06-25 up Wpliu (talk) 19:44, 25 June 2020 (UTC)[reply]

2020-06-26 up Wpliu (talk) 16:29, 26 June 2020 (UTC)[reply]

2020-06-27 up Wpliu (talk) 18:24, 27 June 2020 (UTC)[reply]

2020-06-28 up Wpliu (talk) 18:59, 28 June 2020 (UTC)[reply]

2020-06-29 up Wpliu (talk) 16:39, 29 June 2020 (UTC)[reply]

I don't see it? Anguswalker (talk) 18:40, 29 June 2020 (UTC)[reply]
Sorry, wrong directory. FYI I can't figure out how to setup email notifications. Wpliu (talk) 17:44, 30 June 2020 (UTC)[reply]

2020-06-30 up Wpliu (talk) 18:10, 30 June 2020 (UTC)[reply]


2020-07-01 up Wpliu (talk) 00:18, 2 July 2020 (UTC)[reply]

2020-07-02 up Wpliu (talk) 19:20, 2 July 2020 (UTC)[reply]

2020-07-03 up Wpliu (talk) 20:03, 3 July 2020 (UTC)[reply]

2020-07-04 up Wpliu (talk) 16:23, 4 July 2020 (UTC)[reply]

2020-07-05 up Wpliu (talk) 16:58, 5 July 2020 (UTC)[reply]

2020-07-06 up Wpliu (talk) 19:12, 6 July 2020 (UTC)[reply]

2020-07-07 up Wpliu (talk) 17:27, 7 July 2020 (UTC)[reply]

2020-07-08 up Wpliu (talk) 18:56, 8 July 2020 (UTC)[reply]

2020-07-09 up Wpliu (talk) 18:32, 9 July 2020 (UTC)[reply]

2020-07-10 up Wpliu (talk) 16:46, 10 July 2020 (UTC)[reply]

2020-07-11 up Wpliu (talk) 16:15, 11 July 2020 (UTC)[reply]

2020-07-12 up Wpliu (talk) 16:24, 12 July 2020 (UTC)[reply]

2020-07-13 up Wpliu (talk) 18:34, 13 July 2020 (UTC)[reply]

2020-07-14 up Wpliu (talk) 18:11, 14 July 2020 (UTC)[reply]

2020-07-15 up Wpliu (talk) 19:16, 15 July 2020 (UTC)[reply]

Thanks, but the file is incomplete Anguswalker (talk) 21:08, 15 July 2020 (UTC)[reply]
Sorry. This one is the right size Wpliu (talk) 13:51, 16 July 2020 (UTC)[reply]

2020-07-16 up Wpliu (talk) 20:12, 16 July 2020 (UTC)[reply]

2020-07-17 up Wpliu (talk) 20:32, 17 July 2020 (UTC)[reply]

2020-07-18 up Wpliu (talk) 18:50, 18 July 2020 (UTC)[reply]

2020-07-19 up Wpliu (talk) 19:49, 19 July 2020 (UTC)[reply]

2020-07-20 up Wpliu (talk) 19:26, 20 July 2020 (UTC)[reply]

2020-07-21 up Wpliu (talk) 20:37, 21 July 2020 (UTC)[reply]

2020-07-22 up Wpliu (talk) 18:55, 22 July 2020 (UTC)[reply]

2020-07-23 up Wpliu (talk) 19:43, 23 July 2020 (UTC)[reply]

2020-07-24 up Wpliu (talk) 18:45, 24 July 2020 (UTC)[reply]

2020-07-25 up Wpliu (talk) 16:25, 25 July 2020 (UTC)[reply]

2020-07-26 up Wpliu (talk) 17:58, 26 July 2020 (UTC)[reply]

2020-07-27 up Wpliu (talk) 20:16, 27 July 2020 (UTC)[reply]

2020-07-28 up Wpliu (talk) 17:24, 28 July 2020 (UTC)[reply]

2020-07-29 up Wpliu (talk) 18:21, 29 July 2020 (UTC)[reply]

2020-07-30 up Wpliu (talk) 18:02, 30 July 2020 (UTC)[reply]

2020-07-31 up Wpliu (talk) 17:54, 31 July 2020 (UTC)[reply]

2020-08-01 up Wpliu (talk) 17:46, 1 August 2020 (UTC)[reply]

2020-08-02 up Wpliu (talk) 16:25, 2 August 2020 (UTC)[reply]

2020-08-03 up Wpliu (talk) 20:29, 3 August 2020 (UTC)[reply]

2020-08-04 up Wpliu (talk) 18:19, 4 August 2020 (UTC)[reply]

2020-08-05 up Wpliu (talk) 17:49, 5 August 2020 (UTC)[reply]

2020-08-06 up Wpliu (talk) 21:14, 6 August 2020 (UTC)[reply]

2020-08-07 up Wpliu (talk) 18:36, 7 August 2020 (UTC)[reply]

2020-08-08 up Wpliu (talk) 17:41, 8 August 2020 (UTC)[reply]

2020-08-09 up Wpliu (talk) 18:14, 9 August 2020 (UTC)[reply]

2020-08-10 up Wpliu (talk) 21:06, 10 August 2020 (UTC)[reply]

2020-08-11 up Wpliu (talk) 18:54, 11 August 2020 (UTC)[reply]

2020-08-12 up Wpliu (talk) 18:59, 12 August 2020 (UTC)[reply]

2020-08-13 up Wpliu (talk) 17:20, 13 August 2020 (UTC)[reply]

2020-08-14 up Wpliu (talk) 18:16, 14 August 2020 (UTC)[reply]

2020-08-15 up Wpliu (talk) 18:24, 15 August 2020 (UTC)[reply]

2020-08-16 up Wpliu (talk) 18:29, 16 August 2020 (UTC)[reply]

covid19

hi please creat 2 article 1 covid 19 number of cases added in 1 day example china 2 july 31 3 july 15 4 july 9 and other countries and world 2 covid 19 number of deaths in 1 day example china july2 0 july 3 0 july 4 0 thanks Amirh123 (talk) 17:59, 7 July 2020 (UTC)[reply]

You want equivalent charts but daily increases instead of total numbers? That's a big job, I'll think about it Anguswalker (talk) 20:02, 8 July 2020 (UTC)[reply]

I think you can use the bot to creat this 2 articles for number cases bot go to COVID-19 pandemic cases and use minus example china 4 july 85287 - 3 july 87278 =9 and for number deaths go to COVID-19 pandemic deaths and use the same way Amirh123 (talk) 13:23, 12 July 2020 (UTC)[reply]

Coronavirus cases/deaths pages

Hey, I'm a data dork who has been copying & using the data spreadsheets that you're creating on the COVID-19 pandemic cases and COVID-19 pandemic deaths pages. I noticed that there hadn't been any updates for a few days. Do you need help updating these? Maybe I could take some days off your plate? I personally think it's important to have an easily publicly accessible record of the pandemic. CircleAdrian (talk) 01:14, 17 July 2020 (UTC)[reply]

I was busy for a couple of days but have updated the data now. Glad you like it. Anguswalker (talk) 21:59, 17 July 2020 (UTC)[reply]

WHO Situation Reports format (weekly) 2020-08-17 onwards

https://www.who.int/emergencies/diseases/novel-coronavirus-2019/situation-reports/

It appears that they have changed to a weekly summary.

I suggest we wait 1 day and see if they continue updating the daily reports.

If not then we need to decide what to do.

Wpliu (talk) 04:18, 18 August 2020 (UTC)[reply]

Hmm, OK, this could turn into a weekly update Anguswalker (talk) 07:14, 18 August 2020 (UTC)[reply]


Weekly report

2020-08-17 up Wpliu (talk) 17:47, 18 August 2020 (UTC)[reply]

Thanks, it's the same totals as the 16 August daily report, so I guess we wait until next week for new figures? Anguswalker (talk) 18:27, 18 August 2020 (UTC)[reply]
I have just discovered that they are still producing daily data at this page, and a full CSV can be downloaded https://covid19.who.int/table
This is what I have been looking for all along.
Do you want me to continue with the now weekly report? Wpliu (talk) 18:02, 22 August 2020 (UTC)[reply]
No need, if you can use this one, although it seems to update frequently. Once a new day's figures start appearing, presumably the previous day is complete? Anguswalker (talk) 18:20, 22 August 2020 (UTC)[reply]



Daily report data I have put the data in a database and have reformatted it in a conventional table Countries/Dates

https://my.owndrive.com/index.php/s/rDC227CwJK3RF3r

Wpliu (talk) 21:12, 29 August 2020 (UTC)[reply]

2020-09-01 up Wpliu (talk) 03:56, 2 September 2020 (UTC)[reply]
2020-09-02 up Wpliu (talk) 17:26, 2 September 2020 (UTC)[reply]
Hi, the dates are coming up as 2020-01-01 etc, and the numbers as zero FYI. In fact the WHO CSV works OK for me now so I don't think I need your parsing of it from now on. Thank you very much for doing it over the last few months though, it saved me a lot of time!

Totals

Hi there. Thank you for all the great work you've been doing with https://en.wikipedia.org/wiki/COVID-19_pandemic_cases#Second_half_8 . It's really appreciated. Just a quick questions - are the World totals for Sep 21 and Sep 22 correct? I can't seem to find that data in the WHO .csv file to double check. Thanks! :) NoWikiNoLife 22:56, 23 September 2020 (UTC)[reply]

No, you're right, thanks for spotting, now corrected. Anguswalker (talk) 08:34, 24 September 2020 (UTC)[reply]

Thank you for your COVID stats work!

Hi Anguswalker,

I saw that you've been working on keeping COVID-19_pandemic_cases up to date – you're amazing :) Not sure if you're aware, but the data from this page (and now the monthly pages) is being picked up by Google and shown in Google Search and their COVID stats tracker (i.e., this). If you're planning to create the new page for November daily stats, would you mind giving me a ping before you do so, so I can update the Google team to switch over to the current month's page and avoid any breakage/gap in reporting? There's also a mailing list that some folks from WikiProject COVID-19 and the Google team are monitoring (covid-19-stats@lists.wikimedia.org) – highly encourage you to join and post there, if you'd like :) You can subscribe here.

Massive thank-you again for your hard work on this (and swine flu)!

Maryana (WMF) (talk) 22:22, 9 October 2020 (UTC)[reply]

Thank you, will do! How do I give you a ping? Anguswalker (talk) 09:11, 10 October 2020 (UTC)[reply]
Great, thank you! You can leave a note on my talk page or email me at mpinchuk@wikimedia.org. Much appreciated :) Maryana (WMF) (talk) 13:50, 10 October 2020 (UTC)[reply]

Thanks for COVID-19 pandemic deaths#Monthly totals

Thanks for COVID-19 pandemic deaths#Monthly totals.

That table is enlightening. It clearly shows when any country peaked, slowed down, and started climbing up rapidly in deaths again.

It shows how pathetically some countries (US, UK, Brazil, etc.) are doing when compared with other countries. --Timeshifter (talk) 04:25, 15 October 2020 (UTC)[reply]

ArbCom 2020 Elections voter message

Hello! Voting in the 2020 Arbitration Committee elections is now open until 23:59 (UTC) on Monday, 7 December 2020. All eligible users are allowed to vote. Users with alternate accounts may only vote once.

The Arbitration Committee is the panel of editors responsible for conducting the Wikipedia arbitration process. It has the authority to impose binding solutions to disputes between editors, primarily for serious conduct disputes the community has been unable to resolve. This includes the authority to impose site bans, topic bans, editing restrictions, and other measures needed to maintain our editing environment. The arbitration policy describes the Committee's roles and responsibilities in greater detail.

If you wish to participate in the 2020 election, please review the candidates and submit your choices on the voting page. If you no longer wish to receive these messages, you may add {{NoACEMM}} to your user talk page. MediaWiki message delivery (talk) 01:31, 24 November 2020 (UTC)[reply]

Date of first death in United States

Hello! I wanted to let you know that the date of the first death in the United States listed at COVID-19 pandemic deaths is incorrect. The date is listed as 3 March but the actual first death was 6 February, according to these sources here, here, and here. Could you take a look at this? Thank you in advance! Herbfur (Eric, He/Him) (talk) 15:45, 12 January 2021 (UTC)[reply]

Thank you for your message. The page records deaths as reported to WHO, and the first death was indeed reported on 3 March. I think it is more useful if it uses a consistent source rather than any source, however reliable. Anguswalker (talk) 20:44, 12 January 2021 (UTC)[reply]
Understood, thank you for your response. Would you be OK with adding a note to the article explaining this? Herbfur (Eric, He/Him) (talk) 17:32, 13 January 2021 (UTC)[reply]
I think there should be a note explaining that this is old info as first reported by WHO in their daily situation reports. And that we are keeping that date as an historical record. Also, we should note that we are doing this because it would be way too time-consuming to vet updates for a couple hundred countries.
I am not wedded to this though, and if someone wants to do that vetting, then I am OK with that too. But from my experience with country lists it is much better for one's sanity to use only one source, and let them do the vetting.
It would be nice if WHO had a first death list that they continually updated. Or John Hopkins. Do either of those trusted sources have one yet?
In the meantime I added this note to the 2020 section:
COVID-19 pandemic deaths#2020
"First death" column is for first reported death by WHO in their daily situation reports, and is kept as an historical record. Earlier deaths, as they are found by others, will have to go in another article.
Feel free to clarify it. --Timeshifter (talk) 13:53, 15 January 2021 (UTC)[reply]

Day to day COVID-19 numbers

Where did you get day-to-day numbers of the number of COVID-19 cases for articles like COVID-19 pandemic cases in April 2021? (I have only found the weekly updates.) Your sources need to be added as references. Velayinosu (talk) 01:51, 24 July 2021 (UTC)[reply]

They are from https://covid19.who.int/WHO-COVID-19-global-data.csv - I agree, I (or someone) should add them as references. Anguswalker (talk) 18:19, 7 August 2021 (UTC)[reply]

Updates for August 1

Hi. Thank you for your great work updating COVID-19 pandemic cases and COVID-19 pandemic deaths. Will you have time soon to add data for August 1? Many thanks! (talk) 7:50, 9 August 2021 (UTC)

Now added, sorry for the delay. Although someone's changed the format so I have probably partly reverted to the previous format Anguswalker (talk) 14:41, 9 August 2021 (UTC)[reply]