https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/Head https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/assertion https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/provenance https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/pubinfo https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/assertion https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions http://purl.org/dc/terms/description Returns one row per institution involved in the projects of a space: the institutions declared as lead or partner institution (ff:has-lead-institution, ff:has-partner-institution) in the space definitions of the space itself and of every space whose IRI extends it with a slash, the same sub-space convention the sibling 'all projects' views use. Each row gives the institution with its label (taken from the labels recorded in the pubinfo of the space definitions), the number of projects it is involved in, how many of those it leads and in how many it is a partner, Rows are ordered by the number of projects, then by the number led. Funders are left out, since the funding body is the same for every project of a programme. Only space definitions 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. This version drops the project-links column of the previous version. https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions http://www.w3.org/2000/01/rdf-schema#label Get the institutions per space and its sub-spaces, with project counts https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/full https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions 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/> select ?institution ?institution_label ?projects ?lead ?partner where { { select ?institution (min(?lbl) as ?institution_label) (count(distinct ?project) as ?projects) (count(distinct if(?relation = ff:has-lead-institution, ?project, ?undefined)) as ?lead) (count(distinct if(?relation = ff:has-partner-institution, ?project, ?undefined)) as ?partner) 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)) # Institutions are asserted in each project's own space definition. graph ?a { ?project a gen:Space . ?project ?relation ?institution . } filter(?relation in (ff:has-lead-institution, ff:has-partner-institution)) filter(?project = ?_space_multi_iri || strstarts(str(?project), concat(str(?_space_multi_iri), "/"))) optional { graph ?pi { ?institution rdfs:label|nt:hasLabelFromApi ?lbl } } } group by ?institution } } order by desc(?projects) desc(?lead) ?institution_label https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/provenance https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://purl.org/dc/terms/created 2026-09-13T05:18:18Z https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://purl.org/nanopub/x/embeds https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/get-space-institutions https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://purl.org/nanopub/x/supersedes https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw http://www.w3.org/2000/01/rdf-schema#label Get the institutions per space and its sub-spaces, with project counts https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8 https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/sig http://purl.org/nanopub/x/hasSignature BWPIs+GqkwcrT6W5wBn5ImGHBz82HlCkiuYUDlFZwboNODbO7YKBuMcE7s6G0tZSRj2+O4ioG2ZiqNhGKfcFjZI0VNzft1CmjtjyouWzHBNiqAtcUT0s2CaaWU+0mr0rdinpm8Qdl+NvC28Exy2B+x2yvSCxd3zVUGu5vaLor+s= https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw https://w3id.org/np/RA3WTyukTXXay4LVl1HV3EtvP1Mz2shZ-ygZ6QNlKQsRw/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234