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