charts: 779

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
779 share-of-the-labor-force-employed-in-agriculture LineChart 
{
    "id": 779,
    "map": {
        "colorScale": {
            "baseColorScheme": "PuBuGn",
            "binningStrategy": "manual",
            "colorSchemeInvert": false,
            "legendDescription": "Share employed in agriculture (in %)",
            "customNumericColors": [
                null,
                null
            ],
            "customNumericLabels": [
                "",
                "",
                "",
                "",
                "",
                "",
                "",
                "",
                "",
                ""
            ],
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80,
                90,
                100
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "148031",
        "timeTolerance": 5
    },
    "tab": "map",
    "slug": "share-of-the-labor-force-employed-in-agriculture",
    "title": "Share of the labor force employed in agriculture",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": 1991,
    "version": 12,
    "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": {
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 312261
        }
    ],
    "isPublished": true,
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/agri-employment-sources",
            "text": "Employment in agriculture: Our data sources and definition"
        }
    ],
    "selectedEntityNames": [
        "Colombia",
        "China",
        "Jamaica",
        "Italy",
        "Poland",
        "France",
        "Netherlands"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2017-07-21 23:39:49 2024-04-08 12:13:54 2024-03-04 14:23:12 2017-07-21 23:39:49 46   1 Share of the labor force 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.   Share of the labor force 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": "map",
    "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": 12,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "stackMode": "absolute",
    "minTime": 1991,
    "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": 779,
    "slug": "share-of-the-labor-force-employed-in-agriculture",
    "title": "Share of the labor force 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": {
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 312261
        }
    ],
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/agri-employment-sources",
            "text": "Employment in agriculture: Our data sources and definition"
        }
    ],
    "selectedEntityNames": [
        "Colombia",
        "China",
        "Jamaica",
        "Italy",
        "Poland",
        "France",
        "Netherlands"
    ]
}

Links from other tables