UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	total_semi_durable_goods Total Semi-durable Goods	clothing_and_footwear Clothing And Footwear	clothing_materials Clothing Materials	garments Garments	other_articles_of_clothing_and_clothing_accessories Other Articles Of Clothing And Clothing Accessories	shoes_and_other_footwear Shoes And Other Footwear	household_goods Household Goods	household_textiles Household Textiles	small_electric_household_appliances Small Electric Household Appliances	glassware_tableware_and_household_appliances Glassware, Tableware And Household Appliances	small_tools_and_equipment Small Tools And Equipment	transport Transport	spare_parts_and_accessories_for_personal_transport_equipment Spare Parts And Accessories For Personal Transport Equipment	recreation_and_culture Recreation And Culture	recording_media Recording Media	games_toys_and_hobbies Games, Toys And Hobbies	equipment_for_sport_camping_and_open_air_recreation Equipment For Sport, Camping And Open-air Recreation	books Books	miscellaneous Miscellaneous	electrical_appliances_for_personal_care Electrical Appliances For Personal Care	other_personal_effects Other Personal Effects
COICOP identifier code	TSD	TSD03	03.1.1	03.1.2	03.1.3	03.2.1	TSD05	05.2	05.3.2	05.4	05.5.2	TSD07	07.2.1	TSD09	09.1.4	09.3.1	09.3.2	09.5.1	TSD12	12.1.2	12.3.2
CDID identifier code	UTIQ	LLJL	ADUQ	ADUR	ADUS	ADUV	LLJM	ADGG	ADVQ	ADGM	ADVT	LLJN	AWTV	LLJO	ADWT	ADWY	ADWZ	CDEO	LLJP	ADXR	ADXV
1997 Q1	11,955	5,875	36	4,623	296	920	2,246	848	164	717	517	717	717	2,998	953	946	753	346	119	38	81
1997 Q2	12,994	6,657	34	5,247	294	1,082	2,290	812	154	721	603	866	866	3,026	894	888	857	387	155	35	120
1997 Q3	13,019	6,764	34	5,371	282	1,077	2,277	815	148	733	581	891	891	2,913	918	820	841	334	174	36	138
1997 Q4	17,159	9,227	43	7,557	350	1,277	2,804	1,003	209	958	634	835	835	4,057	1,348	1,077	1,049	583	236	53	183
1998 Q1	12,958	6,247	31	5,095	251	870	2,491	888	167	817	619	857	857	3,188	1,058	968	792	370	175	44	131
1998 Q2	14,189	7,119	31	5,763	260	1,065	2,640	882	153	879	726	1,021	1,021	3,221	1,029	979	826	387	188	42	146
1998 Q3	14,624	7,383	32	5,946	265	1,140	2,662	915	154	921	672	1,040	1,040	3,337	1,126	1,057	786	368	202	46	156
1998 Q4	18,566	9,591	39	7,947	316	1,289	3,090	1,049	223	1,143	675	984	984	4,650	1,657	1,430	917	646	251	64	187


CREATE TABLE sdgcn (
  "time_period_and_codes" VARCHAR,
  "total_semi_durable_goods" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "clothing_materials" VARCHAR,
  "garments" VARCHAR,
  "other_articles_of_clothing_and_clothing_accessories" VARCHAR,
  "shoes_and_other_footwear" VARCHAR,
  "household_goods" VARCHAR,
  "household_textiles" VARCHAR,
  "small_electric_household_appliances" VARCHAR,
  "glassware_tableware_and_household_appliances" VARCHAR,
  "small_tools_and_equipment" VARCHAR,
  "transport" VARCHAR,
  "spare_parts_and_accessories_for_personal_transport_equipment" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "recording_media" VARCHAR,
  "games_toys_and_hobbies" VARCHAR,
  "equipment_for_sport_camping_and_open_air_recreation" VARCHAR,
  "books" VARCHAR,
  "miscellaneous" VARCHAR,
  "electrical_appliances_for_personal_care" VARCHAR,
  "other_personal_effects" 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
);