Template talk:COVID-19 vaccination data

Source: Wikipedia, the free encyclopedia.

Wikitable solution proposal

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 Kingdom4,973,2478.1%
 EU 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
  1. ^ Latest available data as of this date. Individual country reporting frequency varies.
  2. ^ *Number of unique individuals who have received at least one dose of a COVID-19 vaccine.
  3. ^ Percentage of population that has received at least one dose of a COVID-19 vaccine.

References

  1. ^ "Coronavirus (COVID-19) Vaccinations". Our World in Data.

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)[]

@Tenryuu, Sdkb, Timeshifter, -Hyde-, Yug, RScheiber, WikiHannibal, Axelcabrera100, and Naldo-Crocoduck: Let me know what you think. - Wikmoz (talk) 20:37, 9 January 2021 (UTC)[]
I do not think I will (be able to) edit it this way. Have you considered something like the layout of Template:COVID-19 testing by country? Anyway, I have only updated the Czech Republic data, so my contribution is not that relevant. WikiHannibal (talk) 21:00, 9 January 2021 (UTC)[]
Understood. Just tagged a few recent editors to see if they may be able to step through this routine once a week instead of updating individual countries. - Wikmoz (talk) 21:58, 9 January 2021 (UTC)[]
If this could be adapted to Google Sheets, that'd be great, as individually downloading, processing, and uploading will require coordination from editors to avoid wasted effort. I can't say if all versions of Excel have the same layout that applies to someone following the instructions as is. —Tenryuu 🐲 ( 💬 • 📝 ) 21:14, 9 January 2021 (UTC)[]
Updated to add Google Sheets instructions and to indicate the version requirement for Excel. The entire process takes about 3 minutes so if by chance two editors execute at the same time, there's not much wasted effort. - Wikmoz (talk) 21:58, 9 January 2021 (UTC)[]
Could you add freeware LibreOffice Calc instructions? Also pinging: Quantocius Quantotius --Timeshifter (talk) 23:43, 9 January 2021 (UTC)[]
I don't have LibreOffice but read about compatability with Excel and it looks like the same formula should work. - Wikmoz (talk) 02:21, 10 January 2021 (UTC)[]
Hi everyone , hi Wikmoz.When I have created the chart I thinked I could manage some countries and then everybody could update the data and add countries,but for once things are getting faster.I'm ok for the Wikmoz proposal but we can also put the % of the population been vaccinated in a comment alongside the bar like thisZiemiaanim.gif Axelcabrera100 (talk 17:09, 10 January 2021 (UTC)[]
Year Passengers (% change from prior year)
2003-04
110,649(+17.8%)
Or we can even create 2 bar charts one for the number of the vaccines administered and other bar for the % of the population for each country been vaccinated. Like this:
Fiscal year Revenue passengers Aircraft movements
2001-02
20,194
2,281
I create the bar chart because with the bars we see the difference of the effectiveness of the differents governments so thats why I prefer that. As shown above we can but 2 bars to include data of % of the population vaccinated as proposed by Wikmoz . A final solution will be a web scraping tool in Phyton or something like that to use a bot to do the mechanical task of extracting data from ourworldindata.org.Cheers and hope this pandemic nightmare end as soon as possible.I'm searching to do that web scraping tool but if anyone knows a IT engineer friend because for them is very easy will be nice because the sooner the better.Besides I think the Excel and Google Sheets updates are good ideas. Ziemiaanim.gif Axelcabrera100 (talk 17:09, 10 January 2021 (UTC)[]
Unfortunately, the bar charts don't work well because the world and large country totals throw off the scale for most other countries. We're also unable to wrap them in a scrollbox. On a related note, it looks like OWID is intentionally not referring to the % of population vaccinated because countries are inconsistent in how they report numbers (first dose only vs all doses) so they're just reporting doses per 100 as a rough indicator of volume. - Wikmoz (talk) 17:31, 11 January 2021 (UTC)[]
Updated formula and instructions to capture total vaccinated and vaccinated as a percentage of population... new data being reported by OWID to account for two dose regimens. - Wikmoz (talk) 04:22, 13 January 2021 (UTC)[]
I figured out how to format the table so that the copy and paste through Word is not needed. Reduced the code times by a minute. Also removed the last column with the 'As of:' date so there's one less data point to update if doing this manually. Added EFN that individual country data update frequency varies. - Wikmoz (talk) 21:45, 16 January 2021 (UTC)[]
THANK YOU BRO Wikmoz Ziemiaanim.gif Axelcabrera100 (talk 06:12, 17 January 2021 (UTC)[]

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)[]

