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

6 rows where datasetId = 6566 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, 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
935531 population_in_2018     2024-06-17 11:36:43 2024-06-17 12:19:28     2000-2000 Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data 6566     
{}
 0     population_in_2018 grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018/draft_joe_gini_diff_1980_2018#population_in_2018   2                 
[]
         int 
[]
 207cf1b7b5871175b4ee29b7c3d1906a 07f40eb229fc911bdacb712aa7063937
935530 region     2024-06-17 11:36:43 2024-06-17 12:19:28     2000-2000 Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data 6566     
{}
 0     region grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018/draft_joe_gini_diff_1980_2018#region   2                 
[]
         string 
[]
 9c359e5afdcda4bb3f9b581e3d2f0a97 32bb9cc7d8b35c5e1a51b91dc7fddfbc
935529 pip_gini_relative_difference_1980_2018     2024-06-17 11:36:43 2024-06-17 12:19:28     2000-2000 Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data 6566     
{}
 0     pip_gini_relative_difference_1980_2018 grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018/draft_joe_gini_diff_1980_2018#pip_gini_relative_difference_1980_2018   2                 
[]
         float 
[]
 bff8c1b879d12b732fea686554b13872 5d01f965e66069f385fc7696bfce3221
935528 wid_gini_relative_difference_1980_2018     2024-06-17 11:36:43 2024-06-17 12:19:28     2000-2000 Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data 6566     
{}
 0     wid_gini_relative_difference_1980_2018 grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018/draft_joe_gini_diff_1980_2018#wid_gini_relative_difference_1980_2018   2                 
[]
         float 
[]
 d739643a4ab8ac902b26f183760630a2 399b1dfcfe6ac63a3669724772b241c6
935527 pip_gini_difference_1980_2018     2024-06-17 11:36:43 2024-06-17 12:19:28     2000-2000 Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data 6566     
{}
 0     pip_gini_difference_1980_2018 grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018/draft_joe_gini_diff_1980_2018#pip_gini_difference_1980_2018   2                 
[]
         float 
[]
 d894ca94eaf403131faaa04ef443291e 92a48f5d477fd6fc5ba56644d070ca3c
935526 wid_gini_difference_1980_2018     2024-06-17 11:36:43 2024-06-17 12:19:28     2000-2000 Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data 6566     
{}
 0     wid_gini_difference_1980_2018 grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018/draft_joe_gini_diff_1980_2018#wid_gini_difference_1980_2018   2                 
[]
         float 
[]
 094c64a072cfb5c655a1a3ce7c149692 265f5e6bb00eb7a1bccfbb3148bff336

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