National Economic and Demographic Development
Description
This data collects various economic and financial indicators from both the United Nations and the IMF. The countries table contains information on general population statistics as well as GDP statistics. The economic indicators table contains information such as the agricultural production index, consumer price index (indexed to 2010), unemployment rate, as well as the male labor force participation rate and the female labor force participation rate. The financial indicators table contains information about government budgets, including the amount of loans owed to foreign creditors, amount of loans owed to domestic creditors, total net worth of assets held by a government, as well as total pension payouts made by a government. The renewable energy table tracks investments into renewable energy by a government, measured in total amount of power generated organized by renewable energy source. All information from this dataset is taken from 2015 data collected by the United Nations and the International Monetary Fund. This dataset was constructed as part of a final course project for Data Management 6200.
Files
Steps to reproduce
Data was taken from the public UN data website https://data.un.org/. Sources used from this site were the population, density, and surface area sheet, GDP and GDP per capita sheet, labor force and unemployment sheet, consumer price indices sheet, and agricultural production indices sheet. Data taken from the IMF public data website, https://data.imf.org, included the Government Finance Statistics Balance Sheet, as well as the Renewable Energy Sheet. Data organization was done in MySQL Workbench, Data from the population and GDP tables were joined, grouped by year, and then filtered for data in the relevant time range. The economic indicators table was joined from the agricultural production index from the agricultural production indices table, as well as pivoted values from the unemployment and labor force table to extract total labor force participation rate, male labor force participation rate, and female labor force participation rate. Additionally, the consumer price index from the consumer price indices table was also joined to this table, filtering for exclusively rows in the consumer price indices table that referred to the general consumer price. The financial indicators table was pivoted to extract data from the GFS Balance Sheet, including net worth, domestic loans, foreign loans, and pension payouts. Information for this table was taken from the most recent available source of 2025. The renewable energy table was built from the energy source and observed value in the Renewable Energy IMF data. Data was exported and imported through the MySQL export and import wizard.
Institutions
- Wentworth Institute of TechnologyMassachusetts, Boston