charts: 851

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
851 world-crude-oil-price-vs-oil-consumption ScatterPlot 
{
    "id": 851,
    "map": {
        "time": 2021,
        "colorScale": {
            "baseColorScheme": "BuGn",
            "binningStrategy": "equalInterval",
            "legendDescription": ""
        },
        "columnSlug": "597930",
        "timeTolerance": 1
    },
    "note": "Prices are expressed in constant 2022 US$.",
    "slug": "world-crude-oil-price-vs-oil-consumption",
    "type": "ScatterPlot",
    "title": "World crude oil price vs. oil consumption",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 28,
    "subtitle": "Global crude oil price, measured in US dollars per cubic meter, against total oil consumption, measured in average cubic meters per day. Prices are adjusted for inflation.",
    "originUrl": "https://ourworldindata.org/fossil-fuels/",
    "colorScale": {
        "binningStrategy": "equalInterval"
    },
    "dimensions": [
        {
            "display": {
                "name": "Crude oil price",
                "unit": "US$ per cubic meter",
                "shortUnit": "$",
                "tolerance": 5,
                "conversionFactor": 1
            },
            "property": "y",
            "variableId": 943978
        },
        {
            "display": {
                "unit": "cubic meters per day",
                "shortUnit": ""
            },
            "property": "x",
            "variableId": 943908
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "hideLegend": true,
    "isPublished": true,
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "World"
    ],
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2017-07-31 10:51:15 2024-07-17 09:50:15 2024-07-17 09:50:15 2017-07-31 10:51:15 58   1 World crude oil price vs. oil consumption Global crude oil price, measured in US dollars per cubic meter, against total oil consumption, measured in average cubic meters per day. Prices are adjusted for inflation. Prices are expressed in constant 2022 US$. World crude oil price vs. oil consumption () 
{
    "$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": true,
    "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": 28,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "ScatterPlot",
    "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": 851,
    "note": "Prices are expressed in constant 2022 US$.",
    "slug": "world-crude-oil-price-vs-oil-consumption",
    "title": "World crude oil price vs. oil consumption",
    "subtitle": "Global crude oil price, measured in US dollars per cubic meter, against total oil consumption, measured in average cubic meters per day. Prices are adjusted for inflation.",
    "originUrl": "https://ourworldindata.org/fossil-fuels/",
    "dimensions": [
        {
            "display": {
                "name": "Crude oil price",
                "unit": "US$ per cubic meter",
                "shortUnit": "$",
                "tolerance": 5,
                "conversionFactor": 1
            },
            "property": "y",
            "variableId": 943978
        },
        {
            "display": {
                "unit": "cubic meters per day",
                "shortUnit": ""
            },
            "property": "x",
            "variableId": 943908
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "World"
    ]
}

Links from other tables