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 = 153 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
86 Fraser Institute, Economic Freedom of the World (2018) 
{
    "link": "https://www.fraserinstitute.org/economic-freedom/dataset?geozone=world&year=2016&page=dataset",
    "retrievedDate": "13/05/19",
    "additionalInfo": "Economic Freedom of the World is calculated by the Fraser Institute, and measures the degree to which individuals are free to choose, trade, and cooperate with others, and compete as they see fit.\n\nThe cornerstones of economic freedom are (1) personal choice, (2) voluntary exchange coordinated by markets, (3) freedom to enter and compete in markets, and (4) protection of persons and their property from aggression by others.\n\nIndividuals have economic freedom when property they acquire without the use of force, fraud, or theft is protected from physical invasions by others and they are free to use, exchange, or give their property as long as their actions do not violate the identical rights of others.",
    "dataPublishedBy": "Fraser Institute",
    "dataPublisherSource": "Third party sources, such as the International Country Risk Guide, the Global Competitiveness Report, and the World Bank\u2019s Doing Business project"
}
 2016-01-24 00:43:53 2017-11-27 11:23:44 Economic Freedom of the World - Fraser Institute (2018) 153 Economic Freedom of the World is calculated by the Fraser Institute, and measures the degree to which individuals are free to choose, trade, and cooperate with others, and compete as they see fit. The cornerstones of economic freedom are (1) personal choice, (2) voluntary exchange coordinated by markets, (3) freedom to enter and compete in markets, and (4) protection of persons and their property from aggression by others. Individuals have economic freedom when property they acquire without the use of force, fraud, or theft is protected from physical invasions by others and they are free to use, exchange, or give their property as long as their actions do not violate the identical rights of others. https://www.fraserinstitute.org/economic-freedom/dataset?geozone=world&year=2016&page=dataset Fraser 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");