UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	furnishing_household_equipment_and_routine_hh_maintenance Furnishing, Household Equipment And Routine HH Maintenance	furniture_and_furnishings_carpets_and_other_floor_coverings Furniture And Furnishings, Carpets And Other Floor Coverings	furniture_and_furnishings Furniture And Furnishings	carpets_and_other_floor_coverings Carpets And Other Floor Coverings	repair_of_furniture_furnishings_and_floor_coverings Repair Of Furniture, Furnishings And Floor Coverings	household_textiles Household Textiles	household_appliances Household Appliances	major_appliances_whether_electrical_or_not Major Appliances Whether Electrical Or Not	small_electric_household_appliances Small Electric Household Appliances	repair_of_household_appliances Repair Of Household Appliances	glassware_tableware_and_household_utensils Glassware, Tableware And Household Utensils	tools_and_equipment_for_house_and_garden Tools And Equipment For House And Garden	major_tools_and_equipment Major Tools And Equipment	small_tools_and_equipment Small Tools And Equipment	goods_and_services_for_routine_household_maintenance Goods And Services For Routine Household Maintenance	non_durable_household_goods Non-durable Household Goods	domestic_and_household_services Domestic And Household Services
COICOP identifier code	05	05.1	05.1.1	05.1.2	05.1.3	05.2	05.3	05.3.1	05.3.2	05.3.3	05.4	05.5	05.5.1	05.5.2	05.6	05.6.1	05.6.2
CDID identifier code	ADFY	ADFZ	ADVM	ADVN	ADVO	ADGG	ADGL	ADVP	ADVQ	ADVR	ADGM	ADGN	ADVS	ADVT	ADGO	ADVU	ADVV
1997 Q1	8,072	3,365	2,444	914	7	848	1,330	1,051	164	115	717	596	79	517	1,216	672	544
1997 Q2	7,663	3,025	2,312	706	7	812	1,180	982	154	44	721	680	77	603	1,245	731	514
1997 Q3	7,650	2,952	2,293	651	8	815	1,237	981	148	108	733	662	81	581	1,251	732	519
1997 Q4	9,174	3,535	2,745	782	8	1,003	1,660	1,359	209	92	958	716	82	634	1,302	768	534
1998 Q1	8,165	3,164	2,459	696	9	888	1,310	1,050	167	93	817	701	82	619	1,285	741	544
1998 Q2	8,324	3,277	2,509	761	7	882	1,179	980	153	46	879	813	87	726	1,294	765	529
1998 Q3	8,665	3,435	2,604	822	9	915	1,299	1,028	154	117	921	761	89	672	1,334	784	550
1998 Q4	9,966	3,910	2,996	904	10	1,049	1,747	1,420	223	104	1,143	763	88	675	1,354	792	562


CREATE TABLE n_05cn (
  "time_period_and_codes" VARCHAR,
  "furnishing_household_equipment_and_routine_hh_maintenance" VARCHAR,
  "furniture_and_furnishings_carpets_and_other_floor_coverings" VARCHAR,
  "furniture_and_furnishings" VARCHAR,
  "carpets_and_other_floor_coverings" VARCHAR,
  "repair_of_furniture_furnishings_and_floor_coverings" VARCHAR,
  "household_textiles" VARCHAR,
  "household_appliances" VARCHAR,
  "major_appliances_whether_electrical_or_not" VARCHAR,
  "small_electric_household_appliances" VARCHAR,
  "repair_of_household_appliances" VARCHAR,
  "glassware_tableware_and_household_utensils" VARCHAR,
  "tools_and_equipment_for_house_and_garden" VARCHAR,
  "major_tools_and_equipment" VARCHAR,
  "small_tools_and_equipment" VARCHAR,
  "goods_and_services_for_routine_household_maintenance" VARCHAR,
  "non_durable_household_goods" VARCHAR,
  "domestic_and_household_services" 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
);