Foreign: Difference between revisions

From Resistance in Belgium
No edit summary
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 3: Line 3:
<translate>
<translate>


==== Foreign Resistance Members ====   
==== Foreign Resistance Members ==== <!--T:1-->  


Below is the complete list of people who were living in a country other than Belgium 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.
<!--T:2-->
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 has been produced by the State Security Service (Sûreté de l’État/Staatsveiligheid). Note that the '''places of residence have been "modernised" according to current countries and borders''', in particular to facilitate datavisualisations 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 [https://data.arch.be/wiki/FAQ/en#Consultation_des_archives_papier FAQ].


For more complex searches, combining multiple criteria or gathering more information, please visit the [[page dedicated to cross-search queries]].
<!--T:3-->
The search bar, located at the top right of the list, allows you to filter the results by '''country, city''', or any other term. Clicking on a person's ID (blue link) will take you to the person's complete file, where you can view all the data recorded about them. The table also contains the reference to the individual file held by the State Archives. For more information on access to paper archives, please consult the [https://data.arch.be/wiki/FAQ/en#Consultation_des_archives_papier FAQ].


'''Good to know:''' you have the option to download this data in CSV format, which you can open with programs like LibreOffice Calc.
<!--T:4-->
For more complex searches, combining several criteria or aiming to group together more information, please consult the page dedicated to [https://data.arch.be/wiki/In-depth_search in-depth search].


'''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.'''
<!--T:5-->
'''Good to know:''' You can download this data in CSV format, which you can open with programmes such as LibreOffice Calc.


<!--T:6-->
<br>'''Would you like to quote or re-use content found on '''Resistance in Belgium'''? Please consult our [https://data.arch.be/wiki/licence/en practical information page] to make sure to comply with re-use rules.'''


</translate>




<!--T:7-->
<div class="table-container">
<div class="table-container">
{{#sparql:
{{#sparql:


SELECT ?PaysLabel ?DomicileLabel  ?Nom ?Prenom (CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID)
<!--T:8-->
    (CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance)
SELECT ?CountryLabel ?ResidenceLabel ?LastName ?FirstName
?NoInventaire ?FondsArchivesLabel
(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


<!--T:9-->
WHERE {   
WHERE {   
   ?personne wdt:P7 ?Domicile.  # Trouver des personnes avec un domicile connu (P7)
   ?person wdt:P7 ?Residence.  # Find people with a known residence (P7)
   ?Domicile wdt:P12 ?Pays.     # Trouver les domiciles et leur pays (P14)
   ?Residence wdt:P12 ?Country. # Find residence and their country (P12)


FILTER (?Pays NOT IN (wd:Q5, wd:Q4029))  
<!--T:10-->
FILTER (?Country NOT IN (wd:Q5, wd:Q4029)) # Exclude Belgium and France


   OPTIONAL { ?personne wdt:P2 ?Prenom }   
   <!--T:11-->
   OPTIONAL { ?personne wdt:P3 ?Nom }   
OPTIONAL { ?person wdt:P2 ?FirstName }   
   OPTIONAL { ?personne wdt:P67 ?dateNaissance }
   OPTIONAL { ?person wdt:P3 ?LastName }   
   
   OPTIONAL { ?person wdt:P67 ?birthDate }   
    
    
  # Lien vers les collections et numéro d'inventaire
  # Link to collections and inventory number
   ?personne p:P34 ?DeclarationArchives .  
   ?person p:P34 ?ArchiveDeclaration .  
   ?DeclarationArchives ps:P34 ?FondsArchives .  
   ?ArchiveDeclaration ps:P34 ?ArchiveCollection .  
   ?DeclarationArchives pq:P35 ?NoInventaire .
   ?ArchiveDeclaration pq:P35 ?InventoryNumber .


   # Récupérer les labels automatiquement en français
   <!--T:12-->
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }   
# Automatically retrieve labels in English
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }   
}
}


ORDER BY ASC(?PaysLabel) ASC(?DomicileLabel) ASC(?Nom)
<!--T:13-->
 
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
Line 57: Line 68:
}}
}}
</div>
</div>
</translate>

Latest revision as of 10:34, 20 October 2024


Foreign Resistance Members

Below is the complete list of people who were living in a country other than Belgium (sorted by region) or France (see the dedicated page) during or just after the Second World War, for whom a file has been produced by the State Security Service (Sûreté de l’État/Staatsveiligheid). Note that the places of residence have been "modernised" according to current countries and borders, in particular to facilitate datavisualisations 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. Clicking on a person's ID (blue link) will take you to the person's complete file, where you can view all the data recorded about them. The table also contains the reference to the individual file held by the State Archives. For more information on access to paper archives, please consult the FAQ.

For more complex searches, combining several criteria or aiming to group together more information, please consult the page dedicated to in-depth search.

Good to know: You can download this data in CSV format, which you can open with programmes such as LibreOffice Calc.


Would you like to quote or re-use content found on Resistance in Belgium? Please consult our practical information page to make sure to comply with re-use rules.