Baselight
Sign In

UK Consumer Trends: 1997 - 2022, Quarterly

Consumer trends: current price, not seasonally adjusted

@kaggle.matarrgaye_uk_consumer_trends_current_price

Loading...
Loading...

About this Dataset

UK Consumer Trends: 1997 - 2022, Quarterly

This dataset contains all the data tables related to the consumer trends statistical release published in March 2023 by the Office for National Statistics (ONS) from Q1 1997 to Q4 2022, aka Household final consumption expenditure for the UK, as a measure of economic growth. Includes all spending on goods and services by members of UK households £ millions.

Throughout these tables, Q1 refers to Quarter 1 (January to March), Q2 refers to Quarter 2 (April to June), Q3 refers to Quarter 3 (July to September), and Q4 refers to Quarter 4 (October to December).

Table of contents:
OCN = UK national and domestic total expenditure
01CN = Food and non-alcoholic beverages
02CN = Alcoholic beverages, tobacco and narcotics
03CN = Clothing and footwear
04CN = Housing, water, electricity,gas and other fuels
05CN = Furnishings, household equipment and routine maintenance of the house
06CN = Health
07CN = Transport
08CN = Communication
09CN = Recreation and culture (missing and will update)
10CN = Education
11CN = Restaurants and hotels
12CN = Miscellaneous goods and services
TOURCN = UK and foreign tourist expenditure expenditure
0GSCN = UK national and domestic goods and services
TGCN = Total goods
DGCN = Durable goods
SDGCN = Semi-durable goods
NDGCN = Non-durable goods
SERCN = Total services

Row key:
COICOP = Classification of Individual Consumption by Purpose.
CDID = The four-character identification codes appearing in the tables are the Office for National Statistics' (ONS) references for the data series.

Tables

Dgcn

@kaggle.matarrgaye_uk_consumer_trends_current_price.dgcn
  • 54.33 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE dgcn (
  "time_period_and_codes" VARCHAR,
  "total_semi_durable_goods" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "clothing_materials" VARCHAR,
  "garments" VARCHAR,
  "other_articles_of_clothing_and_clothing_accessories" VARCHAR,
  "shoes_and_other_footwear" VARCHAR,
  "household_goods" VARCHAR,
  "household_textiles" VARCHAR,
  "small_electric_household_appliances" VARCHAR,
  "glassware_tableware_and_household_appliances" VARCHAR,
  "small_tools_and_equipment" VARCHAR,
  "transport" VARCHAR,
  "spare_parts_and_accessories_for_personal_transport_equipment" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "recording_media" VARCHAR,
  "games_toys_and_hobbies" VARCHAR,
  "equipment_for_sport_camping_and_open_air_recreation" VARCHAR,
  "books" VARCHAR,
  "miscellaneous" VARCHAR,
  "electrical_appliances_for_personal_care" VARCHAR,
  "other_personal_effects" 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
);

N 01cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_01cn
  • 48.03 KB
  • 141 rows
  • 67 columns
Loading... 

CREATE TABLE n_01cn (
  "time_period_and_codes" VARCHAR,
  "food_and_non_alcoholic_beverages" VARCHAR,
  "food" VARCHAR,
  "bread_and_cereals" VARCHAR,
  "meat" VARCHAR,
  "fish" VARCHAR,
  "milk_cheese_and_eggs" VARCHAR,
  "oils_and_fats" VARCHAR,
  "fruit" VARCHAR,
  "vegetables" VARCHAR,
  "sugar_confectionery_and_ice_cream" VARCHAR,
  "other_food" VARCHAR,
  "non_alcoholic_beverages" VARCHAR,
  "coffee_tea_and_cocoa" VARCHAR,
  "fruit_and_vegetable_juices_and_other_soft_drinks" 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
);

N 02cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_02cn
  • 42.84 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_02cn (
  "time_period_and_codes" VARCHAR,
  "alcoholic_beverages_and_tobacco_note_1" VARCHAR,
  "alcoholic_beverages_note_1" VARCHAR,
  "spirits_note_1" VARCHAR,
  "wines_cider_and_perry_note_1" VARCHAR,
  "beer_note_1" VARCHAR,
  "tobacco" VARCHAR,
  "narcotics" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

N 03cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_03cn
  • 44.16 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_03cn (
  "time_period_and_codes" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "clothing" VARCHAR,
  "clothing_materials" VARCHAR,
  "garments" VARCHAR,
  "other_articles_of_clothing_and_clothing_accessories" VARCHAR,
  "cleaning_and_hire_of_clothing" VARCHAR,
  "footwear" VARCHAR,
  "shoes_and_other_footwear" VARCHAR,
  "repair_and_hire_of_footwear" VARCHAR,
  "unnamed_10" 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
);

N 04cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_04cn
  • 52.34 KB
  • 142 rows
  • 67 columns
Loading... 

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
);

