Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Nomisma IDs created or edited by Andy Meadows
PREFIX crm: <>
PREFIX dcmitype: <>
PREFIX dcterms: <>
PREFIX foaf: <>
PREFIX geo: <>
PREFIX nm: <>
PREFIX nmo: <>
PREFIX org: <>
PREFIX rdf: <>
PREFIX rdfs: <>
PREFIX skos: <>
PREFIX xsd: <>
PREFIX prov: <>
SELECT ?concept ?label ?editor ?orcid ?date ?spreadsheet ?desc WHERE {
BIND (<> as ?editor)
SELECT ?editor ?orcid WHERE {
?editor skos:exactMatch ?orcid FILTER (strStarts(str(?orcid), ""))
?concept skos:changeNote ?prov ;
skos:prefLabel ?label FILTER (langMatches(lang(?label), "en"))
{?prov prov:wasGeneratedBy ?activity}
UNION {?prov prov:activity ?activity}
?activity a prov:Activity ;
prov:atTime ?date
{?activity prov:wasAssociatedWith ?editor FILTER NOT EXISTS {?activity prov:used ?spreadsheet}}
UNION {?activity prov:used ?spreadsheet
{?spreadsheet dcterms:creator ?editor }
UNION {?spreadsheet dcterms:contributor ?editor}
?spreadsheet dcterms:description ?desc
} ORDER BY ?label LIMIT 100

This comment has been minimized.

Copy link
Owner Author

@ewg118 ewg118 commented Sep 13, 2018

Copy and paste into the test SPARQL endpoint at

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment