Rice - Pest And Diseases

Weather based information of Rice pest and diseases

@kaggle.zsinghrahulk_rice_pest_and_diseases

Table List

1 table(186.87 KB)

Rice

@kaggle.zsinghrahulk_rice_pest_and_diseases.rice

186.87 KB
19404 rows
14 columns

observation_year Observation Year	standard_week Standard Week	collection_type Collection Type	maxt MaxT	mint MinT	rh1 RH1(%)	rh2 RH2(%)	rf_mm RF(mm)	ws_kmph WS(kmph)	ssh_hrs SSH(hrs)	evp_mm EVP(mm)	pest_name PEST NAME	location Location
2003	1	Number/hill	27.9	14.8	94.7	51.3		3.1	8.7	2.7	Brownplanthopper	Cuttack
2003	2	Number/hill	27.2	15	93.9	53.1		2.1	8.7	2.4	Brownplanthopper	Cuttack
2003	3	Number/hill	28.7	18.3	94.1	56.7	0.6	4.8	6.7	2.8	Brownplanthopper	Cuttack
2003	4	Number/hill	25.3	16.4	90.9	57.4	0.3	6.5	5.3	3	Brownplanthopper	Cuttack
2003	5	Number/hill	28.8	18.7	95.7	55		5.2	6.3	2.8	Brownplanthopper	Cuttack
2003	6	Number/hill	27.1	17.2	94.9	53.3	4.4	3.5	6.9	2.9	Brownplanthopper	Cuttack
2003	7	Number/hill	30.7	16	93.9	33		2.6	10.2	4	Brownplanthopper	Cuttack
2003	8	Number/hill	30.4	21.4	95.3	56.9	15.4	5.1	6.4	3.4	Brownplanthopper	Cuttack
2003	9	Number/hill	31.1	22.3	92.6	56.7	17.5	6	6.5	4.2	Brownplanthopper	Cuttack
2003	10	Number/hill	31.1	21.5	95.3	54.7		3.5	7.5	4.2	Brownplanthopper	Cuttack


CREATE TABLE rice (
  "observation_year" BIGINT,
  "standard_week" BIGINT,
  "pest_value" DOUBLE,
  "collection_type" VARCHAR,
  "maxt" DOUBLE,
  "mint" DOUBLE,
  "rh1" DOUBLE,
  "rh2" DOUBLE,
  "rf_mm" DOUBLE,
  "ws_kmph" DOUBLE,
  "ssh_hrs" DOUBLE,
  "evp_mm" DOUBLE,
  "pest_name" VARCHAR,
  "location" VARCHAR
);