Template talk:COVID-19 vaccination data

Wikitable solution proposal
As discussed in, 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:



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.


 * Microsoft_Office_Excel_%282018%E2%80%93present%29.svg Excel update instructions (<3 minutes)
 * Requires Microsoft Excel (2007 or later)


 * 1) Open vaccinations.csv in Excel (GitHub source for reference)
 * 2) Enable filters [Data > Filter]
 * 3) Sort by date (column C) newest to oldest
 * 4) Select [Data > Remove Duplicates] and uncheck all but Location (this will remove all older entries)
 * 5) Sort by people vaccinated (column E) largest to smallest
 * 6) Select cell M2 and paste this formula into the Formula field at the top of the screen  (to the right of the 'fx' symbol):




 * 1) Press the enter key to register the formula. Extend the formula to the last row (Click on M2 and double click the black square in the bottom right of the cell)
 * 2) Copy and paste into Wikipedia.


 * Google Docs icon (2020).svg Google Sheets update instructions (~3 minutes)


 * 1) Open vaccinations.csv in a browser
 * 2) Copy (Ctrl+A then Ctrl+C) and paste (Ctrl+V) the contents into Google Sheets (be sure cell A1 is selected before pasting)
 * 3) Enable filters [Data > Create a Filter]
 * 4) Sort by date (column C) Z to A (most recent first)
 * 5) Select [Data > Remove Duplicates]. Uncheck 'Select all' and check off 'Column A' for location. (this will remove older entries)
 * 6) Sort by people vaccinated (column E) Z to A (largest to smallest)
 * 7) Select cell M2 and paste this formula into the Formula field at the top of the screen  (to the right of the 'fx' symbol):




 * 1) Press the enter key to register the formula. Extend the formula to the last row (click on M2 and then double click on the black square in the bottom right of the cell)
 * 2) Copy and paste into Wikipedia.

- Wikmoz (talk) 20:28, 9 January 2021 (UTC)


 * 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: --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)


 * 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:


 * 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)

India data update
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. 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
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)


 * 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 (talk • contribs) 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)


 * WP:DEM --Betseg (talk) 19:03, 20 January 2021 (UTC)


 * 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 's user talk page? — Tenryuu 🐲 ( 💬 • 📝 ) 19:51, 20 January 2021 (UTC)
 * , 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 . Best Wishes,  Lee Vilenski (talk • contribs) 19:55, 20 January 2021 (UTC)
 * 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 (talk • contribs) 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)


 * 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 (talk • contribs) 20:58, 20 January 2021 (UTC)
 * 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)
 * The delay was not on OWID's side. CDC did not update statistics on cdc.gov for several days. I think you just caught the several hour gap between when CDC finally refreshed the numbers and OWID published those numbers. - Wikmoz (talk) 23:19, 21 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)

Northern Ireland
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. Green Runner  0  21:34, 29 January 2021 (UTC)
 * Just to follow-up, I went ahead and manually added them to the current template, but they should probably be added to User:Wikmoz's template so they don't get wiped out by future updates. Green  Runner  0  16:43, 1 February 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. Green  Runner  0  22:31, 1 February 2021 (UTC)
 * Sounds good. I will do this with the next update. Can you add a reference for each source? Will you be able to regularly update data for these entries? - Wikmoz (talk) 22:35, 1 February 2021 (UTC)
 * I'll do my best. The reference for all three is the same source as the USA. Green  Runner  0  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. Green  Runner  0  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)


 * 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 &#38;nbsp;s around the globe icon aren't lost...




 * 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:




 * 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.




 * - 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)




 * Thank you Bom4446! I adjusted your fix above to correct the padding (Wikipedia drops the &#38;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)


 * Please report this to OWID, GreenRunner0 found this GitHub page where you can report issues directly to the people in charge of updating the data. - Wikmoz (talk) 22:00, 3 February 2021 (UTC)


 * Hmm, it seems I need a GitHub account for that. I guess I'll create one if I find time. If not, I'll update this template every once in a while... Thank you for the answer! 94.189.131.122 (talk) 22:18, 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)

Link to the Republic of Ireland
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, 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)
 * Can someone correct this? I am not knowledgable enough to get into this. CaffeinAddict (talk) 00:28, 3 March 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)
 * Thanks for the update. CaffeinAddict (talk) 04:37, 5 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:  

instead of this:  
 * 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)
 * 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)

