charts: 5611

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
5611 excess-deaths-daily-economist-single-entity LineChart 
{
    "id": 5611,
    "map": {
        "columnSlug": "180166"
    },
    "note": "For some countries, all-cause deaths and COVID-19 deaths use different date schemes, in which one refers to when the death occurred and the other to when it was reported. This difference could produce an artificial lag between the two time series.",
    "slug": "excess-deaths-daily-economist-single-entity",
    "title": "Estimated daily excess deaths during COVID",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 1748,
    "subtitle": "For countries that have not reported all-cause mortality data for a given week, an estimate is shown, with uncertainty interval. If reported data is available, that value only is shown. For comparison, daily confirmed COVID-19 deaths are shown (7-day rolling average).",
    "originUrl": "ourworldindata.org/coronavirus",
    "dimensions": [
        {
            "display": {
                "name": "Central excess death estimate",
                "color": "#b13507",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 734422
        },
        {
            "display": {
                "name": "Upper bound, 95% uncertainty interval",
                "color": "#c8c8c8",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 734425
        },
        {
            "display": {
                "name": "Lower bound",
                "color": "#c8c8c8",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 734424
        },
        {
            "display": {
                "name": "Confirmed COVID-19 deaths",
                "color": "#000000",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 954549
        }
    ],
    "isPublished": true,
    "variantName": "Non-Explorer, single-entity version",
    "addCountryMode": "change-country",
    "selectedEntityNames": [
        "World"
    ],
    "selectedFacetStrategy": "entity",
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2022-03-08 18:37:51 2024-07-26 15:18:21 2024-07-26 15:18:21 2022-03-08 18:49:41 74 48 1 Estimated daily excess deaths during COVID For countries that have not reported all-cause mortality data for a given week, an estimate is shown, with uncertainty interval. If reported data is available, that value only is shown. For comparison, daily confirmed COVID-19 deaths are shown (7-day rolling average). For some countries, all-cause deaths and COVID-19 deaths use different date schemes, in which one refers to when the death occurred and the other to when it was reported. This difference could produce an artificial lag between the two time series. Estimated daily excess deaths during COVID (Non-Explorer, single-entity version) 
{
    "$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": "entity",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 1748,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "change-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "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": 5611,
    "note": "For some countries, all-cause deaths and COVID-19 deaths use different date schemes, in which one refers to when the death occurred and the other to when it was reported. This difference could produce an artificial lag between the two time series.",
    "slug": "excess-deaths-daily-economist-single-entity",
    "title": "Estimated daily excess deaths during COVID",
    "subtitle": "For countries that have not reported all-cause mortality data for a given week, an estimate is shown, with uncertainty interval. If reported data is available, that value only is shown. For comparison, daily confirmed COVID-19 deaths are shown (7-day rolling average).",
    "originUrl": "ourworldindata.org/coronavirus",
    "dimensions": [
        {
            "display": {
                "name": "Central excess death estimate",
                "color": "#b13507",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 734422
        },
        {
            "display": {
                "name": "Upper bound, 95% uncertainty interval",
                "color": "#c8c8c8",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 734425
        },
        {
            "display": {
                "name": "Lower bound",
                "color": "#c8c8c8",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 734424
        },
        {
            "display": {
                "name": "Confirmed COVID-19 deaths",
                "color": "#000000",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 954549
        }
    ],
    "variantName": "Non-Explorer, single-entity version",
    "selectedEntityNames": [
        "World"
    ]
}

Links from other tables