charts: 245

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
245 productivity-vs-annual-hours-worked ScatterPlot 
{
    "id": 245,
    "map": {
        "time": 1980,
        "colorScale": {
            "baseColorScheme": "BuGn",
            "binningStrategy": "equalInterval",
            "legendDescription": "",
            "customNumericMinValue": 0
        },
        "timeTolerance": 1
    },
    "slug": "productivity-vs-annual-hours-worked",
    "type": "ScatterPlot",
    "title": "Annual working hours vs. labor productivity",
    "xAxis": {
        "min": 0,
        "canChangeScaleType": true
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 43,
    "subtitle": "Labor productivity is measured as GDP per hour of work. GDP is adjusted for inflation and for differences in the cost of living between countries.",
    "originUrl": "https://ourworldindata.org/working-hours",
    "colorScale": {
        "binningStrategy": "equalInterval"
    },
    "dimensions": [
        {
            "display": {
                "name": "Annual working hours per worker",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 539739
        },
        {
            "property": "x",
            "variableId": 539764
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "hideLegend": true,
    "sourceDesc": "Feenstra et al. (2015), Penn World Table (2021)",
    "isPublished": true,
    "excludedEntities": [
        2
    ],
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/rich-poor-working-hours",
            "text": "Do workers in richer countries work longer hours?"
        }
    ],
    "hideRelativeToggle": false
}
 2016-05-27 23:14:04 2024-07-17 09:43:46 2024-07-17 09:43:46 2016-05-27 23:14:04 58   1 Annual working hours vs. labor productivity Labor productivity is measured as GDP per hour of work. GDP is adjusted for inflation and for differences in the cost of living between countries.   Annual working hours vs. labor productivity () 
{
    "$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": true,
    "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": 43,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "ScatterPlot",
    "hasMapTab": false,
    "stackMode": "absolute",
    "minTime": "latest",
    "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": 245,
    "slug": "productivity-vs-annual-hours-worked",
    "title": "Annual working hours vs. labor productivity",
    "subtitle": "Labor productivity is measured as GDP per hour of work. GDP is adjusted for inflation and for differences in the cost of living between countries.",
    "originUrl": "https://ourworldindata.org/working-hours",
    "dimensions": [
        {
            "display": {
                "name": "Annual working hours per worker",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 539739
        },
        {
            "property": "x",
            "variableId": 539764
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "sourceDesc": "Feenstra et al. (2015), Penn World Table (2021)",
    "excludedEntities": [
        2
    ],
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/rich-poor-working-hours",
            "text": "Do workers in richer countries work longer hours?"
        }
    ],
    "hideRelativeToggle": false
}

Links from other tables