MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Role = 55 and Department = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Artist Nationality, Classification

Department ✖

  • Robert Lehman Collection · 11 ✖

Artist Role ✖

  • Former Attribution|Artist · 11 ✖
Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
320987 320987 1975.1.15 0 1 458955 Robert Lehman Collection 16 Painting 69 Saint Peter Italian, Siena 123         Former Attribution|Artist 55   Follower of Barna da Siena|Follower of Lippo Memmi (Italian, Sienese, active mid-14th century) Sienese, active mid-14th century   Siena, Barna da|Memmi, Lippo, Follower of (Italian, Sienese, active 44323 Sienese|Italian 3373 1350 |1329 1350 |1369 mid-14th century 1336 1370 Tempera on wood, gold ground 44477 Overall, with original side and bottom moldings, 17 5/8 x 10 7/8 in. (44.8 x 27.6 cm) Robert Lehman Collection, 1975                       Paintings 11   http://www.metmuseum.org/art/collection/search/458955 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321243 321243 1975.1.632 0 0 459212 Robert Lehman Collection 16 Drawing 23 Hiro and the Virgin (after Paul Gauguin)           Former Attribution|Artist 55   Paul Gauguin|Henri de Monfried French, Paris 1848–1903 Atuona, Hiva Oa, Marquesas Islands|Le Franqui 1879–Ingrandes 1974   Gauguin, Paul|Monfried, Henri de 44393 French|French 21 1848 |1879 1903 |1974 1914–17 1914 1917 Watercolor, ink and graphite on off-white wove paper mounted on Bristol board 47801 6 5/16 x 9 1/2 in. (16 x 24.2 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459212 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321248 321248 1975.1.629 0 1 459217 Robert Lehman Collection 16 Drawing 23 Landscape with Road and Monument           Former Attribution|Artist 55 Imitator of Jean Honoré Fragonard|Jean Honoré Fragonard French, Grasse 1732–1806 Paris|French, Grasse 1732–1806 Paris   Fragonard, Jean Honoré|Fragonard, Jean Honoré 44395 French|French 21 1732 |1732 1806 |1806 mid-18th century–early 19th century 1736 1835 Pencil and pale sepia wash 47804 6 3/16 x 8 3/4 in. (15.7 x 22.3 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459217 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321353 321353 1975.1.786 0 1 459322 Robert Lehman Collection 16 Drawing 23 Christ among the Doctors           Former Attribution|Artist 55   Nicolaes Maes|School of Rembrandt van Rijn Dutch, Dordrecht 1634–1693 Amsterdam|Dutch, 1606–1669   Maes, Nicolaes|Rembrandt, van Rijn, School of 44421 Dutch 11 1634 |1606 1693 |1669 ca. 1652 1649 1655 Pen and brush and brown ink. 47881 8 7/8 x 7 in. (22.6 x 17.8 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459322 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321377 321377 1975.1.809 0 1 459346 Robert Lehman Collection 16 Drawing 23 A Seated Huntsman           Former Attribution|Artist 55   Gesina ter Borch|Gerard ter Borch the Younger Dutch, Zwolle 1633–1690 Zwolle|Dutch, Zwolle 1617–1681 Deventer   Borch, Gesina ter|Borch, Gerard ter, the Younger 44424 Dutch|Dutch 290 1633 |1617 1690 |1681 1672 1672 1672 Black chalk 29155 10 9/16 x 7 3/16 in. (26.8 x 18.3 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459346 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321393 321393 1975.1.659 0 1 459362 Robert Lehman Collection 16 Drawing 23 Trees           Former Attribution|Artist 55 French artist in the circle of Claude Lorrain (Claude Gellée)|Giovanni Francesco Grimaldi French, Chamagne 1604/5?–1682 Rome|Italian, Bologna 1606–1680 Rome   Claude Lorrain (Claude Gellée)|Grimaldi, Giovanni Francesco 44430 French|Italian 247 1604 |1606 1682 |1680 ca. 1650 1650 1650 Pen, sepia ink and wash with white gouache heightening on blue paper 47915 7 7/8 x 10 1/4 in. (20 x 26 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459362 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321473 321473 1975.1.544 0 1 459442 Robert Lehman Collection 16 Drawing 23 Head of a Bearded Man           Former Attribution|Artist 55   Paolo Veronese (Paolo Caliari)|School of Paolo Veronese Italian, Verona 1528–1588 Venice|Venice, ca. 1548–1588   Veronese, Paolo (Paolo Caliari)|Veronese, Paolo, School of 44456 Italian|Venice 3384 1528 |1548 1588 |1588 ca. 1565 1562 1568 Black chalk, heightened with white, on greenish blue paper. 47970 10 5/16 x 7 7/8 in. (26.2 x 20 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459442 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321501 321501 1975.1.409 0 1 459470 Robert Lehman Collection 16 Drawing 23 A Seated Saint Reading from a Book           Former Attribution|Artist 55 Attributed to Alesso Baldovinetti|Francesco Botticini (Francesco di Giovanni) Italian, Florence 1425–1499 Florence|Italian, Florentine, ca. 1446–1497   Baldovinetti, Alesso|Botticini, Francesco (Francesco di Giovanni) 44469 Italian 6 1425 |1446 1499 |1497 late 15th century 1471 1500 Brush and brown ink, brown wash, heightened with white (partly oxidized); horizontal lines in black chalk (?); pricked for transfer; outlines reinforced in brown ink, perhaps in the 15th or early 16th century. 47988 10 1/4 x 6 3/8 in. (26.1 x 16.2 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459470 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321833 321833 1975.1.336 0 1 459952 Robert Lehman Collection 16 Drawing 23 Presumed Portrait of Jacopo Alvarotto           Former Attribution|Artist 55   Benozzo Gozzoli (Benozzo di Lese di Sandro)|Unidentified Artist Italian, Florence ca. 1420–1497 Pistoia|Italian, Venice (?), 18th century   Gozzoli, Benozzo (Benozzo di Lese di Sandro)|Unidentified Artist 44510 Italian 6 1420 1497 probably 18th century 1798 1802 Black chalk, brown wash 48129 10 5/8 x 7 13/16 in. (27 x 19.8 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459952 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321870 321870 1975.1.585 0 1 460021 Robert Lehman Collection 16 Drawing 23 Landscape           Former Attribution|Artist 55 In the manner of Camille Corot|Camille Corot French, Paris 1796–1875 Paris|French, Paris 1796–1875 Paris   Corot, Camille|Corot, Camille 44516 French|French 21 1796 |1796 1875 |1875 1855–75(?) 1850 1875 Fixative over charcoal highlighted by erasures on tan wove paper 48157 12 5/8 x 16 5/8 in. (32.1 x 42.3 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/460021 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321881 321881 1975.1.977 0 1 460032 Robert Lehman Collection 16 Drawing 23 Bullfight Spanish 13         Former Attribution|Artist 55   Velázquez (Diego Rodríguez de Silva y Velázquez)|Eugenio Lucas y Padilla Spanish, Seville 1599–1660 Madrid|Spanish, 1824–1870   Velázquez (Diego Rodríguez de Silva y Velázquez)|Lucas y Padilla, Eugenio 44519 Spanish|Spanish 85 1599 |1824 1660 |1870 19th century 1800 1900 Brush and black ink with wash 48167 5 5/8 x 8 11/16 in. (14.3 x 22 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/460032 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 390.056ms · Data license: CC0 · Data source: metmuseum/openaccess