MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Medium = 331

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Period, Dynasty, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line, Geography Type, Country, 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
1146 36.148.1 0 1 1243 American Decorative Arts 1 Candlestick 163 Candlestick American 1                           1840–60 1840 1860 Yellow glass 331 H. 10 3/8 in. (26.4 cm) Rogers Fund, 1936 Made in 1       United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
1147 36.148.2 0 1 1244 American Decorative Arts 1 Candlestick 163 Candlestick American 1                           1840–60 1840 1860 Yellow glass 331 H. 10 3/8 in. (26.4 cm) Rogers Fund, 1936 Made in 1       United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
35288 14.40.475a, b 0 1 41236 Asian Art 7 Snuff bottle 4192   China 51 Qing dynasty (1644–1911)                         late 18th–early 19th century 1767 1833 Yellow glass 331 H. 2 15/16 in. (7.5 cm); W. 1 1/2 in. (3.8 cm); D. 1 in. (2.5 cm) Bequest of Benjamin Altman, 1913                       Snuff Bottles 195   Metropolitan Museum of Art, New York, NY 1
357452 10.130.3049 0 0 550626 Egyptian Art 19 Beads, string 18482 String of eight beads   New Kingdom, Amarna Period Dynasty 18 21 reign of Akhenaten to Haremhab 126                     ca. 1353–1336 B.C. -1353 -1353 Yellow glass 331 L. 7 cm (2 3/4 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
359752 10.130.3064 0 0 553118 Egyptian Art 19 Necklace, beads 21835 Necklace, beads   Third Intermediate Period–Late Period                         ca. 1070–343 B.C -1070 -343 Yellow glass 331 L. 27.5 cm (10 13/16 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
360192 10.130.3065 0 0 553577 Egyptian Art 19 Beads, string 18482 String of beads   Third Intermediate Period or later Dynasty 21–25 109                       ca. 1070–664 B.C. -1070 -1070 Yellow glass 331 L. 5.5 cm (2 3/16 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
361974 09.180.2504 0 0 555410 Egyptian Art 19 Bead, spool-shaped 23234 Spool-shaped bead   New Kingdom, Ramesside Dynasty 19–20 48                       ca. 1295–1070 B.C. -1295 -1070 Yellow glass 331 H. 1.1 x Diam. 1.2 cm (7/16 x 1/2 in.) Rogers Fund, 1909 From 19       Egypt 104 Memphite Region 645 Lisht North 135 Cemetery 26   MMA excavations 19       Metropolitan Museum of Art, New York, NY 1
364962 10.130.3060 0 0 558887 Egyptian Art 19 Beads, string 18482 String of Beads   Third Intermediate Period or later Dynasty 21–25 109                       ca. 1070–664 B.C. -1070 -1070 Yellow glass 331 L. 3.2 cm (1 1/4 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
364963 10.130.3061 0 0 558888 Egyptian Art 19 Beads, string 18482 String of Beads   Third Intermediate Period or later Dynasty 21–25 109                       ca. 1070–664 B.C. -1070 -1070 Yellow glass 331 L. 5.4 cm (2 1/8 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
364999 11.151.505a–c 0 0 558925 Egyptian Art 19 Glass Cane fragments (3) 24339 Glass Cane fragments (3)   New Kingdom, Ramesside Dynasty 19–20 48                       ca. 1295–1070 B.C. -1295 -1070 Yellow glass 331   Rogers Fund, 1911 From 19       Egypt 104 Memphite Region 645 Lisht North 135 Cemetery 26   MMA excavations 19       Metropolitan Museum of Art, New York, NY 1
374199 10.130.3078 0 1 570526 Egyptian Art 19 Beads, string 18482 String of 46 disc beads   Roman Period                         30 B.C.–A.D. 364 -30 364 Yellow glass 331 l. 21.9 cm (8 5/8 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
374200 10.130.3079 0 1 570527 Egyptian Art 19 Beads, string 18482 String of 7 beads   Roman Period                         1st to 2nd Century A.D. 1 199 Yellow glass 331 l. 4.8 cm (1 7/8 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
374201 10.130.3080 0 1 570528 Egyptian Art 19 Beads, string 18482 String of 15 disc beads   Ptolemaic or Roman Period                         1st Century B.C. to 5th Century A.D. or later -99 499 Yellow glass 331 l. 3.8 cm (1 1/2 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
374202 10.130.3081 0 1 570529 Egyptian Art 19 Beads, string 18482 String of 115 discoid ridged beads   Ptolemaic or Roman Period                         304 B.C.–A.D. 364 -304 364 Yellow glass 331 l. 38.3 cm (15 1/16 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
375916 10.130.3063 0 0 574346 Egyptian Art 19 Beads, string 18482 String of Beads   Third Intermediate Period or later Dynasty 21–25 109                       ca. 1070–664 B.C. -1070 -1070 Yellow glass 331 L. 12.1 cm (4 3/4 in.) Gift of Helen Miller Gould, 1910 From 19       Egypt 104                 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 135.462ms · Data license: CC0 · Data source: metmuseum/openaccess