Linking International Macro and Micro Data - The Basics

Unit 1

Celia Russell ESDS International, MIMAS, The University of Manchester

Objectives

• Understand the basic conceptual differences between aggregate and survey data • Understand how international data is produced and disseminated, and the role of ESDS International • Know more about the organisations that produce the international databanks • Outline the content of the major international aggregate databases • Access, subset and chart data from the World Development Indicators • Outline the content of the major international survey datasets

Survey data

• Micro or survey data are data on individuals. This may be an individual person, or household or company. • For example, in a census every household fills in a form with the name and age of everyone in the house. These individual responses are collected together into one giant survey dataset.

• Often survey data is anonymised before released. This means that some details are removed to protect the identity of the respondent

Survey data in SPSS (data view)

This row represents a person This variable gives the age of each person in the file So does this one

SPSS (variable view)

These are names, descriptive labels and technical information for the variables we saw in data view.

This box of value labels tells us what each value in the “ occat80 ” is useless.

variable represents. Without some way of knowing what the numbers represent, the data

Aggregate or macro data

Macro

or

aggregated

• Data about populations, groups, regions or countries. Example of aggregate indicators are life expectancy or employment rates. data are: • Data that have been averaged, totaled or otherwise derived from the individual level data found in the survey datasets. Most of the aggregate data we are going to talk about now is data about countries.

Aggregate data are usually time series data, with repeated observations of the same indicator for the same country at regular intervals.

Other types of data

• Other types of database used in the social sciences include: • longitudinal or panel • qualitative • mesodata

Example longitudinal data: The British Cohort Study

• Following the lives of the 17,000 babies born in the UK between 5th and 11th April 1970 • In year zero used clinical records and talked to mother and midwife about the birth • At ages 5, 10 and 16 talked to class teachers and parents and carried out medical tests • At 26, 29 and 32 interviewed subjects about their work, relationships, health, family, politics and values • The anonymised data can be used to follow individual life courses

Aggregate data sources

Inter-governmental organisations (IGOs) such as the International Monetary Fund and World Bank are the primary actors in the collection and dissemination of international aggregate data The UK is unique in that through ESDS International, the UK academic community has free web-based access to the major databanks produced by the IMF, World Bank and other major international governmental organisations.

ESDS International

• Provides the UK academic community with free web based access to a range of key international macro databanks produced by organisations such as the United Nations, OECD and World Bank • Helps users to locate and acquire international micro level datasets • Promotes the use of international datasets in research and teaching across a range of disciplines • Is led by MIMAS at the Manchester University

International data providers

The databanks originate from: • International Monetary Fund (IMF) • Organisation for Economic Cooperation and Development (OECD) • United Nations (UN) • World Bank • Eurostat • International Labour Organisation (ILO) • UK Office for National Statistics • International Energy Agency

International data themes

Databanks cover:

• economic performance and development • trade, industry and markets • employment • demography, migration and health • governance • human development • social expenditure • education • science and technology • land use and the environment • energy

Aggregate data portfolio …

International Monetary Fund

Direction of Trade Statistics Balance of Payments Statistics Government Finance Statistics International Financial Statistics

World Bank

World Development Indicators World Bank Global Development Finance

International Labour Organisation

Key Indicators of the Labour Market

United Nations

Common Database

United Nations Industrial Development Organization

Industrial Statistics Databases Demand Supply Databases ESDS International provides free online access to the full versions of the latest releases of these databases to the UK academic community.

Aggregate data portfolio (cont)

Organisation for Economic Co-operation and Development

Main Economic Indicators International Development International Direct Investment Statistics International Migration Statistics Main Economic Indicators Main Science and Technology Indicators Measuring Globalisation Quarterly Labour Force Statistics Services Statistics International Trade by Commodities Social Expenditure Database

Eurostat

New Cronos

International Energy Agency

Coal Information CO2 Emissions from Fuel Combustion Electricity information Energy Prices and Taxes Energy Technology Research and Development Database Natural Gas Information Oil Information Renewables Information World Energy Statistics and Balances

ESDS International provides free online access to the full versions of these databases to the UK academic community.

Usage by Database, Sept 2006

