Foreign: Difference between revisions
No edit summary |
(Marked this version for translation) |
||
| Line 22: | Line 22: | ||
<!--T:7--> | |||
<div class="table-container"> | <div class="table-container"> | ||
{{#sparql: | {{#sparql: | ||
<!--T:8--> | |||
SELECT ?CountryLabel ?ResidenceLabel ?LastName ?FirstName | SELECT ?CountryLabel ?ResidenceLabel ?LastName ?FirstName | ||
(CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID) | (CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID) | ||
| Line 30: | Line 32: | ||
?InventoryNumber ?ArchiveCollectionLabel | ?InventoryNumber ?ArchiveCollectionLabel | ||
<!--T:9--> | |||
WHERE { | WHERE { | ||
?person wdt:P7 ?Residence. # Find people with a known residence (P7) | ?person wdt:P7 ?Residence. # Find people with a known residence (P7) | ||
?Residence wdt:P12 ?Country. # Find residence and their country (P12) | ?Residence wdt:P12 ?Country. # Find residence and their country (P12) | ||
<!--T:10--> | |||
FILTER (?Country NOT IN (wd:Q5, wd:Q4029)) # Exclude Belgium and France | FILTER (?Country NOT IN (wd:Q5, wd:Q4029)) # Exclude Belgium and France | ||
OPTIONAL { ?person wdt:P2 ?FirstName } | <!--T:11--> | ||
OPTIONAL { ?person wdt:P2 ?FirstName } | |||
OPTIONAL { ?person wdt:P3 ?LastName } | OPTIONAL { ?person wdt:P3 ?LastName } | ||
OPTIONAL { ?person wdt:P67 ?birthDate } | OPTIONAL { ?person wdt:P67 ?birthDate } | ||
| Line 45: | Line 50: | ||
?ArchiveDeclaration pq:P35 ?InventoryNumber . | ?ArchiveDeclaration pq:P35 ?InventoryNumber . | ||
# Automatically retrieve labels in English | <!--T:12--> | ||
# Automatically retrieve labels in English | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
<!--T:13--> | |||
ORDER BY ASC(?CountryLabel) ASC(?ResidenceLabel) ASC(?LastName) | ORDER BY ASC(?CountryLabel) ASC(?ResidenceLabel) ASC(?LastName) | ||
<!--T:14--> | |||
| chart=bordercloud.visualization.DataTable | | chart=bordercloud.visualization.DataTable | ||
| class=my-table-class | | class=my-table-class | ||
Revision as of 20:06, 4 October 2024
Foreign Resistance Members
Below is the complete list of people who were living in a country other than Belgium or France during or just after the Second World War, for whom a file or record was established by the Sûreté de l'État. Note that the places of residence have been "modernized" according to current countries and borders, particularly to facilitate data visualizations and other analyses.
The search bar, located at the top right of the list, allows you to filter the results by country, city, or any other term. By clicking on a person's identifier (blue link), you will access their complete record to view all registered data about them. The table also contains the reference for the individual file held by the State Archives. For more information on consulting paper archives, please see the FAQ.
For more complex searches, combining multiple criteria or gathering more information, please visit the page dedicated to cross-search queries.
Good to know: you have the option to download this data in CSV format, which you can open with programs like LibreOffice Calc.
Want to cite or reuse content found on Resistance in Belgium? Please check our information page to ensure you comply with reuse conditions.