charts: 5209

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
5209
 8533
 01957561-67f3-7ecb-b39d-1a5157910da6
 False
 2025-03-08 10:51:12
 2025-03-10 10:11:56
 2025-03-10 10:11:56
   62
   False
 
{"id": 8533, "note": "", "slug": "china-tops-official-financing-to-developing-countries-2014-2021", "title": "China tops official financing to developing countries, 2014-2021", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 3, "subtitle": "Official financial flows from China and the G7 to the developing world. This data is expressed in 2021 US dollars.", "originUrl": "https://www.aiddata.org/publications/belt-and-road-reboot", "chartTypes": ["StackedDiscreteBar"], "dimensions": [{"display": {"unit": "$", "includeInTable": true, "conversionFactor": 1000000000, "numDecimalPlaces": 0}, "property": "y", "variableId": 1014844}, {"display": {"unit": "$", "color": "#00295b", "includeInTable": true, "conversionFactor": 1000000000, "numDecimalPlaces": 0}, "property": "y", "variableId": 1014845}, {"display": {"unit": "$", "includeInTable": true, "conversionFactor": 1000000000, "numDecimalPlaces": 0}, "property": "y", "variableId": 1014846}], "sourceDesc": "AidData (2023)", "isPublished": false, "selectedEntityNames": ["Italy", "China", "Canada", "France", "Japan", "Germany", "United Kingdom", "United States"], "hideAnnotationFieldsInTitle": {"time": true}}
 china-tops-official-financing-to-developing-countries-2014-2021
 StackedDiscreteBar
 China tops official financing to developing countries, 2014-2021
 Official financial flows from China and the G7 to the developing world. This data is expressed in 2021 US dollars.
     False