SELECT "economy", CAST(TRIM(LEADING 'yr' FROM population_t."year") AS INT) "data_year", "population"
FROM (
UNPIVOT @worldbank.world_development_indicators.sp_pop_totl
ON COLUMNS (* EXCLUDE "economy")
INTO
NAME "year"
VALUE "population"
) population_t
INNER JOIN @kaggle.joebeachcapital_world_bank_country_profile.worldbank_country_profile
ON "economy" = "country_code"
WHERE "data_year" > 2000
Results limited to the first 500 rows.
economy | data_year | population |
---|---|---|
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VIR | 2023 | 104917 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |
VNM | 2023 | 100352192 |