Transcript WIOD Database Construction Marcel Timmer

This project is funded by the European Commission, Research Directorate General as part
of the 7th Framework Programme, Theme 8: Socio-Economic Sciences and Humanities.
Grant Agreement no: 225 281
WIOD
WORLD INPUT-OUTPUT DATABASE
construction
WP 1-5
Marcel Timmer
Groningen Growth and Development Centre
University of Groningen
(WIOD Conference, Sevilla , 25-28 May, 2011)
WIOD project: Work Packages

WP1-3: Construction of harmonized supply and use
tables, national input-output tables, price deflators,
trade flows and intercountry input-output tables

WP4: Construction of environmental satellite accounts
(energy use, greenhouse gas emissions, etc.)

WP5: Construction of socio-economic satellite accounts
(skill levels, investment, accumulation of intangibles)
List of Countries
• EU-27
• plus13 non-EU:
- Canada
- United States
- Brazil
- Mexico
- Turkey
- Russia
- China
- India
- Japan
- South Korea
- Taiwan
- Indonesia
- Australia
Past year work done




SUTs time-series (RUG, IPTS, HTWG)
Trade in goods and services (WIIW)
Inter-country IO tables (RUG, WIIW)
Socio-economic accounts (RUG): building upon World KLEMS
project
 Environmental accounts (IPTS): building upon EXIOPOL project
 Consultation and feedback through workshops: OECD, WTO,
