MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Reign = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Region, Subregion, Locale, Excavation

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
351181 351181 26.7.1287a–k 1 1 543867 Egyptian Art 19 Game box, hounds and jackals, Reniseneb 17554 Game of Hounds and Jackals   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1805 Ebony, ivory 22584 Board: H. 6.8 cm (2 11/16 in.); W. 10.1 cm (4 in.); D. 15.6 cm (6 1/8 in.); Average height with pins: H. 14 cm (5 1/2 in.); Jackal pins: H. 7 cm (2 3/4 in.) to 8.5 cm (3 3/8 in.) Bottom (2012.508): L. 12.9 cm (5 1/16 in); W. 7.4 cm (2 15/16 in); Th. 0.3 cm (1/8 in) Hound pins: H. 6 cm (2 3/8 in.) to 6.8 cm (2 11/16 in.) Purchase, Edward S. Harkness Gift, 1926 (26.7.1287a-k); Gift of Lord Carnarvon, 2012 (2012.508) From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif, Birabi 132 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/543867 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351266 351266 26.7.1438 0 1 543955 Egyptian Art 19 Cosmetic box, Kemeni 17625 Cosmetic Box of the Royal Butler Kemeni   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1814 Cedar, with ebony and ivory veneer and silver mounting 55648 L. 28.5 cm (11 1/4 in.); W. 17.7 cm (6 15/16 in.); H. 20.3 cm (8 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif, Birabi 132 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/543955 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351267 351267 26.7.1440a, b 0 1 543956 Egyptian Art 19 Ointment jar, lid 17626 Cosmetic jar with lid   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1814 Travertine (Egyptian alabaster) 55630 H. 8.2 cm (3 1/4 in.); Diam. 5.5 cm (2 3/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/543956 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351268 351268 26.7.1441a, b 0 1 543957 Egyptian Art 19 Ointment jar, lid 17626 Cosmetic jar with lid   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1814 Travertine (Egyptian alabaster) 55630 H. 7.7 cm (3 1/16 in.); Diam 5 cm (1 15/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/543957 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351269 351269 26.7.1442 0 1 543958 Egyptian Art 19 Ointment jar 17627 Cosmetic jar   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1814 Travertine (Egyptian alabaster) 55630 H. 7.4 cm (2 15/16 in.); W. 5.5 cm (2 3/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif, Birabi 132 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/543958 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351280 351280 26.7.1439a, b 0 1 543969 Egyptian Art 19 Ointment jar, lid 17626 Ointment jar with lid   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1814 Travertine (Egyptian alabaster) 55630 H. 8.3 cm (3 1/4 in.); Diam. 5.5 cm (2 3/16 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif, Birabi 132 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/543969 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
362237 362237 22.1.12a, b 0 1 555680 Egyptian Art 19 Door lintel, temple relief, Amenemhat IV 23327 Door lintel temple relief   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1813–1802 B.C. -1813 -1802 Limestone, paint traces 55631 h. 25 cm (9 13/16 in); w. 65 cm (25 9/16 in) Rogers Fund and Edward S. Harkness Gift, 1922 From 19       Egypt 104 Memphite Region 645 Lisht North 135 Pyramid Temple of Amenemhat I 9   MMA excavations, 1920–22 12       http://www.metmuseum.org/art/collection/search/555680 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377602 377602 2012.508 0 1 591455 Egyptian Art 19 Game box, hounds and jackals, Reniseneb 17554 Bottom of Game Board of Reniseneb (part of 26.7.1287)   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1805 Ebony 12685 L. 12.9 cm (5 1/16 in); W. 7.4 cm (2 15/16 in); Th. 0.3 cm (1/8 in) Gift of Lord Carnarvon, 2012 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3       http://www.metmuseum.org/art/collection/search/591455 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399855 399855 26.7.1438-related 0 1 654374 Egyptian Art 19 Cosmetic box, Kemeni, mirror, Reniseneb, jars 26729 Cosmetic Box of Kemeni and Mirror of Reniseneb   Middle Kingdom Dynasty 12 2 reign of Amenemhat IV 3                     ca. 1814–1805 B.C. -1814 -1814 Cedar, with ebony and ivory veneer and silver mounting 55648 L. 28.5 cm (11 1/4 in.); W. 17.7 cm (6 15/16 in.); H. 20.3 cm (8 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif, Birabi 132 pit tomb CC 25 3 debris 2 Carnarvon/Carter excavations, 1910 3   | 259   http://www.metmuseum.org/art/collection/search/654374 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 134.941ms · Data license: CC0 · Data source: metmuseum/openaccess