MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Region = 343

View and edit SQL

Suggested facets: Object Name, Title, 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
200313 74.51.4379 0 1 321460 Ancient Near Eastern Art 14 Stamp seal 13624 Rectangular plaque seal   Iron Age                         ca. 7th century B.C. -700 -600 Steatite, black 28424 Seal Face: 1.96 x 1.77 cm Height: 0.8 cm String Hole: 0.3 cm The Cesnola Collection, Purchased by subscription, 1874–76           Syria (?) 343           Stone-Stamp Seals-Inscribed 590   Metropolitan Museum of Art, New York, NY 1
201061 99.22.18 0 1 322287 Ancient Near Eastern Art 14 Stamp seal 13624 Stepped pyramidal seal with loop handle Syrian 364 Middle Bronze Age (?)                         ca. 18th century B.C. (?) -1800 -1700 Steatite, black 28424 Seal Face: 1.45 x 1.42 cm Height: 1.38 cm remaining String Hole: 0.1 cm (broken) Purchase, 1899           Syria (?) 343           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
201288 26.31.364 0 1 322552 Ancient Near Eastern Art 14 Stamp seal 13624 Pyramidal seal Assyrian 5654 Neo-Assyrian                         ca. 8th–7th century B.C. -800 -600 Chert, white 28489 Seal Face: 1.63 x 1.38 cm Height: 2.0 cm String Hole: 0.35 cm Bequest of Richard B. Seager, 1926           Syria (?) 343           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
202430 41.20 0 1 323740 Ancient Near Eastern Art 14 Vessel 3894 Vessel decorated with four rows of pine cones Roman 736 Roman                         ca. 1st century B.C–1st century A.D. 1 1 Ceramic, lead-glazed ware 28581 6 in. (15.24 cm) Samuel D. Lee Fund, 1941           Syria (?) 343           Ceramics-Vessels 504   Metropolitan Museum of Art, New York, NY 1
205119 1982.374 0 1 326696 Ancient Near Eastern Art 14 Stamp seal 13624 Scaraboid seal   Neo-Assyrian or Neo-Babylonian, Provincial                         ca. 8th–7th century B.C. -800 -600 Chalcedony 8194 Seal Face: 1.8 x 1.55 cm Height: 1.17 cm String Hole: 0.25 cm Gift of R. Anavian & Sons, 1982           Syria (?) 343           Stone-Stamp Seals 586   Metropolitan Museum of Art, New York, NY 1
205390 1984.383.16 0 1 326977 Ancient Near Eastern Art 14 Cylinder seal 13625 Cylinder seal   Old Syrian                         ca. 1900–1800 B.C. -1900 -1800 Steatite (?) 27256 H. 2.2 cm x Diam. 1.1 cm Gift of Martin and Sarah Cherkasky, 1984           Syria (?) 343           Stone-Cylinder Seals 588   Metropolitan Museum of Art, New York, NY 1
205604 1985.357.13 0 1 327195 Ancient Near Eastern Art 14 Cylinder seal 13625 Cylinder seal   Late Bronze Age (?)                         ca. mid 2nd–late 2nd millennium B.C. -1600 -1200 Stone 164 H. 2.8 cm x Diam. 1.2 cm Gift of The Right Reverend Paul Moore Jr., 1985           Syria (?) 343           Stone-Cylinder Seals 588   Metropolitan Museum of Art, New York, NY 1
206153 1999.325.173 0 1 327769 Ancient Near Eastern Art 14 Cylinder seal 13625 Cylinder seal   Late Bronze Age (?)                         2nd millennium B.C. (?) -2 -2 Hematite 22482 H. 11/16 in. (1.8 cm); Diam. 3/8 in. (0.9 cm) Gift of Nanette B. Kelekian, in memory of Charles Dikran and Beatrice Kelekian, 1999           Syria (?) 343           Stone-Cylinder Seals 588   Metropolitan Museum of Art, New York, NY 1
206174 1999.325.195 0 1 327791 Ancient Near Eastern Art 14 Stamp seal  13639 Scaraboid seal   Late Bronze Age                         ca. mid-1st millennium B.C. -1 -1 Porphyry, red 28906 H. 1/2 in. (1.3cm); W. 11/16 in.( 1.8 cm ) Gift of Nanette B. Kelekian, in memory of Charles Dikran and Beatrice Kelekian, 1999           Syria (?) 343           Stone-Stamp Seals 586   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 117.226ms · Data license: CC0 · Data source: metmuseum/openaccess