Drought Events Based On SPI 12 Version 1.0

Joint Research Centre

@ecjrc.n_77ece7c8_dd09_4006_a544_245761d310a5

Table 2

@ecjrc.n_77ece7c8_dd09_4006_a544_245761d310a5.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-12,"","ALA",1,1,"1957-10-01","1958-02-01","1959-08-01","1958-02-01",23,26.76,1.16,28.44,51.2,10,5278
Spi-12,"","ALA",10,10,"2014-12-01","2015-07-01","2016-12-01","2015-07-01",25,29.05,1.16,28.38,39.48,9,5305
Spi-12,"","ALA",2,2,"1966-09-01","1966-09-01","1967-03-01","1966-09-01",7,4.37,0.62,18.68,23.38,1,5280
Spi-12,"","ALA",3,3,"1968-11-01","1969-06-01","1970-09-01","1969-06-01",23,46.5,2.02,40.1,54.59,19,5281
Spi-12,"","ALA",4,4,"1978-02-01","1978-09-01","1979-08-01","1978-09-01",19,21.42,1.13,24.27,48.62,9,5288
Spi-12,"","ALA",5,5,"1983-12-01","1983-12-01","1984-06-01","1983-12-01",7,6.16,0.88,21,27.39,3,5291
Spi-12,"","ALA",6,6,"1995-06-01","1995-12-01","1997-08-01","1995-06-01",27,29.55,1.09,24.79,39.19,10,5296
Spi-12,"","ALA",7,7,"1998-11-01","1998-12-01","1999-10-01","1998-12-01",12,9.32,0.78,21.63,34.5,2,5297
Spi-12,"","ALA",8,8,"2004-07-01","2004-08-01","2005-06-01","2004-08-01",12,16.92,1.41,30.6,42.59,11,5300
Spi-12,"","ALA",9,9,"2013-08-01","2013-09-01","2014-06-01","2014-05-01",11,7.61,0.69,21.77,27.29,2,5304


CREATE TABLE table_2 (
  "indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3" VARCHAR
);