View source for Foreign/de




<span id="Foreign_Resistance_Members"></span>
==== Widerstandskämpfer:innen aus dem Ausland ====  

<div lang="en" dir="ltr" class="mw-content-ltr">
Below is the complete list of people who were '''living in a country other than Belgium''' (sorted by region) '''or  France''' (see the [https://data.arch.be/wiki/France dedicated page]) 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.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
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 [https://data.arch.be/wiki/FAQ/en#Consultation_des_archives_papier FAQ].
</div>

<div lang="en" dir="ltr" class="mw-content-ltr">
For more complex searches, combining multiple criteria or aimed at gathering more information, please consult [https://data.arch.be/wiki/Exemples our examples page] for cross-sectional queries.
</div>

<div lang="en" dir="ltr" class="mw-content-ltr">
'''Good to know:''' you have the option to download this data in CSV format, which you can open with programs like LibreOffice Calc.
</div>

<div lang="en" dir="ltr" class="mw-content-ltr">
<br>'''Want to cite or reuse content found on ''Resistance in Belgium''? Please check our [https://data.arch.be/wiki/licence/en information page] to ensure you comply with reuse conditions.'''
</div>



<div lang="en" dir="ltr" class="mw-content-ltr">
<div class="table-container">
{{#sparql:
</div>

<div lang="en" dir="ltr" class="mw-content-ltr">
SELECT ?CountryLabel ?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)
?InventoryNumber ?ArchiveCollectionLabel
</div> 

<div lang="en" dir="ltr" class="mw-content-ltr">
WHERE {  
  ?person wdt:P7 ?Residence.  # Find people with a known residence (P7)
  ?Residence wdt:P12 ?Country.  # Find residence and their country (P12)
</div>

<div lang="en" dir="ltr" class="mw-content-ltr">
FILTER (?Country NOT IN (wd:Q5, wd:Q4029))  # Exclude Belgium and France
</div>

  <div lang="en" dir="ltr" class="mw-content-ltr">
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 .
</div>

  <div lang="en" dir="ltr" class="mw-content-ltr">
# Automatically retrieve labels in English
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
}
</div>

<div lang="en" dir="ltr" class="mw-content-ltr">
ORDER BY ASC(?CountryLabel) ASC(?ResidenceLabel) ASC(?LastName)
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
| chart=bordercloud.visualization.DataTable
| class=my-table-class
| options=scrollX:true!scrollY:true!ordering:true
| endpoint = https://query.data.arch.be/proxy/wdqs/bigdata/namespace/wdq/sparql
| log=2
}}
</div>
</div>