Skip to main content

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.

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:

TitleQueryDescription
Kusama People Chain - Identity Historyquery_3836167Find 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.