{"title": "GoodDollar: Dune Spellbook models", "logoImg": "bafkreig5g33m5wliz3frmebr3w3dybbujsbguqmea2hub65vhjx6byt4w4", "website": "https://github.com/duneanalytics/spellbook", "createdAt": 1742830649946, "userGithub": "tomfutago", "credentials": {"twitter": {"type": ["VerifiableCredential"], "proof": {"type": "EthereumEip712Signature2021", "created": "2025-03-24T15:34:57.717Z", "@context": "https://w3id.org/security/suites/eip712sig-2021/v1", "proofValue": "0xa69ff4edf70226ed2dc5a4f38f5e738bceab7e50c96eae6b390d1ac9f89c07f34e9b28ecfe925ce7fa68770ceb1b350d10dbac4de1ea04d862278a227af38e761c", "eip712Domain": {"types": {"Proof": [{"name": "@context", "type": "string"}, {"name": "created", "type": "string"}, {"name": "proofPurpose", "type": "string"}, {"name": "type", "type": "string"}, {"name": "verificationMethod", "type": "string"}], "@context": [{"name": "nullifiers", "type": "NullifiersContext"}, {"name": "provider", "type": "string"}], "Document": [{"name": "@context", "type": "string[]"}, {"name": "credentialSubject", "type": "CredentialSubject"}, {"name": "expirationDate", "type": "string"}, {"name": "issuanceDate", "type": "string"}, {"name": "issuer", "type": "string"}, {"name": "proof", "type": "Proof"}, {"name": "type", "type": "string[]"}], "EIP712Domain": [{"name": "name", "type": "string"}], "CredentialSubject": [{"name": "@context", "type": "@context"}, {"name": "nullifiers", "type": "string[]"}, {"name": "id", "type": "string"}, {"name": "provider", "type": "string"}], "NullifiersContext": [{"name": "@container", "type": "string"}, {"name": "@type", "type": "string"}]}, "domain": {"name": "VerifiableCredential"}, "primaryType": "Document"}, "proofPurpose": "assertionMethod", "verificationMethod": "did:ethr:0xd6f8d6ca86aa01e551a311d670a0d1bd8577e5fb#controller"}, "issuer": "did:ethr:0xd6f8d6ca86aa01e551a311d670a0d1bd8577e5fb", "@context": ["https://www.w3.org/2018/credentials/v1", "https://w3id.org/vc/status-list/2021/v1"], "issuanceDate": "2025-03-24T15:34:57.717Z", "expirationDate": "2025-06-22T15:34:57.717Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xfDe4Bef9B6060cE3a214FbC220677a13535CEb9A", "@context": {"provider": "https://schema.org/Text", "nullifiers": {"@type": "https://schema.org/Text", "@container": "@list"}}, "provider": "ClearTextTwitter#tomfutago", "nullifiers": ["v0.0.0:hIfb7xRYFTUYuTo+awTzADi2CFnPw4V/QHZwSE4pdzc="]}}}, "description": "This project establishes comprehensive analytics infrastructure within Dune Spellbook for tracking UBI distribution through the GoodDollar protocol on the Celo blockchain. Created data models capture individual transaction details to aggregate statistics and behavioral patterns.\n\nAdded data models (\"spells\") improve onchain data transparency for GoodDollar by enhancing the accessibility, accuracy, and usability of blockchain data for developers, community members, and ecosystem participants. Researchers can analyze UBI distribution efficiency, participant engagement, and financial inclusion metrics with ease.\n\nKey capabilities include:\n- Transaction-level tracking of all UBI claims with complete financial details\n- Daily aggregation of claim metrics to identify temporal patterns\n- Individual claimer profiles with comprehensive financial summaries\n- Advanced engagement analytics through streak tracking and behavioral modeling\n\nThis infrastructure supports evidence-based decision making, provides transparency for stakeholders, and enables research capabilities on the real-world implementation of Universal Basic Income programs on blockchain networks. All models are designed with rigorous data validation to ensure reliability for critical economic analysis.", "logoImgData": {}, "projectGithub": "tomfutago", "projectTwitter": "tomfutago"}