Difference between revisions of "Sample Queries"

@@ Line 3: / Line 3: @@
 * https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help/Result_Views/en
 * https://en.wikibooks.org/wiki/SPARQL/FILTER
+* https://www.mediawiki.org/wiki/Extension:LinkedWiki
-== People and their relationships ==
+== Persons ==
-=== People in this Wikibase ===
+=== Persons in this Wikibase ===
-https://tinyurl.com/yz8nymbf
+* [https://querydev.jdcrp-research.eu/#%23People%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Flifetime%20%3FitemDescription%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP21%20%3Flifetime.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+=== Schloss family members ===
+* [https://querydev.jdcrp-research.eu/#%23Schloss%20Family%20members%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Flifetime%20%3FitemDescription%20%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP120%20wd%3AQ11219.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP21%20%3Flifetime.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+=== All events Erhard Göpel has been involved in ===
+* [https://querydev.jdcrp-research.eu/#%23all%20events%20Erhard%20G%C3%B6pel%20has%20been%20involved%20in%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fstartdate%20WHERE%20%7B%0A%20%20BIND%28wd%3AQ3815%20AS%20%3Fperson%29%0A%20%20%3Fitem%20wdt%3AP101%20%3Fperson.%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ15.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP65%20%3Fstartdate%7D%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20ORDER%20BY%20%3Fstartdate start query]
+=== all data items Bruno Lohse is connected to as an object ===
+* [https://querydev.jdcrp-research.eu/#%23all%20data%20items%20Bruno%20Lohse%20is%20connected%20to%20as%20an%20object%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FinstanceLabel%20WHERE%20%7B%0A%20%20%3Fitem%20%3Fprop%20wd%3AQ3663.%0A%20%20%3Fitem%20wdt%3AP4%20%3Finstance.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+== Attributions to artists ==
+=== attributions of Q4519, An Old Scholar, painting by Salomon Koninck ===
+* item: https://wbdev.jdcrp-research.eu/wiki/Item:Q4519
+* [https://querydev.jdcrp-research.eu/#%23attributions%20of%20Q4519%2C%20An%20Old%20Scholar%2C%20painting%20by%20Salomon%20Koninck%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FartistLabel%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP102%20%3Fartist.%0A%20%20%7B%3Fitem%20%3Fprop%20wd%3AQ4519.%7D%0A%20%20UNION%0A%20%20%7Bwd%3AQ4519%20%3Fprop%20%3Fitem.%7D%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+== Locations ==
+Location items have geocodes added in order to allow display on maps.
+=== All exhibition places, map view ===
+* [https://querydev.jdcrp-research.eu/#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FlocationLabel%20%3Fcoord%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ15.%0A%20%20%3Fitem%20wdt%3AP15%20%22exhibition%22.%0A%20%20%3Fitem%20wdt%3AP113%20%3Flocation%20.%0A%20%20%3Flocation%20wdt%3AP69%20%3Fcoord.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+=== Location information in CCP cards, map view ===
+* [https://querydev.jdcrp-research.eu/#%23Location%20information%20in%20property%20cards%0A%23defaultView%3AMap%0ASELECT%20%3Fartwork%20%3FartistLabel%20%3FartworkLabel%20%3Fccpcard%20%3FccpcardLabel%20%3FarrivDate%20%3FlocationLabel%20%3Fgeocode%0AWHERE%20%0A%7B%0A%20%20%3Fccpcard%20wdt%3AP4%20wd%3AQ20.%0A%20%20OPTIONAL%20%7B%3Fccpcard%20wdt%3AP29%20%3FarrivDate.%7D%0A%20%20%3Fartwork%20wdt%3AP115%20%3Fccpcard.%0A%20%20%3Fartwork%20wdt%3AP4%20wd%3AQ10.%0A%20%20OPTIONAL%20%7B%3Fartwork%20wdt%3AP121%20%3Fartist.%7D%0A%20%20OPTIONAL%20%7B%3Fccpcard%20wdt%3AP101%20%3Flocation.%7D%0A%20%20OPTIONAL%20%7B%3Flocation%20wdt%3AP69%20%3Fgeocode.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+== Documents ==
+=== Inventory documents ===
+* [https://querydev.jdcrp-research.eu/#%23Schloss%20inventory%20documents%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FarchivCollLabel%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ24.%0A%20%20%3Fitem%20wdt%3AP133%20wd%3AQ280.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP120%20%3FarchivColl.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3FarchivCollLabel start query]
+=== Paintings inventoried in Lefranc / Catroux inventory ===
+* Data item Catroux inventory AN-Z6: https://wbdev.jdcrp-research.eu/wiki/Item:Q9012
+* Data item Catroux inventory 209SUP-147-118: https://wbdev.jdcrp-research.eu/wiki/Item:Q9048
+* [https://querydev.jdcrp-research.eu/#%23paintings%20in%20Lefranc%20inventory%0ASELECT%20%3Fitem%20%3FtitlePainting%20%3Fentry%20%3FartistLabel%20%3FentryLabel%20%3FfrenchNumber%20%3Fprice%20%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP111%20%3Fentry.%0A%20%20%3Fentry%20wdt%3AP120%20wd%3AQ5022.%0AOPTIONAL%20%7B%3Fentry%20wdt%3AP83%20%3Fprice.%7D%0AOPTIONAL%20%7B%3Fitem%20wdt%3AP70%20%3FtitlePainting.%7D%0AOPTIONAL%20%7B%3Fitem%20wdt%3AP95%20%3FfrenchNumber.%7D%0AOPTIONAL%20%7B%3Fentry%20wdt%3AP102%20%3Fartist.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3FartistLabel start query]
+=== B323/1212 German inventory and related paintings ===
+* [https://querydev.jdcrp-research.eu/#%23paintings%20in%20B323%2F1212%20German%20inventory%0ASELECT%20%3FentryLabel%20%3Fentry%20%3Fpage%20%3Fscan%20%3FgermanNumber%20%3FartistLabel%20%3FtitlePainting%20%3Fpainting%0AWHERE%20%7B%0A%20%20%3Fpainting%20wdt%3AP111%20%3Fentry.%0A%20%20%3Fentry%20wdt%3AP120%20wd%3AQ5020.%0A%20%20%3Fentry%20wdt%3AP14%20%3Fatid.%0A%20%20%3Fentry%20wdt%3AP82%20%3Fpage.%0A%20%20%3Fentry%20wdt%3AP108%20%3Fscan.%0AOPTIONAL%20%7B%3Fpainting%20wdt%3AP70%20%3FtitlePainting.%7D%0AOPTIONAL%20%7B%3Fpainting%20wdt%3AP96%20%3FgermanNumber.%7D%0AOPTIONAL%20%7B%3Fentry%20wdt%3AP34%20%3Fartist.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3Fatid start query]
+=== Property cards and related paintings ===
+* [https://querydev.jdcrp-research.eu/#%23CCP%20cards%20and%20related%20paintings%2C%20sorted%20per%20arrival%20date%0ASELECT%20%3Fccpcard%20%3FccpcardLabel%20%3FarrivDate%20%3FartworkLabel%20%3FartistLabel%20%3Fartwork%0AWHERE%20%0A%7B%0A%20%20%3Fccpcard%20wdt%3AP4%20wd%3AQ20.%0A%20%20OPTIONAL%20%7B%3Fartwork%20wdt%3AP121%20%3Fartist.%7D%0A%20%20OPTIONAL%20%7B%3Fccpcard%20wdt%3AP29%20%3FarrivDate.%7D%0A%20%20%3Fartwork%20wdt%3AP115%20%3Fccpcard.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3FarrivDate start query]
+=== People mentioned together with Bruno Lohse in documents ===
 == Events ==
-=== All timeline events displayed as a timeline ===
+=== Transfers of paintings or groups of paintings ===
-https://tinyurl.com/yhvqc8co
+* [https://querydev.jdcrp-research.eu/#%23transfers%20of%20Schloss%20collection%2C%20groups%20or%20single%20paintings%0ASELECT%20%3Ftransfer%20%3FtransferLabel%20%3FstartDate%20%3FendDate%20%3FtypeLabel%20%3FtransferStartLabel%20%3FtransferEndLabel%20%3FgroupLabel%20%3FpaintingLabel%0AWHERE%20%7B%0A%20%20%3Ftransfer%20wdt%3AP4%20wd%3AQ15.%0A%20%20%3Ftransfer%20wdt%3AP15%20%22provenance_transfer%22.%0A%20%20%3Ftransfer%20wdt%3AP131%20%3FtransferStart.%0A%20%20%3Ftransfer%20wdt%3AP132%20%3FtransferEnd.%0A%20%20%3Ftransfer%20wdt%3AP65%20%3FstartDate.%0A%20%20%3Ftransfer%20wdt%3AP66%20%3FendDate.%0A%20%20OPTIONAL%20%7B%3Ftransfer%20wdt%3AP133%20%3Ftype.%7D%0A%20%20OPTIONAL%20%7B%3Ftransfer%20wdt%3AP124%20%3Fgroup.%7D%0A%20%20OPTIONAL%20%7B%3Ftransfer%20wdt%3AP125%20%3Fpainting.%7D%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3FstartDate start query]
-=== Which paintings have been part of sales and when? ===
+=== All (non provenance) events (timeline events) displayed on a timeline ===
-https://tinyurl.com/yjovsw6m
+* [https://querydev.jdcrp-research.eu/#%23defaultView%3ATimeline%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fexhstart%20%3Fexhend%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP15%20%22timeline%22.%0A%20%20%3Fitem%20wdt%3AP65%20%3Fexhstart.%0A%20%20%3Fitem%20wdt%3AP66%20%3Fexhend.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+=== All events with subtype history of Schloss collection on a timeline ===
+* [https://querydev.jdcrp-research.eu/#%23defaultView%3ATimeline%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fexhstart%20%3Fexhend%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ15.%0A%20%20%3Fitem%20wdt%3AP133%20wd%3AQ11164.%0A%20%20%3Fitem%20wdt%3AP65%20%3Fexhstart.%0A%20%20%3Fitem%20wdt%3AP66%20%3Fexhend.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D start query]
+=== Schloss paintings mentioned in different European collections, chronological list ===
+* [https://querydev.jdcrp-research.eu/#%23transfers%20of%20Schloss%20collection%2C%20groups%20or%20single%20paintings%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FstartDate%20%3FendDate%20%3FpaintingLabel%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ15.%0A%20%20%3Fitem%20wdt%3AP15%20%22provenance_mention%22.%0A%20%20%3Fitem%20wdt%3AP65%20%3FstartDate.%0A%20%20%3Fitem%20wdt%3AP66%20%3FendDate.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP125%20%3Fpainting.%7D%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3FstartDate]
+=== All provenance events related to the painting "Portrait of a gentleman" by Judith Leyster ===
+* [https://querydev.jdcrp-research.eu/#SELECT%20%3FartworkLabel%20%3Fprovenance%20%3FprovenanceLabel%20%3FstartDate%20%3FendDate%20%0AWHERE%20%7B%0A%20%20BIND%20%28wd%3AQ4817%20AS%20%3Fartwork%29%0A%20%20%3Fartwork%20wdt%3AP110%20%3Fprovenance.%0A%20%20OPTIONAL%20%7B%3Fprovenance%20wdt%3AP65%20%3FstartDate.%7D%0A%20%20OPTIONAL%20%7B%3Fprovenance%20wdt%3AP66%20%3FendDate.%7D%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7DORDER%20BY%20%3FstartDate start query]
 == Paintings ==
+=== A list of paintings from the Schloss collection ===
+* [http://wbdev.jdcrp-research.eu:8282/#%23A%20list%20of%20Schloss%20collection%20paintings%0ASELECT%20%3Fartwork%20%3FartworkLabel%20%3FartistLabel%20%3FgermanSchlossId%20%3FfrenchSchlossId%0AWHERE%20%0A%7B%0A%20%20%3Fartwork%20wdt%3AP4%20wd%3AQ10.%0A%20%20%3Fartwork%20wdt%3AP120%20wd%3AQ5753.%0A%20%20OPTIONAL%20%7B%20%3Fartwork%20wdt%3AP121%20%3Fartist.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fartwork%20wdt%3AP96%20%3FgermanSchlossId.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fartwork%20wdt%3AP95%20%3FfrenchSchlossId.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fartist%20wdt%3AP19%20%3Flastname.%20%7D%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20ORDER%20BY%20%3Flastname start query]
 === Which paintings have been restituted and when? ===
-https://tinyurl.com/yz3pa29v
+* [https://querydev.jdcrp-research.eu/#SELECT%20%3Fitem%20%3FitemLabel%20%20%3FrestDate%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP31%20%22Yes%22.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP30%20%3FrestDate%20.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0A start query]
+=== Which paintings have been part of sales and when? ===
+* [https://querydev.jdcrp-research.eu/#%23sales%20with%20Schloss%20paintings%20%28chronological%20list%29%0ASELECT%20%3Fitem%20%3Fstart_date%20%3FeventLabel%20%3FartistLabel%20%3FitemLabel%20%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ10.%0A%20%20%3Feventref%20wdt%3AP125%20%3Fitem.%0A%20%20%3Feventref%20wdt%3AP109%20%3Fevent.%0A%20%20%3Fevent%20wdt%3AP15%20%22sale%22.%0A%20%20%0A%20%20OPTIONAL%20%7B%3Fevent%20wdt%3AP65%20%3Fstart_date.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP121%20%3Fartist.%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20ORDER%20BY%20%3Fstart_date start query]
+=== Schloss paintings in exhibitions, chronological list ===
+* [https://querydev.jdcrp-research.eu/#%23Schloss%20paintings%20in%20exhibitions%0ASELECT%20%3Fitem%20%3FeventLabel%20%3Fstart_date%20%3FartistLabel%20%3FitemLabel%20%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP4%20wd%3AQ10.%0A%20%20%3Feventref%20wdt%3AP125%20%3Fitem.%0A%20%20%3Feventref%20wdt%3AP109%20%3Fevent.%0A%20%20%3Fevent%20wdt%3AP15%20%22exhibition%22.%0A%20%20%0A%20%20OPTIONAL%20%7B%3Fevent%20wdt%3AP65%20%3Fstart_date.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP121%20%3Fartist.%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20ORDER%20BY%20%3Fstart_date start query]
+=== Which paintings have been displayed in the exhibition "Oude portretten" in 1903? ===
+* data item Exh. "Oude portretten": https://wbdev.jdcrp-research.eu/wiki/Item:Q5867
+* [http://wbdev.jdcrp-research.eu:8282/#%23Paintings%20in%20the%20exhibition%20%22Oude%20Portretten%22%2C%201903%0ASELECt%20%3FartistLabel%20%3FartworkLabel%20%3FexhibitionRef%20%3Fartwork%20%3FgermanSchlossId%20%3FfrenchSchlossId%0AWHERE%20%0A%7B%0A%20%20%3FexhibitionRef%20wdt%3AP109%20wd%3AQ5867.%0A%20%20%3FexhibitionRef%20wdt%3AP125%20%3Fartwork.%0A%20%20OPTIONAL%20%7B%20%3Fartwork%20wdt%3AP121%20%3Fartist.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fartwork%20wdt%3AP96%20%3FgermanSchlossId.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fartwork%20wdt%3AP95%20%3FfrenchSchlossId.%20%7D%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20ORDER%20BY%20%3FartworkLabel start query]

Difference between revisions of "Sample Queries"

Latest revision as of 21:45, 25 August 2021

Contents

Read more on queries

Persons

Persons in this Wikibase

Schloss family members

All events Erhard Göpel has been involved in

all data items Bruno Lohse is connected to as an object

Attributions to artists

attributions of Q4519, An Old Scholar, painting by Salomon Koninck

Locations

All exhibition places, map view

Location information in CCP cards, map view

Documents

Inventory documents

Paintings inventoried in Lefranc / Catroux inventory

B323/1212 German inventory and related paintings

Property cards and related paintings

People mentioned together with Bruno Lohse in documents

Events

Transfers of paintings or groups of paintings

All (non provenance) events (timeline events) displayed on a timeline

All events with subtype history of Schloss collection on a timeline

Schloss paintings mentioned in different European collections, chronological list

All provenance events related to the painting "Portrait of a gentleman" by Judith Leyster

Paintings

A list of paintings from the Schloss collection

Which paintings have been restituted and when?

Which paintings have been part of sales and when?

Schloss paintings in exhibitions, chronological list

Which paintings have been displayed in the exhibition "Oude portretten" in 1903?

Navigation menu

Search