MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Classification = 4 and Period = "Ming dynasty (1368–1644)" sorted by Locus

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line

Period ✖

  • Ming dynasty (1368–1644) · 11 ✖
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 Metadata Date Repository
30842 30842 1995.181 0 1 36458 Asian Art 7 Table screen 3905 大理石插屏|Table Screen Inscribed with the Poem "Lisao," now converted to a wall panel China 51 Ming dynasty (1368–1644)       Artist 2   Li Mi active early 17th century   Li Mi 3445   1600 1699 dated 1624 1624 1624 Veined marble with wood frame 7350 H. 16 5/8 (42.2 cm); W. 14 3/8in. (36.5cm) Purchase, Eileen W. Bamberger Bequest, in memory of her husband, Max Bamberger, 1995                       Furniture 4   http://www.metmuseum.org/art/collection/search/36458 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
33869 33869 1996.338 0 1 39614 Asian Art 7 Table 477 明 黃花梨 畫案|Painting table China 51 Ming dynasty (1368–1644)                         late 16th–early 17th century 1567 1633 Wood (huanghuali, Dalbergia odorifera)  7833 H. 31 1/2 in. (80 cm); W. 73 1/4 in. (186.1 cm); D. 29 7/8 in. (75.9 cm) Purchase, The Vincent Astor Foundation and The Dillon Fund Gifts, 1996                       Furniture 4   http://www.metmuseum.org/art/collection/search/39614 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
36653 36653 1976.193.5a–c 0 1 42734 Asian Art 7 Side table 1235 晚明 黃花梨條几|Side Table China 51 Ming dynasty (1368–1644)                         16th century 1500 1599 Wood (huanghuali, or Dalbergia odorifera) 8817 H. 34 in. (86.4 cm); W. 54 1/4 in. (137.8 cm); D. 17 1/2 (44.5 cm) Purchase, The Vincent Astor Foundation Gift, 1976                       Furniture 4   http://www.metmuseum.org/art/collection/search/42734 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
36661 36661 1976.193.7a–o 0 1 42742 Asian Art 7 Wardrobe 945   China 51 Ming dynasty (1368–1644)                         16th century 1500 1599 Wood (Huanghuali, or Dalbergia odoriferal); metal fittings 8823 H. 103 3/4 in. (263.5 cm); W. 56 in. (142.2 cm); D. 24 3/4 in. (62.9 cm) Purchase, The Vincent Astor Foundation Gift, 1976                       Furniture 4   http://www.metmuseum.org/art/collection/search/42742 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
36663 36663 1976.193.8a–o 0 1 42744 Asian Art 7 Wardrobe 945   China 51 Ming dynasty (1368–1644)                         16th century 1500 1599 Wood (Huanghuali/Dalbergia odoriferal); metal fittings 8825 H. 103 3/4 in. (263.5 cm); W. 56 in. (142.2 cm); D. 24 3/4 in. (62.9 cm) Purchase, The Vincent Astor Foundation Gift, 1976                       Furniture 4   http://www.metmuseum.org/art/collection/search/42744 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48594 48594 51.100.1a–f 0 1 56355 Asian Art 7 Wardrobe 945   China 51 Ming dynasty (1368–1644)                         late 16th or early 17th century 1567 1633 Wood with inlay of mother-of-pearl, amber, glass, ivory, and other materials 11808 H. 112 1/2 in. (285.8 cm); W. 62 3/8 in. (158.4 cm); D. 32 1/2 in. (82.6 cm) Gift of Mrs. Albert H. Wiggin, 1951                       Furniture 4   http://www.metmuseum.org/art/collection/search/56355 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48595 48595 51.100.2a–f 0 1 56356 Asian Art 7 Wardrobe 945   China 51 Ming dynasty (1368–1644)                         late 16th or early 17th century 1567 1633 Wood with inlay of mother-of-pearl, amber, glass, ivory, and other materials 11808 H. 112 1/2 in. (285.8 cm); W. 62 3/8 in. (158.4 cm); D. 32 1/2 in. (82.6 cm) Gift of Mrs. Albert H. Wiggin, 1951                       Furniture 4   http://www.metmuseum.org/art/collection/search/56356 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48597 48597 61.38.1a–d 0 1 56359 Asian Art 7 Sofa 824   China 51 Ming dynasty (1368–1644)                           1368 1644 Lacquered wood with inlay 11809 H. 29 14 in. (74.3 cm); W. 33 3/4 in. (85.7 cm); L. 79 7/8 in. (202.9 cm) Gift of Mrs. Jean Mauzé, 1961                       Furniture 4   http://www.metmuseum.org/art/collection/search/56359 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48599 48599 65.57 0 1 56362 Asian Art 7 Table 477   China 51 Ming dynasty (1368–1644)                         late 16th–early 17th century 1567 1633 Black lacquer inlaid with mother-of-pearl 8103 H. 33 1/2 in. (85.1 cm); W. 79 1/2 in. (201.9 cm); D. 33 3/4 in. (85.7 cm) Louis V. Bell Fund, 1965                       Furniture 4   http://www.metmuseum.org/art/collection/search/56362 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48602 48602 1973.34 0 1 56369 Asian Art 7 Folding chair 5073   China 51 Ming dynasty (1368–1644)                         16th century 1500 1599 Wood 25 H. 39 1/2 in. (100.3 cm); W. 17 3/4 in. (45.1 cm); D. 29 in. (73.7 cm) Gift of Mr. and Mrs. James Biddle, 1973                       Furniture 4   http://www.metmuseum.org/art/collection/search/56369 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48606 48606 69.217 0 1 56375 Asian Art 7 Folding chair 5073 明早期 剔黑飛鳥穿花紋交椅|Folding chair with two birds among flowers China 51 Ming dynasty (1368–1644)                         14th–15th century 1368 1499 Carved lacquer, rattan seat 11812 H. 38 in. (96.5 cm); W. 26 1/8 in. (66.4 cm); D. (approx.) 17 in. (43.2 cm) Rogers Fund, 1969                       Furniture 4   http://www.metmuseum.org/art/collection/search/56375 4/23/2018 8:00:01 AM 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 274.653ms · Data license: CC0 · Data source: metmuseum/openaccess