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 eg_elc_coal_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_hyro_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_hyro_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_loss_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_ngas_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_ngas_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_nucl_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_nucl_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_petr_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_petr_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_elc_prod_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_gdp_puse_ko_pp (
"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" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_gdp_puse_ko_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_imp_cons_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_imp_totl_kt_oe (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_comm_cl_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_comm_fo_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_comm_kt_oe (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_crnw_kt_oe (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_crnw_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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_elec_kh (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_elec_kh_pc (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE eg_use_pcap_kg_oe (
"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" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE en_agr_empl (
"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" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" DOUBLE
);
Anyone who has the link will be able to view this.