It possible to export all ULAN Subject ID with their associated artist Nationaties?

[Alice Lambert]

Hi All! 

My understanding is that I may be able to extract this information from the LOD releases, using a SPARQL and that I can have a look at what is already available and see if the query I need is already there. I have to admit that I am completely unfamiliar with LOD, SPARQL etc. and that any advice on how to query and retrieve the data would be more than welcome! 

Moreover, what format would be available? Would it be XML?

Thank you all for your help!

Alice

[Vladimir Alexiev]

See http://vocab.getty.edu/doc/queries/#ULAN-Specific_Queries.

The closest ones are http://vocab.getty.edu/doc/queries/#Native_American_Painters, http://vocab.getty.edu/doc/queries/#Ancient_Artists_or_Groups_by_Nationality.

The basic query you need is this:

select ?x ?name ?bio ?nationality ?type {
  ?x skos:inScheme ulan: .
  optional {?x gvp:agentTypePreferred [gvp:prefLabelGVP [xl:literalForm ?type]]}
  optional {?x foaf:focus [gvp:nationalityPreferred [gvp:prefLabelGVP [xl:literalForm ?nationality]]]}
  optional {?x gvp:prefLabelGVP [xl:literalForm ?name]}
  optional {?x foaf:focus [gvp:biographyPreferred [schema:description ?bio]]}
}

But it starts with a number of "unknown artists". So you probably want to filter to a specific facet.

See this for a list of facets: http://vocab.getty.edu/doc/queries/#ULAN_Facet_Counts.

Eg if you want only ulan:500000002 Persons, Artists:

select ?x ?name ?bio ?nationality ?type {
  ?x gvp:broaderExtended ulan:500000002. # Persons, Artists
  optional {?x gvp:agentTypePreferred [gvp:prefLabelGVP [xl:literalForm ?type]]}
  optional {?x foaf:focus [gvp:nationalityPreferred [gvp:prefLabelGVP [xl:literalForm ?nationality]]]}
  optional {?x gvp:prefLabelGVP [xl:literalForm ?name]}
  optional {?x foaf:focus [gvp:biographyPreferred [schema:description ?bio]]}
}

Cheers!

[Vladimir Alexiev]

You can download the result in TSV or CSV. (XML and JSON are also available)