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_1000000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" DOUBLE,
"yr2013" DOUBLE,
"yr2014" DOUBLE,
"yr2015" DOUBLE,
"yr2016" DOUBLE,
"yr2017" DOUBLE
);CREATE TABLE n_1101000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101110 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101120 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101130 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101140 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101150 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101160 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101170 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101180 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101190 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1101200 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1102000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1102100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1102200 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1103000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1105000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1107000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1107100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1107300 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1108000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1111000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1113000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);CREATE TABLE n_1300000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2011" DOUBLE,
"yr2012" VARCHAR,
"yr2013" VARCHAR,
"yr2014" VARCHAR,
"yr2015" VARCHAR,
"yr2016" VARCHAR,
"yr2017" DOUBLE
);Anyone who has the link will be able to view this.