charts: 369

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
369 gov-procurement-share-gov-expenditure LineChart 
{
    "id": 369,
    "map": {
        "time": 2000,
        "colorScale": {
            "baseColorScheme": "BuGn",
            "binningStrategy": "equalInterval",
            "colorSchemeInvert": false,
            "legendDescription": "",
            "customNumericColorsActive": false
        },
        "columnSlug": "1444",
        "timeTolerance": 1
    },
    "slug": "gov-procurement-share-gov-expenditure",
    "title": "Government procurement as share of government expenditure, OECD",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 8,
    "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 expenditures for central, state and local governments.",
    "originUrl": "https://ourworldindata.org/government-spending",
    "dimensions": [
        {
            "display": {
                "name": "General government procurement (% government expenditures)",
                "unit": "% of government spending",
                "color": "#818282",
                "tolerance": 5,
                "isProjection": false,
                "includeInTable": true
            },
            "property": "y",
            "variableId": 1445
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "Greece",
        "South Korea",
        "United States",
        "Netherlands",
        "United Kingdom"
    ]
}
 2016-10-21 18:33:24 2024-04-08 12:13:54 2023-12-18 11:54:28 2016-10-21 18:33:24 46   1 Government procurement as share of government expenditure, 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 expenditures for central, state and local governments.   Government procurement as share of government expenditure, 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": 8,
    "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": 369,
    "slug": "gov-procurement-share-gov-expenditure",
    "title": "Government procurement as share of government expenditure, 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 expenditures for central, state and local governments.",
    "originUrl": "https://ourworldindata.org/government-spending",
    "dimensions": [
        {
            "display": {
                "name": "General government procurement (% government expenditures)",
                "unit": "% of government spending",
                "color": "#818282",
                "tolerance": 5,
                "isProjection": false,
                "includeInTable": true
            },
            "property": "y",
            "variableId": 1445
        }
    ],
    "selectedEntityNames": [
        "Greece",
        "South Korea",
        "United States",
        "Netherlands",
        "United Kingdom"
    ]
}

Links from other tables