Kind participant

This page calls Snapshot.entitiesOfKind(participant), which builds:

WITH kinds AS (
  SELECT entity, MIN(asserted_at) AS created_at, ... AS created_by
  FROM facts
  WHERE attribute = 'kind' AND value = 'participant'
  GROUP BY entity
)
SELECT k.entity, k.created_at, k.created_by,
       MAX(CASE WHEN cf.attribute='<attr>' THEN cf.value END) AS "<attr>",
       ...
FROM kinds k
LEFT JOIN current_facts cf ON cf.entity = k.entity
GROUP BY k.entity
HAVING "tombstoned" IS NULL
ORDER BY k.entity DESC