MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Classification = 617

View and edit SQL

Suggested facets: Object Name, Title, Culture, Period, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Region, Subregion

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
201368 32.150.15 0 1 322642 Ancient Near Eastern Art 14 Brick 129 Glazed brick Sasanian 5655 Sasanian                         ca. 3rd–7th century A.D. 200 699 Ceramic, glaze 28523 15 x 12.75 in. (38.1 x 32.39 cm) Rogers Fund, 1932 From 19         Mesopotamia 335 Ctesiphon 31         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
202445 41.160.188 0 1 323756 Ancient Near Eastern Art 14 Brick 129 Inscribed brick Babylonian 5652 Old Babylonian                         ca. 20th century B.C. -2000 -1900 Ceramic, glaze 28523 36 x 17.8 x 8.9 cm (14 1/8 x 7 x 3 1/2 in.) Bequest of W. Gedney Beatty, 1941           Mesopotamia 335 Eshnunna (modern Tell Asmar) 57         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
202770 50.132 0 1 324102 Ancient Near Eastern Art 14 Brick 129 Brick with Elamite royal building inscription Elamite 5684 Middle Elamite                         ca. 1340–1300 B.C. -1340 -1300 Ceramic, glaze 28523 3.75 x 6.75 x 14.5 in. (9.53 x 17.15 x 36.83 cm) Gift of Nasli Heeramaneck, 1950           Iran 347 probably from Choga Zanbil 83         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
202888 52.74.1 0 1 324226 Ancient Near Eastern Art 14 Brick 129 Brick with Elamite royal inscription Elamite 5684 Middle Elamite                         ca. 12th century B.C. -1200 -1100 Ceramic, glaze 28523 3.12 x 5.37 x 8.87 in. (7.92 x 13.64 x 22.53 cm) Gift of Mrs. Charlotte M. Bradford, 1952           Iran 347 Susa 60         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
202998 54.117.29 0 1 324342 Ancient Near Eastern Art 14 Brick 129 Brick with inscription of Ashurnasirpal II Assyrian 5654 Neo-Assyrian                         ca. 883–859 B.C. -883 -859 Ceramic 161 4.49 x 14.02 x 14.49 in. (11.4 x 35.61 x 36.8 cm) Rogers Fund, 1954           Mesopotamia 335 Nimrud (ancient Kalhu) 5         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
203303 57.66.1 0 1 324680 Ancient Near Eastern Art 14 Wall plaque 938 Wall plaque Elamite 5684 Middle Elamite                         ca. 1340–1300 B.C. -1340 -1300 Ceramic, glaze 28523 9 x 14.5 in. (22.86 x 36.83 cm) Gift of Prof. Roman Ghirshman, 1957           Iran 347 Choga Zanbil 98         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
203520 59.41.82 0 1 324911 Ancient Near Eastern Art 14 Brick 129 Inscribed brick: dedicatory inscription of Adad-shuma-usur Kassite 5650 Kassite                         ca. 1216–1187 B.C. -1216 -1187 Ceramic 161 Brick: 13.2 x 10.8 x 7.2 cm (5 1/4 x 4 1/4 x 2 7/8 in.) Inscription: 10.6 x 8.6 cm (4 1/8 x 3 3/8 in.) Rogers Fund, 1959           Mesopotamia 335 Nippur 81         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
203522 59.41.84 0 1 324913 Ancient Near Eastern Art 14 Brick 129 Inscribed brick Isin-Larsa 5685 Isin-Larsa                         ca. 1895–1874 B.C. -1895 -1874 Ceramic 161 Brick: 18.9 x 31.9 x 8 cm (7 1/2 x 12 1/2 x 3 1/8 in.) Inscription: 13 x 10.4 cm (5 1/8 x 4 1/8 in.) Rogers Fund, 1959           Mesopotamia 335 Nippur 81         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
203523 59.41.85 0 1 324914 Ancient Near Eastern Art 14 Brick 129 Brick with inscription of Ashurbanipal describing building work on Ekur, the temple of the god Enlil at Nippur Assyrian 5654 Neo-Assyrian                         ca. 668–631 B.C. -668 -631 Ceramic 161 2.76 x 16.26 x 16.26 in. (7.01 x 41.3 x 41.3 cm) Rogers Fund, 1959           Mesopotamia 335 Nippur 81         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
203524 59.41.86 0 1 324915 Ancient Near Eastern Art 14 Brick 129 Inscribed brick Neo-Sumerian 5666 Ur III                         ca. 2112–2095 B.C. -2112 -2095 Ceramic, glaze 28523 Brick: 30.9 x 31.4 x 7.5 cm (12 1/8 x 12 3/8 x 3 in.) Inscription: 11 x 9.5 cm (4 3/8 x 3 3/4 in.) Rogers Fund, 1959           Mesopotamia 335 Nippur 81         Ceramics-Architectural-Inscribed 617   Metropolitan Museum of Art, New York, NY 1
203525 59.41.87 0 1 324916 Ancient Near Eastern Art 14 Brick 129 Inscribed brick Neo-Sumerian 5666 Ur III                         ca. 2094–2047 B.C. -2094 -2047 Ceramic, glaze 28523 Brick: 31.5 x 31.2 x 5.5 cm (12 3/8 x 12 1/4 x 2 1/8 in.) Inscription: 17 x 10.2 cm (6 3/4 x 4 in.) Rogers Fund, 1959           Mesopotamia 335 Nippur 81         Ceramics-Architectural-Inscribed 617   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 138.936ms · Data license: CC0 · Data source: metmuseum/openaccess