2b:null 2c:["$","title",null,{"children":"Example SPARQL Queries for Provenance Index LOD | getty | Observable"}] 31:T126e,## Query 2: From object accession number to transaction activity to buyer and artist to buyer ULAN bio to buyer Wikidata item and image Starting with the object accession number, this query federates from a Provenance Index transaction activity where the object is involved to the artist and buyer information in ULAN and Wikidata. Try it in the [SPARQL GUI](https://data.getty.edu/provenance/sparql-ui#query=PREFIX%20schema%3A%20%3Chttp%3A%2F%2Fschema.org%2F%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20gvp%3A%20%3Chttp%3A%2F%2Fvocab.getty.edu%2Fontology%23%3E%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20crm%3A%20%3Chttp%3A%2F%2Fwww.cidoc-crm.org%2Fcidoc-crm%2F%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20psn%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2Fvalue-normalized%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Factivity%20%3Fobject%20%3Fbuyer%20%3Fbuyer_image_url%20%3Fbuyer_ulan_uri%20%3Fartist%20%3Fartist_image_url%20%3Fartist_ulan_uri%20WHERE%20%7B%0A%20%20%20%20%3Factivity%20a%20crm%3AE7_Activity%20.%20%23%20Key%20on%20the%20Activity%20type%0A%20%20%20%20%3Factivity%20crm%3AP9_consists_of%20%3Fpart%20.%20%23%20The%20transaction%20is%20made%20up%20of%20a%20number%20of%20different%20parts%0A%20%20%20%20%3Fpart%20crm%3AP24_transferred_title_of%20%3Fobject.%20%23%20Connect%20with%20the%20object%20involved%20in%20the%20transaction%0A%20%20%20%20%3Fobject%20crm%3AP1_is_identified_by%20%3Fidn%20.%20%23%20Connect%20to%20the%20identified_by%20node%0A%20%20%20%20%3Fidn%20crm%3AP2_has_type%20%3Chttp%3A%2F%2Fvocab.getty.edu%2Faat%2F300312355%3E%20.%20%23%20Filter%20itentifier%20on%20Accession%20number%20type%0A%20%20%20%20%3Fidn%20crm%3AP190_has_symbolic_content%20%22N02736%22%20.%20%23%20Input%20the%20accession%20number%20text%20value%0A%20%20%20%20%3Fpart%20crm%3AP23_transferred_title_from%20%3Chttps%3A%2F%2Fdata.getty.edu%2Fprovenance%2F29246664-db2b-3f62-8ba6-5e82ad675c77%3E%20.%20%23%20Title%20is%20transferred%20from%20Knoedler%20Gallery%20in%20all%20cases%0A%20%20%20%20%3Fpart%20crm%3AP22_transferred_title_to%20%3Fbuyer%20.%20%23%20Connect%20to%20buyer%20part%20of%20transaction%0A%20%20%20%20%3Fobject%20crm%3AP108i_was_produced_by%2Fcrm%3AP9_consists_of%20%3Fproduction_part%20.%20%23%20Connect%20to%20production%20event%20for%20the%20object%0A%20%20%20%20%3Fproduction_part%20crm%3AP14_carried_out_by%20%3Fartist%20.%20%23%20Get%20the%20artist%20URI%20within%20the%20production%20event%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fartist%20skos%3AexactMatch%20%3Fartist_ulan_uri%20.%20%23%20See%20if%20artist%20has%20an%20ULAN%20ID%20identified%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fbigdata%2Fnamespace%2Fwdq%2Fsparql%3E%20%7B%20%23%20Connect%20to%20Wikidata%20SPARQL%20service%0A%20%20%20%20%20%20%20%20%3Fitem%20p%3AP245%20%3Fstatement0.%0A%20%20%20%20%20%20%20%20%3Fstatement0%20psn%3AP245%20%3Fartist_ulan_uri%20.%20%23%20Match%20ULAN%20URI%20to%20Wikidata%20coreference%0A%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP18%20%3Fartist_image_url%20.%20%23%20Get%20the%20image%20URL%20for%20the%20artist%20from%20Wikidata%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fbuyer%20skos%3AexactMatch%20%3Fbuyer_ulan_uri%20.%20%23%20Get%20buyer%20ULAN%20ID%20if%20available%0A%20%20%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fvocab.getty.edu%2Fsparql%3E%20%7B%20%23%20Connect%20to%20Vocab%20SPARQL%20service%0A%20%20%20%20%20%20%20%20%3Fbuyer_ulan_uri%20foaf%3Afocus%20%3Fbuyer_schema%20.%0A%20%20%20%20%20%20%20%20%3Fbuyer_schema%20gvp%3AbiographyPreferred%20%3Fpref_bio%20.%0A%20%20%20%20%20%20%20%20%3Fpref_bio%20schema%3Adescription%20%3Fbuyer_bio%20.%20%23%20Get%20buyer%20preferred%20bio%20from%20ULAN%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fbigdata%2Fnamespace%2Fwdq%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%20%20%3Fbuyer_item%20p%3AP245%20%3Fbuyer_statement0.%0A%20%20%20%20%20%20%20%20%3Fbuyer_statement0%20psn%3AP245%20%3Fbuyer_ulan_uri%20.%0A%20%20%20%20%20%20%20%20%3Fbuyer_item%20wdt%3AP18%20%3Fbuyer_image_url%20.%20%23%20Get%20buyer%20image%20from%20Wikidata%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%7D&endpoint=https%3A%2F%2Fdata.getty.edu%2Fprovenance%2Fsparql&requestMethod=POST&tabTitle=Query%2012&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq%3D0.9&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq%3D0.9&outputFormat=table)32:Ta84,buyer_bio_query = ` PREFIX schema: PREFIX foaf: PREFIX gvp: PREFIX skos: PREFIX crm: PREFIX p: PREFIX psn: PREFIX wdt: SELECT ?activity ?object ?buyer ?buyer_image_url ?buyer_ulan_uri ?artist ?artist_image_url ?artist_ulan_uri WHERE { ?activity a crm:E7_Activity . # Key on the Activity type ?activity crm:P9_consists_of ?part . # The transaction is made up of a number of different parts ?part crm:P24_transferred_title_of ?object. # Connect with the object involved in the transaction ?object crm:P1_is_identified_by ?idn . # Connect to the identified_by node ?idn crm:P2_has_type . # Filter itentifier on Accession number type ?idn crm:P190_has_symbolic_content "ACC_NO" . # Input the accession number text value ?part crm:P23_transferred_title_from . # Title is transferred from Knoedler Gallery in all cases ?part crm:P22_transferred_title_to ?buyer . # Connect to buyer part of transaction ?object crm:P108i_was_produced_by/crm:P9_consists_of ?production_part . # Connect to production event for the object ?production_part crm:P14_carried_out_by ?artist . # Get the artist URI within the production event OPTIONAL { ?artist skos:exactMatch ?artist_ulan_uri . # See if artist has an ULAN ID identified } OPTIONAL { SERVICE { # Connect to Wikidata SPARQL service ?item p:P245 ?statement0. ?statement0 psn:P245 ?artist_ulan_uri . # Match ULAN URI to Wikidata coreference ?item wdt:P18 ?artist_image_url . # Get the image URL for the artist from Wikidata } } OPTIONAL { ?buyer skos:exactMatch ?buyer_ulan_uri . # Get buyer ULAN ID if available SERVICE { # Connect to Vocab SPARQL service ?buyer_ulan_uri foaf:focus ?buyer_schema . ?buyer_schema gvp:biographyPreferred ?pref_bio . ?pref_bio schema:description ?buyer_bio . # Get buyer preferred bio from ULAN } } OPTIONAL { SERVICE { ?buyer_item p:P245 ?buyer_statement0. ?buyer_statement0 psn:P245 ?buyer_ulan_uri . ?buyer_item wdt:P18 ?buyer_image_url . # Get buyer image from Wikidata } } } `33:[] 2f:{"id":"0099520872e082b9","slug":null,"title":"Example SPARQL Queries for Provenance Index LOD","thumbnail":"5f98ad91c078b0825860e7091c33f5c33acd34dd3f82b90ebb9ef1cdaf8c0e45","access_level":"public","create_time":"$D2024-11-18T18:33:53.336Z","update_time":"$D2025-12-09T12:19:37.972Z","view_time":null,"first_public_time":"$D2024-11-18T18:33:53.336Z","fork":{"id":"515b260f027b1e40","slug":"sparql-queries-for-data-cleanup","title":"SPARQL Queries for Cross-referencing and Data Cleanup","owner":{"id":"869bed2618e3e3dc","login":"getty","name":"getty"}},"stars":0,"starred":false,"owner":{"type":"team","id":"869bed2618e3e3dc","login":"getty","name":"getty","avatar_url":"https://avatars-next.observableusercontent.com/05507b4cccf3e22249c6b267641707da332180adb28f29ccf00a56ffbde7947f","tier":"pro"},"version":237,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"24ebb36c5101724a","login":"garciagregg","name":"Gregg Garcia","avatar_url":"https://avatars-next.observableusercontent.com/397d65fc4968ead11aa2b436571cebde13cccdac0952fac1581c59e25cf98bb6","tier":null}],"members":[{"type":"individual","id":"24ebb36c5101724a","login":"garciagregg","name":"Gregg Garcia","avatar_url":"https://avatars-next.observableusercontent.com/397d65fc4968ead11aa2b436571cebde13cccdac0952fac1581c59e25cf98bb6","tier":null,"role":"editor"},{"type":"team","id":"869bed2618e3e3dc","login":"getty","name":"getty","avatar_url":"https://avatars-next.observableusercontent.com/05507b4cccf3e22249c6b267641707da332180adb28f29ccf00a56ffbde7947f","tier":"pro","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Example SPARQL Queries for Provenance Index LOD","cells":[{"id":4,"value":"# Example SPARQL Queries for Provenance Index LOD","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":70,"value":"## Query 1: Find all People and Group Entities\n\nThis query returns all People and Group entity URLs in the Provenance Index data set. Try it in the [SPARQL GUI](https://data.getty.edu/provenance/sparql-ui#query=PREFIX%20crm%3A%20%3Chttp%3A%2F%2Fwww.cidoc-crm.org%2Fcidoc-crm%2F%3E%0ASELECT%20%3Fentity_lod%20WHERE%20%7B%0A%20%20VALUES%20%3Ftype%20%7B%20crm%3AE21_Person%20crm%3AE74_Group%20%7D%0A%20%20graph%20%3Fentity_lod%20%7B%0A%20%20%20%20%3Fentity_lod%20a%20%3Ftype%0A%20%20%7D%0A%7D&endpoint=https%3A%2F%2Fdata.getty.edu%2Fprovenance%2Fsparql&requestMethod=POST&tabTitle=Query%2012&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq%3D0.9&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq%3D0.9&outputFormat=table)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"agents_query = `\nPREFIX crm: \nSELECT ?entity_lod WHERE {\n VALUES ?type { crm:E21_Person crm:E74_Group }\n graph ?entity_lod {\n ?entity_lod a ?type\n }\n} LIMIT 10\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"{\n let config = {\n header: {\n entity_lod: \"LOD URL\"\n },\n format: {\n entity_lod: (x) => html`${x}`\n }\n };\n return Inputs.table(agents_results, config);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":95,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"viewof acc_no = Inputs.text({\n label: \"Accession Number\",\n value: \"1998.25\",\n width: \"1\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"{\n let config = {\n header: {\n activity: \"Activity URI\",\n object: \"Object LOD\",\n buyer: \"Buyer URI\",\n buyer_ulan_uri: \"Buyer ULAN ID\",\n buyer_image_url: \"Buyer Image\",\n artist: \"Artist URI\",\n artist_ulan_uri: \"Artist ULAN ID\",\n artist_image_url: \"Artist Image\"\n },\n format: {\n activity: (x) => html`${x}`,\n object: (x) => html`${x}`,\n buyer: (x) => html`${x}`,\n buyer_ulan_uri: (x) => html`${x}`,\n buyer_image_url: (x) => html`${x}`,\n artist: (x) => html`${x}`,\n artist_ulan_uri: (x) => html`${x}`,\n artist_image_url: (x) => html`${x}`\n }\n };\n return Inputs.table(buyer_bio_results, config);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"### Helper functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":48,"value":"import { SPARQLQueryDispatcher } from \"@lukesmurray/wikidata-sparql-helpers\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"queryDispatcher = new SPARQLQueryDispatcher(\n \"https://data.getty.edu/provenance/sparql\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"agents_results = queryDispatcher.query(agents_query)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"buyer_bio_results = queryDispatcher.query(\n buyer_bio_query.replace(\"ACC_NO\", acc_no)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"