I can run a full table update every few days. The steps above, once learned take literally 3 minutes to run. I was waiting for another volunteer before pushing this version live. However, given that it includes the same data points that are currently being manually updated I guess there's no harm doing the swap now. - Wikmoz (talk) 22:22, 21 January 2021 (UTC)[]

Vaccination numbers are wrong

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)[]

On the second day of vaccination today, 17,072 beneficiaries administered the vaccine and a total of 2,24,301 — Amkgp 💬 19:58, 17 January 2021 (UTC)[]
Hi! Amkgp Thanks for the info, the table has been updated. Ziemiaanim.gif Axelcabrera100 (talk 22:27, 17 January 2021 (UTC)[]

About the distracting spinning Earth gif

@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)[]

@Betseg: That's the point,the main reason for I've created the bar chart it's to bring attention on the slowniness of the Governments vaccination campaign. I regulary update the bar chart with current data of at least 15 countries looking directly OWID's sources every day while you keep eraising an earth gif. At least I propose a register votes.Seriously you waste my time I hope you're happy.— Preceding unsigned comment added by Axelcabrera100 (talkcontribs) 16:14, 20 January 2021 (UTC)[]
Do not add a spinning Earth gif, as it is distracting. — Goszei (talk) 19:03, 20 January 2021 (UTC)[]
keep the earth gif
yes no
1 1
@Betseg: Well I don't see how we can advance further since I think the earth gif it's important and you dont. Since you dont want to vote, any other idea? maybe we can decide on heads or tails.I choose heads. Besides you should look up turkey's vaccination campaign and not a gif image.Ziemiaanim.gif Axelcabrera100 (talk 19:47, 20 January 2021 (UTC)[]
Is... is this about a signature? Can this discussion take place somewhere else, like Axelcabrera100's user talk page? —Tenryuu 🐲 ( 💬 • 📝 ) 19:51, 20 January 2021 (UTC)[]
Tenryuu, looks like the same gif was being used in this template to identify worldwide numbers. This template is wrong on many fronts, but no, we should definitely not use a gif on a template. Even more so on one used on lots of pages. Please do not re-add this axelcabrera100. Best Wishes, Lee Vilenski (talkcontribs) 19:55, 20 January 2021 (UTC)[]
@Lee Vilenski: for the info I only have created one bar chart of countries vaccination data wich Wikmoz converted in a template. If others users use the template in other sections its not my fault because you lack of information you should see the history's pages that you indrectly allegate that were put by me and you dont have to mention me either guy.Or at least create productive content insted og being in chats.Ziemiaanim.gif Axelcabrera100 (talk 20:05, 20 January 2021 (UTC)[]
You have the same spinning gif in your signature. GIFs should not be in templates. here is a diff of you adding such a gif. Not that it matters, just please don't have GIFs in templates. I've also removed the flags, per MOS:FLAG Best Wishes, Lee Vilenski (talkcontribs) 20:19, 20 January 2021 (UTC)[]
I dont even want to talk to you guy.Write about brexit or whatever.Ziemiaanim.gif Axelcabrera100 (talk 20:24, 20 January 2021 (UTC)[]
@Lee Vilenski: All the templates have flags i will not put a gif could you stop removing the flags.
Pings do not work if you do not sign your posts with four tildes. Consistency with other templates is irrelevant, see WP:OTHERSTUFFEXISTS Best Wishes, Lee Vilenski (talkcontribs) 20:58, 20 January 2021 (UTC)[]
@Lee Vilenski: ok thank you Ziemiaanim.gif Axelcabrera100 (talk 21:06, 20 January 2021 (UTC)[]

Adding Source for US

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)[]

Table source list

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)[]

