Baselight

Africa Development Indicators

Development data for 53 African countries

@worldbank.africa_development_indicators

Loading...
Loading...

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

Air Transport, Passengers Carried

@worldbank.africa_development_indicators.is_air_psgr
  • 46.4 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_air_psgr (
  "economy" VARCHAR,
  "yr1960" VARCHAR,
  "yr1961" VARCHAR,
  "yr1962" VARCHAR,
  "yr1963" VARCHAR,
  "yr1964" VARCHAR,
  "yr1965" VARCHAR,
  "yr1966" VARCHAR,
  "yr1967" VARCHAR,
  "yr1968" VARCHAR,
  "yr1969" VARCHAR,
  "yr1970" DOUBLE,
  "yr1971" DOUBLE,
  "yr1972" DOUBLE,
  "yr1973" DOUBLE,
  "yr1974" DOUBLE,
  "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
);

Road Density (km Of Road Per 100 Sq. Km Of Land Area)

@worldbank.africa_development_indicators.is_rod_dnst_k2
  • 29.87 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rod_dnst_k2 (
  "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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Roads, Goods Transported (million Ton-km)

@worldbank.africa_development_indicators.is_rod_good_mt_k6
  • 30.44 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rod_good_mt_k6 (
  "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" DOUBLE,
  "yr1991" DOUBLE,
  "yr1992" DOUBLE,
  "yr1993" DOUBLE,
  "yr1994" DOUBLE,
  "yr1995" DOUBLE,
  "yr1996" DOUBLE,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Roads, Paved (% Of Total Roads)

@worldbank.africa_development_indicators.is_rod_pave_zs
  • 34.3 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rod_pave_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" 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" VARCHAR,
  "yr2012" VARCHAR
);

Roads, Passengers Carried (million Passenger-km)

@worldbank.africa_development_indicators.is_rod_psgr_k6
  • 28.59 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rod_psgr_k6 (
  "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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" DOUBLE,
  "yr2000" DOUBLE,
  "yr2001" DOUBLE,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" VARCHAR,
  "yr2008" DOUBLE,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Roads, Total Network (km)

@worldbank.africa_development_indicators.is_rod_totl_km
  • 34.59 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rod_totl_km (
  "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" 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" VARCHAR,
  "yr2012" VARCHAR
);

Railways, Goods Transported (million Ton-km)

@worldbank.africa_development_indicators.is_rrs_good_mt_k6
  • 35.96 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rrs_good_mt_k6 (
  "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
);

Railways, Passengers Carried (million Passenger-km)

@worldbank.africa_development_indicators.is_rrs_pasg_km
  • 35.85 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rrs_pasg_km (
  "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
);

Rail Lines (total Route-km)

@worldbank.africa_development_indicators.is_rrs_totl_km
  • 35.65 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_rrs_totl_km (
  "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
);

Container Port Traffic (TEU: 20 Foot Equivalent Units)

@worldbank.africa_development_indicators.is_shp_good_tu
  • 30.43 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_shp_good_tu (
  "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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "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
);

Motor Vehicles (per 1,000 People)

@worldbank.africa_development_indicators.is_veh_nveh_p3
  • 29.68 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_veh_nveh_p3 (
  "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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" VARCHAR,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Passenger Cars (per 1,000 People)

@worldbank.africa_development_indicators.is_veh_pcar_p3
  • 29.9 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_veh_pcar_p3 (
  "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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Vehicles (per Km Of Road)

@worldbank.africa_development_indicators.is_veh_road_k1
  • 29.28 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE is_veh_road_k1 (
  "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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" DOUBLE,
  "yr2004" DOUBLE,
  "yr2005" DOUBLE,
  "yr2006" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular - Price Of 3-minute Local Call (off-peak On-net, Current US$)

@worldbank.africa_development_indicators.it_cell_3min_cd_op
  • 37.12 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_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" 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" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular - Price Of 3-minute Local Call (peak On-net, Current US$)

@worldbank.africa_development_indicators.it_cell_3min_cd_pk
  • 37.68 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_3min_cd_pk (
  "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" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular - Price Of 3-minute Local Call (off-peak On-net, Current LCU)

@worldbank.africa_development_indicators.it_cell_3min_cn_op
  • 35.74 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_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" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular - Price Of 3-minute Local Call (peak On-net, Current LCU)

@worldbank.africa_development_indicators.it_cell_3min_cn_pk
  • 36.14 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_3min_cn_pk (
  "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" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular Monthly Subscription (current US$)

@worldbank.africa_development_indicators.it_cell_msub_cd
  • 35.44 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_msub_cd (
  "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" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular Monthly Subscription (current LCU)

@worldbank.africa_development_indicators.it_cell_msub_cn
  • 34.56 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_msub_cn (
  "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" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular Postpaid Connection Charge (current US$)

@worldbank.africa_development_indicators.it_cell_po_conn_cd
  • 37.34 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_po_conn_cd (
  "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" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular Postpaid Connection Charge (current LCU)

@worldbank.africa_development_indicators.it_cell_po_conn_cn
  • 35.61 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_po_conn_cn (
  "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" VARCHAR,
  "yr2012" VARCHAR
);

Mobile Cellular Prepaid Connection Charge (current US$)

@worldbank.africa_development_indicators.it_cell_pr_conn_cd
  • 31.53 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_pr_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" 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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "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 Cellular Prepaid Connection Charge (current LCU)

@worldbank.africa_development_indicators.it_cell_pr_conn_cn
  • 30.69 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cell_pr_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" 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" VARCHAR,
  "yr1997" VARCHAR,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "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 Cellular Subscriptions

@worldbank.africa_development_indicators.it_cel_sets
  • 40.02 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cel_sets (
  "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
);

Mobile Cellular Subscriptions (per 100 People)

@worldbank.africa_development_indicators.it_cel_sets_p2
  • 42.12 KB
  • 60 rows
  • 54 columns
Loading...

CREATE TABLE it_cel_sets_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
);

Share link

Anyone who has the link will be able to view this.