Olympics

• Query Olympics USA
• All WikiTree Olympics
• On a Map
• If picture Display

All American citizens who has participated in Olympics

#SPARQL query in Wikidata

# Find all people with WikiTreeID => they have a profile in WikiTree

# Display on the map 

# - Place of Birth

# - Place of Death 

# - Place of Burial

#

# In the popup window show illustration from Wikidata and URL to WikiTree

SELECT distinct ?person ?olympicsLabel ?personLabel ?personDescription ?BirthDate ?BirthlocLabel ?DeathDate ?DeathlocLabel ?WikiTree WHERE {

{

   ?olympics wdt:P31 wd:Q159821 . # All Olympics

   ?person wdt:P1344 ?olympics .

   ?person wdt:P27 wd:Q30 .    # American 

   OPTIONAL{ ?person wdt:P2949 ?WikiTreeID .}    # All item with WikiTreeID

#   OPTIONAL { ?person  wdt:P535 ?FindAGrave }  # FindAGrave

#   OPTIONAL { ?person wdt:P1819 ?Genealogics } # Genealogics

#   OPTIONAL { ?person wdt:P2013 ?FB }   # Facebook

    OPTIONAL { ?person wdt:P569 ?BirthDate .} # P569 Birth

    OPTIONAL { ?person wdt:P570 ?DeathDate .} # P569 Birth

    OPTIONAL {  ?person wdt:P19 ?Birthloc .} # P19 Place of Birth

    OPTIONAL {  ?person wdt:P20 ?Deathloc .} # P19 Place of Birth

#    ?Birthloc wdt:P625 ?coord } .     # Get coordinates from Place of Birth

#   OPTIONAL {?person wdt:P18 ?ppicture}         # If Wikidata has a illustration use that

  

   BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)

#   BIND (URI(CONCAT("https://www.facebook.com/",?FB)) AS ?FBf)  

}

   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

  Order by ?olympicsLabel ?personLabel

LIMIT 10000