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 = 152 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
85 Freedom House, Freedom of the Press (2017) 
{
    "link": "https://freedomhouse.org/sites/default/files/2020-02/FOTP1980-FOTP2017_Public-Data.xlsx",
    "retrievedDate": "March 8, 2022",
    "additionalInfo": "This dataset provides information on press freedoms, using data from Freedom House's (2017) Freedom of the Press.\n\nFor the years 1979-1987, we use the worse classification across the two dimensions of print and broadcast media. \n\nFor the data covering January 1981 to August 1982 we code the year 1982, and for the data covering August 1982 to November 1983 we code the year 1983.\n\nWe show the data for Czechoslovakia as Czechia, for the USSR as Russia, and for Yugoslavia as Serbia.\n\nYou can download the code and complete dataset, including supplementary variables, from GitHub: https://github.com/owid/notebooks/tree/main/BastianHerre/human_rights",
    "dataPublishedBy": "Freedom House, Freedom of the Press",
    "dataPublisherSource": "On-the-ground research, consultations with local contacts, and information from news articles, nongovernmental organizations, and governments."
}
 2016-01-23 23:05:01 2017-11-16 13:33:35 Press freedom - Freedom House (2017) 152 This dataset provides information on press freedoms, using data from Freedom House's (2017) Freedom of the Press. For the years 1979-1987, we use the worse classification across the two dimensions of print and broadcast media. For the data covering January 1981 to August 1982 we code the year 1982, and for the data covering August 1982 to November 1983 we code the year 1983. We show the data for Czechoslovakia as Czechia, for the USSR as Russia, and for Yugoslavia as Serbia. You can download the code and complete dataset, including supplementary variables, from GitHub: https://github.com/owid/notebooks/tree/main/BastianHerre/human_rights https://freedomhouse.org/sites/default/files/2020-02/FOTP1980-FOTP2017_Public-Data.xlsx Freedom House, Freedom of the Press

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