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

32 rows where sourceId = 17906 sorted by id descending

✎ View and edit SQL

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
143656 CSP LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Concentrated solar power levelized cost of energy",
    "unit": "2019 US$ per kilowatt-hour",
    "shortUnit": "$/kWh",
    "includeInTable": true
}
 0           1                                  
143655 CSP capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Concentrated solar power capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143654 CSP total installed costs (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Concentrated solar power total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143653 Bioenergy LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Bioenergy levelized cost of energy",
    "unit": "2019 US$ per kilowatt-hour",
    "shortUnit": "$/kWh",
    "includeInTable": true
}
 0           1                                  
143652 Bioenergy capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Bioenergy capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143651 Bioenergy total installed costs (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Bioenergy total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143650 Geothermal LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Geothermal levelized cost of energy",
    "unit": "2019 US$ per kilowatt-hour",
    "shortUnit": "$/kWh",
    "includeInTable": true
}
 0           1                                  
143649 Geothermal capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Geothermal capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143648 Geothermal total installed costs (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Geothermal total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143647 Hydro LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Hydropower levelized cost of energy",
    "unit": "2019 US$ per kilowatt-hour",
    "shortUnit": "$/kWh",
    "includeInTable": true
}
 0           1                                  
143646 Hydro capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Hydropower capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143645 Hydro total installed costs, small     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Small hydropower total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143644 Hydro total installed costs, large     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Large hydropower total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143643 Hydro total installed costs (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Hydropower total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143642 Offshore wind LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Offshore wind levelized cost of energy",
    "unit": "2019 US$ per kilowatt-hour",
    "shortUnit": "$/kWh",
    "includeInTable": true
}
 0           1                                  
143641 Offshore wind capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Offshore wind capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143640 Offshore wind total installed costs (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{}
 0           1                                  
143639 Offshore wind average project capacity (MW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Offshore wind average project capacity",
    "unit": "megawatts",
    "shortUnit": "MW",
    "includeInTable": true
}
 0           1                                  
143638 Offshore wind average turbine rating (MW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Offshore wind average turbine rating",
    "unit": "megawatts",
    "shortUnit": "MW",
    "includeInTable": true
}
 0           1                                  
143637 Solar PV module price (2019 USD/W)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Solar PV module price",
    "unit": "2019 US$ per watt",
    "shortUnit": "$/W",
    "includeInTable": true
}
 0           1                                  
143636 Solar LCOE, commercial (USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Commercial solar levelized cost of energy",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143635 Solar LCOE, residential (USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Residential solar levelized cost of energy",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143634 Solar capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Solar PV capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143633 Total installed solar cost, commercial     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Commercial solar total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143632 Total installed solar cost, residential     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Residential solar total installed cost",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143631 Solar LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Solar levelised cost of energy",
    "unit": "2019 US$ per kilowatt-hour",
    "shortUnit": "$/kWh",
    "includeInTable": true
}
 0           1                                  
143630 Total installed solar cost (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Solar PV total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143629 Onshore wind LCOE (2019 USD/kWh)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{}
 0           1                                  
143628 Onshore wind capacity factor     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Onshore wind capacity factor",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "conversionFactor": 100
}
 0           1                                  
143627 Total installed cost onshore wind (2019 USD/kW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Onshore wind total installed costs",
    "unit": "2019 US$ per kilowatt",
    "shortUnit": "$/kW",
    "includeInTable": true
}
 0           1                                  
143626 Onshore turbine rotor diameter (m)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Onshore turbine rotor diameter",
    "unit": "meters",
    "shortUnit": "m",
    "includeInTable": true
}
 0           1                                  
143625 Onshore wind turbine nameplate capacity (MW)     2020-09-30 09:45:37 2023-06-15 05:05:42       Renewable energy costs (IRENA, 2020) 5176 International Renewable Energy Agency (IRENA) 17906   
{
    "name": "Onshore wind turbine nameplate capacity",
    "unit": "megawatts",
    "shortUnit": "MW",
    "includeInTable": true
}
 0           1                                  

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