Difference between revisions of "Workdocumentation 2020-09-01"
(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 14: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 |
