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 sh_tbs_incd_lw (
"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
);
CREATE TABLE sh_tbs_mort (
"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
);
CREATE TABLE sh_tbs_mort_hg (
"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
);
CREATE TABLE sh_tbs_mort_lw (
"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
);
CREATE TABLE sh_tbs_prev (
"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
);
CREATE TABLE sh_tbs_prev_hg (
"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
);
CREATE TABLE sh_tbs_prev_lw (
"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
);
CREATE TABLE sh_xpd_extr_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" 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 sh_xpd_oopc_to_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" 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" VARCHAR,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE sh_xpd_oopc_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" 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 sh_xpd_pcap (
"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" 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 sh_xpd_pcap_gx (
"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" 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" VARCHAR,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE sh_xpd_pcap_pp_kd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" 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" 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" VARCHAR,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE sh_xpd_priv (
"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" 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 sh_xpd_priv_prpp_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" 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 sh_xpd_priv_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" 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 sh_xpd_publ (
"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" 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 sh_xpd_publ_gx_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" 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 sh_xpd_publ_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" 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 sh_xpd_sose_gx_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" 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 sh_xpd_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" 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 sh_xpd_totl_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" 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 si_dst_02nd_20 (
"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" VARCHAR,
"yr1982" DOUBLE,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"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 si_dst_03rd_20 (
"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" VARCHAR,
"yr1982" DOUBLE,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"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 si_dst_04th_20 (
"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" VARCHAR,
"yr1982" DOUBLE,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"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.