https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/Head https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/assertion https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/provenance https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/pubinfo https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/assertion https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/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, and the projects themselves as links labelled with the last segment of their IRI, which for the ZonMw programme spaces is the grant number. 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. https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/get-space-institutions http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/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/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/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/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/get-space-institutions https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/full https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/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 ?project_multi_iri ?project_label_multi 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) (group_concat(distinct str(?project); separator="\n") as ?project_multi_iri) (group_concat(distinct ?projectLabel; separator="\n") as ?project_label_multi) 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 } } bind(replace(str(?project), "^.*/", "") as ?projectLabel) } group by ?institution } } order by desc(?projects) desc(?lead) ?institution_label https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/provenance https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://purl.org/dc/terms/created 2026-09-13T05:10:05Z https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM http://purl.org/nanopub/x/embeds https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/get-space-institutions https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM 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/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8 https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/sig http://purl.org/nanopub/x/hasSignature PwOwSlSCg3gtooyaAZnnSRnN77mpZRuH0j6qq+4tdcPLw04ioDVdAcmhDE/xtvx+8Mc7vZGb1kIuE5snluKFICVLYxC8221jeoQG5C0tOUamGx7tJj1hYFkV//SuanZ7QkJuHc6wwkhygUwiDGw5Cq7Y/DxBg4NB9mUHE6jdLLc= https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM https://w3id.org/np/RArAiBwj9YzUHPF8u9SwleS-ielHNiprbgBidTYG1bxRM/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234