1800 1600 1400 1200 1000 800 600 400 200 0 IL O N at S ta t E ur os ta t IE A U N C D B U ni do O E C D IM F W or ld B an k

Accessing the Data

• Freely available to UK FE and HE • Access via federated access management user authentication and ESDS online registration • Special Conditions may also apply • Delivered over the web via Beyond 20/20 Web Data Server (WDS) • Download formats include *.xls, *.csv and *.ivt

World Bank Databases

• Collects data on all aspects of human development worldwide • Annual data, designed for international comparability • •

World Development Indicators Global Development Finance

World Development Indicators

•

Global database covers 190

• •

countries Annual data starting 1960 Widely cited The World Development Indicators provides a broad picture of poverty trends and social welfare, the use of environmental resources, the performance of the public sector, and the integration of the global economy.

Example from the World Development Indicators

Global Urbanisation Source: World Bank World Development Indicators 2005

100 75 50 25 0 19601962196419661968197019721974197619781980198219841986198819901992199419961998200020022004 Hong Kong Macao South Korea.

Malaysia World Thailand Bhutan

Global Development Finance

• Global Development Finance is the World Bank ’ s annual review of financial flows to developing countries. It also contains the Bank's projections for debt repayments etc for next ten years • Only covers developing countries • Annual data starting 1970 ’ s

Example from the Global Development Finance

Worker's Remittances Source: Global Development Finance (April 2005)

20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 India Mexico Philippines China Pakistan El Salvador 19 70 19 72 19 74 19 76 19 78 19 80 19 82 19 84 19 86 19 88 19 90 19 92 19 94 19 96 19 98 20 00 20 02

IMF databanks

• • • •

International Financial Statistics Government Finance Statistics Balance of Payments Statistics Direction of Trade

The four major databanks produced by the IMF contain data on national accounts, trade, the balance of payments and government spending for around 190 countries. Collectively, they provide a global picture of economic development and international trade over the last 50 years.

IMF International Financial Statistics

• is published monthly since 1948 and

updated monthly

• is the IMF’s principal statistical publication and is the standard source for all aspects of international and domestic finance. • covers over 200 countries • reports time series data on exchange rates, balance of payments, international liquidity, money and banking, interest rates, prices, production, international transactions, government accounts, national accounts and population • Has 3 sections: world tables, country tables and commodity prices

IMF Direction of Trade

• Contains data on the value of merchandise exports and imports between each country and all its trading partners • Covers 186 countries and 12 regional groups • Monthly, quarterly and annual data are presented • most countries’ data extend from the 1980’s to the present • the IMF release pre-1980 Direction of Trade data as a separate database, (also available through ESDS International) • The database is updated monthly

IMF Balance of Payments Statistics

• 175 countries worldwide • Time series data covering the standard balance of payment components and international investment positions of countries worldwide • Quarterly and annual time series data. When the data are available • Where available, most countries ’ 1970 ’ s to the present data extend from

IMF Government Finance Statistics

• Covers data government income (such as tax and bonds) and expenditure by sector (defence, education, health, etc) for all levels of government (national, state, local) • 149 countries worldwide • Annual time series data. Annual entries generally begin in 1990 and run to the latest available year • Pre 1990 data is released as a separate database • Updated quarterly

IMF databanks

Iraqi Trade with Rest of World Source: IMF Direction of Trade, January 2006

7000 6000 5000 Exports Imports 4000 3000 2000 1000 0 19 81 Q 1 19 83 Q 1 19 85 Q 1 19 87 Q 1 19 89 Q 1 19 91 Q 1 19 93 Q 1 19 95 Q 1 19 97 Q 1 19 99 Q 1 20 01 Q 1 20 03 Q 1 20 05 Q 1

Hands on activities

OK, let’s try some hands-on!

www.esds.ac.uk/international

The prototype materials are located at:

www.mimas.ac.uk/limmd/workshop

Organisation for Economic Cooperation and Development (OECD) databases

• Agriculture • Banking Statistics (formerly Bank Profitability) • Economic Outlook: Statistics and Projections • Education Statistics (formerly Education at a Glance) • Employment and Labour Market Statistics • Globalisation • ITCS International Trade by Commodity • Indicators of Industry and Services • Institutional Investors • Insurance • International Development • International Direct Investment • International Migration • International Trade and Competitiveness

