Upload voter rolls to the election software

[jpkrohling]

Either @bogdandrutu or @jpkrohling should work on this, perhaps with guidance from @lizthegrey, who did this last year.

[jpkrohling]

I just had a call with @lizthegrey and I believe I understand the process now:

1. get the GitHub IDs from devstats' dashboard "Developer Activity Counts by Repository Group", selecting the time frame to "Last year". Note that "Developer" here is misleading, as everything (not only code) is counted here. Ideally, the time frame would start when the last election finished, up to the cut-off date for the new election.
2. filter out the people with less than 20 contributions
3. upload the GitHub IDs to Helios
4. update the announcement issue to mention the eligible people

I'll work on a script to automate the first item.

[jpkrohling]

Instead of a script, I think it's easier to just the data from the dashboard itself and filter out the data manually

1. Go to the "Developer Activity Counts by Repository group" dashboard
2. Select "Last year" as the time range
3. On the data panel, open the drop-down menu and click "Inspect", "Data"
   
4. Download the CSV file
5. Filter out the people with less than 20 contributions

Alternatively, edit the panel and use the following query. The last step won't be necessary and the data will be cleaner to use on the next steps:

select 
  sub.name as name,
  sub.value 
from (
  select 
    split_part(name, '$$$', 1) as name,
    sum(value) as value
  from
    shdev
  where
    series = 'hdev_[[metric]][[repogroup]][[country]]'
    and period = '[[period]]'
  group by
    split_part(name, '$$$', 1)
) sub
where sub.value >= 20
order by name

[jpkrohling]

This is the current voter roll. The file has the GitHub names in the first column and the number of contributions in the second. I uploaded it already to Helios and will prepare the GitHub comments soon, but perhaps one of you could do a sanity check first?

I have 5988 contributions, which is in line with my expectations.

voter-roll.csv

[lizthegrey]

yup, my contribution count about tracks too, and 500 active contributors feels right for our project

[jpkrohling]

I ended up creating a repository with all the information and scripts: https://github.com/jpkrohling/voter-roll-otel-elections