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

19 rows where datasetId = 941 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, shortUnit, display, 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
42553 Commercial vehicles (Comin and Hobijn (2004))   Number of commercial vehicles, typically including buses and taxis (excluding tractors and similar vehicles), in use. Numbers typically derived from) registration and licensing records, meaning that vehicles out of use may occasionally be included 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42552 Synthetic (non-cellulosic) fibres (Comin and Hobijn (2004))   Weight of synthetic (non‐cellulosic) fibres used in spindles 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42551 Telegrams (Mitchell (1998)) million Number of telegrams sent, in millions 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800 mns 
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42550 Crude steel production (electric furnaces) (Comin and Hobijn (2004)) in metric tons Crude steel production (in metric tons) in electric arc furnaces (a process that complemented and improved upon Bessemer and OHF processes) 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800 tons 
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42549 Crude steel production (blast oxygen furnaces) (Comin and Hobijn (2004)) in metric tons Crude steel production (in metric tons) in blast oxygen furnaces (a process that replaced Bessemer and OHF processes) 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800 metric tons 
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42548 Steamships (tons) (Comin and Hobijn (2004)) tons Tonnage of steam ships (above a minimum weight) in use at midyear 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42547 Rail passenger-km (Comin and Hobijn (2004)) passenger-km Passenger journeys by railway in passenger‐km. Free passengers typically excluded but may be included for some countries 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42546 Retail locations accepting card (Comin and Hobijn (2004))   Number of retail locations at which payment cards can be used. 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42545 Newspapers (Comin and Hobijn (2004))   Number of newspaper copies circulated daily. Note that there is a tendency for news circulation to be under‐reported, since data for weekly and biweekly publications are not included. 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42544 MRI units (Comin and Hobijn (2004))   Number of magnetic resonance imaging (MRI) units 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42543 Mail (Mitchell (1998)) million Number of items mailed/received, with internal items counted one and cross border items counted once for each country. May or may not include newspapers sent by mail, registered mail, or parcel post (in millions) 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800 mns 
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42542 Card payments (Comin and Hobijn (2004))   Number of transactions using payment cards at points of service (retail locations) 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42541 Credit and debit payments (Comin and Hobijn (2004)) in millions Payments by credit and debit cards (in millions) 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800 mns 
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42540 Aviation passenger-km (Comin and Hobijn (2004)) passenger-km Civil aviation passenger‐km travelled on scheduled services by companies registered in the country concerned. Not a measure of travel through a country’s airports 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42539 ATM (Comin and Hobijn (2004))   Number of electro-mechanical devices that permit authorized users, typically using machine readable plastic cards, to withdraw cash from their accounts and/or access other services 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42538 Agricultural tractor (Comin and Hobijn (2004))   Number of wheel and crawler tractors (excl. garden tractors) used in agriculture 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42537 Diesel locomotives in service (US Census Bureau (2017))   Number of diesel locomotives in service. 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42536 Roads (US Census Bureau (2017)) in thousands of miles Total surface mileage in thousands of miles. 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
42535 Canals (Isard (1942)) mileage Measures the number of kilometres of completed canals. 2017-09-30 19:53:00 2023-06-15 05:05:42       Technology Adoption - Multiple sources compiled by Our World in Data 941 Multiple sources compiled by Our World in Data 6800   
{
    "unit": "km",
    "shortUnit": "km",
    "includeInTable": true,
    "conversionFactor": 1.60934,
    "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");