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

3 rows where datasetId = 6269 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updatedAt, 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
815382 Period life expectancy at birth - Sex: female years   2023-10-12 13:06:19 2024-07-08 16:31:26     1960-2022 Life expectancy at birth 6269   years 
{
    "name": "Life expectancy at birth, females, period",
    "unit": "years",
    "shortUnit": "years",
    "numDecimalPlaces": 1
}
 0     life_expectancy_birth__sex_female grapher/oecd/2023-10-11/life_expectancy_birth/life_expectancy_birth#life_expectancy_birth__sex_female 
{
    "filters": [
        {
            "name": "sex",
            "value": "female"
        }
    ],
    "originalName": "Period life expectancy at birth",
    "originalShortName": "life_expectancy_birth"
}
 2 minor   Life expectancy at birth females, period tables OECD   The period life expectancy at birth among females, in a given year. Life expectancy at birth is defined as how long, on average, a newborn can expect to live, if current death rates do not change. However, the actual age-specific death rate of any particular birth cohort cannot be known in advance. If rates are falling, actual life spans will be higher than life expectancy calculated using current death rates. Life expectancy at birth is one of the most frequently used health status indicators. Gains in life expectancy at birth can be attributed to a number of factors, including rising living standards, improved lifestyle and better education, as well as greater access to quality health services. This indicator is presented as a total and per gender and is measured in years. 
[
    "Period life expectancy is a metric that summarizes death rates across all age groups in one particular year.",
    "For a given year, it represents the average lifespan for a hypothetical group of people, if they experienced the same age-specific death rates throughout their lives as the age-specific death rates seen in that particular year."
]
       
{
    "selectedEntityNames": [
        "Japan",
        "Spain",
        "France",
        "Australia",
        "United Kingdom",
        "United States",
        "Mexico",
        "Russia",
        "South Africa"
    ]
}
 float 
[]
 cba66adb59522610d014b98f399ee56b 318701850f17b83631896abaefc05f99
815381 Period life expectancy at birth - Sex: all years   2023-10-12 13:06:19 2024-07-08 16:31:25     1960-2022 Life expectancy at birth 6269   years 
{
    "name": "Life expectancy at birth, period",
    "unit": "years",
    "shortUnit": "years",
    "numDecimalPlaces": 1
}
 0     life_expectancy_birth__sex_all grapher/oecd/2023-10-11/life_expectancy_birth/life_expectancy_birth#life_expectancy_birth__sex_all 
{
    "filters": [
        {
            "name": "sex",
            "value": "all"
        }
    ],
    "originalName": "Period life expectancy at birth",
    "originalShortName": "life_expectancy_birth"
}
 2 minor   Life expectancy at birth period tables OECD   The period life expectancy at birth, in a given year. Life expectancy at birth is defined as how long, on average, a newborn can expect to live, if current death rates do not change. However, the actual age-specific death rate of any particular birth cohort cannot be known in advance. If rates are falling, actual life spans will be higher than life expectancy calculated using current death rates. Life expectancy at birth is one of the most frequently used health status indicators. Gains in life expectancy at birth can be attributed to a number of factors, including rising living standards, improved lifestyle and better education, as well as greater access to quality health services. This indicator is presented as a total and per gender and is measured in years. 
[
    "Period life expectancy is a metric that summarizes death rates across all age groups in one particular year.",
    "For a given year, it represents the average lifespan for a hypothetical group of people, if they experienced the same age-specific death rates throughout their lives as the age-specific death rates seen in that particular year."
]
       
{
    "selectedEntityNames": [
        "Japan",
        "Spain",
        "France",
        "Australia",
        "United Kingdom",
        "United States",
        "Mexico",
        "Russia",
        "South Africa"
    ]
}
 float 
[]
 1d35fa99bce7c14fb7afb1f1241edbcf 83fee4efafbc063c39de90aeca71085c
815380 Period life expectancy at birth - Sex: male years   2023-10-12 13:06:19 2024-07-08 16:31:25     1960-2022 Life expectancy at birth 6269   years 
{
    "name": "Life expectancy at birth, males, period",
    "unit": "years",
    "shortUnit": "years",
    "numDecimalPlaces": 1
}
 0     life_expectancy_birth__sex_male grapher/oecd/2023-10-11/life_expectancy_birth/life_expectancy_birth#life_expectancy_birth__sex_male 
{
    "filters": [
        {
            "name": "sex",
            "value": "male"
        }
    ],
    "originalName": "Period life expectancy at birth",
    "originalShortName": "life_expectancy_birth"
}
 2 minor   Life expectancy at birth males, period tables OECD   The period life expectancy at birth among males, in a given year. Life expectancy at birth is defined as how long, on average, a newborn can expect to live, if current death rates do not change. However, the actual age-specific death rate of any particular birth cohort cannot be known in advance. If rates are falling, actual life spans will be higher than life expectancy calculated using current death rates. Life expectancy at birth is one of the most frequently used health status indicators. Gains in life expectancy at birth can be attributed to a number of factors, including rising living standards, improved lifestyle and better education, as well as greater access to quality health services. This indicator is presented as a total and per gender and is measured in years. 
[
    "Period life expectancy is a metric that summarizes death rates across all age groups in one particular year.",
    "For a given year, it represents the average lifespan for a hypothetical group of people, if they experienced the same age-specific death rates throughout their lives as the age-specific death rates seen in that particular year."
]
       
{
    "selectedEntityNames": [
        "Japan",
        "Spain",
        "France",
        "Australia",
        "United Kingdom",
        "United States",
        "Mexico",
        "Russia",
        "South Africa"
    ]
}
 float 
[]
 0f31ea502e35546fd886ce4006a65831 486cc3ac1a26c5c5efd7910a5e56de89

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