charts: 5063

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
5063 yield-gap-vs-nitrogen-pollution DiscreteBar 
{
    "id": 5063,
    "map": {
        "colorScale": {
            "baseColorScheme": "RdYlBu",
            "binningStrategy": "manual",
            "colorSchemeInvert": true,
            "customNumericValues": [
                -100,
                -50,
                0,
                50,
                100,
                150,
                200
            ],
            "customNumericMinValue": -150,
            "binningStrategyBinCount": 6
        },
        "columnSlug": "699927"
    },
    "tab": "map",
    "slug": "yield-gap-vs-nitrogen-pollution",
    "type": "DiscreteBar",
    "title": "Which countries overapplied nitrogen without gains in crop yields?",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 8,
    "subtitle": "Shown is how much nitrogen pollution countries caused compared with how much they reduced their yield gaps relative to directly neighboring countries. Positive values (yellow to red) indicate a country overapplied nitrogen without gains in yield. This is based on yield gap and nitrogen data published between 2012 and 2015.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/fertilizers",
    "dimensions": [
        {
            "property": "y",
            "variableId": 852124
        }
    ],
    "isPublished": true,
    "hideTimeline": true,
    "selectedEntityNames": [
        "South Sudan",
        "Lebanon",
        "Kazakhstan",
        "Malawi",
        "Haiti",
        "El Salvador",
        "Burkina Faso",
        "Colombia"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2021-06-28 12:17:59 2024-04-08 12:13:54 2024-04-01 07:45:19 2021-06-28 12:17:59 58 14 1 Which countries overapplied nitrogen without gains in crop yields? Shown is how much nitrogen pollution countries caused compared with how much they reduced their yield gaps relative to directly neighboring countries. Positive values (yellow to red) indicate a country overapplied nitrogen without gains in yield. This is based on yield gap and nitrogen data published between 2012 and 2015.   Which countries overapplied nitrogen without gains 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": "map",
    "matchingEntitiesOnly": false,
    "hasChartTab": true,
    "hideLegend": false,
    "hideLogo": false,
    "hideTimeline": true,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "year",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 8,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "DiscreteBar",
    "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": 5063,
    "slug": "yield-gap-vs-nitrogen-pollution",
    "title": "Which countries overapplied nitrogen without gains in crop yields?",
    "subtitle": "Shown is how much nitrogen pollution countries caused compared with how much they reduced their yield gaps relative to directly neighboring countries. Positive values (yellow to red) indicate a country overapplied nitrogen without gains in yield. This is based on yield gap and nitrogen data published between 2012 and 2015.",
    "originUrl": "ourworldindata.org/fertilizers",
    "dimensions": [
        {
            "property": "y",
            "variableId": 852124
        }
    ],
    "selectedEntityNames": [
        "South Sudan",
        "Lebanon",
        "Kazakhstan",
        "Malawi",
        "Haiti",
        "El Salvador",
        "Burkina Faso",
        "Colombia"
    ]
}

Links from other tables