📈Consumer Price Index - 💰Economics

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,
  "fresh_fish_seafood" DOUBLE,
  "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_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,
  "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_imported" DOUBLE,
  "pork_domestic" DOUBLE,
  "pork_imported" DOUBLE,
  "chicken" DOUBLE,
  "meat_products" DOUBLE,
  "ham" DOUBLE,
  "sausages" DOUBLE,
  "bacon" DOUBLE,
  "seasoned_meat" DOUBLE,
  "dairy_products_eggs" DOUBLE,
  "fresh_milk_dairy_products" DOUBLE,
  "fresh_milk" DOUBLE,
  "fresh_milk_1" DOUBLE,
  "dairy_products" DOUBLE,
  "powdered_milk" DOUBLE,
  "yogurt" DOUBLE,
  "butter" DOUBLE,
  "cheese_domestic" DOUBLE,
  "cheese_imported" DOUBLE,
  "eggs" DOUBLE,
  "hen_eggs" DOUBLE,
  "vegetables_seaweeds" DOUBLE,
  "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_compositeindexexcludingimputedrent (
  "year" BIGINT,
  "all_items" DOUBLE,
  "goods" DOUBLE,
  "goods_less_fresh_food" DOUBLE,
  "agricultural_aquatic_livestock_products" DOUBLE,
  "fresh_food_raw_meats_cut_flowers" DOUBLE,
  "other_agricultural_aquatic_livestock_products" DOUBLE,
  "rice" DOUBLE,
  "industrial_products" DOUBLE,
  "food_products" DOUBLE,
  "textiles" DOUBLE,
  "petroleum_products" DOUBLE,
  "other_industrial_products" DOUBLE,
  "electricity_manufactured_piped_gas_water_charges" DOUBLE,
  "publications" DOUBLE,
  "services" DOUBLE,
  "services_less_imputed_rent" DOUBLE,
  "public_services" DOUBLE,
  "meals_outside_the_home" DOUBLE,
  "house_rent_public_urban_renaissance_agency_public_corporation" DOUBLE,
  "services_related_to_domestic_duties" DOUBLE,
  "services_related_to_medical_care_welfare" DOUBLE,
  "services_related_to_forwarding_communication" DOUBLE,
  "services_related_to_education" DOUBLE,
  "services_related_to_culture_recreation" DOUBLE,
  "general_services" DOUBLE,
  "meals_outside_the_home_1" DOUBLE,
  "house_rent_private" DOUBLE,
  "house_rent_private_wooden" DOUBLE,
  "house_rent_private_non_wooden" DOUBLE,
  "imputed_rent" DOUBLE,
  "imputed_rent_wooden" DOUBLE,
  "imputed_rent_non_wooden" DOUBLE,
  "other_services" DOUBLE,
  "services_related_to_domestic_duties_1" DOUBLE,
  "services_related_to_medical_care_welfare_1" DOUBLE,
  "services_related_to_education_1" DOUBLE,
  "services_related_to_communication_culture_recreation" DOUBLE,
  "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_imputed_rent" DOUBLE,
  "all_items_less_imputed_rent_fresh_food" DOUBLE,
  "all_items_less_fresh_food_and_energy" DOUBLE,
  "all_items_less_food_less_alcoholic_beverages_and_energy" DOUBLE,
  "food" DOUBLE,
  "fresh_food" DOUBLE,
  "food_less_fresh_food" DOUBLE,
  "cereals" DOUBLE,
  "fish_seafood" DOUBLE,
  "fresh_fish_seafood_reentry" DOUBLE,
  "meats" DOUBLE,
  "dairy_products_eggs" DOUBLE,
  "vegetables_seaweeds" DOUBLE,
  "fresh_vegetables_reentry" DOUBLE,
  "fruits" DOUBLE,
  "fresh_fruits_reentry" DOUBLE,
  "oils_fats_seasonings" DOUBLE,
  "cakes_candies" DOUBLE,
  "cooked_food" DOUBLE,
  "beverages" DOUBLE,
  "alcoholic_beverages" DOUBLE,
  "meals_outside_the_home" DOUBLE,
  "housing" DOUBLE,
  "housing_less_imputed_rent" DOUBLE,
  "rent" DOUBLE,
  "rent_less_imputed_rent" DOUBLE,
  "repairs_maintenance" DOUBLE,
  "fuel_light_water_charges" DOUBLE,
  "electricity" DOUBLE,
  "gas" DOUBLE,
  "other_fuel_light" DOUBLE,
  "water_sewerage_charges" DOUBLE,
  "furniture_household_utensils" DOUBLE,
  "household_durable_goods" DOUBLE,
  "interior_furnishings" DOUBLE,
  "bedding" DOUBLE,
  "domestic_utensils" DOUBLE,
  "domestic_non_durable_goods" DOUBLE,
  "domestic_services" DOUBLE,
  "clothes_footwear" DOUBLE,
  "clothes" DOUBLE,
  "japanese_clothing" DOUBLE,
  "clothing" DOUBLE,
  "shirts_sweaters_underwear" DOUBLE,
  "shirts_sweaters" DOUBLE,
  "underwear" DOUBLE,
  "footwear" DOUBLE,
  "other_clothing" DOUBLE,
  "services_related_to_clothing" DOUBLE,
  "medical_care" DOUBLE,
  "medicines_health_fortification" DOUBLE,
  "medical_supplies_appliances" DOUBLE,
  "medical_services" DOUBLE,
  "transportation_communication" DOUBLE,
  "public_transportation" DOUBLE,
  "private_transportation" DOUBLE,
  "communication" DOUBLE,
  "education" DOUBLE,
  "school_fees" DOUBLE,
  "school_textbooks_reference_books_for_study" DOUBLE,
  "tutorial_fees" DOUBLE,
  "culture_recreation" DOUBLE,
  "recreational_durable_goods" DOUBLE,
  "recreational_goods" DOUBLE,
  "books_other_reading_materials" DOUBLE,
  "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_information_communication" DOUBLE
);

CREATE TABLE n_2022_japan_cpi_priceindexbyitems (
  "year" BIGINT,
  "all_items_less_imputed_rent" DOUBLE
);