charts: 1234

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
1234 children-in-employment-ages-7-14-vs-weekly-hours-worked-by-children-ages-7-14 ScatterPlot 
{
    "id": 1234,
    "map": {
        "time": 2016,
        "colorScale": {
            "binningStrategy": "equalInterval"
        }
    },
    "slug": "children-in-employment-ages-7-14-vs-weekly-hours-worked-by-children-ages-7-14",
    "type": "ScatterPlot",
    "title": "Children in employment vs. hours worked by children",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 20,
    "subtitle": "The horizontal axis shows the share of children ages 7-14 who are involved in an economic activity for at least one hour in the reference week of the corresponding survey. The vertical axis shows the average weekly working hours among these economically active children. Colors represent world regions. Bubble sizes are proportional to the population of the country.",
    "originUrl": "https://ourworldindata.org/child-labor/",
    "colorScale": {
        "binningStrategy": "equalInterval"
    },
    "dimensions": [
        {
            "display": {
                "name": "Average working hours of children who work",
                "tolerance": 5
            },
            "property": "y",
            "variableId": 905994
        },
        {
            "display": {
                "name": "Share of children in employment",
                "tolerance": 5
            },
            "property": "x",
            "variableId": 906002
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "sourceDesc": "International Labour Organization; UNICEF; World Bank",
    "isPublished": true,
    "hideRelativeToggle": false
}
 2017-09-27 14:14:22 2024-07-17 09:51:00 2024-07-17 09:51:00 2017-09-27 14:14:22 58   1 Children in employment vs. hours worked by children The horizontal axis shows the share of children ages 7-14 who are involved in an economic activity for at least one hour in the reference week of the corresponding survey. The vertical axis shows the average weekly working hours among these economically active children. Colors represent world regions. Bubble sizes are proportional to the population of the country.   Children in employment vs. hours worked by children () 
{
    "$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": 20,
    "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": 1234,
    "slug": "children-in-employment-ages-7-14-vs-weekly-hours-worked-by-children-ages-7-14",
    "title": "Children in employment vs. hours worked by children",
    "subtitle": "The horizontal axis shows the share of children ages 7-14 who are involved in an economic activity for at least one hour in the reference week of the corresponding survey. The vertical axis shows the average weekly working hours among these economically active children. Colors represent world regions. Bubble sizes are proportional to the population of the country.",
    "originUrl": "https://ourworldindata.org/child-labor/",
    "dimensions": [
        {
            "display": {
                "name": "Average working hours of children who work",
                "tolerance": 5
            },
            "property": "y",
            "variableId": 905994
        },
        {
            "display": {
                "name": "Share of children in employment",
                "tolerance": 5
            },
            "property": "x",
            "variableId": 906002
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "sourceDesc": "International Labour Organization; UNICEF; World Bank",
    "hideRelativeToggle": false
}

Links from other tables