variables
Data license: CC-BY
8 rows where datasetId = 2825 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97623 | Average hours of work per week in anthracite coal (Jones) | hours | Average hours of work per week in bituminous coal. Data gathered using monthly reports from a sample of establishments since 1932. Jones' historical series takes the data from the BLS and performs downward adjustments of the BLS observations necessitated by the introduction of a number of employer pay practices. In 1943, employers began to compensate workers in bituminous and anthracite industries for the hours spent travelling in the mine shaft opening to the place of work within the time. Travel time within the mine is included in average work hours when it is paid for, and excluded when it is not. Employee coverage is limited to production workers. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97622 | Average hours of work per week in anthracite coal (BLS) | hours | Average hours of work per week in bituminous coal. Data gathered using monthly reports from a sample of establishments since 1932. Jones' historical series takes the data from the BLS and performs downward adjustments of the BLS observations necessitated by the introduction of a number of employer pay practices. In 1943, employers began to compensate workers in bituminous and anthracite industries for the hours spent travelling in the mine shaft opening to the place of work within the time. Travel time within the mine is included in average work hours when it is paid for, and excluded when it is not. Employee coverage is limited to production workers. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97621 | Average hours of work per week in bituminous coal (Jones) | hours | Average hours of work per week in bituminous coal. Data gathered using monthly reports from a sample of establishments since 1932. Jones' historical series takes the data from the BLS and performs downward adjustments of the BLS observations necessitated by the introduction of a number of employer pay practices. In 1943, employers began to compensate workers in bituminous and anthracite industries for the hours spent travelling in the mine shaft opening to the place of work within the time. Travel time within the mine is included in average work hours when it is paid for, and excluded when it is not. Employee coverage is limited to production workers. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97620 | Average hours of work per week in bituminous coal (BLS) | hours | Average hours of work per week in bituminous coal. Data gathered using monthly reports from a sample of establishments since 1932. Employee coverage is limited to production workers. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97619 | Average hours of work per week on railroads (Jones) | hours | Average hours of work per week working on railroads. Estimates derived hours per week from the monthly reports on hours filed by Class I steam railroads with the United States Interstate Commerce Commission. Total hours paid have sub-categories which allows the separation of hours paid for into 'hours actually spent at work', and 'hours paid for but not worked'. BLS bases its estimates on total time paid for, including both categories above, whereas Jones' series excludes the sub-category 'time paid for but not worked'. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97618 | Average hours of work per week on railroads (BLS) | hours | Average hours of work per week working on railroads. Estimates derived hours per week from the monthly reports on hours filed by Class I steam railroads with the United States Interstate Commerce Commission. Total hours paid have sub-categories which allows the separation of hours paid for into 'hours actually spent at work', and 'hours paid for but not worked'. BLS bases its estimates on total time paid for, including both categories above, whereas Jones' series excludes the sub-category 'time paid for but not worked'. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97617 | Average hours per week worked in manufacturing (Jones) | hours | Average hours of work per week in manufacturing using Jones' series construction. Employee coverage is limited to production workers. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97616 | Average hours per week worked in manufacturing (BLS) | hours | Average hours of work per week in manufacturing using the Bureau of Labour Statistics' (BLS) historical series. Employee coverage is limited to production workers. | 2018-06-28 12:37:57 | 2023-06-15 05:05:42 | New estimates of hours of work per week, 1900-1957 - Jones (1963) 2825 | Jones (1963) 15556 | {} |
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");