MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Object Name = 13875

View and edit SQL

Suggested facets: Is Public Domain, Medium, 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
216687 37.19.2(1-46) 0 0 344160 Drawings and Prints 11 Book Collection Ornament & Architecture 13875 Album of Goldsmith's Designs by Hans Janssen           Engraver|Artist|Binder|Publisher 1448 Bound by|Published by Bartolomeus van Lochom|Hans Janssen|Leon Lemardeley|Claes Jansz. Visscher Dutch, 1607–after 1629|Dutch, 1605–after 1631|Dutch, Amsterdam 1586–1652 Amsterdam   Lochom, Bartolomeus van|Janssen, Hans|Lemardeley, Leon|Visscher, Claes Jansz. 20756 Dutch|Dutch|Dutch 789 1607 |1605 |1586 1629 |1631 |1652 ca. 1660 1655 1665 Engraving 7208 13 1/16 x 9 13/16 x 9/16 in. (33.2 x 25 x 1.5 cm) Harris Brisbane Dick Fund, 1937   Amsterdam 201                   Albums|Ornament & Architecture|Prints 695   Metropolitan Museum of Art, New York, NY 1
228991 21.67 0 0 356636 Drawings and Prints 11 Book Collection Ornament & Architecture 13875 Oeuvre de la Diversite des termes, dont on use en Architecture, reduict en ordre           Artist|Publisher|Printer 1061 Published by|Printed by Hugues Sambin|Jean Durant|Jean Marcorelle French, Gray ca. 1520–1601 Dijon|French   Sambin, Hugues|Durant, Jean|Marcorelle, Jean 29418 French|French|French 103 1520 1601 1572 1572 1572 Woodcut 26552 Overall: 12 3/8 x 8 1/4 x 3/8 in. (31.4 x 21 x 1 cm) Rogers Fund, 1921   Lyon 312                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
229217 49.69.7 0 0 356862 Drawings and Prints 11 Book Collection Ornament & Architecture 13875 Vases, Ecclesiastical ornaments and other metal works           Designer 5 Designed by Horatio Scoppa Italian, active Naples   Scoppa, Horatio 29580 Italian 6     1642 1642 1642     The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
231617 1991.1073.145(1–107) 0 1 359356 Drawings and Prints 11 Book Collection Ornament & Architecture 13875 Le Fontane di Roma (parts 1-4)           Publisher|Etcher|Etcher 3673 Views in parts 1 and 2 drawn and etched by|Views in parts 3 and 4 drawn and etched by Giovanni Giacomo De Rossi|Giovanni Battista Falda|Giovanni Francesco Venturini Italian, Rome 1627–1691 Rome|Italian, Valduggia 1643–1678 Rome|Italian, active ca. 1650–1700   Rossi, Giovanni Giacomo De|Falda, Giovanni Battista|Venturini, Giovanni Francesco 30946 Italian|Italian|Italian 145 1627 |1643 |1650 1691 |1678 |1700 1691 or after 1691 1691 Etching 26137 Overall: 11 x 15 7/8 x 1 5/16 in. (27.9 x 40.4 x 3.4 cm) Gift of D. W. Langton, transferred from the Library (1991.1073.145)                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
266709 2012.136.952(1–12) 0 0 395734 Drawings and Prints 11 Book Collection Ornament & Architecture 13875 Vases           Publisher|Artist and publisher|Publisher|Designer|Designer 4577 Previously by|Originally by Claes Jansz. Visscher|René Boyvin|Frederick de Wit|Polidoro da Caravaggio|Rosso Fiorentino Dutch, Amsterdam 1586–1652 Amsterdam|French, Angers ca. 1525–1598 or 1625/6 Angers|Dutch, 1629/30–1706|Italian, Caravaggio ca. 1499–ca. 1543 Messina|Italian, Florence 1494–1540 Fontainebleau ? Visscher, Claes Jansz.|Boyvin, René|de Wit, Frederick|Caravaggio, Polidoro da|Fiorentino, Rosso 39325 Dutch|French|Dutch|Italian|Italian 3062 1586 |1525 |1629 |1494 |1494 1652 |1598 |1706 |1548 |1540 17th century (late) 1670 1700 Engraving 7208 Overall: 11 1/8 x 8 3/8 in. (28.2 x 21.2 cm) Bequest of Phyllis Massar, 2011                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
285373 31.67.4(1-137) 0 0 414683 Drawings and Prints 11 Book Collection Ornament & Architecture 13875 Teatro Fabrich[e] di Roma           Designer|Publisher 1009 Designed by|Published by Giovanni Battista Falda|Giovanni Giacomo De Rossi Italian, Valduggia 1643–1678 Rome|Italian, Rome 1627–1691 Rome   Falda, Giovanni Battista|Rossi, Giovanni Giacomo De 24310 Italian|Italian 93 1643 |1627 1678 |1691 1665–69 1665 1669 Etching 26137 Overall: 11 x 15 15/16 x 1 7/16 in. (28 x 40.5 x 3.6 cm) Harris Brisbane Dick Fund, 1931   Rome 571                   Books|Ornament & Architecture 665   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 224.982ms · Data license: CC0 · Data source: metmuseum/openaccess