Agriculture Dataset | Karnataka

Agriculture dataset Karnataka

@kaggle.imtkaggleteam_agriculture_dataset_karnataka

Table List

1 table(14.4 KB)

Data Season

@kaggle.imtkaggleteam_agriculture_dataset_karnataka.data_season

14.4 KB
3158 rows
12 columns

year Year	location Location	area Area	rainfall Rainfall	temperature Temperature	soil_type Soil Type	irrigation Irrigation	yeilds Yeilds	humidity Humidity	crops Crops	price Price	season Season
2004	Mangalore	1279	2903.1	27	Alluvial	Drip	2570	57	Coconut	200000	Kharif
2004	Mangalore	13283	2903.1	27	Alluvial	Drip	27170	57.5	Coconut	4847	Kharif
2004	Mangalore	52119	2903.1	27	Alluvial	Drip	114744	57	Coconut	51239	Kharif
2004	Mangalore	725	2996.6	27	Alluvial	Drip	1402	55	Coconut	216396	Kharif
2004	Mangalore	12885	2996.6	27	Alluvial	Drip	23456	56	Coconut	2644	Kharif
2004	Mangalore	51179	2996.6	27	Alluvial	Drip	107809	54	Coconut	44235	Kharif
2004	Mangalore	468	3522.8	27.2	Alluvial	Drip	1132	58	Coconut	203317	Kharif
2004	Mangalore	11841	3522.8	27.2	Alluvial	Drip	23960	58	Coconut	2134	Kharif
2004	Mangalore	50975	3522.8	27.2	Alluvial	Drip	126487	59	Coconut	45186	Kharif
2004	Mangalore	206	3729.8	27	Alluvial	Drip	804	50	Coconut	238542	Kharif


CREATE TABLE data_season (
  "year" BIGINT,
  "location" VARCHAR,
  "area" BIGINT,
  "rainfall" DOUBLE,
  "temperature" DOUBLE,
  "soil_type" VARCHAR,
  "irrigation" VARCHAR,
  "yeilds" DOUBLE,
  "humidity" DOUBLE,
  "crops" VARCHAR,
  "price" BIGINT,
  "season" VARCHAR
);