Pre-computation in progress... First run takes several hours. Check container logs.
Gender Homophily in Research Teams
When the last author (typically the team leader) is female, team composition approaches gender parity (~47% female). When male, women comprise only ~34% of the team.
Gender composition by last author gender
Methodology & formula
What it shows: gender composition of research teams (2015-2024) grouped by last author gender and team size.
The last author is typically the PI/professor. For each article with ≥2 authors, M and F team members are counted.
Buckets: 2-5 authors, 6-10, 11+.
Formula:
Buckets: 2-5 authors, 6-10, 11+.
Formula:
% F members = female_members / (female_members + male_members) × 100
SELECT aa.pmid, aa.author_order, aa."gender"
FROM article_authors aa
JOIN pmid_year py ON aa.pmid = py.pmid
WHERE py.year BETWEEN 2015 AND 2024
AND aa."gender" IN ('m','f')
ORDER BY aa.pmid, aa.author_order
-- Python: group by pmid, last author = max(order)
-- Bucket by team size, aggregate M/F counts
Gender Homophily in Research Teams — Data
| Last author | Team Size | Female members | Male members | % Female |
|---|