Open source boards and tenure terms: The FSF has stalled

There’s plenty of research establishing that boards should refresh their members regularly. Let’s see the numbers for the Free Software Foundation, Apache Software Foundation, Python Software Foundation and Open Source Initiative.

Rotation in open source boards: Average # of years served by members

Why boards should rotate

Source data

Sheet to SQL

// see https://github.com/fhoffa/snowflake_snippets/blob/main/open_source_boards/board_tenure.sqlunpivot as (
select f
, split(y.value, '\t')[0]::string who, z.index+2000-5 year
, row_number() over(partition by f, who order by year) years_served
from sheet4
, table(split_to_table(x, '\n')) y
, table(split_to_table(y.value, '\t')) z
where z.index>5
and z.value='1'
)
-- select *
-- from unpivot;
select f, year, avg(years_served)
from unpivot
group by 1,2
order by 1,2

Above average terms

Board members that have served for 9 years or more

Shared sheet

Learn more

Data Cloud Advocate at Snowflake ❄️. Originally from Chile, now in San Francisco and around the world. Previously at Google. Let’s talk data.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store