charts: 5023

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
5023 crop-allocation-farm-size StackedDiscreteBar 
{
    "id": 5023,
    "map": {
        "columnSlug": "146989"
    },
    "slug": "crop-allocation-farm-size",
    "type": "StackedDiscreteBar",
    "title": "Global allocation of crops to end uses by farm size",
    "yAxis": {
        "min": 0
    },
    "sortBy": "custom",
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 5,
    "subtitle": "Allocation of crops \u2013 measured as the aggregate across all major food groups in kilocalories \u2013 broken down by farm size. Farms are grouped based on their total agricultural area, in hectares.",
    "originUrl": "ourworldindata.org/farm-size",
    "sortOrder": "asc",
    "stackMode": "relative",
    "dimensions": [
        {
            "display": {
                "name": "Food",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146990
        },
        {
            "display": {
                "name": "Animal feed",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146989
        },
        {
            "display": {
                "name": "Other uses",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146991
        },
        {
            "display": {
                "name": "Processing",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146992
        },
        {
            "display": {
                "name": "Seed",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146993
        },
        {
            "display": {
                "name": "Waste",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146994
        }
    ],
    "isPublished": true,
    "addCountryMode": "disabled",
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "0 to 1 ha",
        "1 to 2 ha",
        "2 to 5 ha",
        "5 to 10 ha",
        "10 to 20 ha",
        "20 to 50 ha",
        "50 to 100 ha",
        "100 to 200 ha",
        "200 to 500 ha",
        "500 to 1000 ha",
        "> 1000 ha"
    ]
}
 2021-06-17 15:33:31 2024-04-08 12:13:54 2023-01-20 10:48:51 2021-06-17 15:33:31 52 14 1 Global allocation of crops to end uses by farm size Allocation of crops – measured as the aggregate across all major food groups in kilocalories – broken down by farm size. Farms are grouped based on their total agricultural area, in hectares.   Global allocation of crops to end uses by farm size () 
{
    "$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": 5,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "disabled",
    "compareEndPointsOnly": false,
    "type": "StackedDiscreteBar",
    "hasMapTab": false,
    "stackMode": "relative",
    "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": "custom",
    "sortOrder": "asc",
    "hideFacetControl": true,
    "entityTypePlural": "countries",
    "missingDataStrategy": "auto",
    "id": 5023,
    "slug": "crop-allocation-farm-size",
    "title": "Global allocation of crops to end uses by farm size",
    "subtitle": "Allocation of crops \u2013 measured as the aggregate across all major food groups in kilocalories \u2013 broken down by farm size. Farms are grouped based on their total agricultural area, in hectares.",
    "originUrl": "ourworldindata.org/farm-size",
    "dimensions": [
        {
            "display": {
                "name": "Food",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146990
        },
        {
            "display": {
                "name": "Animal feed",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146989
        },
        {
            "display": {
                "name": "Other uses",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146991
        },
        {
            "display": {
                "name": "Processing",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146992
        },
        {
            "display": {
                "name": "Seed",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146993
        },
        {
            "display": {
                "name": "Waste",
                "unit": "kilocalories",
                "shortUnit": "kcal",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 146994
        }
    ],
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "0 to 1 ha",
        "1 to 2 ha",
        "2 to 5 ha",
        "5 to 10 ha",
        "10 to 20 ha",
        "20 to 50 ha",
        "50 to 100 ha",
        "100 to 200 ha",
        "200 to 500 ha",
        "500 to 1000 ha",
        "> 1000 ha"
    ]
}

Links from other tables