variables
Data license: CC-BY
13 rows where datasetId = 5274 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145969 | Aviation transport share of food emissions | Share of food system emissions that come from air transport. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Aviation",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 145968 | Shipping transport share of food emissions | Share of food system emissions that come from international shipping. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Shipping",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 145967 | Rail transport share of food emissions | Share of food system emissions that come from rail transport. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Rail",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 145966 | Road transport share of food emissions | Share of food system emissions that come from road transport. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Road",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 145965 | Total emissions from food | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Total",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145964 | End-of-Life food emissions | Greenhouse gas emissions from end-of-life food processing. This includes consumer waste and management of the end-of-life waste from input materials. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Consumer waste",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145963 | Food consumption emissions | Greenhouse gas emissions from food consumption. This includes energy use such as cooking and refrigeration. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Consumer energy (e.g. cooking)",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145962 | Food retail emissions | Greenhouse gas emissions from food retailers. This includes energy production from refrigeration, freezing etc. in retail operations. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Retail",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145961 | Food packaging emissions | Greenhouse gas emissions from food packaging. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Food packaging",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145960 | Food processing emissions | Greenhouse gas emissions from food processing. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Food processing",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145959 | Food transport emissions | Greenhouse gas emissions from food transport emissions. This includes local, regional and international transport from road, rail, shipping and aviation. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Transport",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145958 | Agricultural production emissions | Emissions from agricultural production include enteric fermentation from livestock; methane emissions from rice; emissions from manure and synthetic fertilizer application, in addition to upstream emissions from energy production for agricultural inputs including fertilizers and fuel use in machinery. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Agricultural production",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145957 | Land use change emissions | Greenhouse gas emissions from land use, and land use change from food production. | 2021-03-10 10:48:08 | 2023-06-15 05:05:42 | GHG emissions from food by life-cycle stage (Crippa et al. 2021) 5274 | Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18003 | {
"name": "Land use",
"unit": "tonnes CO\u2082e",
"shortUnit": "t",
"includeInTable": true,
"conversionFactor": 1000000000,
"numDecimalPlaces": 0
} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");