UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	total_services Total Services	clothing_and_footwear Clothing And Footwear	cleaning_and_hire_of_clothing Cleaning And Hire Of Clothing	repair_and_hire_of_footwear Repair And Hire Of Footwear	housing_water_electricity_gas_and_other_fuel Housing, Water, Electricity, Gas And Other Fuel	actual_rentals_for_housing Actual Rentals For Housing	actual_rentals_paid_by_tenants Actual Rentals Paid By Tenants	other_actual_rentals Other Actual Rentals	imputed_rentals_for_housing Imputed Rentals For Housing	imputed_rentals_for_owner_occupiers Imputed Rentals For Owner-occupiers	other_imputed_rentals Other Imputed Rentals	maintenance_and_repair_of_the_dwelling_services Maintenance And Repair Of The Dwelling Services	refuse_collection Refuse Collection	sewerage_collection Sewerage Collection	other_services_relating_to_the_dwelling Other Services Relating To The Dwelling	household_services Household Services	repair_of_furniture_furnishings_and_floor_coverings Repair Of Furniture, Furnishings And Floor Coverings	repair_of_household_appliances Repair Of Household Appliances	domestic_and_household_services Domestic And Household Services	health Health	out_patient_services Out-patient Services	medical_services Medical Services	dental_services Dental Services	paramedical_services Paramedical Services	hospital_services Hospital Services	transport Transport	maintenance_and_repair_of_personal_transport_equipment Maintenance And Repair Of Personal Transport Equipment	other_services_in_respect_of_personal_transport_equipment Other Services In Respect Of Personal Transport Equipment	transport_services Transport Services	rail Rail	road Road	air Air	sea_and_inland_waterway Sea And Inland Waterway	other_purchased_transport_services Other Purchased Transport Services	communication Communication	postal_services Postal Services	telephone_and_telefax_services Telephone And Telefax Services	recreation_and_culture Recreation And Culture	repairs_of_audio_visual_etc_equipment Repairs Of Audio-visual Etc Equipment	maintenance_and_repairs_of_other_major_durables Maintenance And Repairs Of Other Major Durables	veterinary_and_other_services_for_pets Veterinary And Other Services For Pets	recreational_and_cultural_services Recreational And Cultural Services	recreational_and_sporting_services Recreational And Sporting Services	cultural_services Cultural Services	games_of_chance Games Of Chance	package_holidays_note_2 Package Holidays [note 2]	education Education	restaurant_and_hotels Restaurant And Hotels	catering_services Catering Services	restaurants_cafes_etc_note_3_note_4 Restaurants, Cafes Etc [note 3][note 4]	canteens Canteens	accommodation Accommodation	miscellaneous Miscellaneous	hairdressing_salons_and_personal_grooming_establishments Hairdressing Salons And Personal Grooming Establishments	prostitution Prostitution	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	TS	TS03	03.1.4	03.2.2	TS04	04.1	04.1.1	04.1.2	04.2	04.2.1	04.2.2	04.3.2	04.4.2	04.4.3	04.4.4	TS05	05.1.3	05.3.3	05.6.2	TS06	06.2	06.2.1	06.2.2	06.2.3	06.3	TS07	07.2.3	07.2.4	07.3	07.3.1	07.3.2	07.3.3	07.3.4	07.3.6	TS08	08.1	08.3	TS09	09.1.5	09.2.3	09.3.5	09.4	09.4.1	09.4.2	09.4.3	09.6	10	11	11.1	11.1.1	11.1.2	11.2	TS12	12.1.1	12.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	UTIM	LLJD	ADUT	AWTX	LLJE	ADFT	ADUX	ADUY	ADFU	CDDF	ADVB	AWTY	UUOX	ADVG	UUOY	LLJF	ADVO	ADVR	ADVV	LLJG	ADGR	ADVW	ADVX	UTME	ADGS	LLJH	AWTZ	ADWG	ADGW	AWUA	ADWI	AWUB	AWUC	AWUD	LLJI	CDEF	ADWP	LLJJ	ADWU	ADWX	ADXC	ADIA	ADXD	ADXE	CDEM	ADID	ADIE	ADIF	ADIG	ADXO	ADXP	ADIH	LLJK	CDEV	MNC8	ADIL	ADIM	ADXW	ADXX	ADXY	ADXZ	ADYA	ADIN	C68S	ADYC	ADIO
1997 Q1	80,818	169	154	15	35,309	5,917	5,899	18	28,605	27,678	927	182	19	586	[x]	666	7	115	544	1,530	937	570	298	69	593	7,489	2,406	799	4,284	860	1,185	1,623	411	205	3,097	232	2,865	4,988	56	301	210	4,421	938	1,821	1,662	[x]	1,390	12,735	10,695	9,710	985	2,040	13,445	743	510	1,415	3,617	2,283	299	358	303	374	5,165	2,623	2,542	1,995
1997 Q2	86,220	170	155	15	35,713	6,023	6,004	19	28,878	27,936	942	174	19	619	[x]	565	7	44	514	1,491	887	531	296	60	604	8,415	2,562	845	5,008	907	1,389	2,127	343	242	3,150	255	2,895	5,558	50	305	209	4,994	996	2,207	1,791	[x]	1,418	15,725	12,693	11,517	1,176	3,032	14,015	744	516	1,405	3,869	2,383	315	401	370	400	5,497	2,973	2,524	1,984
1997 Q3	89,426	165	151	14	35,928	6,053	6,033	20	29,072	28,113	959	162	20	621	[x]	635	8	108	519	1,497	878	520	295	63	619	9,953	2,591	830	6,532	1,004	1,520	3,015	699	294	3,167	199	2,968	5,475	49	303	197	4,926	975	2,167	1,784	[x]	1,453	16,507	12,874	11,883	991	3,633	14,646	741	524	1,423	3,797	2,452	290	361	329	365	6,034	3,351	2,683	2,127
1997 Q4	87,741	166	147	19	36,106	6,072	6,052	20	29,230	28,255	975	161	20	623	[x]	634	8	92	534	1,621	989	593	323	73	632	8,417	2,578	768	5,071	938	1,593	1,855	467	218	3,437	434	3,003	5,468	55	307	197	4,909	923	2,219	1,767	[x]	1,489	15,760	13,218	12,143	1,075	2,542	14,643	774	529	1,407	3,623	2,566	259	280	201	317	6,225	3,395	2,830	2,085
1998 Q1	85,815	163	143	20	36,656	6,350	6,329	21	29,489	28,505	984	172	20	625	[x]	646	9	93	544	1,589	979	554	346	79	610	8,142	2,587	866	4,689	887	1,305	1,822	459	216	3,168	179	2,989	5,356	61	309	203	4,783	927	2,052	1,804	[x]	1,531	13,589	11,424	10,251	1,173	2,165	14,975	801	536	1,392	3,891	2,542	288	365	332	364	6,430	3,535	2,895	1,925
1998 Q2	90,612	170	147	23	37,021	6,450	6,429	21	29,751	28,760	991	136	21	663	[x]	582	7	46	529	1,610	982	549	350	83	628	8,972	2,657	874	5,441	923	1,545	2,316	406	251	3,295	159	3,136	5,654	63	311	222	5,058	987	2,296	1,775	[x]	1,573	16,003	12,909	11,682	1,227	3,094	15,732	833	544	1,356	4,027	2,645	290	373	351	368	6,693	3,523	3,170	2,279
1998 Q3	94,187	181	157	24	37,349	6,499	6,478	21	30,060	29,055	1,005	120	20	650	[x]	676	9	117	550	1,524	898	506	323	69	626	10,432	2,685	927	6,820	1,008	1,600	3,218	687	307	3,319	141	3,178	5,695	63	314	231	5,087	1,018	2,302	1,767	[x]	1,614	17,434	13,693	12,617	1,076	3,741	15,963	861	551	1,391	3,910	2,750	252	309	283	316	7,068	3,664	3,404	2,182
1998 Q4	92,519	196	171	25	37,953	6,579	6,557	22	30,580	29,557	1,023	141	19	634	[x]	676	10	104	562	1,475	875	516	299	60	600	8,984	2,678	786	5,520	952	1,599	2,233	513	223	3,520	306	3,214	5,701	58	317	251	5,075	966	2,353	1,756	[x]	1,654	16,714	14,133	12,963	1,170	2,581	15,646	890	562	1,364	3,614	2,856	199	199	120	240	6,791	3,518	3,273	2,425


