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 = 2821 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
15552 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 
{
    "link": "2004 edition: http://ec.europa.eu/eurostat/web/products-pocketbooks/-/KS-58-04-998 and 2005 edition: http://ec.europa.eu/eurostat/documents/3888793/5833013/KS-CC-05-001-EN.PDF/5af70d49-9012-444d-b6a0-f28a7677d8e4",
    "retrievedDate": "20/06/2018",
    "additionalInfo": "Ten European countries, Belgium, Germany, Estonia, France, Hungary, Slovenia, Finland, Sweden, the United Kingdom, and Norway are included because the survey methods used closely followed the <a href=\"http://ec.europa.eu/eurostat/ramon/statmanuals/files/KS-RA-08-014-EN.pdf\" rel=\"noopener\" target=\"_blank\">Guidelines on Harmonised European Time Use Surveys</a> published in September 2000. Therefore, results are considered to be comparable. \n\nA representative sample of individuals completed a diary during one weekday and one weekend day distributed over the whole year. ",
    "dataPublishedBy": "Eurostat",
    "dataPublisherSource": "National time use surveys, HETUS"
}
 2018-06-20 13:50:52 2018-06-20 14:26:00 How Europeans spend their time - European Commission (2004) 2821 Ten European countries, Belgium, Germany, Estonia, France, Hungary, Slovenia, Finland, Sweden, the United Kingdom, and Norway are included because the survey methods used closely followed the <a href="http://ec.europa.eu/eurostat/ramon/statmanuals/files/KS-RA-08-014-EN.pdf" rel="noopener" target="_blank">Guidelines on Harmonised European Time Use Surveys</a> published in September 2000. Therefore, results are considered to be comparable. A representative sample of individuals completed a diary during one weekday and one weekend day distributed over the whole year. 2004 edition: http://ec.europa.eu/eurostat/web/products-pocketbooks/-/KS-58-04-998 and 2005 edition: http://ec.europa.eu/eurostat/documents/3888793/5833013/KS-CC-05-001-EN.PDF/5af70d49-9012-444d-b6a0-f28a7677d8e4 Eurostat

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