FactGrid:Sample queries: Difference between revisions
Olaf Simons (talk | contribs) |
Olaf Simons (talk | contribs) No edit summary |
||
(6 intermediate revisions by the same user not shown) | |||
Line 29: | Line 29: | ||
Zwei Personen, '''wann und wo sind sie sich begegnet'''? | Zwei Personen, '''wann und wo sind sie sich begegnet'''? | ||
[https://database.factgrid.de/query/#%23defaultView%3ATimeline%0ASELECT%20%3FEreignis%20%3FEndzeitpunkt%20%3FEreignisLabel%20%3FStandort%20%3FStandortLabel%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%3FEreignis%20wdt%3AP2%20wd%3AQ9%3B%0A%20%20%20%20wdt%3AP106%20%3FEndzeitpunkt%3B%0A%20%20%20%20wdt%3AP133%20wd%3AQ100000%2C%20wd%3AQ101971.%0A%20%20OPTIONAL%20%7B%20%3FEreignis%20wdt%3AP47%20%3FStandort.%20%7D%0A%7D Zeitleiste] | [https://database.factgrid.de/query/#%23defaultView%3ATimeline%0ASELECT%20%3FEreignis%20%3FEndzeitpunkt%20%3FEreignisLabel%20%3FStandort%20%3FStandortLabel%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%3FEreignis%20wdt%3AP2%20wd%3AQ9%3B%0A%20%20%20%20wdt%3AP106%20%3FEndzeitpunkt%3B%0A%20%20%20%20wdt%3AP133%20wd%3AQ100000%2C%20wd%3AQ101971.%0A%20%20OPTIONAL%20%7B%20%3FEreignis%20wdt%3AP47%20%3FStandort.%20%7D%0A%7D Zeitleiste] | ||
|- | |||
| valign="top"| | |||
* [https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FGeschlechtLabel%20%3FFactGrid_Benutzerseite%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%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP163%20%3FFactGrid_Benutzerseite.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP154%20%3FGeschlecht.%20%7D%0A%7D%0AORDER%20BY%20%3FGeschlecht All people with a FactGrid account by gender] | |||
| valign="top"| | |||
* [https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FGeschlechtLabel%20%3FFactGrid_Benutzerseite%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%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP163%20%3FFactGrid_Benutzerseite.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP154%20%3FGeschlecht.%20%7D%0A%7D%0AORDER%20BY%20%3FGeschlecht All Inhaber(innen) eines FactGrid Kontos nach Geschlecht] | |||
|- | |- | ||
| valign="top"| | | valign="top"| | ||
Line 105: | Line 110: | ||
== Timelines == | == Timelines == | ||
*[https://database.factgrid.de/query/#%23defaultView%3ATimeline%0ASELECT%20%3FEreignis%20%3FEreignisLabel%20%3FEndzeitpunkt%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%3FEreignis%20wdt%3AP2%20wd%3AQ9.%0A%20%20%3FEreignis%20wdt%3AP106%20%3FEndzeitpunkt.%0A%20%20%3FEreignis%20wdt%3AP97%20wd%3AQ10677.%0A%7D All Illuminati events by date]/ [http://tinyurl.com/y8zwjosq tinyurl] | *[https://database.factgrid.de/query/#%23defaultView%3ATimeline%0ASELECT%20%3FEreignis%20%3FEreignisLabel%20%3FEndzeitpunkt%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%3FEreignis%20wdt%3AP2%20wd%3AQ9.%0A%20%20%3FEreignis%20wdt%3AP106%20%3FEndzeitpunkt.%0A%20%20%3FEreignis%20wdt%3AP97%20wd%3AQ10677.%0A%7D All Illuminati events by date]/ [http://tinyurl.com/y8zwjosq tinyurl] | ||
* [https://database.factgrid.de/query/index.html#%23defaultView%3ATimeline%0ASELECT%20%3Fperson%20%3FpersonLabel%20%3FDatum%20%3Fgnd_id%20WHERE%20%7B%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%0A%20%20%3Fperson%20wdt%3AP91%20wd%3AQ10677%20.%20%0A%20%20%3Fperson%20p%3AP91%20%3Fstatement%20.%20%0A%20%20%3Fstatement%20ps%3AP91%20wd%3AQ10677%20.%20%0A%20%20%3Fstatement%20pq%3AP49%20%3FDatum%20.%20%20%20%20%0A%20%20OPTIONAL%20%7B%3Fperson%20wdt%3AP76%20%3Fgnd_id%20.%7D%0A%7D%20%0AORDER%20BY%20%3FDatum%0A known membership entry points of Illuminati] | |||
== Grammatically intricate searches == | == Grammatically intricate searches == | ||
* [https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Flink%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%3Fplace%20wdt%3AP2%20wd%3AQ8.%0A%20%20%3Flink%20schema%3Aabout%20%3Fplace%20%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20.%0A%7D all places - with their respective Wikidata numbers] | * [https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Flink%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%3Fplace%20wdt%3AP2%20wd%3AQ8.%0A%20%20%3Flink%20schema%3Aabout%20%3Fplace%20%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20.%0A%7D all places - with their respective Wikidata numbers] | ||
* [https://database.factgrid.de/query/#%23Content%20of%20a%20reference%20for%20a%20specific%20statement%0A%23%20See%20also%20the%20SPARQL%20manual%0A%23%20https%3A%2F%2Fen.wikibooks.org%2Fwiki%2FSPARQL%2FWIKIDATA_Qualifiers%2C_References_and_Ranks%0A%23%20In%20this%20example%20we%20look%20for%20statements%20which%20assign%20a%20specific%20value%20%28Q38779%29%0A%23%20to%20the%20property%20P91%20and%20then%20look%20for%20references%20of%20that%20property%2C%20specifically%0A%23%20the%20string%20associated%20to%20P51%20for%20the%20reference.%20May%20actually%20bring%20up%20references%0A%23%20for%20other%20P1343%20statements%3B%20uses%20the%20shortened%20expression%20syntax%20with%20brackets.%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Freference%20%3FreferenceLabel%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP91%20%3FpNode.%0A%20%20%3FpNode%20ps%3AP91%20wd%3AQ10677%3B%0A%20%20%20%20prov%3AwasDerivedFrom%20%3Freferences.%0A%20%20%3Freferences%20pr%3AP51%20%3Freference.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Member of the Illuminati, state the primary document reference that we have for this statement] | |||
== Wishful thinking == | == Wishful thinking == | ||
* A map of all places a Person has been, using (also) the information from sender's and receiver's places | * A map of all places a Person has been, using (also) the information from sender's and receiver's places | ||
* [https://phabricator.wikimedia.org/T165473 visualisations quest on phabricator] | * [https://phabricator.wikimedia.org/T165473 visualisations quest on phabricator] |
Revision as of 22:21, 18 April 2020
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 peopleSearch all people of the same family name, sort by given names, state everyone with information about life dates and family details. Table |
PersonensucheSuche 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 |
Looking for documentsAll documents written by N.N. with corresponding documents. Table |
DokumentensucheAlle 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 |
MapsAll documents of a specific research interest where from? Map All persons of a certain profession in a town Map |
LandkartenAlle Dokumente eines bestimmten Forschungsinteresses, Ort der Abfassung Landkarte Alle Personen einer Berufsgruppe am Ort Landkarte |
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
Graphs
Timelines
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
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