MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

21 rows where Artist Role = 2, Classification = 325 and Department = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Culture, 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

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 Metadata Date Repository
321841 321841 1975.1.1421 0 1 459960 Robert Lehman Collection 16 Chandelier 207 Chandelier with tabernacle (Kapellenkrone) German, Munich 128         Artist 2 German, cast in F. Ring Foundry   , Munich F. Ring Foundry 44512       ca. 1875 after a dinanderie model from the Southern Netherlands, ca. 1450 1872 1878 Brass 12 H. 106 cm, L. of long branches 41 cm, L. of short branches 19 cm Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/459960 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322286 322286 1975.1.1382 0 1 460444 Robert Lehman Collection 16 Candlestick 163 Altar candlestick (pair with 1975.1.1383)           Artist 2   Andrea di Alessandri, called Il Bresciano Italian, Brescia ca. 1530–ca. 1569 Venice   di Alessandri, Andrea , called Il Bresciano 44550   1550 1575 ca. 1565 1562 1568 Copper alloy with a thick black varnish patina. 48319 H. 62 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460444 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322288 322288 1975.1.1383 0 1 460446 Robert Lehman Collection 16 Candlestick 163 Altar candlestick           Artist 2   Andrea di Alessandri, called Il Bresciano Italian, Brescia ca. 1530–ca. 1569 Venice   di Alessandri, Andrea , called Il Bresciano 44550   1550 1575 ca. 1565 1562 1568 Copper alloy with a thick black varnish patina. 48319 H. 62 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460446 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322292 322292 1975.1.1389 0 1 460450 Robert Lehman Collection 16 Candelabra 7332 Candlestick in the Form of a Kneeling Angel           Artist 2 Close collaborator of Giambologna Netherlandish, Douai 1529–1608 Florence , possibly Hans Reichle (German, Schongau 1570–1642 South Tyrol) Giambologna 7987 Netherlandish 179 1529 1608 ca. 1590–1600 1587 1603 Reddish copper alloy covered with a natural, warm brown patina 48321 H. 27.5 cm Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460450 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322293 322293 1975.1.1390 0 1 460451 Robert Lehman Collection 16 Candelabra 7332 Candlestick in the Form of a Kneeling Angel           Artist 2 Close collaborator of Giambologna Netherlandish, Douai 1529–1608 Florence , possibly Hans Reichle (German, Schongau 1570-1642 South Tyrol) Giambologna 7987 Netherlandish 179 1529 1608 ca. 1590–1600 1587 1603 Reddish copper alloy covered with a natural, warm brown patina. 48322 H. 27.5 cm Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460451 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322294 322294 1975.1.1391 0 1 460452 Robert Lehman Collection 16 Figure 9 Warrior on Horseback           Artist 2 Attributed to Desiderio da Firenze Italian, born Florence, active Padua, 1532–45   Firenze, Desiderio da 44551 Italian 6 1532 1545 ca. 1540 1537 1543 Ternary alloy of copper, zinc and tin, with small traces of lead, iron, nickel, silver, and antimony (both horse and rider); Black lacquer patina under a chocolate brown patina (on both horse and rider); the eyes of the horse are inlaid with silver. 48323 H. 25.8 cm (excluding the modern, green marble base). Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460452 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322297 322297 1975.1.1396 0 1 460455 Robert Lehman Collection 16 Incense burner 4170 Perfume Burner Surmounted by a Satyr           Artist 2 Workshop of Desiderio da Firenze Italian, born Florence, active Padua, 1532–45   Firenze, Desiderio da 44551 Italian 6 1532 1545 ca. 1530–40 1527 1543 Binary alloy (copper, tin, with traces of zinc, iron, nickel, silver, and antimony); a brown to olive green patina and minor traces of gilding. 48326 H. overall 50 cm, h. of base 10.5 cm; h. of middle section, including bajonet joint, 15.5 cm; h. of cover, including the bajonet joint 26.4 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460455 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322298 322298 1975.1.1397 0 1 460456 Robert Lehman Collection 16 Incense burner 4170 Perfume Burner Surmounted by a Satyr           Artist 2 Workshop of Desiderio da Firenze Italian, born Florence, active Padua, 1532–45   Firenze, Desiderio da 44551 Italian 6 1532 1545 ca. 1540–50 1537 1553 The cover and body are binary bronze (copper and tin, with traces of zinc, iron, nickel, silver, and antimony); the foot is cast in brass (copperzinc alloy with very minor amounts of tin, lead, and the usual copper impurities of iron, nickel, silver, and antimony). 48327 H. overall 46.5 cm, h. of base 6.9 cm, h. of middle section, including bajonet joint 15.1 cm, h. of cover 25.7 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460456 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322299 322299 1975.1.1401 0 1 460457 Robert Lehman Collection 16 Sculpture 100 Neptune           Artist 2 Attributed to Pietro da Barga Italian, Florence, active 1574–88   Barga, Pietro da 11099 Italian 6 1574 1588 ca. 1580 1577 1583 Copper alloy with light brown patina under a verdigris patina. 48328 H. 28.3 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460457 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322301 322301 1975.1.1426 0 1 460459 Robert Lehman Collection 16 Censer 3914 Censer with elephant-shaped handles Chinese 10         Artist 2   Chinese   , Qing Dynasty Chinese 44503       1644–1911 1644 1911 Bronze with treated surface. 48330 Diameter: 11.4 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460459 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322302 322302 1975.1.1427 0 1 460460 Robert Lehman Collection 16 Censer 3914 Censer Chinese 10         Artist 2   Chinese   , Qing Dynasty Chinese 44503       ca. 18th century 1697 1803 Bronze with treated surface. 48330 Diameter: 13 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460460 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322398 322398 1975.1.1428 0 1 460557 Robert Lehman Collection 16 Censer 3914 Censer Chinese 10         Artist 2   Chinese   , Qing Dynasty Chinese 44503       19th to early 20th century 1800 1935 Bronze. 48387 Height (with handle): 35 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460557 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322648 322648 1975.1.1425 0 1 460812 Robert Lehman Collection 16 Censer 3914 Censer Chinese 10         Artist 2   Chinese   , Qing Dynasty Chinese 44503       19th century 1800 1900 Brass. 48542 H. 19 cm. Diameter: 32.7 cm. Robert Lehman Collection, 1975 1975.1.1425                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460812 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322819 322819 1975.1.1394 0 1 460991 Robert Lehman Collection 16 Sculpture 100 Satyress and her Infant           Artist 2 Workshop of Severo Calzetta da Ravenna Italian, active by 1496, died before 1543   Ravenna, Severo Calzetta da 8693 Italian 6 1496 1543 ca. 1520 or later 1520 1575 Bronze, light reddish brown patina. 48640 H. 23 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460991 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322822 322822 1975.1.1393 0 1 460994 Robert Lehman Collection 16 Sculpture 100 Satyress and her Infant           Artist 2 Workshop of Severo Calzetta da Ravenna Italian, active by 1496, died before 1543   Ravenna, Severo Calzetta da 8693 Italian 6 1496 1543 ca. 1520 or later 1520 1575 Indirect cast; copper alloy, dark brown with areas of black patina. 48642 H. 25.5 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/460994 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322980 322980 1975.1.1386 0 1 461153 Robert Lehman Collection 16 Sculpture 100 Crouching Boar (Il Porcellino)           Artist 2 Follower of Pietro Tacca Italian, Carrara 1577–1640 Florence   Tacca, Pietro 8394 Italian 6 1577 1640 late 17th or early 18th century 1676 1735 Bronze, dark patina and black varnish. 48706 H. 16.5 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/461153 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323025 323025 1975.1.1405 0 1 461198 Robert Lehman Collection 16 Andiron 12 Andiron with the Figure of Juno           Artist 2 Model, workshop of Niccolò Roccatagliata Italian, born Genoa, active 1593–1636 (?), Venice Roccatagliata, Niccolò 8721 Italian 6 1593 1636 17th century or later 1600 1700 Bronze, dark brown wax or lacquer patina. 48722 H. 92.5 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/461198 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323113 323113 1975.1.1400 0 1 461290 Robert Lehman Collection 16 Sculpture 100 Cupid on Horseback           Artist 2   Francesco Fanelli Italian, born Florence, active Genoa, England and Paris, 1608–65   Fanelli, Francesco 9493 Italian 6 1608 1665 before 1639 (model), 1640–64 (cast) 1600 1664 Copper alloy, covered with a dark brown lacquer patina. 48773 H. 15.3 cm, l. 20.4 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/461290 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323138 323138 1975.1.1399 0 1 461316 Robert Lehman Collection 16 Inkwell 528 Inkwell in the Form of Atlas Holding a Globe           Artist 2 Workshop of Severo Calzetta da Ravenna Italian, active by 1496, died before 1543   Ravenna, Severo Calzetta da 8693 Italian 6 1496 1543 first half 16th century or later 1500 1600 Copper alloy 4107 H. 23.8 cm. Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/461316 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323285 323285 1975.1.1402 0 1 461463 Robert Lehman Collection 16 Sculpture 100 Angel           Artist 2   Ludovico del Duca Italian, Rome, active 1551 (?)–died after 1603   del Duca, Ludovico 44625 Italian, Rome 3402 1551 1603 ca. 1590–1600 1587 1603 Copper alloy, with brown patina under a grayish lacquer and various spots of bright green corrosion 48830 H. 13.5 cm (excluding green marble base). Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/461463 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323286 323286 1975.1.1406 0 1 461464 Robert Lehman Collection 16 Andiron 12 Andiron with the Figure of Jupiter           Artist 2 Model, workshop of Niccolò Roccatagliata Italian, born Genoa, active 1593–1636 (?), Venice Roccatagliata, Niccolò 8721 Italian 6 1593 1636 17th century or later 1600 1700 Bronze, dark brown wax or lacquer patina. 48722 H. 90.5 cm Robert Lehman Collection, 1975                       Metalwork-Bronze 325   http://www.metmuseum.org/art/collection/search/461464 4/23/2018 8:00:01 AM 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 394.889ms · Data license: CC0 · Data source: metmuseum/openaccess