Export a CSV of all verified projects that have an Arbitrum address on their Giveth profile

koday1 commented 2 weeks ago

We are going to announce an Arbitrum address bounty program soon, with 5k ARB earmarked to give out to verified projects that add an Arbitrum address to their profile between now (June 18) and when the Arbitrum QF round starts (set for July 23).

@mohammadranjbarz Assigning this to you - could you please query the database for

a CSV of all verified projects that have an Arbitrum address right now
include project name, project ID, Giveth link, and Arbitrum address

You can leave out all the projects that do not have an Arbitrum address. At the end of this bounty program, I will ask for another query with the same parameters, and compare the two to filter out the projects that already have one. Then I will send the list of projects and addresses to ThankARB, and they will send the ARB to the projects.

mohammadranjbarz commented 2 weeks ago

Sure I attached the CSV here

Query

SELECT 
    pa."createdAt" as "walletAddressAddedTime",
    pa."projectId",
    pa.address,
    'https://giveth.io/project/' || p.slug AS "givethLink"
FROM 
    project_address pa
JOIN 
    project p ON pa."projectId" = p.id
WHERE 
    pa."networkId" = 42161 AND pa."isRecipient" = true AND p.verified = true AND p."statusId" = 5
ORDER BY 
    pa."createdAt" ASC;

Response

Project-withArbitrum-addresses-june-2024.csv

@koday1 Is this CSV ok?

koday1 commented 9 hours ago

Hey @mohammadranjbarz that CSV is perfect. Thanks for getting this! I will re-create this issue a couple more times to compare the new lists to this first one. You should be able to use the same query for those.

I also added this CSV to a google sheet for easy viewing: https://docs.google.com/spreadsheets/d/1MD0lxd4iN0ZB-yoTKSFT0d_4lEqsOLqRvzkkb_BScxk/edit?usp=sharing

Closing this issue

Giveth / giveth-dapps-v2

Export a CSV of all verified projects that have an Arbitrum address on their Giveth profile #4295

Query

Response