This template does not require a rating on Wikipedia's
content assessment scale. It is of interest to the following WikiProjects: | |||||||||||||||||||||||||||||
|
As discussed in Talk:COVID-19 vaccine § COVID-19 vaccination chart, the current solution has a few limitations: there's no ability to sort by vaccine doses as a percent of country population; we can't reliably wrap in a scrolling div without display issues; the world and large country totals will be so large that the bar for most countries won't display.
I think a move to Template:Wikitable is necessary. Here's how it looks:
Country | Vaccinated* [b] | % of Pop. [c] | |
---|---|---|---|
World | 50,499,754 | 0.7% | |
China | 15,000,000 | 1.0% | |
United States | 14,270,441 | 5.0% | |
United Kingdom | 4,973,247 | 8.1% | |
European Union | 6,870,138 | 1.6% | |
England | 4,303,730 | 8.4% | |
Israel | 2,407,060 | 37.1% | |
United Arab Emirates | 1,996,069 | 22.7% | |
Germany | 1,324,091 | 1.7% | |
Italy | 1,257,118 | 2.1% | |
Turkey | 1,120,258 | 1.3% | |
Spain | 1,054,245 | 2.4% | |
Russia | 1,000,000 | 0.7% | |
India | 806,484 | 0.1% | |
Canada | 696,242 | 1.8% | |
France | 692,777 | 1.0% | |
Poland | 566,793 | 1.6% | |
Mexico | 489,628 | 0.4% | |
Romania | 338,252 | 1.8% | |
Scotland | 334,871 | 6.2% | |
Saudi Arabia | 295,530 | 0.9% | |
Argentina | 249,372 | 0.6% | |
Wales | 190,435 | 6.1% | |
Denmark | 178,969 | 3.2% | |
Austria | 161,965 | 1.8% | |
Czech Republic | 154,989 | 1.5% | |
Sweden | 146,775 | 1.5% | |
Northern Ireland | 144,212 | 8.8% | |
Bahrain | 144,130 | 8.5% | |
Belgium | 141,758 | 1.2% | |
Brazil | 136,519 | 0.1% | |
Hungary | 134,554 | 1.4% | |
Ireland | 121,900 | 2.5% | |
Greece | 121,109 | 1.2% | |
Switzerland | 110,000 | 1.3% | |
Portugal | 106,000 | 1.0% | |
Netherlands | 100,000 | 0.6% | |
Finland | 78,300 | 1.4% | |
Slovakia | 71,478 | 1.3% | |
Norway | 63,727 | 1.2% | |
Lithuania | 56,358 | 2.4% | |
Croatia | 54,304 | 1.3% | |
Slovenia | 47,931 | 2.3% | |
Chile | 45,676 | 0.3% | |
Serbia | 44,611 | 0.7% | |
Costa Rica | 24,804 | 0.5% | |
Oman | 24,773 | 0.6% | |
Estonia | 21,985 | 1.7% | |
Bulgaria | 19,834 | 0.4% | |
Latvia | 18,404 | 1.0% | |
Malta | 15,316 | 3.5% | |
Seychelles | 13,163 | 13.4% | |
Cyprus | 10,226 | 1.2% | |
Gibraltar | 7,017 | 20.8% | |
Singapore | 6,200 | 0.1% | |
Luxembourg | 6,193 | 1.0% | |
Iceland | 5,725 | 1.8% | |
Kuwait | 2,500 | 0.1% | |
Notes |
References
To update, editors could manually enter new values as they do in the current solution. However, it's much faster if someone runs through the following steps. I can do this on occasion but would like to confirm others can help before deploying.
|
|
- Wikmoz ( talk) 20:28, 9 January 2021 (UTC)
Year | Passengers (% change from prior year) |
---|---|
2003-04 | 110,649(+17.8%)
|
Fiscal year | Revenue passengers | Aircraft movements |
---|---|---|
2001-02 | 20,194 |
2,281
|
Hi, so, is the topic closed, and is anybody updating the table en masse? I can from time to time do it manually for more nations but it would be futile to do it in case someone is regularly (how often?) going to update the whole table. Thanks, -- WikiHannibal ( talk) 16:42, 21 January 2021 (UTC)
Vaccination numbers are wrong (ourworldindata lists Romania at 108,000 as of Jan 10, confirmed by https://www.hotnews.ro/stiri-coronavirus-24533671-prima-transa-din-vaccinul-anti-covid-moderna-ajunge-miercuri-romania.htm) while this Wikipedia table lists it at 76,000 as of Jan 11. 2A02:2F07:3604:CD00:D4F4:C7CD:12CA:FC81 ( talk) 16:45, 11 January 2021 (UTC)
@ Wikmoz, Tenryuu, Sdkb, Timeshifter, -Hyde-, Yug, RScheiber, WikiHannibal, Axelcabrera100, and Naldo-Crocoduck: India recorded the highest number of vaccinations on day one in the world on Saturday, at 2,07,229, higher than the US, UK and France. [1] Thank you. — Amkgp 💬 19:54, 17 January 2021 (UTC)
References
@ Axelcabrera100: hi, I keep removing the distracting spinning Earth gif and you keep readding. I think we should come to an agreement on what to do with it before it becomes a full-on edit war. -- Betseg ( talk) 10:28, 20 January 2021 (UTC)
yes | no |
---|---|
1 | 1 |
I move that we add an additional source, the CDC Covid Vaccination Rates specifically for the US. It seems the OurWorldInData.org source is slightly behind in updating vaccine counts for the United States. ChipotleHater ( talk) 20:25, 20 January 2021 (UTC)
A column for sources was recently added in this edit. Unfortunately, the column can't be maintained with the automatic updates as each row needs to follow a standard pattern using data from the CSV. As a workaround, I've added a link to the country-level sources in the main reference and in the table footer so the list is easily accessible to anyone who is interested. - Wikmoz ( talk) 19:01, 22 January 2021 (UTC)
FDW777 correctly notes that Northern Ireland has no official flag. Unfortunately, the default flag will be replaced with each automated update. Can this issue be pressed on the appropriate forum? In the interim, I've added a conditional statement to change the flag to the "|variant=union" version. The alternative would be the "noflag" variant suggested at the link above but this doesn't work in the existing flag+link template. - Wikmoz ( talk) 00:24, 25 January 2021 (UTC)
The three sovereign nations in the Compact of Free Association with the United States ( Palau, Micronesia, and the Marshall Islands) have their data reported via the same source as the US data (they're somewhat erroneously reported on the CDC's tracker part of the US's territories, even though they're not). They should probably be included with entries on this table. Green Runner 0 21:34, 29 January 2021 (UTC)
The current excel formula in the documentation means that countries who only supply total vaccination figures will result in blank fields as it is only checking against single dosages.
I've tweaked it so that any countries that are missing this data will be included using total dosage info, but will have a note stating that the info is as such.
Any objections to this being added to the documentation as the preferred method of running the update? Fishdude96 ( talk) 22:56, 2 February 2021 (UTC)
=IF(A2="World","| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World",IF(A2="Northern Ireland","|{{flag+link|COVID-19 pandemic in|"&A2&"|variant=union}}","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total|Data based on total doses administered, not first shot only.}}||&TEXT(D2,"#,#"&"||"&TEXT(I2/100,"0.0%"),"||"&TEXT(E2,"#,#"&"||"&TEXT(J2/100,"0.0%")))&"<tr>"
=IF(A2="World","| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World",IF(A2="Northern Ireland","|{{flag+link|COVID-19 pandemic in|"&A2&"|variant=union}}","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||{{font color|darkred|--}}","||"&TEXT(E2,"#,#")&"||"&TEXT(J2/100,"0.0%"))&"<tr>"
="| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World{{efn|name=incorrect-total|Data based on {{font color|darkred|total doses administered}}, not first shot only.}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||{{font color|darkred|"&TEXT(I2/100,"0.0%")&"}}"&"<tr>"
=IF(A2="World","| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World{{efn|name=world-total}}",IF(OR(A2="Northern Ireland",A2="Scotland",A2="Wales",A2="England"),"|******REMOVE ROW******","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||{{font color|darkred|--}}","||"&TEXT(E2,"#,#")&"||"&TEXT(J2/100,"0.0%"))&"<tr>"
=IF(A2="World","|{{pad|0.1em}}[[File:Emojione 1F310.svg|23x15px|alt=|link=]]{{pad|0.4em}}World{{efn|name=world-total}}",IF(OR(A2="Northern Ireland",A2="Scotland",A2="Wales",A2="England",A2="Europe",A2="Africa",A2="Oceania",A2="North America",A2="South America",A2="Asia"),"|******REMOVE ROW******","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||--","||"&TEXT(E2,"#,#")&"||"&TEXT(J2/100,"0.0%"))&"<tr>"
Elshad has suggested removing England, Northern Ireland, Wales, and Scottland from the table. These are included in the OWID source data but could be an artifact of OWID being based in the UK. My preference is to just go with OWID's breakout but if there are no objections, I can adjust the formula to flag these entries for deletion with each update. - Wikmoz ( talk) 23:16, 2 February 2021 (UTC)
Prime Minister Brnabić has confirmed (several times) that figures Government give for Serbia are first-dose only, ie. number of people vaccinated, not number of doses administered. For example, two days ago, she said that 463k first shots (which was the number officially reported, and strangely missing from OWID) and 10k second shots (these still aren't officially reported, but I guess they soon will be, since all number are automatically extracted from Government database) were given. Source: https://rs.n1info.com/vesti/brnabic-stiglo-9-360-doza-fajzerove-vakcine-novi-kontingenti-do-kraja-februara/. Nevertheless, template automatically lists Serbia as "data based on total doses administered, not first shot only". I fixed it manually this time (and updated it with yesterday's data that is already on OWID), but how to make auto-updates work in the future? That has to be fixed on OWID side? 94.189.131.122 ( talk) 19:20, 3 February 2021 (UTC)
Edl-irishboy, thank you for your help in updating this the template! I see you've changed the link for COVID-19 pandemic in Ireland to correctly point to COVID-19 pandemic in the Republic of Ireland. Please note that other users are not intentionally reverting this correct edit. Rather, the template is updated through a semi-automated process that automatically enters data based on country names in the source data. The easiest way to resolve would be to change COVID-19 pandemic in Ireland from a disambiguation page to a redirect, if possible. - Wikmoz ( talk) 23:20, 21 February 2021 (UTC)
Hi there, another source, [1] allows for a tabulation on amount of people in Canada who have received at least one dose instead of shots administered. CaffeinAddict ( talk) 17:20, 22 February 2021 (UTC)
Does anybody agree that the articles from Category:COVID-19 vaccination programmes are the ones that should be linked on the table instead of their "COVID-19 pandemic in country" counterparts? — hueman1 ( talk • contributions) 15:29, 9 March 2021 (UTC)
For example, this:
Location | Vaccinated [b] | % of pop. [c] | |
---|---|---|---|
World [d] | 186,586,871 | 2.4% | |
United States | 60,005,231 | 17.9% | |
United Kingdom | 22,377,255 | 33.0% | |
Philippines | 44,000 | 0.0% | |
...cells omitted... | |||
Sources List of
sources by country.
Notes
|
instead of this:
Location | Vaccinated [b] | % of pop. [c] | |
---|---|---|---|
World [d] | 186,586,871 | 2.4% | |
United States | 60,005,231 | 17.9% | |
United Kingdom | 22,377,255 | 33.0% | |
Philippines | 44,000 | 0.0% | |
...cells omitted... | |||
Sources List of
sources by country.
Notes
|
I noticed the EU was removed from the list without a discussion here. My preference would be to include it as the vaccine acquisition was organised by the EU rather than the individual member states. I understood the EU is also listed in the source so we do not have to do the sum ourselves. Nico ( talk) 10:48, 24 March 2021 (UTC)
Why is there no article on "COVID-19 vaccine distribution by location"?-- 2A02:810A:11BF:E564:DC14:1C28:6619:6013 ( talk) 13:22, 27 March 2021 (UTC)
There's an obvious problem in rounding the percents done in automated update process. I can't help with fixing it, but here's an example, so someone who can fix it (maybe @ Bom4446:) gets the idea. OWID data has Serbian population at 6,804,596. Current number of first doses administered should be 1,677,268. Percentually, that is 100 * 1677268/6804596 % ~ 24.6490460271 % ~ 24.6 %. That number, 24.6, really is on the OWID site, but here on Wikipedia, template incorrectly rounds it as 24.7. 178.220.248.46 ( talk) 12:50, 10 April 2021 (UTC)
Serbia,SRB,2021-04-09,2836012,1677268,1158744,,44878,41.68,24.65,17.03,6595
I'm not sure what's going on with Gibraltar (maybe a lack of update on newest population estimate) but it can't have more than 100% of its population vaccinated? CaffeinAddict ( talk) 20:59, 13 April 2021 (UTC)
Hello, I have written a bot to automatically update this template. I have opened a BRFA at Wikipedia:Bots/Requests for approval/TolBot, if anybody is interested to take a look or comment there. Tol | Talk | Contribs (formerly Twassman) 00:16, 17 April 2021 (UTC)
people_vaccinated_per_hundred
).
Tol |
Talk |
Contribs 20:46, 27 May 2021 (UTC)
Although they are not officially recognised by anyone in the UN, I think disputed territories should still be added. If not, at least include the number of doses received in each disputed territory combined with the country that claims that territory. For example, Abkhazia has just gotten their first doses of the Sputnik V vaccine. [1] If you don’t want to add it alone, we could alternatively add Abkhazia’s vaccination data into Georgia’s.
References
I believe the data for F.S. Micronesia, Marshall Islands, and Palau are already included in OWID's figures for the United States. -- 17jiangz1 ( talk) 16:16, 29 May 2021 (UTC)
In Vatican City, there are about 453 residents and 372 nonresident citizens. Should the sum be used or should only residents count to the population total when calculating the percentage of the population vaccinated? 17jiangz1 ( talk) 16:50, 29 May 2021 (UTC)
Where is the source for Canada coming from? I believe it is over-reporting percentage. CaffeinAddict ( talk) 00:33, 22 June 2021 (UTC)
Hello! Three months ago, I wrote a bot to automatically update this template. However, there are multiple different templates which all contain COVID-19 information. I wrote a Lua script which pulls data from a JSON page and generates this template. That way, the (JSON) data is easier to update: instead of generating new wikitext for the table content each time, it changes only the parts of the data that it updates. In other words, any changes you make to the JSON's non-data fields, like country names and notes, will stay. This also lets there be a single data source for multiple templates (like this one, Template:COVID-19 vaccination data in Africa, and Template:COVID-19 vaccination data in North America). The template is at Template:COVID-19 vaccination data/Lua, the module is at Module:COVID-19 data, and the data is at Template:COVID-19 data/data. What do you think? Tol | talk | contribs 18:08, 16 July 2021 (UTC)
@ Tol: The updated table is missing The United Kingdom, Germany, Japan, Mexico, France and so on. Also please sort the table by "Vaccinated".―― Phoenix7777 ( talk) 04:40, 26 July 2021 (UTC)
The decimal point in the percentages has been removed. This I would say is to the detriment of the table. At the foot of the table a 0.1 difference is still quite a difference. For a great many countries it still amounts to a tenth of the overall amount. I think this should be restored. Mtaylor848 ( talk) 13:47, 27 July 2021 (UTC)
Why would Italy include Vatican City when it's well known that it has state-hood? CaffeinAddict ( talk) 19:05, 27 July 2021 (UTC)
Is this table being updated daily by a bot?
Is it possible to use some kind of auto-dating template to indicate a "last updated" date?
Similar to this one, for example:
As of 13:21 UTC
As of {{Cases in the COVID-19 pandemic|time|editlink=|ref=no}}
I could place the auto-dating template above the table in articles.
The above auto-dating template is part of this longer bit of info above a table in an article:
As of 13:21 UTC on 10 March 2023, there are 676,609,955 confirmed cases and 6,881,955 deaths in almost 200 countries/territories and 26 cruise/naval ships.
But if the vaccination bot is updating daily, then above the table I could just say that the data is updated daily. Instead of the above idea.
See table inclusion here:
-- Timeshifter ( talk) 13:04, 21 September 2021 (UTC)
Hi there it seems to be formatted as a redlink missing the "the" in the title COVID-19 vaccination in the Republic of Ireland. CaffeinAddict ( talk) 03:37, 26 September 2021 (UTC)
I'm confused by the UAE number as it's high. I'm going to assume they're vaccinating people not from their country, workers in their country, non-citizens etc, as it doesn't appear to be that they're vaccinating kids under 12. If that's the case, a footnote should be added. CaffeinAddict ( talk) 15:16, 5 October 2021 (UTC)
Including info about non sovereign states such as Pitcairn Islands and others is the fastest way to cram a table with unnecessary clutter. CGBoas ( talk) 11:33, 13 November 2021 (UTC)
COVID-19 pandemic in Isle of Man has been marked as an incorrect name. Should be COVID-19 pandemic in the Isle of Man. wbm1058 ( talk) 03:51, 28 March 2024 (UTC)
row._code == 'UK'
–
wbm1058 (
talk) 22:45, 28 March 2024 (UTC)
This template does not require a rating on Wikipedia's
content assessment scale. It is of interest to the following WikiProjects: | |||||||||||||||||||||||||||||
|
As discussed in Talk:COVID-19 vaccine § COVID-19 vaccination chart, the current solution has a few limitations: there's no ability to sort by vaccine doses as a percent of country population; we can't reliably wrap in a scrolling div without display issues; the world and large country totals will be so large that the bar for most countries won't display.
I think a move to Template:Wikitable is necessary. Here's how it looks:
Country | Vaccinated* [b] | % of Pop. [c] | |
---|---|---|---|
World | 50,499,754 | 0.7% | |
China | 15,000,000 | 1.0% | |
United States | 14,270,441 | 5.0% | |
United Kingdom | 4,973,247 | 8.1% | |
European Union | 6,870,138 | 1.6% | |
England | 4,303,730 | 8.4% | |
Israel | 2,407,060 | 37.1% | |
United Arab Emirates | 1,996,069 | 22.7% | |
Germany | 1,324,091 | 1.7% | |
Italy | 1,257,118 | 2.1% | |
Turkey | 1,120,258 | 1.3% | |
Spain | 1,054,245 | 2.4% | |
Russia | 1,000,000 | 0.7% | |
India | 806,484 | 0.1% | |
Canada | 696,242 | 1.8% | |
France | 692,777 | 1.0% | |
Poland | 566,793 | 1.6% | |
Mexico | 489,628 | 0.4% | |
Romania | 338,252 | 1.8% | |
Scotland | 334,871 | 6.2% | |
Saudi Arabia | 295,530 | 0.9% | |
Argentina | 249,372 | 0.6% | |
Wales | 190,435 | 6.1% | |
Denmark | 178,969 | 3.2% | |
Austria | 161,965 | 1.8% | |
Czech Republic | 154,989 | 1.5% | |
Sweden | 146,775 | 1.5% | |
Northern Ireland | 144,212 | 8.8% | |
Bahrain | 144,130 | 8.5% | |
Belgium | 141,758 | 1.2% | |
Brazil | 136,519 | 0.1% | |
Hungary | 134,554 | 1.4% | |
Ireland | 121,900 | 2.5% | |
Greece | 121,109 | 1.2% | |
Switzerland | 110,000 | 1.3% | |
Portugal | 106,000 | 1.0% | |
Netherlands | 100,000 | 0.6% | |
Finland | 78,300 | 1.4% | |
Slovakia | 71,478 | 1.3% | |
Norway | 63,727 | 1.2% | |
Lithuania | 56,358 | 2.4% | |
Croatia | 54,304 | 1.3% | |
Slovenia | 47,931 | 2.3% | |
Chile | 45,676 | 0.3% | |
Serbia | 44,611 | 0.7% | |
Costa Rica | 24,804 | 0.5% | |
Oman | 24,773 | 0.6% | |
Estonia | 21,985 | 1.7% | |
Bulgaria | 19,834 | 0.4% | |
Latvia | 18,404 | 1.0% | |
Malta | 15,316 | 3.5% | |
Seychelles | 13,163 | 13.4% | |
Cyprus | 10,226 | 1.2% | |
Gibraltar | 7,017 | 20.8% | |
Singapore | 6,200 | 0.1% | |
Luxembourg | 6,193 | 1.0% | |
Iceland | 5,725 | 1.8% | |
Kuwait | 2,500 | 0.1% | |
Notes |
References
To update, editors could manually enter new values as they do in the current solution. However, it's much faster if someone runs through the following steps. I can do this on occasion but would like to confirm others can help before deploying.
|
|
- Wikmoz ( talk) 20:28, 9 January 2021 (UTC)
Year | Passengers (% change from prior year) |
---|---|
2003-04 | 110,649(+17.8%)
|
Fiscal year | Revenue passengers | Aircraft movements |
---|---|---|
2001-02 | 20,194 |
2,281
|
Hi, so, is the topic closed, and is anybody updating the table en masse? I can from time to time do it manually for more nations but it would be futile to do it in case someone is regularly (how often?) going to update the whole table. Thanks, -- WikiHannibal ( talk) 16:42, 21 January 2021 (UTC)
Vaccination numbers are wrong (ourworldindata lists Romania at 108,000 as of Jan 10, confirmed by https://www.hotnews.ro/stiri-coronavirus-24533671-prima-transa-din-vaccinul-anti-covid-moderna-ajunge-miercuri-romania.htm) while this Wikipedia table lists it at 76,000 as of Jan 11. 2A02:2F07:3604:CD00:D4F4:C7CD:12CA:FC81 ( talk) 16:45, 11 January 2021 (UTC)
@ Wikmoz, Tenryuu, Sdkb, Timeshifter, -Hyde-, Yug, RScheiber, WikiHannibal, Axelcabrera100, and Naldo-Crocoduck: India recorded the highest number of vaccinations on day one in the world on Saturday, at 2,07,229, higher than the US, UK and France. [1] Thank you. — Amkgp 💬 19:54, 17 January 2021 (UTC)
References
@ Axelcabrera100: hi, I keep removing the distracting spinning Earth gif and you keep readding. I think we should come to an agreement on what to do with it before it becomes a full-on edit war. -- Betseg ( talk) 10:28, 20 January 2021 (UTC)
yes | no |
---|---|
1 | 1 |
I move that we add an additional source, the CDC Covid Vaccination Rates specifically for the US. It seems the OurWorldInData.org source is slightly behind in updating vaccine counts for the United States. ChipotleHater ( talk) 20:25, 20 January 2021 (UTC)
A column for sources was recently added in this edit. Unfortunately, the column can't be maintained with the automatic updates as each row needs to follow a standard pattern using data from the CSV. As a workaround, I've added a link to the country-level sources in the main reference and in the table footer so the list is easily accessible to anyone who is interested. - Wikmoz ( talk) 19:01, 22 January 2021 (UTC)
FDW777 correctly notes that Northern Ireland has no official flag. Unfortunately, the default flag will be replaced with each automated update. Can this issue be pressed on the appropriate forum? In the interim, I've added a conditional statement to change the flag to the "|variant=union" version. The alternative would be the "noflag" variant suggested at the link above but this doesn't work in the existing flag+link template. - Wikmoz ( talk) 00:24, 25 January 2021 (UTC)
The three sovereign nations in the Compact of Free Association with the United States ( Palau, Micronesia, and the Marshall Islands) have their data reported via the same source as the US data (they're somewhat erroneously reported on the CDC's tracker part of the US's territories, even though they're not). They should probably be included with entries on this table. Green Runner 0 21:34, 29 January 2021 (UTC)
The current excel formula in the documentation means that countries who only supply total vaccination figures will result in blank fields as it is only checking against single dosages.
I've tweaked it so that any countries that are missing this data will be included using total dosage info, but will have a note stating that the info is as such.
Any objections to this being added to the documentation as the preferred method of running the update? Fishdude96 ( talk) 22:56, 2 February 2021 (UTC)
=IF(A2="World","| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World",IF(A2="Northern Ireland","|{{flag+link|COVID-19 pandemic in|"&A2&"|variant=union}}","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total|Data based on total doses administered, not first shot only.}}||&TEXT(D2,"#,#"&"||"&TEXT(I2/100,"0.0%"),"||"&TEXT(E2,"#,#"&"||"&TEXT(J2/100,"0.0%")))&"<tr>"
=IF(A2="World","| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World",IF(A2="Northern Ireland","|{{flag+link|COVID-19 pandemic in|"&A2&"|variant=union}}","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||{{font color|darkred|--}}","||"&TEXT(E2,"#,#")&"||"&TEXT(J2/100,"0.0%"))&"<tr>"
="| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World{{efn|name=incorrect-total|Data based on {{font color|darkred|total doses administered}}, not first shot only.}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||{{font color|darkred|"&TEXT(I2/100,"0.0%")&"}}"&"<tr>"
=IF(A2="World","| [[File:Emojione 1F310.svg|23x15px|alt=|link=]] World{{efn|name=world-total}}",IF(OR(A2="Northern Ireland",A2="Scotland",A2="Wales",A2="England"),"|******REMOVE ROW******","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||{{font color|darkred|--}}","||"&TEXT(E2,"#,#")&"||"&TEXT(J2/100,"0.0%"))&"<tr>"
=IF(A2="World","|{{pad|0.1em}}[[File:Emojione 1F310.svg|23x15px|alt=|link=]]{{pad|0.4em}}World{{efn|name=world-total}}",IF(OR(A2="Northern Ireland",A2="Scotland",A2="Wales",A2="England",A2="Europe",A2="Africa",A2="Oceania",A2="North America",A2="South America",A2="Asia"),"|******REMOVE ROW******","|{{flag+link|COVID-19 pandemic in|"&A2&"}}"))&IF(ISBLANK(E2),"{{efn|name=incorrect-total}}||{{font color|darkred|"&TEXT(D2,"#,#")&"}}||--","||"&TEXT(E2,"#,#")&"||"&TEXT(J2/100,"0.0%"))&"<tr>"
Elshad has suggested removing England, Northern Ireland, Wales, and Scottland from the table. These are included in the OWID source data but could be an artifact of OWID being based in the UK. My preference is to just go with OWID's breakout but if there are no objections, I can adjust the formula to flag these entries for deletion with each update. - Wikmoz ( talk) 23:16, 2 February 2021 (UTC)
Prime Minister Brnabić has confirmed (several times) that figures Government give for Serbia are first-dose only, ie. number of people vaccinated, not number of doses administered. For example, two days ago, she said that 463k first shots (which was the number officially reported, and strangely missing from OWID) and 10k second shots (these still aren't officially reported, but I guess they soon will be, since all number are automatically extracted from Government database) were given. Source: https://rs.n1info.com/vesti/brnabic-stiglo-9-360-doza-fajzerove-vakcine-novi-kontingenti-do-kraja-februara/. Nevertheless, template automatically lists Serbia as "data based on total doses administered, not first shot only". I fixed it manually this time (and updated it with yesterday's data that is already on OWID), but how to make auto-updates work in the future? That has to be fixed on OWID side? 94.189.131.122 ( talk) 19:20, 3 February 2021 (UTC)
Edl-irishboy, thank you for your help in updating this the template! I see you've changed the link for COVID-19 pandemic in Ireland to correctly point to COVID-19 pandemic in the Republic of Ireland. Please note that other users are not intentionally reverting this correct edit. Rather, the template is updated through a semi-automated process that automatically enters data based on country names in the source data. The easiest way to resolve would be to change COVID-19 pandemic in Ireland from a disambiguation page to a redirect, if possible. - Wikmoz ( talk) 23:20, 21 February 2021 (UTC)
Hi there, another source, [1] allows for a tabulation on amount of people in Canada who have received at least one dose instead of shots administered. CaffeinAddict ( talk) 17:20, 22 February 2021 (UTC)
Does anybody agree that the articles from Category:COVID-19 vaccination programmes are the ones that should be linked on the table instead of their "COVID-19 pandemic in country" counterparts? — hueman1 ( talk • contributions) 15:29, 9 March 2021 (UTC)
For example, this:
Location | Vaccinated [b] | % of pop. [c] | |
---|---|---|---|
World [d] | 186,586,871 | 2.4% | |
United States | 60,005,231 | 17.9% | |
United Kingdom | 22,377,255 | 33.0% | |
Philippines | 44,000 | 0.0% | |
...cells omitted... | |||
Sources List of
sources by country.
Notes
|
instead of this:
Location | Vaccinated [b] | % of pop. [c] | |
---|---|---|---|
World [d] | 186,586,871 | 2.4% | |
United States | 60,005,231 | 17.9% | |
United Kingdom | 22,377,255 | 33.0% | |
Philippines | 44,000 | 0.0% | |
...cells omitted... | |||
Sources List of
sources by country.
Notes
|
I noticed the EU was removed from the list without a discussion here. My preference would be to include it as the vaccine acquisition was organised by the EU rather than the individual member states. I understood the EU is also listed in the source so we do not have to do the sum ourselves. Nico ( talk) 10:48, 24 March 2021 (UTC)
Why is there no article on "COVID-19 vaccine distribution by location"?-- 2A02:810A:11BF:E564:DC14:1C28:6619:6013 ( talk) 13:22, 27 March 2021 (UTC)
There's an obvious problem in rounding the percents done in automated update process. I can't help with fixing it, but here's an example, so someone who can fix it (maybe @ Bom4446:) gets the idea. OWID data has Serbian population at 6,804,596. Current number of first doses administered should be 1,677,268. Percentually, that is 100 * 1677268/6804596 % ~ 24.6490460271 % ~ 24.6 %. That number, 24.6, really is on the OWID site, but here on Wikipedia, template incorrectly rounds it as 24.7. 178.220.248.46 ( talk) 12:50, 10 April 2021 (UTC)
Serbia,SRB,2021-04-09,2836012,1677268,1158744,,44878,41.68,24.65,17.03,6595
I'm not sure what's going on with Gibraltar (maybe a lack of update on newest population estimate) but it can't have more than 100% of its population vaccinated? CaffeinAddict ( talk) 20:59, 13 April 2021 (UTC)
Hello, I have written a bot to automatically update this template. I have opened a BRFA at Wikipedia:Bots/Requests for approval/TolBot, if anybody is interested to take a look or comment there. Tol | Talk | Contribs (formerly Twassman) 00:16, 17 April 2021 (UTC)
people_vaccinated_per_hundred
).
Tol |
Talk |
Contribs 20:46, 27 May 2021 (UTC)
Although they are not officially recognised by anyone in the UN, I think disputed territories should still be added. If not, at least include the number of doses received in each disputed territory combined with the country that claims that territory. For example, Abkhazia has just gotten their first doses of the Sputnik V vaccine. [1] If you don’t want to add it alone, we could alternatively add Abkhazia’s vaccination data into Georgia’s.
References
I believe the data for F.S. Micronesia, Marshall Islands, and Palau are already included in OWID's figures for the United States. -- 17jiangz1 ( talk) 16:16, 29 May 2021 (UTC)
In Vatican City, there are about 453 residents and 372 nonresident citizens. Should the sum be used or should only residents count to the population total when calculating the percentage of the population vaccinated? 17jiangz1 ( talk) 16:50, 29 May 2021 (UTC)
Where is the source for Canada coming from? I believe it is over-reporting percentage. CaffeinAddict ( talk) 00:33, 22 June 2021 (UTC)
Hello! Three months ago, I wrote a bot to automatically update this template. However, there are multiple different templates which all contain COVID-19 information. I wrote a Lua script which pulls data from a JSON page and generates this template. That way, the (JSON) data is easier to update: instead of generating new wikitext for the table content each time, it changes only the parts of the data that it updates. In other words, any changes you make to the JSON's non-data fields, like country names and notes, will stay. This also lets there be a single data source for multiple templates (like this one, Template:COVID-19 vaccination data in Africa, and Template:COVID-19 vaccination data in North America). The template is at Template:COVID-19 vaccination data/Lua, the module is at Module:COVID-19 data, and the data is at Template:COVID-19 data/data. What do you think? Tol | talk | contribs 18:08, 16 July 2021 (UTC)
@ Tol: The updated table is missing The United Kingdom, Germany, Japan, Mexico, France and so on. Also please sort the table by "Vaccinated".―― Phoenix7777 ( talk) 04:40, 26 July 2021 (UTC)
The decimal point in the percentages has been removed. This I would say is to the detriment of the table. At the foot of the table a 0.1 difference is still quite a difference. For a great many countries it still amounts to a tenth of the overall amount. I think this should be restored. Mtaylor848 ( talk) 13:47, 27 July 2021 (UTC)
Why would Italy include Vatican City when it's well known that it has state-hood? CaffeinAddict ( talk) 19:05, 27 July 2021 (UTC)
Is this table being updated daily by a bot?
Is it possible to use some kind of auto-dating template to indicate a "last updated" date?
Similar to this one, for example:
As of 13:21 UTC
As of {{Cases in the COVID-19 pandemic|time|editlink=|ref=no}}
I could place the auto-dating template above the table in articles.
The above auto-dating template is part of this longer bit of info above a table in an article:
As of 13:21 UTC on 10 March 2023, there are 676,609,955 confirmed cases and 6,881,955 deaths in almost 200 countries/territories and 26 cruise/naval ships.
But if the vaccination bot is updating daily, then above the table I could just say that the data is updated daily. Instead of the above idea.
See table inclusion here:
-- Timeshifter ( talk) 13:04, 21 September 2021 (UTC)
Hi there it seems to be formatted as a redlink missing the "the" in the title COVID-19 vaccination in the Republic of Ireland. CaffeinAddict ( talk) 03:37, 26 September 2021 (UTC)
I'm confused by the UAE number as it's high. I'm going to assume they're vaccinating people not from their country, workers in their country, non-citizens etc, as it doesn't appear to be that they're vaccinating kids under 12. If that's the case, a footnote should be added. CaffeinAddict ( talk) 15:16, 5 October 2021 (UTC)
Including info about non sovereign states such as Pitcairn Islands and others is the fastest way to cram a table with unnecessary clutter. CGBoas ( talk) 11:33, 13 November 2021 (UTC)
COVID-19 pandemic in Isle of Man has been marked as an incorrect name. Should be COVID-19 pandemic in the Isle of Man. wbm1058 ( talk) 03:51, 28 March 2024 (UTC)
row._code == 'UK'
–
wbm1058 (
talk) 22:45, 28 March 2024 (UTC)