charts: 2334

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
2334 sdg-target-on-improved-water-access LineChart 
{
    "id": 2334,
    "map": {
        "time": "latest",
        "colorScale": {
            "binningStrategy": "manual",
            "customNumericColors": [
                "#ef8a62",
                "#67a9cf"
            ],
            "customNumericLabels": [
                "Still not met",
                "Target met"
            ],
            "customNumericValues": [
                98.99,
                200
            ],
            "customNumericMinValue": 0,
            "customNumericColorsActive": true
        },
        "columnSlug": "3379",
        "timeTolerance": 5
    },
    "tab": "map",
    "slug": "sdg-target-on-improved-water-access",
    "title": "Has country already reached SDG target on improved water access?",
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 9,
    "subtitle": "Target 7.1 of the UN Sustainable Development Goals (SDGs) is to achieve universal and equitable usage of safe and affordable drinking water for all. Here, we assume a target threshold of at least 99% using an improved water source.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "property": "y",
            "variableId": 820162
        }
    ],
    "isPublished": true,
    "variantName": "",
    "internalNotes": "SDG target binary.",
    "selectedEntityNames": [
        "World"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true
    }
}
 2018-03-09 16:56:24 2024-04-08 12:13:54 2024-02-26 15:13:56 2018-03-09 16:56:24 54 14 1 Has country already reached SDG target on improved water access? Target 7.1 of the UN Sustainable Development Goals (SDGs) is to achieve universal and equitable usage of safe and affordable drinking water for all. Here, we assume a target threshold of at least 99% using an improved water source.   Has country already reached SDG target on improved water access? () 
{
    "$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": 2334,
    "slug": "sdg-target-on-improved-water-access",
    "title": "Has country already reached SDG target on improved water access?",
    "subtitle": "Target 7.1 of the UN Sustainable Development Goals (SDGs) is to achieve universal and equitable usage of safe and affordable drinking water for all. Here, we assume a target threshold of at least 99% using an improved water source.",
    "originUrl": "ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "property": "y",
            "variableId": 820162
        }
    ],
    "variantName": "",
    "internalNotes": "SDG target binary.",
    "selectedEntityNames": [
        "World"
    ]
}

Links from other tables