charts: 7235

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

id slug type config createdAt updatedAt lastEditedAt publishedAt lastEditedByUserId publishedByUserId isIndexable title subtitle note title_plus_variant configWithDefaults
7235 european-overseas-colonies-and-their-colonizers LineChart 
{
    "id": 7235,
    "map": {
        "time": 1914,
        "colorScale": {
            "baseColorScheme": "Paired",
            "binningStrategy": "manual",
            "customCategoryColors": {
                "Italy": "#ff9da7",
                "Spain": "#59a14f",
                "France": "#b07aa1",
                "Belgium": "#76b7b2",
                "Germany": "#9c755f",
                "Portugal": "#edc948",
                "Netherlands": "#f28e2b",
                "zz. Colonizer": "#e15759",
                "United Kingdom": "#4e79a7",
                "zzz. Not colonized": "#f3e2da",
                "z. Multiple colonizers": "#76d472",
                "zzzz. No longer colonized": "#ffbc71"
            },
            "customCategoryLabels": {
                "zz. Colonizer": "Colonizer",
                "zzz. Not colonized": "Not colonized",
                "z. Multiple colonizers": "Multiple colonizers",
                "zzzz. No longer colonized": "No longer colonized"
            },
            "customNumericColorsActive": true
        },
        "tooltipUseCustomLabels": true
    },
    "tab": "map",
    "slug": "european-overseas-colonies-and-their-colonizers",
    "title": "European overseas colonies and their colonizers over time",
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 27,
    "subtitle": "Only countries that are independent today are considered. Current country borders are used across time.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/state-capacity",
    "dimensions": [
        {
            "property": "y",
            "variableId": 814888
        }
    ],
    "hasChartTab": false,
    "isPublished": true,
    "selectedEntityNames": [
        "Ghana",
        "Saint Kitts and Nevis",
        "Myanmar",
        "Saint Vincent and the Grenadines"
    ]
}
 2023-10-05 09:07:36 2024-04-08 12:13:54 2023-11-30 14:16:34 2023-10-06 14:06:41 51 62 1 European overseas colonies and their colonizers over time Only countries that are independent today are considered. Current country borders are used across time.   European overseas colonies and their colonizers over time () 
{
    "$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": "map",
    "matchingEntitiesOnly": false,
    "hasChartTab": false,
    "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": 27,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "compareEndPointsOnly": false,
    "type": "LineChart",
    "hasMapTab": true,
    "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": 7235,
    "slug": "european-overseas-colonies-and-their-colonizers",
    "title": "European overseas colonies and their colonizers over time",
    "subtitle": "Only countries that are independent today are considered. Current country borders are used across time.",
    "originUrl": "ourworldindata.org/state-capacity",
    "dimensions": [
        {
            "property": "y",
            "variableId": 814888
        }
    ],
    "selectedEntityNames": [
        "Ghana",
        "Saint Kitts and Nevis",
        "Myanmar",
        "Saint Vincent and the Grenadines"
    ]
}

Links from other tables