Staff Counts: Difference between revisions
Jump to navigation
Jump to search
(create table) |
(update for 2018) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[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 5: | Line 19: | ||
! Volunteers | ! Volunteers | ||
! Total | ! Total | ||
|- | |||
| 2018 | |||
| 56 | |||
| 38 | |||
| 94 | |||
|- | |||
| 2017 | |||
| 74 | |||
| 51 | |||
| 125 | |||
|- | |- | ||
| 2016 | | 2016 | ||
| 72 | | 72 | ||
| | | 49 | ||
| | | 121 | ||
|- | |- | ||
| 2015 | | 2015 | ||
| 73 | | 73 | ||
| | | 68 | ||
| | | 141 | ||
|- | |- | ||
| 2014 | | 2014 | ||
| Line 33: | 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 |