variables
Data license: CC-BY
5 rows where datasetId = 2758 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97401 | Number of international elections observed and not critcized (Hyde and Marinov (2012)) | Number of international elections that were observed by Western monitors with no allegations of significant vote-fraud by Western monitors. | 2018-04-13 15:58:11 | 2023-06-15 05:05:42 | Rate of internationally observed elections - Hyde and Marinov (2012) 2758 | Hyde and Marinov, NELDA (2012) 15492 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 97400 | Number of international elections observed and criticized (Hyde and Marinov (2012)) | Number of international elections that were observed by Western monitors with allegations of significant vote-fraud by Western monitors. | 2018-04-13 15:58:11 | 2023-06-15 05:05:42 | Rate of internationally observed elections - Hyde and Marinov (2012) 2758 | Hyde and Marinov, NELDA (2012) 15492 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 97399 | Number of international elections not observed (Hyde and Marinov (2012)) | Number of international elections that were not observed by Western monitors. | 2018-04-13 15:58:11 | 2023-06-15 05:05:42 | Rate of internationally observed elections - Hyde and Marinov (2012) 2758 | Hyde and Marinov, NELDA (2012) 15492 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 97383 | Percent of elections observed and not criticized (Hyde and Marinov (2012)) | % | Percent of internationally observed elections that were observed and not criticized by Western monitors. Western monitors are defined as election observers from Western countries (as defined by OECD membership) or Western international organizations. Criticism refers to allegations of significant vote-fraud by any Western monitors. | 2018-04-12 17:20:49 | 2023-06-15 05:05:42 | Rate of internationally observed elections - Hyde and Marinov (2012) 2758 | Hyde and Marinov, NELDA (2012) 15492 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97382 | Percent of elections observed and criticized (Hyde and Marinov (2012)) | % | Percent of internationally observed elections that were observed and criticized by Western monitors. Western monitors are defined as election observers from Western countries (as defined by OECD membership) or Western international organizations. Criticism refers to allegations of significant vote-fraud by any Western monitors. | 2018-04-12 17:20:49 | 2023-06-15 05:05:42 | Rate of internationally observed elections - Hyde and Marinov (2012) 2758 | Hyde and Marinov, NELDA (2012) 15492 | {} |
0 | 1 |
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");