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

7 rows where sourceId = 29428 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
792769 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - Domain 6. Safe, orderly and regular migration number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:26 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__domain_6__safe__orderly_and_regular_migration grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__domain_6__safe__orderly_and_regular_migration#_10_7_2__sg_cpa_migrs__domain_6__safe__orderly_and_regular_migration   1                 
[]
         int 
[]
 3ec3e74a0b50646c47a62cf625c491b5 918a0780b54760dec51241f71918761c
792768 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - Domain 5. Mobility dimensions of crises number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:26 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__domain_5__mobility_dimensions_of_crises grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__domain_5__mobility_dimensions_of_crises#_10_7_2__sg_cpa_migrs__domain_5__mobility_dimensions_of_crises   1                 
[]
         int 
[]
 6a236ba9931a97ddf9908f1f5bda7620 657187550c25f7e57a161ebc5f4d2ed7
792767 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - Domain 4. Socioeconomic well-being number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:25 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__domain_4__socioeconomic_well_being grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__domain_4__socioeconomic_well_being#_10_7_2__sg_cpa_migrs__domain_4__socioeconomic_well_being   1                 
[]
         int 
[]
 2ea6ce2710eb3f9e7fa1487410ad79e4 de9efdb7619a81438dff0257dfc6de54
792766 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - Domain 3. Cooperation and partnerships number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:25 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__domain_3__cooperation_and_partnerships grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__domain_3__cooperation_and_partnerships#_10_7_2__sg_cpa_migrs__domain_3__cooperation_and_partnerships   1                 
[]
         int 
[]
 b6c4440ba5ef33025e5898a121b2bb7f ed368f3cde3fdd3dcc4b149c696e7cb4
792765 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - Domain 2. Whole-of-government/ Evidence-based policies number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:24 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__domain_2__whole_of_government__evidence_based_policies grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__domain_2__whole_of_government__evidence_based_policies#_10_7_2__sg_cpa_migrs__domain_2__whole_of_government__evidence_based_policies   1                 
[]
         int 
[]
 17a419f081569aa6a3596631fa778d8d 2eeabf25fa9340476c4687da3afeb951
792764 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - Domain 1. Migrant rights number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:24 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__domain_1__migrant_rights grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__domain_1__migrant_rights#_10_7_2__sg_cpa_migrs__domain_1__migrant_rights   1                 
[]
         int 
[]
 76aca467303bff241a53cf9d1e82c257 0512765e9a0768402459983102e216f8
792763 10.7.2 - Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) - SG_CPA_MIGRS - All Domains number Countries with migration policies to facilitate orderly, safe, regular and responsible migration and mobility of people, by policy domain (1 = Requires further progress; 2 = Partially meets; 3 = Meets; 4 = Fully meets) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-10-07-02.pdf 2023-08-17 15:58:23 2024-07-08 16:14:29     2019-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 United Nations 29428   
{
    "unit": "number"
}
 0     _10_7_2__sg_cpa_migrs__all_domains grapher/un/2023-08-16/un_sdg/_10_7_2__sg_cpa_migrs__all_domains#_10_7_2__sg_cpa_migrs__all_domains   1                 
[]
         int 
[]
 1fd4a8c370544ad303ac5bf1b0bddfcc 8c6dc0de71a8f4380095bb7d64a539ee

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