MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 7313

View and edit SQL

Suggested facets: Is Public Domain, Culture, Period, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist 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 Repository
30649 1986.267.203a–l 0 0 36264 Asian Art 7 Album 1119 近代 黃賓虹 十二奇峰圖 冊頁|Sketches of Twelve Strange Mountain Peaks China 51         Artist 2   Huang Binhong Chinese, 1865–1955   Huang, Binhong 3355 Chinese 116 1865 1955 ca. 1935 1925 1945 Album of twelve leaves; ink on paper 7313 22 x 16 1/2 in. (55.9 x 41.9 cm) Gift of Robert Hatfield Ellsworth, in memory of La Ferne Hatfield Ellsworth, 1986                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
30661 1986.267.237a–l 0 0 36276 Asian Art 7 Album 1119 近代 齊白石 草蟲 冊頁十二幀|Insects and Plants China 51         Artist 2   Qi Baishi Chinese, 1864–1957   QI BAISHI 3260 Chinese 116 1864 1957 dated 1943 1943 1943 Album of twelve leaves; ink on paper 7313 10 1/8 x 13 1/2 in. (25.7 x 34.3 cm) Gift of Robert Hatfield Ellsworth, in memory of La Ferne Hatfield Ellsworth, 1986                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
30817 1986.495a–l 0 1 36432 Asian Art 7 Album 1119 清 金農 梅花圖 冊|Plum Blossoms China 51 Qing dynasty (1644–1911)       Artist 2   Jin Nong Chinese, 1687–1773   Jin Nong 3440 Chinese 116 1687 1773 dated 1757 1757 1757 Album of twelve leaves; ink on paper 7313 Image: 10 x 11 3/4 in. (25.4 x 29.8 cm) Edward Elliott Family Collection, Gift of Douglas Dillon, 1986                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
34129 1989.142a–l 0 1 39931 Asian Art 7 Album 1119 清 戴本孝 山水圖 冊 紙本|Landscapes China 51 Qing dynasty (1644–1911)       Artist 2   Dai Benxiao Chinese, 1621–1693   DAI BENXIAO 3598 Chinese 116 1621 1693   1621 1691 Album of twelve leaves; ink on paper 7313 Each: 8 7/16 × 6 9/16 in. (21.4 × 16.7 cm) Purchase, The Dillon Fund Gift, 1989                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
35534 1979.499a–l 0 1 41483 Asian Art 7 Album 1119 清 龔賢 山水圖 冊 紙本|Landscapes and trees China 51 Qing dynasty (1644–1911)       Artist 2   Gong Xian Chinese, 1619–1689   GONG XIAN 3263 Chinese 116 1619 1689 ca. 1679 1669 1689 Album of twelve leaves; ink on paper 7313 Image (each leaf): 6 1/4 x 7 1/2 in. (15.9 x 19.1 cm) From the P. Y. and Kinmay W. Tang Family Collection, Gift of Wen and Constance Fong, in honor of Mr. and Mrs. Douglas Dillon, 1979                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
42754 1986.267.134a–l 0 0 49643 Asian Art 7 Album 1119 近代 黃賓虹 冊頁|Sketches of Shating China 51         Artist 2   Huang Binhong Chinese, 1865–1955   Huang, Binhong 3355 Chinese 116 1865 1955 20th century 1861 1955 Album of twelve leaves; ink on paper 7313 22 x 16 1/4 in. (55.9 x 41.3 cm) Gift of Robert Hatfield Ellsworth, in memory of La Ferne Hatfield Ellsworth, 1986                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
63149 2005.411.7a–j 0 0 72954 Asian Art 7 Album 1119 現代 謝稚柳 臨張旭草書古詩帖 冊頁|Copy of Zhang Xu's Cursive Calligraphy of Four Ancient Poems China 51         Artist 2   Xie Zhiliu Chinese, 1910–1997   Xie Zhiliu 3419 Chinese 116 1910 1997 Datable to 1969–70 1969 1970 Album of twelve leaves; ink on paper 7313 Overall (backed, leaves a–j): 13 3/4 x 10 1/2 in. (34.9 x 26.7 cm) Gift of Sarah Shay, 2005                       Calligraphy 173 Estate of Xie Zhiliu Metropolitan Museum of Art, New York, NY 1
65057 SL.18.2011.1.27a–l 0 0 76512 Asian Art 7   明/清 黃向堅 尋親紀歷山水圖 冊|Journey in Search of My Parents China 51 late Ming (1368–1644) or early Qing dynasty (1644–1911)       Artist 2   Huang Xiangjian Chinese, 1609–1673   Huang Xiangjian 4928 Chinese 116 1609 1673 17th century 1609 1673 Album of twelve leaves; ink on paper 7313 Image (each): 10 1/4 x 12 3/8 in. (26 x 31.5 cm) Lent by The Chih Lo Lou Collection, Hong Kong                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
65874 2015.500.9.48 0 1 78079 Asian Art 7 Album 1119 「四時清雅」|"Refined Elegance in the Four Seasons" (Shiji seiga), Album of Flower Paintings Japan 46 Edo period (1615–1868)       Artist 2   Yamamoto Baiitsu Japanese, 1783–1856   Yamamoto Baiitsu 3728   1783 1783 1844 1844 1844 Album of twelve leaves; ink on paper 7313 Each leaf: 10 7/8 x 12 7/8 in. (27.6 x 32.7 cm) Gift of Florence and Herbert Irving, 2015                       Paintings 11   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 131.837ms · Data license: CC0 · Data source: metmuseum/openaccess