UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	miscellaneous_goods_and_services Miscellaneous Goods And Services	personal_care Personal Care	hairdressing_salons_and_personal_grooming_establishments Hairdressing Salons And Personal Grooming Establishments	electrical_appliances_for_personal_care Electrical Appliances For Personal Care	other_appliances_articles_and_products_for_personal_care Other Appliances, Articles And Products For Personal Care	prostitution Prostitution	personal_effects_n_e_c_note_7 Personal Effects N.e.c [note 7]	jewellery_clocks_and_watches Jewellery Clocks And Watches	other_personal_effects Other Personal Effects	social_protection Social Protection	insurance Insurance	life_insurance Life Insurance	insurance_connected_with_the_dwelling Insurance Connected With The Dwelling	insurance_connected_with_health Insurance Connected With Health	insurance_connected_with_transport Insurance Connected With Transport	other_insurance Other Insurance	financial_services_n_e_c_note_7 Financial Services N.e.c [note 7]	fisim_note_5 FISIM [note 5]	other_financial_services_n_e_c_note_7 Other Financial Services N.e.c [note 7]	other_services_n_e_c_note_7 Other Services N.e.c [note 7]
COICOP identifier code	12	12.1	12.1.1	12.1.2	12.1.3	12.2	12.3	12.3.1	12.3.2	12.4	12.5	12.5.1	12.5.2	12.5.3	12.5.4	12.5.5	12.6	12.6.1	12.6.2	12.7
CDID identifier code	ADII	ADIJ	CDEV	ADXR	ADXS	MNC8	ADIK	ADXU	ADXV	ADIL	ADIM	ADXW	ADXX	ADXY	ADXZ	ADYA	ADIN	C68S	ADYC	ADIO
1997 Q1	16,044	2,482	743	38	1,701	510	860	779	81	1,415	3,617	2,283	299	358	303	374	5,165	2,623	2,542	1,995
1997 Q2	16,824	2,571	744	35	1,792	516	982	862	120	1,405	3,869	2,383	315	401	370	400	5,497	2,973	2,524	1,984
1997 Q3	17,499	2,613	741	36	1,836	524	981	843	138	1,423	3,797	2,452	290	361	329	365	6,034	3,351	2,683	2,127
1997 Q4	18,341	3,162	774	53	2,335	529	1,310	1,127	183	1,407	3,623	2,566	259	280	201	317	6,225	3,395	2,830	2,085
1998 Q1	17,802	2,676	801	44	1,831	536	952	821	131	1,392	3,891	2,542	288	365	332	364	6,430	3,535	2,895	1,925
1998 Q2	18,779	2,810	833	42	1,935	544	1,070	924	146	1,356	4,027	2,645	290	373	351	368	6,693	3,523	3,170	2,279
1998 Q3	19,065	2,903	861	46	1,996	551	1,060	904	156	1,391	3,910	2,750	252	309	283	316	7,068	3,664	3,404	2,182
1998 Q4	19,606	3,489	890	64	2,535	562	1,361	1,174	187	1,364	3,614	2,856	199	199	120	240	6,791	3,518	3,273	2,425


CREATE TABLE n_12cn (
  "time_period_and_codes" VARCHAR,
  "miscellaneous_goods_and_services" VARCHAR,
  "personal_care" VARCHAR,
  "hairdressing_salons_and_personal_grooming_establishments" VARCHAR,
  "electrical_appliances_for_personal_care" VARCHAR,
  "other_appliances_articles_and_products_for_personal_care" VARCHAR,
  "prostitution" VARCHAR,
  "personal_effects_n_e_c_note_7" VARCHAR,
  "jewellery_clocks_and_watches" VARCHAR,
  "other_personal_effects" VARCHAR,
  "social_protection" VARCHAR,
  "insurance" VARCHAR,
  "life_insurance" VARCHAR,
  "insurance_connected_with_the_dwelling" VARCHAR,
  "insurance_connected_with_health" VARCHAR,
  "insurance_connected_with_transport" VARCHAR,
  "other_insurance" VARCHAR,
  "financial_services_n_e_c_note_7" VARCHAR,
  "fisim_note_5" VARCHAR,
  "other_financial_services_n_e_c_note_7" VARCHAR,
  "other_services_n_e_c_note_7" 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
);