MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Department = 7 and Object Name = 257

View and edit SQL

Suggested facets: Is Public Domain, Culture, Object Date, Object End Date

Department

  • Asian Art · 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 Repository
31788 2000.284.8 0 1 37411 Asian Art 7 Comb 257   Afghanistan, possibly of West Indian manufacture 1282                           1st–3rd century 1 299 Ivory 148 H. 2 3/16 in. (5.6 cm); W. 3 1/8 in. (7.9 cm) Samuel Eilenberg Collection, Bequest of Samuel Eilenberg, 1998                       Ivories 181   Metropolitan Museum of Art, New York, NY 1
32699 26.33.1 0 1 38355 Asian Art 7 Comb 257   Sri Lanka 811                           17th–18th century 1600 1799 Ivory 148 H. 4 1/2 in. (11.4 cm); W. 2 5/8 in. (6.6 cm) Bequest of Richard Seager, 1926                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
37799 02.18.503 0 1 43888 Asian Art 7 Comb 257   China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                           1736 1795 Jadeite, emerald-green with patches of light lavender 8940 H. 1 5/16 in. (3.3 cm); W. 2 5/8 in. (6.7 cm); L. 1/4 in. (0.7 cm) Gift of Heber R. Bishop, 1902                       Jade 174   Metropolitan Museum of Art, New York, NY 1
38935 1985.214.94 0 1 45175 Asian Art 7 Comb 257 商 玉梳|Comb China 51 Shang dynasty (ca. 1600–1046 B.C.)                         13th–11th century B.C. -1300 -1000 Jade (nephrite) with traces of cinnabar 9304 H. 3 in. (7.6 cm); W. 2 3/8 in. (6 cm) Gift of Ernest Erickson Foundation, 1985                       Jade 174   Metropolitan Museum of Art, New York, NY 1
49866 91.1.658 0 1 57797 Asian Art 7 Comb 257 花丸紋散蒔絵櫛|Lacquer Comb with Flower-Shaped Roundels Japan 46 Edo (1615–1868) or Meiji period (1868–1912)                         mid-19th century 1834 1866 Lacquered wood with gold, silver, red hiramaki-e on gold ground 11997 H. 1 3/4 in. (4.4 cm; W. 4 1/2 in. (11.4 cm); D. 7/16 in. (1.1 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Lacquer 179   Metropolitan Museum of Art, New York, NY 1
50341 1982.244.5 0 1 58436 Asian Art 7 Comb 257 月観作 雁秋草蒔絵櫛|Lacquer Comb with Geese and Autumn Grasses Japan 46 Meiji period (1868–1912)                         second half of the 19th century 1850 1899 Lacquered wood with gold, silver hiramaki-e, red lacquer on gold ground  12168 H. 1 3/8 in. (3.5 cm); W. 3 5/16 in. (8.4 cm); D. 3/16 in. (.5 cm) Bequest of Hope Skillman Schary, 1981                       Lacquer 179   Metropolitan Museum of Art, New York, NY 1
50342 1982.244.6 0 1 58437 Asian Art 7 Comb 257 紅葉散蒔絵櫛|Lacquer Comb with Maple Leaves Japan 46 Meiji period (1868–1912)                         mid-19th century 1834 1866 Lacquered wood with gold, silver hiramaki-e, red lacquer on black ground 12169 L. 3 1/16 in. (7.8 cm); Gr. W. 1 in. (2.5 cm) Bequest of Hope Skillman Schary, 1981                       Lacquer 179   Metropolitan Museum of Art, New York, NY 1
52592 25.186.3 0 1 60844 Asian Art 7 Comb 257   China 51 Song (960–1279) or Ming (1368–1644) dynasty                           960 1644 Silver 2 H. 2 in. (5.1 cm); W. 3 1/2 in. (8.9 cm) Fletcher Fund, 1925                       Jewelry 10   Metropolitan Museum of Art, New York, NY 1
62902 2004.322 0 1 72544 Asian Art 7 Comb 257   China 51 Eastern Han dynasty (25–220)                           25 220 Jade (nephrite) and gold 14301 H. 2 in. (5.1 cm); L. 3 in. (7.6 cm) Purchase, The Rosenkranz Foundation and Shelby White Gifts, 2004                       Jade 174   Metropolitan Museum of Art, New York, NY 1
65459 2011.576.4 0 1 77160 Asian Art 7 Comb 257   Sri Lanka 811                           18th century 1700 1799 Ivory 148 H. 6 3/4 in. (17.1 cm); W. 4 1/2 in. (11.4 cm); D. 1/4 in. (0.6 cm) Gift of Cynthia Hazen Polsky, 2011                       Ivories 181   Metropolitan Museum of Art, New York, NY 1
77258 2005.262 0 0 101324 Asian Art 7 Comb 257   Chinese minority (Miao) 1929                           mid-20th century 1925 1975 wood, hair 17426 Total Length: 26 in. (66 cm) Purchase, Harold Koda Gift, 2005                       Accessory-Headwear 263   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 6790.31ms · Data license: CC0 · Data source: metmuseum/openaccess