nicholas 🧨
@nicholas
@kenny could we put do a @poidh to get a query that outputs all contributors to a given project on Gitcoin? There's currently no UI to learn who donated to my project, although i'm told it's on Gitcoin's roadmap https://explorer.publicgoods.network/address/0x98720dD1925d34a2453ebC1F91C9d48E7e89ec29?tab=contract
3 replies
0 recast
2 reactions
kenny 🎩
@kenny
for sure! I don't know what a good bounty amount would be but I'm down to contribute $50 in ETH towards it 🤝
1 reply
0 recast
1 reaction
kenny 🎩
@kenny
@yesyes would love your thoughts on this bounty as my data viz expert of choice
1 reply
0 recast
0 reaction
yesyes
@yesyes
Sure! i have played with gitcoin data before but it's been a while. @nicholas could you detail exactly what you are looking for? Enter a particular project's address and get a list of all the address that donated to the particular project(probably sorted by the amount donated) ?
1 reply
0 recast
0 reaction
nicholas 🧨
@nicholas
Yes! Enter project ID Get list of donors, how much they donated, and in which round. ENS labels a plus. ideally works on all chains where gitcoin accepts donations, but PGN is the priority. I’ll put in $50 too
3 replies
0 recast
0 reaction
yesyes
@yesyes
Okay so - There are currently three ways to get the PGN data - using the explorer api, using covalent and building a subgraph using goldsky. I used Covalent to get the list of all your donors plus how much they donated. Using other methods or building any further might be too complex for now because of lack of data.
2 replies
0 recast
2 reactions
yesyes
@yesyes
Covalent's increment is currently rather restrictive so i cant add the option to enter the project id or to select the donor round. There's a date aggregation filter that will allow a person to check all the donors in a particular date range but that's it. I don't believe there's any other option right now.
1 reply
0 recast
0 reaction
yesyes
@yesyes
Best that can be done is that i can provide the SQL code and you can manually enter the project id in increment.
1 reply
0 recast
0 reaction
nicholas 🧨
@nicholas
Amazing. I just saw that Meg from Gitcoin is also interested in funding this effort. Let's coordinate 🤝 https://twitter.com/MegLister/status/1730282849624813986
1 reply
0 recast
1 reaction
