MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

1,130 rows where Medium = 21 sorted by County

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
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
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
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
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
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
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
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
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
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
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
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
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
3697 93.8 0 1 3951 American Decorative Arts 1 Medallion 72 Medallion of George Washington British 6                           1776–96 1776 1796 Earthenware 21 H. 5 in. (12.7 cm) Gift of William H. Huntington, 1883 Made in 1       England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3698 42.76.38 0 0 3952 American Decorative Arts 1 Medallion 72 Medallion of George Washington British 6                           1778–88 1778 1788 Earthenware 21 14 x 11 1/2 in. (35.6 x 29.2 cm) Purchase, Joseph Pulitzer Bequest, 1942 Made in 1       England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4147 11.87.46 0 1 4476 American Decorative Arts 1 Jar 116 Globular Jar Mexican 11                           ca. 1800 1797 1800 Earthenware 21 H. 10 3/4 in. (27.3 cm); Diam. (base) 6 1/4 in. (15.9 cm) Gift of Mrs. Robert W. de Forest, 1911 Made in 1       Mexico 1             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4159 18.95.11 0 0 4488 American Decorative Arts 1 Jar 116 Jar American 1                           1800–1900 1800 1900 Earthenware 21 H. 10 1/2in. (26.7cm) Rogers Fund, 1918                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4162 26.25.6 0 1 4492 American Decorative Arts 1 Jar 116 Jar Dutch 4                           1700–1720 1700 1720 Earthenware 21 H. 9 3/4 in. (24.8 cm) Rogers Fund, 1926 Made in 1 Delft 9     Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4163 33.129.1a–c 0 1 4493 American Decorative Arts 1 Jar 116 Jar Dutch 4                           1740–60 1740 1760 Earthenware 21 H. 7 3/8 in. (18.7 cm) Gift of Mrs. Charles C. Kalbfleisch, 1933 Made in 1       Netherlands 7             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4176 67.84.1 0 0 4507 American Decorative Arts 1 Jar 116 Jar American 1         Maker|Designer 7   Newcomb Pottery|Mary W. Summey Smith 1894–1940|American, died 1980   Newcomb Pottery |Summey Smith, Mary W. 601 American 1 1894 1940 |1980 1911 1911 1911 Earthenware 21 H. 2 3/4 in. (7 cm); Diam. 2 1/8 in. (5.4 cm) Gift of Robert Blasberg, 1967 Made in 1 New Orleans 175     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4204 1996.371 0 0 4537 American Decorative Arts 1 Vase 7 Vase American 1         Designer|Manufacturer 3 Designed by|Manufactured by Frederick Hurten Rhead|Rhead Pottery American (born England), Hanley Stoke-on-Trent 1880–1942 New York   Rhead, Frederick Hurten|Rhead Pottery 604 American, born England 16 1880 1942 |9999 1913–17 1913 1917 Earthenware 21 H. 11 1/2 in. (29.2 cm) Friends of the American Wing Fund, 1996 Made in 1 Santa Barbara 185     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4225 13.7.19 0 0 4559 American Decorative Arts 1 Jug 293 Jug American 1                           1800–1900 1800 1900 Earthenware 21 H. 6 3/4 in. (17.1 cm); Diam. 5 1/8 in. (13 cm) Rogers Fund, 1913 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4229 18.95.18 0 1 4563 American Decorative Arts 1 Jug 293 Jug American 1                           ca. 1800–1830 1800 1830 Earthenware 21 H. 8 3/4 in. (22.2 cm); Diam. 6 3/4 in. (17.1 cm) Rogers Fund, 1918 Made in 1       United States 3 New England  1           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4232 34.100.148 0 1 4566 American Decorative Arts 1 Jug 293 Jug American 1                           ca. 1800–1840 1800 1840 Earthenware 21 H. 8 3/4 in. (22.2 cm) Gift of Mrs. Robert W. de Forest, 1933 Probably made in 2       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4234 38.165.22 0 1 4568 American Decorative Arts 1 Jug 293 Jug British 6                           ca. 1760 1757 1760 Earthenware 21 H. 6 1/8 in. (15.6 cm) Harris Brisbane Dick Fund, 1938 Made in 1       England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4249 1984.132 0 1 4584 American Decorative Arts 1 Jug 293 Jug American 1         Designer|Manufacturer 3 Possibly designed by|Manufactured by C. A. Lawrence|Beverly Pottery     Lawrence, C. A.|Beverly Pottery  618     9999 1875–80 1875 1880 Earthenware 21 H. 4 7/8 in. (12.4 cm); Diam. 1 7/8 in. (4.8 cm) Friends of the American Wing Fund, 1984 Made in 1 Beverly 46     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4250 18.95.19 0 1 4585 American Decorative Arts 1 Jug 293 Jug American 1                           ca. 1800–1830 1800 1830 Earthenware 21 H. 7 3/4 in. (19.7 cm); Diam. 6 5/8 in. (16.8 cm) Rogers Fund, 1918 Probably made in 2       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4423 17.83 0 1 4768 American Decorative Arts 1 Lavatory 570 Lavatory Mexican 11                           ca. 1830 1827 1830 Earthenware 21 54 1/2 x 83 x 25 1/2 in. (138.4 x 210.8 x 64.8 cm) Gift of Mrs. Robert W. de Forest, 1917 Made in 1       Mexico 1             Architecture 8   Metropolitan Museum of Art, New York, NY 1
4450 41.135.1 0 1 4796 American Decorative Arts 1 Figure 9 Standing lion American 1         Designer|Manufacturer|Manufacturer 42 Possibly designed by Daniel Greatbatch|Lyman, Fenton & Co.|United States Pottery Company active 1838–ca. 1861|1849–52|1852–58   Greatbach, Daniel|Lyman, Fenton and Company |United States Pottery Company  656 British 7 1838 |1849 |1852 1838 |1849 |1852 1849–52 1849 1849 Earthenware 21 9 1/4 x 10 7/8 x 5 7/8 in. (23.5 x 27.6 x 14.9 cm) Rogers Fund, 1941 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4546 1987.402.3 0 0 4900 American Decorative Arts 1 Plate 356 Plate American 1         Designer|Manufacturer 3 Designed by|Manufactured by Frank Lloyd Wright|Bauscher Brothers Porcelain Factory American, Richland Center, Wisconsin 1867–1959 Phoenix, Arizona   Wright, Frank Lloyd|Bauscher Brothers Porcelain Factory  662 American 1 1867 1959 |9999 ca. 1914 1911 1914 Earthenware 21 Diam. 7 1/2 in. (19.1 cm) Gift of Erving and Joyce Wolf, in memory of Diane R. Wolf, 1987 Made in 1 Riverside 181     United States 3             Ceramics 5 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
4911 12.221 0 1 5274 American Decorative Arts 1 Mug 49 Mug American 1                           1770–1800 1770 1800 Earthenware 21 H. 5 1/2 in. (14 cm); Diam. 3 3/4 in. (9.5 cm) Rogers Fund, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4950 1982.67.2 0 1 5314 American Decorative Arts 1 Mug 49 Mug American 1                           ca. 1770–1800 1770 1800 Earthenware 21 H. 5 in. (12.7 cm); Diam. 4 3/4 in. (12.1 cm) Sansbury-Mills Fund, 1982 Probably made in 2       United States 3 New England  1           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5236 1984.395.4 0 1 5608 American Decorative Arts 1 Frame 15 Frame American 1         Manufacturer 20   United States Pottery Company 1852–58   United States Pottery Company  75   1852 1852 1849–58 1849 1858 Earthenware 21 11 x 9 3/4 in. (27.9 x 24.8 cm) Gift of Mrs. Stanley Herzman, 1984 Made in 1 Bennington 25     United States 3             Frames 7   Metropolitan Museum of Art, New York, NY 1
5288 13.7.16 0 0 5661 American Decorative Arts 1 Pitcher 296 Pitcher American 1                           1700–1900 1700 1900 Earthenware 21 7 5/8 x 7 3/8 x 6 1/4 in. (19.4 x 18.7 x 15.9 cm) Rogers Fund, 1913 Made in 1       United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5331 37.134.6 0 0 5704 American Decorative Arts 1 Pitcher 296 Pitcher American 1                           1800–1900 1800 1900 Earthenware 21 3 3/4 x 4 1/4 x 3 1/2 in. (9.5 x 10.8 x 8.9 cm) Gift of Mrs. J. Insley Blair, 1937                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5335 39.115.1 0 1 5708 American Decorative Arts 1 Pitcher 296 Pitcher American 1                           ca. 1815 1815 1815 Earthenware 21 14 x 10 1/2 x 10 in. (35.6 x 26.7 x 25.4 cm) Gift of Mrs. J. Insley Blair, 1939 Made in 1       United States 3 New England  1           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5393 1983.206.6 0 1 5767 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker|Manufacturer 23 Attributed to Charles Coxon|E. & W. Bennett Pottery 1805–1868|1847–1857   Coxon, Charles|Bennett, E. and W. 791   1805 |1847 1805 |1847 ca. 1850–56 1847 1856 Earthenware 21 H. 8 1/2 in. (21.6 cm) Gift of Mr. and Mrs. Stanley Herzman, 1983 Made in 1 Baltimore 35     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5411 1984.443.2 0 1 5785 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker 1   Cook Pottery Company 1894–1929   Cook Pottery Company  797   1894 1929 ca. 1899 1896 1899 Earthenware 21 H. 6 1/2 in. (16.5 cm); Diam. 7 1/2 in. (19.1 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
5427 69.70 0 1 5803 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Manufacturer 20   Harker, Taylor and Company 1846–52   Harker, Taylor and Company  806   1846 1846 ca. 1846–52 1846 1846 Earthenware 21 H. 11 1/4 in. (28.6 cm) Purchase, The Edgar J. Kaufmann Foundation Gift, 1969 Made in 1 East Liverpool 70     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5439 43.105.4 0 1 5815 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker 1   Jersey City Pottery 1855–92   Jersey City Pottery  808   1855 1892 ca. 1850 1847 1850 Earthenware 21 H. 7 3/4 in. (19.7 cm) Gift of Mrs. Ernest H. Fairchild, 1943 Made in 1 Jersey City 122     United States 3             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 402.69ms · Data license: CC0 · Data source: metmuseum/openaccess