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

Compensation Of Employees (% Of Expense)

@worldbank.africa_development_indicators.gc_xpn_comp_zs
  • 33.82 KB
  • 60 rows
  • 54 columns
Loading... 

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

Goods And Services Expense (current LCU)

@worldbank.africa_development_indicators.gc_xpn_gsrv_cn
  • 33.8 KB
  • 60 rows
  • 54 columns
Loading... 

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

Goods And Services Expense (% Of Expense)

@worldbank.africa_development_indicators.gc_xpn_gsrv_zs
  • 33.79 KB
  • 60 rows
  • 54 columns
Loading... 

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

Interest Payments (current LCU)

@worldbank.africa_development_indicators.gc_xpn_intp_cn
  • 33.85 KB
  • 60 rows
  • 54 columns
Loading... 

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

Interest Payments (% Of Revenue)

@worldbank.africa_development_indicators.gc_xpn_intp_rv_zs
  • 34.07 KB
  • 60 rows
  • 54 columns
Loading... 

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

Interest Payments (% Of Expense)

@worldbank.africa_development_indicators.gc_xpn_intp_zs
  • 33.81 KB
  • 60 rows
  • 54 columns
Loading... 

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

Other Expense (current LCU)

@worldbank.africa_development_indicators.gc_xpn_othr_cn
  • 32.69 KB
  • 60 rows
  • 54 columns
Loading... 

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

Other Expense (% Of Expense)

@worldbank.africa_development_indicators.gc_xpn_othr_zs
  • 32.79 KB
  • 60 rows
  • 54 columns
Loading... 

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

Expense (current US$)

@worldbank.africa_development_indicators.gc_xpn_totl_cd
  • 33.79 KB
  • 60 rows
  • 54 columns
Loading... 

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

Expense (current LCU)

@worldbank.africa_development_indicators.gc_xpn_totl_cn
  • 33.73 KB
  • 60 rows
  • 54 columns
Loading... 

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

Expense (% Of GDP)

@worldbank.africa_development_indicators.gc_xpn_totl_gd_zs
  • 33.96 KB
  • 60 rows
  • 54 columns
Loading... 

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

Subsidies And Other Transfers (current LCU)

@worldbank.africa_development_indicators.gc_xpn_trft_cn
  • 33.48 KB
  • 60 rows
  • 54 columns
Loading... 

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

Subsidies And Other Transfers (% Of Expense)

@worldbank.africa_development_indicators.gc_xpn_trft_zs
  • 33.49 KB
  • 60 rows
  • 54 columns
Loading... 

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

Control Of Corruption (estimate)

@worldbank.africa_development_indicators.gv_cont_co_es
  • 35.22 KB
  • 60 rows
  • 54 columns
Loading... 

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

Control Of Corruption (number Of Surveys/polls)

@worldbank.africa_development_indicators.gv_cont_co_no
  • 30.3 KB
  • 60 rows
  • 54 columns
Loading... 

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

Government Effectiveness (estimate)

@worldbank.africa_development_indicators.gv_govt_ef_es
  • 35.35 KB
  • 60 rows
  • 54 columns
Loading... 

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

Government Effectiveness (number Of Surveys/polls)

@worldbank.africa_development_indicators.gv_govt_ef_no
  • 30.19 KB
  • 60 rows
  • 54 columns
Loading... 

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

Political Stability/No Violence (estimate)

@worldbank.africa_development_indicators.gv_poli_st_es
  • 35.43 KB
  • 60 rows
  • 54 columns
Loading... 

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

Political Stability/No Violence (number Of Surveys/polls)

@worldbank.africa_development_indicators.gv_poli_st_no
  • 30.06 KB
  • 60 rows
  • 54 columns
Loading... 

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

Regulatory Quality (estimate)

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

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

Regulatory Quality (number Of Surveys/polls)

@worldbank.africa_development_indicators.gv_regl_la_no
  • 30.13 KB
  • 60 rows
  • 54 columns
Loading... 

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

Rule Of Law (estimate)

@worldbank.africa_development_indicators.gv_rule_lw_es
  • 35.43 KB
  • 60 rows
  • 54 columns
Loading... 

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

Rule Of Law (number Off Surveys/polls)

@worldbank.africa_development_indicators.gv_rule_lw_no
  • 30.37 KB
  • 60 rows
  • 54 columns
Loading... 

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

Corruption Perceptions Index (rank)

@worldbank.africa_development_indicators.gv_ti_rank_idx
  • 31.66 KB
  • 60 rows
  • 54 columns
Loading... 

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

Corruption Perceptions Index (score)

@worldbank.africa_development_indicators.gv_ti_scor_idx
  • 31.96 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE gv_ti_scor_idx (
  "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" 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.