People Dashboards

Overview

People's Chain focuses on decentralized identity and social interactions, enabling users to manage their digital identity and engage in community governance.

Featured Dashboards on Dune

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

• People Dashboard: A comprehensive view of identity management and social interaction activities within the People ecosystem.

Please also visit our dashboards for People on Dune Analytics.

Key Tables

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

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

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

Useful Queries

Some useful queries for People are provided:

Title	Query	Description
Kusama People Chain - Identity History	query_3836167	Find all identity history records on the Kusama People Chain

Getting Started with Queries

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

Kusama People Chain - Identity History Sample

SELECT
  block_time,
  extrinsic_id,
  signer_ss58,
  signer_pub_key,
  CAST(
    from_utf8(
      from_hex(JSON_EXTRACT_SCALAR(call_args, '$.info.display.raw'))
    ) AS VARCHAR
  ) AS name,
  CAST(
    from_utf8(
      from_hex(JSON_EXTRACT_SCALAR(call_args, '$.info.email.raw'))
    ) AS VARCHAR
  ) AS email
FROM
  people_kusama.calls
WHERE
  call_section = 'identity'
  AND call_method = 'setIdentity';

Query result:

DuneSQL Referece

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