variables
Data license: CC-BY
8 rows where datasetId = 6592 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, updatedAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
944175 | voter_turnout_group8 | 2024-06-26 09:44:10 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group8 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group8 | 2 | [] |
int | [] |
5aa6c9682634eaea85a123a91fc5269d | 8480c5dccb2c41b5a451d7cf1d72e8d7 | |||||||||||||||||||||
944174 | voter_turnout_group7 | 2024-06-25 15:45:14 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group7 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group7 | 2 | [] |
int | [] |
389ff01b14210d4a15ec43a1cbe8b5b1 | 241a9301d62c0e0dda11449a6e041faa | |||||||||||||||||||||
944173 | voter_turnout_group6 | 2024-06-25 15:45:14 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group6 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group6 | 2 | [] |
int | [] |
c430e42c756f7ba69f09780f2b74d45e | 9633ef3352cd0b742a3e67fa0b22830c | |||||||||||||||||||||
944172 | voter_turnout_group4 | 2024-06-25 15:45:14 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group4 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group4 | 2 | [] |
int | [] |
66b458414c008608e6d619da4319f087 | 9b3ce0df0f6141c19f315131d3ca379b | |||||||||||||||||||||
944171 | voter_turnout_group5 | 2024-06-25 15:45:14 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group5 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group5 | 2 | [] |
int | [] |
ee53181b53113d72f47512acefa76b9b | c07b9ad559af586b4a6e0121a93c46da | |||||||||||||||||||||
944170 | voter_turnout_group3 | 2024-06-25 15:45:14 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group3 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group3 | 2 | [] |
int | [] |
ad229c9136432ac9e8b3523fc52db408 | 89a8493a5227110020ab0f1cd01097aa | |||||||||||||||||||||
944169 | voter_turnout_group2 | 2024-06-25 15:45:14 | 2024-06-26 09:44:11 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group2 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group2 | 2 | [] |
int | [] |
891faf478fa4a9b78898ab293f56ec5b | 75dd73968c4f9fad4ead8f3d7f12d9e1 | |||||||||||||||||||||
944168 | voter_turnout_group1 | 2024-06-25 15:45:14 | 2024-06-26 09:44:10 | 2024-2024 | DRAFT Voter turnout by age - Sheet1 6592 | {} |
0 | voter_turnout_group1 | grapher/fasttrack/latest/voter_turnout_by_age__sheet1/voter_turnout_by_age__sheet1#voter_turnout_group1 | 2 | [] |
int | [] |
98181fb6ee6eb4f1f89ae146e8aac301 | d313ae2bff1f2305575d4b63e212bdf0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");