charts: 3318

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
3318 alcohol-by-type-1890 StackedArea 
{
    "id": 3318,
    "map": {
        "time": 2014,
        "colorScale": {
            "binningStrategy": "equalInterval"
        },
        "columnSlug": "99499"
    },
    "slug": "alcohol-by-type-1890",
    "type": "StackedArea",
    "title": "Alcohol consumption by type of alcoholic beverage",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 5,
    "subtitle": "The share of total alcohol consumption from wine, beer and spirits. This is given as the percentage of pure alcohol consumption from each type.",
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "name": "Spirits",
                "unit": "% of total alcohol consumption",
                "shortUnit": "%",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 99499
        },
        {
            "property": "y",
            "variableId": 99498
        },
        {
            "property": "y",
            "variableId": 99497
        }
    ],
    "sourceDesc": "Holmes, A. J., & Anderson, K. (2017). Convergence in national alcohol consumption patterns: New global indicators. ",
    "isPublished": true,
    "baseColorScheme": "OwidCategoricalC",
    "selectedEntityNames": [
        "Italy"
    ],
    "selectedEntityColors": {
        "Italy": "#d26e66"
    }
}
 2019-02-14 15:39:51 2024-04-08 12:13:54 2022-11-08 16:38:29 2019-02-14 15:39:51 64 14 1 Alcohol consumption by type of alcoholic beverage The share of total alcohol consumption from wine, beer and spirits. This is given as the percentage of pure alcohol consumption from each type.   Alcohol consumption by type of alcoholic beverage () 
{
    "$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": "OwidCategoricalC",
    "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": 5,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "StackedArea",
    "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": "countries",
    "missingDataStrategy": "auto",
    "id": 3318,
    "slug": "alcohol-by-type-1890",
    "title": "Alcohol consumption by type of alcoholic beverage",
    "subtitle": "The share of total alcohol consumption from wine, beer and spirits. This is given as the percentage of pure alcohol consumption from each type.",
    "originUrl": "https://ourworldindata.org/alcohol-consumption",
    "dimensions": [
        {
            "display": {
                "name": "Spirits",
                "unit": "% of total alcohol consumption",
                "shortUnit": "%",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 99499
        },
        {
            "property": "y",
            "variableId": 99498
        },
        {
            "property": "y",
            "variableId": 99497
        }
    ],
    "sourceDesc": "Holmes, A. J., & Anderson, K. (2017). Convergence in national alcohol consumption patterns: New global indicators. ",
    "selectedEntityNames": [
        "Italy"
    ],
    "selectedEntityColors": {
        "Italy": "#d26e66"
    }
}

Links from other tables