📈Consumer Price Index - 💰Economics

CREATE TABLE n_2022_japan_cpi_compositeindexexcludingimputedrent (
  "year" BIGINT,
  "all_items" DOUBLE,
  "goods" DOUBLE,
  "goods_less_fresh_food" DOUBLE  -- Goods, Less Fresh Food,
  "agricultural_aquatic_livestock_products" DOUBLE  -- Agricultural, Aquatic & Livestock Products,
  "fresh_food_raw_meats_cut_flowers" DOUBLE  -- Fresh Food, Raw Meats & Cut Flowers,
  "other_agricultural_aquatic_livestock_products" DOUBLE  -- Other Agricultural, Aquatic & Livestock Products,
  "rice" DOUBLE,
  "industrial_products" DOUBLE,
  "food_products" DOUBLE,
  "textiles" DOUBLE,
  "petroleum_products" DOUBLE,
  "other_industrial_products" DOUBLE,
  "electricity_manufactured_piped_gas_water_charges" DOUBLE  -- Electricity, Manufactured & Piped Gas & Water Charges,
  "publications" DOUBLE,
  "services" DOUBLE,
  "services_less_imputed_rent" DOUBLE  -- Services, Less Imputed Rent,
  "public_services" DOUBLE,
  "meals_outside_the_home" DOUBLE,
  "house_rent_public_urban_renaissance_agency_public_corporation" DOUBLE  -- House Rent, Public, Urban Renaissance Agency & Public Corporation,
  "services_related_to_domestic_duties" DOUBLE,
  "services_related_to_medical_care_welfare" DOUBLE  -- Services Related To Medical Care & Welfare,
  "services_related_to_forwarding_communication" DOUBLE  -- Services Related To Forwarding & Communication,
  "services_related_to_education" DOUBLE,
  "services_related_to_culture_recreation" DOUBLE  -- Services Related To Culture & Recreation,
  "general_services" DOUBLE,
  "meals_outside_the_home_1" DOUBLE,
  "house_rent_private" DOUBLE  -- House Rent, Private,
  "house_rent_private_wooden" DOUBLE  -- House Rent, Private (wooden),
  "house_rent_private_non_wooden" DOUBLE  -- House Rent, Private (non-wooden),
  "imputed_rent" DOUBLE,
  "imputed_rent_wooden" DOUBLE  -- Imputed Rent (wooden),
  "imputed_rent_non_wooden" DOUBLE  -- Imputed Rent (non-wooden),
  "other_services" DOUBLE,
  "services_related_to_domestic_duties_1" DOUBLE,
  "services_related_to_medical_care_welfare_1" DOUBLE  -- Services Related To Medical Care & Welfare.1,
  "services_related_to_education_1" DOUBLE,
  "services_related_to_communication_culture_recreation" DOUBLE  -- Services Related To Communication, Culture & Recreation,
  "durable_goods" DOUBLE,
  "semi_durable_goods" DOUBLE,
  "non_durable_goods" DOUBLE,
  "public_utilities_charges" DOUBLE
);

