MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Medium = 7316

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Role, 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
30660 1986.267.234a–d 0 0 36275 Asian Art 7 Hanging scrolls 3893 近代 齊白石 水族圖 四屏|Water Life China 51         Artist 2   Qi Baishi Chinese, 1864–1957   QI BAISHI 3260 Chinese 116 1864 1957 dated 1940 1940 1940 Set of four hanging scrolls; ink on paper 7316 Image (each scroll): 25 3/4 × 6 in. (65.4 × 15.2 cm) Overall with mounting: 68 1/2 × 12 1/2 in. (174 × 31.8 cm) mounting/knobs: 68 1/2 × 15 3/4 in. (174 × 40 cm) Gift of Robert Hatfield Ellsworth, in memory of La Ferne Hatfield Ellsworth, 1986                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
38475 1990.322a–d 0 1 44620 Asian Art 7 Hanging scrolls 3893 清 鄭燮 遠山煙竹圖 軸|Misty Bamboo on a Distant Mountain China 51 Qing dynasty (1644–1911)       Artist 2   Zheng Xie Chinese, 1693–1765   Zheng Xie 3247 Chinese 116 1693 1765 dated 1753 1753 1753 Set of four hanging scrolls; ink on paper 7316 Overall with mounting (each): 107 1/4 × 27 in. (272.4 × 68.6 cm) From the P. Y. and Kinmay W. Tang Family Collection, Gift of Oscar L. Tang, 1990                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
64705 2010.327a–d 0 1 75814 Asian Art 7 Hanging scrolls 3893 吳煕載 篆書詩經南山有臺|Nutgrass Grows on the Southern Hills China 51 Qing dynasty (1644–1911)       Artist 2   Wu Xizai Chinese, 1799–1870   Wu Xizai 3285 Chinese 116 1799 1870 before 1862 1799 1862 Set of four hanging scrolls; ink on paper 7316 each: 12 3/16 x 51 9/16 in. (31 x 131 cm) Overall with mounting (each): 16 1/8 x 64 15/16 in. (41 x 165 cm) Gift of Judith G. and F Randall Smith, in honor of Wen C. Fong, 2010                       Calligraphy 173   Metropolitan Museum of Art, New York, NY 1
66343 SL.14.2014.1.17a–d 0 0 78831 Asian Art 7 Hanging scroll 3882 清 鄧石如 隷書程子視聽言動之箴 四條屏 紙本|Master Cheng’s Admonition on Seeing, Hearing, Words, and Deeds China 51 Qing dynasty (1644–1911)       Calligrapher 183   Deng Shiru Chinese, 1743–1805   Deng Shiru 5247 Chinese 116 1743 1805 1805 1805 1805 Set of four hanging scrolls; ink on paper 7316 Image (each scroll): 64 5/8 × 16 3/4 in. (164.1 × 42.5 cm) Overall with mounting (each scroll): 79 1/4 × 18 3/4 in. (201.3 × 47.6 cm) Lent by Guanyuan Shanzhuang Collection                       Calligraphy 173   Metropolitan Museum of Art, New York, NY 1
66375 SL.14.2014.1.37a–d 0 0 78865 Asian Art 7 Hanging scroll 3882 清 趙之謙 楷書 石颿銘 四條屏 紙本|Inscription on Stone Sails China 51 Qing dynasty (1644–1911)       Calligrapher 183   Zhao Zhiqian Chinese, 1829–1884   Zhao Zhiqian 3288 Chinese 116 1829 1884 1869 1869 1869 Set of four hanging scrolls; ink on paper 7316 Image (each scroll): 38 1/4 × 20 3/8 in. (97.2 × 51.8 cm) Overall with mounting (each scroll): 61 × 21 1/2 in. (154.9 × 54.6 cm) Promised Gift of Guanyuan Shanzhuang Collection                       Calligraphy 173   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 156.751ms · Data license: CC0 · Data source: metmuseum/openaccess