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

36 rows where datasetId = 5148 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, display, 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
243991 deaths_2020_2022_all_ages   Reported number of weekly or monthly deaths from all causes for all ages for 2020–2022. 2022-01-20 16:46:20 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
241706 deaths_2022_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2022. 2022-01-15 20:55:37 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
179997 excess_per_million_proj_all_ages   The number of excess deaths per million people in the population; calculated as reported deaths minus projected deaths 2021-11-08 23:06:05 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
176425 cum_excess_per_million_proj_all_ages   The cumulative number of excess deaths per million people in the population; cumulated starting 1 January 2020 2021-09-27 20:03:57 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176383 p_proj_85p   P-scores using projected baseline for ages 85 and above 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 85+",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176382 p_proj_75_84   P-scores using projected baseline for ages 75–84 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 75\u201384",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176381 p_proj_65_74   P-scores using projected baseline for ages 65–74 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 65\u201374",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176380 p_proj_15_64   P-scores using projected baseline for ages 15–64 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 15\u201364",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176379 p_proj_0_14   P-scores using projected baseline for ages 0–14 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 0\u201314",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176378 p_proj_all_ages   P-scores using projected baseline for all ages 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Excess mortality P-scores, projected baseline, all ages",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176377 cum_p_proj_all_ages   Cumulative P-scores using projected baseline for all ages 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Excess mortality cumulative P-scores, projected baseline, all ages",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176376 cum_proj_deaths_all_ages   The cumulative number of projected deaths; cumulated starting 1 January 2020 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
176375 cum_excess_proj_all_ages   The cumulative number of excess deaths; cumulated starting 1 January 2020 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176374 excess_proj_all_ages   The number of excess deaths; calculated as reported deaths minus projected deaths 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
176373 projected_deaths_2020_2022_all_ages   Projected number of weekly or monthly deaths from all causes for all ages for 2020–2022 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Projected, 2020",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
176372 p_avg_0_14   P-scores using 5-year average baseline for ages 0–14 2021-09-20 18:38:04 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 0\u201314",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145911 time_unit   Denotes whether the “time” column values are weekly or monthly 2021-02-20 19:38:02 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145910 time   The week or month number in the year 2021-02-20 19:38:02 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145685 deaths_2021_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2021. 2021-01-17 16:44:42 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145372 deaths_2014_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2014. 2020-11-01 17:28:58 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145371 deaths_2013_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2013. 2020-11-01 17:28:58 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145370 deaths_2012_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2012. 2020-11-01 17:28:58 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145369 deaths_2011_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2011. 2020-11-01 17:28:58 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145368 deaths_2010_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2010. 2020-11-01 17:28:58 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "includeInTable": true
}
 0           1                                  
145174 deaths_2019_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2019. 2020-10-18 19:57:08 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145173 deaths_2018_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2018. 2020-10-18 19:57:08 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145172 deaths_2017_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2017. 2020-10-18 19:57:08 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145171 deaths_2016_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2016. 2020-10-18 19:57:08 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145170 deaths_2015_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2015. 2020-10-18 19:57:08 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143514 average_deaths_2015_2019_all_ages   The average number of weekly or monthly deaths from all causes for all ages over the years 2015–2019. 2020-08-22 18:00:49 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
143513 deaths_2020_all_ages   The reported number of weekly or monthly deaths from all causes for all ages in 2020. 2020-08-22 18:00:49 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143390 p_avg_85p   P-scores using projected baseline for ages 85 and above 2020-08-17 21:44:10 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 85+",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
143389 p_avg_75_84   P-scores using projected baseline for ages 75–84 2020-08-17 21:44:10 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 75\u201384",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143388 p_avg_65_74   P-scores using projected baseline for ages 65–74 2020-08-17 21:44:10 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 65\u201374",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143387 p_avg_15_64   P-scores using projected baseline for ages 15–64 2020-08-17 21:44:10 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Ages 15\u201364",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143222 p_avg_all_ages   P-scores using 5-year average baseline for all ages 2020-07-30 23:21:08 2023-06-15 05:05:42       Excess Mortality Data – OWID (2022) 5148 Human Mortality Database (2022), World Mortality Dataset (2022) 17878   
{
    "name": "Excess mortality P-scores, 5-year average baseline, all ages",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 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");