Workdocumentation 2020-09-01

From Openresearch
Jump to: navigation, search

OPENRESEARCH year distribution

query

select year,count(*) as count
from event_or
group by year
order by year

result

year count
None 718
16 1
20 1
1970 13
1973 1
1974 1
1975 2
1976 2
1977 2
1978 2
1979 2
1980 5
1981 2
1982 9
1983 9
1984 7
1985 8
1986 12
1987 16
1988 20
1989 21
1990 23
1991 23
1992 25
1993 29
1994 32
1995 34
1996 34
1997 42
1998 38
1999 42
2000 45
2001 46
2002 49
2003 53
2004 56
2005 60
2006 63
2007 387
2008 1576
2009 965
2010 285
2011 210
2012 208
2013 172
2014 98
2015 121
2016 513
2017 1010
2018 551
2019 455
2020 681
2021 44
2106 1

Invalid year entries

select eventId,title from event_or
where year<1970 or year > 2030
year eventId title
2106 ACIIDS 2016 (null)
20 RANDOM 2020 International Workshop on Randomization and Computation
16 VaMoS 2016 Variability Modelling of Software-Intensive Systems