Carl Cervone

Current repo checks: ``` repo_snapshot.commit_count >= 10 and repo_snapshot.days_with_commits_count >= 3 and repo_snapshot.first_commit_time < '2024-05-01' and repo_snapshot.star_count >= 10 and repo_snapshot.language in ('Solidity', 'JavaScript', 'TypeScript') and repo_snapshot.license_type != 'Unspecified' ```

This will be informed by #1467

Create standalone metric for WebOfTrust: ``` web_of_trust as ( {# draft model for testing #} select 1 as vitalik_verification, CAST(fof_id as string) as farcaster_id from ( select l2.peer_farcaster_id as fof_id,...

Update descriptions and close out this issue: https://www.notion.so/Update-Trusted-User-descriptions-to-be-more-detailed-d3134fa71dc54fd2a780e94105d85c16?pvs=4

@ryscheng per our discussion today, will remove pages like [this one](https://docs.opensource.observer/docs/how-oso-works/impact-metrics/code) and instead add links to dbt-generated docs on models.opensource.observer. See also #959

@ravenac95 FYI, Agora are suggesting they create a read replica DB (they are on AWS). WDYT?

For now, we will just get a CSV export that we can transform however we like. Most important thing is to have a staging model that extracts the data we...

From Telegram chat: - could be a 2 week window, ie, June 10-24. - we review submissions June 24-27, announce winner(s) June 28 - implement for Emily (on the repos...

FYI, from Emily just now: https://www.notion.so/Round-5-Guest-Voter-Selection-OSO-Karma3-45d4e95f5f7346138c3c805d27c69648

https://app.hex.tech/00bffd76-9d33-4243-8e7e-9add359f25c7/app/1488806c-cc70-4245-b8f6-78ace4a5a0e7/latest