charts: 2603

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
2603 productivity-vs-educational-attainment ScatterPlot 
{
    "id": 2603,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval"
        }
    },
    "note": "Data for educational attainment for the years before 2015 are estimates, while data from 2015 onwards are projections.",
    "slug": "productivity-vs-educational-attainment",
    "type": "ScatterPlot",
    "title": "Productivity vs. educational attainment",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 26,
    "subtitle": "Figure illustrates educational attainment (average years of total education) versus productivity (GDP per hour worked).",
    "originUrl": "ourworldindata.org/economic-growth",
    "colorScale": {
        "binningStrategy": "equalInterval"
    },
    "dimensions": [
        {
            "display": {},
            "property": "y",
            "variableId": 539764
        },
        {
            "display": {
                "name": "Average years of education of 15-64 year old youth and adults",
                "tolerance": 5
            },
            "property": "x",
            "variableId": 809139
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "isPublished": true,
    "hideRelativeToggle": false
}
 2018-04-16 10:00:58 2024-07-17 09:53:00 2024-07-17 09:53:00 2018-04-16 10:00:58 58 19 1 Productivity vs. educational attainment Figure illustrates educational attainment (average years of total education) versus productivity (GDP per hour worked). Data for educational attainment for the years before 2015 are estimates, while data from 2015 onwards are projections. Productivity vs. educational attainment () 
{
    "$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": 26,
    "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": 2603,
    "note": "Data for educational attainment for the years before 2015 are estimates, while data from 2015 onwards are projections.",
    "slug": "productivity-vs-educational-attainment",
    "title": "Productivity vs. educational attainment",
    "subtitle": "Figure illustrates educational attainment (average years of total education) versus productivity (GDP per hour worked).",
    "originUrl": "ourworldindata.org/economic-growth",
    "dimensions": [
        {
            "display": {},
            "property": "y",
            "variableId": 539764
        },
        {
            "display": {
                "name": "Average years of education of 15-64 year old youth and adults",
                "tolerance": 5
            },
            "property": "x",
            "variableId": 809139
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "hideRelativeToggle": false
}

Links from other tables