ABCDEFGHIJ
1
Vaccinations for one-year-olds Dataset - v4 via Gapminder
2
About this fileThis file has multiple sheets with data for one or more indicators used by Gapminder. In this sheet below you'll first find an overview of the indicators (measures) and the list of underlying sources. The actual data we use, is found in the sheet(s) labeled "data-...".
This file is also a documentation of the data process. To follow how the data was transformed from the original sources, start in the sheet to the far right, which holds the input data. You can then follow the process step by step, by looking at the formulas in the sheets from right to left, until you reach the output in the "data-..." sheets.
3
Version:v4
4
Updated:August 18 2021
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dvacc_for_1yr
7
Contributor(s) to this version: Jean U
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1BCG immunizedThe percentage of one-year-olds who have received one dose of bacille Calmette-Guérin (BCG) vaccine in a given year.Bacille Calmette-Guérin (BCG) immunizarion coverage among 1-year-olds (%)percentbcg_vaccmeasure2
12
2DTP3 immunizedThe percentage of one-year-olds who have received three doses of the combined diphtheria, tetanus toxoid and pertussis vaccine in a given year.Diphtheria tetanus toxoid and pertussis (DTP3) immunization coverage among 1-year-olds (%)percentdtp3_vaccmeasure2
13
3HepB3 immunizedThe percentage of one-year-olds who have received three doses of hepatitis B vaccine in a given year.Hepatitis B (HepB3) immunization coverage among 1-year-olds (%)percenthepb3_vaccmeasure2
14
4HIB3 immunizedThe percentage of one-year-olds who have received three doses of Haemophilus influenzae type B vaccine in a given year.Haemophilus influenzae type B (HIB3) immunization coverage among 1-year-olds (%).percenthib3_vaccmeasure2
15
5
Measles 1st dose immunized
The percentage of children under one year of age who have received at least one dose of measles-containing vaccine in a given year. For countries recommending the first dose of measles vaccine in children over 12 months of age, the indicator is calculated as the proportion of children less than 12-23 months of age receiving one dose of measles-containing vaccine.Measles-containing-vaccine first-dose (MCV1) immunization coverage among 1-year-olds (%)percentmcv1_vaccmeasure2
16
6
Measles 2nd dose immunized
The percentage of children who have received two doses of measles containing vaccine (MCV2) in a given year, according to the nationally recommended schedule.Measles-containing-vaccine second-dose (MCV1) immunization coverage among 1-year-olds (%)percentmcv2_vaccmeasure2
17
7PCV3 immunizedThe percentage of one-year-olds who have received three doses of Pneumococcal conjugate (PCV3) vaccine in a given year.Pneumoccocal Conjugate vaccines (PCV3) immunization coverage among 1-year-olds (%)percentpcv3_vaccmeasure2
18
8Pol3 immunizedThe percentage of one-year-olds who have received three doses of polio vaccine in a given year.Polio (Pol3) immunization coverage among 1-year-olds (%)percentpol3_vaccmeasure2
19
9RotaC immunizedThe percentage of surviving infants who received the final recommended dose of rotavirus vaccine, which can be either the 2nd or the 3rd dose depending on the vaccine in a given year.Rotavirus vaccines completed dose (RotaC) immunization coverage among 1-year-olds (%)percentrotac_vaccmeasure2
20
10
Some vaccination rate
The share of one-year-olds who have received at least one of the following vaccinations: BCG, DTP3, HepB3, HIB3, Measles 1st,Measles 2nd, PCV3, Pol3 or RotaC. This shows the number for the vaccine with the highest coverage.Share of one-year-olds who are vaccinated against at least one disease.percentvacc_ratemeasure1
21
11
Lowest vaccination rate among six basic vaccines
The share of one-year-olds who have recieved all these six vaccinations BCG, DTP3, HepB3, HIB3, Measles 1st dose and Pol3. This shows the number for the vaccine with the lowest coverage.Share of one-year-olds who are vaccinated against this six: Bacille Calmette-Guérin (BCG), Diphtheria tetanus toxoid and pertussis (DTP3) , Hepatitis B (HepB3), Haemophilus influenza type B (HIB3) , Measles 1st dose (MCV1) and Polio (Pol3)percentsix_vacc_ratemeasure1
22
23
Sources
24
Dataset description:The data comes from Global Health Observatory data repository of World Health Organisation (WHO). WHO/UNICEF estimated Immunization coverage amoung 1 years old child based mainly on data from administrative records, household surveys, such as the Expanded Programme on Immunization (EPI) 30-cluster survey, the UNICEF Multiple Indicator Cluster Survey (MICS), and the Demographic and Health Survey (DHS). The surveys assesses the immunization coverage among 12-23 months children who received a vaccination anytime before the survey; by dividing the total number of vaccinations given by the number of children in the target population, often based on census projections.
In this spreadsheet , we compiled the estimates on the percentage of 1 years olds children who received nine different vaccinations: three doses of Haemophilus influenzae type B vaccine, three doses of the combined diphtheria, tetanus toxoid and pertussis vaccine,one dose of bacille Calmette-Guérin (BCG) vaccin,three doses of hepatitis B vaccine, 1st dose of measles (MCV1),2nd dose of measles,pneumococcal conjugate,poliomyelitis and rotavirus vaccines completed dose, for the period 2000-2020 for countries and territories and average global immunization coverage. Global coverage is a weighted sum of WHO/UNICEF estimates of national coverage by target population ( which is the the national annual number of infants surviving their first year of life) from the United Nations Population Division's World Population Prospects. Gapminder has extended series from 1980-2020 to show long term changes in vaccination trend and data is presented for the world and countries/territories.
25
Link to documentation:http://gapm.io/dvacc_for_1yr
26
Short source summary:WHO
27
28
#Source idNameLink
29
1WHO2021World Health Organisation (WHO),Global Health Observatory data repository
http://apps.who.int/gho/data/node.main.A830?lang=en
30
31
License
32
Attribution:
We believe in free knowledge and therefor we share free data. Most sheets in this file are provided under the open license, called Creative Commmon Attribution License CC BY 4.0., except those sheets mentioned in the exceptions section below. This means you can freely use, copy, and spread the data in those sheets, as long as you mention the following: 'Free data from Gapminder.org'.
You should also mention the underlaying data sources listed above and include this link: http://gapm.io/dvacc_for_1yr
33
License link:Creative Common License CC BY 4.0
34
Exceptions:
The sheets starting with the word "data" are covered by this license. Other sheets are included for documentation purpose, and may include data that is governed by other licenses. Check the underlying sources for the specific licenses in these cases.
35
36
VersionsLinkChanges compared to previousDateContributors
37
v1https://docs.google.com/spreadsheets/d/1sk6K94iC4Y8wrA7DfaMytLFoxZVWU-rVviUwwTdzBF0/edit#gid=119027199First version2019 May 17Claudia Sanchez
38
v2https://docs.google.com/spreadsheets/d/124-vdbkRjkXgu0WS-97tT-CEl3UYu21p-MlZCRVe0H8/edit#gid=569008164new series for 20182019 October 15Claudia S
39
v3https://docs.google.com/spreadsheets/d/1YxVSb84P0BwMQqq6_BjsQPjHyIFZDdXh1muIW7AUnJk/edit#gid=501532268new data for 20192020 November 11Claudia S
40
v4https://docs.google.com/spreadsheets/d/1xJabmMIHGnA_y91L_1rnLIT3UeWup3zVJ2ep-oDlgoY/edit#gid=501532268new data for 20202021 August 18Jean U
41
42
Technical stuff
43
Dataset name:Vaccinations for one-year-olds
44
Dataset id:vacc_for_1yr
45
Doc urlhttps://docs.google.com/spreadsheets/d/17TZgHPJrV5I09CSJYxsps8fKMK2XB2it2YWpXYMmRiE/edit#gid=501532268
46
Doc id of work doc spreadsheet17TZgHPJrV5I09CSJYxsps8fKMK2XB2it2YWpXYMmRiE
47
FormulasThe formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. Search for "named ranges" to see how to use those instead of cell ranges.
48
For developersIf you like the data we use into your own products, it's better if you fetch data from our standardized gitHub repo on https://open-numbers.github.io
These spreadsheets are part of Gapminder's data compilation process and allow end users to track how we combine data.
49
Read more:gapm.io/dataworks
50
CHART PREVIEWS
51
[c]
data-for-countries-etc-by-year
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=income_per_person_gdppercapita_ppp_inflation_adjusted&scaleType=log&spaceRef:null;&axis_y$data=data_&which=BCG%20immunized&spaceRef:null;&label$which=name&scaleType=ordinal;&size$which=population_total&use=indicator&scaleType=linear;&color$which=_default&use=constant&scaleType=ordinal;;;&data$reader=ddfbw&service=https:////big-waffle.gapminder.org&dataset=sg-master&translateContributionLink:///crowdin.com//project//systema-globalis;&data_$reader=google_csv&path=https:////docs.google.com//spreadsheets//d//17TZgHPJrV5I09CSJYxsps8fKMK2XB2it2YWpXYMmRiE//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
52
BCG%20immunized
53
DDF mapping:schema for indicator table
54
concept_id6
55
name_short2
56
name4
57
description3
58
unit5
59
type7
60
usage8
61
62
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
63
BCG immunizedbcg_vaccyear#NAME?--#NAME?
64
DTP3 immunizeddtp3_vaccyear#NAME?--#NAME?
65
HepB3 immunizedhepb3_vaccyear#NAME?--#NAME?
66
HIB3 immunizedhib3_vaccyear#NAME?--#NAME?
67
Measles 1st dose immunized
mcv1_vaccyear#NAME?--#NAME?
68
Measles 2nd dose immunized
mcv2_vaccyear#NAME?--#NAME?
69
PCV3 immunizedpcv3_vaccyear#NAME?--#NAME?
70
Pol3 immunizedpol3_vaccyear#NAME?--#NAME?
71
RotaC immunizedrotac_vaccyear#NAME?--#NAME?
72
Some vaccination ratevacc_rateyear#NAME?--#NAME?
73
Lowest vaccination rate among six basic vaccines
six_vacc_rateyear#NAME?--#NAME?
74
75
#Validation
76
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
77
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
78
3
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
79
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
80
5
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
81
6
output-sheet:data-for-countries-etc-by-year
GOOD: The 'data-for-countries-etc-by-year' output sheet has at least 4 header columns
82
7
output-sheet:data-for-countries-etc-by-year
GOOD: The 'data-for-countries-etc-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
83
8versionGOOD: Named range 'version' exists
84
9versionGOOD: 'Version:' is filled in
85
10versionGOOD: The version at 'Version:' starts with a v, followed by an integer
86
11dateGOOD: Named range 'date' exists
87
12dateGOOD: 'Updated:' is filled in
88
13gapmioGOOD: Named range 'gapmio' exists
89
14gapmioGOOD: 'Latest version online:' is filled in
90
15contributorsGOOD: Named range 'contributors' exists
91
16contributorsGOOD: 'Contributor(s) to this version:' is filled in
92
17indicator_tableGOOD: Named range 'indicator_table' exists
93
18indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
94
19indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
95
20indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
96
21
indicator_table:row_1:data-for-world-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-world-by-year' output sheet in column 4 as "=ABOUT!B11"
97
22
indicator_table:row_1:data-for-regions-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-regions-by-year' output sheet in column 4 as "=ABOUT!B11"
98
23
indicator_table:row_1:data-for-countries-etc-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-countries-etc-by-year' output sheet in column 4 as "=ABOUT!B11"
99
24indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
100
25indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)