CREATE TABLE n_2022_japan_cpi_goodsandserviceclassificationindex (
  "year" BIGINT,
  "all_items" DOUBLE,
  "all_items_less_fresh_food" DOUBLE  -- All Items, Less Fresh Food,
  "all_items_less_imputed_rent" DOUBLE  -- All Items, Less Imputed Rent,
  "all_items_less_imputed_rent_fresh_food" DOUBLE  -- All Items, Less Imputed Rent & Fresh Food,
  "all_items_less_fresh_food_and_energy" DOUBLE  -- All Items, Less Fresh Food And Energy,
  "all_items_less_food_less_alcoholic_beverages_and_energy" DOUBLE  -- All Items, Less Food (less Alcoholic Beverages) And Energy,
  "food" DOUBLE,
  "fresh_food" DOUBLE,
  "food_less_fresh_food" DOUBLE  -- Food, Less Fresh Food,
  "cereals" DOUBLE,
  "fish_seafood" DOUBLE  -- Fish & Seafood,
  "fresh_fish_seafood_reentry" DOUBLE  -- Fresh Fish & Seafood (reentry),
  "meats" DOUBLE,
  "dairy_products_eggs" DOUBLE  -- Dairy Products & Eggs,
  "vegetables_seaweeds" DOUBLE  -- Vegetables & Seaweeds,
  "fresh_vegetables_reentry" DOUBLE  -- Fresh Vegetables (reentry),
  "fruits" DOUBLE,
  "fresh_fruits_reentry" DOUBLE  -- Fresh Fruits (reentry),
  "oils_fats_seasonings" DOUBLE  -- Oils, Fats & Seasonings,
  "cakes_candies" DOUBLE  -- Cakes & Candies,
  "cooked_food" DOUBLE,
  "beverages" DOUBLE,
  "alcoholic_beverages" DOUBLE,
  "meals_outside_the_home" DOUBLE,
  "housing" DOUBLE,
  "housing_less_imputed_rent" DOUBLE  -- Housing, Less Imputed Rent,
  "rent" DOUBLE,
  "rent_less_imputed_rent" DOUBLE  -- Rent, Less Imputed Rent,
  "repairs_maintenance" DOUBLE  -- Repairs & Maintenance,
  "fuel_light_water_charges" DOUBLE  -- Fuel, Light & Water Charges,
  "electricity" DOUBLE,
  "gas" DOUBLE,
  "other_fuel_light" DOUBLE  -- Other Fuel & Light,
  "water_sewerage_charges" DOUBLE  -- Water & Sewerage Charges,
  "furniture_household_utensils" DOUBLE  -- Furniture & Household Utensils,
  "household_durable_goods" DOUBLE,
  "interior_furnishings" DOUBLE,
  "bedding" DOUBLE,
  "domestic_utensils" DOUBLE,
  "domestic_non_durable_goods" DOUBLE,
  "domestic_services" DOUBLE,
  "clothes_footwear" DOUBLE  -- Clothes & Footwear,
  "clothes" DOUBLE,
  "japanese_clothing" DOUBLE,
  "clothing" DOUBLE,
  "shirts_sweaters_underwear" DOUBLE  -- Shirts, Sweaters & Underwear,
  "shirts_sweaters" DOUBLE  -- Shirts & Sweaters,
  "underwear" DOUBLE,
  "footwear" DOUBLE,
  "other_clothing" DOUBLE,
  "services_related_to_clothing" DOUBLE,
  "medical_care" DOUBLE,
  "medicines_health_fortification" DOUBLE  -- Medicines & Health Fortification,
  "medical_supplies_appliances" DOUBLE  -- Medical Supplies & Appliances,
  "medical_services" DOUBLE,
  "transportation_communication" DOUBLE  -- Transportation & Communication,
  "public_transportation" DOUBLE,
  "private_transportation" DOUBLE,
  "communication" DOUBLE,
  "education" DOUBLE,
  "school_fees" DOUBLE,
  "school_textbooks_reference_books_for_study" DOUBLE  -- School Textbooks & Reference Books For Study,
  "tutorial_fees" DOUBLE,
  "culture_recreation" DOUBLE  -- Culture & Recreation,
  "recreational_durable_goods" DOUBLE,
  "recreational_goods" DOUBLE,
  "books_other_reading_materials" DOUBLE  -- Books & Other Reading Materials,
  "recreational_services" DOUBLE,
  "miscellaneous" DOUBLE,
  "personal_care_services" DOUBLE,
  "toilet_articles" DOUBLE,
  "personal_effects" DOUBLE,
  "tobacco" DOUBLE,
  "other_miscellaneous" DOUBLE,
  "energy" DOUBLE,
  "expenses_for_education" DOUBLE,
  "expenses_for_culture_recreation" DOUBLE  -- Expenses For Culture & Recreation,
  "expenses_for_information_communication" DOUBLE  -- Expenses For Information & Communication
);

