charts: 4703

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.

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
4703	7887	0191b6c7-59ed-7137-a565-460f268a7f70	False	2024-06-16 06:42:20	2024-09-05 09:00:28	2024-06-16 06:49:26		10		False	{"id": 7887, "note": "Data points above the 45-degree line saw rising inequality. For example, the top 1% share in India was 12% around 1993, and 23% around 2018. Data points below the line saw falling inequality. For example, the top 1% share in Ethiopia was 30% around 1993, and 14% around 2018.", "slug": "joe-phd-draft-top1p-wid-data-1993-vs-2018", "title": "Joe PhD Draft: Top 1% share (WID data) 1993 vs 2018", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 2, "chartTypes": ["ScatterPlot"], "dimensions": [{"display": {"name": "Around 2018", "unit": "", "shortUnit": "%", "includeInTable": true}, "property": "y", "variableId": 935522}, {"display": {"name": "Around 1993", "shortUnit": "%", "includeInTable": true}, "property": "x", "variableId": 935524}, {"property": "size", "variableId": 935497}, {"property": "color", "variableId": 935496}], "sourceDesc": "", "isPublished": false, "comparisonLines": [{"yEquals": "x"}], "matchingEntitiesOnly": true, "hideAnnotationFieldsInTitle": {"time": true}}	joe-phd-draft-top1p-wid-data-1993-vs-2018	ScatterPlot	Joe PhD Draft: Top 1% share (WID data) 1993 vs 2018		Data points above the 45-degree line saw rising inequality. For example, the top 1% share in India was 12% around 1993, and 23% around 2018. Data points below the line saw falling inequality. For example, the top 1% share in Ethiopia was 30% around 1993, and 14% around 2018.		False

rowid

configId

isInheritanceEnabled

createdAt

updatedAt

lastEditedAt

publishedAt

lastEditedByUserId

publishedByUserId

isIndexable

config

slug

type

title

subtitle

note

title_plus_variant

isPublished

4703

7887

0191b6c7-59ed-7137-a565-460f268a7f70

False

2024-06-16 06:42:20

2024-09-05 09:00:28

2024-06-16 06:49:26

False

{"id": 7887, "note": "Data points above the 45-degree line saw rising inequality. For example, the top 1% share in India was 12% around 1993, and 23% around 2018. Data points below the line saw falling inequality. For example, the top 1% share in Ethiopia was 30% around 1993, and 14% around 2018.", "slug": "joe-phd-draft-top1p-wid-data-1993-vs-2018", "title": "Joe PhD Draft: Top 1% share (WID data) 1993 vs 2018", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 2, "chartTypes": ["ScatterPlot"], "dimensions": [{"display": {"name": "Around 2018", "unit": "", "shortUnit": "%", "includeInTable": true}, "property": "y", "variableId": 935522}, {"display": {"name": "Around 1993", "shortUnit": "%", "includeInTable": true}, "property": "x", "variableId": 935524}, {"property": "size", "variableId": 935497}, {"property": "color", "variableId": 935496}], "sourceDesc": "", "isPublished": false, "comparisonLines": [{"yEquals": "x"}], "matchingEntitiesOnly": true, "hideAnnotationFieldsInTitle": {"time": true}}

joe-phd-draft-top1p-wid-data-1993-vs-2018

ScatterPlot

Joe PhD Draft: Top 1% share (WID data) 1993 vs 2018

Data points above the 45-degree line saw rising inequality. For example, the top 1% share in India was 12% around 1993, and 23% around 2018. Data points below the line saw falling inequality. For example, the top 1% share in Ethiopia was 30% around 1993, and 14% around 2018.

False