Actually, I figured out how to code for the the noflag version so that's an option as well. - Wikmoz (talk) 06:12, 25 January 2021 (UTC)[]
Thank you, I assumed it might have been an automatic update that caused it, but as it was the first occurrence I thought I'd wait and see. FDW777 (talk) 07:46, 25 January 2021 (UTC)[]

Compact of Free Association data

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. GreenRunner0 21:34, 29 January 2021 (UTC)[]

GreenRunner0, Thanks for highlighting on the talk page. Ideally, OWID would report these numbers so they can be included in the automated refresh. Short of that, we can add the numbers below the templated numbers. The nations would appear at the bottom of the list by default but would get sorted in with the others whenever a user re-sorts a column. Alternatively, we could put these in as a separate unsortable section at the bottom but not sure what the title would be. Let me know what you think. - Wikmoz (talk) 20:34, 1 February 2021 (UTC)[]
I'm fine with moving them to the bottom of the list (behind a nowiki note) to prevent wiping as a temporary workaround. The issue should probably be brought up with the OWID team on the project's GitHub; they seem fairly responsive to new data. GreenRunner0 22:31, 1 February 2021 (UTC)[]
I'll do my best. The reference for all three is the same source as the USA. GreenRunner0 05:59, 2 February 2021 (UTC)[]
I've raised the issue with OWID team on GitHub. Hopefully that fixes solves our issue but I'll maintain them here in the interim. GreenRunner0 06:07, 2 February 2021 (UTC)[]

Update to excel formula to account for total vaccination figures

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>"

It's a good idea. I was moving data between columns and applying a separate formula (with EFN) for those countries but it could be done this way to speed things up. I fixed a minor error (missing closing parens on the number formatting), added the red highlighting, and escaped the ampersand so the &nbsp;s around the globe icon aren't lost...
=IF(A2="World","| &nbsp;[[File:Emojione 1F310.svg|23x15px|alt=|link=]] &nbsp;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>"
The one catch is that the default Excel sort needs to be based on total doses. The World total also needs to be overwritten to add the full EFN and reflect total doses. It's not ideal but may be necessary until at least China starts breaking out their numbers:
="| &nbsp;[[File:Emojione 1F310.svg|23x15px|alt=|link=]] &nbsp;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>"
Alternatively, we could add a different EFN indicating that the World totals exclude countries that don't report the first dose counts? - Wikmoz (talk) 00:14, 3 February 2021 (UTC)[]
It looks like OWID is now counting China's numbers as first-dose only. This makes things easier. I've updated the code to add a new EFN for the World total, exclude the percentages for countries not reporting first-dose only, and removed England, Scotland, Wales, and North Ireland per discussion below.
=IF(A2="World","| &nbsp;[[File:Emojione 1F310.svg|23x15px|alt=|link=]] &nbsp;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>"
- Wikmoz (talk) 21:33, 5 February 2021 (UTC)[]
So, OWID now includes figures for entire continents. It probably makes to remove them too in the table so it stays simple as the original. Updated the formula by Wikmoz as below. Bom4446 (talk) 11:04, 18 March 2021 (UTC)[]
=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>"
Thank you Bom4446! I adjusted your fix above to correct the padding (Wikipedia drops the &nbsp; markup unless the ampersand is escaped so it's now replaced with a padding template). Will update the template documentation. - Wikmoz (talk) 19:05, 18 March 2021 (UTC)[]

United Kingdom data

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)[]

  • Many thanks for doing this. Elshad (talk) 13:09, 7 February 2021 (UTC)[]

Serbia

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)[]

A little update on Serbia, in case someone is confused with OWID data: https://www.alo.rs/vesti/drustvo/592-634-primilo-vakcinu-sve-veci-broj-revakcinisanih/383807/vest. To sum up, up to yesterday, 592,634 people in total have been vaccinated (first shot), while 47,665 have also been revaccinated (second shot). I see that someone updated the template with the first number, which is correct. OWID however, reports 640,299, which is the total number of doses administered (592,634 + 47,665). So, if someone was confused, I hope I explained it now. It's just a discrepancy in data reporting methodology. Cheers, 178.223.106.73 (talk) 19:32, 11 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)[]

Edl-irishboy, please see above. I think the best solution may be to change the disambiguation page to a redirect. - Wikmoz (talk) 21:03, 28 February 2021 (UTC)[]

Canada

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)[]

