Drought Events Based On SPI 12 Version 1.0

Joint Research Centre

@ecjrc.n_77ece7c8_dd09_4006_a544_245761d310a5

Table 1

@ecjrc.n_77ece7c8_dd09_4006_a544_245761d310a5.table_1

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,"AFG","",1,1,"1955-02-01","1955-02-01","1956-01-01","1955-02-01",12,13.67,1.14,25.34,77.73,8,4
Spi-12,"AFG","",2,2,"1963-02-01","1963-02-01","1963-04-01","1963-02-01",3,2.95,0.98,21.06,28.64,2,11
Spi-12,"AFG","",3,3,"1970-05-01","1971-10-01","1972-02-01","1971-01-01",22,46.55,2.12,62.81,94.09,20,14
Spi-12,"AFG","",4,4,"1977-04-01","1977-10-01","1979-04-01","1977-09-01",25,18.82,0.75,17.51,39.09,4,17
Spi-12,"AFG","",5,5,"1984-04-01","1986-01-01","1988-03-01","1986-01-01",48,51.57,1.07,32.54,69.55,13,22
Spi-12,"AFG","",6,6,"1999-05-01","2000-11-01","2003-02-01","2001-12-01",46,77.82,1.69,54.46,94.09,18,28
Spi-12,"AFG","",7,7,"2004-03-01","2004-11-01","2005-01-01","2004-11-01",11,14.75,1.34,40.99,53.18,9,30
Spi-12,"AFG","",8,8,"2006-05-01","2006-05-01","2006-11-01","2006-05-01",7,9.37,1.34,43.96,61.36,8,32
Spi-12,"AFG","",9,9,"2008-03-01","2008-07-01","2009-02-01","2009-01-01",12,14.65,1.22,40.34,49.09,8,36
Spi-12,"AGO","",10,1,"1958-11-01","1958-12-01","1959-03-01","1958-12-01",5,5.38,1.07,30.72,50.72,7,42


CREATE TABLE table_1 (
  "indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3" VARCHAR
);