Structure Of National Consumption A Satellite Variables A beginning #9

13 March 2015

Exploring the structure of national consumption

This entry is a direct continuation of my:

  1. entry
  2. entry
  3. entry
  4. entry
  5. entry
  6. entry
  7. entry
  8. entry

In the category of “national consumption structure”

Satellite variables

Today I will work on associating so called satellite variables (varaibles external to the input-output derived products) for some of the hypothesis explored in this entry.

Notably - demography (proportion of populatoin able to take up work) - resource endowments (e.g. ore deposits or land use types) - economy (structure).

We will see if I get to associating these variables with the Eora dataset.

Demography

The UN World Population Prospects (WPP) is the most obvious source. The latest dataset is the “2012 revision”. Find publications relatig to the WPP 2012 revision, here.

Excel data, including “Population by Age Groups - Both Sexes”, can be found here.

The WPP also operate with various dependency ratios describing the proportion of the population that can take up work divide by the population unable to take up work (i.e. people in the youngest and oldest ages classes, varying from 0-14 over 0-19 to 0-24 and 65? to 70?). Instead of downloading these data separately I think it makes more sense to calculate them on the go using just the single spreadsheet of the age distriubtion (for both sexes or in some cases for men and women, respectively - i.e. downloading both sexes as well as men and women).

The dependency ratios calculated by the WPP are the following:

  1. Total dependency ratio (young + old) / potential workforce
  2. Child dependency ratio young / potential workforce
  3. Old-age dependency ratio old / potential workforce
  4. Potential support ratio potential workforce / old - inverse of old-age dependenccy ratio.

In addition to the WPP the UN DESA also calculates Probabilistic Population Projections (PPP) - see publications here . Note, there is an R package:

install.packages("BayesTFR")

Migration

I am also downloading some migration data for later use - data files, here.

Aggregated country groups

Here is the link to data aggregated for various

  1. economic and trading groups
  2. political groups
  3. UN groups
  4. ecological groups
  5. geographical groups

The downloaded demographic data is here:

setwd("G:/Documents/PostDocKVA/Data/WPP");dir()
## [1] "WPP2012_MIGR_F01_NET_MIGRATION_RATE.XLS"           
## [2] "WPP2012_MIGR_F02_NET_NUMBER_OF_MIGRANTS.XLS"       
## [3] "WPP2012_POP_F07_1_POPULATION_BY_AGE_BOTH_SEXES.csv"
## [4] "WPP2012_POP_F07_1_POPULATION_BY_AGE_BOTH_SEXES.XLS"
## [5] "WPP2012_POP_F07_2_POPULATION_BY_AGE_MALE.XLS"      
## [6] "WPP2012_POP_F07_3_POPULATION_BY_AGE_FEMALE.XLS"

Economy structure

Main aggregates

UN Statistical division - national accounts and their main aggregates.

Here is a quick overview of changes to the System of National Accounts from 1947 to 2008.

Guide to the main aggregates

Resolution (temporal): Annual

Resolution (spatial): National

Extent (temporal): 1970 - 2013

Extent (spatial): 220 economies

Variables (17)

By type of expenditure (see example with Denmark here)

  • Final consumption expenditure
    • Final consumption expenditure consists of houshold final consumption expenditure, government final consumption expenditure and final consumption expenditure of NPISH’s.
    • final = household + government
  • Household consumption expenditure (including Non-profit institutions serving households)
    • Household final consumption expenditure consists of the expenditure, including imputed expenditure, incurred by resident households on individual consumption goods and services, including those sold at prices that are not economically significant.

  • General government final consumption expenditure

  • Gross capital formation

  • Gross fixed capital formation (including Acquisitions less disposals of valuables)

  • Changes in inventories

  • Exports of goods and services

  • Imports of goods and services

  • Gross Domestic Product (GDP)
    • Total expen

