Showing posts with label opendata. Show all posts
Showing posts with label opendata. Show all posts

Aug 12, 2021

Jul 21, 2021

Tutorial for the Looted Art Detector: Using custom indicators


Looted Art Detector: Part 2 Using custom indicators

example with : ALIU Red Flag restorers

The user can analyse provenances for any names or words that seem interesting.

The list below contains the last names of art restorers who were investigated by the OSS Art Looting Investigation Unit for their role in the art market for Nazi-looted art.

Apr 27, 2020

Tracing the Nazi extermination of Jewish art collectors with Wikidata Sparql Queries


How to represent the impact of the Holocaust?

Inhumanly huge numbers defy our capacity to understand.

How to depict both the fates of individuals and the larger context, without losing sight of either?

In this next series of posts we attempt to find a way to show what happened to Jewish art collectors and their world during and after the Holocaust.


Timeline from Wikidata Query

As Jewish art collectors, dealers, artists, curators, historians  and museum personnel were being targeted for persecution, robbery and murder by Germany's Nazi government, covetous eyes fixed upon their precious art collections. 


How can we document and visualise this massive double movement: the persecuted people on one hand and their possessions on the other?

We will begin with the people. Those who did not manage to flee, and who ended up murdered in Nazi camps or ghettos.




Each and every one of these individuals had a story: a family, friends, business and social relations, activities, passions, beliefs, enthusiasms, achievements, foibles; a life filled with events and people and - in the case of the individuals whose stories we trace here -  art.



How can we gather the huge amount of information and comprehend how it all fits together and what it means? 

This is not a small challenge.
___


One of the best tools for dealing with large amounts of linked information, such as relationships between people, places, things and events, is Wikidata.







Why Wikidata?


1) STRUCTURED

Because Wikidata is open yet structurally rigorous where it matters.
Wikidata has built into it a linked data structure that can be read by both humans and machines. 

2) OPEN TO THE OUTSIDE WORLD
Wikidata can be used for querying not only what is referenced in Wikidata itself, but also for linking to information that is held outside of Wikidata which shares a reference or authority file.

3) DATA QUALITY

For the art world and the Holocaust, Wikidata has remarkably rich data. Though still a work in progress with much that remains to be done, Wikidata is already far more reliable and complete in the topics that concern us than any other database, authority file or linked dataset that I know of.

4) CROWDSOURCED

The task of telling the story of the Jewish art world and what happened to the people and the artworks during and after the Holocaust is too big for any one person or institution. There are so many people and events and places and objects, so many photos and documents, so many sources, so many languages. It is a job for every individual of good faith who wants to contribute to the sum of our knowledge.

5) WIKIMEDIA FOUNDATION

Because Wikidata is driven and maintained and enriched by very clever and hardworking people, and whatever innovations and advances are achieved become available to all of us, for free, where amazingly powerful tools cost only the effort of learning how to use them.


In this next series of posts, I hope to share some ideas and practical tips for using Wikidata Sparql queries to better understand the fates of Jewish art collectors and their collections, both collectively and individually. 


I hope that Holocaust scholars, art historians, provenance researchers, families and their advocates will find some of this useful, and that Sparql mavens will engage with the queries to improve them for the benefit of all.





(My apologies in advance to people who actually know how to write Sparql queries, and my thanks in advance for improving upon these amateurish efforts.)

_____

Sparql Query for above image



#With pictures

#art collectors, art dealers, art historians, curators, museum directors, restorers, galleries...
#died in Auschwitz-Birkenau Q7341
#died in Theresienstadt Q160175