Eurostat, IO-community, consortium members
Dataflows and construction steps in WIOT
Public
statistics
For each
country
Harmonisation
Estimation
Time series
for each
country
National accounts
(time-series)
Supply and use tables
(infrequent)
Total Final demand by type
Total Export/Import
Value added by industry
Gross output by industry
Supply (Basic price)
Use (Purchasers' price)
International trade
statistics
(time-series)
Imports and exports
on bilateral basis
- of goods
- of services
WP 2
WP 1
Supply (Basic price)
Use (Basic price)
Valuation matrix
Bilateral import
shares by use
Estimation
Time series
for each
country
Supply (Basic price)
Valuation matrix
Domestic use (Basic price)
Import use (Basic price) by
delivering country
Estimation
Time series
World input-output tables
WP 3
Achievements
Draft full version of WIOT time-series (1995-2006) and
 underlying national and international SUTs
 At current and constant national prices
Three revision rounds mainly geared towards
 Negatives in intermediate block
 Treatment of tax/trade margins
 Split domestic and import USE
 Improving trade data (in particular services trade)
 Draft version of environmental accounts: increasing number of
variables
 Draft version of socio-economic accounts: continuous work on
various non-EU countries
Remaining challenges
 WIOTable
 Negative exports to ROW,
 Better data onTariffs
 Continous improvement on trade in services
 International trade margins (imports cif/fob)
 Re-exports: problems bigger than expected but datasituation very weak. We decided to keep them in (as in
National Accounts) and not work back towards original
source country (except for Hong Kong)
 Environmental and socio-economic acounts: progress is
depended on other projects: Exiopol and World KLEMS
PPP based tables
D1.4: Preliminary constant international price SUTs for
1995-2006.
Based on International deflators (PPPs): World Bank ICP
expenditure PPPs adjusted and allocated to industries (for
2005). All necessary data has been collected from World
Bank. Will be implemented in upcoming months.
Future plans
Presentation of results at workshops incl. World Bank, NBER, InputOutput-conference etc.
More rounds of revisions towards final database. We will revise the
database in the upcoming months based on the comments received
Extension of WIOT to 2009
Full set of socio-economic and environmental accounts
Why WIOD?
 Number of alternative initiatives is rising
 Main innovations in WIOT
 Benchmarked on National Accounts data with transparent
flow of adjustments
 Timeseries data: updating is integral part
 Methodological improvements (e.g. SUT-RAS; import by
use)
 Integrated socio-economic and environmental accounts
 Quality? Consistent approach as limited number of people
work on the database.
 Inbetween “official statistics” and “anything-goes-becausewe-can-RAS” approach
Long-term challenges
 Upcoming revisions in System of National
Accounts and industrial classifications
 SEEA and environmental accounts integration
 Institutionalize this type of work in statistical world
(long-long term) and academic community (longterm)
Additional material
Columns in USE Table
Code
NACE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
AtB
C
15t16
17t18
19
20
21t22
23
24
25
26
27t28
29
30t33
34t35
36t37
E
F
50
51
52
H
60
61
62
63
64
J
70
71t74
L
M
N
O
P
Description
Agriculture, Hunting, Forestry and Fishing
Mining and Quarrying
Food, Beverages and Tobacco
Textiles and Textile Products
Leather, Leather and Footwear
Wood and Products of Wood and Cork
Pulp, Paper, Paper , Printing and Publishing
Coke, Refined Petroleum and Nuclear Fuel
Chemicals and Chemical Products
Rubber and Plastics
Other Non-Metallic Mineral
Basic Metals and Fabricated Metal
Machinery, Nec
Electrical and Optical Equipment
Transport Equipment
Manufacturing, Nec; Recycling
Electricity, Gas and Water Supply
Construction
Sale, Maintenance and Repair of Motor Vehicles Retail Sale of Fuel
Wholesale Trade and Commission Trade, Except of Motor Vehicles
Retail Trade, Except of Motor Vehicles ; Repair of Household Goods
Hotels and Restaurants
Inland Transport
Water Transport
Air Transport
Other Supporting and Auxiliary Transport Activities; Activities of Travel Agencies
Post and Telecommunications
Financial Intermediation
Real Estate Activities
Renting of M&Eq and Other Business Activities
Public Admin and Defence; Compulsory Social Security
Education
Health and Social Work
Other Community, Social and Personal Services
Private Households with Employed Persons
Financial intermediation services indirectly measured (FISIM)
Total
Final consumption expenditure by households
Final consumption exp. by non-profit organisations serving households
Final consumption expenditure by government
Final consumption expenditure
Gross fixed capital formation
Changes in inventories and valuables
Gross capital formation
Exports
Final uses at purchasers' prices
Total use at purchasers' prices
Columns
in Use
table
Description
Code
CPA
1
1
Products of agriculture, hunting and related services
2
2
Products of forestry, logging and related services
3
5
Fish and other fishing products; services incidental of fishing
4
10
Coal and lignite; peat
5
11
Crude petroleum and natural gas; services incidental to oil and gas extraction excluding surveying
6
12
Uranium and thorium ores
7
13
Metal ores
8
14
Other mining and quarrying products
9
15
Food products and beverages
10
16
Tobacco products
11
17
Textiles
12
18
Wearing apparel; furs
13
19
Leather and leather products
14
20
Wood and products of wood and cork (except furniture); articles of straw and plaiting materials
15
21
Pulp, paper and paper products
16
22
Printed matter and recorded media
17
23
Coke, refined petroleum products and nuclear fuels
18
24
Chemicals, chemical products and man-made fibres
19
25
Rubber and plastic products
20
26
Other non-metallic mineral products
21
27
Basic metals
22
28
Fabricated metal products, except machinery and equipment
23
29
Machinery and equipment n.e.c.
24
30
Office machinery and computers
25
31
Electrical machinery and apparatus n.e.c.
26
32
Radio, television and communication equipment and apparatus
27
33
Medical, precision and optical instruments, watches and clocks
28
34
Motor vehicles, trailers and semi-trailers
29
35
Other transport equipment
30
36
Furniture; other manufactured goods n.e.c.
31
37
Secondary raw materials
32
40
Electrical energy, gas, steam and hot water
33
41
Collected and purified water, distribution services of water
34
45
Construction work
Rows in
Use
table
(part 1)
35
50
Trade, maintenance and repair services of motor vehicles and motorcycles; retail sale of automotive fuel
36
51
Wholesale trade and commission trade services, except of motor vehicles and motorcycles
37
52
Retail trade services, except of motor vehicles and motorcycles; repair services of personal and household goods
38
55
Hotel and restaurant services
39
60
Land transport; transport via pipeline services
40
61
Water transport services
41
62
Air transport services
42
63
Supporting and auxiliary transport services; travel agency services
43
64
Post and telecommunication services
44
65
Financial intermediation services, except insurance and pension funding services
45
66
46
67
47
70
48
71
49
72
Rows in
Insurance and pension funding services, except compulsory social security services
Use
Services auxiliary to financial intermediation
Real estate services
table
Renting services of machinery and equipment without operator and of personal and household goods
(part 2)
Computer and related services
50
73
Research and development services
51
74
Other business services
52
75
Public administration and defence services; compulsory social security services
53
80
Education services
54
85
Health and social work services
55
90
Sewage and refuse disposal services, sanitation and similar services
56
91
Membership organisation services n.e.c.
57
92
Recreational, cultural and sporting services
58
93
Other services
59
95
Private households with employed persons
60
Total
61
Cif/ fob adjustments on exports
62
Direct purchases abroad by residents
63
Purchases on the domestic territory by non-residents
64
Total intermediate consumption/final use at purchasers' prices
65
Compensation of employees
66
Other net taxes on production
67
Operating surplus, gross
68
Value added at basic prices
69
Output at basic prices
Deliverables
Delivery date
Deliverab
le
1.2
6.1
2.2
8.1
1.3
3.1
3.2
4.2
5.1
5.2
6.2
7.1
Responsibl
Content
e institute
Target Expected Realised
Nominal SUT
RUG
6
14
Report IO-types
IPTS/HTWG
6
8
Bilateral trade
WIIW
9
14
Report lit review
WIIW
9
14
Real SUT
RUG
12
14
Inter-country SUT
RUG
12
14
Inter-country IO (current)
RUG
12
14
Environmental indicators
IPTS
12
14
Update EU KLEMS
RUG
12
9
9
KL for others
RUG
12
14
Report IO-compilation
IPTS/HTWG
12
14
Linking economic and environmental
ZEW indicators
12
13
Deliverables, coming years
Delivery date
Deliverab
le
1.4
4.3
8.2
9.1
5.4
6.3a
6.3b
6.3c
7.2
7.4
8.4
3.3
3.4
5.3
6.4
7.3
7.5
8.5
9.2
9.3
9.4
Responsibl
Content
e institute
Real SUT (PPP)
RUG
Indicators for CGE
IPTS
Report factor content
WIIW/RUG
Report suggestions
CPB
Foreign affiliates
WIIW
Report IO constant price
IPTS/HTWG
Report IO projection
IPTS/HTWG
Report sensitivity model choice RUG
Report structural change
ZEW
Improving CGE calibration
ZEW/WIFO
Report trade in intermediates WIIW
Inter-country IO (real)
RUG
Regional IO
RUG
Intangibles
TCB
Report sensitivity price and aggregation
RUG
Environmental policies
ZEW/WIFO
Report techn change and environment
ZEW/WIFO
Report outsourcing
WIIW
Report GEM
ICCS
Report Nemesis
CRSA
Report World scan
CPB
Target
16
16
16
16
18
18
18
18
18
18
18
21
21
24
24
24
24
24
24
24
24
Deliverab
le
7.6
8.7
1.5
2.3
3.5
4.4
4.5
5.5
8.3
8.6
8.8
9.5+9.9
9.6+9.10
9.7+9.11
9.8+9.12
Content
Model prototype
Report econometric model
All SUT final
Final bilateral trade
Final IO
Final data
Technical report
Final socio-economic
Report factor content (final)
Report outsourcing (final)
Report econometric model
Model + report GEM
Model + report Nemesis
Model + report Worldscan
Model + report PACE
Delivery date
Responsibl
e institute
Target
ZEW/WIFO
30
WIIW/ WIFO
30
RUG
36
WIIW
36
RUG
36
IPTS
36
IPTS
36
RUG
36
WIIW/RUG
36
WIIW
36
WIIW/ WIFO
36
ICCS
36
CRSA
36
CPB
36
ZEW
36