Baselight
Sign In

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

Bird Species, Threatened

@worldbank.africa_development_indicators.en_bir_thrd_no
  • 28.02 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE en_bir_thrd_no (
  "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" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" VARCHAR,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" DOUBLE
);

Plant Species (higher), Threatened

@worldbank.africa_development_indicators.en_hpt_thrd_no
  • 28.09 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE en_hpt_thrd_no (
  "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" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" VARCHAR,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" DOUBLE
);

Non-agricultural Population (FAO, Number)

@worldbank.africa_development_indicators.en_nagr_empl_in
  • 45.4 KB
  • 60 rows
  • 54 columns
Loading... 

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

Population Density (people Per Sq. Km Of Land Area)

@worldbank.africa_development_indicators.en_pop_dnst
  • 60.6 KB
  • 60 rows
  • 54 columns
Loading... 

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

Rural Population Density (rural Population Per Sq. Km Of Arable Land)

@worldbank.africa_development_indicators.en_rur_dnst
  • 60.42 KB
  • 60 rows
  • 54 columns
Loading... 

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

Population In Largest City

@worldbank.africa_development_indicators.en_urb_lcty
  • 53.18 KB
  • 60 rows
  • 54 columns
Loading... 

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

Population In The Largest City (% Of Urban Population)

@worldbank.africa_development_indicators.en_urb_lcty_ur_zs
  • 60.86 KB
  • 60 rows
  • 54 columns
Loading... 

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

Population In Urban Agglomerations Of More Than 1 Million

@worldbank.africa_development_indicators.en_urb_mcty
  • 47.2 KB
  • 60 rows
  • 54 columns
Loading... 

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

Population In Urban Agglomerations Of More Than 1 Million (% Of Total Population)

@worldbank.africa_development_indicators.en_urb_mcty_tl_zs
  • 50.3 KB
  • 60 rows
  • 54 columns
Loading... 

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

Pump Price For Diesel Fuel (US$ Per Liter)

@worldbank.africa_development_indicators.ep_pmp_desl_cd
  • 31.89 KB
  • 60 rows
  • 54 columns
Loading... 

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

Pump Price For Gasoline (US$ Per Liter)

@worldbank.africa_development_indicators.ep_pmp_sgas_cd
  • 31.93 KB
  • 60 rows
  • 54 columns
Loading... 

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

GEF Benefits Index For Biodiversity (0 = No Biodiversity Potential To 100 = Maximum)

@worldbank.africa_development_indicators.er_bdv_totl_xq
  • 28.89 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE er_bdv_totl_xq (
  "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" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" DOUBLE,
  "yr2006" VARCHAR,
  "yr2007" VARCHAR,
  "yr2008" DOUBLE,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" VARCHAR,
  "yr2012" VARCHAR
);

Water Productivity, Total (constant 2000 US$ GDP Per Cubic Meter Of Total Freshwater Withdrawal)

@worldbank.africa_development_indicators.er_gdp_fwtl_m3_kd
  • 31.42 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE er_gdp_fwtl_m3_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" VARCHAR,
  "yr1972" DOUBLE,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" DOUBLE,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" DOUBLE,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" VARCHAR,
  "yr1992" DOUBLE,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" VARCHAR,
  "yr1996" VARCHAR,
  "yr1997" DOUBLE,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" DOUBLE,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Annual Freshwater Withdrawals, Agriculture (% Of Total Freshwater Withdrawal)

@worldbank.africa_development_indicators.er_h2o_fwag_zs
  • 30.93 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE er_h2o_fwag_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" DOUBLE,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" DOUBLE,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" DOUBLE,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" VARCHAR,
  "yr1992" DOUBLE,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" VARCHAR,
  "yr1996" VARCHAR,
  "yr1997" DOUBLE,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" DOUBLE,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Annual Freshwater Withdrawals, Domestic (% Of Total Freshwater Withdrawal)

