charts: 2472

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
2472 road-traffic-deaths-to-alcohol DiscreteBar 
{
    "id": 2472,
    "map": {
        "colorScale": {
            "baseColorScheme": "OrRd",
            "binningStrategy": "manual",
            "customNumericColors": [
                null,
                null,
                null,
                null,
                null
            ],
            "customNumericValues": [
                5,
                10,
                15,
                20,
                25,
                30,
                35
            ],
            "customCategoryColors": {
                "\u2013": "#eeeeee"
            },
            "customNumericMinValue": 0,
            "customHiddenCategories": {
                "\u2013": true,
                "11 - 24": true,
                "20 - 25": true,
                "14.3 (Drivers)": true,
                "13 (GB), 23 (NI)": true,
                "17 Males, 6.7 Females": true
            }
        },
        "columnSlug": "468301",
        "timeTolerance": 5
    },
    "tab": "map",
    "slug": "road-traffic-deaths-to-alcohol",
    "type": "DiscreteBar",
    "title": "Share of road traffic deaths attributed to alcohol",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 16,
    "subtitle": "Share of all road traffic deaths attributed to alcohol consumption above the national legal limit for alcohol consumption. It includes deaths in vehicles, of pedestrians and of cyclists.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "unit": "%",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 824235
        }
    ],
    "isPublished": true,
    "hideTimeline": true,
    "invertColorScheme": true,
    "selectedEntityNames": [
        "South Africa",
        "United States",
        "Honduras",
        "Switzerland",
        "Sweden",
        "Italy",
        "Canada",
        "China",
        "India"
    ]
}
 2018-03-27 04:56:54 2024-06-18 11:37:02 2024-06-18 11:37:02 2018-03-27 04:56:54 54 14 1 Share of road traffic deaths attributed to alcohol Share of all road traffic deaths attributed to alcohol consumption above the national legal limit for alcohol consumption. It includes deaths in vehicles, of pedestrians and of cyclists.   Share of road traffic deaths attributed to alcohol () 
{
    "$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": true,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "year",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": true,
    "version": 16,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "DiscreteBar",
    "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": 2472,
    "slug": "road-traffic-deaths-to-alcohol",
    "title": "Share of road traffic deaths attributed to alcohol",
    "subtitle": "Share of all road traffic deaths attributed to alcohol consumption above the national legal limit for alcohol consumption. It includes deaths in vehicles, of pedestrians and of cyclists.",
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "unit": "%",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 824235
        }
    ],
    "selectedEntityNames": [
        "South Africa",
        "United States",
        "Honduras",
        "Switzerland",
        "Sweden",
        "Italy",
        "Canada",
        "China",
        "India"
    ]
}

Links from other tables