charts: 3317

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
3317 per-capita-alcohol-1890 LineChart 
{
    "id": 3317,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlGnBu",
            "binningStrategy": "manual",
            "customNumericValues": [
                5,
                6,
                7,
                8,
                9,
                10,
                15
            ]
        },
        "columnSlug": "99496"
    },
    "note": "Note figures are presented as the per capita average of the total population (not restricted to adults).",
    "slug": "per-capita-alcohol-1890",
    "title": "Alcohol consumption per capita",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 10,
    "subtitle": "Average per capita alcohol consumption measured in litres of pure alcohol per person per year.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "name": "Per capita alcohol consumption",
                "unit": "liters of pure alcohol",
                "shortUnit": "liters",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 99496
        }
    ],
    "sourceDesc": "Holmes, A. J., & Anderson, K. (2017). Convergence in national alcohol consumption patterns: New global indicators. ",
    "isPublished": true,
    "variantName": "Per capita alcohol consumption in high-income countries",
    "selectedEntityNames": [
        "Australia",
        "Belgium",
        "France",
        "Germany",
        "Italy",
        "United Kingdom",
        "United States"
    ]
}
 2019-02-14 15:29:01 2024-04-08 12:13:54 2024-01-03 09:31:55 2019-02-14 15:29:01 46 14 1 Alcohol consumption per capita Average per capita alcohol consumption measured in litres of pure alcohol per person per year. Note figures are presented as the per capita average of the total population (not restricted to adults). Alcohol consumption per capita (Per capita alcohol consumption in high-income countries) 
{
    "$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": 10,
    "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": 3317,
    "note": "Note figures are presented as the per capita average of the total population (not restricted to adults).",
    "slug": "per-capita-alcohol-1890",
    "title": "Alcohol consumption per capita",
    "subtitle": "Average per capita alcohol consumption measured in litres of pure alcohol per person per year.",
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "name": "Per capita alcohol consumption",
                "unit": "liters of pure alcohol",
                "shortUnit": "liters",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 99496
        }
    ],
    "sourceDesc": "Holmes, A. J., & Anderson, K. (2017). Convergence in national alcohol consumption patterns: New global indicators. ",
    "variantName": "Per capita alcohol consumption in high-income countries",
    "selectedEntityNames": [
        "Australia",
        "Belgium",
        "France",
        "Germany",
        "Italy",
        "United Kingdom",
        "United States"
    ]
}

Links from other tables