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 = 55 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
24 Sam Peltzman (2009) 
{
    "link": "https://ezproxy-prd.bodleian.ox.ac.uk:3297/articles?id=10.1257/jep.23.4.175",
    "retrievedDate": "15/11/2017",
    "additionalInfo": "Sent in by Sam Peltzman, who uses this data in his paper \u201cMortality Inequality\u201d, Journal of Economic Perspectives 23(4), Fall 2009: 175-190.\r\n\r\nLife tables defined by Peltzman (2009) \"lists the number of survivors at each age from a hypothetical birth (age=0) cohort of 100,000.\" The life table data is compiled from two online databases: www.mortality.org developed by researchers at the University of California Berkeley and the Data Laboratory of the Max Planck Institute for Demographic Research in Rostock, Germany. The http://www.lifetable.de/ data was put together by researchers from these two institutions and the researchers from the Institut national d'etudes demographiques in Paris, France.",
    "dataPublishedBy": "Please see additional information. ",
    "dataPublisherSource": "Data in Peltzman's paper based on life tables."
}
 2015-07-19 04:12:00 2017-11-15 20:55:14 Gini coefficients for lifetime inequality - Peltzman (2009) 55 Sent in by Sam Peltzman, who uses this data in his paper “Mortality Inequality”, Journal of Economic Perspectives 23(4), Fall 2009: 175-190. Life tables defined by Peltzman (2009) "lists the number of survivors at each age from a hypothetical birth (age=0) cohort of 100,000." The life table data is compiled from two online databases: www.mortality.org developed by researchers at the University of California Berkeley and the Data Laboratory of the Max Planck Institute for Demographic Research in Rostock, Germany. The http://www.lifetable.de/ data was put together by researchers from these two institutions and the researchers from the Institut national d'etudes demographiques in Paris, France. https://ezproxy-prd.bodleian.ox.ac.uk:3297/articles?id=10.1257/jep.23.4.175 Please see additional information.

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