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 = 2500 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
14719 Clio-infra (2016) and Northern Ireland Statistics and Research Agency census (1991, 2001) 
{
    "link": "https://www.clio-infra.eu/ & https://www.nisra.gov.uk/statistics/census ",
    "retrievedDate": null,
    "additionalInfo": "Prior to 1921 (partition of Ireland) the Clio-infra series is used. After 1921 this series presents the Clio-infra data (which represents only the Republic of Ireland) added to the population of Northern Ireland as given in the closest census year to the reference year. For 1930, the population figure for Northern Ireland used is that of the 1926 census. That of 1940, the 1937 census. From 1950 onwards, decadal census figures from 1951, 1961, etc are used. ",
    "dataPublishedBy": "Clio-infra, NISRA",
    "dataPublisherSource": null
}
 2018-03-09 14:15:02 2018-03-09 14:15:02 Population (Clio-infra (2016)), with Island of Ireland (Rep. + Northern) 2500 Prior to 1921 (partition of Ireland) the Clio-infra series is used. After 1921 this series presents the Clio-infra data (which represents only the Republic of Ireland) added to the population of Northern Ireland as given in the closest census year to the reference year. For 1930, the population figure for Northern Ireland used is that of the 1926 census. That of 1940, the 1937 census. From 1950 onwards, decadal census figures from 1951, 1961, etc are used. https://www.clio-infra.eu/ & https://www.nisra.gov.uk/statistics/census Clio-infra, NISRA

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