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

Trademark Applications, Direct Nonresident

@worldbank.africa_development_indicators.ip_tmk_nres
  • 39.06 KB
  • 60 rows
  • 54 columns
Loading... 

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

Trademark Applications, Direct Resident

@worldbank.africa_development_indicators.ip_tmk_resd
  • 38.72 KB
  • 60 rows
  • 54 columns
Loading... 

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

CPIA Business Regulatory Environment Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_breg_xq
  • 29.09 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_breg_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Debt Policy Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_debt_xq
  • 29.21 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_debt_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Economic Management Cluster Average (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_econ_xq
  • 29.6 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_econ_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Policy And Institutions For Environmental Sustainability Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_envr_xq
  • 29.05 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_envr_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Quality Of Budgetary And Financial Management Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_finq_xq
  • 29.12 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_finq_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Financial Sector Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_fins_xq
  • 29.12 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_fins_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Fiscal Policy Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_fisp_xq
  • 29.19 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_fisp_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Gender Equality Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_gndr_xq
  • 29.13 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_gndr_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Building Human Resources Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_hres_xq
  • 29.17 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_hres_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

IDA Resource Allocation Index (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_irai_xq
  • 30.24 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_irai_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Macroeconomic Management Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_macr_xq
  • 29.17 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_macr_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Quality Of Public Administration Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_padm_xq
  • 29.12 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_padm_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Equity Of Public Resource Use Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_pres_xq
  • 29.19 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_pres_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Property Rights And Rule-based Governance Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_prop_xq
  • 29.16 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_prop_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Social Protection Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_prot_xq
  • 29.17 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_prot_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Public Sector Management And Institutions Cluster Average (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_pubs_xq
  • 29.58 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_pubs_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Efficiency Of Revenue Mobilization Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_revn_xq
  • 29.07 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_revn_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Policies For Social Inclusion/equity Cluster Average (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_soci_xq
  • 29.63 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_soci_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Structural Policies Cluster Average (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_strc_xq
  • 29.4 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_strc_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Trade Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_trad_xq
  • 29.19 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_trad_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

CPIA Transparency, Accountability, And Corruption In The Public Sector Rating (1=low To 6=high)

@worldbank.africa_development_indicators.iq_cpa_tran_xq
  • 29.19 KB
  • 60 rows
  • 54 columns
Loading... 

CREATE TABLE iq_cpa_tran_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" DOUBLE,
  "yr2007" DOUBLE,
  "yr2008" DOUBLE,
  "yr2009" DOUBLE,
  "yr2010" DOUBLE,
  "yr2011" DOUBLE,
  "yr2012" VARCHAR
);

Air Transport, Registered Carrier Departures Worldwide

@worldbank.africa_development_indicators.is_air_dprt
  • 44.44 KB
  • 60 rows
  • 54 columns
Loading... 

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

Air Transport, Freight (million Ton-km)

@worldbank.africa_development_indicators.is_air_good_mt_k1
  • 44.98 KB
  • 60 rows
  • 54 columns
Loading... 

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

Share link

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