Incorrect rounding
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 ) 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:
 * 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)
 * In the case you're referencing, OWID rounded down because they know the actual number (24.6490460271) is closer to 24.6 than to 24.7. Excel would round it the same way. We just don't have that level of detail in the provided data. - Wikmoz (talk) 03:52, 11 April 2021 (UTC)
 * In the case you're referencing, OWID rounded down because they know the actual number (24.6490460271) is closer to 24.6 than to 24.7. Excel would round it the same way. We just don't have that level of detail in the provided data. - Wikmoz (talk) 03:52, 11 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)


 * Don't forget that Gibraltar vaccinated Spanish citizens who travel to work there every day, so they aren't their citizens or even residents, but are still counted as vaccinated. Other countries do it to, for example, Serbia vaccinated about 30.000 foreign citizens who reside in neighbouring countries just the last weekend, plus a lot more Serbian citizens who don't live in Serbia. That is at least 1 % of the total population (and definitely much more in total, because that's data from just one weekend), which means that if the whole real population gets vaccinated, total would be well over 100 %. As for GitHub, note that this question HAS BEEN raised two days ago, but the issue was closed as it has been concluded that everything's okay. 178.221.60.179 (talk) 04:28, 14 April 2021 (UTC)
 * This is true, Canada is now vaccinating migrant farm workers coming into the country for part of the year. Not sure what to do. CaffeinAddict (talk) 03:27, 16 April 2021 (UTC)
 * Well, yes, I guess more and more countries are going to do that, as vaccines become more widely available. Since it would take much effort to track numbers of vaccinated non-residents, I think it would be best to ignore it for now, the same way OWID, our main source, does. However, it could be handy to add a note to the template, with brief explanation what's going on. We probably won't see many countries hitting the 100 % mark and going over it, but it could be confusing even at this point, when we have Gibraltar. 109.92.56.196 (talk) 18:01, 16 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 Bots/Requests for approval/TolBot, if anybody is interested to take a look or comment there. Tol &#124; Talk &#124; Contribs (formerly Twassman) 00:16, 17 April 2021 (UTC)
 * 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: I'm not exactly sure what you mean by the first question. It has been approved to update the template every day, and does so. The bot gets the percentages from https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/vaccinations/vaccinations.csv (specifically, the column ). Tol &#124; Talk &#124; Contribs 20:46, 27 May 2021 (UTC)
 * Sorry, pasted wrong link! I meant Template:COVID-19 vaccination data in Africa. Greenman (talk) 20:53, 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 &#124; Talk &#124; Contribs 21:01, 27 May 2021 (UTC)
 * Thanks! Greenman (talk) 21:06, 27 May 2021 (UTC)
 * You're welcome! Tol &#124; Talk &#124; Contribs 21:08, 27 May 2021 (UTC)
 * Symbol_wait.svg BRFA filed. Tol  &#124; talk &#124; 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. If you don’t want to add it alone, we could alternatively add Abkhazia’s vaccination data into Georgia’s.


 * 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 &#124; Talk &#124; 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)

Using Lua and JSON
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 &#124; talk &#124; contribs 18:08, 16 July 2021 (UTC)


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

Data & sorting
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  &#124; talk &#124; contribs 00:02, 27 July 2021 (UTC)
 * 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  &#124; talk &#124; contribs 03:13, 27 July 2021 (UTC)
 * The source code is at User:TolBot/Task 5. Tol  &#124; talk &#124; contribs 04:01, 27 July 2021 (UTC)
 * 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  &#124; talk &#124; 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  &#124; talk &#124; contribs 18:04, 27 July 2021 (UTC)
 * 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 &#124; 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 ). 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  &#124; talk &#124; contribs 17:56, 27 July 2021 (UTC)
 * 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 &#124; 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  &#124; talk &#124; 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
 * Template:Cases in the COVID-19 pandemic

As of

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 on, there are  confirmed cases and  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)
 * COVID-19 pandemic by country and territory


 * Hello @Timeshifter! The data is indeed updated daily by a bot (TolBot Task 5). Tol  (talk &#124; contribs) @ 13:51, 22 September 2021 (UTC)
 * Thanks . 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 &#124; 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)
 * . 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 &#124; 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 &#124; 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)

Non sovereign states should be removed from the table
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
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)
 * you two may be the only editors who understand how this black box works. – wbm1058 (talk) 21:15, 28 March 2024 (UTC)
 * When I click on "Isle of Man", it links to COVID-19 pandemic in Isle of Man and redirects correctly to COVID-19 pandemic in the Isle of Man. Is the redirect not working for you or is there further change needed? Jroberson108 (talk) 21:53, 28 March 2024 (UTC)
 * Right. I was hoping that you could edit the module code to make it bypass that redirect. Lacking that I've made this edit to clear the pages from my Linked incorrect names report. Hopefully that doesn't upset, who marked that redirect as incorrect. – wbm1058 (talk) 22:00, 28 March 2024 (UTC)
 * I've changed it in the module. Jroberson108 (talk) 22:12, 28 March 2024 (UTC)
 * For each location, the code links to "COVID-19 pandemic in [location name]". This works for the vast majority of locations; redirects handle the few others, like this one or COVID-19 pandemic in United Kingdom. There's no good way to bypass the redirect; if this is necessary, we would need to add special exceptions for each case like this. Tol  (talk &#124; contribs) @ 22:14, 28 March 2024 (UTC)
 * Yeah, the redirect is preferable to adding more exception code to the module. Jroberson108 (talk) 22:18, 28 March 2024 (UTC)
 * Thanks. I hear where you guys are coming from. I've seen this scenario play out in other modules. I try to balance the line between perfectionists and the efficiency-minded. Now I've seen how you did it, I suppose I could "fix" the UK now, if someone ever insisted, assuming that for the UK  – wbm1058 (talk) 22:45, 28 March 2024 (UTC)
 * No, it's not "UK". The module reads from a JSON file that has all the codes. You can just mention it on the talk page if it needs changing. Jroberson108 (talk) 23:03, 28 March 2024 (UTC)
 * For reference, Template:COVID-19 data/data. Tol  (talk &#124; contribs) @ 23:10, 28 March 2024 (UTC)
 * I guess they are ISO 3166-1 Alpha-2 codes? Tol set all this up. The code for "World" is probably unique. Not sure if other's differ too. Jroberson108 (talk) 23:16, 28 March 2024 (UTC)