Provinces: Difference between revisions
| Line 5: | Line 5: | ||
<div class="table-container"> | <div class="table-container"> | ||
{{#sparql: | {{#sparql: | ||
SELECT DISTINCT (?person AS ?link) (?lastName AS ?lastName) (?firstName AS ?firstName) (?middleNames AS ?middleNames) ?genderLabel ?residenceLabel | SELECT DISTINCT (?person AS ?link) (?lastName AS ?lastName) (?firstName AS ?firstName) (?middleNames AS ?middleNames) ?genderLabel ?residenceLabel | ||
(CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?birthDateFormatted) | (CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?birthDateFormatted) | ||
(CONCAT(SUBSTR(STR(?deathDate), 1, 4), "-", SUBSTR(STR(?deathDate), 6, 2), "-", SUBSTR(STR(?deathDate), 9, 2)) AS ?deathDateFormatted) | (CONCAT(SUBSTR(STR(?deathDate), 1, 4), "-", SUBSTR(STR(?deathDate), 6, 2), "-", SUBSTR(STR(?deathDate), 9, 2)) AS ?deathDateFormatted) | ||
?profession ?birthPlaceLabel ?civilStatusLabel ?motherTongueLabel ?nationalityCountryLabel ?evenementLabel | ?profession ?birthPlaceLabel ?civilStatusLabel ?motherTongueLabel ?nationalityCountryLabel ?evenementLabel | ||
? | (GROUP_CONCAT(DISTINCT ?demandeStatutLabel; SEPARATOR = " ; ") AS ?statuts_demandes_concat) | ||
(GROUP_CONCAT(DISTINCT ?decisionStatutLabel; SEPARATOR = " ; ") AS ?statuts_obtenus_concat) | |||
?archivesCollectionLabel ?inventoryNumber ?wikidataIdentifier | |||
(GROUP_CONCAT(DISTINCT ?affiliationLabel; SEPARATOR = " ; ") AS ?affiliations) | (GROUP_CONCAT(DISTINCT ?affiliationLabel; SEPARATOR = " ; ") AS ?affiliations) | ||
WHERE { | WHERE { | ||
?person wdt:P7 ?residence . | ?person wdt:P7 ?residence . | ||
?residence wdt:P14* wd:Q53 . # Province of Namur | ?residence wdt:P14* wd:Q53 . # Province of Namur | ||
| Line 29: | Line 29: | ||
OPTIONAL { ?person wdt:P45 ?nationalityCountry } | OPTIONAL { ?person wdt:P45 ?nationalityCountry } | ||
OPTIONAL { ?person wdt:P53 ?evenement } | OPTIONAL { ?person wdt:P53 ?evenement } | ||
# Ajouter les statuts demandés et obtenus | |||
OPTIONAL { | |||
?person wdt:P54 ?demandeStatut. # Type de statuts demandés | |||
?demandeStatut rdfs:label ?demandeStatutLabel. | |||
FILTER(LANG(?demandeStatutLabel) = "en") | |||
} | |||
OPTIONAL { | |||
?person wdt:P55 ?decisionStatut. # Type de statuts obtenus | |||
?decisionStatut rdfs:label ?decisionStatutLabel. | |||
FILTER(LANG(?decisionStatutLabel) = "en") | |||
} | |||
OPTIONAL { ?person wdt:P54 ?requestStatus } | OPTIONAL { ?person wdt:P54 ?requestStatus } | ||
OPTIONAL { ?person wdt:P55 ?decisionStatus } | OPTIONAL { ?person wdt:P55 ?decisionStatus } | ||
| Line 51: | Line 64: | ||
ORDER BY ASC(?lastName) ASC(?firstName) | ORDER BY ASC(?lastName) ASC(?firstName) | ||
LIMIT | LIMIT 1000 | ||
| chart=bordercloud.visualization.DataTable | | chart=bordercloud.visualization.DataTable | ||
Revision as of 14:07, 17 September 2024