charts: 5179

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
5179
 8495
 0194ec1c-a4ac-724a-ba26-dfbedde22ea3
 False
 2025-02-09 19:08:07
 2025-02-09 19:17:44
 2025-02-09 19:17:44
   80
   True
 
{"id": 8495, "note": "", "slug": "people-in-many-countries-are-pessimistic-about-housing", "title": "People in many countries are pessimistic about housing", "sortBy": "column", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 4, "subtitle": "\"In general, do you think that your country is on the right track or the wrong track when it comes to housing?\"", "stackMode": "relative", "chartTypes": ["StackedDiscreteBar"], "dimensions": [{"display": {"color": "#883039", "includeInTable": true}, "property": "y", "variableId": 1010206}, {"display": {"color": "#58ac8c", "includeInTable": true}, "property": "y", "variableId": 1010207}, {"display": {"color": "#6d3e91", "includeInTable": true}, "property": "y", "variableId": 1010208}], "isPublished": false, "sortColumnSlug": "1010206", "hideRelativeToggle": false, "selectedEntityNames": ["Chile", "Brazil", "Mexico", "United States", "Turkey", "Thailand", "Spain", "Sweden", "South Korea", "Singapore", "South Africa", "Poland", "Peru", "New Zealand", "Netherlands", "Malaysia", "Italy", "Japan", "Ireland", "India", "Indonesia", "Hungary", "Great Britain", "Germany", "France", "Colombia", "Canada", "Belgium", "Australia", "Argentina"]}
 people-in-many-countries-are-pessimistic-about-housing
 StackedDiscreteBar
 People in many countries are pessimistic about housing
 "In general, do you think that your country is on the right track or the wrong track when it comes to housing?"
     False