SocioCryptoper years
Updated 2023-01-25
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date_trunc('year',closedat) as year,
count(DISTINCT author) as n_authors,
count(DISTINCT id) as n_pull_requests,
count(DISTINCT repo) as n_repos,
COUNT(DISTINCT org) as n_org
FROM near.beta.github_activity
WHERE date_trunc('day',closedat) <= '2022-12-31'
GROUP by year
Run a query to Download Data