sources
Data license: CC-BY
1 row where datasetId = 5316 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
18036 | International Labor Organization (2021) | { "link": "https://www.ilo.org/ilostat-files/WEB_bulk_download/indicator/EMP_TEMP_SEX_HOW_DT_A.csv.gz", "retrievedDate": "February 2021", "additionalInfo": "According to the ILO, \"The employed comprise all persons of working age who, during a specified brief period, were in one of the following categories: a) paid employment (whether at work or with a job but not at work); or b) self-employment (whether at work or with an enterprise but not at work).\n\nData are disaggregated by weekly hours actually worked, on the basis of the mean number of hours of work per week, and with reference to hours worked in all jobs of employed persons and in all types of working time arrangements (e.g. full-time and part-time).\n\nThe concept of hours actually worked within the System of National Accounts (SNA) production boundary relates to the time that persons in employment spend directly on, and in relation to, productive activities; down time; and resting time during a specified time reference period. It thus includes (a) \u201cdirect hours\u201d or the time spent carrying out the tasks and duties of a job; (b) \u201crelated hours\u201d, or the time spent maintaining, facilitating or enhancing productive activities; (c) \u201cdown time\u201d, or time when a person in a job cannot work due to machinery or process breakdown, accident, lack of supplies or power or Internet access; and (d) \u201cresting time\u201d, or time spent in short periods of rest, relief or refreshment, including tea, coffee or prayer breaks, generally practiced by custom or contract according to established norms and/or national circumstances.\n\nHours actually worked excludes time not worked during activities such as: (a) Annual leave, public holidays, sick leave, parental leave or maternity/paternity leave, other leave for personal or family reasons or civic duty; (b) Commuting time between work and home when no productive activity for the job is performed; (c) Time spent in certain educational activities; (d) Longer breaks distinguished from short resting time when no productive activity is performed (such as meal breaks or natural repose during long trips).\"\n\nFor more details see the ILO Indicator description page: https://ilostat.ilo.org/resources/concepts-and-definitions/description-hours-of-work/", "dataPublishedBy": "International Labor Organization", "dataPublisherSource": "Labor force surveys" } |
2021-05-26 21:50:51 | 2021-05-26 21:50:51 | Weekly Working Hours — ILO (2021) 5316 | According to the ILO, "The employed comprise all persons of working age who, during a specified brief period, were in one of the following categories: a) paid employment (whether at work or with a job but not at work); or b) self-employment (whether at work or with an enterprise but not at work). Data are disaggregated by weekly hours actually worked, on the basis of the mean number of hours of work per week, and with reference to hours worked in all jobs of employed persons and in all types of working time arrangements (e.g. full-time and part-time). The concept of hours actually worked within the System of National Accounts (SNA) production boundary relates to the time that persons in employment spend directly on, and in relation to, productive activities; down time; and resting time during a specified time reference period. It thus includes (a) “direct hours” or the time spent carrying out the tasks and duties of a job; (b) “related hours”, or the time spent maintaining, facilitating or enhancing productive activities; (c) “down time”, or time when a person in a job cannot work due to machinery or process breakdown, accident, lack of supplies or power or Internet access; and (d) “resting time”, or time spent in short periods of rest, relief or refreshment, including tea, coffee or prayer breaks, generally practiced by custom or contract according to established norms and/or national circumstances. Hours actually worked excludes time not worked during activities such as: (a) Annual leave, public holidays, sick leave, parental leave or maternity/paternity leave, other leave for personal or family reasons or civic duty; (b) Commuting time between work and home when no productive activity for the job is performed; (c) Time spent in certain educational activities; (d) Longer breaks distinguished from short resting time when no productive activity is performed (such as meal breaks or natural repose during long trips)." For more details see the ILO Indicator description page: https://ilostat.ilo.org/resources/con… | https://www.ilo.org/ilostat-files/WEB_bulk_download/indicator/EMP_TEMP_SEX_HOW_DT_A.csv.gz | International Labor Organization |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");