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

22 rows where datasetId = 6628 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, shortUnit, display, processingLevel, descriptionShort, descriptionKey, type, createdAt (date), updatedAt (date), descriptionKey (array)

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
953966 Global sea level as an average of Church and White (2011) and UHSLC data millimeters   2024-07-23 10:09:49 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   mm 
{
    "unit": "millimeters",
    "zeroDay": "1850-01-15",
    "shortUnit": "mm",
    "yearIsDay": true
}
 0     sea_level_average grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_level_average   2                 
[]
         float 
[]
 ad9dcff5b4b0ebc1d3bb86e06446b18d 8fbe7e3b411bb3414e2147ac9c25ffdb
953965 Global sea level according to UHSLC millimeters   2024-07-23 10:09:49 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   mm 
{
    "unit": "millimeters",
    "zeroDay": "1850-01-15",
    "shortUnit": "mm",
    "yearIsDay": true
}
 0     sea_level_uhslc grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_level_uhslc   2                 
[]
         float 
[]
 54da2f44b1225bf2b53bdefe670ac61a f53392fa759c93269244dbbd4ad9950c
953964 Global sea level according to Church and White (2011) millimeters   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   mm 
{
    "unit": "millimeters",
    "zeroDay": "1850-01-15",
    "shortUnit": "mm",
    "yearIsDay": true
}
 0     sea_level_church_and_white_2011 grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_level_church_and_white_2011   2                 
[]
         float 
[]
 0d0b25e7d54fa4b4591adc064606024f a959b4a2d7d08af9f09bc1853372f906
953963 Rolling yearly average of the concentration of atmospheric nitrous oxide parts per billion   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   ppb 
{
    "unit": "parts per billion",
    "zeroDay": "1850-01-15",
    "shortUnit": "ppb",
    "yearIsDay": true
}
 0     n2o_concentration_yearly_average grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#n2o_concentration_yearly_average   2 major           Measured in parts per million.   
[]
         float 
[]
 561b4f8e5c9d68b123bf58607b6d6251 448ed09cb6528f2447da262feaee6276
953962 Rolling yearly average of the concentration of atmospheric methane parts per billion   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   ppb 
{
    "unit": "parts per billion",
    "zeroDay": "1850-01-15",
    "shortUnit": "ppb",
    "yearIsDay": true
}
 0     ch4_concentration_yearly_average grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#ch4_concentration_yearly_average   2 major           Measured in parts per million.   
[]
         float 
[]
 79f0fb62bda32e07ffb0cc79e86226f0 78f2d1e7aee5c9e23f66b8b29eaaad83
953961 Monthly concentration of atmospheric nitrous oxide parts per billion   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   ppb 
{
    "unit": "parts per billion",
    "zeroDay": "1850-01-15",
    "shortUnit": "ppb",
    "yearIsDay": true
}
 0     n2o_concentration grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#n2o_concentration   2 minor           Measured in parts per million.   
[]
         float 
[]
 517535820cb739cb616f33e60bc76740 152d82cdd385e9b6d1ff8061c2d23668
953960 Monthly concentration of atmospheric methane parts per billion   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   ppb 
{
    "unit": "parts per billion",
    "zeroDay": "1850-01-15",
    "shortUnit": "ppb",
    "yearIsDay": true
}
 0     ch4_concentration grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#ch4_concentration   2 minor           Measured in parts per million.   
[]
         float 
[]
 8f5180855ffe0eb972ca8580c10493a2 3e89989930f031ca5fabd44f651af4cc
953959 Rolling yearly average of the concentration of atmospheric carbon dioxide parts per million   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   ppm 
{
    "unit": "parts per million",
    "zeroDay": "1850-01-15",
    "shortUnit": "ppm",
    "yearIsDay": true
}
 0     co2_concentration_yearly_average grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#co2_concentration_yearly_average   2 major           Measured in parts per million.   
[]
         float 
[]
 70dc6667ad82c41ffd0f85aa50129975 a9bd262c23d3df8f3417cbd0dff18611
