Add Passport data to support analysis

[Jkd-eth]

Here is some additional data that I think could help enhance the ETL tool
Passport score

• could attach to the user table or have a separate table linked by address
• Data can be found in the Indexer or through the APIs

Passport stamp data (indexer or API)

• same as above, but pulling the full set of all credentials for a particular address
• available through the APIs

Staking data

• Current contract has all of the data on GTC staked on the passport address (stake) and staked on others (stake users)
• Being able to build a Community staking social graph would be a great output
• Total (current and historical) GTC staked on and by a passport

Historical data by address (only ceramic for now 😦 )

[ufkhan97]

Score and stamp data now completed. Moving towards live data.

Can staking data only be found in the contract rn? Is there a db in redash or anything?

[Jkd-eth]

@ufkhan97 We just moved from a sub graph to our own indexer as the data stopped being indexed on the Graph. We have an endpoint you can hit: https://api.scorer.gitcoin.co/docs#/Score%20your%20passport/registry_api_v1_get_gtc_stake
Also so the data is stored in our scorer DB if you need/want to query it directly