charts: 1623

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
1623 marine-protected-areas LineChart 
{
    "id": 1623,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlGnBu",
            "binningStrategy": "manual",
            "customNumericColors": [
                null,
                null
            ],
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80,
                90,
                100
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "735269"
    },
    "tab": "map",
    "slug": "marine-protected-areas",
    "title": "Share of marine territorial waters that are protected",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": "latest",
    "version": 23,
    "subtitle": "[Marine protected areas](#dod:protected_area) are regions of intertidal or sub-tidal land and associated water, flora and fauna, and cultural and historical features that have been legally or effectively reserved for protection.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/biodiversity",
    "dimensions": [
        {
            "display": {
                "unit": "% of territorial waters"
            },
            "property": "y",
            "variableId": 905115
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "India",
        "World",
        "Bangladesh",
        "Pakistan",
        "South Asia",
        "Australia",
        "United States",
        "United Kingdom",
        "Maldives",
        "Brazil",
        "Chile",
        "Norway"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2017-11-23 12:46:28 2024-05-31 07:05:18 2024-05-31 07:05:18 2017-11-23 12:46:28 59   1 Share of marine territorial waters that are protected [Marine protected areas](#dod:protected_area) are regions of intertidal or sub-tidal land and associated water, flora and fauna, and cultural and historical features that have been legally or effectively reserved for protection.   Share of marine territorial waters that are protected () 
{
    "$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": 23,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "stackMode": "absolute",
    "minTime": "latest",
    "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": 1623,
    "slug": "marine-protected-areas",
    "title": "Share of marine territorial waters that are protected",
    "subtitle": "[Marine protected areas](#dod:protected_area) are regions of intertidal or sub-tidal land and associated water, flora and fauna, and cultural and historical features that have been legally or effectively reserved for protection.",
    "originUrl": "https://ourworldindata.org/biodiversity",
    "dimensions": [
        {
            "display": {
                "unit": "% of territorial waters"
            },
            "property": "y",
            "variableId": 905115
        }
    ],
    "selectedEntityNames": [
        "India",
        "World",
        "Bangladesh",
        "Pakistan",
        "South Asia",
        "Australia",
        "United States",
        "United Kingdom",
        "Maldives",
        "Brazil",
        "Chile",
        "Norway"
    ]
}

Links from other tables