sources
Data license: CC-BY
1 row where datasetId = 5199 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
|---|---|---|---|---|---|---|---|---|
| 17929 | Multi-Year American Time Use Survey (2009-2019) | {
"link": "https://www.bls.gov/tus/datafiles-0319.htm",
"retrievedDate": "16/10/2020",
"additionalInfo": "These estimates are based on a classification of time spent on various activities while being in company of others, and the presentation of the data was inspired by earlier work from Henrik Lindberg.\n\nThe time-use data comes from the American Time Use Survey (ATUS), and the classification of activities and relationships relies on the code from Henrik Lindberg, available from <a href=\"https://gist.github.com/halhen/d969234077c9b70df4c4b8dd902bea38\">Lindberg's GitHub Repo</a>. All estimates correspond to pooled data for the period 2009-2019, using population weights.\n\nEstimates rely on the ATUS \"Who File\". This is a file that indicates who was present during each activity recorded. People can be counted twice, which means that attending a party with friends and your spouse, for example, would count for both categories. Sleeping is excluded.\n\n<b> Further notes </b>\n\n- Some of the original \"Who Codes\" have be re-coded and grouped (e.g. 'roommate' has been coded as 'friend')\n- In the ATUS \"Who File\" there is one record for each person reported present. Therefore, there will be one record for activities done alone and multiple records for activities with multiple people present. For some activities, no \u201cwho\u201d codes are collected (such as sleeping and grooming).",
"dataPublishedBy": "US Bureau of Labor Statistics",
"dataPublisherSource": "Survey data"
} |
2020-10-18 19:33:16 | 2020-10-18 19:33:16 | Who Americans spend time with - American Time Use Survey (2009-2019) 5199 | These estimates are based on a classification of time spent on various activities while being in company of others, and the presentation of the data was inspired by earlier work from Henrik Lindberg. The time-use data comes from the American Time Use Survey (ATUS), and the classification of activities and relationships relies on the code from Henrik Lindberg, available from <a href="https://gist.github.com/halhen/d969234077c9b70df4c4b8dd902bea38">Lindberg's GitHub Repo</a>. All estimates correspond to pooled data for the period 2009-2019, using population weights. Estimates rely on the ATUS "Who File". This is a file that indicates who was present during each activity recorded. People can be counted twice, which means that attending a party with friends and your spouse, for example, would count for both categories. Sleeping is excluded. <b> Further notes </b> - Some of the original "Who Codes" have be re-coded and grouped (e.g. 'roommate' has been coded as 'friend') - In the ATUS "Who File" there is one record for each person reported present. Therefore, there will be one record for activities done alone and multiple records for activities with multiple people present. For some activities, no “who” codes are collected (such as sleeping and grooming). | https://www.bls.gov/tus/datafiles-0319.htm | US Bureau of Labor Statistics |
Advanced export
JSON shape: default, array, newline-delimited, object
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");