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

47 rows where sourceId = 21965 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
414060 Other renewables including bioenergy (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Other renewables, including bioenergy",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414059 Other renewables excluding bioenergy (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Other renewables, excluding bioenergy",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414058 Bioenergy (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Bioenergy",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414057 Hydro (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Hydropower",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414056 Wind (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Wind",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414055 Solar (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Solar",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414054 Nuclear (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Nuclear",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414053 Low-carbon electricity (% electricity)   Low-carbon electricity is the sum of electricity from nuclear and renewable sources (including solar, wind, hydropower, biomass and waste, geothermal and wave and tidal). 2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Share of electricity from low-carbon sources",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414052 Renewables (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Renewables",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0           1                                  
414051 Fossil fuels (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Fossil fuels",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414050 Gas (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Gas",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414049 Oil (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Oil",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414048 Coal (% electricity)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Coal",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414047 Net electricity imports as a share of demand     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{}
 0           1                                  
414046 Electricity as share of primary energy     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Electricity as share of primary energy",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
414045 Other renewable electricity including bioenergy per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Other renewable electricity per capita, including bioenergy",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414044 Other renewable electricity excluding bioenergy per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Other renewable electricity per capita, excluding bioenergy",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414043 Bioenergy electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Bioenergy electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414042 Hydro electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Hydro electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414041 Wind electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Wind electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414040 Solar electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Solar electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414039 Nuclear electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Nuclear electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414038 Low-carbon electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Low-carbon electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414037 Renewable electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Renewable electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414036 Fossil fuel electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Fossil fuel electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414035 Gas electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Gas electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414034 Oil electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{}
 0           1                                  
414033 Coal electricity per capita (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Coal electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414032 Per capita electricity (kWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Per capita electricity use",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
414031 Carbon intensity of electricity (gCO2/kWh)   Carbon intensity of electricity production is measured in grams of carbon dioxide (CO₂) emitted per kilowatt-hour (kWh). 2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Carbon intensity of electricity per kWh",
    "unit": "grams CO\u2082 per kilowatt-hour",
    "shortUnit": "gCO\u2082",
    "includeInTable": true
}
 0           1                                  
414030 Electricity from wind (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Wind",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414029 Electricity from solar (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Solar",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414028 Electricity from renewables (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Renewables",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414027 Electricity from other renewables including bioenergy (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Other renewables, including bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414026 Electricity from other renewables excluding bioenergy (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Other renewables excluding bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414025 Electricity from oil (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Oil",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414024 Electricity from nuclear (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Nuclear",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414023 Net imports (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Net imports",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414022 Low-carbon electricity (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Low-carbon electricity",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414021 Electricity from hydro (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Hydropower",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414020 Electricity from gas (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Gas",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414019 Electricity from fossil fuels (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Fossil fuels",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414018 Emissions (MtCO2)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Emissions",
    "unit": "million tonnes CO2 equivalent",
    "shortUnit": "million t",
    "includeInTable": true
}
 0           1                                  
414017 Electricity generation (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Electricity generation",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414016 Electricity demand (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Electricity demand",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414015 Electricity from coal (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Coal",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
414014 Electricity from bioenergy (TWh)     2022-04-08 12:20:51 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) 5574 Our World in Data based on BP Statistical Review of World Energy, Ember Global Electricity Review (2022) & Ember European Electricity Review (2022) 21965   
{
    "name": "Bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "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");