MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

1,130 rows where Medium = 21

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Artist Role, Artist Prefix, Artist Nationality, Geography Type, State, County, Country, Region, Classification

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
116 38.165.24 0 1 124 American Decorative Arts 1 Apothecary jar 13 Apothecary Jar Dutch 4                           1730–40 1730 1740 Earthenware 21 H. 3 5/8 in. (9.2 cm); Diam. 2 7/8 in. (7.3 cm) Harris Brisbane Dick Fund, 1938 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
117 38.165.25 0 1 125 American Decorative Arts 1 Apothecary jar 13 Apothecary Jar Dutch 4                           1730–40 1730 1740 Earthenware 21 H. 3 5/8 in. (9.2 cm); Diam. 2 7/8 in. (7.3 cm) Harris Brisbane Dick Fund, 1938 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
258 34.100.222 0 1 299 American Decorative Arts 1 Baking dish 38 Baking Dish American 1                           1800–1830 1800 1830 Earthenware 21 H. 3 3/4 in. (9.5 cm); Diam. 12 1/4 in. (31.1 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
283 13.7.10 0 0 327 American Decorative Arts 1 Mug 49 Barrel Mug American 1                           1700–1900 1700 1900 Earthenware 21 5 3/4 x 6 x 4 5/8 in. (14.6 x 15.2 x 11.7 cm) Rogers Fund, 1913 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
305 1982.91.1 0 1 350 American Decorative Arts 1 Basin 51 Basin British (American market) 2                           1857–90 1857 1890 Earthenware 21 H. 13 in. (33 cm) Friends of the American Wing Fund, 1982 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
323 20.109.14 0 0 369 American Decorative Arts 1 Oil cruet 57 Oil Cruet European 12                           1800–1900 1800 1900 Earthenware 21 H. 6 5/8 in. (16.8 cm) Gift of Robert Macauley Jackson, 1920                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
505 1970.100.7 0 1 566 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 ca. 1881 1878 1881 Earthenware 21 2 1/8 x 6 x 3/8 in. (5.4 x 15.2 x 1 cm) Funds from various donors, 1970 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
506 1970.100.8 0 1 567 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881–84 1881 1884 Earthenware 21 2 3/16 x 6 1/8 x 3/8 in. (5.6 x 15.6 x 1 cm) Funds from various donors, 1970 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
507 1970.100.9 0 1 568 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 ca. 1885 1882 1885 Earthenware 21 2 3/16 x 6 3/16 x 7/16 in. (5.6 x 15.7 x 1.1 cm) Funds from various donors, 1970 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
508 1970.100.10 0 1 569 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 ca. 1885 1882 1885 Earthenware 21 2 3/16 x 6 1/8 x 7/16 in. (5.6 x 15.6 x 1.1 cm) Funds from various donors, 1970 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
509 1970.100.11 0 1 570 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881 1881 1881 Earthenware 21 2 3/16 x 6 1/8 x 3/8 in. (5.5 x 15.6 x 1 cm) Funds from various donors, 1970 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
510 1970.100.12 0 1 571 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 ca. 1885 1882 1885 Earthenware 21 2 1/8 x 6 x 5/16 in. (5.4 x 15.2 x 0.8 cm) Funds from various donors, 1970 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
511 1971.182.3 0 1 572 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881 1881 1881 Earthenware 21 6 1/8 x 2 3/16 x 3/8 in. (15.6 x 5.6 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
512 1971.182.4 0 1 573 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1883 1883 1883 Earthenware 21 6 1/8 x 2 1/8 x 3/8 in. (15.6 x 5.4 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
513 1971.182.5 0 1 574 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881–85 1881 1885 Earthenware 21 6 1/8 x 2 3/16 x 5/16 in. (15.6 x 5.6 x 0.8 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
514 1971.182.6 0 1 575 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881 1881 1881 Earthenware 21 6 1/8 x 2 3/16 x 3/8 in. (15.6 x 5.6 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
515 1971.182.7 0 1 576 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881 1881 1881 Earthenware 21 6 1/8 x 2 1/8 x 3/8 in. (15.6 x 5.4 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
516 1971.182.8 0 1 577 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1882 1882 1882 Earthenware 21 6 3/16 x 2 3/16 x 3/8 in. (15.7 x 5.6 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
517 1971.182.9 0 1 578 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881 1881 1881 Earthenware 21 6 1/16 x 2 1/8 x 3/8 in. (15.4 x 5.4 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
518 1971.182.10 0 1 579 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1881 1881 1881 Earthenware 21 6 1/8 x 2 1/8 x 3/8 in. (15.6 x 5.4 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
519 1971.182.11 0 1 580 American Decorative Arts 1 Tile 101 Border Tile American 1         Maker 1   J. and J. G. Low Art Tile Works 1877–1907   Low Art Tile Works J. and J. G. 143   1877 1907 1885 1885 1885 Earthenware 21 6 1/16 x 2 1/8 x 3/8 in. (15.4 x 5.4 x 1 cm) Gift of Mrs. George F. Leonard, 1971 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
533 15.79.10 0 1 594 American Decorative Arts 1 Bottle 48 Bottle American 1                           1800–1830 1800 1830 Earthenware 21 6 1/8 x 2 1/2 in. (15.6 x 6.4 cm) Gift of Charles M. Baldwin, 1915 Made in 1 Norwich 5     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
534 18.95.1 0 1 595 American Decorative Arts 1 Ring bottle 102 Ring bottle American 1                           1820–30 1820 1830 Earthenware 21 H. 12 1/8 in. (30.8 cm) Rogers Fund, 1918 Probably made in 2       United States 3 Southern 4           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
536 20.109.18 0 1 597 American Decorative Arts 1 Bottle 48 Bottle American 1                           1820–50 1820 1850 Earthenware 21 H. 5 1/2 in. (14 cm) Gift of Robert Macauley Jackson, 1920 Made in 1       United States 3 Southern 4           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
537 26.277 0 1 598 American Decorative Arts 1 Bottle 48 Bottle American 1                           1770–1830 1770 1830 Earthenware 21 H. 6 1/4 in. (15.9 cm) Gift of Mrs. Barclay Ward, 1926 Possibly made in 5   Long Island 4 Long Island 4 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
732 1981.432.3 0 1 800 American Decorative Arts 1 Bowl 106 Bowl American 1         Maker|Maker 6   Jervis Pottery|William P. Jervis 1908–12|American (born England), Stoke-on-Trent 1851–1925 Sparta, New Jersey   Jervis Pottery |Jervis, William P. 163 American 1 1908 |1851 1912 |1925 1908–12 1908 1912 Earthenware 21 2 1/4 x 4 3/4 in. (5.7 x 12.1 cm) Gift of Florence I. Balasny-Barnes, in memory of her sister, Mrs. Ella B. Darivoff, 1981 Made in 1 Oyster Bay 12     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
746 69.37.3 0 0 817 American Decorative Arts 1 Bowl 106 Bowl American 1         Decorator|Manufacturer 21 Manufactured by Kataro Shirayamadani|Rookwood Pottery 1865–1948|American, Cincinnati, Ohio, 1880–1967   Shirayamadani, Kataro|Rookwood Pottery 172 American 1 1865 |1880 1865 |1967 1890 1890 1890 Earthenware 21 H. 5 9/16 in. (14.1 cm); Diam. 11 in. (27.9 cm) Purchase, The Edgar J. Kaufmann Foundation Gift, 1969 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
762 1980.452 0 1 834 American Decorative Arts 1 Bowl 106 Bowl American 1         Maker|Manufacturer 23 Manufactured by Albert R. Valentien|Rookwood Pottery American, Cincinnati, Ohio 1862–1925 San Diego, California|American, Cincinnati, Ohio, 1880–1967   Valentien, Albert R.|Rookwood Pottery 180 American|American 5 1862 |1880 1925 |1967 1882 1882 1882 Earthenware 21 H. 3 15/16 in. (10 cm); Diam. 10 in. (25.4 cm) Purchase, Sansbury-Mills Fund and Bequest of Herbert L. Pratt, by exchange, 1980 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
934 1984.220 0 1 1011 American Decorative Arts 1 Bread plate 128 Bread Plate American 1         Maker 1   Griffen, Smith and Hill 1880–1889   Griffen, Smith and Hill  200   1880 1889 1880–89 1880 1889 Earthenware 21 H. 9 1/2 in. (24.1 cm); Diam. 12 in. (30.5 cm) Gift of Beatrice B. Slater, 1984 Made in 1 Philadelphia 1     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
935 1986.241 0 0 1012 American Decorative Arts 1 Bread plate 128 Bread Plate British (American market) 2         Designer|Manufacturer 3 Designed by|Manufactured by Augustus Welby Northmore Pugin|Minton and Company British, London 1812–1852 Ramsgate|1793–present   Pugin, Augustus Welby Northmore|Minton and Company  201 British 7 1812 |1793 1852 |2002 ca. 1850 1847 1850 Earthenware 21 Diam. 13 in. (33 cm) Friends of the American Wing Fund, 1986 Made in 1 Stoke-on-Trent 79 Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1005 1971.180.139a, b 0 1 1088 American Decorative Arts 1 Cachepot 151 Cachepot British (American market) 2                           1775–1800 1775 1800 Earthenware 21 With stand: H. 4 7/8 in. (12.4 cm); Diam. 5 7/16 in. (13.8 cm) Bequest of Flora E. Whiting, 1971 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1006 1971.180.140a, b 0 1 1089 American Decorative Arts 1 Cachepot 151 Cachepot British (American market) 2                           1775–1800 1775 1800 Earthenware 21 With stand: H. 4 13/16 in. (12.2 cm); Diam. 5 1/2 in. (14 cm) Bequest of Flora E. Whiting, 1971 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1027 83.2.280 0 1 1111 American Decorative Arts 1 Cameo medallion 157 Cameo Medallion British 6                           1760–1800 1760 1800 Earthenware 21 4 x 3 1/8 in. (10.2 x 7.9 cm) Gift of William H. Huntington, 1883 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1028 83.2.282 0 0 1112 American Decorative Arts 1 Cameo medallion 157 Cameo Medallion British 6         Artist|Manufacturer 26 Manufactured by Jean-Baptiste Nini|Josiah Wedgwood and Sons Italian, Urbino 1717–1786 Chaumont-sur-Loire|1759–present   Nini, Jean-Baptiste|Wedgwood and Sons, Josiah 220 Italian 6 1717 |1759 1786 |9999 1777 (?) 1777 1777 Earthenware 21 4 x 3 1/16 in. (10.2 x 7.8 cm) Gift of William H. Huntington, 1883 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1030 83.2.289 0 0 1114 American Decorative Arts 1 Cameo medallion 157 Cameo Medallion British 6         Maker 1   Josiah Wedgwood and Sons 1759–present   Wedgwood and Sons, Josiah 124   1759 9999 1760–1883 1760 1883 Earthenware 21 2 5/8 x 2 in. (6.7 x 5.1 cm) Gift of William H. Huntington, 1883 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1093 18.95.4 0 1 1184 American Decorative Arts 1 Candlestick 163 Candlestick American 1                           1800–1830 1800 1830 Earthenware 21 H. 4 in. (10.2 cm); Diam. 5 in. (12.7 cm) Rogers Fund, 1918 Probably made in 2       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1100 37.134.8 0 0 1191 American Decorative Arts 1 Candlestick 163 Candlestick American 1                           1800–1900 1800 1900 Earthenware 21 H. 1 3/4 in. (4.4 cm); Diam. 2 5/8 in. (6.7 cm) Gift of Mrs. J. Insley Blair, 1937 Made in 1 Strasburg 33     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1403 1984.395.1 0 1 1513 American Decorative Arts 1 Celery vase 188 Celery vase American 1         Manufacturer 20   United States Pottery Company 1852–58   United States Pottery Company  75   1852 1852 1849–58 1849 1858 Earthenware 21 H. 10 in. (25.4 cm) Gift of Mrs. Stanley Herzman, 1984 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2030 68.197 0 0 2205 American Decorative Arts 1 Sweetmeat compote 261 Sweetmeat Compote British 6                           1790–1800 1790 1800 Earthenware 21 16 3/4 x 16 1/2 in. (42.5 x 41.9 cm) Gift of Ginsburg and Levy, Inc., 1968 Made in 1       England 4 Yorkshire and the Humber 7           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2109 36.22.15 0 0 2287 American Decorative Arts 1 Dish cover 277 Dish Cover British 6                           1750–75 1750 1775 Earthenware 21 3 1/8 x 9 7/8 x 6 7/8 in. (7.9 x 25.1 x 17.5 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2110 36.22.16 0 0 2288 American Decorative Arts 1 Dish cover 277 Dish Cover British 6                           1750–75 1750 1775 Earthenware 21 3 1/4 x 9 15/16 x 6 7/8 in. (8.3 x 25.2 x 17.5 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2113 1984.395.8 0 1 2291 American Decorative Arts 1 Ale pitcher 279 Covered ale pitcher American 1         Manufacturer 20   Lyman, Fenton & Co. 1849–52   Lyman, Fenton and Company  73   1849 1849 1849–52 1849 1849 Earthenware 21 H. 6 3/4 in. (17.1 cm) Gift of Mrs. Stanley Herzman, 1984 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2114 14.11.6 0 1 2292 American Decorative Arts 1 Bean pot 61 Covered bean pot American 1         Manufacturer 20   Lyman, Fenton & Co. 1849–52   Lyman, Fenton and Company  73   1849 1849 1849–52 1849 1849 Earthenware 21 8 3/4 in. (22.2 cm) Rogers Fund, 1914 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2118 11.87.48a, b 0 1 2296 American Decorative Arts 1 Bowl 106 Covered Bowl Mexican 11                           ca. 1825 1822 1825 Earthenware 21 Diam. 5 3/4 in. (14.6 cm) Gift of Mrs. Robert W. de Forest, 1911 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2124 34.100.153a, b 0 1 2302 American Decorative Arts 1 Bowl 106 Covered Bowl American 1                           1800–1830 1800 1830 Earthenware 21 H. 6 in. (15.2 cm); Diam. 5 in. (12.7 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2134 34.100.150a, b 0 1 2313 American Decorative Arts 1 Bowl 106 Covered Bowl American 1         Maker 1 Probably David Haring 1801–1871   Haring, David 367   1801 1871 ca. 1835 1832 1835 Earthenware 21 H. 4 1/2 in. (11.4 cm); Diam. 6 1/2 in. (16.5 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2135 34.100.151a, b 0 1 2314 American Decorative Arts 1 Bowl 106 Covered Bowl American 1         Maker 1 Probably David Haring 1801–1871   Haring, David 367   1801 1871 1830–70 1830 1870 Earthenware 21 H. 4 in. (10.2 cm); Diam. 6 3/4 in. (17.1 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2173 34.100.156a, b 0 1 2356 American Decorative Arts 1 Dish 110 Covered Dish American 1                           1800–1830 1800 1830 Earthenware 21 H. 3 1/4 in. (8.3 cm); Diam. 4 1/4 in. (10.8 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2178 13.31.19 0 1 2361 American Decorative Arts 1 Dish 110 Covered dish American 1         Maker 1   Ralph Bagnall Beech active 1845–57   Beech, Ralph Bagnall 375   1845 1845 1851–57 1851 1857 Earthenware 21 H. 4 7/8 in. (12.4 cm); Diam. 6 1/2 in. (16.5 cm) Rogers Fund, 1913 Made in 1 Kensington 130     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2202 36.22.8 0 1 2385 American Decorative Arts 1 Dish 110 Covered Dish British 6                           1750–75 1750 1775 Earthenware 21 5 x 11 1/2 x 8 1/2 in. (12.7 x 29.2 x 21.6 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2216 18.27.1a, b 0 1 2399 American Decorative Arts 1 Jar 116 Covered Jar American 1                           1800–1830 1800 1830 Earthenware 21 H. 13 1/2 in. (34.3 cm) Rogers Fund, 1918 Probably made in 2       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2224 26.25.1 0 1 2407 American Decorative Arts 1 Jar 116 Covered Jar Dutch 4         Designer|Manufacturer 3 Designed by|Manufactured by Justus Brouwer|The Porcelain Axe Dutch, active 1739–1775   Brouwer, Justus|Porcelain, Axe The 379 Dutch 11 1739 1775 1739–75 1739 1775 Earthenware 21 H. 15 in. (38.1 cm) Rogers Fund, 1926 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2227 18.95.17 0 1 2410 American Decorative Arts 1 Jar 116 Covered jar American 1                           ca. 1820–60 1820 1860 Earthenware 21 H. 10 in. (25.4 cm); Diam. 6 1/2 in. (16.5 cm) Rogers Fund, 1918 Probably made in 2       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2231 26.25.2 0 1 2415 American Decorative Arts 1 Jar 116 Covered Jar Dutch 4         Manufacturer|Designer 18 Manufactured by|Designed by The Porcelain Axe|Justus Brouwer Dutch, active 1739–1775   Porcelain, Axe The|Brouwer, Justus 381 Dutch 11 1739 1775 1739–75 1739 1775 Earthenware 21 H. 15 1/2 in. (39.4 cm) Rogers Fund, 1926 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2232 26.25.3 0 1 2416 American Decorative Arts 1 Jar 116 Covered Jar Dutch 4         Designer|Manufacturer 3 Designed by|Manufactured by Justus Brouwer|The Porcelain Axe Dutch, active 1739–1775   Brouwer, Justus|Porcelain, Axe The 379 Dutch 11 1739 1775 1739–75 1739 1775 Earthenware 21 H. 15 1/2 in. (39.4 cm) Rogers Fund, 1926 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2242 45.13.11a, b 0 1 2426 American Decorative Arts 1 Milk jug 294 Covered milk jug British (American market) 2         Maker 1 Possibly Wedgwood-Whieldon partnership 1754–59   Wedgwood-Whieldon, partnership  384   1754 1759 1750–60 1750 1760 Earthenware 21 H. 6 3/4 in. (17.1 cm) Gift of Josephine Atterbury, 1945 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2243 1987.111a, b 0 1 2427 American Decorative Arts 1 Mug 49 Covered mug American 1         Maker 1   John Bell American, Waynesboro, Pennsylvania, 1800–1880   Bell, John 385   1800 1880 1830–50 1830 1850 Earthenware 21 6 1/4 x 5 1/2 in. (15.9 x 14 cm) Purchase, Dr. and Mrs. Burton P. Fabricand Gift, 1987 Possibly made in|Possibly made in 3 Chambersburg|Waynesboro 133     United States|United States 8             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2246 13.7.17 0 0 2430 American Decorative Arts 1 Pitcher 296 Covered Pitcher American 1                           1700–1900 1700 1900 Earthenware 21 7 1/4 x 6 3/8 x 5 1/2 in. (18.4 x 16.2 x 14 cm) Rogers Fund, 1913 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2289 39.115.4a, b 0 1 2473 American Decorative Arts 1 Slop jar 304 Covered slop jar American 1         Maker|Manufacturer 23 Probably United States Pottery Company|Lyman, Fenton & Co. 1852–58|1849–52 or United States Pottery Company |Lyman, Fenton and Company  389   1852 |1849 1852 |1849 1849–58 1849 1849 Earthenware 21 H. 19 1/2 in. (49.5 cm) Gift of Mrs. J. Insley Blair, 1939 Probably made in 2 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2318 1982.440.2a, b 0 1 2503 American Decorative Arts 1 Sugar bowl 307 Covered Sugar Bowl American 1         Maker 1   Chelsea Keramic Art Works 1872–1889   Chelsea Keramic Art Works  390   1872 1889 1879–83 1879 1883 Earthenware 21 H. 4 1/4 in. (10.8 cm); Diam. 3 1/2 in. (8.9 cm) Gift of Mr. and Mrs. I. Wistar Morris III, 1982 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2328 36.22.13a, b 0 0 2513 American Decorative Arts 1 Sugar bowl 307 Covered Sugar Bowl British 6                           1750–75 1750 1775 Earthenware 21 4 7/8 x 6 5/8 x 4 in. (12.4 x 16.8 x 10.2 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2352 37.134.1a, b 0 0 2539 American Decorative Arts 1 Tobacco jar 311 Tobacco Jar American 1                           1800–1900 1800 1900 Earthenware 21 H. 8 in. (20.3 cm); Diam. 5 7/8 in. (14.9 cm) Gift of Mrs. J. Insley Blair, 1937 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2360 36.22.7a, b 0 1 2547 American Decorative Arts 1 Tureen 315 Covered Tureen British 6                           1750–75 1750 1775 Earthenware 21 8 x 12 3/4 x 7 5/8 in. (20.3 x 32.4 x 19.4 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2376 1981.432.4 0 1 2563 American Decorative Arts 1 Vase 7 Covered Vase American 1         Maker 1   Faience Manufacturing Company American, New York, 1881–1892   Faience Manufacturing Company  404 American 1 1881 1892 1886–90 1886 1890 Earthenware 21 H. 16 1/4 in. (41.3 cm); Diam. 8 1/2 in. (21.6 cm) Gift of Florence I. Balasny-Barnes, in memory of her parents, Elizabeth C. and Joseph Balasny, 1981 Made in 1 New York 3 Brooklyn 17 Brooklyn 17 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2378 33.57.1a, b 0 0 2565 American Decorative Arts 1 Vase 7 Covered Vase Dutch 4         Maker 1   Rose factory 1662–1854   Rose factory  406   1662 1854 1727–39 1727 1739 Earthenware 21 H. 13 1/4 in. (33.7 cm) Rogers Fund, 1933 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2379 33.57.2a, b 0 0 2566 American Decorative Arts 1 Vase 7 Covered Vase Dutch 4         Maker 1   Rose factory 1662–1854   Rose factory  406   1662 1854 1727–39 1727 1739 Earthenware 21 H. 13 1/4 in. (33.7 cm) Rogers Fund, 1933 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2380 33.57.3a, b 0 0 2567 American Decorative Arts 1 Vase 7 Covered Vase Dutch 4         Maker 1   Rose factory 1662–1854   Rose factory  406   1662 1854 1727–39 1727 1739 Earthenware 21 H. 13 1/4 in. (33.7 cm) Rogers Fund, 1933 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2387 1983.206.4 0 1 2578 American Decorative Arts 1 Figure 9 Recumbant cow American 1         Manufacturer 20   Lyman, Fenton & Co. 1849–52   Lyman, Fenton and Company  73   1849 1849 1849–52 1849 1849 Earthenware 21 10 x 7 in. (25.4 x 17.8 cm) Gift of Mr. and Mrs. Stanley Herzman, 1983 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2413 14.36.6a, b 0 1 2604 American Decorative Arts 1 Cream pot 284 Creamer American 1                           1830–60 1830 1860 Earthenware 21 5 3/4 x 7 1/4 in. (14.6 x 18.4 cm) Rogers Fund, 1914 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2491 38.165.3 0 1 2684 American Decorative Arts 1 Milk pitcher 321 Milk pitcher British 6                           1770–80 1770 1780 Earthenware 21 H. 5 1/8 in. (13 cm) Harris Brisbane Dick Fund, 1938 Made in 1       England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2565 20.109.16 0 1 2760 American Decorative Arts 1 Cup 107 Cup American 1                           1800–1850 1800 1850 Earthenware 21 3 x 5 3/8 x 4 3/8 in. (7.6 x 13.7 x 11.1 cm) Gift of Robert Macauley Jackson, 1920 Made in|Possibly made in 8 Hartford 26     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2659 1982.440.3a, b 0 1 2856 American Decorative Arts 1 Cup and saucer 285 Cup and Saucer American 1         Maker 1   Chelsea Keramic Art Works 1872–1889   Chelsea Keramic Art Works  390   1872 1889 1879–83 1879 1883 Earthenware 21 H. 2 1/2 in. (6.4 cm); Diam. 4 3/4 in. (12.1 cm) Gift of Mr. and Mrs. I. Wistar Morris III, 1982 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2660 1982.440.4a, b 0 1 2857 American Decorative Arts 1 Cup and saucer 285 Cup and Saucer American 1         Maker 1   Chelsea Keramic Art Works 1872–1889   Chelsea Keramic Art Works  390   1872 1889 1879–83 1879 1883 Earthenware 21 H. 2 1/2 in. (6.4 cm); Diam. 4 3/4 in. (12.1 cm) Gift of Mr. and Mrs. I. Wistar Morris III, 1982 Made in 1 Chelsea 56     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2661 1984.443.4a, b 0 1 2858 American Decorative Arts 1 Cup and saucer 285 Cup and Saucer American 1         Maker 1   Glasgow Pottery Company 1856–1906   Glasgow Pottery Company  446   1856 1906 1876 1876 1876 Earthenware 21 H. 2 1/8 in. (5.4 cm); Diam. 5 1/2 in. (14 cm) Gift of Florence I. Balasny-Barnes, in memory of her sister, Yvette B. Gould, 1984 Made in 1 Trenton 49     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2990 08.66.4 0 0 3206 American Decorative Arts 1 Dish 110 Dish Mexican 11                           1800–1900 1800 1900 Earthenware 21 Diam. 8 3/4 in. (22.2 cm) Gift of Garrett Chatfield Pier, 1908 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2993 11.87.49 0 1 3210 American Decorative Arts 1 Plate 356 Plate Mexican 11                           ca. 1820 1817 1820 Earthenware 21 Diam. 14 3/8 in. (36.5 cm) Gift of Mrs. Robert W. de Forest, 1911 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2994 11.87.50 0 1 3211 American Decorative Arts 1 Plate 356 Plate Mexican 11                           ca. 1825 1822 1825 Earthenware 21 Diam. 14 3/8 in. (36.5 cm) Gift of Mrs. Robert W. de Forest, 1911 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2995 11.87.57 0 1 3212 American Decorative Arts 1 Plate 356 Plate Mexican 11                           ca. 1840 1837 1840 Earthenware 21 Diam. 14 5/8 in. (37.1 cm) Gift of Mrs. Robert W. de Forest, 1911 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2996 11.87.88 0 0 3213 American Decorative Arts 1 Plate 356 Plate Mexican 11                           ca. 1830 1827 1830 Earthenware 21 Dimensions unavailable Gift of Mrs. Robert W. de Forest, 1911 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2997 13.6.2 0 1 3214 American Decorative Arts 1 Dish 110 Dish American 1                           1800–1830 1800 1830 Earthenware 21 H. 2 1/2 in. (6.4 cm); Diam. 10 in. (25.4 cm) Rogers Fund, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3002 18.95.9 0 1 3220 American Decorative Arts 1 Dish 110 Dish American 1                           ca. 1850 1847 1850 Earthenware 21 2 3/8 x 5 7/8 in. (6 x 14.9 cm) Rogers Fund, 1918 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3003 20.109.15 0 1 3221 American Decorative Arts 1 Dish 110 Dish American 1                           1800–1850 1800 1850 Earthenware 21 H. 2 1/2 in. (6.4 cm); Diam. 6 5/8 in. (16.8 cm) Gift of Robert Macauley Jackson, 1920 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3013 38.165.19 0 1 3231 American Decorative Arts 1 Dish 110 Dish German 27                           1720–30 1720 1730 Earthenware 21 Diam. 12 1/8 in. (30.8 cm) Harris Brisbane Dick Fund, 1938 Made in 1 Nuremberg 149     Germany 16             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3102 36.22.9 0 1 3320 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 2 3/4 x 12 1/2 x 7 1/2 in. (7 x 31.8 x 19.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3103 36.22.10 0 1 3321 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 3 3/8 x 1 3/8 x 8 1/8 in. (8.6 x 3.5 x 20.6 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3104 36.22.11 0 1 3322 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 1 7/8 x 10 3/8 x 7 7/8 in. (4.8 x 26.4 x 20 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3113 36.22.37 0 1 3331 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 H. 7 1/4 in. (18.4 cm); Diam. 6 in. (15.2 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3114 36.22.38 0 1 3332 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 H. 7 1/4 in. (18.4 cm); Diam. 6 in. (15.2 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3298 1984.443.8 0 1 3531 American Decorative Arts 1 Encaustic tile 401 Encaustic Tile American 1         Maker 1   American Encaustic Tile Company American, New York, 1875–before 1945   American Encaustic Tile Company 505 American 1 1875 1945 1870–75 1870 1875 Earthenware 21 4 5/16 x 4 5/16 x 1/2 in. (11 x 11 x 1.3 cm) Gift of Florence I. Balasny-Barnes, in memory of her sister, Yvette B. Gould, 1984 Made in 1 Zanesville 57     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3299 1984.448.1 0 1 3532 American Decorative Arts 1 Encaustic tile 401 Encaustic Tile American 1         Designer|Manufacturer 3 Designed by|Manufactured by Herman Carl Mueller|American Encaustic Tile Company 1854–1941|American, New York, 1875–before 1945   Mueller, Herman Carl|American Encaustic Tile Company 506 American 1 1854 |1875 1941 |1945 ca. 1890 1887 1890 Earthenware 21 12 1/8 x 18 in. (30.8 x 45.7 cm) Gift of Mr. and Mrs. I. Wistar Morris III, 1984 Made in 1 Zanesville 57     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3300 1984.48 0 0 3533 American Decorative Arts 1 Encaustic tile 401 Encaustic Tile American 1         Designer|Manufacturer 3 Designed by|Manufactured by Loiz Whitcomb Rhead|American Encaustic Tile Company American, New York, 1875–before 1945   Rhead, Loiz Whitcomb|American Encaustic Tile Company 507 American 1 1875 9999 |1945 1918 1918 1918 Earthenware 21 9 1/2 x 6 in. (24.1 x 15.2 cm) Friends of the American Wing Fund, 1984 Made in 1 Zanesville 57     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3336 1984.424 0 1 3571 American Decorative Arts 1 Ewer 227 Ewer American 1         Maker 1   Faience Manufacturing Company American, New York, 1881–1892   Faience Manufacturing Company  404 American 1 1881 1892 1886–90 1886 1890 Earthenware 21 H. 15 x 8 in. (38.1 x 20.3 cm) Friends of the American Wing Fund, 1984 Made in 1 New York 3 Brooklyn 17 Brooklyn 17 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3339 69.37.1 0 1 3574 American Decorative Arts 1 Ewer 227 Ewer American 1         Decorator|Manufacturer 21 Probably decorated by|Manufactured by Albert R. Valentien|Rookwood Pottery American, Cincinnati, Ohio 1862–1925 San Diego, California|American, Cincinnati, Ohio, 1880–1967   Valentien, Albert R.|Rookwood Pottery 180 American|American 5 1862 |1880 1925 |1967 1889 1889 1889 Earthenware 21 H. 9 1/4 in. (23.5 cm); Diam. 7 1/2 in. (19.1 cm) Purchase, The Edgar J. Kaufmann Foundation Gift, 1969 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3364 1971.180.114 0 1 3599 American Decorative Arts 1 Figure group 416 Figure Group British (American market) 2                           1785–1835 1785 1835 Earthenware 21 6 1/16 x 6 1/16 in. (15.4 x 15.4 cm) Bequest of Flora E. Whiting, 1971 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3365 1971.180.115 0 1 3600 American Decorative Arts 1 Figure group 416 Figure Group British (American market) 2                           1785–1835 1785 1835 Earthenware 21 8 7/16 x 4 7/16 in. (21.4 x 11.3 cm) Bequest of Flora E. Whiting, 1971 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3366 1971.180.116 0 1 3601 American Decorative Arts 1 Figure group 416 Figure Group British (American market) 2                           1785–1835 1785 1835 Earthenware 21 5 11/16 x 4 1/2 in. (14.4 x 11.4 cm) Bequest of Flora E. Whiting, 1971 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3396 69.2.1 0 1 3631 American Decorative Arts 1 Finger vase 420 Finger Vase British 6                           ca. 1785 1782 1785 Earthenware 21 9 x 8 5/8 x 2 3/4 in. (22.9 x 21.9 x 7 cm) Rogers Fund, 1969 Made in 1       England 4 Yorkshire and the Humber 7           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3397 69.2.2 0 0 3632 American Decorative Arts 1 Finger vase 420 Finger Vase British 6                           ca. 1785 1782 1785 Earthenware 21 9 x 8 5/8 x 2 3/4 in. (22.9 x 21.9 x 7 cm) Rogers Fund, 1969 Made in 1       England 4 Yorkshire and the Humber 7           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3508 1984.395.6 0 1 3746 American Decorative Arts 1 Flask 96 Flask American 1         Manufacturer 20 Manufactured by United States Pottery Company 1852–58   United States Pottery Company  75   1852 1852 1852–58 1852 1852 Earthenware 21 H. 6 in. (15.2 cm) Gift of Mrs. Stanley Herzman, 1984 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3670 83.2.82 0 1 3923 American Decorative Arts 1 Figure 9 George Washington British (American market) 2                           1800–30 1800 1830 Earthenware 21 H. 14 3/4 in. (37.5 cm) Gift of William H. Huntington, 1883 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1

Next page

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 363.787ms · Data license: CC0 · Data source: metmuseum/openaccess