Template:COVID-19 vaccination data

[show all]
[collapse]
v
t
e
COVID-19 vaccine distribution by location
(as of 5 May 2021^[a])^[1]
Location	Vaccinated^[b]	% of pop.^[c]
World^[d]	616,273,053	7.9%
China^[e]	284,595,000	--
United States	147,894,671	44.2%
India	128,627,919	9.3%
EU	113,808,942	25.6%
United Kingdom	34,667,904	51.1%
Brazil	30,364,738	14.3%
Germany	24,546,919	29.3%
Turkey	14,132,161	16.8%
France	16,158,403	23.7%
Italy	15,190,069	25.1%
Canada	13,394,276	35.2%
Indonesia	12,699,568	4.6%
Mexico	12,740,897	9.9%
Russia	12,478,994	8.6%
Spain	12,381,213	26.5%
United Arab Emirates^[e]	10,779,163	--
Saudi Arabia^[e]	9,816,391	--
Poland	9,186,041	24.3%
Chile	8,169,056	42.7%
Argentina	7,149,293	15.8%
Bangladesh	5,819,757	3.5%
Israel	5,410,942	62.5%
Morocco	5,177,964	14.0%
Netherlands	4,448,730	26.0%
Hungary	4,099,495	42.4%
South Korea	3,530,014	6.9%
Colombia	3,454,250	6.8%
Romania	3,355,073	17.4%
Belgium	3,133,908	27.0%
Sweden	2,681,307	26.6%
Portugal	2,583,878	25.3%
Japan	2,493,961	2.0%
Austria	2,401,839	26.7%
Czech Republic	2,327,091	21.7%
Australia^[e]	2,316,969	--
Greece	2,214,648	21.2%
Pakistan	2,100,000	0.9%
Nepal	2,091,511	7.2%
Serbia	2,028,490	29.8%
Switzerland	1,841,984	21.3%
Philippines	1,786,480	1.7%
Finland	1,723,088	31.1%
Cambodia	1,515,447	9.1%
Denmark	1,387,556	24.0%
Singapore	1,364,124	23.3%
Dominican Republic	1,251,674	11.5%
Uruguay	1,191,957	34.3%
Peru	1,180,939	3.6%
Kazakhstan	1,422,204	7.6%
Norway	1,379,744	25.4%
Kuwait^[e]	1,367,000	--
Nigeria	1,246,845	0.6%
Ethiopia^[e]	1,168,268	--
Slovakia	1,156,789	21.2%
Ireland	1,159,083	23.5%
Thailand	1,150,564	1.6%
Mongolia	1,128,680	34.4%
Iran	1,083,138	1.3%
Qatar	1,047,196	36.4%
Myanmar	1,040,000	1.9%
Hong Kong	989,723	13.2%
Azerbaijan	980,005	9.7%
Sri Lanka	928,107	4.3%
Malaysia	914,663	2.8%
El Salvador	890,109	13.7%
Kenya	853,081	1.6%
Ghana	849,527	2.7%
Ecuador	821,960	4.7%
Jordan	805,020	7.9%
Ukraine	759,432	1.7%
Bahrain	747,409	43.9%
Croatia	716,861	17.5%
Lithuania	712,738	26.2%
Egypt	660,000	0.6%
Bolivia	637,694	5.5%
Bulgaria	619,256	8.9%
Costa Rica	605,099	11.9%
Uzbekistan	600,369	1.8%
Albania^[e]	537,387	--
Vietnam	506,435	0.5%
Panama	501,055	11.6%
Bhutan	480,818	62.3%
Angola	456,349	1.4%
Zimbabwe	452,191	3.0%
Slovenia	439,194	21.1%
Senegal	416,956	2.5%
Rwanda	350,310	2.7%
Estonia	346,940	26.1%
Uganda	341,819	0.8%
South Africa	339,655	0.6%
Tunisia	320,652	2.7%
Lebanon	307,573	4.5%
Maldives	298,396	55.2%
Iraq	298,377	0.7%
Malawi	296,127	1.6%
Latvia	273,574	14.5%
Oman	253,000	5.0%
Venezuela	250,000	0.9%
Belarus	244,000	2.6%
Afghanistan	240,000	0.6%
Malta	237,018	53.7%
New Zealand	217,603	4.5%
Ivory Coast	183,301	0.7%
Cyprus	176,082	20.1%
Guatemala	170,591	0.9%
Palestine	170,109	3.3%
Togo	160,000	1.9%
Luxembourg	152,149	24.3%
Sudan	140,227	0.3%
Jamaica	135,473	4.6%
Nicaragua	135,130	2.0%
Moldova	132,065	3.3%
Paraguay	131,013	1.8%
Laos	126,072	1.7%
Guyana	124,000	15.8%
Somalia	117,567	0.7%
Mauritius	117,323	9.2%
Iceland	110,199	32.3%
Guinea	95,911	0.7%
Barbados	75,006	26.1%
Algeria^[e]	75,000	--
Curaçao	74,294	45.3%
Macau	71,719	11.0%
Seychelles	68,045	69.2%
Taiwan^[e]	67,931	--
North Macedonia	66,086	3.2%
Equatorial Guinea	64,646	4.6%
Bosnia and Herzegovina	63,376	1.9%
Northern Cyprus	60,642	15.9%
Isle of Man	57,681	67.8%
Mozambique	57,305	0.2%
Fiji	56,000	6.2%
Sierra Leone	55,083	0.7%
Honduras	55,000	0.6%
Aruba	54,898	51.4%
Jersey	52,850	52.3%
Zambia	51,784	0.3%
Trinidad and Tobago	51,283	3.7%
Mali	49,903	0.2%
Botswana	49,882	2.1%
Georgia	45,338	1.1%
Belize	44,548	11.2%
Suriname	41,110	7.0%
Montenegro	40,843	6.5%
Gibraltar	37,504	111.3%
Cayman Islands	35,774	54.4%
Eswatini	34,897	3.0%
Guernsey	32,969	49.2%
Bermuda	32,129	51.6%
Antigua and Barbuda	29,754	30.4%
Kyrgyzstan	27,000	0.4%
Bahamas	25,692	6.5%
Saint Lucia^[e]	24,473	--
Andorra	23,822	30.8%
Kosovo	22,096	1.1%
San Marino	20,963	61.8%
Gambia	20,922	0.9%
Namibia	18,837	0.7%
Dominica	18,498	25.7%
Lesotho	16,000	0.8%
Turks and Caicos Islands	15,039	38.8%
Saint Vincent and the Grenadines^[e]	14,526	--
Faroe Islands	14,458	29.6%
Congo	14,297	0.3%
Monaco	12,758	32.5%
Grenada	12,666	11.3%
Greenland	8,900	15.7%
Liechtenstein	8,815	23.1%
Saint Kitts and Nevis	11,848	22.3%
Brunei	10,715	2.5%
Djibouti	10,246	1.0%
São Tomé and Príncipe	9,724	4.4%
Gabon	6,895	0.3%
Samoa^[e]	7,435	--
Mauritania	7,038	0.1%
Anguilla	6,115	40.8%
Tonga	5,367	5.1%
Solomon Islands	4,890	0.7%
Saint Helena	3,563	58.7%
Papua New Guinea	2,900	0.0%
Falkland Islands	2,632	75.6%
East Timor	2,629	0.2%
Syria	2,500	0.0%
Cape Verde	2,184	0.4%
DR Congo	1,700	0.0%
Niger	1,366	0.0%
Montserrat	1,293	25.9%
South Sudan	947	0.0%
Libya	750	0.0%
Nauru	700	6.5%
Armenia	565	0.0%
Cameroon	400	0.0%
F.S. Micronesia^[2]	21,323	20.6%
Marshall Islands^[2]	14,827	25.4%
Palau^[2]	12,808	71.5%
Vatican City^[3]^[4]	22	2.7%
Sources List of sources by country. Notes ^ Latest available data as of this date. Individual country reporting frequency varies. ^ Number of unique individuals who have received at least one dose of a COVID-19 vaccine (unless noted otherwise). ^ Includes those who are partially vaccinated with a single dose. May include vaccination of non-citizen workers, which can push totals beyond 100% of the local population. ^ Some countries are not yet reporting first-dose counts. Total dose counts for these countries are not included in the World total. ^ ^a ^b ^c ^d ^e ^f ^g ^h ⁱ ^j ^k ^l This country's data reflects total doses administered, not the first shot only.

