charts: 5225

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
5225
 8553
 0195a900-db62-706c-8e98-37fc18d9f833
 True
 2025-03-18 11:26:00
   2025-03-18 11:26:01
   80
   False
 
{"id": 8553, "yAxis": {"min": 0}, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "minTime": 2015, "version": 6, "subtitle": "This data is adjusted for inflation.", "chartTypes": ["LineChart", "SlopeChart"], "dimensions": [{"display": {"name": "House price index, 2015 = 100", "roundingMode": "significantFigures", "includeInTable": true}, "property": "y", "variableId": 1015598}], "isPublished": false, "selectedEntityNames": ["Germany", "France", "Italy", "Spain", "Poland", "Romania", "Netherlands", "Belgium", "Czechia", "Sweden", "Portugal", "Greece"], "selectedFacetStrategy": "entity"}
   LineChart
   This data is adjusted for inflation.
     False