World Telecommunication Indicators Database, ITU - Revision history

Norah.Shamin at 18:33, 10 September 2025

2025-09-10T18:33:56Z

← Older revision		Revision as of 18:33, 10 September 2025
Line 1:		Line 1:
			'''''<u>This database has been discontinued! Go to [[International Telecommunication Union DataHub]] for the new database.</u>'''''

			= Summary =
	'''International Telecommunications Union (ITU): World Telecommunication Indicators Database (12<sup>th</sup> edition 2008)'''		'''International Telecommunications Union (ITU): World Telecommunication Indicators Database (12<sup>th</sup> edition 2008)'''

Yutang.Xiong: Yutang.Xiong moved page International Telecommunications Union (ITU) to World Telecommunication Indicators Database, ITU without leaving a redirect: new name

2025-02-12T21:19:19Z

Yutang.Xiong moved page International Telecommunications Union (ITU) to World Telecommunication Indicators Database, ITU without leaving a redirect: new name

← Older revision	Revision as of 21:19, 12 February 2025
(No difference)

Norah.Shamin at 17:19, 15 October 2024

2024-10-15T17:19:57Z

← Older revision		Revision as of 17:19, 15 October 2024
Line 10:		Line 10:
	As of right now, SeriesHouseholds and SeriesICTCYBICTDevelopmentIndexITU are not available on this new platform.		As of right now, SeriesHouseholds and SeriesICTCYBICTDevelopmentIndexITU are not available on this new platform.

	For ICTCYBICTDevelopmentIndexITU, the ICT Development Index (IDI) was discontinued in 2018, owing to issues of data availability and quality.		For ICTCYBICTDevelopmentIndexITU, the ICT Development Index (IDI) was discontinued in 2018, owing to issues of data availability and quality. However, there is a new ICT Development Index with the data for 2023 and 2024 available at https://www.itu.int/itu-d/reports/statistics/idi2024/ You can download it where it says "Download the IDI 2024 dataset (Excel)"

	= Series pulled from ITU =		= Series pulled from ITU =

Kexin.Shang: /* Series pulled from ITU */

2024-09-26T17:32:05Z

Series pulled from ITU

