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

1 row where datasetId = 940 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
42805 Technology Diffusion (Comin and Hobijn (2004) and others) % Running water: Percentage of all American households with access to running water. Flush toilet: Percentage of all American households with access to a flush toilet. Central heating: Percentage of American dwelling units with central heating. Stove: Percentage of US households with a stove. Landline: Percentage of US households with a landline. Electric power: Percentage of US households with electric power. Automobile: Percentage of US households that own an automobile. Radio: Percentage of US households that own a radio. Washing machine: Percentage of US households that own a washing machine. Household refrigerator: Percentage of US households that own a refrigerator. Electricity access: Percentage of households with electricity access. Original data refers to the percentage of the population, however as it stands at 100%, we assume it includes 100% of households. Households with only mobile phone (no landline): Percentage of US households without a landline, using only mobile phones. Amazon Prime users (adults aged 15+): Percentage of the US population who are Amazon Prime users. Calculated as the number of Amazon Prime users divided by the US population aged 15 and over. </p> Automatic transmission: Automatic transmission vehicle in percentage of car output. Power steering: Power steering in vehicles in percentage of car output. Home air conditioning: Percentage of US households with home air conditioning. Colour TV: Percentage of US households with colour TV. Shipping container port infrastructure: Percentage adoption of port infrastructure. Disk brakes: Disk brakes in the percentage of car output. Cable TV: Percentage of US households with cable TV. Radial tires: Cars with radial tires in percentage of car output. Electronic ignition: Cars with electronic ignition in percentage of car output. Microcomputer: Percentage of US households with microcomputers. Nox pollution controls (boilers): Percentage of boilers adopting Nox pollution control technologies. Cellular phone: Percentage of US households with a c… 2017-10-26 15:26:07 2023-06-15 05:05:42       Technology Diffusion - Comin and Hobijn (2004) and others 940 Horace Dediu; Comin and Hobijn (2004); other sources collated by Our World in Data 6799   
{
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 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");