charts: 4536

This table contains the information used by our Grapher datavisualisation tool to render charts.

The most relevant field is the config field that contains json stored as text. A JSON Schema is available that describes the content of this json data. The SQLite JSON_EXTRACT function can be used in SQL queries to extract the content of this JSON data into columns in a result table.

Data license: CC-BY

This data as json

id slug type config createdAt updatedAt lastEditedAt publishedAt lastEditedByUserId publishedByUserId isIndexable title subtitle note title_plus_variant configWithDefaults
4536 compare-sources-working-hours LineChart 
{
    "id": 4536,
    "map": {
        "columnSlug": "143569"
    },
    "note": "OECD data refers to average annual hours actually worked per worker; PWT data refers to average annual hours worked by persons engaged; Bick et al data refers to average annual hours worked per employed person; Huberman & Minns data refers to annual hours of full-time production workers (male and female) in non-agricultural activities",
    "slug": "compare-sources-working-hours",
    "title": "Annual working hours per worker, various sources",
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 94,
    "subtitle": "Comparison of various sources of annual working hours estimates. Note that not all sources publish data for every country.",
    "originUrl": "https://ourworldindata.org/working-hours",
    "dimensions": [
        {
            "display": {
                "name": "Bick et al",
                "unit": "hours per worker",
                "color": "#6e3e91",
                "shortUnit": "h",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 143569
        },
        {
            "display": {
                "name": "PWT",
                "unit": "hours per worker",
                "color": "#01847d",
                "shortUnit": "h",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 539739
        },
        {
            "display": {
                "name": "Huberman & Minns",
                "unit": "hours per worker",
                "color": "#3d4e67",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 143615
        },
        {
            "display": {
                "name": "OECD",
                "unit": "hours per worker",
                "color": "#b13609",
                "shortUnit": "h",
                "isProjection": false,
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 143616
        }
    ],
    "sourceDesc": "OECD (2020); Feenstra et al. (2015), PWT (2021); Bick et al. (2019); Huberman & Minns (2007)",
    "isPublished": true,
    "addCountryMode": "change-country",
    "baseColorScheme": "owid-distinct",
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/measure-working-hours",
            "text": "How are working hours measured?"
        }
    ],
    "selectedEntityNames": [
        "France"
    ],
    "selectedEntityColors": {
        "France": "#01847d"
    },
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2020-09-15 19:16:46 2024-04-08 12:13:54 2023-04-10 10:48:46 2020-12-10 22:08:47 52 48 1 Annual working hours per worker, various sources Comparison of various sources of annual working hours estimates. Note that not all sources publish data for every country. OECD data refers to average annual hours actually worked per worker; PWT data refers to average annual hours worked by persons engaged; Bick et al data refers to average annual hours worked per employed person; Huberman & Minns data refers to annual hours of full-time production workers (male and female) in non-agricultural activities Annual working hours per worker, various sources () 
{
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "map": {
        "projection": "World",
        "hideTimeline": false,
        "colorScale": {
            "baseColorScheme": "default",
            "equalSizeBins": true,
            "binningStrategy": "ckmeans",
            "customNumericColorsActive": false,
            "colorSchemeInvert": false,
            "binningStrategyBinCount": 5
        },
        "timeTolerance": 0,
        "toleranceStrategy": "closest",
        "tooltipUseCustomLabels": false,
        "time": "latest"
    },
    "maxTime": "latest",
    "baseColorScheme": "owid-distinct",
    "yAxis": {
        "removePointsOutsideDomain": false,
        "scaleType": "linear",
        "canChangeScaleType": false,
        "facetDomain": "shared"
    },
    "tab": "chart",
    "matchingEntitiesOnly": false,
    "hasChartTab": true,
    "hideLegend": false,
    "hideLogo": false,
    "hideTimeline": false,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "year",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 94,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "change-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": false,
    "stackMode": "absolute",
    "minTime": "earliest",
    "hideAnnotationFieldsInTitle": {
        "entity": false,
        "time": false,
        "changeInPrefix": false
    },
    "xAxis": {
        "removePointsOutsideDomain": false,
        "scaleType": "linear",
        "canChangeScaleType": false,
        "facetDomain": "shared"
    },
    "hideConnectedScatterLines": false,
    "showNoDataArea": true,
    "zoomToSelection": false,
    "showYearLabels": false,
    "hideLinesOutsideTolerance": false,
    "hideTotalValueLabel": false,
    "hideScatterLabels": false,
    "sortBy": "total",
    "sortOrder": "desc",
    "hideFacetControl": true,
    "entityTypePlural": "countries",
    "missingDataStrategy": "auto",
    "id": 4536,
    "note": "OECD data refers to average annual hours actually worked per worker; PWT data refers to average annual hours worked by persons engaged; Bick et al data refers to average annual hours worked per employed person; Huberman & Minns data refers to annual hours of full-time production workers (male and female) in non-agricultural activities",
    "slug": "compare-sources-working-hours",
    "title": "Annual working hours per worker, various sources",
    "subtitle": "Comparison of various sources of annual working hours estimates. Note that not all sources publish data for every country.",
    "originUrl": "https://ourworldindata.org/working-hours",
    "dimensions": [
        {
            "display": {
                "name": "Bick et al",
                "unit": "hours per worker",
                "color": "#6e3e91",
                "shortUnit": "h",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 143569
        },
        {
            "display": {
                "name": "PWT",
                "unit": "hours per worker",
                "color": "#01847d",
                "shortUnit": "h",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 539739
        },
        {
            "display": {
                "name": "Huberman & Minns",
                "unit": "hours per worker",
                "color": "#3d4e67",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 143615
        },
        {
            "display": {
                "name": "OECD",
                "unit": "hours per worker",
                "color": "#b13609",
                "shortUnit": "h",
                "isProjection": false,
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 143616
        }
    ],
    "sourceDesc": "OECD (2020); Feenstra et al. (2015), PWT (2021); Bick et al. (2019); Huberman & Minns (2007)",
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/measure-working-hours",
            "text": "How are working hours measured?"
        }
    ],
    "selectedEntityNames": [
        "France"
    ],
    "selectedEntityColors": {
        "France": "#01847d"
    }
}

Links from other tables