MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Artist Alpha Sort = 3928

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Period, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line

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
39713 93.3.364a, b 0 1 45997 Asian Art 7 Wine pot 4458 染付龍文水注|Ewer with Dragon Japan 46 Meiji period (1868–1912)       Artist 2 Style of Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th century 1867 1899 Porcelain with underglaze blue  9623 H. 9 1/4 in. (23.5 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
40267 93.3.111 0 1 46691 Asian Art 7 Flower vase 4512 紫馬麒麟卍紗綾形紋瓶 (一対)|Vase with Horse and Kirin on Geometric Sayagata (key fret) Pattern (one of a pair) Japan 46 Meiji period (1868–1912)       Artist 2 Style of Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th century 1867 1899 Porcelain with incised design and underglaze red  9812 H. 4 3/4 in. (12.1 cm); Diam. of rim 1 1/4 in. (3.2 cm); Diam. 4 3/4 in. (12.1 cm); Diam. of base 2 1/4 in. (5.7 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
40268 93.3.112 0 1 46692 Asian Art 7 Flower vase 4512 紫馬麒麟卍紗綾形紋瓶 (一対)|Vase with Horse and Kirin on Geometric Sayagata (key fret) Pattern (one of a pair) Japan 46 Meiji period (1868–1912)       Artist 2 Style of Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th century 1867 1899 Porcelain with incised design and underglaze red 9813 H. 4 3/4 in. (12.1 cm); Diam. of rim 1 1/4 in. (3.2 cm); Diam. 4 3/4 in. (12.1 cm); Diam. of base 2 1/4 in. (5.7 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41173 93.3.271 0 1 47808 Asian Art 7 Vase 7   Japan 46         Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 19th century 1800 1899 Clay covered with high-fired glazes 10300 H. 6 3/4 in. (17.1 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41178 93.3.15a, b 0 1 47814 Asian Art 7 Pot 726   Japan 46         Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 1890 1890 1890 White porcelain decorated in red under the glaze (Kyoto ware, Makuzu type) 10305 H. inc. lid 8 1/2 in. (21.6 cm); H. w/o lid 7 3/4 in. (19.7 cm); Diam. 8 1/4 in. (21 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41304 93.3.480 0 1 47970 Asian Art 7 Vase 7   Japan 46         Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 19th century 1800 1899 White porcelain covered with a mazarine blue glaze (Kyoto ware) 10364 H. 11 3/8 in. (28.9 cm); Diam. 11 in. (27.9 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41317 93.3.423 0 1 47983 Asian Art 7 Vase 7   Japan 46         Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 19th century 1800 1899 Porcelain covered with a dark green glaze and design in white enamel (Kyoto ware) 10375 H. 5 3/4 in. (14.6 cm); Diam. 5 1/2 in. (14 cm) Gift of Charles Stewart Smith, 1893                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
46121 91.1.367a, b 0 1 53613 Asian Art 7 Water jar 4177 バッタ行列文水指|Water Jar with Procession of Grasshoppers Japan 46 Meiji period (1868–1912)       Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th century 1868 1899 Stoneware with polychrome overglaze enamels and gold with a wood lid and ivory knob (Makuzu ware)  11584 H. 5 3/4 in. (14.6 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
54802 36.120.531 0 1 63190 Asian Art 7 Teabowl 4174   Japan 46 Edo period (1615–1868)       Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 ca. 1850 1840 1860 Clay with flecks of crackle inside and out (Awata ware) 13639 H. 3 in. (7.6 cm); Diam. 4 5/8 in. (11.7 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
54916 36.120.624a, b 0 0 63307 Asian Art 7 Tea jar 4686   Japan 46         Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th century 1871 1899 Slightly ovoid with short neck and rounded shoulder; whitish clay; olive glaze streaked with reddish brown (Kyoto ware) 13728 H. 4 1/2 in. (11.4 cm); Diam. 2 1/2 in. (6.4 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
54917 36.120.625a, b 0 0 63308 Asian Art 7 Tea jar 4686   Japan 46         Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th century 1871 1899 Small neck, nearly cylindrical body; grayish clay, dark glaze with brown spots (Kyoto ware) 13729 H. (with lid) 3 5/16 in. (8.4 cm); Diam. 1 7/8 in. (4.8 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
55527 1984.408.1 0 1 63939 Asian Art 7 Vase 7 波に鯉文瓶|Vase with Carps in Waves Japan 46 Meiji period (1868–1912)       Artist 2   Makuzu Kōzan I (Miyagawa Toranosuke) Japanese, 1842–1916   Makuzu Kōzan 3928 Japanese 74 1842 1916 late 19th–early 20th century 1867 1933 Porcelain with metal fittings 13779 H. 10 in. (25.4 cm); Diam. 3 1/4 in. (8.3 cm) Diam. of rim: 3 3/4 in. (9.5 cm) Diam. of foot: 4 7/8 in. (12.4 cm) Gift of Stanley J. Love, 1984                       Ceramics 5   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 172.54ms · Data license: CC0 · Data source: metmuseum/openaccess