Difference between revisions of "Sample Queries"

From jdcrp-wikibase
Jump to navigation Jump to search
 
(11 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 29: Line 39:
  
 
=== Inventory documents ===
 
=== Inventory documents ===
−
https://tinyurl.com/yju3teap
+
* [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 ===
 
=== Paintings inventoried in Lefranc / Catroux inventory ===
−
https://wbdev.jdcrp-research.eu/wiki/Item:Q9012
+
* 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://wbdev.jdcrp-research.eu/wiki/Item:Q9048
 
  
−
https://tinyurl.com/ye2d6vgg
+
* [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 ===
 
=== B323/1212 German inventory and related paintings ===
−
https://tinyurl.com/yetpvmub
+
* [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 ===
 
=== Property cards and related paintings ===
−
https://tinyurl.com/yfybqet2
+
* [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 ===
 
=== People mentioned together with Bruno Lohse in documents ===
−
 
  
 
== Events ==
 
== Events ==
  
−
=== Transports of paintings or groups of paintings ===
+
=== Transfers of paintings or groups of paintings ===
−
https://tinyurl.com/yj866zav
+
* [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]
  
 
=== All (non provenance) events (timeline events) displayed on a timeline ===
 
=== All (non provenance) events (timeline events) displayed on a timeline ===
−
https://tinyurl.com/yhvqc8co
+
* [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 ===
 
=== All events with subtype history of Schloss collection on a timeline ===
−
https://tinyurl.com/yecy62p6
+
* [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 ===
−
https://tinyurl.com/yecxywv8
+
* [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 ==
 
== Paintings ==
  
 
=== 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?

Retrieved from "https://wbdev.jdcrp-research.eu/w/index.php?title=Sample_Queries&oldid=61851"