charts: 5187

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

rowid id configId isInheritanceEnabled createdAt updatedAt lastEditedAt publishedAt lastEditedByUserId publishedByUserId isIndexable config slug type title subtitle note title_plus_variant isPublished
5187
 8505
 0195043a-db2d-7fb5-b005-544990439b27
 True
 2025-02-14 11:32:00
 2025-04-02 18:00:22
 2025-04-02 18:00:22
   62
   False
 
{"id": 8505, "slug": "government-expenditure-of-gdp", "title": "Government spending in nine rich countries: three grew, three stable, three shrank", "yAxis": {"min": 0}, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "minTime": 1980, "version": 5, "subtitle": "Government expenditure as a share of GDP, including interest expense.", "chartTypes": ["LineChart", "SlopeChart"], "dimensions": [{"display": {"roundingMode": "significantFigures", "numSignificantFigures": 2}, "property": "y", "variableId": 1025229}], "isPublished": false, "selectedEntityNames": ["France", "Italy", "Spain", "Germany", "United Kingdom", "United States", "Denmark", "Netherlands", "Norway"], "selectedFacetStrategy": "entity", "hideAnnotationFieldsInTitle": {"time": true}}
 government-expenditure-of-gdp
 LineChart
 Government spending in nine rich countries: three grew, three stable, three shrank
 Government expenditure as a share of GDP, including interest expense.
     False