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

5 rows where datasetId = 6142 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display, 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
738170 num_sequences_cumulative_per_1M     2023-07-24 09:54:16 2024-07-31 15:41:59       COVID-19 - Sequencing 6142 GISAID, via CoVariants.org – Last updated 30 July 2024 30937   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0     num_sequences_cumulative_per_1m grapher/covid/latest/sequencing/sequencing#num_sequences_cumulative_per_1m   1                 
[]
         float 
[]
 b6f7bab66bdbb1dfce8e5394652253cf 8ed893c9e7abdd9cb4f8c10c2a63689f
738169 num_sequences_cumulative     2023-07-24 09:54:16 2024-07-31 15:41:59       COVID-19 - Sequencing 6142 GISAID, via CoVariants.org – Last updated 30 July 2024 30937   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0     num_sequences_cumulative grapher/covid/latest/sequencing/sequencing#num_sequences_cumulative   1                 
[]
         int 
[]
 73b93a34bf563a136570648b0869b96f 75f6ad49a6c8013f4aa76b01fa24c27c
738168 num_sequences_per_1M     2023-07-24 09:54:16 2024-07-31 15:41:59       COVID-19 - Sequencing 6142 GISAID, via CoVariants.org – Last updated 30 July 2024 30937   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0     num_sequences_per_1m grapher/covid/latest/sequencing/sequencing#num_sequences_per_1m   1                 
[]
         float 
[]
 2d8fe664442b7367e2f32d068144742f 965a235a83f3ea3b15311666a3409382
738167 variant_dominant     2023-07-24 09:54:16 2024-07-31 15:41:59       COVID-19 - Sequencing 6142 GISAID, via CoVariants.org – Last updated 30 July 2024 30937   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0     variant_dominant grapher/covid/latest/sequencing/sequencing#variant_dominant   1                 
[]
         string 
[]
 4e224150778ae2bd3202a1ac9fe7d5a9 e05d110ce55ba9d282d8334b11fa0d03
738166 num_sequences     2023-07-24 09:54:16 2024-07-31 15:41:59       COVID-19 - Sequencing 6142 GISAID, via CoVariants.org – Last updated 30 July 2024 30937   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0     num_sequences grapher/covid/latest/sequencing/sequencing#num_sequences   1                 
[]
         int 
[]
 642f69e9c23ec36a44aab04e52028c30 684452fc1a45c98da136949189af1e70

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