charts: 3354

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
3354 sex-ratio-at-birth-vs-five-years-old ScatterPlot 
{
    "id": 3354,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval"
        }
    },
    "slug": "sex-ratio-at-birth-vs-five-years-old",
    "type": "ScatterPlot",
    "title": "Sex ratio at birth vs. at five years old",
    "xAxis": {
        "max": 118,
        "min": 100
    },
    "yAxis": {
        "max": 118,
        "min": 100
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 15,
    "subtitle": "Sex ratio at birth, measured as the number of male births per 100 female births versus the sex ratio at five years old, measured as the number of males per 100 females. The grey line represents the point of equal ratio: countries which lie above this line had a higher sex ratio at birth than at five years old.",
    "originUrl": "https://ourworldindata.org/gender-ratio",
    "colorScale": {
        "binningStrategy": "equalInterval"
    },
    "dimensions": [
        {
            "display": {
                "name": "Sex ratio at birth"
            },
            "property": "y",
            "variableId": 952780
        },
        {
            "display": {
                "name": "Sex ratio at age 5"
            },
            "property": "x",
            "variableId": 952840
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "isPublished": true,
    "comparisonLines": [
        {}
    ],
    "hideRelativeToggle": false
}
 2019-04-11 11:06:39 2024-07-12 03:27:04 2024-07-12 03:27:04 2019-04-11 11:06:39 74 14 1 Sex ratio at birth vs. at five years old Sex ratio at birth, measured as the number of male births per 100 female births versus the sex ratio at five years old, measured as the number of males per 100 females. The grey line represents the point of equal ratio: countries which lie above this line had a higher sex ratio at birth than at five years old.   Sex ratio at birth vs. at five years old () 
{
    "$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": 15,
    "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": 3354,
    "slug": "sex-ratio-at-birth-vs-five-years-old",
    "title": "Sex ratio at birth vs. at five years old",
    "subtitle": "Sex ratio at birth, measured as the number of male births per 100 female births versus the sex ratio at five years old, measured as the number of males per 100 females. The grey line represents the point of equal ratio: countries which lie above this line had a higher sex ratio at birth than at five years old.",
    "originUrl": "https://ourworldindata.org/gender-ratio",
    "dimensions": [
        {
            "display": {
                "name": "Sex ratio at birth"
            },
            "property": "y",
            "variableId": 952780
        },
        {
            "display": {
                "name": "Sex ratio at age 5"
            },
            "property": "x",
            "variableId": 952840
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "comparisonLines": [
        {}
    ],
    "hideRelativeToggle": false
}

Links from other tables