International Telecommunications Union (ITU)
International Telecommunications Union (ITU): World Telecommunication Indicators Database (12th edition 2008)
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
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.
Series pulled from ITU
| Table | Source | Last IFs Update | UsedInPreprocessorFileName |
|---|---|---|---|
| SeriesICTIntlBandwidthPerCap | ITU | 2015/04/14 | |
| SeriesICTIntlBandwidth | ITU | 2015/04/14 | |
| SeriesICTInternetHousehold% | ITU | 2015/04/14 | INFRA |
| SeriesICTTelephoneLinesInOperationITU | ITU - World Telecommunication Development Report | 2010/08/25 | |
| SeriesICTPersonalComputers | ITU 2003 | 2005/01 | |
| SeriesICTPersonalComputersinEducation | ITU 2003 | 2005/01 | |
| SeriesICTInternetHostsITU | ITU 2003 | 2005/01 | |
| SeriesICTInternetUsersITU | ITU 2008 | 2008/12/17 | |
| SeriesICTTelecomEquipImports | ITU 2008 | 2008/12/31 | |
| SeriesICTTelevisionEquippedHouseholds | ITU 2008 | 2008/12/31 | |
| SeriesICTTelevisionSets | ITU 2008 | 2008/12/31 | |
| SeriesICTTelephoneCellSubscribersDigital | ITU 2008 | 2009/01/03 | |
| SeriesICTTelephoneCellSubscribersPre&PostPaid | ITU 2008 | 2009/01/03 | |
| SeriesICTTelephoneNatTrafficCalls | ITU 2008 | 2009/01/07 | |
| SeriesICTTelevisionCable | ITU 2008 | 2009/01/02 | |
| SeriesICTRadioEquippedHouseholds | ITU 2008 | 2008/12/24 | |
| SeriesICTTelephoneLinesInOperation | ITU 2008 | 2009/04/10 | |
| SeriesICTTelephoneNatTrafficMin | ITU 2008 | 2009/01/07 | |
| SeriesICTRadios | ITU 2008 | 2008/12/24 | |
| SeriesICTTelephoneSubscribersPer100 | ITU 2008 | 2009/01/02 | |
| SeriesPopulationLargestCity | ITU 2008 | 2008/12/24 | |
| SeriesICTComputers | ITU 2008 | 2008/12/24 | |
| SeriesICTTelephoneCallsNatLongDistance | ITU 2008 | 2008/12/22 | |
| SeriesICTTelephoneCallsLocal | ITU 2008 | 2008/12/22 | |
| SeriesICTTelephoneIntCallsOut | ITU 2008 | 2008/12/16 | |
| SeriesICTTelephoneIntCallsIn | ITU 2008 | 2009/01/07 | |
| SeriesHouseholdsOld | ITU 2008 | 2009/01/07 | |
| SeriesICTTelephoneLinesUrban% | ITU 2008 | 2008/12/04 | |
| SeriesICTTelephoneAutomaticMainLines% | ITU 2008 | 2008/12/02 | |
| SeriesICTTelephoneMainlinesper1000 | ITU 2008 | 2009/01/25 | |
| SeriesICTTelevisionSetsper1000 | ITU 2008 | 2009/01/06 | |
| SeriesICTTelecomEquipExports | ITU 2008 | 2008/12/31 | |
| SeriesICTComputersper100 | ITU 2010 | 2010/11/23 | |
| SeriesICTTelephoneLinesMajorCityTotal | ITU 2010 | 2009/01/06 | |
| SeriesICTInternetUsersITUper100 | ITU 2010 Database | 2010/10/13 | |
| SeriesICTTelephoneLinesPer100old | ITU 2010 Database | 2010/10/13 | |
| SeriesICTTelephoneLinesPer1000 | ITU 2010; 2010 is growth rate estimate | 2011/08/08 | |
| SeriesICTTelephoneLinesPer100New | ITU 2011 | 2012/02/01 | |
| SeriesHouseholds | ITU 2011 | 2011/08/19 | INFRA |
| SeriesICTTelephoneMobileCov% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneInvest | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneLocalPeakCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesEnElecAccess%Households | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneIntMinOut | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCallsMinutesNatLongDistance | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTPublicSwitchingExchCapacity | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellOffPeakCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTHomeSatelliteAntennas | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneIntMinIn | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneHousehold% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneFaultsClearedNextDay% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneLinesWaitingList | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelevisionHousehold% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelecomInvest | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneFaults | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellConnectFee | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellMonthlyCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephonePercentDigital | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCircuits | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneResMonthlyCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneResLines% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTInternetISDNChannels | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTRadioHousehold% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneBusMonthlyCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellPeakCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTInternetCableModemSubscribers | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneMobileInvest | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneResConnectFee | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneTrafficMinutesIntlIncoming | ITU 2014 BATCH PULL | 2015/02/03 | |
| SeriesICTTelecomFTStaff | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellSubscribers | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCallsMinutesLocal | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTMobileCommStaff | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTPublicPayphonesper1000 | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTInternetISDNSubscribersTotal | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTPublicPayphones | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelecomRevTotal | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellSubscribersPrePaid | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneTrafficMinutesIntlOutgoing | ITU 2014 BATCH PULL | 2015/02/03 | |
| SeriesICTInternetFixedSubscribersPer100 | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTInternetFixedSubscribers | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneRevFixed | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTInternetDSLSubscribers | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTInternetDialUpSubscribers | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTBroadbandSubscribersITU | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelecomFemaleStaff | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneLocalOffPeakCost | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTComputerHousehold% | ITU 2014 BATCH PULL | 2015/01/28 | INFRA |
| SeriesICTTelephoneRevMobile | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneBusConnectFee | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesHouseholdsITU2014 | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTTelephoneCellHousehold% | ITU 2014 BATCH PULL | 2015/01/28 | |
| SeriesICTBroadbandMobileSubsPer100 | ITU 2014 BATCH PULL | 2015/02/03 | INFRA |
| SeriesICTTelephoneCellSubscribersPer100 | ITU 2015 | 2016/05/18 | INFRA |
| SeriesICTTelephoneLinesPer100 | ITU 2015 | 2016/05/18 | INFRA |
| SeriesICTBroadbandSubscribersPer100ITU | ITU 2015 | 2016/05/18 | INFRA |
| SeriesICTDigitalAccessIndex | ITU available at http://www.itu.int/newsroom/press_releases/2003/30.html | 2005/01 | |
| SeriesICTCYBGlobalCybSecSubIndexOrganizationalITU | ITU Global Cyber Security Index | 2015/02/06 | |
| SeriesICTCYBGlobalCybSecIndexITU | ITU Global Cyber Security Index | 2015/02/06 | |
| SeriesICTCYBGlobalCybSecSubIndexCapacityBuildingITU | ITU Global Cyber Security Index | 2015/02/06 | |
| SeriesICTCYBGlobalCybSecSubIndexLegalITU | ITU Global Cyber Security Index | 2015/02/06 | |
| SeriesICTCYBGlobalCybSecSubIndexCooperationITU | ITU Global Cyber Security Index | 2015/02/06 | |
| SeriesICTCYBGlobalCybSecSubIndexTechnicalITU | ITU Global Cyber Security Index | 2015/02/06 | |
| SeriesICTInternetISDNSubscribers | ITU World Telecommunications Indicators 2001 | 2005/01 | |
| SeriesICTCYBICTDevelopmentSubIndexAccessITU | ITU: Measuring the Information Society 2008, 2010-2014 | 2015/02/12 | |
| SeriesICTCYBICTDevelopmentIndexITU | ITU: Measuring the Information Society 2008, 2010-2014 | 2015/05/10 | INFRA |
| SeriesICTCYBICTDevelopmentSubIndexUseITU | ITU: Measuring the Information Society 2008, 2010-2014 | 2015/02/12 | |
| SeriesICTCYBICTDevelopmentSubIndexSkillsITU | ITU: Measuring the Information Society 2008, 2010-2014 | 2015/02/12 |
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.
Data source: http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx
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.
|
ICTBroadbandMobileSubsPer100 |
2015/02/03 |
|
ICTBroadbandSubscribersPer100ITU |
2015/01/28 |
|
ICTComputerHousehold% |
2015/01/28 |
|
ICTCYBICTDevelopmentIndexITU |
2015/05/10 |
|
ICTInternetHousehold% |
2015/04/14 |
|
ICTTelephoneCellSubscribersPer100 |
2015/01/28 |
|
ICTTelephoneLinesPer100 |
2014/06/30 |
The following Series were updated by an additional year up to 2014
ICTTelephoneLinesPer100
ICTTelephoneCellSubscribersPer100
ICTBroadbandSubscribersPer100ITU
Operations:
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
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.
Issues to note
Kosovo and Korea, Democratic Republic are not covered in the ICTBroadbandSubscribersPer100ITU series.
Kosovo is not covered in the other two 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.