MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Alpha Sort = 3651

View and edit SQL

Suggested facets: Is Highlight, Object Name, Period, Artist Prefix, 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
34470 29.100.453 0 1 40353 Asian Art 7 Painting 69   Japan 46 Edo period (1615–1868)       Artist 2 After Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651 Japanese 74 1504 1589 probably 19th century 1800 1868 Matted painting; ink on paper 8062 Image: 16 1/2 x 20 in. (41.9 x 50.8 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
38551 1992.8.1, .2 1 1 44696 Asian Art 7 Screen 256 猿猴捉月図屏風|Gibbons in a Landscape Japan 46 Muromachi period (1392–1573)       Artist 2   Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651 Japanese 74 1504 1589 ca. 1570 1560 1580 Pair of six-panel screens; ink on paper 9171 Image (each screen): 62 in. x 11 ft. 5 in. (157.5 x 348 cm) Purchase, Rogers Fund and The Vincent Astor Foundation, Mary Livingston Griggs and Mary Griggs Burke Foundation, and Florence and Herbert Irving Gifts, 1992                       Screens 190   Metropolitan Museum of Art, New York, NY 1
38897 1982.244.16 0 1 45072 Asian Art 7 Screen 256   Japan 46 Muromachi period (1392–1573)       Artist 2 Follower of Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651 Japanese 74 1504 1589 16th century 1500 1599 Six-panel folding screen; ink on paper 9290 60 1/2 in. x 11 ft. 8 1/4 in. (153.7 x 356.2 cm) Bequest of Hope Skillman Schary, 1981                       Screens 190   Metropolitan Museum of Art, New York, NY 1
39396 29.100.496 0 1 45651 Asian Art 7 Screen 256   Japan 46 Edo period (1615–1868)       Artist 2 Attributed to Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651 Japanese 74 1504 1589 17th century 1600 1699 Two-panel folding screen; ink on paper 9516 59 1/4 x 66 7/16 in. (150.5 x 168.8 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Screens 190   Metropolitan Museum of Art, New York, NY 1
45769 2015.300.54 0 1 53230 Asian Art 7 Hanging scroll 3882 雪村周継筆 山水図|Landscape with Rocky Precipice Japan 46 Muromachi period (1392–1573)       Artist 2   Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651   1504 1589 16th century 1504 1589 Hanging scroll; ink and color on paper 7241 Image: 11 7/8 × 18 3/8 in. (30.2 × 46.7 cm) Overall with mounting: 44 in. × 22 5/8 in. (111.8 × 57.4 cm) Overall with knobs: 44 × 24 1/2 in. (111.8 × 62.3 cm) Mary Griggs Burke Collection, Gift of the Mary and Jackson Burke Foundation, 2015                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
45770 2015.300.50 0 1 53231 Asian Art 7 Hanging scroll 3882 雪村周継筆 竹林七聖図|Seven Sages of the Bamboo Grove Japan 46 Muromachi period (1392–1573)       Artist 2   Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651   1504 1589 1550s 1550 1559 Hanging scroll; ink and color on paper 7241 Image: 40 5/16 × 20 3/8 in. (102.4 × 51.7 cm) Overall with mounting: 79 3/4 × 26 7/16 in. (202.5 × 67.2 cm) Overall with knobs: 79 3/4 × 28 9/16 in. (202.5 × 72.6 cm) Mary Griggs Burke Collection, Gift of the Mary and Jackson Burke Foundation, 2015                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
49314 36.100.64 0 1 57175 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist 2 After Sesson Shūkei ca. 1504–ca. 1589   Sesson Shūkei 3651 Japanese 74 1504 1589 probably 19th century 1800 1868 Hanging scroll; ink on paper 7253 28 1/2 x 16 in. (72.4 x 40.6 cm) The Howard Mansfield Collection, Purchase, Rogers Fund, 1936                       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 118.904ms · Data license: CC0 · Data source: metmuseum/openaccess