MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Medium = 7972

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Culture, Period, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date

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
34257 1973.120.6 1 1 40081 Asian Art 7 Handscroll 3886 元 錢選 王羲之觀鵝圖 卷|Wang Xizhi watching geese China 51 Yuan dynasty (1271–1368)       Artist 2   Qian Xuan Chinese, ca. 1235–before 1307   QIAN XUAN 3631 Chinese 116 1235 1307 ca. 1295 1285 1305 Handscroll; ink, color, and gold on paper 7972 Image: 9 1/8 x 36 1/2 in. (23.2 x 92.7 cm) Overall with mounting: 11 x 418 13/16 in. (27.9 x 1063.8 cm) Ex coll.: C. C. Wang Family, Gift of The Dillon Fund, 1973                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
34429 13.220.124 0 1 40311 Asian Art 7 Handscroll 3886 元/明 倣錢選 鮮于樞 歸去來辭 卷|Ode on Returning Home China 51         Artist 2 After Qian Xuan Chinese, ca. 1235–before 1307   QIAN XUAN 3631 Chinese 116 1235 1307 14th–15th century 1300 1499 Handscroll; ink, color, and gold on paper 7972 Image: 42 x 10 1/4 in. (106.7 x 26 cm) Overall with mounting: 12 1/4 in. x 13 ft. 6 in. (31.1 x 411.5 cm) John Stewart Kennedy Fund, 1913                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
38704 53.7.3 0 1 44849 Asian Art 7 Handscroll 3886 『妙法蓮華経』「観世音菩薩普門品」|“Universal Gateway,” Chapter 25 of the Lotus Sutra Japan 46 Kamakura period (1185–1333)       Artist 2 Calligrapher: Sugawara Mitsushige Japanese, active mid- 13th century   Sugawara Mitsushige 3760 Japanese 74 1234 1266 dated 1257 1257 1257 Handscroll; ink, color, and gold on paper 7972 Overall with mounting: 9 11/16 in. × 30 ft. 8 1/16 in. (24.6 × 934.9 cm) Purchase, Louisa Eldridge McBurney Gift, 1953                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
38802 12.134.11 0 1 44958 Asian Art 7 Handscroll 3886 源氏物語绘卷|Scene from the Tale of Genji (Genji monogatari e-maki) Japan 46 Edo period (1615–1868)       Artist 2   Kyō-Kano School     Kyō-Kano School 3779       mid-17th century 1634 1666 Handscroll; ink, color, and gold on paper 7972 Overall with mounting: 13 7/8 × 89 in. (35.2 × 226.1 cm) Rogers Fund, 1912                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
55856 2001.717 0 1 64381 Asian Art 7 Handscroll 3886   Japan 46 Edo period (1615–1868)                         late 17th–early 18th century 1667 1733 Handscroll; ink, color, and gold on paper 7972 1 ft. 1 3/8 in. x 18 ft. 1 7/8 in. (0.34 x 5.53 m) Overall (with mounting and rollers): 1 ft.1 3/8 in. x 20 ft. 5 1/8 in. (0.34 x 6.23 m) Gift of Carol and John Lyden, 2001                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
64687 SL.14.2011.7.3 0 0 75748 Asian Art 7     Japan 46 Edo period (1615–1868)                         19th century 1800 1899 Handscroll; ink, color, and gold on paper 7972 Image: 9 1/8 x 192 5/16 in. (23.2 x 488.4 cm) Mary and Jackson Burke Foundation                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
64690 SL.14.2011.8.1 0 0 75752 Asian Art 7 Handscroll 3886   Japan 46 Edo period (1615–1868)       Calligrapher 183   Asakura Jūken Japanese, active mid-17th century   Asakura Jūken 4960 Japanese 74 1634 1666 late 17th or early 18th century 1667 1733 Handscroll; ink, color, and gold on paper 7972 Overall: 13 1/8 x 435 1/16 in. (33.4 x 1105 cm) Lent by C. V. Starr East Asian Library, Columbia University                       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 116.759ms · Data license: CC0 · Data source: metmuseum/openaccess