charts: 2474

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
2474 alcohol-related-crimes-of-all-crimes LineChart 
{
    "id": 2474,
    "map": {
        "colorScale": {
            "baseColorScheme": "OrRd",
            "binningStrategy": "manual",
            "customNumericColors": [
                null,
                null,
                null
            ],
            "customNumericValues": [
                10,
                20,
                30,
                40,
                50,
                60,
                70,
                80
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "469797",
        "timeTolerance": 10
    },
    "tab": "map",
    "slug": "alcohol-related-crimes-of-all-crimes",
    "title": "Share of crimes which are alcohol-related",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 14,
    "subtitle": "This includes two groups of criminal offenses: First, those where alcohol is part of the crime such as driving with excess alcohol, liquor license violations, and drunkenness. \nSecond, crimes in which the consumption of alcohol is thought to have played a role in the committing of the offense \u2013 including assault and criminal damage.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "unit": "%",
                "shortUnit": "%"
            },
            "property": "y",
            "variableId": 821989
        }
    ],
    "sourceDesc": "WHO, Global Health Observatory (2022)",
    "isPublished": true,
    "selectedEntityNames": [
        "United States",
        "Canada",
        "Norway",
        "Russia",
        "United Kingdom"
    ]
}
 2018-03-27 09:16:22 2024-04-08 12:13:54 2024-03-06 20:49:26 2018-03-27 09:16:22 59 14 1 Share of crimes which are alcohol-related This includes two groups of criminal offenses: First, those where alcohol is part of the crime such as driving with excess alcohol, liquor license violations, and drunkenness. Second, crimes in which the consumption of alcohol is thought to have played a role in the committing of the offense – including assault and criminal damage.   Share of crimes which are alcohol-related () 
{
    "$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": 14,
    "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": 2474,
    "slug": "alcohol-related-crimes-of-all-crimes",
    "title": "Share of crimes which are alcohol-related",
    "subtitle": "This includes two groups of criminal offenses: First, those where alcohol is part of the crime such as driving with excess alcohol, liquor license violations, and drunkenness. \nSecond, crimes in which the consumption of alcohol is thought to have played a role in the committing of the offense \u2013 including assault and criminal damage.",
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "unit": "%",
                "shortUnit": "%"
            },
            "property": "y",
            "variableId": 821989
        }
    ],
    "sourceDesc": "WHO, Global Health Observatory (2022)",
    "selectedEntityNames": [
        "United States",
        "Canada",
        "Norway",
        "Russia",
        "United Kingdom"
    ]
}

Links from other tables