Income Classifications (World Bank, 2022)
@owid.income_groups
@owid.income_groups
CREATE TABLE owid_income_groups_1 (
"country" VARCHAR,
"year" INTEGER,
"classification" VARCHAR
);
CREATE TABLE owid_income_groups_2 (
"country" VARCHAR,
"year" INTEGER,
"classification" VARCHAR
);
CREATE TABLE owid_income_groups_3 (
"country" VARCHAR,
"year" INTEGER,
"classification" VARCHAR,
"classification_low_income_countries_count" INTEGER,
"classification_lower_middle_income_countries_count" INTEGER,
"classification_upper_middle_income_countries_count" INTEGER,
"classification_high_income_countries_count" INTEGER,
"classification_low_income_countries_pop" UINTEGER,
"classification_lower_middle_income_countries_pop" UINTEGER,
"classification_upper_middle_income_countries_pop" UINTEGER,
"classification_high_income_countries_pop" UINTEGER,
"classification_missing_pop" INTEGER
);
CREATE TABLE owid_income_groups_latest_1 (
"country" VARCHAR,
"classification" VARCHAR
);
CREATE TABLE owid_income_groups_latest_2 (
"country" VARCHAR,
"classification" VARCHAR
);
CREATE TABLE owid_income_groups_latest_3 (
"country" VARCHAR,
"index" INTEGER,
"classification" VARCHAR
);
Anyone who has the link will be able to view this.