sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 4135 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
16964 Hyde and Marinov (2012, 2015) 
{
    "link": "https://www.dropbox.com/s/tsy2a9j3fud2rk8/NELDA_version_4.zip?file_subpath=%2FNELDA+version+4",
    "retrievedDate": "2019-05-27",
    "additionalInfo": "This dataset gives the number of direct national elections held in each country in each year 1945\u20132012. These data are taken entirely from Susan Hyde and Nikolay Marinov's NELDA dataset (Version 4, 2015).\n\nFor a summary of the most important information about the NELDA dataset (e.g. which elections and countries are included), see their overview: https://nelda.co/#about. \n\nSee also their 2012 paper, \u201cWhich Elections can be Lost?\u201d Political Analysis, 20(2), 191\u2013210, available at: https://www.cambridge.org/core/services/aop-cambridge-core/content/view/0474B124646DF486D1FD9A8E26D31DEC/S1047198700013097a.pdf/div-class-title-which-elections-can-be-lost-div.pdf\n\nNotes: \u201cSerbia\u201d refers to Yugoslavia for 1945\u201391 and to \u201cSerbia and Montenegro\u201d for 1992\u20132006. \u201cGermany\u201d refers to West Germany for 1945\u201389.\n\nHow the dataset \"Number of direct national elections \u2014 NELDA (2015)\" was produced: https://drive.google.com/open?id=1bfmN0bd00-7PVFf9W4eRPRHdOTTHm6cB",
    "dataPublishedBy": "Hyde, Susan D. and Nikolay Marinov, \"National Elections Across Democracy and Autocracy Dataset Version 4\" (2015).",
    "dataPublisherSource": "\"Sources used to code the data are diverse, including scholarly studies of specific countries, the elections data handbooks published by Oxford University Press (Nohlen, Krennerich, and Thibaut 1999; Nohlen, Grotz and Hartmann 2001; Nohlen 2005), historical news archives available through ProQuest and Lexis-Nexis, the Inter-Parliamentary Union\u2019s data and archives on parliamentary elections, and a number of other sources.\""
}
 2019-06-05 03:26:32 2019-06-05 03:26:32 Number of direct national elections — NELDA (2015) 4135 This dataset gives the number of direct national elections held in each country in each year 1945–2012. These data are taken entirely from Susan Hyde and Nikolay Marinov's NELDA dataset (Version 4, 2015). For a summary of the most important information about the NELDA dataset (e.g. which elections and countries are included), see their overview: https://nelda.co/#about. See also their 2012 paper, “Which Elections can be Lost?” Political Analysis, 20(2), 191–210, available at: https://www.cambridge.org/core/services/aop-cambridge-core/content/view/0474B124646DF486D1FD9A8E26D31DEC/S1047198700013097a.pdf/div-class-title-which-elections-can-be-lost-div.pdf Notes: “Serbia” refers to Yugoslavia for 1945–91 and to “Serbia and Montenegro” for 1992–2006. “Germany” refers to West Germany for 1945–89. How the dataset "Number of direct national elections — NELDA (2015)" was produced: https://drive.google.com/open?id=1bfmN0bd00-7PVFf9W4eRPRHdOTTHm6cB https://www.dropbox.com/s/tsy2a9j3fud2rk8/NELDA_version_4.zip?file_subpath=%2FNELDA+version+4 Hyde, Susan D. and Nikolay Marinov, "National Elections Across Democracy and Autocracy Dataset Version 4" (2015).

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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