Foreign: Difference between revisions

From Resistance in Belgium
No edit summary
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 6: Line 6:


<!--T:2-->
<!--T:2-->
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.
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.
 


<!--T:3-->
<!--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. 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].
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].


<!--T:4-->
<!--T:4-->
For more complex searches, combining multiple criteria or gathering more information, please visit the [[page dedicated to cross-search queries]].
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].


<!--T:5-->
<!--T:5-->
'''Good to know:''' you have the option to download this data in CSV format, which you can open with programs like LibreOffice Calc.
'''Good to know:''' You can download this data in CSV format, which you can open with programmes such as LibreOffice Calc.


<!--T:6-->
<!--T:6-->
'''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.'''
<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:


<!--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 32: Line 33:
?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 47: Line 51:
   ?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
Line 61: 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.