UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	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 Maintenance And Repair Of The Dwelling	materials Materials	services Services	water_and_miscellaneous_services Water And Miscellaneous Services	water_supply Water Supply	refuse_collection Refuse Collection	sewerage_collection Sewerage Collection	other_services_note_6 Other Services [note 6]	electricity_gas_and_other_fuels Electricity, Gas And Other Fuels	electricity Electricity	gas Gas	liquid_fuels Liquid Fuels	solid_fuels Solid Fuels	heat_energy_note_6 Heat Energy [note 6]
COICOP identifier code	04	04.1	04.1.1	04.1.2	04.2	04.2.1	04.2.2	04.3	04.3.1	04.3.2	04.4	04.4.1	04.4.2	04.4.3	04.4.4	04.5	04.5.1	04.5.2	04.5.3	04.5.4	04.5.5
CDID identifier code	ADFS	ADFT	ADUX	ADUY	ADFU	CDDF	ADVB	ADFV	ATKH	AWTY	ADFW	ADVE	UUOX	ADVG	UUOY	ADFX	CDDL	ADVI	ADVJ	ADVK	ADVL
1997 Q1	41,064	5,917	5,899	18	28,605	27,678	927	308	126	182	1,200	595	19	586	[x]	5,034	2,322	2,352	192	168	[x]
1997 Q2	39,496	6,023	6,004	19	28,878	27,936	942	317	143	174	1,260	622	19	619	[x]	3,018	1,702	1,081	96	139	[x]
1997 Q3	39,264	6,053	6,033	20	29,072	28,113	959	300	138	162	1,271	630	20	621	[x]	2,568	1,620	728	84	136	[x]
1997 Q4	41,305	6,072	6,052	20	29,230	28,255	975	307	146	161	1,280	637	20	623	[x]	4,416	2,169	1,925	149	173	[x]
1998 Q1	41,993	6,350	6,329	21	29,489	28,505	984	324	152	172	1,286	641	20	625	[x]	4,544	2,161	2,095	141	147	[x]
1998 Q2	40,967	6,450	6,429	21	29,751	28,760	991	313	177	136	1,355	671	21	663	[x]	3,098	1,672	1,198	88	140	[x]
1998 Q3	40,684	6,499	6,478	21	30,060	29,055	1,005	286	166	120	1,336	666	20	650	[x]	2,503	1,586	713	76	128	[x]
1998 Q4	42,999	6,579	6,557	22	30,580	29,557	1,023	298	157	141	1,313	660	19	634	[x]	4,229	2,141	1,789	119	180	[x]


CREATE TABLE n_04cn (
  "time_period_and_codes" 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" VARCHAR,
  "materials" VARCHAR,
  "services" VARCHAR,
  "water_and_miscellaneous_services" VARCHAR,
  "water_supply" VARCHAR,
  "refuse_collection" VARCHAR,
  "sewerage_collection" VARCHAR,
  "other_services_note_6" VARCHAR,
  "electricity_gas_and_other_fuels" VARCHAR,
  "electricity" VARCHAR,
  "gas" VARCHAR,
  "liquid_fuels" VARCHAR,
  "solid_fuels" VARCHAR,
  "heat_energy_note_6" 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
);