Museum Collection Coverage #6
Description
By this query of all the Van Gogh's in our database, it looks like we have pretty poor coverage.
$ dolt sql -q "SELECT institution_name, institution_city, title FROM objects where maker_full_name like '%Van Gogh%'"
+----------------------------+------------------+------------------------------------------------------------+
| institution_name | institution_city | title |
+----------------------------+------------------+------------------------------------------------------------+
| Albertina | Vienna | Landschaft mit Haus und Bäumen |
| Albertina | Vienna | Friedhof im Regen |
| Orsay Museum | Paris | Eugène Boch |
| Orsay Museum | Paris | Portrait de l'artiste |
| Orsay Museum | Paris | Le Docteur Paul Gachet |
| Orsay Museum | Paris | Portrait de l'artiste |
| Orsay Museum | Paris | Vaches dans un pré |
| Orsay Museum | Paris | La Salle de danse à Arles |
| Orsay Museum | Paris | L'église d'Auvers-sur-Oise, vue du chevet |
| Orsay Museum | Paris | La Méridienne |
| Orsay Museum | Paris | L'Arlésienne |
| Orsay Museum | Paris | Roses et anémones |
| Orsay Museum | Paris | Mademoiselle Gachet dans son jardin à Auvers-sur-Oise |
| Orsay Museum | Paris | Chaumes de Cordeville à Auvers-sur-Oise |
| Orsay Museum | Paris | Dans le jardin du docteur Paul Gachet |
| Orsay Museum | Paris | Deux fillettes |
| Orsay Museum | Paris | Tête de paysanne hollandaise |
| Orsay Museum | Paris | La Chambre de Van Gogh à Arles |
| Orsay Museum | Paris | L'Italienne |
| Orsay Museum | Paris | Hôpital Saint-Paul à Saint-Rémy-de-Provence |
| Orsay Museum | Paris | La Nuit étoilée |
| Orsay Museum | Paris | Paysanne près de l'âtre |
| Orsay Museum | Paris | Fritillaires couronne impériale dans un vase de cuivre |
| Orsay Museum | Paris | La Guinguette à Montmartre |
| Orsay Museum | Paris | Le Restaurant de la Sirène à Asnières |
| Orsay Museum | Paris | Les Roulottes, campement de bohémiens aux environs d'Arles |
| Orsay Museum | Paris | Palette de Vincent Van Gogh |
| Orsay Museum | Paris | Portrait du Docteur Gachet |
| Rijksmuseum | Amsterdam | Brief aan Pieter Haverkorn van Rijsewijk |
| Victoria and Albert Museum | London | The fortifications of Paris |
+----------------------------+------------------+------------------------------------------------------------+
I think some sort of coverage report and a "Most desired collections" list would be a good thing. Maybe use it in another bounty. Like only pay for museums on the "most desired list".