FactGrid:Sample queries

Help:

• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views/en
• https://en.wikibooks.org/wiki/SPARQL/FILTER

Map: all documents of a certain research interest, where from?

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	Personensuche Suche alle Personen mit demselben Familienname, sortiere nach Vornamen und gebe die Informationen über Zeitraum, Vater, Mutter, und Ehe hinzu. Tabelle
Name of people who ever were a residents of place with basic personal information. Table	Nenne alle Personen, die an einem Ort wohnhaft waren, mit biographischer Basisinformation. Tabelle
Two Persons, when and where did they meet? timeline	Zwei Personen, wann und wo sind sie sich begegnet? Zeitleiste
All people with a FactGrid account by gender	All Inhaber(innen) eines FactGrid Kontos nach Geschlecht
Looking for documents All documents written by N.N. with corresponding documents. Table	Dokumentensuche Alle Dokumente verfasst von N.N. mit korrespondierenden Dokumenten. Tabelle
All documents sent to N.N. with corresponding documents. Table	Alle Dokumente an N.N. mit korrespondierenden Dokumenten. Tabelle
All documents mentioning N.N. with corresponding documents. Table	Alle Dokumente, die N.N. erwähnen mit korrespondierenden Dokumenten. Tabelle
All documents of a file listed in sequence. Table	Alle Dokumente einer Akte der Reihenfolge nach. Tabelle
All documents sent from (place) by date. Table	Alle Dokumente mit demselben Absendeort chronologisch. Tabelle
All documents of a specific archive and research interest by date. Table	Alle Dokumente eines bestimmten Archivs und Forschungsinteresses chronologisch. Tabelle
Maps Dots All documents of a specific research interest where from? Map All persons of a certain profession in a town Map Lines The Illuminati correspondence, who wrote whom, from where, whereto	Landkarten Punkte Alle Dokumente eines bestimmten Forschungsinteresses, Ort der Abfassung Landkarte Alle Personen einer Berufsgruppe am Ort Landkarte Linien Die Illuminatenkorrespondenz, wer schrieb wem, von wo nach wo?

Tables

• Mitglied des Concordienordens
• was a member of the Illuminati
• All guided compositions, where written? when? plus links to FactGrid transcripts.

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

• all 18th-century addresses in Gotha (which have already received geo-coordinates)
• when was the Gregorian calendar introduced?

Graphs

• People and organisations

• member of the Theocratie du verbe incarnée and connected information

Timelines

• All Illuminati events by date/ tinyurl
• known membership entry points of Illuminati

Bubble Charts

File:Adherents of the French Prophets and their religious affiliation.JPG

Adherents of the French Prophets and their religious affiliation

• The distribution of males and females who became followers of the early 18th-century "French Prophets"

Adherents of the French Prophets and their religious affiliation

• The Illuminati membership statements The intricate thing is that this search excludes the two 100% bubbles of Illuminati and Freemasons that are of course given with every Illuminati membership.

Grammatically intricate searches

• all places - with their respective Wikidata numbers
• Member of the Illuminati, state the primary document reference that we have for this statement
• The graduates of Gotha's Gymnasium Illustre/Ernestinum: their fathers with career information, their mothers and the fathers of the mothers (i.e. maternal grandfathers) with the respective career information] The search is intricate as it goes into related database objects and brings information located there into the table.

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

• A map of all places a Person has been, using (also) the information from sender's and receiver's places
• visualisations quest on phabricator