By type of activity

  • Agriculture, hunting, forestry, fishing (ISIC A-B)
    • Primary (Kuznets)
  • Mining, Manufacturing, Utilities (ISIC C-E)
    • Primary (Kuznets)
  • Manufacturing (ISIC D)
    • Secondary (Kuznets)
  • Construction (ISIC F)
    • Secondary (Kuznets)
  • Wholesale, retail trade, restaurants and hotels (ISIC G-H)
    • Tertiary (Kuznets)
  • Transport, storage and communication (ISIC I)
    • Tertiary (Kuznets)
  • Other Activities (ISIC J-P)
    • Other activities constitute the aggregation of economic activities of
      • Section J Financial intermediation,

      • Section K Real estate, renting and business activities,

      • Section L Public administration and defence, compulsory social security,
      • Section M Education,
      • Section N Health and social work,

      • Section O Other community, social and personal service activities and

      • Section P Activities of private households as employers and undifferentiated production activities of private households (see ISIC Rev 3.1).

  • Total Value Added
    • Sum of all activities

The downloaded data is here:

setwd("G:/Documents/PostDocKVA/Data/UNSD/gdp_structure");dir()
##  [1] "Download-GDPconstant-USD-all.xls"                          
##  [2] "Download-GDPconstant-USD-countries.csv"                    
##  [3] "Download-GDPconstant-USD-countries.xls"                    
##  [4] "Download-GDPconstant-USD-regions.xls"                      
##  [5] "Download-GDPcurrent-NCU-countries.xls"                     
##  [6] "Download-GDPcurrent-USD-all.xls"                           
##  [7] "Download-GDPcurrent-USD-countries.xls"                     
##  [8] "Download-GDPcurrent-USD-regions.xls"                       
##  [9] "Download-Shares-countries.xls"                             
## [10] "SeqAccts.xls"                                              
## [11] "Table2p2_VA_indusries_rev3_constant_national_1946_1985.csv"
## [12] "Table2p2_VA_indusries_rev3_constant_national_1986_1995.csv"
## [13] "Table2p2_VA_indusries_rev3_constant_national_1996_2001.csv"
## [14] "Table2p2_VA_indusries_rev3_constant_national_2002_2007.csv"
## [15] "Table2p2_VA_indusries_rev3_constant_national_2008_2013.csv"
## [16] "Table2p5_VA_industries_constant_national.csv"              
## [17] "UNdata_Export_20150313_121105553"

Use “Download-GDPconstant-USD-countries.xls”

Main aggregates and detailed tables

Yearbook publications can be downloaded, here.

Constant price in national currency (1970-2013) - downloaded, here - following (following ISIC v. rev. 4).

File: “Table2p5_VA_industries_constant_national.csv”

SNA version 1993

Sector designations as noted in Kenessey 2005 Review of income and wealth

  • Agriculture, forestry and fishing A

    • Crop and animal production, hunting and related service activities 1
      • primary
    • Forestry and logging 2
      • primary
    • Fishing and aquaculture 3
      • primary

  • Manufacturing, mining and quarrying and other industrial activities B+C+D+E

    • Mining and quarrying B
      • primary
    • Manufacturing C
      • secondary
    • Electricity, gas, steam and air conditioning supply D
      • tertiary
    • Water supply; sewerage, waste management and remediation activities E
      • tertiary
  • Construction F
    • secondary

  • Wholesale and retail trade, transportation and storage, accommodation and food service activities G+H+I

    • Wholesale and retail trade; repair of motor vehicles and motorcycles G
      • tertiary
    • Transportation and storage H
      • tertiary
    • Accommodation and food service activities I
      • quarternary (services)
  • Information and communication J
    • quarternary (services)
  • Financial and insurance activities K
    • quarternary
  • Real estate activities L
    • quarternary

  • Professional, scientific, technical, administrative and support service activities M+N

    • Professional, scientific and technical activities M
      • quarternary (services)
    • Administrative and support service activities N
      • quarternary (services)

  • Public administration and defence, education, human health and social work activities O+P+Q

    • Public administration and defence; compulsory social security O
      • quarternary
    • Education P
      • quarternary (services)
    • Human health and social work activities Q
      • quarternary (services)

  • Other service activities R+S+T

    • Arts, entertainment and recreation R
      • quarternary (services)
    • Other service activities S
      • quarternary (services)
    • Private households with employed persons T
      • quarternary (services)

  • Equals: VALUE ADDED, GROSS, at basic prices B.1g

  • Less: Financial intermediation services indirectly measured (FISIM) P.119

  • Plus: Taxes less Subsidies on products D.21-D.31
    • Plus: Taxes on products D.21
    • Less: Subsidies on products D.31

  • Equals: GROSS DOMESTIC PRODUCT B.1*g

  • Plus: Statistical discrepancy

  • Memorandum Item: FISIM, if distributed to uses P.119

