Vital Food Costs: A Five-Nation Analysis 2018-2022

Comparing Vital Food Costs in Australia, Japan, Canada, South Africa & Sweden

@kaggle.sumangoda_food_prices

Table List

1 table(15.49 KB)

Food Prices

@kaggle.sumangoda_food_prices.food_prices

15.49 KB
1200 rows
10 columns

country Country	year Year	month Month	food_item Food Item	unit_of_measurement Unit Of Measurement	average_price Average Price	currency Currency	price_in_usd Price In USD	availability Availability	quality Quality
Australia	2018	1	Bread	Loaf	2.2	AUD	1.47	1	High
Australia	2018	2	Bread	Loaf	2.2	AUD	1.48	1	High
Australia	2018	3	Bread	Loaf	2.2	AUD	1.48	1	High
Australia	2018	4	Bread	Loaf	2.21	AUD	1.48	1	High
Australia	2018	5	Bread	Loaf	2.21	AUD	1.48	1	High
Australia	2018	6	Bread	Loaf	2.22	AUD	1.49	1	High
Australia	2018	7	Bread	Loaf	2.22	AUD	1.49	1	High
Australia	2018	8	Bread	Loaf	2.22	AUD	1.49	1	High
Australia	2018	9	Bread	Loaf	2.23	AUD	1.5	1	High
Australia	2018	10	Bread	Loaf	2.23	AUD	1.5	1	High


CREATE TABLE food_prices (
  "country" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "food_item" VARCHAR,
  "unit_of_measurement" VARCHAR,
  "average_price" DOUBLE,
  "currency" VARCHAR,
  "price_in_usd" DOUBLE,
  "availability" BIGINT,
  "quality" VARCHAR
);