FAOSTAT Food Balance Sheet - Revision history

Norah.Shamin: /* Data Pulling Instructions */

2025-08-15T16:37:57Z

Data Pulling Instructions

← Older revision		Revision as of 16:37, 15 August 2025
Line 1,811:		Line 1,811:
	#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.		#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.
	#Remember to follow the formulas of the DataDict!		#Remember to follow the formulas of the DataDict!

			= Data Notes =

Norah.Shamin at 00:55, 11 July 2025

2025-07-11T00:55:53Z

Show changes

Norah.Shamin at 14:49, 3 July 2025

2025-07-03T14:49:07Z

← Older revision		Revision as of 14:49, 3 July 2025
Line 1:		Line 1:
	FAOSTAT provides annual statistics of food supply by country. FAOSTAT data can be found here < ~~[http:~~/~~/www.fao.org/faostat/en/#data~~ http://www.fao.org/faostat/en/#data]>. The latest data has been pulled from the report updated on April, ~~2024~~ which covers 186 economies from year 1961 to year ~~2021~~.		== Summary ==
			FAOSTAT provides annual statistics of food supply by country. FAOSTAT data can be found here<nowiki/>http://www.fao.org/faostat/en/#data. The latest data has been pulled from the report updated on April, 2025 which covers 186 economies from year 1961 to year 2022.

	= ~~<font style~~="~~background~~-~~color: rgb~~(~~255~~, ~~255~~, ~~255~~)~~;"><span style="font-size:x-large;">Series pulled from the FAOSTAT Food Balance Sheets</span> </font> =~~		== Tables In IFs ==
			Note: For "OtherUtl" series, the old “other utilizations” variable has been split into two new ones: “Tourist” food allocation (for now used in a limited number of countries where tourism has a very significant impact on food supply) and “Industrial non-food uses” (which should cover allocations to the textile, pharmaceutical, etc. industries). Thus, there are 2 Element Codes.
	{\| class="wikitable"		{\| class="wikitable"
	\|Standard Series		\|Standard Series
Line 658:		Line 660:
	\|5511		\|5511
	\|}		\|}
	~~Note~~: ~~For "OtherUtl"~~ series, the ~~old “other utilizations” variable has been split into two new ones: “Tourist” food allocation (~~for ~~now used in a limited number~~ of countries where tourism has a very significant impact on food supply) and “Industrial non-food uses” (which should cover allocations to the textile, pharmaceutical, etc. industries). Thus, there are 2 Element Codes.
			== Tables In IFs: Aggregation Item Codes Series ==
			These are the series and the item codes for each item group. This is important for the aggregation of tables.

			=== Crop Series ===
	{\| class="wikitable"		{\| class="wikitable"
	\|AGCrop Series		\|AGCrop Series
Line 730:		Line 736:
	\|Crops		\|Crops
	\|}		\|}
	Items in Crops Group:
			==== Items in Crops Group: ====
	{\| class="wikitable"		{\| class="wikitable"
	\|Item		\|Item
Line 780:		Line 787:
	\|2928		\|2928
	\|}		\|}

			=== Meat Series ===
	{\| class="wikitable"		{\| class="wikitable"
	\|AGMeat Series		\|AGMeat Series
Line 851:		Line 860:
	\|Meat		\|Meat
	\|}		\|}
	Items in Meat Group:
			==== Items in Meat Group: ====
	{\| class="wikitable"		{\| class="wikitable"
	\|Item		\|Item
Line 880:		Line 890:
	\|2949		\|2949
	\|}		\|}

			=== FruVeg Series ===
	{\| class="wikitable"		{\| class="wikitable"
	\|FruVeg Series		\|FruVeg Series
Line 896:		Line 908:
	\|FruVeg		\|FruVeg
	\|}		\|}
	Items in FruVeg Group:
			==== Items in FruVeg Group: ====
	{\| class="wikitable"		{\| class="wikitable"
	\|Item		\|Item
Line 907:		Line 920:
	\|2918		\|2918
	\|}		\|}

			=== Fish Series ===
	{\| class="wikitable"		{\| class="wikitable"
	\|Variable		\|Variable
Line 924:		Line 939:
	\|}		\|}

			==== Items in Fish Group: ====
	Items in Fish Group:
	{\| class="wikitable"		{\| class="wikitable"
	\|Item		\|Item
Line 943:		Line 957:
	\|}		\|}

	= <font style="background-color: rgb(255, 255, 255);"><span style="font-size:x-large;">Instructions ~~for pulling FAOSTAT FBS series~~</span></font> =		== <font style="background-color: rgb(255, 255, 255);"><span style="font-size:x-large;">Data Pulling Instructions</span></font> ==

	The FAOSTAT FBS series are blended from two datasets: The historical data goes from 1961 to 2009 while the preliminary data goes from 2010 to 2021. Both datasets are from the FAOSTAT website.		The FAOSTAT FBS series are blended from two datasets: The historical data goes from 1961 to 2009 while the preliminary data goes from 2010 to 2021. Both datasets are from the FAOSTAT website.

Line 965:		Line 978:
	#*Sudan (former) --> Sudan		#*Sudan (former) --> Sudan
	#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.		#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.
			#Remember to follow the formulas of the DataDict!
	~~'''2020 Update'''~~

	~~For~~ the ~~2020 update,~~ the ~~FAOSTAT FBS series were pulled using Python. The Python code can be accessed through the Pardee Data Team.~~

Yutang.Xiong: Yutang.Xiong moved page FAOSTAT FBS to FAOSTAT Food Balance Sheet without leaving a redirect: new name

2025-02-19T22:27:37Z

Yutang.Xiong moved page FAOSTAT FBS to FAOSTAT Food Balance Sheet without leaving a redirect: new name

← Older revision	Revision as of 22:27, 19 February 2025
(No difference)

Kexin.Shang: /* Series pulled from the FAOSTAT Food Balance Sheets */

2024-08-08T22:58:55Z

Series pulled from the FAOSTAT Food Balance Sheets

@@ Line 922: / Line 922: @@
 |2911
 |5611
 |}

