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 = 5361 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
19977 V-Dem Dataset (2021) 
{
    "link": "https://www.v-dem.net/en/data/data",
    "retrievedDate": "2021-08-12",
    "additionalInfo": "The Varieties of Democracy Project (V-Dem) provides a multidimensional and disaggregated dataset with indicators of democracy for all countries since 1900. The data covers five high-level concepts of democracy (electoral, liberal, participatory, deliberative, and egalitarian) and collects data to measure them. V-Dem draws on theoretical and methodological expertise from a global team of experts. Approximately half of the indicators in the V-Dem dataset are based on factual information obtainable from official documents such as constitutions and government records. The other half consists of subjective assessments on topics where multiple country experts provide ratings.",
    "dataPublishedBy": "V-Dem (Varieties of Democracy) Institute",
    "dataPublisherSource": "Coppedge, Michael, John Gerring, Carl Henrik Knutsen, Staffan I. Lindberg, Jan Teorell, Nazifa Alizada, David Altman, Michael Bernhard, Agnes Cornell, M. Steven Fish, Lisa Gastaldi, Haakon Gjerl\u00f8w, Adam Glynn, Allen Hicken, Garry Hindle, Nina Ilchenko, Joshua Krusell, Anna Luhrmann, Seraphine F. Maerz, Kyle L. Marquardt, Kelly McMann, Valeriya Mechkova, Juraj Medzihorsky, Pamela Paxton, Daniel Pemstein, Jose\ufb01ne Pernes, Johannes von R\u00f6mer, Brigitte Seim, Rachel Sigman, Svend-Erik Skaaning, Jeffrey Staton, Aksel Sundstr\u00f6m, Ei-tan Tzelgov, Yi-ting Wang, Tore Wig, Steven Wilson and Daniel Ziblatt. 2021. \u201dV-Dem [Country\u2013Year/Country\u2013Date] Dataset v11.1\u201d Varieties of Democracy Project. https://doi.org/10.23696/vdemds21"
}
 2021-08-12 11:30:54 2021-08-12 11:30:54 V-Dem Dataset Version 11.1 - V-Dem Institute 5361 The Varieties of Democracy Project (V-Dem) provides a multidimensional and disaggregated dataset with indicators of democracy for all countries since 1900. The data covers five high-level concepts of democracy (electoral, liberal, participatory, deliberative, and egalitarian) and collects data to measure them. V-Dem draws on theoretical and methodological expertise from a global team of experts. Approximately half of the indicators in the V-Dem dataset are based on factual information obtainable from official documents such as constitutions and government records. The other half consists of subjective assessments on topics where multiple country experts provide ratings. https://www.v-dem.net/en/data/data V-Dem (Varieties of Democracy) Institute

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