UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	total_goods Total Goods	food_and_non_alcoholic_beverages Food And Non-alcoholic Beverages	alcoholic_beverages_and_tobacco_note_1 Alcoholic Beverages And Tobacco [note 1]	clothing_and_footwear Clothing And Footwear	housing_water_electricity_gas_and_other_fuel Housing, Water, Electricity, Gas And Other Fuel	household_goods Household Goods	health Health	transport Transport	communication Communication	recreation_and_culture Recreation And Culture	miscellaneous Miscellaneous
COICOP identifier code	TG	TG01	TG02	TG03	TG04	TG05	TG06	TG07	TG08	TG09	TG12
CDID identifier code	UTIE	ABZV	ADFL	LLIP	LLIQ	LLIR	LLIS	LLIT	LLIU	LLIV	LLIW
1997 Q1	63,778	12,939	7,207	5,875	5,755	7,406	944	11,847	244	8,962	2,599
1997 Q2	63,647	13,438	7,529	6,657	3,783	7,098	922	11,943	301	9,167	2,809
1997 Q3	65,418	12,934	7,563	6,764	3,336	7,015	918	15,293	333	8,409	2,853
1997 Q4	71,655	14,051	8,251	9,227	5,199	8,540	976	11,025	408	10,280	3,698
1998 Q1	66,972	13,170	7,619	6,247	5,337	7,519	933	13,716	494	9,110	2,827
1998 Q2	66,946	14,037	7,897	7,119	3,946	7,742	935	12,258	440	9,525	3,047
1998 Q3	69,229	13,841	7,593	7,383	3,335	7,989	968	15,346	463	9,209	3,102
1998 Q4	75,013	14,317	8,194	9,591	5,046	9,290	1,041	11,431	605	11,538	3,960


CREATE TABLE tgcn (
  "time_period_and_codes" VARCHAR,
  "total_goods" VARCHAR,
  "food_and_non_alcoholic_beverages" VARCHAR,
  "alcoholic_beverages_and_tobacco_note_1" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "housing_water_electricity_gas_and_other_fuel" VARCHAR,
  "household_goods" VARCHAR,
  "health" VARCHAR,
  "transport" VARCHAR,
  "communication" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "miscellaneous" 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
);