Wikidata:WikiProject sum of all paintings/Collections by number of paintings with image suggestion missing data

This is a list of collections sorted by the number of paintings that have a Commons compatible image available at URL (P4765) statement, but some data is missing:

No creator (P170). Add the creator to the painting
Does have a creator (P170) and the creator isn't anonymous (Q4233718), but the creator is missing date of birth (P569) or date of death (P570). Add the missing statements on the creator
Does have a creator (P170) and it's set anonymous (Q4233718), but the date of death (P570) is missing. Add the missing inception.

See Collections by number of paintings with image suggestion for collections with image suggestions. See also Collections by number of paintings with image and Wikidata:WikiProject sum of all paintings/Collections by number of paintings without image.

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

SELECT ?item (CONCAT("[[Wikidata:WikiProject sum of all paintings/Collection/",?name, "|list]]") AS ?listlink) ?todo (COUNT(?painting) as ?count) WHERE {   ?painting wdt:P31 wd:Q3305213 .     ?painting wdt:P195 ?item .    ?painting wdt:P4765 ?image .   MINUS { ?painting wdt:P170 ?creator . ?creator wdt:P569 ?dob . ?creator wdt:P570 ?dod } .   MINUS { ?painting wdt:P170 ?creator . ?creator wdt:P569 ?dob . FILTER(YEAR(?dob) > 1900) } .   MINUS { ?painting wdt:P170 wd:Q4233718 . ?painting wdt:P571 ?inception } .   SERVICE wikibase:label {     bd:serviceParam wikibase:language "en" .     ?item rdfs:label ?name .    }   BIND(CONCAT("[https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Finception%20%3Fcreator%20%3FcreatorLabel%20%3Fsourceurl%20%3Fimageurl%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP195%20%3C", STR(?item), "%3E%20.%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ3305213%20.%20%20%0A%20%20%3Fitem%20%20p%3AP4765%20%3Fimagesuggestion%20.%0A%20%20%3Fimagesuggestion%20ps%3AP4765%20%3Fimageurl%20.%0A%20%20OPTIONAL%20%7B%20%3Fimagesuggestion%20pq%3AP2699%20%3Fsourceurl%20%7D%20.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP170%20%3Fcreator%20%7D%20.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP571%20%3Finception%20%7D%20.%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP170%20%3Fminuscreator%20.%20%3Fminuscreator%20wdt%3AP569%20%3Fdob%20.%20%3Fminuscreator%20wdt%3AP570%20%3Fdod%20%7D%20.%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP170%20%3Fminuscreator%20.%20%3Fminuscreator%20wdt%3AP569%20%3Fdob%20.%20FILTER(YEAR(%3Fdob)%20%3E%201900)%20%7D%20.%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP170%20wd%3AQ4233718%20.%20%3Fitem%20wdt%3AP571%20%3Fminusinception%20%7D%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20%0ALIMIT%202000 To do list]", "") AS ?todo) . } GROUP BY ?item ?name ?listlink ?todo ORDER BY DESC(?count)  LIMIT 250

