charts

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

1 row where publishedByUserId = 66 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date), lastEditedAt (date), publishedAt (date)

id ▲ slug type config createdAt updatedAt lastEditedAt publishedAt lastEditedByUserId publishedByUserId isIndexable title subtitle note title_plus_variant configWithDefaults
6924 urban-population-vs-female-labor-force-participation-rate ScatterPlot 
{
    "id": 6924,
    "note": "Urban populations are defined based on the definition of urban areas by national statistical offices.",
    "slug": "urban-population-vs-female-labor-force-participation-rate",
    "type": "ScatterPlot",
    "title": "Urban population vs. female labor force participation rate",
    "xAxis": {
        "max": 100,
        "min": 0
    },
    "yAxis": {
        "max": 100,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "minTime": 2022,
    "version": 7,
    "subtitle": "Share of the total population living in urban areas versus the proportion of the female population aged 15 and older that is economically active.",
    "originUrl": "https://ourworldindata.org/economic-growth",
    "dimensions": [
        {
            "display": {
                "name": "Urban population"
            },
            "property": "y",
            "variableId": 906167
        },
        {
            "display": {
                "name": "Female labor force participation rate",
                "shortUnit": "%"
            },
            "property": "x",
            "variableId": 906020
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ],
    "isPublished": true
}
 2023-07-04 12:48:35 2024-07-17 09:56:53 2024-07-17 09:56:53 2023-07-04 12:49:56 Pablo Rosado 58 Natasha Ahuja 66 1 Urban population vs. female labor force participation rate Share of the total population living in urban areas versus the proportion of the female population aged 15 and older that is economically active. Urban populations are defined based on the definition of urban areas by national statistical offices. Urban population vs. female labor force participation rate () 
{
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "map": {
        "projection": "World",
        "hideTimeline": false,
        "colorScale": {
            "baseColorScheme": "default",
            "equalSizeBins": true,
            "binningStrategy": "ckmeans",
            "customNumericColorsActive": false,
            "colorSchemeInvert": false,
            "binningStrategyBinCount": 5
        },
        "timeTolerance": 0,
        "toleranceStrategy": "closest",
        "tooltipUseCustomLabels": false,
        "time": "latest"
    },
    "maxTime": "latest",
    "baseColorScheme": "default",
    "yAxis": {
        "removePointsOutsideDomain": false,
        "scaleType": "linear",
        "canChangeScaleType": false,
        "facetDomain": "shared"
    },
    "tab": "chart",
    "matchingEntitiesOnly": false,
    "hasChartTab": true,
    "hideLegend": false,
    "hideLogo": false,
    "hideTimeline": false,
    "colorScale": {
        "baseColorScheme": "default",
        "equalSizeBins": true,
        "binningStrategy": "ckmeans",
        "customNumericColorsActive": false,
        "colorSchemeInvert": false,
        "binningStrategyBinCount": 5
    },
    "scatterPointLabelStrategy": "year",
    "selectedFacetStrategy": "none",
    "isPublished": true,
    "invertColorScheme": false,
    "version": 7,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "ScatterPlot",
    "hasMapTab": false,
    "stackMode": "absolute",
    "minTime": 2022,
    "hideAnnotationFieldsInTitle": {
        "entity": false,
        "time": false,
        "changeInPrefix": false
    },
    "xAxis": {
        "removePointsOutsideDomain": false,
        "scaleType": "linear",
        "canChangeScaleType": false,
        "facetDomain": "shared"
    },
    "hideConnectedScatterLines": false,
    "showNoDataArea": true,
    "zoomToSelection": false,
    "showYearLabels": false,
    "hideLinesOutsideTolerance": false,
    "hideTotalValueLabel": false,
    "hideScatterLabels": false,
    "sortBy": "total",
    "sortOrder": "desc",
    "hideFacetControl": true,
    "entityTypePlural": "countries",
    "missingDataStrategy": "auto",
    "id": 6924,
    "note": "Urban populations are defined based on the definition of urban areas by national statistical offices.",
    "slug": "urban-population-vs-female-labor-force-participation-rate",
    "title": "Urban population vs. female labor force participation rate",
    "subtitle": "Share of the total population living in urban areas versus the proportion of the female population aged 15 and older that is economically active.",
    "originUrl": "https://ourworldindata.org/economic-growth",
    "dimensions": [
        {
            "display": {
                "name": "Urban population"
            },
            "property": "y",
            "variableId": 906167
        },
        {
            "display": {
                "name": "Female labor force participation rate",
                "shortUnit": "%"
            },
            "property": "x",
            "variableId": 906020
        },
        {
            "property": "size",
            "variableId": 953903
        },
        {
            "property": "color",
            "variableId": 123
        }
    ]
}

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "charts" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"slug" VARCHAR(255) NULL  ,
	"type" VARCHAR(255) NULL  ,
	"config" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"lastEditedAt" DATETIME NOT NULL  ,
	"publishedAt" DATETIME NULL  ,
	"lastEditedByUserId" INTEGER NOT NULL  ,
	"publishedByUserId" INTEGER NULL  ,
	"isIndexable" TINYINT NOT NULL DEFAULT '0', title TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.title'))  VIRTUAL, subtitle TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.subtitle'))  VIRTUAL, note TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.note'))  VIRTUAL, title_plus_variant GENERATED ALWAYS as (printf("%s (%s)", title, json_extract(config, "$.variantName"))) VIRTUAL, configWithDefaults json,
	FOREIGN KEY("lastEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("publishedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "charts_lastEditedByUserId" ON "charts" ("lastEditedByUserId");
CREATE INDEX "charts_publishedByUserId" ON "charts" ("publishedByUserId");
CREATE INDEX "charts_slug" ON "charts" ("slug");
CREATE INDEX idx_title_plus_variant ON charts(title_plus_variant);