Template documentation[view] [edit] [history] [purge]

Semi-automated update instructions[edit]

To manually update, reference values included in this GitHub source table. Columns labeled people_vaccinated and people_vaccinated_per_hundred contain relevant data. For corresponding visuals, look to these charts on Our World in Data.

To update the full table in <1 minute, use the Excel macro provided below.

Alternatively, to update the full table in ~3 minutes, run through the following steps:

Excel update instructions

Requires Microsoft Excel (2007 or later)

Open vaccinations.csv in Excel (GitHub source for reference and last updated date)
Enable filters [Data > Filter]
Sort by date (column C) newest to oldest
Select [Data > Remove Duplicates]. Click 'Unselect all' then check off Location and click 'Ok' (this will remove all older entries)
Sort by total vaccinations (column D) largest to smallest
Select cell M2^[a] and paste this formula into the Formula field at the top of the screen^[b] (to the right of the 'fx' symbol):

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

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)
Copy and paste into Wikipedia.
Delete all rows marked REMOVE.

Google Sheets update instructions

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

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

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)
Copy and paste into Wikipedia.
Delete all rows marked REMOVE.

^ If OWID adds additional columns to the source data, paste the formula in the last empty column.
^ ^a ^b Do not attempt to paste directly into the cell

Excel macro:

