variables
Data license: CC-BY
49 rows where datasetId = 5171 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146787 | annual_leave | The data is from the Bick et al (2019) Online Appendix section A.2: Public Holidays and Days of Annual Leave. It is originally presented as number of days; we convert days to 5-day workweeks by dividing by 5. | 2021-05-25 20:44:57 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | { "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
146786 | public_holidays | The data is from the Bick et al (2019) Online Appendix section A.2: Public Holidays and Days of Annual Leave. It is originally presented as number of days; we convert days to 5-day workweeks by dividing by 5. | 2021-05-25 20:44:57 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | { "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
143614 | annual_hrs_worked_employed_serv | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143613 | weekly_hrs_worked_serv | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143612 | annual_hrs_worked_employed_manuf | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143611 | weekly_hrs_worked_manuf | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143610 | annual_hrs_worked_employed_agri | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143609 | weekly_hrs_worked_agri | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143608 | annual_hrs_worked_person_edu_high | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143607 | annual_hrs_worked_employed_edu_high | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143606 | weekly_hrs_worked_edu_high | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143605 | employment_rate_edu_high | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143604 | annual_hrs_worked_person_edu_med | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143603 | annual_hrs_worked_employed_edu_med | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143602 | weekly_hrs_worked_edu_med | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143601 | employment_rate_edu_med | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143600 | annual_hrs_worked_person_edu_low | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143599 | annual_hrs_worked_employed_edu_low | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143598 | weekly_hrs_worked_edu_low | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143597 | employment_rate_edu_low | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143596 | annual_hrs_worked_person_edu_enrolled | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143595 | annual_hrs_worked_employed_edu_enrolled | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143594 | weekly_hrs_worked_edu_enrolled | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143593 | employment_rate_edu_enrolled | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143592 | weekly_hrs_worked_55_64 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143591 | employment_rate_55_64 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143590 | annual_hrs_worked_employed_55_64 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143589 | annual_hrs_worked_person_55_64 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143588 | weekly_hrs_worked_25_54 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143587 | employment_rate_25_54 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143586 | annual_hrs_worked_employed_25_54 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143585 | annual_hrs_worked_person_25_54 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143584 | weekly_hrs_worked_15_24 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143583 | employment_rate_15_24 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143582 | annual_hrs_worked_employed_15_24 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143581 | annual_hrs_worked_person_15_24 | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143580 | weekly_hrs_worked_employed_women | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143579 | employment_rate_women | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143578 | annual_hrs_worked_employed_women | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143577 | annual_hrs_worked_person_women | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143576 | weekly_hrs_worked_employed_men | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143575 | employment_rate_men | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143574 | annual_hrs_worked_employed_men | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143573 | annual_hrs_worked_person_men | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143572 | weekly_hrs_worked_employed | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143571 | weeks_worked | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143570 | employment_rate | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
0 | 1 | ||||||||||||||||||||||||||||
143569 | Average annual hours worked per employed person (Bick et al 2019) | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | { "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
143568 | annual_hrs_worked_person | 2020-09-15 18:47:56 | 2023-06-15 05:05:42 | Working Hours – Bick et al (2019) 5171 | Bick et al (2019) 17901 | {} |
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");