Difference between revisions of "FAOSTAT FBS"

From Wiki
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
{| cellpadding="0" cellspacing="0" border="1" width="64"
 
{| cellpadding="0" cellspacing="0" border="1" width="64"
 
|-
 
|-
| height="20" | Code in Source in DataDict<br/>
+
| height="20" | Standard Series<br/>
 
|-
 
|-
 
| height="20" | SeriesAgBovineMeatProductionFAO<br/>
 
| height="20" | SeriesAgBovineMeatProductionFAO<br/>
Line 258: Line 258:
 
|-
 
|-
 
| height="20" | SeriesAgPoultryMeatProductionFAO<br/>
 
| height="20" | SeriesAgPoultryMeatProductionFAO<br/>
|-
 
| height="20" | SeriesAgPulsesEx<br/>
 
|-
 
| height="20" | SeriesAgPulsesIm<br/>
 
 
|}
 
|}
  
Line 343: Line 339:
 
= <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;">Instructions for pulling FAOSTAT FBS series</span></font> =
  
#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 recent 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.<font style="background-color: rgb(255, 255, 255);"><!--[http:--><!--[http:--><!--<font--></font>
+
The FAOSTAT FBS series are blended from two datasets: The historical data goes from 1961 to 2013 while the preliminary data goes from 2014 to 2017. Both datasets are from the FAOSTAT website.
#There are 128 series with values in Code in Source in DataDict, 13 series starting with "AGCrop", 13 series starting with "AGMeat", and 2 series starting with "AGPulses".
+
 
 +
#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.<font style="background-color: rgb(255, 255, 255);"><!--[http:--><!--[http:--><!--<font--></font>
 +
#Apply Python script. There are 128 standard series, 13 series starting with "AGCrop", 13 series starting with "AGMeat", and 2 series starting with "AGPulses". Different scripts are used to pull each category. The series are sorted by category in the tables above.
  
 
'''2020 Update'''
 
'''2020 Update'''
  
For the 2020 update, the FAOSTAT FBS series were pulled using Python. The Python code can be accessed through the 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.

Latest revision as of 17:23, 14 February 2020

FAOSTAT provides annual statistics of food supply by country. FAOSTAT data can be found here < http://www.fao.org/faostat/en/#data>. The latest data has been pulled from the report updated on February 10, 2020 which covers 186 economies from year 1961 to year 2017.

Series pulled from the FAOSTAT Food Balance Sheets 