953958 Monthly concentration of atmospheric carbon dioxide parts per million   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   ppm 
{
    "unit": "parts per million",
    "zeroDay": "1850-01-15",
    "shortUnit": "ppm",
    "yearIsDay": true
}
 0     co2_concentration grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#co2_concentration   2 minor           Measured in parts per million.   
[]
         float 
[]
 f16955d07638feace598c985baff96db 46987de6588d4bf92e502320c9acea3e
953957 Cumulative change in mass in the ice sheets, according to NASA/JPL billion tonnes   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   billion t 
{
    "unit": "billion tonnes",
    "zeroDay": "1850-01-15",
    "shortUnit": "billion t",
    "yearIsDay": true
}
 0     land_ice_mass_nasa grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#land_ice_mass_nasa   2 major     NASA/JPL     Measured in billion tonnes.   
[
    "Values are centered at zero in 2002 to provide a consistent point of reference.",
    "A downward slope indicates a net loss of ice and snow.",
    "For reference, 1,000 billion metric tons is enough to raise sea level by about 3 millimeters."
]
         float 
[]
 65aecc9678112d671cc415b87fbdf4da 4e369db750133ffb975e074061ae69fe
953954 Rolling yearly average of the area covered by snow square kilometers   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   km² 
{
    "unit": "square kilometers",
    "zeroDay": "1850-01-15",
    "shortUnit": "km\u00b2",
    "yearIsDay": true
}
 0     snow_cover_extent_yearly_average grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#snow_cover_extent_yearly_average   2 major           Measured in square kilometers.   
[]
         float 
[]
 11bba790525466a309794fa41fbe55a1 aedc5c950a1560ba082389211874d9bc
953953 Cumulative change in mass in the ice sheets, according to IMBIE billion tonnes   2024-07-23 10:09:48 2024-07-31 07:49:59       Climate Change Impacts - Monthly 6628   billion t 
{
    "unit": "billion tonnes",
    "zeroDay": "1850-01-15",
    "shortUnit": "billion t",
    "yearIsDay": true
}
 0     cumulative_ice_mass_change_imbie grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#cumulative_ice_mass_change_imbie   2 major     IMBIE     Measured in billion tonnes. Based on more than 20 different studies that have been combined for each region.   
[
    "Values are centered at zero in 2002 to provide a consistent point of reference.",
    "A downward slope indicates a net loss of ice and snow.",
    "For reference, 1,000 billion metric tons is enough to raise sea level by about 3 millimeters."
]
         float 
[]
 c815afe23b8b10ce34e9540284e933ad 1eccd438841e71706125a69f22103cf0
953952 Monthly measurement of the area covered by snow square kilometers   2024-07-23 10:09:48 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   km² 
{
    "unit": "square kilometers",
    "zeroDay": "1850-01-15",
    "shortUnit": "km\u00b2",
    "yearIsDay": true
}
 0     snow_cover_extent grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#snow_cover_extent   2 minor           Measured in square kilometers.   
[]
         int 
[]
 644d6e5ca52c0c6fdf4772a85dcd0679 e0d844a214e0c29feb89a53caffd9348
953948 Rolling yearly average of ocean pH levels pH   2024-07-23 10:09:48 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   pH 
{
    "unit": "pH",
    "zeroDay": "1850-01-15",
    "shortUnit": "pH",
    "yearIsDay": true
}
 0     ocean_ph_yearly_average grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#ocean_ph_yearly_average   2 major               
[]
         float 
[]
 1ae301c394136cd7055d2a790cdc8bf4 f79e20a8e89c482ebb20d2728d5d63c8
953947 Monthly measurement of ocean pH levels pH   2024-07-23 10:09:48 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   pH 
{
    "unit": "pH",
    "zeroDay": "1850-01-15",
    "shortUnit": "pH",
    "yearIsDay": true
}
 0     ocean_ph grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#ocean_ph   2 minor               
[]
         float 
[]
 e14d1440bbe909f08a67f70a9559356d 04dca4bd20cf8ad632a15aeb100c1e27
