Drought Events Based On SPI 6 Version 1.0

Joint Research Centre

@ecjrc.n_3cf5e33e_87e0_45bb_80ec_c4baa718a418

Table 2

@ecjrc.n_3cf5e33e_87e0_45bb_80ec_c4baa718a418.table_2

indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3 INDICATOR,"CTY CODE","MGN CODE","EVENT NR","EVENT NR CR","START DATE","PEAK DATE","END DATE","MAX EXT ON","DURATION","SEVERITY","INTENSITY","AVERAGE AREA","WIDEST AREA PERC","SCORE","GRP ID"
Spi-6,"","ALA",1,1,"1951-10-01","1951-11-01","1951-12-01","1951-11-01",3,3.49,1.16,35.99,39.58,4,5274
Spi-6,"","ALA",10,10,"1976-11-01","1976-11-01","1977-03-01","1976-12-01",5,4.8,0.96,29.37,36.38,3,5286
Spi-6,"","ALA",11,11,"1977-11-01","1978-03-01","1978-11-01","1978-03-01",13,22.06,1.7,31.29,52.16,15,5287
Spi-6,"","ALA",12,12,"1983-06-01","1984-04-01","1984-05-01","1984-04-01",12,10.26,0.85,18.87,29.78,6,5291
Spi-6,"","ALA",13,13,"1993-07-01","1993-07-01","1993-09-01","1993-07-01",3,3.03,1.01,24.67,32.72,3,5294
Spi-6,"","ALA",14,14,"1995-05-01","1996-01-01","1996-06-01","1996-01-01",14,17.8,1.27,24.36,42.16,10,5296
Spi-6,"","ALA",15,15,"1997-02-01","1997-04-01","1997-06-01","1997-04-01",5,6.71,1.34,24.87,34.93,8,5296
Spi-6,"","ALA",16,16,"1998-03-01","1998-04-01","1998-08-01","1998-04-01",6,6.43,1.07,28.91,35.98,6,5297
Spi-6,"","ALA",17,17,"1998-12-01","1999-03-01","1999-04-01","1999-03-01",5,8.14,1.63,30.76,38.22,10,5297
Spi-6,"","ALA",18,18,"2000-05-01","2000-06-01","2000-07-01","2000-06-01",3,4.31,1.44,27.88,37.23,8,5297


CREATE TABLE table_2 (
  "indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3" VARCHAR
);