FactGrid:Sample queries: Difference between revisions

From FactGrid
Jump to navigation Jump to search
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
== How to ==
* https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views/en
__TOC__
== People with the same family names ==
* [https://database.factgrid.de/query/#SELECT%20%3FMensch%20%3FMenschLabel%20%3Fvon%20%3Fbis%20%3FMenschDescription%20%3FVater%20%3FVaterLabel%20%3FMutter%20%3FMutterLabel%20%3Fverheiratet_mit%20%3Fverheiratet_mitLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FMensch%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FMensch%20wdt%3AP247%20wd%3AQ26448.%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP290%20%3Fvon.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP291%20%3Fbis.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP141%20%3FVater.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP142%20%3FMutter.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP84%20%3Fverheiratet_mit.%20%7D%0A%7D%0AORDER%20BY%20%3FMenschLabel name, father, mother, marriage] - change the family name to the person you are trying to identify.
* [https://database.factgrid.de/query/#SELECT%20%3FMensch%20%3FMenschLabel%20%3FMenschDescription%20%3FAdresse%20%3FAdresseLabel%20%3FVater%20%3FVaterLabel%20%3FMutter%20%3FMutterLabel%20%3Fverheiratet_mit%20%3Fverheiratet_mitLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FMensch%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FMensch%20wdt%3AP247%20wd%3AQ25777.%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP141%20%3FVater.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP142%20%3FMutter.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP84%20%3Fverheiratet_mit.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP208%20%3FAdresse.%20%7D%0A%7D%0AORDER%20BY%20%3FMenschLabel Family name, address father, mother, marriage] - same with address if you have a wide screen or use a small font.
==Archival searches ==
==Archival searches ==
* [https://database.factgrid.de/query/#SELECT%20%3FDokument%20%3FDokumentLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FDokument%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3FDokument%20wdt%3AP47%20wd%3AQ10658.%0A%7D all documents located in Hamburg's State Archive]
* [https://database.factgrid.de/query/#SELECT%20%3FDokument%20%3FDokumentLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FDokument%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3FDokument%20wdt%3AP47%20wd%3AQ10658.%0A%7D all documents located in Hamburg's State Archive]
Line 6: Line 16:
== Tables ==
== Tables ==
* [https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fitem%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3Fitem%20wdt%3AP95%20wd%3AQ10378.%0A%7D All letters sent from Hannover]
* [https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fitem%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3Fitem%20wdt%3AP95%20wd%3AQ10378.%0A%7D All letters sent from Hannover]
* [https://database.factgrid.de/query/#SELECT%20%3FCostanzo_Marchese_di_Costanzo%20%3FCostanzo_Marchese_di_CostanzoLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FCostanzo_Marchese_di_Costanzo%20wdt%3AP21%20wd%3AQ217.%0A%7D All documents authored by Costanzo Marchese di Costanzo (Q217)]
* [https://database.factgrid.de/query/#SELECT%20%3FFriedrich_Christian_Rudorff%20%3FFriedrich_Christian_RudorffLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FFactGrid_Transkript%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FFriedrich_Christian_Rudorff%20wdt%3AP21%20wd%3AQ969.%0A%20%20OPTIONAL%20%7B%20%3FFriedrich_Christian_Rudorff%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FFriedrich_Christian_Rudorff%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FFriedrich_Christian_Rudorff%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum All documents authored by Friedrich Christian Rudorff, from where sent? when sent? Transcript where available, order by date]
* [https://database.factgrid.de/query/#SELECT%20%3FCostanzo_Marchese_di_Costanzo%20%3FCostanzo_Marchese_di_CostanzoLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FCostanzo_Marchese_di_Costanzo%20wdt%3AP28%20wd%3AQ217.%0A%7D All documents where Costanzo Marchese di Costanzo (Q217) was the first recipient]  
* [https://database.factgrid.de/query/#SELECT%20%3FCostanzo_Marchese_di_Costanzo%20%3FCostanzo_Marchese_di_CostanzoLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FCostanzo_Marchese_di_Costanzo%20wdt%3AP28%20wd%3AQ217.%0A%7D All documents where Costanzo Marchese di Costanzo (Q217) was the first recipient]  
* [https://database.factgrid.de/query/#SELECT%20%3FCostanzo_Marchese_di_Costanzo%20%3FCostanzo_Marchese_di_CostanzoLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FCostanzo_Marchese_di_Costanzo%20wdt%3AP33%20wd%3AQ217.%0A%7D all documents mentioning Costanzo Marchese di Costanzo (Q217)]
* [https://database.factgrid.de/query/#SELECT%20%3FCostanzo_Marchese_di_Costanzo%20%3FCostanzo_Marchese_di_CostanzoLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FCostanzo_Marchese_di_Costanzo%20wdt%3AP33%20wd%3AQ217.%0A%7D all documents mentioning Costanzo Marchese di Costanzo (Q217)]
* [https://database.factgrid.de/query/#SELECT%20%3FIlluminatenorden%20%3FIlluminatenordenLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%0A%20%20%3FIlluminatenorden%20wdt%3AP91%20wd%3AQ10677.%0A%7D was a member of the Illuminati]
* [https://database.factgrid.de/query/#SELECT%20%3Fsigned_a_Revers_for_the_Order_of_the_Illuminati%20%3Fsigned_a_Revers_for_the_Order_of_the_IlluminatiLabel%20%3FGeburtsdatum%20%3FSterbedatum%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fsigned_a_Revers_for_the_Order_of_the_Illuminati%20wdt%3AP91%20wd%3AQ38780.%0A%20%20OPTIONAL%20%7B%20%3Fsigned_a_Revers_for_the_Order_of_the_Illuminati%20wdt%3AP77%20%3FGeburtsdatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fsigned_a_Revers_for_the_Order_of_the_Illuminati%20wdt%3AP38%20%3FSterbedatum.%20%7D%0A%7D was a member of the Illuminati]
* [https://database.factgrid.de/query/#SELECT%20DISTINCT%20%3Flodge%20%3FlodgeLabel%20%3FmasonLabel%0AWHERE%20%7B%0A%20%20%3Fmason%20p%3AP91%20%3Ffm%20.%0A%20%20%3Ffm%20ps%3AP91%20wd%3AQ10539%20.%0A%20%20%3Ffm%20pq%3AP91%20%3Flodge%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3FlodgeLabel was a freemason - of which lodge]
* [https://database.factgrid.de/query/#SELECT%20%3FAufsatz%20%3FAufsatzLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FFactGrid_Transkript%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FAufsatz%20wdt%3AP121%20wd%3AQ10512.%0A%20%20%3FAufsatz%20wdt%3AP97%20wd%3AQ10677.%0A%20%20OPTIONAL%20%7B%20%3FAufsatz%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FAufsatz%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FAufsatz%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D All guided compositions, where written? when? plus links to FactGrid transcripts].
* [https://database.factgrid.de/query/#SELECT%20%3FMensch%20%3FFamiliennameLabel%20%3FMenschLabel%20%3FMenschDescription%20%3FLebensspanne__mindestens__von%20%3FAdresse%20%3FAdresseLabel%20%3FVater%20%3FVaterLabel%20%3FMutter%20%3FMutterLabel%20%3Fverheiratet_mit%20%3Fverheiratet_mitLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FMensch%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FMensch%20wdt%3AP83%20wd%3AQ10279.%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP247%20%3FFamilienname.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP141%20%3FVater.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP142%20%3FMutter.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP84%20%3Fverheiratet_mit.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP208%20%3FAdresse.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP290%20%3FLebensspanne__mindestens__von.%20%7D%0A%7D%0AORDER%20BY%20%3FFamiliennameLabel Gothaer Bürger, Basis-Informationen] Diese Suche mit kleinerer Buchstabengröße durchführen, um Tabelle zu erhalten.


== Maps ==
== Maps ==
Line 23: Line 34:
== Graphs ==
== Graphs ==
*[https://database.factgrid.de/query/#%23defaultView%3AGraph%0ASELECT%20%3FPerson%20%3FPersonLabel%20%3FOrganisation%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FPerson%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FPerson%20wdt%3AP91%20%3FOrganisation.%0A%7D People and organisations]
*[https://database.factgrid.de/query/#%23defaultView%3AGraph%0ASELECT%20%3FPerson%20%3FPersonLabel%20%3FOrganisation%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FPerson%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FPerson%20wdt%3AP91%20%3FOrganisation.%0A%7D People and organisations]
* [https://database.factgrid.de/query/#%23defaultView%3AGraph%0ASELECT%20%3FPerson%20%3FOrganisation%20%3Fdokumentiert%20%3FdokumentiertLabel%20%3FDokumente_ihrer_seiner_Hand%20%3FDokumente_ihrer_seiner_HandLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FPerson%20wdt%3AP91%20wd%3AQ23165.%0A%20%20%3FPerson%20wdt%3AP91%20%3FOrganisation.%0A%20%20OPTIONAL%20%7B%20%3FPerson%20wdt%3AP51%20%3Fdokumentiert.%20%7D%0A%20%20OPTIONAL%20%7B%20%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPerson%20wdt%3AP185%20%3FDokumente_ihrer_seiner_Hand.%20%7D%0A%7D member of the Theocratie du verbe incarnée and connected information]


== Timelines ==
== Timelines ==
*[https://database.factgrid.de/query/#%23defaultView%3ATimeline%0ASELECT%20%3FEreignis%20%3FEreignisLabel%20%3FEndzeitpunkt%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FEreignis%20wdt%3AP2%20wd%3AQ9.%0A%20%20%3FEreignis%20wdt%3AP106%20%3FEndzeitpunkt.%0A%7D%0A events by date]
*[https://database.factgrid.de/query/#%23defaultView%3ATimeline%0ASELECT%20%3FEreignis%20%3FEreignisLabel%20%3FEndzeitpunkt%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FEreignis%20wdt%3AP2%20wd%3AQ9.%0A%20%20%3FEreignis%20wdt%3AP106%20%3FEndzeitpunkt.%0A%20%20%3FEreignis%20wdt%3AP97%20wd%3AQ10677.%0A%7D All Illuminati events by date]/ [http://tinyurl.com/y8zwjosq tinyurl]


== Wishful thinking ==
== Wishful thinking ==
* A map of all places a Person has been, using (also) the information from sender's and receiver's places
* A map of all places a Person has been, using (also) the information from sender's and receiver's places
* [https://phabricator.wikimedia.org/T165473 visualisations quest on phabricator]
* [https://phabricator.wikimedia.org/T165473 visualisations quest on phabricator]

Revision as of 11:40, 20 August 2019

How to

People with the same family names

Archival searches

Tables

Maps

SPARQL query and results for places from which members of the Illuminati had sent letters contained in the FactGrid database, as encoded via place of origin (P95)

Graphs

Timelines

Wishful thinking