charts: 1027

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
1027 cereal-distribution-to-uses StackedArea 
{
    "id": 1027,
    "map": {
        "time": 1980,
        "colorScale": {
            "baseColorScheme": "BuGn",
            "binningStrategy": "equalInterval",
            "legendDescription": "",
            "customNumericMinValue": 0
        },
        "columnSlug": "37324",
        "timeTolerance": 1
    },
    "note": "The FAO apply a methodological change from the year 2010 onwards.",
    "slug": "cereal-distribution-to-uses",
    "type": "StackedArea",
    "title": "Cereals allocated to food, animal feed and fuel",
    "yAxis": {
        "min": 0,
        "facetDomain": "independent"
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 17,
    "subtitle": "Cereal crops allocated to direct human consumption, used for animal feed, and other uses \u2013 mainly industrial uses such as biofuel production. This is based on domestic supply quantity for countries after correction for imports, exports and stocks.",
    "originUrl": "https://ourworldindata.org/land-use-diets",
    "dimensions": [
        {
            "display": {
                "name": "Industrial uses (often fuel)",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 848425
        },
        {
            "display": {
                "name": "Animal feed",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 848423
        },
        {
            "display": {
                "name": "Human food",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 848424
        }
    ],
    "isPublished": true,
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "World"
    ],
    "selectedEntityColors": {
        "World": "#3360a9"
    },
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2017-08-29 16:02:35 2024-04-08 12:13:54 2024-03-26 13:38:41 2017-08-29 16:02:35 58   1 Cereals allocated to food, animal feed and fuel Cereal crops allocated to direct human consumption, used for animal feed, and other uses – mainly industrial uses such as biofuel production. This is based on domestic supply quantity for countries after correction for imports, exports and stocks. The FAO apply a methodological change from the year 2010 onwards. Cereals allocated to food, animal feed and fuel () 
{
    "$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": 17,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "StackedArea",
    "hasMapTab": false,
    "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": 1027,
    "note": "The FAO apply a methodological change from the year 2010 onwards.",
    "slug": "cereal-distribution-to-uses",
    "title": "Cereals allocated to food, animal feed and fuel",
    "subtitle": "Cereal crops allocated to direct human consumption, used for animal feed, and other uses \u2013 mainly industrial uses such as biofuel production. This is based on domestic supply quantity for countries after correction for imports, exports and stocks.",
    "originUrl": "https://ourworldindata.org/land-use-diets",
    "dimensions": [
        {
            "display": {
                "name": "Industrial uses (often fuel)",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 848425
        },
        {
            "display": {
                "name": "Animal feed",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 848423
        },
        {
            "display": {
                "name": "Human food",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 848424
        }
    ],
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "World"
    ],
    "selectedEntityColors": {
        "World": "#3360a9"
    }
}

Links from other tables