@worldbank.africa_development_indicators.er_h2o_fwdm_zs
  • 30.89 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE er_h2o_fwdm_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" DOUBLE,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" DOUBLE,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" DOUBLE,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" VARCHAR,
  "yr1992" DOUBLE,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" VARCHAR,
  "yr1996" VARCHAR,
  "yr1997" DOUBLE,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" DOUBLE,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Annual Freshwater Withdrawals, Industry (% Of Total Freshwater Withdrawal)

@worldbank.africa_development_indicators.er_h2o_fwin_zs
  • 30.96 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE er_h2o_fwin_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" DOUBLE,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" DOUBLE,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" DOUBLE,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" VARCHAR,
  "yr1992" DOUBLE,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" VARCHAR,
  "yr1996" VARCHAR,
  "yr1997" DOUBLE,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" DOUBLE,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Annual Freshwater Withdrawals, Total (billion Cubic Meters)

@worldbank.africa_development_indicators.er_h2o_fwtl_k3
  • 31.33 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE er_h2o_fwtl_k3 (
  "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" DOUBLE,
  "yr1973" VARCHAR,
  "yr1974" VARCHAR,
  "yr1975" VARCHAR,
  "yr1976" VARCHAR,
  "yr1977" DOUBLE,
  "yr1978" VARCHAR,
  "yr1979" VARCHAR,
  "yr1980" VARCHAR,
  "yr1981" VARCHAR,
  "yr1982" DOUBLE,
  "yr1983" VARCHAR,
  "yr1984" VARCHAR,
  "yr1985" VARCHAR,
  "yr1986" VARCHAR,
  "yr1987" DOUBLE,
  "yr1988" VARCHAR,
  "yr1989" VARCHAR,
  "yr1990" VARCHAR,
  "yr1991" VARCHAR,
  "yr1992" DOUBLE,
  "yr1993" VARCHAR,
  "yr1994" VARCHAR,
  "yr1995" VARCHAR,
  "yr1996" VARCHAR,
  "yr1997" DOUBLE,
  "yr1998" VARCHAR,
  "yr1999" VARCHAR,
  "yr2000" VARCHAR,
  "yr2001" VARCHAR,
  "yr2002" DOUBLE,
  "yr2003" VARCHAR,
  "yr2004" VARCHAR,
  "yr2005" VARCHAR,
  "yr2006" VARCHAR,
  "yr2007" DOUBLE,
  "yr2008" VARCHAR,
  "yr2009" VARCHAR,
  "yr2010" VARCHAR,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Annual Freshwater Withdrawals, Total (% Of Internal Resources)

@worldbank.africa_development_indicators.er_h2o_fwtl_zs
  • 28.27 KB
  • 60 rows
  • 54 columns
Loading... 

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

Renewable Internal Freshwater Resources, Total (billion Cubic Meters)

@worldbank.africa_development_indicators.er_h2o_intr_k3
  • 33.07 KB
  • 60 rows
  • 54 columns
Loading... 

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

Renewable Internal Freshwater Resources Per Capita (cubic Meters)

@worldbank.africa_development_indicators.er_h2o_intr_pc
  • 34.65 KB
  • 60 rows
  • 54 columns
Loading... 

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

Terrestrial Protected Areas (sq. Km)

@worldbank.africa_development_indicators.er_lnd_ptld_k2
  • 40.68 KB
  • 60 rows
  • 54 columns
Loading... 

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

Terrestrial Protected Areas (% Of Total Surface Area)

@worldbank.africa_development_indicators.er_lnd_ptld_zs
  • 40.7 KB
  • 60 rows
  • 54 columns
Loading... 

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

Marine Protected Areas (sq. Km)

@worldbank.africa_development_indicators.er_mrn_ptmr_k2
  • 37.23 KB
  • 60 rows
  • 54 columns
Loading... 

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

Marine Protected Areas (% Of Total Surface Area)

@worldbank.africa_development_indicators.er_mrn_ptmr_zs
  • 37.23 KB
  • 60 rows
  • 54 columns
Loading... 

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

Bank Nonperfoming Loans To Total Gross Loans (%)

@worldbank.africa_development_indicators.fb_ast_nper_zs
  • 30.48 KB
  • 60 rows
  • 54 columns
Loading... 

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

Share link

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