variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

2 rows where datasetId = 4913 sorted by id descending

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license type sort grapherConfigIdAdmin grapherConfigIdETL dataChecksum metadataChecksum
77242
 77242
 110133
 Percentage of food loss by region (FAO, 2019)
   The share of food lost (from post-harvest through to, but not including, retail level) by region. Post-harvest processes include handling and distribution, food processing, transport and distribution to (but not including) retailers and markets. Share of food loss refers to the physical quantity lost for different commodities divided by the amount produced. An economic weight is used to aggregate percentages at regional or commodity group levels, so that higher-value commodities carry more weight in loss estimation than lower-value ones.
 2020-02-07 12:29:12
 2023-06-15 05:05:42
       4913
 17644
   {"name": "Share of food lost in post-harvest processes", "unit": "% of food produced", "shortUnit": "%"}
 0
         1
                                    
77241
 77241
 110132
 Percentage of food loss by food group (FAO, 2019)
   The share of food lost (from post-harvest through to, but not including, retail level) by food group. Post-harvest processes include handling and distribution, food processing, transport and distribution to (but not including) retailers and markets. Share of food loss refers to the physical quantity lost for different commodities divided by the amount produced. An economic weight is used to aggregate percentages at regional or commodity group levels, so that higher-value commodities carry more weight in loss estimation than lower-value ones.
2020-02-07 12:29:12
 2023-06-15 05:05:42
       4913
 17644
   {"name": "Share of food lost in post-harvest processes", "unit": "% of food produces", "shortUnit": "%", "numDecimalPlaces": 1}
 0
         1
                                    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE variables(id INTEGER, "name" VARCHAR, unit VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, code VARCHAR, coverage VARCHAR, timespan VARCHAR, datasetId INTEGER, sourceId INTEGER, shortUnit VARCHAR, display VARCHAR, columnOrder INTEGER, originalMetadata VARCHAR, shortName VARCHAR, catalogPath VARCHAR, dimensions VARCHAR, schemaVersion INTEGER, processingLevel VARCHAR, processingLog VARCHAR, titlePublic VARCHAR, titleVariant VARCHAR, attributionShort VARCHAR, attribution VARCHAR, descriptionShort VARCHAR, descriptionFromProducer VARCHAR, descriptionKey VARCHAR, descriptionProcessing VARCHAR, licenses VARCHAR, license VARCHAR, "type" VARCHAR, sort VARCHAR, grapherConfigIdAdmin VARCHAR, grapherConfigIdETL VARCHAR, dataChecksum VARCHAR, metadataChecksum VARCHAR);;