In-depth search: Difference between revisions

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


<!--T:3-->
<!--T:3-->
To find out more about '''SPARQL''' and learn how to customise queries, see [this tutorial].
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)''.




Line 21: Line 21:




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


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


<!--T:8-->
<!--T:8-->
* [https://tinyurl.com/2avltfy9 View results in list format.]
* [https://tinyurl.com/27kcbgtl 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).
* [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).




Line 38: Line 37:


<!--T:10-->
<!--T:10-->
* [https://tinyurl.com/2djbmear View results in list format.]
* [https://tinyurl.com/26rfpqls View results in list format.]
* [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).
* [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).


<!--T:11-->
<!--T:11-->
Line 55: Line 54:


<!--T:14-->
<!--T:14-->
* [https://tinyurl.com/278gfy9s View results in list format.]
* [https://tinyurl.com/2xnrv3q6 View results in list format.]
* [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/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-->
<!--T:15-->
Line 65: Line 64:


<!--T:17-->
<!--T:17-->
* [https://tinyurl.com/23cyr5dn View results in graph format.]
* [https://tinyurl.com/2bvsgzqz View results in graph format.]
* [https://tinyurl.com/2xvtylt5 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/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-->
<!--T:18-->
Line 75: Line 74:


<!--T:20-->
<!--T:20-->
* [https://tinyurl.com/274cwhpj View results on an interactive map.]
* [https://tinyurl.com/2yge44rz View results on an interactive map.]
* [https://tinyurl.com/26qqo59k 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/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-->
<!--T:21-->
Line 88: Line 87:
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.
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-->
==== > List the women who have been detained, including their occupation and recognition status if available ==== <!--T:23-->


<!--T:24-->
<!--T:24-->
* [https://tinyurl.com/258dynx2 View results in list format.]
* [https://tinyurl.com/2dcxkq3a View results in list format.]
* [https://tinyurl.com/29akrbat 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/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).


<!--T:25-->
<!--T:25-->
Line 98: Line 97:




==== > 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-->
==== > 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-->


<!--T:27-->
<!--T:27-->
* [https://tinyurl.com/26jhhzbs View results in list format.]
* [https://tinyurl.com/29u7ume4 View results in list format.]
* [https://tinyurl.com/2blfxzul 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/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).


<!--T:28-->
<!--T:28-->
Line 112: Line 111:
<!--T:30-->
<!--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.
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.


<!--T:31-->
<!--T:31-->
* [https://tinyurl.com/5c4wxubn View results in list format.]
* [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://tinyurl.com/y9kezzkv 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://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).


<!--T:32-->
<!--T:32-->

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.