About this Dataset

Africa Development Indicators

Africa Development Indicators 2012/13 provides the most detailed collection of data on Africa available in one volume.
It contains macroeconomic, sectoral, and social indicators, covering 53 African countries.

Additional data may be found on the companion time series database, covering over 1,700 indicators from 1960 to 2011.
Designed to provide all those interested in Africa with quick reference and a reliable set of data to monitor development programs and aid flows in the region, Africa Development Indicators is an invaluable reference tool for analysts and policy makers who want a better understanding of the economic and social developments occurring in Africa.

Tables

Mobile Phone Subscribers (per 1,000 People)

@worldbank.africa_development_indicators.it_cel_sets_p3

42.12 KB
60 rows
54 columns


CREATE TABLE it_cel_sets_p3 (
  "economy" VARCHAR,
  "yr1960" DOUBLE,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" DOUBLE,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" DOUBLE,
  "yr1976" DOUBLE,
  "yr1977" DOUBLE,
  "yr1978" DOUBLE,
  "yr1979" DOUBLE,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Price Of A 3-minute Fixed Telephone Local Call (off-peak Rate - Current US$)

@worldbank.africa_development_indicators.it_mlt_3min_cd_op

38.56 KB
60 rows
54 columns


CREATE TABLE it_mlt_3min_cd_op (
  "economy" VARCHAR,
  "yr1960" DOUBLE,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" DOUBLE,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" DOUBLE,
  "yr1976" DOUBLE,
  "yr1977" DOUBLE,
  "yr1978" DOUBLE,
  "yr1979" DOUBLE,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Price Of A 3-minute Fixed Telephone Local Call (peak Rate - Current US$)

@worldbank.africa_development_indicators.it_mlt_3min_cd_pk

39.91 KB
60 rows
54 columns


CREATE TABLE it_mlt_3min_cd_pk (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Telephone Average Cost Of Call To US (US$ Per Three Minutes)

@worldbank.africa_development_indicators.it_mlt_3min_cd_us

37.86 KB
60 rows
54 columns


CREATE TABLE it_mlt_3min_cd_us (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Price Of A 3-minute Fixed Telephone Local Call (off-peak Rate - Current LCU)

@worldbank.africa_development_indicators.it_mlt_3min_cn_op

37.25 KB
60 rows
54 columns


CREATE TABLE it_mlt_3min_cn_op (
  "economy" VARCHAR,
  "yr1960" DOUBLE,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" DOUBLE,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" DOUBLE,
  "yr1976" DOUBLE,
  "yr1977" DOUBLE,
  "yr1978" DOUBLE,
  "yr1979" DOUBLE,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Price Of A 3-minute Fixed Telephone Local Call (peak Rate - Current LCU)

@worldbank.africa_development_indicators.it_mlt_3min_cn_pk

36.91 KB
60 rows
54 columns


CREATE TABLE it_mlt_3min_cn_pk (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Business Telephone Connection Charge (current US$)

@worldbank.africa_development_indicators.it_mlt_bconn_cd

39.49 KB
60 rows
54 columns


CREATE TABLE it_mlt_bconn_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Business Telephone Connection Charge (current LCU)

@worldbank.africa_development_indicators.it_mlt_bconn_cn

36.93 KB
60 rows
54 columns


CREATE TABLE it_mlt_bconn_cn (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Business Telephone Monthly Subscription (current US$)

@worldbank.africa_development_indicators.it_mlt_bsub_cd

39.44 KB
60 rows
54 columns


CREATE TABLE it_mlt_bsub_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Business Telephone Monthly Subscription (current LCU)

@worldbank.africa_development_indicators.it_mlt_bsub_cn

36.71 KB
60 rows
54 columns


CREATE TABLE it_mlt_bsub_cn (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Residential Telephone Connection Charge (current US$)

@worldbank.africa_development_indicators.it_mlt_conn_cd

39.84 KB
60 rows
54 columns


CREATE TABLE it_mlt_conn_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Residential Telephone Connection Charge (current LCU)

@worldbank.africa_development_indicators.it_mlt_conn_cn

37.14 KB
60 rows
54 columns


CREATE TABLE it_mlt_conn_cn (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Telephone Faults Cleared By Next Working Day (%)

@worldbank.africa_development_indicators.it_mlt_falt_cl

34.4 KB
60 rows
54 columns


CREATE TABLE it_mlt_falt_cl (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Telephone Faults (per 100 Mainlines)

@worldbank.africa_development_indicators.it_mlt_falt_m2

35.27 KB
60 rows
54 columns


CREATE TABLE it_mlt_falt_m2 (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Fixed Telephone Service Investment (current US$)

@worldbank.africa_development_indicators.it_mlt_invs_cd

34.42 KB
60 rows
54 columns


CREATE TABLE it_mlt_invs_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Fixed Telephone Service Investment (current LCU)

@worldbank.africa_development_indicators.it_mlt_invs_cn

33.84 KB
60 rows
54 columns


CREATE TABLE it_mlt_invs_cn (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Telephone Lines

@worldbank.africa_development_indicators.it_mlt_main

47.43 KB
60 rows
54 columns


CREATE TABLE it_mlt_main (
  "economy" VARCHAR,
  "yr1960" DOUBLE,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" DOUBLE,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" DOUBLE,
  "yr1976" DOUBLE,
  "yr1977" DOUBLE,
  "yr1978" DOUBLE,
  "yr1979" DOUBLE,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Telephone Lines (per 100 People)

@worldbank.africa_development_indicators.it_mlt_main_p2

52.05 KB
60 rows
54 columns


CREATE TABLE it_mlt_main_p2 (
  "economy" VARCHAR,
  "yr1960" DOUBLE,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" DOUBLE,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" DOUBLE,
  "yr1976" DOUBLE,
  "yr1977" DOUBLE,
  "yr1978" DOUBLE,
  "yr1979" DOUBLE,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Telephone Mainlines (per 1,000 People)

@worldbank.africa_development_indicators.it_mlt_main_p3

52.05 KB
60 rows
54 columns


CREATE TABLE it_mlt_main_p3 (
  "economy" VARCHAR,
  "yr1960" DOUBLE,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" DOUBLE,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" DOUBLE,
  "yr1976" DOUBLE,
  "yr1977" DOUBLE,
  "yr1978" DOUBLE,
  "yr1979" DOUBLE,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Revenue From Fixed Telephone Service (current US$)

@worldbank.africa_development_indicators.it_mlt_revn_cd

41.03 KB
60 rows
54 columns


CREATE TABLE it_mlt_revn_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Revenue From Fixed Telephone Service (current LCU)

@worldbank.africa_development_indicators.it_mlt_revn_cn

39.57 KB
60 rows
54 columns


CREATE TABLE it_mlt_revn_cn (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" DOUBLE,
  "yr1981" DOUBLE,
  "yr1982" DOUBLE,
  "yr1983" DOUBLE,
  "yr1984" DOUBLE,
  "yr1985" DOUBLE,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Residential Monthly Telephone Subscription (current US$)

@worldbank.africa_development_indicators.it_mlt_rsub_cd

40.04 KB
60 rows
54 columns


CREATE TABLE it_mlt_rsub_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Residential Monthly Telephone Subscription (current LCU)

@worldbank.africa_development_indicators.it_mlt_rsub_cn

37.08 KB
60 rows
54 columns


CREATE TABLE it_mlt_rsub_cn (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" DOUBLE,
  "yr1987" DOUBLE,
  "yr1988" DOUBLE,
  "yr1989" DOUBLE,
  "yr1990" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Population Coverage Of Mobile Cellular Telephony (%)

@worldbank.africa_development_indicators.it_mob_cov_zs

32.84 KB
60 rows
54 columns


CREATE TABLE it_mob_cov_zs (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" VARCHAR,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" VARCHAR,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Mobile Communication Investment (current US$)

@worldbank.africa_development_indicators.it_mob_invs_cd

31.83 KB
60 rows
54 columns


CREATE TABLE it_mob_invs_cd (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" VARCHAR,
  "yr1971" VARCHAR,
  "yr1972" VARCHAR,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" VARCHAR,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" VARCHAR,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" VARCHAR,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" VARCHAR,
  "yr1992" VARCHAR,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" VARCHAR,
  "yr1996" DOUBLE,
  "yr1997" DOUBLE,
  "yr1998" DOUBLE,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);