MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 189 and Culture = 46

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Nationality, Medium, Classification

Artist Role

  • Artist|Artist|Artist|Artist · 5
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
38941 1975.268.133 0 1 45183 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Tani Bunchō|Watanabe Kazan|Sakai Hōitsu|sixty-six others Japanese, 1763–1840|Japanese, 1793–1841|Japanese, 1761–1828|Japanese   Tani Bunchō|Watanabe Kazan|Sakai Hōitsu|sixty-six others 3795 Japanese|Japanese|Japanese|Japanese 94 1763 |1793 |1761 1840 |1841 |1828 1820 1820 1820 Hanging scroll; ink and color on paper 7241 Image: 31 3/8 x 23 3/8 in. (79.7 x 59.4 cm) Overall with mounting: 64 5/8 x 25 3/4 in. (164.1 x 65.4 cm) Overall with knobs: 64 5/8 x 28 1/8 in. (164.1 x 71.4 cm) The Harry G. C. Packard Collection of Asian Art, Gift of Harry G. C. Packard, and Purchase, Fletcher, Rogers, Harris Brisbane Dick, and Louis V. Bell Funds, Joseph Pulitzer Bequest, and The Annenberg Fund Inc. Gift, 1975                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
65096 2011.149 0 0 76579 Asian Art 7 Woodblock prints 3908   Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Unidentified Artists|Utagawa Hirosada|Utagawa Kunimasu|Kunishige Japanese, active 1825–75|Japanese, active 1830–52|Japanese Japanese, (2)|(30)|(5)|(3) Unidentified Artists|Utagawa Hirosada|Utagawa Kunimasu|Kunishige 5027 Japanese|Japanese|Japanese 73 1825 |1830 1875 |1852 ca. 1852 1842 1862 Polychrome woodblock prints in single, diptych, triptych, tetraptych, and hexaptych form 14696 Each (chûban tate-e): 10 x 7 1/4 in. (25.4 x 18.4 cm) Purchase, Friends of Asian Art Gifts, in honor of James C. Y. Watt, 2011                       Prints 13   Metropolitan Museum of Art, New York, NY 1
66255 2013.843a, b 0 1 78733 Asian Art 7 Illustrated books 5103   Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Nukina Kaioku|Shiokawa Bunrin|Kawabata Gyokushō|Musō Soseki Japanese, 1778–1863|Japanese, 1808–1877|Japanese, 1842–1913|Japanese, 1275–1351 , et al Nukina Kaioku|Shiokawa Bunrin|Kawabata Gyokushō|Musō Soseki 5222 Japanese|Japanese|Japanese|Japanese 94 1778 |1808 |1842 |1275 1863 |1877 |1913 |1351 postscript dated 1861 1861 1861 Set of two woodblock printed books; ink and color on paper 15011 each: 10 3/16 × 6 11/16 in. (25.8 × 17 cm) Purchase, Mary and James G. Wallach Foundation Gift, 2013                       Illustrated Books 180   Metropolitan Museum of Art, New York, NY 1
66331 2013.793 0 1 78809 Asian Art 7 Illustrated book 3906 鳥文斎栄之・北川歌麿・礫川亭永理 葛飾北斎画  『男踏歌』|Men’s Stomping Dances (Otoko dōka) Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Rekisentei (Chōkyōsai) Eiri|Katsushika Hokusai|Chōbunsai Eishi|Kitagawa Utamaro Japanese, active ca. 1789–1801|Japanese, Tokyo (Edo) 1760–1849 Tokyo (Edo)|Japanese, 1756–1829|Japanese, ca. 1754–1806   Rekisentei Eiri|Katsushika Hokusai|Chōbunsai Eishi|Kitagawa Utamaro 5240 Japanese|Japanese|Japanese|Japanese 94 1789 |1760 |1756 |1754 1801 |1849 |1829 |1806 1798 1798 1798 Woodblock printed book; ink and color on paper 9286 10 1/16 × 7 1/2 in. (25.5 × 19 cm) Purchase, Mary and James G. Wallach Family Foundation Gift, in honor of John T. Carpenter, 2013                       Illustrated Books 180   Metropolitan Museum of Art, New York, NY 1
424498 SL.15.2018.1.6a, b 0 0 705076 Asian Art 7 Hanging scroll 3882 蜀山人(大田南畝)・式亭三馬他 諸家書画寄書|Drawings and Poems by Various Artists Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Shokusanjin (Ōta Nanpo)|Teisai Hokuba|Shikitei Sanba|Kitao Masanobu (Santō Kyōden) Japanese, 1749–1823|Japanese, 1771–1844|Japanese, 1776–1822|Japanese, 1761–1816 , and others Teisai Hokuba|Shikitei Sanba|Kitao Masanobu (Santō Kyōden) 54152   1749 |1771 |1776 |1761 1823 |1844 |1822 |1816 ca. 1814 1804 1824 Hanging scroll; ink and color on paper 7241 Image: 60 in. × 18 1/2 in. (152.4 × 47 cm) Overall with mounting: 81 × 24 7/8 in. (205.7 × 63.2 cm) Overall with knobs: 81 × 27 5/8 in. (205.7 × 70.2 cm) Lent by Fishbein-Bender Collection                       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 3778.664ms · Data license: CC0 · Data source: metmuseum/openaccess