Difference between revisions of "Sample Queries"
Jump to navigation
Jump to search
(→Events) |
|||
| Line 62: | Line 62: | ||
=== A list of paintings from the Schloss collection === | === A list of paintings from the Schloss collection === | ||
| − | 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] |
=== 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] | |
| − | |||
Revision as of 13:19, 31 July 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
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
Transports 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
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