Prepare Airdrop Script

[closerearth]

Read from DB models and export into CSV or similar:

• User name
• Wallet
• Number of nights booked (paid)
• Number of nights booked (volunteer)
• planting actions (count)
• Metric > Sales of $TDF total
• Number of successful referrals
• Snapshot > Governance participation (voters.includes (user.wallet))

Collated with:

• Social Mentions (count) (https://docs.google.com/spreadsheets/d/1PLydHDgeKgoCYOMSiz1SG3QvXju5AwmQ6neGXMJKoeY/edit#gid=1444001582) (

Share with users the info about Airdrop:

• Social Claim Form: https://forms.gle/Q42WMdsXkCCj9nZa7

Additional Data:

• Voters: ['0xfA8b2631fb05Cf5E199a16b6C0Cbec6a1F4d824f', '0x1FaF59040e9087675A7198E3C79d34dE2f5796b1', '0xD83dbCFC60d4d4f99C343C6c089E9d5f08Fc839B', '0x5DA9b0F40BD95235324Caa275Ab910c2543Fb421', '0x445E8b91626A7A2dBa2471475DfD3B515880a91d', '0xAf160E879Abe686D9174bd769Ed129272F5c08c8', '0x3fDA433cEe41185983771BDe8bd22FaE2F090Fe5', '0xEed5B859640206b3Aa3d77eE9B882FeB6D40785B', '0x7Fa57d1147832D579431A9944550d0F9559802b4', '0xE6e3Bb4CAfcb5388bb142021a84B7528a9aAa4ee', '0x6543c99d0e073c140Fd08A741c6cfdcd1449da94', '0xFe7B610735b35CFbbcA5B1c78dcee0aB5d4C04B6', '0xF0f4610ef547E1a5201CD1526565B8a6F92Eb515', '0xA6eB16A580f865F14A2A58a30b16bA6C1ee6390f', '0xFB0c86bdf15142cEbC0Ad787D5293B40B25cb7fE', '0xEB5c8E93A7e2796d7e1a1189d1A097235b00FE77', '0xd8Fe8F3B3CeB7540494ba374D8E597Ef228cA9Fb', '0xEADAf51028A7C3d95D0CdBF4c53F47B8ED02d73b', '0x528fD0eDf2D42b4691d6F2a3a040F1610510065C', '0x661Ac71bbe43fe56935c1CA4d62e62ed380950A3', '0x75aa907006E293828567E0F931138aB4aa214D38', '0x7a85Aba48077C412079Ad9da57bA048Ad924b37f', '0x4E02E68E16278B4822DEF008bF6acef11EE2Da2F', '0xB9D53Cc752D3d1888FE8e340a65027C1a2d86f94', '0xCC9e498c9c1Fa1285ad80972520E3828f9AB1220', '0xa8Ff7cB732f4d0e57489a7b68eD0F8c93a74ea33', '0xdF1191A980b82E2eb7c8C6EAC7F1Eff201C7c445', '0xe39b7BCb5a4434A604da2ADefB724aa656FF70CC'] (https://hub.snapshot.org/graphql?query=query%20%7B%0A%20%20votes%20(%0A%20%20%20%20first%3A%201000%2C%0A%20%20%20%20skip%3A%200%2C%0A%20%20%20%20where%3A%20%7B%0A%20%20%20%20%20%20space_in%3A%20%5B%22traditionaldreamfactory.eth%22%5D%0A%20%20%20%20%7D%2C%0A%20%20%20%20orderBy%3A%20%22created%22%2C%0A%20%20%20%20orderDirection%3A%20desc%0A%20%20)%20%7B%0A%20%20%20%20voter%0A%20%20%7D%0A%7D)