query-13395296cdd1d38be7120e089d3ea817

rq turtle/ttl

Potential merge/takeover dates for former hospitals of a hospital SELECT ?oldHospitals ?oldHospitalsLabel ?takeoverMergeDate WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de". } wd:Q50038789 wdt:P1365 ?oldHospitals; #Find all former hospitals of "Sana Klinikum Lichtenberg” wdt:P571 ?newHospitalInception. OPTIONAL { ?oldHospitals wdt:P582 ?takeoverMergeDate. #End time property is potential takeover/merge date } #If end time couldn't be found, use new hospital's inception date BIND (COALESCE(?takeoverMergeDate, ?newHospitalInception) As ?takeoverMergeDate) }

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Potential merge/takeover dates for former hospitals of a hospital
SELECT ?oldHospitals ?oldHospitalsLabel ?takeoverMergeDate WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de". }
    wd:Q50038789 wdt:P1365 ?oldHospitals; #Find all former hospitals of "Sana Klinikum Lichtenberg”
    wdt:P571 ?newHospitalInception.
  OPTIONAL {
    ?oldHospitals wdt:P582 ?takeoverMergeDate. #End time property is potential takeover/merge date
  } 
  #If end time couldn't be found, use new hospital's inception date
  BIND (COALESCE(?takeoverMergeDate, ?newHospitalInception) As ?takeoverMergeDate)
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Hospitals/Report/East-Berlin