Drought Events Based On SPI 3 Version 1.0

Joint Research Centre

@ecjrc.c2bb3e2f_a726_4094_ae00_20ff6c12fd8c

Table 1

@ecjrc.c2bb3e2f_a726_4094_ae00_20ff6c12fd8c.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-3,"AFG","",1,1,"1952-10-01","1952-11-01","1953-06-01","1952-11-01",9,6.98,0.78,19.75,44.09,5,1
Spi-3,"AFG","",10,10,"1970-11-01","1971-01-01","1971-12-01","1971-01-01",14,23.47,1.68,43.21,88.64,17,14
Spi-3,"AFG","",11,11,"1973-10-01","1973-11-01","1974-01-01","1973-11-01",4,6.53,1.63,48.18,74.55,13,15
Spi-3,"AFG","",12,12,"1974-10-01","1974-11-01","1974-11-01","1974-11-01",2,3.3,1.65,44.32,60,10,15
Spi-3,"AFG","",13,13,"1977-03-01","1977-04-01","1977-09-01","1977-04-01",7,7.09,1.01,27.27,86.36,10,17
Spi-3,"AFG","",14,14,"1978-04-01","1978-06-01","1978-07-01","1978-06-01",4,4.21,1.05,31.93,47.27,6,17
Spi-3,"AFG","",15,15,"1983-11-01","1983-11-01","1984-11-01","1983-11-01",13,13.74,1.06,27.45,66.36,11,19
Spi-3,"AFG","",16,16,"1985-03-01","1985-04-01","1986-04-01","1985-04-01",14,11.75,0.84,27.5,61.36,8,20
Spi-3,"AFG","",17,17,"1996-12-01","1997-02-01","1997-03-01","1997-02-01",4,6.09,1.52,43.3,66.82,13,25
Spi-3,"AFG","",18,18,"1998-11-01","1998-12-01","1999-02-01","1998-12-01",4,6.68,1.67,42.95,89.55,14,26


CREATE TABLE table_1 (
  "indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3" VARCHAR
);