https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/Head https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/assertion https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/provenance https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/pubinfo https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/assertion https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts http://purl.org/dc/terms/description Returns one row per direct sub-space (project) of the given space, with the number of knowledge products the project has delivered per category (articles, datasets, software, presentations, blog posts, media coverage, social posts, podcasts and discussions - formal FAIR outputs as well as informal / public-engagement outputs) and a total count. Sub-spaces without any products are included with zero counts; products of deeper nested sub-spaces are rolled up to the direct sub-space. Restricted to links authored by a member, maintainer, or admin of some space in the subtree. This version drops the Methods, DMPs and Preregistrations columns of the previous version, and leaves those output relations out of the total as well. https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts http://www.w3.org/2000/01/rdf-schema#label Get knowledge product counts per project for a space https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/full https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts 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 gen: <https://w3id.org/kpxl/gen/terms/> prefix ff: <https://w3id.org/fair/ff/terms/> select ?Project (coalesce(min(?plabel), replace(str(?project), "^.*/", "")) as ?Project_label) (count(distinct if(?outputProp = ff:has-article, ?output, ?undefined)) as ?Articles) (count(distinct if(?outputProp = ff:has-dataset, ?output, ?undefined)) as ?Datasets) (count(distinct if(?outputProp = ff:has-software, ?output, ?undefined)) as ?Software) (count(distinct if(?outputProp = ff:has-presentation, ?output, ?undefined)) as ?Presentations) (count(distinct if(?outputProp = ff:has-blog-post, ?output, ?undefined)) as ?Blogs) (count(distinct if(?outputProp = ff:has-media-coverage, ?output, ?undefined)) as ?Media) (count(distinct if(?outputProp = ff:has-social-post, ?output, ?undefined)) as ?Social) (count(distinct if(?outputProp = ff:has-podcast, ?output, ?undefined)) as ?Podcasts) (count(distinct if(?outputProp = ff:has-discussion, ?output, ?undefined)) as ?Discussions) (count(distinct concat(str(?outputProp), "|", str(?output))) as ?Total) where { service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { select ?project ?memberPubkeys where { { select (group_concat(distinct ?mpk; separator=" ") as ?memberPubkeys) where { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?stateG . } values ?_space_multi_iri {} graph ?stateG { ?ri a gen:RoleInstantiation ; npa:forSpace ?proj ; npa:forAgent ?agent ; npa:hasRoleType ?rt . filter(?rt in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole)) filter(?proj = ?_space_multi_iri || strstarts(str(?proj), concat(str(?_space_multi_iri), "/"))) ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk . } } } graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?stateG2 . } values ?_space_multi_iri {} graph ?stateG2 { ?_space_multi_iri npa:hasSubSpace ?project . } } } optional { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?npPubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?npPubkey . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np np:hasAssertion ?a . } filter(contains(?memberPubkeys, ?npPubkey)) graph ?a { ?p ?outputProp ?output . } values ?outputProp { ff:has-article ff:has-dataset ff:has-software ff:has-presentation ff:has-blog-post ff:has-media-coverage ff:has-social-post ff:has-podcast ff:has-discussion } filter(?p = ?project || strstarts(str(?p), concat(str(?project), "/"))) } optional { graph npa:graph { ?lnp npa:hasValidSignatureForPublicKeyHash ?lpk . filter not exists { ?lnpx npx:invalidates ?lnp ; npa:hasValidSignatureForPublicKeyHash ?lpk . } ?lnp np:hasAssertion ?la . } filter(contains(?memberPubkeys, ?lpk)) graph ?la { ?project rdfs:label ?plabel . } } bind(?project as ?Project) } group by ?project ?Project order by ?project https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/provenance https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://purl.org/dc/terms/created 2026-09-13T05:02:11Z https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://purl.org/nanopub/x/embeds https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/get-space-knowledge-product-counts https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://purl.org/nanopub/x/supersedes https://w3id.org/np/RAr8XlsXJ4f_h_9mtf2yBHtIR2CdM5oLHvsA19o5U1NRU https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI http://www.w3.org/2000/01/rdf-schema#label Get knowledge product counts per project for a space https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8 https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/sig http://purl.org/nanopub/x/hasSignature X26Wih0GWUW7lTel9UB7KMGMkdIPWl7noCUtnm4TQNka3YYUI52UsglFVjbSVNERZKnMogfZBdw4EqDqwx0zLJZhTnRTyesTjk5HdytkQVNHccYDK5/f4tgeltxpMOeuA3CNvbXlctVYFdEAHMGm5ASXELS6l2Okr+cc2B89NeA= https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI https://w3id.org/np/RA7JRzfji5R4o6b0rrd3Tp2MzeHb1RMY3R1GcnE1NBpBI/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234