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 ic_cns_loss_zs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cns_per_durs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cns_polc_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cns_taxad_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cns_taxr_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cns_trad_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cns_trsp_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_con_gift_zs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_crd_info_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" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);
CREATE TABLE ic_crd_lgl_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" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);
CREATE TABLE ic_crd_prvt_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" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);
CREATE TABLE ic_crd_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" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" VARCHAR,
"yr2003" VARCHAR,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);
CREATE TABLE ic_crd_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" VARCHAR,
"yr2006" VARCHAR,
"yr2007" VARCHAR,
"yr2008" VARCHAR,
"yr2009" VARCHAR,
"yr2010" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);
CREATE TABLE ic_cus_durs_ex (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_cus_durs_im (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_dmkt_brk_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_dmkt_loss_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_elc_durs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_elc_gen_zs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_elc_gift_zs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_elc_outg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" VARCHAR,
"yr2003" VARCHAR,
"yr2004" VARCHAR,
"yr2005" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" VARCHAR,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_elc_outg_hr (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" VARCHAR,
"yr1991" VARCHAR,
"yr1992" VARCHAR,
"yr1993" VARCHAR,
"yr1994" VARCHAR,
"yr1995" VARCHAR,
"yr1996" VARCHAR,
"yr1997" VARCHAR,
"yr1998" VARCHAR,
"yr1999" VARCHAR,
"yr2000" VARCHAR,
"yr2001" VARCHAR,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_empl_ftrng_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" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" VARCHAR,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE ic_exp_cost_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" DOUBLE
);
CREATE TABLE ic_exp_docs (
"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" DOUBLE
);
Anyone who has the link will be able to view this.