ABCDEFGHIJK
1
Population in Democracies Data-v2
2
About this datasetThis 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:v2
4
Updated:October 18 2018
5
Download:Excel file »
6
Link to latest version:http://gapm.io/ddemocrp
7
Contributor(s) to this version: Ola Rosling
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDTypeUsage
11
1Share of people in democracyThe sum of populations in all countries categorized as Democracies according to the Polity IV criteria for, as a share of the total world population.Share of population living in democraciesPercentshare_pop_in_democracymeasure1
12
2Democracy populationThe sum of population of all countries categorized as democracies according to the Polity IV criteria for, as a share of total population.Number of people living in democraciesNumber of peoplepop_in_democracymeasure1
13
14
15
Sources
16
Summary:Determining what is democracy is not a clear cut. We use the definition from the Economist Intelligence Únit (EIU), of 60% or higher score on Democracy index, which includes their two categories "Full democracy" and "Flawed democracy". The data from 2006 and later comes from the EIU. Data before 2006 are based on the trend form World in Data, based mainly on POLITY-IV definition, which is a bit more generous and puts the share of people in democracy on 55% in 2015. To fit the definition of EIU, we multiplied the historic OWID numbers with a rate 0.895, to adjust the historic curve so that it hit the number of EIU in 2006. This is a quick way to calculate a curve that both conveys the long historic development while fitting the higher quality data of the more recent decades.
17
Link to documentation:http://gapm.io/ddemocrp
18
Short source summary:EIU & Gapminder
19
20
#Source idNameLink
21
1OWIDOur World in Data, estimates of number of people in democracies
https://ourworldindata.org/democracy#share-of-world-population-living-in-democracies
22
2GMPOPGapminder's population datahttp://gapm.io/datapop
23
3GMDIDemocracy Index Datagapm.io/ddemocrix
24
25
License
26
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 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/ddemocrp
27
License link:Creative Common License CC BY 4.0
28
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.
29
30
VersionsLink
Changes compared to previous
DateContributors
31
v1-
Data prepeared for the book Factfulness in 2018, contained data only from the OWID, Polity IV data.
Nov 2017OlaRosling
32
v2https://docs.google.com/spreadsheets/d/1Q6ns1Otbu6uzJO2kJdaraXWPG5FsR-49IEJQfk8B5a8
Use the Economist's Democracy Index as a criteria for democracy (index > 60%), which made the total number of people in democracies, 5% lower compared to version 1. By adjusting the OWID curve to hit the EIU curve in the overlapping year 2006, we get a long historic curve that includes better data for the last 10 years, better illustrating the decline of democracy in many countries.
Nov 2018Ola Rosling
33
v3
34
v4
35
36
Dataset namePopulation in Democracies
37
Dataset iddemocrp
38
The Google id of this spreadsheet1km9lsO1FxYBRMpG244HGevtLUSR9JLCTqRAYICyPZ8k
39
FormulasThe formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. If a spreadsheet is broken in the tree of formulas, we avoid other formulas to get broken, by always linking to the output data sheets, which are manually copied and pasted form the formula outputs in the sheets to the right of DATA_PREP sheet.
40
For developersIf you like to integrate Gapmidner's data into your product, it's better if you integrate
These spreadsheets are part of Gapminder's data production and publishing, but there's more to it. Please follow this link to get the bigger picture of our data processes.
41
Read more:gapm.io/dataworks
42
43
CHART PREVIEWS
44
data-for-countries-etc-by-yearbubble chart with countries etc
45
46
DDF mapping:schema for indicator table
47
concept_id6
48
name_short2
49
name4
50
description3
51
unit5
52
type7
53
usage8
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100