charts: 1508

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
1508 municipal-water-withdrawal LineChart 
{
    "id": 1508,
    "map": {
        "colorScale": {
            "baseColorScheme": "PuBu",
            "binningStrategy": "manual",
            "customNumericValues": [
                100000000,
                300000000,
                1000000000,
                3000000000,
                10000000000,
                30000000000,
                100000000000
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "43004",
        "timeTolerance": 10
    },
    "tab": "map",
    "slug": "municipal-water-withdrawal",
    "title": "Municipal water withdrawal",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 4,
    "subtitle": "Total water withdrawal for municipal (domestic) purposes, measured in cubic metres (m\u00b3) per year. Municipal water is the annual quantity of water withdrawn primarily for the direct use by the population.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "display": {
                "unit": "m\u00b3 per year",
                "shortUnit": "m\u00b3",
                "includeInTable": true,
                "conversionFactor": 1000000000
            },
            "property": "y",
            "variableId": 43004
        }
    ],
    "sourceDesc": "Food and Agriculture Organization of the United Nations - AQUASTAT",
    "isPublished": true,
    "selectedEntityNames": [
        "India",
        "China",
        "United States",
        "Indonesia",
        "Brazil",
        "South Africa",
        "Russia"
    ]
}
 2017-11-06 12:36:53 2024-04-08 12:13:54 2024-02-01 15:03:53 2017-11-06 12:36:53 54   1 Municipal water withdrawal Total water withdrawal for municipal (domestic) purposes, measured in cubic metres (m³) per year. Municipal water is the annual quantity of water withdrawn primarily for the direct use by the population.   Municipal water withdrawal () 
{
    "$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": 4,
    "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": 1508,
    "slug": "municipal-water-withdrawal",
    "title": "Municipal water withdrawal",
    "subtitle": "Total water withdrawal for municipal (domestic) purposes, measured in cubic metres (m\u00b3) per year. Municipal water is the annual quantity of water withdrawn primarily for the direct use by the population.",
    "originUrl": "https://ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "display": {
                "unit": "m\u00b3 per year",
                "shortUnit": "m\u00b3",
                "includeInTable": true,
                "conversionFactor": 1000000000
            },
            "property": "y",
            "variableId": 43004
        }
    ],
    "sourceDesc": "Food and Agriculture Organization of the United Nations - AQUASTAT",
    "selectedEntityNames": [
        "India",
        "China",
        "United States",
        "Indonesia",
        "Brazil",
        "South Africa",
        "Russia"
    ]
}

Links from other tables