torsdag 14 juli 2016

House of Windsor P53 Noble family Q81589 House of Windsor

Some queries on the house of Windsor


  1. Number of people in Wikipedia set up belonging to House of Windsor
    1. ?person wdt:P53 wd:Q81589  
      1. House of Windsor 49 members today in Wikidata
      2. Connected to Wikitree are 47 profiles
      3. Profiles in Wikidata not connected to WikiTree are 2 people


Query URL



# People in the House Of Windsor on a map with Birth Death and burial locations
# If Wikitree property set you will have a link
#defaultView:Map
Select ?person ?personLabel ?WikiTreeIDf ?pic ?coord ?coord2 ?coord3 {
?person wdt:P53 wd:Q81589 # P53 Noble family Q81589 House of Windsor
OPTIONAL {?person wdt:P2949 ?WikiTreeID} # P2949 all Wikidata articles with WikiTree id set
    BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTreeIDf)
OPTIONAL {?person wdt:P18 ?pic}
    OPTIONAL {  ?person wdt:P19 ?loc . # P19 Place of Birth
    ?loc wdt:P625 ?coord } .     # Get coordinates from Place of Birth
    OPTIONAL {  ?person wdt:P20 ?loc2 . # P20 Place of Death
    ?loc2 wdt:P625 ?coord2 } .     # Get coordinates from Place of Death
    OPTIONAL {  ?person wdt:P119 ?loc3 . # P119 Place of Burial
    ?loc3 wdt:P625 ?coord3 } .     # Get coordinates from Place of Burial

    SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?WikiTreeIDf)

Inga kommentarer:

Skicka en kommentar