953946 Monthly average ocean heat content for the 0-700 meters layer 10²² Joules   2024-07-23 10:09:47 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   10²² J 
{
    "unit": "10\u00b2\u00b2 Joules",
    "zeroDay": "1850-01-15",
    "shortUnit": "10\u00b2\u00b2 J",
    "yearIsDay": true
}
 0     ocean_heat_content_700m grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#ocean_heat_content_700m   2 minor           Measured in 10²² Joules.   
[]
         float 
[]
 27c97aae38c0f3d0d4f897215c6fd614 21d17bf6442a199394fb2c59ad31adb3
953945 Monthly average ocean heat content for the 0-2000 meters layer 10²² Joules   2024-07-23 10:09:47 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   10²² J 
{
    "unit": "10\u00b2\u00b2 Joules",
    "zeroDay": "1850-01-15",
    "shortUnit": "10\u00b2\u00b2 J",
    "yearIsDay": true
}
 0     ocean_heat_content_2000m grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#ocean_heat_content_2000m   2 minor           Measured in 10²² Joules.   
[]
         float 
[]
 431d493257a68e761085f222fb50f758 ae1620875277cd4619dc6aadc76c90f8
953939 Monthly sea surface temperature anomaly (upper bound) °C   2024-07-23 10:09:46 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   °C 
{
    "unit": "\u00b0C",
    "zeroDay": "1850-01-15",
    "shortUnit": "\u00b0C",
    "yearIsDay": true
}
 0     sea_temperature_anomaly_high grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_temperature_anomaly_high   2 minor           Measured in degrees Celsius.   
[]
         float 
[]
 51ede8fb9aed9be141fbbd18ff817925 2d211d9facbc2cabc87baee12169112e
953938 Monthly sea surface temperature anomaly (lower bound) °C   2024-07-23 10:09:46 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   °C 
{
    "unit": "\u00b0C",
    "zeroDay": "1850-01-15",
    "shortUnit": "\u00b0C",
    "yearIsDay": true
}
 0     sea_temperature_anomaly_low grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_temperature_anomaly_low   2 minor           Measured in degrees Celsius.   
[]
         float 
[]
 46fc32051724e94ebca6cd25ea49d8c7 e59034354e29747ec81053668917277b
953937 Monthly sea surface temperature anomaly °C   2024-07-23 10:09:46 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   °C 
{
    "unit": "\u00b0C",
    "zeroDay": "1850-01-15",
    "shortUnit": "\u00b0C",
    "yearIsDay": true
}
 0     sea_temperature_anomaly grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_temperature_anomaly   2 minor           Measured in degrees Celsius.   
[]
         float 
[]
 049af4b1a8499db7dc28d6831a92f601 4870a8039d45388dc92daf0f2673adbe
953936 Global warming: monthly temperature anomaly °C   2024-07-23 10:09:46 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   °C 
{
    "unit": "\u00b0C",
    "zeroDay": "1850-01-15",
    "shortUnit": "\u00b0C",
    "yearIsDay": true
}
 0     temperature_anomaly grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#temperature_anomaly   2 minor           Combined land-surface air and sea-surface water temperature anomaly, given as the deviation from the 1951-1980 mean, in degrees Celsius.   
[]
         float 
[]
 aa016df2542ba46e7cbd6975ed8f5f8b 93f2e6c62d60a728b99a593d7e397da0
953933 Sea ice extent million square kilometers   2024-07-23 10:09:46 2024-07-31 07:49:58       Climate Change Impacts - Monthly 6628   million km² 
{
    "unit": "million square kilometers",
    "zeroDay": "1850-01-15",
    "shortUnit": "million km\u00b2",
    "yearIsDay": true
}
 0     sea_ice_extent grapher/climate/2024-07-23/climate_change_impacts_monthly/climate_change_impacts_monthly#sea_ice_extent   2 minor               
[]
         float 
[]
 d835670e948e6b0e407afea6599208ba b68e99b15e3251c3445719af74a4a915

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