owid: variables: 4 rows where sourceId = 17758 sorted by id descending

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

4 rows where sourceId = 17758 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid
85063	85063
85062	85062
85061	85061
85060	85060

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE variables(id INTEGER, "name" VARCHAR, unit VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, code VARCHAR, coverage VARCHAR, timespan VARCHAR, datasetId INTEGER, sourceId INTEGER, shortUnit VARCHAR, display VARCHAR, columnOrder INTEGER, originalMetadata VARCHAR, shortName VARCHAR, catalogPath VARCHAR, dimensions VARCHAR, schemaVersion INTEGER, processingLevel VARCHAR, processingLog VARCHAR, titlePublic VARCHAR, titleVariant VARCHAR, attributionShort VARCHAR, attribution VARCHAR, descriptionShort VARCHAR, descriptionFromProducer VARCHAR, descriptionKey VARCHAR, descriptionProcessing VARCHAR, licenses VARCHAR, license VARCHAR, "type" VARCHAR, sort VARCHAR, grapherConfigIdAdmin VARCHAR, grapherConfigIdETL VARCHAR, dataChecksum VARCHAR, metadataChecksum VARCHAR);;