FAOSTAT FBS: Difference between revisions
Jump to navigation
Jump to search
Ifsdatateam (talk | contribs) No edit summary |
Ifsdatateam (talk | contribs) No edit summary |
||
| Line 339: | 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 | 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. | ||
#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> | #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. | #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. | ||
Revision as of 17:22, 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.
- 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.
- Download 'All Data Normalized' under Bulk Downloads.
- 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.