It appears that OWID switched its data source for Canada from https://health-infobase.canada.ca/covid-19/vaccination-administration/ to https://covid19tracker.ca/ earlier today. So this should resolve the issue going forward. - Wikmoz (talk) 18:59, 3 March 2021 (UTC)[]

Deployment of COVID-19 vaccines by country

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

Notes

  1. ^ Latest available data as of this date. Individual country reporting frequency varies.
  2. ^ Number of unique individuals who have received at least one dose of a COVID-19 vaccine (unless noted otherwise).
  3. ^ Percentage of population that has received at least one dose of a COVID-19 vaccine.
  4. ^ Some countries are not yet reporting first-dose counts. Total dose counts for these countries are not included in the World total.

Cite error: A list-defined reference named "incorrect-total" is not used in the content (see the help page).


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

Notes

  1. ^ Latest available data as of this date. Individual country reporting frequency varies.
  2. ^ Number of unique individuals who have received at least one dose of a COVID-19 vaccine (unless noted otherwise).
  3. ^ Percentage of population that has received at least one dose of a COVID-19 vaccine.
  4. ^ Some countries are not yet reporting first-dose counts. Total dose counts for these countries are not included in the World total.

Cite error: A list-defined reference named "incorrect-total" is not used in the content (see the help page).

Ideally, those links would be a little better. Unfortunately, the links are generated dynamically in Excel and need to follow the same pattern so there's no straightforward way to selectively change the target for certain large countries that have breakout vaccine articles. The best solution might be to add a link to the category page in a hatnote and prose. - Wikmoz (talk) 04:26, 12 March 2021 (UTC)[]
@Wikmoz: Another reason why I'm suggesting this is that the See also section of the main article is getting longer, making it an eyesore. —hueman1 (talk contributions) 14:57, 12 March 2021 (UTC)[]
I tried a new formatting option there with countries listed in columns. I think this should resolve the list length issue. - Wikmoz (talk) 22:02, 12 March 2021 (UTC)[]
Yes, editor of COVID-19 vaccination in Canada here, I believe it would be more appropriate to link to those articles if they exist, and then to their pandemic articles if they don't exist. CaffeinAddict (talk) 02:54, 24 March 2021 (UTC)[]

Removal of the EU

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)[]

At least give us a page where the data of the EU is included!!!--2A02:810A:11BF:E564:DC14:1C28:6619:6013 (talk) 13:24, 27 March 2021 (UTC)[]
It's not being removed by the automated process. Bom4446, can we restore the EU? Helpful to see numbers for the union in aggregate. - Wikmoz (talk) 21:52, 27 March 2021 (UTC)[]
Wikmoz I agree EU figures are important. Remember one of the users delete it saying we don't include other blocks in the table. EU figures have been restored. Apologies for the lack of notification. Bom4446 (talk) 13:17, 28 March 2021 (UTC)[]
Is it possible to automatic link to the European Union response to the COVID-19 pandemic instead of the European union? Nico (talk) 05:42, 29 March 2021 (UTC)[]
The link is generated by Template:Flag+link. If the designated article doesn't exist (in this case, it's looking for COVID-19 pandemic in European Union) then it will revert to the main country link. To resolve the issue, someone would just need to create a redirect from COVID-19 pandemic in European Union to European Union response to the COVID-19 pandemic. - Wikmoz (talk) 08:00, 29 March 2021 (UTC)[]
Done. Nico (talk) 17:39, 29 March 2021 (UTC)[]

