charts: 133

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
133 share-of-the-population-with-access-to-improved-drinking-water LineChart 
{
    "id": 133,
    "map": {
        "colorScale": {
            "baseColorScheme": "GnBu",
            "binningStrategy": "manual",
            "legendDescription": "Population with access to improved drinking water",
            "customNumericColors": [
                "#000",
                "#c00",
                "#0c0",
                "#00c",
                "#c0c"
            ],
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80,
                90,
                100
            ]
        },
        "columnSlug": "3379",
        "timeTolerance": 1
    },
    "tab": "map",
    "note": "Data encompasses both people using basic water services as well as those using safely managed water services. Basic drinking water services is defined as drinking water from an 'improved source', which includes piped water, boreholes or tubewells, protected dug wells, protected springs, and packaged or delivered water. Safely managed water services include improved sources that are accessible on premises, available when needed, and free from faecal and priority chemical contamination.",
    "slug": "share-of-the-population-with-access-to-improved-drinking-water",
    "title": "Share of the population using at least basic water services",
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 11,
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/water-access",
    "dimensions": [
        {
            "display": {
                "color": "#B0171F"
            },
            "property": "y",
            "variableId": 905784
        }
    ],
    "selectedEntityNames": [
        "World",
        "Low-income countries",
        "High-income countries",
        "Lower-middle-income countries",
        "Upper-middle-income countries"
    ],
    "selectedEntityColors": {
        "World": "#B0171F"
    },
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2016-01-06 06:43:18 2024-05-31 07:01:57 2024-05-31 07:01:57 2016-01-06 06:43:18 59   1 Share of the population using at least basic water services   Data encompasses both people using basic water services as well as those using safely managed water services. Basic drinking water services is defined as drinking water from an 'improved source', which includes piped water, boreholes or tubewells, protected dug wells, protected springs, and packaged or delivered water. Safely managed water services include improved sources that are accessible on premises, available when needed, and free from faecal and priority chemical contamination. Share of the population using at least basic water services () 
{
    "$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": false,
    "invertColorScheme": false,
    "version": 11,
    "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": 133,
    "note": "Data encompasses both people using basic water services as well as those using safely managed water services. Basic drinking water services is defined as drinking water from an 'improved source', which includes piped water, boreholes or tubewells, protected dug wells, protected springs, and packaged or delivered water. Safely managed water services include improved sources that are accessible on premises, available when needed, and free from faecal and priority chemical contamination.",
    "slug": "share-of-the-population-with-access-to-improved-drinking-water",
    "title": "Share of the population using at least basic water services",
    "originUrl": "https://ourworldindata.org/water-access",
    "dimensions": [
        {
            "display": {
                "color": "#B0171F"
            },
            "property": "y",
            "variableId": 905784
        }
    ],
    "selectedEntityNames": [
        "World",
        "Low-income countries",
        "High-income countries",
        "Lower-middle-income countries",
        "Upper-middle-income countries"
    ],
    "selectedEntityColors": {
        "World": "#B0171F"
    }
}

Links from other tables