Transcript Economic and Social Data Service (ESDS)
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!