charts: 4583

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
4583 rural-without-improved-sanitation LineChart 
{
    "id": 4583,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlOrBr",
            "binningStrategy": "manual",
            "customNumericValues": [
                100000,
                500000,
                1000000,
                5000000,
                10000000,
                50000000,
                100000000
            ],
            "binningStrategyBinCount": 6
        }
    },
    "tab": "map",
    "note": "An 'improved sanitation facility' includes flush/pour flush (to piped sewer system, septic tank, pit latrine), ventilated improved pit latrine, pit latrine with slab, and composting toilet.",
    "slug": "rural-without-improved-sanitation",
    "title": "People in rural areas not using improved sanitation facilities",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 5,
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/sanitation",
    "dimensions": [
        {
            "property": "y",
            "variableId": 145135
        }
    ],
    "sourceDesc": "WHO/UNICEF Joint Monitoring Programme (JMP) for Water Supply and Sanitation",
    "isPublished": true,
    "selectedEntityNames": [
        "Belize",
        "Niger",
        "Botswana",
        "Ethiopia",
        "Cote d'Ivoire",
        "Congo",
        "Ghana"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2020-10-03 09:44:14 2024-04-08 12:13:54 2024-01-11 11:42:22 2020-10-03 09:44:14 54 14 1 People in rural areas not using improved sanitation facilities   An 'improved sanitation facility' includes flush/pour flush (to piped sewer system, septic tank, pit latrine), ventilated improved pit latrine, pit latrine with slab, and composting toilet. People in rural areas not using 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": 5,
    "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": 4583,
    "note": "An 'improved sanitation facility' includes flush/pour flush (to piped sewer system, septic tank, pit latrine), ventilated improved pit latrine, pit latrine with slab, and composting toilet.",
    "slug": "rural-without-improved-sanitation",
    "title": "People in rural areas not using improved sanitation facilities",
    "originUrl": "ourworldindata.org/sanitation",
    "dimensions": [
        {
            "property": "y",
            "variableId": 145135
        }
    ],
    "sourceDesc": "WHO/UNICEF Joint Monitoring Programme (JMP) for Water Supply and Sanitation",
    "selectedEntityNames": [
        "Belize",
        "Niger",
        "Botswana",
        "Ethiopia",
        "Cote d'Ivoire",
        "Congo",
        "Ghana"
    ]
}

Links from other tables