Volunteer numbers for 2019/20 ACNC reports

[jamezpolley]

Similar to #299 but for the 2019/20 FY. Process is documented at https://github.com/openaustralia/oaf/wiki/Calculating-Volunteer-numbers-for-ACNC-reports

[jamezpolley]

RTK: 462 unique requestors, up from 317 the previous year. 957 total requests up from 816

deploy@ip-172-31-43-31:/srv/www/production/current$ bundle exec rails c production
Loading production environment (Rails 3.2.22.3)
irb(main):001:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2018-07-01", "2019-07-01").collect { |i| i.user }.uniq.count
  InfoRequest Load (15.5ms)  SELECT "info_requests".* FROM "info_requests" WHERE (created_at >= '2018-07-01' AND created_at < '2019-07-01')
=> 317
irb(main):002:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2019-07-01", "2020-07-01").collect { |i| i.user }.uniq.count
=> 462
irb(main):003:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2019-07-01", "2020-07-01").count
   (5.6ms)  SELECT COUNT(*) FROM "info_requests" WHERE (created_at >= '2019-07-01' AND created_at < '2020-07-01')
=> 957
irb(main):004:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2018-07-01", "2019-07-01").count
   (1.9ms)  SELECT COUNT(*) FROM "info_requests" WHERE (created_at >= '2018-07-01' AND created_at < '2019-07-01')
=> 816
irb(main):005:0>

[jamezpolley]

RTK breakdown by agency and state:

root@ip-172-31-43-31:~# psql -U rtk-production -d rtk-production -h postgresql.czhqms2kijym.ap-southeast-2.rds.amazonaws.com -AF,< agency-state-breakdown.psql > 1920.csv
root@ip-172-31-43-31:~# cat agency-state-breakdown.psql
SELECT t.name as name, pb.name as tag, COUNT(r.*) FROM info_requests as r, public_bodies as pb, has_tag_string_tags as t WHERE (r.created_at >= '2019-07-01' AND r.created_at < '2020-07-01') and r.public_body_id = pb.id and pb.id = t.model_id and t.name
in ('ACT','NSW','NT','QLD','SA','TAS','VIC','WA','federal') GROUP BY t.name, pb.name ORDER BY t.name, pb.name;
root@ip-172-31-43-31:~#

Full results at https://docs.google.com/spreadsheets/d/1llrfswJYgYSbWVgyMSf_tOkCqEeJ1vNWERrmR1fn9IA/edit#gid=804761463

state	count
ACT	7
federal	671
NSW	107
NT	7
QLD	57
SA	11
TAS	9
VIC	48
WA	43
Grand Total	960

state	agency	count
federal	Department of Home Affairs	141
federal	Department of Human Services	38
federal	Department of the Prime Minister and Cabinet	32
federal	NBN Co Limited	28
federal	Department of Health	27
federal	Australian Taxation Office	25
federal	Australian Federal Police	20
federal	Department of Communications and the Arts	18
federal	Department of Defence	18
federal	Department of Veterans' Affairs	17
federal	Australian Broadcasting Corporation	16
federal	Australian Securities and Investments Commission	15
federal	Administrative Appeals Tribunal	14
WA	Administrative Appeals Tribunal	14
federal	Department of the Treasury	13
federal	Attorney-General's Department	12
federal	Federal Court of Australia	12
federal	Australian Prudential Regulation Authority	10
federal	Department of Foreign Affairs and Trade	10
federal	Department of the Environment and Energy	10
federal	Therapeutic Goods Administration	9
NSW	Roads and Maritime Services	9
federal	Office of the Australian Information Commissioner	8
QLD	Brisbane City Council	8
federal	Department of Finance	7

[jamezpolley]

PlanningAlerts Contributors:

Total Contributions: 544 /tmp/pa_contribs/pa_contributors.txt
Contributors:
      1 Daniel Hoolihan
     15 James Polley
    500 Matthew Landauer
      1 Michael Bone
     27 muzza1976

Calculated with https://raw.githubusercontent.com/wiki/openaustralia/oaf/scripts/pa_contribs.sh

[jamezpolley]

Contributors as per https://raw.githubusercontent.com/wiki/openaustralia/oaf/scripts/contributor-count.sh (with dates changed)

2018-07-01 -> 2019-07-01:

     36 Ben Fairless
      1 Deploy user
      1 Eric Tam
    218 James Polley
      1 Kevin Liao
      6 Liz Conlan
      1 Martin Wright
   1051 Matthew Landauer
     18 MicaelaMicaela

2019-07-01 -> 2020-07-01:

      1 abimysoc
     11 dependabot[bot]
      2 Gareth Rees
      1 Graeme Porteous
    165 James Polley
      1 Liz Conlan
      1 Luke Bacon
     10 mackaymackay
   1357 Matthew Landauer
      7 MicaelaMicaela
      7 [email protected]
      1 Nigel Jones

REPOS=("morph"
       "morph-cli"
       "openaustralia-parser"
       "twfy"
       "publicwhip"
       "righttoknow"
       "planningalerts"
       "australian_local_councillors_images"
       "australian_local_councillors_popolo"
       "alaveteli"
       "infrastructure"
       "openaustralia"
       "yinyo"
       "buildstep"
      )