MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Medium = 29392

View and edit SQL

Suggested facets: Is Highlight, Department, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date

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 Repository
207298 37.165.107 1 1 334650 Drawings and Prints 11 Drawing 23 Head of a Man           Artist 2   Antoine Watteau French, Valenciennes 1684–1721 Nogent-sur-Marne   Watteau, Antoine 9446 French 2 1684 1721 ca. 1718 1710 1721 Red and black chalk 29392 5 7/8 x 5 3/16 in. (14.9 x 13.1 cm) Rogers Fund, 1937                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
208058 1970.736.65 0 1 335416 Drawings and Prints 11 Drawing 23 Study for a Mantel and Overmantel           Artist|Former Attribution 54 Formerly attributed to Laurent Hubert|Juste Aurèle Meissonnier French, died ca. 1780|French, Turin 1695–1750 Paris   Hubert, Laurent|Meissonnier, Juste-Aurèle 18073 French|French 21 1780 |1695 1780 |1750 n.d. 1690 1785 Red and black chalk 29392 14 1/8 x 7 7/8 in. (35.9 x 20 cm.) Gift of Mr. and Mrs. Charles Wrightsman, 1970                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
208455 66.759.3 0 1 335818 Drawings and Prints 11 Drawing 23 Design for the Headpiece of the "Gazette de France"           Artist 2   Hubert François Gravelot French, Paris 1699–1773 Paris   Gravelot, Hubert François 18083 French 2 1699 1773   1699 1773 Red and black chalk 29392 7 7/8 x 5 in. (20 x 12.7 cm.) Rogers Fund, 1966                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211056 1994.268 0 1 338444 Drawings and Prints 11 Drawing 23 Youth Gazing Upwards in Profile.           Artist 2   Francesco Montelatici ("Cecco Bravo") Italian, Florence 1601–1661 Innsbruck   Montelatici, Francesco 19094 Italian 6 1601 1661 1607–61 1607 1661 Red and black chalk 29392 7 11/16 x 7 7/8in. (19.5 x 20cm) Van Day Truex Fund, 1994                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
212454 1978.12.1 0 1 339848 Drawings and Prints 11 Drawing 23 Standing Savoyarde with a Marmot Box           Artist 2   Antoine Watteau French, Valenciennes 1684–1721 Nogent-sur-Marne   Watteau, Antoine 9446 French 2 1684 1721 ca. 1715 1710 1720 Red and black chalk 29392 12 5/16 x 8 in. (31.2 x 20.3 cm) Bequest of Therese Kuhn Straus, in memory of her husband, Herbert N. Straus, 1978                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213729 1978.276 0 1 341148 Drawings and Prints 11 Drawing 23 Portrait of a Man: Francesco Albani ?           Artist 2   Andrea Sacchi Italian, Rome (?) ca. 1599–1661 Rome   Sacchi, Andrea 19871 Italian 6 1599 1661 1599–1661 1599 1661 Red and black chalk 29392 3 3/4 x 2 3/4in. (9.5 x 7cm) Harry G. Sperling Fund, 1978                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
215737 1983.1132 0 1 343162 Drawings and Prints 11 Drawing 23 Design for Fantasy Branches of Flowers           Artist 2   Jean Pillement French, Lyons 1728–1808 Lyons   Pillement, Jean 1682 French 2 1728 1808 n.d. 1740 1808 Red and black chalk 29392 8 3/32 x 8 5/32 in. (20.6 x 20.7 cm) Purchase, Leon Lowenstein Foundation Inc. Gift, 1983                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
234256 68.729.5 0 1 362012 Drawings and Prints 11 Drawing 23 The Arming of Bellona           Artist|Former Attribution 54 Formerly attributed to Laurent Hubert|Juste Aurèle Meissonnier French, died ca. 1780|French, Turin 1695–1750 Paris   Hubert, Laurent|Meissonnier, Juste-Aurèle 18073 French|French 21 1780 |1695 1780 |1750 18th century 1675 1785 Red and black chalk 29392 15 7/8 x 21 1/8 in. (40.4 x 53.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
243362 2006.219.1 0 1 371558 Drawings and Prints 11 Drawing 23 Deacon Saint (Stephen or Lawrence)           Artist 2   Jacopo Confortini Italian, Florence 1602–1672 Florence   Confortini, Jacopo 19133 Italian 6 1602 1672 ca. 1640–50 1635 1655 Red and black chalk 29392 sheet: 9 x 6 15/16 in. (22.8 x 17.6 cm) Gift of Thomas and Gianna le Claire, 2006                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
253921 2008.231 0 1 382502 Drawings and Prints 11 Drawing 23 Portrait of Henry VII           Artist 2   Anonymous, Italian, 16th century     Anonymous, Italian, 16th century 19618 Italian 6 1500 1600 16th century 1500 1599 Red and black chalk 29392 sheet: 7 1/8 x 5 3/8 in. (18.1 x 13.6 cm) Purchase, C. G. Boerner Gift, 2008                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
258379 2010.158 0 1 387073 Drawings and Prints 11 Drawing 23 Cleopatra           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 1647 1647 1647 Red and black chalk 29392 sheet: 12 5/8 x 8 1/2 in. (32 x 21.6 cm) Purchase, Charles and Jessie Price and Mrs. Howard J. Barnet Gifts, 2010                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
270020 2012.52 0 1 399145 Drawings and Prints 11 Drawing 23 Studies of the Dead Christ supported by an Angel, with subsidiary studies for the same composition           Artist 2   Poppi (Francesco Morandini) Italian, Poppi 1544–1597 Florence   Poppi (Francesco Morandi) 18950 Italian 6 1544 1597 ca. 1570 1565 1575 Red and black chalk 29392 sheet: 14 7/16 x 10 5/16 in. (36.6 x 26.2 cm) Harry G. Sperling Fund, 2012                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
272628 87.12.147 0 1 401791 Drawings and Prints 11 Drawing 23 Death of Saint Joseph           Artist 2   Anonymous, Italian     Anonymous, Italian 26302 Italian 6 1400 2050   1550 1750 Red and black chalk 29392 20 1/2 x 11 5/8 in. (52 x 29.6 cm) Gift of Cephas G. Thompson, 1887                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
292328 2013.107 0 1 421661 Drawings and Prints 11 Drawing 23 Study of a Female Nude, Seated           Artist 2   George Richmond British, Brompton 1809–1896 London   Richmond, George 26145 British 7 1809 1896 1870–79 (?) 1870 1879 Red and black chalk 29392 Sheet: 8 7/16 x 11 1/4 in. (21.5 x 28.5 cm) Purchase, Brooke Russell Astor Bequest, 2013                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321416 1975.1.655 0 1 459385 Robert Lehman Collection 16 Drawing 23 Seated Woman in Profile           Artist 2   Nicolas Bernard Lépicié French, Paris 1735–1784 Paris   Lépicié, Nicolas Bernard 18791 French 2 1735 1784 1774 1774 1774 Red and black chalk 29392 8 1/2 x 7 5/8 in. (21.6 x 19.4 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
382207 2014.460 0 1 631142 Drawings and Prints 11 Drawing 23 A Nude Male Seen from the Back in Clouds (after Michelangelo Buonarroti)           Artist|Artist 13 after Daniel Fröschl|Michelangelo Buonarroti German, Augsburg 1563–1613 Prague|Italian, Caprese 1475–1564 Rome   Fröschl, Daniel|Michelangelo Buonarroti 49128 German|Italian 348 1563 |1475 1613 |1564 1602 (?) 1602 1602 Red and black chalk 29392 Sheet: 7 1/4 × 5 1/2 in. (18.4 × 13.9 cm) Purchase, Ian Woodner Family Collection, Mary Oenslager, and Karen B. Cohen Funds, 2014                       Drawings 9   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 118.28ms · Data license: CC0 · Data source: metmuseum/openaccess