- 9 Sep 2020
Supply, use, input-output tables and multipliers for download
The tables available for download here relate to 1998 to 2017. These were published on September 9 2020.
The tables are available in filtered list Excel (xlsx) format and printable Adobe PDF. They are set out in the traditional Supply Use Table format and are intended for viewing and printing.
Please note that all the tables are also available in machine readable format on the Scottish Government Open Data Platform. This is a compressed archive (zip) file with excel (MS Office version 2016 .xlsx) datasets are in stacked (wide) format with variable names in row 1 and unstacked (narrow) format with all values in a single column. For guidance on how to access this zipped collection of files using API, please visit the help guide.
More information about presentational and methodological changes can be seen the the Developments section of the Supply, Use and Input-Output Tables information pages.
Additional export retail table
Introduced for the 1998-2016 Tables, a separate table is provided that splits the non-resident spending in Scotland column of the Use Table into non-residents from the Rest of the UK and from the Rest of the World. This allows users to derive the total Exports to the Rest of the UK, and separately, to the Rest of the World.
Please note that these estimates are derived from raw data non-resident Rest of the UK and Rest of the World spending splits applied to the single balanced non-resident spending column in the published Use Table. As such it is not possible to derive a Rest of the UK or Rest of the World non-resident spending split for the Industry by Industry or Product by Product Input-Output Tables.
The Scottish Government Input-Output model has an environmental extension that makes it possible to estimate Greenhouse Gas Emission effects. These were last updated for the High Level Carbon Assessment of the Scottish Budget 2020/21, published on 6th of February 2020. Although the methodology underpinning the Carbon Assessment remains the same as for the Carbon Assessment of the 2019/20 Budget, the base year of Environmental Input-Output (EIO) model itself has been updated from 2014 to 2015. This is possible because of the newly available Input-Output Analytical Tables covering the year 2015 for the UK. As usual the model has also been updated to use the latest available Scottish Government Input-Output Analytical Tables, ONS Greenhouse Gas emissions ratios and HM Treasury deflators. For more information about the methodology used please see the Environmental Input-Output methodology page.
The GHG effects published here detail the estimated direct and indirect greenhouse gas emissions (expressed in tonnes of carbon dioxide equivalent) as a result of £1m final use from each of the 98 Input-Output industry categories. These are derived from the Scottish Government Environmental Input-Output Model 2015 v1.1. This model is based on the Scottish Government Input-Output tables 2015 (published in July 2019), ONS Input-Output Analytical Tables 2015 (Blue Book 2018 consistent), ONS Environmental Accounts GHG emissions by industrial sector for 2015 (published in June 2019) and HM Treasury deflators (published on 20th December 2019).
Since the Model is applied to 2020/21 Scottish Budget spending plans, the GHG effects are in 2020/21 prices.
Previously published tables are available upon request
Please contact the Input-Output team directly if you have any questions about the tables or require any help in using them.
We are especially interested in any work that you may be doing that uses any of the IO data. We would also be interested in any feedback concerning the layout and content of this web site or any other suggestions that you have.
Telephone: +44 (0)131 244 3330
The Scottish Government Input-Output team
St. Andrew's House