charts: 1629

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
1629 internal-renewable-freshwater-resources-by-region DiscreteBar 
{
    "id": 1629,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval",
            "customNumericMinValue": 0
        }
    },
    "slug": "internal-renewable-freshwater-resources-by-region",
    "type": "DiscreteBar",
    "title": "Internal renewable freshwater resources by region",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 5,
    "subtitle": "Renewable internal freshwater resources refers to the quantity of internal freshwater from inflowing river basins and recharging groundwater aquifers.",
    "originUrl": "https://ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "display": {
                "unit": "cubic kilometers",
                "shortUnit": "km\u00b3",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 905116
        }
    ],
    "isPublished": true,
    "hideTimeline": true,
    "selectedEntityNames": [
        "Oceania",
        "Central America and Caribbean",
        "East Asia",
        "Central Asia",
        "Eastern Europe",
        "Middle East",
        "North America",
        "Northern Africa",
        "South America",
        "Sub-Saharan Africa",
        "South Asia",
        "Western & Central Europe",
        "World",
        "South Asia (WB)",
        "East Asia and Pacific (WB)",
        "Europe and Central Asia (WB)",
        "Sub-Saharan Africa (WB)",
        "Middle East and North Africa (WB)",
        "North America (WB)",
        "Latin America and Caribbean (WB)"
    ]
}
 2017-11-23 16:39:31 2024-05-31 07:05:19 2024-05-31 07:05:19 2017-11-23 16:39:31 59   1 Internal renewable freshwater resources by region Renewable internal freshwater resources refers to the quantity of internal freshwater from inflowing river basins and recharging groundwater aquifers.   Internal renewable freshwater resources by region () 
{
    "$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": "chart",
    "matchingEntitiesOnly": false,
    "hasChartTab": true,
    "hideLegend": false,
    "hideLogo": false,
    "hideTimeline": true,
    "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": "DiscreteBar",
    "hasMapTab": false,
    "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": 1629,
    "slug": "internal-renewable-freshwater-resources-by-region",
    "title": "Internal renewable freshwater resources by region",
    "subtitle": "Renewable internal freshwater resources refers to the quantity of internal freshwater from inflowing river basins and recharging groundwater aquifers.",
    "originUrl": "https://ourworldindata.org/water-use-stress",
    "dimensions": [
        {
            "display": {
                "unit": "cubic kilometers",
                "shortUnit": "km\u00b3",
                "numDecimalPlaces": 0
            },
            "property": "y",
            "variableId": 905116
        }
    ],
    "selectedEntityNames": [
        "Oceania",
        "Central America and Caribbean",
        "East Asia",
        "Central Asia",
        "Eastern Europe",
        "Middle East",
        "North America",
        "Northern Africa",
        "South America",
        "Sub-Saharan Africa",
        "South Asia",
        "Western & Central Europe",
        "World",
        "South Asia (WB)",
        "East Asia and Pacific (WB)",
        "Europe and Central Asia (WB)",
        "Sub-Saharan Africa (WB)",
        "Middle East and North Africa (WB)",
        "North America (WB)",
        "Latin America and Caribbean (WB)"
    ]
}

Links from other tables