MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Object Name = 897

View and edit SQL

Suggested facets: Is Public Domain, Department, Culture, Period, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
7778 69.194.13 0 1 8289 American Decorative Arts 1 Tea bowl 897 Tea bowl American 1         Manufacturer|Designer 18 Manufactured by|Designed by Union Porcelain Works|Karl L. H. Müller 1863–ca. 1922|ca. 1820–1887   Union Porcelain Works |Müller, Karl L. H. 814 American 1 1863 |1817 1922 |1890 ca. 1876 1873 1876 Porcelain 109 H. 2 1/16 in. (5.2 cm); Diam. 2 9/16 in. (6.5 cm) Gift of Mr. and Mrs. Franklin Chace, 1969 Made in 1 Brooklyn 48     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
36466 91.1.226 0 1 42455 Asian Art 7 Tea bowl 897 中國 南宋 建窯 兔毫釉茶碗|Tea Bowl with “Hare’s-Fur” Glaze China 51 Southern Song dynasty (1127–1279)                         12th century 1100 1199 Stoneware with iron glaze (Jian ware)  8718 H. 2 3/4 in. (7 cm); Diam. 5 in. (12.7 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
54727 29.100.634 0 1 63115 Asian Art 7 Tea bowl 897 仁阿弥道八作 紫陽花文茶碗|Tea Bowl with Hydrangeas Japan 46 Edo period (1615–1868)       Artist 2   Nin'ami Dōhachi (Takahashi Dōhachi II) Japanese, 1783–1855   Dōhachi II 4594 Japanese 74 1783 1855 first half of the 19th century 1800 1849 Stoneware with polychrome enamels over a transparent glaze (Kyoto ware) 13568 H. 3 1/8 in. (7.9 cm); Diam. 4 3/4 in. (12.1 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
63350 2006.128 0 0 73164 Asian Art 7 Tea bowl 897   Japan 46 Heisei period (1989–present)       Artist 2   Kamada Kōji Japanese, born 1948 active in Kyoto Kamada Kōji 4862 Japanese 74 1948 2048 2005 2005 2005 Stoneware with iron-oxide glazes  14407 H. 2 7/8 in. (7.3 cm); Diam. of rim 5 1/8 in. (13 cm); Diam. of foot 1 5/8 in. (4.1 cm) Gift of the artist, 2006                       Ceramics 5 © Kamada Kōji Metropolitan Museum of Art, New York, NY 1
63351 2006.185 0 0 73165 Asian Art 7 Tea bowl 897   Japan 46 Heisei period (1989–present)       Artist 2   Kamada Kōji Japanese, born 1948   Kamada Kōji 4862 Japanese 74 1948 2048 2005 2005 2005 Stoneware with copper-colored temmoku glaze  14408 H. 2 13/16 in. (7.1 cm); Diam. 4 7/8 in. (12.3 cm) Purchase, The B. D. G. Leviton Foundation Gift, 2006                       Ceramics 5 © Kamada Kōji Metropolitan Museum of Art, New York, NY 1
63355 2006.72 0 1 73172 Asian Art 7 Tea bowl 897   China 51 Jin dynasty (1115–1234)                         12th–13th century 1100 1299 Earthenware with glaze (Cizhou ware)  14409 H. 2 3/4 in. (7 cm); Diam. 6 5/16 in. (16 cm) Purchase, Friends of Asian Art Gifts, 2006                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
65996 2013.174 0 1 78392 Asian Art 7 Tea bowl 897   China 51 Southern Song dynasty (1127–1279)                         12th–13th century 1100 1299 Stoneware with brown glaze and slip decoration 14965 H. 1 3/4 in. (4.4 cm); Diam. 5 7/8 in. (14.9 cm); Diam. of foot 1 3/4 in. (4.4 cm) Purchase, Friends of Asian Art Gifts, 2013                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
342111 1999.516 0 0 490736 Modern and Contemporary Art 4 Tea bowl 897 Tea Bowl           Designer 5   Hamada Shōji Japanese, 1894–1978   Hamada Shōji 3727 Japanese 74 1894 1978 ca. 1935 1935 1935 Stoneware 209 H. 3-1/8, W. 4-1/2 inches (7.9 x 11.4 cm) Gift of Cyril Frankel, 1999                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
449199 SL.19.2017.4.3a, b 0 0 752042 Asian Art 7 Tea bowl 897 細川護煕作 樂焼茶碗|Red Raku Tea Bowl Japan 46 Heian period (794–1185)       Artist 2   Hosokawa Morihiro Japanese, born 1938   Morihiro, Hosokawa 57422   1938 2038 2006 2006 2006 Stoneware with red glaze (Raku ware) 62785 H. 3 3/8 in. (8.6 cm); Diam. 4 5/8 in. (11.8 cm) Lent by Peggy and Richard M. Danziger                       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 128.096ms · Data license: CC0 · Data source: metmuseum/openaccess