FactGrid:Sample queries: Difference between revisions

From FactGrid
Jump to navigation Jump to search
(8 intermediate revisions by the same user not shown)
Line 12: Line 12:
== 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%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%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]
 
* [http://tinyurl.com/y99eyox2 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].


== Maps ==
== Maps ==
Line 30: Line 32:
*[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%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 member of the Theocratie du verbe incarnée and connected information]
* [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 13:16, 8 February 2019

How to

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