Translations:Antwerpen/7/en
{{#sparql: SELECT DISTINCT ?ResidenceLabel ?LastName ?FirstName (CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID)
(CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?BirthDate) ?ArchiveCollectionLabel ?InventoryNumber
WHERE {
?person wdt:P7 ?Residence . ?Residence wdt:P14* wd:Q49 . # Province of Antwerp OPTIONAL { ?person wdt:P2 ?FirstName } OPTIONAL { ?person wdt:P3 ?LastName } OPTIONAL { ?person wdt:P67 ?birthDate } # Link to collections and inventory number ?person p:P34 ?ArchiveDeclaration . ?ArchiveDeclaration ps:P34 ?ArchiveCollection . ?ArchiveDeclaration pq:P35 ?InventoryNumber .