Variables for intensity study

Governance

World bank - worldwide governance indicators

Data source - link

Resolution (temporal): Annual

Resolution (spatial): National

Extent (temporal): 1996 - 2013

Extent (spatial): 215 countries

Variables (6):

  • Control of corruption
  • Government effectiveness
  • Political stability and absence of violence
  • Regulatory quality
  • Rule of law
  • Voice and Accountability

Variable definitions

  • Control of corruption
    • Control of Corruption captures perceptions of the extent to which public power is exercised for private gain, including both petty and grand forms of corruption, as well as capture" of the state by elites and private interests. Estimate gives the country’s score on the aggregate indicator
  • Government effectiveness
    • Government Effectiveness captures perceptions of the quality of public services, the quality of the civil service and the degree of its independence from political pressures, the quality of policy formulation and implementation, and the credibility of the government’s commitment to such policies. Estimate gives the country’s score on the aggregate indicator, in units of a standard normal distribution, i.e. ranging from approximately -2.5 to 2.5.
  • Political stability and absence of violence
    • Political Stability and Absence of Violence/Terrorism captures perceptions of the likelihood that the government will be destabilized or overthrown by unconstitutional or violent means, including politically-motivated violence and terrorism. Estimate gives the country’s score on the aggregate indicator, in units of a standard normal distribution, i.e. ranging from approximately -2.5 to 2.5.
  • Regulatory quality
    • Regulatory Quality captures perceptions of the ability of the government to formulate and implement sound policies and regulations that permit and promote private sector development. Estimate gives the country’s score on the aggregate indicator, in units of a standard normal distribution, i.e. ranging from approximately -2.5 to 2.5.
  • Rule of law
    • Rule of Law captures perceptions of the extent to which agents have confidence in and abide by the rules of society, and in particular the quality of contract enforcement, property rights, the police, and the courts, as well as the likelihood of crime and violence. Estimate gives the country’s score on the aggregate indicator, in units of a standard normal distribution, i.e. ranging from approximately -2.5 to 2.5.
  • Voice and Accountability
    • Voice and Accountability captures perceptions of the extent to which a country’s citizens are able to participate in selecting their government, as well as freedom of expression, freedom of association, and a free media. Estimate gives the country’s score on the aggregate indicator, in units of a standard normal distribution, i.e. ranging from approximately -2.5 to 2.5.

