FactGrid:Sample queries: Difference between revisions
Jump to navigation
Jump to search
Olaf Simons (talk | contribs) |
Olaf Simons (talk | contribs) |
||
Line 81: | Line 81: | ||
* [https://database.factgrid.de/query/index.html#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FVater%20%3FVaterLabel%20%3FBildung_Vater%20%3FBildung_VaterLabel%20%3FBeruf_Vater%20%3FBeruf_VaterLabel%20%3FMutter%20%3FMutterLabel%20%3FMutters_Vater%20%3FMutters_VaterLabel%20%3FBildung_Mutters_Vater%20%3FBildung_Mutters_VaterLabel%20%3FBeruf_Mutters_Vater%20%3FBeruf_Mutters_VaterLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%3Fitem%20wdt%3AP160%20wd%3AQ23295%3B%0A%20%20%20%20wdt%3AP141%20%3FVater.%0A%20%20%3FVater%20wdt%3AP160%20%3FBildung_Vater%3B%0A%20%20%20%20wdt%3AP165%20%3FBeruf_Vater.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP142%20%3FMutter.%0A%20%20%20%20%20%20%20%20%20%20%20%3FMutter%20wdt%3AP141%20%3FMutters_Vater.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3FMutters_Vater%20wdt%3AP160%20%3FBildung_Mutters_Vater%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP165%20%3FBeruf_Mutters_Vater.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%7D%0A%7D 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. | * [https://database.factgrid.de/query/index.html#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FVater%20%3FVaterLabel%20%3FBildung_Vater%20%3FBildung_VaterLabel%20%3FBeruf_Vater%20%3FBeruf_VaterLabel%20%3FMutter%20%3FMutterLabel%20%3FMutters_Vater%20%3FMutters_VaterLabel%20%3FBildung_Mutters_Vater%20%3FBildung_Mutters_VaterLabel%20%3FBeruf_Mutters_Vater%20%3FBeruf_Mutters_VaterLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%3Fitem%20wdt%3AP160%20wd%3AQ23295%3B%0A%20%20%20%20wdt%3AP141%20%3FVater.%0A%20%20%3FVater%20wdt%3AP160%20%3FBildung_Vater%3B%0A%20%20%20%20wdt%3AP165%20%3FBeruf_Vater.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP142%20%3FMutter.%0A%20%20%20%20%20%20%20%20%20%20%20%3FMutter%20wdt%3AP141%20%3FMutters_Vater.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3FMutters_Vater%20wdt%3AP160%20%3FBildung_Mutters_Vater%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP165%20%3FBeruf_Mutters_Vater.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%7D%0A%7D 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. | ||
* [https://database.factgrid.de/query/#SELECT%20DISTINCT%20%3Flodge%20%3FlodgeLabel%20%3Fbegin%20%3Fend%20%3Fgeo%0AWHERE%0A%7B%0A%20%20%20%20VALUES%20%3Fterritory%20%7Bwd%3AQ176240%7D%0A%20%20%20%20%3Flodge%20wdt%3AP2%20wd%3AQ11211%20.%0A%20%20%20%20%3Flodge%20wdt%3AP83%20%3Fplace%20.%0A%20%20%20%20%3Fplace%20wdt%3AP297%20%3Fterritory%20.%0A%20%20%20%20%3Flodge%20wdt%3AP49%20%3Fbegin.%0A%20%20%20%20%3Flodge%20wdt%3AP49%20%3Fend.%0A%20%20%20%20%3Fplace%20wdt%3AP48%20%3Fgeo%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%0AORDER%20BY%20%3Fbegin 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. | * [https://database.factgrid.de/query/#SELECT%20DISTINCT%20%3Flodge%20%3FlodgeLabel%20%3Fbegin%20%3Fend%20%3Fgeo%0AWHERE%0A%7B%0A%20%20%20%20VALUES%20%3Fterritory%20%7Bwd%3AQ176240%7D%0A%20%20%20%20%3Flodge%20wdt%3AP2%20wd%3AQ11211%20.%0A%20%20%20%20%3Flodge%20wdt%3AP83%20%3Fplace%20.%0A%20%20%20%20%3Fplace%20wdt%3AP297%20%3Fterritory%20.%0A%20%20%20%20%3Flodge%20wdt%3AP49%20%3Fbegin.%0A%20%20%20%20%3Flodge%20wdt%3AP49%20%3Fend.%0A%20%20%20%20%3Fplace%20wdt%3AP48%20%3Fgeo%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%0AORDER%20BY%20%3Fbegin 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 === | === Looking for a statement - give it with all the qualifying statements === |
Revision as of 23:06, 9 May 2022
Help:
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views/en
- https://en.wikibooks.org/wiki/SPARQL/FILTER
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
- 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
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
Timelines
Statistics
- The members of Frankfurt's Union-Lodge, branches of occupation, bubble chart
- 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.
- 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
- 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
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