Egregoros

select distinct data->>'actor' as actor_id, data->>'name' as vote from objects where data->>'inReplyTo' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93' and data->>'type' = 'Answer' order by vote asc;
             actor_id              | vote 
-----------------------------------+------
 https ://fluffytail.org/users/phnt | no.
(1 row)

select data from objects where data->>'id' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93';

 {"cc": ["..."], "id": "https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93", "to": ["..."], "bcc": [], "bto": [], "tag": [], "type": "Question", "actor": "https://netzsphaere.xyz/users/georgia", "anyOf": [], "emoji": {}, "likes": [], "oneOf": [{"name": "yes!", "type": "Note", "replies": {"type": "Collection", "totalItems": 15}}, {"name": "no.", "type": "Note", "replies": {"type": "Collection", "totalItems": 7}}], "closed": "2026-05-01T13:11:42.972718Z", "voters": ["https://fluffytail.org/users/phnt"], "content": "test poll", "context": "https://netzsphaere.xyz/contexts/4f83c49a-4104-478e-a45b-38116e48a00f", "published": "2026-04-11T13:11:42.981613Z", "sensitive": false, "attachment": [], "contentMap": {"en": "test poll"}, "like_count": 0, "quotesCount": 2, "attributedTo": "https://netzsphaere.xyz/users/georgia", "quotes_count": 0, "repliesCount": 5, "announcements": ["https://poa.st/users/graf"], "replies_count": 0, "announcement_count": 1}
(1 row)