ABCDEFGHIJ
1
Fertility rates Dataset - v15 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:v15
4
Updated:August 8,2024
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dtfr
7
Contributor(s) to this version: Hisham N
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1Babies per womanThis is the number of children that would be born to a woman if she were to live to the end of her childbearing years and bear children in accordance with age-specific fertility rates of the specified year. It expresses the statisctical indicator total fertility rate.Total fertility ratenumber of babies per womantfrmeasure2
12
13
Sources
14
Dataset description:This file contains data on total fertility rates compiled by Gapminder, based on multiple sources: — 1800 to 1950 (and in some cases also years after 1950): Gapminder v6 which were compiled and documented by Mattias Lindgren, based on multiple sources, (see documentation here https://www.gapminder.org/data/documentation/gd008/)
— 1950 to 2023: In most cases we use the latest UN estimates from World Population Prospects 2024 published in the file with Annually interpolated demographic indicators
— 2024 – 2100: We use the UN forecast of future fertility rate in all countries, called median fertility variant.
We combine the series by linking our historic estimates with the UN data by smoothly transitioning the curves over a period of 40 years (i.e 1930-1970) from whatever our historic sources had to the levels that UN is publishing.
The data is part of Gapminder effort to build a fact-based worldview by showing the big picture of global development. When we find multiple data sources that haven't been combined we combine them into one consistent timeseries. This often results in large data uncertainty, as the underlaying data-sources use different methodologies etc. But we still dare to combine data that hasn't been combined, as we find it extremely important to visualize the big picture, which people otherwise tend to get absolutely wrong. Before using our data for any other purpose though, please read the documentation to make sure you are aware of our levels of doubts in the data.
15
Link to documentation:http://gapm.io/dtfr
16
Short source summary:GM&UNPOP
17
18
#Source idNameLink
19
1wpp2024UN-population division, World Population Prospects 2024https://population.un.org/wpp/
20
2gm2010TFR's documentation by Gapminderhttps://www.gapminder.org/data/documentation/gd008/
21
22
License
23
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/dtfr
24
License link:Creative Common License CC BY 4.0
25
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.
26
27
VersionsLinkChanges compared to previousDateContributors
28
v1-First version--
29
v2----
30
v3----
31
v4----
32
v5----
33
v6-
see https://www.gapminder.org/data/documentation/gd008/
--
34
v7----
35
v8----
36
v9----
37
v10----
38
v11----
39
v12
https://docs.google.com/spreadsheets/d/1x4TVxqLda0flkhOkX2zMH7wnfO07Y2HE/edit#gid=1705269648
new data from UNPOP, WPP2017December 12,2017Ola Rosling
40
v13
https://docs.google.com/spreadsheets/d/1WmPvJQkd0OWjr9m8y-1Mz1hOQWTs0DSa1FV5HDGOiGM/edit#gid=501532268
new data from UNPOP, WPP2019
Ocotober 18,2019
Diane I
41
v14
https://docs.google.com/spreadsheets/d/1aLtIpAWvDGGa9k2XXEz6hZugWn0wCd5nmzaRPPjbYNA/edit#gid=501532268
new data from UNPOP, WPP20222024 January 20Hisham N
42
v15
https://docs.google.com/spreadsheets/d/1j6zkY_a1vX7RtIGKsC9V6AXyfUgtYZl52_SCezwESZM/edit?gid=501532268#gid=501532268
new data from UNPOP, WPP20242024 August 8Hisham N
43
44
Technical stuff
45
Dataset name:Fertility rates
46
Dataset id:tfr
47
Doc urlhttps://docs.google.com/spreadsheets/d/1j6zkY_a1vX7RtIGKsC9V6AXyfUgtYZl52_SCezwESZM/edit?gid=501532268#gid=501532268
48
Doc id of work doc spreadsheet1j6zkY_a1vX7RtIGKsC9V6AXyfUgtYZl52_SCezwESZM
49
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.
50
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.
51
Read more:gapm.io/dataworks
52
CHART PREVIEWS
53
[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=Babies%20per%20woman&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//1j6zkY_a1vX7RtIGKsC9V6AXyfUgtYZl52_SCezwESZM//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
54
Babies%20per%20woman
55
DDF mapping:schema for indicator table
56
concept_id6
57
name_short2
58
name4
59
description3
60
unit5
61
type7
62
usage8
63
64
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
65
Babies per womantfryearBAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><script nonce="VoZdpxMssS3cJ2JZ-ExElg">window['ppConfig'] = {productName: '26981ed0d57bbad37e728ff58134270c', ... (use muteHttpExceptions option to examine full response)BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><script nonce="o2544tOUs4naa3wHIWLQYg">window['ppConfig'] = {productName: '26981ed0d57bbad37e728ff58134270c', ... (use muteHttpExceptions option to examine full response)-BAD: Request failed for https://spreadsheets.google.com returned code 404. Truncated server response: <!DOCTYPE html><html lang="en"><head><script nonce="aeTR70Jip4ddpM-r7Km70Q">window['ppConfig'] = {productName: '26981ed0d57bbad37e728ff58134270c', ... (use muteHttpExceptions option to examine full response)
66
67
#Validation
68
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
69
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
70
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)
71
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
72
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)
73
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
74
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)
75
8
output-sheet:data-for-4ilevels-by-year
GOOD: The 'data-for-4ilevels-by-year' output sheet has at least 4 header columns
76
9
output-sheet:data-for-4ilevels-by-year
GOOD: The 'data-for-4ilevels-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
77
10versionGOOD: Named range 'version' exists
78
11versionGOOD: 'Version:' is filled in
79
12versionGOOD: The version at 'Version:' starts with a v, followed by an integer
80
13dateGOOD: Named range 'date' exists
81
14dateGOOD: 'Updated:' is filled in
82
15gapmioGOOD: Named range 'gapmio' exists
83
16gapmioGOOD: 'Latest version online:' is filled in
84
17contributorsGOOD: Named range 'contributors' exists
85
18contributorsGOOD: 'Contributor(s) to this version:' is filled in
86
19indicator_tableGOOD: Named range 'indicator_table' exists
87
20indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
88
21indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
89
22indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
90
23
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"
91
24
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"
92
25
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"
93
26
indicator_table:row_1:data-for-4ilevels-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-4ilevels-by-year' output sheet in column 4 as "=ABOUT!B11"
94
27indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
95
28indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)
96
29indicator_table:row_1GOOD: Indicator 1 has a unit (Column 5)
97
30indicator_table:row_1GOOD: Indicator 1's unit does not start or end with a space
98
31indicator_table:row_1GOOD: Indicator 1 has an ID (Column 6)
99
32indicator_table:row_1GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
100
33indicator_table:row_1GOOD: Indicator 1's ID has less than or equal to 20 characters