FactGrid:Sample queries: Difference between revisions

From FactGrid
Jump to navigation Jump to search
No edit summary
Line 25: Line 25:
* All documents '''mentioning N.N.''' with corresponding documents. [https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%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%3FA_%20wdt%3AP33%20wd%3AQ595.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum Table]
* All documents '''mentioning N.N.''' with corresponding documents. [https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%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%3FA_%20wdt%3AP33%20wd%3AQ595.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum Table]


* All documents '''of a file''' listed in sequence.
* All documents '''of a file''' listed in sequence. [https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FEmpf_nger%20%3FEmpf_ngerLabel%20%3FFactGrid_Transkript%20%3FPosition__in_Abfolge_%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%3FA_%20wdt%3AP8%20wd%3AQ2040.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP101%20%3FPosition__in_Abfolge_.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP28%20%3FEmpf_nger.%20%7D%0A%7D%0AORDER%20BY%20%3FPosition__in_Abfolge_ Table]
[https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FEmpf_nger%20%3FEmpf_ngerLabel%20%3FFactGrid_Transkript%20%3FPosition__in_Abfolge_%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%3FA_%20wdt%3AP8%20wd%3AQ2040.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP101%20%3FPosition__in_Abfolge_.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP28%20%3FEmpf_nger.%20%7D%0A%7D%0AORDER%20BY%20%3FPosition__in_Abfolge_ Table]


* All documents '''sent from (place)''' by date. [https://database.factgrid.de/query/#SELECT%20%3FGotha%20%3FGothaLabel%20%3FGothaDescription%20%3FRezipient%20%3FRezipientLabel%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%3FGotha%20wdt%3AP95%20wd%3AQ10279.%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP28%20%3FRezipient.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%28%3FDatum%29 Table]
* All documents '''sent from (place)''' by date. [https://database.factgrid.de/query/#SELECT%20%3FGotha%20%3FGothaLabel%20%3FGothaDescription%20%3FRezipient%20%3FRezipientLabel%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%3FGotha%20wdt%3AP95%20wd%3AQ10279.%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP28%20%3FRezipient.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%28%3FDatum%29 Table]

Revision as of 20:42, 16 June 2021

Help:



Looking for people

  • Search all people of the same family name, sort by given names, state everyone with information about life dates and family details. Table
  • Name of people who ever were a residents of place with basic personal information. Table

Looking for documents

  • All documents written by N.N. with corresponding documents. Table
  • All documents sent to N.N. with corresponding documents. Table
  • All documents mentioning N.N. with corresponding documents. Table
  • All documents of a file listed in sequence. Table
  • All documents sent from (place) by date. Table
  • All documents of a specific archive and research interest by date. Table

Maps

Dots

All documents of a specific research interest where from? Map

All persons of a certain profession in a town Map

Lines

Linien

Tables

  • no functional query yet, but a first attempt is here, modeled after the "academic tree" graph in Scholia's author aspect

Graphs

Timelines

Bubble Charts

Grammatically intricate searches

Looking for a statement - give it with all the qualifying statements

This search is especially useful if the data model needs to be changed. It searches the database for a particular statement and gives all the instances with the respective qualifying sub-statements:

SELECT * WHERE {
  ?s wdt:P2 wd:Q7.
  ?s p:P266 ?st. # ?s is the the statement node
  ?st ps:P266 ?o. # that simulates the predicate
  ?st ?qualifier ?value. # this is an attribute (a qualifier)
}

Wishful thinking