Showing posts with label Digital Art History. Show all posts
Showing posts with label Digital Art History. Show all posts

Nov 12, 2024

Part II: Tracking the Munich connections, ideas from ChatGPT

In "The Munich Connection" we listed artworks that American museums published on the Nazi Era Provenance Internet Portal whose provenance contained the word "Munich".

How to go from there to a map of the WWII and postwar art dealing networks? There is a lot of data and it is held in different places for different purposes. How not to get lost in it all

In this day of LLMs, it seemed reasonable to see if ChatGPT had any advice.

Prompt:

You are an art detective. You know the names of ten dealers based in Munich who were guilty of trading in Nazi looted art. What you’d like to find out is the names of the intermediaries they used postwar to launder looted artworks and sell them to American museums. You can obtain provenance from museums, from looted art databases and from restitution cases. You have access to a knowledge graph that can tell you who people are. Please suggest a plan. 

ChatGPT:

To trace the intermediaries used by Munich-based art dealers to launder Nazi-looted artworks postwar and sell them to American museums, a well-structured approach can be valuable. Here’s a plan:

1. Gather Known Provenance Information

  • Museum Provenance Records: Focus on American museums known for acquiring European art post-WWII. Request detailed provenance information for artworks acquired in the 1940s-60s, especially noting gaps or vague terms like "private collection," "anonymous dealer," or "European dealer."
  • Looted Art Databases: Use databases such as the Lost Art Database, Looted Art Commission, and the ERR Project for provenance listings, especially to identify common gaps or placeholders in known trajectories of looted items.
  • Restitution Case Documents: Review case files, court documents, and museum press releases on restituted items to identify language around intermediaries and specific networks for laundered art.

2. Map Munich Dealers and Known Intermediaries in the Knowledge Graph

  • Identify Munich Dealers and Known Relationships: Using the knowledge graph, input each dealer and examine linked entities, focusing on relationships with postwar American art dealers, auction houses, or European intermediaries.
  • Entity Type Filters: Restrict the search to entities categorized as “art dealer,” “collector,” “auction house,” or “museum.” Add any other common intermediary roles, such as “agent” or “gallery.”
  • Timeline Filtering: Narrow down connections from the late 1940s to the 1960s, which will highlight postwar networks.

3. Identify Patterns and Red Flags in Provenance

  • Look for Recurring Names and Organizations: Track any intermediary names, auction houses, or “anonymous collectors” that appear repeatedly. Often, a small number of names indicate laundering networks.
  • Map Transfers and Ownership Changes: Use the knowledge graph to link changes in ownership or exhibition between Munich dealers and American institutions.
  • Spot Geographic Patterns: Identify locations where intermediaries operated (e.g., Paris, New York, Buenos Aires) and correlate them with known laundering hubs.

4. Construct Provenance Subgraphs for In-Depth Analysis

  • Dealer-Intermediary-Museum Chain: Create subgraphs showing each dealer's documented transactions with intermediaries, which led to acquisitions by American museums.
  • Intermediary and Auction House Network: Map connections between dealers and auction houses or intermediaries who acted repeatedly in sales to American museums.
  • Use Family or Business Associations: If available, analyze relationships between family members or business associates of dealers and intermediaries to uncover hidden links or front organizations.

5. Integrate Data Sources for Query Optimization

  • To avoid data overload and timeouts, create modular queries targeting specific dealer-intermediary pairs.
  • SPARQL Querying for Entities: With your knowledge graph, design SPARQL queries that limit results to provenance chains involving dealers and museums, particularly for cases of early postwar acquisitions.
  • Tag and Record Suspicious Provenance Patterns: Note entries in provenance records with vague language and investigate further through additional query filtering.

6. Review Secondary Sources for Supporting Evidence

  • Literature on Art Laundering Postwar: Sources on art market dynamics and postwar laundering methods can provide leads.
  • Identify Network Corroboration in Case Studies: Analyze academic case studies on similar restitution cases and laundering networks to validate your findings or suggest additional angles.

This approach uses systematic data mining across provenance records, legal cases, and the knowledge graph, allowing you to triangulate connections between the Munich dealers, their intermediaries, and the eventual American museums. By combining entity matching and pattern detection, this plan aims to uncover laundered art chains and hidden intermediaries.

