variables
Data license: CC-BY
4 rows where datasetId = 6595 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
953898 | Gas extracted | kilograms per GWh | The amount of gas that has to be extracted, measured in kilograms per gigawatt-hour (GWh). | 2024-07-16 10:34:37 | 2024-07-24 11:36:40 | 2022-2022 | Material footprint of electricity (Wang et al. 2024) 6595 | kg | { "unit": "kilograms per GWh", "shortUnit": "kg" } |
0 | gas_extracted | grapher/fasttrack/latest/electricity_material_footprint_wang/electricity_material_footprint_wang#gas_extracted | 2 | [] |
int | [] |
ab975ee5d77e4252b7de16cf0264183d | 0c4cc66f63d510b2d0066f433fe6b410 | ||||||||||||||||||
946877 | Rock | kilograms per GWh | Amount of waste rock produced for electricity sources, measured in kilograms per gigawatt-hour (GWh). | 2024-07-01 13:30:46 | 2024-07-24 11:36:40 | 2022-2022 | Material footprint of electricity (Wang et al. 2024) 6595 | kg | { "unit": "kilograms per GWh", "shortUnit": "kg" } |
0 | rock | grapher/fasttrack/latest/electricity_material_footprint_wang/electricity_material_footprint_wang#rock | 2 | [] |
int | [] |
c0c1c94e0e853912dbeaac1903789e5e | 62cd0829c1a3912fb16fde507a43b7f7 | ||||||||||||||||||
946876 | Materials (excl. rock) | kilograms per GWh | Material footprint of each electricity source, excluding waste rock. This is measured in kilograms of material per gigawatt-hour of power (GWh). | 2024-07-01 13:30:46 | 2024-07-24 11:36:40 | 2022-2022 | Material footprint of electricity (Wang et al. 2024) 6595 | kg | { "unit": "kilograms per GWh", "shortUnit": "kg" } |
0 | material_footprint_excl_rock | grapher/fasttrack/latest/electricity_material_footprint_wang/electricity_material_footprint_wang#material_footprint_excl_rock | 2 | [] |
int | [] |
487defba520d115b3b579c2dc6119269 | 6c03d534e37fb8a531cbfc80ec2af6ec | ||||||||||||||||||
946875 | Materials (incl. rock) | kilograms per GWh | Material footprint of each electricity source, including waste rock. This is measured in kilograms of material per gigawatt-hour of power (GWh). | 2024-07-01 13:30:46 | 2024-07-24 11:36:40 | 2022-2022 | Material footprint of electricity (Wang et al. 2024) 6595 | kg | { "unit": "kilograms per GWh", "shortUnit": "kg" } |
0 | material_footprint_incl_rock | grapher/fasttrack/latest/electricity_material_footprint_wang/electricity_material_footprint_wang#material_footprint_incl_rock | 2 | [] |
int | [] |
5c80367d43df327cd3b30761822cec67 | 278284e0eac3efc88ce6ef7c0ea2e931 |
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");