charts: 5069

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
5069 share-without-improved-water LineChart 
{
    "id": 5069,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlGnBu",
            "binningStrategy": "manual",
            "colorSchemeInvert": true,
            "customNumericColors": [
                null,
                null,
                null,
                null,
                null,
                null,
                null
            ],
            "customNumericValues": [
                5,
                10,
                15,
                20,
                25,
                30,
                35,
                40,
                45
            ],
            "customNumericMinValue": 0,
            "binningStrategyBinCount": 9
        },
        "columnSlug": "820220",
        "timeTolerance": 5
    },
    "tab": "map",
    "slug": "share-without-improved-water",
    "title": "Share of the population not using an improved water source",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 9,
    "subtitle": "Improved drinking water sources are those that can deliver safe water. They include piped water, boreholes or tube wells, protected dug wells, protected springs, rainwater, and packaged or delivered water.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/water-access",
    "dimensions": [
        {
            "display": {
                "unit": "%",
                "shortUnit": "%"
            },
            "property": "y",
            "variableId": 820220
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "China",
        "India",
        "Pakistan",
        "Niger",
        "Kenya",
        "Peru",
        "Madagascar"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2021-07-01 14:23:15 2024-04-08 12:13:54 2024-02-10 19:29:04 2021-07-01 14:23:15 54 14 1 Share of the population not using an improved water source Improved drinking water sources are those that can deliver safe water. They include piped water, boreholes or tube wells, protected dug wells, protected springs, rainwater, and packaged or delivered water.   Share of the population not using an improved water source () 
{
    "$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": 9,
    "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": 5069,
    "slug": "share-without-improved-water",
    "title": "Share of the population not using an improved water source",
    "subtitle": "Improved drinking water sources are those that can deliver safe water. They include piped water, boreholes or tube wells, protected dug wells, protected springs, rainwater, and packaged or delivered water.",
    "originUrl": "ourworldindata.org/water-access",
    "dimensions": [
        {
            "display": {
                "unit": "%",
                "shortUnit": "%"
            },
            "property": "y",
            "variableId": 820220
        }
    ],
    "selectedEntityNames": [
        "China",
        "India",
        "Pakistan",
        "Niger",
        "Kenya",
        "Peru",
        "Madagascar"
    ]
}

Links from other tables