charts: 368

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
368 government-procurement-share-gdp LineChart 
{
    "id": 368,
    "map": {
        "time": 2007,
        "colorScale": {
            "baseColorScheme": "Reds",
            "binningStrategy": "equalInterval",
            "colorSchemeInvert": true,
            "legendDescription": "",
            "customNumericColorsActive": false
        },
        "columnSlug": "1444",
        "projection": "Europe",
        "timeTolerance": 1
    },
    "slug": "government-procurement-share-gdp",
    "title": "General government procurement as a percentage of GDP, OECD",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 6,
    "subtitle": "General government procurement is defined as the sum of intermediate consumption (e.g. accounting services), gross fixed capital formation (e.g. new roads) and social transfers in kind via market producers (purchases by general government of goods/services produced by markets and supplied to households). Figures include procurement for central, state and local governments.",
    "originUrl": "https://ourworldindata.org/government-spending",
    "dimensions": [
        {
            "display": {
                "name": "General government procurement expenditure (%GDP)",
                "unit": "% of GDP",
                "color": "#818282",
                "tolerance": 5,
                "isProjection": false,
                "includeInTable": true
            },
            "property": "y",
            "variableId": 1444
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "Colombia",
        "Greece",
        "Mexico",
        "Canada",
        "Netherlands"
    ]
}
 2016-10-21 18:31:19 2024-04-08 12:13:54 2023-12-18 11:54:23 2016-10-21 18:31:19 46   1 General government procurement as a percentage of GDP, OECD General government procurement is defined as the sum of intermediate consumption (e.g. accounting services), gross fixed capital formation (e.g. new roads) and social transfers in kind via market producers (purchases by general government of goods/services produced by markets and supplied to households). Figures include procurement for central, state and local governments.   General government procurement as a percentage of GDP, OECD () 
{
    "$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": 6,
    "logo": "owid",
    "entityType": "country or region",
    "facettingLabelByYVariables": "metric",
    "addCountryMode": "add-country",
    "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": 368,
    "slug": "government-procurement-share-gdp",
    "title": "General government procurement as a percentage of GDP, OECD",
    "subtitle": "General government procurement is defined as the sum of intermediate consumption (e.g. accounting services), gross fixed capital formation (e.g. new roads) and social transfers in kind via market producers (purchases by general government of goods/services produced by markets and supplied to households). Figures include procurement for central, state and local governments.",
    "originUrl": "https://ourworldindata.org/government-spending",
    "dimensions": [
        {
            "display": {
                "name": "General government procurement expenditure (%GDP)",
                "unit": "% of GDP",
                "color": "#818282",
                "tolerance": 5,
                "isProjection": false,
                "includeInTable": true
            },
            "property": "y",
            "variableId": 1444
        }
    ],
    "selectedEntityNames": [
        "Colombia",
        "Greece",
        "Mexico",
        "Canada",
        "Netherlands"
    ]
}

Links from other tables