MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Medium = 7264

View and edit SQL

Suggested facets: Is Public Domain, Period, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End 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 Repository
30458 55.211.1 0 1 36070 Asian Art 7 Handscroll 3886   China 51 Ming dynasty (1368–1644)       Artist 2 Attributed to Dong Qichang Chinese, 1555–1636   Dong, Qichang 3232 Chinese 116 1555 1636 dated 1611 and 1612 1350 1650 Handscroll; ink on satin 7264 10 1/5 x 86 1/4 in. (25.9 x 219.1 cm) Gift of Wan-go H. C. Weng, 1955                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
42109 1989.363.98 0 1 48958 Asian Art 7 Handscroll 3886   China 51 Ming dynasty (1368–1644)       Artist 2   Dong Qichang Chinese, 1555–1636   Dong, Qichang 3232 Chinese 116 1555 1636   1555 1636 Handscroll; ink on satin 7264 10 1/2 x 72 5/16 in. (26.7 x 183.7 cm) Bequest of John M. Crawford Jr., 1988                       Calligraphy 173   Metropolitan Museum of Art, New York, NY 1
42120 1989.363.108 0 1 48969 Asian Art 7 Handscroll 3886 明 張瑞圖 後赤壁賦圖 卷|Second Ode on the Red Cliff China 51 Ming dynasty (1368–1644)       Artist 2   Zhang Ruitu Chinese, 1570–1641   Zhang Ruitu 4001 Chinese 116 1570 1641 dated 1628 1628 1628 Handscroll; ink on satin 7264 Image: 11 in. x 10 ft. 6 in. (27.9 x 320 cm) Overall with mounting: 12 1/4 in. x 34 ft. 2 3/4 in. (31.1 x 1043.3 cm) Bequest of John M. Crawford Jr., 1988                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
42270 1989.363.135 0 1 49143 Asian Art 7 Handscroll 3886 清 八大山人 (朱耷) 蓮塘戲禽圖 卷|Birds in a lotus pond China 51 Qing dynasty (1644–1911)       Artist 2   Bada Shanren (Zhu Da) Chinese, 1626–1705   Bada Shanren (Zhu Da) 3548 Chinese 116 1626 1705 ca. 1690 1680 1700 Handscroll; ink on satin 7264 10 3/4 x 80 3/4 in. (27.3 x 205.1 cm) Bequest of John M. Crawford Jr., 1988                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
63470 2015.784.8 0 1 73330 Asian Art 7 Handscroll 3886 明 二家法書合卷|Joint Calligraphy China 51 Ming dynasty (1368–1644)       Artist|Artist 13   Ni Yuanlu|Huang Daozhou Chinese, 1593–1644|Chinese, 1585–1646   Ni Yuanlu|Huang Daozhou 4909   1593 |1585 1644 |1646 dated 1632 1632 1632 Handscroll; ink on satin 7264 Image: 10 11/16 x 57 3/4 in. (27.1 x 146.7 cm) Overall with mounting: 10 13/16 x 357 7/16 in. (27.5 x 907.9 cm) Gift of Julia and John Curtis, 2015                       Calligraphy 173   Metropolitan Museum of Art, New York, NY 1
66361 SL.14.2014.1.29 0 0 78850 Asian Art 7 Handscroll 3886 清 王鐸 草書贈沈石友詩 卷 絹本|Poems dedicated to Shen Shiyou China 51 Qing dynasty (1644–1911)       Calligrapher 183   Wang Duo Chinese, 1592–1652   Wang Duo 3750 Chinese 116 1592 1652 1650 1650 1650 Handscroll; ink on satin 7264 Image: 10 1/2 in. × 12 ft. 6 in. (26.7 × 381 cm) Image (colophon): 10 3/4 × 12 in. (27.3 × 30.5 cm) Overall with knobs: 12 3/8 in. × 22 ft. 1 in. × 2 3/8 in. (31.4 × 673.1 × 6 cm) Lent by 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 132.669ms · Data license: CC0 · Data source: metmuseum/openaccess