MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Region = 333

View and edit SQL

Suggested facets: Object Name, Title, Culture, Period, Object Date, Object Begin Date, Object End Date, Medium, 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
200239 74.51.4366 0 1 321381 Ancient Near Eastern Art 14 Stamp seal 13624 Quasi-pyramidal seal Cypriot 3578 Late Cypriot III                         ca. 12th–11th century B.C. -1200 -1000 Steatite, gray brown 28423 Seal Face: 1.19 x 1.68 cm Height: 1.78 cm String Hole: 0.4 cm The Cesnola Collection, Purchased by subscription, 1874–76           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
200243 74.51.4370 0 1 321385 Ancient Near Eastern Art 14 Stamp seal 13624 Conoid seal   Late Cypriot III-Cypro-Geometric III                         ca. 12th–9th century B.C. -1200 -800 Steatite, brown 28426 Seal Face; 1.61 x 1.46 cm Height: 1.35 cm String Hole: 0.25 cm The Cesnola Collection, Purchased by subscription, 1874–76           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
200304 74.51.4363 0 1 321451 Ancient Near Eastern Art 14 Stamp seal 13624 Conoid seal   Late Cypriot III-Cypro-Geometric III (?)                         ca. 12th–9th century B.C. -1200 -800 Hematite 22482 Seal Face: 1.35 cm Height: 1.52 x 1.6 cm String Hole: 0.3 cm The Cesnola Collection, Purchased by subscription, 1874–76           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
200338 74.51.4408 0 1 321486 Ancient Near Eastern Art 14 Stamp seal 13624 Scarab seal   Cypro-Archaic                         ca. 7th–6th century B.C. -700 -500 Carnelian 8207 0.31 x 0.42 x 0.62 in. (0.79 x 1.07 x 1.57 cm) The Cesnola Collection, Purchased by subscription, 1874–76           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
202608 41.160.562 0 1 323934 Ancient Near Eastern Art 14 Stamp seal 13624 Carinated lentoid seal   Late Cypriot (?)                         ca. 14th century B.C. (?) -1400 -1300 Agate, banded gray white 28615 Seal Face: 1.33 x 1.37 cm Height: 0.65 cm String Hole: 0.65 cm Bequest of W. Gedney Beatty, 1941           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
205340 1984.175.19 0 1 326918 Ancient Near Eastern Art 14 Stamp seal 13624 Scaraboid seal Cypriot 3578 Cypro-Geometric III                         ca. 9th century B.C. (?) -900 -800 Steatite (talc), black 28793 Seal Face: 1.84 x 1.55 cm Height: 0.91 cm String Hole: 0.2 cm Bequest of Lester Wolfe, 1983           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
205625 1985.357.36 0 1 327218 Ancient Near Eastern Art 14 Stamp seal 13624 Conoid stamp seal: lions (?) attacking cow suckling calf   Late Cypriot III                         ca. 13th–12th century B.C. (?) -1300 -1100 Hematite, copper alloy tube in string hole 28843 Seal Face: 1.87 x 1.67 cm Height: 1.75 cm String Hole: 0.3 cm Gift of The Right Reverend Paul Moore Jr., 1985           Cyprus (?) 333           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
206193 1999.325.215 0 1 327811 Ancient Near Eastern Art 14 Cylinder seal 13625 Cylinder seal Cypriot (?) 5718 Late Bronze Age                         ca. late 2nd millennium B.C. -2000 -1000 Hematite 22482 H. 5/8 in. (1.6 cm); Diam. 3/16 in. (0.5 cm) Gift of Nanette B. Kelekian, in memory of Charles Dikran and Beatrice Kelekian, 1999           Cyprus (?) 333           Stone-Cylinder Seals 588   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 145.167ms · Data license: CC0 · Data source: metmuseum/openaccess