sources
Data license: CC-BY
1 row where datasetId = 2758 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
15492 | Hyde and Marinov, NELDA (2012) | { "link": "https://nelda.co/#access", "retrievedDate": "11/04/2018", "additionalInfo": "Codebook notes:\n\" The National Elections across Democracy and Autocracy (NELDA) dataset provides detailed information on all election events from 1945-2012. To be included, elections must be for a national executive figure, such as a president, or for a national legislative body, such as a parliament, legislature, constituent assembly, or other directly elected representative bodies. In order for an election to be included, voters must directly elect the person or persons appearing on the ballot to the national post in question.\n\nElections may or may not be competitive, and may have any number of other ostensible flaws. In fact, the inclusion of flawed elections is a feature of the NELDA dataset. \"\n\nThe unit of observation is the NELDA dataset is the election round. The ElectionID variable has been used to collapse multi-round elections into one observation for OWID\u2019s purposes. In three election events, Equatorial Guinea's 1993 legislative/parliamentary election, Equatorial Guinea's 1996 presidential/other direct executive election, and Zimbabwe's 2005 legislative/parliamentary election, these election events were coded as unobserved by Western monitors, yet criticized with allegations of significant vote-fraud. For our purposes, these three election events have been re-coded as unobserved and not criticized as no Western monitors were in the country at the time to monitor the election.\n\nThe percent of observed and criticized elections was calculated as:\n\n% observed and criticized elections = (no.of criticized elections/ total no. of elections) * 100\n\nThe percent of observed and not criticized elections was calculated as:\n\n% observed and not criticized elections = [(no. of observed elections - no. of criticized elections)/total number of elections] * 100\n\nMicrostates, defined as those countries with less than 500,000 citizens at the time of election, have been excluded. Five independent states that did not hold any direct elections between 1945-2012 - China, Eritrea, Qatar, Saudi Arabia, and the United Arab Emirates - have also been excluded. ", "dataPublishedBy": "Susan D. Hyde and Nikolay Marinov, 2012, Which Elections Can Be Lost?, Political Analysis, 20(2), 191-201. ", "dataPublisherSource": "Primary sources included election handbooks for different continents, and other historical data. For a complete list of sources used see: https://nelda.co/#sources" } |
2018-04-12 17:20:49 | 2018-04-13 21:59:16 | Rate of internationally observed elections - Hyde and Marinov (2012) 2758 | Codebook notes: " The National Elections across Democracy and Autocracy (NELDA) dataset provides detailed information on all election events from 1945-2012. To be included, elections must be for a national executive figure, such as a president, or for a national legislative body, such as a parliament, legislature, constituent assembly, or other directly elected representative bodies. In order for an election to be included, voters must directly elect the person or persons appearing on the ballot to the national post in question. Elections may or may not be competitive, and may have any number of other ostensible flaws. In fact, the inclusion of flawed elections is a feature of the NELDA dataset. " The unit of observation is the NELDA dataset is the election round. The ElectionID variable has been used to collapse multi-round elections into one observation for OWID’s purposes. In three election events, Equatorial Guinea's 1993 legislative/parliamentary election, Equatorial Guinea's 1996 presidential/other direct executive election, and Zimbabwe's 2005 legislative/parliamentary election, these election events were coded as unobserved by Western monitors, yet criticized with allegations of significant vote-fraud. For our purposes, these three election events have been re-coded as unobserved and not criticized as no Western monitors were in the country at the time to monitor the election. The percent of observed and criticized elections was calculated as: % observed and criticized elections = (no.of criticized elections/ total no. of elections) * 100 The percent of observed and not criticized elections was calculated as: % observed and not criticized elections = [(no. of observed elections - no. of criticized elections)/total number of elections] * 100 Microstates, defined as those countries with less than 500,000 citizens at the time of election, have been excluded. Five independent states that did not hold any direct elections between 1945-2012 - China, Eritrea, Qatar, Saudi Arabia, and the United Arab Emira… | https://nelda.co/#access | Susan D. Hyde and Nikolay Marinov, 2012, Which Elections Can Be Lost?, Political Analysis, 20(2), 191-201. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");