In-depth search: Difference between revisions

From Resistance in Belgium
No edit summary
No edit summary
 
(9 intermediate revisions by the same user not shown)
Line 2: Line 2:
__TOC__
__TOC__


<translate>


<!--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.
'''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.


<!--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'''.
'''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'''.


To find out more about '''SPARQL''' and learn how to customise queries, see [this tutorial].
<!--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>In-depth queries - Level: beginner</big></span> </div>
<span style="color:#FFFFFF;"><big>In-depth queries - Level: beginner</big></span> </div>
Line 16: Line 21:




==== > Search for resistance fighters by family name ====
==== > Search for resistance members by family name ==== <!--T:5-->


* [https://tinyurl.com/23l82ln6 View results in list format.]
<!--T:6-->
* [https://tinyurl.com/26plvm38 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/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>


==== > Search for members of a resistance organisation ==== <!--T:7-->


==== > Search for members of a resistance organisation ====
<!--T:8-->
* [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).


* [https://tinyurl.com/2avltfy9 View results in list format.]
* [https://tinyurl.com/28pzp9fg 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).


==== > Search for resistance members by place of residence ==== <!--T:9-->


==== > Search for resistance members by place of residence ====
<!--T:10-->
 
* [https://tinyurl.com/26rfpqls View results in list format.]
* [https://tinyurl.com/2djbmear 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).
* [https://tinyurl.com/2ykwatuq 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: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].
'''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>In-depth queries - Level: intermediate</big></span> </div>
<span style="color:#FFFFFF"><big>In-depth queries - Level: intermediate</big></span> </div>
Line 42: Line 51:




==== > Search for resistance members by profession ====
==== > Search for resistance members by profession ==== <!--T:13-->


* [https://tinyurl.com/278gfy9s View results in list format.]
<!--T:14-->
* [https://tinyurl.com/2bhgyjaa 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/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.
'''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 ====
==== > Number of members of a resistance organisation ==== <!--T:16-->


* [https://tinyurl.com/23cyr5dn Voir les résultats sous forme de graphique.]
<!--T:17-->
* [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).
* [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).


'''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: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 ====
==== > View places of death during the war ==== <!--T:19-->


* [https://tinyurl.com/274cwhpj Voir les résultats sous forme de carte interactive.]
<!--T:20-->
* [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).
* [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).


'''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: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.