variables
Data license: CC-BY
3 rows where datasetId = 2801 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97542 | Hours per week spent in leisure (Aguiar and Hurst (2006)) | hours | Authors explore three alternative definitions of leisure. Leisure Measure 1 sums together the time spent on "entertainment/social activities/relaxing" and "active recreation". Activities in this measure do not have close market substitutes, such as watching television, leisure reading, going to parties, relaxing, going to bars, playing golf, surfing the web, visiting friends etc. "Recreational" child care is included in this measure which includes activities such as playing with a child, going on outings with a child, attending a child's sporting events or dance recital, etc. Leisure Measure 2 includes Leisure Measure 1 as well as time spent in sleeping, eating, and personal care, e.g. eating at home or in restaurants. Leisure Measure 3 includes Leisure Measure 2 plus time spent in "primary" and "educational" child care. "Primary" child care includes any time spent on the basic needs of children while "educational" child care includes time spent reading to children, teaching children, helping with homework etc. The authors note: "there appears to be a discontinuity in how child care is measured between the 2003 American Time Use Survey and all other surveys. There is a potential for there to be an increase in time spent in child care activities between the 2003 time‐use survey and the other surveys that results purely from a change in the classification of activities across the surveys. Time spent in activities that were conducted in the presence of children that were previously coded as time spent in other activities may have been classified as child care in 2003." Leisure Measure 4 is the residual of total work. The difference between Leisure Measures 3 and 4 includes time spent in education, civic and religious activities (going to church, volunteering, social clubs, etc.), caring for other adults, and own medical care. | 2018-06-07 14:05:50 | 2023-06-15 05:05:42 | The allocation of time over five decades - Aguiar and Hurst (2006) 2801 | Aguiar and Hurst (2006) 15538 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97541 | Hours per week spent on child care (Aguiar and Hurst (2006)) | hours | Aguiar and Hurst (2006) define 'primary' child care as "any time spent on the basic needs of children, including breast feeding, rocking a child to sleep, general feeding, changing diapers, providing medical care (either directly or indirectly), grooming, etc; 'educational' child care as any time spent reading to children, teaching children, helping children with homework, attending meetings at a child’s school, etc; 'recreational' child care as playing games with children, playing outdoors with children, attending a child’s sporting event or dance recital, going to the zoo with children, and taking walks with children; and 'total' child care,” which is the sum of the other three measures." | 2018-06-07 14:05:50 | 2023-06-15 05:05:42 | The allocation of time over five decades - Aguiar and Hurst (2006) 2801 | Aguiar and Hurst (2006) 15538 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97540 | Hours per week spent in market and non-market work (Aguiar and Hurst (2006)) | hours | Aguiar and Hurst (2006) define "core" market work to "include all time spent working in the market sector on main jobs, second jobs, and overtime, including any time spent working at home. This market-work measure is analogous to the market work measures in the Census, the Panel Survey of Income Dynamics (PSID), or the Survey of Consumer Finances (SCF). The broader category "total" market work is core market work plus time spent commuting to/from work and time spent on ancillary work activities (e.g. time spent at work on breaks or eating a meal)." Note non-market work excludes child care which has been included as a separate category altogether. Aguiar and Hurst define three categories of time spent in non-market production. Time spent on an activity includes any time spent on transportation associated with that activity. 1. Time spent on "core" housework. This includes any time spent on meal preparation and cleanup, doing laundry, ironing, dusting, vacuuming, indoor household cleaning, indoor design and maintenance (including painting and decorating), etc. 2. Time spent “obtaining goods and services.” This category includes all time spent acquiring any goods or services (excluding medical care, education, and restaurant meals). Examples include grocery shopping, shopping for other household items, comparison shopping, coupon clipping, going to the bank, going to a barber, going to the post office, buying goods online, etc. 3. Total non-market work includes time spent in core household chores, time spent obtaining goods and services, plus time spent on other home production such as home maintenance, outdoor cleaning, vehicle repair, gardening, pet care, etc. This latter category is designed to be a complete measure of non‐market work. | 2018-06-07 14:05:50 | 2023-06-15 05:05:42 | The allocation of time over five decades - Aguiar and Hurst (2006) 2801 | Aguiar and Hurst (2006) 15538 | {} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");