UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	health Health	medical_products_appliances_and_equipment Medical Products, Appliances And Equipment	pharmaceutical_products Pharmaceutical Products	other_medical_products Other Medical Products	therapeutic_appliances_and_equipment Therapeutic Appliances And Equipment	out_patient_services Out-patient Services	medical_services Medical Services	dental_services Dental Services	paramedical_services Paramedical Services	hospital_services Hospital Services
COICOP identifier code	06	06.1	06.1.1	06.1.2	06.1.3	06.2	06.2.1	06.2.2	06.2.3	06.3
CDID identifier code	ADGP	ADGQ	UTXM	UUPU	UUPV	ADGR	ADVW	ADVX	UTME	ADGS
1997 Q1	2,474	944	492	61	391	937	570	298	69	593
1997 Q2	2,413	922	471	55	396	887	531	296	60	604
1997 Q3	2,415	918	461	70	387	878	520	295	63	619
1997 Q4	2,597	976	522	91	363	989	593	323	73	632
1998 Q1	2,522	933	496	65	372	979	554	346	79	610
1998 Q2	2,545	935	507	56	372	982	549	350	83	628
1998 Q3	2,492	968	521	70	377	898	506	323	69	626
1998 Q4	2,516	1,041	554	93	394	875	516	299	60	600


CREATE TABLE n_06cn (
  "time_period_and_codes" VARCHAR,
  "health" VARCHAR,
  "medical_products_appliances_and_equipment" VARCHAR,
  "pharmaceutical_products" VARCHAR,
  "other_medical_products" VARCHAR,
  "therapeutic_appliances_and_equipment" VARCHAR,
  "out_patient_services" VARCHAR,
  "medical_services" VARCHAR,
  "dental_services" VARCHAR,
  "paramedical_services" VARCHAR,
  "hospital_services" 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
);