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. | ||
* [https://database.factgrid.de/query/index.html#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%20FILTER%28%221730-01-01%22%5E%5Exsd%3AdateTime%20%3C%3D%20%3Fbegin%20%26%26%20%3Fbegin%20%3C%20%221830-01-01%22%5E%5Exsd%3AdateTime%29.%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 lodges of Saint Domingue, when founded and dissolved, plus coordinates] The tricky thing is that the Lodges do not have the territory information on their items, it is on the respective places and become the basic filter in this search | |||
=== 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.
- All lodges of Saint Domingue, when founded and dissolved, plus coordinates The tricky thing is that the Lodges do not have the territory information on their items, it is on the respective places and become the basic filter in this search
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