Difference between revisions of "Workdocumentation 2020-09-01"

From Openresearch
Jump to: navigation, search
(Created page with "== OPENRESEARCH year distribution == === query === <source lang='sql'> select year,count(*) as count from event_or group by year order by year </source...")
 
(OPENRESEARCH year distribution)
Line 6: Line 6:
 
group by year
 
group by year
 
order by year                       
 
order by year                       
 
 
</source>
 
</source>
  

Revision as of 15:03, 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