MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Alpha Sort = 4037

View and edit SQL

Suggested facets: Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Nationality, Artist Begin Date, Artist End Date, 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
42221 1975.268.132 0 1 49093 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist|Artist 13   Shokusanjin (Ōta Nanpo)|Utamaro II Japanese, 1749–1823|Japanese (died 1831?) , and others Utamaro II 4037 Japanese|Japanese 72 1749 |1750 1823 |1850 ca. 1801–6 1791 1806 Hanging scroll; ink and color on paper  9372 Image: 35 5/8 x 12 in. (90.5 x 30.5 cm) Overall: 67 3/4 x 15 5/8 in. (172.1 x 39.7 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
46646 1991.341 0 1 54231 Asian Art 7 Woodblock print 3907   Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850 ca. 1807 1797 1817 Polychrome woodblock print (surimono); ink and color on paper 7358 15 3/4 x 21 5/8 in. (40 x 54.9 cm) (unfolded) Gift of Joan B. Mirviss and Robert J. Levine, in memory of Carolyn D. Solomon, 1991                       Prints 13   Metropolitan Museum of Art, New York, NY 1
47243 JP1000 0 1 54877 Asian Art 7 Print 731 風流六玉川 紀伊 高野の玉川|The Kōya no Tamagawa, Province of Kii Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850 ca. 1806 1796 1816 Polychrome woodblock print; ink and color on paper 7352 H. 13 7/8 in. (35.2 cm); W. 8 7/8 in. (22.5 cm) Gift of Estate of Samuel Isham, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
47244 JP1001 0 1 54878 Asian Art 7 Woodblock print 3907   Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850 ca. 1806 1796 1816 Polychrome woodblock print; ink and color on paper 7352 H. 15 in. (38.1 cm); W. 9 5/8 in. (24.4 cm) Gift of Estate of Samuel Isham, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
47245 JP1002 0 1 54879 Asian Art 7 Print 731 遊君出そめ初衣裳 扇屋内花扇|The Oiran Hanaogi of Ogiya attended by Two Shinzo and Her Kamuro Yoshino Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850 ca. 1806 1796 1816 Polychrome woodblock print; ink and color on paper 7352 H. 14 5/8 in. (37.1 cm); W. 9 1/2 in. (24.1 cm) Gift of Estate of Samuel Isham, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
47390 JP1089 0 1 55026 Asian Art 7 Print 731 青楼美人 六花撰 岡本屋内 重岡|A Courtesan with Morning-glories on the Background Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850   1615 1831 Polychrome woodblock print; ink and color on paper 7352 H. 14 1/4 in. (36.2 cm); W. 9 3/8 in. (23.8) The Metropolitan Museum of Art                       Prints 13   Metropolitan Museum of Art, New York, NY 1
47391 JP1090 0 1 55027 Asian Art 7 Print 731 青楼美人 六花撰 扇屋内花扇|A Courtesan with Wisteria on the Background Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850   1615 1831 Polychrome woodblock print; ink and color on paper 7352 H. 14 1/8 in. (35.9 cm); W. 9 1/4 in. (23.5 cm) The Metropolitan Museum of Art                       Prints 13   Metropolitan Museum of Art, New York, NY 1
47918 JP3394 0 1 55570 Asian Art 7 Print 731   Japan 46 Edo period (1615–1868)       Artist 2   Utamaro II Japanese (died 1831?)   Utamaro II 4037 Japanese 74 1750 1850   1804 1817 Triptych of polychrome woodblock prints; ink and color on paper 7356 15 x 30 in. (38.1 x 76.2 cm) Bequest of Julia H. Manges, 1960                       Prints 13   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.894ms · Data license: CC0 · Data source: metmuseum/openaccess