variables

Data license: CC-BY

24 rows where sourceId = 29575 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, createdAt, updatedAt, timespan, display, type, createdAt (date), updatedAt (date)

{
    "name": "Unspecified or other",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Annual industrial robots installed",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Number of industrial robots installed",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Transportation and logistics",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Total of industrial robots installed",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Total industrial robots in operation",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Professional cleaning",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Hospitality",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Agriculture",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Medical robotics",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Plastic and chemical",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Unspecified",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Metal and machinery",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Food",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Electronics",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "All others",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Automotive",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Welding",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Unspecified",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Processing",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Handling",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Dispensing",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Cleanroom",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

{
    "name": "Assembling",
    "unit": "robots",
    "numDecimalPlaces": 0
}

[]

[]

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