Article on COVID-19 vaccine distribution by location?

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 is an article on COVID-19 vaccine deployment, which covers this subject in depth. Our World in Data: Coronavirus (COVID-19) Vaccinations is also great resource. A dedicated topic on statistics doesn't appear necessary (WP:NOTDATABASE and WP:TENYEARTEST). - Wikmoz (talk) 22:00, 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)[]

In the meanwhile, I updated Serbia data with today's numbers, so please check revision history in order to understand what I was talking about. 178.220.248.46 (talk) 13:59, 10 April 2021 (UTC)[]
Great catch! This should be a rare issue and not too meaningful in the grand scheme of things. The issue is that OWID reports the data to 2 decimal places and we round to 1. Relevant data for Serbia follows:
Serbia,SRB,2021-04-09,2836012,1677268,1158744,,44878,41.68,24.65,17.03,6595
In this case the number reported by OWID is 24.65% (not 24.649%), which impacts whether we round up or down. I believe this should only affect 5% of the reported numbers each day. In the cited example, we'd be left about 0.2% away from the correct number (24.649) regardless of whether we rounded up or down. - Wikmoz (talk) 20:52, 10 April 2021 (UTC)[]
Thank you for the explanation! I see your point that there's no substantial difference whether we choose to round it up or down. However, maybe it would be the best to follow OWID's tie-breaking rule, which is neither of those two, but presumably round half to even, the mostly used one in mathematics and computing (I'm not sure why Excel is an exception, I guess that's where this "problem" comes from). To be specific, look at the graphic here, it says 24.6 for Serbia. If automated script writes 24.7, one could argue it's misquoting the reference. Of course, I'm being minutious by saying that, but I just wanted to share my thougths on it. In the end, it could be the best to keep both decimals. 178.220.248.46 (talk) 22:51, 10 April 2021 (UTC)[]

Gibraltar percentage

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)[]

Good catch. The same issue appears on OWID. It doesn't yet appear in the list of open issues on GitHub if someone would like to report it. Otherwise, I'm sure this will be noticed and corrected by someone at OWID in the near future. - Wikmoz (talk) 21:35, 13 April 2021 (UTC)[]
Thank you for the additional information! This makes sense. We can add an additional footnote along the lines of "May include vaccination of foreigners and migrant workers, which can increase the percent of the population vaccinated beyond 100%." What do you think? Could keep it as a general footnote or automatically link to it from any country exceeding 100%. - Wikmoz (talk) 19:03, 16 April 2021 (UTC)[]
Yes, that seems like a good footnote example. The thing is, we should emphasize that the number of vaccinations is tied to locations themselves (as is first column's name), and not their citizens or residents. As for whare to put it, I would make it general, since it's applicable to many countries/territories (including aforementioned Serbia and Canada), and not just those exceeding 100 % (just Gibraltar for now). 109.92.56.196 (talk) 00:26, 17 April 2021 (UTC)[]
Sounds good. I added the following EFN in the column header: "May include vaccination of non-citizen workers, which can push totals beyond 100% of the local population." - Wikmoz (talk) 06:55, 17 April 2021 (UTC)[]

Automation of updates to this template

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)[]

@Tol: great work! Can you adjust the bot to update Template:COVID-19_vaccination_data as well? Also, where are you getting the percentage figures from? I can't see these in the original data at https://github.com/owid/covid-19-data/tree/master/public/data/vaccinations. Greenman (talk) 20:42, 27 May 2021 (UTC)[]
@Greenman: No problem! I'm somewhat busy right now, but this shouldn't be too hard. For this, I use a blacklist so that new countries can be added; for Africa, I'll probably use a whitelist of African country names instead. I should have a working version in anywhere between a few days and a month (sorry!). Tol | Talk | Contribs 21:01, 27 May 2021 (UTC)[]
Thanks! Greenman (talk) 21:06, 27 May 2021 (UTC)[]
You're welcome! Tol | Talk | Contribs 21:08, 27 May 2021 (UTC)[]
Symbol wait.svg BRFA filed. Tol | talk | contribs 18:33, 1 June 2021 (UTC)[]

Add disputed territories?

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

  1. ^ "Vaccination has begun in Abkhazia, the tourist season has begun". English Jamnews. 2021-05-15. Retrieved 2021-05-16.
