Dataset Open Access

Food and Agriculture Biomass Input–Output (FABIO) database

Bruckner, Martin; Kuschnig, Nikolas

This data repository provides the Food and Agriculture Biomass Input Output (FABIO) database, a global set of multi-regional physical supply-use and input-output tables covering global agriculture and forestry. 

The work is based on mostly freely available data from FAOSTAT, IEA, EIA, and UN Comtrade/BACI. FABIO currently covers 191 countries + RoW, 118 processes and 125 commodities (raw and processed agricultural and food products) for 1986-2013. All R codes and auxilliary data are available on GitHub. For more information please refer to https://fabio.fineprint.global.

The database consists of the following main components, in compressed .rds format:

  • Z: the inter-commodity input-output matrix, displaying the relationships of intermediate use of each commodity in the production of each commodity, in physical units (tons). The matrix has 24000 rows and columns (125 commodities x 192 regions), and is available in two versions, based on the method to allocate inputs to outputs in production processes: Z_mass (mass allocation) and Z_value (value allocation). Note that the row sums of the Z matrix (= total intermediate use by commodity) are identical in both versions.
  • Y: the final demand matrix, denoting the consumption of all 24000 commodities by destination country and final use category. There are six final use categories (yielding 192 x 6 = 1152 columns): 1) food use, 2) other use (non-food), 3) losses, 4) stock addition, 5) balancing, and 6) unspecified.
  • X: the total output vector of all 24000 commodities. Total output is equal to the sum of intermediate and final use by commodity.
  • L: the Leontief inverse, computed as (I – A)-1, where A is the matrix of input coefficients derived from Z and x. Again, there are two versions, depending on the underlying version of Z (L_mass and L_value).
  • E: environmental extensions for each of the 24000 commodities, including four resource categories: 1) primary biomass extraction (in tons), 2) land use (in hectares), 3) blue water use (in m3)., and 4) green water use (in m3).
  • mr_sup_mass/mr_sup_value: For each allocation method (mass/value), the supply table gives the physical supply quantity of each commodity by producing process, with processes in the rows (118 processes x 192 regions = 22656 rows) and commodities in columns (24000 columns).
  • mr_use: the use table capture the quantities of each commodity (rows) used as an input in each process (columns).

A description of the included countries and commodities (i.e. the rows and columns of the Z matrix) can be found in the auxiliary file io_codes.csv. Separate lists of the country sample (including ISO3 codes and continental grouping) and commodities (including moisture content) are given in the files regions.csv and items.csv, respectively. For information on the individual processes, see auxiliary file su_codes.csv. RDS files can be opened in R. Information on how to read these files can be obtained here: https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/readRDS

Except of X.rds, which contains a matrix, all variables are organized as lists, where each element contains a sparse matrix. Please note that values are always given in physical units, i.e. tonnes or head, as specified in items.csv. The suffixes value and mass only indicate the form of allocation chosen for the construction of the symmetric IO tables (for more details see Bruckner et al. 2019). Product, process and country classifications can be found in the file fabio_classifications.xlsx.

Footprint results are not contained in the database but can be calculated, e.g. by using this script: https://github.com/martinbruckner/fabio_comparison/blob/master/R/fabio_footprints.R

 

How to cite:

To cite FABIO work please refer to this paper:

Bruckner, M., Wood, R., Moran, D., Kuschnig, N., Wieland, H., Maus, V., Börner, J. 2019. FABIO – The Construction of the Food and Agriculture Input–Output Model. Environmental Science & Technology 53(19), 11302–11312. DOI: 10.1021/acs.est.9b03554

 

License:

This data repository is distributed under the CC BY-NC-SA 4.0 License. You are free to share and adapt the material for non-commercial purposes using proper citation. If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original. In case you are interested in a collaboration, I am happy to receive enquiries at martin.bruckner@wu.ac.at.

 

Known issues:

The underlying FAO data have been manipulated to the minimum extent necessary. Data filling and supply-use balancing, yet, required some adaptations. These are documented in the code and are also reflected in the balancing item in the final demand matrices. For a proper use of the database, I recommend to distribute the balancing item over all other uses proportionally and to do analyses with and without balancing to illustrate uncertainties.

