DATASET Query Run Date: September 20, 2018

Resources for Linked Open Data: Art Historians in Wikidata and Wikipedia with IDs, birth, death

DOWNLOAD CSV ART HISTORIANS


DOWNLOAD GOOGLE SPREADSHEET ART HISTORIANS


****

Sparql Query in Wikidata that, for a Wikidata item, derives the DBpedia ID from Wikipedia in English. *

Note: This query shows only those art historians who have both a Wikidata and a Wikipedia entry.
It shows the DBpedia URL, WIKIDATA ID, VIAF, ULAN, BNF, GND, Birth and Death Date, and the Library of Congress ID where available. 

Number of records: 2661

Wikidata Sparql Query

PREFIX schema:

# Get DBpedia URIs for Wikidata objects by converting them from Wikipedia URLs
SELECT ?dbpediaId ?item ?VIAF_ID ?ULAN_ID ?BnF_ID ?GND_ID ?date_of_birth ?date_of_death ?Library_of_Congress_authority_ID WHERE {
  ?item wdt:P106 wd:Q1792450.
  ?sitelink schema:about ?item.
  ?sitelink schema:isPartOf .
  BIND(URI(CONCAT("http://dbpedia.org/resource/", SUBSTR(STR(?sitelink), 31))) AS ?dbpediaId)
  OPTIONAL { ?item wdt:P214 ?VIAF_ID. }
  OPTIONAL { ?item wdt:P245 ?ULAN_ID. }
  OPTIONAL { ?item wdt:P268 ?BnF_ID. }
  OPTIONAL { ?item wdt:P227 ?GND_ID. }
  OPTIONAL { ?item wdt:P569 ?date_of_birth. }
  OPTIONAL { ?item wdt:P570 ?date_of_death. }
  OPTIONAL { ?item wdt:P244 ?Library_of_Congress_authority_ID. }
  OPTIONAL {  }
}
LIMIT 40000



====
* many thanks to the developer