Africa Development Indicators
Development data for 53 African countries
@worldbank.africa_development_indicators
Development data for 53 African countries
@worldbank.africa_development_indicators
CREATE TABLE bx_gsr_fcty_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_gsr_gnfs_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_gsr_incl_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_gsr_mrch_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_gsr_nfsv_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_gsr_royl_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_gsr_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" 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
);
CREATE TABLE bx_klt_dinv_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_klt_dinv_cd_wd (
"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
);
CREATE TABLE bx_klt_dinv_wd_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" 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
);
CREATE TABLE bx_trf_curr_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_trf_mgr_cd (
"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
);
CREATE TABLE bx_trf_mgr_dt_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" 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
);
CREATE TABLE bx_trf_ofdc_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_trf_offt_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_trf_prvt_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_trf_pwkr_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" 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
);
CREATE TABLE bx_trf_pwkr_cd_dt (
"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
);
CREATE TABLE bx_trf_pwkr_dt_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" 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
);
CREATE TABLE bx_trf_pwkr_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" 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
);
CREATE TABLE cm_mkt_lcap_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" 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
);
CREATE TABLE cm_mkt_lcap_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" 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
);
CREATE TABLE cm_mkt_ldom_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" 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
);
CREATE TABLE cm_mkt_trnr (
"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" 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
);
CREATE TABLE dc_dac_ausl_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"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
);
Anyone who has the link will be able to view this.