![]() | This is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page. |
Archive 5 | Archive 6 | Archive 7 | Archive 8 | Archive 9 |
The table in this section needs to be removed from the article:
It is being maintained mainly by 1 or 2 people lately (see history) vetting hundreds of sources. Here is the table template:
There is no way the above-linked table can be as accurate, or as regularly and fully updated, as this table updated daily by a bot:
It is found in this section:
Its reference: {{ COVID-19 data/Cite}}:
The link in that reference:
Then scroll down to "Download database" box and clicking it to go here and see databases:
-- Timeshifter ( talk) 11:52, 28 September 2021 (UTC)
LSGH. Template:COVID-19 pandemic data and its section would be removed from this article. The section containing Template:COVID-19 pandemic death rates would remain. -- Timeshifter ( talk) 12:32, 2 October 2021 (UTC)
@ Timeshifter: I would prefer to remove "The table is updated daily by a bot" (and links to Template:COVID-19 data/Cite) from COVID-19 pandemic by country and territory#Total cases, deaths, and death rates by country (Our World in Data) and COVID-19 pandemic by country and territory#Total cases, deaths, and death rates by country (Our World in Data). This is somewhat of a self-reference, and I don't think it should be in the text of the article. I do not think the link to Template:COVID-19 data/Cite is helpful; that template is just the citation (displayed in the reference in the table). A better alternative would be to use Template:COVID-19 data/Date for an automatically-updating date for when the data was last updated. Tol ( talk | contribs) @ 16:59, 3 October 2021 (UTC)
Bit of a long one this. I’ve been recording the available coronavirus statistics on a daily basis since the 9th January 2020 and started noting down any figures I heard in media reports from China on a spreadsheet on 3st December 2019. Since then this has grown as statistical websites have become available to include daily country by country figures from Wikipedia, WorldOMeter, Testing, Vaccines, UK, England, Scotland, Wales, N. Ireland, Rep of Ireland and various UK regions into a 38Mb file collection of daily data.
To the spreadsheet above I add my own columns e.g. on the paste copy of the < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases_and_deaths_(mixed_sources)> table that I take every day. I add new Death Rate, Daily Deaths, Daily Cases and Recoveries columns taking the previous days data from the latest data. By doing this every day on a spreadsheet it’s easy to cross check figures and I know what is updated and what is not. The Wikipedia table is usually the most accurate, bots or no bots. It’s very easy to see what is updated and what is not updated on a daily basis.
As a result of copying the figures on to a spreadsheet it’s easy to spot some of the inconsistencies and occasional errors on the reporting of daily figures on the UK countries websites, the Republic of Ireland’s government’s website and very occasionally on the Wikipedia table if data had been entered incorrectly, maybe an extra digit, wrong digit etc. If this happens I can cross check with the links for each country’s coronavirus reporting website provided in the notes on Wikipedia and correct any mistakes accordingly. The way it is since yesterday, users have no idea where this data is coming from as there are no references provided in the Wikipedia notes anymore. For instance, one example of these errors that occurs on an almost daily basis is that I noticed the cumulative figures for coronavirus deaths in certain English regions decreasing instead of increasing each day resulting in minus daily deaths. This is still happening in about 2 or 3 regions a day but back in March / April of this year there was a decrease in the total death figures of about twenty to forty deaths a day with no explanation given.
Just a few points.
1 – I don’t know about programming or about Bots but I do know about statistics and it’s usually garbage in, garbage out. I used to look at the OWID site last year but the data on it wasn’t updated as often as the Wikipedia or WorldOmeter sites and sometimes some data wasn’t updated for weeks or was inaccurate. This may have changed since then and it looks as if there is a lot more data sets than there was.
I’ve just done a quick check for today’s UK figures which are posted once daily and it looks as though nothing has changed in the past year on OWID. OWID is still out of date and not only out of date, it is also posting incorrect figures. For example, the UK Deaths for two days ago was 127, yesterday was 121, today is 43. < https://coronavirus.data.gov.uk/details/deaths>
OWID latest UK deaths is showing 124 ( wherever they get that from, there has never been 124 deaths reported on any single day since the beginning of the pandemic in the UK). < https://ourworldindata.org/covid-deaths>
Today’s current official UK Total Cumulative Death Total within 28 days of a positive test is 136,953 as at the top of the page on the .gov.uk link above. Wikipedia now shows this as 137,295, an increase of 382 deaths since yesterday’s correct Wikipedia total. There are 43 new deaths in the UK today, not 124 or 382. OWID is both inaccurate and out of date. This Wikipedia table is now a nonsense. I wish editors who don’t know what they’re doing would just leave well enough alone. If it’s working, leave it. If the figures are not accurate as is the case now, you’ll soon get to know about it. If it is to be changed, then someone who knows what they’re doing needs to change it and the automated update needs to scrape all the government sites around the world as in the reference notes for the original table for the official figures i.e. as in the table until yesterday.
Today’s official UK case cumulative total is 7,900,680. < https://coronavirus.data.gov.uk/details/cases>
Wikipedia / OWID case cumulative total is 7,908,091 or as in the link below the figure is listed as ‘7.91 million’. Accurate it is not. < https://ourworldindata.org/covid-cases>
Some countries update in real time and so their figures do update throughout the day depending when you check them but the UK is not one of them. They release their new official figures every day 16:00 pm. There’s no argument here, the Wikipedia / OWID figures are now inaccurate and should no longer be relied on. They’re about as ‘accurate’ as they were last year. If you check the links above you can see this for yourself.
I could go on but I hope it’s point taken.
2 – There used to be a noticeable Yellow Box Note at the top of the ‘Talk:COVID-19 pandemic by country and territory’ page last year, < /info/en/?search=Talk:COVID-19_pandemic_by_country_and_territory> with a warning not to use the World In Data statistics, I think it was, in Wikipedia as they were unreliable. I agreed with this then and after checking some of the figures today, I still agree with it although I see that the warning box has been removed. There is a note about accuracy on WorldOMeter.info from April 2020 so it could be this that I’m thinking of. This may have been the case at the time but they appear to me to have been accurate for about a year now, more accurate than OWID anyway. I hope I’ve shown the inaccuracy of the OWID data above.
3 – Wikipedia / OWID now has 194 Countries and Territories covered, < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases,_deaths,_and_death_rates_by_country_(Our_World_in_Data)>
Old Wikipedia table had 243 < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases_and_deaths_(mixed_sources)>
WorldOMeter which is now more accurate than Wikipedia has 229 < https://www.worldometers.info/coronavirus/#countries>
Not now included - Abkhazia, American Samoa, Anguilla, Antarctica, Artsakh, Aruba, Bermuda, Bonaire, British Indian Ocean Territory, British Virgin Islands, Cayman Islands, Charles de Gaulle, Coral Princess, Costa Atlantica, Diamond Princess, Djibouti, Donetsk PR, Falkland Islands, Faroe Islands, French Polynesia, Gibraltar, Greenland, Greg Mortimer, Guam, Guernsey, HNLMS Dolfijn, Isle of Man, Jersey, Luhansk PR, Macau, Montserrat, MS Zaandam, New Caledonia, Nicaragua, Northern Cyprus, Northern Mariana Islands, Puerto Rico, Saba, Sahrawi Arab DR, Saint Helena, Ascension and Tristan da Cunha, Saint Pierre and Miquelon, SeaDream I, Sierra Leone, Sint Eustatius, Sint Maarten, Somaliland, South Ossetia, Transnistria, Turks and Caicos Islands, U.S. Virgin Islands, USS Theodore Roosevelt, Vatican City, Wallis and Futuna
From your list Cape Verde, East Timor and Gambia are included but well spotted, Curacao is not in the old Wikipedia, OWID or in WorldOMeter.info.
4 – ‘Even the few editors who remain are no longer able to update the template as often as they used to.’ I check these figures every day. I would say that the figures are updated more now than they were a year ago. There are also more countries being updated on an almost daily basis than were being updated last year.
5 – Leave ‘Country’, ‘Confirmed’, ‘Deaths’, ‘Recoveries’ columns in the order they are in and as it was, and add in a new ‘Deaths/Million’ column on the right if need be. More data is usually better than less data.
6 – ‘ Recoveries ‘ column data was updated on a daily basis on the < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases_and_deaths_(mixed_sources)> table for most countries as I check it every day and new recovery figures appear against almost all countries on a daily basis, although twenty-one countries or territories out of two hundred and forty-two do not post any recovery data at all. This data gives a rough number of people infected in any particular territory over a two or three week period.
7 – I’ve had a discussion like this before back in June 2020 when a Wikipedia editor wanted to remove the world country by country coronavirus Testing statistics table from the main < /info/en/?search=2019-20_Wuhan_coronavirus_outbreak> page as it was then and deprive the Wikipedia world of these figures forever. This dismayed me so much that I had to open an account and comment. Thankfully he reversed his opinion and coronavirus Testing now has a page in it’s own right.
8 – Thank you to the contributors who keep these pages updated. Believe me I understand what a job it is if being done manually as it takes me about 45 mins to 1.5 hours each day (if there are errors to research and correct) and it does take a certain amount of dedication. A bot to do the work would obviously be an easier solution but it should be Wikipedia’s own bot with the tables updated from the links in the previous reference notes as in the figures from each government. There must be lots of people out there in Wikiworld who could throw together a perfectly accurate bespoke bot from the original reference notes for these Wikipedia pages. I wish I knew how to do it myself. Until that project is able to be completed then I would propose that no changes are made and that the table remains as it was up until a day ago. I have referenced many of these government reporting websites myself since last year when I have suspected an error and although sometimes it is bit of an educated guess for myself to get the correct figure because of the different languages and script, they are, no doubt, the most accurate source of information and I feel both comfortable and confident with the figures I’ve had to enter from time to time by referencing the Wikipedia reference notes for each country. When you’ve been doing this a while, it’s plain to see that many governments around the world have their own agendas but they are the best that we have at present. Although seemingly convenient, OWID is really not our solution and it’s just not good enough for Wikipedia.
9 - Trust in Wikipedia’s figures is important and I know that I for one have grown over time to trust the figures in Wikipedia’s table and the way that they have been compiled so far. That trust has dissipated overnight to the point that I know now that they’re useless. BringBackTheStats ( talk) 02:26, 4 October 2021 (UTC)
Government changes definition of death to those occuring within 28 days of a positive test. We have revised the historical death data to match this reporting. | time_series_covid19_deaths_global.csv | The change in definition results in a loss of around 5000 deaths from the official tally. | Data accessed from the official webpage on August 17 was used to recreate the time series file. |
@Tol: @Timeshifter: Hi. I don’t have the time to go through all your points and reply to you properly tonight but I have been looking into it a bit as you do. Forget about the UK figures. They’re in a world of their own. I could spend days explaining the bubble notes I’ve made on the UK spreadsheet when figures don’t look right, or figures have been revised up or down or sometimes just a mistake by someone. I might have a go at counting them all sometime just to see how many there are. There’s a good example of this in the NI coronavirus deaths registered which happened around the first or second week of 2021. It now looks as if no-one will ever correct it as I suspect it’s being transferred into the UK .gov website automatically otherwise someone would have picked it up by now.
Anyway, this isn’t about OWID not posting the correct UK figures and making up their own figures. That was just one example. I told you I could go on but I thought you’d get the point. Look at Ireland’s figures, look at France’s, look at Singapore, look at almost any country’s official figures. The OWID figures don’t bear any relation to any country that I have looked at. It could be the case that they’re actually a more accurate nonsense than the government websites but no-one will ever know. The officially compiled figures are all we have to go on. The OWID are like something they made up a while ago and compiled as they see fit with the aid of a bot merrily churning out figures that everyone seems to have forgotten about or at least that was the impression I was left with.
You said that OWID get their figures from John Hopkins so I spent an hour and a half on the John Hopkins website this evening trying to locate the definitive sources for their information and how their figures are compiled. I did searches on Google. I didn’t find a link on Google, so on to the John Hopkins. I expected to find loads of links and references all over their coronavirus homepage or at least in the footers saying, ‘ This is how we compile our data.’ Or ‘For a list of our sources please click here.’ I couldn’t find any such link or page. I ended up going down so many dead ends on that website that I became infuriated and gave up. I had expected to see a clearly marked page listing the references for each country like Wikipedia had. I couldn’t find it. I found a few references to data they had used for maybe four or five countries but a lot of those led nowhere, i.e. to private company apps that had given up the task or links to dead websites that hadn’t been updated since last year. Maybe I’m really dumb but I’ve been following these figures for a while now and have usually bee able to locate the source references. OWID are not the official figures. Wikipedia’s figures were the officially released figures for each country and it was excellent to get them all in one table. If someone does know of a link to their data sources for each country then please post it so I can have a look at it.
@Timeshifter : That is the correct UK deaths by date reported figure but not for the 1st Oct. It’s the figure released at 16:00 on the 30th Sept 2021. Those are the official UK figures on https://covid19.who.int/WHO-COVID-19-global-data.csv but the figures in the New Daily Cases column don’t look right. If you check on the Cases tab on the .Gov coronavirus website ( link above ) -> Cases by Date Reported -> UK Total -> Data you’ll see that they’re not the official figure. It’s something that the WHO is doing itself, i.e. adding a column that I’ve also added myself on my UK spreadsheet tab, calculating the difference between the previous day’s Cumulative Case Total figure from the present day’s release of the Cumulative Case Total as one day I thought to myself that those figures don’t add up. The official UK Daily New Case released figure is usually more than the figure in that WHO column and is currently about an average of about 600 more cases a day over the past month or so or to put it another way, the reported UK Cumulative Total Cases figure is about 18,000 cases short every month to the officially reported Daily New Cases at present but that fluctuates over time. It could just be that collectively as a nation the UK is just not very good at adding up but a few more teachers and a reduction in class sizes should rectify that swiftly.
You’re only scratching the surface but I’m glad that you’re slowly getting sucked into the nuanced, intricate and muddy world of coronavirus data manufacture. Now multiply all of this by the number of countries on this planet by all the various social pressures in our modern world and I hope you can see how complicated this is. Now I don’t have anything against bots, as I said myself I wish I had the knowledge to do it myself but I hope you can see why this is a world that is encouraged by blind trust in simple bots that once let off their leash should by rights entail just as much ongoing monitoring to ensure that they’re still on the right path but in reality are probably forgotten about at times and just let run their merry way. It’s a world that humans are needed to constantly monitor. I have confidence in the Wikipedia data because everything is referenced and I can check it myself and have done so many times. I don’t have confidence in the OWID data because I don’t know where it comes from, I can’t check it, it’s not referenced and their numbers that I have tried to check against official sources are something completely different from that official data. As I said before, until we know where these figures come from, they’re not credible and it’s a case of garbage in, garbage out. Again as I’ve said before this isn't about the UK figures, check the OWID data against other country's official data. BringBackTheStats ( talk) 09:02, 5 October 2021 (UTC)
@Timeshifter: I’ll have to check links above again in more detail but I have checked some of the links already and I couldn’t find the data references when I looked yesterday. BringBackTheStats ( talk) 03:49, 6 October 2021 (UTC)
|
Can you also show the number of recoveries in the COVID-19 table? Qhairun ( talk) 15:36, 11 October 2021 (UTC)
Please I want the old COVID-19 statistic table back. Qhairun ( talk) 15:41, 11 October 2021 (UTC)
BringBackTheStats. See:
The Github csv links do not operate as they do in other places that I have found csv files.
There you have to click them once before downloading the "Raw" csv file. For example, go here:
Click on total_deaths_per_million.csv
It opens into a Github page with a scrolling window consisting of plain text csv. Download the "Raw" csv file. Open it in freeware LibreOffice Calc. It is a spreadsheet with the deaths per million data for every day for every country. -- Timeshifter ( talk) 00:41, 17 October 2021 (UTC)
For File:COVID-19 Outbreak World Map Total Deaths per Capita.svg there are no longer any countries with <0.1 deaths per 100,000 population, so it might be a good idea to remove the lightest shade in the legend. An update to the range of values for each shade might also be appropriate; there are now only 6 countries in the 0.1–0.6 range, 19 in the 0.6–3.3 range, 42 in the 3.3–18 range, 52 in the 18–100 range, 67 in the 100–555 range, and just 1 in the 555+ range. JACKINTHEBOX • TALK 10:33, 19 October 2021 (UTC)
Timeshifter, regarding your revert to my edit, from what i can tell, the table to which i added tonga currently does not appear to use citations, so i decided to not add a visible one to it, to conform with the entries already present. also, i am not sure how i would go about providing a citation for the table from which i removed tonga, since the removal of the entry results in there being no entry for which a citation could be provided. i had added a source in a comment so that other editors who questioned the edit could easily verify that the edit was warranted, and not have to look for one to confirm. because you reverted my edit, i am assuming that i am missing something here, but i cannot seem to figure out what it is. it has been a while since i last edited this page, so i apologize if i am unaware of any significant changes since then.
also, admittedly, i don't consider the age of my account to be evidence of knowledge of current editing standards. much of what i have learned is outdated now, and i still look to edits from younger accounts to understand what is now acceptable. similarly, i believe most of my edits on pages dealing directly with the pandemic were made during the first half of last year, so i acknowledge that much has changed on these pages since then. if there's anything you think i should have known, but did not appear to when i made my edit, i would be grateful if you could be more detailed in your explanation, because i admittedly could not understand your edit summary. thanks! dying ( talk) 18:30, 29 October 2021 (UTC)
There have been two cases in Svalbard:
1. Oct 7 - "A sick Russian fisherman who was picked up at Bjørnøya on Wednesday night and transported to a hospital in Longyearbyen, has tested positive for Covid-19." [1]
2. Oct 19 - "A resident of Longyearbyen has been confirmed infected with Covid-19." [2]
Laniwov732 ( talk) 01:08, 8 November 2021 (UTC)
References
Two countries (Kazakhstan in Central Asia and Slovakia in Central Europe) have crossed the one million mark for many days but their corresponding colours on the map have not been changed. Even many countries later crossed the one million mark have had their colours changed. — Preceding unsigned comment added by 101.78.179.28 ( talk) 01:07, 14 December 2021 (UTC)
What happened to the old list that showed total number of confirmed cases from higher to lower (1st USA, 2nd India, 3rd Brazil, etc.) I don't want to see a random lists where Peru appears first, then jump to a random country with, let's say 1000 cases, then to other where there's been 200.000 or a number like that. It's just weird and unorganized MatsLP ( talk) 10:17, 24 December 2021 (UTC)
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Country | Deaths/million | Deaths | Cases |
---|---|---|---|
World | 684 | 5,392,790 | 278,891,403 |
European Union | 1,994 | 891,943 | 52,820,293 |
United States | 2,452 | 816,436 | 51,966,735 |
Country | Deaths/million | Deaths | Cases |
---|---|---|---|
World | 612 (-72) | 4,823,730 (-569,060) | 237,803,829 (-41,087,574) |
United States | 2,452 | 816,463 (+27) | 52,095,411 (+128,676) |
European Union | 1,590 (-404) | 711,113 (-180,830) | 41,158,525 (-11,661,768) |
Does anyone know or can anyone explain why these OWID numbers have changed so much?
Has anyone found the reliable references for the information on the OWID table yet? I've been referred to the JHU references in the past but the OWID data is not the same as the JHU data so these can't be the correct references for OWID. Where do OWID get their numbers from? I can understand numbers remaining static if not updated over Christmas but they shouldn't reduce like this. BringBackTheStats ( talk) 11:43, 27 December 2021 (UTC)
The death toll has already crossed five million. It crossed five million many days ago. Please update! 49.178.138.126 ( talk) 07:39, 2 November 2021 (UTC)
crossed five million many days ago. Yes, I can do my own research, but you're the one coming with a claim; it should be because you have at least one usable source supporting it. — JohnFromPinckney ( talk / edits) 16:18, 2 November 2021 (UTC)
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Why are the death toll is decreasing? Isn't supposed to be more than 5 million right now? Can someone explain this? And also, if you can, please fix this. I'm so confused. I used to check the statistics everyday, but now since the numbers were unexpectedly decreasing, I decided to use Worldometer instead of Wikipedia. Qhairun ( talk) 15:33, 27 December 2021 (UTC)
![]() | This is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page. |
Archive 5 | Archive 6 | Archive 7 | Archive 8 | Archive 9 |
The table in this section needs to be removed from the article:
It is being maintained mainly by 1 or 2 people lately (see history) vetting hundreds of sources. Here is the table template:
There is no way the above-linked table can be as accurate, or as regularly and fully updated, as this table updated daily by a bot:
It is found in this section:
Its reference: {{ COVID-19 data/Cite}}:
The link in that reference:
Then scroll down to "Download database" box and clicking it to go here and see databases:
-- Timeshifter ( talk) 11:52, 28 September 2021 (UTC)
LSGH. Template:COVID-19 pandemic data and its section would be removed from this article. The section containing Template:COVID-19 pandemic death rates would remain. -- Timeshifter ( talk) 12:32, 2 October 2021 (UTC)
@ Timeshifter: I would prefer to remove "The table is updated daily by a bot" (and links to Template:COVID-19 data/Cite) from COVID-19 pandemic by country and territory#Total cases, deaths, and death rates by country (Our World in Data) and COVID-19 pandemic by country and territory#Total cases, deaths, and death rates by country (Our World in Data). This is somewhat of a self-reference, and I don't think it should be in the text of the article. I do not think the link to Template:COVID-19 data/Cite is helpful; that template is just the citation (displayed in the reference in the table). A better alternative would be to use Template:COVID-19 data/Date for an automatically-updating date for when the data was last updated. Tol ( talk | contribs) @ 16:59, 3 October 2021 (UTC)
Bit of a long one this. I’ve been recording the available coronavirus statistics on a daily basis since the 9th January 2020 and started noting down any figures I heard in media reports from China on a spreadsheet on 3st December 2019. Since then this has grown as statistical websites have become available to include daily country by country figures from Wikipedia, WorldOMeter, Testing, Vaccines, UK, England, Scotland, Wales, N. Ireland, Rep of Ireland and various UK regions into a 38Mb file collection of daily data.
To the spreadsheet above I add my own columns e.g. on the paste copy of the < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases_and_deaths_(mixed_sources)> table that I take every day. I add new Death Rate, Daily Deaths, Daily Cases and Recoveries columns taking the previous days data from the latest data. By doing this every day on a spreadsheet it’s easy to cross check figures and I know what is updated and what is not. The Wikipedia table is usually the most accurate, bots or no bots. It’s very easy to see what is updated and what is not updated on a daily basis.
As a result of copying the figures on to a spreadsheet it’s easy to spot some of the inconsistencies and occasional errors on the reporting of daily figures on the UK countries websites, the Republic of Ireland’s government’s website and very occasionally on the Wikipedia table if data had been entered incorrectly, maybe an extra digit, wrong digit etc. If this happens I can cross check with the links for each country’s coronavirus reporting website provided in the notes on Wikipedia and correct any mistakes accordingly. The way it is since yesterday, users have no idea where this data is coming from as there are no references provided in the Wikipedia notes anymore. For instance, one example of these errors that occurs on an almost daily basis is that I noticed the cumulative figures for coronavirus deaths in certain English regions decreasing instead of increasing each day resulting in minus daily deaths. This is still happening in about 2 or 3 regions a day but back in March / April of this year there was a decrease in the total death figures of about twenty to forty deaths a day with no explanation given.
Just a few points.
1 – I don’t know about programming or about Bots but I do know about statistics and it’s usually garbage in, garbage out. I used to look at the OWID site last year but the data on it wasn’t updated as often as the Wikipedia or WorldOmeter sites and sometimes some data wasn’t updated for weeks or was inaccurate. This may have changed since then and it looks as if there is a lot more data sets than there was.
I’ve just done a quick check for today’s UK figures which are posted once daily and it looks as though nothing has changed in the past year on OWID. OWID is still out of date and not only out of date, it is also posting incorrect figures. For example, the UK Deaths for two days ago was 127, yesterday was 121, today is 43. < https://coronavirus.data.gov.uk/details/deaths>
OWID latest UK deaths is showing 124 ( wherever they get that from, there has never been 124 deaths reported on any single day since the beginning of the pandemic in the UK). < https://ourworldindata.org/covid-deaths>
Today’s current official UK Total Cumulative Death Total within 28 days of a positive test is 136,953 as at the top of the page on the .gov.uk link above. Wikipedia now shows this as 137,295, an increase of 382 deaths since yesterday’s correct Wikipedia total. There are 43 new deaths in the UK today, not 124 or 382. OWID is both inaccurate and out of date. This Wikipedia table is now a nonsense. I wish editors who don’t know what they’re doing would just leave well enough alone. If it’s working, leave it. If the figures are not accurate as is the case now, you’ll soon get to know about it. If it is to be changed, then someone who knows what they’re doing needs to change it and the automated update needs to scrape all the government sites around the world as in the reference notes for the original table for the official figures i.e. as in the table until yesterday.
Today’s official UK case cumulative total is 7,900,680. < https://coronavirus.data.gov.uk/details/cases>
Wikipedia / OWID case cumulative total is 7,908,091 or as in the link below the figure is listed as ‘7.91 million’. Accurate it is not. < https://ourworldindata.org/covid-cases>
Some countries update in real time and so their figures do update throughout the day depending when you check them but the UK is not one of them. They release their new official figures every day 16:00 pm. There’s no argument here, the Wikipedia / OWID figures are now inaccurate and should no longer be relied on. They’re about as ‘accurate’ as they were last year. If you check the links above you can see this for yourself.
I could go on but I hope it’s point taken.
2 – There used to be a noticeable Yellow Box Note at the top of the ‘Talk:COVID-19 pandemic by country and territory’ page last year, < /info/en/?search=Talk:COVID-19_pandemic_by_country_and_territory> with a warning not to use the World In Data statistics, I think it was, in Wikipedia as they were unreliable. I agreed with this then and after checking some of the figures today, I still agree with it although I see that the warning box has been removed. There is a note about accuracy on WorldOMeter.info from April 2020 so it could be this that I’m thinking of. This may have been the case at the time but they appear to me to have been accurate for about a year now, more accurate than OWID anyway. I hope I’ve shown the inaccuracy of the OWID data above.
3 – Wikipedia / OWID now has 194 Countries and Territories covered, < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases,_deaths,_and_death_rates_by_country_(Our_World_in_Data)>
Old Wikipedia table had 243 < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases_and_deaths_(mixed_sources)>
WorldOMeter which is now more accurate than Wikipedia has 229 < https://www.worldometers.info/coronavirus/#countries>
Not now included - Abkhazia, American Samoa, Anguilla, Antarctica, Artsakh, Aruba, Bermuda, Bonaire, British Indian Ocean Territory, British Virgin Islands, Cayman Islands, Charles de Gaulle, Coral Princess, Costa Atlantica, Diamond Princess, Djibouti, Donetsk PR, Falkland Islands, Faroe Islands, French Polynesia, Gibraltar, Greenland, Greg Mortimer, Guam, Guernsey, HNLMS Dolfijn, Isle of Man, Jersey, Luhansk PR, Macau, Montserrat, MS Zaandam, New Caledonia, Nicaragua, Northern Cyprus, Northern Mariana Islands, Puerto Rico, Saba, Sahrawi Arab DR, Saint Helena, Ascension and Tristan da Cunha, Saint Pierre and Miquelon, SeaDream I, Sierra Leone, Sint Eustatius, Sint Maarten, Somaliland, South Ossetia, Transnistria, Turks and Caicos Islands, U.S. Virgin Islands, USS Theodore Roosevelt, Vatican City, Wallis and Futuna
From your list Cape Verde, East Timor and Gambia are included but well spotted, Curacao is not in the old Wikipedia, OWID or in WorldOMeter.info.
4 – ‘Even the few editors who remain are no longer able to update the template as often as they used to.’ I check these figures every day. I would say that the figures are updated more now than they were a year ago. There are also more countries being updated on an almost daily basis than were being updated last year.
5 – Leave ‘Country’, ‘Confirmed’, ‘Deaths’, ‘Recoveries’ columns in the order they are in and as it was, and add in a new ‘Deaths/Million’ column on the right if need be. More data is usually better than less data.
6 – ‘ Recoveries ‘ column data was updated on a daily basis on the < /info/en/?search=COVID-19_pandemic_by_country_and_territory#Total_cases_and_deaths_(mixed_sources)> table for most countries as I check it every day and new recovery figures appear against almost all countries on a daily basis, although twenty-one countries or territories out of two hundred and forty-two do not post any recovery data at all. This data gives a rough number of people infected in any particular territory over a two or three week period.
7 – I’ve had a discussion like this before back in June 2020 when a Wikipedia editor wanted to remove the world country by country coronavirus Testing statistics table from the main < /info/en/?search=2019-20_Wuhan_coronavirus_outbreak> page as it was then and deprive the Wikipedia world of these figures forever. This dismayed me so much that I had to open an account and comment. Thankfully he reversed his opinion and coronavirus Testing now has a page in it’s own right.
8 – Thank you to the contributors who keep these pages updated. Believe me I understand what a job it is if being done manually as it takes me about 45 mins to 1.5 hours each day (if there are errors to research and correct) and it does take a certain amount of dedication. A bot to do the work would obviously be an easier solution but it should be Wikipedia’s own bot with the tables updated from the links in the previous reference notes as in the figures from each government. There must be lots of people out there in Wikiworld who could throw together a perfectly accurate bespoke bot from the original reference notes for these Wikipedia pages. I wish I knew how to do it myself. Until that project is able to be completed then I would propose that no changes are made and that the table remains as it was up until a day ago. I have referenced many of these government reporting websites myself since last year when I have suspected an error and although sometimes it is bit of an educated guess for myself to get the correct figure because of the different languages and script, they are, no doubt, the most accurate source of information and I feel both comfortable and confident with the figures I’ve had to enter from time to time by referencing the Wikipedia reference notes for each country. When you’ve been doing this a while, it’s plain to see that many governments around the world have their own agendas but they are the best that we have at present. Although seemingly convenient, OWID is really not our solution and it’s just not good enough for Wikipedia.
9 - Trust in Wikipedia’s figures is important and I know that I for one have grown over time to trust the figures in Wikipedia’s table and the way that they have been compiled so far. That trust has dissipated overnight to the point that I know now that they’re useless. BringBackTheStats ( talk) 02:26, 4 October 2021 (UTC)
Government changes definition of death to those occuring within 28 days of a positive test. We have revised the historical death data to match this reporting. | time_series_covid19_deaths_global.csv | The change in definition results in a loss of around 5000 deaths from the official tally. | Data accessed from the official webpage on August 17 was used to recreate the time series file. |
@Tol: @Timeshifter: Hi. I don’t have the time to go through all your points and reply to you properly tonight but I have been looking into it a bit as you do. Forget about the UK figures. They’re in a world of their own. I could spend days explaining the bubble notes I’ve made on the UK spreadsheet when figures don’t look right, or figures have been revised up or down or sometimes just a mistake by someone. I might have a go at counting them all sometime just to see how many there are. There’s a good example of this in the NI coronavirus deaths registered which happened around the first or second week of 2021. It now looks as if no-one will ever correct it as I suspect it’s being transferred into the UK .gov website automatically otherwise someone would have picked it up by now.
Anyway, this isn’t about OWID not posting the correct UK figures and making up their own figures. That was just one example. I told you I could go on but I thought you’d get the point. Look at Ireland’s figures, look at France’s, look at Singapore, look at almost any country’s official figures. The OWID figures don’t bear any relation to any country that I have looked at. It could be the case that they’re actually a more accurate nonsense than the government websites but no-one will ever know. The officially compiled figures are all we have to go on. The OWID are like something they made up a while ago and compiled as they see fit with the aid of a bot merrily churning out figures that everyone seems to have forgotten about or at least that was the impression I was left with.
You said that OWID get their figures from John Hopkins so I spent an hour and a half on the John Hopkins website this evening trying to locate the definitive sources for their information and how their figures are compiled. I did searches on Google. I didn’t find a link on Google, so on to the John Hopkins. I expected to find loads of links and references all over their coronavirus homepage or at least in the footers saying, ‘ This is how we compile our data.’ Or ‘For a list of our sources please click here.’ I couldn’t find any such link or page. I ended up going down so many dead ends on that website that I became infuriated and gave up. I had expected to see a clearly marked page listing the references for each country like Wikipedia had. I couldn’t find it. I found a few references to data they had used for maybe four or five countries but a lot of those led nowhere, i.e. to private company apps that had given up the task or links to dead websites that hadn’t been updated since last year. Maybe I’m really dumb but I’ve been following these figures for a while now and have usually bee able to locate the source references. OWID are not the official figures. Wikipedia’s figures were the officially released figures for each country and it was excellent to get them all in one table. If someone does know of a link to their data sources for each country then please post it so I can have a look at it.
@Timeshifter : That is the correct UK deaths by date reported figure but not for the 1st Oct. It’s the figure released at 16:00 on the 30th Sept 2021. Those are the official UK figures on https://covid19.who.int/WHO-COVID-19-global-data.csv but the figures in the New Daily Cases column don’t look right. If you check on the Cases tab on the .Gov coronavirus website ( link above ) -> Cases by Date Reported -> UK Total -> Data you’ll see that they’re not the official figure. It’s something that the WHO is doing itself, i.e. adding a column that I’ve also added myself on my UK spreadsheet tab, calculating the difference between the previous day’s Cumulative Case Total figure from the present day’s release of the Cumulative Case Total as one day I thought to myself that those figures don’t add up. The official UK Daily New Case released figure is usually more than the figure in that WHO column and is currently about an average of about 600 more cases a day over the past month or so or to put it another way, the reported UK Cumulative Total Cases figure is about 18,000 cases short every month to the officially reported Daily New Cases at present but that fluctuates over time. It could just be that collectively as a nation the UK is just not very good at adding up but a few more teachers and a reduction in class sizes should rectify that swiftly.
You’re only scratching the surface but I’m glad that you’re slowly getting sucked into the nuanced, intricate and muddy world of coronavirus data manufacture. Now multiply all of this by the number of countries on this planet by all the various social pressures in our modern world and I hope you can see how complicated this is. Now I don’t have anything against bots, as I said myself I wish I had the knowledge to do it myself but I hope you can see why this is a world that is encouraged by blind trust in simple bots that once let off their leash should by rights entail just as much ongoing monitoring to ensure that they’re still on the right path but in reality are probably forgotten about at times and just let run their merry way. It’s a world that humans are needed to constantly monitor. I have confidence in the Wikipedia data because everything is referenced and I can check it myself and have done so many times. I don’t have confidence in the OWID data because I don’t know where it comes from, I can’t check it, it’s not referenced and their numbers that I have tried to check against official sources are something completely different from that official data. As I said before, until we know where these figures come from, they’re not credible and it’s a case of garbage in, garbage out. Again as I’ve said before this isn't about the UK figures, check the OWID data against other country's official data. BringBackTheStats ( talk) 09:02, 5 October 2021 (UTC)
@Timeshifter: I’ll have to check links above again in more detail but I have checked some of the links already and I couldn’t find the data references when I looked yesterday. BringBackTheStats ( talk) 03:49, 6 October 2021 (UTC)
|
Can you also show the number of recoveries in the COVID-19 table? Qhairun ( talk) 15:36, 11 October 2021 (UTC)
Please I want the old COVID-19 statistic table back. Qhairun ( talk) 15:41, 11 October 2021 (UTC)
BringBackTheStats. See:
The Github csv links do not operate as they do in other places that I have found csv files.
There you have to click them once before downloading the "Raw" csv file. For example, go here:
Click on total_deaths_per_million.csv
It opens into a Github page with a scrolling window consisting of plain text csv. Download the "Raw" csv file. Open it in freeware LibreOffice Calc. It is a spreadsheet with the deaths per million data for every day for every country. -- Timeshifter ( talk) 00:41, 17 October 2021 (UTC)
For File:COVID-19 Outbreak World Map Total Deaths per Capita.svg there are no longer any countries with <0.1 deaths per 100,000 population, so it might be a good idea to remove the lightest shade in the legend. An update to the range of values for each shade might also be appropriate; there are now only 6 countries in the 0.1–0.6 range, 19 in the 0.6–3.3 range, 42 in the 3.3–18 range, 52 in the 18–100 range, 67 in the 100–555 range, and just 1 in the 555+ range. JACKINTHEBOX • TALK 10:33, 19 October 2021 (UTC)
Timeshifter, regarding your revert to my edit, from what i can tell, the table to which i added tonga currently does not appear to use citations, so i decided to not add a visible one to it, to conform with the entries already present. also, i am not sure how i would go about providing a citation for the table from which i removed tonga, since the removal of the entry results in there being no entry for which a citation could be provided. i had added a source in a comment so that other editors who questioned the edit could easily verify that the edit was warranted, and not have to look for one to confirm. because you reverted my edit, i am assuming that i am missing something here, but i cannot seem to figure out what it is. it has been a while since i last edited this page, so i apologize if i am unaware of any significant changes since then.
also, admittedly, i don't consider the age of my account to be evidence of knowledge of current editing standards. much of what i have learned is outdated now, and i still look to edits from younger accounts to understand what is now acceptable. similarly, i believe most of my edits on pages dealing directly with the pandemic were made during the first half of last year, so i acknowledge that much has changed on these pages since then. if there's anything you think i should have known, but did not appear to when i made my edit, i would be grateful if you could be more detailed in your explanation, because i admittedly could not understand your edit summary. thanks! dying ( talk) 18:30, 29 October 2021 (UTC)
There have been two cases in Svalbard:
1. Oct 7 - "A sick Russian fisherman who was picked up at Bjørnøya on Wednesday night and transported to a hospital in Longyearbyen, has tested positive for Covid-19." [1]
2. Oct 19 - "A resident of Longyearbyen has been confirmed infected with Covid-19." [2]
Laniwov732 ( talk) 01:08, 8 November 2021 (UTC)
References
Two countries (Kazakhstan in Central Asia and Slovakia in Central Europe) have crossed the one million mark for many days but their corresponding colours on the map have not been changed. Even many countries later crossed the one million mark have had their colours changed. — Preceding unsigned comment added by 101.78.179.28 ( talk) 01:07, 14 December 2021 (UTC)
What happened to the old list that showed total number of confirmed cases from higher to lower (1st USA, 2nd India, 3rd Brazil, etc.) I don't want to see a random lists where Peru appears first, then jump to a random country with, let's say 1000 cases, then to other where there's been 200.000 or a number like that. It's just weird and unorganized MatsLP ( talk) 10:17, 24 December 2021 (UTC)
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Country | Deaths/million | Deaths | Cases |
---|---|---|---|
World | 684 | 5,392,790 | 278,891,403 |
European Union | 1,994 | 891,943 | 52,820,293 |
United States | 2,452 | 816,436 | 51,966,735 |
Country | Deaths/million | Deaths | Cases |
---|---|---|---|
World | 612 (-72) | 4,823,730 (-569,060) | 237,803,829 (-41,087,574) |
United States | 2,452 | 816,463 (+27) | 52,095,411 (+128,676) |
European Union | 1,590 (-404) | 711,113 (-180,830) | 41,158,525 (-11,661,768) |
Does anyone know or can anyone explain why these OWID numbers have changed so much?
Has anyone found the reliable references for the information on the OWID table yet? I've been referred to the JHU references in the past but the OWID data is not the same as the JHU data so these can't be the correct references for OWID. Where do OWID get their numbers from? I can understand numbers remaining static if not updated over Christmas but they shouldn't reduce like this. BringBackTheStats ( talk) 11:43, 27 December 2021 (UTC)
The death toll has already crossed five million. It crossed five million many days ago. Please update! 49.178.138.126 ( talk) 07:39, 2 November 2021 (UTC)
crossed five million many days ago. Yes, I can do my own research, but you're the one coming with a claim; it should be because you have at least one usable source supporting it. — JohnFromPinckney ( talk / edits) 16:18, 2 November 2021 (UTC)
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Why are the death toll is decreasing? Isn't supposed to be more than 5 million right now? Can someone explain this? And also, if you can, please fix this. I'm so confused. I used to check the statistics everyday, but now since the numbers were unexpectedly decreasing, I decided to use Worldometer instead of Wikipedia. Qhairun ( talk) 15:33, 27 December 2021 (UTC)