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