variables
Data license: CC-BY
6 rows where datasetId = 6567 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, updatedAt, type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
935511 | population_in_2018 | 2024-06-15 11:03:46 | 2024-06-17 12:19:29 | 2000-2000 | Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data (take2) 6567 | {} |
0 | population_in_2018 | grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018_take2/draft_joe_gini_diff_1980_2018_take2#population_in_2018 | 2 | [] |
int | [] |
207cf1b7b5871175b4ee29b7c3d1906a | 5bafe643cc0e48f6bba4c17b4c8e1804 | |||||||||||||||||||||
935510 | region | 2024-06-15 11:03:45 | 2024-06-17 12:19:28 | 2000-2000 | Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data (take2) 6567 | {} |
0 | region | grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018_take2/draft_joe_gini_diff_1980_2018_take2#region | 2 | [] |
string | [] |
9c359e5afdcda4bb3f9b581e3d2f0a97 | 155dbc83f067b0f13fafff1095b3f1ed | |||||||||||||||||||||
935509 | wid_gini_relative_difference_1980_2018 | 2024-06-15 11:03:45 | 2024-06-17 12:19:28 | 2000-2000 | Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data (take2) 6567 | {} |
0 | wid_gini_relative_difference_1980_2018 | grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018_take2/draft_joe_gini_diff_1980_2018_take2#wid_gini_relative_difference_1980_2018 | 2 | [] |
float | [] |
d739643a4ab8ac902b26f183760630a2 | ca83575022f37c6c04d3c1f35f5b2a03 | |||||||||||||||||||||
935508 | pip_gini_relative_difference_1980_2018 | 2024-06-15 11:03:45 | 2024-06-17 12:19:28 | 2000-2000 | Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data (take2) 6567 | {} |
0 | pip_gini_relative_difference_1980_2018 | grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018_take2/draft_joe_gini_diff_1980_2018_take2#pip_gini_relative_difference_1980_2018 | 2 | [] |
float | [] |
bff8c1b879d12b732fea686554b13872 | cefff812fa9a8ebd9b6d5d3be1a69f68 | |||||||||||||||||||||
935507 | pip_gini_difference_1980_2018 | 2024-06-15 11:03:45 | 2024-06-17 12:19:28 | 2000-2000 | Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data (take2) 6567 | {} |
0 | pip_gini_difference_1980_2018 | grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018_take2/draft_joe_gini_diff_1980_2018_take2#pip_gini_difference_1980_2018 | 2 | [] |
float | [] |
d894ca94eaf403131faaa04ef443291e | aa7d0118f36eab969aa5e628b087058e | |||||||||||||||||||||
935506 | wid_gini_difference_1980_2018 | 2024-06-15 11:03:45 | 2024-06-17 12:19:28 | 2000-2000 | Draft: Joe – Difference in Gini, 1980-2018, PIP vs WID data (take2) 6567 | {} |
0 | wid_gini_difference_1980_2018 | grapher/fasttrack/latest/draft_joe_gini_diff_1980_2018_take2/draft_joe_gini_diff_1980_2018_take2#wid_gini_difference_1980_2018 | 2 | [] |
float | [] |
094c64a072cfb5c655a1a3ce7c149692 | c123767850cee888c7f79111064eda66 |
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");