charts: 1795

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
1795 average-hourly-earnings LineChart 
{
    "id": 1795,
    "map": {
        "colorScale": {
            "binningStrategy": "manual",
            "customNumericValues": [
                5,
                10,
                15,
                20,
                25,
                30,
                35
            ],
            "customNumericMinValue": 0
        },
        "columnSlug": "65660",
        "timeTolerance": 10
    },
    "tab": "map",
    "note": "This data is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices.",
    "slug": "average-hourly-earnings",
    "title": "Average hourly earnings of employees",
    "yAxis": {
        "max": 0,
        "min": 0
    },
    "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
    "version": 13,
    "subtitle": "Earnings are defined as in-cash and in-kind payments to employees at regular intervals for time worked or work done together with remuneration for time not worked, such as annual vacation, other paid leave, or holidays. This data is adjusted for inflation and differences in the cost of living between countries.",
    "hasMapTab": true,
    "originUrl": "https://ourworldindata.org/economic-inequality",
    "dimensions": [
        {
            "property": "y",
            "variableId": 65660
        }
    ],
    "sourceDesc": "ILOSTAT",
    "isPublished": true,
    "selectedEntityNames": [
        "Finland",
        "Slovakia",
        "Paraguay",
        "Argentina",
        "Brazil",
        "United Kingdom",
        "Spain"
    ]
}
 2017-12-12 16:23:27 2024-04-08 12:13:54 2023-07-07 11:38:58 2017-12-12 16:23:27 62   1 Average hourly earnings of employees Earnings are defined as in-cash and in-kind payments to employees at regular intervals for time worked or work done together with remuneration for time not worked, such as annual vacation, other paid leave, or holidays. This data is adjusted for inflation and differences in the cost of living between countries. This data is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices. Average hourly earnings of employees () 
{
    "$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": 13,
    "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": 1795,
    "note": "This data is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices.",
    "slug": "average-hourly-earnings",
    "title": "Average hourly earnings of employees",
    "subtitle": "Earnings are defined as in-cash and in-kind payments to employees at regular intervals for time worked or work done together with remuneration for time not worked, such as annual vacation, other paid leave, or holidays. This data is adjusted for inflation and differences in the cost of living between countries.",
    "originUrl": "https://ourworldindata.org/economic-inequality",
    "dimensions": [
        {
            "property": "y",
            "variableId": 65660
        }
    ],
    "sourceDesc": "ILOSTAT",
    "selectedEntityNames": [
        "Finland",
        "Slovakia",
        "Paraguay",
        "Argentina",
        "Brazil",
        "United Kingdom",
        "Spain"
    ]
}

Links from other tables