charts: 2638

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
2638 average-hours-worked-per-person-employed LineChart 
{
    "id": 2638,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval",
            "customNumericColors": [],
            "customNumericLabels": [],
            "customNumericValues": [],
            "customCategoryColors": {},
            "customCategoryLabels": {},
            "customHiddenCategories": {}
        },
        "projection": "World"
    },
    "tab": "chart",
    "slug": "average-hours-worked-per-person-employed",
    "type": "LineChart",
    "title": "Average hours worked per person employed",
    "xAxis": {
        "scaleType": "linear"
    },
    "yAxis": {
        "max": 3000,
        "min": 0,
        "scaleType": "linear"
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 1,
    "subtitle": "Figure illustrates the average hours worked per person in employment. Hours reflect regular hours worked by full-time and part-time workers, paid and unpaid overtime, hours worked in additional jobs, and time not worked because of public holidays, annual paid leave, strikes and labour disputes and other reasons.",
    "hasMapTab": false,
    "originUrl": "ourworldindata.org/working-hours",
    "stackMode": "absolute",
    "dimensions": [
        {
            "display": {
                "name": "Average hours worked per person employed",
                "unit": "hours",
                "shortUnit": "hours",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 87175
        }
    ],
    "hasChartTab": true,
    "isPublished": true,
    "addCountryMode": "add-country",
    "hideRelativeToggle": true,
    "selectedEntityNames": [
        "Australia",
        "Korea",
        "Italy",
        "Germany",
        "France",
        "United Kingdom",
        "United States",
        "Japan",
        "Netherlands",
        "Norway",
        "South Africa",
        "Canada",
        "Iceland",
        "Sweden"
    ]
}
 2018-04-24 13:40:26 2024-04-08 12:13:54 2018-04-24 13:40:26 2018-04-24 13:40:26 19 19 1 Average hours worked per person employed Figure illustrates the average hours worked per person in employment. Hours reflect regular hours worked by full-time and part-time workers, paid and unpaid overtime, hours worked in additional jobs, and time not worked because of public holidays, annual paid leave, strikes and labour disputes and other reasons.   Average hours worked per person employed () 
{
    "$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": "default",
    "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": 1,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-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": 2638,
    "slug": "average-hours-worked-per-person-employed",
    "title": "Average hours worked per person employed",
    "subtitle": "Figure illustrates the average hours worked per person in employment. Hours reflect regular hours worked by full-time and part-time workers, paid and unpaid overtime, hours worked in additional jobs, and time not worked because of public holidays, annual paid leave, strikes and labour disputes and other reasons.",
    "originUrl": "ourworldindata.org/working-hours",
    "dimensions": [
        {
            "display": {
                "name": "Average hours worked per person employed",
                "unit": "hours",
                "shortUnit": "hours",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 87175
        }
    ],
    "hideRelativeToggle": true,
    "selectedEntityNames": [
        "Australia",
        "Korea",
        "Italy",
        "Germany",
        "France",
        "United Kingdom",
        "United States",
        "Japan",
        "Netherlands",
        "Norway",
        "South Africa",
        "Canada",
        "Iceland",
        "Sweden"
    ]
}

Links from other tables