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 sp_pop_3539_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_3539_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_4044_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_4044_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_4549_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_4549_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_5054_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_5054_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_5559_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_5559_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_6064_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_6064_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_6569_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_6569_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_65up_fe_in (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_65up_fe_zs (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_65up_ma_in (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_65up_ma_zs (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_65up_to (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_65up_to_zs (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_7074_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_7074_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_7579_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_7579_ma_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);CREATE TABLE sp_pop_80up_fe_5y (
"economy" VARCHAR,
"yr1960" DOUBLE,
"yr1961" DOUBLE,
"yr1962" DOUBLE,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" DOUBLE,
"yr1966" DOUBLE,
"yr1967" DOUBLE,
"yr1968" DOUBLE,
"yr1969" DOUBLE,
"yr1970" DOUBLE,
"yr1971" DOUBLE,
"yr1972" DOUBLE,
"yr1973" DOUBLE,
"yr1974" DOUBLE,
"yr1975" DOUBLE,
"yr1976" DOUBLE,
"yr1977" DOUBLE,
"yr1978" DOUBLE,
"yr1979" DOUBLE,
"yr1980" DOUBLE,
"yr1981" DOUBLE,
"yr1982" DOUBLE,
"yr1983" DOUBLE,
"yr1984" DOUBLE,
"yr1985" DOUBLE,
"yr1986" DOUBLE,
"yr1987" DOUBLE,
"yr1988" DOUBLE,
"yr1989" DOUBLE,
"yr1990" DOUBLE,
"yr1991" DOUBLE,
"yr1992" DOUBLE,
"yr1993" DOUBLE,
"yr1994" DOUBLE,
"yr1995" DOUBLE,
"yr1996" DOUBLE,
"yr1997" DOUBLE,
"yr1998" DOUBLE,
"yr1999" DOUBLE,
"yr2000" DOUBLE,
"yr2001" DOUBLE,
"yr2002" DOUBLE,
"yr2003" DOUBLE,
"yr2004" DOUBLE,
"yr2005" DOUBLE,
"yr2006" DOUBLE,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);Anyone who has the link will be able to view this.