---

Comment

Except for the timeline filtering, which is too narrow given that many of the European artworks in American museums have no provenance for the 1940s-1960s, ChatGPT's proposed plan looks doable to me. We already have the artworks in American museums whose provenance mentions Munich. Now let's start identifying the names in those provenances and linking them up to other sources, such as Art Looting Investigation Unit Red Flag Names, Jewish refugees and victims of the Holocaust, and art market players mentioned in the itineraries of looted art cases.

Dec 7, 2022

How to use information in the provenance texts of Nazi looted art that has been restituted to find other Nazi-looted artworks

This Nazi-looted painting was restituted in 2016. 
https://www.lostart.de/de/Verlust/526702


Often, when a painting is restituted, it is the conclusion of a long and arduous process of archival research to establish the itinerary of the painting and the different actors involved in its looting (or sale, or transfer, or translocation). 
What happens if we take the NAMES that appear in the provenance AFTER an artwork has left the possession of the persecuted Jewish owner and plug them in to some powerful digital tools to check other provenance texts for their presence?

Could this application of digital tools provide clues that lead to other Nazi-looted artworks?

Dec 19, 2021

Art collectors and the Holocaust: itineraries from birth to death

Henri Rieger, born in Sered, died in Theresienstadt






Henri Hinrichsen, born in Hamburg, died in Auschwitz




Rosa Oppenheimer, born in Berlin, died in Auschwitz





Ernst Pollack, born in Vienna, died in Theresienstadt concentration camp





Margarete Mauthner, born in Berlin, escaped Nazi Germany to die thousands of miles away in Johannesburg South Africa






Maria Altmann, born in Vienna, escaped Nazi Austria and died thousands of miles away in Los Angeles, California. 








Click on the Play Arrow 


 https://public.flourish.studio/visualisation/8168334/









****

How was this interactive data visualization created?

Note: this map only shows birth and death places, not the many other places these art collectors lived.

1) Gather the birth and death places of the selected art collectors and dealers, along with coordinates, latitude and longitude. (Wikidata Query)

https://w.wiki/4a4s

#Places of Death or Birth (with coordinates long and lat) for Art historians dealers collectors museum directors restorers 
SELECT DISTINCT ?place ?placeLabel ?coord ?lat ?long
WHERE 
{
  {?item wdt:P106 wd:Q1792450} UNION {?item wdt:P106 wd:Q173950} UNION {?item wdt:P106 wd:Q10732476} UNION {?item wdt:P106 wd:Q674426} UNION {?item wdt:P106 wd:Q22132694} UNION {?item wdt:P106 wd:Q2145981} 
  
?item (wdt:P20|wdt:P19) ?place.
   ?place wdt:P625 ?coord.
   ?place p:P625 ?statement.
   ?statement psv:P625 ?coordinate_node .
  ?coordinate_node wikibase:geoLatitude ?lat .
  ?coordinate_node wikibase:geoLongitude ?long .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}

Download the result of the query. This will provide the location data file for Flourish.


2) Gather the names, descriptions, birth and death places and dates (as well as additional information) about the art collectors. 

Link to Wikidata query used in this data visualisation with birth and death places


https://query.wikidata.org/embed.html#%23Art%20historians%20dealers%20collectors%20museum%20directors%20restorers%20with%20significant%20event%20of%20Aryanization%20or%20claim%20for%20restitution%20of%20artwork%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fbirthplace%20%3FbirthplaceLabel%20%3Fdeathplace%20%3FdeathplaceLabel%0AWHERE%20%0A%7B%0A%20%20%7B%3Fitem%20wdt%3AP106%20wd%3AQ1792450%7D%20UNION%20%7B%3Fitem%20wdt%3AP106%20wd%3AQ173950%7D%20UNION%20%7B%3Fitem%20wdt%3AP106%20wd%3AQ10732476%7D%20UNION%20%7B%3Fitem%20wdt%3AP106%20wd%3AQ674426%7D%20UNION%20%7B%3Fitem%20wdt%3AP106%20wd%3AQ22132694%7D%20UNION%20%7B%3Fitem%20wdt%3AP106%20wd%3AQ2145981%7D%20%0A%20%20%20%20%20%20%7B%3Fitem%20wdt%3AP793%20wd%3AQ664017.%7D%20UNION%20%7B%3Fitem%20wdt%3AP793%20wd%3AQ107614552.%7D%0A%20%20%0A%20%20%3Fitem%20wdt%3AP20%20%3Fdeathplace%3B%0A%20%20%20%20%20%20%20%20wdt%3AP19%20%3Fbirthplace.%0A%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%23%20Helps%20get%20the%20label%20in%20your%20language%2C%20if%20not%2C%20then%20en%20language%0A%7D


