charts: 926

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
926 gdp-vs-agriculture-employment ScatterPlot 
{
    "id": 926,
    "map": {
        "time": 2021,
        "colorScale": {
            "baseColorScheme": "BuGn",
            "binningStrategy": "equalInterval",
            "legendDescription": ""
        },
        "columnSlug": "525711",
        "timeTolerance": 1
    },
    "note": "GDP per capita is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices.",
    "slug": "gdp-vs-agriculture-employment",
    "type": "ScatterPlot",
    "title": "Share of workers employed in agriculture vs. GDP per capita",
    "xAxis": {
        "scaleType": "log",
        "canChangeScaleType": true
    },
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 25,
    "subtitle": "Agriculture includes the cultivation of crops and livestock production, as well as forestry, hunting, and fishing. GDP per capita is adjusted for inflation and differences in the cost of living between countries.",
    "originUrl": "https://ourworldindata.org/employment-in-agriculture",
    "colorScale": {
        "binningStrategy": "equalInterval"
    },
    "dimensions": [
        {
            "display": {
                "name": "Share employed in agriculture"
            },
            "property": "y",
            "variableId": 312261
        },
        {
            "property": "x",
            "variableId": 900793
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "hideLegend": true,
    "isPublished": true,
    "hideRelativeToggle": false,
    "matchingEntitiesOnly": true
}
 2017-08-09 16:18:10 2024-07-17 09:50:27 2024-07-17 09:50:27 2017-08-09 16:18:10 58   1 Share of workers employed in agriculture vs. GDP per capita Agriculture includes the cultivation of crops and livestock production, as well as forestry, hunting, and fishing. GDP per capita is adjusted for inflation and differences in the cost of living between countries. GDP per capita is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices. Share of workers employed in agriculture vs. GDP per capita () 
{
    "$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": true,
    "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": 25,
    "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": 926,
    "note": "GDP per capita is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices.",
    "slug": "gdp-vs-agriculture-employment",
    "title": "Share of workers employed in agriculture vs. GDP per capita",
    "subtitle": "Agriculture includes the cultivation of crops and livestock production, as well as forestry, hunting, and fishing. GDP per capita is adjusted for inflation and differences in the cost of living between countries.",
    "originUrl": "https://ourworldindata.org/employment-in-agriculture",
    "dimensions": [
        {
            "display": {
                "name": "Share employed in agriculture"
            },
            "property": "y",
            "variableId": 312261
        },
        {
            "property": "x",
            "variableId": 900793
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "hideRelativeToggle": false
}

Links from other tables