DATASET Query Run Date: September 20, 2018
DOWNLOAD CSV ART HISTORIANS
DOWNLOAD GOOGLE SPREADSHEET ART HISTORIANS
****
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
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