charts: 5815

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
5815 stateness-index-bti LineChart 
{
    "id": 5815,
    "map": {
        "colorScale": {
            "baseColorScheme": "PuBu",
            "binningStrategy": "manual",
            "customNumericColors": [
                "#8a148c",
                "#d979d2",
                "#1ac6d9"
            ],
            "customNumericLabels": [
                "Poor",
                "Flawed",
                "Fair",
                "Sound",
                "Excellent",
                "",
                "",
                "",
                "",
                ""
            ],
            "customNumericValues": [
                2.5,
                4.5,
                6.5,
                8.5,
                10
            ],
            "customCategoryLabels": {
                "No data": "No data"
            },
            "customNumericMinValue": 1
        },
        "columnSlug": "164988",
        "tooltipUseCustomLabels": true
    },
    "tab": "map",
    "slug": "stateness-index-bti",
    "title": "Stateness index",
    "yAxis": {
        "max": 10,
        "min": 1
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 90,
    "subtitle": "Based on the expert estimates and index by the [Bertelsmann Transformation Index (2024)](#dod:bertelsmann-transformation-index). It combines information on the extent to which the state has the monopoly on the use of force, provides basic public services across the country, citizens accept the state as legitimate, religious dogmas do not interfere, and citizenship is accessible. It ranges from 1 to 10 (high stateness).",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/democracy",
    "colorScale": {
        "legendDescription": ""
    },
    "dimensions": [
        {
            "display": {
                "shortUnit": "",
                "includeInTable": true,
                "numDecimalPlaces": 1
            },
            "property": "y",
            "variableId": 902087
        }
    ],
    "isPublished": true,
    "variantName": "BTI",
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/explorers/democracy",
            "text": "How do different approaches score democracy across the world?"
        }
    ],
    "selectedEntityNames": [
        "Argentina",
        "Botswana",
        "China",
        "Czechia"
    ],
    "selectedFacetStrategy": "entity",
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2022-05-26 19:49:13 2024-05-21 22:26:11 2024-05-21 22:26:11 2022-05-26 19:52:39 52 51 1 Stateness index Based on the expert estimates and index by the [Bertelsmann Transformation Index (2024)](#dod:bertelsmann-transformation-index). It combines information on the extent to which the state has the monopoly on the use of force, provides basic public services across the country, citizens accept the state as legitimate, religious dogmas do not interfere, and citizenship is accessible. It ranges from 1 to 10 (high stateness).   Stateness index (BTI) 
{
    "$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": "map",
    "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": "entity",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 90,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "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": 5815,
    "slug": "stateness-index-bti",
    "title": "Stateness index",
    "subtitle": "Based on the expert estimates and index by the [Bertelsmann Transformation Index (2024)](#dod:bertelsmann-transformation-index). It combines information on the extent to which the state has the monopoly on the use of force, provides basic public services across the country, citizens accept the state as legitimate, religious dogmas do not interfere, and citizenship is accessible. It ranges from 1 to 10 (high stateness).",
    "originUrl": "ourworldindata.org/democracy",
    "dimensions": [
        {
            "display": {
                "shortUnit": "",
                "includeInTable": true,
                "numDecimalPlaces": 1
            },
            "property": "y",
            "variableId": 902087
        }
    ],
    "variantName": "BTI",
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/explorers/democracy",
            "text": "How do different approaches score democracy across the world?"
        }
    ],
    "selectedEntityNames": [
        "Argentina",
        "Botswana",
        "China",
        "Czechia"
    ]
}

Links from other tables