Difference between revisions of "Sample Queries"
Jump to navigation
Jump to search
(9 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 38: | Line 48: | ||
=== B323/1212 German inventory and related paintings === | === B323/1212 German inventory and related paintings === | ||
− | https:// | + | * [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:// | + | * [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 == | ||
− | === | + | === Transfers of paintings or groups of paintings === |
− | https:// | + | * [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:// | + | * [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:// | + | * [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:// | + | * [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 === | ||
− | + | * [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:// | + | * [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:// | + | * [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:// | + | * [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] | |
− |
Latest revision as of 21:45, 25 August 2021
Read more on queries
- 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
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
- 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
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
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?
- data item Exh. "Oude portretten": https://wbdev.jdcrp-research.eu/wiki/Item:Q5867
- start query