MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Artist Alpha Sort = 18404

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

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
208982 80.3.344 0 1 336358 Drawings and Prints 11 Drawing 23 A Dying Ecclesiastic Supported by an Angel           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1760–70 1760 1770 Pen and brown ink, brush and gray wash, over traces of black chalk 30225 7 13/16 x 5 3/4in. (19.9 x 14.6cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211428 62.132.3 0 1 338818 Drawings and Prints 11 Drawing 23 Alexander the Great Offering His Concubine Campaspe to the Painter Apelles           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1793–1797 1793 1797 Black chalk (stumped), highlighted with white, on brownish paper 31731 12-1/16 x 16-7/8 in. (30.6 x 42.9 cm) Rogers Fund, 1962                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211431 80.3.37 0 1 338821 Drawings and Prints 11 Drawing 23 A Martyr Saint Reading           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Pen and brown ink, brush and wash 31734 10 1/8 x 7 1/4in. (25.7 x 18.4cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211432 80.3.235 0 1 338822 Drawings and Prints 11 Drawing 23 The Holy Family           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Red chalk, highlighted with white, on beige paper 31410 9 7/8 x 7 15/16in. (25.1 x 20.2cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211433 80.3.236 0 1 338823 Drawings and Prints 11 Drawing 23 The Royal Family of Troy Mourning the Death of Hector           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Black chalk  31735 8 1/8 x 11 3/8in. (20.7 x 28.9cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211435 80.3.503 0 1 338825 Drawings and Prints 11 Drawing 23 Marcus Curtius Leaping into the Chasm           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Black chalk 29155 10 7/16 x 8in. (26.5 x 20.3cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211436 80.3.513 0 1 338826 Drawings and Prints 11 Drawing 23 Saint Margaret of Cortona, Saint James of the March, and Saint Didacus           Artist 2 Attributed to Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Pen and brown ink, brush and brown wash, over black chalk 29736 11 5/8 x 7 3/8in. (29.5 x 18.7cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211437 1987.177 0 1 338827 Drawings and Prints 11 Drawing 23 The Dutch Microscopist Anton van Leeuwenhoek           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Pen with black and brown ink, brush with brown and gray wash. Framing lines in black ink 31737 8 x 5 9/16in. (20.3 x 14.1cm) Purchase, Mrs. Carl L. Selden Gift, in memory of Carl L. Selden, 1987                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211438 1989.108.1 0 1 338828 Drawings and Prints 11 Drawing 23 Seated Prophet           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1779 1779 1779 Black chalk (stumped), brush and gray wash, highlighted with white, on beige paper 31738 16-5/8 x 12-5/16 in. (42.2 x 31.2 cm) Gift of Jacob Bean, in memory of Donald P. Gurney, 1989                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
211439 1989.108.2 0 1 338829 Drawings and Prints 11 Drawing 23 Joshua           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1779 1779 1779 Black chalk (stumped), brush and gray wash, highlighted with white chalk, on beige paper 31739 16-5/8 x 12-7/16 in. (42.3 x 31.6 cm) Gift of Jacob Bean, in memory of Donald P. Gurney, 1989                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
234170 51.501.4918 0 0 361923 Drawings and Prints 11 Print 731 Child Bacchus on a Barrel           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1750–1802 1750 1802 Etching 26137   The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234178 60.611.66 0 1 361931 Drawings and Prints 11 Print 731 Rape of Persephone           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 ca. 1755–90 1750 1760 Etching 26137 Plate: 2 3/4 x 4 5/16 in. (7 x 11 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960                       Prints 13   Metropolitan Museum of Art, New York, NY 1
266519 2012.98.8 0 1 395502 Drawings and Prints 11 Drawing 23 Three Female Heads           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1734–1802 1734 1802 Pen and brown ink 25596 sheet: 7 15/16 x 10 1/4 in. (20.2 x 26 cm) Bequest of Anna Mont, in memory of Frederick Mont, 2010                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
308160 2010.117 0 1 440847 European Paintings 15 Painting 69 Head of a Bishop           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 ca. 1770 1765 1775 Oil on canvas 953 18 3/8 x 14 7/8 in. (46.7 x 37.8 cm) Purchase, Charles and Jessie Price and Stephen Mazoh Gifts, 2010                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
407385 2015.46 0 1 665702 European Paintings 15 Painting 69 The Sacrifice of Iphigenia           Artist 2   Gaetano Gandolfi Italian, San Matteo della Decima 1734–1802 Bologna   Gandolfi, Gaetano 18404 Italian 6 1734 1802 1789 1789 1789 Oil on canvas 953 26 7/8 × 18 in. (68.3 × 45.7 cm) Rogers Fund, 2015                       Paintings 11   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 136.355ms · Data license: CC0 · Data source: metmuseum/openaccess