MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Medium = 8264

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Period, Object Date, Object Begin Date, Object End Date, 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
35404 14.40.593a, b 0 1 41352 Asian Art 7 Snuff bottle 4192   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 2 5/8 in. (6.7 cm) Bequest of Benjamin Altman, 1913                       Snuff Bottles 195   Metropolitan Museum of Art, New York, NY 1
36511 1978.149 0 1 42501 Asian Art 7 Plate 356   China 51 Ming dynasty (1368–1644)                         15th century 1400 1499 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 Diam. 14 7/8 in. (37.8 cm) Gift of Mrs. Richard E. Linburn, 1978                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
39724 20.41.8a, b 0 1 46008 Asian Art 7 Covered jar 3929   China 51 Qing dynasty (1644–1911), Shunzhi period (1644–1681)                           1644 1681 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 9 7/8 in. (25.1 cm); H. incl. lid 10 1/2 in. (26.7 cm); Diam. 8 3/8 in. (21.3 cm); Diam. of rim 4 in. (10.2 cm); Diam. of base 5 3/8 in. (13.7 cm) Rogers Fund, 1920                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
39834 18.61.1a, b 0 0 46132 Asian Art 7 Covered jar 3929   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 21 1/4 in. (54 cm); W. 12 1/2 in. (31.8 cm) Rogers Fund, 1918                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41238 79.2.237a, b 0 1 47896 Asian Art 7 Covered jar 3929   China 51 Ming dynasty (1368–1644)                         mid-17th century 1634 1666 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. with cover 2 1/4 in. (5.7 cm) Purchase by subscription, 1879                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41239 79.2.269a, b 0 1 47897 Asian Art 7 Covered jar 3929   China 51 Ming dynasty (1368–1644)                         mid-17th century 1634 1666 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 2 3/8 in. (6 cm) Purchase by subscription, 1879                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41538 24.170.3 0 1 48299 Asian Art 7 Dish 110   China 51 Ming dynasty (1368–1644), Jiajing period (1522–66)                           1522 1566 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 1 3/4 in. (4.4 cm); Diam. 6 7/8 in. (17.5 cm) Fletcher Fund, 1924                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41854 79.2.444 0 1 48676 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 21 7/8 in. (55.6 cm); W. 6 1/4 in. (15.9 cm); Diam. of rim 5 1/2 in. (14 cm) Purchase by subscription, 1879                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
41916 66.156.1 0 0 48749 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 27 1/4 in. (69.2 cm); Diam. 12 1/4 in. (31.1 cm) Gift of Paul E. Manheim, 1966                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
43893 79.2.306 0 1 50935 Asian Art 7 Vase 7   China 51 Qing dynasty (1644–1911), Shunzhi period (1644–61)                         mid-17th century 1644 1670 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 17 7/8 in. (45.4 cm); Diam. of rim 8 in. (20.3 cm); Diam. of foot 6 7/8 in. (17.5 cm) Purchase by subscription, 1879                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
414275 2015.270 0 1 684269 Asian Art 7 Bowl 106   China 51 Ming dynasty (1368–1644), Tianqi period (1620–27)                           1620 1627 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 2 1/16 in. (5.2 cm); Diam. 6 in. (15.2 cm); Diam. of foot 2 3/8 in. (6 cm) Purchase, Anonymous Gift, in memory of Donatella Durazzo, 2015                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
414771 2015.302 0 1 685113 Asian Art 7 Censer 3914 清康熙 景德鎮窯青花山水人物圖香爐|Censer with figures in landscape China 51 Qing dynasty (1644–1911), Kangxi period (1662–1722)                         1707 1707 1707 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 6 3/8 in. (16.2 cm); Diam. 7 1/4 in. (18.4 cm) Gift of Julia and John Curtis, 2015                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
422836 2015.784.1 0 1 701291 Asian Art 7 Vase 7 清康熙 景德鎮窯青花前後赤壁賦圖方瓶|Square-form vase with decoration of Su Shi’s Former and Latter Rhapsodies on the Red Cliff China 51 Qing dynasty (1644–1911), Kangxi mark and period (1662–1722)                           1622 1722 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 20 3/4 in. (52.7 cm); W. 6 1/4 in. (15.9 cm); D. 6 1/4 in. (15.9 cm); Diam. of rim: 5 1/4 in. (13.3 cm) Gift of Julia and John Curtis, 2015                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
446686 SL.37.2017.1.3 0 0 747460 Asian Art 7 Vase 7 明崇禎 景德鎮窯青花朱熹詩山水瓶|Vase with landscape and poem by Zhu Xi China 51 Ming dynasty (1368–1644)                         dated 1639 1639 1639 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 19 1/4 in. (48.9 cm) Lent by a private collection                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
449146 SL.37.2017.1.4 0 0 751931 Asian Art 7 Brushpot 4875 清康熙 景德鎮窯青花杜甫詩山水筆筒|Brush pot with decoration of landscape and poem by Du Fu (712–770) China 51 Qing dynasty (1644–1911)                         ca. 1670 1660 1680 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 6 1/2 in. (16.5 cm); Diam. 8 in. (20.3 cm) Lent by a private collection                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
449147 SL.37.2017.1.5 0 0 751932 Asian Art 7 Dish 110 清康熙 青花山水人物圖 盤|Dish with decoration of a scholar in a river landscape China 51 Qing dynasty (1644–1911)                         ca. 1670 1660 1680 Porcelain painted with cobalt blue under a transparent glaze (Jingdezhen ware) 8264 H. 2 in. (5.1 cm); Diam. of rim 10 7/8 in. (27.6 cm); Diam. of foot 6 1/4 in. (15.9 cm) Lent by a private collection                       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 127.23ms · Data license: CC0 · Data source: metmuseum/openaccess