charts: 4699

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
4699	7873	0191b6c7-59e3-746e-a896-c2bab60a19b9	False	2024-06-14 07:54:15	2024-09-05 09:00:28	2024-06-14 08:03:39		10		False	{"id": 7873, "note": "Russia saw an 80% rise (i.e. percent, not percentage point) in the Top 1 % share in the WID data, and a 50% fall in the PIP data. Belgium saw a 50% rise in the PIP Top 1% share, and a 10% rise in the WID data.", "slug": "joe-phd-draft-percentage-change-in-top1share-1993-2018-wid-vs-pip", "title": "Joe PhD draft: Percentage change in Top 1% share 1993-2018, WID vs PIP", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 8, "chartTypes": ["ScatterPlot"], "dimensions": [{"display": {"name": "WID", "unit": "%", "shortUnit": "%", "includeInTable": true, "numDecimalPlaces": 1}, "property": "y", "variableId": 935495}, {"display": {"name": "PIP", "unit": "", "shortUnit": "%", "includeInTable": true, "numDecimalPlaces": 1}, "property": "x", "variableId": 935493}, {"property": "size", "variableId": 930575}, {"property": "color", "variableId": 930576}], "sourceDesc": "", "isPublished": false, "comparisonLines": [{"yEquals": "x"}]}	joe-phd-draft-percentage-change-in-top1share-1993-2018-wid-vs-pip	ScatterPlot	Joe PhD draft: Percentage change in Top 1% share 1993-2018, WID vs PIP		Russia saw an 80% rise (i.e. percent, not percentage point) in the Top 1 % share in the WID data, and a 50% fall in the PIP data. Belgium saw a 50% rise in the PIP Top 1% share, and a 10% rise in the WID data.		False

rowid

configId

isInheritanceEnabled

createdAt

updatedAt

lastEditedAt

publishedAt

lastEditedByUserId

publishedByUserId

isIndexable

config

slug

type

title

subtitle

note

title_plus_variant

isPublished

4699

7873

0191b6c7-59e3-746e-a896-c2bab60a19b9

False

2024-06-14 07:54:15

2024-09-05 09:00:28

2024-06-14 08:03:39

False

{"id": 7873, "note": "Russia saw an 80% rise (i.e. percent, not percentage point) in the Top 1 % share in the WID data, and a 50% fall in the PIP data. Belgium saw a 50% rise in the PIP Top 1% share, and a 10% rise in the WID data.", "slug": "joe-phd-draft-percentage-change-in-top1share-1993-2018-wid-vs-pip", "title": "Joe PhD draft: Percentage change in Top 1% share 1993-2018, WID vs PIP", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 8, "chartTypes": ["ScatterPlot"], "dimensions": [{"display": {"name": "WID", "unit": "%", "shortUnit": "%", "includeInTable": true, "numDecimalPlaces": 1}, "property": "y", "variableId": 935495}, {"display": {"name": "PIP", "unit": "", "shortUnit": "%", "includeInTable": true, "numDecimalPlaces": 1}, "property": "x", "variableId": 935493}, {"property": "size", "variableId": 930575}, {"property": "color", "variableId": 930576}], "sourceDesc": "", "isPublished": false, "comparisonLines": [{"yEquals": "x"}]}

joe-phd-draft-percentage-change-in-top1share-1993-2018-wid-vs-pip

ScatterPlot

Joe PhD draft: Percentage change in Top 1% share 1993-2018, WID vs PIP

Russia saw an 80% rise (i.e. percent, not percentage point) in the Top 1 % share in the WID data, and a 50% fall in the PIP data. Belgium saw a 50% rise in the PIP Top 1% share, and a 10% rise in the WID data.

False