Nouns Governance Participation

Question:

Q1. Analyze the on-chain voting for NounsDAO. Which proposals have had the most engagement, relative to the number of tokens minted?

\n Please use the core schema within the Ethereum database for this analysis.

Approach:

Vote in the governing body of the Nouns DAO,

from ethereum.core.fact_event_logs

where EVENT_NAME ilike '%VoteCast'

and ORIGIN_TO_ADDRESS='0x6f3e6272a167e8accb32072d08e0957f9c79223d'

and ORIGIN_FUNCTION_SIGNATURE in('0x56781388','0x7b3c71d3')
Voting features analysis

distinct EVENT_INPUTS:proposalId as proposal

sum(EVENT_INPUTS:votes) as token_minted,

count(distinct EVENT_INPUTS:voter) as voter

Results:

The results section of this essay contain the arrangement of proposals by token minted. Additionally, the top proposals with voter count and top voters with most token minted.

Key findings:

The proposal #82 has 98 token minted and its in the first rank of proposal. This proposal has been approved by majority vote and declare as an alternative to Proposal 81 and propose to facilitate their purchase of one for 69.420 ETH in a historic DAO to DAO on chain transaction.
The second proposal is #81 and this proposal was rejected by majority vote. Its modified to reduce token approval surface area.
Other proposals with minted NFTs displays in the first graph with minted NFTs.
The engagement of proposals by minted NFTs over time demonstrate the highest engagement on May 23.
Other method to find the engagement on proposals is based on the count of unique voters.
The count of unique voters on proposal #90 is the most heighten proposal based on count of voter.
The top voters shown in the table reveals that the top voter hold 9 minted NFTs.
The top voters based on count of unique proposals engagement shown that the most active voter has been voted on 67 various proposals.

NounDao Governance:

Nouns is a generative non-fungible token project on the Ethereum blockchain. The Nouns DAO and its holder base grow organically every day thanks to its unique daily minting process.

One noun is auctioned every 24 hours, forever. Nouns use their voting abilities (remember, 1 Noun = 1 vote) to direct the treasury. Nouns can create and vote on governance proposals, which execute transactions on the ethereum blockchain when they are approved.