MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where Medium = 25618

View and edit SQL

Suggested facets: Object Name, Title, Period, 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
142993 74.51.2450 0 1 242003 Greek and Roman Art 12 Vase with inscription 9595 Tall alabaster flask Cypriot 3578 Early Geometric (?)                         ca. 1050–950 B.C. -1100 -900 Gypsum (alabaster) 25618 H.: 9 x 2 1/4 in. (22.9 x 5.7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
144959 74.51.5093 0 1 243973 Greek and Roman Art 12 Alabastron 9194 Alabaster alabastron (perfume vase) Cypriot 3578 Classical                         5th–4th century B.C. -400 -300 Gypsum (alabaster) 25618 H. 17.50 cm. The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144967 74.51.5101 0 1 243981 Greek and Roman Art 12 Alabastron 9194 Alabaster alabastron (perfume vase) Cypriot 3578 Classical                         5th–4th century B.C. -499 -300 Gypsum (alabaster) 25618 H. 5 1/4 x 1 3/4 in. (13.3 x 4.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144968 74.51.5102 0 1 243982 Greek and Roman Art 12 Alabastron 9194 Alabaster alabastron (perfume vase) Cypriot 3578 Archaic or Classical                         6th–4th century B.C. -599 -300 Gypsum (alabaster) 25618 H. 5 3/8 x 1 7/8 in. (13.7 x 4.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144977 74.51.5112 0 1 243992 Greek and Roman Art 12 Vase 7 Alabaster alabastron (perfume vase) Cypriot 3578 Archaic or Classical                         6th–4th century B.C. -599 -300 Gypsum (alabaster) 25618 H. 4 1/4 x 1 5/16 in. (10.8 x 3.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144978 74.51.5113 0 1 243993 Greek and Roman Art 12 Jar 116 Gypsum jar Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Gypsum (alabaster) 25618 H. 9 1/2 in. (24.1 cm); Diam. 4 5/8 in. (11.7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144979 74.51.5114 0 1 243994 Greek and Roman Art 12 Flask with broad lip 10173 Alabaster flask Cypriot 3578 Classical or Hellenistic                         late 4th–3rd century B.C. -350 -200 Gypsum (alabaster) 25618 H. 7.29 cm.; Rim Diam. 3 1/2 in. The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144982 74.51.5117 0 1 243997 Greek and Roman Art 12 Bowl 106 Alabaster stemmed bowl Cypriot 3578 Late Bronze Age                         ca. 1600–1200 B.C. -1600 -1200 Gypsum (alabaster) 25618 H. 2 1/8 x 3 3/8 in. (5.4 x 8.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144984 74.51.5119 0 1 243999 Greek and Roman Art 12 Spoon or ladle 5097 Alabaster spoon or ladle Cypriot 3578 Late Bronze Age III                         1200–1050 B.C. -1200 -1050 Gypsum (alabaster) 25618 Overall: 1 3/4 × 2 × 5 1/2 in. (4.4 × 5.1 × 14 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144988 74.51.5123 0 1 244003 Greek and Roman Art 12 Vase, pear-shaped 10170 Miniature alabaster pithoid jar Cypriot 3578 Late Bronze Age                         ca. 1400–1050 B.C. -1400 -1050 Gypsum (alabaster) 25618 H. 3 7/8 x 3 1/2 in. (9.8 x 8.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144991 74.51.5126 0 1 244006 Greek and Roman Art 12 Bowl 106 Fragmentary alabaster stemmed bowl Cypriot 3578 Late Bronze Age                         1600–1200 B.C. -1600 -1200 Gypsum (alabaster) 25618 H. 2 1/8 x 4 3/4 in. (5.4 x 12.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144992 74.51.5127 0 1 244007 Greek and Roman Art 12 Bowl 106 Alabaster mortar or deep bowl Cypriot 3578 Late Bronze Age (?)                         ca. 1600–1050 B.C. (?) -1605 -1595 Gypsum (alabaster) 25618 H. 1 15/16 x 5 3/4 in. (4.9 x 14.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144993 74.51.5128 0 1 244008 Greek and Roman Art 12 Bowl 106 Alabaster bowl Cypriot 3578 Archaic or Classical?                         6th–4th century B.C. ? -599 -300 Gypsum (alabaster) 25618 W: 2 in. (5.1 cm): Diam. 4 in. (10.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144995 74.51.5130 0 1 244010 Greek and Roman Art 12 Amphoriskos 9200 Alabaster amphoriskos (small flask) Cypriot 3578 Hellenistic                         310–30 B.C. -310 -30 Gypsum (alabaster) 25618 H. 5 1/4 x 2 1/8 in. (13.3 x 5.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144996 74.51.5131 0 1 244011 Greek and Roman Art 12 Amphora 4816 Miniature alabaster amphora (jar) Cypriot 3578 Hellenistic                         late 4th–3rd century B.C. -450 -200 Gypsum (alabaster) 25618 H. 2 5/8 (6.7 cm); Diam. 1 11/16 in. (4.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144997 74.51.5132 0 1 244012 Greek and Roman Art 12 Amphora 4816 Miniature alabaster amphora (jar) Cypriot 3578 Hellenistic                         late 4th–3rd century B.C. -450 -200 Gypsum (alabaster) 25618 H. 3 1/8 (7.9 cm); 1 7/8 in. (4.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144999 74.51.5134 0 1 244014 Greek and Roman Art 12 Vase 7 Alabaster unguentarium Cypriot 3578 Hellenistic                         late 4th–3rd century B.C. -350 -200 Gypsum (alabaster) 25618 H. 5 5/8 (14.3 cm); Diam. 1 15/16 in. (4.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
145001 74.51.5136 0 1 244016 Greek and Roman Art 12 Vase, pear-shaped 10170 Miniature alabaster amphora (jar) Cypriot 3578 Hellenistic                         late 4th–3rd century B.C. -450 -200 Gypsum (alabaster) 25618 H. 2 7/8 (7.3 cm); Diam. 1 11/16 in. (4.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
145003 74.51.5138 0 1 244018 Greek and Roman Art 12 Bowl 106 Alabaster mortar or deep bowl Cypriot 3578 Late Bronze Age(?)                         ca. 1600–1050 B.C. -1600 -1050 Gypsum (alabaster) 25618 H. 1 9/16 x W. 3 7/8 in. (4 x 9.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   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 607.242ms · Data license: CC0 · Data source: metmuseum/openaccess