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

19 rows where datasetId = 6115 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updatedAt, 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
737001 Total renewable energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:14     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     total_renewable_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#total_renewable_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
737000 Wind energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:14     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     wind_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#wind_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736999 Solar energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:13     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     solar_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#solar_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736998 Solid biofuels and renewable waste capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:13     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     solid_biofuels_and_renewable_waste grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#solid_biofuels_and_renewable_waste   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736997 Solar photovoltaic capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:13     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     solar_photovoltaic grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#solar_photovoltaic   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736996 Pure pumped storage capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     pure_pumped_storage grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#pure_pumped_storage   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736995 Renewable municipal waste capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:13     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     renewable_municipal_waste grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#renewable_municipal_waste   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736994 Other solid biofuels capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     other_solid_biofuels grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#other_solid_biofuels   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736993 Renewable hydropower including mixed plants capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     renewable_hydropower_including_mixed_plants grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#renewable_hydropower_including_mixed_plants   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736992 Onshore wind energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     onshore_wind_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#onshore_wind_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736991 Offshore wind energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     offshore_wind_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#offshore_wind_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736990 Marine energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     marine_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#marine_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736989 Liquid biofuels capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     liquid_biofuels grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#liquid_biofuels   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736988 Hydropower capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     hydropower grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#hydropower   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736987 Geothermal energy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     geothermal_energy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#geothermal_energy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736986 Concentrated solar power capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     concentrated_solar_power grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#concentrated_solar_power   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736985 Biogas capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     biogas grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#biogas   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736984 Bioenergy capacity megawatts   2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     bioenergy grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#bioenergy   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            
736983 Bagasse capacity megawatts Bagasse is a byproduct from the process of sugar cane refining, often used as a biofuel for the production of heat, energy, and electricity. 2023-07-06 13:22:18 2023-12-14 12:09:12     2000-2022 Renewable electricity capacity (IRENA, 2023-06-26) 6115 International Renewable Energy Agency (IRENA) 28069 MW 
{
    "unit": "megawatts",
    "shortUnit": "MW",
    "numDecimalPlaces": 0
}
 0     bagasse grapher/irena/2023-06-26/renewable_electricity_capacity/renewable_electricity_capacity#bagasse   1                 
[]
   
[
    {
        "url": "https://www.irena.org/-/media/Files/IRENA/Agency/Publication/2023/Mar/IRENA_RE_Capacity_Statistics_2023.pdf",
        "name": "Copyright \u00a9 IRENA 2023"
    }
]
            

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