variables
Data license: CC-BY
4 rows where datasetId = 234 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, coverage, timespan, display, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145323 | Days of vacation and holidays for full-time production workers in non-agricultural activities (Huberman & Minns 2007) | The original sources are: 1870 and 1900, Huberman (2004); 1938, ILO (1939); 1950 and 1980, European Industrial Relations Review (1982), Green and Potepan (1988), Monthly Labor Review (1955); 1990, ILO (1995); 2000, EIRO (2003) and OECD (2004) | 2020-10-23 22:02:18 | 2023-06-15 05:05:42 | Working Hours Data - Huberman & Minns (2007) 234 | Huberman & Minns (2007) 200 | { "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
143621 | Weeks worked for full-time production workers in non-agricultural activities (Huberman & Minns 2007) | These values were calculated by OWID as: Weeks Worked = Annual Working Hours / Weekly Working Hours | 2020-09-29 19:43:24 | 2023-06-15 05:05:42 | Working Hours Data - Huberman & Minns (2007) 234 | Huberman & Minns (2007) 200 | { "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
143615 | Annual working hours for full-time production workers in non-agricultural activities (Huberman & Minns 2007) | 2020-09-15 21:19:02 | 2023-06-15 05:05:42 | Working Hours Data - Huberman & Minns (2007) 234 | Huberman & Minns (2007) 200 | { "includeInTable": true, "entityAnnotationsMap": "The original sources are: 1870\u20131913, Huberman (2004); 1929 and 1938, Tables 1 and 2 with deductions for days absent; the values for Spain in 1938 are for 1936. 1950\u20132000, University of Groningen and the Conference Board GGDC Total Economy Database (2005)" } |
0 | 1 | ||||||||||||||||||||||||||||
348 | Weekly working hours for full-time production workers in non-agricultural activities (Huberman & Minns 2007) | hours per week | Data refers to full-time production workers (male and female) in non-agricultural activities. Only for 2000 Huberman & Minns give estimates for both genders separately. The average of the two measures have been calculated and visualised. The original sources are: 1870–1913: Huberman (2004); 1929–1938, ILO (1934–38), except for Canada (Ostry and Zaidi, 1972), U.S. (Jones, 1963 and Owen, 1988), and for Australia (Butlin, 1977); the values for Spain in 1938 are for 1936; 1950–1980: ILO (1950–80), except for U.S. (McGratten and Rogerson, 2004), and Australia ( Butlin, 1977); 1980–2000: ILO (2005), except for U.S. (McGratten and Rogerson, 2004), Canada (Heisz and LaRochelle-Côté, 2003), and Denmark (Eurostat, 1995). | 2016-01-01 00:00:00 | 2023-06-15 05:05:42 | 14 early industrialized countries | 1870 to 2000 | Working Hours Data - Huberman & Minns (2007) 234 | Huberman & Minns (2007) 200 | h | { "includeInTable": true } |
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");