3) Select a data visualization template in Flourish 

Selected template 
Connections globe4.0.0



4) Upload two data files into Flourish, a file with the geographical names and locations, and a file with the birth and death places of the art collectors and dealers selected




5) Format (still in progress) and publish




Sep 2, 2021

DATASET: Carnegie Museum of Art merged with Github provenances

DATASET: Provenance information gathered from the 2015 CMOA Github merged with information from the Carnegie Museum of Art online collections website


Description: This dataset contains publicly available information originally published online by the Carnegie Museum of Art which has been formatted by OAD as a CSV file for easy download and analysis with digital tools. Many of the artworks in the list also appear on the Nazi Era Provenance Internet Portal (NEPIP). For more recent updates or additional information concerning the artworks, please contact the Carnegie Museum of Art.

The CMOA collections dataset was published on Github by the Carnegie Museum of Art under a Creative Commons CC0 1.0 licence (no copyright). 

It has been enhanced with a NEW URL field in order to link to the CMOA museum website.


Date data retrieved: August 2021


AOD Version: 1.0


Format: CSV                           Click to DOWNLOAD CSV



https://docs.google.com/spreadsheets/d/e/2PACX-1vQwCWFQ13AB3EFsfXN84BxCMoWZ1keAT8-vxyTTlvEwZLQDuRqsxa5Ebrh0OdVOQfy79VdiB30Om6cm/pub?gid=1728520750&single=true&output=csv



Aug 12, 2021

Detector Tool Tutorial: ranking by number of Red Flag and Restitution Case Names


This post, in the educational series on the experimental digital tool for analysing provenance texts, demonstrates Ranking by Red Flag Names (photo: Albright-Knox).

Work in progress. Feedback welcome.

Jul 21, 2021

Tutorial for the Looted Art Detector: Using custom indicators

Note: 12NOV2024 The Looted Art Detector is undergoing an update on Pythonanywhere and will be back in service soon

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.

Jul 18, 2021

Looted Art Detector Tool: Swiss GLAMHACK2021

Note: 12NOV2024 The Looted Art Detector is undergoing an update on Pythonanywhere and will be back in service soon


Objective: Identify high priority artworks for provenance research


Description: Online Free Digital Tool



Approach: Automatic text analysis using frequency counts

note: The frequency counts target textual indicators of UNCERTAINTY, UNRELIABILITY,  or ANONYMITY, as well as the possible presence of RED FLAG names related to NAZI-looted art, forced sales and duress sales. 
The resulting calculations do not signify that an artwork is looted. They simply quantify observations concerning the text for further analysis.

How it works: 

May 1, 2021

Names of persecuted Austrian Jewish collectors



How to verify the provenance texts of artworks for names that might indicate a history of Nazi looting or persecution?

There are many potential sources and lists.

In this post, we look an official Austrian report from 2008 that contains names of Austrian Jewish collectors whose art collections were plundered by the Nazis.

Mar 19, 2021

Suspicious provenance errors: Manet's Mellon

Mrs Kurt Riezler (née Käthe Liebermann, daughter of Max Liebermann) was previously mis-identified as Liezler

 Why does it matter? Because her family was persecuted by the Nazis and she herself was a refugee.


EDOUARD MANET

The Melonc. 1880

Sep 3, 2020

César Mange de Hauke


Who was César Mange de Hauke (1900-1965)?

What was the role of this French art dealer in bringing European artworks to America?
Which artists did he handle?
Who were his clients?
Why did the Art Looting Investigation Unit put him on the Red Flag List?