Files (8.8 GB)
Name Size
1986_L_mass.rds
md5:0f7e60552eb9f8312cc2f0bdccfa685b
118.2 MB Download
1986_L_value.rds
md5:643482ca0e6e5ed7e6f7ee06be6a12b6
119.5 MB Download
1987_L_mass.rds
md5:1fa8fb4658c756836e2d96c67495a8e7
133.6 MB Download
1987_L_value.rds
md5:1e0d40fdeebfcd4be348e915f85995bd
133.0 MB Download
1988_L_mass.rds
md5:5251f5f3657540d553d494df3ef93583
133.0 MB Download
1988_L_value.rds
md5:09deb3870ea4b31fe49edfc6e5edef06
129.8 MB Download
1989_L_mass.rds
md5:0183e8080401dbafb9832633987a1871
115.4 MB Download
1989_L_value.rds
md5:5e7995f9058e0378a128d9348b5e578f
126.3 MB Download
1990_L_mass.rds
md5:c98dfce92733b9a6931dfdf8c4a36186
131.1 MB Download
1990_L_value.rds
md5:5f57792f029eceef9b64194b6ab2364d
135.7 MB Download
1991_L_mass.rds
md5:32a51bf078298f4e7b46e15ca455a506
119.9 MB Download
1991_L_value.rds
md5:94ac2d410151af0f088e6a0fb34ac67f
119.2 MB Download
1992_L_mass.rds
md5:0baa5cb7673774fe5700f37ba9877496
143.2 MB Download
1992_L_value.rds
md5:f50b018d9074b9619046dd0284f28a62
154.9 MB Download
1993_L_mass.rds
md5:e354480dbe7a65fc8565b0ffceaeaa93
146.8 MB Download
1993_L_value.rds
md5:8f3a4526a42a0e97e5042fa792f6318c
148.7 MB Download
1994_L_mass.rds
md5:3db3850568aef476b28eefbde6f31b78
150.8 MB Download
1994_L_value.rds
md5:d02000d597cc6a0b3cd2a812f03df06c
150.5 MB Download
1995_L_mass.rds
md5:43c53d81bd661f7e94a2d8b231f14067
153.1 MB Download
1995_L_value.rds
md5:6cbb6f2b5721d211087374dc5b1d31f1
154.2 MB Download
1996_L_mass.rds
md5:594a27ce94fa92340548b27b3ef6f7fe
153.2 MB Download
1996_L_value.rds
md5:946a76a1a103d8093a840af83ebbbe3d
154.8 MB Download
1997_L_mass.rds
md5:aa6d82e5e3ce2080644ce4f610373e17
153.7 MB Download
1997_L_value.rds
md5:5dacebefeee9c5936f720a3690dc39bf
155.0 MB Download
1998_L_mass.rds
md5:41d554a82e1eefd900d612bd41e67499
156.2 MB Download
1998_L_value.rds
md5:4196f49d009bc82a451a9bb667b5db4b
157.2 MB Download
1999_L_mass.rds
md5:1d80d3915c03db6ed8d3aced9b99627b
159.2 MB Download
1999_L_value.rds
md5:9cee0728cf4f9b148f1b3a047904a15e
160.9 MB Download
2000_L_mass.rds
md5:3d0cdada12c1fde31724f286169bd74a
160.2 MB Download
2000_L_value.rds
md5:fe94a4ff90775a528a69c75ec9c59c37
160.7 MB Download
2001_L_mass.rds
md5:fdcd2d5785d8967eb66f24ce0b2e0e12
161.3 MB Download
2001_L_value.rds
md5:46cccd44f6e0bbb5dbca14159e460305
162.4 MB Download
2002_L_mass.rds
md5:6f620a538e0571728442eaffc6ddfb9f
165.6 MB Download
2002_L_value.rds
md5:50f916fd86cb391fddada450b56bea95
165.4 MB Download
2003_L_mass.rds
md5:1db0eda918aaaaae60b0e4ec1b86613b
169.7 MB Download
2003_L_value.rds
md5:1edcc837ea9c6588b886e3e8a60810fa
167.2 MB Download
2004_L_mass.rds
md5:588e43e7d63a741dff7abd6f4b715f80
166.3 MB Download
2004_L_value.rds
md5:3390a01e86ffccad097b719e84703d92
164.9 MB Download
2005_L_mass.rds
md5:240479734b485186fd71446b94085eb9
167.8 MB Download
2005_L_value.rds
md5:1bfbe8f457b8b8b3153d5876053f53cc
168.3 MB Download
2006_L_mass.rds
md5:006f3b6cd339eeaaf9adef00a8b8a799
166.6 MB Download
2006_L_value.rds
md5:0205932d988c83d80bba42b87cf2786c
165.8 MB Download
2007_L_mass.rds
md5:ae8920e3cddbed3b3f183f3ff0e2d842
166.9 MB Download
2007_L_value.rds
md5:cec87a5424e6cb1105c9240481048661
168.5 MB Download
2008_L_mass.rds
md5:f762b97eaa2666ded43bb0e015a6b441
167.2 MB Download
2008_L_value.rds
md5:5739abaf8963ef041b217a763ea5958d
165.2 MB Download
2009_L_mass.rds
md5:a260b37e672d81bd481bb2a61e0d803f
168.3 MB Download
2009_L_value.rds
md5:52c92cb5b71d499dcdd83f3b2cfc4e2c
167.3 MB Download
2010_L_mass.rds
md5:cbd5b64c3eba736ee68e1f02085b91f3
167.3 MB Download
2010_L_value.rds
md5:3ad856d00cb8a6d53bd5f6bd782029eb
166.1 MB Download
2011_L_mass.rds
md5:2e1b23cb6e9c3b385f229d13956fe9b1
166.3 MB Download
2011_L_value.rds
md5:c82c4710164a1dc45dc8fb01ca2598d0
168.0 MB Download
2012_L_mass.rds
md5:6f3ae2f8d08b7695f4f9aeb56cda81e5
168.1 MB Download
2012_L_value.rds
md5:d3e6a548d109fe93bfc9f888919f6162
167.4 MB Download
2013_L_mass.rds
md5:2306549d14a8a129de13e65dae91d302
171.2 MB Download
2013_L_value.rds
md5:6f323e48299f8d704d6e5353d650b2e3
188.7 MB Download
E.rds
md5:1c523e6a7383820f1b0496ffb5b741ba
6.7 MB Download
fabio_classifications.xlsx
md5:71a398cb0ca1093540539b0d80b135ca
23.8 kB Download
io_codes.csv
md5:ac9258afadf9569f0723044ec50bb261
1.7 MB Download
items.csv
md5:4b6371996296f5a372255e9ec036fc4a
8.7 kB Download
regions.csv
md5:553bd031c9a9efaa1192ab3c332d8acf
4.6 kB Download
su_codes.csv
md5:f2f423cda6b0d2f8249a9f97db55b75a
943.0 kB Download
X.rds
md5:d6153a83d43f891f4deed9e1ee7eb964
1.4 MB Download
Y.rds
md5:29be7170654ca84eda49c6cc8aeddf86
53.9 MB Download
Z_mass.rds
md5:da39b5cb7befde686c9a5d76d8e4204a
56.3 MB Download
Z_value.rds
md5:a58a27084ec3c2510fddf3a39e9ae959
56.7 MB Download
  • Bruckner, M., Wood, R., Moran, D., Kuschnig, N., Wieland, H., Maus, V., Börner, J. 2019. FABIO – The Construction of the Food and Agriculture Input–Output Model. Environmental Science & Technology 53(19), 11302–11312. https://doi.org/10.1021/acs.est.9b03554

  • Bruckner, M., Kuschnig, N., 2020. FABIO database, v1.1. Zenodo. https://doi.org/10.5281/zenodo.2577067

72
175
views
downloads
All versions This version
Views 7272
Downloads 175175
Data volume 13.0 GB13.0 GB
Unique views 4949
Unique downloads 5151

Share

Cite as