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 = 17016 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
104623 Black Rhino population (AfRSG & other sources, 2019)   Number of Black Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "Black Rhino",
    "numDecimalPlaces": 0
}
 0           1                                  
104622 White Rhino population (AfRSG & other sources, 2019)   Number of White (Northern plus Southern) Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "White Rhino",
    "numDecimalPlaces": 0
}
 0           1                                  
104621 Northern White Rhino population (AfRSG & other sources, 2019)   Number of Northern White Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "Northern White Rhino",
    "numDecimalPlaces": 0
}
 0           1                                  
104620 Southern White Rhino population (AfRSG & other sources, 2019)   Number of Southern White Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "Southern White Rhino",
    "numDecimalPlaces": 0
}
 0           1                                  
104619 Javan Rhino population (AfRSG & other sources, 2022)   Number of Javan Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "Javan Rhino",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
104618 Indian Rhino population (AfRSG & other sources, 2022)   Number of Indian (Greater One-Horned) Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "Indian Rhino",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
104617 Sumatran Rhino population (AfRSG & other sources, 2019)   Number of Sumatran Rhinos. 2019-08-15 16:03:16 2023-06-15 05:05:42       Rhino populations (AfRSG & other sources, 2022) 4188 Rhino populations (AfRSG & other sources, 2022) 17016   
{
    "name": "Sumatran Rhino",
    "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");