MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

46 rows where Medium = 7809

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Culture, Period, Object Date, Object Begin Date, Object End Date, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
33800 1997.1.12 0 1 39533 Asian Art 7 Incense burner 4170   China 51 Ming dynasty (1368–1644), Zhengde mark and period (1506–21)                         early 16th century 1500 1533 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 4 1/2 in. (11.5 cm) Gift of Stanley Herzman, in memory of Gladys Herzman, 1997                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
33893 1987.10 0 1 39638 Asian Art 7 Plate 356   China 51 Yuan dynasty (1271–1368)                         mid-14th century 1334 1366 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 Diam. 18 in. (45.7 cm) Purchase, Mrs. Richard E. Linburn Gift, 1987                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
33919 37.191.1 1 1 39666 Asian Art 7 Jar 116   China 51 Ming dynasty (1368–1644), Xuande mark and period (1426–35)                         early 15th century 1400 1433 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 19 in. (48.3 cm); Diam. 19 in. (48.3 cm) Gift of Robert E. Tod, 1937                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36211 1979.109 0 1 42190 Asian Art 7 Vase 7   China 51 Ming dynasty (1368–1644), Wanli mark and period (1573–1620)                         late 16th–early 17th century 1567 1633 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 25 1/8 in. (63.8 cm); Diam. 13 1/2 in. (34.3 cm); Diam. of rim 3 1/8 in. (7.9 cm); Diam. of base 8 in. (20.3 cm) Gift of Mrs. Eugene L. Garbáty, in memory of Eugene L. Garbáty, 1979                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36220 14.40.279 0 1 42200 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         late 17th–early 18th century 1667 1733 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 8 in. (20.3 cm) Bequest of Benjamin Altman, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36221 14.40.328 0 1 42201 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         late 17th century 1667 1799 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 9 7/8 in. (25.1 cm) Bequest of Benjamin Altman, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36222 14.40.288 0 1 42202 Asian Art 7 Bottle 48   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         late 17th–early 18th century 1667 1733 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 5 1/2 in. (14 cm) Bequest of Benjamin Altman, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36224 14.40.276 0 1 42204 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         late 17th–early 18th century 1667 1733 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 18 in. (45.7 cm) Bequest of Benjamin Altman, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36230 19.136.4 0 1 42210 Asian Art 7 Kendi 3933   China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                         late 16th century 1567 1599 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 7 3/8 in. (18.7 cm); W. 5 1/2 in. (14 cm) Rogers Fund, 1919                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36351 17.200 0 1 42337 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Shunzhi (1644–61) period                         mid-17th century 1634 1666 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 8 in. (20.3 cm); Diam. 3 3/8 (8.6 cm) Rogers Fund, 1918                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36508 1975.99 0 1 42497 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Xuande mark and period (1426–35)                           1426 1435 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 Diam. 8 1/8 in. (20.6 cm) Gift of Mrs. Richard E. Linburn, in memory of Richard E. Linburn, 1975                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36514 1991.253.37 0 1 42505 Asian Art 7 Flask 96   China 51 Ming dynasty (1368–1644)                         early 15th century 1400 1433 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 12 1/4 in. (31.1 cm) Gift of Stanley Herzman, in memory of Adele Herzman, 1991                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36518 1981.81.1 0 1 42509 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Chenghua period (1465–87)                         mid- to late 15th century 1434 1499 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 1 3/4 in. (4.4 cm); Diam. 8 1/2 in. (21.6 cm); Diam. of foot 5 in. (12.7 cm) Gift of Alan and Simone Hartman, 1981                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36520 1986.208.1 0 1 42511 Asian Art 7 Jar 116   China 51 Ming dynasty (1368–1644)                         15th–16th century 1400 1599 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 3 1/2 in. (8.9 cm); Diam. of rim 5 1/4 in. (13.3 cm); Diam. of foot 2 7/8 in. (13.3 cm) Purchase, Mrs. Richard E. Linburn Gift, 1986                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36534 25.216.3 0 1 42525 Asian Art 7 Bowl 106   China 51 Ming dynasty (1368–1644), Zhengde mark and period (1506–21)                         early 16th century 1500 1533 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 4 in. (10.2 cm); Diam. 6 1/8 in. (15.6 cm) Fletcher Fund, 1925                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36537 18.56.14 0 1 42528 Asian Art 7 Brush rest 4228   China 51 Ming dynasty (1368–1644), Zhengde mark and period (1506–21)                         early 16th century 1500 1533 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 L.: 8 3/4 in. (22.2 cm) Rogers Fund, 1918                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36538 63.155.2 0 1 42529 Asian Art 7 Bowl 106   China 51 Ming dynasty (1368–1644), Zhengde mark and period (1506–21)                         early 16th century 1500 1533 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 3 1/2 in. (8.9 cm); Diam. 8 1/8 in. (20.6 cm) Harris Brisbane Dick Fund, 1963                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36539 65.56.1a, b 0 1 42530 Asian Art 7 Box 114   China 51 Ming dynasty (1368–1644), Jiajing mark and period (1522–66)                         16th century 1500 1599 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 7 1/16 in. (17.9 cm); Diam. 11 5/8 in. (29.5 cm); H. (cover alone) 3 7/16 in. (8.7 cm) Purchase, Anonymous Gift, 1965                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36541 1991.253.48 0 0 42532 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Jiajing period (1522–66)                         dated 1561 1561 1561 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 1 3/4 in. (4.4 cm); Diam. 8 1/2 in. (21.6 cm); Diam. of foot 4 7/8 in. (12.4 cm) Gift of Stanley Herzman, in memory of Adele Herzman, 1991                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36542 25.64.12a, b 0 1 42533 Asian Art 7 Covered box 3931   China 51 Ming dynasty (1368–1644), Jiajing mark and period (1522–66)                         mid-16th century 1534 1566 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 4 in. (10.2 cm); Diam.15 1/2 in. (39.4 cm) Rogers Fund, 1925                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36545 17.118.11 0 1 42536 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Wanli mark and period (1573–1620)                         late 16th–early 17th century 1567 1633 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 1 1/4 in. (3.2 cm); Diam. 6 in. (15.2 cm); Diam. of foot 3 1/4 in. (8.3 cm) Rogers Fund, 1917                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36553 16.93 0 1 42544 Asian Art 7 Plate 356   China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                         late 16th–early 17th century 1567 1633 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 Diam. 14 1/4 in. (36.2 cm) Rogers Fund, 1916                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
38599 1991.253.38 0 1 44744 Asian Art 7 Tankard 888   China 51 Ming dynasty (1368–1644)                         early 15th century 1400 1433 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 3 5/8 in. (9.2cm); Diam. of rim: 2 3/8 in. (6 cm); Diam. of foot: 1 in. (2.5 cm) Gift of Stanley Herzman, in memory of Adele Herzman, 1991                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
38600 1991.253.39 0 1 44745 Asian Art 7 Bowl 106   China 51 Ming dynasty (1368–1644), Xuande mark and period (1426–35)                         early 15th century 1400 1433 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 8 1/4 in. (21 cm) Gift of Stanley Herzman, in memory of Adele Herzman, 1991                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41750 79.2.467 0 1 48559 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         early 18th century 1700 1733 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 14 1/2 in. (36.8 cm); Diam. 7 1/2 in. (19.1 cm); Diam. of rim: 2 1/16 in. (5.2 cm); Diam. of foot: 4 3/4 in. (12.1 cm) Purchase by subscription, 1879                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41866 14.40.317 0 1 48692 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         early 18th century 1700 1722 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 17 7/8 in. (45.4 cm); Diam. of rim 9 in. (22.9 cm); Diam. 7 1/4 in. (18.4 cm); Diam. of base 6 1/8 in. (15.6 cm) Bequest of Benjamin Altman, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
42313 16.61 0 1 49189 Asian Art 7 Vase 7   China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                         late 16th–17th century 1567 1633 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 21 1/4 in. (54 cm); Diam. 9 in. (22.9 cm); Diam. of rim 3 3/8 in. (8.6 cm); Diam. of foot 6 in. (15.2 cm) Rogers Fund, 1916                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
42541 2002.447.120a, b 0 1 49420 Asian Art 7 Teapot 26   Japan 46 Edo period (1615–1868)       Artist 2 Design attributed to Olfert Dapper Dutch, 1635–1689   Dapper, Olfert 4074 Dutch 11 1639 1689 early 18th century 1700 1733 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 6 1/2 in. (16.5 cm); W. 9 3/4 in. (24.8 cm) Dr. and Mrs. Roger G. Gerry Collection, Bequest of Dr. and Mrs. Roger G. Gerry, 2000                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
42956 1984.297 0 1 49855 Asian Art 7 Flask 96   China 51 Yuan dynasty (1271–1368)                         mid-14th century 1334 1366 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 11 1/4 in. (28.6 cm); Diam. 3 1/4 in. (8.3 cm) Gift of Irene and Earl Morse, 1984                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
43098 63.155.1 0 1 50021 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Zhengde mark and period (1506–21)                         early 16th century 1500 1533 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 1 7/8 (4.8 cm); Diam. 9 3/8 in. (23.8 cm) Harris Brisbane Dick Fund, 1963                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
43315 17.118.10 0 1 50263 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Jiajing mark and period (1522–66)                         mid-16th century 1534 1566 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 1 1/2 in. (3.8 cm); Diam. 7 5/8 in. (19.4 cm) Rogers Fund, 1917                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
43319 27.119.26a, b 0 1 50267 Asian Art 7 Covered box 3931   China 51 Ming dynasty (1368–1644), Wanli mark and period (1573–1620)                         late 16th–early 17th century 1567 1633 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 4 in. (10.2 cm); Diam. 8 1/2 in. (21.6 cm) Fletcher Fund, 1927                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
43901 79.2.357 0 1 50943 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         late 17th century 1667 1699 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 10 in. (25.4 cm); Diam. 4 1/2 in. (11.4 cm); Diam. of base 3 1/4 in. (8.3 cm); Diam. of rim 2 5/8 in. (6.7 cm) Purchase by subscription, 1879                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
44902 14.40.314 0 1 52042 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         early 18th century 1700 1722 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 17 3/4 in. (45.1 cm) Bequest of Benjamin Altman, 1913                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
45478 20.41.2 0 1 52777 Asian Art 7 Vase 7   China 51 Ming dynasty (1368–1644), Wanli mark and period (1573–1620)                         dated 1587 1587 1587 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 23 3/4 in. (60.3 cm); Diam. 12 7/8 in. (32.7 cm); Diam. of rim 7 5/8 in. (19.4 cm); Diam. of base 7 7/8 in. (20 cm) Rogers Fund, 1920                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
45479 18.56.8a, b 0 1 52778 Asian Art 7 Jar 116   China 51 Ming dynasty (1368–1644)                         early 16th century 1500 1533 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 16 in. (40.6 cm); Diam. 13 in. (33 cm) Rogers Fund, 1918                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
55947 2001.738 0 1 64484 Asian Art 7 Bowl 106   China 51 Ming dynasty (1368–1644), Jiajing mark and period (1522–66)                         mid-16th century 1534 1566 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 6 in. (15.2 cm); Diam. of mouth 12 1/4 in. (31.1 cm) Gift of Denise and Andrew Saul, 2001                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
62961 2005.257 0 0 72729 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Jiajing mark and period (1522–66)                         late 16th century 1567 1599 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 1 3/4 in. (4.4 cm); Diam. of rim 7 1/16 in. (17.9 cm); Diam. of foot 4 5/8 in. (11.7 cm) Purchase, Sir Joseph Hotung Gift, 2005                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
63907 2008.80 0 1 74336 Asian Art 7 Brush pot 4225   China 51 Ming dynasty (1368–1644), Chongzhen period (1628–44)                         mid-17th century 1634 1666 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 6 1/2 in. (16.5 cm) Diam. of rim: 4 7/8 in. (12.4 cm) Diam. of base: 4 7/16 in. (11.2 cm) Purchase, Gift of Elizabeth V. Cockcroft, by exchange, 2008                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
64507 2009.107 0 1 75261 Asian Art 7 Vessel (Kendi) 5816   China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                         late 16th–early 17th century 1567 1633 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 7 1/4 in. (18.4 cm); W. 4 1/2 in. (11.4 cm); D. 5 3/8 in. (13.7 cm) Purchase, The Vincent Astor Foundation Gift, 2009                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
64667 2010.59 0 1 75721 Asian Art 7 Bowl 106 明隆慶 景德鎮窯青花詩文碗|Bowl with inscription China 51 Ming dynasty (1368–1644), Longqing mark and period (1567–72)                         late 16th century 1567 1599 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 2 3/8 in. (6 cm); Diam. of rim: 4 11/16 in. (11.9 cm); Diam. of foot: 1 15/16 in. (4.9 cm) Purchase, The Vincent Astor Foundation Gift, 2010                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
64708 2010.206 0 1 75822 Asian Art 7 Dish 110 明晚期 景德鎮窯青花鹿馬山水富士山型盤|Dish in Shape of Mount Fuji with Horses and Deer China 51 Ming dynasty (1368–1644), Tianqi period (1621–27)                         ca. 1625 1615 1635 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 2 1/16 in. (5.3 cm); W. 9 7/8 in. (25.1 cm); L. 11 1/4 in. (28.5 cm) Purchase, Barbara and William Karatz Gift, Gift of C. T. Loo and Company, by exchange and Rogers Fund, by exchange, 2010                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
65236 2011.157 0 1 76734 Asian Art 7 Dish 110   China (for Japanese market) 1885 Ming dynasty (1368–1644), Chongzhen period (1628–44)                         mid-17th century 1634 1666 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 2 1/2 in. (6.4 cm); Diam. 11 in. (28 cm); Diam. of foot 4 3/4 in. (12.1 cm) Seymour Fund, 2011                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
425264 L.2017.53.3 0 0 706313 Asian Art 7 Dish 110 清康熙 景德鎮窯青花西廂記故事圖盤|Dish with Tryst Scene from Xixiang ji (Romance of the West Chamber) China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                           1662 1722 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 2 1/8 in. (5.4 cm); Diam. 7 1/4 in. (18.4 cm) Lent by a private collection                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
425266 L.2017.53.5 0 0 706315 Asian Art 7 Censer 3914 明崇禎 景德鎮窯青花十八羅漢圖香爐|Incense Burner with Eighteen Luohans China 51 Ming dynasty (1368–1644)                         ca. 1640 1630 1650 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 7 1/8 in. (18.1 cm); Diam. 13 3/16 in. (33.5 cm) Lent by a private collection                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
429360 L.2017.53.9 0 0 712496 Asian Art 7 Brush holder 4190 明末清初 景德鎮窯青花水滸故事圖筆筒|Brush holder with scene of Wang Qing crossing the river from The Water Margin (Shuihu zhuan) China 51 Ming (1368–1644) or Qing (1644–1911) dynasty                         dated 1636 or 1696 1636 1636 Porcelain painted with cobalt blue under transparent glaze (Jingdezhen ware)  7809 H. 91/4 in. (23.5 cm); Diam. 8 7/8 in. (22.5 cm) Lent by a private collection                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 123.664ms · Data license: CC0 · Data source: metmuseum/openaccess