MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 21711

View and edit SQL

Suggested facets: Object Name, Title, Culture, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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 Repository
107057 23.61 0 1 194980 European Sculpture and Decorative Arts 3 Mustard pot 295 Mustard pot French, Paris 114         Maker 1   Pierre-François Coste master 1782, active 1793   COSTE PIERRE-FRANÇOIS 9451   1752 1823 1786–87 1786 1787 Silver; glass 21711 Height: 4 1/2 in. (11.4 cm) Gift of Mrs. Schuyler van Rensselaer, 1923                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111832 48.187.63a–c 0 1 200101 European Sculpture and Decorative Arts 3 Sugar bowl with cover 6970 Sugar bowl with cover French, Paris 114         Maker 1   Antoine Bouiller master 1775, active 1806   BOUILLER ANTOINE 10380   1745 1836 1779–80 1779 1780 Silver; glass 21711 Overall: 4 3/4 × 7 3/8 × 4 1/8 in. (12.1 × 18.7 × 10.5 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111833 48.187.64a–c 0 1 200102 European Sculpture and Decorative Arts 3 Sugar bowl with cover 6970 Sugar bowl with cover French, Paris 114         Maker 1   Étienne Modenx master 1777, recorded 1793   Modenx Étienne 10381   1747 1823 1786–87 1786 1787 Silver; glass 21711 Overall: 5 1/8 × 8 1/8 × 4 1/16 in. (13 × 20.6 × 10.3 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111835 48.187.66a–c 0 1 200104 European Sculpture and Decorative Arts 3 Sugar bowl with cover 6970 Sugar bowl with cover French, Paris 114         Maker 1   Jacques Favre master 1774, recorded 1793   FAVRE JACQUES 10383   1744 1823 1779–80 1779 1780 Silver; glass 21711 Overall: 5 3/4 × 5 1/2 in. (14.6 × 14 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111855 48.187.88a–e 0 1 200124 European Sculpture and Decorative Arts 3 Cruet stand 325 Cruet stand French, Paris 114         Maker 1 Probably Joseph-Pierre-Jacques Duguay born 1724, master 1756, recorded 1793   Duguay Joseph-Pierre-Jacques 10397   1724 1824 1762–63 1762 1763 Silver; glass 21711 Overall (stand .88a): 3 1/2 × 11 1/4 × 6 1/4 in. (8.9 × 28.6 × 15.9 cm); Height (each cruet with cover .88b–e): 7 in. (17.8 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111859 48.187.92a, b 0 1 200128 European Sculpture and Decorative Arts 3 Mustard pot 295 Mustard pot French, Paris 114         Maker 1   Jean-Baptiste Saurin born 1734/6, master 1774, recorded 1793   Saurin Jean-Baptiste 10401   1734 1834 1778–79 1778 1779 Silver; glass 21711 Height: 4 3/4 in. (12.1 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111946 48.187.185a–e 0 1 200215 European Sculpture and Decorative Arts 3 Cruet frame 7140 Cruet frame French, Dôle (Besançon Mint) 3064         Maker 1   Pierre-Noel David master 1729   DAVID PIERRE-NOEL 10462   1699 1759 ca. 1730–35 1725 1740 Silver; glass 21711 Overall (cruet frame .185a): 3 3/4 × 6 1/8 × 9 3/4 in. (9.5 × 15.6 × 24.8 cm); Height (cruet with stopper .185b, c): 8 in. (20.3 cm); Height (cruet with stopper .185d, e): 8 in. (20.3 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111953 48.187.193a–c 0 1 200222 European Sculpture and Decorative Arts 3 Mustard pot 295 Mustard pot French, Lyons 2685         Maker 1   Pierre Benardié (or Berardier) master 1775, active 1792   Benardié (or Berardier) Pierre 10468   1745 1822 1775–81 1775 1781 Silver; glass 21711 Overall: 4 7/8 × 4 in. (12.4 × 10.2 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112004 48.187.276a, b 0 1 200273 European Sculpture and Decorative Arts 3 Mustard pot 295 Mustard pot French, Paris 114         Maker 1 Maker attributed to: Pierre-Nicolas Sommé master 1760, retired 1806   Sommé Pierre-Nicolas 8218   1730 1836 1777–78 1777 1778 Silver; glass 21711 Height: 4 1/2 in. (11.4 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   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 145.982ms · Data license: CC0 · Data source: metmuseum/openaccess