de Haucke, Cesar Monge. Paris, 14 rue du Cherche-Midi. Dealer active in Paris and New York before the war. Active in Paris during the occupation; in contact with Wuester, Haberstock and Hofer; documentary evidence in Unit files.


In this post we take a look at some of Hauke's (Haucke's) transactions in the Knoedler files at the Getty Provenance Index.

Jun 5, 2020

DATASET: Text Analysis Challenge - Detect Looted Art - GLAMhack2020



Download  Provenance Texts Dataset: CSV 

Text Analysis Challenge: Detect Looted Art.

Help Automate Analysis, Flagging and Ranking of Museum Art Provenance Texts by the Probability of a Hidden History

The Question: How to sift through the millions of objects in museums to identify top priorities for intensive research by humans? 

The Goal: Automatically Classify and Rank 60,000+ art provenance texts by probability that further research will turn up a deliberately concealed history of looting, forced sale, theft or forgery. 

The Challenge: Analyse texts quickly for Red Flags, quantify, detect patterns, classify, rank, and learn. Whatever it takes to produce a reliable list of top suspects

For this challenge several datasets will be provided.

1) DATASET: 60,000+ art provenance texts for analysis

(example)
https://www.harvardartmuseums.org/collections/object/296887[Pierre Matisse Gallery, New York, New York], by 1932, to M. Gutmann, 1936. Maurice Wertheim, by 1937, bequest, to Fogg Art Museum, 1951.;NOTE: Provenance derived from "Degas to Matisse: The Maurice Wertheim Collection," John O'Brian, Harry N. Abrams, New York, 1988.1951.76
https://www.harvardartmuseums.org/collections/object/229045Private Collector, Paris, Said to have been bought directly from artist, 1918.;Maurice Wertheim, Purchased from the Valentine Gallery, 1937, Bequest to Fogg Art Museum, 1951.1951.52
https://www.harvardartmuseums.org/collections/object/229044Paul Guillaume, Paris, France, 1925, 1935. By 1930, per caption of photo, Paul Guillaume dining room dated c. 1930, Georgel 2006;Maurice Wertheim, 1937, Bequest to Fogg Art Museum, 1951.1951.51
https://www.harvardartmuseums.org/collections/object/229043Unidentified owner, Paris, sold, [through Hôtel Drouot, Paris, June 16, 1906, no 30.]. Dr. Alfred Wolff, Munich, (1912). Sir Michael Sadler, England, (1912). [De Hauke & Co., New York], sold, to A. Conger Goodyear, New York, (1929-1937) sold, [through Wildenstein && Co., New York];to Maurice Wertheim, New York (1937-1951) bequest, to Fogg Art Museum, 1951.1951.49

2) DATASET: 1000 Red Flag Names

(example)

Bignou, EtienneBignouEtienneEtienne Bignou
Billiet, DirectorBillietDirectorDirector Billiet
Binder, Dr. Moritz JuliusBinderDr. Moritz JuliusDr. Moritz Julius Binder
Bing CollectionBing CollectionBing Collection
Birtschansky, ZacharieBirtschanskyZacharieZacharie Birtschansky
Bisson, E.BissonE.E. Bisson
Blanc, PierreBlancPierrePierre Blanc
Bleye, WilliBleyeWilliWilli Bleye
Bloch, Dr. VitaleBlochDr. VitaleDr. Vitale Bloch
Bloch-Bauer Collection
Bloch-Bauer Collection
Bloch-Bauer Collection
BlotBlotBlot
Bode, Dr.BodeDr.Dr. Bode
Bodenschatz, General KarlBodenschatzGeneral KarlGeneral Karl Bodenschatz
Boedecker, AlfredBoedeckerAlfredAlfred Boedecker
Boehler, Julius, Jr.BoehlerJuliusJulius Boehler
Boehler, Julius, Sr.BoehlerJuliusJulius Boehler
Boehm, Dr. FranzBoehmDr. FranzDr. Franz Boehm
Boehmer, BernhardBoehmerBernhardBernhard Boehmer

3) DATESET:  Red Flag Words or Phrases

