UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	clothing_and_footwear Clothing And Footwear	clothing Clothing	clothing_materials Clothing Materials	garments Garments	other_articles_of_clothing_and_clothing_accessories Other Articles Of Clothing And Clothing Accessories	cleaning_and_hire_of_clothing Cleaning And Hire Of Clothing	footwear Footwear	shoes_and_other_footwear Shoes And Other Footwear	repair_and_hire_of_footwear Repair And Hire Of Footwear
COICOP identifier code	03	03.1	03.1.1	03.1.2	03.1.3	03.1.4	03.2	03.2.1	03.2.2
CDID identifier code	ADFP	ADFQ	ADUQ	ADUR	ADUS	ADUT	ADFR	ADUV	AWTX
1997 Q1	6,044	5,109	36	4,623	296	154	935	920	15
1997 Q2	6,827	5,730	34	5,247	294	155	1,097	1,082	15
1997 Q3	6,929	5,838	34	5,371	282	151	1,091	1,077	14
1997 Q4	9,393	8,097	43	7,557	350	147	1,296	1,277	19
1998 Q1	6,410	5,520	31	5,095	251	143	890	870	20
1998 Q2	7,289	6,201	31	5,763	260	147	1,088	1,065	23
1998 Q3	7,564	6,400	32	5,946	265	157	1,164	1,140	24
1998 Q4	9,787	8,473	39	7,947	316	171	1,314	1,289	25


CREATE TABLE n_03cn (
  "time_period_and_codes" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "clothing" VARCHAR,
  "clothing_materials" VARCHAR,
  "garments" VARCHAR,
  "other_articles_of_clothing_and_clothing_accessories" VARCHAR,
  "cleaning_and_hire_of_clothing" VARCHAR,
  "footwear" VARCHAR,
  "shoes_and_other_footwear" VARCHAR,
  "repair_and_hire_of_footwear" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" 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
);