Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
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 | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1974 | 1974 | 2006.446 | 0 | 1 | 2146 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Joseph Richardson Jr. | 1752–1831 | Richardson, Jr. Joseph 348 | 1752 | 1831 | ca. 1795 | 1792 | 1798 | Silver 2 | Overall: 15 3/4 x 10 7/8 in. (40 x 27.6 cm); 47 oz. 10 dwt. (1476.7 g) Foot: 4 1/8 x 4 1/8 in. (10.5 x 10.5 cm) | Purchase, Dr. and Mrs. Burton P. Fabricand Gift, 2006 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2146 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7902 | 7902 | 68.130.1 | 0 | 1 | 8426 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Harvey Lewis | ca. 1783–1835 | Lewis, Harvey 396 | 1780 | 1835 | 1827 | 1827 | 1827 | Silver 2 | Overall: 9 7/8 x 13 5/16 x 6 5/8 in. (25.1 x 33.8 x 16.8 cm); 44 oz. 12 dwt. (1387 g) Foot: Diam. 4 13/16 in. (12.2 cm) | Gift of Mrs. Arthur C. Steinbach, 1968 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8426 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
111873 | 111873 | 48.187.109 | 0 | 1 | 200142 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Miniature coffeepot | French, Paris 114 | Maker 1 | Antoine Bouiller | master 1775, active 1806 | BOUILLER ANTOINE 10380 | 1745 | 1836 | 1777–78 | 1777 | 1778 | Silver 2 | 3 1/4 × 5 in. (8.3 × 12.7 cm) | Bequest of Catherine D. Wentworth, 1948 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/200142 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
119524 | 119524 | 1996.436.1a, b | 0 | 1 | 208560 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Augsburg 126 | Maker 1 | Alois Simpert Eschenlohr | 1785–1837, master 1824? | Eschenlohr Alois Simpert 11941 | 1785 | 1837 | 1823–24 | 1823 | 1824 | Silver, ebony, ivory, macassar ivory 23792 | Height (with cover): 10 5/16 in. (26.2 cm) | Gift of Wolfram Koeppe, in memory of Walter E. Stait, 1996 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/208560 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
1975 | 1975 | 63.88.7a, b | 0 | 1 | 2147 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Manufacturer 20 | Manufactured by | Tucker Factory | 1826–1838 | Tucker Factory 349 | 1826 | 1838 | ca. 1838 | 1835 | 1838 | Porcelain 109 | H. 8 7/8 in. (22.5 cm); Diam. 8 3/4 in. (22.2 cm) | Rogers Fund, 1963 | Made in 1 | Philadelphia 1 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2147 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
107070 | 107070 | 23.67.18 | 0 | 1 | 194994 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | Flemish, Mons 2766 | Silversmith 122 | Master with the Mark of a Crowned D | Master with the Mark of a Crowned D 9457 | 1741 | 1841 | 1771 | 1771 | 1771 | Silver, wood 1114 | Height: 13 1/2 in. (34.3 cm) | Rogers Fund, 1923 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/194994 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
109413 | 109413 | 34.12.1 | 0 | 1 | 197465 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | French, Paris 114 | Maker 1 | Martin-Guillaume Biennais | French, 1764–1843, active ca. 1796–1819 | Biennais, Martin-Guillaume 9900 | French 2 | 1764 | 1843 | 1797–1809 | 1797 | 1809 | Silver gilt 9203 | Height: 13 1/8 in. (33.3 cm) | Rogers Fund, 1934 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/197465 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
1978 | 1978 | 33.120.225 | 0 | 1 | 2150 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | John Vernon | 1755–1845 | Vernon, John 352 | 1755 | 1845 | ca. 1790 | 1787 | 1790 | Silver 2 | Overall: 13 1/16 x 12 x 5 7/8 in. (33.2 x 30.5 x 14.9 cm); 49 oz. 11 dwt. (1541.2 g) Foot: Diam. 5 1/4 in. (13.3 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2150 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
1973 | 1973 | 83.2.367 | 0 | 1 | 2145 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | British (American market) 2 | Maker 1 | Enoch Wood & Sons | British, active Burslem, 1818–46 | Wood & Sons, Enoch 347 | British 7 | 1818 | 1846 | ca. 1824–ca. 1846 | 1821 | 1849 | Earthenware, transfer-printed 119 | H. 9 3/4 in. (24.8 cm) | Gift of William H. Huntington, 1883 | Made in 1 | Staffordshire 1 | Staffordshire 1 | England 4 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2145 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
16771 | 16771 | 2009.505.1 | 0 | 1 | 20424 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Robert and William Wilson | active ca. 1825–ca.1846 | Wilson, Robert and William 433 | 1825 | 1846 | ca. 1830 | 1825 | 1835 | silver 3219 | 9 1/8 x 13 5/8 x 5 1/2 in. (23.2 x 34.6 x 14 cm) 37 oz. 19 dwt (1181 g) | Gift of Peter A. Feld, 2009 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/20424 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
1971 | 1971 | 10.162.3 | 0 | 1 | 2143 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Lyman, Fenton & Co. | 1849–52 | Lyman, Fenton and Company 73 | 1849 | 1849 | ca. 1849–58 | 1846 | 1858 | Mottled brown earthenware 118 | H. 12 1/4 in. (31.1 cm) | Gift of Mrs. Russell Sage, 1910 | Made in 1 | Bennington 25 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2143 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
114330 | 114330 | 63.53.30 | 0 | 1 | 202753 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Miniature coffeepot (part of a set) | Irish, Dublin 2300 | Artist 2 | Henry Flavelle | FLAVELLE HENRY 10980 | 1750 | 1850 | 1827 and 1829 | 1827 | 1829 | Silver 2 | 2 9/16 × 2 in. (6.5 × 5.1 cm) | The Joseph M. and Aimee Loeb May Collection, 1963 | Metalwork-Silver-Miniature 360 | http://www.metmuseum.org/art/collection/search/202753 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
1980 | 1980 | 1980.503.1 | 0 | 1 | 2152 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Attributed to | Christian Wiltberger | American, Philadelphia, Pennsylvania 1766–1851 Philadelphia, Pennsylvania | Wiltberger, Christian 353 | American 1 | 1766 | 1851 | ca. 1800 | 1797 | 1800 | Silver 2 | Overall: 14 1/2 x 10 15/16 x 5 5/8 in. (36.8 x 27.8 x 14.3 cm); 41 oz. 11 dwt. (1292 g) Foot: 4 3/16 x 4 5/16 in. (10.6 x 11 cm) | Gift of H. H. Walker Lewis, in memory of his parents, Mr. and Mrs. Edwin A. S. Lewis, 1980 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2152 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
1965 | 1965 | 42.88 | 0 | 1 | 2136 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | British 6 | Maker 1 | Benjamin Brewood II | active from 1755 | Brewood, Benjamin, II 342 | 1755 | 1855 | 1762–63 | 1762 | 1763 | Silver 2 | Overall: 12 x 9 1/4 in. (30.5 x 23.5 cm); 33 oz. 14 dwt. (1048.6 g) Foot: Diam. 4 3/16 in. (10.6 cm) | Gift of James DeLancey Verplanck and John Bayard Rodgers Verplanck, 1942 | Made in 1 | London 14 | England 4 | Silver 2 | http://www.metmuseum.org/art/collection/search/2136 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
109919 | 109919 | 38.12.1 | 0 | 1 | 198020 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | French, Paris 114 | Maker 1 | Marc Jacquart | active by 1797, recorded 1829 | Jacquart Marc 10018 | 1767 | 1859 | 1809–19 | 1809 | 1819 | Silver, mother-of-pearl 22106 | Overall: 15 1/2 × 6 1/2 × 11 in. (39.4 × 16.5 × 27.9 cm) | Purchase, Joseph Pulitzer Bequest, 1938 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/198020 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
118578 | 118578 | 1986.281.1a, b | 0 | 1 | 207592 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (cafetière "campanienne") (part of a service) | French, Sèvres 2212 | Decorator|Factory|Decorator|Patron 582 | Pictorial decoration by|Gilded by|Commissioned by | Jean Charles Develly|Sèvres Manufactory|Pierre Riton|Louis Philippe, King of France | active 1813–47|French, 1740–present|active 1821–60|French, Paris 1773–1850 Claremont, Surrey | for Queen Marie-Amélie | DEVELLY JEAN CHARLES|Sèvres Manufactory|Riton Pierre|Louis Philippe, King of France 11534 | French|French 21 | 1783 |1740 |1821 |1773 | 1862 |9999 |1860 |1850 | 1836 | 1836 | 1836 | Hard-paste porcelain 572 | Overall (confirmed): 7 9/16 x 6 15/16 x 4 1/4 in. (19.2 x 17.6 x 10.8 cm) | Purchase, The Charles E. Sampson Memorial Fund and Gift of Irwin Untermyer, by exchange, 1986 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207592 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
101212 | 101212 | 02.6.216a, b | 0 | 1 | 188719 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | Austrian, Vienna 349 | Factory 328 | Imperial Porcelain Manufactory | Vienna, 1744–1864 | Imperial Porcelain Manufactory, Vienna 8184 | 1744 | 1864 | ca. 1775–80 | 1770 | 1785 | Hard-paste porcelain 572 | Height: 10 1/4 in. (26 cm) | Gift of Alfred Duane Pell, 1902 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/188719 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
101248 | 101248 | 02.6.257a, b | 0 | 1 | 188755 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | Austrian, Vienna 349 | Factory 328 | Imperial Porcelain Manufactory | Vienna, 1744–1864 | Imperial Porcelain Manufactory, Vienna 8184 | 1744 | 1864 | ca. 1760 | 1755 | 1765 | Hard-paste porcelain 572 | Height: 10 1/4 in. (26 cm) | Gift of Alfred Duane Pell, 1902 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/188755 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
12298 | 12298 | 1990.87.1 | 0 | 1 | 13403 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker|Maker 6 | Thomas Danforth Boardman|Sherman Boardman | 1784–1873|1787–1861 | Boardman, Thomas Danforth|Boardman, Sherman 83 | 1784 |1787 | 1873 |1861 | 1854–65 | 1854 | 1865 | Britannia metal 1275 | H. 11 5/16 in. (28.7 cm); Diam. 10 in. (25.4 cm) | Bequest of Delight L. Sherwin, 1989 | Made in 1 | Hartford 26 | United States 3 | Metal 1 | http://www.metmuseum.org/art/collection/search/13403 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
108849 | 108849 | 31.132.1a, b | 0 | 1 | 196891 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | Italian, Florence 1136 | Factory 328 | Doccia Porcelain Manufactory | Italian, 1737–1896 | Doccia Porcelain Manufactory 8138 | Italian 6 | 1737 | 1896 | ca. 1760 | 1755 | 1765 | Hard-paste porcelain 572 | Height: 10 1/2 in. (26.7 cm) | Gift of George F. Baker, 1931 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/196891 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111045 | 111045 | 42.205.241a, b | 0 | 1 | 199266 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Thuringia (Gotha) 2384 | Factory 328 | Gotha | German, 1757–1900 | Gotha 8334 | 1757 | 1900 | 18th century | 1700 | 1799 | Hard-paste porcelain 572 | Height: 6 3/4 in. (17.1 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199266 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
15572 | 15572 | 2000.605.1a, b | 0 | 0 | 16873 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Manufacturer 20 | Manufactured by | Willets Manufacturing Company | 1879–1908 | Willets Manufacturing Company 373 | 1879 | 1908 | ca. 1901 | 1901 | 1901 | Porcelain 109 | 9 1/4 x 5 1/4 in. (23.5 x 13.3 cm) | Friends of the American Wing Fund, 2000 | Made in 1 | Trenton 49 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/16873 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
16751 | 16751 | 2013.959.3 | 0 | 0 | 20269 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Katherine Pratt | 1891–1978 | Pratt, Katherine 2593 | 1891 | 1978 | ca. 1920 | 1920 | 1920 | Silver and ivory 815 | 8 3/4 × 4 1/2 × 7 3/4 in. (22.2 × 11.4 × 19.7 cm) | Gift, Silver & Metalwork of the Twentieth Century from the Margo Grant Walsh Collection, 2013 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/20269 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
337022 | 337022 | 1986.412.17a-c | 0 | 0 | 484576 | Modern and Contemporary Art 4 | Coffeepot 251 | "Sintrax" Coffeepot | Designer|Designer|Manufacturer 247 | Gerhard Marcks|Wilhelm Wagenfeld|Jenaer Glaswerk Schott & Gen., Jena | German, Berlin 1889–1981 Burgbrohl|German, Bremen 1900–1990 Stuttgart | Marcks, Gerhard|Wagenfeld, Wilhelm|JENAER GLASWERK 45703 | German|German|German 80 | 1889 |1900 | 1981 |1990 | ca. 1934 | 1934 | 1934 | Glass, rubber, and wood 51688 | H. 9-3/8, Diam. 8-1/4 inches (23.8 x 21 cm.) | Gift of Barry Friedman and Patricia Pastor, 1986 | Glass 3 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/484576 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
115447 | 115447 | 64.142.16a, b | 0 | 1 | 204028 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | British, Worcester 2267 | Factory 328 | Worcester factory | British, 1751–2008 | Worcester factory 8164 | 1751 | 2008 | ca. 1760–65 | 1755 | 1770 | Soft-paste porcelain 2061 | Height: 9 3/4 in. (24.8 cm) | Gift of Mrs. Constance D. Stieglitz, in memory of her husband, Marcel H. Stieglitz, 1964 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/204028 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
116709 | 116709 | 1971.277.2a, b | 0 | 1 | 205450 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | British, Worcester 2267 | Factory 328 | Worcester factory | British, 1751–2008 | Worcester factory 8164 | 1751 | 2008 | ca. 1770 | 1765 | 1775 | Soft-paste porcelain 2061 | Height (with cover): 9 3/16 in. (23.3 cm) | Bequest of Barbara S. Adler, 1971 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/205450 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
121079 | 121079 | 61.107.395a, b | 0 | 0 | 210372 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | British, Worcester 2267 | Factory 328 | Worcester factory | British, 1751–2008 | Worcester factory 8164 | 1751 | 2008 | 19th century | 1800 | 1899 | Soft-paste porcelain 2061 | Height: 3 7/16 in. (8.7 cm) | Gift of Dr. and Mrs. A. L. Garbat, 1961 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/210372 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
1970 | 1970 | 1985.343.3 | 0 | 1 | 2142 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Manufacturer 20 | Manufactured by | Leonard, Reed & Barton | Leonard, Reed & Barton 345 | 9999 | 1837–40 | 1837 | 1840 | Pewter 104 | 12 1/2 x 6 3/4 in. (31.8 x 17.1 cm) | Gift of Dr. and Mrs. Roger Gerry, 1985 | Made in 1 | Taunton 119 | United States 3 | Metal 1 | http://www.metmuseum.org/art/collection/search/2142 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
1976 | 1976 | 27.85.8 | 0 | 1 | 2148 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Marked by | H. M. | H., M. 350 | 9999 | 1705–35 | 1705 | 1735 | Silver 2 | Overall: 10 5/16 x 7 5/8 in. (26.2 x 19.4 cm); 32 oz. 12 dwt. (1013.8 g) Base: Diam. 4 3/4 in. (4 3/4 in.) At spout: W. 6 1/2 in. (16.5 cm) | Gift of Annie Clarkson, 1927 | Possibly made in 5 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2148 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
1977 | 1977 | 33.120.224 | 0 | 1 | 2149 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Marked by | I. P. | I. P. 351 | 9999 | 1735–45 | 1730 | 1750 | Silver 2 | Overall: 10 1/16 x 8 11/16 in. (25.6 x 22.1 cm); 31 oz. 5 dwt. (971.4 g) Base: Diam. 5 7/16 in. (13.8 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2149 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
12263 | 12263 | 1989.263.1a, b | 0 | 1 | 13363 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Manufacturer 20 | Manufactured by | Lenox, Incorporated | established 1889 | Lenox, Incorporated 1190 | 1889 | 9999 | ca. 1906 | 1903 | 1906 | White bone porcelain 2059 | H. 6 5/8 in. (16.8 cm) | Gift of Mrs. Kenneth C. Heath, in memory of Marjorie L. Sloan, and Reginald J. and Kenneth C. Heath, 1989 | Made in 1 | Trenton 49 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/13363 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
17298 | 17298 | 2013.959.1.1 | 0 | 0 | 21787 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Maker 1 | Tiffany & Co. | 1837–present | Tiffany & Co. 193 | 1837 | 9999 | 1928 | 1928 | 1928 | Silver, wood 1114 | 7 1/4 × 6 3/8 × 3 3/8 in. (18.4 × 16.2 × 8.6 cm) | Gift, Silver & Metalwork of the Twentieth Century from the Margo Grant Walsh Collection, 2013 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/21787 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
98914 | 98914 | 83.1.27a, b | 0 | 1 | 186248 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a coffee service) | German, Nymphenburg 2138 | Factory 328 | Nymphenburg Porcelain Manufactory | German, 1747–present | Nymphenburg Porcelain Manufactory 8008 | 1747 | 9999 | early 19th century | 1800 | 1815 | Hard-paste porcelain 572 | Height: 6 3/4 in. (17.1 cm) | Bequest of George White Thorne, 1883 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/186248 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
101155 | 101155 | 02.6.104a, b | 0 | 1 | 188651 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | German, Berlin 247 | Factory 328 | Royal Porcelain Manufactory, Berlin | German, founded 1763 | Royal Porcelain Manufactory, Berlin 8175 | 1763 | 9999 | ca. 1790 | 1785 | 1795 | Hard-paste porcelain 572 | Height: 9 1/2 in. (24.1 cm) | Gift of Alfred Duane Pell, 1902 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/188651 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
101223 | 101223 | 02.6.230 | 0 | 1 | 188730 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1725–70 | 1720 | 1775 | Hard-paste porcelain 572 | Height: 6 3/8 in. (16.2 cm) | Gift of Alfred Duane Pell, 1902 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/188730 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
106989 | 106989 | 22.45.24a, b | 0 | 1 | 194897 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a set) | German, Berlin 247 | Factory 328 | Royal Porcelain Manufactory, Berlin | German, founded 1763 | Royal Porcelain Manufactory, Berlin 8175 | 1763 | 9999 | ca. 1765 | 1760 | 1770 | Hard-paste porcelain 572 | H. with cover 6 1/4 in. (15.9 cm.) | Joint Bequest of Harriet K. and Grace Wilkes, 1922 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/194897 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
109578 | 109578 | 35.80.60a, b | 0 | 1 | 197663 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1735 | 1730 | 1740 | Hard-paste porcelain 572 | Height: 8 1/4 in. (21 cm) | Bequest of Mary Strong Shattuck, 1935 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/197663 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110913 | 110913 | 42.205.24a, b | 0 | 1 | 199133 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1713–20 | 1708 | 1725 | Hard-paste porcelain 572 | Height: 7 7/8 in. (20 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199133 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110936 | 110936 | 42.205.55a, b | 0 | 1 | 199157 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1725–30 | 1720 | 1735 | Hard-paste porcelain 572 | Height (with cover): 7 1/4 in. (18.4 cm); Height (without cover): 5 5/8 in. (14.3 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199157 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110943 | 110943 | 42.205.69a, b | 0 | 1 | 199164 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a set) | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1735–40 | 1730 | 1745 | Hard-paste porcelain 572 | Height: 8 1/2 in. (21.6 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199164 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110962 | 110962 | 42.205.96a, b | 0 | 1 | 199183 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1740 | 1735 | 1745 | Hard-paste porcelain 572 | Height: 5 1/4 in. (13.3 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199183 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
110997 | 110997 | 42.205.154a, b | 0 | 1 | 199218 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1740–45 | 1735 | 1750 | Hard-paste porcelain 572 | Height: 6 3/8 in. (16.2 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199218 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111006 | 111006 | 42.205.173a, b | 0 | 1 | 199227 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1725 | 1720 | 1730 | Hard-paste porcelain 572 | Height: 6 7/8 in. (17.5 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199227 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111009 | 111009 | 42.205.176a, b | 0 | 1 | 199230 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1750 | 1745 | 1755 | Hard-paste porcelain 572 | Height: 5 1/2 in. (14 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199230 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111029 | 111029 | 42.205.221a, b | 0 | 1 | 199250 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen 2269 | Factory 328 | Meissen Manufactory | German, 1710–present | Meissen Manufactory 981 | German 10 | 1710 | 9999 | ca. 1800 | 1795 | 1805 | Hard-paste porcelain 572 | Height: 5 3/4 in. (14.6 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199250 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111047 | 111047 | 42.205.244a, b | 0 | 1 | 199268 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Fürstenberg 2289 | Factory 328 | Fürstenberg Porcelain Manufactory | German, founded 1747 | Fürstenberg Porcelain Manufactory 8190 | 1747 | 9999 | 1770–75 | 1770 | 1775 | Hard-paste porcelain 572 | Height: 9 1/2 in. (24.1 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199268 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
111141 | 111141 | 43.100.55a, b | 0 | 1 | 199365 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Nymphenburg 2138 | Factory|Decorator 330 | Nymphenburg Porcelain Manufactory|Unidentified | German, 1747–present | Hausmaler | Nymphenburg Porcelain Manufactory|Unidentified 10233 | 1747 | 9999 | ca. 1760–70 | 1755 | 1775 | Hard-paste porcelain 572 | Height (with cover): 7 1/4 in. (18.4 cm) | Anonymous Gift, 1943 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199365 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111575 | 111575 | 48.29a, b | 0 | 1 | 199838 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Pfalz-Zweibrücken 3008 | Factory 328 | Pfalz-Zweibrücken Porcelain Manufactory | German, founded 1767 | Pfalz-Zweibrücken Porcelain Manufactory 10312 | 1767 | 9999 | ca. 1770 | 1765 | 1775 | Hard-paste porcelain 572 | Height: 5 1/8 in. (13 cm) | Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1948 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199838 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
119452 | 119452 | 1995.268.318a, b | 0 | 1 | 208488 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Volkstedt 3445 | Factory 328 | Volkstedt Porcelain Manufactory | German, founded 1760 | Volkstedt Porcelain Manufactory 8413 | 1760 | 9999 | ca. 1770 | 1765 | 1775 | Hard-paste porcelain 572 | Height: 10 1/2 in. (26.7 cm) | The Hans Syz Collection, Gift of Stephan B. Syz and John D. Syz, 1995 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/208488 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
120265 | 120265 | 69.162.2a, b | 0 | 1 | 209461 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a tea service) | Russian, St. Petersburg 2372 | Factory 328 | Imperial Porcelain Manufactory, St. Petersburg | Russian, 1744–present | Imperial Porcelain Manufactory, St. Petersburg 8311 | Russian 57 | 1744 | 9999 | 1834 | 1834 | 1834 | Hard-paste porcelain 572 | Height (with cover): 6 in. (15.2 cm) | Bequest of John Rolston Peacock, 1969 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/209461 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
389086 | 389086 | 2014.200.1.1 | 0 | 1 | 639665 | American Decorative Arts 1 | Coffeepot 251 | Coffeepot | American 1 | Manufacturer 20 | Gorham Manufacturing Company | American, 1831–present | Gorham Manufacturing Company 183 | American 1 | 1831 | 9999 | 1881 | 1881 | 1881 | Silver, ivory 1272 | 10 5/8 × 6 × 4 7/8 in., 30oz. 9dwt. (27 × 15.2 × 12.4 cm, 947.2g) | Gift of Martha J. Fleischman, in honor of Morrison H. Heckscher, 2014 | Made in 1 | Providence 36 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/639665 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
117141 | 117141 | 1974.356.424 | 0 | 1 | 205976 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | German, Meissen with German, Augsburg mounts 3306 | Factory|Maker 400 | Mounts by | Meissen Manufactory|Elias Adam | German, 1710–present|German, ca. 1669–1745, master 1703 | Meissen Manufactory|Adam Elias 11452 | German|German 79 | 1710 |1669 | 9999 |1745 | 1723–26 | 1723 | 1726 | Hard-paste porcelain and silver-gilt 23299 | H. with cover 8-1/8 in. (20.6 cm.) | The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/205976 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
110922 | 110922 | 42.205.34a, b | 0 | 1 | 199142 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen with German, Augsburg decoration 2910 | Factory|Decorator 330 | Decorated by workshop of the Hausmaler | Meissen Manufactory|Bartholomäus Seuter | German, 1710–present|Augsburg, died 1754 | Meissen Manufactory|Seuter Bartholomäus 10202 | German 10 | 1710 |1654 | 9999 |1754 | ca. 1720–25, decorated ca. 1725–30 | 1715 | 1735 | Hard-paste porcelain 572 | Height: 7 1/4 in. (18.4 cm) | The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/199142 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117169 | 117169 | 1974.356.474 | 0 | 1 | 206004 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot | German, Meissen with German, Augsburg mounts 3306 | Factory|Decorator|Maker 449 | Decorated in the manner of|Mounts by | Meissen Manufactory|Franz Ferdinand Mayer|Elias Adam | German, 1710–present|German, ca. 1669–1745, master 1703 | Meissen Manufactory|Mayer Franz Ferdinand|Adam Elias 11453 | German|German 79 | 1710 |1700 |1669 | 9999 |1800 |1745 | ca. 1715–40 | 1710 | 1745 | Hard-paste porcelain, silver 20478 | Height: 9 in. (22.9 cm) | The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/206004 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
121265 | 121265 | 64.101.300a, b | 0 | 1 | 210900 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | German, Nymphenburg 2138 | Manufactory|Decorator 367 | Decoration in the style of | Nymphenburg Porcelain Manufactory|Kajetan Purtscher | German, 1747–present|German, ca. 1740–1813 Nymphenburg | Nymphenburg Porcelain Manufactory|Purtscher Kajetan 11037 | German 10 | 1747 |1735 | 9999 |1813 | 1760–65 | 1760 | 1765 | Hard-paste porcelain 572 | H. 8 3/4 in. (22.2 cm.) | Gift of Irwin Untermyer, 1964 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/210900 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117151 | 117151 | 1974.356.440a, b | 0 | 1 | 205986 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | German, Meissen 2269 | Factory|Factory director 366 | Meissen Manufactory|Marcolini Period | German, 1710–present|1774–1814 | period | Meissen Manufactory|MARCOLINI CAMILLO 8333 | German 10 | 1710 |1736 | 9999 |1836 | ca. 1780–85 | 1775 | 1790 | Hard-paste porcelain 572 | Height: 7 3/8 in. (18.7 cm) | The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/205986 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
118742 | 118742 | 1988.287.1a, b | 0 | 0 | 207761 | European Sculpture and Decorative Arts 3 | Coffeepot 251 | Coffeepot (part of a service) | French, Sèvres 2212 | Factory|Designer 389 | Sèvres Manufactory|Léon Kann | French, 1740–present|French, active 1896–ca. 1915, active at Sèvres 1896–98 and 1900–1908 | Sèvres Manufactory|Kann, Léon 11752 | French|French 21 | 1740 |1896 | 9999 |1908 | 1900–1904 | 1900 | 1904 | Hard-paste porcelain 572 | Height: 7 in. (17.8 cm) | Gift of Diane R. Wolf, 1988 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207761 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");