Drought Events Based On SPI 6 Version 1.0

Joint Research Centre

@ecjrc.n_3cf5e33e_87e0_45bb_80ec_c4baa718a418

Table 1

@ecjrc.n_3cf5e33e_87e0_45bb_80ec_c4baa718a418.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-6,"AFG","",1,1,"1952-11-01","1952-11-01","1953-09-01","1952-11-01",11,9.07,0.82,22.03,47.73,7,1
Spi-6,"AFG","",10,10,"1977-03-01","1977-07-01","1977-09-01","1977-07-01",7,10.38,1.48,40.84,82.27,13,17
Spi-6,"AFG","",11,11,"1978-06-01","1978-07-01","1978-10-01","1978-09-01",5,4.93,0.99,31.64,38.64,4,17
Spi-6,"AFG","",12,12,"1983-11-01","1984-02-01","1984-12-01","1984-02-01",14,17.12,1.22,33.57,58.18,11,19
Spi-6,"AFG","",13,13,"1985-02-01","1985-07-01","1986-07-01","1985-07-01",18,17.87,0.99,35.23,61.82,9,21
Spi-6,"AFG","",14,14,"1998-12-01","1998-12-01","1999-10-01","1998-12-01",11,14.32,1.3,40.62,70.45,13,26
Spi-6,"AFG","",15,15,"2000-03-01","2000-05-01","2000-10-01","2000-05-01",8,20.98,2.62,71.88,95.45,20,27
Spi-6,"AFG","",16,16,"2001-03-01","2001-06-01","2002-08-01","2001-06-01",18,27.17,1.51,43.18,95.45,16,28
Spi-6,"AFG","",17,17,"2004-03-01","2004-07-01","2004-10-01","2004-07-01",8,13.33,1.67,54.83,83.18,15,30
Spi-6,"AFG","",18,18,"2006-03-01","2006-07-01","2006-10-01","2006-07-01",8,10.4,1.3,40.28,64.55,11,33


CREATE TABLE table_1 (
  "indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3" VARCHAR
);