MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Medium = 38659

View and edit SQL

Suggested facets: Portfolio, 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, Credit Line

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
242907 24.63.875 0 0 371079 Drawings and Prints 11 Print 731 Christ at Emmaus           Publisher|Artist|Artist 878 Published by|Engraved by|After Pieter Soutman|Pieter Van Sompel|Peter Paul Rubens Dutch, ca. 1580–1657|Dutch, ca. 1600–ca. 1643|Flemish, Siegen 1577–1640 Antwerp   Soutman, Pieter|Sompel, Pieter Van|Rubens, Peter Paul 34031 Dutch|Dutch|Flemish 1821 1580 |1600 |1577 1657 |1643 |1640 1643 1643 1643 Engraving and etching; third state of three 38659 sheet: 14 1/2 x 13 1/16 in. (36.8 x 33.1 cm) plate: 14 5/16 x 12 7/8 in. (36.3 x 32.7 cm) Gift of Georgiana W. Sargent, in memory of John Osborne Sargent, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
242979 51.501.6674 0 0 371154 Drawings and Prints 11 Print 731 Frederik Hendrik of Nassau, Prince of Orange, from the series of the Princes of Nassau         Princes of Nassau 886 Artist and publisher|Artist 1288 Engraved by Pieter Soutman|Jonas Suyderhoef Dutch, ca. 1580–1657|Dutch, Haarlem ca. 1613–1686 Haarlem   Soutman, Pieter|Suyderhoef, Jonas 34036 Dutch|Dutch 290 1580 |1613 1657 |1686 1643 1643 1643 Engraving and etching; third state of three 38659 sheet: 17 3/8 x 14 1/4 in. (44.1 x 36.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
243005 51.501.6645(10) 0 0 371180 Drawings and Prints 11 Print 731 St. Odulf, from the series Saints of North and South Netherlands         Saints of North and South Netherlands 898 Artist and publisher|Artist 1288 Engraved by Pieter Soutman|Cornelis Visscher Dutch, ca. 1580–1657|Dutch, Haarlem (?) 1629–1658 Amsterdam   Soutman, Pieter|Visscher, Cornelis 34067 Dutch|Dutch 290 1580 |1629 1657 |1658 1650 1650 1650 Engraving and etching; third state of three 38659 sheet: 17 1/16 x 11 3/4 in. (43.3 x 29.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
243056 41.101.2(8) 0 0 371231 Drawings and Prints 11 Print 731 Gertrude from the series Counts and Countesses of Holland, Zeeland, and West-Frisia         Counts and Countesses of Holland, Zeeland, and West-Frisia 899 Artist and publisher|Artist|Author 4091 Engraved by|Written by Pieter Soutman|Cornelis Visscher|Petrus Scriverius Dutch, ca. 1580–1657|Dutch, Haarlem (?) 1629–1658 Amsterdam   Soutman, Pieter|Visscher, Cornelis|Scriverius, Petrus 34070 Dutch|Dutch|Dutch 789 1580 |1629 1657 |1658 1650 1650 1650 Engraving and etching; third state of three 38659 sheet: 20 9/16 x 15 in. (52.2 x 38.1 cm) plate: 16 1/16 x 11 3/4 in. (40.8 x 29.8 cm) Gift of Mrs. Hugo Elliot, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
243072 56.524.2 0 0 371247 Drawings and Prints 11 Print 731 William III, from the series Counts and Countesses of Holland, Zeeland, and West-Frisia         Counts and Countesses of Holland, Zeeland, and West-Frisia 899 Artist and publisher|Artist 1288 Engraved by Pieter Soutman|Cornelis Visscher Dutch, ca. 1580–1657|Dutch, Haarlem (?) 1629–1658 Amsterdam   Soutman, Pieter|Visscher, Cornelis 34067 Dutch|Dutch 290 1580 |1629 1657 |1658 1650 1650 1650 Engraving and etching; third state of three 38659 plate: 15 3/4 x 11 9/16 in. (40 x 29.4 cm) sheet: 16 3/4 x 12 1/2 in. (42.6 x 31.8 cm) Museum Accession, 1956                       Prints 13   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 127.658ms · Data license: CC0 · Data source: metmuseum/openaccess