UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	food_and_non_alcoholic_beverages Food And Non-alcoholic Beverages	food Food	bread_and_cereals Bread And Cereals	meat Meat	fish Fish	milk_cheese_and_eggs Milk, Cheese And Eggs	oils_and_fats Oils And Fats	fruit Fruit	vegetables Vegetables	sugar_confectionery_and_ice_cream Sugar, Confectionery And Ice-cream	other_food Other Food	non_alcoholic_beverages Non-alcoholic Beverages	coffee_tea_and_cocoa Coffee, Tea And Cocoa	fruit_and_vegetable_juices_and_other_soft_drinks Fruit And Vegetable Juices And Other Soft Drinks
COICOP identifier code	01	01.1	01.1.1	01.1.2	01.1.3	01.1.4	01.1.5	01.1.6	01.1.7	01.1.8	01.1.9	01.2	01.2.1	01.2.2
CDID identifier code	ABZV	ABZW	ADST	CDCJ	CDCK	CDCL	CDCM	CDCN	ADSZ	ADTD	ADTH	ADFK	CDCU	CDCV
1997 Q1	12,939	11,759	2,284	2,724	457	1,882	410	735	1,623	1,092	552	1,180	282	898
1997 Q2	13,438	12,106	2,280	2,699	465	1,884	410	905	1,818	1,123	522	1,332	318	1,014
1997 Q3	12,934	11,619	2,232	2,598	435	1,849	378	865	1,605	1,199	458	1,315	274	1,041
1997 Q4	14,051	12,729	2,496	2,951	460	1,861	417	840	1,723	1,381	600	1,322	336	986
1998 Q1	13,170	11,916	2,231	2,672	466	1,887	365	802	1,764	1,174	555	1,254	312	942
1998 Q2	14,037	12,550	2,352	2,754	492	1,917	390	915	1,966	1,250	514	1,487	315	1,172
1998 Q3	13,841	12,324	2,330	2,648	474	1,782	355	1,028	1,853	1,350	504	1,517	313	1,204
1998 Q4	14,317	12,882	2,469	2,837	482	1,802	437	887	1,823	1,501	644	1,435	340	1,095


CREATE TABLE n_01cn (
  "time_period_and_codes" VARCHAR,
  "food_and_non_alcoholic_beverages" VARCHAR,
  "food" VARCHAR,
  "bread_and_cereals" VARCHAR,
  "meat" VARCHAR,
  "fish" VARCHAR,
  "milk_cheese_and_eggs" VARCHAR,
  "oils_and_fats" VARCHAR,
  "fruit" VARCHAR,
  "vegetables" VARCHAR,
  "sugar_confectionery_and_ice_cream" VARCHAR,
  "other_food" VARCHAR,
  "non_alcoholic_beverages" VARCHAR,
  "coffee_tea_and_cocoa" VARCHAR,
  "fruit_and_vegetable_juices_and_other_soft_drinks" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR
);