charts: 5564

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
5564 age-of-democracy-bmr LineChart 
{
    "id": 5564,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlGnBu",
            "binningStrategy": "manual",
            "customNumericColors": [
                "#edf8b1",
                null,
                "#41b6c4",
                "#225ea8",
                "#172976"
            ],
            "customNumericLabels": [
                "",
                null,
                null,
                null,
                null,
                null,
                null
            ],
            "customNumericValues": [
                18,
                30,
                60,
                90,
                2
            ],
            "customCategoryColors": {
                "No data": "#ffffff",
                "no data": "#ffffff",
                "non-democracy": "#c6a1a5",
                "closed autocracy": "#737373",
                "electoral autocracy": "#aaaaaa",
                "not an electoral democracy": "#aaaaaa"
            },
            "customCategoryLabels": {
                "no data": "No data",
                "non-democracy": "Non-democracy",
                "not an electoral democracy": "non-democracy"
            },
            "customNumericMinValue": 0,
            "customNumericColorsActive": true
        },
        "columnSlug": "830996",
        "tooltipUseCustomLabels": true
    },
    "tab": "map",
    "slug": "age-of-democracy-bmr",
    "title": "Age of democracy",
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 52,
    "subtitle": "Based on the [classification](#dod:democracy-boix-miller-rosato) and estimates by Boix et al. (2013). Democracies are understood here as political systems in which political leaders are elected under broad rights for men to vote in free and fair elections.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/democracy",
    "dimensions": [
        {
            "display": {
                "shortUnit": "years",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 830996
        }
    ],
    "hasChartTab": false,
    "isPublished": true,
    "variantName": "Boix et al.",
    "timelineMaxTime": 2020,
    "timelineMinTime": 1800,
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/explorers/democracy",
            "text": "How do different approaches score democracy across the world?"
        }
    ],
    "selectedEntityNames": [
        "Iraq",
        "Hesse-Darmstadt",
        "South Africa"
    ]
}
 2022-02-15 12:30:53 2024-04-11 18:32:14 2024-04-11 18:32:14 2022-02-17 13:13:54 51 51 1 Age of democracy Based on the [classification](#dod:democracy-boix-miller-rosato) and estimates by Boix et al. (2013). Democracies are understood here as political systems in which political leaders are elected under broad rights for men to vote in free and fair elections.   Age of democracy (Boix et al.) 
{
    "$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": false,
    "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": 52,
    "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": 5564,
    "slug": "age-of-democracy-bmr",
    "title": "Age of democracy",
    "subtitle": "Based on the [classification](#dod:democracy-boix-miller-rosato) and estimates by Boix et al. (2013). Democracies are understood here as political systems in which political leaders are elected under broad rights for men to vote in free and fair elections.",
    "originUrl": "https://ourworldindata.org/democracy",
    "dimensions": [
        {
            "display": {
                "shortUnit": "years",
                "includeInTable": true,
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 830996
        }
    ],
    "variantName": "Boix et al.",
    "timelineMaxTime": 2020,
    "timelineMinTime": 1800,
    "relatedQuestions": [
        {
            "url": "https://ourworldindata.org/explorers/democracy",
            "text": "How do different approaches score democracy across the world?"
        }
    ],
    "selectedEntityNames": [
        "Iraq",
        "Hesse-Darmstadt",
        "South Africa"
    ]
}

Links from other tables