charts: 2984

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
2984 urban-land-area LineChart 
{
    "id": 2984,
    "map": {
        "colorScale": {
            "baseColorScheme": "GnBu",
            "binningStrategy": "manual",
            "customNumericValues": [
                5000,
                10000,
                50000,
                100000,
                250000,
                500000
            ]
        },
        "columnSlug": "734993"
    },
    "tab": "map",
    "slug": "urban-land-area",
    "title": "Urban land area",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 10,
    "subtitle": "Urban land area in square kilometers (km\u00b2), based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights. Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/urbanization",
    "dimensions": [
        {
            "display": {
                "unit": "square kilometres",
                "shortUnit": "km\u00b2",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 904837
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "United States",
        "United Kingdom",
        "India",
        "Nigeria",
        "China"
    ]
}
 2018-08-22 12:54:15 2024-05-31 07:03:51 2024-05-31 07:03:51 2018-08-22 12:54:15 59 14 1 Urban land area Urban land area in square kilometers (km²), based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights. Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons.   Urban land area () 
{
    "$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": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 10,
    "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": 2984,
    "slug": "urban-land-area",
    "title": "Urban land area",
    "subtitle": "Urban land area in square kilometers (km\u00b2), based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights. Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons.",
    "originUrl": "ourworldindata.org/urbanization",
    "dimensions": [
        {
            "display": {
                "unit": "square kilometres",
                "shortUnit": "km\u00b2",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 904837
        }
    ],
    "selectedEntityNames": [
        "United States",
        "United Kingdom",
        "India",
        "Nigeria",
        "China"
    ]
}

Links from other tables