Workdocumentation 2020-09-01

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