Africa Development Indicators
Development data for 53 African countries
@worldbank.africa_development_indicators
Development data for 53 African countries
@worldbank.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.
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
);CREATE TABLE ic_exp_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" VARCHAR,
"yr2003" VARCHAR,
"yr2004" VARCHAR,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);CREATE TABLE ic_frm_acc_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_frm_age_yr (
"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" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE ic_frm_audit_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_frm_bnks_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_frm_comp_zs (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" VARCHAR,
"yr1964" VARCHAR,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"yr1967" VARCHAR,
"yr1968" VARCHAR,
"yr1969" VARCHAR,
"yr1970" VARCHAR,
"yr1971" VARCHAR,
"yr1972" VARCHAR,
"yr1973" VARCHAR,
"yr1974" VARCHAR,
"yr1975" VARCHAR,
"yr1976" VARCHAR,
"yr1977" VARCHAR,
"yr1978" VARCHAR,
"yr1979" VARCHAR,
"yr1980" VARCHAR,
"yr1981" VARCHAR,
"yr1982" VARCHAR,
"yr1983" VARCHAR,
"yr1984" VARCHAR,
"yr1985" VARCHAR,
"yr1986" VARCHAR,
"yr1987" VARCHAR,
"yr1988" VARCHAR,
"yr1989" VARCHAR,
"yr1990" 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_frm_corr_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_frm_cor_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_frm_cost_pc_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" DOUBLE
);CREATE TABLE ic_frm_crd_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_frm_crim_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_frm_crt_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_frm_cus_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_frm_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" VARCHAR,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" VARCHAR,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE ic_frm_elec_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_frm_email_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_frm_empl_perm (
"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_frm_empl_skill (
"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_frm_empl_temp (
"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_frm_empl_unskill (
"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_frm_exp_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_frm_femm_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" VARCHAR,
"yr2007" VARCHAR,
"yr2008" VARCHAR,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE ic_frm_femo_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_frm_femw_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_frm_fina_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
);Anyone who has the link will be able to view this.