UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	total_expenditure Total Expenditure	net_tourism Net Tourism	total_domestic_expenditure Total Domestic Expenditure	food_and_drink Food And Drink	alcohol_tobacco_and_narcotics Alcohol, Tobacco And Narcotics	clothing_and_footwear Clothing And Footwear	housing Housing	furnishings_household_equipment_and_routine_maintenanc_fc5d8bb8 Furnishings, Household Equipment And Routine Maintenance Of The House	health Health	transport Transport	communication Communication	recreation_and_culture Recreation And Culture	education Education	restaurants_and_hotels Restaurants And Hotels	miscellaneous Miscellaneous
COICOP identifier code	NAT0	TOUR	0	01	02	03	04	05	06	07	08	09	10	11	12
CDID identifier code	ABPB	ABTE	ABQI	ABZV	ADFL	ADFP	ADFS	ADFY	ADGP	ADGT	ADGX	ADGY	ADIE	ADIF	ADII
1997 Q1	144,887	291	144,596	12,939	7,207	6,044	41,064	8,072	2,474	19,336	3,341	13,950	1,390	12,735	16,044
1997 Q2	150,474	607	149,867	13,438	7,529	6,827	39,496	7,663	2,413	20,358	3,451	14,725	1,418	15,725	16,824
1997 Q3	155,809	965	154,844	12,934	7,563	6,929	39,264	7,650	2,415	25,246	3,500	13,884	1,453	16,507	17,499
1997 Q4	159,193	-203	159,396	14,051	8,251	9,393	41,305	9,174	2,597	19,442	3,845	15,748	1,489	15,760	18,341
1998 Q1	153,347	560	152,787	13,170	7,619	6,410	41,993	8,165	2,522	21,858	3,662	14,466	1,531	13,589	17,802
1998 Q2	158,601	1,043	157,558	14,037	7,897	7,289	40,967	8,324	2,545	21,230	3,735	15,179	1,573	16,003	18,779
1998 Q3	164,976	1,560	163,416	13,841	7,593	7,564	40,684	8,665	2,492	25,778	3,782	14,904	1,614	17,434	19,065
1998 Q4	167,673	141	167,532	14,317	8,194	9,787	42,999	9,966	2,516	20,415	4,125	17,239	1,654	16,714	19,606


CREATE TABLE ocn (
  "time_period_and_codes" VARCHAR,
  "total_expenditure" VARCHAR,
  "net_tourism" VARCHAR,
  "total_domestic_expenditure" VARCHAR,
  "food_and_drink" VARCHAR,
  "alcohol_tobacco_and_narcotics" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "housing" VARCHAR,
  "furnishings_household_equipment_and_routine_maintenanc_fc5d8bb8" VARCHAR,
  "health" VARCHAR,
  "transport" VARCHAR,
  "communication" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "education" VARCHAR,
  "restaurants_and_hotels" VARCHAR,
  "miscellaneous" 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
);