Translations:West-Vlaanderen/7/de

From Resistance in Belgium
Revision as of 13:15, 18 October 2024 by A Lyapounov (talk | contribs) (Created page with "<div class="table-container"> {{#sparql: SELECT DISTINCT ?OrtLabel ?Nachname ?Vorname (CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID) (CONCAT(SUBSTR(STR(?Geburtsdatum), 1, 4), "-", SUBSTR(STR(?Geburtsdatum), 6, 2), "-", SUBSTR(STR(?Geburtsdatum), 9, 2)) AS ?GeburtsDatum) ?ArchivsammlungLabel ?Inventarnummer WHERE { ?person wdt:P7 ?Ort . ?Ort wdt:P14* wd:Q58 . # Pr...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

{{#sparql: SELECT DISTINCT ?OrtLabel ?Nachname ?Vorname (CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID)

     (CONCAT(SUBSTR(STR(?Geburtsdatum), 1, 4), "-", SUBSTR(STR(?Geburtsdatum), 6, 2), "-", SUBSTR(STR(?Geburtsdatum), 9, 2)) AS ?GeburtsDatum)
      ?ArchivsammlungLabel ?Inventarnummer

WHERE {

 ?person wdt:P7 ?Ort . 
 ?Ort wdt:P14* wd:Q58 .  # Province of West Flanders
 OPTIONAL { ?person wdt:P2 ?Vorname }  
 OPTIONAL { ?person wdt:P3 ?Nachname }  
 OPTIONAL { ?person wdt:P67 ?Geburtsdatum }  

 # Link to collections and inventory number
 ?person p:P34 ?ArchivsammlungDeclaration . 
 ?ArchivsammlungDeclaration ps:P34 ?Archivsammlung . 
 ?ArchivsammlungDeclaration pq:P35 ?Inventarnummer .