MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Excavation = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Period, Dynasty, Reign, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Locale, Locus

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 Metadata Date Repository
351258 351258 26.7.1433a, b 0 1 543947 Egyptian Art 19 Ointment jar, foundation deposit, Hatshepsut 17617 Ointment jar from a Foundation Deposit of Hatshepsut's Valley Temple   New Kingdom Dynasty 18 21 Joint reign of Hatshepsut and Thutmose III 30                     ca. 1479–1458 B.C. -1479 -1458 Travertine (Egyptian alabaster) 55630 H. 12 cm (4 3/4 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Hatshepsut Causeway 27 Foundation Deposit (secondary dep. 14-60) 20 Carnarvon excavations, 1912 20       http://www.metmuseum.org/art/collection/search/543947 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354222 354222 26.7.124 0 1 546999 Egyptian Art 19 Scarab, Nefertari 19397 Scarab Inscribed With the Name Nefertari   New Kingdom Dynasty 18, early 5 reign of Ahmose I 121                     ca. 1550–1525 B.C. -1550 -1525 Blue glazed steatite 55777 L. 1.1 cm (7/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 43 298 Burial 12 162 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/546999 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354223 354223 26.7.134 0 1 547000 Egyptian Art 19 Scarab, Amenhotep, Red Crowns 19398 Scarab Inscribed With the Name Amenhotep Flanked by Two Red Crowns   New Kingdom Dynasty 18 21 reign of Amenhotep I 91                     ca. 1525–1504 B.C. -1525 -1504 Glazed steatite 55680 L. 1.3 cm (1/2 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 43 298 Burial 12 162 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547000 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354224 354224 26.7.135 0 1 547001 Egyptian Art 19 Scarab, Amenhotep 19399 Scarab Inscribed With the Name Amenhotep   New Kingdom Dynasty 18, early 5                       ca. 1550–1458 B.C. -1550 -1295 Green glazed steatite 55774 L. 1.3 cm (1/2 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 43 298 Burial 12 162 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547001 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354225 354225 26.7.163 0 1 547002 Egyptian Art 19 Scarab, Neferure 19400 Scarab Inscribed With the Name of Princess Neferure   New Kingdom Dynasty 18 21 Joint reign of Hatshepsut and Thutmose III 30                     ca. 1479–1458 B.C. -1473 -1458 Green glazed steatite 55774 l. 1.2 cm (1/2 in) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 43 298 Burial 7 489 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547002 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354228 354228 26.7.489 0 1 547005 Egyptian Art 19 Scarab, Wedjat Eye, Nefer 19402 Scarab Inscribed With a Wedjat Eye and a Nefer Hieroglyph   Late Second Intermediate Period–Early New Kingdom Dynasty 17–Early Dynasty 18 25                       ca. 1635–1458 B.C. -1580 -1550 Blue glazed steatite 55777 L. 1.4 cm (9/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 46 300 Burial 1 131 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354233 354233 26.7.579 0 1 547010 Egyptian Art 19 Scarab 10062 Scarab   Second Intermediate Period Dynasty 13–17 35                       ca. 1640–1550 B.C. -1640 -1550 Blue glazed steatite 55777 L. 2.5 cm (1 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 47 297   Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547010 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354237 354237 26.7.631 0 0 547014 Egyptian Art 19 Scarab 10062 Scarab   Middle Kingdom–Second Intermediate Period Dynasty 12–17 23                       ca. 2030–1550 B.C. -2030 -2030 Blue glazed steatite 55777 L. 2 cm (13/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 47 (or 43?) 302 Burial 21 496 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547014 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354238 354238 26.7.637 0 1 547015 Egyptian Art 19 Scarab 10062 Scarab   Second Intermediate Period–Early New Kingdom                         ca. 1640–1504 B.C. -1640 -1504 Dark green jasper 56235 L. 1.7 cm (11/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 46 300 Burial 12 162 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547015 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354244 354244 26.7.688 0 0 547021 Egyptian Art 19 Scarab 10062 Scarab   Second Intermediate Period Dynasty 13–17 35                       ca. 1640–1550 B.C. -1640 -1550 Blue glazed steatite 55777 L. 1.2 cm (1/2 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Courtyard CC 41, Tomb 62 304 Facade, lower rubbish 499 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547021 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
354245 354245 26.7.728 0 0 547022 Egyptian Art 19 Scarab, face 19410 Scarab   Second Intermediate Period Dynasty 13–17 35                       ca. 1640–1550 B.C. -1640 -1550 Blue glazed steatite 55777 L. 1.6 cm (5/8 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Courtyard CC 41, Tomb (?) 305 Burial 10 149 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/547022 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
357707 357707 26.7.846 0 1 550888 Egyptian Art 19 Statuette, Neith 18956 Statuette, Neith   Late Period Dynasty 26–29 53                       664–380 B.C. -664 -664 Bronze or copper alloy 55660 17.5 cm (6 7/8 in) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104         Carnarvon excavations, 1912 20       http://www.metmuseum.org/art/collection/search/550888 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
359014 359014 26.7.122 0 1 552372 Egyptian Art 19 Scarab 10062 Scarab   New Kingdom Dynasty 18, early 5 reign of Ahmose I 121                     ca. 1550–1525 B.C. -1550 -1525 Pottery 7419 L. 1.4 cm (9/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 43 298 Burial 12 162 Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/552372 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
359062 359062 26.7.572 0 1 552420 Egyptian Art 19 Scarab 10062 Scarab   New Kingdom                         ca. 1786–1482 B.C. -1786 -1786 Glazed steatite in gold funda 56814 L. 1.5 cm (9/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb CC 47 297   Carnarvon excavations, 1912 20   | 259   http://www.metmuseum.org/art/collection/search/552420 4/23/2018 8:00:01 AM 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 131.011ms · Data license: CC0 · Data source: metmuseum/openaccess