8,093 agents across 7,962 distinct wallets registered the same document.

The state column is a view (fovea.record_state) so one definition serves the page, the feed and the API. A probe records what happened; the view decides what that means and the view is allowed to improve without re-fetching anyone's server.

WITH live AS (
  SELECT "uriHash" AS h, count(*) AS n FROM "Agent" WHERE "chainId" = $1 AND "uriHash" IS NOT NULL GROUP BY 1
)
SELECT coalesce(p.state, 'not probed') AS state,
       count(*)                        AS records,
       sum(l.n)                        AS agents,
       max(p.checked_at)               AS probed_at
FROM "AgentRecord" r
JOIN live l ON l.h = r.id
LEFT JOIN fovea.record_state p ON p.uri_hash = r.id
WHERE r."chainId" = $1
GROUP BY 1
ORDER BY agents DESC

Nansen profiler/address/related-wallets (1 credit a wallet), relation First Funder. The sample is ordered by md5(address), so rerunning asks the same wallets. Each funding tx can be opened on the explorer: from is the funder, to is the wallet. Labels (100 credits a wallet) were not affordable at this scale; first funders answer the question that mattered here.

WITH s AS (
  SELECT f.*, r.uri, r."distinctOwners" AS owners FROM fovea.wallet_funder_latest f
  JOIN "AgentRecord" r ON 'cluster:' || r.id = f.sample AND r."chainId" = 143
), top AS (
  SELECT DISTINCT ON (sample) sample, funder, funder_label, count(*) AS n, min(tx) AS tx
  FROM s WHERE status = 'found' GROUP BY sample, funder, funder_label ORDER BY sample, count(*) DESC
)
SELECT s.uri, s.owners, count(*) AS sampled, count(*) FILTER (WHERE s.status = 'found') AS found,
       count(DISTINCT s.funder) AS funders, t.funder AS top_funder, t.funder_label AS top_label, t.n AS top_n,
       t.tx AS example_tx, max(s.checked_at) AS asked_at
FROM s LEFT JOIN top t USING (sample)
GROUP BY s.uri, s.owners, t.funder, t.funder_label, t.n, t.tx
ORDER BY s.owners DESC, s.uri

SELECT split_part(split_part(r.uri, '://', 2), '/', 1)        AS host,
       count(*)                                                AS records,
       sum(r."memberCount")                                    AS agents,
       count(*) FILTER (WHERE p.state = 'answered')            AS answered,
       count(*) FILTER (WHERE p.state = 'gone')                AS gone,
       count(*) FILTER (WHERE p.state = 'paywalled')           AS paywalled,
       count(*) FILTER (WHERE p.state IN ('refused','nohost','malformed','unknown')) AS other,
       count(*) FILTER (WHERE p.state IS NULL)                 AS not_probed
FROM "AgentRecord" r
LEFT JOIN fovea.record_state p ON p.uri_hash = r.id
WHERE r."chainId" = $1 AND r.uri LIKE 'http%'
GROUP BY 1
ORDER BY agents DESC
LIMIT $2

SELECT r.id AS uri_hash, r.uri, r."memberCount", r."distinctOwners", r.kind, r."firstSeenBlock",
       p.scheme, p.reachable, p.http_status, p.byte_length, p.media_type,
       p.parsed_name, p.reason, p.checked_at, p.state,
       COALESCE(c."chainCount", 1) AS chain_count,
       COALESCE(c."chainIds", ARRAY[$1]::integer[]) AS chain_ids
FROM "AgentRecord" r
LEFT JOIN fovea.record_state p ON p.uri_hash = r.id
LEFT JOIN "ChiasmRecord" c ON c.id = r.id
WHERE r."chainId" = $1
ORDER BY r."memberCount" DESC, r."firstSeenBlock" ASC
LIMIT $2 OFFSET $3