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 ag_sed_sgm_mt (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_sed_wht_mt (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_srf_totl_ha (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_srf_totl_k2 (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_bly_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_crel_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_fno_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_mlt_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_mze_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_rice_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_sgm_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 ag_yld_wht_kg (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bg_gsr_nfsv_gd_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" VARCHAR
);
CREATE TABLE bm_ag_agr_trac_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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" VARCHAR,
"yr2009" VARCHAR,
"yr2010" VARCHAR,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE bm_ag_agr_trac_no (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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" VARCHAR,
"yr2009" VARCHAR,
"yr2010" VARCHAR,
"yr2011" VARCHAR,
"yr2012" VARCHAR
);
CREATE TABLE bm_ag_crel_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bm_ag_crel_mt (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bm_ag_frst_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bm_ag_hz_pest_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" VARCHAR,
"yr2006" VARCHAR,
"yr2007" DOUBLE,
"yr2008" DOUBLE,
"yr2009" DOUBLE,
"yr2010" DOUBLE,
"yr2011" DOUBLE,
"yr2012" VARCHAR
);
CREATE TABLE bm_ag_pest_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bm_fod_agri_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bm_gsr_agri_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"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 bm_gsr_fcty_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" VARCHAR
);
CREATE TABLE bm_gsr_fxai_cd (
"economy" VARCHAR,
"yr1960" VARCHAR,
"yr1961" VARCHAR,
"yr1962" VARCHAR,
"yr1963" DOUBLE,
"yr1964" DOUBLE,
"yr1965" VARCHAR,
"yr1966" VARCHAR,
"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 bm_gsr_gnfs_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" VARCHAR
);
Anyone who has the link will be able to view this.