charts: 5673

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
5673 large-oil-spills-decadal StackedBar 
{
    "id": 5673,
    "map": {
        "columnSlug": "427445"
    },
    "note": "Decadal figures are measured as the annual average over the subsequent ten-year period. For example, the\nfigures for the 1990s is the average from 1990 (inclusive) to 1999.",
    "slug": "large-oil-spills-decadal",
    "type": "StackedBar",
    "title": "Global annual average number of oil spills from tankers per decade",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 11,
    "subtitle": "Tanker accidents are broken down by magnitude based on the amount of oil spilled.",
    "originUrl": "ourworldindata.org/oil-spills",
    "dimensions": [
        {
            "property": "y",
            "variableId": 700004
        },
        {
            "property": "y",
            "variableId": 700003
        }
    ],
    "entityType": "magnitude of oil spill",
    "isPublished": true,
    "entityTypePlural": "magnitude of oil spills",
    "selectedEntityNames": [
        "World"
    ],
    "selectedEntityColors": {
        "Large (> 700 tonnes)": "#6f0f1c"
    },
    "selectedFacetStrategy": "none",
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2022-05-04 15:36:00 2024-04-08 12:13:54 2023-06-29 07:33:38 2022-05-04 15:36:00 72 14 1 Global annual average number of oil spills from tankers per decade Tanker accidents are broken down by magnitude based on the amount of oil spilled. Decadal figures are measured as the annual average over the subsequent ten-year period. For example, the figures for the 1990s is the average from 1990 (inclusive) to 1999. Global annual average number of oil spills from tankers per decade () 
{
    "$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": false,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "year",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 11,
    "logo": "owid",
    "entityType": "magnitude of oil spill",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "StackedBar",
    "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": "magnitude of oil spills",
    "missingDataStrategy": "auto",
    "id": 5673,
    "note": "Decadal figures are measured as the annual average over the subsequent ten-year period. For example, the\nfigures for the 1990s is the average from 1990 (inclusive) to 1999.",
    "slug": "large-oil-spills-decadal",
    "title": "Global annual average number of oil spills from tankers per decade",
    "subtitle": "Tanker accidents are broken down by magnitude based on the amount of oil spilled.",
    "originUrl": "ourworldindata.org/oil-spills",
    "dimensions": [
        {
            "property": "y",
            "variableId": 700004
        },
        {
            "property": "y",
            "variableId": 700003
        }
    ],
    "selectedEntityNames": [
        "World"
    ],
    "selectedEntityColors": {
        "Large (> 700 tonnes)": "#6f0f1c"
    }
}

Links from other tables