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 = 470 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
592 Schön and Krantz (2007, 2012, 2015) 
{
    "link": "https://www.ekh.lu.se/en/research/economic-history-data/shna",
    "retrievedDate": "12/05/2017",
    "additionalInfo": "The source notes: \"One should note that present time levels of GDP and sector value added in these series differ from data in contemporary official national accounts. It is natural that a number of shifts and redefinitions are performed in contemporary statistics in relation to structural and technological changes, but it is also reasonable that levels in the short contemporary series are adjusted to the long historical series rather than the other way around. \"",
    "dataPublishedBy": "(i) Sch\u00f6n, L. & Krantz, O. (2015), \"New Swedish Historical National Accounts since the 16th Century in Constant and Current Prices.\" Lund Papers in Economic History 140, Lund University. (ii) Sch\u00f6n, L. & Krantz, O. (2012), \u201cSwedish Historical National Accounts 1560\u20132010.\u201d Lund Papers in Economic History 123, Lund University. (iii) Krantz, O. & Sch\u00f6n, L. (2007), Swedish Historical National Accounts 1800\u20132000, Lund Studies in Economic History 41, Lund.",
    "dataPublisherSource": "Various sources (see papers for details)"
}
 2017-05-15 19:06:21 2017-11-02 13:04:39 Swedish Historical National Accounts - Schön and Krantz (2007, 2012, 2015) 470 The source notes: "One should note that present time levels of GDP and sector value added in these series differ from data in contemporary official national accounts. It is natural that a number of shifts and redefinitions are performed in contemporary statistics in relation to structural and technological changes, but it is also reasonable that levels in the short contemporary series are adjusted to the long historical series rather than the other way around. " https://www.ekh.lu.se/en/research/economic-history-data/shna (i) Schön, L. & Krantz, O. (2015), "New Swedish Historical National Accounts since the 16th Century in Constant and Current Prices." Lund Papers in Economic History 140, Lund University. (ii) Schön, L. & Krantz, O. (2012), “Swedish Historical National Accounts 1560–2010.” Lund Papers in Economic History 123, Lund University. (iii) Krantz, O. & Schön, L. (2007), Swedish Historical National Accounts 1800–2000, Lund Studies in Economic History 41, Lund.

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