Community Health

Ratio of non-core committers (drive-by committers) Can indicate openess to outsiders

GHTorrent Database

## Commits from project members vs non-members

 Project members have commit rights for the repo.

### Number of Commits from Project Members

select count(commits.id) as num_member_commits, projects.name as project_name, projects.url as url
from
commits
join projects on projects.id = commits.project_id
join users on commits.author_id = users.id
join project_members on project_members.repo_id = projects.id
where project_members.user_id = commits.author_id
group by projects.id

### Number of Commits from non project members

select count(commits.id) as num_commits, projects.name as project_name, projects.url as url
from
commits
join projects on commits.project_id = projects.id
join users on users.id = commits.author_id
where (projects.id, users.id) not in
	(select repo_id, user_id from project_members)
group by projects.id

Describe how the metric is encoded for sharing and communicating between programs.

Papers released in the academic literature that uses the metric.

Links to websites that add value to the understanding of the metric.

Authors of the metric page and authors who made significant changes.