Dairy Goods Sales Dataset

A comprehensive dataset on dairy farms, products, sales, and inventory tracking

@kaggle.suraj520_dairy_goods_sales_dataset

Table List

1 table(319.45 KB)

Dairy Dataset

@kaggle.suraj520_dairy_goods_sales_dataset.dairy_dataset

319.45 KB
4325 rows
23 columns

location Location	total_land_area_acres Total Land Area (acres)	number_of_cows Number Of Cows	farm_size Farm Size	date Date	product_id Product ID	product_name Product Name	brand Brand	quantity_liters_kg Quantity (liters/kg)	price_per_unit Price Per Unit	total_value Total Value	shelf_life_days Shelf Life (days)	storage_condition Storage Condition	production_date Production Date	expiration_date Expiration Date	quantity_sold_liters_kg Quantity Sold (liters/kg)	price_per_unit_sold Price Per Unit (sold)	approx_total_revenue_inr Approx. Total Revenue(INR)	customer_location Customer Location	sales_channel Sales Channel	quantity_in_stock_liters_kg Quantity In Stock (liters/kg)	minimum_stock_threshold_liters_kg Minimum Stock Threshold (liters/kg)	reorder_quantity_liters_kg Reorder Quantity (liters/kg)
Telangana	310.84	96	Medium	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	5	Ice Cream	Dodla Dairy	222.4	85.72	19064.128	25	Frozen	Mon Dec 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	7	82.24	575.68	Madhya Pradesh	Wholesale	215	19.55	64.03
Uttar Pradesh	19.19	44	Large	Wed Dec 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Milk	Amul	687.48	42.61	29293.5228	22	Tetra Pack	Sun Oct 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	558	39.24	21895.92	Kerala	Wholesale	129	43.17	181.1
Tamil Nadu	581.69	24	Medium	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	4	Yogurt	Dodla Dairy	503.48	36.5	18377.02	30	Refrigerated	Fri Jan 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	256	33.81	8655.36	Madhya Pradesh	Online	247	15.1	140.83
Telangana	908	89	Small	Sun Jun 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Cheese	Britannia Industries	823.36	26.52	21835.5072	72	Frozen	Wed May 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	601	28.92	17380.92	Rajasthan	Online	222	74.5	57.68
Maharashtra	861.95	21	Medium	Mon Dec 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	8	Buttermilk	Mother Dairy	147.77	83.85	12390.5145	11	Refrigerated	Sat Oct 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	145	83.07	12045.15	Jharkhand	Retail	2	76.02	33.4
Telangana	87.64	51	Medium	Mon Jan 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	6	Curd	Raj	593.92	85.54	50803.9168	5	Refrigerated	Thu Jan 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	74	84.75	6271.5	Gujarat	Retail	519	55.6	139.59
Karnataka	73.28	74	Small	Fri Aug 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Cheese	Dynamix Dairies	757.14	36.83	27885.4662	83	Frozen	Tue Jun 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	410	32.66	13390.6	Karnataka	Online	347	49.82	105.86
Bihar	67.61	77	Medium	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	9	Paneer	Mother Dairy	203.36	29.08	5913.7088	14	Refrigerated	Sun Jan 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	15	29.09	436.35	Haryana	Online	188	10.9	25.14
West Bengal	72.31	76	Medium	Sun Aug 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	6	Curd	Raj	949.12	22.79	21630.4448	6	Refrigerated	Sat Jun 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	860	24.77	21302.2	Jharkhand	Wholesale	89	85.71	32.03
Telangana	413.24	36	Large	Fri Mar 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8	Buttermilk	Mother Dairy	385.64	42.08	16227.731199999998	9	Refrigerated	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	108	46.15	4984.2	Tamil Nadu	Retail	277	93.61	66.26


CREATE TABLE dairy_dataset (
  "location" VARCHAR,
  "total_land_area_acres" DOUBLE,
  "number_of_cows" BIGINT,
  "farm_size" VARCHAR,
  "date" TIMESTAMP,
  "product_id" BIGINT,
  "product_name" VARCHAR,
  "brand" VARCHAR,
  "quantity_liters_kg" DOUBLE,
  "price_per_unit" DOUBLE,
  "total_value" DOUBLE,
  "shelf_life_days" BIGINT,
  "storage_condition" VARCHAR,
  "production_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "quantity_sold_liters_kg" BIGINT,
  "price_per_unit_sold" DOUBLE,
  "approx_total_revenue_inr" DOUBLE,
  "customer_location" VARCHAR,
  "sales_channel" VARCHAR,
  "quantity_in_stock_liters_kg" BIGINT,
  "minimum_stock_threshold_liters_kg" DOUBLE,
  "reorder_quantity_liters_kg" DOUBLE
);