search

igpmn / gees

Global Economy Equilibrium Scenario Builder
6 stars 1 forks source link

Data for China Demography scenario #2

Open jaromir-benes opened 8 months ago

jaromir-benes commented 8 months ago

United Nations World Population Prospects

ILO

ljubicabor commented 8 months ago

There is an API available for the UN data https://population.un.org/dataportal/about/dataapi https://population.un.org/dataportalapi/index.html

It is possible to use this API, I have created a small python script as a proof of concept, but it needs to be improved further with more filters. There are no groupings so we would need to download data for all the EA countries and calculate what we need.

Q: For the population data, in the scenario description it mentions population 25-64, is this what we need to extract or total population?

ILO also has an API https://ilostat.ilo.org/resources/sdmx-tools/ Explanation refers to SDMX user group, so I don't have some clear examples for this particular case. I would need more time to figure out how it works. In the meantime I downloaded most recent data manually, but there are no data for China there (only 2010, the other data are for Hong Kong, Taiwan and Macau)

ljubicabor commented 8 months ago

population_resize.xlsx Population and labor participation rate data downloaded manually for now (until API is finished). I followed the calculation from previous update, but I included Croatia (although small) in the EA and India is added as a separate country.