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 = 672 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
2832 Hermanussen (2003) and NCD RisC, Human Height (2017) 
{
    "link": "http://www.hormones.gr/pdf/Stature_europeans.pdf and http://www.ncdrisc.org/data-downloads-height.html",
    "retrievedDate": "16/05/19",
    "additionalInfo": "This series combines figures from two published datasets.\n\nData on human heights in Early Europeans in the Eastern Mediterranean region was sourced from Stature of Early Europeans - Hermanussen (2013). These heights are provided for specific historical periods: where values are provided over a time range (for example, 10000-8000 BC), we have have allocated a date in the middle of this range (9000 BC, in this example).\n\nTo compare how historical heights have evolved into the 19th and 20th century, we have combined this series with data for Europe and Central Asia in the period 1896-1996 from the NCD RisC.\n\nReferences:\n\nHermanussen, M. (2003). Stature of early Europeans. HORMONES-ATHENS-, 2, 175-178.",
    "dataPublishedBy": "HORMONES Journal and NCD RisC",
    "dataPublisherSource": null
}
 2017-08-17 14:30:57 2017-11-02 13:04:39 Heights of Early Europeans - based on Hermanussen (2003) and the NCD RisC (2017) 672 This series combines figures from two published datasets. Data on human heights in Early Europeans in the Eastern Mediterranean region was sourced from Stature of Early Europeans - Hermanussen (2013). These heights are provided for specific historical periods: where values are provided over a time range (for example, 10000-8000 BC), we have have allocated a date in the middle of this range (9000 BC, in this example). To compare how historical heights have evolved into the 19th and 20th century, we have combined this series with data for Europe and Central Asia in the period 1896-1996 from the NCD RisC. References: Hermanussen, M. (2003). Stature of early Europeans. HORMONES-ATHENS-, 2, 175-178. http://www.hormones.gr/pdf/Stature_europeans.pdf and http://www.ncdrisc.org/data-downloads-height.html HORMONES Journal and NCD RisC

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