← Older revision		Revision as of 17:32, 26 September 2024
Line 5:		Line 5:
	There are a total of 105 series with that begin with ICT; the majority of the series come from ITU (104), and World Bank (1). The series were updated in the first quarter of 2015 or earlier and need updating. I have attached an ITU.xlsx file.		There are a total of 105 series with that begin with ICT; the majority of the series come from ITU (104), and World Bank (1). The series were updated in the first quarter of 2015 or earlier and need updating. I have attached an ITU.xlsx file.

			= Update Notes for Sept. 2024 =
			The World Telecommunication/ICT Indicators Database was discontinued in 2024. All the data is now available free of charge on [https://datahub.itu.int/ ITU DataHub]. We only updated 6 out of 8 preprocessors.

	~~The The World Telecommunication/ICT Indicators Database was discontinued in 2024. All the data is now available free of charge on [https://datahub.itu.int/ ITU DataHub].~~ As of right now, ~~<font style="font-size: 11pt;" face="calibri" color="#000000">~~SeriesHouseholds and SeriesICTCYBICTDevelopmentIndexITU are not available on this new platform. For ICTCYBICTDevelopmentIndexITU, the ICT Development Index (IDI) was discontinued in 2018, owing to issues of data availability and quality.~~</font>~~		As of right now, SeriesHouseholds and SeriesICTCYBICTDevelopmentIndexITU are not available on this new platform.

			For ICTCYBICTDevelopmentIndexITU, the ICT Development Index (IDI) was discontinued in 2018, owing to issues of data availability and quality.

	= Series pulled from ITU =		= Series pulled from ITU =
Line 563:		Line 567:
	= Instructions on pulling ITU data =		= Instructions on pulling ITU data =

	'''Step 1:''' Go to https://datahub.itu.int/~~indicators~~/ ~~and choose~~ the indicators that you need.		'''Step 1:''' Go to https://datahub.itu.int/query/

			A. Choose the indicators that you need based on the "Name in Source" for each series below.
			[[File:Image itu datadict.png\|none\|thumb\|500x500px]]
			B. Select all countries.

			C. Select years from 1990 to most recent year.

	'''Step 2:''' Download the data by clicking download all indicators (csv).		'''Step 2:''' Download the data by clicking download all indicators (csv).
			[[File:Image itu download.png\|none\|thumb\|517x517px]]

	'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the ITU country concordance. Also sort data by seriesID and seriesCode to ensure the right data. In the DataDict the Source in Code goes like seriesID_seriesCode.		'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the ITU country concordance. Also sort data by seriesID and seriesCode to ensure the right data. In the DataDict the Source in Code goes like seriesID_seriesCode.

Norah.Shamin at 21:45, 25 September 2024

2024-09-25T21:45:29Z

← Older revision		Revision as of 21:45, 25 September 2024
Line 3:		Line 3:
	The World Telecommunication Indicators Database is one of the various data sources that have been used in IFs system for analyzing the size of the Information Communications Technology (ICT) sector in economies. The World Telecommunication Indicators Database, launched by ITU, contains time series data for the years 1960, 1965, 1970 and annually from 1975-2007 for around 80 sets of telecommunication statistics and is categorized into telephone network size and dimension, mobile services, quality of service, traffic, staff, tariffs, revenue and investment. Selected demographic, macroeconomic, broadcasting and information technology statistics are also included. The database encompasses data for over 200 economies.  It can be purchased either in CD-ROM or in printed version. The ITU database is updated and revised approximately every three months. Detailed information about World Telecommunication Indicators is available at [http://www.itu.int/ITU-D/ict/publications/world/world.html http://www.itu.int/ITU-D/ict/publications/world/world.html]		The World Telecommunication Indicators Database is one of the various data sources that have been used in IFs system for analyzing the size of the Information Communications Technology (ICT) sector in economies. The World Telecommunication Indicators Database, launched by ITU, contains time series data for the years 1960, 1965, 1970 and annually from 1975-2007 for around 80 sets of telecommunication statistics and is categorized into telephone network size and dimension, mobile services, quality of service, traffic, staff, tariffs, revenue and investment. Selected demographic, macroeconomic, broadcasting and information technology statistics are also included. The database encompasses data for over 200 economies.  It can be purchased either in CD-ROM or in printed version. The ITU database is updated and revised approximately every three months. Detailed information about World Telecommunication Indicators is available at [http://www.itu.int/ITU-D/ict/publications/world/world.html http://www.itu.int/ITU-D/ict/publications/world/world.html]

			There are a total of 105 series with that begin with ICT; the majority of the series come from ITU (104), and World Bank (1). The series were updated in the first quarter of 2015 or earlier and need updating. I have attached an ITU.xlsx file.


	~~There are a total of 105 series with that begin with~~ ICT; the ~~majority~~ of ~~the series come from~~ ITU ~~(104)~~, and ~~World Bank~~ (1)~~. The series were updated~~ in ~~the first quarter~~ of ~~2015 or earlier~~ and ~~need updating. I have attached an ITU.xlsx file~~.		The The World Telecommunication/ICT Indicators Database was discontinued in 2024. All the data is now available free of charge on [https://datahub.itu.int/ ITU DataHub]. As of right now, <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesHouseholds and SeriesICTCYBICTDevelopmentIndexITU are not available on this new platform. For ICTCYBICTDevelopmentIndexITU, the ICT Development Index (IDI) was discontinued in 2018, owing to issues of data availability and quality.</font>

	= Series pulled from ITU =		= Series pulled from ITU =
Line 562:		Line 563:
	= Instructions on pulling ITU data =		= Instructions on pulling ITU data =

	~~The following series were updated up to 2014:~~		'''Step 1:''' Go to https://datahub.itu.int/indicators/ and choose the indicators that you need.

	~~ICTTelephoneLinesPer100 <br/>ICTTelephoneCellSubscribersPer100 <br/>ICTBroadbandSubscribersPer100ITU ~~

	'''Step 1:''' Go to~~ [http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http~~://~~www~~.itu.int/~~en/ITU-D/Statistics/Pages/stat~~/~~default.aspx] ~~and ~~find five links under~~ the "aggregate data " header titled "Time Series By Country(2015)".  Three links were relevant for the pre-processor update(fixed-telephone subscriptions, mobile-cellular subscriptions, and fixed broadband subscriptions).

	'''Step 2:''' ~~Click on~~ the ~~three links and~~ download ~~the fixed-telephone subscriptions, mobile-cellular subscriptions, and fixed broadband subscriptions excel data sheets~~.		'''Step 2:''' Download the data by clicking download all indicators (csv).

	'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the ITU country concordance.		'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the ITU country concordance. Also sort data by seriesID and seriesCode to ensure the right data. In the DataDict the Source in Code goes like seriesID_seriesCode.

	== '''Issues to note''' ==		== '''Issues to note''' ==

JoelMaweni at 22:11, 3 August 2016

2016-08-03T22:11:33Z

← Older revision		Revision as of 22:11, 3 August 2016
Line 566:		Line 566:
	ICTTelephoneLinesPer100 <br/>ICTTelephoneCellSubscribersPer100 <br/>ICTBroadbandSubscribersPer100ITU		ICTTelephoneLinesPer100 <br/>ICTTelephoneCellSubscribersPer100 <br/>ICTBroadbandSubscribersPer100ITU

	'''Step 1:''' Go to [http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx] and ~~click on the link~~ under the "aggregate data " header titled "Time Series By Country(2015)". ~~There are 5 excel sheets under this heading and only 3~~ were relevant for the pre-processor update.		'''Step 1:''' Go to [http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx] and find five links under the "aggregate data " header titled "Time Series By Country(2015)".  Three links were relevant for the pre-processor update(fixed-telephone subscriptions, mobile-cellular subscriptions, and fixed broadband subscriptions).

	'''Step 2:''' ~~Download~~ the fixed-telephone subscriptions, mobile-cellular subscriptions, and ~~Fixed~~ broadband subscriptions data sheets.		'''Step 2:''' Click on the three links and download the fixed-telephone subscriptions, mobile-cellular subscriptions, and fixed broadband subscriptions excel data sheets.

	'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the ~~appropriate~~ country concordance.		'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the ITU country concordance.

	== '''Issues to note''' ==		== '''Issues to note''' ==

JoelMaweni at 22:04, 3 August 2016

2016-08-03T22:04:38Z

← Older revision		Revision as of 22:04, 3 August 2016
Line 5:		Line 5:


	There is a total of 105 series with that begin with ICT; the majority of the series come from ITU (104), and World Bank (1). The series were updated in the first quarter of 2015 or earlier and need updating. I have attached an ITU.xlsx file.		There are a total of 105 series with that begin with ICT; the majority of the series come from ITU (104), and World Bank (1). The series were updated in the first quarter of 2015 or earlier and need updating. I have attached an ITU.xlsx file.

	= Series pulled from ITU =		= Series pulled from ITU =
Line 562:		Line 562:
	= Instructions on pulling ITU data =		= Instructions on pulling ITU data =

	~~A data set with a similar extended source definition~~ to ~~ICTCYBICTDevelopmentSubIndexUseITU (percentage of internet users) had highly divergent data points and I left it out in the importation. ~~		The following series were updated up to 2014:

	~~The following Series were updated by an additional year up to 2014~~		ICTTelephoneLinesPer100 <br/>ICTTelephoneCellSubscribersPer100 <br/>ICTBroadbandSubscribersPer100ITU

	~~ICTTelephoneLinesPer100~~ ~~<br/>ICTTelephoneCellSubscribersPer100~~ ~~<br~~/~~>ICTBroadbandSubscribersPer100ITU~~ ~~'''<br/>'''~~		'''Step 1:''' Go to [http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx] and click on the link under the "aggregate data " header titled "Time Series By Country(2015)". There are 5 excel sheets under this heading and only 3 were relevant for the pre-processor update.

	'''Step 1:''' ~~searching for data from ITU,~~ the ~~three series were listed as new at [http://www.itu.int/en/ITU~~-~~D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU~~-~~D/Statistics/Pages/stat/default~~.~~aspx]~~		'''Step 2:''' Download the fixed-telephone subscriptions, mobile-cellular subscriptions, and Fixed broadband subscriptions data sheets.

	'''Step 2:''' ~~Simple statistical actions were conducted including V-Look up (optional) for~~ the ~~country concordance. No updates were made to~~ the country concordance.		'''Step 3:''' Sort the data into a format that can be imported into IFs by adding the appropriate country concordance.

	~~'''Step 3:''' Excel operation to add an additional year(2014) through the addition of new and adjusted data from 2000-2014 for all three series~~.

	== '''Issues to note''' ==		== '''Issues to note''' ==
Line 578:		Line 576:
	Kosovo and Korea, Democratic Republic are not covered in the ICTBroadbandSubscribersPer100ITU series.		Kosovo and Korea, Democratic Republic are not covered in the ICTBroadbandSubscribersPer100ITU series.

	Kosovo is not covered in the ~~other two~~ series.		Kosovo is not covered in the three series.

	Inconsistency: there have been variations in the appearance of zeros and nulls for SeriesICTBroadbandSubscribersPer100ITU for previous updates. The current update removes the zeros from 2000-2014 which had appeared in the previous update. this is in accordance with the new dataset which has nulls.





			Inconsistency: There have been variations in the appearance of zeros and nulls for SeriesICTBroadbandSubscribersPer100ITU. The current dataset has nulls, leading to the removal of zeros in the current update for SeriesICTBroadbandSubscribersPer100ITU.

Wikiadmin at 20:38, 2 August 2016

2016-08-02T20:38:38Z

@@ Line 562: / Line 562: @@
 = Instructions on pulling ITU data =
-The following series are used in the pre-processor. I managed to get data for 3 series which was the assigned task. The dates listed are the dates of the last update. The site has more data which seems to require purchasing in order to conduct a batch pull.
+A data set with a similar extended source definition to ICTCYBICTDevelopmentSubIndexUseITU (percentage of internet users) had highly divergent data points and I left it out in the importation.&nbsp;
 The following Series were updated by an additional year up to 2014
-ICTTelephoneLinesPer100&nbsp;<br/>ICTTelephoneCellSubscribersPer100&nbsp;<br/>ICTBroadbandSubscribersPer100ITU&nbsp;
+ICTTelephoneLinesPer100&nbsp;<br/>ICTTelephoneCellSubscribersPer100&nbsp;<br/>ICTBroadbandSubscribersPer100ITU&nbsp;'''<br/>'''
-Step 1&nbsp;: searching for data from ITU, the three series were listed as new at [http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx]
+'''Step 1:''' searching for data from ITU, the three series were listed as new at [http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx]
-Step 2: Simple statistical actions were conducted including V-Look up (optional) for the country concordance. No updates were made to the country concordance.
+'''Step 2:''' Simple statistical actions were conducted including V-Look up (optional) for the country concordance. No updates were made to the country concordance.
-Step 3: Excel operation to add an additional year(2014) through the addition of new and adjusted data from 2000-2014 for all three series.
+'''Step 3:''' Excel operation to add an additional year(2014) through the addition of new and adjusted data from 2000-2014 for all three series.
-'''Issues to note'''
+== '''Issues to note''' ==
 Kosovo and Korea, Democratic Republic are not covered in the&nbsp;ICTBroadbandSubscribersPer100ITU series.&nbsp;

Wikiadmin at 20:21, 2 August 2016

2016-08-02T20:21:16Z

Show changes

Wikiadmin at 20:17, 2 August 2016

2016-08-02T20:17:21Z

Show changes