MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Alpha Sort = 3739

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Period, Object Date, Object Begin Date, Object End Date, Medium, 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
38437 1989.139.1a–d 0 1 44580 Asian Art 7 Sliding-door panels 4622 列子図襖|The Daoist Immortal Liezi Japan 46 Momoyama period (1573–1615)       Artist 2   Kano School     Kano School 3739       ca. 1606 1596 1616 Set of four sliding-door panels; ink, color, gold, and gold leaf on paper  9140 Overall: 6 ft. x 24 ft. (182.9 x 731.5 cm) Purchase, Anonymous Gift, in honor of Ambassador and Mrs. Michael Mansfield, 1989                       Screens 190   Metropolitan Museum of Art, New York, NY 1
38439 1989.139.2a–d 0 1 44582 Asian Art 7 Screen 256 琴棋書画図襖の内|Appreciation of Painting, from a set of the Four Accomplishments Japan 46 Momoyama period (1573–1615)       Artist 2   Kano School     Kano School 3739       ca. 1606 1596 1616 Four of eight panels mounted on sliding-door panels; ink, color, gold, and gold leaf on paper  9141 72 in. × 24 ft. (182.9 × 731.5 cm) Purchase, Anonymous Gift, in honor of Ambassador and Mrs. Michael Mansfield, 1989                       Screens 190   Metropolitan Museum of Art, New York, NY 1
39247 36.100.79 0 1 45499 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist 2   Kano School     Kano School 3739       early 19th century 1800 1833 Hanging scroll; ink on paper 7253 12 1/2 x 19 1/8 in. (31.8 x 48.6 cm) The Howard Mansfield Collection, Purchase, Rogers Fund, 1936                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
39384 62.98.2, .3 0 1 45639 Asian Art 7 Screen 256 十二ヶ月花鳥図書画挿絵貼屏風|Birds and Flowers of the Twelve Months with Chinese Calligraphy Japan 46 Muromachi period (1392–1573)       Artist 2   Kano School     Kano School 3739       16th century; sheets of poetry, one dated 1553 1500 1599 Pair of six-panel folding screens; ink and color and gold leaf on paper 9515 Image (each screen): 60 11/16 x 139 1/8 in. (154.1 x 353.4 cm) Gift of Mrs. P. H. B. Frelinghuysen, 1962                       Screens 190   Metropolitan Museum of Art, New York, NY 1
39399 25.215.53 0 1 45654 Asian Art 7 Screen 256   Japan 46 Edo period (1615–1868)       Artist 2   Kano School     Kano School 3739       17th century 1600 1699 Two-panel folding screen; ink, color, and gold on paper (obverse); ink and color on paper (reverse side) 9518 22 x 73 1/2 in. (55.9 x 186.7 cm) Fletcher Fund, 1925                       Screens 190   Metropolitan Museum of Art, New York, NY 1
49320 36.100.80 0 1 57181 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist 2   Kano School     Kano School 3739         1615 1868 Hanging scroll; ink on paper 7253 40 3/4 x 11 5/8 in. (103.5 x 29.5 cm) The Howard Mansfield Collection, Purchase, Rogers Fund, 1936                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
49322 36.100.82 0 1 57183 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist 2   Kano School     Kano School 3739         1615 1868 Hanging scroll; ink on silk 7242 32 3/4 x 14 1/2 in. (83.2 x 36.8 cm) The Howard Mansfield Collection, Purchase, Rogers Fund, 1936                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
49979 27.95.1 0 1 57920 Asian Art 7 Printed scroll 5120   Japan 46         Artist 2   Kano School     Kano School 3739       1626 1626 1626 One of a set of two handscrolls; ink and color on paper, hand-tinted 12040 Image: 10 1/4 in. × 44 ft. 5 1/4 in. (26 × 1354.5 cm) Overall (entire length): 10 1/4 in. × 46 ft. 8 1/4 in. (26 × 1423 cm) Rogers Fund, 1927                       Prints 13   Metropolitan Museum of Art, New York, NY 1
52919 27.95.2 0 1 61180 Asian Art 7 Printed scroll 5120   Japan 46         Artist 2   Kano School     Kano School 3739       1626 1626 1626 One of a set of two handscrolls; ink and color on paper, hand-tinted 12040 Image: 10 1/4 in. × 41 ft. (26 × 1249.7 cm) overall (entire length): 10 1/4 in. × 43 ft. 4 1/16 in. (26 × 1321 cm) Rogers Fund, 1927                       Prints 13   Metropolitan Museum of Art, New York, NY 1
398882 2014.491.1, .2 0 1 653246 Asian Art 7 Screens 4613 東山遊楽図屏風|Amusements at Higashiyama in Kyoto Japan 46 Edo period (1615–1868)       Artist 2   Kano School     Kano School 3739       ca. 1620s 1620 1629 Pair of six-panel screens; ink, color, gold, mica, and gold leaf on paper  58839 Image (each screen): 33 1/16 in. × 8 ft. 11 1/2 in. (84 × 273 cm) Purchase, 2013 Benefit Fund and Mary and James G. Wallach Foundation Gift, 2014                       Screens 190   Metropolitan Museum of Art, New York, NY 1
440731 L.2018.7a, b 0 0 735202 Asian Art 7 Screens 4613 狩野派 竹林図屏風|Bamboo Grove Japan 46 Edo period (1615–1868)       Artist 2   Kano School   artist Kano School 3739       second half of the 17th–early 18th century 1650 1733 Pair of six-panel folding screens; ink, color, gold, and gold leaf on paper  61891 Image (each): 72 in. × 12 ft. 6 in. (182.9 × 381 cm) Lent by Leighton R. Longhi                       Screens 190   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 103.287ms · Data license: CC0 · Data source: metmuseum/openaccess