Collectives Dashboards

Overview

The Technical Fellowship is a self-governing body of experts and developers of Polkadot and Kusama networks protocols. It operates on-chain through the Polkadot Collectives system chain and off-chain through the Polkadot Fellows repository.

Featured Dashboards on Dune

Here you will find a variety of dashboards that help visualize data from the Collectives parachain:

• Collectives: This dashboard provides an overview of the Collectives ecosystem. On this dashboard, you can see the entire landscape of activities within the Collectives network, such as the distribution of Salaries, Member Ranks, and voting activities on Referenda.

Key Tables

Data from the manta parachain is organized into several key tables:

• collectives.balances
• collectives.blocks
• collectives.calls
• collectives.events
• collectives.extrinsics
• collectives.transfers

Start building your own queries using granular data on Dune here.

Useful Queries

Some useful queries for Collectives are provided:

Title	Query	Description
Collectives Core Member Events	query_3799229	Provides details on events involving core members of Collectives.
Collective Fellowship Referenda	query_3776581	Offers comprehensive data on Collective fellowship referenda, covering vote counts (Ayes, BareAyes, Nays), current status, and type of referendum.

Getting Started with Queries

To get started with querying data from Collectives, you are welcome to use the mentioned materialized queries. You can use the following DuneSQL queries as examples:

Collectives Referenda Types

WITH types AS (
  SELECT
    block_time,
    JSON_EXTRACT_SCALAR(params, '$.proposal.lookup.hash') AS lookup,
    JSON_EXTRACT_SCALAR(params, '$.proposal_origin.fellowshipOrigins') AS fellowshipOrigins
  FROM
    collectives.extrinsics
  WHERE
    section = 'fellowshipReferenda'
    AND method = 'submit'
    AND JSON_EXTRACT_SCALAR(params, '$.proposal.lookup.hash') IS NOT NULL
)
SELECT
  JSON_EXTRACT_SCALAR(data, '$[0]') AS r_id,
  JSON_EXTRACT_SCALAR(data, '$[2].lookup.hash') AS lookup,
  COALESCE(types.fellowshipOrigins, 'Fellows') AS types
FROM
  collectives.events
LEFT JOIN types ON JSON_EXTRACT_SCALAR(data, '$[2].lookup.hash') = types.lookup
WHERE
  method = 'Submitted'
  AND JSON_EXTRACT_SCALAR(data, '$[2].lookup.hash') IS NOT NULL;

Query result:

DuneSQL Referece

For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.