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.balancespeople.blockspeople.callspeople.eventspeople.extrinsicspeople.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:
sql title="Kusama People Chain - Identity History Sample" showLineNumbers
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 Reference
For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.