MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Medium = 22450

View and edit SQL

Suggested facets: Object Name, Title, Culture, 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
111851 48.187.84 0 1 200120 European Sculpture and Decorative Arts 3 Coffeepot 251 Coffeepot French, Paris 114         Maker 1   Denys Frankson master through service at Hôpital de la Trinité 1765, master Paris guild 1773, recorded 1791   FRANKSON DENYS 10392   1735 1821 1766–67 1766 1767 Silver; ebony 22450 Height: 6 1/2 in. (16.5 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111852 48.187.85 0 1 200121 European Sculpture and Decorative Arts 3 Coffeepot 251 Coffeepot French, Paris 114         Maker 1   Jacques-Pierre Marteau apprenticed 1740, master 1757, died 1779   Marteau Jacques-Pierre 9580   1679 1779 1775–76 1775 1776 Silver; ebony 22450 Height: 6 3/4 in. (17.1 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111889 48.187.127 0 1 200158 European Sculpture and Decorative Arts 3 Hot milk pot (?) 7993 Hot milk pot (?) French, Paris 114         Maker 1   Jean-Louis-Dieudonné Outrebon master 1772, recorded 1789   Outrebon Jean-Louis-Dieudonné 10421   1742 1819 1778–79 1778 1779 Silver; ebony 22450 Height: 5 1/4 in. (13.3 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111891 48.187.129 0 1 200160 European Sculpture and Decorative Arts 3 Hot milk pot (?) 7993 Hot milk pot (?) French, Paris 114                           1768–69 1768 1769 Silver; ebony 22450 Overall (with handle): 4 1/8 × 5 3/8 in. (10.5 × 13.7 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111898 48.187.136 0 1 200167 European Sculpture and Decorative Arts 3 Hot milk pot 1237 Hot milk pot French, Rennes 3063         Maker 1 probably François Girard master 1769, active 1789   Girard François 10429   1739 1811 1783–84 1783 1784 Silver; ebony 22450 Height: 4 in. (10.2 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111957 48.187.199 0 1 200226 European Sculpture and Decorative Arts 3 Teapot 26 Teapot French, Bordeaux 2382         Maker 1   Antoine Dutemple born 1741, master 1768, retired 1779, recorded 1788   DUTEMPLE ANTOINE 10471   1741 1841 1775–77 1775 1777 Silver; ebony 22450 Overall: 6 × 9 × 4 1/2 in. (15.2 × 22.9 × 11.4 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112098 48.187.405, .406 0 1 200367 European Sculpture and Decorative Arts 3 Standish with bell 8011 Standish and bell French, Paris 114         Maker 1   Antoine Bailly master through service at Hôpital de la Trinité 1748, master Paris 1756, died 1765   Bailly, Antoine 10400   1665 1765 1750–51 1750 1751 Silver; ebony 22450 Overall (standish .405): 4 1/4 × 9 1/2 × 15 1/8 in. (10.8 × 24.1 × 38.4 cm); Height (bell .406): 4 1/2 in. (11.4 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112099 48.187.407 0 1 200368 European Sculpture and Decorative Arts 3 Chocolate pot 226 Chocolate pot French, Paris 114         Maker 1   François Thomas Germain French, Paris 1726–1791 Paris, master 1748   Germain, François Thomas 8029 French 2 1726 1791 1765–66 1765 1766 Silver; ebony 22450 Overall (with handle): 9 1/4 × 8 3/4 in. (23.5 × 22.2 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112100 48.187.408 0 1 200369 European Sculpture and Decorative Arts 3 Coffeepot 251 Coffeepot French, Paris 114         Maker 1   Guillaume Ledoux master 1705, died 1751   LEDOUX GUILLAUME 10541   1651 1751 1747–48 1747 1748 Silver; ebony 22450 Height: 7 7/8 in. (20 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112101 48.187.409 0 1 200370 European Sculpture and Decorative Arts 3 Coffeepot 251 Coffeepot French, Paris 114         Maker 1   Charles Donze master 1756, died 1777   DONZE CHARLES 10546   1677 1777 1768–69 1768 1769 Silver; ebony 22450 Height: 7 7/8 in. (20 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112106 48.187.416 0 1 200375 European Sculpture and Decorative Arts 3 Teapot 26 Teapot French, Lille 2284         Maker 1   Barthélemy Decourchelle master 1726, active 1761   DECOURCHELLE BARTHÉLEMY 10549   1696 1791 probably 1752 1752 1752 Silver; ebony 22450 Height: 8 3/16 in. (20.8 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
113600 56.176 0 1 201912 European Sculpture and Decorative Arts 3 Teapot 26 Teapot French (Jurisdiction of Lille) 3171         Maker 1   I.M.P.     I.M.P. 10799       mid-18th century 1730 1765 Silver; ebony 22450 Height: 7 5/16 in. (18.6 cm) Gift of James Hazen Hyde, 1956                       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 131.349ms · Data license: CC0 · Data source: metmuseum/openaccess