Drought Events Based On SPI 3 Version 1.0

Joint Research Centre

@ecjrc.c2bb3e2f_a726_4094_ae00_20ff6c12fd8c

Table 2

@ecjrc.c2bb3e2f_a726_4094_ae00_20ff6c12fd8c.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-3,"","ALA",1,1,"1953-01-01","1953-01-01","1953-07-01","1953-01-01",7,8,1.14,27.58,39.28,7,5275
Spi-3,"","ALA",10,10,"1971-07-01","1971-07-01","1971-09-01","1971-07-01",3,3.51,1.17,27.55,34.52,5,5282
Spi-3,"","ALA",11,11,"1972-07-01","1972-08-01","1972-10-01","1972-08-01",4,4.03,1.01,19.79,22.7,5,5283
Spi-3,"","ALA",12,12,"1976-08-01","1976-10-01","1976-12-01","1976-08-01",5,5.89,1.18,32.11,35.67,6,5286
Spi-3,"","ALA",13,13,"1977-08-01","1978-03-01","1978-05-01","1978-03-01",10,16.92,1.69,33.36,53,15,5287
Spi-3,"","ALA",14,14,"1980-12-01","1980-12-01","1981-02-01","1980-12-01",3,2.92,0.97,25.76,33.72,2,5288
Spi-3,"","ALA",15,15,"1982-01-01","1982-02-01","1982-03-01","1982-02-01",3,3.95,1.32,31.46,35.99,7,5289
Spi-3,"","ALA",16,16,"1983-12-01","1983-12-01","1984-01-01","1983-12-01",2,3.81,1.91,39.14,45.5,11,5291
Spi-3,"","ALA",17,17,"1993-04-01","1993-07-01","1993-08-01","1993-07-01",5,5.03,1.01,22.75,29.05,5,5294
Spi-3,"","ALA",18,18,"1994-08-01","1994-09-01","1994-10-01","1994-08-01",3,3.81,1.27,36.24,40.54,6,5295


CREATE TABLE table_2 (
  "indicator_cty_code_mgn_code_event_nr_event_nr_cr_start_64dccde3" VARCHAR
);