charts: 1058

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
1058 number-of-people-employed-in-agriculture LineChart 
{
    "id": 1058,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlGn",
            "binningStrategy": "manual",
            "colorSchemeInvert": false,
            "legendDescription": "",
            "customNumericColors": [
                null,
                null,
                null,
                null
            ],
            "customNumericValues": [
                100000,
                500000,
                1000000,
                5000000,
                10000000,
                50000000,
                100000000,
                500000000
            ],
            "binningStrategyBinCount": 6
        },
        "columnSlug": "1816",
        "timeTolerance": 1
    },
    "slug": "number-of-people-employed-in-agriculture",
    "title": "Number of people employed in agriculture",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 9,
    "subtitle": "Agriculture includes the cultivation of crops and livestock production, as well as forestry, hunting, and fishing. Employment includes anyone engaged in any activity to produce goods or services for pay or profit.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/employment-in-agriculture",
    "dimensions": [
        {
            "display": {
                "color": "#3360a9",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 312264
        }
    ],
    "isPublished": true,
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/agri-employment-sources",
            "text": "Employment in agriculture: Our data sources and definition"
        }
    ],
    "selectedEntityNames": [
        "France",
        "United States",
        "United Kingdom",
        "Belgium",
        "Sweden",
        "Japan",
        "South Korea",
        "Spain"
    ],
    "selectedEntityColors": {
        "Japan": "#a2559c",
        "Spain": "#cf0a66",
        "Sweden": "#4c6a9c",
        "United Kingdom": "#883039"
    }
}
 2017-09-01 12:42:22 2024-04-08 12:13:54 2022-12-02 10:52:09 2017-09-01 12:42:22 14   1 Number of people employed in agriculture Agriculture includes the cultivation of crops and livestock production, as well as forestry, hunting, and fishing. Employment includes anyone engaged in any activity to produce goods or services for pay or profit.   Number of people employed in agriculture () 
{
    "$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": 9,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "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": 1058,
    "slug": "number-of-people-employed-in-agriculture",
    "title": "Number of people employed in agriculture",
    "subtitle": "Agriculture includes the cultivation of crops and livestock production, as well as forestry, hunting, and fishing. Employment includes anyone engaged in any activity to produce goods or services for pay or profit.",
    "originUrl": "https://ourworldindata.org/employment-in-agriculture",
    "dimensions": [
        {
            "display": {
                "color": "#3360a9",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 312264
        }
    ],
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/agri-employment-sources",
            "text": "Employment in agriculture: Our data sources and definition"
        }
    ],
    "selectedEntityNames": [
        "France",
        "United States",
        "United Kingdom",
        "Belgium",
        "Sweden",
        "Japan",
        "South Korea",
        "Spain"
    ],
    "selectedEntityColors": {
        "Japan": "#a2559c",
        "Spain": "#cf0a66",
        "Sweden": "#4c6a9c",
        "United Kingdom": "#883039"
    }
}

Links from other tables