Open vaccinations.csv in Excel (if copying and pasting into Excel, you'll likely need to use [Data: Text to Columns] (set to comma delimited) to convert to table layout.
Run the following macro:

Sub OwidUpdate()
'
' Run OWID update routine
'

Range("A1").Select
Selection.AutoFilter
ActiveWorkbook.ActiveSheet.AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.ActiveSheet.AutoFilter.Sort.SortFields.Add2 Key:= _
Range("C1:C" & Range("A" & Rows.Count).End(xlUp).Row), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
 :=xlSortNormal
With ActiveWorkbook.ActiveSheet.AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
ActiveSheet.Range("A1:L" & Range("A" & Rows.Count).End(xlUp).Row).RemoveDuplicates Columns:=1, Header:= _
xlYes
ActiveWorkbook.ActiveSheet.AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.ActiveSheet.AutoFilter.Sort.SortFields.Add2 Key:= _
Range("D1:D" & Range("A" & Rows.Count).End(xlUp).Row), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
 :=xlSortNormal
With ActiveWorkbook.ActiveSheet.AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("M2").Select
ActiveCell.FormulaR1C1 = _
"=IF(RC[-12]=""World"",""|{{pad|0.1em}}[[File:Emojione 1F310.svg|23x15px|alt=|link=]]{{pad|0.4em}}World{{efn|name=world-total}}"",IF(OR(RC[-12]=""Northern Ireland"",RC[-12]=""Scotland"",RC[-12]=""Wales"",RC[-12]=""England"",RC[-12]=""Europe"",RC[-12]=""Africa"",RC[-12]=""Oceania"",RC[-12]=""North America"",RC[-12]=""South America"",RC[-12]=""Asia""),""|******REMOVE ROW******"",""|{{flag+link|COVID-19 pandemic in|""&RC[-12]&""}}""))&IF(ISBLANK(RC[-8]),""{{efn|name=incorrect-total}}||{{font color|darkred|" & _
"""&TEXT(RC[-9],""#,#"")&""}}||--"",""||""&TEXT(RC[-8],""#,#"")&""||""&TEXT(RC[-3]/100,""0.0%""))&""<tr>"""
Range("M2").Select
Selection.AutoFill Destination:=Range("M2:M" & Range("A" & Rows.Count).End(xlUp).Row)
' Remove bad rows
Dim rng As Range
Dim pos As Integer
Set rng = ActiveSheet.UsedRange
For i = rng.Cells.Count To 1 Step -1
pos = InStr(LCase(rng.Item(i).Value), LCase("remove"))
If pos > 0 Then
rng.Item(i).EntireRow.Delete
End If
Next i
' Select and copy range for Wikipedia
Range("M2:M" & Range("A" & Rows.Count).End(xlUp).Row).Select
Selection.Copy
End Sub

^ "Coronavirus (COVID-19) Vaccinations". Our World in Data. Sourced from individual health agencies.CS1 maint: postscript (link)
^ ^a ^b ^c "COVID Data Tracker". Centers for Disease Control and Prevention.
^ "Pope Francis and Benedict XVI receive second dose of COVID-19 vaccine". Catholic News Agency.
^ "Vatican defends pope's trip to Iraq, stadium mass for 10,000 people". Associated Press. 2 March 2021.

Usage[edit]

Deployment of COVID-19 vaccines
COVID-19 vaccine

The above documentation is transcluded from Template:COVID-19 vaccination data/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.

[1] Latest available data as of this date. Individual country reporting frequency varies.

[3] Number of unique individuals who have received at least one dose of a COVID-19 vaccine (unless noted otherwise).

[foreign-vacs-4] Includes those who are partially vaccinated with a single dose. May include vaccination of non-citizen workers, which can push totals beyond 100% of the local population.

[world-total-5] Some countries are not yet reporting first-dose counts. Total dose counts for these countries are not included in the World total.

[incorrect-total-6] ^ ^a ^b ^c ^d ^e ^f ^g ^h ⁱ ^j ^k ^l This country's data reflects total doses administered, not the first shot only.

[10] If OWID adds additional columns to the source data, paste the formula in the last empty column.

[use-formula-field-11] Do not attempt to paste directly into the cell

[2] "Coronavirus (COVID-19) Vaccinations". Our World in Data. Sourced from individual health agencies.CS1 maint: postscript (link)

[cdc-data-7] "COVID Data Tracker". Centers for Disease Control and Prevention.

[8] "Pope Francis and Benedict XVI receive second dose of COVID-19 vaccine". Catholic News Agency.

[9] "Vatican defends pope's trip to Iraq, stadium mass for 10,000 people". Associated Press. 2 March 2021.

[a]

[1]

[b]

[c]

[d]

[e]

[2]

[3]

[4]

[a]

[b]

Template:COVID-19 vaccination data

Semi-automated update instructions[edit]

Usage[edit]

Navigation menu

Search