International Comparison Program (ICP) 2021
Global price level comparison for 2021
@worldbank.icp_2021
Global price level comparison for 2021
@worldbank.icp_2021
CREATE TABLE n_1000000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" DOUBLE
);
CREATE TABLE n_1101000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101110 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101120 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101130 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101140 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101150 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101160 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101170 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101180 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101190 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1101200 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1102000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1102100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1102200 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1103000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1105000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1107000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1107100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1107300 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1108000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1111000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1113000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1300000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1400000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1500000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1501000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1501100 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1501200 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1501300 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1502000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1503000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_1600000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9020000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9060000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9080000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9100000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9110000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9120000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9140000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9250000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9260000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9270000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
CREATE TABLE n_9280000 (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" DOUBLE,
"yr2023" VARCHAR
);
Anyone who has the link will be able to view this.