Dataset source - description

  • Detailed documentation of the WGI, interactive tools for exploring the data, and full access to the underlying source data available at www.govindicators.org.The WGI are produced by Daniel Kaufmann (Brookings Institution), Aart Kraay (World Bank Development Research Group) and Massimo Mastruzzi (World Bank Institute). Please cite Kaufmann, Daniel, Aart Kraay and Massimo Mastruzzi (2010). The Worldwide Governance Indicators: Methodology and Analytical Issues“. World Bank Policy Research Working Paper No. 5430 (http://papers.ssrn.com/sol3/papers.cfm?abstract_id=1682130). The WGI do not reflect the official views of Brookings Institution, the World Bank, its Executive Directors, or the countries they represent.

The downloaded data is here:

setwd("G:/Documents/PostDocKVA/Data/WorldBank/WWideGovernanceInd");dir()
## [1] "WorldWideGovernanceIndicators_1996_2013.csv"                      
## [2] "WorldWideGovernanceIndicators_1996_2013_Definition and Source.csv"

Poverty and Equity Database

World bank - poverty and equity database

Latest poverty and inequality indicators compiled from officially recognized international sources. Poverty indicators include the poverty headcount ratio, poverty gap, and number of poor at both international and national poverty lines. Inequality indicators include the Gini index and income or consumption distributions. The database includes national, regional and global estimates.

This database is maintained by the Gloabl Poverty Working Group (GPWG), a team of poverty measurement experts from the Poverty Reduction and Equity Network, the Development Research Group, and the Development Data Group.

Data source - link

Resolution (temporal): Annual

Resolution (spatial): National

Extent (temporal): 1974 - 2013

Extent (spatial): 170 economies

Variable groups (6):

  • Health: Population: Structure
  • Poverty: Income distribution
  • Poverty: Poverty rates
  • Poverty: Shared prosperity

Variable list (40)

  • Health: Population: Structure
    • Population, total
  • Poverty: Income distribution
    • GINI index (World Bank estimate)
    • Income share held by fourth 20%
    • Income share held by highest 10%
    • Income share held by highest 20%
    • Income share held by lowest 10%
    • Income share held by lowest 20%
    • Income share held by second 20%
    • Income share held by third 20%
  • Poverty: Poverty rates
    • Number of poor at $1.25 a day (PPP) (millions)
    • Number of poor at $2 a day (PPP) (millions)
    • Number of poor at $2.5 a day (PPP) (millions)
    • Number of poor at $4 a day (PPP) (millions)
    • Number of poor at $5 a day (PPP) (millions)
    • Poverty gap at $1.25 a day (PPP) (%)
    • Poverty gap at $2 a day (PPP) (%)
    • Poverty gap at $2.5 a day (PPP) (%)
    • Poverty gap at $4 a day (PPP) (%)
    • Poverty gap at $5 a day (PPP) (%)
    • Poverty gap at national poverty lines (%)
    • Poverty gap at national poverty lines (%), including noncomparable values
    • Poverty headcount ratio at $1.25 a day (PPP) (% of population)
    • Poverty headcount ratio at $2 a day (PPP) (% of population)
    • Poverty headcount ratio at $2.5 a day (PPP) (% of population)
    • Poverty headcount ratio at $4 a day (PPP) (% of population)
    • Poverty headcount ratio at $5 a day (PPP) (% of population)
    • Poverty headcount ratio at national poverty lines (% of population)
    • Poverty headcount ratio at national poverty lines (% of population), including noncomparable values
    • Rural poverty gap at national poverty lines (%)
    • Rural poverty gap at national poverty lines (%), including noncomparable values
    • Rural poverty headcount ratio at national poverty lines (% of rural population)
    • Rural poverty headcount ratio at national poverty lines (% of rural population), including noncomparable values
    • Urban poverty gap at national poverty lines (%)
    • Urban poverty gap at national poverty lines (%), including noncomparable values
    • Urban poverty headcount ratio at national poverty lines (% of urban population)
    • Urban poverty headcount ratio at national poverty lines (% of urban population), including noncomparable values
  • Poverty: Shared prosperity
    • Annualized average growth rate in per capita real survey mean consumption or income, bottom 40% of population (%, based on 2005 PPP)
    • Annualized average growth rate in per capita real survey mean consumption or income, total population (%, based on 2005 PPP)
    • Survey mean consumption or income per capita, bottom 40% of population (2005 PPP $ per day)
    • Survey mean consumption or income per capita, total population (2005 PPP $ per day)

The downloaded data is here:

setwd("G:/Documents/PostDocKVA/Data/WorldBank/PovertyEquityDB");dir()
## [1] "Poverty-Country-Series.csv" "Poverty-Country.csv"       
## [3] "Poverty-Data.csv"           "Poverty-FootNote.csv"      
## [5] "Poverty-Series.csv"

——————-

References

None

blog comments powered by Disqus