charts: 4677

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
4677 oil-yield-by-crop DiscreteBar 
{
    "id": 4677,
    "map": {},
    "note": "Based on oil production and area harvested data. Maximum yields can vary depending on the ratio of oil production to co-products (e.g. what fraction of soybeans or coconuts are used for oil production).",
    "slug": "oil-yield-by-crop",
    "type": "DiscreteBar",
    "title": "Oil yields by crop type",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 13,
    "subtitle": "Global oil yields are measured as the average amount of vegetable oil produced (in tonnes) per hectare of land. This is different from the total yield of the crop since only a fraction is available as vegetable oil.",
    "originUrl": "ourworldindata.org/crop-yields",
    "dimensions": [
        {
            "display": {
                "name": "Coconut oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848583
        },
        {
            "display": {
                "name": "Groundnut oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848589
        },
        {
            "display": {
                "name": "Palm oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848555
        },
        {
            "display": {
                "name": "Sesame oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848602
        },
        {
            "display": {
                "name": "Sunflower oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848561
        },
        {
            "display": {
                "name": "Cottonseed oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848596
        },
        {
            "display": {
                "name": "Olive oil",
                "unit": "tonnes per hectare",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848576
        },
        {
            "display": {
                "name": "Rapeseed oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848567
        },
        {
            "display": {
                "name": "Soybean oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848573
        }
    ],
    "isPublished": true,
    "hideTimeline": true,
    "addCountryMode": "change-country",
    "baseColorScheme": "SingleColorDarkCopper",
    "selectedEntityNames": [
        "World"
    ],
    "selectedEntityColors": {
        "Palm Oil": "#a64c5b",
        "Olive Oil": "#747676",
        "Coconut Oil": "#575c61",
        "Soybean Oil": "#5b8363",
        "Groundnut Oil": "#886959",
        "Cottonseed Oil": "#cebe9e",
        "Sesameseed Oil": "#876e7e",
        "Sunflowerseed Oil": "#da964a",
        "Rape and Mustard Oil": "#baae00"
    }
}
 2020-11-25 10:30:30 2024-04-08 12:13:54 2024-03-26 13:30:44 2020-11-25 10:30:30 58 14 1 Oil yields by crop type Global oil yields are measured as the average amount of vegetable oil produced (in tonnes) per hectare of land. This is different from the total yield of the crop since only a fraction is available as vegetable oil. Based on oil production and area harvested data. Maximum yields can vary depending on the ratio of oil production to co-products (e.g. what fraction of soybeans or coconuts are used for oil production). Oil yields by crop type () 
{
    "$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": "SingleColorDarkCopper",
    "yAxis": {
        "removePointsOutsideDomain": false,
        "scaleType": "linear",
        "canChangeScaleType": false,
        "facetDomain": "shared"
    },
    "tab": "chart",
    "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": 13,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "change-country",
    "compareEndPointsOnly": false,
    "type": "DiscreteBar",
    "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": 4677,
    "note": "Based on oil production and area harvested data. Maximum yields can vary depending on the ratio of oil production to co-products (e.g. what fraction of soybeans or coconuts are used for oil production).",
    "slug": "oil-yield-by-crop",
    "title": "Oil yields by crop type",
    "subtitle": "Global oil yields are measured as the average amount of vegetable oil produced (in tonnes) per hectare of land. This is different from the total yield of the crop since only a fraction is available as vegetable oil.",
    "originUrl": "ourworldindata.org/crop-yields",
    "dimensions": [
        {
            "display": {
                "name": "Coconut oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848583
        },
        {
            "display": {
                "name": "Groundnut oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848589
        },
        {
            "display": {
                "name": "Palm oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848555
        },
        {
            "display": {
                "name": "Sesame oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848602
        },
        {
            "display": {
                "name": "Sunflower oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848561
        },
        {
            "display": {
                "name": "Cottonseed oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848596
        },
        {
            "display": {
                "name": "Olive oil",
                "unit": "tonnes per hectare",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848576
        },
        {
            "display": {
                "name": "Rapeseed oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848567
        },
        {
            "display": {
                "name": "Soybean oil",
                "shortUnit": "t"
            },
            "property": "y",
            "variableId": 848573
        }
    ],
    "selectedEntityNames": [
        "World"
    ],
    "selectedEntityColors": {
        "Palm Oil": "#a64c5b",
        "Olive Oil": "#747676",
        "Coconut Oil": "#575c61",
        "Soybean Oil": "#5b8363",
        "Groundnut Oil": "#886959",
        "Cottonseed Oil": "#cebe9e",
        "Sesameseed Oil": "#876e7e",
        "Sunflowerseed Oil": "#da964a",
        "Rape and Mustard Oil": "#baae00"
    }
}

Links from other tables