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 lastEditedByUserId = 13 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
1180 what-percentage-of-the-us-public-approves-of-working-wives LineChart 
{
    "id": 1180,
    "map": {
        "colorScale": {
            "binningStrategy": "equalInterval",
            "customNumericColors": [],
            "customNumericLabels": [],
            "customNumericValues": [],
            "customCategoryColors": {},
            "customCategoryLabels": {},
            "customHiddenCategories": {}
        },
        "projection": "World"
    },
    "tab": "chart",
    "note": "In some years, the poll question varied slightly. For example, in 1936 participants were asked: \"Should a married woman earn money if she has a husband capable of supporting her?\" All variations of the survey question, which itself reveals social norms of the time, stopped being asked after 1998.",
    "slug": "what-percentage-of-the-us-public-approves-of-working-wives",
    "type": "LineChart",
    "title": "What percentage of the US public approves of working wives?",
    "xAxis": {
        "scaleType": "linear"
    },
    "yAxis": {
        "max": 0,
        "min": 0,
        "scaleType": "linear"
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 2,
    "subtitle": "Displayed is the percentage of survey respondents who approved of wives working when asked the question: \"Do you approve or disapprove of a married woman earning money in business or industry if she has a husband capable of supporting her?\"",
    "hasMapTab": false,
    "originUrl": "https://ourworldindata.org/women-in-the-labor-force-determinants/",
    "stackMode": "absolute",
    "dimensions": [
        {
            "display": {
                "color": "#ca2628"
            },
            "property": "y",
            "variableId": 42463
        }
    ],
    "hasChartTab": true,
    "isPublished": true,
    "internalNotes": "",
    "addCountryMode": "disabled",
    "hideRelativeToggle": true,
    "selectedEntityNames": [
        "United States"
    ],
    "selectedEntityColors": {
        "United States": "#ca2628"
    },
    "hideAnnotationFieldsInTitle": {
        "time": true,
        "entity": true,
        "changeInPrefix": true
    }
}
 2017-09-19 14:19:55 2024-04-08 12:13:54 2017-10-07 17:18:40 2017-09-19 14:19:55 Sandra Tzvetkova 13   1 What percentage of the US public approves of working wives? Displayed is the percentage of survey respondents who approved of wives working when asked the question: "Do you approve or disapprove of a married woman earning money in business or industry if she has a husband capable of supporting her?" In some years, the poll question varied slightly. For example, in 1936 participants were asked: "Should a married woman earn money if she has a husband capable of supporting her?" All variations of the survey question, which itself reveals social norms of the time, stopped being asked after 1998. What percentage of the US public approves of working wives? () 
{
    "$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": 2,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "disabled",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": false,
    "stackMode": "absolute",
    "minTime": "earliest",
    "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": 1180,
    "note": "In some years, the poll question varied slightly. For example, in 1936 participants were asked: \"Should a married woman earn money if she has a husband capable of supporting her?\" All variations of the survey question, which itself reveals social norms of the time, stopped being asked after 1998.",
    "slug": "what-percentage-of-the-us-public-approves-of-working-wives",
    "title": "What percentage of the US public approves of working wives?",
    "subtitle": "Displayed is the percentage of survey respondents who approved of wives working when asked the question: \"Do you approve or disapprove of a married woman earning money in business or industry if she has a husband capable of supporting her?\"",
    "originUrl": "https://ourworldindata.org/women-in-the-labor-force-determinants/",
    "dimensions": [
        {
            "display": {
                "color": "#ca2628"
            },
            "property": "y",
            "variableId": 42463
        }
    ],
    "internalNotes": "",
    "hideRelativeToggle": true,
    "selectedEntityNames": [
        "United States"
    ],
    "selectedEntityColors": {
        "United States": "#ca2628"
    }
}

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);