UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	alcoholic_beverages_and_tobacco_note_1 Alcoholic Beverages And Tobacco [note 1]	alcoholic_beverages_note_1 Alcoholic Beverages [note 1]	spirits_note_1 Spirits [note 1]	wines_cider_and_perry_note_1 Wines, Cider And Perry [note 1]	beer_note_1 Beer [note 1]	tobacco Tobacco	narcotics Narcotics
COICOP identifier code	02	02.1	02.1.1	02.1.2	02.1.3	02.2	02.3
CDID identifier code	ADFL	ADFM	UUHX	UTHT	UUMI	ADFN	MNC2
1997 Q1	7,207	2,080	621	853	606	3,009	2,118
1997 Q2	7,529	2,335	630	975	730	3,087	2,107
1997 Q3	7,563	2,313	585	933	795	3,166	2,084
1997 Q4	8,251	2,991	916	1,227	848	3,211	2,049
1998 Q1	7,619	2,173	588	909	676	3,437	2,009
1998 Q2	7,897	2,563	625	1,049	889	3,365	1,969
1998 Q3	7,593	2,403	597	989	817	3,255	1,935
1998 Q4	8,194	3,079	933	1,263	883	3,204	1,911


CREATE TABLE n_02cn (
  "time_period_and_codes" VARCHAR,
  "alcoholic_beverages_and_tobacco_note_1" VARCHAR,
  "alcoholic_beverages_note_1" VARCHAR,
  "spirits_note_1" VARCHAR,
  "wines_cider_and_perry_note_1" VARCHAR,
  "beer_note_1" VARCHAR,
  "tobacco" VARCHAR,
  "narcotics" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" 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
);