. . . . "Returns the number of human users who published their first introduction nanopub per week (Mon-Sun)." . . . "Get weekly new user count" . . "prefix np: \nprefix npa: \nprefix npx: \nprefix xsd: \nprefix dct: \n\nselect ?week (substr(str(min(?firstdate)), 0, 11) as ?firstday) (count(distinct ?userid) as ?newusercount) where {\n {\n select ?userid (min(?date) as ?firstdate) where {\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n ?np npx:signedBy ?userid .\n ?np npx:hasNanopubType npx:declaredBy .\n ?np dct:created ?date .\n }\n filter(strstarts(str(?userid), \"https://orcid.org/\"))\n filter(?userid != )\n filter(?userid != )\n }\n group by ?userid\n }\n\n bind(if(month(?firstdate) <= 2, year(?firstdate) - 1, year(?firstdate)) as ?y)\n bind(if(month(?firstdate) <= 2, month(?firstdate) + 9, month(?firstdate) - 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(?firstdate) 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)" . . "Tobias Kuhn" . "2026-03-19T09:44:12Z"^^ . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "M/p9gTpcndCgQRYX16rkEN7qtwqqYl/qzAhC9zkQFagXlihEfSiJH+9BO6Y/BsFPW8iOK767ldSa72fuY7IWxPqEGjhvSpEcTSF+RzmMr9n6Dqsf7orwdFetxazNurgZ13pE5DO6GYDIWrBwZpdFVVcL5pxUwRS1u0AMzUVmzpQ=" . . .