charts: 4726

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
4726 soil-lifespans ScatterPlot 
{
    "id": 4726,
    "map": {
        "columnSlug": "145606"
    },
    "slug": "soil-lifespans",
    "type": "ScatterPlot",
    "title": "Distribution of soil lifespans",
    "xAxis": {
        "max": 10000000,
        "min": 5,
        "scaleType": "log",
        "canChangeScaleType": true,
        "removePointsOutsideDomain": true
    },
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": 1,
    "version": 6,
    "subtitle": "Soil lifespans are measured by on how many years it would take to erode 30 centimeters of topsoil based on current erosion rates. Data is based on a global assessment of soil erosion from 240 studies across 38 countries.",
    "originUrl": "ourworldindata.org/soil-lifespans",
    "dimensions": [
        {
            "display": {
                "name": "Cumulative percentage of soils",
                "unit": "%",
                "color": "#00823f",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 145606
        },
        {
            "display": {
                "unit": "years",
                "shortUnit": "years",
                "includeInTable": true
            },
            "property": "x",
            "variableId": 145607
        }
    ],
    "isPublished": true,
    "hideTimeline": true,
    "addCountryMode": "disabled",
    "timelineMinTime": 1,
    "selectedEntityNames": [
        "Bare soils",
        "Conservationally managed",
        "Conventionally managed"
    ],
    "selectedEntityColors": {
        "Bare soils": "#9a5129",
        "Conventionally managed": "#4c6a9c",
        "Conservationally managed": "#00823f"
    },
    "hideConnectedScatterLines": false,
    "scatterPointLabelStrategy": "y",
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2021-01-11 13:24:13 2024-04-08 12:13:54 2023-09-26 16:46:18 2021-01-11 13:24:13 70 14 1 Distribution of soil lifespans Soil lifespans are measured by on how many years it would take to erode 30 centimeters of topsoil based on current erosion rates. Data is based on a global assessment of soil erosion from 240 studies across 38 countries.   Distribution of soil lifespans () 
{
    "$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": true,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "y",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 6,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "disabled",
    "compareEndPointsOnly": false,
    "type": "ScatterPlot",
    "hasMapTab": false,
    "stackMode": "absolute",
    "minTime": 1,
    "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": 4726,
    "slug": "soil-lifespans",
    "title": "Distribution of soil lifespans",
    "subtitle": "Soil lifespans are measured by on how many years it would take to erode 30 centimeters of topsoil based on current erosion rates. Data is based on a global assessment of soil erosion from 240 studies across 38 countries.",
    "originUrl": "ourworldindata.org/soil-lifespans",
    "dimensions": [
        {
            "display": {
                "name": "Cumulative percentage of soils",
                "unit": "%",
                "color": "#00823f",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 145606
        },
        {
            "display": {
                "unit": "years",
                "shortUnit": "years",
                "includeInTable": true
            },
            "property": "x",
            "variableId": 145607
        }
    ],
    "timelineMinTime": 1,
    "selectedEntityNames": [
        "Bare soils",
        "Conservationally managed",
        "Conventionally managed"
    ],
    "selectedEntityColors": {
        "Bare soils": "#9a5129",
        "Conventionally managed": "#4c6a9c",
        "Conservationally managed": "#00823f"
    }
}

Links from other tables