charts: 2981

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
2981 countries-with-minimum-urban-threshold StackedDiscreteBar 
{
    "id": 2981,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval"
        }
    },
    "note": "Some countries with minimum inhabitant thresholds noted here also require additional qualities (such as population density) to be met.",
    "slug": "countries-with-minimum-urban-threshold",
    "type": "StackedDiscreteBar",
    "title": "Number of countries with a given minimum urban population threshold",
    "yAxis": {
        "min": 0
    },
    "sortBy": "custom",
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 6,
    "subtitle": "The number of countries that have adopted a given minimum population threshold (number of inhabitants) for classification of an 'urban area'.",
    "originUrl": "https://ourworldindata.org/urbanization",
    "sortOrder": "desc",
    "dimensions": [
        {
            "property": "y",
            "variableId": 820000
        }
    ],
    "entityType": "threshold",
    "hideLegend": true,
    "isPublished": true,
    "hideTimeline": true,
    "selectedEntityNames": [
        "No minimum population threshold",
        "150 inhabitants",
        "200 inhabitants",
        "300 inhabitants",
        "400 inhabitants",
        "500 inhabitants",
        "600 inhabitants",
        "1,000 inhabitants",
        "1,500 inhabitants",
        "2,500 inhabitants",
        "2,000 inhabitants",
        "3,000 inhabitants",
        "4,000 inhabitants",
        "5,000 inhabitants",
        "9,000 inhabitants",
        "10,000 inhabitants",
        "20,000 inhabitants",
        "30,000 inhabitants",
        "50,000 inhabitants",
        "100,000 inhabitants"
    ],
    "hideAnnotationFieldsInTitle": {}
}
 2018-08-21 14:20:11 2024-04-08 12:13:54 2024-02-12 16:28:09 2018-08-21 14:20:11 72 14 1 Number of countries with a given minimum urban population threshold The number of countries that have adopted a given minimum population threshold (number of inhabitants) for classification of an 'urban area'. Some countries with minimum inhabitant thresholds noted here also require additional qualities (such as population density) to be met. Number of countries with a given minimum urban population threshold () 
{
    "$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": true,
    "hideLogo": false,
    "hideTimeline": true,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "year",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 6,
    "logo": "owid",
    "entityType": "threshold",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "StackedDiscreteBar",
    "hasMapTab": false,
    "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": "custom",
    "sortOrder": "desc",
    "hideFacetControl": true,
    "entityTypePlural": "countries",
    "missingDataStrategy": "auto",
    "id": 2981,
    "note": "Some countries with minimum inhabitant thresholds noted here also require additional qualities (such as population density) to be met.",
    "slug": "countries-with-minimum-urban-threshold",
    "title": "Number of countries with a given minimum urban population threshold",
    "subtitle": "The number of countries that have adopted a given minimum population threshold (number of inhabitants) for classification of an 'urban area'.",
    "originUrl": "https://ourworldindata.org/urbanization",
    "dimensions": [
        {
            "property": "y",
            "variableId": 820000
        }
    ],
    "selectedEntityNames": [
        "No minimum population threshold",
        "150 inhabitants",
        "200 inhabitants",
        "300 inhabitants",
        "400 inhabitants",
        "500 inhabitants",
        "600 inhabitants",
        "1,000 inhabitants",
        "1,500 inhabitants",
        "2,500 inhabitants",
        "2,000 inhabitants",
        "3,000 inhabitants",
        "4,000 inhabitants",
        "5,000 inhabitants",
        "9,000 inhabitants",
        "10,000 inhabitants",
        "20,000 inhabitants",
        "30,000 inhabitants",
        "50,000 inhabitants",
        "100,000 inhabitants"
    ]
}

Links from other tables