https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/Head https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/assertion https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/provenance https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/pubinfo https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/assertion https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type http://purl.org/dc/terms/description Returns the latest 100 users who have introduced themselves, newest first, with their display name, a type column (software agent if declared npx:SoftwareAgent, human if an ORCID, unknown otherwise), a joined column (creation time of their earliest introduction) and a status column marking users not yet approved in the trust state; for those, approve_target holds their current (latest non-invalidated) introduction nanopub. https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type http://www.w3.org/2000/01/rdf-schema#label Get latest users with name and type https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/type/77757cabf6184c51c20b8b0fe5dc5e1365b7f628448335184ad54319a0affdfc https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type https://w3id.org/kpxl/grlc/sparql prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?user_iri (sample(?name) as ?user_iri_label) (if(?isBot, "🤖 software agent", if(strstarts(str(?user_iri), "https://orcid.org/") || strstarts(str(?user_iri), "http://orcid.org/"), "👤 human", "❔ unknown")) as ?type) (str(?mindate) as ?joined) (if(?isApproved, "", "⏳ not yet approved") as ?status) (if(?isApproved, "", strafter(max(concat(str(?introDate), " ", str(?currentIntro))), " ")) as ?approve_target) where { { select ?user_iri (min(?date) as ?mindate) where { graph npa:graph { ?intronp npa:hasValidSignatureForPublicKey ?introPubkey . filter not exists { ?intronpx npx:retracts ?intronp ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?intronp npx:supersedes ?intronpx . } ?intronp dct:created ?date . ?intronp np:hasAssertion ?a . } graph ?a { ?keydeclaration npx:declaredBy ?user_iri . ?keydeclaration npx:hasPublicKey ?pubkey . } } group by ?user_iri order by desc(?mindate) limit 100 } { select (concat(" ", group_concat(distinct str(?approvedAgent); separator=" "), " ") as ?approvedAgents) where { service <https://w3id.org/np/l/nanopub-query-1.1/repo/trust> { graph npa:graph { npa:thisRepo npa:hasCurrentTrustState ?tg . } graph ?tg { ?acct npa:agent ?approvedAgent ; npa:trustStatus ?trustStatus . } values ?trustStatus { npa:loaded npa:toLoad } } } } bind(contains(?approvedAgents, concat(" ", str(?user_iri), " ")) as ?isApproved) bind(exists { graph ?a2 { ?user_iri a npx:SoftwareAgent } } as ?isBot) optional { graph ?a3 { ?kd3 npx:declaredBy ?user_iri . ?user_iri foaf:name ?name } } optional { graph npa:graph { ?currentIntro npa:hasValidSignatureForPublicKey ?currentPubkey ; np:hasAssertion ?a4 ; dct:created ?introDate . filter not exists { ?invalidating npx:invalidates ?currentIntro ; npa:hasValidSignatureForPublicKey ?currentPubkey . } } graph ?a4 { ?kd4 npx:declaredBy ?user_iri . } } } group by ?user_iri ?mindate ?isBot ?isApproved order by desc(?mindate) https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/provenance https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://purl.org/dc/terms/created 2026-09-25T08:36:50Z https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://purl.org/nanopub/x/embeds https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/get-latest-users-with-type https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://purl.org/nanopub/x/supersedes https://w3id.org/np/RAvlxWqDNtsqXPDqPmXG0-IOysqKAvUVpftJbQ7hoJcWg https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ http://www.w3.org/2000/01/rdf-schema#label Get latest users with name and type https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RA-N4_kFxcruvBTlo1yJv29E4SLOXsx5KO_th69PprMrA https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8 https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RARJj78P72NR5edKOnu_f4ePE9NYYuW2m2pM-fEoobMBk https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/sig http://purl.org/nanopub/x/hasSignature Rxu4JAb6cVLNotS0Aa9RlXgVvX52YJd4WgsZ9IE2u289aMvjO1ANEa1weQljcnKn7anFcUpSGC6m+9rUepPW/EjOvSPXFbGEYP7Qm4hCW8y2x0sHHhkuuF+G2u1el9UzhwLEzJ4uTplxCGJSZHAjwc7u9Avqe3iAnZuABysU+ZI= https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234