MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 29528

View and edit SQL

Suggested facets: Object Name, Artist Role, Artist Prefix, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
207513 60.66.12 0 1 334867 Drawings and Prints 11 Drawing 23 Three Angels Visiting Abraham           Artist|Former Attribution 54 Formerly attributed to Charles Meynier|Anonymous, German, 19th century French, Paris 1768–1832 Paris   Meynier, Charles|Anonymous, German, 19th century 17791 French|German 83 1768 |1800 1832 |1899 1793 1793 1793 Pen and brown ink, brush and brown wash. 29528 6 3/4 x 8 3/4 in. (17.2 x 22.3 cm) Gift of Harry G. Friedman, 1960                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
208269 29.100.933 0 1 335628 Drawings and Prints 11 Drawing 23 Interior of a Picture Gallery           Artist 2 Attributed to Hans Jordaens III Flemish, Antwerp ca. 1595–1643 Antwerp   Jordaens, Hans III 18153 Flemish 87 1595 1643 ca. 1620 1615 1625 Pen and brown ink, brush and brown wash. 29528 7 7/8 x 9 7/8 in. (20 x 25.1 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
208403 52.567.7 0 1 335766 Drawings and Prints 11 Drawing 23 Design for a Book Illustration: a Man Approaching a Woman Playing a Harp           Artist 2   Anonymous, German, 19th century     Anonymous, German, 19th century 17786 German 10 1800 1899 19th century 1800 1900 Pen and brown ink, brush and brown wash. 29528 3 5/8 x 2 11/16 in. (9.2 x 6.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1952                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
208696 50.605.41 0 1 336068 Drawings and Prints 11 Drawing 23 Judgment of Paris           Artist|Artist 13 After Adrien van der Bogaerts|Anonymous, Dutch, 17th century Dutch, active 1617–22 ? Bogaerts, Adrien van der|Anonymous, Dutch, 17th century 18328 Dutch|Dutch 290 1617 |1600 1622 |1700 17th century 1600 1699 Pen and brown ink, brush and brown wash. 29528 6 1/4 x 7 15/16 in. (15.9 x 20.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1950                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
210626 1979.131 0 1 338010 Drawings and Prints 11 Drawing Collection Ornament & Architecture 13830 Design for a Covered Vase with the Arms of the Aldobrandini and Pamphilj Families           Artist 2   Alessandro Algardi Italian, Bologna 1598–1654 Rome   Algardi, Alessandro 8588 Italian 6 1598 1654 ca. 1647 1598 1654 Pen and brown ink, brush and brown wash. 29528 12-5/16 x 7-7/8 in. (31.3 x 20.0 cm) Harry G. Sperling Fund, 1979                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
212485 80.3.448 0 1 339879 Drawings and Prints 11 Drawing 23 Sketch for Adoration of the Kings           Artist 2   Anonymous, French, 17th century     Anonymous, French, 17th century 17516 French 2 1600 1700 17th century 1600 1699 Pen and brown ink, brush and brown wash. 29528 7 3/16 x 9 11/16 in. (18.2 x 24.6 cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
218796 40.93.5 0 1 346304 Drawings and Prints 11 Drawing 23 Ornamental Drawing, with St. John the Evangelist Seated in a Columned Niche, with Two Putti           Artist 2 Attributed to Anonymous, Italian, late 16th century     Anonymous, Italian, 16th century late 22116 Italian 6 1550 1600 1550–1600 1550 1600 Pen and brown ink, brush and brown wash. 29528 sheet: 10 13/16 x 8 1/16 in. (27.5 x 20.4 cm) Miss Anna E. Roelker, 1940                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
235926 63.712.92 0 1 363757 Drawings and Prints 11 Drawing 23 Ornamental Designs After Antique Vases           Artist 2 After Bernardino Poccetti Italian, San Marino di Valdelsa 1548–1612 Florence   Poccetti, Bernardino 19399 Italian 6 1548 1612 1548–1612 1548 1612 Pen and brown ink, brush and brown wash. 29528 4 15/16 x 7 5/8 in. (12.5 x 19.4 cm) Mrs. Regina Slatkin, 1963                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
255727 80.3.55 0 1 384395 Drawings and Prints 11 Drawing 23 Statue of a Draped Female Figure           Artist 2   Anonymous, Italian, 17th century     Anonymous, Italian, 17th century 18709 Italian 6 1600 1700 17th century 1600 1699 Pen and brown ink, brush and brown wash. 29528 sheet: 7 1/16 x 3 3/8 in. (17.9 x 8.6 cm) Gift of Cornelius Vanderbilt, 1880                       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 131.208ms · Data license: CC0 · Data source: metmuseum/openaccess