[ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/pubinfo", "@graph": [ { "@id": "https://orcid.org/0000-0002-1267-0234", "http://xmlns.com/foaf/0.1/name": [ { "@value": "Tobias Kuhn" } ] }, { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s", "http://purl.org/dc/terms/created": [ { "@value": "2026-03-19T09:32:07Z", "@type": "http://www.w3.org/2001/XMLSchema#dateTime" } ], "http://purl.org/dc/terms/creator": [ { "@id": "https://orcid.org/0000-0002-1267-0234" } ], "http://purl.org/dc/terms/license": [ { "@id": "https://creativecommons.org/licenses/by/4.0/" } ], "http://purl.org/nanopub/x/embeds": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/get-weekly-active-user-count" } ], "https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate": [ { "@id": "http://purl.org/np/RANwQa4ICWS5SOjw7gp99nBpXBasapwtZF1fIM3H2gYTM" } ], "https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate": [ { "@id": "https://w3id.org/np/RA0J4vUn_dekg-U1kK3AOEt02p9mT2WO03uGxLDec1jLw" }, { "@id": "https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw" }, { "@id": "https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI" } ], "https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate": [ { "@id": "https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k" } ] }, { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/sig", "http://purl.org/nanopub/x/hasAlgorithm": [ { "@value": "RSA" } ], "http://purl.org/nanopub/x/hasPublicKey": [ { "@value": "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" } ], "http://purl.org/nanopub/x/hasSignature": [ { "@value": "VS6y1YRhMqEONFvVQ1OrdCLKwhXb4q9yakjlu+iaCvLSyQy0Bd+FNdiPl4pSgUosed7I47fE/wzqm3FKIVCCbb2s8awpiQ5icVnwsC5b0vX2AWr1YxGA0+TpF6mF54aa1WNhqlTQm3XKBsw4xvz/r7fm+J/h39FWVcreacCylW0=" } ], "http://purl.org/nanopub/x/hasSignatureTarget": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s" } ], "http://purl.org/nanopub/x/signedBy": [ { "@id": "https://orcid.org/0000-0002-1267-0234" } ] } ] }, { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/Head", "@graph": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s", "http://www.nanopub.org/nschema#hasAssertion": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/assertion" } ], "http://www.nanopub.org/nschema#hasProvenance": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/provenance" } ], "http://www.nanopub.org/nschema#hasPublicationInfo": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/pubinfo" } ], "@type": [ "http://www.nanopub.org/nschema#Nanopublication" ] } ] }, { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/provenance", "@graph": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/assertion", "http://www.w3.org/ns/prov#wasAttributedTo": [ { "@id": "https://orcid.org/0000-0002-1267-0234" } ] } ] }, { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/assertion", "@graph": [ { "@id": "https://w3id.org/np/RAqLNf0-hUqFK9oAURrkWtF_AU27-u4unk5LJObU-U04s/get-weekly-active-user-count", "http://purl.org/dc/terms/description": [ { "@value": "Returns the number of active users per week (Mon-Sun)." } ], "http://purl.org/dc/terms/license": [ { "@id": "http://www.apache.org/licenses/LICENSE-2.0" } ], "@type": [ "https://w3id.org/kpxl/grlc/grlc-query" ], "http://www.w3.org/2000/01/rdf-schema#label": [ { "@value": "Get weekly active user count" } ], "https://w3id.org/kpxl/grlc/endpoint": [ { "@id": "https://w3id.org/np/l/nanopub-query-1.1/repo/full" } ], "https://w3id.org/kpxl/grlc/sparql": [ { "@value": "prefix rdfs: \nprefix np: \nprefix npa: \nprefix npx: \nprefix xsd: \nprefix dct: \nprefix prov: \nprefix foaf: \n\nselect ?week (substr(str(min(?date)), 0, 11) as ?firstday) (count(distinct ?userid) as ?usercount) where {\n { graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n ?np dct:creator ?userid .\n ?np dct:created ?date .\n } }\n union\n {\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n ?np np:hasAssertion ?assertion .\n ?np np:hasProvenance ?prov .\n ?np dct:created ?date .\n ?np dct:creator ?tool .\n values ?tool { }\n }\n graph ?prov {\n ?assertion prov:wasAttributedTo ?userid .\n }\n }\n filter not exists {\n graph npa:graph { ?np npa:hasSubIri ?userid . }\n }\n bind(if(month(?date) <= 2, year(?date) - 1, year(?date)) as ?y)\n bind(if(month(?date) <= 2, month(?date) + 9, month(?date) - 3) as ?m)\n bind(365*?y + xsd:integer(?y/4) - xsd:integer(?y/100) + xsd:integer(?y/400) + xsd:integer((153*?m + 2)/5) + day(?date) as ?daynum)\n bind(?daynum + 1 - xsd:integer((?daynum + 1) / 7) * 7 as ?dow)\n bind(xsd:integer((?daynum - ?dow) / 7) as ?week)\n}\ngroup by ?week\norder by desc(?week)" } ] } ] } ]