MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Is Highlight = 1 and Medium = 2

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Culture, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End Date, Geography Type, City, Country, Classification

Is Highlight

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
318 54.167 1 1 364 American Decorative Arts 1 Basket 55 Basket American 1         Maker 1   Myer Myers 1723–1795   Myers, Myer 78 American 1 1723 1795 1770–76 1770 1776 Silver 2 11 3/16 x 14 7/16 x 11 3/8 in. (28.4 x 36.7 x 28.9 cm); 41 oz. 5 dwt. (1282.7 g) Morris K. Jesup Fund, 1954 Made in 1 New York 3     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
734 38.63 1 1 802 American Decorative Arts 1 Bowl 106 Two-handled Bowl American 1         Maker 1   Cornelius Kierstede 1674–ca. 1757   Kierstede, Cornelius 165 American 1 1674 1760 1700–1710 1700 1710 Silver 2 Overall: 5 3/8 x 13 13/16 in. (13.7 x 35.1 cm); 25 oz. 19 dwt. (806.9 g) Lip: Diam. 9 11/16 in. (24.6 cm) Foot: Diam. 4 13/16 in. (12.2 cm) Samuel D. Lee Fund, 1938 Made in 1 New York 3     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
952 77.9a, b 1 1 1029 American Decorative Arts 1 Vase 7 The Bryant Vase American 1         Designer|Manufacturer|Decorator|Designer 25 Designed by|Manufactured by|Chased by|Medallions by James Horton Whitehouse|Tiffany & Co.|Eugene J. Soligny|Augustus Saint-Gaudens 1833–1902|1837–present|1832–1901|American, Dublin 1848–1907 Cornish, New Hampshire   Whitehouse, James Horton|Tiffany & Co.|Soligny, Eugene J.|Saint-Gaudens, Augustus 205 American 1 1833 |1837 |1832 |1848 1902 |9999 |1901 |1907 1875–76 1875 1876 Silver 2 33 1/2 x 14 x 11 5/16 in. (85.1 x 35.6 x 28.7 cm); Diam. 11 5/16 in. (28.7cm); 452 oz. 16 dwt. (14084.2 g) Gift of William Cullen Bryant, 1877 Made in 1 New York 3     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
1894 33.120.221 1 1 2059 American Decorative Arts 1 Chocolate Pot 228 Chocolate Pot American 1         Maker 1   Edward Winslow 1669–1753   Winslow, Edward 242 American 1 1669 1753 1700–1710 1700 1710 Silver 2 Overall: 9 1/8 x 6 3/4 x 5 13/16 in. (23.2 x 17.1 x 14.8 cm); 23 oz. (715.4 g) Foot: Diam. 3 15/16 in. (10 cm) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
3342 1974.214.26a, b 1 0 3577 American Decorative Arts 1 Ewer 227 Ewer and Plateau American 1         Retailer|Maker 11   Spaulding and Company|Gorham Manufacturing Company American, 1831–present   Spaulding and Company |Gorham Manufacturing Company 510 American 1 1831 9999 |9999 1901 1901 1901 Silver 2 Overall: 19 1/16 x 8 3/4 x 6 3/8 in. (48.4 x 22.2 x 16.2 cm); 64 oz. 9 dwt. (2005.6 g) Plateau: 2 5/16 x 17 1/4 in. (5.9 x 43.8 cm); 67 oz. 2 dwt. (2086.5 g) Gift of Mr. and Mrs. Hugh J. Grant, 1974 Made in 1 Providence 36     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
6338 1982.4a, b 1 1 6778 American Decorative Arts 1 Vase 7 Presentation Vase American 1         Maker|Maker 6   Thomas Fletcher|Sidney Gardiner American, Alstead, New Hampshire 1787–1866 New Jersey|American, Mattituck, New York 1787–1827 Mexico   Fletcher, Thomas|Gardiner, Sidney 934 American|American 5 1787 |1787 1866 |1827 1824 1824 1824 Silver 2 Overall: 23 7/16 x 20 1/8 x 15 1/8 in. (59.5 x 51.1 x 38.4 cm); 410 oz. 5 dwt. (12760 g) Lip: Diam. 12 3/4 in. (32.4 cm) Cover: 5 5/8 x 12 3/4 in. (14.3 x 32.4 cm) Purchase, Louis V. Bell and Rogers Funds; Anonymous and Robert G. Goelet Gifts; and Gifts of Fenton L. B. Brown and of the grandchildren of Mrs. Ranson Spaford Hooker, in her memory, by exchange, 1982 Made in 1 Philadelphia 1     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
202700 47.100.88 1 1 324029 Ancient Near Eastern Art 14 Beaker 58 Beaker with birds and animals                             ca. 4th century B.C. -400 -300 Silver 2 H. 18.7 cm Rogers Fund, 1947           Thrace 394           Metalwork-Vessels 607   Metropolitan Museum of Art, New York, NY 1
206362 66.173 1 1 329074 Ancient Near Eastern Art 14 Sculpture 100 Kneeling bull holding a spouted vessel Proto-Elamite 5686 Proto-Elamite                         ca. 3100–2900 B.C. -3100 -2900 Silver 2 6 7/16 x 2 1/2 x 4 1/4in. (16.3 x 6.3 x 10.8cm) Purchase, Joseph Pulitzer Bequest, 1966           Southwestern Iran 395           Metalwork-Sculpture 521   Metropolitan Museum of Art, New York, NY 1
324663 17.190.396 1 1 464377 Medieval Art 6 Plate 356 Plate with the Battle of David and Goliath Byzantine 1134                           629–30 629 630 Silver 2 Overall: 19 7/16 x 2 5/8 in., 203.9oz. (49.4 x 6.6 cm, 5780g) foot: 8 1/8 x 3/4 in. (20.6 x 1.9 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Constantinople 1847                   Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
353972 30.8.93 1 1 546746 Egyptian Art 19 Female statuette with cartouches of Necho II on her arms 19291 Statuette of a Royal (?) Woman with the Cartouches of Necho II on her Arms   Late Period, Saite Dynasty 26 115 reign of Necho II 165                     610–595 B.C. -610 -610 Silver 2 H. 23.8 cm (9 3/8 in.); W. 5.6 cm (2 3/16 in.); D. 5.4 cm (2 1/8 in.) Theodore M. Davis Collection, Bequest of Theodore M. Davis, 1915 From 19       Egypt 104                 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 2091.167ms · Data license: CC0 · Data source: metmuseum/openaccess