sources
Data license: CC-BY
1 row where datasetId = 5712 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
26735 | Food and Agriculture Organization of the United Nations | { "link": "http://www.fao.org/faostat/en/#data", "retrievedDate": "2022-05-17", "additionalInfo": "For detailed description of the indicators below see attached document: Average Dietary Supply Adequacy; Average Value of Food Production; Share of Dietary Energy Supply Derived from Cereals, Roots and Tubers; Average Protein Supply; Average Supply of Protein of Animal Origin; Rail lines Density (per 100 square km of land area); Percentage of Population Using At Least Basic Drinking Water Sources; Percentage of Population Using Safely Managed Drinking Water Sources; Percentage of Population Using At Least Basic Sanitation Services; Percentage of Population Using Safely Managed Sanitation Services; Cereal Import Dependency Ratio; Percent of Arable Land Equipped for Irrigation; Value of Food Imports in Total Merchandise Exports; Political Stability and Absence of Violence; Domestic Food Price Volatility Index; Per capita food production variability; Per Capita Food Supply Variability; Prevalence of Undernourishment; Prevalence of Severe Food Insecurity; Prevalence of Moderate or Severe Food Insecurity; Children aged <5 years wasted (%); Children aged <5 years stunted (%); Children aged <5 years overweight (%); Percentage of Adult Obesity; Prevalence of Anaemia among Women of Reproductive Age; Prevalence of Exclusive Breastfeeding among Infants 0-5 Months of Age; Prevalence of Low Birthweight; Number of Undernourished People; Number of Severely Food Insecure People; Prevalence of Moderately or Severely Food Insecure People; Minimum Dietary Energy Requirement (MDER); Average Dietary Energy Requirement (ADER); Coefficient of Variation of Habitual Caloric Consumption Distribution (CV); Skewness of Habitual Caloric Consumption Distribution (SK); Incidence of Caloric Losses at Retail Distribution Level; Dietary Energy Supply (DES); Average Fat Supply", "dataPublishedBy": "Food and Agriculture Organization of the United Nations", "dataPublisherSource": null } |
2022-08-23 19:50:51 | 2022-08-23 19:50:51 | Food Security: Suite of Food Security Indicators (FAO, 2022-05-17) 5712 | For detailed description of the indicators below see attached document: Average Dietary Supply Adequacy; Average Value of Food Production; Share of Dietary Energy Supply Derived from Cereals, Roots and Tubers; Average Protein Supply; Average Supply of Protein of Animal Origin; Rail lines Density (per 100 square km of land area); Percentage of Population Using At Least Basic Drinking Water Sources; Percentage of Population Using Safely Managed Drinking Water Sources; Percentage of Population Using At Least Basic Sanitation Services; Percentage of Population Using Safely Managed Sanitation Services; Cereal Import Dependency Ratio; Percent of Arable Land Equipped for Irrigation; Value of Food Imports in Total Merchandise Exports; Political Stability and Absence of Violence; Domestic Food Price Volatility Index; Per capita food production variability; Per Capita Food Supply Variability; Prevalence of Undernourishment; Prevalence of Severe Food Insecurity; Prevalence of Moderate or Severe Food Insecurity; Children aged <5 years wasted (%); Children aged <5 years stunted (%); Children aged <5 years overweight (%); Percentage of Adult Obesity; Prevalence of Anaemia among Women of Reproductive Age; Prevalence of Exclusive Breastfeeding among Infants 0-5 Months of Age; Prevalence of Low Birthweight; Number of Undernourished People; Number of Severely Food Insecure People; Prevalence of Moderately or Severely Food Insecure People; Minimum Dietary Energy Requirement (MDER); Average Dietary Energy Requirement (ADER); Coefficient of Variation of Habitual Caloric Consumption Distribution (CV); Skewness of Habitual Caloric Consumption Distribution (SK); Incidence of Caloric Losses at Retail Distribution Level; Dietary Energy Supply (DES); Average Fat Supply | http://www.fao.org/faostat/en/#data | Food and Agriculture Organization of the United Nations |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");