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 = 2911 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
15639 Statistics Finland 
{
    "link": "http://pxnet2.stat.fi/PXWeb/pxweb/en/StatFin/StatFin__eli__akay/statfin_akay_pxt_001.px/?rxid=8125706d-1229-4acf-acef-1e302ecb617a",
    "retrievedDate": "31/08/2018",
    "additionalInfo": "Statistics Finland has 26 time use categories aggregated under 6 main headings: gainful employment, domestic work, personal care, study, free time, and time left unspecified. \n\nActivity definitions are outlined below:\n<ul>\n<li>Gainful employment includes time spent at work as well as travel to and from work. </li>\n<li>Domestic work includes housekeeping, maintenance work, other domestic work, childcare, shopping and services, and travel related to domestic work.</li>\n<li>Personal care includes sleep, meals, washing and dressing. </li>\n<li>Study includes time spent in school or university, travel related to study, and free time study (incl. related travel). </li>\n<li>Free time includes participatory activity, sports and outdoor activities, entertainment and culture, reading, listening to radio, TV, socialising with friends and family, hobbies, other free time, and travel related to free time.</li>\n</ul>",
    "dataPublishedBy": "Statistics Finland",
    "dataPublisherSource": "National time use surveys"
}
 2018-08-31 16:54:24 2018-08-31 16:54:24 Time use in Finland - Statistics Finland 2911 Statistics Finland has 26 time use categories aggregated under 6 main headings: gainful employment, domestic work, personal care, study, free time, and time left unspecified. Activity definitions are outlined below: <ul> <li>Gainful employment includes time spent at work as well as travel to and from work. </li> <li>Domestic work includes housekeeping, maintenance work, other domestic work, childcare, shopping and services, and travel related to domestic work.</li> <li>Personal care includes sleep, meals, washing and dressing. </li> <li>Study includes time spent in school or university, travel related to study, and free time study (incl. related travel). </li> <li>Free time includes participatory activity, sports and outdoor activities, entertainment and culture, reading, listening to radio, TV, socialising with friends and family, hobbies, other free time, and travel related to free time.</li> </ul> http://pxnet2.stat.fi/PXWeb/pxweb/en/StatFin/StatFin__eli__akay/statfin_akay_pxt_001.px/?rxid=8125706d-1229-4acf-acef-1e302ecb617a Statistics Finland

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