Kexin.Shang: /* Series pulled from the FAOSTAT Food Balance Sheets */

2024-08-06T19:38:17Z

Series pulled from the FAOSTAT Food Balance Sheets

← Older revision		Revision as of 19:38, 6 August 2024
Line 781:		Line 781:
	\|}		\|}
	{\| class="wikitable"		{\| class="wikitable"
	\|AGMeat Series		\|AGMeat Series
	\|Name in Source		\|Name in Source
	~~\|Item Code~~
	\|Element Code		\|Element Code
	\|-		\|Item Group
	~~\|AGMeatCalPerCapPerDayFAO~~
	~~\|Meat: Food supply (kcal/capita/day)~~
	~~\|2943~~
	~~\|664~~
	\|-		\|-
	\|AGMeatDomesticSupplyFAO		\|AGMeatDomesticSupplyFAO
	\|Meat: Domestic supply quantity		\|Meat: Domestic supply quantity
	~~\|2943~~
	\|5301		\|5301
			\|Meat
	\|-		\|-
	\|AGMeatExportsFAO		\|AGMeatExportsFAO
	\|Meat: Export Quantity		\|Meat: Export Quantity
	~~\|2943~~
	\|5911		\|5911
			\|Meat
			\|-
			\|AGMeattoFeedFAO
			\|Meat: Feed
			\|5521
			\|Meat
			\|-
			\|AGMeattoFoodFAO
			\|Meat: Food
			\|5142
			\|Meat
			\|-
			\|AGMeatCalPerCapPerDayFAO
			\|Meat: Food supply (kcal/capita/day)
			\|664
			\|Meat
	\|-		\|-
	\|AGMeatFoodSupplyPerCapPerDayFAO		\|AGMeatFoodSupplyPerCapPerDayFAO
	\|Meat: Food supply quantity (kg/capita/yr)		\|Meat: Food supply quantity (kg/capita/yr)
	~~\|2943~~
	\|645		\|645
			\|Meat
	\|-		\|-
	\|AGMeatImportsFAO		\|AGMeatImportsFAO
	\|Meat: Import Quantity		\|Meat: Import Quantity
	~~\|2943~~
	\|5611		\|5611
			\|Meat
			\|-
			\|AGMeattoWasteFAO
			\|Meat: Losses
			\|5123
			\|Meat
			\|-
			\|AGMeattoOtherUtilFAO
			\|Meat: Other uses (non-food) & Tourist consumption
			\|5154 & 5171
			\|Meat
			\|-
			\|AGMeattoFoodManuFAO
			\|Meat: Processing
			\|5131
			\|Meat
	\|-		\|-
	\|AGMeatProductionFAO		\|AGMeatProductionFAO
	\|Meat: Production		\|Meat: Production
	~~\|2943~~
	\|5511		\|5511
			\|Meat
	\|-		\|-
	\|AGMeatProteinPerCapPerDayFAO		\|AGMeatProteinPerCapPerDayFAO
	\|Meat: Protein supply quantity (g/capita/day)		\|Meat: Protein supply quantity (g/capita/day)
	~~\|2943~~
	\|674		\|674
			\|Meat
			\|-
			\|AGMeattoSeedFAO
			\|Meat: Seed
			\|5527
			\|Meat
			\|}
			Items in Meat Group:
			{\| class="wikitable"
			\|Item
			\|Item Code
			\|-
			\|Fats, Animals, Raw
			\|2737
			\|-
			\|Butter, Ghee
			\|2740
	\|-		\|-
	\|~~AGMeattoFeedFAO~~		\|Cream
	\|~~Meat: Feed~~		\|2743
	~~\|2943~~
	~~\|5521~~
	\|-		\|-
	\|~~AGMeattoFoodFAO~~		\|Honey
	\|~~Meat: Food~~		\|2745
	~~\|2943~~
	~~\|5142~~
	\|-		\|-
	~~\|AGMeattoFoodManuFAO~~		\|Meat
	\|Meat~~: Processing~~
	\|2943		\|2943
	~~\|5131~~
	\|-		\|-
	\|~~AGMeattoOtherUtilFAO~~		\|Offals
	\|~~Meat: Other uses (non-food) & Tourist consumption~~		\|2945
	~~\|2943~~
	~~\|5154 & 5171~~
	\|-		\|-
	\|~~AGMeattoSeedFAO~~		\|Milk - Excluding Butter
	\|~~Meat: Seed~~		\|2948
	~~\|2943~~
	~~\|5527~~
	\|-		\|-
	\|~~AGMeattoWasteFAO~~		\|Eggs
	\|~~Meat: Losses~~		\|2949
	~~\|2943~~
	~~\|5123~~
	\|}		\|}
	{\| class="wikitable"		{\| class="wikitable"

Kexin.Shang: /* Instructions for pulling FAOSTAT FBS series */

2024-04-11T04:34:30Z

Instructions for pulling FAOSTAT FBS series

← Older revision		Revision as of 04:34, 11 April 2024
Line 900:		Line 900:

	#The data can be accessed on the FAOSTAT website. Historical data series are available here <[http://www.fao.org/faostat/en/#data/FBSH http://www.fao.org/faostat/en/#data/FBSH]> and preliminary data series are available here <[http://www.fao.org/faostat/en/#data/FBS http://www.fao.org/faostat/en/#data/FBS]>.		#The data can be accessed on the FAOSTAT website. Historical data series are available here <[http://www.fao.org/faostat/en/#data/FBSH http://www.fao.org/faostat/en/#data/FBSH]> and preliminary data series are available here <[http://www.fao.org/faostat/en/#data/FBS http://www.fao.org/faostat/en/#data/FBS]>.
	#Download 'All Data ~~Normalized~~' under Bulk Downloads.		#Download 'All Data' under Bulk Downloads.
	#Apply Python script.		#Apply [https://github.com/shangkexin/FAO_Food_Balance_Sheet Python script].
	#There are 160 series in Total. The series are sorted by category in the tables above.		#There are 160 series in Total. The series are sorted by category in the tables above.
	#*130 standard series, [[File:Picture1.png\|none\|thumb]]		#*130 standard series, [[File:Picture1.png\|none\|thumb]]
Line 917:		Line 917:
	#*Sudan (former) --> Sudan		#*Sudan (former) --> Sudan
	#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.		#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.
	#

	'''2020 Update'''		'''2020 Update'''

	For the 2020 update, the FAOSTAT FBS series were pulled using Python. The Python code can be accessed through the Pardee Data Team.		For the 2020 update, the FAOSTAT FBS series were pulled using Python. The Python code can be accessed through the Pardee Data Team.

Kexin.Shang: /* Instructions for pulling FAOSTAT FBS series */

2024-04-04T16:40:06Z

Instructions for pulling FAOSTAT FBS series

← Older revision		Revision as of 16:40, 4 April 2024
Line 903:		Line 903:
	#Apply Python script.		#Apply Python script.
	#There are 160 series in Total. The series are sorted by category in the tables above.		#There are 160 series in Total. The series are sorted by category in the tables above.
	#*130 standard series,		#*130 standard series, [[File:Picture1.png\|none\|thumb]]
	#*13 series starting with "AGCrop",		#*13 series starting with "AGCrop",
	#*13 series starting with "AGMeat",		#*13 series starting with "AGMeat",

Kexin.Shang: /* Instructions for pulling FAOSTAT FBS series */

2024-04-02T17:42:05Z

Instructions for pulling FAOSTAT FBS series

← Older revision		Revision as of 17:42, 2 April 2024
Line 658:		Line 658:
	\|5511		\|5511
	\|}		\|}
	Note: For "OtherUtl", the old “other utilizations” variable has been split into two new ones: “Tourist” food allocation (for now used in a limited number of countries where tourism has a very significant impact on food supply) and “Industrial non-food uses” (which should cover allocations to the textile, pharmaceutical, etc. industries). Thus, there are 2 Element Codes.		Note: For "OtherUtl" series, the old “other utilizations” variable has been split into two new ones: “Tourist” food allocation (for now used in a limited number of countries where tourism has a very significant impact on food supply) and “Industrial non-food uses” (which should cover allocations to the textile, pharmaceutical, etc. industries). Thus, there are 2 Element Codes.
	{\| class="wikitable"		{\| class="wikitable"
	\|AGCrop Series		\|AGCrop Series
Line 902:		Line 902:
	#Download 'All Data Normalized' under Bulk Downloads.		#Download 'All Data Normalized' under Bulk Downloads.
	#Apply Python script.		#Apply Python script.
	#There are 160 series in Total.		#There are 160 series in Total. The series are sorted by category in the tables above.
	##130 standard series,		#*130 standard series,
	##13 series starting with "AGCrop",		#*13 series starting with "AGCrop",
	##13 series starting with "AGMeat",		#*13 series starting with "AGMeat",
	##2 series starting with "AgFruVeg",		#*2 series starting with "AgFruVeg",
	##2 series starting with "~~AGPulses~~".		#*2 series starting with "AgPulses".
	#The ~~series~~ are ~~sorted by category~~ in the ~~tables above~~.		#The following states are included in FAOSTAT countries, but we do not have them in IFs Countries. You will need to copy and paste the data from the below dissolved states into their new states (The general rule about merging data between current states and their former dissolved states is whichever state that inherited the capital city has the right to claim data from its former dissolved state):
			#*China, mainland --> China
			#*Czechoslovakia --> Czech Republic
			#*Ethiopia PDR --> Ethiopia
			#*USSR --> Russian Federation
			#*Yugoslav SFR --> Serbia
			#*Serbia and Montenegro --> Serbia
			#*Sudan (former) --> Sudan
			#When take the sum of items under crops/fruveg group, be aware that sum of null is null instead of 0.
	#		#

Kexin.Shang: /* Series pulled from the FAOSTAT Food Balance Sheets */

2024-04-02T17:19:21Z

Series pulled from the FAOSTAT Food Balance Sheets

Show changes