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
);Anyone who has the link will be able to view this.