MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Role = 1 and Object Name = 3917

View and edit SQL

Suggested facets: Is Public Domain, 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, Classification

Artist Role

  • Maker · 9
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
103693 09.215 0 1 191254 European Sculpture and Decorative Arts 3 Relief 3917 Virgin and Child Italian 36         Maker 1 Follower of Andrea del Verrocchio Italian, Florence 1435–1488 Venice   Verrocchio, Andrea del 8668 Italian 6 1435 1488 15th century 1400 1499 Terracotta, painted and partially gilt 21034 Overall: 30 1/2 × 23 in. (77.5 × 58.4 cm); Framed: 46 1/2 × 36 1/4 in. (118.1 × 92.1 cm) Rogers Fund, 1909                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
106162 17.190.1405 0 1 194000 European Sculpture and Decorative Arts 3 Relief 3917 Elijah in the Fiery Chariot Italian, Venice 122         Maker 1   Master of the Barbarigo Reliefs     MASTER OF THE BARBARIGO RELIEFS 9185   1475 1575 ca. 1520 1515 1525 Bronze 23 Overall (confirmed): 1 3/8 × 9 1/4 in. (3.5 × 23.5 cm) Gift of J. Pierpont Morgan, 1917                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
107200 24.131.1 0 1 195144 European Sculpture and Decorative Arts 3 Relief 3917 Pasiphaë Adorning the Bull with Flowers French, Paris or Sèvres 2772         Maker 1   César-Isidore-Henry Cros French, 1840–1907   Cros, César-Isidore-Henry 9489 French 2 1840 1840 1891–1907 1891 1907 Pâte-de-verre 21732 Overall: 9 × 13 in. (22.9 × 33 cm) Purchase, Edward C. Moore Jr. Gift, 1924                       Glass 3   Metropolitan Museum of Art, New York, NY 1
107201 24.131.2 0 1 195145 European Sculpture and Decorative Arts 3 Relief 3917 Young woman holding libation cup French, Paris or Sèvres 2772         Maker 1   César-Isidore-Henry Cros French, 1840–1907   Cros, César-Isidore-Henry 9489 French 2 1840 1840 1891–1907 1891 1907 Painted terracotta; study for a work in pâte-de-verre 21733 Overall: 12 1/2 × 7 3/4 in. (31.8 × 19.7 cm) Purchase, Edward C. Moore Jr. Gift, 1924                       Glass 3   Metropolitan Museum of Art, New York, NY 1
110383 39.180.3 0 1 198559 European Sculpture and Decorative Arts 3 Relief 3917 Portrait of an unknown man British 6         Maker 1 Possibly by Joachim Smith active 1774   Smith Joachim 10092   1774 1774 1798 1798 1798 Colored wax on glass over paper, painted grey-blue with water-color; frame: brown wood 22210 8 5/8 × 7 1/4 in. (21.9 × 18.4 cm) Gift of Mrs. J. Insley Blair, 1939                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
110384 39.180.4 0 1 198560 European Sculpture and Decorative Arts 3 Relief 3917 Portrait of a man British 6         Maker 1 Possibly by Joachim Smith active 1774   Smith Joachim 10092   1774 1774 1798 1798 1798 Colored wax; frame: wood 22211 Framed: 12 × 10 3/4 in. (30.5 × 27.3 cm) Gift of Mrs. J. Insley Blair, 1939                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
119054 1992.339 0 1 208089 European Sculpture and Decorative Arts 3 Relief 3917 The Virgin and Child Triumphing over Evil Italian, Rome 549         Maker 1 Probably by Francesco Giardoni 1692–1757   Giardoni Francesco 11865   1692 1757 ca. 1731–40 1726 1745 Silver, gilt bronze, and wood 23723 Relief: 10 9/16 × 8 7/8 in. (26.8 × 22.5 cm); Frame: 23 5/16 × 14 1/2 in. (59.2 × 36.8 cm) Wrightsman Fund, 1992                       Metalwork-Silver In Combination 327   Metropolitan Museum of Art, New York, NY 1
140292 L.2012.22 0 0 238934 European Sculpture and Decorative Arts 3 Relief 3917 Bacchante and Satyress Dancing with Children French 7         Maker 1   Clodion (Claude Michel) French, Nancy 1738–1814 Paris   Clodion (Claude Michel) 8515 French 2 1738 1814 1773 1768 1778 Terracotta 160 Other: 14 9/16 in. (37 cm) Framed: 19 7/8 x 19 7/8 in. (50.5 x 50.5 cm) Private Collection, Courtesy of Daniel Katz Gallery, London                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
140452 2013.198 0 1 239337 European Sculpture and Decorative Arts 3 Relief 3917 Profile head of Napoleon French 7         Maker 1   Pierre Jean David d'Angers French, Angers 1788–1856 Paris   David d'Angers, Pierre Jean 679 French 2 1788 1856 1839 1839 1839 Patinated plaster 23634 Overall: 14 1/2 × 7 1/16 × 2 7/8 in. (36.8 × 17.9 × 7.3 cm) Gift of Eugene V. Thaw, 2013                       Sculpture 12   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 2545.289ms · Data license: CC0 · Data source: metmuseum/openaccess