Heliophysics Event Catalogue


Download as  VoTable or CSV
select bgd.nar, extract('days' from (bgd.mint-nbgd.maxt)) as dift, bgd.bgd_n, nbgd.maxt, bgd.mint, nbgd.mag_class from (select nar, min(time_start) as mint, count(*) as bgd_n from noaa_active_region_summary where time_start>='2012-03-01 00:00:00' AND time_start<='2016-04-01 23:59:59' and mag_class='Beta-Gamma-Delta' group by nar) bgd inner join (select nar, max(time_start) as maxt, mag_class from noaa_active_region_summary where time_start>='2012-03-01 00:00:00' AND time_start<='2016-04-01 23:59:59' and mag_class!='Beta-Gamma-Delta' group by nar, mag_class order by nar) nbgd on (bgd.nar = nbgd.nar) where bgd.mint > nbgd.maxt
nar dift bgd_n maxt mint mag_class
11515 5.0 4 2012-06-29 00:00:00.0 2012-07-04 00:00:00.0 Beta
11618 1.0 7 2012-11-21 00:00:00.0 2012-11-22 00:00:00.0 Beta-Gamma
11618 3.0 7 2012-11-19 00:00:00.0 2012-11-22 00:00:00.0 Beta
11620 4.0 3 2012-11-24 00:00:00.0 2012-11-28 00:00:00.0 Alpha
11620 3.0 3 2012-11-25 00:00:00.0 2012-11-28 00:00:00.0 Beta
11654 7.0 2 2013-01-09 00:00:00.0 2013-01-16 00:00:00.0 Alpha
11678 1.0 3 2013-02-19 00:00:00.0 2013-02-20 00:00:00.0 Beta
11726 2.0 5 2013-04-20 00:00:00.0 2013-04-22 00:00:00.0 Beta
11762 1.0 3 2013-06-03 00:00:00.0 2013-06-04 00:00:00.0 Beta-Gamma
11785 2.0 7 2013-07-03 00:00:00.0 2013-07-05 00:00:00.0 Beta
11785 3.0 7 2013-07-02 00:00:00.0 2013-07-05 00:00:00.0 Alpha
11787 5.0 1 2013-07-04 00:00:00.0 2013-07-09 00:00:00.0 Beta
11818 3.0 2 2013-08-14 00:00:00.0 2013-08-17 00:00:00.0 Beta-Gamma
11818 1.0 2 2013-08-16 00:00:00.0 2013-08-17 00:00:00.0 Beta
11875 1.0 9 2013-10-21 00:00:00.0 2013-10-22 00:00:00.0 Beta-Gamma
11875 4.0 9 2013-10-18 00:00:00.0 2013-10-22 00:00:00.0 Beta
11877 5.0 2 2013-10-19 00:00:00.0 2013-10-24 00:00:00.0 Alpha
11934 7.0 4 2013-12-22 00:00:00.0 2013-12-29 00:00:00.0 Beta
11934 1.0 4 2013-12-28 00:00:00.0 2013-12-29 00:00:00.0 Beta-Gamma
11936 6.0 3 2013-12-25 00:00:00.0 2013-12-31 00:00:00.0 Beta
11967 1.0 12 2014-01-29 00:00:00.0 2014-01-30 00:00:00.0 Beta-Gamma
11967 2.0 12 2014-01-28 00:00:00.0 2014-01-30 00:00:00.0 Beta
11974 5.0 7 2014-02-07 00:00:00.0 2014-02-12 00:00:00.0 Beta
11974 6.0 7 2014-02-06 00:00:00.0 2014-02-12 00:00:00.0 Alpha
11991 1.0 1 2014-03-04 00:00:00.0 2014-03-05 00:00:00.0 Beta-Gamma
12017 1.0 1 2014-03-29 00:00:00.0 2014-03-30 00:00:00.0 Beta-Delta
12021 2.0 1 2014-04-03 00:00:00.0 2014-04-05 00:00:00.0 Beta-Gamma
12051 1.0 5 2014-05-02 00:00:00.0 2014-05-03 00:00:00.0 Beta
12065 4.0 1 2014-05-22 00:00:00.0 2014-05-26 00:00:00.0 Alpha
12065 2.0 1 2014-05-24 00:00:00.0 2014-05-26 00:00:00.0 Beta
12080 2.0 9 2014-06-05 00:00:00.0 2014-06-07 00:00:00.0 Beta
12080 1.0 9 2014-06-06 00:00:00.0 2014-06-07 00:00:00.0 Beta-Gamma
12087 2.0 2 2014-06-11 00:00:00.0 2014-06-13 00:00:00.0 Beta-Delta
12108 3.0 4 2014-07-04 00:00:00.0 2014-07-07 00:00:00.0 Beta
12109 1.0 3 2014-07-06 00:00:00.0 2014-07-07 00:00:00.0 Beta-Gamma
12146 8.0 1 2014-08-20 00:00:00.0 2014-08-28 00:00:00.0 Alpha
12146 3.0 1 2014-08-25 00:00:00.0 2014-08-28 00:00:00.0 Beta
12158 4.0 2 2014-09-05 00:00:00.0 2014-09-09 00:00:00.0 Alpha
12158 1.0 2 2014-09-08 00:00:00.0 2014-09-09 00:00:00.0 Beta-Delta
12209 1.0 11 2014-11-15 00:00:00.0 2014-11-16 00:00:00.0 Beta-Gamma
12216 2.0 1 2014-11-22 00:00:00.0 2014-11-24 00:00:00.0 Beta-Delta
12219 3.0 1 2014-11-27 00:00:00.0 2014-11-30 00:00:00.0 Beta
12255 2.0 1 2015-01-10 00:00:00.0 2015-01-12 00:00:00.0 Alpha
12257 1.0 3 2015-01-11 00:00:00.0 2015-01-12 00:00:00.0 Beta-Delta
12257 3.0 3 2015-01-09 00:00:00.0 2015-01-12 00:00:00.0 Beta
12280 1.0 3 2015-02-08 00:00:00.0 2015-02-09 00:00:00.0 Beta-Gamma
12297 2.0 10 2015-03-07 00:00:00.0 2015-03-09 00:00:00.0 Alpha
12403 1.0 8 2015-08-22 00:00:00.0 2015-08-23 00:00:00.0 Beta-Gamma
12422 1.0 7 2015-09-26 00:00:00.0 2015-09-27 00:00:00.0 Beta-Gamma
12434 1.0 1 2015-10-17 00:00:00.0 2015-10-18 00:00:00.0 Beta-Gamma
12473 1.0 1 2015-12-26 00:00:00.0 2015-12-27 00:00:00.0 Beta-Gamma
12497 1.0 7 2016-02-11 00:00:00.0 2016-02-12 00:00:00.0 Beta-Gamma
12497 3.0 7 2016-02-09 00:00:00.0 2016-02-12 00:00:00.0 Beta


'
Designed and maintained by INAF-TRIESTE ASTRONOMICAL OBSERVATORY
Server monitoring