Standard Series
SeriesAgBovineMeatProductionFAO
SeriesAgCerealsEx
SeriesAgCerealsIm
SeriesAgFishCalPerCapPerDayAqAnimalsFAO
SeriesAgFishCalPerCapPerDayAqPlantsFAO
SeriesAgFishCalPerCapPerDayBodyOilFAO
SeriesAgFishCalPerCapPerDayCephalopodsFAO
SeriesAgFishCalPerCapPerDayCrustaceansFAO
SeriesAgFishCalPerCapPerDayDemersalFAO
SeriesAgFishCalPerCapPerDayFreshwaterFAO
SeriesAgFishCalPerCapPerDayLiverOilFAO
SeriesAgFishCalPerCapPerDayMarineFAO
SeriesAgFishCalPerCapPerDayMolluscsFAO
SeriesAgFishCalPerCapPerDayPelagicFAO
SeriesAgFishDomesticSupplyAqAnimalsFAO
SeriesAgFishDomesticSupplyAqPlantsFAO
SeriesAgFishDomesticSupplyBodyOilFAO
SeriesAgFishDomesticSupplyCephalopodsFAO
SeriesAgFishDomesticSupplyCrustaceansFAO
SeriesAgFishDomesticSupplyDemersalFAO
SeriesAgFishDomesticSupplyFreshwaterFAO
SeriesAgFishDomesticSupplyLiverOilFAO
SeriesAgFishDomesticSupplyMarineFAO
SeriesAgFishDomesticSupplyMolluscsFAO
SeriesAgFishDomesticSupplyPelagicFAO
SeriesAgFishExportsAqAnimalsFAO
SeriesAgFishExportsAqPlantsFAO
SeriesAgFishExportsBodyOilFAO
SeriesAgFishExportsCephalopodsFAO
SeriesAgFishExportsCrustaceansFAO
SeriesAgFishExportsDemersalFAO
SeriesAgFishExportsFreshwaterFAO
SeriesAgFishExportsLiverOilFAO
SeriesAgFishExportsMarineFAO
SeriesAgFishExportsMolluscsFAO
SeriesAgFishExportsPelagicFAO
SeriesAgFishFoodSupplyPerCapPerDayAqAnimalsFAO
SeriesAgFishFoodSupplyPerCapPerDayAqPlantsFAO
SeriesAgFishFoodSupplyPerCapPerDayBodyOilFAO
SeriesAgFishFoodSupplyPerCapPerDayCephalopodsFAO
SeriesAgFishFoodSupplyPerCapPerDayCrustaceansFAO
SeriesAgFishFoodSupplyPerCapPerDayDemersalFAO
SeriesAgFishFoodSupplyPerCapPerDayFreshwaterFAO
SeriesAgFishFoodSupplyPerCapPerDayLiverOilFAO
SeriesAgFishFoodSupplyPerCapPerDayMarineFAO
SeriesAgFishFoodSupplyPerCapPerDayMolluscsFAO
SeriesAgFishFoodSupplyPerCapPerDayPelagicFAO
SeriesAgFishImportsAqAnimalsFAO
SeriesAgFishImportsAqPlantsFAO
SeriesAgFishImportsBodyOilFAO
SeriesAgFishImportsCephalopodsFAO
SeriesAgFishImportsCrustaceansFAO
SeriesAgFishImportsDemersalFAO
SeriesAgFishImportsFreshwaterFAO
SeriesAgFishImportsLiverOilFAO
SeriesAgFishImportsMarineFAO
SeriesAgFishImportsMolluscsFAO
SeriesAgFishImportsPelagicFAO
SeriesAgFishProdAqAnimalsFAO
SeriesAgFishProdAqPlantsFAO
SeriesAgFishProdBodyOilFAO
SeriesAgFishProdCephalopodsFAO
SeriesAgFishProdCrustaceansFAO
SeriesAgFishProdDemersalFAO
SeriesAgFishProdFreshwaterFAO
SeriesAgFishProdLiverOilFAO
SeriesAgFishProdMarineFAO
SeriesAgFishProdMolluscsFAO
SeriesAgFishProdPelagicFAO
SeriesAgFishProteinPerCapPerDayAqAnimalsFAO
SeriesAgFishProteinPerCapPerDayAqPlantsFAO
SeriesAgFishProteinPerCapPerDayBodyOilFAO
SeriesAgFishProteinPerCapPerDayCephalopodsFAO
SeriesAgFishProteinPerCapPerDayCrustaceansFAO
SeriesAgFishProteinPerCapPerDayDemersalFAO
SeriesAgFishProteinPerCapPerDayFreshwaterFAO
SeriesAgFishProteinPerCapPerDayLiverOilFAO
SeriesAgFishProteinPerCapPerDayMarineFAO
SeriesAgFishProteinPerCapPerDayMolluscsFAO
SeriesAgFishProteinPerCapPerDayPelagicFAO
SeriesAgFishtoFeedAqPlantsFAO
SeriesAgFishtoFeedBodyOilFAO
SeriesAgFishtoFeedCephalopodsFAO
SeriesAgFishtoFeedCrustaceansFAO
SeriesAgFishtoFeedDemersalFAO
SeriesAgFishtoFeedFreshwaterFAO
SeriesAgFishtoFeedLiverOilFAO
SeriesAgFishtoFeedMarineFAO
SeriesAgFishtoFeedMolluscsFAO
SeriesAgFishtoFeedPelagicFAO
SeriesAgFishtoFoodAqAnimalsFAO
SeriesAgFishtoFoodAqPlantsFAO
SeriesAgFishtoFoodBodyOilFAO
SeriesAgFishtoFoodCephalopodsFAO
SeriesAgFishtoFoodCrustaceansFAO
SeriesAgFishtoFoodDemersalFAO
SeriesAgFishtoFoodFreshwaterFAO
SeriesAgFishtoFoodLiverOilFAO
SeriesAgFishtoFoodMarineFAO
SeriesAgFishtoFoodMolluscsFAO
SeriesAgFishtoFoodPelagicFAO
SeriesAgFishtoOtherUtilAqAnimalsFAO
SeriesAgFishtoOtherUtilAqPlantsFAO
SeriesAgFishtoOtherUtilBodyOilFAO
SeriesAgFishtoOtherUtilCephalopodsFAO
SeriesAgFishtoOtherUtilCrustaceansFAO
SeriesAgFishtoOtherUtilDemersalFAO
SeriesAgFishtoOtherUtilFreshwaterFAO
SeriesAgFishtoOtherUtilLiverOilFAO
SeriesAgFishtoOtherUtilMarineFAO
SeriesAgFishtoOtherUtilMolluscsFAO
SeriesAgFishtoOtherUtilPelagicFAO
SeriesAgFishtoSeedAqAnimalsFAO
SeriesAgFishtoSeedCephalopodsFAO
SeriesAgFishtoSeedCrustaceansFAO
SeriesAgFishtoSeedDemersalFAO
SeriesAgFishtoSeedFreshwaterFAO
SeriesAgFishtoSeedMarineFAO
SeriesAgFishtoSeedMolluscsFAO
SeriesAgFishtoSeedPelagicFAO
SeriesAgMeatEx
SeriesAgMeatIm
SeriesAgMeatOtherProductionFAO
SeriesAgMuttonandGoatMeatProductionFAO
SeriesAgPigMeatProductionFAO
SeriesAgPoultryMeatProductionFAO