Organisation for Economic Cooperation and Development (OECD) databases 2

• Main Economic Indicators • Monthly International Trade • National Accounts • OECD Health Data • Revenue .

• STAN Structural Analysis • Science, Technology and R & D • Services • Social Expenditure • Statistical Compendium • Structural and Demographic Business Statistics (formerly Structural Statistics for Industry and Services) • Taxing Wages • Telecommunications and Internet

OECD International Development Statistics

Net US Development Assistance to the Middle East

OECD, International Development Statistics, October 2006, ESDS International, (MIMAS) University of Manchester

International Energy Agency

• Databases cover around 130 countries • The majority of the IEA datasets contain annual time series data from 1960 onwards • Updated annually except for Energy Prices and Taxes which is updated quarterly • Cover energy production, trade, stocks, transformation, consumption, prices and taxes

IEA databanks I

• CO 2 Emissions from Fuel Combustion • Energy Prices and Taxes • Energy Technology Research and Development Database • World Energy Statistics and Balances – –

Energy Statistics of OECD Countries Energy Balances of OECD Countries

– –

Energy Statistics of Non-OECD Countries Energy Balances of Non-OECD Countries

IEA databanks II

• Electricity information • Coal Information • Natural Gas Information • Oil Information • Renewables Information

Example from IEA:

CO

2

emissions from electricity generation in Latin America

UN and its agencies

• The

UN Common database

has been used for many years by the UN internally as a basis for the formulation of policy. Covers a huge range of human development topics including health, culture, family life, education and the environment • The International Labour Organisation ’ s

Key Indicators of the Labour Market

• The

UNIDO Industrial Statistics and Demand Supply

databanks cover employment and trade world-wide, broken down by country and manufacturing sector.

Example from the ILO

Average Annual Hours Worked

2400 2200 2000 1800 1600 1400 1200 1000 No rw Ne ay th er la nd s Fr an ce G er m an y De nm ar k Ita ly UK Ca na da US A Ja pa n Sl ov ak ia M ex ico Po la nd Cz ec h Re p Ko re a

Source: ILO Key Indicators

International Microdata datasets: official sources

• Almost every country produces its own household surveys. • The International Household Survey Network maintains a web-based

Central Survey and Census Catalogue

that holds the metadata created by these surveys.

Academic international surveys

• Many smaller organizations produce cross-national survey datasets. • These typically are academically-driven surveys that compare opinions, life and individual experiences in several countries. • Examples include the European Social Survey and the World Values survey.

• ESDS International provides access to these survey datasets alongside the macro-databanks through a series of reciprocal arrangements with the host institution or data archive.

European Social Survey

The European Social Survey (the ESS) is examines the interaction between Europe's changing institutions and the attitudes, beliefs and behaviour patterns of its diverse populations. Now in its third round, the survey covers over 20 nations.

World Values Survey

• The World Values Survey originally developed to answer the question,

"What makes people happy?".

It investigates socio-cultural, moral, religious and political values of different cultures around the world and looks for the relationships between people's values and beliefs and their overall levels of well-being.

The Global Barometers

• • •

Eurobarometer

attitudes.

is a series of surveys cross-national and cross temporal comparative social research conducted on behalf of the European Commission and designed to monitor social and political

Afrobarometer

measures social and political attitudes in Africa. In common with the other barometers, it examines issues of trust in institutions and society, evaluation of the country's political and economic performance, participation and spiritual beliefs. It has a particular focus on how people feel about their living conditions. Covers around 18 countries

Latinobarómetro

is an annual public opinion survey of approximately 19.000 interviews in 18 countries in Latin America.

Other international surveys

ESDS International also provides access to a number of other cross-national surveys including: • E-Living : Life in a Digital Europe • European Election Study • European Quality of Life Survey (Eurofound) • European Values Study • International Social Survey Programme

Our top ten users, Sept 2006

Institution

University of Manchester University of Oxford University of Essex London School of Economics and Politic..

University of Birmingham University of Leicester School of Oriental and African Studies University of Nottingham University of Bath University of Warwick

Number of Accesses

534 388 367 308 274 255 253 239 171 143

Courses and Training

ESDS International provides courses and seminars on the service on request - please ask!