UK CPI microdata extract — uk

A subset of the official UK CIP microdata set published by the United Kingdom Office for National Statistics (ONS)

Usage

uk_cpi

Format

`uk_cpi`

A data frame with 11,807 rows and 14 columns containing two products: White sliced loaf branded 750 grams (COICOP 1010103) and carpenter hourly rate (COICOP 410518).

More information on COICOP classification can be found in the ONS Classification of household consumption headings and in the UN Statistics Division’s COICOP 2018 statistical paper.

Year: Year
Date of quote: year and month of data collection (yyyymm)
coicop_5d: COICOP 5-digit code
Product code: Identification of the item collected
Product description: Description of item collected
Reference quantity: Reference quantity of commodity that should be surveyed
Unit of reference quantity: Unit of reference quantity of commodity that should be surveyed
Region: Region, following TL2/ITL1 boundaries)
Shop identifier: Code of shop that the price was collected from
Type of shop: Either "Multiple" (10 or more outlets) or "Independents" (less than 10 outlets)
Quantity observed: Quantity observed of commodity that was be surveyed
Unit of observed quantity: Unit of observed quantity of commodity that was be surveyed
Price observed: Price observed of commodity that was be surveyed
Reference quantity price: The reference quantity price scales the observed price to the quantity that should be surveyed. It is defined as Price observed / Quantity observed * Reference quantity whenever Unit of observed quantity == Unit of reference quantity.

Source

ONS Consumer price inflation consumption segment indices and price quotes , last access November 2025

Examples

uk_cpi |> dim()
#> [1] 11807    14
uk_cpi |> dplyr::distinct(`Product description`)
#> # A tibble: 2 × 1
#>   `Product description`         
#>   <chr>                         
#> 1 WHITE SLICED LOAF BRANDED 750G
#> 2 CARPENTER HOURLY RATE         
uk_cpi |> names()
#>  [1] "Year"                       "Date of quote"             
#>  [3] "coicop_5d"                  "Product code"              
#>  [5] "Product description"        "Reference quantity"        
#>  [7] "Unit of reference quantity" "Region"                    
#>  [9] "Shop identifier"            "Type of shop"              
#> [11] "Quantity observed"          "Unit of observed quantity" 
#> [13] "Price observed"             "Reference quantity price"