charts: 5075

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
5075 land-sparing-by-crop StackedDiscreteBar 
{
    "id": 5075,
    "note": "Land spared = [Area that would have been needed without yield improvements] - [Actual cropland area in a given year].",
    "slug": "land-sparing-by-crop",
    "type": "StackedDiscreteBar",
    "title": "How much cropland has the world spared due to increases in crop yields?",
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 6,
    "subtitle": "Land sparing is calculated as the amount of additional land that would have been needed to meet crop production if global average crop yields had not increased since 1961.",
    "originUrl": "ourworldindata.org/crop-yields",
    "dimensions": [
        {
            "display": {
                "name": "Actual cropland area used",
                "unit": "hectares",
                "color": "#578145"
            },
            "property": "y",
            "variableId": 848419
        },
        {
            "display": {
                "name": "Land spared due to crop yield improvements since 1961",
                "color": "#8a6046"
            },
            "property": "y",
            "variableId": 848463
        }
    ],
    "isPublished": true,
    "addCountryMode": "disabled",
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "All crops",
        "Cereals",
        "Pulses",
        "Fruit",
        "Vegetables",
        "Roots and tubers",
        "Sugar crops"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2021-07-07 05:39:04 2024-04-08 12:13:54 2024-03-26 13:13:23 2021-07-07 05:39:04 58 14 1 How much cropland has the world spared due to increases in crop yields? Land sparing is calculated as the amount of additional land that would have been needed to meet crop production if global average crop yields had not increased since 1961. Land spared = [Area that would have been needed without yield improvements] - [Actual cropland area in a given year]. How much cropland has the world spared due to increases in crop yields? () 
{
    "$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": 6,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "disabled",
    "compareEndPointsOnly": false,
    "type": "StackedDiscreteBar",
    "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": 5075,
    "note": "Land spared = [Area that would have been needed without yield improvements] - [Actual cropland area in a given year].",
    "slug": "land-sparing-by-crop",
    "title": "How much cropland has the world spared due to increases in crop yields?",
    "subtitle": "Land sparing is calculated as the amount of additional land that would have been needed to meet crop production if global average crop yields had not increased since 1961.",
    "originUrl": "ourworldindata.org/crop-yields",
    "dimensions": [
        {
            "display": {
                "name": "Actual cropland area used",
                "unit": "hectares",
                "color": "#578145"
            },
            "property": "y",
            "variableId": 848419
        },
        {
            "display": {
                "name": "Land spared due to crop yield improvements since 1961",
                "color": "#8a6046"
            },
            "property": "y",
            "variableId": 848463
        }
    ],
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "All crops",
        "Cereals",
        "Pulses",
        "Fruit",
        "Vegetables",
        "Roots and tubers",
        "Sugar crops"
    ]
}

Links from other tables