Chapter 18 UK Economic Data
Note: Chapter under development
18.1 ONS
The Office of National Statistics (ONS) collates and publishes most of the UK’s economic data sets.
There’s two main ways to access this data. Option 1, poorly formatted spreadsheets. Option 2, an API (which has been in beta for over 5 years). We’ll step through both.
There’s several R packages out there that either ping the ONS’ API or web scrape the data. Kostas Vasilopoulos has produced one of the better ones (and it’s on CRAN) called onsr.
## [1] "wellbeing-quarterly"
## [2] "wellbeing-local-authority"
## [3] "weekly-deaths-region"
## [4] "weekly-deaths-local-authority"
## [5] "weekly-deaths-health-board"
## [6] "weekly-deaths-age-sex"
## [7] "uk-spending-on-cards"
## [8] "uk-business-by-enterprises-and-local-units"
## [9] "traffic-camera-activity"
## [10] "trade"
## [11] "tax-benefits-statistics"
## [12] "suicides-in-the-uk"
## [13] "sexual-orientation-by-region"
## [14] "sexual-orientation-by-age-and-sex"
## [15] "retail-sales-index-large-and-small-businesses"
## [16] "retail-sales-index-all-businesses"
## [17] "retail-sales-index"
## [18] "regional-gdp-by-year"
## [19] "regional-gdp-by-quarter"
## [20] "projections-older-people-sex-ratios"
## [21] "projections-older-people-in-single-households"
## [22] "output-in-the-construction-industry"
## [23] "online-job-advert-estimates"
## [24] "older-people-sex-ratios"
## [25] "older-people-net-internal-migration"
## [26] "older-people-economic-activity"
## [27] "mid-year-pop-est"
## [28] "life-expectancy-by-local-authority"
## [29] "labour-market"
## [30] "index-private-housing-rental-prices"
## [31] "house-prices-local-authority"
## [32] "health-accounts"
## [33] "gva-by-industry-by-local-authority"
## [34] "generational-income"
## [35] "gdp-to-four-decimal-places"
## [36] "gdp-by-local-authority"
## [37] "faster-indicators-shipping-data"
## [38] "cpih01"
## [39] "childrens-wellbeing"
## [40] "ashe-tables-9-and-10"
## [41] "ashe-tables-7-and-8"
## [42] "ashe-tables-3"
## [43] "ashe-tables-27-and-28"
## [44] "ashe-tables-26"
## [45] "ashe-tables-25"
## [46] "ashe-tables-20"
## [47] "ashe-tables-11-and-12"
## [48] "ashe-table-5"
## [49] "ageing-population-projections"
## [50] "ageing-population-estimates"
## [51] "TS079"
## [52] "TS078"
## [53] "TS077"
## [54] "TS076"
## [55] "TS075"
## [56] "TS074"
## [57] "TS073"
## [58] "TS072"
## [59] "TS071"
## [60] "TS070"## # A tibble: 60 × 22
## contacts description keywords id links$editions$href methodologies
## <list> <chr> <list> <chr> <chr> <list>
## 1 <df [1 × 3]> Seasonally and… <chr> well… https://api.beta.o… <df [1 × 2]>
## 2 <df [1 × 3]> Estimates of l… <chr> well… https://api.beta.o… <NULL>
## 3 <df [1 × 3]> Provisional co… <chr> week… https://api.beta.o… <NULL>
## 4 <df [1 × 3]> Provisional co… <chr> week… https://api.beta.o… <NULL>
## 5 <df [1 × 3]> Provisional co… <chr> week… https://api.beta.o… <NULL>
## 6 <df [1 × 3]> Provisional co… <chr> week… https://api.beta.o… <NULL>
## 7 <df [1 × 3]> These data ser… <NULL> uk-s… https://api.beta.o… <NULL>
## 8 <df [1 × 3]> The data conta… <chr> uk-b… https://api.beta.o… <NULL>
## 9 <df [1 × 3]> Experimental d… <NULL> traf… https://api.beta.o… <NULL>
## 10 <df [1 × 3]> Country by com… <chr> trade https://api.beta.o… <NULL>
## # ℹ 50 more rows
## # ℹ 19 more variables: links$latest_version <df[,2]>, $self <df[,1]>,
## # $taxonomy <df[,1]>, national_statistic <lgl>, next_release <chr>,
## # qmi <tibble[,1]>, related_datasets <list>, release_frequency <chr>,
## # state <chr>, title <chr>, unit_of_measure <chr>, type <chr>,
## # publications <list>, license <chr>, is_based_on <df[,2]>,
## # canonical_topic <chr>, subtopics <list>, survey <chr>, …## # A tibble: 100 × 7
## v4_0 `mmm-yy` Time `uk-only` Geography `sic-unofficial`
## <dbl> <chr> <chr> <chr> <chr> <chr>
## 1 95.9 Jan-25 Jan-25 K02000001 United Kingdom B--E
## 2 102. Jan-25 Jan-25 K02000001 United Kingdom A--T
## 3 103. Jan-25 Jan-25 K02000001 United Kingdom F
## 4 103. Jan-25 Jan-25 K02000001 United Kingdom A
## 5 102. Jan-25 Jan-25 K02000001 United Kingdom G--T
## 6 102. Dec-24 Dec-24 K02000001 United Kingdom A--T
## 7 103. Dec-24 Dec-24 K02000001 United Kingdom F
## 8 102. Dec-24 Dec-24 K02000001 United Kingdom G--T
## 9 96.8 Dec-24 Dec-24 K02000001 United Kingdom B--E
## 10 103. Dec-24 Dec-24 K02000001 United Kingdom A
## # ℹ 90 more rows
## # ℹ 1 more variable: UnofficialStandardIndustrialClassification <chr>18.2 Nomis
Census data, as well as economic and social data sets that take into account location, are produced by the ONS’ Nomis service. Nomis has it’s very own R package called nomisr.
The last UK census was in 2021. While there is a census slated for 2031, there is a growing consensus that this may not be necessary, with new administrative data sets providing a more accurate picture of the UK’s population.
18.3 Trade
In April 2025, trade is well and truly the talk of the town.
UK trade data is collated by HM Revenue & Customs (HMRC) and published on the website https://www.uktradeinfo.com/.
Peter van der Meulen has developed a wonderful R package uktrade to query HMRC’s database and stitch together tables.
Here’s a worked example: