charts: 3854

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
3854
 6623
 0191b6c7-5341-7328-95bc-7aa3c37d4f41
 False
 2023-05-03 12:32:11
 2024-09-05 09:00:28
 2024-03-06 20:46:57
 2023-05-31 10:32:02
 59
 50
 True
 
{"id": 6623, "map": {"colorScale": {"baseColorScheme": "YlOrRd", "binningStrategy": "manual", "customNumericValues": [0.1, 0.2, 0.5, 1, 2, 5, 10, 1], "binningStrategyBinCount": 10}, "columnSlug": "467734", "hideTimeline": true, "timeTolerance": 10}, "tab": "map", "note": "Data points are taken as single-year observations between 2013 and 2017, depending on the country.", "slug": "mental-health-units-in-general-hospitals", "title": "Mental health units in general hospitals", "yAxis": {"min": 0}, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 22, "subtitle": "Shown as the number of mental health units in general hospitals per 100,000 people in the population.", "hasMapTab": true, "originUrl": "ourworldindata.org/mental-health", "chartTypes": ["DiscreteBar"], "dimensions": [{"display": {"shortUnit": "", "tolerance": 10, "numDecimalPlaces": 1}, "property": "y", "variableId": 828314}], "isPublished": true, "selectedEntityNames": ["Ireland", "Norway", "United States", "Japan", "Niger", "Brazil", "Romania", "Ghana", "India", "Kenya"]}
 mental-health-units-in-general-hospitals
 DiscreteBar
 Mental health units in general hospitals
 Shown as the number of mental health units in general hospitals per 100,000 people in the population.
 Data points are taken as single-year observations between 2013 and 2017, depending on the country.
   True