airdrop

Airdrop files

Gitcoin 8

The data was indexed in Gitcoin database which is managed by an open source codebase: https://github.com/gitcoinco/web/ to include the zk list which couldn't be fetched from endpoint.

Script:

select 
    distinct admin_address
from grants_grant
union
select 
    distinct contributor_address
from 
    grants_subscription

Data was verified by Gitcoin Team.

Fix for ZkSync:

select 
    distinct contributor_address
from 
    grants_subscription
INNER JOIN grants_contribution
ON grants_contribution.subscription_id = grants_subscription.id
where checkout_type = 'eth_zksync'
and grants_subscription.created_on < '2020-12-17'