Difference between revisions of "Sample Queries"

From jdcrp-wikibase
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 15: Line 15:
 
=== All events Erhard Göpel has been involved in ===
 
=== 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]
 
* [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 ==
 
== Locations ==
Line 47: Line 57:
 
== Events ==
 
== Events ==
  
=== Transports of paintings or groups of paintings ===
+
=== Transfers of paintings or groups of paintings ===
 
* [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]
 
* [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]
  
Line 55: Line 65:
 
=== All events with subtype history of Schloss collection on a timeline ===
 
=== 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]
 
* [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 ===
 
=== All provenance events related to the painting "Portrait of a gentleman" by Judith Leyster ===
Line 62: Line 75:
  
 
=== A list of paintings from the Schloss collection ===
 
=== A list of paintings from the Schloss collection ===
https://tinyurl.com/yfdbzbff
+
* [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? ===
 
=== 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? ===
 
=== Which paintings have been part of sales and when? ===
https://tinyurl.com/yjovsw6m
+
* [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 ===
 
=== Schloss paintings in exhibitions, chronological list ===
https://tinyurl.com/yzrx5zs2
+
* [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? ===
 
=== Which paintings have been displayed in the exhibition "Oude portretten" in 1903? ===
https://wbdev.jdcrp-research.eu/wiki/Item:Q5867
+
* 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]
https://tinyurl.com/yk2vb8j7
 

Latest revision as of 21:45, 25 August 2021

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

Location items have geocodes added in order to allow display on maps.

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?