(example)
flaguncertaintyflaganonymityflagpuncutationflagmoveflagreliability
likelyprivate collector?transfertelephone
probablyanonymous[removedto at least
possiblyart marketuntil at least
maybeunidentifiedby 19
?unknownbefore 19
property of a European collectoraccording to
private collection
property of a lady
anon. 


You're the doctor and the texts are your patients! Who's in good health and who's sick? How sick? With what disease? What kind of tests and measurements can we perform on the texts to help us to reach a diagnosis? What kind of markers for should we look for? What kind of patterns? 

What digital methods can we use - and put into practice during the Hackathon - to "diagnose" these texts and prioritize them for "treatment" (ie, additional provenance research)?


  • IDENTIFY Red Flag Names and Words in each Text?
  • COUNT Red Flag Names and Words in each Text?
  • CHARACTERIZE each Text (number of words? sentiment? completeness v gaps? other features to be identified that may be useful)?
  • ANALYZE for patterns, links and networks?
  • CALCULATE probability that the provenance conceals a Nazi-era history that will prove problematic if investigated in detail
  • RANK according to urgency for further in-depth provenance research 


(Voyant-Tools Whitelist containing names: 
keywords-14ca7131716f24c62c6529fcc143bbd2  )


What might a successful result look like?




  • A list of 50 provenances from the DATASET ranked most likely to conceal looted art
  • A color-coded evaluation of each provenance (RED, ORANGE, GREEN) by likelihood of concealing looted art
  • Instructions how to analyze the provenances with the tools, functions or code to use  (for example, how to use Voyant-Tools to count all the Red Flag Names and inject the result back into the spreadsheet)
  • Ideas for going further....


Triage: "assignment of degrees of urgency to wounds or illnesses to decide the order of treatment of a large number of patients or casualties."

Link to Glamhack2020 project for participants
https://hack.glam.opendata.ch/project/7



Help us to test and improve and test and improve the code!

Link to Code on Github 

https://github.com/parisdata/GLAMhack2020

Issues to resolve:
- While the word list counts and general name extraction seem to work pretty well, reconciliation with the list of 1000 Red Flag Names still needs work. To test: A tighter tolerance combined with a more complete listing of alias might help.
- The extraction of transaction years after 1900 gives interesting though incomplete indicators. The decision to exclude dates in parentheses (as they are sometimes biographical dates and not transaction dates) needs to be reviewed and refined. 
(note: The texts are from multiple sources applying multiple formats and deliberately entered exactly as is)

Results RAW (with uncorrected errors for analysis)




Apr 30, 2020

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

In our previous post, we introduced the idea of using Wikidata Queries to Trace Jewish art collectors and their collections.


In this post, we begin to look at how we might identify these Jewish individuals, many of whom have been not only forgotten but deliberately written out of history. 


What information or feature might help us to identify them?
What do we know about them?


  • They died after 1932 
  • They were connected to the arts in some way: as collectors, dealers, curators, historians, curators, museum directors, gallery owners, possibly as artists
  • Their names might have appeared in exhibitions or catalogs as owners or lenders or donors or experts, or in books or articles as authors, in the provenance texts of collections, for example.



The above criteria is very large and not specific to Jewish collectors in the Nazi era.  How can we further narrow the criteria? One element that distinguishes the fates of Jewish individuals from others is how and where they died, and whether or not they were interned, spoliated or became refugees. 

What kind of markers can we look for in the data?


  • Place of death
  • Year of death
  • Cause of death
  • Place of internment
  • Significant events like aryanization or arrest or deportation


All of the above correspond to "Properties" that are defined in Wikidata. Not all these properties have been updated for every Wikidata item. But they could be. 


A Wikidata Query can easily show us all the people who are known (in Wikidata) to have died or been interned in a Nazi camp or ghetto.


How to do this?

There were so many Nazi camps in so many countries (see below) that we look for a way to take each one into account without necessarily naming each one in a query.

One way is to use Wikidata's "instance of" (P31).

We can tell the query to list people who died in a place that is defined as any of the following things:


  • Nazi concentration camp (Q328468)
  • concentration camp (Q152081)
  • extermination camp (Q153813)
  • ghetto in Nazi-occupied Europe (Q2583015)


We might still miss a few of the camps (due to the crowdsourcing nature of Wikidata, not every item is coded in exactly the same way,) but this should be a good start.

There are several ways to do OR type queries in Wikidata.

We will use the very straight forward UNION. (Please do not hesitate to suggest better ways).

WHERE {
{ ?placedied wdt:P31 wd:Q328468.} UNION { ?placedied wdt:P31 wd:Q152081. } UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placediedwdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q2583015.}


To make the Wikidata query run faster and avoid time outs, we will first check that the place of death has been entered by someone into Wikidata.


?item wdt:P20 ?placedied.

Then, instead of specifying, as we did in the previous query, that we want to list the people who died in the specific Nazi concentration camp of Auschwitz-Birkenau


  ?item wdt:P20 wd:Q7341.  

we want to request people who died in any place coded as an instance of Q328468, Q152081, Q153813 or Q2583015


{ ?placedied wdt:P31 wd:Q328468.} UNION { ?placedied wdt:P31 wd:Q152081. } UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q2583015.}

