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 = 2826 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
15557 Eurostat 
{
    "link": "http://ec.europa.eu/eurostat/data/database?node_code=tus_00npaywork# Dataset: tus_00age",
    "retrievedDate": "28/06/2018",
    "additionalInfo": "This Eurostat data set measures the time spent, participation time, and participation rate in 55 activities. \n\nFor the purposes of illustrating how time use has changed over time, we have aggregated the 55 activities under six main headings provided in the original Eurostat source. The six headings are (1) Personal care; (2) Employment, related activities, and travel; (3) Study; (4) Household and family care; (5) Leisure, social, and associative life; and (6) Travel and unspecified time use. The data has been normalised to 1440 minutes per day. \n\nThe survey population includes private participants only - individuals living in institutions (nursing homes, homes for the elderly, children\u2019s homes, rehabilitation centres and penitentiary) are excluded. For further information on the time use surveys see: http://ec.europa.eu/eurostat/cache/metadata/en/tus_esms.htm",
    "dataPublishedBy": "Eurostat",
    "dataPublisherSource": "Time use surveys, Harmonised European Time Use Surveys (HETUS) Wave 1 (2000) and Wave 2 (2010)"
}
 2018-06-29 10:52:44 2018-08-10 12:52:16 Time spent, participation time, and participation rates - Eurostat 2826 This Eurostat data set measures the time spent, participation time, and participation rate in 55 activities. For the purposes of illustrating how time use has changed over time, we have aggregated the 55 activities under six main headings provided in the original Eurostat source. The six headings are (1) Personal care; (2) Employment, related activities, and travel; (3) Study; (4) Household and family care; (5) Leisure, social, and associative life; and (6) Travel and unspecified time use. The data has been normalised to 1440 minutes per day. The survey population includes private participants only - individuals living in institutions (nursing homes, homes for the elderly, children’s homes, rehabilitation centres and penitentiary) are excluded. For further information on the time use surveys see: http://ec.europa.eu/eurostat/cache/metadata/en/tus_esms.htm http://ec.europa.eu/eurostat/data/database?node_code=tus_00npaywork# Dataset: tus_00age 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");