International Measures of Development

The International Measures of Development dataset provides a snapshot into the economic, demographic, and investment profiles of 70 countries from across the globe over the last 50 years. The included countries provide representation of all major geographic regions, while being diverse in their financial and social characteristics. The dataset contains a total of four tables, each representing a separate entity inherent to a country’s overall image. By placing all of these tables in one dataset, different aspects from various categories can be compared for different countries.

The first of which is the country table, which serves as the primary reference for the three other tables. Each record within this table represents one of the 70 countries which comprise the dataset. The attributes associated with this table include country ID, country name, continent, current population, and land area. The respective datatypes are of type VARCHAR and INT.

Secondly, the demographic table contains key quality of life indicators relevant to countries on an international scale. Each record in this table represents a given year for a given country, for a total of 3500 records. It contains the following 12 columns: demographic ID, country ID, year, life expectancy, population, birth rate, death rate, median age, percent married, sex ratio, child dependency, and old age dependency. Datatypes for this table are of type INT and DECIMAL.

Next, the economic table contains variables which represent the country’s financial and workforce profile. Like the demographic table, each record in this table represents a given year for a given country for a total of 3500 records. It contains the following 8 columns: economic ID, country ID, year, GDP, GDP per capita, inflation, unemployment rate, and GNI. Datatypes for this table are of type INT and DECIMAL.

Lastly, the investment table captures a country’s investing landscape. It features the same structure as the other two tables. The 12 contained columns include investment ID, country ID, year, inflow FDI, outflow FDI, investments in energy, ICT, transportation, and water, non-financial asset investment, portfolio investment, and net financial account. Datatypes for this table are of type INT and DECIMAL.