A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Population in Democracies Data-v2 | ||||||||||
2 | About this dataset | This 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 | Feedback | Please give feedback here | |||||||||
9 | |||||||||||
10 | # | Indicator(s) | Description | Full name | Unit | ID | Type | Usage | |||
11 | 1 | Share of people in democracy | The 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 democracies | Percent | share_pop_in_democracy | measure | 1 | |||
12 | 2 | Democracy population | The 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 democracies | Number of people | pop_in_democracy | measure | 1 | |||
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 id | Name | Link | |||||||
21 | 1 | OWID | Our World in Data, estimates of number of people in democracies | https://ourworldindata.org/democracy#share-of-world-population-living-in-democracies | |||||||
22 | 2 | GMPOP | Gapminder's population data | http://gapm.io/datapop | |||||||
23 | 3 | GMDI | Democracy Index Data | gapm.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 | Versions | Link | Changes compared to previous | Date | Contributors | ||||||
31 | v1 | - | Data prepeared for the book Factfulness in 2018, contained data only from the OWID, Polity IV data. | Nov 2017 | OlaRosling | ||||||
32 | v2 | https://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 2018 | Ola Rosling | ||||||
33 | v3 | ||||||||||
34 | v4 | ||||||||||
35 | |||||||||||
36 | Dataset name | Population in Democracies | |||||||||
37 | Dataset id | democrp | |||||||||
38 | The Google id of this spreadsheet | 1km9lsO1FxYBRMpG244HGevtLUSR9JLCTqRAYICyPZ8k | |||||||||
39 | Formulas | The 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 developers | If 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-year | bubble chart with countries etc | |||||||||
45 | |||||||||||
46 | DDF mapping: | schema for indicator table | |||||||||
47 | concept_id | 6 | |||||||||
48 | name_short | 2 | |||||||||
49 | name | 4 | |||||||||
50 | description | 3 | |||||||||
51 | unit | 5 | |||||||||
52 | type | 7 | |||||||||
53 | usage | 8 | |||||||||
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 |