. . . . "Returns a list of all events related to the Three Point FAIRification Framework (3PFF), with IRIs output directly (not pre-rendered as HTML). Multi-value organizer/facilitator/more-info columns carry their IRIs alongside a parallel label companion column (organizer and facilitator labels resolved from the trust repository, falling back to the URI's local name). Variant of get-3pff-events-html intended for tabular views that render IRIs and labels natively (e.g. Nanodash). The final 'np' column uses '^' labels to trigger the per-row dropdown menu." . . . "Get 3PFF Events (IRIs)" . . "prefix rdfs: \nprefix np: \nprefix npa: \nprefix npx: \nprefix xsd: \nprefix dct: \nprefix prov: \nprefix foaf: \nprefix tpff: \nprefix schema: \n\nselect\n (?event as ?Event_ID) (?eventShortName as ?Event_ID_label)\n (?eventLongName as ?Event_Name)\n (?eventDate as ?Date)\n ?Organizers_multi_iri ?Organizers_label_multi\n ?Facilitators_multi_iri ?Facilitators_label_multi\n ?More_Info_multi_iri ?More_Info_label_multi\n ?np (\"^\" as ?np_label)\nwhere {\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n ?np np:hasAssertion ?assertion .\n ?np npx:introduces ?event .\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }\n }\n graph ?assertion {\n ?event a tpff:3PFF-event .\n ?event rdfs:label ?eventName .\n optional { ?event dct:date ?dateDct . }\n optional { ?event schema:startDate ?dateSchema . }\n }\n bind(coalesce(?dateDct, strBefore(str(?dateSchema), \"T\")) as ?eventDate)\n bind(replace(str(?eventName), ' ?\\\\|.*$', '') as ?eventShortName)\n bind(replace(str(?eventName), '^.*\\\\| ?(.*)$', '$1') as ?eventLongName)\n\n optional {\n select ?event\n (group_concat(str(?org); separator=\" \") as ?Organizers_multi_iri)\n (group_concat(?orgLabel; separator=\"\\n\") as ?Organizers_label_multi)\n where {\n select ?event ?org (sample(?orgName) as ?orgLabel) where {\n graph npa:graph {\n ?onp npx:introduces ?event ; np:hasAssertion ?oa ; npa:hasValidSignatureForPublicKey ?opk .\n filter not exists { ?onpx npx:invalidates ?onp ; npa:hasValidSignatureForPublicKey ?opk . }\n }\n graph ?oa {\n ?event a tpff:3PFF-event .\n ?event tpff:has-event-organizer ?org .\n }\n bind(replace(replace(str(?org), \"/$\", \"\"), \"^.*[/#]\", \"\") as ?orgLocal)\n optional {\n service {\n graph npa:graph { npa:hasCurrentTrustState ?ts . }\n graph ?ts { ?org foaf:name ?orgFoaf . }\n }\n }\n bind(coalesce(?orgFoaf, ?orgLocal) as ?orgName)\n } group by ?event ?org\n } group by ?event\n }\n\n optional {\n select ?event\n (group_concat(str(?fac); separator=\" \") as ?Facilitators_multi_iri)\n (group_concat(?facLabel; separator=\"\\n\") as ?Facilitators_label_multi)\n where {\n select ?event ?fac (sample(?facName) as ?facLabel) where {\n graph npa:graph {\n ?fnp npx:introduces ?event ; np:hasAssertion ?fa ; npa:hasValidSignatureForPublicKey ?fpk .\n filter not exists { ?fnpx npx:invalidates ?fnp ; npa:hasValidSignatureForPublicKey ?fpk . }\n }\n graph ?fa {\n ?event a tpff:3PFF-event .\n ?event tpff:has-event-facilitator ?fac .\n }\n bind(replace(replace(str(?fac), \"/$\", \"\"), \"^.*[/#]\", \"\") as ?facLocal)\n optional {\n service {\n graph npa:graph { npa:hasCurrentTrustState ?fts . }\n graph ?fts { ?fac foaf:name ?facFoaf . }\n }\n }\n bind(coalesce(?facFoaf, ?facLocal) as ?facName)\n } group by ?event ?fac\n } group by ?event\n }\n\n optional {\n select ?event\n (group_concat(str(?link); separator=\" \") as ?More_Info_multi_iri)\n (group_concat(?linkLabel; separator=\"\\n\") as ?More_Info_label_multi)\n where {\n select ?event ?link (sample(?linkLocal) as ?linkLabel) where {\n graph npa:graph {\n ?lnp npx:introduces ?event ; np:hasAssertion ?la ; npa:hasValidSignatureForPublicKey ?lpk .\n filter not exists { ?lnpx npx:invalidates ?lnp ; npa:hasValidSignatureForPublicKey ?lpk . }\n }\n graph ?la {\n ?event a tpff:3PFF-event .\n ?event rdfs:seeAlso ?link .\n }\n bind(replace(replace(str(?link), \"/$\", \"\"), \"^.*[/#]\", \"\") as ?linkLocal)\n } group by ?event ?link\n } group by ?event\n }\n}\norder by desc(?eventDate)" . . . "Tobias Kuhn" . "2026-06-30T07:42:34Z"^^ . . . . "Get 3PFF Events (IRIs)" . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "V6I2jgU74RH4eg2k5EK25gGtWr5EdNYu7PmOOZuzH97e1Q4sXjQ1fAqL7ikfziwBcgiQSDCSbYC0Iti+Oct5B7B6twBtwk8j9SXTdBg6x22JMX0fVQknPnrk/MwEp8aWPzLKHt9O6R89k7WHmvcjB21UdlCtnxblt2vIQjJ2EGI=" . . .