Brussels: Difference between revisions

From Resistance in Belgium
(Created page with " <div class="table-container"> {{#sparql: SELECT DISTINCT ?DomicileLabel ?Nom ?Prenom (CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID) (CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance) ?FondsArchivesLabel ?NoInventaire WHERE { ?personne wdt:P7 ?Domicile . ?Domicile wdt:...")
 
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:


<translate>
==== Resistance Members from the Brussels-Capital Region ==== <!--T:1-->
<!--T:2-->
Below is the complete list of individuals residing in the Brussels-Capital Region (based on the current organisation of municipalities) during or just after World War II, for whom a file or record has been drawn up by the State Security Service (Sûreté de l’État/Staatsveiligheid). The residency municipalities are listed according to their names prior to the fusion of the municipalities, but grouped according to current provinces for convenience.
<!--T:3-->
'''The search bar, located at the top right of the list, lets you to filter the results by municipality''' 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#Access_to_paper_archives FAQ].
<!--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].
<!--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 refer to our [https://data.arch.be/wiki/licence/en practical information page] to make sure you comply with the reuse rules.'''
<!--T:7-->
<div class="table-container">
<div class="table-container">
{{#sparql:
{{#sparql:
SELECT DISTINCT ?DomicileLabel ?Nom ?Prenom
SELECT DISTINCT ?ResidenceLabel ?LastName ?FirstName
(CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID)
(CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID)
       (CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance)
       (CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?BirthDate)
       ?FondsArchivesLabel ?NoInventaire
       ?ArchiveCollectionLabel ?InventoryNumber
WHERE {
WHERE {
   ?personne wdt:P7 ?Domicile .  
   ?person wdt:P7 ?Residence .  
   ?Domicile wdt:P14* wd:Q46 .  # Région de Bruxelles-Capitale
   ?Residence wdt:P14* wd:Q46 .  # Brussels-Capital Region
    
    
   OPTIONAL { ?personne wdt:P2 ?Prenom }   
   OPTIONAL { ?person wdt:P2 ?FirstName }   
   OPTIONAL { ?personne wdt:P3 ?Nom }   
   OPTIONAL { ?person wdt:P3 ?LastName }   
   OPTIONAL { ?personne wdt:P67 ?dateNaissance }   
   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 le label du domicile
<!--T:8-->
#  OPTIONAL { ?domicile rdfs:label ?DomicileLabel . FILTER(LANG(?DomicileLabel) = 'fr') }
# Retrieve the residence label
#  OPTIONAL { ?Residence rdfs:label ?ResidenceLabel . FILTER(LANG(?ResidenceLabel) = 'en') }


   # Récupérer les labels automatiquement ou en français
   <!--T:9-->
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }   
# Automatically retrieve labels or in English
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }   
}
}
# GROUP BY ?personne ?Nom ?Prenom ?DomicileLabel ?dateNaissance ?FondsArchivesLabel ?NoInventaire
# GROUP BY ?person ?LastName ?FirstName ?ResidenceLabel ?birthDate ?ArchiveCollectionLabel ?InventoryNumber
ORDER BY ASC(?DomicileLabel) ASC(?Nom) ASC(?Prenom)
ORDER BY ASC(?ResidenceLabel) ASC(?LastName) ASC(?FirstName)
| chart=bordercloud.visualization.DataTable
| chart=bordercloud.visualization.DataTable
| class=my-table-class
| class=my-table-class
Line 34: Line 57:
}}
}}
</div>
</div>
</translate>

Latest revision as of 18:46, 20 October 2024


Resistance Members from the Brussels-Capital Region

Below is the complete list of individuals residing in the Brussels-Capital Region (based on the current organisation of municipalities) during or just after World War II, for whom a file or record has been drawn up by the State Security Service (Sûreté de l’État/Staatsveiligheid). The residency municipalities are listed according to their names prior to the fusion of the municipalities, but grouped according to current provinces for convenience.

The search bar, located at the top right of the list, lets you to filter the results by municipality 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 refer to our practical information page to make sure you comply with the reuse rules.