Add links

    Oost-Vlaanderen: 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 Province of East Flanders ==== <!--T:1-->


    <!--T:2-->
    Below is the complete list of individuals residing in the Province of East Flanders (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:Q54 .  # Province de Oost-Vlaanderen
       ?Residence wdt:P14* wd:Q54 .  # Province of East Flanders
        
        
       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 54:
    }}
    }}
    </div>
    </div>
    </translate>

    Latest revision as of 18:50, 20 October 2024

    Resistance Members from the Province of East Flanders

    Below is the complete list of individuals residing in the Province of East Flanders (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.

    Retrieved from "https://data.arch.be/w/index.php?title=Oost-Vlaanderen&oldid=186888"