UK Consumer Trends: 1997 - 2022, Quarterly

time_period_and_codes Time Period And Codes	transport Transport	purchase_of_vehicles Purchase Of Vehicles	motor_cars Motor Cars	motor_cycles Motor Cycles	bicycles Bicycles	operation_of_personal_transport_equipment Operation Of Personal Transport Equipment	spare_parts_and_accessories_for_personal_transport_equipment Spare Parts And Accessories For Personal Transport Equipment	fuels_and_lubricants_for_personal_transport_equipment Fuels And Lubricants For Personal Transport Equipment	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
COICOP identifier code	07	07.1	07.1.1	07.1.2	07.1.3	07.2	07.2.1	07.2.2	07.2.3	07.2.4	07.3	07.3.1	07.3.2	07.3.3	07.3.4	07.3.6
CDID identifier code	ADGT	ADGU	ADVZ	ADWA	ADWB	ADGV	AWTV	CDDY	AWTZ	ADWG	ADGW	AWUA	ADWI	AWUB	AWUC	AWUD
1997 Q1	19,336	7,300	7,028	151	121	7,752	717	3,830	2,406	799	4,284	860	1,185	1,623	411	205
1997 Q2	20,358	7,054	6,694	238	122	8,296	866	4,023	2,562	845	5,008	907	1,389	2,127	343	242
1997 Q3	25,246	10,379	10,021	237	121	8,335	891	4,023	2,591	830	6,532	1,004	1,520	3,015	699	294
1997 Q4	19,442	6,044	5,794	131	119	8,327	835	4,146	2,578	768	5,071	938	1,593	1,855	467	218
1998 Q1	21,858	8,579	8,260	202	117	8,590	857	4,280	2,587	866	4,689	887	1,305	1,822	459	216
1998 Q2	21,230	7,171	6,775	280	116	8,618	1,021	4,066	2,657	874	5,441	923	1,545	2,316	406	251
1998 Q3	25,778	10,057	9,683	257	117	8,901	1,040	4,249	2,685	927	6,820	1,008	1,600	3,218	687	307
1998 Q4	20,415	6,277	6,027	130	120	8,618	984	4,170	2,678	786	5,520	952	1,599	2,233	513	223


CREATE TABLE n_07cn (
  "time_period_and_codes" VARCHAR,
  "transport" VARCHAR,
  "purchase_of_vehicles" VARCHAR,
  "motor_cars" VARCHAR,
  "motor_cycles" VARCHAR,
  "bicycles" VARCHAR,
  "operation_of_personal_transport_equipment" VARCHAR,
  "spare_parts_and_accessories_for_personal_transport_equipment" VARCHAR,
  "fuels_and_lubricants_for_personal_transport_equipment" 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,
  "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
);