International Telecommunications Union (ITU)

From Pardee Wiki
Revision as of 13:41, 1 July 2016 by JoelMaweni (talk | contribs)
Jump to navigation Jump to search

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.

Variable

Last IFs Update

ICTBroadbandSubscribersITU

2015/01/28

ICTComputers

2008/12/24

ICTComputersper100

2010/11/23

ICTCYBGlobalCybSecIndexITU

2015/02/06

ICTCYBGlobalCybSecSubIndexCapacityBuildingITU

2015/02/06

ICTCYBGlobalCybSecSubIndexCooperationITU

2015/02/06

ICTCYBGlobalCybSecSubIndexLegalITU

2015/02/06

ICTCYBGlobalCybSecSubIndexOrganizationalITU

2015/02/06

ICTCYBGlobalCybSecSubIndexTechnicalITU

2015/02/06

ICTCYBICTDevelopmentSubIndexAccessITU

2015/02/12

ICTCYBICTDevelopmentSubIndexSkillsITU

2015/02/12

ICTCYBICTDevelopmentSubIndexUseITU

2015/02/12

ICTDigitalAccessIndex

2005/01

ICTHomeSatelliteAntennas

2015/01/28

ICTInternetCableModemSubscribers

2015/01/28

ICTInternetDialUpSubscribers

2015/01/28

ICTInternetDSLSubscribers

2015/01/28

ICTInternetFixedSubscribers

2015/01/28

ICTInternetFixedSubscribersPer100

2015/01/28

ICTInternetHostsITU

2005/01

ICTInternetISDNChannels

2015/01/28

ICTInternetISDNSubscribers

2005/01

ICTInternetISDNSubscribersTotal

2015/01/28

ICTInternetUsersITU

2008/12/17

ICTInternetUsersITUper100

2010/10/13

ICTIntlBandwidth

2015/04/14

ICTIntlBandwidthPerCap

2015/04/14

ICTMobileCommStaff

2015/01/28

ICTPersonalComputers

2005/01

ICTPersonalComputersinEducation

2005/01

ICTPublicPayphones

2015/01/28

ICTPublicPayphonesper1000

2015/01/28

ICTPublicSwitchingExchCapacity

2015/01/28

ICTRadioEquippedHouseholds

2008/12/24

ICTRadioHousehold%

2015/01/28

ICTRadios

2008/12/24

ICTTelecomEquipExports

2008/12/31

ICTTelecomEquipImports

2008/12/31

ICTTelecomFemaleStaff

2015/01/28

ICTTelecomFTStaff

2015/01/28

ICTTelecomInvest

2015/01/28

ICTTelecomRevTotal

2015/01/28

ICTTelecomRevTotal%GDP

2015/02/08

ICTTelephoneAutomaticMainLines%

2008/12/02

ICTTelephoneBusConnectFee

2015/01/28

ICTTelephoneBusMonthlyCost

2015/01/28

ICTTelephoneCallsLocal

2008/12/22

ICTTelephoneCallsMinutesLocal

2015/01/28

ICTTelephoneCallsMinutesNatLongDistance

2015/01/28

ICTTelephoneCallsNatLongDistance

2008/12/22

ICTTelephoneCellConnectFee

2015/01/28

ICTTelephoneCellHousehold%

2015/01/28

ICTTelephoneCellMonthlyCost

2015/01/28

ICTTelephoneCellOffPeakCost

2015/01/28

ICTTelephoneCellPeakCost

2015/01/28

ICTTelephoneCellSubscribers

2015/01/28

ICTTelephoneCellSubscribersDigital

2009/01/03

ICTTelephoneCellSubscribersPre&PostPaid

2009/01/03

ICTTelephoneCellSubscribersPrePaid

2015/01/28

ICTTelephoneCircuits

2015/01/28

ICTTelephoneFaults

2015/01/28

ICTTelephoneFaultsClearedNextDay%

2015/01/28

ICTTelephoneHousehold%

2015/01/28

ICTTelephoneIntCallsIn

2009/01/07

ICTTelephoneIntCallsOut

2008/12/16

ICTTelephoneIntMinIn

2015/01/28

ICTTelephoneIntMinOut

2015/01/28

ICTTelephoneInvest

2015/01/28

ICTTelephoneLinesInOperation

2009/04/10

ICTTelephoneLinesInOperationITU

2010/08/25

ICTTelephoneLinesMajorCityTotal

2009/01/06

ICTTelephoneLinesPer1000

2011/08/08

ICTTelephoneLinesPer100New

2012/02/01

ICTTelephoneLinesPer100old

2010/10/13

ICTTelephoneLinesUrban%

2008/12/04

ICTTelephoneLinesWaitingList

2015/01/28

ICTTelephoneLocalOffPeakCost

2015/01/28

ICTTelephoneLocalPeakCost

2015/01/28

ICTTelephoneMainlinesper1000

2009/01/25

ICTTelephoneMobileCov%

2015/01/28

ICTTelephoneMobileInvest

2015/01/28

ICTTelephoneNatTrafficCalls

2009/01/07

ICTTelephoneNatTrafficMin

2009/01/07

ICTTelephonePercentDigital

2015/01/28

ICTTelephoneResConnectFee

2015/01/28

ICTTelephoneResLines%

2015/01/28

ICTTelephoneResMonthlyCost

2015/01/28

ICTTelephoneRevFixed

2015/01/28

ICTTelephoneRevMobile

2015/01/28

ICTTelephoneSubscribersPer100

2009/01/02

ICTTelephoneTrafficMinutesIntlIncoming

2015/02/03

ICTTelephoneTrafficMinutesIntlOutgoing

2015/02/03

ICTTelevisionCable

2009/01/02

ICTTelevisionEquippedHouseholds

2008/12/31

ICTTelevisionHousehold%

2015/01/28

ICTTelevisionSets

2008/12/31

ICTTelevisionSetsper1000

2009/01/06

SIGIRestrictedCivilLibertiesSubIndex

2013/10/07

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

 June 2016 Updates

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.