Difference between revisions of "Workdocumentation 2020-09-01"
(→OPENRESEARCH year distribution) |
|||
| Line 120: | Line 120: | ||
|- | |- | ||
||2106||1 | ||2106||1 | ||
| + | |} | ||
| + | = Invalid year entries = | ||
| + | <source lang='sql'> | ||
| + | select eventId,title from event_or | ||
| + | where year<1970 or year > 2030 | ||
| + | </source> | ||
| + | {|class="wikitable sortable" | ||
| + | |+ | ||
| + | !eventId !!title | ||
| + | |- | ||
| + | |[[ACIIDS 2016]] || (null) | ||
| + | |[[RANDOM 2020]]|| International Workshop on Randomization and Computation | ||
| + | |[[VaMoS 2016]] || Variability Modelling of Software-Intensive Systems | ||
|} | |} | ||
Revision as of 14:16, 1 September 2020
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
| eventId | title | ||||
|---|---|---|---|---|---|
| ACIIDS 2016 | (null) | RANDOM 2020 | International Workshop on Randomization and Computation | VaMoS 2016 | Variability Modelling of Software-Intensive Systems |
