Add links

    In-depth search: Difference between revisions

    From Resistance in Belgium
    (Created page with " __TOC__ '''Cette page présente trois niveaux de requêtes approfondies''' pour explorer les données de la plateforme : débutant, intermédiaire, et avancé. Ces requêtes, basées sur le langage '''SPARQL''', permettent d'interroger des bases de données structurées comme celle-ci. Chaque exemple peut être adapté à vos besoins pour réaliser des recherches plus spécifiques et croiser différentes informations présentes dans la base de données. '''À noter''...")
     
    No edit summary
     
    (10 intermediate revisions by the same user not shown)
    Line 2: Line 2:
    __TOC__
    __TOC__


    <translate>


    '''Cette page présente trois niveaux de requêtes approfondies''' pour explorer les données de la plateforme : débutant, intermédiaire, et avancé. Ces requêtes, basées sur le langage '''SPARQL''', permettent d'interroger des bases de données structurées comme celle-ci. Chaque exemple peut être adapté à vos besoins pour réaliser des recherches plus spécifiques et croiser différentes informations présentes dans la base de données.
    <!--T:1-->
    '''This page presents three levels of in-depth queries''' for exploring the platform's data: beginner, intermediate and advanced. These queries are based on the SPARQL language, which can be used to query structured databases such as this one. Each query example can be customised to access specific information about the persons listed in the database.


    '''À noter''' : par défaut, les requêtes affichent toutes les personnes enregistrées, sans appliquer de filtre pour n'afficher que les résistant·e·s officiellement reconnu·e·s par l'État belge. Vous pouvez personnaliser les filtres selon vos besoins dans chaque requête. Ce point est abordé plus en détail dans le niveau '''avancé'''.  
    <!--T:2-->
    '''Please note''': By default, the queries display all persons registered, without applying a filter to display only those resistance members officially recognised by the Belgian state. You can customise the filters to suit your needs in each query. This is covered in more detail in the '''advanced level'''.


    Pour en savoir plus sur '''SPARQL''' et apprendre à personnaliser les requêtes, consultez [ce tutoriel].
    <!--T:3-->
    Soon, you will be able to learn more about SPARQL and how to customise queries by following [https://data.arch.be/wiki/Tutorial this tutorial] ''(coming soon)''.




    <!--T:4-->
    <div style="border:2px ;padding:10px; background-color:#43A586;">
    <div style="border:2px ;padding:10px; background-color:#43A586;">
    <span style="color:#FFFFFF;"><big>Requêtes approfondies - Niveau : débutant</big></span> </div>
    <span style="color:#FFFFFF;"><big>In-depth queries - Level: beginner</big></span> </div>
    <br>
    <br>
    Cette section présente des requêtes de base pour explorer les données de la plateforme. Vous pourrez, par exemple, rechercher des personnes par '''nom de famille, lieu de résidence ou appartenance à une organisation de résistance'''. Ces requêtes ne nécessitent pas de connaissances avancées et vous permettront de mieux comprendre les bases du langage SPARQL. Pour croiser davantage de données ou récupérer plusieurs colonnes d'informations supplémentaires, veuillez consulter les requêtes de niveau intermédiaire ou avancé.
    This section presents some basic queries for exploring the platform's data. For example, you can search for persons by '''family name, place of residence or membership in a resistance organisation'''. These queries do not require any advanced knowledge and will give you a better understanding of the basics of the SPARQL language. To cross-reference more data or retrieve additional information, please consult the section about intermediate or advanced level queries.


    ==== > Rechercher des résistant·e·s par nom de famille ====


    * [https://tinyurl.com/23l82ln6 Voir les résultats sous forme de liste.]
    ==== > Search for resistance members by family name ==== <!--T:5-->
    * [https://tinyurl.com/26plvm38 Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).


    <!--T:6-->
    * [https://tinyurl.com/247hknjq View results in list format.]
    * [https://tinyurl.com/22h4s88h Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).<br>


    ==== > Rechercher les membres d'une organisation de résistance ====
    ==== > Search for members of a resistance organisation ==== <!--T:7-->


    * [https://tinyurl.com/2avltfy9 Voir les résultats sous forme de liste.]
    <!--T:8-->
    * [https://tinyurl.com/28pzp9fg Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).
    * [https://tinyurl.com/27kcbgtl View results in list format.]
    * [https://tinyurl.com/2yhdv73c Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).




    ==== > Rechercher des résistant·e·s par commune de domicile ====
    ==== > Search for resistance members by place of residence ==== <!--T:9-->


    * [https://tinyurl.com/2djbmear Voir les résultats sous forme de liste.]
    <!--T:10-->
    * [https://tinyurl.com/2ykwatuq Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).
    * [https://tinyurl.com/26rfpqls View results in list format.]
    * [https://tinyurl.com/2ynaxr6h Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    '''Astuce''' : si vous préférez explorer les données à travers des tableaux préétablis par région de domicile, consultez [https://data.arch.be/wiki/Search_by_location cette page].
    <!--T:11-->
    '''Hint''': If you prefer to explore the data using predefined tables by region of residence, consult [https://data.arch.be/wiki/Search_by_place_of_residence this page].




    <!--T:12-->
    <div style="border:2px ;padding:10px; background-color:#158f68;">
    <div style="border:2px ;padding:10px; background-color:#158f68;">
    <span style="color:#FFFFFF"><big>Requêtes approfondies - Niveau : intermédiaire </big></span> </div>
    <span style="color:#FFFFFF"><big>In-depth queries - Level: intermediate</big></span> </div>
    <br>
    <br>
    Cette section vous propose des requêtes permettant d'approfondir votre exploration des données de la plateforme. Vous pourrez, par exemple, rechercher des résistant·e·s '''par profession''', visualiser le nombre de '''membres des différentes organisations de résistance''', ou encore visualiser les '''lieux de décès pendant la guerre''' sur une carte interactive. Ces requêtes nécessitent une compréhension un peu plus avancée du langage SPARQL et vous offrent la possibilité de croiser plusieurs types de données pour obtenir des informations plus détaillées.
    This section presents queries for exploring the platform's data more extensively. For example, you can search for members of the Resistance '''by profession''', view the number of '''members of the various Resistance organisations''', or view the '''places where people died during the war''' on an interactive map. These queries require a slightly more advanced understanding of the SPARQL language and give you the opportunity to cross-reference several types of data to obtain more detailed information.


    ==== > Rechercher des résistant·e·s par profession ====


    * [https://tinyurl.com/278gfy9s Voir les résultats sous forme de liste.]
    ==== > Search for resistance members by profession ==== <!--T:13-->
    * [https://tinyurl.com/2bhgyjaa Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).


    '''À noter''' : les professions apparaissent telles qu'encodées dans les dossiers papiers ; elles n'ont pour l'instant pas été standardisées ni traduites. Il est donc opportun d'utiliser des termes de recherche à la fois en français et en néerlandais. Nous travaillons activement à catégoriser ces professions afin de faciliter les recherches ; cette mise à jour sera disponible dans le courant des prochaines semaines.  
    <!--T:14-->
    * [https://tinyurl.com/2xnrv3q6 View results in list format.]
    * [https://tinyurl.com/24zmmjal Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    <!--T:15-->
    '''Please note''': The professions are shown as written down in the paper files; they have not yet been standardised or translated. It is therefore advisable to use search terms in both French and Dutch. We are actively working on categorising these professions to make them easier to find, and this update will be available in the next few months.


    ==== > Nombre de membres des organisations de résistance ====


    * [https://tinyurl.com/23cyr5dn Voir les résultats sous forme de graphique.]
    ==== > Number of members of a resistance organisation ==== <!--T:16-->
    * [https://tinyurl.com/2xvtylt5  Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).


    '''Astuce''' : en cliquant sur les bulles contenant les noms d'organisations dans le graphique, vous accéderez directement à la fiche détaillée de l'organisation.
    <!--T:17-->
    * [https://tinyurl.com/2bvsgzqz View results in graph format.]
    * [https://tinyurl.com/29g3rvr3 Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    <!--T:18-->
    '''Hint''': By clicking on the fields containing the names of the organisations in the graph, you can go directly to the organisation's detailed sheet.


    ==== > Visualiser les lieux de décès pendant la guerre ====


    * [https://tinyurl.com/274cwhpj Voir les résultats sous forme de carte interactive.]
    ==== > View places of death during the war ==== <!--T:19-->
    * [https://tinyurl.com/26qqo59k Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).


    '''Astuce''' : en cliquant sur les points sur la carte, vous pourrez afficher les noms des résistant·e·s, leur date de décès et d'éventuels détails complémentaires.
    <!--T:20-->
    * [https://tinyurl.com/2yge44rz View results on an interactive map.]
    * [https://tinyurl.com/2cw6sw7v Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    <!--T:21-->
    '''Hint''': By clicking on the dots on the map, you can display the names of the resistance fighters, their dates of death and any additional details.


    <!--T:22-->
    <div style="border:2px ;padding:10px; background-color:#0E6448;">
    <div style="border:2px ;padding:10px; background-color:#0E6448;">
    <span style="color:#FFFFFF"><big>Requêtes approfondies - Niveau : avancé</big></span> </div>
    <span style="color:#FFFFFF"><big>In-depth queries - Level: advanced</big></span> </div>
    <br>
    <br>
    Les requêtes avancées vous permettent d'explorer les données en profondeur. Vous pouvez regrouper les résultats en fonction de plusieurs critères, récupérer davantage de données ou encore enrichir les données locales avec des informations issues de sources externes grâce aux requêtes fédérées.
    Advanced queries let you explore data in depth. You can group results according to several criteria, retrieve more data or enrich local data with information from external sources using federated queries.
     
    ==== > List the women who have been detained, including their occupation and recognition status if available ==== <!--T:23-->


    ==== > Lister les femmes ayant été placées en détention, avec, si disponibles, leur profession et statut de reconnaissance ====
    <!--T:24-->
    * [https://tinyurl.com/2dcxkq3a View results in list format.]
    * [https://tinyurl.com/26hdpzw5 Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    * [https://tinyurl.com/258dynx2 Voir les résultats sous forme de liste.]
    <!--T:25-->
    * [https://tinyurl.com/29akrbat Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).
    '''Please note''': Some persons may be listed on several consecutive lines if there is more than one value for the dates of detention, profession or status obtained. If necessary, you can adjust the query to group the results; see the [tutorial] to find out more.


    '''À noter''' : certaines personnes peuvent apparaître sur plusieurs lignes consécutives s'il existe plus d'une valeur pour les dates de détention, la profession ou le statut obtenu. Si nécessaire, vous pouvez ajuster la requête pour regrouper les résultats ; consultez le [tutoriel] pour en savoir plus.


    ==== > List the members of the Resistance who have been recognised as ARA/FFC members, or who have received a letter of appreciation, with their place of residence and a reference to the individual archive files ==== <!--T:26-->


    ==== > Lister les résistant·e·s reconnu·e·s ARA/FFC, ou ayant reçu une lettre de remerciements, avec leur domicile et la référence aux dossiers d'archives individuels ====
    <!--T:27-->
    * [https://tinyurl.com/29u7ume4 View results in list format.]
    * [https://tinyurl.com/2bgsfk5l Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    * [https://tinyurl.com/26jhhzbs Voir les résultats sous forme de liste.]
    <!--T:28-->
    * [https://tinyurl.com/2blfxzul Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).
    '''Please note''': The number of results displayed is limited to 100 by default to avoid overloading the query and improve display performance. This limit can be adjusted or removed according to your needs.


    '''À noter''' : le nombre de résultats affichés est limité à 100 par défaut afin de ne pas surcharger la requête et d'améliorer la performance d'affichage. Cette limite peut être ajustée ou retirée en fonction de vos besoins.


    ==== > Enriching data on resistance members using external sources [federated query] ==== <!--T:29-->


    ==== > Enrichir les données sur les résistant·e·s à l'aide de sources externes [requête fédérée] ====
    <!--T:30-->
    Federated queries take full advantage of the Linked Open Data principle by combining the local data stored in ''Resistance in Belgium'' with that of Wikidata, thereby enriching our information base. This process is possible as soon as a match has been established between our data and Wikidata. This gives instant access, starting from our records, to additional information such as Wikipedia articles, entries in the National Biography of Belgium, external identifiers (Righteous Among the Nations, ODIS, Maitron, VIAF, SNAC), or the names of institutions holding archives on these persons. This cross-referencing of data, a true bridgework between several sources, offers an enriched and in-depth view, enabling researchers to easily delve into these resources, without having to search for them manually. The example below can be customised to suit your needs.


    Les requêtes fédérées exploitent pleinement le principe des ''Linked Open Data'' (données ouvertes et liées) en combinant les données locales stockées dans ''Resistance in Belgium'' avec celles de Wikidata, permettant ainsi d'enrichir notre base d’informations. Ce procédé est possible dès qu'une correspondance a pu être établie entre nos données et Wikidata. Cela permet d’accéder instantanément, à partir de nos fiches existantes, à des informations complémentaires telles que '''des articles Wikipédia, des notices de la Biographie nationale de Belgique, des identifiants externes (Juste parmi les Nations, ODIS, Maitron, VIAF, SNAC), ou encore des noms d'institutions possédant des archives sur ces personnes'''. Ce croisement de données, véritable passerelle entre plusieurs sources, offre un panorama enrichi et approfondi, permettant aux chercheurs de naviguer facilement entre ces ressources, sans avoir à les rechercher manuellement. L'exemple présenté ci-dessous peut être personnalisé et ajusté à vos besoins.
    <!--T:31-->
    * [https://query.data.arch.be/embed.html#%23%23%20This%20query%20has%20been%20automatically%20translated%20for%20pragmatic%20reasons%20and%20due%20to%20limited%20resources.%20Please%20be%20aware%20that%20some%20terms%20may%20not%20be%20fully%20accurate.%0A%0A%23%20This%20query%20retrieves%20additional%20information%20about%20the%20resistance%20fighters%20in%20the%20database%2C%20thanks%20to%20Wikidata%2C%20including%20Wikipedia%20articles%20and%20external%20archives%20%28ODIS%2C%20Biographie%20Nationale%2C%20VIAF%2C%20SNAC%2C%20etc.%29.%0A%0A%23title%3A%20Enrichment%20of%20resistance%20fighter%20data%20via%20Wikidata%0A%0APREFIX%20wd_wikidata%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%20%20%23%20Prefix%20for%20Wikidata%0APREFIX%20wdt_wikidata%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%20%20%23%20Prefix%20for%20Wikidata%20direct%20properties%0A%0ASELECT%20DISTINCT%20%3Fperson%20%3Fsurname%20%3FfirstName%20%3Fwikidata_ID%20%3Farticle_en%20%3FodisURL%20%3FbioNationaleURL%20%3FJusteURL%20%3FmaitronURL%20%3FviafURL%20%3FsnacURL%20%0A%28GROUP_CONCAT%28DISTINCT%20%3FarchivesLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Farchives%29%20%20%23%20Concatenation%20of%20found%20archives%0A%0AWHERE%20%7B%0A%20%20%3Fperson%20wdt%3AP1%20wd%3AQ2%20.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Selects%20all%20persons%20%28P1%20%3D%20Q2%29%0A%20%20%3Fperson%20%20wdt%3AP3%20%3Fsurname%20.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Retrieves%20the%20surname%20%28P3%29%0A%20%20%3Fperson%20%20wdt%3AP2%20%3FfirstName%20.%20%20%20%20%20%20%20%20%20%20%20%20%23%20Retrieves%20the%20first%20name%20%28P2%29%0A%0A%20%20%3Fperson%20wdt%3AP15%20%3FwikidataIdentifier%20.%20%20%20%23%20Retrieves%20the%20Wikidata%20identifier%20%28P15%29%0A%0A%20%20%23%20Generates%20a%20link%20to%20the%20corresponding%20Wikidata%20entity%0A%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataIdentifier%29%29%20AS%20%3Fwikidata_ID%29%0A%0A%20%20%23%20Federated%20query%20to%20retrieve%20additional%20information%20from%20Wikidata%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%0A%20%20%20%20%23%20Retrieves%20and%20generates%20the%20URLs%20of%20external%20identifiers%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP2372%20%3FodisID.%20%20%23%20Retrieves%20the%20ODIS%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fwww.odis.be%2Flnk%2F%22%2C%20STR%28%3FodisID%29%29%29%20AS%20%3FodisURL%29%20%20%23%20Generates%20the%20ODIS%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP6234%20%3FbioNationaleID.%20%20%23%20Biographie%20Nationale%20of%20Belgium%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Facademieroyale.be%2Ffr%2Fla-biographie-nationale-personnalites-detail%2Fpersonnalites%2F%22%2C%20STR%28%3FbioNationaleID%29%2C%20%22%2FVrai%2F%22%29%29%20AS%20%3FbioNationaleURL%29%20%20%23%20Generates%20the%20Biographie%20Nationale%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP214%20%3FviafID.%20%20%23%20VIAF%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fviaf.org%2Fviaf%2F%22%2C%20STR%28%3FviafID%29%29%29%20AS%20%3FviafURL%29%20%20%23%20Generates%20the%20VIAF%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP3430%20%3FsnacID.%20%20%23%20SNAC%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fsnaccooperative.org%2Fark%3A%2F99166%2F%22%2C%20STR%28%3FsnacID%29%29%29%20AS%20%3FsnacURL%29%20%20%23%20Generates%20the%20SNAC%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP4724%20%3FmaitronID.%20%20%23%20Maitron%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fmaitron.fr%2Fspip.php%3Farticle%22%2C%20STR%28%3FmaitronID%29%29%29%20AS%20%3FmaitronURL%29%20%20%23%20Generates%20the%20Maitron%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP1979%20%3FJusteID.%20%20%23%20Righteous%20Among%20the%20Nations%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fcollections.yadvashem.org%2Fen%2Frighteous%2F%22%2C%20STR%28%3FJusteID%29%29%29%20AS%20%3FJusteURL%29%20%20%23%20Generates%20the%20Righteous%20Among%20the%20Nations%20URL%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Retrieves%20the%20English%20Wikipedia%20article%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Farticle_en%20schema%3Aabout%20%3Fwikidata_ID%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3AinLanguage%20%22en%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E%20.%20%20%23%20English%20Wikipedia%20article%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Retrieves%20archives%20linked%20to%20the%20person%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP485%20%3Farchives.%20%20%23%20Retrieves%20archives%20%28P485%29%0A%20%20%20%20%20%20%3Farchives%20rdfs%3Alabel%20%3FarchivesLabel.%20%20%23%20Retrieves%20archive%20labels%0A%20%20%20%20%20%20FILTER%28LANG%28%3FarchivesLabel%29%20%3D%20%22en%22%29%20%20%23%20Filters%20for%20labels%20in%20English%0A%20%20%20%20%7D%0A%20%20%7D%0A%0A%20%20%23%20Retrieves%20labels%20of%20persons%20in%20the%20defined%20language%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0A%0AGROUP%20BY%20%3Fperson%20%3Fsurname%20%3FfirstName%20%3Fwikidata_ID%20%3Farticle_en%20%3FodisURL%20%3FJusteURL%20%3FbioNationaleURL%20%3FmaitronURL%20%3FviafURL%20%3FsnacURL%0A%0AORDER%20BY%20LCASE%28%3Fsurname%29%20LCASE%28%3FfirstName%29%20%20%23%20Sorts%20results%20by%20surname%2C%20then%20first%20name%20%28case-insensitive%29%0A View results in list format.]
    * [https://query.data.arch.be/index.html#%23%23%20This%20query%20has%20been%20automatically%20translated%20for%20pragmatic%20reasons%20and%20due%20to%20limited%20resources.%20Please%20be%20aware%20that%20some%20terms%20may%20not%20be%20fully%20accurate.%0A%0A%23%20This%20query%20retrieves%20additional%20information%20about%20the%20resistance%20fighters%20in%20the%20database%2C%20thanks%20to%20Wikidata%2C%20including%20Wikipedia%20articles%20and%20external%20archives%20%28ODIS%2C%20Biographie%20Nationale%2C%20VIAF%2C%20SNAC%2C%20etc.%29.%0A%0A%23title%3A%20Enrichment%20of%20resistance%20fighter%20data%20via%20Wikidata%0A%0APREFIX%20wd_wikidata%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%20%20%23%20Prefix%20for%20Wikidata%0APREFIX%20wdt_wikidata%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%20%20%23%20Prefix%20for%20Wikidata%20direct%20properties%0A%0ASELECT%20DISTINCT%20%3Fperson%20%3Fsurname%20%3FfirstName%20%3Fwikidata_ID%20%3Farticle_en%20%3FodisURL%20%3FbioNationaleURL%20%3FJusteURL%20%3FmaitronURL%20%3FviafURL%20%3FsnacURL%20%0A%28GROUP_CONCAT%28DISTINCT%20%3FarchivesLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Farchives%29%20%20%23%20Concatenation%20of%20found%20archives%0A%0AWHERE%20%7B%0A%20%20%3Fperson%20wdt%3AP1%20wd%3AQ2%20.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Selects%20all%20persons%20%28P1%20%3D%20Q2%29%0A%20%20%3Fperson%20%20wdt%3AP3%20%3Fsurname%20.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20Retrieves%20the%20surname%20%28P3%29%0A%20%20%3Fperson%20%20wdt%3AP2%20%3FfirstName%20.%20%20%20%20%20%20%20%20%20%20%20%20%23%20Retrieves%20the%20first%20name%20%28P2%29%0A%0A%20%20%3Fperson%20wdt%3AP15%20%3FwikidataIdentifier%20.%20%20%20%23%20Retrieves%20the%20Wikidata%20identifier%20%28P15%29%0A%0A%20%20%23%20Generates%20a%20link%20to%20the%20corresponding%20Wikidata%20entity%0A%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataIdentifier%29%29%20AS%20%3Fwikidata_ID%29%0A%0A%20%20%23%20Federated%20query%20to%20retrieve%20additional%20information%20from%20Wikidata%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%0A%20%20%20%20%23%20Retrieves%20and%20generates%20the%20URLs%20of%20external%20identifiers%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP2372%20%3FodisID.%20%20%23%20Retrieves%20the%20ODIS%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fwww.odis.be%2Flnk%2F%22%2C%20STR%28%3FodisID%29%29%29%20AS%20%3FodisURL%29%20%20%23%20Generates%20the%20ODIS%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP6234%20%3FbioNationaleID.%20%20%23%20Biographie%20Nationale%20of%20Belgium%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Facademieroyale.be%2Ffr%2Fla-biographie-nationale-personnalites-detail%2Fpersonnalites%2F%22%2C%20STR%28%3FbioNationaleID%29%2C%20%22%2FVrai%2F%22%29%29%20AS%20%3FbioNationaleURL%29%20%20%23%20Generates%20the%20Biographie%20Nationale%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP214%20%3FviafID.%20%20%23%20VIAF%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fviaf.org%2Fviaf%2F%22%2C%20STR%28%3FviafID%29%29%29%20AS%20%3FviafURL%29%20%20%23%20Generates%20the%20VIAF%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP3430%20%3FsnacID.%20%20%23%20SNAC%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fsnaccooperative.org%2Fark%3A%2F99166%2F%22%2C%20STR%28%3FsnacID%29%29%29%20AS%20%3FsnacURL%29%20%20%23%20Generates%20the%20SNAC%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP4724%20%3FmaitronID.%20%20%23%20Maitron%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fmaitron.fr%2Fspip.php%3Farticle%22%2C%20STR%28%3FmaitronID%29%29%29%20AS%20%3FmaitronURL%29%20%20%23%20Generates%20the%20Maitron%20URL%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP1979%20%3FJusteID.%20%20%23%20Righteous%20Among%20the%20Nations%20ID%0A%20%20%20%20%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fcollections.yadvashem.org%2Fen%2Frighteous%2F%22%2C%20STR%28%3FJusteID%29%29%29%20AS%20%3FJusteURL%29%20%20%23%20Generates%20the%20Righteous%20Among%20the%20Nations%20URL%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Retrieves%20the%20English%20Wikipedia%20article%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Farticle_en%20schema%3Aabout%20%3Fwikidata_ID%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3AinLanguage%20%22en%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E%20.%20%20%23%20English%20Wikipedia%20article%0A%20%20%20%20%7D%0A%20%20%20%20%0A%20%20%20%20%23%20Retrieves%20archives%20linked%20to%20the%20person%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fwikidata_ID%20wdt_wikidata%3AP485%20%3Farchives.%20%20%23%20Retrieves%20archives%20%28P485%29%0A%20%20%20%20%20%20%3Farchives%20rdfs%3Alabel%20%3FarchivesLabel.%20%20%23%20Retrieves%20archive%20labels%0A%20%20%20%20%20%20FILTER%28LANG%28%3FarchivesLabel%29%20%3D%20%22en%22%29%20%20%23%20Filters%20for%20labels%20in%20English%0A%20%20%20%20%7D%0A%20%20%7D%0A%0A%20%20%23%20Retrieves%20labels%20of%20persons%20in%20the%20defined%20language%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0A%0AGROUP%20BY%20%3Fperson%20%3Fsurname%20%3FfirstName%20%3Fwikidata_ID%20%3Farticle_en%20%3FodisURL%20%3FJusteURL%20%3FbioNationaleURL%20%3FmaitronURL%20%3FviafURL%20%3FsnacURL%0A%0AORDER%20BY%20LCASE%28%3Fsurname%29%20LCASE%28%3FfirstName%29%20%20%23%20Sorts%20results%20by%20surname%2C%20then%20first%20name%20%28case-insensitive%29%0A Test or modify the query] (once the query has been opened, click on the blue "play" button in the bottom left-hand corner to run it and see the results).


    * [https://tinyurl.com/5c4wxubn Voir les résultats sous forme de liste.]
    <!--T:32-->
    * [https://tinyurl.com/y9kezzkv Tester ou modifier la requête] (une fois la requête ouverte, cliquez sur le bouton bleu "play" en bas à gauche pour lancer l'exécution et voir les résultats).
    '''Please note:''': It is also possible to customise the query to enrich the data with additional content contained on Wikidata, such as photos, dates and places of birth and death, places of detention or awards received.


    '''À noter''' : il est possible également de personnaliser la requête pour enrichir les données à l'aide de contenu additionnel contenu sur Wikidata comme des photos, dates et lieux de naissance et de décès, lieux de détention ou encore distinctions reçues.
    </translate>

    Latest revision as of 19:31, 17 October 2024


    This page presents three levels of in-depth queries for exploring the platform's data: beginner, intermediate and advanced. These queries are based on the SPARQL language, which can be used to query structured databases such as this one. Each query example can be customised to access specific information about the persons listed in the database.

    Please note: By default, the queries display all persons registered, without applying a filter to display only those resistance members officially recognised by the Belgian state. You can customise the filters to suit your needs in each query. This is covered in more detail in the advanced level.

    Soon, you will be able to learn more about SPARQL and how to customise queries by following this tutorial (coming soon).


    In-depth queries - Level: beginner


    This section presents some basic queries for exploring the platform's data. For example, you can search for persons by family name, place of residence or membership in a resistance organisation. These queries do not require any advanced knowledge and will give you a better understanding of the basics of the SPARQL language. To cross-reference more data or retrieve additional information, please consult the section about intermediate or advanced level queries.


    > Search for resistance members by family name

    > Search for members of a resistance organisation


    > Search for resistance members by place of residence

    Hint: If you prefer to explore the data using predefined tables by region of residence, consult this page.


    In-depth queries - Level: intermediate


    This section presents queries for exploring the platform's data more extensively. For example, you can search for members of the Resistance by profession, view the number of members of the various Resistance organisations, or view the places where people died during the war on an interactive map. These queries require a slightly more advanced understanding of the SPARQL language and give you the opportunity to cross-reference several types of data to obtain more detailed information.


    > Search for resistance members by profession

    Please note: The professions are shown as written down in the paper files; they have not yet been standardised or translated. It is therefore advisable to use search terms in both French and Dutch. We are actively working on categorising these professions to make them easier to find, and this update will be available in the next few months.


    > Number of members of a resistance organisation

    Hint: By clicking on the fields containing the names of the organisations in the graph, you can go directly to the organisation's detailed sheet.


    > View places of death during the war

    Hint: By clicking on the dots on the map, you can display the names of the resistance fighters, their dates of death and any additional details.


    In-depth queries - Level: advanced


    Advanced queries let you explore data in depth. You can group results according to several criteria, retrieve more data or enrich local data with information from external sources using federated queries.

    > List the women who have been detained, including their occupation and recognition status if available

    Please note: Some persons may be listed on several consecutive lines if there is more than one value for the dates of detention, profession or status obtained. If necessary, you can adjust the query to group the results; see the [tutorial] to find out more.


    > List the members of the Resistance who have been recognised as ARA/FFC members, or who have received a letter of appreciation, with their place of residence and a reference to the individual archive files

    Please note: The number of results displayed is limited to 100 by default to avoid overloading the query and improve display performance. This limit can be adjusted or removed according to your needs.


    > Enriching data on resistance members using external sources [federated query]

    Federated queries take full advantage of the Linked Open Data principle by combining the local data stored in Resistance in Belgium with that of Wikidata, thereby enriching our information base. This process is possible as soon as a match has been established between our data and Wikidata. This gives instant access, starting from our records, to additional information such as Wikipedia articles, entries in the National Biography of Belgium, external identifiers (Righteous Among the Nations, ODIS, Maitron, VIAF, SNAC), or the names of institutions holding archives on these persons. This cross-referencing of data, a true bridgework between several sources, offers an enriched and in-depth view, enabling researchers to easily delve into these resources, without having to search for them manually. The example below can be customised to suit your needs.

    Please note:: It is also possible to customise the query to enrich the data with additional content contained on Wikidata, such as photos, dates and places of birth and death, places of detention or awards received.

    Retrieved from "https://data.arch.be/w/index.php?title=In-depth_search&oldid=186207"