Difference between revisions of "Sample Queries"
Jump to navigation
Jump to search
(→Events) |
|||
| Line 48: | Line 48: | ||
=== Transports of paintings or groups of paintings === | === Transports 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] |
=== 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 == | ||
Revision as of 13:14, 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