This should include all the Nazi camps and ghettos listed at the bottom of this post

_______


SELECT DISTINCT ?item ?itemLabel ?pic ?datedied ?placediedLabel ?placedied ?child ?childLabel ?ownedby ?ownedbyLabel ?depicts ?depictsLabel ?depictedby ?depictedbyLabel ?countryLabel ?ownerof ?ownerofLabel ?spouse ?employer ?employerLabel ?spouseLabel ?mother ?motherLabel ?father ?fatherLabel ?sibling ?siblingLabel ?investby ?investbyLabel ?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 ?placedied.  
{ ?placedied wdt:P31 wd:Q328468.} UNION { ?placedied wdt:P31 wd:Q152081. } UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q2583015.}
OPTIONAL  { ?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:P1840 ?investby. }
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

_______

note: careful: the filter should read datedied "greater than or equal to" 1933. Sometimes the greater than symbol gets garbled on this blog

(Notice the word OPTIONAL? We are telling Wikidata to get the information if it is available but not to worry about it if it is not. Since we want to understand who these individuals were, the context of their lives and their relations with others, we have added much optional information to the query. This is not strictly speaking necessary, but possibly useful for future network analysis)
The Wikidata Sparql Query can present the results in many different ways.

As a table. 


As a graph. 












With photos







We can zoom in close to view certain specific elements that are hard to see when looking at lots of data.





We also get an idea of where data might be missing.














Try the query yourself.  It shows only those art people who died in a Nazi camp or ghetto. What one immediately notices is how many are missing. 

How to see what is present and what is absent will be the subject of our next post.

Link to Query
https://query.wikidata.org/#%0A%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fpic%20%3Fdatedied%20%3FplacediedLabel%20%3Fplacedied%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%3Finvestby%20%3FinvestbyLabel%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%3Fitem%20wdt%3AP20%20%3Fplacedied.%20%20%0A%7B%20%3Fplacedied%20wdt%3AP31%20wd%3AQ328468.%7D%20UNION%20%7B%20%3Fplacedied%20wdt%3AP31%20wd%3AQ152081.%20%7D%20UNION%20%7B%20%3Fplacedied%20wdt%3AP31%20wd%3AQ153813.%7D%20UNION%20%7B%20%3Fplacedied%20wdt%3AP31%20wd%3AQ153813.%7D%20UNION%20%7B%20%3Fplacedied%20wdt%3AP31%20wd%3AQ2583015.%7D%0AOPTIONAL%20%20%7B%20%3Fitem%20wdt%3AP18%20%3Fpic.%20%7D%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%3AP1840%20%3Finvestby.%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%0A%23%20FILTER%20%28YEAR%28%3Fbirth%29%20%3D%201860%20%26amp%3B%26amp%3B%20YEAR%28%3Fbirth%29%20%26lt%3B%3D%201990%29%0AFILTER%20%28YEAR%28%3Fdatedied%29%20%3E%3D%201933%20%29%0A%7D%0ALIMIT%2020000




Camps and ghettos listed in the Wikidata Query


SELECT ?placedied ?placediedLabel
WHERE
{
  { ?placedied wdt:P31 wd:Q328468.} UNION { ?placedied wdt:P31 wd:Q152081. } UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q153813.} UNION { ?placedied wdt:P31 wd:Q2583015.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}



(Short link to query and result - Try it!)