CINXE.COM
FactGrid:Sample queries - FactGrid
<!DOCTYPE html> <html class="client-nojs" lang="en" dir="ltr"> <head> <meta charset="UTF-8"/> <title>FactGrid:Sample queries - FactGrid</title> <script>document.documentElement.className="client-js";RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"Z0OdtaToSDO1FQAAyU5KDAAAAQQ","wgCSPNonce":false,"wgCanonicalNamespace":"Project","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":4,"wgPageName":"FactGrid:Sample_queries","wgTitle":"Sample queries","wgCurRevisionId":9760946,"wgRevisionId":9760946,"wgArticleId":10671,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":[],"wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"FactGrid:Sample_queries","wgRelevantArticleId":10671,"wgIsProbablyEditable":false,"wgRelevantPageIsProbablyEditable":false,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgVector2022PreviewPages":[], "wgULSAcceptLanguageList":[],"wgULSCurrentAutonym":"English","wgULSPosition":"personal","wgULSisCompactLinksEnabled":true};RLSTATE={"site.styles":"ready","user.styles":"ready","user":"ready","user.options":"loading","ext.cite.styles":"ready","skins.vector.styles.legacy":"ready","wikibase.client.init":"ready","ext.uls.pt":"ready"};RLPAGEMODULES=["ext.cite.ux-enhancements","site","mediawiki.page.ready","mediawiki.toc","skins.vector.legacy.js","wikibase.ui.entitysearch","ext.uls.compactlinks","ext.uls.interface"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.implement("user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"});});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.cite.styles%7Cext.uls.pt%7Cskins.vector.styles.legacy%7Cwikibase.client.init&only=styles&skin=vector"/> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector"></script> <meta name="generator" content="MediaWiki 1.39.10"/> <meta name="format-detection" content="telephone=no"/> <meta name="viewport" content="width=1000"/> <link rel="icon" href="/favicon.ico"/> <link rel="search" type="application/opensearchdescription+xml" href="/w/opensearch_desc.php" title="FactGrid (en)"/> <link rel="EditURI" type="application/rsd+xml" href="https://database.factgrid.de/w/api.php?action=rsd"/> <link rel="alternate" type="application/atom+xml" title="FactGrid Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"/> </head> <body class="mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-4 ns-subject page-FactGrid_Sample_queries rootpage-FactGrid_Sample_queries skin-vector action-view skin-vector-legacy vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-language-alert-in-sidebar-disabled vector-feature-sticky-header-disabled vector-feature-sticky-header-edit-disabled vector-feature-table-of-contents-disabled vector-feature-visual-enhancement-next-disabled"><div id="mw-page-base" class="noprint"></div> <div id="mw-head-base" class="noprint"></div> <div id="content" class="mw-body" role="main"> <a id="top"></a> <div id="siteNotice"></div> <div class="mw-indicators"> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">FactGrid</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">Sample queries</span></h1> <div id="bodyContent" class="vector-body"> <div id="siteSub" class="noprint">From FactGrid</div> <div id="contentSub"></div> <div id="contentSub2"></div> <div id="jump-to-nav"></div> <a class="mw-jump-link" href="#mw-head">Jump to navigation</a> <a class="mw-jump-link" href="#searchInput">Jump to search</a> <div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="en" dir="ltr"><div class="mw-parser-output"><p><b>Help:</b> </p> <ul><li><a rel="nofollow" class="external free" href="https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views/en">https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views/en</a></li> <li><a rel="nofollow" class="external free" href="https://en.wikibooks.org/wiki/SPARQL/FILTER">https://en.wikibooks.org/wiki/SPARQL/FILTER</a></li></ul> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Screenshot_of_a_Wikibase_SPARQL_query_and_results_for_places_from_which_members_of_the_Illuminati_sent_letters_contained_in_the_FactGrid_database,_with_erroneous_datapoint_removed_after_database_sync.png" class="image"><img alt="" src="https://upload.wikimedia.org/wikipedia/commons/thumb/8/8e/Screenshot_of_a_Wikibase_SPARQL_query_and_results_for_places_from_which_members_of_the_Illuminati_sent_letters_contained_in_the_FactGrid_database%2C_with_erroneous_datapoint_removed_after_database_sync.png/300px-thumbnail.png" decoding="async" width="300" height="224" class="thumbimage" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/8/8e/Screenshot_of_a_Wikibase_SPARQL_query_and_results_for_places_from_which_members_of_the_Illuminati_sent_letters_contained_in_the_FactGrid_database%2C_with_erroneous_datapoint_removed_after_database_sync.png/450px-thumbnail.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/8/8e/Screenshot_of_a_Wikibase_SPARQL_query_and_results_for_places_from_which_members_of_the_Illuminati_sent_letters_contained_in_the_FactGrid_database%2C_with_erroneous_datapoint_removed_after_database_sync.png/600px-thumbnail.png 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Screenshot_of_a_Wikibase_SPARQL_query_and_results_for_places_from_which_members_of_the_Illuminati_sent_letters_contained_in_the_FactGrid_database,_with_erroneous_datapoint_removed_after_database_sync.png" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FOrt%20%3FOrtLabel%20%3FGeokoordinaten%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%3Fitem%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3Fitem%20wdt%3AP95%20%3FOrt.%0A%20%20%3FOrt%20wdt%3AP48%20%3FGeokoordinaten.%0A%20%20%3Fitem%20wdt%3AP97%20wd%3AQ10677.%0A%7D">Map: all documents of a certain research interest, where from?</a></div></div></div> <p><br /> </p> <div id="toc" class="toc" role="navigation" aria-labelledby="mw-toc-heading"><input type="checkbox" role="button" id="toctogglecheckbox" class="toctogglecheckbox" style="display:none" /><div class="toctitle" lang="en" dir="ltr"><h2 id="mw-toc-heading">Contents</h2><span class="toctogglespan"><label class="toctogglelabel" for="toctogglecheckbox"></label></span></div> <ul> <li class="toclevel-1 tocsection-1"><a href="#Looking_for_people"><span class="tocnumber">1</span> <span class="toctext">Looking for people</span></a></li> <li class="toclevel-1 tocsection-2"><a href="#Looking_for_documents"><span class="tocnumber">2</span> <span class="toctext">Looking for documents</span></a></li> <li class="toclevel-1 tocsection-3"><a href="#Looking_for_dates"><span class="tocnumber">3</span> <span class="toctext">Looking for dates</span></a></li> <li class="toclevel-1 tocsection-4"><a href="#Maps"><span class="tocnumber">4</span> <span class="toctext">Maps</span></a> <ul> <li class="toclevel-2 tocsection-5"><a href="#Dots"><span class="tocnumber">4.1</span> <span class="toctext">Dots</span></a></li> <li class="toclevel-2 tocsection-6"><a href="#Lines"><span class="tocnumber">4.2</span> <span class="toctext">Lines</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-7"><a href="#Tables"><span class="tocnumber">5</span> <span class="toctext">Tables</span></a></li> <li class="toclevel-1 tocsection-8"><a href="#Graphs"><span class="tocnumber">6</span> <span class="toctext">Graphs</span></a></li> <li class="toclevel-1 tocsection-9"><a href="#Timelines"><span class="tocnumber">7</span> <span class="toctext">Timelines</span></a></li> <li class="toclevel-1 tocsection-10"><a href="#Statistics"><span class="tocnumber">8</span> <span class="toctext">Statistics</span></a> <ul> <li class="toclevel-2 tocsection-11"><a href="#Prevent_double_listings"><span class="tocnumber">8.1</span> <span class="toctext">Prevent double listings</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-12"><a href="#Grammatically_intricate_searches"><span class="tocnumber">9</span> <span class="toctext">Grammatically intricate searches</span></a> <ul> <li class="toclevel-2 tocsection-13"><a href="#Wikimedia_sources"><span class="tocnumber">9.1</span> <span class="toctext">Wikimedia sources</span></a></li> <li class="toclevel-2 tocsection-14"><a href="#Statements_with_sources"><span class="tocnumber">9.2</span> <span class="toctext">Statements with sources</span></a></li> <li class="toclevel-2 tocsection-15"><a href="#Statements_with_unit_information"><span class="tocnumber">9.3</span> <span class="toctext">Statements with unit information</span></a></li> <li class="toclevel-2 tocsection-16"><a href="#Get_information_from_connected_items"><span class="tocnumber">9.4</span> <span class="toctext">Get information from connected items</span></a></li> <li class="toclevel-2 tocsection-17"><a href="#Search_for_specific_Qualifiers_on_a_Statement"><span class="tocnumber">9.5</span> <span class="toctext">Search for specific Qualifiers on a Statement</span></a></li> <li class="toclevel-2 tocsection-18"><a href="#Search_for_all_the_Qualifiers_on_Statements_with_the_same_property"><span class="tocnumber">9.6</span> <span class="toctext">Search for all the Qualifiers on Statements with the same property</span></a></li> <li class="toclevel-2 tocsection-19"><a href="#You_already_know_one_related_value"><span class="tocnumber">9.7</span> <span class="toctext">You already know one related value</span></a></li> <li class="toclevel-2 tocsection-20"><a href="#Looking_for_a_statement_-_give_it_with_all_the_qualifying_statements"><span class="tocnumber">9.8</span> <span class="toctext">Looking for a statement - give it with all the qualifying statements</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-21"><a href="#Missing_Statements"><span class="tocnumber">10</span> <span class="toctext">Missing Statements</span></a></li> <li class="toclevel-1 tocsection-22"><a href="#Missing_connections"><span class="tocnumber">11</span> <span class="toctext">Missing connections</span></a></li> <li class="toclevel-1 tocsection-23"><a href="#Wildcards"><span class="tocnumber">12</span> <span class="toctext">Wildcards</span></a></li> <li class="toclevel-1 tocsection-24"><a href="#State_all_statements_that_are_made_on_an_item"><span class="tocnumber">13</span> <span class="toctext">State all statements that are made on an item</span></a></li> <li class="toclevel-1 tocsection-25"><a href="#Filters"><span class="tocnumber">14</span> <span class="toctext">Filters</span></a> <ul> <li class="toclevel-2 tocsection-26"><a href="#Filter_based_on_strings"><span class="tocnumber">14.1</span> <span class="toctext">Filter based on strings</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-27"><a href="#SPARQL_patterns_for_reuse"><span class="tocnumber">15</span> <span class="toctext">SPARQL patterns for reuse</span></a> <ul> <li class="toclevel-2 tocsection-28"><a href="#GROUP_CONCAT_Bring_several_values_in_one_cell_(to_avoid_the_repetition_of_lines)"><span class="tocnumber">15.1</span> <span class="toctext">GROUP_CONCAT Bring several values in one cell (to avoid the repetition of lines)</span></a></li> <li class="toclevel-2 tocsection-29"><a href="#Count_properties"><span class="tocnumber">15.2</span> <span class="toctext">Count properties</span></a> <ul> <li class="toclevel-3 tocsection-30"><a href="#Get_all_properties_of_an_item"><span class="tocnumber">15.2.1</span> <span class="toctext">Get all properties of an item</span></a></li> <li class="toclevel-3 tocsection-31"><a href="#count_statements_per_item_within_a_certain_project"><span class="tocnumber">15.2.2</span> <span class="toctext">count statements per item within a certain project</span></a></li> </ul> </li> <li class="toclevel-2 tocsection-32"><a href="#Get_popular_items"><span class="tocnumber">15.3</span> <span class="toctext">Get popular items</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-33"><a href="#Federated_Queries"><span class="tocnumber">16</span> <span class="toctext">Federated Queries</span></a> <ul> <li class="toclevel-2 tocsection-34"><a href="#Get_Factgrid_IDs_that_don't_have_a_Wikidata_QID,_but_can_be_found_in_Wikidata_via_its_Factgrid_ID"><span class="tocnumber">16.1</span> <span class="toctext">Get Factgrid IDs that don't have a Wikidata QID, but can be found in Wikidata via its Factgrid ID</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-35"><a href="#Wishful_thinking"><span class="tocnumber">17</span> <span class="toctext">Wishful thinking</span></a></li> <li class="toclevel-1 tocsection-36"><a href="#Notes"><span class="tocnumber">18</span> <span class="toctext">Notes</span></a></li> </ul> </div> <p><br clear="all" /> </p> <h2><span class="mw-headline" id="Looking_for_people">Looking for people</span></h2> <ul><li>Search all people of the <b>same family name</b>, sort by given names, state everyone with information about life dates and family details. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FMensch%20%3FMenschLabel%20%3FMenschDescription%20%3Fvon_ca%20%3FAdresse%20%3FAdresseLabel%20%3FVater%20%3FVaterLabel%20%3FMutter%20%3FMutterLabel%20%3Fverheiratet_mit%20%3Fverheiratet_mitLabel%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%3FMensch%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FMensch%20wdt%3AP247%20wd%3AQ25777.%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP141%20%3FVater.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP142%20%3FMutter.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP84%20%3Fverheiratet_mit.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP208%20%3FAdresse.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP290%20%3Fvon_ca.%20%7D%0A%7D%0AORDER%20BY%20%3FMenschLabel">Table</a></li></ul> <ul><li>Name of people who ever were <b>residents of a given place</b> with basic personal information. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FMensch%20%3FFamilienname%20%3FFamiliennameLabel%20%3FMenschLabel%20%3FMenschDescription%20%3Fvon_ca%20%3FAdresse%20%3FAdresseLabel%20%3FVater%20%3FVaterLabel%20%3FMutter%20%3FMutterLabel%20%3Fverheiratet_mit%20%3Fverheiratet_mitLabel%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%3FMensch%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FMensch%20wdt%3AP83%20wd%3AQ10279.%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP290%20%3Fvon_ca.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP141%20%3FVater.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP142%20%3FMutter.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP84%20%3Fverheiratet_mit.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP208%20%3FAdresse.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP247%20%3FFamilienname.%20%7D%0A%7D%0AORDER%20BY%20%3FFamiliennameLabel">Table</a></li></ul> <ul><li>Two Persons, <b>when and where did they meet</b> <a rel="nofollow" class="external text" href="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">timeline</a></li> <li><a rel="nofollow" class="external text" href="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</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemAltLabel%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%3Fitem%20wdt%3AP131%20wd%3AQ459500.%0A%7D">search all people of a research project, Labels and Aliases</a></li></ul> <h2><span class="mw-headline" id="Looking_for_documents">Looking for documents</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#SELECT%20%3FAuthor%20%3FAuthorLabel%20%3FRecipient%20%3FRecipientLabel%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FDate%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%3Fitem%20%28wdt%3AP21%7Cwdt%3AP28%29%20wd%3AQ969.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP106%20%3FDate.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP21%20%3FAuthor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP28%20%3FRecipient.%20%7D%0A%7D%0AORDER%20BY%20%28%3FDate%29">Everything authored or written to <b>N.N.</b></a></li></ul> <dl><dd><ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem1%20%3Fitem1Label%20%3FRecipient1%20%3FRecipient1Label%20%3FAuthor2%20%3FAuthor2Label%20%3Fitem2%20%3Fitem2Label%20%3FDate%20%0AWHERE%0A%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%7B%20%3Fitem1%20wdt%3AP21%20wd%3AQ969.%0A%20%20OPTIONAL%20%7B%20%3Fitem1%20wdt%3AP28%20%3FRecipient1.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem1%20wdt%3AP106%20%3FDate.%20%7D%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fitem2%20%20wdt%3AP28%20wd%3AQ969.%0A%20%20%20OPTIONAL%20%7B%20%3Fitem2%20wdt%3AP21%20%3FAuthor2.%20%7D%0A%20%20%20OPTIONAL%20%7B%20%3Fitem2%20wdt%3AP106%20%3FDate.%20%7D%20%7D%0A%7D%0AORDER%20BY%20%3FDate">The correspondence of <b>N.N.</b> with him/her as sender (right) and recipient (left)</a></li></ul></dd></dl> <ul><li>All documents <b>written by N.N.</b> with corresponding documents. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FAntwort_auf%20%3FAntwort_aufLabel%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FFactGrid_Transkript%20%3FAntwort%20%3FAntwortLabel%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%3FA_%20wdt%3AP21%20wd%3AQ969.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP65%20%3FAntwort_auf.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP205%20%3FAntwort.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum">Table</a></li></ul> <ul><li>All documents sent <b>to N.N.</b> with corresponding documents. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%20%3FDatum%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FFactGrid_Transkript%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%3FA_%20wdt%3AP28%20wd%3AQ1308.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum">Table</a></li></ul> <ul><li>All documents <b>mentioning N.N.</b> with corresponding documents. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FFactGrid_Transkript%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%3FA_%20wdt%3AP33%20wd%3AQ595.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum">Table</a></li></ul> <ul><li>All documents <b>of a file</b> listed in sequence. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FA_%20%3FA_Label%20%3FA_Description%20%3FAutor%20%3FAutorLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FEmpf_nger%20%3FEmpf_ngerLabel%20%3FFactGrid_Transkript%20%3FPosition__in_Abfolge_%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%3FA_%20wdt%3AP8%20wd%3AQ2040.%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP101%20%3FPosition__in_Abfolge_.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FA_%20wdt%3AP28%20%3FEmpf_nger.%20%7D%0A%7D%0AORDER%20BY%20%3FPosition__in_Abfolge_">Table</a></li></ul> <ul><li>All documents <b>sent from (place)</b> by date. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FGotha%20%3FGothaLabel%20%3FGothaDescription%20%3FRezipient%20%3FRezipientLabel%20%3FDatum%20%3FFactGrid_Transkript%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%3FGotha%20wdt%3AP95%20wd%3AQ10279.%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP28%20%3FRezipient.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FGotha%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D%0AORDER%20BY%20%28%3FDatum%29">Table</a></li></ul> <ul><li>All documents <b>of a specific archive and research interest</b> by date. <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FDokument%20%3FAutor%20%3FAutorLabel%20%3FDokumentLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%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%3FDokument%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3FDokument%20wdt%3AP47%20wd%3AQ10658.%0A%20%20%3FDokument%20wdt%3AP97%20wd%3AQ10677.%0A%20%20OPTIONAL%20%7B%20%3FDokument%20wdt%3AP21%20%3FAutor.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FDokument%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FDokument%20wdt%3AP106%20%3FDatum.%20%7D%0A%7D%0AORDER%20BY%20%3FDatum">Table</a></li></ul> <h2><span class="mw-headline" id="Looking_for_dates">Looking for dates</span></h2> <p>Dates are still a problem with wikibase. The manual input is very sophisticated. You can set the precision of date and you can define the calendar format. The QuickStatements mass input allows a definition of precision with a defining component on each date (for instance "/9" precision year, "/11" precision day...) but regular searches as formulated with the Query Service's Query Helper do not grab these additional details. A 1650 year input is downloaded as a "1 January 1650" value unless you specifically ask for the precision: </p> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FFruitbearing_Society%20%3FFruitbearing_SocietyLabel%20%3Fdate_of_birth%20%3Fprecision%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%3FFruitbearing_Society%20wdt%3AP91%20wd%3AQ436419.%0A%20%20OPTIONAL%20%7B%20%3FFruitbearing_Society%20p%3AP77%2Fpsv%3AP77%20%5B%20wikibase%3AtimeValue%20%3Fdate_of_birth%3B%20wikibase%3AtimePrecision%20%3Fprecision%20%5D%20%20%20%20%7D%20%20%20%20%20%20%20%20%20%20%0A%7D">All the members of the "Fruchtbringende Gesellschaft" with dates of birth and statement of exactness</a></li></ul> <h2><span class="mw-headline" id="Maps">Maps</span></h2> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Second-Mission-French-Prophets.JPG" class="image"><img alt="" src="/w/images/thumb/3/35/Second-Mission-French-Prophets.JPG/300px-Second-Mission-French-Prophets.JPG" decoding="async" width="300" height="176" class="thumbimage" srcset="/w/images/thumb/3/35/Second-Mission-French-Prophets.JPG/450px-Second-Mission-French-Prophets.JPG 1.5x, /w/images/thumb/3/35/Second-Mission-French-Prophets.JPG/600px-Second-Mission-French-Prophets.JPG 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Second-Mission-French-Prophets.JPG" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fpoint%22%2C%20%22%3Fline%22%2C%20%22%3Frgb%22%5D%7D%0ASELECT%20%0A%20%20%20%20%3Fbegin%20%3Fstay%20%3FstayLabel%20%3Fpoint%20%3Fline%20%3Fvisualisation%20%3Frgb%0AWITH%20%7B%0A%20%20SELECT%20%3Fjourney%20%3Fstay%20%3Fbegin%20%3Fdate%20%3Fpoint%20%3Fpoint_str%20WHERE%20%7B%0A%20%20%20%20VALUES%20%3Fjourney%20%7B%20%0A%20%20%20%20%20%20wd%3AQ257130%0A%20%20%20%20%7D%20.%20%20%0A%20%20%20%3Fjourney%20p%3AP296%20%5Bps%3AP296%20%3Fstay%20%3B%20%28pq%3AP49%20%7C%20pq%3AP50%20%7C%20pq%3AP106%29%20%3Fbegin%5D%20.%20%20%20%0A%20%20%20%3Fstay%20p%3AP48%20%5B%20ps%3AP48%20%3Fpoint%20%3B%20psv%3AP48%20%2F%20wikibase%3AgeoLatitude%20%3Flat%20%3B%20psv%3AP48%20%2F%20wikibase%3AgeoLongitude%20%3Flong%20%5D%20.%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Flong%29%2C%20%27%20%27%2C%20STR%28%3Flat%29%29%20AS%20%3Fpoint_str%29%0A%20%20%7D%0A%20%20ORDER%20BY%20%28%3Fbegin%29%0A%7D%20AS%20%25points%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Fjourney%20%28STRDT%28%20CONCAT%28%27LINESTRING%20%28%27%2C%20GROUP_CONCAT%28%3Fpoint_str%3B%20separator%3D%27%2C%27%29%2C%20%27%29%27%29%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%20%3Frgb%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25points%0A%20%20%20OPTIONAL%20%7B%20%3Fjourney%20p%3AP693%20%5Bpq%3AP697%20%3Fcolor%5D%20.%0A%20%20%20%20%3Fcolor%20wdt%3AP696%20%3Frgb.%20%7D%0A%20%20%7D%20GROUP%20BY%20%3Fjourney%20%3Frgb%0A%7D%20AS%20%25line%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25points%0A%20%20INCLUDE%20%25line%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">Second mission of the French Prophets, 1 June 1712-1714</a></div></div></div> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Illuminati_correspondence,_lines_on_maps.JPG" class="image"><img alt="" src="/w/images/thumb/b/bc/Illuminati_correspondence%2C_lines_on_maps.JPG/300px-Illuminati_correspondence%2C_lines_on_maps.JPG" decoding="async" width="300" height="173" class="thumbimage" srcset="/w/images/thumb/b/bc/Illuminati_correspondence%2C_lines_on_maps.JPG/450px-Illuminati_correspondence%2C_lines_on_maps.JPG 1.5x, /w/images/thumb/b/bc/Illuminati_correspondence%2C_lines_on_maps.JPG/600px-Illuminati_correspondence%2C_lines_on_maps.JPG 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Illuminati_correspondence,_lines_on_maps.JPG" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html?fbclid=IwAR29yqUCMsZsCD4caHaH475VCbMICGUUb8zdjrvQ_jDT87Nj5TQEycLDGqU&fbclid=IwAR1dIHXj94VuVG3w0RAps1QbjwFDoZ2ELfXdK61X1gptkyuR7WUZkkRWHkQ#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ10671%20.%0A%20%20%3Fq%20wdt%3AP97%20wd%3AQ10677%20.%0A%20%20%3Fq%20wdt%3AP95%20%3Forigin%20.%0A%20%20%3Forigin%20wdt%3AP48%20%3FcoordO%20.%0A%20%20%3Forigin%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenode1%20wikibase%3AgeoLongitude%20%3Flon1.%0A%20%20%3Fq%20p%3AP28%2Fpq%3AP29%20%3Fdest%20.%0A%20%20%3Fdest%20wdt%3AP48%20%3FcoordD%20.%0A%20%20%3Fdest%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode2.%20%3Fvaluenode2%20wikibase%3AgeoLatitude%20%3Flat2%20.%20%3Fvaluenode2%20wikibase%3AgeoLongitude%20%3Flon2.%0A%20%20BIND%28geof%3Adistance%28%3FcoordO%2C%20%3FcoordD%29%20AS%20%3Fdist%29.%0A%20%20BIND%28floor%28%3Fdist%2F100%29%20AS%20%3Flayer%29.%0A%20%20BIND%28CONCAT%28%27LINESTRING%20%28%27%2C%20STR%28%3Flon1%29%2C%20%27%20%27%2C%20STR%28%3Flat1%29%2C%20%27%2C%27%2C%20STR%28%3Flon2%29%2C%20%27%20%27%2C%20STR%28%3Flat2%29%2C%20%27%29%27%29%20AS%20%3Fstr%29%20.%0A%20%20BIND%28STRDT%28%3Fstr%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%0A%7D">The Illuminati correspondence on a map</a></div></div></div> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Heinrich_Heine,_Paris.jpg" class="image"><img alt="" src="/w/images/thumb/3/3e/Heinrich_Heine%2C_Paris.jpg/300px-Heinrich_Heine%2C_Paris.jpg" decoding="async" width="300" height="178" class="thumbimage" srcset="/w/images/thumb/3/3e/Heinrich_Heine%2C_Paris.jpg/450px-Heinrich_Heine%2C_Paris.jpg 1.5x, /w/images/thumb/3/3e/Heinrich_Heine%2C_Paris.jpg/600px-Heinrich_Heine%2C_Paris.jpg 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Heinrich_Heine,_Paris.jpg" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fpoint%22%2C%20%22%3Fline%22%5D%7D%0ASELECT%20DISTINCT%0A%3Fviewer%20%3Fsubject%20%3FsubjectLabel%20%3Fperiod%20%3Flocation%20%3FlocationLabel%20%3Fpoint%20%3Fline%20%0AWITH%20%7B%0A%20%20SELECT%20%3Fviewer%20%3Fsubject%20%3Flocation%20%3Ftime%20%3Fperiod%20%3Fpoint%20%3Fpoint_str%20WHERE%20%7B%0A%20%20%20%20VALUES%20%3Fsubject%20%7B%20wd%3AQ365979%20%7D%20.%0A%20%20%20%20%3Fsubject%20p%3AP208%20%3Flocation_statement%20.%0A%20%20%20%20%3Flocation_statement%20ps%3AP208%20%3Flocation%20%3B%20pq%3AP49%20%3Fbt%20%3B%20pq%3AP50%20%3Fet%20.%20%0A%20%23%20%20%20%3Flocation%20wdt%3AP47%20wd%3AQ10441%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20ps%3AP48%20%3Fpoint%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLatitude%20%3Flatitude%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLongitude%20%3Flongitude%20.%0A%20%20%20%20BIND%28STR%28YEAR%28%3Fbt%29%29%20AS%20%3Fbegin_time%29%20%0A%20%20%20%20BIND%28STR%28YEAR%28%3Fet%29%29%20AS%20%3Fend_time%29%0A%20%20%20%20BIND%28CONCAT%28%3Fbegin_time%2C%20%27-%27%2C%3Fend_time%29AS%20%3Fperiod%29%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Flongitude%29%2C%20%27%20%27%2C%20STR%28%3Flatitude%29%29%20AS%20%3Fpoint_str%29%0A%20%20%20%20BIND%28STRAFTER%28STR%28%3Fsubject%29%2C%20STR%28wd%3A%29%29%20AS%20%3FitemId%29%0A%20%20%20%20BIND%28IRI%28CONCAT%28%22https%3A%2F%2Fdatabase.factgrid.de%2Fviewer%2Fitem%2F%22%2C%20%3FitemId%29%29%20AS%20%3Fviewer%29%0A%20%20%7D%0A%20%20ORDER%20BY%20%28%3Fbt%29%0A%7D%20AS%20%25points%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Fsubject%20%28STRDT%28%20CONCAT%28%27LINESTRING%20%28%27%2C%20GROUP_CONCAT%28%3Fpoint_str%3B%20separator%3D%27%2C%27%29%2C%20%27%29%27%29%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25points%0A%20%20%7D%20GROUP%20BY%20%3Fsubject%0A%7D%20AS%20%25line%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25points%0A%20%20INCLUDE%20%25line%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">Heinrich Heine's Parisian addresses</a></div></div></div> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:FactGrid_Screenshot,_kitchen_types_in_layers_on_map.PNG" class="image"><img alt="" src="/w/images/thumb/1/1f/FactGrid_Screenshot%2C_kitchen_types_in_layers_on_map.PNG/300px-FactGrid_Screenshot%2C_kitchen_types_in_layers_on_map.PNG" decoding="async" width="300" height="216" class="thumbimage" srcset="/w/images/thumb/1/1f/FactGrid_Screenshot%2C_kitchen_types_in_layers_on_map.PNG/450px-FactGrid_Screenshot%2C_kitchen_types_in_layers_on_map.PNG 1.5x, /w/images/thumb/1/1f/FactGrid_Screenshot%2C_kitchen_types_in_layers_on_map.PNG/600px-FactGrid_Screenshot%2C_kitchen_types_in_layers_on_map.PNG 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:FactGrid_Screenshot,_kitchen_types_in_layers_on_map.PNG" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%7B%22layer%22%3A%22%3FtypeLabel%22%7D%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fgeo%20%3Ftype%20%3FtypeLabel%20%28SAMPLE%28%3F_image%29%20AS%20%3Fimage%29%20WHERE%20%7B%0A%20%20%3Ftype%20wdt%3AP3%2a%20wd%3AQ648943%20.%0A%20%20%3Fitem%20wdt%3AP575%20%3Ftype%20%3B%0A%20%20%20%20%20%20%20%20wdt%3AP48%20%3Fgeo%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20%28p%3AP575%2Fpq%3AP189%29%20%3F_image.%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fgeo%20%3Ftype%20%3FtypeLabel">Kitchen types in layers on map</a></div></div></div> <h3><span class="mw-headline" id="Dots">Dots</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FOrt%20%3FOrtLabel%20%3FGeokoordinaten%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%3Fitem%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3Fitem%20wdt%3AP95%20%3FOrt.%0A%20%20%3FOrt%20wdt%3AP48%20%3FGeokoordinaten.%0A%20%20%3Fitem%20wdt%3AP97%20wd%3AQ10677.%0A%7D">All documents <b>of a specific research interest where from?</b> </a></li></ul> <ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/ybeonrb8">All the ancestors of a person, where were they born?</a></li></ul> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%0A%23poets%0ASELECT%20%3Fpoet%20%3FpoetLabel%20%3FaddressLabel%20%3Fcoord%20WHERE%20%7B%0A%20%20%3Fpoet%20wdt%3AP2%20wd%3AQ7%3B%0A%20%20%20%20%28wdt%3AP165%2F%28wdt%3AP3%2a%29%29%20wd%3AQ36715%3B%0A%20%20%20%20wdt%3AP208%20%3Faddress.%0A%20%20%3Faddress%20wdt%3AP47%20wd%3AQ10279%3B%0A%20%20%20%20wdt%3AP48%20%3Fcoord.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">All <b>persons of a certain profession in a town</b> (here merchants)</a> / <a rel="nofollow" class="external text" href="https://tinyurl.com/yb2nejbm">Poets in Paris</a> / <a rel="nofollow" class="external text" href="https://kurzelinks.de/l3ih">Authors in Paris in 1834</a> with comments / <a rel="nofollow" class="external text" href="https://kurzelinks.de/chgf">Authors in Paris in 1834 with direct links to the viewer</a> with comments / <a rel="nofollow" class="external text" href="https://kurzelinks.de/q8xe">Scholars and playwrights in Paris in 1834, map with two layers</a> with comments</li></ul> <ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/2fzngjj8">Masonic lodges by systems and obediences, where are they located?</a></li></ul> <ul><li><a rel="nofollow" class="external text" href="https://kurzelinks.de/y2hg">Parisian miniaturists in 1834 (with clusters)</a></li></ul> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#%23defaultView%3AMap%7B%22layer%22%3A%22%3FtypeLabel%22%7D%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fgeo%20%3Ftype%20%3FtypeLabel%20%28SAMPLE%28%3F_image%29%20AS%20%3Fimage%29%20WHERE%20%7B%0A%20%20%3Ftype%20wdt%3AP3%2a%20wd%3AQ648943%20.%0A%20%20%3Fitem%20wdt%3AP575%20%3Ftype%20%3B%0A%20%20%20%20%20%20%20%20wdt%3AP48%20%3Fgeo%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20%28p%3AP575%2Fpq%3AP189%29%20%3F_image.%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fgeo%20%3Ftype%20%3FtypeLabel">kitchen types in layers on a map</a></li></ul> <h3><span class="mw-headline" id="Lines">Lines</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%0A%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fpoint%22%2C%20%22%3Fline%22%5D%7D%0ASELECT%20%0A%20%20%3Ftime%20%3Fbegin_time%20%3FlocationLabel%20%3Fpoint%20%3Fline%20%0AWITH%20%7B%0A%20%20SELECT%20%3Fsubject%20%3Flocation%20%3Ftime%20%3Fbegin_time%20%3Fpoint%20%3Fpoint_str%20WHERE%20%7B%0A%20%20%20%20VALUES%20%3Fsubject%20%7B%20wd%3AQ257130%20%7D%20.%0A%20%20%20%20%3Fsubject%20p%3AP296%20%3Fwork_location_statement%20.%0A%20%20%20%20%3Fwork_location_statement%20ps%3AP296%20%3Flocation%20.%20%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20ps%3AP48%20%3Fpoint%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLatitude%20%3Flatitude%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLongitude%20%3Flongitude%20.%0A%20%20%20%20%3Fwork_location_statement%20pq%3AP106%20%3Ftime%20.%20%0A%20%20%20%20OPTIONAL%20%7B%20%3Fwork_location_statement%20pq%3AP49%20%3Fbegin_time%20%7D%20.%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Flongitude%29%2C%20%27%20%27%2C%20STR%28%3Flatitude%29%29%20AS%20%3Fpoint_str%29%0A%20%20%7D%0A%20%20ORDER%20BY%20%28%3Ftime%29%0A%7D%20AS%20%25points%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Fsubject%20%28STRDT%28%20CONCAT%28%27LINESTRING%20%28%27%2C%20GROUP_CONCAT%28%3Fpoint_str%3B%20separator%3D%27%2C%27%29%2C%20%27%29%27%29%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25points%0A%20%20%7D%20GROUP%20BY%20%3Fsubject%0A%7D%20AS%20%25line%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25points%0A%20%20INCLUDE%20%25line%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">The second missionary journey of the French Prophets 1712-1714</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html?fbclid=IwAR29yqUCMsZsCD4caHaH475VCbMICGUUb8zdjrvQ_jDT87Nj5TQEycLDGqU&fbclid=IwAR1dIHXj94VuVG3w0RAps1QbjwFDoZ2ELfXdK61X1gptkyuR7WUZkkRWHkQ#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ10671%20.%0A%20%20%3Fq%20wdt%3AP97%20wd%3AQ10677%20.%0A%20%20%3Fq%20wdt%3AP95%20%3Forigin%20.%0A%20%20%3Forigin%20wdt%3AP48%20%3FcoordO%20.%0A%20%20%3Forigin%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenode1%20wikibase%3AgeoLongitude%20%3Flon1.%0A%20%20%3Fq%20p%3AP28%2Fpq%3AP29%20%3Fdest%20.%0A%20%20%3Fdest%20wdt%3AP48%20%3FcoordD%20.%0A%20%20%3Fdest%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode2.%20%3Fvaluenode2%20wikibase%3AgeoLatitude%20%3Flat2%20.%20%3Fvaluenode2%20wikibase%3AgeoLongitude%20%3Flon2.%0A%20%20BIND%28geof%3Adistance%28%3FcoordO%2C%20%3FcoordD%29%20AS%20%3Fdist%29.%0A%20%20BIND%28floor%28%3Fdist%2F100%29%20AS%20%3Flayer%29.%0A%20%20BIND%28CONCAT%28%27LINESTRING%20%28%27%2C%20STR%28%3Flon1%29%2C%20%27%20%27%2C%20STR%28%3Flat1%29%2C%20%27%2C%27%2C%20STR%28%3Flon2%29%2C%20%27%20%27%2C%20STR%28%3Flat2%29%2C%20%27%29%27%29%20AS%20%3Fstr%29%20.%0A%20%20BIND%28STRDT%28%3Fstr%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%0A%7D">The Illuminati correspondence, who wrote whom, from where, whereto</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%0A%23%20Workplaces%20of%20society%20portrait%20painter%20Philip%20de%20Laszlo%0A%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fpoint%22%2C%20%22%3Fline%22%5D%7D%0ASELECT%20%0A%20%20%3Ftime%20%3Fend_time%20%3FlocationLabel%20%3Fpoint%20%3Fline%20%0AWITH%20%7B%0A%20%20SELECT%20%3Fsubject%20%3Flocation%20%3Ftime%20%3Fend_time%20%3Fpoint%20%3Fpoint_str%20WHERE%20%7B%0A%20%20%20%20VALUES%20%3Fsubject%20%7B%20wd%3AQ172808%20%7D%20.%0A%20%20%20%20%3Fsubject%20p%3AP83%20%3Fwork_location_statement%20.%0A%20%20%20%20%3Fwork_location_statement%20ps%3AP83%20%3Flocation%20.%20%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20ps%3AP48%20%3Fpoint%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLatitude%20%3Flatitude%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLongitude%20%3Flongitude%20.%0A%20%20%20%20%3Fwork_location_statement%20pq%3AP49%20%3Ftime%20.%20%0A%20%20%20%20OPTIONAL%20%7B%20%3Fwork_location_statement%20pq%3AP50%20%3Fend_time%20%7D%20.%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Flongitude%29%2C%20%27%20%27%2C%20STR%28%3Flatitude%29%29%20AS%20%3Fpoint_str%29%0A%20%20%7D%0A%20%20ORDER%20BY%20%28%3Ftime%29%0A%7D%20AS%20%25points%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Fsubject%20%28STRDT%28%20CONCAT%28%27LINESTRING%20%28%27%2C%20GROUP_CONCAT%28%3Fpoint_str%3B%20separator%3D%27%2C%27%29%2C%20%27%29%27%29%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25points%0A%20%20%7D%20GROUP%20BY%20%3Fsubject%0A%7D%20AS%20%25line%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25points%0A%20%20INCLUDE%20%25line%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">Arthur Schopenhauer, Places of residence</a></li> <li><a rel="nofollow" class="external text" href="https://kurzelinks.de/4p7d">Liszt's homes in Paris</a></li> <li><a rel="nofollow" class="external text" href="https://kurzelinks.de/a5ew">Comte's homes in Paris</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fpoint%22%2C%20%22%3Fline%22%5D%7D%0ASELECT%20DISTINCT%0A%3Fviewer%20%3Fsubject%20%3FsubjectLabel%20%3Fperiod%20%3Flocation%20%3FlocationLabel%20%3Fpoint%20%3Fline%20%0AWITH%20%7B%0A%20%20SELECT%20%3Fviewer%20%3Fsubject%20%3Flocation%20%3Ftime%20%3Fperiod%20%3Fpoint%20%3Fpoint_str%20WHERE%20%7B%0A%20%20%20%20VALUES%20%3Fsubject%20%7B%20wd%3AQ380472%20%7D%20.%0A%20%20%20%20%3Fsubject%20p%3AP208%20%3Flocation_statement%20.%0A%20%20%20%20%3Flocation_statement%20ps%3AP208%20%3Flocation%20%3B%20pq%3AP49%20%3Fbt%20%3B%20pq%3AP50%20%3Fet%20.%20%0A%20%20%20%20%3Flocation%20wdt%3AP47%20wd%3AQ10441%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20ps%3AP48%20%3Fpoint%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLatitude%20%3Flatitude%20.%0A%20%20%20%20%3Flocation%20p%3AP48%20%2F%20psv%3AP48%20%2F%20wikibase%3AgeoLongitude%20%3Flongitude%20.%0A%20%20%20%20BIND%28STR%28YEAR%28%3Fbt%29%29%20AS%20%3Fbegin_time%29%20%0A%20%20%20%20BIND%28STR%28YEAR%28%3Fet%29%29%20AS%20%3Fend_time%29%0A%20%20%20%20BIND%28CONCAT%28%3Fbegin_time%2C%20%27-%27%2C%3Fend_time%29AS%20%3Fperiod%29%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Flongitude%29%2C%20%27%20%27%2C%20STR%28%3Flatitude%29%29%20AS%20%3Fpoint_str%29%0A%20%20%20%20BIND%28STRAFTER%28STR%28%3Fsubject%29%2C%20STR%28wd%3A%29%29%20AS%20%3FitemId%29%0A%20%20%20%20BIND%28IRI%28CONCAT%28%22https%3A%2F%2Fdatabase.factgrid.de%2Fviewer%2Fitem%2F%22%2C%20%3FitemId%29%29%20AS%20%3Fviewer%29%0A%20%20%7D%0A%20%20ORDER%20BY%20%28%3Fbt%29%0A%7D%20AS%20%25points%0A%0AWITH%20%7B%0A%20%20SELECT%20%3Fsubject%20%28STRDT%28%20CONCAT%28%27LINESTRING%20%28%27%2C%20GROUP_CONCAT%28%3Fpoint_str%3B%20separator%3D%27%2C%27%29%2C%20%27%29%27%29%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25points%0A%20%20%7D%20GROUP%20BY%20%3Fsubject%0A%7D%20AS%20%25line%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25points%0A%20%20INCLUDE%20%25line%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">Chopin's homes in Paris</a></li></ul> <h2><span class="mw-headline" id="Tables">Tables</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fmember%20%3FnameLabel%20%3FmemberLabel%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%3Fmember%20wdt%3AP91%20wd%3AQ10677.%0A%20%20OPTIONAL%20%7B%20%3Fmember%20wdt%3AP247%20%3Fname.%20%7D%0A%7D%0AORDER%20BY%20%3FnameLabel">Was a member of the Illuminati</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FAufsatz%20%3FAufsatzLabel%20%3FAbsendeort%20%3FAbsendeortLabel%20%3FDatum%20%3FFactGrid_Transkript%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%3FAufsatz%20wdt%3AP121%20wd%3AQ10512.%0A%20%20%3FAufsatz%20wdt%3AP97%20wd%3AQ10677.%0A%20%20OPTIONAL%20%7B%20%3FAufsatz%20wdt%3AP95%20%3FAbsendeort.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FAufsatz%20wdt%3AP106%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FAufsatz%20wdt%3AP251%20%3FFactGrid_Transkript.%20%7D%0A%7D">All guided compositions, where written? when? plus links to FactGrid transcripts</a>.</li></ul> <ul><li>no functional query yet, but a first attempt is <a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AGraph%0A%23%20Doctoral%20student%2Fadvisor%20network%20with%20a%20source%20from%20a%20spectific%20researcher%0APREFIX%20gas%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%2Fgas%23%3E%0A%0ASELECT%20DISTINCT%20%3Fstudent1%20%3Fstudent1Label%20%3Fsupervisor1%20%3Fsupervisor1Label%0AWHERE%20%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fstudent1%20%3Fsupervisor1%20%28MIN%28%3Fdepth1%29%20as%20%3Fdepth%29%0A%20%20%20%20WHERE%20%7B%0A%20%20%20%20%20%20SERVICE%20gas%3Aservice%20%7B%0A%20%20%20%20%20%20%20%20gas%3Aprogram%20gas%3AgasClass%20%22com.bigdata.rdf.graph.analytics.BFS%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Ain%20wd%3AQ8673%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AtraversalDirection%20%22Forward%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout%20%3Fstudent1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout1%20%3Fdepth1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout2%20%3Fsupervisor1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AlinkType%20wdt%3AP95%20%3B%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fstudent1%20%3Fsupervisor1%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fstudent1%20%3Fsupervisor1%20%28MIN%28%3Fdepth1%29%20as%20%3Fdepth%29%0A%20%20%20%20WHERE%20%7B%0A%20%20%20%20%20%20service%20gas%3Aservice%20%7B%0A%20%20%20%20%20%20%20%20gas%3Aprogram%20gas%3AgasClass%20%22com.bigdata.rdf.graph.analytics.BFS%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Ain%20wd%3AQ8673%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AtraversalDirection%20%22Forward%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout%20%3Fsupervisor1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout1%20%3Fdepth1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout2%20%3Fstudent1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AlinkType%20pq%3AP29%20%3B%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fstudent1%20%3Fsupervisor1%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fstudent1%20%3Fsupervisor1%20%28MIN%28%3Fdepth1%29%20as%20%3Fdepth%29%0A%20%20%20%20WHERE%20%7B%0A%20%20%20%20%20%20SERVICE%20gas%3Aservice%20%7B%0A%20%20%20%20%20%20%20%20gas%3Aprogram%20gas%3AgasClass%20%22com.bigdata.rdf.graph.analytics.BFS%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Ain%20wd%3AQ8673%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AtraversalDirection%20%22Reverse%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout%20%3Fstudent1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout1%20%3Fdepth1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout2%20%3Fsupervisor1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AlinkType%20pq%3AP29%20%3B%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fstudent1%20%3Fsupervisor1%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fstudent1%20%3Fsupervisor1%20%28MIN%28%3Fdepth1%29%20as%20%3Fdepth%29%0A%20%20%20%20WHERE%20%7B%0A%20%20%20%20%20%20SERVICE%20gas%3Aservice%20%7B%0A%20%20%20%20%20%20%20%20gas%3Aprogram%20gas%3AgasClass%20%22com.bigdata.rdf.graph.analytics.BFS%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Ain%20wd%3AQ8673%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AtraversalDirection%20%22Reverse%22%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout%20%3Fsupervisor1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout1%20%3Fdepth1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3Aout2%20%3Fstudent1%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20gas%3AlinkType%20wdt%3AP95%20%3B%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fstudent1%20%3Fsupervisor1%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cda%2Csv%2Cjp%2Czh%2Cru%2Cfr%2Cde%22%20.%20%20%7D%0A%7D%0A">here</a>, modelled after the "academic tree" graph in Scholia's author aspect</li></ul> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FGeokoordinaten%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%3Fitem%20wdt%3AP2%20wd%3AQ16200.%0A%20%20%3Fitem%20wdt%3AP48%20%3FGeokoordinaten.%0A%20%20%3Fitem%20wdt%3AP47%20wd%3AQ10279.%0A%7D">all 18th-century addresses in Gotha (which have already received geo-coordinates)</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#SELECT%20%3Fterritorium%20%3FterritoriumLabel%20%3Fab%20WHERE%0A%7B%0A%20%20%20%20%20wd%3AQ220486%20p%3AP360%20%3Fstatement.%0A%20%20%20%20%20%3Fstatement%20ps%3AP360%20%3Fterritorium.%0A%20%20%20%20%20%3Fstatement%20pq%3AP49%20%3Fab.%0A%20%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fab">when was the Gregorian calendar introduced?</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3FSystem%20%3FSystemLabel%20%3FBegin%20%3FEnd%20%3FCause%20%3FNote%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%3AP521%20%3FSystem%3B%0A%20%20%20%20%20%20p%3AP521%20%3Fstatement.%0A%20%20%3Fstatement%20ps%3AP521%20%3FSystem.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP49%20%3FBegin.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP50%20%3FEnd.%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%7D">Lodges and their rites, how to get the qualifiers</a></li></ul> <h2><span class="mw-headline" id="Graphs">Graphs</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AGraph%0ASELECT%20%3FPerson%20%3FPersonLabel%20%3FOrganisation%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%3FPerson%20wdt%3AP2%20wd%3AQ7.%0A%20%20%3FPerson%20wdt%3AP91%20%3FOrganisation.%0A%7D">People and organisations</a></li></ul> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3AGraph%0ASELECT%20%3FPerson%20%3FOrganisation%20%3Fdokumentiert%20%3FdokumentiertLabel%20%3FDokumente_ihrer_seiner_Hand%20%3FDokumente_ihrer_seiner_HandLabel%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%3FPerson%20wdt%3AP91%20wd%3AQ23165.%0A%20%20%3FPerson%20wdt%3AP91%20%3FOrganisation.%0A%20%20OPTIONAL%20%7B%20%3FPerson%20wdt%3AP51%20%3Fdokumentiert.%20%7D%0A%20%20OPTIONAL%20%7B%20%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPerson%20wdt%3AP185%20%3FDokumente_ihrer_seiner_Hand.%20%7D%0A%7D">member of the Theocratie du verbe incarnée and connected information</a></li></ul> <h2><span class="mw-headline" id="Timelines">Timelines</span></h2> <ul><li><a rel="nofollow" class="external text" href="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</a>/ <a rel="nofollow" class="external text" href="http://tinyurl.com/y8zwjosq">tinyurl</a></li> <li><a rel="nofollow" class="external text" href="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</a></li></ul> <h2><span class="mw-headline" id="Statistics">Statistics</span></h2> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG" class="image"><img alt="" src="/w/images/thumb/e/ec/Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG/300px-Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG" decoding="async" width="300" height="260" class="thumbimage" srcset="/w/images/thumb/e/ec/Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG/450px-Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG 1.5x, /w/images/thumb/e/ec/Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG/600px-Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Adherents_of_the_French_Prophets_and_their_religious_affiliations.JPG" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://tinyurl.com/yglpoqzq">Adherents of the French Prophets and their religious affiliations</a></div></div></div> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Age_at_death_of_all_FacGrid_humans.JPG" class="image"><img alt="" src="/w/images/thumb/f/f4/Age_at_death_of_all_FacGrid_humans.JPG/300px-Age_at_death_of_all_FacGrid_humans.JPG" decoding="async" width="300" height="141" class="thumbimage" srcset="/w/images/thumb/f/f4/Age_at_death_of_all_FacGrid_humans.JPG/450px-Age_at_death_of_all_FacGrid_humans.JPG 1.5x, /w/images/thumb/f/f4/Age_at_death_of_all_FacGrid_humans.JPG/600px-Age_at_death_of_all_FacGrid_humans.JPG 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Age_at_death_of_all_FacGrid_humans.JPG" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://tinyurl.com/yhzquxwf">Age at death of all Human beings (Q7) noted on FactGrid, statistical distribution</a></div></div></div> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Bar_chart,_historical_book_production.png" class="image"><img alt="" src="https://upload.wikimedia.org/wikipedia/commons/thumb/3/3b/Bar_chart%2C_historical_book_production.png/300px-Bar_chart%2C_historical_book_production.png" decoding="async" width="300" height="159" class="thumbimage" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/3/3b/Bar_chart%2C_historical_book_production.png/450px-Bar_chart%2C_historical_book_production.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/3/3b/Bar_chart%2C_historical_book_production.png/600px-Bar_chart%2C_historical_book_production.png 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Bar_chart,_historical_book_production.png" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3ABarChart%0ASELECT%20%3Fitem%20%3Fcountry%20%3Fdecade%20%20%28COUNT%28%3Fitem%29%20as%20%3Fproduction%29%20%3FcountryLabel%0AWITH%0A%7B%0A%20%20%20%20SELECT%20%3Fitem%20%3Fdecade%20%3Fplace%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP2%20wd%3AQ394362%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP243%20wd%3AQ172203%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP222%20%3Fdate%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP241%20%3Fplace%20.%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20BIND%28YEAR%28%3Fdate%29%20AS%20%3Fyear%29%0A%20%20%20%20%20%20%20%20%20%20BIND%28STR%28xsd%3Ainteger%28%3Fyear%2F10%29%2a10%29%20as%20%3Fdecade%29%0A%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20GROUP%20BY%20%20%3Fitem%20%3Fdecade%20%3Fplace%0A%7D%20AS%20%25results%0AWHERE%0A%7B%0A%20%20%20%20INCLUDE%20%25results.%0A%20%20%20%20%20%3Fplace%20wdt%3AP297%20%3Fcountry%20.%0A%20%20%20%20%20%3Fcountry%20wdt%3AP2%20wd%3AQ21925%20.%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fdecade%20%3Fcountry%20%3FcountryLabel%20%3Fitem">Bar chart of books on Mesmerism Country</a></div></div></div> <div class="thumb tright"><div class="thumbinner" style="width:302px;"><a href="/wiki/File:Screenshot_area_chart.png" class="image"><img alt="" src="https://upload.wikimedia.org/wikipedia/commons/thumb/c/cb/Screenshot_area_chart.png/300px-Screenshot_area_chart.png" decoding="async" width="300" height="146" class="thumbimage" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/c/cb/Screenshot_area_chart.png/450px-Screenshot_area_chart.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/c/cb/Screenshot_area_chart.png/600px-Screenshot_area_chart.png 2x" /></a> <div class="thumbcaption"><div class="magnify"><a href="/wiki/File:Screenshot_area_chart.png" class="internal" title="Enlarge"></a></div><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#%23defaultView%3AAreaChart%0ASELECT%20%3Fitem%20%3Fcountry%20%3Fdecade%20%20(COUNT(%3Fitem)%20as%20%3Fproduction)%20%3FcountryLabel%0AWITH%0A%7B%0A%20%20%20%20SELECT%20%3Fitem%20%3Fdecade%20%3Fplace%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP2%20wd%3AQ394362%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP243%20wd%3AQ172203%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP222%20%3Fdate%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP241%20%3Fplace%20.%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20BIND(YEAR(%3Fdate)%20AS%20%3Fyear)%0A%20%20%20%20%20%20%20%20%20%20BIND(STR(ROUND(%3Fyear%2F10)*10)%20as%20%3Fdecade)%0A%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20GROUP%20BY%20%20%3Fitem%20%3Fdecade%20%3Fplace%0A%7D%20AS%20%25results%0AWHERE%0A%7B%0A%20%20%20%20INCLUDE%20%25results.%0A%20%20%20%20%20%3Fplace%20wdt%3AP297%20%3Fcountry%20.%0A%20%20%20%20%20%3Fcountry%20wdt%3AP2%20wd%3AQ21925%20.%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fdecade%20%3Fcountry%20%3FcountryLabel%20%3Fitem">Area chart of a books on Mesmerism by language</a></div></div></div> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FSectorLabel%20(count(distinct(%3FA))%20as%20%3Fcount)%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FSector%20%3FSectorLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ11161.%0A%20%20%20%20%3FA%20wdt%3AP165%20%3FOccupation.%20%0A%20%20%20%20%3FOccupation%20wdt%3AP626%20%3FSector.%0A%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FSectorLabel">The members of Frankfurt's Union-Lodge, branches of occupation, bubble chart</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3ABarChart%0ASELECT%20%3FGenderLabel%20%28count%28distinct%28%3FA%29%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FGender%20%3FGenderLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP300%20wd%3AQ255080.%0A%20%20%20%20%3FA%20wdt%3AP154%20%3FGender.%20%0A%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FGenderLabel">Followers of the "French Prophets", gender ratio, bar chart</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FReligionLabel%20%28count%28distinct%28%3FA%29%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FReligion%20%3FReligionLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP300%20wd%3AQ255080.%0A%20%20%20%20OPTIONAL%20%7B%20%3FA%20%28p%3AP300%2Fpq%3AP49%29%20%3FEntry.%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%3FA%20wdt%3AP247%20%3Ffamily_name.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP172%20%3FReligion.%20%0A%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FReligionLabel">Adherents of the French Prophets and their religious affiliation</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FSpracheLabel%20%28count%28distinct%28%3Fitem%29%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FFamiliennameLabel%20%3FitemDescription%20%3FGeschlechtLabel%20%3FSpracheLabel%20%3FFactGrid_Benutzerseite%20%3FDate%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%20%28p%3AP163%2Fpq%3AP49%29%20%3FDate.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP154%20%3FGeschlecht.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP247%20%3FFamilienname.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP460%20%3FSprache.%20%7D%0A%7D%0AORDER%20BY%20%28%3FFamiliennameLabel%29%0A%20%20%0A%20%20%20%20%7D%20group%20by%20%3FSpracheLabel">Those with a FactGrid account - first languages</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FMembershipLabel%20%28count%28distinct%28%3FA%29%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FMembership%20%3FMembershipLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ10677.%0A%20%20%20%20OPTIONAL%20%7B%20%3FA%20%28p%3AP91%2Fpq%3AP49%29%20%3FEntry.%20%7D%0A%20%20%20%20OPTIONAL%20%7B%20%3FA%20wdt%3AP247%20%3Ffamily_name.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20%3FMembership.%20%0A%20%20%20%20minus%20%7B%0A%20%20%20%20%20%20values%20%3FMembership%20%7B%0A%20%20%20%20%20%20%20%20wd%3AQ10678%20%0A%20%20%20%20%20%20%20%20wd%3AQ10677%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FMembershipLabel">The Illuminati membership statements</a> 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.</li></ul> <ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/yhzquxwf">Age at death of all human beings listed on FactGrid, diagram</a><sup id="cite_ref-1" class="reference"><a href="#cite_note-1">[1]</a></sup></li></ul> <dl><dd><ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/2xzmdxw9">Age profile for the Strict Observance</a></li> <li><a rel="nofollow" class="external text" href="https://tinyurl.com/2bf5w5ec">Age profile for the Illuminati</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#SELECT%20%3FPerson%20%3FPersonLabel%20%3FDatum%20%3FGebDat%20%3Fage%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%3FPerson%20wdt%3AP91%20wd%3AQ10677%3B%0A%20%20%20%20wdt%3AP91%20wd%3AQ10677%3B%0A%20%20%20%20p%3AP91%20%3Fstatement.%0A%20%20%3Fstatement%20ps%3AP91%20wd%3AQ10677.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP49%20%3FDatum.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPerson%20wdt%3AP77%20%3FGebDat.%20%7D%0A%20%20%20%20%20%20%20%20BIND%28%20year%28%3FDatum%29%20-%20year%28%3FGebDat%29%20-%20if%28month%28%3FDatum%29%3Cmonth%28%3FGebDat%29%20%7C%7C%20%28month%28%3FDatum%29%3Dmonth%28%3FGebDat%29%20%26%26%20day%28%3FDatum%29%3Cday%28%3FGebDat%29%29%2C1%2C0%29%20as%20%3Fage%20%29%0A%20%20%20%20%20%20%20%20%23%20calculate%20the%20age%2C%20precisely%20to%20the%20day%20%28times%20and%20timezones%20ignored%29%0A%7D%0AORDER%20BY%20%28%3FDatum%29">How old was the person when he became a member of the Illuminati?</a></li></ul></dd></dl> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23defaultView%3ALineChart%0ASELECT%20%3Fdate%20%20%28COUNT%20%28DISTINCT%20%3Fa%29%20AS%20%3Fcount%29%20%0AWHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fa%20wdt%3AP2%20wd%3AQ20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP136%20wd%3AQ400628%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP222%20%3Fdate%20.%0A%20%20%20%20%20%20%20%20%20%20%20FILTER%20%28%20YEAR%28%3Fdate%29%20%3E%201700%20%29%0A%7D%0A%20GROUP%20BY%20%0A%3Fdate%0A%0A">J.J.C. Bode's Library (1793), profile by date of publication of the copies</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#%23defaultView%3ABarChart%0ASELECT%20%3Fitem%20%3Fcountry%20%3Fdecade%20%20(COUNT(%3Fitem)%20as%20%3Fproduction)%20%3FcountryLabel%0AWITH%0A%7B%0A%20%20%20%20SELECT%20%3Fitem%20%3Fdecade%20%3Fplace%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP2%20wd%3AQ394362%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP243%20wd%3AQ172203%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP222%20%3Fdate%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP241%20%3Fplace%20.%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20BIND(YEAR(%3Fdate)%20AS%20%3Fyear)%0A%20%20%20%20%20%20%20%20%20%20BIND(STR(ROUND(%3Fyear%2F10)*10)%20as%20%3Fdecade)%0A%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20GROUP%20BY%20%20%3Fitem%20%3Fdecade%20%3Fplace%0A%7D%20AS%20%25results%0AWHERE%0A%7B%0A%20%20%20%20INCLUDE%20%25results.%0A%20%20%20%20%20%3Fplace%20wdt%3AP297%20%3Fcountry%20.%0A%20%20%20%20%20%3Fcountry%20wdt%3AP2%20wd%3AQ21925%20.%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fdecade%20%3Fcountry%20%3FcountryLabel%20%3Fitem">Bar chart of a historical book production by decade, script by Bruno Belhoste, books on Mesmerism by language</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#%23defaultView%3AAreaChart%0ASELECT%20%3Fitem%20%3Fcountry%20%3Fdecade%20%20(COUNT(%3Fitem)%20as%20%3Fproduction)%20%3FcountryLabel%0AWITH%0A%7B%0A%20%20%20%20SELECT%20%3Fitem%20%3Fdecade%20%3Fplace%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP2%20wd%3AQ394362%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP243%20wd%3AQ172203%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP222%20%3Fdate%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP241%20%3Fplace%20.%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20BIND(YEAR(%3Fdate)%20AS%20%3Fyear)%0A%20%20%20%20%20%20%20%20%20%20BIND(STR(ROUND(%3Fyear%2F10)*10)%20as%20%3Fdecade)%0A%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20GROUP%20BY%20%20%3Fitem%20%3Fdecade%20%3Fplace%0A%7D%20AS%20%25results%0AWHERE%0A%7B%0A%20%20%20%20INCLUDE%20%25results.%0A%20%20%20%20%20%3Fplace%20wdt%3AP297%20%3Fcountry%20.%0A%20%20%20%20%20%3Fcountry%20wdt%3AP2%20wd%3AQ21925%20.%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fdecade%20%3Fcountry%20%3FcountryLabel%20%3Fitem">Area chart of a historical book production by decade, script by Bruno Belhoste, books on Mesmerism by language</a></li> <li class="mw-empty-elt"></li></ul> <p><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23defaultView%3ABubbleChart%0ASELECT%20%3FpositionLabel%20%28COUNT%28%3Fitem%29%20AS%20%3Fcount%29%20%0AWHERE%20%0A%7B%20%3Fitem%20wdt%3AP2%20wd%3AQ20%3B%0A%20%20%20%20%20%20%20%20wdt%3AP243%20wd%3AQ172203%3B%0A%20%20%20%20%20%20%20%20wdt%3AP222%20%3Fdate%20.%0A%20OPTIONAL%20%7B%20%3Fitem%20%20%20p%3AP243%5Bpq%3AP823%20%3Fposition%5D%20%7D%20.%0A%20BIND%28COALESCE%28%3FpositionLabel%2C%20%22Indifferent%22%29%20AS%20%3FpositionLabel%29%0A%20BIND%28YEAR%28%3Fdate%29%20AS%20%3Fyear%29%20%0A%20FILTER%20%28%3Fyear%20%3E%3D1784%20%26%26%20%3Fyear%20%3C%3D%201785%20%29%20%23les%20bornes%20temporelles%20%28ici%201784%20et%201785%29%20peuvent%20%C3%AAtre%20modifi%C3%A9es%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%7D%0A%20GROUP%20BY%20%3FpositionLabel%0A">Bubble chart of books on animal magnetism in 1784-1785, pro, contra and indifferent; indifferent replacing empty value</a> </p> <h3><span class="mw-headline" id="Prevent_double_listings">Prevent double listings</span></h3> <p>Especially important if you are working with the wdt:P2/wdt:P3* switch that can lead to double hits of the same object - the DISTINCT command: </p> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#SELECT%20DISTINCT%20%3FVerlag%20%3FVerlagLabel%20%3FOrtsans_ssig_inLabel%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%3FVerlag%20%28wdt%3AP2%2F%28wdt%3AP3%2a%29%29%20wd%3AQ21907%3B%0A%20%20%20%20wdt%3AP1098%20wd%3AQ876306.%0A%20%20OPTIONAL%20%7B%20%3FVerlag%20wdt%3AP83%20%3FOrtsans_ssig_in.%20%7D%0A%7D%0AORDER%20BY%20%28%3FOrtsans_ssig_inLabel%29">List of publishers</a></li></ul> <h2><span class="mw-headline" id="Grammatically_intricate_searches">Grammatically intricate searches</span></h2> <h3><span class="mw-headline" id="Wikimedia_sources">Wikimedia sources</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%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%3Fitem%20wdt%3AP91%20wd%3AQ22423.%0A%20%20OPTIONAL%20%7B%20%3Flink%20schema%3Aabout%20%3Fitem%20%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20.%20%7D%0A%7D">all Members of "Theodor zum guten Rat" with their respective Wikidata numbers</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Flink%20%3Fname%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%2Fuk.wikipedia.org%2F%3E%3B%0A%20%20%20%20%20%20%20%20schema%3Aname%20%3Fname%20.%0A%7D">All places that have an article on the Ukrainian Wikipedia; link with the respective uk.wp lemma</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3Flink%20%3Fis%20%3FisLabel%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%3Flink%20schema%3Aabout%20%3Fitem%3B%0A%20%20%20%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP2%20%3Fis.%20%7D%0A%20%20%20%20%20%20minus%20%7B%0A%20%20%20%20%20%20values%20%3Fis%20%7B%0A%20%20%20%20%20%20%20%20wd%3AQ7%20%0A%20%20%20%20%20%20%20%20wd%3AQ8%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%20%7D%0A%20%20%0A%7D">All items with a Wikidata equivalent, without humans and localities</a></li></ul> <h3><span class="mw-headline" id="Statements_with_sources">Statements with sources</span></h3> <ul><li><a rel="nofollow" class="external text" href="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</a></li></ul> <h3><span class="mw-headline" id="Statements_with_unit_information">Statements with unit information</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#%23Alle%20Testamente%20der%20L%C3%BCbecker%20B%C3%BCrger%20mit%20den%20jeweiligen%20Erbnehmern%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Freceiver%20%3FreceiverLabel%20%3Fmonetaryvalue%20%3FunitLabel%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP131%20%20wd%3AQ452393.%0A%20%20%3Fitem%20wdt%3AP417%20%3Freceiver%0AOPTIONAL%20%7B%20%3Freceiver%20pq%3AP73%20%3FErbe_Notiz.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20p%3AP417%20%5B%20ps%3AP417%20%3Freceiver%3B%20pq%3AP545%20%3Fmonetaryvalue%20%3B%20%20pqv%3AP545%20%3Fmonetaryunit%20%5D%20.%20%3Fmonetaryunit%20wikibase%3AquantityUnit%20%3Funit%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cde%22.%20%7D%20%0A%7D%0A%0AORDER%20BY%20%3FerbnehmerLabel%0ALIMIT%2030">inherited sums of money, Lübeck late Middle Ages</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FMensch%20%3FMenschLabel%20%3FAdresse%20%3FAdresseLabel%20%3FGeokoordinaten%20%3FMiete%20%3FunitLabel%20%3FGramm_Silber%20%3FGramm_SilberGegenwert%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2C%20en%22.%20%7D%0A%20%20%0A%20%20%3FMensch%20wdt%3AP2%20wd%3AQ7%3B%0A%20%20%20%20wdt%3AP83%20wd%3AQ10408%3B%0A%20%20%20%20wdt%3AP165%20wd%3AQ38388.%0A%20%20%0A%20%20OPTIONAL%20%7B%20%3FMensch%20wdt%3AP208%20%3FAdresse.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FAdresse%20wdt%3AP48%20%3FGeokoordinaten.%20%7D%0A%20%20%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%3FMensch%20p%3AP208%20%5B%20ps%3AP208%20%3FAdresse%3B%20pq%3AP943%20%3FMiete%20%3B%20%20pqv%3AP943%20%3Fmonetaryunit%20%5D%20.%20%0A%20%20%20%20%3Fmonetaryunit%20wikibase%3AquantityUnit%20%3Funit.%20%0A%20%20%20%20%3Funit%20wdt%3AP680%20%3FGramm_Silber.%20%0A%20%20%20%20BIND%20%28%3FMiete%20%2a%20%3FGramm_Silber%20AS%20%3FGramm_SilberGegenwert%29%0A%20%20%7D%0A%0A%20%20%3FMensch%20wdt%3AP131%20wd%3AQ469500.%0A%7D">get the silver-equivalent for a computation in Reichsthaler</a></li></ul> <h3><span class="mw-headline" id="Get_information_from_connected_items">Get information from connected items</span></h3> <ul><li><a rel="nofollow" class="external text" href="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</a> — the search is intricate as it goes into related database objects and brings information located there into the table.</li></ul> <h3><span class="mw-headline" id="Search_for_specific_Qualifiers_on_a_Statement">Search for specific Qualifiers on a Statement</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/276728u8">All documents authored by J.C.C. Bode, locations and shelf-marks</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FTeacher%20%3FTeacherLabel%20%3Fbegin%20%3Fend%20%3Fdate%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%3Fitem%20wdt%3AP161%20%3FTeacher%3B%0A%20%20%20%20p%3AP161%20%3Fstatement.%0A%20%20%3Fstatement%20ps%3AP161%20%3FTeacher.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP49%20%3Fbegin%20.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP50%20%3Fend%20.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20wdt%3AP106%20%3Fdate%20.%20%7D%0A%7D%0A">All Teachers with begin/ end/ date information</a></li> <li><a rel="nofollow" class="external text" href="https://tinyurl.com/y2w3aa5s">Authors writing all kind of satires</a></li> <li><a rel="nofollow" class="external text" href="https://tinyurl.com/yxbtatbw">Authors writing satire and all its subclasses</a> (you just add /wdt:P3* to pq:P122)</li> <li><a rel="nofollow" class="external text" href="https://tinyurl.com/y3ktcf38">The people writing all kind of satires (not necessarily authors)</a> (very simple: remove ps:P165 wd:Q23190)</li></ul> <h3><span class="mw-headline" id="Search_for_all_the_Qualifiers_on_Statements_with_the_same_property">Search for all the Qualifiers on Statements with the same property</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/27kev7q3">all the qualifiers for the people holding position at the pastorates of the Duchy of Gotha-Anstalt</a> useful when you want to delete a specific qualifier in a batch of items (here the pastorates of the Duchy), because it is not possible to simply delete qualifiers with Quickstatements. You need to delete the statement with all its qualifiers and reinstall it without the qualifier you want to delete.</li></ul> <h3><span class="mw-headline" id="You_already_know_one_related_value">You already know one related value</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://tinyurl.com/y4p4svke">all the lodges of Saint Domingue/Haiti</a> 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.</li></ul> <h3><span class="mw-headline" id="Looking_for_a_statement_-_give_it_with_all_the_qualifying_statements">Looking for a statement - give it with all the qualifying statements</span></h3> <p>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: </p> <pre>SELECT * WHERE { ?s wdt:P2 wd:Q7. ?s p:P266 ?st. # ?st is the the statement node ?st ps:P266 ?o. # that simulates the predicate ?st ?qualifier ?value. # this is an attribute (a qualifier) } </pre> <h2><span class="mw-headline" id="Missing_Statements">Missing Statements</span></h2> <p>These searches are most practical to see where work has to be done or where one has forgotten to make a certain statement. </p> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%0AWHERE%20%7B%20%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel%3B%20%20%20%20%20%20%20%0A%20%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP2%20%5B%5D%20%7D.%0A%7D">All the items that lack a P2 (instance of) statement</a> (2732 on 26 April 2023)</li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%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%3Fitem%20wdt%3AP131%20wd%3AQ465031.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP66%20%3Fval%20%7D%0A%7D%0A">All the titles of a specific project, that lack a P66 statement</a></li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FDocument%20%3FDocumentLabel%20%3FAuthor%20%3FAuthorLabel%20%3FGND%20%3FGND2%20%3FRecipient%20%3FRecipientLabel%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%3FDocument%20wdt%3AP2%20wd%3AQ10671.%0A%20%20%3FDocument%20wdt%3AP21%20%3FAuthor.%0A%20%20%20%20%20%20%20%20%20%20%3FAuthor%20wdt%3AP76%20%3FGND.%20%0A%20%20%20%20%3FDocument%20wdt%3AP28%20%3FRecipient.%0A%20%20%20%20%20%20FILTER%20NOT%20EXISTS%20%7B%20%3FRecipient%20wdt%3AP76%20%3Fval%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%7D">All people who do not have a GND number but who receive mail from a person with such a number</a></li> <li><a rel="nofollow" class="external text" href="https://tinyurl.com/2m7zbyzt">all types of non-literary genres that were not listed in Eckard Rolf's book of 1993, with their present position in Rolf's systematisation</a></li></ul> <h2><span class="mw-headline" id="Missing_connections">Missing connections</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23Family%20name%20with%20no%20linked%20pages%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Flink%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP2%20wd%3AQ24499.%0A%20%20%20FILTER%20%28%20NOT%20EXISTS%20%7B%20%20%20%3Fitem%20%5Ewdt%3AP247%20%3Fu%20.%20%3Fu%20wdt%3AP2%20wd%3AQ7%20.%20%7D%29%0A%20%20%20FILTER%20%28%20NOT%20EXISTS%20%7B%20%20%20%3Fitem%20%5Ewdt%3AP247%20%3Fu%20.%20%3Fu%20wdt%3AP2%20wd%3AQ8811%20.%20%7D%29%0A%20%20%20FILTER%20%28%20NOT%20EXISTS%20%7B%20%3Fitem%20%5Ewdt%3AP3%20%3Fu%20%7D%20%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%0A%20%20%20OPTIONAL%20%7B%20%3Flink%20schema%3Aabout%20%3Fitem%20%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20.%20%7D%0A%0A%7D%0AORDER%20BY%20%3Flink">all family names that are not used (with Wikidata references)</a></li></ul> <h2><span class="mw-headline" id="Wildcards">Wildcards</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/index.html#%23title%3A%20Personnes%20li%C3%A9es%20%C3%A0%20Rennes%0ASELECT%20DISTINCT%20%3Fpersonne%20%3FpersonneLabel%20%3Fpage%20WHERE%20%7B%0A%20%20%3Fpersonne%20%3Fprop%20wd%3AQ129672%20%3B%0A%20%20%20%20%20%20%20%20wdt%3AP2%20wd%3AQ7%20.%0A%20%20OPTIONAL%20%7B%20%3Fpage%20schema%3Aabout%20%3Fpersonne%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D">all people linked to the French city of Renne</a></li></ul> <h2><span class="mw-headline" id="State_all_statements_that_are_made_on_an_item">State all statements that are made on an item</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fitem%20%3FitemLabel%20%3FwdLabel%20%3Fps_Label%20%3Fwdpq%20%3FwdpqLabel%20%3Fpq_Label%20%7B%0A%20%20%23%20Ausgangsitem%20festlegen%0A%20%20VALUES%20%28%3Fitem%29%20%7B%28wd%3AQ95%29%7D%0A%0A%20%20%23%20alle%20statement%20nodes%20abgreifen%2C%20siehe%3A%20https%3A%2F%2Fen.wikibooks.org%2Fwiki%2FSPARQL%2FWIKIDATA_Qualifiers%2C_References_and_Ranks%0A%20%20%3Fitem%20%3Fp%20%3Fstatement%20.%0A%20%20%23%20object%20within%20statement%20node%20with%20ps%2C%20siehe%3A%20https%3A%2F%2Fen.wikibooks.org%2Fwiki%2FSPARQL%2FWIKIDATA_Qualifiers%2C_References_and_Ranks%0A%20%20%3Fstatement%20%3Fps%20%3Fps_%20.%0A%0A%20%20%23%20Property%20labels%0A%20%20%3Fwd%20wikibase%3Aclaim%20%3Fp.%0A%20%20%3Fwd%20wikibase%3AstatementProperty%20%3Fps.%0A%0A%20%20%23%20qualifiers%20mitnehmen%0A%20%20OPTIONAL%20%7B%0A%20%20%3Fstatement%20%3Fpq%20%3Fpq_%20.%0A%20%20%3Fwdpq%20wikibase%3Aqualifier%20%3Fpq%20.%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%20ORDER%20BY%20%3Fwd%20%3Fstatement%20%3Fps_%0A">State all statements that are made on an item</a> - the respective value has to be set in line 3.</li></ul> <h2><span class="mw-headline" id="Filters">Filters</span></h2> <ul><li><a rel="nofollow" class="external text" href="https://en.wikibooks.org/wiki/SPARQL/Expressions_and_Functions">Tutorial</a></li></ul> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3Fperson%20%3FpersonLabel%20%3Fdob%0AWHERE%0A%7B%0A%20%20%3Fperson%20wdt%3AP2%20wd%3AQ7%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP77%20%3Fdob.%0A%20%20FILTER%28%221700-01-01%22%5E%5Exsd%3AdateTime%20%3C%3D%20%3Fdob%20%26%26%20%3Fdob%20%3C%20%221710-01-01%22%5E%5Exsd%3AdateTime%29.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%20%0A%7D">all FactGrid people born between 1700 and 1710</a> A Filter that selects a time frame</li> <li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#SELECT%20%3FPers%20%3FPersLabel%20%3FPrefecture%20%3FPrefectureLabel%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%3FPers%20wdt%3AP91%20wd%3AQ10679.%0A%20%20%20%20OPTIONAL%20%7B%20%3FPers%20%28p%3AP91%2Fpq%3AP419%29%20%3FPrefecture.%20%7D%0A%20%20%20%20FILTER%28%3FPrefecture%20IN%28wd%3AQ251652%29%20%29.%0A%7D">All members of the strict Observance in Frankfurt's Prefecture</a> A Filter that selects an Item in a qualifying statement</li></ul> <h3><span class="mw-headline" id="Filter_based_on_strings">Filter based on strings</span></h3> <p>Filtering results containing certain strings (texts) can be archieved with `FILTER()` </p> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/#%23%20Find%20all%20items%20containing%20%22CSD%22%20in%20the%20German%20label%0ASELECT%20DISTINCT%20%3Fitem%20%3Flabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP131%20wd%3AQ400012%3B%0A%20%20%20%20rdfs%3Alabel%20%3Flabel.%0A%20%20FILTER%28%28LANG%28%3Flabel%29%29%20%3D%20%22%5BAUTO_LANGUAGE%5D%22%29%0A%20%20FILTER%28CONTAINS%28%3Flabel%2C%20%22CSD%22%29%29%0A%7D">Get all item with "CSD" in its labels within the Remove NA Project</a></li></ul> <h2><span class="mw-headline" id="SPARQL_patterns_for_reuse">SPARQL patterns for reuse</span></h2> <h3><span id="GROUP_CONCAT_Bring_several_values_in_one_cell_.28to_avoid_the_repetition_of_lines.29"></span><span class="mw-headline" id="GROUP_CONCAT_Bring_several_values_in_one_cell_(to_avoid_the_repetition_of_lines)">GROUP_CONCAT Bring several values in one cell (to avoid the repetition of lines)</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://database.factgrid.de/query/embed.html#SELECT%20%3FNr%20%3FSignatur%20%3Fitem%20%3FitemLabel%20%3FInhalt%20%28YEAR%28%3Fvon1%29%20AS%20%3Fvon%29%20%28YEAR%28%3Fbis1%29%20AS%20%3Fbis%29%20%28GROUP_CONCAT%28%3FPersonLabel%3B%20SEPARATOR%20%3D%20%22%20%E2%80%A2%20%22%29%20AS%20%3FPersonLabels%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP329%20wd%3AQ35000%3B%0A%20%20%20%20%20%20%20%20wdt%3AP2%20wd%3AQ10672.%0A%20%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP49%20%3Fvon1.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP50%20%3Fbis1.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20%28p%3AP329%2Fpq%3AP10%29%20%3FSignatur.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP499%20%3FNr.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP724%20%3FInhalt.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP33%20%3FPerson.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%0A%20%20%20%20%3FPerson%20rdfs%3Alabel%20%3FPersonLabel.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3FNr%20%3FSignatur%20%3FInhalt%20%3Fvon1%20%3Fbis1%0AORDER%20BY%20%3FNr">Table with names of persons mentioned collected in the last cells</a></li></ul> <h3><span class="mw-headline" id="Count_properties">Count properties</span></h3> <h4><span class="mw-headline" id="Get_all_properties_of_an_item">Get all properties of an item</span></h4> <pre>SELECT ?p ?o WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } wd:Q406029 ?p ?o } </pre> <h4><span class="mw-headline" id="count_statements_per_item_within_a_certain_project">count statements per item within a certain project</span></h4> <p>or within any other property-object relation </p> <pre> 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. } </pre> <h3><span class="mw-headline" id="Get_popular_items">Get popular items</span></h3> <p>Considering outcoming, incoming and sitelinks as proxys for popularity, one can formulate this query. </p><p>E.g. for Lodges: </p> <pre> SELECT ?item ?itemLabel ?outcoming ?sitelinks ?incoming { ?item wdt:P2 wd:Q11211. ?item wikibase:statements ?outcoming . ?item wikibase:sitelinks ?sitelinks . { SELECT (count(?s) AS ?incoming) ?item WHERE { ?item wdt:P2 wd:Q11211. ?s ?p ?item . [] wikibase:directClaim ?p } GROUP BY ?item } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }. } ORDER BY DESC (?incoming) </pre> <h2><span class="mw-headline" id="Federated_Queries">Federated Queries</span></h2> <p>Federated queries are those that gather data from multiple data sources. Factgrid can request data from Wikidata and DBpedia. </p><p><br /> </p> <h3><span id="Get_Factgrid_IDs_that_don.27t_have_a_Wikidata_QID.2C_but_can_be_found_in_Wikidata_via_its_Factgrid_ID"></span><span class="mw-headline" id="Get_Factgrid_IDs_that_don't_have_a_Wikidata_QID,_but_can_be_found_in_Wikidata_via_its_Factgrid_ID">Get Factgrid IDs that don't have a Wikidata QID, but can be found in Wikidata via its Factgrid ID</span></h3> <p><a rel="nofollow" class="external text" href="https://query.wikidata.org/#%20%20%23defaultView%3ATable%0A%0A%20%20%23%20Prefixes%0A%20%20PREFIX%20fg%3A%20%3Chttps%3A%2F%2Fdatabase.factgrid.de%2Fentity%2F%3E%0A%20%20PREFIX%20fgt%3A%20%3Chttps%3A%2F%2Fdatabase.factgrid.de%2Fprop%2Fdirect%2F%3E%0A%20%20PREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0A%20%20PREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0A%20%20PREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0A%20%20PREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%20%20PREFIX%20schema%3A%20%3Chttp%3A%2F%2Fschema.org%2F%3E%0A%0A%20%20SELECT%20DISTINCT%20%3Ffg_item%20%3Ffg_itemLabel%20%3Ffg_item_as_string%20%3Fwd_item%20where%20%7B%0A%0A%20%20%20%20%23%20labels%20from%20Factgrid%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%0A%20%20%20%20%23%20maybe%20filter%20to%20prevent%20timeout%0A%20%20%20%20%23%3Ffg_item%20fgt%3AP131%20fg%3AQ400012.%0A%20%20%20%20%23%20get%20those%20Factgrid%20IDs%20that%20don%27t%20have%20a%20Wikidata%20QID%0A%20%20%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%20%20%3Flink%20schema%3Aabout%20%3Ffg_item%20.%0A%20%20%20%20%20%20%3Flink%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20.%20%23Targeting%20Wikipedia%20language%20where%20subjects%20has%20no%20article.%0A%20%20%20%20%7D%0A%20%20%20%20%23%20Convert%20Factgrid%20ID%20from%20IRI%20to%20string%0A%20%20%20%20BIND%28REPLACE%28STR%28%3Ffg_item%29%2C%20%22https%3A%2F%2Fdatabase.factgrid.de%2Fentity%2F%22%2C%20%22%22%29%20as%20%3Ffg_item_as_string%29%20%0A%20%20%20%20%23%20get%20those%20Items%20from%20Wikidata%20that%20have%20that%20corresponding%20Factgrid%20ID%0A%20%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%3Fwd_item%20wdt%3AP8168%20%3Ffg_item_as_string%0A%20%20%20%20%7D%0A%20%20%7D">Try it</a> </p> <pre> #defaultView:Table # Prefixes PREFIX fg: <<a rel="nofollow" class="external free" href="https://database.factgrid.de/entity/">https://database.factgrid.de/entity/</a>> PREFIX fgt: <<a rel="nofollow" class="external free" href="https://database.factgrid.de/prop/direct/">https://database.factgrid.de/prop/direct/</a>> PREFIX wdt: <<a rel="nofollow" class="external free" href="http://www.wikidata.org/prop/direct/">http://www.wikidata.org/prop/direct/</a>> PREFIX wd: <<a rel="nofollow" class="external free" href="http://www.wikidata.org/entity/">http://www.wikidata.org/entity/</a>> PREFIX wikibase: <<a rel="nofollow" class="external free" href="http://wikiba.se/ontology#">http://wikiba.se/ontology#</a>> PREFIX bd: <<a rel="nofollow" class="external free" href="http://www.bigdata.com/rdf#">http://www.bigdata.com/rdf#</a>> PREFIX schema: <<a rel="nofollow" class="external free" href="http://schema.org/">http://schema.org/</a>> SELECT DISTINCT ?fg_item ?fg_itemLabel ?fg_item_as_string ?wd_item where { # labels from Factgrid SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # maybe filter to prevent timeout #?fg_item fgt:P131 fg:Q400012. # get those Factgrid IDs that don't have a Wikidata QID FILTER NOT EXISTS { ?link schema:about ?fg_item . ?link schema:isPartOf <<a rel="nofollow" class="external free" href="https://www.wikidata.org/">https://www.wikidata.org/</a>> . #Targeting Wikipedia language where subjects has no article. } # Convert Factgrid ID from IRI to string BIND(REPLACE(STR(?fg_item), "<a rel="nofollow" class="external free" href="https://database.factgrid.de/entity/">https://database.factgrid.de/entity/</a>", "") as ?fg_item_as_string) # get those Items from Wikidata that have that corresponding Factgrid ID SERVICE <<a rel="nofollow" class="external free" href="https://query.wikidata.org/sparql">https://query.wikidata.org/sparql</a>> { ?wd_item wdt:P8168 ?fg_item_as_string } } </pre> <h2><span class="mw-headline" id="Wishful_thinking">Wishful thinking</span></h2> <ul><li>A map of all places a Person has been, using (also) the information from sender's and receiver's places</li> <li><a rel="nofollow" class="external text" href="https://phabricator.wikimedia.org/T165473">visualisations quest on phabricator</a></li></ul> <h2><span class="mw-headline" id="Notes">Notes</span></h2> <div class="mw-references-wrap"><ol class="references"> <li id="cite_note-1"><span class="mw-cite-backlink"><a href="#cite_ref-1">↑</a></span> <span class="reference-text">Adapted from <a rel="nofollow" class="external text" href="https://en.wikibooks.org/wiki/SPARQL/Expressions_and_Functions#TIMEZONE_and_TZ">here</a>.</span> </li> </ol></div> <!-- NewPP limit report Cached time: 20241124214216 Cache expiry: 86400 Reduced expiry: false Complications: [show‐toc] CPU time usage: 0.151 seconds Real time usage: 2.401 seconds Preprocessor visited node count: 132/1000000 Post‐expand include size: 0/2097152 bytes Template argument size: 0/2097152 bytes Highest expansion depth: 2/100 Expensive parser function count: 0/100 Unstrip recursion depth: 0/20 Unstrip post‐expand size: 430/5000000 bytes Number of Wikibase entities loaded: 0/250 --> <!-- Transclusion expansion time report (%,ms,calls,template) 100.00% 0.000 1 -total --> <!-- Saved in parser cache with key mediawiki:pcache:idhash:10671-0!canonical and timestamp 20241124214213 and revision id 9760946. --> </div> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://database.factgrid.de/w/index.php?title=FactGrid:Sample_queries&oldid=9760946">https://database.factgrid.de/w/index.php?title=FactGrid:Sample_queries&oldid=9760946</a>"</div></div> <div id="catlinks" class="catlinks catlinks-allhidden" data-mw="interface"></div> </div> </div> <div id="mw-navigation"> <h2>Navigation menu</h2> <div id="mw-head"> <nav id="p-personal" class="vector-menu mw-portlet mw-portlet-personal vector-user-menu-legacy" aria-labelledby="p-personal-label" role="navigation" > <h3 id="p-personal-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Personal tools</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="pt-uls" class="mw-list-item active"><a class="uls-trigger" href="#"><span>English</span></a></li><li id="pt-login" class="mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=FactGrid%3ASample+queries" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span>Log in</span></a></li></ul> </div> </nav> <div id="left-navigation"> <nav id="p-namespaces" class="vector-menu mw-portlet mw-portlet-namespaces vector-menu-tabs vector-menu-tabs-legacy" aria-labelledby="p-namespaces-label" role="navigation" > <h3 id="p-namespaces-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Namespaces</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="ca-nstab-project" class="selected mw-list-item"><a href="/wiki/FactGrid:Sample_queries" title="View the project page [a]" accesskey="a"><span>Project page</span></a></li><li id="ca-talk" class="new mw-list-item"><a href="/w/index.php?title=FactGrid_talk:Sample_queries&action=edit&redlink=1" rel="discussion" title="Discussion about the content page (page does not exist) [t]" accesskey="t"><span>Discussion</span></a></li></ul> </div> </nav> <nav id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet vector-menu-dropdown" aria-labelledby="p-variants-label" role="navigation" > <input type="checkbox" id="p-variants-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-variants" class="vector-menu-checkbox" aria-labelledby="p-variants-label" /> <label id="p-variants-label" aria-label="Change language variant" class="vector-menu-heading " > <span class="vector-menu-heading-label">English</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"></ul> </div> </nav> </div> <div id="right-navigation"> <nav id="p-views" class="vector-menu mw-portlet mw-portlet-views vector-menu-tabs vector-menu-tabs-legacy" aria-labelledby="p-views-label" role="navigation" > <h3 id="p-views-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Views</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="ca-view" class="selected mw-list-item"><a href="/wiki/FactGrid:Sample_queries"><span>Read</span></a></li><li id="ca-viewsource" class="mw-list-item"><a href="/w/index.php?title=FactGrid:Sample_queries&action=edit" title="This page is protected. You can view its source [e]" accesskey="e"><span>View source</span></a></li><li id="ca-history" class="mw-list-item"><a href="/w/index.php?title=FactGrid:Sample_queries&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li></ul> </div> </nav> <nav id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-menu-dropdown" aria-labelledby="p-cactions-label" role="navigation" title="More options" > <input type="checkbox" id="p-cactions-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-cactions" class="vector-menu-checkbox" aria-labelledby="p-cactions-label" /> <label id="p-cactions-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">More</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"></ul> </div> </nav> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <div> <h3 > <label for="searchInput">Search</label> </h3> <form action="/w/index.php" id="searchform" class="vector-search-box-form"> <div id="simpleSearch" class="vector-search-box-inner" data-search-loc="header-navigation"> <input class="vector-search-box-input" type="search" name="search" placeholder="Search FactGrid" aria-label="Search FactGrid" autocapitalize="sentences" title="Search FactGrid [f]" accesskey="f" id="searchInput" > <input type="hidden" name="title" value="Special:Search"> <input id="mw-searchButton" class="searchButton mw-fallbackSearchButton" type="submit" name="fulltext" title="Search the pages for this text" value="Search"> <input id="searchButton" class="searchButton" type="submit" name="go" title="Go to a page with this exact name if it exists" value="Go"> </div> </form> </div> </div> </div> </div> <div id="mw-panel"> <div id="p-logo" role="banner"> <a class="mw-wiki-logo" href="/wiki/Main_Page" title="Visit the main page"></a> </div> <nav id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation vector-menu-portal portal" aria-labelledby="p-navigation-label" role="navigation" > <h3 id="p-navigation-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Navigation</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Main_Page" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-Query-service" class="mw-list-item"><a href="https://database.factgrid.de/query/" rel="nofollow"><span>Query service</span></a></li><li id="n-Sample-queries" class="mw-list-item"><a href="/wiki/FactGrid:Sample_queries"><span>Sample queries</span></a></li><li id="n-Advanced-text-search" class="mw-list-item"><a href="https://database.factgrid.de/w/index.php?title=Special:Search&profile=advanced&search=&fulltext=1" rel="nofollow"><span>Advanced text search</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li></ul> </div> </nav> <nav id="p-Browse" class="vector-menu mw-portlet mw-portlet-Browse vector-menu-portal portal" aria-labelledby="p-Browse-label" role="navigation" > <h3 id="p-Browse-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Browse</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-FactGrid-Viewer" class="mw-list-item"><a href="https://database.factgrid.de/viewer/" rel="nofollow"><span>FactGrid Viewer</span></a></li><li id="n-KnolBase-Browser" class="mw-list-item"><a href="https://factgrid.ringgaard.com/" rel="nofollow"><span>KnolBase Browser</span></a></li><li id="n-EntiTree-genealogies" class="mw-list-item"><a href="https://www.entitree.com/factgrid" rel="nofollow"><span>EntiTree genealogies</span></a></li></ul> </div> </nav> <nav id="p-Project_Spaces" class="vector-menu mw-portlet mw-portlet-Project_Spaces vector-menu-portal portal" aria-labelledby="p-Project_Spaces-label" role="navigation" > <h3 id="p-Project_Spaces-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Project Spaces</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-Blog" class="mw-list-item"><a href="https://blog.factgrid.de/" rel="nofollow"><span>Blog</span></a></li><li id="n-Projects-historically" class="mw-list-item"><a href="/wiki/FactGrid:Projects"><span>Projects historically</span></a></li><li id="n-Projects-alphabetically" class="mw-list-item"><a href="/wiki/Category:Alphabetical"><span>Projects alphabetically</span></a></li><li id="n-Projects-personally" class="mw-list-item"><a href="/wiki/Category:FactGrid_Personally"><span>Projects personally</span></a></li><li id="n-To-Do" class="mw-list-item"><a href="/wiki/FactGrid:To_Do"><span>To Do</span></a></li><li id="n-SPARQL-Lab" class="mw-list-item"><a href="/wiki/FactGrid:SPARQL_Lab"><span>SPARQL Lab</span></a></li></ul> </div> </nav> <nav id="p-Items_&_Properties" class="vector-menu mw-portlet mw-portlet-Items_Properties vector-menu-portal portal" aria-labelledby="p-Items_&_Properties-label" role="navigation" > <h3 id="p-Items_&_Properties-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Items & Properties</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-New-Item" class="mw-list-item"><a href="/wiki/Special:NewItem"><span>New Item</span></a></li><li id="n-MergeItems" class="mw-list-item"><a href="/wiki/Special:MergeItems"><span>MergeItems</span></a></li><li id="n-Batch-fragments" class="mw-list-item"><a href="/wiki/Batch_fragments"><span>Batch fragments</span></a></li><li id="n-QuickStatements" class="mw-list-item"><a href="https://database.factgrid.de/quickstatements/#/batch" rel="nofollow"><span>QuickStatements</span></a></li><li id="n-Directory-of-Properties" class="mw-list-item"><a href="/wiki/FactGrid:Directory_of_Properties"><span>Directory of Properties</span></a></li><li id="n-New-Property" class="mw-list-item"><a href="/wiki/Talk:Directory_of_Properties"><span>New Property</span></a></li><li id="n-Data-modeling" class="mw-list-item"><a href="/wiki/FactGrid:Data_modeling"><span>Data modeling</span></a></li><li id="n-Help" class="mw-list-item"><a href="/wiki/Help:Contents"><span>Help</span></a></li></ul> </div> </nav> <nav id="p-Lexemes" class="vector-menu mw-portlet mw-portlet-Lexemes vector-menu-portal portal" aria-labelledby="p-Lexemes-label" role="navigation" > <h3 id="p-Lexemes-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Lexemes</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-New-Lexeme" class="mw-list-item"><a href="https://database.factgrid.de/wiki/Special:NewLexeme" rel="nofollow"><span>New Lexeme</span></a></li><li id="n-Search" class="mw-list-item"><a href="https://database.factgrid.de/w/index.php?search=&title=Special%3ASearch&profile=advanced&fulltext=1&ns146=1" rel="nofollow"><span>Search</span></a></li></ul> </div> </nav> <nav id="p-tb" class="vector-menu mw-portlet mw-portlet-tb vector-menu-portal portal" aria-labelledby="p-tb-label" role="navigation" > <h3 id="p-tb-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Tools</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/FactGrid:Sample_queries" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/FactGrid:Sample_queries" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-print" class="mw-list-item"><a href="javascript:print();" rel="alternate" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=FactGrid:Sample_queries&oldid=9760946" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=FactGrid:Sample_queries&action=info" title="More information about this page"><span>Page information</span></a></li></ul> </div> </nav> <nav id="p-lang" class="vector-menu mw-portlet mw-portlet-lang vector-menu-portal portal" aria-labelledby="p-lang-label" role="navigation" > <h3 id="p-lang-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In other languages</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"></ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-add wb-langlinks-link"><a href="https://database.factgrid.de/wiki/Special:NewItem?site=mediawiki&page=FactGrid%3ASample+queries" title="Add interlanguage links" class="wbc-editpage">Add links</a></span></div> </div> </nav> </div> </div> <footer id="footer" class="mw-footer" role="contentinfo" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 18 November 2024, at 08:28.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="/wiki/FactGrid:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/FactGrid:About">About FactGrid</a></li> <li id="footer-places-disclaimer"><a href="/wiki/FactGrid:General_disclaimer">Disclaimers</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/"><img src="/w/resources/assets/poweredby_mediawiki_88x31.png" alt="Powered by MediaWiki" srcset="/w/resources/assets/poweredby_mediawiki_132x47.png 1.5x, /w/resources/assets/poweredby_mediawiki_176x62.png 2x" width="88" height="31" loading="lazy"/></a></li> </ul> </footer> <script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgPageParseReport":{"limitreport":{"cputime":"0.151","walltime":"2.401","ppvisitednodes":{"value":132,"limit":1000000},"postexpandincludesize":{"value":0,"limit":2097152},"templateargumentsize":{"value":0,"limit":2097152},"expansiondepth":{"value":2,"limit":100},"expensivefunctioncount":{"value":0,"limit":100},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":430,"limit":5000000},"entityaccesscount":{"value":0,"limit":250},"timingprofile":["100.00% 0.000 1 -total"]},"cachereport":{"timestamp":"20241124214216","ttl":86400,"transientcontent":false}}});mw.config.set({"wgBackendResponseTime":2772});});</script> </body> </html>