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

12 rows where sourceId = 29213 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, timespan, shortUnit, display, schemaVersion, licenses, 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
815771 Other renewable electricity excluding bioenergy per capita (kWh) (adapted for visualization of chart per-capita-electricity-source-stacked) kilowatt-hours   2023-10-31 08:49:46 2023-12-19 13:34:05     1985-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 kWh 
{
    "name": "Other renewable electricity excluding bioenergy per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     per_capita_other_renewables_excluding_bioenergy_generation__kwh_chart_per_capita_electricity_source_stacked grapher/energy/2023-07-10/electricity_mix/electricity_mix#per_capita_other_renewables_excluding_bioenergy_generation__kwh_chart_per_capita_electricity_source_stacked   2 major               
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
            
815770 Bioenergy electricity per capita (kWh) (adapted for visualization of chart per-capita-electricity-source-stacked) kilowatt-hours   2023-10-31 08:49:45 2023-12-19 13:34:04     1985-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 kWh 
{
    "name": "Bioenergy electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     per_capita_bioenergy_generation__kwh_chart_per_capita_electricity_source_stacked grapher/energy/2023-07-10/electricity_mix/electricity_mix#per_capita_bioenergy_generation__kwh_chart_per_capita_electricity_source_stacked   2 major               
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
            
815749 Electricity from bioenergy (TWh) (adapted for visualization of chart electricity-prod-source-stacked) terawatt-hours   2023-10-31 08:49:40 2023-12-19 13:34:00     1985-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 TWh 
{
    "name": "Bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     bioenergy_generation__twh_chart_electricity_prod_source_stacked grapher/energy/2023-07-10/electricity_mix/electricity_mix#bioenergy_generation__twh_chart_electricity_prod_source_stacked   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
815748 Other renewables excluding bioenergy (TWh) (adapted for visualization of chart electricity-prod-source-stacked) terawatt-hours   2023-10-31 08:49:40 2023-12-19 13:34:00     1985-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 TWh 
{
    "name": "Other renewables, excluding bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     other_renewables_excluding_bioenergy_generation__twh_chart_electricity_prod_source_stacked grapher/energy/2023-07-10/electricity_mix/electricity_mix#other_renewables_excluding_bioenergy_generation__twh_chart_electricity_prod_source_stacked   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
737715 Net imports (TWh) terawatt-hours   2023-07-17 14:30:59 2023-12-19 13:33:59     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 TWh 
{
    "name": "Net imports",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     total_net_imports__twh grapher/energy/2023-07-10/electricity_mix/electricity_mix#total_net_imports__twh   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
737713 Emissions (MtCO2) million tonnes CO2 equivalent   2023-07-17 14:30:58 2023-12-19 13:33:59     2000-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 million t 
{
    "name": "Emissions",
    "unit": "million tonnes CO2 equivalent",
    "shortUnit": "million t"
}
 0     total_emissions__mtco2 grapher/energy/2023-07-10/electricity_mix/electricity_mix#total_emissions__mtco2   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
737711 Electricity demand (TWh) terawatt-hours   2023-07-17 14:30:58 2023-12-19 13:33:58     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 TWh 
{
    "name": "Electricity demand",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     total_demand__twh grapher/energy/2023-07-10/electricity_mix/electricity_mix#total_demand__twh   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
737697 Other renewable electricity excluding bioenergy per capita (kWh) kilowatt-hours   2023-07-17 14:30:53 2023-12-19 13:33:55     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 kWh 
{
    "name": "Other renewable electricity excluding bioenergy per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     per_capita_other_renewables_excluding_bioenergy_generation__kwh grapher/energy/2023-07-10/electricity_mix/electricity_mix#per_capita_other_renewables_excluding_bioenergy_generation__kwh   2 major               
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
            
737689 Bioenergy electricity per capita (kWh) kilowatt-hours   2023-07-17 14:30:51 2023-12-19 13:33:53     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 kWh 
{
    "name": "Bioenergy electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     per_capita_bioenergy_generation__kwh grapher/energy/2023-07-10/electricity_mix/electricity_mix#per_capita_bioenergy_generation__kwh   2 major               
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
            
737685 Other renewables excluding bioenergy (TWh) terawatt-hours   2023-07-17 14:30:49 2023-12-19 13:33:52     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 TWh 
{
    "name": "Other renewables, excluding bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     other_renewables_excluding_bioenergy_generation__twh grapher/energy/2023-07-10/electricity_mix/electricity_mix#other_renewables_excluding_bioenergy_generation__twh   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
737680 Net electricity imports as a share of demand (%) %   2023-07-17 14:30:47 2023-12-19 13:33:51     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 % 
{
    "name": "Net electricity imports as a share of demand",
    "unit": "%",
    "shortUnit": "%"
}
 0     net_imports_share_of_demand__pct grapher/energy/2023-07-10/electricity_mix/electricity_mix#net_imports_share_of_demand__pct   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            
737667 Electricity from bioenergy (TWh) terawatt-hours   2023-07-17 14:30:41 2023-12-19 13:33:47     1990-2022 Electricity mix (EI & Ember, 2023) 6133 Ember; Ember's European Electricity Review (2022) 29213 TWh 
{
    "name": "Bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     bioenergy_generation__twh grapher/energy/2023-07-10/electricity_mix/electricity_mix#bioenergy_generation__twh   1                 
[]
   
[
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons ShareAlike Attribution Licence (CC BY-SA 4.0)"
    },
    {
        "url": "https://ember-climate.org/creative-commons/",
        "name": "Creative Commons BY-SA 4.0"
    }
]
            

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");