CREATE TABLE n_2022_japan_cpi_middlelevelclassificationindex (
  "year" BIGINT,
  "all_items" DOUBLE,
  "food" DOUBLE,
  "cereals" DOUBLE,
  "rice" DOUBLE,
  "non_glutinous_rice_a" DOUBLE,
  "non_glutinous_rice_b" DOUBLE,
  "bread" DOUBLE,
  "white_bread" DOUBLE,
  "bean_jam_buns" DOUBLE,
  "curry_buns" DOUBLE,
  "noodles" DOUBLE,
  "boiled_udon" DOUBLE,
  "somen_fine_wheat_noodles" DOUBLE,
  "spaghetti" DOUBLE,
  "instant_noodles_in_cups" DOUBLE,
  "chinese_noodles" DOUBLE,
  "other_cereals" DOUBLE,
  "wheat_flour" DOUBLE,
  "mochi_rice_cakes" DOUBLE,
  "cereal" DOUBLE,
  "fish_seafood" DOUBLE  -- Fish & Seafood,
  "fresh_fish_seafood" DOUBLE  -- Fresh Fish & Seafood,
  "tuna_fish" DOUBLE,
  "horse_mackerel" DOUBLE,
  "sardines" DOUBLE,
  "bonito" DOUBLE,
  "salmon" DOUBLE,
  "mackerel" DOUBLE,
  "saury" DOUBLE,
  "sea_bream" DOUBLE,
  "yellowtail" DOUBLE,
  "cuttlefish" DOUBLE,
  "octopus" DOUBLE,
  "prawns" DOUBLE,
  "short_necked_clams" DOUBLE,
  "oysters" DOUBLE,
  "scallops" DOUBLE,
  "salted_dried_fish" DOUBLE  -- Salted & Dried Fish,
  "salted_salmon" DOUBLE,
  "salted_cod_roe" DOUBLE,
  "shirasu_boshi_dried_young_sardines" DOUBLE,
  "dried_horse_mackerel" DOUBLE,
  "niboshi_dried_small_sardines" DOUBLE,
  "capelin" DOUBLE,
  "salmon_roe" DOUBLE,
  "fish_paste_products" DOUBLE,
  "agekamaboko_fried_fish_paste_patties" DOUBLE,
  "chikuwa_baked_fish_paste_bars" DOUBLE,
  "kamaboko_steamed_fish_paste_cakes" DOUBLE,
  "other_processed_fish_seafood" DOUBLE  -- Other Processed Fish & Seafood,
  "dried_bonito_fillets" DOUBLE,
  "pickled_fish" DOUBLE,
  "fish_prepared_in_soy_sauce" DOUBLE,
  "canned_fish" DOUBLE,
  "meats" DOUBLE,
  "raw_meats" DOUBLE,
  "beef_domestic" DOUBLE  -- Beef (domestic),
  "beef_imported" DOUBLE  -- Beef (imported),
  "pork_domestic" DOUBLE  -- Pork (domestic),
  "pork_imported" DOUBLE  -- Pork (imported),
  "chicken" DOUBLE,
  "meat_products" DOUBLE,
  "ham" DOUBLE,
  "sausages" DOUBLE,
  "bacon" DOUBLE,
  "seasoned_meat" DOUBLE,
  "dairy_products_eggs" DOUBLE  -- Dairy Products & Eggs,
  "fresh_milk_dairy_products" DOUBLE  -- Fresh Milk & Dairy Products,
  "fresh_milk" DOUBLE,
  "fresh_milk_1" DOUBLE,
  "dairy_products" DOUBLE,
  "powdered_milk" DOUBLE,
  "yogurt" DOUBLE,
  "butter" DOUBLE,
  "cheese_domestic" DOUBLE  -- Cheese (domestic),
  "cheese_imported" DOUBLE  -- Cheese (imported),
  "eggs" DOUBLE,
  "hen_eggs" DOUBLE,
  "vegetables_seaweeds" DOUBLE  -- Vegetables & Seaweeds,
  "fresh_vegetables" DOUBLE,
  "cabbage" DOUBLE,
  "spinach" DOUBLE,
  "chinese_cabbage" DOUBLE,
  "welsh_onions" DOUBLE,
  "lettuce" DOUBLE,
  "broccoli" DOUBLE,
  "bean_sprouts" DOUBLE,
  "asparagus" DOUBLE,
  "sweet_potatoes" DOUBLE,
  "white_potatoes" DOUBLE,
  "taros" DOUBLE,
  "radishes" DOUBLE,
  "carrots" DOUBLE,
  "burdocks" DOUBLE,
  "onions" DOUBLE,
  "lotus_roots" DOUBLE,
  "naga_imo_yams" DOUBLE,
  "ginger" DOUBLE,
  "green_soybeans" DOUBLE
);

CREATE TABLE n_2022_japan_cpi_priceindexbyitems (
  "year" BIGINT,
  "all_items_less_imputed_rent" DOUBLE  -- All Items, Less Imputed Rent
);