charts: 3437

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
3437 increase-male-vs-female-height ScatterPlot 
{
    "id": 3437,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval",
            "customNumericColors": [],
            "customNumericLabels": [],
            "customNumericValues": [],
            "customCategoryColors": {},
            "customCategoryLabels": {},
            "customHiddenCategories": {}
        },
        "projection": "World"
    },
    "tab": "chart",
    "slug": "increase-male-vs-female-height",
    "type": "ScatterPlot",
    "title": "Percentage increase in mean male vs. female height over a century",
    "xAxis": {
        "max": 15,
        "min": 0,
        "scaleType": "linear"
    },
    "yAxis": {
        "max": 15,
        "min": 0,
        "scaleType": "linear"
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "maxTime": "latest",
    "minTime": "latest",
    "version": 3,
    "subtitle": "The relative increase in mean male versus mean female height for people born in 1996 versus 1896. This therefore represents the difference in the mean height of adults who reached the age of 18 in 2014 versus 1914.",
    "hasMapTab": false,
    "originUrl": "https://ourworldindata.org/human-height",
    "stackMode": "absolute",
    "colorScale": {
        "binningStrategy": "equalInterval",
        "customNumericColors": [],
        "customNumericLabels": [],
        "customNumericValues": [],
        "customCategoryColors": {},
        "customCategoryLabels": {},
        "customHiddenCategories": {}
    },
    "dimensions": [
        {
            "display": {
                "name": "Increase in mean male height (%)"
            },
            "property": "y",
            "variableId": 104391
        },
        {
            "display": {
                "name": "Increase in mean female height (%)"
            },
            "property": "x",
            "variableId": 104392
        },
        {
            "display": {},
            "property": "color",
            "variableId": 123
        }
    ],
    "hasChartTab": true,
    "isPublished": true,
    "comparisonLines": [
        {}
    ],
    "hideRelativeToggle": false,
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2019-05-16 13:48:00 2024-04-08 12:13:54 2019-05-16 13:56:46 2019-05-16 13:48:00 14 14 1 Percentage increase in mean male vs. female height over a century The relative increase in mean male versus mean female height for people born in 1996 versus 1896. This therefore represents the difference in the mean height of adults who reached the age of 18 in 2014 versus 1914.   Percentage increase in mean male vs. female height over a century () 
{
    "$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": 3,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "ScatterPlot",
    "hasMapTab": false,
    "stackMode": "absolute",
    "minTime": "latest",
    "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": 3437,
    "slug": "increase-male-vs-female-height",
    "title": "Percentage increase in mean male vs. female height over a century",
    "subtitle": "The relative increase in mean male versus mean female height for people born in 1996 versus 1896. This therefore represents the difference in the mean height of adults who reached the age of 18 in 2014 versus 1914.",
    "originUrl": "https://ourworldindata.org/human-height",
    "dimensions": [
        {
            "display": {
                "name": "Increase in mean male height (%)"
            },
            "property": "y",
            "variableId": 104391
        },
        {
            "display": {
                "name": "Increase in mean female height (%)"
            },
            "property": "x",
            "variableId": 104392
        },
        {
            "display": {},
            "property": "color",
            "variableId": 123
        }
    ],
    "comparisonLines": [
        {}
    ],
    "hideRelativeToggle": false
}

Links from other tables