variables

Data license: CC-BY

5 rows where datasetId = 6631 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date), descriptionKey (array)

{
    "unit": "%",
    "zeroDay": "2021-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}

[
    "Respondents were asked, 'Which ONE, if any, of the following statements do you  MOST agree with?'",
    "Possible answers were: 'Most robots have already developed higher levels of intelligence than humans', 'Robots will be able to develop higher levels of intelligence than humans in the future', 'Robots will never be able to develop higher levels of intelligence than humans', 'None of these', and 'Don't know'"
]

{
    "note": "Number of respondents ranges between n = 1001 and n = 1085 US adults per survey wave."
}

[]

{
    "unit": "%",
    "zeroDay": "2021-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}

[
    "Respondents were asked, 'Which ONE, if any, of the following statements do you  MOST agree with?'",
    "Possible answers were: 'Most robots have already developed higher levels of intelligence than humans', 'Robots will be able to develop higher levels of intelligence than humans in the future', 'Robots will never be able to develop higher levels of intelligence than humans', 'None of these', and 'Don't know'"
]

{
    "note": "Number of respondents ranges between n = 1001 and n = 1085 US adults per survey wave."
}

[]

{
    "unit": "%",
    "zeroDay": "2021-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}

[
    "Respondents were asked, 'Which ONE, if any, of the following statements do you  MOST agree with?'",
    "Possible answers were: 'Most robots have already developed higher levels of intelligence than humans', 'Robots will be able to develop higher levels of intelligence than humans in the future', 'Robots will never be able to develop higher levels of intelligence than humans', 'None of these', and 'Don't know'"
]

{
    "note": "Number of respondents ranges between n = 1001 and n = 1085 US adults per survey wave."
}

[]

{
    "unit": "%",
    "zeroDay": "2021-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}

[
    "Respondents were asked, 'Which ONE, if any, of the following statements do you  MOST agree with?'",
    "Possible answers were: 'Most robots have already developed higher levels of intelligence than humans', 'Robots will be able to develop higher levels of intelligence than humans in the future', 'Robots will never be able to develop higher levels of intelligence than humans', 'None of these', and 'Don't know'"
]

{
    "note": "Number of respondents ranges between n = 1001 and n = 1085 US adults per survey wave."
}

[]

{
    "unit": "%",
    "zeroDay": "2021-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "numDecimalPlaces": 1
}

[
    "Respondents were asked, 'Which ONE, if any, of the following statements do you  MOST agree with?'",
    "Possible answers were: 'Most robots have already developed higher levels of intelligence than humans', 'Robots will be able to develop higher levels of intelligence than humans in the future', 'Robots will never be able to develop higher levels of intelligence than humans', 'None of these', and 'Don't know'"
]

{
    "note": "Number of respondents ranges between n = 1001 and n = 1085 US adults per survey wave."
}

[]

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