charts: 2333

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
2333 sdg-target-for-access-to-sanitation LineChart 
{
    "id": 2333,
    "map": {
        "time": "latest",
        "colorScale": {
            "binningStrategy": "manual",
            "customNumericColors": [
                "#ef8a62",
                "#67a9cf"
            ],
            "customNumericLabels": [
                "Still not met",
                "Target met"
            ],
            "customNumericValues": [
                98.99,
                200
            ],
            "customNumericMinValue": 0,
            "customNumericColorsActive": true
        },
        "columnSlug": "3376",
        "timeTolerance": 5
    },
    "tab": "map",
    "slug": "sdg-target-for-access-to-sanitation",
    "title": "Has country already reached SDG target for usage of improved sanitation facilities?",
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 8,
    "subtitle": "Target 6.2 of the UN Sustainable Development Goals (SDGs) is to achieve access to adequate and equitable sanitation and hygiene for all. Here we mark a cut-off threshold of 99% of the population using improved sanitation facilities.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/clean-water-sanitation",
    "dimensions": [
        {
            "property": "y",
            "variableId": 820174
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "World",
        "Low-income countries",
        "High-income countries",
        "Lower-middle-income countries",
        "Upper-middle-income countries"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true
    }
}
 2018-03-09 16:29:39 2024-04-08 12:13:54 2024-02-26 13:52:36 2018-03-09 16:32:24 54 14 1 Has country already reached SDG target for usage of improved sanitation facilities? Target 6.2 of the UN Sustainable Development Goals (SDGs) is to achieve access to adequate and equitable sanitation and hygiene for all. Here we mark a cut-off threshold of 99% of the population using improved sanitation facilities.   Has country already reached SDG target for usage of improved sanitation facilities? () 
{
    "$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": 8,
    "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": 2333,
    "slug": "sdg-target-for-access-to-sanitation",
    "title": "Has country already reached SDG target for usage of improved sanitation facilities?",
    "subtitle": "Target 6.2 of the UN Sustainable Development Goals (SDGs) is to achieve access to adequate and equitable sanitation and hygiene for all. Here we mark a cut-off threshold of 99% of the population using improved sanitation facilities.",
    "originUrl": "ourworldindata.org/clean-water-sanitation",
    "dimensions": [
        {
            "property": "y",
            "variableId": 820174
        }
    ],
    "selectedEntityNames": [
        "World",
        "Low-income countries",
        "High-income countries",
        "Lower-middle-income countries",
        "Upper-middle-income countries"
    ]
}

Links from other tables