charts: 1489

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
1489 municipal-water-as-a-share-of-total-water-withdrawals LineChart 
{
    "id": 1489,
    "map": {
        "colorScale": {
            "baseColorScheme": "PuBu",
            "binningStrategy": "manual",
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80,
                90,
                100
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "735260",
        "timeTolerance": 5
    },
    "tab": "map",
    "note": "It is defined as the annual quantity of water withdrawn primarily for direct use by the population. It is usually computed as the total water withdrawn by the public distribution network. It can include that part of the industries and urban agriculture, which is connected to the municipal network.",
    "slug": "municipal-water-as-a-share-of-total-water-withdrawals",
    "title": "Municipal water as a share of total water withdrawals",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": 2019,
    "version": 12,
    "subtitle": "Municipal (domestic) water withdrawals as a percentage of total water withdrawals (which is the sum of water used for agriculture, industry, and municipal purposes).",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "display": {
                "unit": "% of total freshwater withdrawal",
                "shortUnit": "%",
                "numDecimalPlaces": 1
            },
            "property": "y",
            "variableId": 905108
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "Low-income countries",
        "High-income countries",
        "Middle-income countries",
        "Lower-middle-income countries",
        "Upper-middle-income countries",
        "World"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true
    }
}
 2017-11-05 19:09:59 2024-05-31 07:04:54 2024-05-31 07:04:54 2017-11-05 19:09:59 59   1 Municipal water as a share of total water withdrawals Municipal (domestic) water withdrawals as a percentage of total water withdrawals (which is the sum of water used for agriculture, industry, and municipal purposes). It is defined as the annual quantity of water withdrawn primarily for direct use by the population. It is usually computed as the total water withdrawn by the public distribution network. It can include that part of the industries and urban agriculture, which is connected to the municipal network. Municipal water as a share of total water withdrawals () 
{
    "$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": 12,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "stackMode": "absolute",
    "minTime": 2019,
    "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": 1489,
    "note": "It is defined as the annual quantity of water withdrawn primarily for direct use by the population. It is usually computed as the total water withdrawn by the public distribution network. It can include that part of the industries and urban agriculture, which is connected to the municipal network.",
    "slug": "municipal-water-as-a-share-of-total-water-withdrawals",
    "title": "Municipal water as a share of total water withdrawals",
    "subtitle": "Municipal (domestic) water withdrawals as a percentage of total water withdrawals (which is the sum of water used for agriculture, industry, and municipal purposes).",
    "originUrl": "https://ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "display": {
                "unit": "% of total freshwater withdrawal",
                "shortUnit": "%",
                "numDecimalPlaces": 1
            },
            "property": "y",
            "variableId": 905108
        }
    ],
    "selectedEntityNames": [
        "Low-income countries",
        "High-income countries",
        "Middle-income countries",
        "Lower-middle-income countries",
        "Upper-middle-income countries",
        "World"
    ]
}

Links from other tables