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 | ?profession ?birthPlaceLabel ?civilStatusLabel ?motherTongueLabel ?nationalityCountryLabel ?evenementLabel | ||
?requestStatusLabel ?decisionStatusLabel ?archivesCollectionLabel ?inventoryNumber ?wikidataIdentifier | ?requestStatusLabel ?decisionStatusLabel ?archivesCollectionLabel ?inventoryNumber ?wikidataIdentifier | ||
(GROUP_CONCAT(DISTINCT ?affiliationLabel; SEPARATOR = " ; ") AS ?affiliations) | (GROUP_CONCAT(DISTINCT ?affiliationLabel; SEPARATOR = " ; ") AS ?affiliations) | ||
| Line 27: | Line 28: | ||
OPTIONAL { ?person wdt:P44 ?motherTongue } | OPTIONAL { ?person wdt:P44 ?motherTongue } | ||
OPTIONAL { ?person wdt:P45 ?nationalityCountry } | OPTIONAL { ?person wdt:P45 ?nationalityCountry } | ||
OPTIONAL { ?person wdt:P53 ?evenement } | |||
OPTIONAL { ?person wdt:P54 ?requestStatus } | OPTIONAL { ?person wdt:P54 ?requestStatus } | ||
OPTIONAL { ?person wdt:P55 ?decisionStatus } | OPTIONAL { ?person wdt:P55 ?decisionStatus } | ||
| Line 46: | Line 47: | ||
} | } | ||
GROUP BY ?person ?lastName ?firstName ?middleNames ?genderLabel ?residenceLabel ?birthDate ?deathDate ?profession | GROUP BY ?person ?lastName ?firstName ?middleNames ?genderLabel ?residenceLabel ?birthDate ?deathDate ?profession | ||
?birthPlaceLabel ?civilStatusLabel ?motherTongueLabel ?nationalityCountryLabel ?requestStatusLabel ?decisionStatusLabel | ?birthPlaceLabel ?civilStatusLabel ?motherTongueLabel ?nationalityCountryLabel ?evenementLabel ?requestStatusLabel ?decisionStatusLabel | ||
?archivesCollectionLabel ?inventoryNumber ?wikidataIdentifier | ?archivesCollectionLabel ?inventoryNumber ?wikidataIdentifier | ||
ORDER BY ASC(?lastName) ASC(?firstName) | ORDER BY ASC(?lastName) ASC(?firstName) | ||
LIMIT | LIMIT 400 | ||
| chart=bordercloud.visualization.DataTable | | chart=bordercloud.visualization.DataTable | ||
Revision as of 12:58, 17 September 2024