Earnings Data by Area
Provides earnings statistics by geographic area drawn from the Annual Survey of Hours and Earnings (ASHE), published by the Office for National Statistics (ONS). Accessed via the Nomis API, the dataset covers indicators such as pay by sex and by earnings component (e.g. gross pay, hourly pay), broken down across UK geographies. Data is delivered as CSV through parameterised queries specifying geography, sex, item and pay measures, supporting analysis of wage levels and differentials across local areas of the United Kingdom.”Earnings data from the Annual Survey of Hours and Earnings, ONS
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (40 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| DATE | int | — |
| DATE_NAMEDate name | int | — |
| DATE_CODEDate code | int | — |
| DATE_TYPEDate type | text | — |
| DATE_TYPECODEDate typecode | int | — |
| DATE_SORTORDERDate sortorder | int | — |
| GEOGRAPHY | int | — |
| GEOGRAPHY_NAMEGeography name | text | — |
| GEOGRAPHY_CODEGeography code | text | — |
| GEOGRAPHY_TYPEGeography type | text | — |
| GEOGRAPHY_TYPECODEGeography typecode | int | — |
| GEOGRAPHY_SORTORDERGeography sortorder | int | — |
| SEX | int | — |
| SEX_NAMESex name | text | — |
| SEX_CODESex code | int | — |
| SEX_TYPESex type | text | — |
| SEX_TYPECODESex typecode | int | — |
| SEX_SORTORDERSex sortorder | int | — |
| PAY | int | — |
| PAY_NAMEPay name | text | — |
| PAY_CODEPay code | int | — |
| PAY_TYPEPay type | text | — |
| PAY_TYPECODEPay typecode | int | — |
| PAY_SORTORDERPay sortorder | int | — |
| ITEM | int | — |
| ITEM_NAMEItem name | text | — |
| ITEM_CODEItem code | int | — |
| ITEM_TYPEItem type | text | — |
| ITEM_TYPECODEItem typecode | int | — |
| ITEM_SORTORDERItem sortorder | int | — |
| MEASURES | int | — |
| MEASURES_NAMEMeasures name | text | — |
| OBS_VALUEValue | text | — |
| OBS_STATUSStatus | text | — |
| OBS_STATUS_NAMEObs status name | text | — |
| OBS_CONFObs conf | text | — |
| OBS_CONF_NAMEObs conf name | text | — |
| URN | text | — |
| RECORD_OFFSETRecord offset | int | — |
| RECORD_COUNTRecord count | int | — |
Schema captured from ckan 24 days ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1PAY: 1 · SEX: 1
{
"PAY": "1",
"SEX": "1",
"URN": "Nm-30d1d32032e0d1941962793d1d1d2d20100",
"DATE": "2002",
"ITEM": "2",
"MEASURES": "20100",
"OBS_CONF": "F",
"PAY_CODE": "1",
"PAY_NAME": "Weekly pay - gross",
"PAY_TYPE": "item",
"SEX_CODE": "1",
"SEX_NAME": "Male Full Time Workers",
"SEX_TYPE": "sex",
"DATE_CODE": "2002",
"DATE_NAME": "2002",
"DATE_TYPE": "date",
"GEOGRAPHY": "1941962793",
"ITEM_CODE": "2",
"ITEM_NAME": "Median",
"ITEM_TYPE": "item",
"OBS_VALUE": "",
"OBS_STATUS": "Q",
"PAY_TYPECODE": "0",
"RECORD_COUNT": "21120",
"SEX_TYPECODE": "0",
"DATE_TYPECODE": "0",
"ITEM_TYPECODE": "0",
"MEASURES_NAME": "Value",
"OBS_CONF_NAME": "Free (free for publication)",
"PAY_SORTORDER": "0",
"RECORD_OFFSET": "0",
"SEX_SORTORDER": "0",
"DATE_SORTORDER": "0",
"GEOGRAPHY_CODE": "E10000023",
"GEOGRAPHY_NAME": "North Yorkshire",
"GEOGRAPHY_TYPE": "local authorities: county / unitary (prior to April 2015)",
"ITEM_SORTORDER": "0",
"OBS_STATUS_NAME": "These figures are missing.",
"GEOGRAPHY_TYPECODE": "463",
"GEOGRAPHY_SORTORDER": "0"
}Record 2PAY: 1 · SEX: 1
{
"PAY": "1",
"SEX": "1",
"URN": "Nm-30d1d32032e0d1941962793d1d1d2d20701",
"DATE": "2002",
"ITEM": "2",
"MEASURES": "20701",
"OBS_CONF": "F",
"PAY_CODE": "1",
"PAY_NAME": "Weekly pay - gross",
"PAY_TYPE": "item",
"SEX_CODE": "1",
"SEX_NAME": "Male Full Time Workers",
"SEX_TYPE": "sex",
"DATE_CODE": "2002",
"DATE_NAME": "2002",
"DATE_TYPE": "date",
"GEOGRAPHY": "1941962793",
"ITEM_CODE": "2",
"ITEM_NAME": "Median",
"ITEM_TYPE": "item",
"OBS_VALUE": "",
"OBS_STATUS": "Q",
"PAY_TYPECODE": "0",
"RECORD_COUNT": "21120",
"SEX_TYPECODE": "0",
"DATE_TYPECODE": "0",
"ITEM_TYPECODE": "0",
"MEASURES_NAME": "Confidence",
"OBS_CONF_NAME": "Free (free for publication)",
"PAY_SORTORDER": "0",
"RECORD_OFFSET": "1",
"SEX_SORTORDER": "0",
"DATE_SORTORDER": "0",
"GEOGRAPHY_CODE": "E10000023",
"GEOGRAPHY_NAME": "North Yorkshire",
"GEOGRAPHY_TYPE": "local authorities: county / unitary (prior to April 2015)",
"ITEM_SORTORDER": "0",
"OBS_STATUS_NAME": "These figures are missing.",
"GEOGRAPHY_TYPECODE": "463",
"GEOGRAPHY_SORTORDER": "0"
}Record 3PAY: 1 · SEX: 1
{
"PAY": "1",
"SEX": "1",
"URN": "Nm-30d1d32032e0d1941962793d1d1d6d20100",
"DATE": "2002",
"ITEM": "6",
"MEASURES": "20100",
"OBS_CONF": "F",
"PAY_CODE": "1",
"PAY_NAME": "Weekly pay - gross",
"PAY_TYPE": "item",
"SEX_CODE": "1",
"SEX_NAME": "Male Full Time Workers",
"SEX_TYPE": "sex",
"DATE_CODE": "2002",
"DATE_NAME": "2002",
"DATE_TYPE": "date",
"GEOGRAPHY": "1941962793",
"ITEM_CODE": "6",
"ITEM_NAME": "10 percentile",
"ITEM_TYPE": "item",
"OBS_VALUE": "",
"OBS_STATUS": "Q",
"PAY_TYPECODE": "0",
"RECORD_COUNT": "21120",
"SEX_TYPECODE": "0",
"DATE_TYPECODE": "0",
"ITEM_TYPECODE": "0",
"MEASURES_NAME": "Value",
"OBS_CONF_NAME": "Free (free for publication)",
"PAY_SORTORDER": "0",
"RECORD_OFFSET": "2",
"SEX_SORTORDER": "0",
"DATE_SORTORDER": "0",
"GEOGRAPHY_CODE": "E10000023",
"GEOGRAPHY_NAME": "North Yorkshire",
"GEOGRAPHY_TYPE": "local authorities: county / unitary (prior to April 2015)",
"ITEM_SORTORDER": "1",
"OBS_STATUS_NAME": "These figures are missing.",
"GEOGRAPHY_TYPECODE": "463",
"GEOGRAPHY_SORTORDER": "0"
}Record 4PAY: 1 · SEX: 1
{
"PAY": "1",
"SEX": "1",
"URN": "Nm-30d1d32032e0d1941962793d1d1d6d20701",
"DATE": "2002",
"ITEM": "6",
"MEASURES": "20701",
"OBS_CONF": "F",
"PAY_CODE": "1",
"PAY_NAME": "Weekly pay - gross",
"PAY_TYPE": "item",
"SEX_CODE": "1",
"SEX_NAME": "Male Full Time Workers",
"SEX_TYPE": "sex",
"DATE_CODE": "2002",
"DATE_NAME": "2002",
"DATE_TYPE": "date",
"GEOGRAPHY": "1941962793",
"ITEM_CODE": "6",
"ITEM_NAME": "10 percentile",
"ITEM_TYPE": "item",
"OBS_VALUE": "",
"OBS_STATUS": "Q",
"PAY_TYPECODE": "0",
"RECORD_COUNT": "21120",
"SEX_TYPECODE": "0",
"DATE_TYPECODE": "0",
"ITEM_TYPECODE": "0",
"MEASURES_NAME": "Confidence",
"OBS_CONF_NAME": "Free (free for publication)",
"PAY_SORTORDER": "0",
"RECORD_OFFSET": "3",
"SEX_SORTORDER": "0",
"DATE_SORTORDER": "0",
"GEOGRAPHY_CODE": "E10000023",
"GEOGRAPHY_NAME": "North Yorkshire",
"GEOGRAPHY_TYPE": "local authorities: county / unitary (prior to April 2015)",
"ITEM_SORTORDER": "1",
"OBS_STATUS_NAME": "These figures are missing.",
"GEOGRAPHY_TYPECODE": "463",
"GEOGRAPHY_SORTORDER": "0"
}Record 5PAY: 1 · SEX: 1
{
"PAY": "1",
"SEX": "1",
"URN": "Nm-30d1d32032e0d1941962793d1d1d7d20100",
"DATE": "2002",
"ITEM": "7",
"MEASURES": "20100",
"OBS_CONF": "F",
"PAY_CODE": "1",
"PAY_NAME": "Weekly pay - gross",
"PAY_TYPE": "item",
"SEX_CODE": "1",
"SEX_NAME": "Male Full Time Workers",
"SEX_TYPE": "sex",
"DATE_CODE": "2002",
"DATE_NAME": "2002",
"DATE_TYPE": "date",
"GEOGRAPHY": "1941962793",
"ITEM_CODE": "7",
"ITEM_NAME": "20 percentile",
"ITEM_TYPE": "item",
"OBS_VALUE": "",
"OBS_STATUS": "Q",
"PAY_TYPECODE": "0",
"RECORD_COUNT": "21120",
"SEX_TYPECODE": "0",
"DATE_TYPECODE": "0",
"ITEM_TYPECODE": "0",
"MEASURES_NAME": "Value",
"OBS_CONF_NAME": "Free (free for publication)",
"PAY_SORTORDER": "0",
"RECORD_OFFSET": "4",
"SEX_SORTORDER": "0",
"DATE_SORTORDER": "0",
"GEOGRAPHY_CODE": "E10000023",
"GEOGRAPHY_NAME": "North Yorkshire",
"GEOGRAPHY_TYPE": "local authorities: county / unitary (prior to April 2015)",
"ITEM_SORTORDER": "2",
"OBS_STATUS_NAME": "These figures are missing.",
"GEOGRAPHY_TYPECODE": "463",
"GEOGRAPHY_SORTORDER": "0"
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -s 'https://data.gov.uk/api/3/action/package_show?id=earnings-data-by-area' -H 'Accept: application/json'Full CKAN dataset record: resources, licence, organization, freshness.
Dataset
Volume & freshness
License
No license declared upstream.
Distributions (1)
Source: ckan · Open original page
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.