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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, timespan, descriptionShort, 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
946964 Transportation and logistics robots   2024-07-03 10:48:32 2024-07-10 09:35:47     2021-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     transportation_and_logistics grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#transportation_and_logistics   2 minor           Professional service robots are semi- or fully autonomous machines that perform useful tasks in a professional setting outside of industrial applications, such as in cleaning or medical surgery. Consumer service robots are not included.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 f9eb255f927fd60a2c95468fdee658c5 ca3160f9fb72b26f6ce530c0a1f2b974
946963 Professional cleaning robots   2024-07-03 10:48:32 2024-07-10 09:35:47     2021-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     professional_cleaning grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#professional_cleaning   2 minor           Professional service robots are semi- or fully autonomous machines that perform useful tasks in a professional setting outside of industrial applications, such as in cleaning or medical surgery. Consumer service robots are not included.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 665d45897bc65e8f940fe60d407debcd 5b76345383b978cd502d254dcb764f24
946962 Total industrial robots in operation robots   2024-07-03 10:48:32 2024-07-10 09:35:47     2012-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     operational_stock grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#operational_stock   2 minor           Industrial robots are automated, reprogrammable machines that perform a variety of tasks in industrial settings.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 97bfd30a3099767723db5cc10ee478a6 6daefe7975281d0268f1b433bddac7c6
946961 Annual industrial robots installed robots   2024-07-03 10:48:32 2024-07-10 09:35:47     2011-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     installations grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#installations   2 minor           Industrial robots are automated, reprogrammable machines that perform a variety of tasks in industrial settings.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 fe67caf234183cd0ba3c42871ca3f17c c2d655a796a14c48f81ed5ba14af67a3
946960 Medical robotics robots   2024-07-03 10:48:32 2024-07-10 09:35:47     2021-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     medical_robotics grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#medical_robotics   2 minor           Professional service robots are semi- or fully autonomous machines that perform useful tasks in a professional setting outside of industrial applications, such as in cleaning or medical surgery. Consumer service robots are not included.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 d27f65b1a9e8ee22376dab77d803c4b3 74769d4b967ce7748bc7ada065c72df3
946959 Hospitality robots   2024-07-03 10:48:32 2024-07-10 09:35:47     2021-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     hospitality grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#hospitality   2 minor           Professional service robots are semi- or fully autonomous machines that perform useful tasks in a professional setting outside of industrial applications, such as in cleaning or medical surgery. Consumer service robots are not included.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 b29c46dd07757ca2bca39ca158ca7b6e 8063dc39cf9d19cf471131b1339bfa99
946958 Agriculture robots   2024-07-03 10:48:31 2024-07-10 09:35:47     2021-2022 AI Index Report 6608     
{
    "unit": "robots",
    "numDecimalPlaces": 0
}
 0     agriculture grapher/artificial_intelligence/2024-06-28/ai_robots/ai_robots#agriculture   2 minor           Professional service robots are semi- or fully autonomous machines that perform useful tasks in a professional setting outside of industrial applications, such as in cleaning or medical surgery. Consumer service robots are not included.   
[]
       
{
    "note": "Example machines that are not classified as robots: software (e.g., voice assistants), remote-controlled drones, self-driving cars, \u201csmart\u201d washing machines."
}
 int 
[]
 dcc2f355aec414a2c0e03bda34b496e8 39cca05b4f486661da22947f1eecf7e4

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