Food Prices In India

Food Prices in India

@kaggle.abhinavshaw09_food_prices_in_india

Table List

1 table(1.1 MB)

Food Prices Ind

@kaggle.abhinavshaw09_food_prices_in_india.food_prices_ind

1.1 MB
168496 rows
14 columns

date Date	admin1 Admin1	admin2 Admin2	market Market	latitude Latitude	longitude Longitude	category Category	commodity Commodity	unit Unit	priceflag Priceflag	pricetype Pricetype	currency Currency	price Price	usdprice Usdprice
#date	#adm1+name	#adm2+name	#loc+market+name	#geo+lat	#geo+lon	#item+type	#item+name	#item+unit	#item+price+flag	#item+price+type	#currency	#value	#value+usd
1994-01-15	Delhi	Delhi	Delhi	28.666667	77.216667	cereals and tubers	Rice	KG	actual	Retail	INR	8.0	0.255
1994-01-15	Delhi	Delhi	Delhi	28.666667	77.216667	miscellaneous food	Sugar	KG	actual	Retail	INR	13.5	0.4303
1994-01-15	Delhi	Delhi	Delhi	28.666667	77.216667	oil and fats	Oil (mustard)	KG	actual	Retail	INR	31.0	0.988
1994-01-15	Gujarat	Ahmadabad	Ahmedabad	23.033333	72.616667	cereals and tubers	Rice	KG	actual	Retail	INR	6.8	0.2167
1994-01-15	Gujarat	Ahmadabad	Ahmedabad	23.033333	72.616667	cereals and tubers	Wheat	KG	actual	Retail	INR	6.2	0.1976
1994-01-15	Gujarat	Ahmadabad	Ahmedabad	23.033333	72.616667	miscellaneous food	Sugar	KG	actual	Retail	INR	13.5	0.4303
1994-01-15	Gujarat	Ahmadabad	Ahmedabad	23.033333	72.616667	oil and fats	Oil (mustard)	KG	actual	Retail	INR	30.0	0.9562
1994-01-15	Himachal Pradesh	Shimla	Shimla	31.103333	77.172222	cereals and tubers	Rice	KG	actual	Retail	INR	9.0	0.2869
1994-01-15	Himachal Pradesh	Shimla	Shimla	31.103333	77.172222	miscellaneous food	Sugar	KG	actual	Retail	INR	13.75	0.4382


CREATE TABLE food_prices_ind (
  "date" VARCHAR,
  "admin1" VARCHAR,
  "admin2" VARCHAR,
  "market" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "category" VARCHAR,
  "commodity" VARCHAR,
  "unit" VARCHAR,
  "priceflag" VARCHAR,
  "pricetype" VARCHAR,
  "currency" VARCHAR,
  "price" VARCHAR,
  "usdprice" VARCHAR
);