Energy Trends (AEO Data)
Explore the Global Energy Landscape
@kaggle.thedevastator_explore_energy_trends_from_2008_2035_with_aeo201
Explore the Global Energy Landscape
@kaggle.thedevastator_explore_energy_trends_from_2008_2035_with_aeo201
CREATE TABLE n_1_aeo2011 (
"index" BIGINT,
"n_1_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_10_aeo2011 (
"index" BIGINT,
"n_10_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_100_aeo2011 (
"index" BIGINT,
"n_100_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_101_aeo2011 (
"index" BIGINT,
"n_101_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_11_aeo2011 (
"index" BIGINT,
"n_11_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_113_aeo2011 (
"index" BIGINT,
"n_113_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_114_aeo2011 (
"index" BIGINT,
"n_114_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_115_aeo2011 (
"index" BIGINT,
"n_115_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_12_aeo2011 (
"index" BIGINT,
"n_12_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_13_aeo2011 (
"index" BIGINT,
"n_13_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_139_aeo2011 (
"index" BIGINT,
"n_139_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_14_aeo2011 (
"index" BIGINT,
"n_14_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_140_aeo2011 (
"index" BIGINT,
"n_140_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_148_aeo2011 (
"index" BIGINT,
"n_148_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_15_aeo2011 (
"index" BIGINT,
"n_15_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_16_aeo2011 (
"index" BIGINT,
"n_16_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_17_aeo2011 (
"index" BIGINT,
"n_17_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_18_aeo2011 (
"index" BIGINT,
"n_18_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_19_aeo2011 (
"index" BIGINT,
"n_19_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_2_aeo2011 (
"index" BIGINT,
"n_2_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_20_aeo2011 (
"index" BIGINT,
"n_20_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_22_aeo2011 (
"index" BIGINT,
"n_22_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_24_aeo2011 (
"index" BIGINT,
"n_24_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_3_aeo2011 (
"index" BIGINT,
"n_3_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_30_aeo2011 (
"index" BIGINT,
"n_30_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_32_aeo2011 (
"index" BIGINT,
"n_32_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_34_aeo2011 (
"index" BIGINT,
"n_34_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_35_aeo2011 (
"index" BIGINT,
"n_35_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_36_aeo2011 (
"index" BIGINT,
"n_36_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_37_aeo2011 (
"index" BIGINT,
"n_37_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_38_aeo2011 (
"index" BIGINT,
"n_38_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_39_aeo2011 (
"index" BIGINT,
"n_39_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_4_aeo2011 (
"index" BIGINT,
"n_4_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_40_aeo2011 (
"index" BIGINT,
"n_40_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_41_aeo2011 (
"index" BIGINT,
"n_41_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_42_aeo2011 (
"index" BIGINT,
"n_42_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_43_aeo2011 (
"index" BIGINT,
"n_43_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_45_aeo2011 (
"index" BIGINT,
"n_45_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_46_aeo2011 (
"index" BIGINT,
"n_46_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_47_aeo2011 (
"index" BIGINT,
"n_47_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_48_aeo2011 (
"index" BIGINT,
"n_48_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_49_aeo2011 (
"index" BIGINT,
"n_49_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_5_aeo2011 (
"index" BIGINT,
"n_5_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_50_aeo2011 (
"index" BIGINT,
"n_50_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_51_aeo2011 (
"index" BIGINT,
"n_51_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_52_aeo2011 (
"index" BIGINT,
"n_52_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_53_aeo2011 (
"index" BIGINT,
"n_53_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_54_aeo2011 (
"index" BIGINT,
"n_54_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_55_aeo2011 (
"index" BIGINT,
"n_55_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_56_aeo2011 (
"index" BIGINT,
"n_56_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_57_aeo2011 (
"index" BIGINT,
"n_57_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_58_aeo2011 (
"index" BIGINT,
"n_58_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_6_aeo2011 (
"index" BIGINT,
"n_6_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_60_aeo2011 (
"index" BIGINT,
"n_60_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_62_aeo2011 (
"index" BIGINT,
"n_62_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_63_aeo2011 (
"index" BIGINT,
"n_63_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_64_aeo2011 (
"index" BIGINT,
"n_64_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_67_aeo2011 (
"index" BIGINT,
"n_67_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_68_aeo2011 (
"index" BIGINT,
"n_68_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_7_aeo2011 (
"index" BIGINT,
"n_7_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_70_aeo2011 (
"index" BIGINT,
"n_70_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_71_aeo2011 (
"index" BIGINT,
"n_71_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_72_aeo2011 (
"index" BIGINT,
"n_72_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_73_aeo2011 (
"index" BIGINT,
"n_73_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_76_aeo2011 (
"index" BIGINT,
"n_76_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_77_aeo2011 (
"index" BIGINT,
"n_77_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_78_aeo2011 (
"index" BIGINT,
"n_78_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_8_aeo2011 (
"index" BIGINT,
"n_8_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_9_aeo2011 (
"index" BIGINT,
"n_9_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_90_aeo2011 (
"index" BIGINT,
"n_90_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_94_aeo2011 (
"index" BIGINT,
"n_94_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_95_aeo2011 (
"index" BIGINT,
"n_95_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_96_aeo2011 (
"index" BIGINT,
"n_96_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_97_aeo2011 (
"index" BIGINT,
"n_97_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_98_aeo2011 (
"index" BIGINT,
"n_98_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE n_99_aeo2011 (
"index" BIGINT,
"n_99_aeo2011" VARCHAR,
"unnamed_1" VARCHAR,
"case" VARCHAR,
"region" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units_unless_otherwise_specified" VARCHAR,
"n_2008" VARCHAR,
"n_2009" VARCHAR,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE
);
CREATE TABLE aeo_2011_index (
"index" BIGINT,
"title" VARCHAR,
"row" BIGINT,
"quantity" VARCHAR,
"units" VARCHAR
);
Anyone who has the link will be able to view this.