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

Electricity Production From Coal Sources (% Of Total)

@worldbank.africa_development_indicators.eg_elc_coal_zs
  • 37.78 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Hydroelectric Sources (kWh)

@worldbank.africa_development_indicators.eg_elc_hyro_kh
  • 41.59 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Hydroelectric Sources (% Of Total)

@worldbank.africa_development_indicators.eg_elc_hyro_zs
  • 42.95 KB
  • 60 rows
  • 54 columns
Loading...

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

Electric Power Transmission And Distribution Losses (kWh)

@worldbank.africa_development_indicators.eg_elc_loss_kh
  • 42.01 KB
  • 60 rows
  • 54 columns
Loading...

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

Electric Power Transmission And Distribution Losses (% Of Output)

@worldbank.africa_development_indicators.eg_elc_loss_zs
  • 43.34 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Natural Gas Sources (kWh)

@worldbank.africa_development_indicators.eg_elc_ngas_kh
  • 36.83 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Natural Gas Sources (% Of Total)

@worldbank.africa_development_indicators.eg_elc_ngas_zs
  • 38.13 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Nuclear Sources (kWh)

@worldbank.africa_development_indicators.eg_elc_nucl_kh
  • 33.68 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Nuclear Sources (% Of Total)

@worldbank.africa_development_indicators.eg_elc_nucl_zs
  • 34.38 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Oil Sources (kWh)

@worldbank.africa_development_indicators.eg_elc_petr_kh
  • 41.79 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production From Oil Sources (% Of Total)

@worldbank.africa_development_indicators.eg_elc_petr_zs
  • 43.54 KB
  • 60 rows
  • 54 columns
Loading...

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

Electricity Production (kWh)

@worldbank.africa_development_indicators.eg_elc_prod_kh
  • 43.17 KB
  • 60 rows
  • 54 columns
Loading...

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

GDP Per Unit Of Energy Use (PPP $ Per Kg Of Oil Equivalent)

@worldbank.africa_development_indicators.eg_gdp_puse_ko_pp
  • 40.16 KB
  • 60 rows
  • 54 columns
Loading...

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

GDP Per Unit Of Energy Use (constant 2005 PPP $ Per Kg Of Oil Equivalent)

@worldbank.africa_development_indicators.eg_gdp_puse_ko_pp_kd
  • 43.08 KB
  • 60 rows
  • 54 columns
Loading...

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

Energy Imports, Net (% Of Energy Use)

@worldbank.africa_development_indicators.eg_imp_cons_zs
  • 43.72 KB
  • 60 rows
  • 54 columns
Loading...

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

Energy Imports (kt Of Oil Equivalent)

@worldbank.africa_development_indicators.eg_imp_totl_kt_oe
  • 41.96 KB
  • 60 rows
  • 54 columns
Loading...

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

Alternative And Nuclear Energy (% Of Total Energy Use)

@worldbank.africa_development_indicators.eg_use_comm_cl_zs
  • 43.08 KB
  • 60 rows
  • 54 columns
Loading...

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

Fossil Fuel Energy Consumption (% Of Total)

@worldbank.africa_development_indicators.eg_use_comm_fo_zs
  • 43.84 KB
  • 60 rows
  • 54 columns
Loading...

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

Energy Use (kt Of Oil Equivalent)

@worldbank.africa_development_indicators.eg_use_comm_kt_oe
  • 44.41 KB
  • 60 rows
  • 54 columns
Loading...

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

Combustible Renewables And Waste (metric Tons Of Oil Equivalent)

@worldbank.africa_development_indicators.eg_use_crnw_kt_oe
  • 41.89 KB
  • 60 rows
  • 54 columns
Loading...

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

Combustible Renewables And Waste (% Of Total Energy)

@worldbank.africa_development_indicators.eg_use_crnw_zs
  • 43.72 KB
  • 60 rows
  • 54 columns
Loading...

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

Electric Power Consumption (kWh)

@worldbank.africa_development_indicators.eg_use_elec_kh
  • 41.27 KB
  • 60 rows
  • 54 columns
Loading...

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

Electric Power Consumption (kWh Per Capita)

@worldbank.africa_development_indicators.eg_use_elec_kh_pc
  • 43.42 KB
  • 60 rows
  • 54 columns
Loading...

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

Energy Use (kg Of Oil Equivalent Per Capita)

@worldbank.africa_development_indicators.eg_use_pcap_kg_oe
  • 44.23 KB
  • 60 rows
  • 54 columns
Loading...

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

Economically Active Population In Agriculture (number)

@worldbank.africa_development_indicators.en_agr_empl
  • 45.13 KB
  • 60 rows
  • 54 columns
Loading...

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

Share link

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