CREATE TABLE sercn (
  "time_period_and_codes" VARCHAR,
  "total_services" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "cleaning_and_hire_of_clothing" VARCHAR,
  "repair_and_hire_of_footwear" VARCHAR,
  "housing_water_electricity_gas_and_other_fuel" VARCHAR,
  "actual_rentals_for_housing" VARCHAR,
  "actual_rentals_paid_by_tenants" VARCHAR,
  "other_actual_rentals" VARCHAR,
  "imputed_rentals_for_housing" VARCHAR,
  "imputed_rentals_for_owner_occupiers" VARCHAR,
  "other_imputed_rentals" VARCHAR,
  "maintenance_and_repair_of_the_dwelling_services" VARCHAR,
  "refuse_collection" VARCHAR,
  "sewerage_collection" VARCHAR,
  "other_services_relating_to_the_dwelling" VARCHAR,
  "household_services" VARCHAR,
  "repair_of_furniture_furnishings_and_floor_coverings" VARCHAR,
  "repair_of_household_appliances" VARCHAR,
  "domestic_and_household_services" VARCHAR,
  "health" VARCHAR,
  "out_patient_services" VARCHAR,
  "medical_services" VARCHAR,
  "dental_services" VARCHAR,
  "paramedical_services" VARCHAR,
  "hospital_services" VARCHAR,
  "transport" VARCHAR,
  "maintenance_and_repair_of_personal_transport_equipment" VARCHAR,
  "other_services_in_respect_of_personal_transport_equipment" VARCHAR,
  "transport_services" VARCHAR,
  "rail" VARCHAR,
  "road" VARCHAR,
  "air" VARCHAR,
  "sea_and_inland_waterway" VARCHAR,
  "other_purchased_transport_services" VARCHAR,
  "communication" VARCHAR,
  "postal_services" VARCHAR,
  "telephone_and_telefax_services" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "repairs_of_audio_visual_etc_equipment" VARCHAR,
  "maintenance_and_repairs_of_other_major_durables" VARCHAR,
  "veterinary_and_other_services_for_pets" VARCHAR,
  "recreational_and_cultural_services" VARCHAR,
  "recreational_and_sporting_services" VARCHAR,
  "cultural_services" VARCHAR,
  "games_of_chance" VARCHAR,
  "package_holidays_note_2" VARCHAR,
  "education" VARCHAR,
  "restaurant_and_hotels" VARCHAR,
  "catering_services" VARCHAR,
  "restaurants_cafes_etc_note_3_note_4" VARCHAR,
  "canteens" VARCHAR,
  "accommodation" VARCHAR,
  "miscellaneous" VARCHAR,
  "hairdressing_salons_and_personal_grooming_establishments" VARCHAR,
  "prostitution" 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_67" VARCHAR,
  "unnamed_68" VARCHAR
);