MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Culture = 222 and Medium = 20506

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
112307 49.7.92, .93 0 1 200580 European Sculpture and Decorative Arts 3 Fruit dishes 7109 Pair of fruit dishes British, London 222         Maker 1   Thomas Heming active 1745–73   Heming Thomas 9930   1745 1773 1766–67 1766 1767 Silver-gilt 20506 .92, wt. confirmed: 5 1/8 × 19 1/8 in., 6 lb. (13 × 48.6 cm, 2744.262g) .93, wt. confirmed: 5 1/4 × 19 1/8 in., 6 lb. (13.3 × 48.6 cm, 2721.582g) The Jules Bache Collection, 1949                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
116226 68.141.104 0 1 204914 European Sculpture and Decorative Arts 3 Wine cup 3941 Wine cup on high foot (Tazza) British, London 222                           1599 1599 1599 Silver-gilt 20506 Height: 7 1/4 in. (18.4 cm) Gift of Irwin Untermyer, 1968                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
116360 68.141.303 0 1 205060 European Sculpture and Decorative Arts 3 Wager cup 7593 Wager cup (one of a pair) British, London 222         Maker 1   J. A. or I. A., London early 19th century   A. J. or I. 11291   1800 1815 probably early 19th century 1800 1815 Silver-gilt 20506 Height: 6 1/8 in. (15.6 cm) Gift of Irwin Untermyer, 1968                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
116506 1970.131.33 0 1 205221 European Sculpture and Decorative Arts 3 Bowl 106 Bowl British, London 222         Maker 1   George Wickes British, Bury St Edmunds, Suffolk 1698–1761 Thurston, Suffolk   Wickes George 8815   1698 1761 1744/45 1744 1745 Silver-gilt 20506 3 × 6 3/8 in. (7.6 × 16.2 cm) Gift of Irwin Untermyer, 1970                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
117412 1974.379.1 0 1 206312 European Sculpture and Decorative Arts 3 Teapot 26 Teapot (part of a set) British, London 222         Maker|Retailer 34 Firm of Paul Storr|Rundell, Bridge and Rundell British, 1771–1844|British, London, active 1797–1843   Storr, Paul|Rundell, Bridge and Rundell 11491 British|British 9 1771 |1797 1844 |1843 1813/14 1813 1814 Silver-gilt 20506 Overall: 5 1/2 × 10 3/8 in. (14 × 26.4 cm) Gift of Fernanda Munn Kellogg, 1974                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
117413 1974.379.2 0 1 206313 European Sculpture and Decorative Arts 3 Sugar bowl 307 Sugar bowl (part of a set) British, London 222         Maker|Maker 6 for firm of Paul Storr|Rundell, Bridge and Rundell British, 1771–1844|British, London, active 1797–1843   Storr, Paul|Rundell, Bridge and Rundell 11491 British|British 9 1771 |1797 1844 |1843 1813/14 1813 1814 Silver-gilt 20506 Overall: 3 5/8 × 6 1/16 in. (9.2 × 15.4 cm) Gift of Fernanda Munn Kellogg, 1974                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
117414 1974.379.3 0 1 206314 European Sculpture and Decorative Arts 3 Cream jug 318 Cream jug (part of a set) British, London 222         Maker|Maker 6 for the firm of Paul Storr|Rundell, Bridge and Rundell British, 1771–1844|British, London, active 1797–1843   Storr, Paul|Rundell, Bridge and Rundell 11491 British|British 9 1771 |1797 1844 |1843 1812/13 1812 1813 Silver-gilt 20506 Overall: 5 × 6 1/2 in. (12.7 × 16.5 cm) Gift of Fernanda Munn Kellogg, 1974                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
118841 1990.205 0 1 207865 European Sculpture and Decorative Arts 3 Ewer 227 Ewer British, London 222         Maker|Maker 6 and Richard Martin|Ebenezer Hall     Martin, Richard|Hall Ebenezer 11795   1825 |1825 1925 |1925 1877 1877 1877 Silver-gilt 20506 Height: 12 1/8 in. (30.8 cm) Purchase, Friends of European Sculpture and Decorative Arts Gifts, 1990                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
121743 00.19.49 0 0 211428 European Sculpture and Decorative Arts 3 Souvenir spoon 7049 Souvenir spoon with finial in form of John Bull British, London 222         Maker 1   Saunders & Shepherd British, 1869–present   Saunders & Shepherd 12270   1869 9999 1894–95 1894 1895 Silver-gilt 20506 Length: 4 1/2 in. (11.4 cm) Gift of Sir William H. Redding, in memory of his wife, 1900                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
140134 2011.124.2a–c 0 1 238446 European Sculpture and Decorative Arts 3 Cup with cover and stand 9127 Cup with cover and stand (one of a pair) British, London 222         Maker|Maker 6   John Parker|Edward Wakelin British, active 1759–77|British, active before 1748, died 1784   Parker, John|Wakelin, Edward 10594 British|British 9 1759 |1684 1777 |1784 1766/67 1766 1767 Silver-gilt 20506 Overall, cup with cover (confirmed): H. 14 7/16 x W. 11 7/8 x D. 7 1/4 in. (36.7 x 30.2 x 18.4 cm); Overall, base (confirmed): H. 2 3/16 x W. 6 7/8 x D. 6 7/8 in. (5.6 x 17.5 x 17.5 cm) Purchase, Irene Roosevelt Aitken Gift, 2011                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
140138 2011.124.1a–c 0 1 238518 European Sculpture and Decorative Arts 3 Cup with cover and stand 9127 Cup with cover and stand (one of a pair) British, London 222         Maker|Maker 6   John Parker|Edward Wakelin British, active 1759–77|British, active before 1748, died 1784   Parker, John|Wakelin, Edward 10594 British|British 9 1759 |1684 1777 |1784 1766/67 1766 1767 Silver-gilt 20506 Overall, cup with cover (confirmed): H. 14 1/2 x W. 11 7/8 x D. 7 3/16 in. (36.8 x 30.2 x 18.3 cm); Overall, base (confirmed): H. 2 1/4 x W. 6 7/8 x D. 6 7/8 in. (5.7 x 17.5 x 17.5 cm) Purchase, Irene Roosevelt Aitken Gift, 2011                       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 232.262ms · Data license: CC0 · Data source: metmuseum/openaccess