Rainfall In India

Sub-division wise monthly data for 115 years from 1901-2015.

@kaggle.rajanand_rainfall_in_india

Table List

2 tables(321.18 KB)

Rainfall In India 1901–2015

District Wise Rainfall Normal

@kaggle.rajanand_rainfall_in_india.district_wise_rainfall_normal

65.42 KB
641 rows
19 columns

state_ut_name STATE UT NAME	district DISTRICT	jan JAN	feb FEB	mar MAR	apr APR	may MAY	jun JUN	jul JUL	aug AUG	sep SEP	oct OCT	nov NOV	dec DEC	annual ANNUAL	jan_feb Jan-Feb	mar_may Mar-May	jun_sep Jun-Sep	oct_dec Oct-Dec
ANDAMAN And NICOBAR ISLANDS	NICOBAR	107.3	57.9	65.2	117	358.5	295.5	285	271.9	354.8	326	315.2	250.9	2805.2	165.2	540.7	1207.2	892.1
ANDAMAN And NICOBAR ISLANDS	SOUTH ANDAMAN	43.7	26	18.6	90.5	374.4	457.2	421.3	423.1	455.6	301.2	275.8	128.3	3015.7	69.7	483.5	1757.2	705.3
ANDAMAN And NICOBAR ISLANDS	N & M ANDAMAN	32.7	15.9	8.6	53.4	343.6	503.3	465.4	460.9	454.8	276.1	198.6	100	2913.3	48.6	405.6	1884.4	574.7
ARUNACHAL PRADESH	LOHIT	42.2	80.8	176.4	358.5	306.4	447	660.1	427.8	313.6	167.1	34.1	29.8	3043.8	123	841.3	1848.5	231
ARUNACHAL PRADESH	EAST SIANG	33.3	79.5	105.9	216.5	323	738.3	990.9	711.2	568	206.9	29.5	31.7	4034.7	112.8	645.4	3008.4	268.1
ARUNACHAL PRADESH	SUBANSIRI F.D	28	48.3	85.3	101.5	140.5	228.4	217.4	182.8	159.8	75.9	20.9	11.6	1300.4	76.3	327.3	788.4	108.4
ARUNACHAL PRADESH	TIRAP	42.2	72.7	141	316.9	328.7	614.7	851.9	500.6	418.3	218.7	42.9	22.9	3571.5	114.9	786.6	2385.5	284.5
ARUNACHAL PRADESH	ANJAW (LOHIT)	42.2	80.8	176.4	358.5	306.4	447	660.1	427.8	313.6	167.1	34.1	29.8	3043.8	123	841.3	1848.5	231
ARUNACHAL PRADESH	LOWER DIBANG	83.7	153.9	303.5	383.6	268	374.2	272	160.5	266.7	167.2	64	56	2553.3	237.6	955.1	1073.4	287.2
ARUNACHAL PRADESH	CHANGLANG	70.3	170.9	367.9	554.4	334.2	526.2	460.8	291.5	353.6	275	64.9	74.2	3543.9	241.2	1256.5	1632.1	414.1


CREATE TABLE district_wise_rainfall_normal (
  "state_ut_name" VARCHAR,
  "district" VARCHAR,
  "jan" DOUBLE,
  "feb" DOUBLE,
  "mar" DOUBLE,
  "apr" DOUBLE,
  "may" DOUBLE,
  "jun" DOUBLE,
  "jul" DOUBLE,
  "aug" DOUBLE,
  "sep" DOUBLE,
  "oct" DOUBLE,
  "nov" DOUBLE,
  "dec" DOUBLE,
  "annual" DOUBLE,
  "jan_feb" DOUBLE,
  "mar_may" DOUBLE,
  "jun_sep" DOUBLE,
  "oct_dec" DOUBLE
);