MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

41 rows where Medium = 7863

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Culture, Period, Object Date, Object Begin Date, Object End Date, Credit Line, 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 Metadata Date Repository
33931 33931 2015.500.1.70 0 1 39680 Asian Art 7 Dish 110 元 剔紅牡丹紋漆盤|Dish with peonies China 51 Yuan dynasty (1271–1368)                         14th century 1300 1368 Carved red lacquer 7863 H. 1/4 in. (.6 cm); Diam. 6 11/16 (17 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/39680 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
33932 33932 2015.500.1.71a, b 0 1 39681 Asian Art 7 Box 114 明嘉靖 剔紅捧聖龍紋漆盒|Box with dragon design China 51 Ming dynasty (1368–1644), Jiajing period (1522–66)                           1522 1566 Carved red lacquer 7863 H. 4 3/8 in. (11.1 cm); Diam. 10 in. (25.4 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/39681 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
33934 33934 2015.500.1.73 0 1 39683 Asian Art 7 Dish 110 明初 剔紅庭園高士圖漆盤|Dish with garden scene China 51 Ming dynasty (1368–1644)                         late 14th century 1368 1399 Carved red lacquer 7863 H. 1 1/4 in. (3.2 cm); Diam. 7 3/34 in. (19.7 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/39683 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
33936 33936 2015.500.1.75a–e 0 0 39685 Asian Art 7 Four tiered box 4195   China 51 Qing dynasty (1644–1911)                         18th century 1600 1900 Carved red lacquer 7863 H. 7 1/2 in. (19.1 cm); W. 5 3/4 in. (14.6 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/39685 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34344 34344 2011.120.1 0 1 40211 Asian Art 7 Dish 110 元 剔紅綬帶秋葵紋漆盤|Dish with long-tailed birds and hollyhock China 51 Yuan dynasty (1271–1368)                         14th century 1300 1368 Carved red lacquer 7863 H. 1/8 in. (0.3 cm); Diam. 12 3/4 in. (32.4 cm) Gift of Florence and Herbert Irving, in honor of James C. Y. Watt, 2011                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40211 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34346 34346 2015.500.1.29 0 1 40213 Asian Art 7 Dish 110 明永樂 剔紅孔雀牡丹紋盤|Dish with peafowls and peonies China 51 Ming dynasty (1368–1644), Yongle period (1403–24)                         early 15th century 1400 1433 Carved red lacquer 7863 H. 1/8 in. (0.3 cm); Diam. 12 3/4 in. (32.4 cm)； Diam. of foot 9 7/8 in. (25.1 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40213 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34347 34347 2015.500.1.30a, b 0 1 40214 Asian Art 7 Dishes 4265 明早期 剔紅花卉紋漆盤一對|Pair of dishes with flowers China 51 Ming dynasty (1368–1644)                         late 14th century–15th century 1367 1499 Carved red lacquer 7863 Diam. (each) 6 in. (15.2 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40214 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34348 34348 2015.500.1.31 0 1 40215 Asian Art 7 Tray 768 元 剔紅仕女嬰戲圖漆盤|Tray with women and boys on a garden terrace China 51 Yuan dynasty (1271–1368)                         14th century 1300 1399 Carved red lacquer 7863 H. 2 3/8 in. (6 cm); Diam. 21 7/8 in. (55.6 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40215 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34349 34349 2015.500.1.32 0 1 40216 Asian Art 7 Dish 110 元 剔紅高仕圖菱形漆盤|Lozenge-shaped dish with garden scene China 51 Yuan dynasty (1271–1368)                         14th century 1300 1368 Carved red lacquer 7863 H. 7/8 in. (2.2 cm); W. 5 3/8 in. (13.7 cm); L. 7 7/8 in. (20 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40216 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34352 34352 2015.500.1.6a, b 0 1 40219 Asian Art 7 Box 114 明永樂 剔紅庭園高仕圖漆盒|Box with garden scene China 51 Ming dynasty (1368–1644), Yongle period (1403–24)                         1403–1424 1403 1424 Carved red lacquer 7863 H. 2 7/8 in. (7.3 cm); Diam. 8 3/4 in. (22.2 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40219 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34353 34353 2015.500.1.35 0 1 40220 Asian Art 7 Stand 342 明永樂 剔紅鳳穿花盞托|Tea-bowl stand with phoenixes China 51 Ming dynasty (1368–1644), Yongle period (1403–24)                           1403 1424 Carved red lacquer 7863 H. 3 in. (7.6 cm); Diam. 6 1/2 in. (16.5 cm); Diam. of rim 3 3/4 in. (9.5 cm); Diam. of foot 3 1/4 in. (8.3 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40220 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34354 34354 2015.500.1.36 0 1 40221 Asian Art 7 Fly whisk 4266 明中期 剔紅四季花卉紋拂塵|Fly whisk with the Flowers of the Four Seasons China 51 Ming dynasty (1368–1644)                         16th century 1500 1599 Carved red lacquer 7863 L. (of handle) 11 1/4 in.(28.5 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40221 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34355 34355 2015.500.1.37a, b 0 1 40222 Asian Art 7 Writing brush 4262 晚明 剔紅雕漆筆|Writing brush and cover China 51 Ming dynasty (1368–1644)                         late 16th century 1567 1599 Carved red lacquer 7863 L. 9 in. (22.9 cm); Diam. 1/2 in. (1.3 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40222 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34357 34357 2015.500.1.39 0 1 40224 Asian Art 7 Tray 768 明嘉靖 剔紅雲龍捧聖紋漆盤|Tray with dragon and Chinese characters China 51 Ming dynasty (1368–1644), Jiajing period (1522–66)                         1522–1566 1522 1566 Carved red lacquer 7863 H. 2 in. (5.1 cm); Diam. 14 1/2 in. (36.8 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40224 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34359 34359 2015.500.1.41 0 1 40226 Asian Art 7 Dish 110 明嘉靖 剔紅壽字紋八角漆盤|Dish with character for longevity (shou) China 51 Ming dynasty (1368–1644), Jiajing period (1522–66)                         1522–1566 1522 1566 Carved red lacquer 7863 H. 1 5/16 in. (3.3 cm); Diam. 6 /4 in. (17.1 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40226 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34363 34363 2015.500.1.44 0 1 40230 Asian Art 7 Bowl 106 明萬曆 剔紅雲龍紋碗|Bowl with dragon China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                         dated 1589 1589 1589 Carved red lacquer 7863 H. 2 7/8 in. (7.4 cm); Diam. 5 3/8 in. (13.7 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40230 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34364 34364 2015.500.1.45 0 1 40231 Asian Art 7 Dish 110 明萬曆 剔紅龍紋盤|Dish with dragon China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                           1573 1620 Carved red lacquer 7863 H. 1 1/4 in. (3.2 cm); Diam. 6 1/4 in. (15.9 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40231 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34367 34367 2015.500.1.48a, b 0 1 40234 Asian Art 7 Box 114   China 51 Yuan dynasty (1271–1368)                         14th century 1300 1368 Carved red lacquer 7863 Diam. 2 1/2 in. (6.5 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40234 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34368 34368 2015.500.1.8a, b 0 1 40235 Asian Art 7 Box 114 清乾隆 剔紅雲龍寶盒|Box with dragons in clouds China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                           1736 1795 Carved red lacquer 7863 H. 1 3/4 in. (4.4 cm); Diam. 5 1/8 in. (13 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40235 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34377 34377 2015.500.1.49 0 1 40245 Asian Art 7 Brush holder 4190 清乾隆 剔紅庭園人物圖筆筒|Brush holder with scholars in a garden China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                         18th century 1736 1795 Carved red lacquer 7863 H. 6 1/2 in. (16.5 cm); Diam. 6 3/4 in. (17.1 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40245 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
34379 34379 2015.500.1.50a, b 0 1 40247 Asian Art 7 Octagonal box 4269   China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                         18th century 1736 1795 Carved red lacquer 7863 H. 8 5/8 in. (21.9 cm); Diam. 11 in. (27.9 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/40247 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
35292 35292 14.40.479a, b 0 1 41240 Asian Art 7 Snuff bottle 4192   China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                           1736 1795 Carved red lacquer 7863 H. 2 7/8 in. (7.3 cm) Bequest of Benjamin Altman, 1913                       Snuff Bottles 195   http://www.metmuseum.org/art/collection/search/41240 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
35656 35656 21.175.359a, b 0 1 41607 Asian Art 7 Snuff bottle 4192   China 51 Qing dynasty (1644–1911)                         18th century 1700 1799 Carved red lacquer 7863 H. 2 1/2 in. (6.4 cm); H. incl. stand 3 1/4 in. (8.3 cm); W. 2 3/8 in. (6 cm); D. 1 in. (2.5 cm) Bequest of Edmund C. Converse, 1921                       Snuff Bottles 195   http://www.metmuseum.org/art/collection/search/41607 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
50212 50212 38.25.101a, b 0 1 58275 Asian Art 7 Box 114 江戸時代 楼閣山水堆朱香合|Box with Landscape and Scroll Pattern Japan 46 Edo period (1615–1868)                           1615 1868 Carved red lacquer 7863 H. 2 1/8 in. (5.4 cm); W. 3 5/8 in. (9.2 cm); L. 6 7/8 in. (17.5 cm) Gift of Mrs. George A. Crocker (Elizabeth Masten), 1937                       Lacquer 179   http://www.metmuseum.org/art/collection/search/58275 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
50644 50644 29.100.852 0 1 58778 Asian Art 7 Inrō 3889   Japan 46 Edo period (1615–1868)                         18th–19th century 1700 1899 Carved red lacquer 7863 3 9/16 x 2 11/16 x 1 3/16 in. (9 x 6.8 x 3 cm) Netsuke: H. 1/2 in. (1.3 cm); Diam. 2 in. (5.1 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Inrō 175   http://www.metmuseum.org/art/collection/search/58778 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52656 52656 91.1.638 0 1 60909 Asian Art 7 Box 114 明晚期 剔紅綬帶牡丹紋漆盒|Box with long-tailed birds and peonies China 51 Ming dynasty (1368–1644)                         second half of the 16th century 1550 1599 Carved red lacquer 7863 H. 1 3/4 in. (4.4 cm); Diam. 4 1/4 in. (10.8 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60909 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52660 52660 91.1.728 0 1 60913 Asian Art 7 Box with cover 1134 明萬曆 剔紅鳳凰雙螭紋漆盒|Box with patterns of phoenixes and chi dragons China 51 Ming dynasty (1368–1644), Wanli period (1573–1620)                           1573 1620 Carved red lacquer 7863 H. 7 in. (17.8 cm); Diam. 13 1/2 in. (34.3 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60913 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52663 52663 13.100.139 0 1 60916 Asian Art 7 Vase 7 清晚期 剔紅開光山水紋漆瓶|Vase with peony scroll and landscape panels China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Carved red lacquer 7863 H. 18 1/2 in. (47cm); Diam. 13 1/2 in. (34.3cm); Diam. of rim: 4 1/2 in. (11.4 cm); Diam. of foot: 8 1/4 in. (21 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60916 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52666 52666 13.100.143a, b 0 1 60919 Asian Art 7 Box with cover 1134 清乾隆 剔紅昇平寶盒一對|One of a pair of boxes with elephants China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                           1736 1795 Carved red lacquer 7863 H. 4 1/8 in. (10.5 cm); Diam. 8 1/8 in. (20.6 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60919 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52667 52667 13.100.144a, b 0 1 60920 Asian Art 7 Box with cover 1134 清乾隆 剔紅昇平寶盒一對|One of a pair of boxes with elephants China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                           1736 1795 Carved red lacquer 7863 H. 4 1/8 in. (10.5 cm); Diam. 8 1/8 in. (20.6 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60920 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52668 52668 13.100.145 0 1 60921 Asian Art 7 Brush holder 4190 明嘉靖 剔紅雲龍紋漆筒|Brush holder with dragons and clouds China 51 Ming dynasty (1368–1644), Jiajing period (1522–66)                           1522 1566 Carved red lacquer 7863 H. 10 3/8 in. (26.4 cm); Diam. 4 1/2 in. (11.4 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60921 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52669 52669 13.100.146 0 1 60922 Asian Art 7 Box 114 清晚期 剔紅藝菊圖漆盒|Box with figures in a landscape China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Carved red lacquer 7863 H. 2 1/8 in. (5.4 cm); W. 5 3/8 in. (13.7 cm); L. 5 3/8 in. (13.7 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60922 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52673 52673 13.100.150a–c 0 1 60926 Asian Art 7 Box 114   China 51 Qing dynasty (1644–1911)                         18th century 1700 1799 Carved red lacquer 7863 H. 3 in. (7.6 cm); W. 3 in. (7.6 cm); L. 3 in. (7.6 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60926 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52675 52675 13.220.49a–d 0 1 60928 Asian Art 7 Screens 4613   China 51 Qing dynasty (1644–1911)                         late 17th–early 18th century 1667 1733 Carved red lacquer 7863 Screen (each): 8 5/8 x 5 in. (21.9 x 12.7 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60928 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52683 52683 13.220.57a, b 0 1 60937 Asian Art 7 Pair of boxes 5247 清晚期 剔紅瓜瓞綿延圖盒|Pair of boxes with melons and butterflies China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Carved red lacquer 7863 H. 1 3/8 in. (3.5 cm); Diam. 2 7/8 in. (7.3 cm) John Stewart Kennedy Fund, 1913                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60937 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52721 52721 58.64.19c, d 0 1 60975 Asian Art 7 Box 114 清乾隆 剔紅蝙蝠紋筆盒|Presentation box for a brush China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                           1736 1795 Carved red lacquer 7863 Box (bottom): H. 1 1/2 in. (3.8 cm); W. 1 3/4 in. (4.4 cm); L. 12 3/8 in. (31.4 cm) Lid: H. 9/16 in. (1.4 cm); W. 1 1/2 in. (3.8 cm); L. 12 1/8 in. (30.8 cm) Box closed: H. 2 in. (5.1 cm) Gift of A. W. Bahr, 1958                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60975 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
52726 52726 1974.269a, b 0 1 60980 Asian Art 7 Box 114 明 永樂 剔紅牡丹紋盒|Box with peonies China 51 Ming dynasty (1368–1644), Yongle period (1403–24)                         15th century 1400 1499 Carved red lacquer 7863 H. 2 3/4 in. (6.4 cm); Diam. 6 1/4 in. (15.9 cm) Purchase, Arthur M. Sackler Gift, 1974                       Lacquer 179   http://www.metmuseum.org/art/collection/search/60980 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
62967 62967 2005.140a, b 0 1 72740 Asian Art 7 Box 114   China 51 Southern Song dynasty (1127–1279)                         13th century 1200 1299 Carved red lacquer 7863 H. 1 1/2 in. (3.8 cm), Diam. 5 in. (12.7 cm) Purchase, Barbara and Sorrell Mathes Gift, 2005                       Lacquer 179   http://www.metmuseum.org/art/collection/search/72740 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
407956 407956 2015.500.1.103a, b 0 1 666988 Asian Art 7 Brush 4359 明晚期 剔紅梅紋漆筆|Brush with plum blossoms China 51 Ming dynasty (1368–1644)                         second half of the 16th century 1550 1599 Carved red lacquer 7863 L. incl. cover 9 in. (22.9 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/666988 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
407960 407960 2015.500.1.104 0 1 667132 Asian Art 7 Wrist rest 4229 明 剔紅蓮池水禽紋臂擱|Wrist rest with kingfisher and lotus China 51 Ming dynasty (1368–1644)                         1368–1644 1368 1644 Carved red lacquer 7863 L. 9 in. (22.9 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/667132 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
407978 407978 2015.500.1.102a, b 0 1 667277 Asian Art 7 Box 114 明中期 剔紅梅花紋漆盒|Box with plum spray China 51 Ming dynasty (1368–1644)                         16th century 1500 1599 Carved red lacquer 7863 H. 1 3/4 in. (4.4 cm); Diam. 3 1/4 in. (8.3 cm) Gift of Florence and Herbert Irving, 2015                       Lacquer 179   http://www.metmuseum.org/art/collection/search/667277 4/23/2018 8:00:01 AM 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 142.033ms · Data license: CC0 · Data source: metmuseum/openaccess