AGCrop Series
SeriesAGCropCalPerCapPerDayFAO
SeriesAGCropDomesticSupplyFAO
SeriesAGCropExportsFAO
SeriesAGCropFoodSupplyPerCapPerDayFAO
SeriesAGCropImportsFAO
SeriesAGCropProductionFAO
SeriesAGCropProteinPerCapPerDayFAO
SeriesAGCroptoFeedFAO
SeriesAGCroptoFoodFAO
SeriesAGCroptoFoodManuFAO
SeriesAGCroptoOtherUtilFAO
SeriesAGCroptoSeedFAO
SeriesAGCroptoWasteFAO


AGMeat Series
SeriesAGMeatCalPerCapPerDayFAO
SeriesAGMeatDomesticSupplyFAO
SeriesAGMeatExportsFAO
SeriesAGMeatFoodSupplyPerCapPerDayFAO
SeriesAGMeatImportsFAO
SeriesAGMeatProductionFAO
SeriesAGMeatProteinPerCapPerDayFAO
SeriesAGMeattoFeedFAO
SeriesAGMeattoFoodFAO
SeriesAGMeattoFoodManuFAO
SeriesAGMeattoOtherUtilFAO
SeriesAGMeattoSeedFAO
SeriesAGMeattoWasteFAO


AGPulses Series
SeriesAgPulsesEx
SeriesAgPulsesIm

Instructions for pulling FAOSTAT FBS series

The FAOSTAT FBS series are blended from two datasets: The historical data goes from 1961 to 2013 while the preliminary data goes from 2014 to 2017. Both datasets are from the FAOSTAT website.

  1. The data can be accessed on the FAOSTAT website. Historical data series are available here <http://www.fao.org/faostat/en/#data/FBSH> and preliminary data series are available here <http://www.fao.org/faostat/en/#data/FBS>.
  2. Download 'All Data Normalized' under Bulk Downloads.
  3. Apply Python script. There are 128 standard series, 13 series starting with "AGCrop", 13 series starting with "AGMeat", and 2 series starting with "AGPulses". Different scripts are used to pull each category. The series are sorted by category in the tables above.

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.