International Comparison Program (ICP) 2017
Global price level comparison for 2017
@worldbank.icp_2017
Global price level comparison for 2017
@worldbank.icp_2017
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.