charts

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

3 rows where lastEditedByUserId = 55 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, updatedAt, isIndexable, createdAt (date), updatedAt (date), lastEditedAt (date), publishedAt (date)

id ▲ slug type config createdAt updatedAt lastEditedAt publishedAt lastEditedByUserId publishedByUserId isIndexable title subtitle note title_plus_variant configWithDefaults
7870 life-expectancy LineChart 
{
    "id": 7870,
    "map": {
        "time": "latest",
        "colorScale": {
            "baseColorScheme": "YlGnBu",
            "binningStrategy": "manual",
            "legendDescription": "Life expectancy (at birth)",
            "customNumericColors": [
                "#fee08b",
                null,
                "#ffffbf",
                "#e6f598",
                "#abdda4",
                "#66c2a5",
                "#3288bd"
            ],
            "customNumericValues": [
                40,
                45,
                50,
                55,
                60,
                65,
                70,
                75,
                80,
                85,
                -1
            ],
            "customCategoryColors": {
                "No data": "#8b8b8b"
            },
            "customNumericMinValue": 50,
            "binningStrategyBinCount": 10
        },
        "columnSlug": "539022",
        "timeTolerance": 10
    },
    "slug": "life-expectancy",
    "title": "Life expectancy in the United States is lower than peer nations",
    "yAxis": {
        "max": 85,
        "min": 60,
        "canChangeScaleType": true
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": 1990,
    "version": 62,
    "subtitle": "The [period life expectancy](#dod:period-life-expectancy) at birth, in a given year.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/life-expectancy",
    "dimensions": [
        {
            "display": {
                "unit": "years",
                "shortUnit": "years",
                "includeInTable": true,
                "numDecimalPlaces": 1
            },
            "property": "y",
            "variableId": 815383
        }
    ],
    "variantName": "over the long-run",
    "selectedEntityNames": [
        "Australia",
        "Canada",
        "United Kingdom",
        "United States",
        "High-income countries"
    ],
    "selectedEntityColors": {
        "Asia": "#00847e",
        "World": "#18470f",
        "Africa": "#a2559c",
        "Canada": "#b8baba",
        "Europe": "#4c6a9c",
        "Oceania": "#9a5129",
        "Americas": "#c4523e",
        "Australia": "#b8baba",
        "United States": "#be5915",
        "United Kingdom": "#b8baba",
        "High-income countries": "#286bbb"
    },
    "hideAnnotationFieldsInTitle": {
        "time": true
    }
}
 2024-06-11 19:58:00 2024-06-28 09:32:57 2024-06-28 09:32:57   Lars Yencken 55   0 Life expectancy in the United States is lower than peer nations The [period life expectancy](#dod:period-life-expectancy) at birth, in a given year.   Life expectancy in the United States is lower than peer nations (over the long-run) 
{
    "$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": false,
    "invertColorScheme": false,
    "version": 62,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "stackMode": "absolute",
    "minTime": 1990,
    "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": 7870,
    "slug": "life-expectancy",
    "title": "Life expectancy in the United States is lower than peer nations",
    "subtitle": "The [period life expectancy](#dod:period-life-expectancy) at birth, in a given year.",
    "originUrl": "https://ourworldindata.org/life-expectancy",
    "dimensions": [
        {
            "display": {
                "unit": "years",
                "shortUnit": "years",
                "includeInTable": true,
                "numDecimalPlaces": 1
            },
            "property": "y",
            "variableId": 815383
        }
    ],
    "variantName": "over the long-run",
    "selectedEntityNames": [
        "Australia",
        "Canada",
        "United Kingdom",
        "United States",
        "High-income countries"
    ],
    "selectedEntityColors": {
        "Asia": "#00847e",
        "World": "#18470f",
        "Africa": "#a2559c",
        "Canada": "#b8baba",
        "Europe": "#4c6a9c",
        "Oceania": "#9a5129",
        "Americas": "#c4523e",
        "Australia": "#b8baba",
        "United States": "#be5915",
        "United Kingdom": "#b8baba",
        "High-income countries": "#286bbb"
    }
}
3121 undernourished-people-oecd StackedArea 
{
    "id": 3121,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval"
        }
    },
    "slug": "undernourished-people-oecd",
    "type": "StackedArea",
    "title": "Number of people who are undernourished",
    "yAxis": {
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 7,
    "subtitle": "Total number of people who are undernourished, aggregated by the OECD States of Fragility (2018) assessment of country fragility.",
    "originUrl": "https://ourworldindata.org/leaving-no-one-behind",
    "dimensions": [
        {
            "display": {
                "color": "#818282",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 98079
        }
    ],
    "entityType": "level",
    "sourceDesc": "Food and Agriculture Organization of the United Nations",
    "isPublished": true,
    "variantName": "By fragility level",
    "internalNotes": "For OECD Report. Please do not delete.",
    "addCountryMode": "disabled",
    "entityTypePlural": "levels",
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "Extreme Fragility",
        "Fragile",
        "Non-fragile"
    ],
    "selectedEntityColors": {
        "Fragile": "#b16214",
        "Non-fragile": "#970046",
        "Extreme Fragility": "#b13507"
    }
}
 2018-10-03 18:52:43 2024-04-08 12:13:54 2023-04-26 12:55:32 2018-10-03 18:52:43 Lars Yencken 55 Hannah Ritchie 14 0 Number of people who are undernourished Total number of people who are undernourished, aggregated by the OECD States of Fragility (2018) assessment of country fragility.   Number of people who are undernourished (By fragility level) 
{
    "$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": 7,
    "logo": "owid",
    "entityType": "level",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "disabled",
    "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": "levels",
    "missingDataStrategy": "auto",
    "id": 3121,
    "slug": "undernourished-people-oecd",
    "title": "Number of people who are undernourished",
    "subtitle": "Total number of people who are undernourished, aggregated by the OECD States of Fragility (2018) assessment of country fragility.",
    "originUrl": "https://ourworldindata.org/leaving-no-one-behind",
    "dimensions": [
        {
            "display": {
                "color": "#818282",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 98079
        }
    ],
    "sourceDesc": "Food and Agriculture Organization of the United Nations",
    "variantName": "By fragility level",
    "internalNotes": "For OECD Report. Please do not delete.",
    "hideRelativeToggle": false,
    "selectedEntityNames": [
        "Extreme Fragility",
        "Fragile",
        "Non-fragile"
    ],
    "selectedEntityColors": {
        "Fragile": "#b16214",
        "Non-fragile": "#970046",
        "Extreme Fragility": "#b13507"
    }
}
2749 average-weekly-hours-worked-per-person-by-age-group-united-states LineChart 
{
    "id": 2749,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval"
        }
    },
    "slug": "average-weekly-hours-worked-per-person-by-age-group-united-states",
    "title": "Weekly hours worked by age group, United States",
    "yAxis": {
        "max": 50,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 6,
    "subtitle": "The average hours worked per person per week in the United States, aged 14 and above.",
    "originUrl": "ourworldindata.org/working-hours",
    "dimensions": [
        {
            "display": {
                "unit": "average weekly hours worked per person",
                "shortUnit": "hours",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 97536
        }
    ],
    "entityType": "age group",
    "isPublished": true,
    "entityTypePlural": "age groups",
    "selectedEntityNames": [
        "Ages 14+ (male)",
        "Ages 14+ (female)",
        "Ages 14+ (total)"
    ]
}
 2018-06-06 10:44:04 2024-04-08 12:13:54 2023-04-26 12:54:49 2018-06-06 10:44:04 Lars Yencken 55 Diana Beltekian 19 1 Weekly hours worked by age group, United States The average hours worked per person per week in the United States, aged 14 and above.   Weekly hours worked by age group, United States () 
{
    "$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": 6,
    "logo": "owid",
    "entityType": "age group",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-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": "age groups",
    "missingDataStrategy": "auto",
    "id": 2749,
    "slug": "average-weekly-hours-worked-per-person-by-age-group-united-states",
    "title": "Weekly hours worked by age group, United States",
    "subtitle": "The average hours worked per person per week in the United States, aged 14 and above.",
    "originUrl": "ourworldindata.org/working-hours",
    "dimensions": [
        {
            "display": {
                "unit": "average weekly hours worked per person",
                "shortUnit": "hours",
                "includeInTable": true
            },
            "property": "y",
            "variableId": 97536
        }
    ],
    "selectedEntityNames": [
        "Ages 14+ (male)",
        "Ages 14+ (female)",
        "Ages 14+ (total)"
    ]
}

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "charts" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"slug" VARCHAR(255) NULL  ,
	"type" VARCHAR(255) NULL  ,
	"config" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"lastEditedAt" DATETIME NOT NULL  ,
	"publishedAt" DATETIME NULL  ,
	"lastEditedByUserId" INTEGER NOT NULL  ,
	"publishedByUserId" INTEGER NULL  ,
	"isIndexable" TINYINT NOT NULL DEFAULT '0', title TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.title'))  VIRTUAL, subtitle TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.subtitle'))  VIRTUAL, note TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.note'))  VIRTUAL, title_plus_variant GENERATED ALWAYS as (printf("%s (%s)", title, json_extract(config, "$.variantName"))) VIRTUAL, configWithDefaults json,
	FOREIGN KEY("lastEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("publishedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "charts_lastEditedByUserId" ON "charts" ("lastEditedByUserId");
CREATE INDEX "charts_publishedByUserId" ON "charts" ("publishedByUserId");
CREATE INDEX "charts_slug" ON "charts" ("slug");
CREATE INDEX idx_title_plus_variant ON charts(title_plus_variant);