. . . . "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." . . . "Get the institutions per space and its sub-spaces, with project counts" . . "prefix rdfs: \nprefix np: \nprefix npa: \nprefix npx: \nprefix nt: \nprefix gen: \nprefix ff: \n\nselect ?institution ?institution_label ?projects ?lead ?partner ?project_multi_iri ?project_label_multi\nwhere {\n {\n select ?institution (min(?lbl) as ?institution_label)\n (count(distinct ?project) as ?projects)\n (count(distinct if(?relation = ff:has-lead-institution, ?project, ?undefined)) as ?lead)\n (count(distinct if(?relation = ff:has-partner-institution, ?project, ?undefined)) as ?partner)\n (group_concat(distinct str(?project); separator=\"\\n\") as ?project_multi_iri)\n (group_concat(distinct ?projectLabel; separator=\"\\n\") as ?project_label_multi)\n where {\n values ?_space_multi_iri {}\n # One row holding every member pubkey hash of the space and its sub-spaces; a\n # sub-select sharing no variables with the rest, so it is evaluated once.\n {\n select (group_concat(distinct ?mpk; separator=\" \") as ?memberPubkeys) where {\n service {\n select ?mpk where {\n values ?_space_multi_iri {}\n graph npa:graph { npa:hasCurrentSpaceState ?stateG . }\n graph ?stateG {\n ?ri a gen:RoleInstantiation ; npa:forSpace ?sp ; npa:forAgent ?agent ; npa:hasRoleType ?rt .\n filter(?rt in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole))\n ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk .\n }\n filter(?sp = ?_space_multi_iri || strstarts(str(?sp), concat(str(?_space_multi_iri), \"/\")))\n }\n }\n }\n }\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKeyHash ?npPubkey .\n filter not exists { ?invNp npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?npPubkey . }\n filter not exists { ?supNp npx:supersedes ?np . }\n filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }\n ?np np:hasAssertion ?a .\n ?np np:hasPublicationInfo ?pi .\n }\n filter(contains(?memberPubkeys, ?npPubkey))\n # Institutions are asserted in each project's own space definition.\n graph ?a {\n ?project a gen:Space .\n ?project ?relation ?institution .\n }\n filter(?relation in (ff:has-lead-institution, ff:has-partner-institution))\n filter(?project = ?_space_multi_iri || strstarts(str(?project), concat(str(?_space_multi_iri), \"/\")))\n optional { graph ?pi { ?institution rdfs:label|nt:hasLabelFromApi ?lbl } }\n bind(replace(str(?project), \"^.*/\", \"\") as ?projectLabel)\n }\n group by ?institution\n }\n}\norder by desc(?projects) desc(?lead) ?institution_label" . . "Tobias Kuhn" . "2026-09-13T05:10:05Z"^^ . . . . "Get the institutions per space and its sub-spaces, with project counts" . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "PwOwSlSCg3gtooyaAZnnSRnN77mpZRuH0j6qq+4tdcPLw04ioDVdAcmhDE/xtvx+8Mc7vZGb1kIuE5snluKFICVLYxC8221jeoQG5C0tOUamGx7tJj1hYFkV//SuanZ7QkJuHc6wwkhygUwiDGw5Cq7Y/DxBg4NB9mUHE6jdLLc=" . . .