N 05cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_05cn
  • 51.8 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_05cn (
  "time_period_and_codes" VARCHAR,
  "furnishing_household_equipment_and_routine_hh_maintenance" VARCHAR,
  "furniture_and_furnishings_carpets_and_other_floor_coverings" VARCHAR,
  "furniture_and_furnishings" VARCHAR,
  "carpets_and_other_floor_coverings" VARCHAR,
  "repair_of_furniture_furnishings_and_floor_coverings" VARCHAR,
  "household_textiles" VARCHAR,
  "household_appliances" VARCHAR,
  "major_appliances_whether_electrical_or_not" VARCHAR,
  "small_electric_household_appliances" VARCHAR,
  "repair_of_household_appliances" VARCHAR,
  "glassware_tableware_and_household_utensils" VARCHAR,
  "tools_and_equipment_for_house_and_garden" VARCHAR,
  "major_tools_and_equipment" VARCHAR,
  "small_tools_and_equipment" VARCHAR,
  "goods_and_services_for_routine_household_maintenance" VARCHAR,
  "non_durable_household_goods" VARCHAR,
  "domestic_and_household_services" 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
);

N 06cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_06cn
  • 44.77 KB
  • 142 rows
  • 67 columns
Loading... 

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
);

N 07cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_07cn
  • 51.17 KB
  • 142 rows
  • 67 columns
Loading... 

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
);

