variables
Data license: CC-BY
7 rows where datasetId = 2877 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
97808 | Average scheduled minutes of work per day (Atack and Bateman (1992)) | minutes | Average scheduled minutes of work per day nationwide in the United States. | 2018-08-13 10:58:43 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
0 | 1 | ||||||||||||||||||||||||
97807 | Mean absolute difference in minutes of work between summer and winter, weighted by employees (Atack and Bateman (1992)) | minutes | Mean absolute difference in minutes worked between summer and winter, weighted by employees. Each firm observation is weighted by the sum of its male, female, and child workers. | 2018-08-13 10:58:43 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
0 | 1 | ||||||||||||||||||||||||
97806 | Average daily minutes of work in winter, weighted by employees (Atack and Bateman (1992)) | minutes | Average daily minutes of work in the winter. Each firm observation is weighted by the sum of its male, female, and child workers. | 2018-08-13 10:58:43 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
0 | 1 | ||||||||||||||||||||||||
97805 | Average daily minutes of work in summer, weighted by employees (Atack and Bateman (1992)) | minutes | Average daily minutes of work in the summer. Each firm observation is weighted by the sum of its male, female, and child workers. | 2018-08-13 10:58:42 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
0 | 1 | ||||||||||||||||||||||||
97804 | Mean absolute difference in minutes of work between summer and winter, weighted by firm (Atack and Bateman (1992)) | minutes | Mean absolute difference in minutes worked between summer and winter, weighted by firm. Calculated on the basis of each firm's reported hours of work between May and November, and November and May. | 2018-08-13 10:58:42 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
0 | 1 | ||||||||||||||||||||||||
97803 | Average daily minutes of work in winter, weighted by firm (Atack and Bateman (1992)) | minutes | Average daily minutes of work in the winter. Calculated on the basis of each firm's reported hours of work between May and November, and November and May. | 2018-08-13 10:58:42 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
0 | 1 | ||||||||||||||||||||||||
97802 | Average daily minutes of work in summer, weighted by firm (Atack and Bateman (1992)) | minutes | Average daily minutes of work in the summer. Calculated on the basis of each firm's reported hours of work between May and November, and November and May. | 2018-08-13 10:58:42 | 2023-06-15 05:05:42 | United States | 1880 | Length of the workday in 1880 - Atack and Bateman (1992) 2877 | Atack and Bateman (1992) 15605 | {} |
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");