To do list	museum	list	country	count
To do list	Harvard Art Museums	list	United States of America	2091
To do list	National Museum in Warsaw	list	Poland	1911
To do list	Arthur M. Sackler Museum	list	United States of America	1485
To do list	Princeton University Art Museum	list	United States of America	1464
To do list	Minneapolis Institute of Art	list	United States of America	1065
To do list	Bavarian State Painting Collections	list	Germany	617
To do list	Cultural Heritage Agency of the Netherlands Art Collection	list	Netherlands	524
To do list	National Museum in Kraków	list	Poland	480
To do list	Nationalmuseum	list	Sweden	455
To do list	Fogg Museum	list	United States of America	452
To do list	National Trust	list	United Kingdom	429
To do list	Museum De Waag	list	Netherlands	411
To do list	Yale University Art Gallery	list	United States of America	314
To do list	Rhode Island School of Design Museum	list	United States of America	311
To do list	Royal Museums Greenwich	list	United Kingdom	301
To do list	Cleveland Museum of Art	list	United States of America	281
To do list	Stedelijk Museum Alkmaar	list	Netherlands	195
To do list	Museum of Fine Arts Boston	list	United States of America	183
To do list	Smithsonian American Art Museum	list	United States of America	181
To do list	Staatliche Kunsthalle Karlsruhe	list	Germany	180
To do list	National Galleries Scotland	list	United Kingdom	165
To do list	Kunsthistorisches Museum	list	Austria	165
To do list	Museum of Fine Arts, Houston	list	United States of America	152
To do list	Statens Museum for Kunst	list	Denmark	149
To do list	Royal Collection	list	United Kingdom	141
To do list	Reading Public Museum	list	United States of America	138
To do list	Museum Rotterdam	list	Netherlands	135
To do list	Museum Flehite	list	Netherlands	129
To do list	Saint Louis Art Museum	list	United States of America	119
To do list	Museum of Fine Arts Ghent (MSK)	list	Belgium	116
To do list	Suermondt-Ludwig-Museum	list	Germany	113
To do list	New Britain Museum of American Art	list	United States of America	107
To do list	Fries Museum	list	Netherlands	97
To do list	Barnes Foundation	list	United States of America	96
To do list	Huis Bergh	list	Netherlands	94
To do list	Maritime Museum Rotterdam	list	Netherlands	91
To do list	Het Scheepvaartmuseum	list	Netherlands	86
To do list	Dallas Museum of Art	list	United States of America	83
To do list	Fitzwilliam Museum	list	United Kingdom	76
To do list	National Portrait Gallery of Sweden	list	Sweden	74
To do list	Staatliches Museum Schwerin	list	Germany	62
To do list	National Museum of Art, Architecture and Design	list	Norway	59
To do list	Slovak National Gallery	list	Slovakia	56
To do list	Belvedere	list	Austria	54
To do list	Munich Central Collecting Point	list	Allied-occupied Germany	52
To do list	National Portrait Gallery	list	United Kingdom	51
To do list	Führermuseum	list	German Reich	51
To do list	Indianapolis Museum of Art	list	United States of America	43
To do list	National Portrait Gallery	list	United States of America	40
To do list	Rosenborg Castle	list	Denmark	40
To do list	Museum Van Loon	list	Netherlands	37
To do list	Clark Art Institute	list	United States of America	34
To do list	Dordrechts Museum	list	Netherlands	32
To do list	Tate	list	United Kingdom	32
To do list	Rijksmuseum Twenthe	list	Netherlands	32
To do list	Kunstbesitz der Bundesrepublik Deutschland	list	Germany	32
To do list	Isabella Stewart Gardner Museum	list	United States of America	31
To do list	Birmingham Museums Trust	list	United Kingdom	28
To do list	National Gallery	list	United Kingdom	27
To do list	Groninger Museum	list	Netherlands	27
To do list	Amsterdam Museum	list	Netherlands	24
To do list	Berlinische Galerie	list	Germany	23
To do list	Kunsthandel P. de Boer	list	Netherlands	23
To do list	Stichting Historische Verzamelingen van het Huis Oranje-Nassau	list	Netherlands	23
To do list	Metropolitan Museum of Art	list	United States of America	22
To do list	Bonnefanten Museum	list	Netherlands	22
To do list	Gebruder Douwes	list	Netherlands	20
To do list	Art Institute of Chicago	list	United States of America	19
To do list	Instituut Collectie Nederland	list	Netherlands	19
To do list	Frederiksborg Palace	list	Denmark	19
To do list	Geldersch Landschap en Kasteelen	list	Netherlands	19
To do list	Jewish Museum	list	Netherlands	18
To do list	Museum of Fine Arts of Rennes	list	France	17
To do list	Busch–Reisinger Museum	list	United States of America	17
To do list	Rafael Valls Limited	list	United Kingdom	16
To do list	Royal Museum of Fine Arts Antwerp	list	Belgium	15
To do list	Hermitage Museum	list	Russia	15
To do list	Museum Het Valkhof	list	Netherlands	15
To do list	Royal Palace of Amsterdam	list	Netherlands	14
To do list	Museum Boijmans Van Beuningen	list	Netherlands	13
To do list	Schielandshuis	list	Netherlands	13
To do list	Johnny Van Haeften Gallery	list	United Kingdom	12
To do list	Het Loo Palace	list	Netherlands	11
To do list	East Slovak Gallery	list	Slovakia	11
To do list	Jacques Goudstikker collection	list	Netherlands	11
To do list	Yale Center for British Art	list	United States of America	10
To do list	The Wallace Collection	list	United Kingdom	10
To do list	Julius Böhler AG	list	Germany Nazi Germany Weimar Republic	10
To do list	Museo del Prado	list	Spain	10
To do list	Netherlands Open Air Museum	list	Netherlands	10
To do list	Mauritshuis	list	Netherlands	9
To do list	Museum Arnhem	list	Netherlands	9
To do list	National Maritime Museum	list	United Kingdom	9
To do list	Orava Gallery	list	Slovakia	9
To do list	Kunstmuseum Basel	list	Switzerland	9
To do list	Drents Museum	list	Netherlands	8
To do list	Germanisches Nationalmuseum	list	Germany	8
To do list	Hunterian Museum and Art Gallery	list	United Kingdom	8
To do list	Rijksmuseum	list	Netherlands	7
To do list	Vlaamse Kunstcollectie (VKC)	list	Belgium	7
To do list	Prinsenhof	list	Netherlands	7
To do list	Richard Green Fine Paintings	list	United Kingdom	7
To do list	Stedelijk Museum Zutphen	list	Netherlands	7
To do list	Drottningholm Collection	list	Sweden	6
To do list	Dienst Verspreide Rijkscollecties	list	Netherlands	6
To do list	Department of Paintings of the Louvre	list	France	6
To do list	Ernest Zmeták Art Gallery	list	Slovakia	6
To do list	icon collection of Sweden National Museum	list	Sweden	5
To do list	Rijksdienst Beeldende Kunst	list	Netherlands	5
To do list	Jan Michiel Pieter Glerum collection	list	Netherlands	5
To do list	Pyotr Semyonov-Tyan-Shansky collection	list	Russian Empire	5
To do list	National Gallery of Art	list	United States of America	4
To do list	Stichting Nederlands Kunstbezit	list	Netherlands	4
To do list	Victoria and Albert Museum	list	United Kingdom	4
To do list	Haags Historisch Museum	list	Netherlands	4
To do list	Government Art Collection	list	United Kingdom	4
To do list	Museum of the History of France	list	France	3
To do list	Gallery of Spiš Artists	list	Slovakia	3
To do list	Buffalo AKG Art Museum	list	United States of America	3
To do list	Sheffield Galleries and Museums Trust	list	United Kingdom	3
To do list	Gemäldegalerie	list	Germany	3
To do list	New-York Historical Society	list	United States of America	3
To do list	Mauerbach collection	list	Austria	3
To do list	Kunstmuseum Den Haag	list	Netherlands	3
To do list	University of Amsterdam	list	Netherlands	3
To do list	Galleria Sabauda	list	Italy	3
To do list	Pushkin Museum of Fine Arts	list	Russia	3
To do list	Collectie Vlaamse Gemeenschap	list	Belgium	2
To do list	Hermann Göring Collection	list	German Reich	2
To do list	Museum Helmond	list	Netherlands	2
To do list	De Wieger	list	Netherlands	2
To do list	Staatliche Kunstsammlungen Dresden	list	Germany	2
To do list	Knole House	list	United Kingdom	2
To do list	Montacute House	list	United Kingdom	2
To do list	Snowshill Manor	list	United Kingdom	2
To do list	Asian Art	list		2
To do list	Musées Nationaux Récupération	list	France	2
To do list	Bundesdenkmalamt	list	Austria	2
To do list	Royal Museums of Fine Arts of Belgium	list	Belgium	2
To do list	Sanssouci Picture Gallery	list	Germany	2
To do list	Bryan Gallery of Christian Art	list	United States of America	2
To do list	Van Gogh Museum	list	Netherlands	2
To do list	Museum Martena	list	Netherlands	2
To do list	English Heritage	list	United Kingdom	2
To do list	Museum Mayer van den Bergh	list	Belgium	2
To do list	Strömsholmssamlingen	list		1
To do list	Läckö collection	list		1
To do list	Royal Dutch Antiquarian Society	list	Netherlands	1
To do list	Robert Lehman Collection	list		1
To do list	Robert Lehman	list		1
To do list	Maurice Kann	list		1
To do list	Dulwich Picture Gallery	list	United Kingdom	1
To do list	Museum De Lakenhal	list	Netherlands	1
To do list	Legermuseum	list	Netherlands	1
To do list	Limburg Museum	list	Netherlands	1
To do list	collection Willem V Prince of Orange Nassau	list	Netherlands	1
To do list	Wittelsbacher Ausgleichsfonds	list	Germany	1
To do list	Museum of Fine Arts, Budapest	list	Hungary	1
To do list	Liptov Gallery of Peter Michal Bohúň	list	Slovakia	1
To do list	Anglesey Abbey, Gardens and Lode Mill	list	United Kingdom	1
To do list	Blickling Hall	list	United Kingdom	1
To do list	Greys Court	list	United Kingdom	1
To do list	Ham House	list	United Kingdom	1
To do list	Hardwick Hall	list	United Kingdom	1
To do list	Ickworth House	list	United Kingdom	1
To do list	Penmaenmawr Museum	list	United Kingdom	1
To do list	Petworth House	list	United Kingdom	1
To do list	Plas Newydd Military Museum	list	United Kingdom	1
To do list	Saltram House	list	United Kingdom	1
To do list	Sizergh Castle	list	United Kingdom	1
To do list	Trerice	list	United Kingdom	1
To do list	National Gallery of Canada	list	Canada	1
To do list	Alte Pinakothek	list	Germany	1
To do list	Adolphe Schloss collection	list	France	1
To do list	Cook collection	list	United Kingdom	1
To do list	The American Wing	list		1
To do list	Blackburn Museum and Art Gallery	list	United Kingdom	1
To do list	Museu Paulista collection	list	Brazil	1
To do list	Santos Dumont Collection	list	Brazil	1
To do list	Manchester Art Gallery	list	United Kingdom	1
To do list	Bristol City Museum and Art Gallery	list	United Kingdom	1
To do list	Hepworth Wakefield	list	United Kingdom	1
To do list	Crystal Bridges Museum of American Art	list	United States of America	1
To do list	The Costume Institute	list	United States of America	1
To do list	Moderna Museet	list	Sweden	1
To do list	Walker Art Gallery	list	United Kingdom	1
To do list	Regional Gallery of Liberec	list	Czech Republic	1
To do list	Hallwyl Museum	list	Sweden	1
To do list	Andrew W. Mellon collection	list	United States of America	1
To do list	Detroit Institute of Arts	list	United States of America	1
To do list	Collection Goudstikker heirs	list	Netherlands	1
To do list	Kunsthalle Bremen	list	Germany	1
To do list	Städel Museum	list	Germany	1
To do list	Singer Laren	list	Netherlands	1
To do list	Utrecht University	list	Netherlands	1
To do list	Huis Van Gijn	list	Netherlands	1
To do list	Stedelijk Museum Amsterdam	list	Netherlands	1
To do list	Stedelijk Museum Zwolle	list	Netherlands	1
To do list	Six Collection	list	Netherlands	1
To do list	Our Lord in the Attic Museum	list	Netherlands	1
To do list	Fondation Custodia	list	France	1
To do list	Museumslandschaft Hessen Kassel	list	Germany	1
To do list	Brantsen van de Zyp Stichting	list	Netherlands	1
To do list	Musée Magnin	list	France	1
To do list	Brighton Museum & Art Gallery	list	United Kingdom	1
To do list	Dingwall Museum	list	United Kingdom	1
To do list	Barts Health Archives	list	United Kingdom	1
To do list	Victoria College	list	Jersey	1

End of automatically generated list.