owid: sources: 1 row where datasetId = 2756 sorted by id descending

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 = 2756 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
15490	Susan D. Hyde (2011)	{ "link": "Data was kindly shared with OWID by Susan Hyde upon request.", "retrievedDate": "12/04/2018", "additionalInfo": "International election monitoring can be defined as the observation of an election by one or more independent parties, typically from another country or non-governmental organization (NGO). Election observers primarily assess the conduct of elections and factors influencing the prevailing electoral environment. As Hyde (2011) notes \"nearly 80 percent of all national elections are now monitored\". For further background information see Hyde's 2011 paper referenced above.\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 \nCountries excluded from the analysis are microstates and the five independent states that did not hold any direct national elections between 1960 and 2006: China, Eritrea, Qatar, Saudi Arabia, and the United Arab Emirates.", "dataPublishedBy": "Hyde, S.D., 2011. Catch us if you can: Election Monitoring and International Norm Diffusion. American Journal of Political Science, 55(2), pp.356-369.", "dataPublisherSource": "Author's original data." }	2018-04-12 11:05:04	2018-04-12 12:18:00	Rate of internationally observed elections - Susan Hyde (2011) 2756	International election monitoring can be defined as the observation of an election by one or more independent parties, typically from another country or non-governmental organization (NGO). Election observers primarily assess the conduct of elections and factors influencing the prevailing electoral environment. As Hyde (2011) notes "nearly 80 percent of all national elections are now monitored". For further background information see Hyde's 2011 paper referenced above. 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 Countries excluded from the analysis are microstates and the five independent states that did not hold any direct national elections between 1960 and 2006: China, Eritrea, Qatar, Saudi Arabia, and the United Arab Emirates.	Data was kindly shared with OWID by Susan Hyde upon request.	Hyde, S.D., 2011. Catch us if you can: Election Monitoring and International Norm Diffusion. American Journal of Political Science, 55(2), pp.356-369.

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