International Comparison Program (ICP) 2017
Global price level comparison for 2017
@worldbank.icp_2017
Global price level comparison for 2017
@worldbank.icp_2017
Results from the International Comparison Program (ICP) 2017 cycle include data for the new reference year 2017, revised data for the previous reference year 2011, and annual purchasing power parities (PPPs) for 2012 to 2016. 2017 results are available for 176 participating economies and their aggregate regions. They cover 44 expenditure headings and provide several indicators for each heading, including PPPs, national accounts expenditures in PPP and nominal terms, and price level indices. Imputed results are available for an additional 12 economies that did not participate in the ICP 2017 cycle. Revised 2011 results are available for 179 participating economies and cover 44 expenditure headings and several indicators, including PPPs, national accounts expenditures in PPP and nominal terms, and price level indices. Additionally, partial results are available for 20 Pacific islands, while imputed results are available for 15 economies that did not participate in the ICP 2011 cycle. Annual PPPs are available for 2011 to 2017 and cover 6 major expenditure headings.
CREATE TABLE n_1400000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1500000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1501000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE,
"yr2013" DOUBLE,
"yr2014" DOUBLE,
"yr2015" DOUBLE,
"yr2016" DOUBLE,
"yr2017" DOUBLE
);CREATE TABLE n_1501100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1501200 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1501300 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1502000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1503000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1600000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9020000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE,
"yr2013" DOUBLE,
"yr2014" DOUBLE,
"yr2015" DOUBLE,
"yr2016" DOUBLE,
"yr2017" DOUBLE
);CREATE TABLE n_9060000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9080000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9100000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE,
"yr2013" DOUBLE,
"yr2014" DOUBLE,
"yr2015" DOUBLE,
"yr2016" DOUBLE,
"yr2017" DOUBLE
);CREATE TABLE n_9110000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9120000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9140000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9250000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE,
"yr2013" DOUBLE,
"yr2014" DOUBLE,
"yr2015" DOUBLE,
"yr2016" DOUBLE,
"yr2017" DOUBLE
);CREATE TABLE n_9260000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_9270000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE,
"yr2013" DOUBLE,
"yr2014" DOUBLE,
"yr2015" DOUBLE,
"yr2016" DOUBLE,
"yr2017" DOUBLE
);Anyone who has the link will be able to view this.