SELECT ?item ?itemLabel ?pic ?datedied ?placediedLabel ?placedied ?birth ?place_birth ?VIAF_ID ?GND_ID ?Library_of_Congress_authority_ID ?ULAN_ID ?child ?childLabel ?ownedby ?ownedbyLabel ?depicts ?depictsLabel ?depictedby ?depictedbyLabel ?countryLabel ?ownerof ?ownerofLabel ?spouse ?employer ?employerLabel ?spouseLabel ?mother ?motherLabel ?father ?fatherLabel ?sibling ?siblingLabel ?sigperson ?sigpersonLabel ?party ?partyLabel ?partner ?partnerLabel WHERE {
{ ?item wdt:P106 wd:Q1792450.} UNION { ?item wdt:P31 wd:Q1007870. } UNION { ?item wdt:P106 wd:Q173950.} UNION { ?item wdt:P921 wd:Q328376.} UNION { ?item wdt:P106 wd:Q10732476.} UNION { ?item wdt:P106 wd:Q446966.} UNION { ?item wdt:P106 wd:Q22132694.} UNION { ?item wdt:P106 wd:Q674426.}


SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
{?item wdt:P20 wd:Q7341.} UNION {?item wdt:P20 wd:Q160175.}
  ?item wdt:P18 ?pic.
OPTIONAL { ?item wdt:P127 ?ownedby. }
OPTIONAL { ?item wdt:P570 ?datedied. }
OPTIONAL { ?item wdt:P20 ?placedied. }
OPTIONAL { ?item wdt:P180 ?depicts. }
OPTIONAL { ?item wdt:P921 ?plunder. }
OPTIONAL { ?item wdt:P1830 ?ownerof. }
OPTIONAL { ?item wdt:P108 ?employer. }
OPTIONAL { ?item wdt:P569 ?birth. }
OPTIONAL { ?item wdt:P40 ?child. }
OPTIONAL { ?item wdt:P214 ?VIAF_ID. }
OPTIONAL { ?item wdt:P19 ?place_birth. }
OPTIONAL { ?item wdt:P244 ?Library_of_Congress_authority_ID. }
OPTIONAL { ?item wdt:P227 ?GND_ID. }
OPTIONAL { ?item wdt:P245 ?ULAN_ID. }
OPTIONAL { ?item wdt:P26 ?spouse. }
OPTIONAL { ?item wdt:P27 ?country. }
OPTIONAL { ?item wdt:P3342 ?sigperson. }
OPTIONAL { ?item wdt:P102 ?party. }
OPTIONAL { ?item wdt:P1327 ?partner. }
OPTIONAL { ?item wdt:P25 ?mother. }
OPTIONAL { ?item wdt:P22 ?father. }
OPTIONAL { ?item wdt:P3373 ?sibling. }
OPTIONAL { ?item wdt:P1299 ?depictedby. }
OPTIONAL { ?item wdt:P39 ?position. }
FILTER (YEAR(?datedied) >= 1933 )
}
LIMIT 20000


_____


Link to Sparql Query

https://query.wikidata.org/#%23With%20pictures%0A%0A%23died%20in%20Auschwitz-Birkenau%20Q7341%0A%23died%20in%20Theresienstadt%20Q160175%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fpic%20%3Fdatedied%20%3FplacediedLabel%20%3Fplacedied%20%3Fbirth%20%3Fplace_birth%20%3FVIAF_ID%20%3FGND_ID%20%3FLibrary_of_Congress_authority_ID%20%3FULAN_ID%20%3Fchild%20%3FchildLabel%20%3Fownedby%20%3FownedbyLabel%20%3Fdepicts%20%3FdepictsLabel%20%3Fdepictedby%20%3FdepictedbyLabel%20%3FcountryLabel%20%3Fownerof%20%3FownerofLabel%20%3Fspouse%20%3Femployer%20%3FemployerLabel%20%3FspouseLabel%20%3Fmother%20%3FmotherLabel%20%3Ffather%20%3FfatherLabel%20%3Fsibling%20%3FsiblingLabel%20%3Fsigperson%20%3FsigpersonLabel%20%3Fparty%20%3FpartyLabel%20%3Fpartner%20%3FpartnerLabel%20WHERE%20%7B%0A%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ1792450.%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ1007870.%20%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ173950.%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP921%20wd%3AQ328376.%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ10732476.%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ446966.%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ22132694.%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ674426.%7D%0A%0A%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7B%3Fitem%20wdt%3AP20%20wd%3AQ7341.%7D%20UNION%20%7B%3Fitem%20wdt%3AP20%20wd%3AQ160175.%7D%0A%20%20%3Fitem%20wdt%3AP18%20%3Fpic.%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP127%20%3Fownedby.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP570%20%3Fdatedied.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP20%20%3Fplacedied.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP180%20%3Fdepicts.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP921%20%3Fplunder.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP1830%20%3Fownerof.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP108%20%3Femployer.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP569%20%3Fbirth.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP40%20%3Fchild.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP214%20%3FVIAF_ID.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP19%20%3Fplace_birth.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP244%20%3FLibrary_of_Congress_authority_ID.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP227%20%3FGND_ID.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP245%20%3FULAN_ID.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP26%20%3Fspouse.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP27%20%3Fcountry.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP3342%20%3Fsigperson.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP102%20%3Fparty.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP1327%20%3Fpartner.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP25%20%3Fmother.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP22%20%3Ffather.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP3373%20%3Fsibling.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP1299%20%3Fdepictedby.%20%7D%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP39%20%3Fposition.%20%7D%0AFILTER%20%28YEAR%28%3Fdatedied%29%20%3E%3D%201933%20%29%0A%7D%0ALIMIT%2020000



