https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/Head https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/assertion https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/provenance https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/pubinfo https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/assertion https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats http://purl.org/dc/terms/description Returns all 3PFF events with participant counts per role (Participants, Facilitators, Trainers, etc.). https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats http://www.w3.org/2000/01/rdf-schema#label Get 3PFF event participation stats https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/full https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats https://w3id.org/kpxl/grlc/sparql prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix dct: <http://purl.org/dc/terms/> prefix tpff: <https://w3id.org/fair/3pff/> prefix schema: <http://schema.org/> select ?event ?event_label (sample(?ev_name) as ?event_name) (sample(?ev_date) as ?event_date) (sum(if(?role = tpff:participatedAsParticipantIn, 1, 0)) as ?Participants) (sum(if(?role = tpff:participatedAsFacilitatorIn, 1, 0)) as ?Facilitators) (sum(if(?role = tpff:participatedAsTrainerIn, 1, 0)) as ?Trainers) (sum(if(?role = tpff:participatedAsFacilitatorAssistantIn, 1, 0)) as ?Facilitator_Assistants) (sum(if(?role = tpff:participatedAsTrainerAssistantIn, 1, 0)) as ?Trainer_Assistants) (sum(if(?role = tpff:participatedAsImplementerIn, 1, 0)) as ?Implementers) (sum(if(?role = tpff:participatedAsImplementerAspirantIn, 1, 0)) as ?Implementer_Aspirants) where { { select distinct ?event ?role ?user where { values ?role { tpff:participatedAsParticipantIn tpff:participatedAsFacilitatorIn tpff:participatedAsTrainerIn tpff:participatedAsFacilitatorAssistantIn tpff:participatedAsTrainerAssistantIn tpff:participatedAsImplementerIn tpff:participatedAsImplementerAspirantIn } graph npa:graph { ?np npx:hasNanopubType ?role . ?np npa:hasValidSignatureForPublicKeyHash ?pk . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pk . } ?np np:hasAssertion ?a . } graph ?a { ?user ?role ?event . } } } graph npa:graph { ?enp npx:introduces ?event . ?enp npa:hasValidSignatureForPublicKeyHash ?epk . filter not exists { ?enpx npx:invalidates ?enp ; npa:hasValidSignatureForPublicKeyHash ?epk . } ?enp np:hasAssertion ?ea . } graph ?ea { ?event a tpff:3PFF-event . ?event rdfs:label ?ename . optional { ?event dct:date ?dateDct . } optional { ?event schema:startDate ?dateSchema . } } bind(replace(str(?event), "^.*/", "") as ?event_label) bind(coalesce(?dateDct, strBefore(str(?dateSchema), "T")) as ?ev_date) bind(replace(?ename, "^[^|]*\\| ?", "") as ?ev_name) } group by ?event ?event_label order by desc(sample(?ev_date)) https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/provenance https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://purl.org/dc/terms/created 2026-03-26T11:25:28Z https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://purl.org/nanopub/x/embeds https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/get-3pff-event-participation-stats https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ http://www.w3.org/2000/01/rdf-schema#label Get 3PFF event participation stats https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RA0J4vUn_dekg-U1kK3AOEt02p9mT2WO03uGxLDec1jLw https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/sig http://purl.org/nanopub/x/hasSignature Ro5l8jywWmGJJNhMtNR/YYz3FnooKvxJLm+vGkeotfq1Kg76YTOAB8wDgO/j97oQDcYRGP1wy0znhAjuLoio565w7Bz+8QXbOHwz8XXvzbu629TTX45UXwnVwb+d93ElOAw2/vJF46Fioew+fBPYIpRHVWFb4vFOpEN3qd1rIBI= https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234