Community Health

Number of forks

### Number of direct forks for each project that is not itself a fork (does not take into account forks of forks)

select base_projects.base_project_id, base_projects.name as base_project_name, 
base_projects.url as base_project_url, count(forks.id) as num_forks from 

(select * from projects) as forks

right join

(select id as base_project_id, name, url from projects
where forked_from is null) as base_projects

on forks.forked_from = base_projects.base_project_id

group by base_projects.base_project_id

A generic calculation (code) or SQL query that generates the metric.

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.