Earnings Data by Area

DatasetNational · United Kingdom

Earnings data from the Annual Survey of Hours and Earnings, ONS

salary

Trust score

fair

Composite of 5 axes from our methodology (proof-based officialness, live verification, metadata completeness, license clarity, agent readiness).

Officialnessweight 25%40/100
40/100 from 5 proof signals (domain / portal-backlink / GitHub-org / reciprocal / policy).
Availabilityweight 25%100/100
Latest verification succeeded.
Metadata completenessweight 20%38/100
5 of 13 recommended metadata fields populated.
License clarityweight 15%0/100
No license declared upstream.
Agent readinessweight 15%5/100
Landing page present

Official Proof

Public Sector API

Proof Evidence

official domain (gov.uk) (catalog: data_gov_uk)

Data schema (40 fields)

Field	Type	Description
DATE	int	—
DATE_NAME	int	—
DATE_CODE	int	—
DATE_TYPE	text	—
DATE_TYPECODE	int	—
DATE_SORTORDER	int	—
GEOGRAPHY	int	—
GEOGRAPHY_NAME	text	—
GEOGRAPHY_CODE	text	—
GEOGRAPHY_TYPE	text	—
GEOGRAPHY_TYPECODE	int	—
GEOGRAPHY_SORTORDER	int	—
SEX	int	—
SEX_NAME	text	—
SEX_CODE	int	—
SEX_TYPE	text	—
SEX_TYPECODE	int	—
SEX_SORTORDER	int	—
PAY	int	—
PAY_NAME	text	—
PAY_CODE	int	—
PAY_TYPE	text	—
PAY_TYPECODE	int	—
PAY_SORTORDER	int	—
ITEM	int	—
ITEM_NAME	text	—
ITEM_CODE	int	—
ITEM_TYPE	text	—
ITEM_TYPECODE	int	—
ITEM_SORTORDER	int	—
MEASURES	int	—
MEASURES_NAME	text	—
OBS_VALUE	text	—
OBS_STATUS	text	—
OBS_STATUS_NAME	text	—
OBS_CONF	text	—
OBS_CONF_NAME	text	—
URN	text	—
RECORD_OFFSET	int	—
RECORD_COUNT	int	—

Schema captured from ckan 2 days ago.

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.

Full API documentation ↗

Dataset

Volume & freshness

Last upstream update

9 years ago

2017-06-23

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: ckan

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.