MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Credit Line = "Rogers Fund, 1962", Object End Date = "-2350" and Subregion = 81

View and edit SQL

Suggested facets: Object Name, Title, Period, Object Date, Object Begin Date, Medium, 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
204006 62.70.19 0 1 325425 Ancient Near Eastern Art 14 Fruit stand 8300 Fruit stand Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Ceramic 161 11.77 in. (29.9 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Ceramics-Vessels 504   Metropolitan Museum of Art, New York, NY 1
204034 62.70.48 0 1 325453 Ancient Near Eastern Art 14 Inlay 5268 Inlay Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Shell 2067 1.61 x 1.38 in. (4.09 x 3.51 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Shell-Ornaments 531   Metropolitan Museum of Art, New York, NY 1
204038 62.70.52 0 1 325457 Ancient Near Eastern Art 14 Inlay 5268 Inlay Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Shell 2067 1.22 x 0.98 in. (3.1 x 2.49 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Shell-Ornaments 531   Metropolitan Museum of Art, New York, NY 1
204039 62.70.53 0 1 325458 Ancient Near Eastern Art 14 Inlay 5268 Inlay: leg and foot Sumerian 5679 Early Dynastic IIIa                         ca. 2600–2350 B.C. -2600 -2350 Shell 2067 1.61 in. (4.09 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Shell-Ornaments 531   Metropolitan Museum of Art, New York, NY 1
204065 62.70.79 0 1 325484 Ancient Near Eastern Art 14 Foundation peg 13756 Foundation peg Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Bronze 23 3.23 x 2.64 in. (8.2 x 6.71 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Metalwork-Sculpture 521   Metropolitan Museum of Art, New York, NY 1
204066 62.70.80a, b 0 1 325485 Ancient Near Eastern Art 14 Foundation peg 13756 Foundation peg Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Bronze 23 2.56 x 2.24 in. (6.5 x 5.69 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Metalwork-Sculpture 521   Metropolitan Museum of Art, New York, NY 1
204072 62.70.86 0 1 325491 Ancient Near Eastern Art 14 Relief 3917 Plaque   Early Dynastic II-III                         ca. 2700–2350 B.C. -2700 -2350 Ceramic 161 2.28 x 2.52 x 0.91 in. (5.79 x 6.4 x 2.31 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Ceramics-Reliefs 614   Metropolitan Museum of Art, New York, NY 1
204078 62.70.92 0 1 325497 Ancient Near Eastern Art 14 Sealing 4029 Sealing Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Ceramic 161 1.18 x 1.44 in. (3 x 3.66 cm) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Clay-Sealings 627   Metropolitan Museum of Art, New York, NY 1
204081 62.70.95 0 1 325500 Ancient Near Eastern Art 14 Cuneiform tablet 13627 Cuneiform tablet: distribution of copper knives   Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Clay 5548 6.8 x 4.9 x 1.9 cm (2 5/8 x 1 7/8 x 3/4 in.) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Clay-Tablets-Inscribed 594   Metropolitan Museum of Art, New York, NY 1
204082 62.70.96 0 1 325501 Ancient Near Eastern Art 14 Cuneiform tablet 13627 Cuneiform tablet: fragment of an account Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Clay 5548 4.1 x 5.6 x 2.1 cm (1 5/8 x 2 1/4 x 7/8 in.) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Clay-Tablets-Inscribed 594   Metropolitan Museum of Art, New York, NY 1
204083 62.70.97 0 1 325502 Ancient Near Eastern Art 14 Cuneiform tablet 13627 Cuneiform tablet: fragment concerning canals (Sum.e) Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Clay 5548 4.5 x 5.2 x 2.5 cm (1 3/4 x 2 x 1 in.) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Clay-Tablets-Inscribed 594   Metropolitan Museum of Art, New York, NY 1
204084 62.70.98 0 1 325503 Ancient Near Eastern Art 14 Cuneiform tablet 13627 Cuneiform tablet: fragment of an account Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Clay 5548 2.8 x 4.7 x 1.9 cm (1 1/8 x 1 7/8 x 3/4 in.) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Clay-Tablets-Inscribed 594   Metropolitan Museum of Art, New York, NY 1
204085 62.70.99 0 1 325504 Ancient Near Eastern Art 14 Cuneiform tablet 13627 Cuneiform tablet: genre uncertain Sumerian 5679 Early Dynastic III                         ca. 2600–2350 B.C. -2600 -2350 Clay 5548 4.4 x 3.9 x 2.3 cm (1 3/4 x 1 1/2 x 7/8 in.) Rogers Fund, 1962           Mesopotamia 335 Nippur 81         Clay-Tablets-Inscribed 594   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 195.696ms · Data license: CC0 · Data source: metmuseum/openaccess