Staff Counts: Difference between revisions
update staff figures |
update for 2018 |
||
| Line 1: | Line 1: | ||
[[File: | [[File:Staff_over_Time_2018.png]] | ||
<!-- | |||
select year, sum(staff) as staff, sum(volunteer) as volunteers, count(user_id) as total | |||
from ( | |||
select year, user_id, MIN(rank) < 7 as staff, MIN(rank) = 7 as volunteer | |||
from staff | |||
where active = 1 | |||
group by year, user_id | |||
) as agg | |||
group by year | |||
order by year desc | |||
--> | |||
{| class="wikitable" style="text-align: right;" | {| class="wikitable" style="text-align: right;" | ||
| Line 9: | Line 21: | ||
|- | |- | ||
| 2018 | | 2018 | ||
| | | 56 | ||
| | | 38 | ||
| | | 94 | ||
|- | |- | ||
| 2017 | | 2017 | ||
| | | 74 | ||
| | | 51 | ||
| | | 125 | ||
|- | |- | ||
| 2016 | | 2016 | ||
| 72 | | 72 | ||
| | | 49 | ||
| | | 121 | ||
|- | |- | ||
| 2015 | | 2015 | ||
| 73 | | 73 | ||
| | | 68 | ||
| | | 141 | ||
|- | |- | ||
| 2014 | | 2014 | ||
| Line 45: | Line 57: | ||
| 2011 | | 2011 | ||
| 77 | | 77 | ||
| | | 20 | ||
| | | 97 | ||
|- | |- | ||
| 2010 | | 2010 | ||
| 44 | | 44 | ||
| | | 52 | ||
| | | 96 | ||
|} | |} | ||
Latest revision as of 06:59, 8 June 2019
| Year | Staff | Volunteers | Total |
|---|---|---|---|
| 2018 | 56 | 38 | 94 |
| 2017 | 74 | 51 | 125 |
| 2016 | 72 | 49 | 121 |
| 2015 | 73 | 68 | 141 |
| 2014 | 77 | 60 | 137 |
| 2013 | 68 | 75 | 143 |
| 2012 | 70 | 47 | 117 |
| 2011 | 77 | 20 | 97 |
| 2010 | 44 | 52 | 96 |