International Telecommunications Union (ITU): Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
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&nbsp;<br/>ICTTelephoneCellSubscribersPer100&nbsp;<br/>ICTBroadbandSubscribersPer100ITU&nbsp;


ICTTelephoneLinesPer100&nbsp;<br/>ICTTelephoneCellSubscribersPer100&nbsp;<br/>ICTBroadbandSubscribersPer100ITU&nbsp;'''<br/>'''
'''Step 1:'''&nbsp;Go to&nbsp;[http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx http://www.itu.int/en/ITU-D/Statistics/Pages/stat/default.aspx]&nbsp;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:'''&nbsp;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:'''&nbsp;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&nbsp;ICTBroadbandSubscribersPer100ITU series.&nbsp;
Kosovo and Korea, Democratic Republic are not covered in the&nbsp;ICTBroadbandSubscribersPer100ITU series.&nbsp;


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&nbsp;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.
 
 
 
 


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

Revision as of 22:04, 3 August 2016

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 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

Copy Of DataDict
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 were updated up to 2014:

ICTTelephoneLinesPer100 
ICTTelephoneCellSubscribersPer100 
ICTBroadbandSubscribersPer100ITU 

Step 1: Go to 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 2: Download the fixed-telephone subscriptions, mobile-cellular subscriptions, and Fixed broadband subscriptions data sheets.

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

Issues to note

Kosovo and Korea, Democratic Republic are not covered in the ICTBroadbandSubscribersPer100ITU series. 

Kosovo is not covered in the three series.

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.

Retrieved from "https://pardeewiki.du.edu//index.php?title=International_Telecommunications_Union_(ITU)&oldid=1187"