International Comparison Program (ICP) 2021
Global price level comparison for 2021
@worldbank.icp_2021
Global price level comparison for 2021
@worldbank.icp_2021
The ICP 2021 (IC2) dataset provides the latest global price levels and purchasing power parity data, offering insights into the economic conditions and cost of living in 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.