https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/Head https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/assertion https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/provenance https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/pubinfo https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/assertion https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people http://purl.org/dc/terms/description Returns one row per person involved in the projects of a space: everybody granted a project role (principal investigator, project leader, data steward or participant, the ff:has-* role relations) in the space itself or in any space whose IRI extends it with a slash, the same sub-space convention the sibling 'all projects' views use. Each row gives the person with their name (from the pubinfo of the role nanopublications), the number of projects they are involved in, and the distinct roles they hold across those projects. Rows are ordered by the number of projects, then by name. Institutions, which the previous version of this query listed alongside the people, now have their own view. Only role nanopublications signed by a current admin, maintainer or member of a space in the subtree count, with invalidated, superseded and example nanopublications skipped; the membership lookup is a federated sub-select sharing no variables with the rest of the query, so it runs once. https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people http://www.w3.org/2000/01/rdf-schema#label Get the people per space and its sub-spaces, with project counts https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/full https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people 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 nt: <https://w3id.org/np/o/ntemplate/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix ff: <https://w3id.org/fair/ff/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?person ?person_label ?projects ?roles where { { select ?person (min(?name) as ?person_label) (count(distinct ?project) as ?projects) (group_concat(distinct ?roleLabel; separator=", ") as ?roles) where { values ?_space_multi_iri {} # One row holding every member pubkey hash of the space and its sub-spaces; a # sub-select sharing no variables with the rest, so it is evaluated once. { select (group_concat(distinct ?mpk; separator=" ") as ?memberPubkeys) where { service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { select ?mpk where { values ?_space_multi_iri {} graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?stateG . } graph ?stateG { ?ri a gen:RoleInstantiation ; npa:forSpace ?sp ; npa:forAgent ?agent ; npa:hasRoleType ?rt . filter(?rt in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole)) ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk . } filter(?sp = ?_space_multi_iri || strstarts(str(?sp), concat(str(?_space_multi_iri), "/"))) } } } } graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?npPubkey . filter not exists { ?invNp npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?npPubkey . } filter not exists { ?supNp npx:supersedes ?np . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?pi . } filter(contains(?memberPubkeys, ?npPubkey)) # People: one role-instantiation nanopub per person and project role. graph ?pi { ?np npx:hasNanopubType gen:RoleInstantiation } graph ?a { ?project ?relation ?person } filter(?relation in (ff:has-principal-investigator, ff:has-project-leader, ff:has-data-steward, ff:has-participant)) filter(?project = ?_space_multi_iri || strstarts(str(?project), concat(str(?_space_multi_iri), "/"))) optional { graph ?pi { ?person foaf:name|nt:hasLabelFromApi ?name } } bind(replace(strafter(str(?relation), "https://w3id.org/fair/ff/terms/has-"), "-", " ") as ?roleLabel) } group by ?person } } order by desc(?projects) ?person_label https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/provenance https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://purl.org/dc/terms/created 2026-09-13T05:50:30Z https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://purl.org/nanopub/x/embeds https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/get-space-people https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://purl.org/nanopub/x/supersedes https://w3id.org/np/RAWtow_SBqWNLAVApAfZ3ipoC-VTPdAAFFvt2R-vL3ASg https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew http://www.w3.org/2000/01/rdf-schema#label Get the people per space and its sub-spaces, with project counts https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8 https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/sig http://purl.org/nanopub/x/hasSignature ftRzN+JKOjetCBbmUhardQchb8m1ggemgDimjB+2fS3Y36eR5vUipoKdsRB+GC/h3pDa38SGnfGBv6RxI/xcTtynYn933PtG5sZTC5cENGl9j0lIdatXNg0W47gqHo5qCwMYMyQIPGgjny30t5pi4UDHohcS4La6V6MHxhDnnQU= https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew https://w3id.org/np/RARnrZa1x82N7NjW5G6-0MpJp_DvLro4bOCE8mzFADvew/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234