Matches in Nanopublications for { ?s ?p ?o <https://w3id.org/np/RAY1nkPv8FgFhNOe4LhoZpTQ3dCedofD7OT1K142OH8LQ/assertion>. }
Showing items 1 to 6 of
6
with 100 items per page.
- get-3pff-event-participation-stats type grlc-query assertion.
- get-3pff-event-participation-stats label "Get 3PFF event participation stats" assertion.
- get-3pff-event-participation-stats description "Returns all 3PFF events with participant counts per role (Participants, Facilitators, Trainers, etc.)." assertion.
- get-3pff-event-participation-stats 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))" assertion.
- get-3pff-event-participation-stats endpoint full assertion.
- get-3pff-event-participation-stats license LICENSE-2.0 assertion.