There are some issues with this — we get our data from Our World in Data, and my bot automatically updates the table from there. I think that if Abkhazia's numbers are counted under Georgia's in OWID, we should leave it be; if not, somebody could manually add and update their numbers in the CoFA section. Tol | Talk | Contribs 19:35, 16 May 2021 (UTC)[]
I've raised the issue on the Github repository, we can see if OWID adds it to their database first. --17jiangz1 (talk) 16:29, 28 May 2021 (UTC)[]
Similar situations also apply to other disputed territories of Luhansk PR, Donetsk PR, South Ossetia, Transnistria, Artsakh, and Sahrawi Arab DR, which have all started their own vaccination programs, --17jiangz1 (talk) 20:12, 28 May 2021 (UTC)[]

Double counting

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)[]

Population—count non-resident citizens?

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)[]

Canada - again

Where is the source for Canada coming from? I believe it is over-reporting percentage. CaffeinAddict (talk) 00:33, 22 June 2021 (UTC)[]

This hasn't been resolved - Canada is about 1% over reported. CaffeinAddict (talk) 05:44, 11 July 2021 (UTC)[]
According to the Github repository, they're taking the data from https://covid19tracker.ca/vaccinationtracker.html. Nsophiay (talk) 19:22, 11 July 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)[]

If there is no opposition, I will implement this change after BRFA TolBot 5 is approved. Tol | talk | contribs 23:48, 21 July 2021 (UTC)[]
I am implementing the module now. Tol | talk | contribs 04:14, 26 July 2021 (UTC)[]

Data & sorting

@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)[]

Most of the date is now missing, agree with Phoenix7777. Mtaylor848 (talk) 09:55, 26 July 2021 (UTC)[]
@Phoenix7777: The table is sorted by vaccination doses (as it always has been), with a fallback to people vaccinated and people fully vaccinated. I have added code to not override a number with "null" if the newest data is "null", and I am manually copying over old data from the table. Tol | talk | contribs 00:02, 27 July 2021 (UTC)[]
@Tol: The column "Vaccinated" corresponds to "people_vaccinated" (Number of people who have received at least one dose of a COVID-19 vaccine). So sorting by "total_vaccinations" is wrong. Template:COVID-19 data/data has currently 120 entries with "total_vaccinated" null among 224 entries. You cannot solve the problem by manually copying the data. TolBot should be revised to copy all data. By the way, where can I find the source code of TolBot?―― Phoenix7777 (talk) 02:17, 27 July 2021 (UTC)[]
@Phoenix7777: It turns out there was a problem with using the CSV with all data; I've revised it to use a JSON page with only the latest data. As for sorting, the table has always been sorted by total vaccinations (see the old documentation, under "Semi-automated update instructions"). I can change that to sort by people vaccinated, if you like (this would require a change to the Lua module). I haven't got around to publishing the source code of TolBot Task 5, but I'll do that within the next few days. Tol | talk | contribs 03:13, 27 July 2021 (UTC)[]
@Tol: Please sort this table by "people_vaccinated". It is unlikely to sort the column by hidden values.―― Phoenix7777 (talk) 14:12, 27 July 2021 (UTC)[]
@Phoenix7777: I will implement that in the Lua module. Tol | talk | contribs 17:55, 27 July 2021 (UTC)[]
As a follow-up, I think it would be better to sort by people vaccinated and fallback to total vaccinations and then to people fully vaccinated. Currently, it is sorted by total vaccinations, with a fallback to people vaccinated and then to people fully vaccinated. The problem is that total vaccinations is greater than people vaccinated, which is greater than people fully vaccinated. Changing the sorting would mean that countries with incomplete data would potentially be higher than they should be (if there were data for all countries); however, it also means that sorting will be in line with the numbers displayed. I'll implement this change with the fallbacks (so that it's sorted the same way as the numbers in the "Vaccinated" column). Tol | talk | contribs 18:04, 27 July 2021 (UTC)[]
@Tol: I temporarily fixed the above. Please feel free to update the fix.―― Phoenix7777 (talk) 22:49, 31 July 2021 (UTC)[]
@Phoenix7777: Thanks; your fix is perfect! Tol (talk | contribs) @ 23:02, 31 July 2021 (UTC)[]

