https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ
.trig | .trig.txt | .jelly | .jelly.txt | .jsonld | .jsonld.txt | .nq | .nq.txt | .xml | .xml.txt
@prefix this: <https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ> .
@prefix sub: <https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/> .
@prefix np: <http://www.nanopub.org/nschema#> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix nt: <https://w3id.org/np/o/ntemplate/> .
@prefix npx: <http://purl.org/nanopub/x/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix orcid: <https://orcid.org/> .
@prefix prov: <http://www.w3.org/ns/prov#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
sub:Head {
this: a np:Nanopublication;
np:hasAssertion sub:assertion;
np:hasProvenance sub:provenance;
np:hasPublicationInfo sub:pubinfo .
}
sub:assertion {
sub:get-latest-users-with-type a <https://w3id.org/kpxl/grlc/grlc-query>;
dct: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.";
dct:license <http://www.apache.org/licenses/LICENSE-2.0>;
rdfs:label "Get latest users with name and type";
<https://w3id.org/kpxl/grlc/endpoint> <https://w3id.org/np/l/nanopub-query-1.1/repo/type/77757cabf6184c51c20b8b0fe5dc5e1365b7f628448335184ad54319a0affdfc>;
<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)""" .
}
sub:provenance {
sub:assertion prov:wasAttributedTo orcid:0000-0002-1267-0234 .
}
sub:pubinfo {
orcid:0000-0002-1267-0234 foaf:name "Tobias Kuhn" .
this: dct:created "2026-09-25T08:36:50Z"^^xsd:dateTime;
dct:creator orcid:0000-0002-1267-0234;
dct:license <https://creativecommons.org/licenses/by/4.0/>;
npx:embeds sub:get-latest-users-with-type;
npx:supersedes <https://w3id.org/np/RAvlxWqDNtsqXPDqPmXG0-IOysqKAvUVpftJbQ7hoJcWg>;
rdfs:label "Get latest users with name and type";
nt:wasCreatedFromProvenanceTemplate <https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU>;
nt:wasCreatedFromPubinfoTemplate <https://w3id.org/np/RA-N4_kFxcruvBTlo1yJv29E4SLOXsx5KO_th69PprMrA>,
<https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8>, <https://w3id.org/np/RARJj78P72NR5edKOnu_f4ePE9NYYuW2m2pM-fEoobMBk>,
<https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw>;
nt:wasCreatedFromTemplate <https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k> .
sub:sig npx:hasAlgorithm "RSA";
npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB";
npx:hasSignature "Rxu4JAb6cVLNotS0Aa9RlXgVvX52YJd4WgsZ9IE2u289aMvjO1ANEa1weQljcnKn7anFcUpSGC6m+9rUepPW/EjOvSPXFbGEYP7Qm4hCW8y2x0sHHhkuuF+G2u1el9UzhwLEzJ4uTplxCGJSZHAjwc7u9Avqe3iAnZuABysU+ZI=";
npx:hasSignatureTarget this:;
npx:signedBy orcid:0000-0002-1267-0234 .
}