Permalink to this post: https://www.openartdata.org/2020/04/visualising-nazi-extermination-Jewish-art-collectors.html

Next Posts in this series:

Tracing Jewish Art Collectors and other #LostArtPeople by Place of Death

https://www.openartdata.org/2020/04/art-collectors-Holocaust-victims.html


How information about Jewish art  collectors who died in the Holocaust goes missing in the semantic web of linked data.

https://www.openartdata.org/2020/05/holocaust-Jewish-art-collectors-semantic-web.html



Open Art Data



Apr 8, 2020

DATASET: National Gallery of Art Nazi Era Provenance PUBLIC



Dataset name: National Gallery of Art Enhanced Provenance Research Dataset NEPIP PUBLIC


Description: This enhanced Provenance dataset has been constructed from  information available on the public internet site of the National Gallery of Art (NGA)  The dataset merges the list of artworks on the Nazi Era Provenance Internet Portal with provenance texts published on the NGA detailed item pages. 
This dataset is intended to facilitate research into Holocaust-era provenance for scholars, art historians and families. 
The original and best source of information concerning provenance remains the National Gallery of Art  public website.

Format: Google Sheet

URL: https://docs.google.com/spreadsheets/d/e/2PACX-1vTnJR2T4TtT-iFaioInvWpn8xhnhxjrWebFyWCvM3lodUssE0b_j64-vOC-PT17aVrxd-lcGp_SDntU/pubhtml?gid=1646299987&single=true


Download: CSV



Contents:

1. NEPIP National Gallery of Art 

2. About this file

3. NEPIP by Artists

4. NEPIP by Credit Line

5. NEPIP Provenance includes "private", "anonymous", "art market"

6. All of above

Publisher: OAD

Date of Publication: April 6, 2020



Example of content: Provenance text contains word "private", "anonymous", or "art market" 


---


Original data sources that were merged to create the new 
DATASET: National Gallery of Art Nazi Era Provenance PUBLIC:



Apr 6, 2020

Dataset : Museum of Fine Arts Boston Enhanced Provenance Research Dataset NEPIP PUBLIC




Dataset name: Museum of Fine Arts Boston Enhanced Provenance Research Dataset NEPIP PUBLIC

Description: This enhanced Provenance dataset has been constructed from  information available on the public internet site of the Museum of Fine Arts, Boston. The dataset merges the list of artworks on the Nazi Era Provenance Internet Portal with provenance texts published on the Boston MFA detailed item pages. 
This dataset is intended to facilitate research into Holocaust-era provenance for scholars, art historians and families. 
The original and best source of information concerning provenance remains the Museum of Fine Arts, Boston public website.


Original data sources that were merged to create new dataset:

  •  NEPIP Boston Museum of Fine Arts (MFA)




Format: Google Sheet



URL: https://docs.google.com/spreadsheets/d/e/2PACX-1vSFfpdQ1Y6sWQuTAdHejqghDwPvlu4W2cevOxjkLUQYdTOZXdxRM4OH5U_rkAvLUEh38VbFdntHeHoR/pubhtml




Download: CSV



Contents:



1. NEPIP MFA




2. About this file




3. NEPIP Artists


4. NEPIP Credit Line



5. NEPIP Provenance includes "private", "anonymous", "art market"



Publisher: OAD



Date of Publication: April 6, 2020




License: CC0





Example of content: Provenance text contains word "private", "anonymous", or "art market"