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

8 rows where datasetId = 39 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, 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
122 Post-secondary education for those aged 15+ (proportion), 1970-2050 (IIASA (2015))   Post-secondary education includes: Persons who have completed number of years or grades corresponding to standard duration of International Standard Classification of Education (ISCED 1997) 4 or ISCED 5B programmes; persons holding degrees corresponding to ISCED 4, ISCED 5B, ISCED 5A and ISCED 6 levels. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-08-12 15:56:48 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42 % 
{
    "includeInTable": true
}
 0           1                                  
116 Aged 0-14, 1970-2050 (IIASA (2015))     2015-08-07 17:19:00 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{}
 0           1                                  
113 Post-secondary education, 1970-2050 (IIASA (2015))   Post-secondary education includes: Persons who have completed number of years or grades corresponding to standard duration of International Standard Classification of Education (ISCED 1997) 4 or ISCED 5B programmes; persons holding degrees corresponding to ISCED 4, ISCED 5B, ISCED 5A and ISCED 6 levels. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-08-07 16:10:10 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{
    "unit": "%",
    "shortUnit": "%",
    "tolerance": 5,
    "includeInTable": true,
    "conversionFactor": 0.1
}
 0           1                                  
112 Secondary education, 1970-2050 (IIASA (2015))   Secondary education includes: Completed last grade of International Standard Classification of Education (ISCED 1997) 3 level; completed number grades or years below the standard duration at ISCED 4 or ISCED 5B level; persons who indicated an unknown number of grades at ISCED 4 or 5 level. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-08-07 16:08:43 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{
    "includeInTable": true
}
 0           1                                  
111 Primary education, 1970-2050 (IIASA (2015))   Primary education includes: Completed last grade of International Standard Classification of Education (ISCED 1997) 1 level or grades below the last grade of ISCED 2 level; persons attending last grade of ISCED 2 at time of survey; persons who indicated an unknown number of grades at ISCED 2 level. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-08-07 16:07:50 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{
    "includeInTable": true
}
 0           1                                  
110 No education, 1970-2050 (IIASA (2015))   No education includes: Illiterates and persons who have never attended school; persons who were attending 1st grade of primary education at time of survey; persons attending adult literacy courses at time of survey; and khalwa (first level of traditional Koranic schools). No education corresponds to the following International Standard Classification of Education (ISCED 1997) Levels: No Level or Level 0; grade 1 of Level 1 not completed. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-08-07 16:06:51 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{
    "includeInTable": true
}
 0           1                                  
73 Total number of people aged 15+ with no education (millions) (IIASA (2015))   No education includes Illiterates and persons who have never attended school; persons who were attending 1st grade of primary education at time of survey; persons attending adult literacy courses at time of survey; and khalwa (first level of traditional Koranic schools). No education corresponds to the following International Standard Classification of Education (ISCED 1997) Levels: No Level or Level 0; grade 1 of Level 1 not completed. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-07-24 18:41:24 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{
    "includeInTable": true
}
 0           1                                  
39 IIASA rates of no education projections (IIASA (2015)) % No education includes Illiterates and persons who have never attended school; persons who were attending 1st grade of primary education at time of survey; persons attending adult literacy courses at time of survey; and khalwa (first level of traditional Koranic schools). No education corresponds to the following International Standard Classification of Education (ISCED 1997) Levels: No Level or Level 0; grade 1 of Level 1 not completed. For ISCED 1997 definitions see: https://web.archive.org/web/20220131215732/https://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-1997-en_0.pdf 2015-07-09 21:39:14 2023-06-15 05:05:42   Global by country 1970-2100 Population Dynamics and Global Human Capital - IIASA (2015) 39 International Institute for Applied Systems Analysis (IIASA): World Population and Human Capital in the Twenty-First Century (2015) 42   
{
    "shortUnit": "%",
    "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");