metadata: {"signature": "0x8723c8d478d499eb749f63a3c02670994a9aa2d9660ae991121c1c7c093f9b331a89fd56d7f3fbb2000c1e8260cf08b547261f93b02e878269cb8d93fc155dae1c", "application": {"round": "0xd4cc0dd193c7dc1d665ae244ce12d7fab337a008", "answers": [{"type": "email", "hidden": true, "question": "Email Address", "questionId": 0, "encryptedAnswer": {"ciphertext": "YnNXmxgiFuStVsbx0acaQqrZWajkf9iXPHqP4qqB86ymPRnVasYmHGJ9u0fC68Q1", "encryptedSymmetricKey": "a29d9b40c3cc6ab71ebb707becfef7a9cd26b329fa5abaeab51f70742b9c20c5cb1cdf8b748ef01687e46dfcbe61ec0441859ae1a2acfaf37303c47ee6858d34cc6bdedef33c99daae8c19b13fc199ff1c4844a197a75d0d0ff382e6b58824a03f173243d9aabb5806a98a5c63d4e2b8508bcd830cbba64be3dba78d02f1ab05000000000000002043531c42a8b1bff9bd4191bddbac7e614b07f5add27baafb8bef2aef4da2461c227bdc38f4baed504c054e5e5eb7c08e"}}, {"type": "short-answer", "answer": "davidgasquez", "hidden": false, "question": "Telegram Handle (you can answer N/A)", "questionId": 1}, {"type": "short-answer", "hidden": false, "question": "Link to your Public Group Chat (Discord or Telegram )", "questionId": 2}, {"type": "paragraph", "answer": "The project helps democratizing chain data. It allows people to collaborate on Web3 Open Data without having to rely on closed platforms like Dune or Flipside.", "hidden": false, "question": "How is the open-source software you're creating contributing to the evolution or enhancement of the wider Ethereum and Web3 ecosystem?", "questionId": 3}, {"type": "paragraph", "answer": "I participated on the GitCoin Citicens Round 2. Since there I've made several bugfixes and other small changes while working on the bigger picture plan.\n\nThe biggest update from prior months is that datasets are also exposed via GitHub releases (alongside being pushed to IPFS).\n", "hidden": false, "question": "If you've participated in past grant rounds, please share any new updates or milestones from the prior months (N/A if you haven\u2019t participated previously). ", "questionId": 4}, {"type": "paragraph", "answer": "Number of projects using the final structured data or contributing to the repository.", "hidden": false, "question": "How do you measure the impact of your project? Please provide examples and/or standard metrics. This might be used in future impact reports ", "questionId": 5}, {"type": "number", "answer": "1000", "hidden": false, "question": "Total Prior Funding for the project in USD", "questionId": 6}, {"type": "checkbox", "answer": ["Grants"], "hidden": false, "question": "Which of the following funding sources have you received? Check all that apply", "questionId": 7}, {"type": "number", "answer": "1", "hidden": false, "question": "Total Team Size", "questionId": 8}, {"type": "number", "answer": "6", "hidden": false, "question": "How old (in Months) is the project? (We will use twitter, domain registration, github, etc to verify)", "questionId": 9}, {"type": "address", "hidden": true, "question": "If you participated in past grant rounds using a different project payout wallet address, please share it here:", "questionId": 10}, {"type": "paragraph", "answer": "N/A", "hidden": true, "question": "Profiles or socials of other main team members publicly associated with the project (N/A for solo founders): ", "questionId": 11}, {"type": "multiple-choice", "answer": "Yes", "hidden": true, "question": "Have you read and confirmed your grant abides by the Program General Eligibility Policy? https://gitcoin.notion.site/GG19-Eligibility-50843c8b3ab44ad297731a00efa6e389?pvs=4", "questionId": 12}, {"type": "paragraph", "answer": "This project is an instance of a more generic approach to open data as a public good, Datadex.\n\nhttps://github.com/davidgasquez/datadex", "hidden": false, "question": "Anything else you'd like to share about your project, previous work, or other project affiliations? Anything you'd like to add that may help in determining project eligibility?", "questionId": 13}, {"type": "multiple-choice", "hidden": true, "question": "Would you like to opt-in to future messages from Gitcoin for updates, information, and/or interviews? ", "questionId": 14, "encryptedAnswer": {"ciphertext": "/hvA+0qXte9oWbNmEhFQi8iaw9A+MyhGPrCRjQkHoUY=", "encryptedSymmetricKey": "c83d935b8b708ac89a03b17a3372b7575389717de3da12ad05bd8c4d05a082ff2166b12e923a48ff54359edb41b64a03025c013365482e33d387cc1eca9be626efbf030a37aab398a6fceb3444bcdabc426b2b1553c33713dea76cf0a2eb5ba3c251bf652bc3dd3e863c4bcd06a812e96d36017fa09c09182a6d1f0e755f55ca0000000000000020fd0c9747228e608c31eeeec7b6be9ef3e47bb4633af2f039bf5d1d8ac37cb9e61abb8ff0d44d9c06d2f5510a5b53e992"}}, {"type": "multiple-choice", "hidden": true, "question": "Would you like to opt-in to us sharing your information with select third-parties for investment opportunities? ", "questionId": 15, "encryptedAnswer": {"ciphertext": "/SynCq4PRzJz+w/wl7YwI5nQASAUfc5pRU/D/qY+JJw=", "encryptedSymmetricKey": "74174c2556a79a8618212414d1986bf8f6cad236dab3db4e3554eb354b9d6d52582d3d5f04edbc47b1233eb055b051080a04a0fccb58bd34706ce3532f9f89e9484508afccff47493b86afbbdd3bfb66072596adaefb2e4e737928cd25652cb0736c04a760fa3b4f5b49dd664511761d7b60e05545df0c746d6753bba1f0072500000000000000202d81d3a84904979f7ba4030127c804396dc2cff4aa533baf52ad0fc87d09c7173761e070c5a329b7a98255007712cead"}}, {"type": "multiple-choice", "answer": "Europe", "hidden": false, "question": "Location/Region where the project is based.  Choose from: ", "questionId": 16}, {"type": "short-answer", "hidden": false, "question": "Gitcoin Gov Forum Handle (gov.gitcoin.co)", "questionId": 17}], "project": {"id": "424:0xDF9BF58Aa1A1B73F0e214d79C652a7dd37a6074e:130", "title": "Gitcoin Grants Data Portal", "logoImg": "bafkreic26oesr3ssvzdsm5elluyx57244r64gbkkylsdof47grbm2lbwp4", "metaPtr": {"pointer": "bafkreic2yjjpzmbj52aq3kgtw4z7g3v63k4loqn4f42sdmo6smescoe62m", "protocol": "1"}, "website": "https://github.com/davidgasquez/gitcoin-grants-data-portal", "bannerImg": "bafkreie5xoawugzwttopfrn25jxdtcyoa2o55mvkbk4ixsluvbwlqeezdq", "createdAt": 1696239037350, "userGithub": "davidgasquez", "credentials": {"github": {"type": ["VerifiableCredential"], "proof": {"jws": "eyJhbGciOiJFZERTQSIsImNyaXQiOlsiYjY0Il0sImI2NCI6ZmFsc2V9..a_qpFYyeaC_3BuDEnrbHZE9mHlOAaEsv4eVdTMOda7AeL9CeckEe39sraNUbfdo6vbJyD6gxC3nFk60nYFu-Dg", "type": "Ed25519Signature2018", "created": "2023-10-30T15:48:44.737Z", "proofPurpose": "assertionMethod", "verificationMethod": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC#z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC"}, "issuer": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC", "@context": ["https://www.w3.org/2018/credentials/v1"], "issuanceDate": "2023-10-30T15:48:44.737Z", "expirationDate": "2024-01-28T15:48:44.737Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xb9ecee9a0e273d8A1857F3B8EeA30e5dD3cb6335", "hash": "v0.0.0:7OJuleyK9ljLn31qaEoxf5TXLG1fwCor5GZWVDlIgH0=", "@context": [{"hash": "https://schema.org/Text", "provider": "https://schema.org/Text"}], "provider": "ClearTextGithubOrg#datonic#1682202"}}, "twitter": {"type": ["VerifiableCredential"], "proof": {"jws": "eyJhbGciOiJFZERTQSIsImNyaXQiOlsiYjY0Il0sImI2NCI6ZmFsc2V9..9vDqkqq4KvTUoXVsWdhlu6ErCbGAL8O0_25Cs3dQofraXski75Z2ab0ZH6xpjmWcc-VI7eTfsIixYemXEcfkBw", "type": "Ed25519Signature2018", "created": "2023-10-02T09:28:31.002Z", "proofPurpose": "assertionMethod", "verificationMethod": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC#z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC"}, "issuer": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC", "@context": ["https://www.w3.org/2018/credentials/v1"], "issuanceDate": "2023-10-02T09:28:31.002Z", "expirationDate": "2023-12-31T09:28:31.002Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xb9ecee9a0e273d8A1857F3B8EeA30e5dD3cb6335", "hash": "v0.0.0:HlYB0WejK8Jr5W/vLoUSxeVzomfZ019AjM3ZoKe65iA=", "@context": [{"hash": "https://schema.org/Text", "provider": "https://schema.org/Text"}], "provider": "ClearTextTwitter#davidgasquez"}}}, "description": "Open source, serverless, and local-first data hub for Gitcoin Grants data to improve data access and empower data scientists to conduct research and guide community driven analysis and decisions.\n\nThe Gitcoin Data Portal proof of concept repository contains code and artifacts to help process Gitcoin Grants data from the [Allo Indexer Data API](https://indexer-grants-stack.gitcoin.co/data/). It is an instance of [Datadex](https://github.com/davidgasquez/datadex) allowing you and everyone else to:\n\n- Add new data sources to the portal, collaborate on better models (ala Dune) or submit an interesting analysis.\n- All in a permissionless way. 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. Data, artifacts (like the entire DuckDB database), and models all version controlled.\n- Share and explore dashboards and report with the world!\n\n### \ud83d\udce6 Key Features\n\n- **Open**.\n  - Both code and data are fully open source.\n  - Also relies on open standards/formats (Arrow ecosystem).\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, pull requests, ... are available because all the data is transformed declaratively as code.\n- **Decentralized**.\n  - The 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](https://www.bacalhau.org/). Oh, it even works in GitHub Codespaces so you don't even need to setup anything locally!\n  - Data is stored in IPFS. You can run it locally, and it'll generate the same IPFS files if nothing has changed. The more people runst it, the more distributed the IPFS files will be!\n  - Data comes from multiple sources and can be exposed in multiple ways.\n- **Data as Code**.\n  - Every commit generates all the table files and pushes them to IPFS. This means that we can always go back in time and see the data as it was at that point in time. For every commit, we'll have the data as it was at that point in time.\n- **Modular**.\n  - Each component can be replaced, extended, or removed. Works well in many environments (your laptop, in a cluster, or from the browser), and with multiple tools (tables are files at the end of the day).\n- **Low Friction**.\n  - Data (raw and processed) is already there! No need to write your own scripts. You can always reproduce it but getting started is as easy as pasting [a SQL query in your browser](https://shell.duckdb.org/) or doing `pd.read_parquet(url)` in a Notebook.\n  - Every commit will also publish a set of Quarto Notebooks with the data. Could be used to generate reports/dahsboards, or as documentation.\n- **Modern**\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).\n\nThat's it! As an example, you can go to [the generated website with some query examples](https://bafybeieaztvldk23xghlpmzjz5ppry5jrd6bi2kag6q73huckhfrlrabby.ipfs.dweb.link/) or run the following query (rounds by most votes) in [shell.duckdb.org](https://shell.duckdb.org/).\n\n```sql\nselect\n    round_id,\n    count(id)\nfrom read_parquet('https://bafybeieaztvldk23xghlpmzjz5ppry5jrd6bi2kag6q73huckhfrlrabby.ipfs.w3s.link/round_votes.parquet')\ngroup by 1 order by 2 desc limit 10;\n```\n\n![DuckDB Example](https://user-images.githubusercontent.com/1682202/267361009-a416610e-3905-4399-adac-5d395975c2e5.png)\n", "lastUpdated": 0, "projectGithub": "datonic", "projectTwitter": "davidgasquez"}, "recipient": "0xb9ecee9a0e273d8A1857F3B8EeA30e5dD3cb6335"}}