Retro Funding allocations across rounds

[JSeiferth]

Objective

There is currently no consolidated source that tracks the total OP allocations received by projects across all Retro Funding rounds. Our goal is to build a comprehensive database that captures the reward history of all projects from Retro Funding Rounds 2 to 6.

---

Deliverable

A single, unified table that lists all OP allocations for projects across Retro Funding Rounds 2-6.
The desired schema for this output can be found here.

---

Scope of Work

1. Source Data:

   • All CSV files containing Retro Funding results for each round are available here.

2. Unifying Project Allocations:

   • Use the ProjectID to standardize project data.
   • Rounds 4, 5, and 6 use a consistent ProjectID format, labeled as "OPAtlas_ProjectId" in the schema.
   • Rounds 2 and 3 use outdated ProjectIDs that are incompatible with the current system and will require reconciliation.

3. Project Matching Across Rounds:

   • Identify projects that received rewards in Rounds 2 or 3 and also participated in Rounds 4, 5, or 6.
   • Matching can be done using project names; however, names may differ across rounds. Manual verification will be needed for discrepancies.
     • Example: The project Go-Ethereum may appear as "Geth" in earlier rounds and "Go-Ethereum" in later ones.
   • Use this reference sheet as a starting point, which includes preliminary matching attempts.

4. Include Organization Data:

   • If a OrgID is associated with a ProjectID, include it in the final output.
   • If no organization is linked, leave the field blank.