charts: 2013

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
2013 air-transport-freight-ton-km LineChart 
{
    "id": 2013,
    "map": {
        "colorScale": {
            "baseColorScheme": "YlGn",
            "binningStrategy": "manual",
            "customNumericColors": [
                null,
                null
            ],
            "customNumericValues": [
                10000000,
                30000000,
                100000000,
                300000000,
                1000000000,
                3000000000,
                10000000000,
                30000000000,
                100000000000
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "735477"
    },
    "tab": "map",
    "slug": "air-transport-freight-ton-km",
    "title": "Tonne-kilometers of air freight",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 15,
    "subtitle": "Air freight is the volume of freight, express, and diplomatic bags carried on each flight stage (operation of an aircraft from takeoff to its next landing), measured in metric tonnes times kilometers traveled.",
    "hasMapTab": true,
    "originUrl": "ourworldindata.org/trade-and-globalization",
    "dimensions": [
        {
            "display": {
                "unit": "tonne-km",
                "conversionFactor": 1000000
            },
            "property": "y",
            "variableId": 905333
        }
    ],
    "isPublished": true,
    "selectedEntityNames": [
        "Egypt",
        "Haiti",
        "Brazil",
        "Botswana",
        "Australia",
        "Chile",
        "Germany",
        "France"
    ]
}
 2018-02-02 12:52:49 2024-05-31 07:05:54 2024-05-31 07:05:54 2018-02-02 12:52:49 59 14 1 Tonne-kilometers of air freight Air freight is the volume of freight, express, and diplomatic bags carried on each flight stage (operation of an aircraft from takeoff to its next landing), measured in metric tonnes times kilometers traveled.   Tonne-kilometers of air freight () 
{
    "$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": 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": 15,
    "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": 2013,
    "slug": "air-transport-freight-ton-km",
    "title": "Tonne-kilometers of air freight",
    "subtitle": "Air freight is the volume of freight, express, and diplomatic bags carried on each flight stage (operation of an aircraft from takeoff to its next landing), measured in metric tonnes times kilometers traveled.",
    "originUrl": "ourworldindata.org/trade-and-globalization",
    "dimensions": [
        {
            "display": {
                "unit": "tonne-km",
                "conversionFactor": 1000000
            },
            "property": "y",
            "variableId": 905333
        }
    ],
    "selectedEntityNames": [
        "Egypt",
        "Haiti",
        "Brazil",
        "Botswana",
        "Australia",
        "Chile",
        "Germany",
        "France"
    ]
}

Links from other tables