N 08cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_08cn
  • 40.43 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_08cn (
  "time_period_and_codes" VARCHAR,
  "communication" VARCHAR,
  "postal_services" VARCHAR,
  "telephone_and_telefax_equipment" VARCHAR,
  "telephone_and_telefax_services" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

N 0gscn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_0gscn
  • 44.57 KB
  • 142 rows
  • 66 columns
Loading... 

CREATE TABLE n_0gscn (
  "time_period_and_codes" VARCHAR,
  "total_expenditure" VARCHAR,
  "net_tourism" VARCHAR,
  "total_domestic_expenditure" VARCHAR,
  "total_goods" VARCHAR,
  "durable_goods" VARCHAR,
  "semi_durable_goods" VARCHAR,
  "non_durable_goods" VARCHAR,
  "services" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

N 10cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_10cn
  • 38.06 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_10cn (
  "time_period_and_codes" VARCHAR,
  "education" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

N 11cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_11cn
  • 41.81 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_11cn (
  "time_period_and_codes" VARCHAR,
  "restaurant_and_hotels" VARCHAR,
  "catering_services" VARCHAR,
  "restaurants_cafes_etc_note_3_note_4" VARCHAR,
  "canteens" VARCHAR,
  "accommodation" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

N 12cn

@kaggle.matarrgaye_uk_consumer_trends_current_price.n_12cn
  • 54.43 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE n_12cn (
  "time_period_and_codes" VARCHAR,
  "miscellaneous_goods_and_services" VARCHAR,
  "personal_care" VARCHAR,
  "hairdressing_salons_and_personal_grooming_establishments" VARCHAR,
  "electrical_appliances_for_personal_care" VARCHAR,
  "other_appliances_articles_and_products_for_personal_care" VARCHAR,
  "prostitution" VARCHAR,
  "personal_effects_n_e_c_note_7" VARCHAR,
  "jewellery_clocks_and_watches" VARCHAR,
  "other_personal_effects" 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_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
);

Ndgcn

@kaggle.matarrgaye_uk_consumer_trends_current_price.ndgcn
  • 72.13 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE ndgcn (
  "time_period_and_codes" VARCHAR,
  "total_non_durable_goods" VARCHAR,
  "food_and_non_alcoholic_beverages" VARCHAR,
  "food" VARCHAR,
  "bread_and_cereals" VARCHAR,
  "meat" VARCHAR,
  "fish" VARCHAR,
  "milk_cheese_and_eggs" VARCHAR,
  "oils_and_fats" VARCHAR,
  "fruit" VARCHAR,
  "vegetables" VARCHAR,
  "sugar_confectionery_and_ice_cream" VARCHAR,
  "other_food" VARCHAR,
  "non_alcoholic_beverages" VARCHAR,
  "coffee_tea_and_cocoa" VARCHAR,
  "fruit_and_vegetable_juices_and_other_soft_drinks" VARCHAR,
  "alcoholic_beverages_tobacco_and_narcotics" VARCHAR,
  "alcoholic_beverages_note_1" VARCHAR,
  "spirits" VARCHAR,
  "wines_cider_and_perry" VARCHAR,
  "beer" VARCHAR,
  "tobacco" VARCHAR,
  "narcotics" VARCHAR,
  "housing_water_electricity_gas_and_other_fuel" VARCHAR,
  "maintenance_and_repairs_of_the_dwelling_materials" VARCHAR,
  "water_supply" VARCHAR,
  "electricity_gas_and_other_fuels" VARCHAR,
  "electricity" VARCHAR,
  "gas" VARCHAR,
  "liquid_fuels" VARCHAR,
  "solid_fuels" VARCHAR,
  "heat_energy_note_6" VARCHAR,
  "household_goods" VARCHAR,
  "non_durable_household_goods" VARCHAR,
  "health" VARCHAR,
  "pharmaceutical_products" VARCHAR,
  "other_medical_products" VARCHAR,
  "transport" VARCHAR,
  "fuels_and_lubricants_for_personal_transport_equipment" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "garden_plants_and_flowers" VARCHAR,
  "pets_and_related_products" VARCHAR,
  "newspapers" VARCHAR,
  "miscellaneous_printed_matter" VARCHAR,
  "stationery_and_drawing_materials" VARCHAR,
  "miscellaneous" VARCHAR,
  "other_appliances_articles_and_products_for_personal_care" 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
);

Ocn

@kaggle.matarrgaye_uk_consumer_trends_current_price.ocn
  • 51.12 KB
  • 137 rows
  • 67 columns
Loading... 

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
);

Sdgcn

@kaggle.matarrgaye_uk_consumer_trends_current_price.sdgcn
  • 54.33 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE sdgcn (
  "time_period_and_codes" VARCHAR,
  "total_semi_durable_goods" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "clothing_materials" VARCHAR,
  "garments" VARCHAR,
  "other_articles_of_clothing_and_clothing_accessories" VARCHAR,
  "shoes_and_other_footwear" VARCHAR,
  "household_goods" VARCHAR,
  "household_textiles" VARCHAR,
  "small_electric_household_appliances" VARCHAR,
  "glassware_tableware_and_household_appliances" VARCHAR,
  "small_tools_and_equipment" VARCHAR,
  "transport" VARCHAR,
  "spare_parts_and_accessories_for_personal_transport_equipment" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "recording_media" VARCHAR,
  "games_toys_and_hobbies" VARCHAR,
  "equipment_for_sport_camping_and_open_air_recreation" VARCHAR,
  "books" VARCHAR,
  "miscellaneous" VARCHAR,
  "electrical_appliances_for_personal_care" VARCHAR,
  "other_personal_effects" 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
);

Sercn

@kaggle.matarrgaye_uk_consumer_trends_current_price.sercn
  • 89.51 KB
  • 142 rows
  • 69 columns
Loading... 

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
);

Tgcn

@kaggle.matarrgaye_uk_consumer_trends_current_price.tgcn
  • 47.33 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE tgcn (
  "time_period_and_codes" VARCHAR,
  "total_goods" VARCHAR,
  "food_and_non_alcoholic_beverages" VARCHAR,
  "alcoholic_beverages_and_tobacco_note_1" VARCHAR,
  "clothing_and_footwear" VARCHAR,
  "housing_water_electricity_gas_and_other_fuel" VARCHAR,
  "household_goods" VARCHAR,
  "health" VARCHAR,
  "transport" VARCHAR,
  "communication" VARCHAR,
  "recreation_and_culture" VARCHAR,
  "miscellaneous" 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
);

Tourcn

@kaggle.matarrgaye_uk_consumer_trends_current_price.tourcn
  • 40.19 KB
  • 142 rows
  • 67 columns
Loading... 

CREATE TABLE tourcn (
  "time_period_and_codes" VARCHAR,
  "net_tourism" VARCHAR,
  "foreign_tourist_expenditure" VARCHAR,
  "uk_tourist_expenditure_abroad" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

Share link

Anyone who has the link will be able to view this.