charts: 2223

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
2223
 4091
 0191b6c7-4705-743d-b282-ef40fe75ea86
 False
 2020-04-06 22:20:45
 2024-11-15 17:27:16
 2024-11-15 17:27:16
 2020-04-06 22:20:45
 74
 10
 True
 
{"id": 4091, "map": {"colorScale": {"binningStrategy": "equalInterval"}}, "slug": "covid-19-total-confirmed-cases-vs-total-tests-conducted", "title": "Total COVID-19 tests conducted vs. confirmed cases", "xAxis": {"scaleType": "log", "canChangeScaleType": true}, "yAxis": {"min": 0, "scaleType": "log", "canChangeScaleType": true}, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "minTime": "latest", "version": 3538, "subtitle": "Comparisons across countries are affected by differences in testing policies and reporting methods.", "originUrl": "https://ourworldindata.org/coronavirus", "chartTypes": ["ScatterPlot"], "colorScale": {"binningStrategy": "equalInterval"}, "dimensions": [{"display": {"unit": "tests", "tolerance": 2}, "property": "y", "variableId": 984179}, {"display": {"tolerance": 2}, "property": "x", "variableId": 954528}, {"property": "color", "variableId": 900801}], "isPublished": true, "comparisonLines": [{"label": "10x", "yEquals": "10*x"}, {"label": "2x", "yEquals": "2*x"}, {"label": "5x", "yEquals": "5*x"}, {"label": "20x", "yEquals": "20*x"}, {"label": "50x", "yEquals": "50*x"}, {"label": "100x", "yEquals": "100*x"}, {"label": "200x", "yEquals": "200*x"}, {"label": "400x", "yEquals": "400*x"}, {"label": "Number of tests = Number of cases", "yEquals": "x"}], "excludedEntityNames": ["Peru", "Ecuador"]}
 covid-19-total-confirmed-cases-vs-total-tests-conducted
 ScatterPlot
 Total COVID-19 tests conducted vs. confirmed cases
 Comparisons across countries are affected by differences in testing policies and reporting methods.
     True