Percentage precision

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)[]

I agree, this downgraded the table's quality significantly... I've followed table's evolution since the beginning, and several months ago, I even objected trimming percentage to only one decimal from previous two. Even that reduced the quality and introduced many rounding errors (see #Incorrect_rounding). Removing decimals pushes the problem even further. The error is maximum 0.5 %, which may not seem special, bit it actually is huge, not only at the foot of the table, but also for all big countries. As an example, that means the error for India is several million people, which is like 100% for lot of smaller countries. 91.150.120.238 (talk) 15:41, 27 July 2021 (UTC)[]
@Mtaylor848: I will implement this in the Lua module. Currently, everything is processed into an integer. Tol | talk | contribs 17:56, 27 July 2021 (UTC)[]
@Tol: I temporarily fixed the above. Please feel free to update the fix.―― Phoenix7777 (talk) 22:49, 31 July 2021 (UTC)[]
Thank you; that works for now! I'll see if I can improve significant figures later (everything should have two digits after the decimal point). Tol (talk | contribs) @ 23:07, 31 July 2021 (UTC)[]

Vatican City

Why would Italy include Vatican City when it's well known that it has state-hood? CaffeinAddict (talk) 19:05, 27 July 2021 (UTC)[]

@CaffeinAddict: It's what Our World in Data reports. My best guess is that the Vatican gets vaccines from Italy. Tol | talk | contribs 21:47, 27 July 2021 (UTC)[]

No indication of date in table caption. Can an auto-dating template be added in articles?

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 17: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 17:21 UTC on 18 October 2021, there are 240,957,825 confirmed cases and 4,902,519 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)[]

Hello @Timeshifter! The data is indeed updated daily by a bot (TolBot Task 5). Tol (talk | contribs) @ 13:51, 22 September 2021 (UTC)[]
Thanks Tol. I noted the daily updating above the table in all the article pages. Also, in the reference. --Timeshifter (talk) 20:41, 22 September 2021 (UTC)[]
@Timeshifter: No problem! Tol (talk | contribs) @ 20:44, 22 September 2021 (UTC)[]

Redlink - Ireland

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)[]

CaffeinAddict. Redirect created from COVID-19 vaccination in Republic of Ireland.
You can do this too. See wikitext here:
https://en.wikipedia.org/w/index.php?title=COVID-19_vaccination_in_Republic_of_Ireland&redirect=no
#redirect [[COVID-19 vaccination in the Republic of Ireland]]
--Timeshifter (talk) 08:39, 26 September 2021 (UTC)[]
I know that I could have done that, I suppose the issue to me wasn't the redirect, but the auto-generated page names in the template. CaffeinAddict (talk) 17:45, 26 September 2021 (UTC)[]
@CaffeinAddict: The module just links to "COVID-19 vaccination in {country name}", and redirects are created for exceptions (countries with "the"). It used to link to "COVID-19 vaccination in Ireland", but I recently changed the name to "Republic of Ireland" because COVID-19 pandemic in Ireland was turned into a disambiguation page. My apologies for not checking vaccination page links as well. Tol (talk | contribs) @ 21:25, 26 September 2021 (UTC)[]

UAE

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)[]

@CaffeinAddict: There is already a note in the header (the percentages header): "May include vaccination of non-citizens, which can push totals beyond 100% of the local population." Many countries vaccinate non-citizens, so I don't think it's necessary to add a specific note for the UAE. Tol (talk | contribs) @ 18:56, 5 October 2021 (UTC)[]
Okay - I've seen that before as there was an issue with that when Vatican City was being reported separately. Right now just from an occasional viewer's perspective it gives a false perception that 93% of the country's citizens (not just inhabitants) are vaccinated. Although I don't know enough about to UAE to piece that together. CaffeinAddict (talk) 19:28, 5 October 2021 (UTC)[]