charts: 5584

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
5584 agriculture-more-less-land LineChart 
{
    "id": 5584,
    "map": {
        "colorScale": {
            "baseColorScheme": "RdBu",
            "binningStrategy": "manual",
            "colorSchemeInvert": true,
            "customNumericColors": [
                null,
                null,
                "#286bbb",
                null,
                null,
                null
            ],
            "customNumericValues": [
                -10,
                -5,
                0,
                5,
                10,
                30
            ],
            "customCategoryLabels": {
                "TRUE": "Uses less land than in 2010",
                "FALSE": "Uses more or same land as in 2010",
                "Uses less land": "Less land",
                "Uses more land": "More land",
                "Uses same land": "Same amount of land"
            }
        },
        "columnSlug": "347547",
        "hideTimeline": true
    },
    "tab": "map",
    "slug": "agriculture-more-less-land",
    "title": "Is agricultural land expanding? Change over the prior decade",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 11,
    "subtitle": "Agricultural land area is compared to its area 10 years before. Positive values (shown in red) indicate an expansion of agriculture. Negative values (in blue) show a decline. Agricultural land is the sum of croplands and pasture used for livestock grazing.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/land-use",
    "dimensions": [
        {
            "property": "y",
            "variableId": 848410
        }
    ],
    "hasChartTab": false,
    "isPublished": true,
    "selectedEntityNames": [
        "North America",
        "Nepal",
        "Kuwait",
        "Cote d'Ivoire"
    ]
}
 2022-02-20 12:26:03 2024-04-08 12:13:54 2024-03-26 13:10:13 2022-02-20 12:59:23 58 14 1 Is agricultural land expanding? Change over the prior decade Agricultural land area is compared to its area 10 years before. Positive values (shown in red) indicate an expansion of agriculture. Negative values (in blue) show a decline. Agricultural land is the sum of croplands and pasture used for livestock grazing.   Is agricultural land expanding? Change over the prior decade () 
{
    "$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": false,
    "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": 11,
    "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": 5584,
    "slug": "agriculture-more-less-land",
    "title": "Is agricultural land expanding? Change over the prior decade",
    "subtitle": "Agricultural land area is compared to its area 10 years before. Positive values (shown in red) indicate an expansion of agriculture. Negative values (in blue) show a decline. Agricultural land is the sum of croplands and pasture used for livestock grazing.",
    "originUrl": "https://ourworldindata.org/land-use",
    "dimensions": [
        {
            "property": "y",
            "variableId": 848410
        }
    ],
    "selectedEntityNames": [
        "North America",
        "Nepal",
        "Kuwait",
        "Cote d'Ivoire"
    ]
}

Links from other tables