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

• Name of people who ever were a residents of place with basic personal information. Table

• Two Persons, when and where did they meet timeline
• All people with a FactGrid account by gender

Looking for documents

• Everything authored or written to N.N.

• The correspondence of N.N. with him/her as sender (right) and recipient (left)

• 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

Second mission of the French Prophets, 1 June 1712-1714

The Illuminati correspondence on a map

Dots

• All documents of a specific research interest where from?

• All the ancestors of a person, where were they born?

• All persons of a certain profession in a town (here merchants) / Poets in Paris

Lines

• The second missionary journey of the French Prophets 1712-1714
• The Illuminati correspondence, who wrote whom, from where, whereto
• Arthur Schopenhauer, Places of residence

Tables

• 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

Statistics

Adherents of the French Prophets and their religious affiliations

Age at death of all Human beings (Q7) noted on FactGrid, statistical distribution

• The members of Frankfurt's Union-Lodge, branches of occupation, bubble chart
• Followers of the "French Prophets", gender ratio, bar chart
• Adherents of the French Prophets and their religious affiliation
• Those with a FactGrid account - first languages
• 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.

• Age at death of all human beings listed on FactGrid, diagram

• Age profile for the Strict Observance
• Age profile for the Illuminati

• J.J.C. Bode's Library (1793), profile by date of publication of the copies

Grammatically intricate searches

Wimimedia sources

• all places - with their respective Wikidata numbers

Statements with sources

• Member of the Illuminati, state the primary document reference that we have for this statement

Get information from connected items

• 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.

Search for specific Qualifiers on a Statement

• Authors writing all kind of satires
• Authors writing satire and all its subclasses (you just add /wdt:P3* to pq:P122)
• The people writing all kind of satires (not necessarily authors) (very simple: remove ps:P165 wd:Q23190)

You already know one related value

• all the lodges of Saint Domingue/Haiti the intricate part is, that the lodges only have information on places, the places have information on the territorial affiliation - we ask for Q176240 (Haiti) as the must have value. The bracket can also have more countries.

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)
}

Filters

• Tutorial

• all FactGrid people born between 1700 and 1710 A Filter that selects a time frame
• All members of the strict Observance in Frankfurt's Prefecture A Filter that selects an Item in a qualifying statement

Filter based on strings

Filtering results containing certain strings (texts) can be archieved with `FILTER()`

• Get all item with "CSD" in its labels within the Remove NA Project

SPARQL patterns for reuse

Count properties

Get all properties of an item

SELECT ?p ?o WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  wd:Q406029 ?p ?o
 }

count statements per item within a certain project

or within any other property-object relation

 SELECT DISTINCT ?item ?itemLabel ?statementcount WHERE {
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   # change property item relation
   ?item wdt:P131 wd:Q400012 .
   ?item wikibase:statements ?statementcount.
 }

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