ABCDEFGHIJ
1
Internet - Dataset - v5 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:v5
4
Updated:January 18 2021
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dnet
7
Contributor(s) to this version: Jean U.
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1Internet users (%)The proportion of people who used internet (from any location) in the last 3 months, calculated as a percentage of the total population.Percentage of the people using internetpercentnet_users_prcmeasure2
12
2Internet usersTotal number of people who used internet (from any location) in the last 3 months. This is calculated by multiplying the share of internet users with population.Number of people using internetpeoplenet_users_nummeasure2
13
3Non-internet usersThe proportion of people who did not use internet in the last 3 months from any location, calculated as a percentage of the total populationPercentage of people not using internetpercentnon_net_users_prcmeasure2
14
4Non Internet usersTotal number of people who did not use internet in the last 3 months. It is obtained by substructing people who used internet from the total population.Number of people not using internetpeoplenon_net_users_nummeasure2
15
16
Sources
17
Dataset description:ICT Data are published by International Telecommunication Union. ITU collects,verifies and harmonizes telecommunication/ICT statistics for about 200 economies worldwide. Telecommunication/ICT data are mainly collected from national telecommunication/ICT ministries, regulatory authorities and national statistical offices.In this spreadsheet we have imported data on one ICT's indicator, "percentage of the population using the internet" and presented data for countries and territories for the period 1990-2019 in Gapminder's standard format to allow visualization in our tools. We have also compiled the global share of people using internet and extended the trend earlier in the past based on data of share of the population using the internet which was published by ITU. The global trends of internet users starts from 1980 where Gapminder estimated that nobody was using the Internet in 1980, as it was invented the year after, in terms of a shared protocol ( see: https://web.archive.org/web/20120518101749/http://www.isc.org/solutions/survey/history) . In addition, we have estimated the number of people using internet based on data of share of the people using the internet with countries' population data (gm-population V6 which is based on population data from WPP 2019). We computered data for regions using ITU data and global data share of the people using and not using the internet by combining the data reported by World Bank and ITU in a single dataset.
18
Link to documentation:http://gapm.io/dnet
19
Short source summary:gm_ based on ITU
20
21
#Source idNameLink
22
1itu,20International Telecommunication Union, 2020https://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx
23
2wdi,20World Development Indicators,2020https://data.worldbank.org/indicator/IT.NET.USER.ZS
24
3gm,20Gapminder-population v6https://docs.google.com/spreadsheets/d/1pxdiX93KuGUBVf1Oc4o0VME7T8uHst1jMErQupEXF3g/edit#gid=501532268
25
26
License
27
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/dnet
28
License link:Creative Common License CC BY 4.0
29
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.
30
31
VersionsLink
Changes compared to previous
DateContributors
32
v1-used in factfullness book#REF!#REF!
33
v2
https://docs.google.com/spreadsheets/d/1Iz7kTSyBee7oFq-YL9PqLXyMJRBC5bbm4GqeUdWQi4o/edit#gid=501532268
with new data for 20172019 July 15Diane I
34
v3
https://docs.google.com/spreadsheets/d/1M4VIprlZ0Af22Mcpp-cIxaFgEj7egseZuxnanv2hLlc/edit#gid=501532268
with new data for 20182020 February 20Claudia S
35
v4
https://docs.google.com/spreadsheets/d/1Nz22YwEMuIj7ffy08r5JHJevhkPAfH7SObfhDZbPEbA/edit#gid=501532268
with new data from 1990-2005 and 20192021 January 11Jean U.
36
v5https://docs.google.com/spreadsheets/d/14HINefWNOFkh4TNz-ZmBwb1K6w2Lg9z0P9rDJlJiQ8s/edit#gid=501532268includes non internet users2021 January 18Jean U.
37
38
Technical stuff
39
Dataset name:Internet
40
Dataset id:net
41
Doc urlhttps://docs.google.com/spreadsheets/d/1Jf_dfedlbAOYJH5_zCaRyGUVWVv8wekTuwT3fRYq1KE/edit?ouid=114605220718412447890&urlBuilderDomain=gapminder.org
42
Doc id of work doc spreadsheet1Jf_dfedlbAOYJH5_zCaRyGUVWVv8wekTuwT3fRYq1KE
43
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.
44
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.
45
Read more:gapm.io/dataworks
46
CHART PREVIEWS
47
[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=Non-internet%20users&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//1Jf_dfedlbAOYJH5_zCaRyGUVWVv8wekTuwT3fRYq1KE//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
48
Non-internet%20users
49
DDF mapping:schema for indicator table
50
concept_id6
51
name_short2
52
name4
53
description3
54
unit5
55
type7
56
usage8
57
58
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
59
Percentage of the people using internet
net_users_prcyearBAD: Request failed for https://spreadsheets.google.com returned code 429. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)BAD: Request failed for https://spreadsheets.google.com returned code 429. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)-BAD: Request failed for https://spreadsheets.google.com returned code 429. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)
60
Number of people using internet
net_users_numyearBAD: Request failed for https://spreadsheets.google.com returned code 429. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)BAD: Request failed for https://spreadsheets.google.com returned code 429. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)-BAD: Request failed for https://spreadsheets.google.com returned code 429. Truncated server response: <!DOCTYPE html><html lang="en"><head><meta name="description" content="Web word processing, presentations and spreadsheets"><meta name="viewport" c... (use muteHttpExceptions option to examine full response)
61
62
#Validation
63
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
64
2
output-sheet:data-for-world-by-year
GOOD: The 'data-for-world-by-year' output sheet has at least 4 header columns
65
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)
66
4
output-sheet:data-for-regions-by-year
GOOD: The 'data-for-regions-by-year' output sheet has at least 4 header columns
67
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)
68
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
69
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)
70
8versionGOOD: Named range 'version' exists
71
9versionGOOD: 'Version:' is filled in
72
10versionGOOD: The version at 'Version:' starts with a v, followed by an integer
73
11dateGOOD: Named range 'date' exists
74
12dateGOOD: 'Updated:' is filled in
75
13gapmioGOOD: Named range 'gapmio' exists
76
14gapmioGOOD: 'Latest version online:' is filled in
77
15contributorsGOOD: Named range 'contributors' exists
78
16contributorsGOOD: 'Contributor(s) to this version:' is filled in
79
17indicator_tableGOOD: Named range 'indicator_table' exists
80
18indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
81
19indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
82
20indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
83
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"
84
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"
85
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"
86
24indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
87
25indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)
88
26indicator_table:row_1GOOD: Indicator 1 has a unit (Column 5)
89
27indicator_table:row_1GOOD: Indicator 1's unit does not start or end with a space
90
28indicator_table:row_1GOOD: Indicator 1 has an ID (Column 6)
91
29indicator_table:row_1GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
92
30indicator_table:row_1GOOD: Indicator 1's ID has less than or equal to 20 characters
93
31indicator_table:row_1GOOD: Indicator 1 has a type set (Column 7)
94
32indicator_table:row_1GOOD: Indicator 1 has a usage level set (Column 8)
95
33indicator_table:row_2GOOD: This first column of row '2' in the indicator(s) table is incremental (from 1 and up)
96
34indicator_table:row_2GOOD: Indicator 2 has a short indicator name (Column 2)
97
35
indicator_table:row_2:data-for-world-by-year
GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-world-by-year' output sheet in column 5 as "=ABOUT!B12"
98
36
indicator_table:row_2:data-for-regions-by-year
GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-regions-by-year' output sheet in column 5 as "=ABOUT!B12"
99
37
indicator_table:row_2:data-for-countries-etc-by-year
GOOD: The indicator name cell of indicator 2 is referenced in the 'data-for-countries-etc-by-year' output sheet in column 5 as "=ABOUT!B12"
100
38indicator_table:row_2GOOD: Indicator 2 has a description (Column 3)