{"signature": "0x630e0f3bccf679568786b95b4bd0afa62aa43e934610a56f28f3468aa06918cc5f663a21a907be54ae7bbceb4bd3a5b77b9eb5c64401b1dda27f9c291a110e021c", "application": {"round": "0xfdff6316597d6eed115b767a88ec35eff8852275", "answers": [{"type": "email", "hidden": true, "question": "Email Address", "questionId": 0, "encryptedAnswer": {"ciphertext": "51UAKAe/CYArawUzm38ScTRtLE9sPflCCSlTQ6CvkUb/R/V1vDVNVXj/YShdcXjD", "encryptedSymmetricKey": "440c02c7eeb406722899e6f8c7926cdfd79d237e64f5905b5d1e744557803e8bdd5f3d744f23f66c4b9ca36c77c74e10437fe0764a4af8f18c6c4e1b11eff3501c9495714002d79f4ec21a97d60bc2fa2ac9461966cc7f48dfa135f835a3b399792bb2b02f9f34bd4fed14dfff411540d2a70e3a9a632e191a0349611007ecbf00000000000000203c2e3f887c6fc273497def284500b6935426e2eec4eed470ef8a59d7c81b8d82787c021ec6672c7501bd98fb4281cea3"}}, {"type": "paragraph", "answer": "Gitcoin Data can be time consuming to fetch and clean! \n\nGitcoin Data Portal removes those obstacles by providing a central hub where community curated Gitcoin Grants datasets are accessible to everybody. \n\nAnalysts working on Gitcoin Data can now visit the vebsite, pick `.parquet` file they are interested in and download the data they need! This is faster and simpler than using Grants Stack indexer.\n\nhttps://davidgasquez.github.io/gitcoin-grants-data-portal/\n\nBy lowering the barrier of entry and having more people look into the data, we expect to see more people re-using the curated datasets to make better decisions and produce interesting reports and tools!\n\nBy collecting interesting datasets (e.g. snapshot votes for non-Gitcoin communities) we can also produce analysis helping to uncover patterns or market trends.\n\nThis proposal asks for $20k for further development of the portal by team of 2 developers over span of 4 months.\n\nFor technical discussion, and essential intents see full proposal on forums: https://gov.gitcoin.co/t/citizens-innovate-gcp-gitcoin-grants-data-portal/18098", "hidden": false, "question": "Motivation - Describe the motivation behind the proposal and the problem(s) it solves.", "questionId": 1}, {"type": "number", "answer": "20000", "hidden": true, "question": "Amount requested", "questionId": 2}, {"type": "dropdown", "answer": "DAI", "hidden": true, "question": "Payout token", "questionId": 3}, {"type": "paragraph", "answer": "Development can start in **March**, first payout at end of month once grant council/manager approves of results of work. We will share monthly updates with development progress and share those on X as we did before. \n\nAt end of april we can look at stats and work done on the portal to see if it is worth it to proceed to stage 2 of the proposal which aims to not only **improve** the portal for Gitcoin but also **expand** it to datasets coming from other communities. Collecting Web3-wide-data in a single place under common schema can be very valuable undertaking as it allows to easily compare platforms/grantees across various metrics in novel ways. \n\nRoadmap by [month number, amount + main goal]:\n\n\n1 March\t$4000\tBetter pipeline\n2 April\t$4000\tBetter UX\n\u2013\t\u2013\tREVIEW\n3 May\t$6000\tMore data\n4 June\t$6000\tGrants Data Portal\n\n**Milestones.** \n\nMonths 1-2 \n\n- add Gitcoin datasets portal, \n- improve contributor documentation\n- publish interesting analyses on portal \n- improve CI pipelines and portal infrastructure\n\n Months 3-4:\n\n- add new platforms to portal (e.g. Giveth, Octant, Drips, Optimism)\n- portal supports not only Gitcoin data analysts but is also go-to place for other communities\n- try out new forms of serving data (spreadsheets, s3 bucket export)\n- produce shared schema joining projects from multiple ecosystems (e.g. `all_grantees` from Gitcoin+Giveth+Octant)", "hidden": false, "question": "Roadmap and milestones", "questionId": 4}, {"type": "short-answer", "answer": "Gitcoin Citizens#2 funds, already spent", "hidden": false, "question": "Declare existing funding sources, if any", "questionId": 5}, {"type": "number", "answer": "2", "hidden": false, "question": "Team Size", "questionId": 6}, {"type": "paragraph", "answer": "- Gitcoin data becomes easier to use\n- Gitcoin has easy access to new datasets (e.g. snapshots)\n- More analysts are interested to work on Gitcoin data \n- Gitcoin can make better decisions\n- Gitcoin can identify high-potential grantees/communities/partners\n- Gitcoin can stay on top of market trends\n- Each hour of work saved by internal/community analyst is like ~$50 gain for Gitcoin. Break even for proposal is about 100 uses (assuming each use saves ~4 hours of data prep/cleaning)\n\nBy providing easy and fast access to data, we are in great position to support other Gitcoin initiatives like say LLM stream or OS-Observer impact-tracking or RegenData.xyz Bootcamp", "hidden": true, "question": "Benefits - Point out core benefits of the proposal implementation ", "questionId": 7}, {"type": "paragraph", "answer": "- Portal may publish incorrect data\n- Portal may become more costly to run due to changes\n- Portal may be hard to use\n\nTo mitigate, check data against official sources (e.g RegenData.xyz) add tests, keep pipeline lean and talk to people + improve contributor documentation. \n", "hidden": true, "question": "Drawbacks - Highlight any drawbacks from implementing the proposal ", "questionId": 8}, {"type": "dropdown", "answer": "Network Effects", "hidden": true, "question": "Select requested grant category based on alignment to Essential Intent", "questionId": 9}, {"type": "paragraph", "answer": "$20k over span of 4 months to cover work of 2 developers. \n\n$1k would be set aside for infrastructure (current spend $20/month) rest will paid as salaries.", "hidden": true, "question": "Budget Overview - How the funding amount was determined and how it will be allocated.", "questionId": 10}, {"type": "paragraph", "answer": "Quantity:\n\n- repository metrics (new PRs, stars, forks)\n- number of initiatives supported (with data)\n- number of datasets added / analyses published\n- (estimated) number of users \n\nQuality:\n\nWill share monthly updates `changelog` with Gitcoin and community on X to promote the project and report progress, in manner similar to previous posts:\n\nhttps://twitter.com/davidgasquez/status/1760401127609192899\n\nWe will collaborate with OS-Observer (Carl) Impact-tracking Initative to use our data for further public impact analysis.\n\nSo far, 30% projects tracked by OS-Observer were imported from the portal, and we supported creation of 1 impact analysis blog post.", "hidden": true, "question": " Measures of success and KPIs - Attributes to help grants council measure progress and impact", "questionId": 11}, {"type": "paragraph", "answer": "1. Grants Stack Indexer V2 API to remain stable (we can manage without, but advance warning would be nice if breaking changes are due to happen)\n2. Gitcoin *Citizens* X can help amplify our tweets (monthly updates)\n3. We may want to push some datasets to Dune - this would work nice if we could borrow some \"upload limit\" from someone at Gitcoin with paid team Dune account. ", "hidden": true, "question": "Non-Financial Requirements - List any other resources or support needed from Gitcoin to accomplish the objectives", "questionId": 12}], "project": {"id": "0xd11d6c0cc67818dba167e23c0a2f5f55085f1b333db3edbb631fd0fa52992e63", "title": "Gitcoin Grants Data Portal", "logoImg": "bafkreifauq3d25y3rhyataxlt63hm25adll257o34xbj5exwhvy7474jqy", "metaPtr": {"pointer": "bafkreibrmefxy7hjgsqoj5273tqz76fqhglklzyqgjw24bnpvof2s3eo3q", "protocol": "undefined"}, "website": "https://davidgasquez.github.io/gitcoin-grants-data-portal/", "bannerImg": "bafkreianaqqd2nafvggkouzsmbj4zcihaexma7gexdgswm6udpc53bs2tm", "createdAt": 1709238839292, "userGithub": "davidgasquez/gitcoin-grants-data-portal", "credentials": {}, "description": "# Gitcoin Grants Data Portal\nOpen source, serverless, and local-first data hub for Gitcoin Grants data to improve data access and empower data scientists to conduct research!\n\nVisit the portal [website](https://davidgasquez.github.io/gitcoin-grants-data-portal/) to download weekly updates of Gitcoin data packaged as analysis-ready `.parquet` files!\n\nInstead of fetching data such as donations, projects, rounds or passport scores from multiple APIs you can now get it all from one place, packaged and cleaned!\n\nThe Gitcoin Data Portal [repository](https://github.com/davidgasquez/gitcoin-grants-data-portal) contains code and artifacts to help process Gitcoin Grants data from the Grants Stack Indexer API. \n\n\ud83d\udce6 Data portal Pipeline is an instance of [datadex](https://github.com/datonic/datadex) allowing you to:\n\n- Add new data sources to the portal, collaborate on better models (ala Dune) or submit an interesting analysis\n- Don't ask, fork it and improve the models, add a new source or update any script\n- Declarative stateless transformations tracked in git, executed in GitHub Actions and published to IPFS \n- Data, artifacts (like the entire DuckDB database), and models all version controlled.\n- Share and explore dashboards and reports with the world!\n\n\ud83d\udce6 Key Features\n\n- Code, data and infrastructure are fully open source.\n- Uses open standards/formats and modular components (Parquet, IPFS, dbt, Dagster).\n- Permissionless!\n- Clone and edit things away! You're not blocked by any API rate limits, or closed data like in Dune.\n- All other git features like branching, merging are available because all the data is transformed declaratively as code.\n- Decentralized!\n\nThe project runs on a laptop, a server, a CI runner (that's the way is working right now) or a even decentralized compute network like Bacalhau. Oh, it even works in GitHub Codespaces so you don't even need to setup anything locally!\n\nData is stored in IPFS. You can run it locally, and it'll generate the same IPFS files if nothing has changed. The more people run it, the more distributed the IPFS files will be!\n\n\ud83d\udce6 Extra\n\n- It supports all the cool things data engineers want; typing, tests, materialized views, dev branches\n- Uses best practices (declarative transformations) and state of the art tooling (DuckDB + Dagster + DBT + Quatro).\n- It has integrated publishing platform to surface Jupyter notebooks with useful analyses.\n\n\nMade by [DavidGasquez](https://twitter.com/davidgasquez), [DistributedDoge](https://twitter.com/DistributedDoge) and always open to new [contributors](https://github.com/davidgasquez/gitcoin-grants-data-portal)!\n", "lastUpdated": 0, "projectTwitter": "davidgasquez"}, "recipient": "0xb9ecee9a0e273d8A1857F3B8EeA30e5dD3cb6335"}}