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 = 2905 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
15633 Statistics Sweden 
{
    "link": "http://www.scb.se/en_/Finding-statistics/Publishing-calendar/Show-detailed-information/?publobjid=18561+",
    "retrievedDate": "28/08/2018",
    "additionalInfo": "Time spent on activities has been categorised under six main headings: gainful employment, personal needs, housework, leisure, studies, and other activities. \n\nThe definition for each activity is outlined below:\n<ul>\n<li>Gainful employment includes time spent at work and time spent commuting to and from work. </li>\n<li>Personal needs includes meals, personal care, and travel for personal needs. </li>\n<li>Housework includes cooking, washing, ironing, cleaning, caring for own children, caring for others, maintenance work, purchase of goods and services, other housework, and related travel.</li>\n<li>Leisure time includes sports and outdoor activities, TV and radio, hobbies, entertainment, cultural, and social activities, other free time, and related travel. </li>\n<li>Study time includes time spent studying and travel for studies. </li>\n</ul>\n\nFor the original data, see Table 1 in the <a href=\"http://www.scb.se/statistik/_publikationer/LE0103_1990I91_BR_LE80SA9201.pdf\" rel=\"noopener\" target=\"_blank\">1990 Sweden Statistics time use report</a>; Table B:4 in the <a href=\"http://www.scb.se/statistik/LE/LE0103/2003M00/LE99SA0301.pdf\" rel=\"noopener\" target=\"_blank\">2000 report</a>; and Table B:1a in the <a href=\"http://www.scb.se/statistik/_publikationer/LE0103_2010A01_BR_LE123BR1201.pdf\" rel=\"noopener\" target=\"_blank\">2010 report</a>.",
    "dataPublishedBy": "Statistics Sweden",
    "dataPublisherSource": "National time use surveys"
}
 2018-08-29 11:54:33 2018-08-29 11:54:33 Time use in Sweden - Statistics Sweden 2905 Time spent on activities has been categorised under six main headings: gainful employment, personal needs, housework, leisure, studies, and other activities. The definition for each activity is outlined below: <ul> <li>Gainful employment includes time spent at work and time spent commuting to and from work. </li> <li>Personal needs includes meals, personal care, and travel for personal needs. </li> <li>Housework includes cooking, washing, ironing, cleaning, caring for own children, caring for others, maintenance work, purchase of goods and services, other housework, and related travel.</li> <li>Leisure time includes sports and outdoor activities, TV and radio, hobbies, entertainment, cultural, and social activities, other free time, and related travel. </li> <li>Study time includes time spent studying and travel for studies. </li> </ul> For the original data, see Table 1 in the <a href="http://www.scb.se/statistik/_publikationer/LE0103_1990I91_BR_LE80SA9201.pdf" rel="noopener" target="_blank">1990 Sweden Statistics time use report</a>; Table B:4 in the <a href="http://www.scb.se/statistik/LE/LE0103/2003M00/LE99SA0301.pdf" rel="noopener" target="_blank">2000 report</a>; and Table B:1a in the <a href="http://www.scb.se/statistik/_publikationer/LE0103_2010A01_BR_LE123BR1201.pdf" rel="noopener" target="_blank">2010 report</a>. http://www.scb.se/en_/Finding-statistics/Publishing-calendar/Show-detailed-information/?publobjid=18561+ Statistics Sweden

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