MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Dynasty = 2 and Is Highlight = 1

View and edit SQL

Suggested facets: Reign, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type, Region, Subregion, Locale, Locus, 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 Repository
351178 14.3.17 1 1 543864 Egyptian Art 19 Statue, guardian figure 17551 Guardian Figure   Middle Kingdom Dynasty 12 2 reign of Amenemhat II 1                     ca. 1919–1885 B.C. -1919 -1885 Cedar wood, plaster, paint  55622 H. 57.6 cm (22 11/16 in.); W. 11 cm (4 5/16 in.); D. 26 cm (10 1/4 in.) Rogers Fund and Edward S. Harkness Gift, 1914 From 19       Egypt 104 Memphite Region 645 Lisht South 130 tomb of Imhotep 1 chamber inside the south enclosure wall 1 MMA excavations, 1913–14 1       Metropolitan Museum of Art, New York, NY 1
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       Metropolitan Museum of Art, New York, NY 1
351493 26.7.1394 1 1 544184 Egyptian Art 19 Head, Senwosret III 17788 Face of Senwosret III   Middle Kingdom Dynasty 12 2 reign of Senwosret III 36                     ca. 1878–1840 B.C. -1878 -1878 Red quartzite 55712 H. 16.5 × W. 12.6 × D. 11.4 cm (6 1/2 × 4 15/16 × 4 1/2 in.) Purchase, Edward S. Harkness Gift, 1926 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
351495 17.9.2 1 1 544186 Egyptian Art 19 Sphinx, Senwosret III 17790 Senwosret III as a Sphinx   Middle Kingdom Dynasty 12 2 reign of Senwosret III 36                     ca. 1878–1840 B.C. -1878 -1840 Gneiss 25715 L. 73 × W. 29.5 × H. 42.5 cm, 114.3 kg (28 3/4 × 11 5/8 × 16 3/4 in., 252 lb.) Gift of Edward S. Harkness, 1917 Possibly from|From 72   | 96   Egypt 104 Upper Egypt, Thebes 646 Karnak 173             Metropolitan Museum of Art, New York, NY 1
351518 20.3.7 1 1 544210 Egyptian Art 19 Statue, standing woman, offering 17806 Estate Figure   Middle Kingdom Dynasty 12 2 early reign of Amenemhat I 65                     ca. 1981–1975 B.C. -1981 -1981 Wood, gesso, paint 55718 H. 112 cm (44 1/8 in.); W. 17 cm (6 11/16 in.); D. 46.7 cm (18 3/8 in.) Rogers Fund and Edward S. Harkness Gift, 1920 From 19       Egypt 104 Upper Egypt, Thebes 646 Southern Asasif 168 Tomb of Meketre (TT 280, MMA 1101) 53 serdab 76 MMA excavations, 1920 45       Metropolitan Museum of Art, New York, NY 1
351522 20.3.1 1 1 544214 Egyptian Art 19 Travelling boat, Meketre, music, harp 17810 Travelling Boat being Rowed   Middle Kingdom Dynasty 12 2 reign of Amenemhat I, early 52                     ca. 1981–1975 B.C. -1981 -1981 Wood, paint, gesso, linen twine and linen fabric 55721 l. 128 cm (50 3/8 in), with rudder 175 cm (68 7/8 in) x w. with oars 30.5 cm (12 in) x h. 37 cm (14 9/16 in) Rogers Fund and Edward S. Harkness Gift, 1920 From 19       Egypt 104 Upper Egypt, Thebes 646 Southern Asasif 168 Tomb of Meketre (TT 280, MMA 1101) 53 serdab 76 MMA excavations, 1920 45   | 259   Metropolitan Museum of Art, New York, NY 1
351534 17.9.1 1 1 544227 Egyptian Art 19 Figurine, Hippopotamus ("William") 17818 Hippopotamus ("William")   Middle Kingdom Dynasty 12 2 Senwosret I to Senwosret II 66                     ca. 1961–1878 B.C. -1961 -1878 Faience 781 L. 20 cm (7 7/8 in.); W. 7.5 cm (2 15/16 in.); H. 11.2 cm (4 7/16 in.) Gift of Edward S. Harkness, 1917 From 19       Egypt 104 Middle Egypt 649 Meir 145 Tomb B3 of the nomarch Senbi II 74 pit 1 (steward Senbi) 79 Khashaba excavations, 1910 60       Metropolitan Museum of Art, New York, NY 1
351535 40.3.12 1 1 544228 Egyptian Art 19 Scarab, bracelet, Wah 17819 Scarab of the Storehouse Overseer Wah   Middle Kingdom Dynasty 12 2 reign of Amenemhat I, early 52                     ca. 1981–1975 B.C. -1981 -1981 Silver, electrum, glazed steatite, linen cord  55724 scarab: l. 3.9 cm (1 1/2 in.); w. 2.7 cm (1 1/16 in.); h. 2.5 cm (1 in.); barrel bead: l. 1.4 cm (9/16 in.); diam. 1 cm (3/8 in.); cylindrical bead: l. 1.9 cm (3/4 in.); 0.8 cm (5/16 in.) overall length: 43 cm (16 15/16 in) Rogers Fund and Edward S. Harkness Gift, 1940 From 19       Egypt 104 Upper Egypt, Thebes 646 Southern Asasif 168 Tomb of Wah (MMA 1102) 75 Mummy, over crossed wrists 80 MMA excavations, 1920 45   | 259   Metropolitan Museum of Art, New York, NY 1
351539 16.1.3a, b 1 1 544232 Egyptian Art 19 Necklace, pectoral, Sithathoryunet, Senwosret II 17823 Pectoral and Necklace of Sithathoryunet with the Name of Senwosret II   Middle Kingdom Dynasty 12 2 reign of Senwosret II 67                     ca. 1887–1878 B.C. -1887 -1878 Gold, carnelian, lapis lazuli, turquoise, garnet (pectoral) Gold, carnelian, lapis lazuli, turquoise, green feldspar (necklace) 55725 L. of necklace (b): 82 cm (32 5/16 in.); H. of pectoral (a): 4.5 cm (1 3/4 in.); W. 8.2 cm (3 1/4 in.) Purchase, Rogers Fund and Henry Walters Gift, 1916 From 19       Egypt 104 Fayum Entrance Area 650 Lahun 147 Tomb of Sithathoryunet (BSA Tomb 8) 34   BSAE excavations 1914 24       Metropolitan Museum of Art, New York, NY 1
351622 28.9.4 1 1 544319 Egyptian Art 19 Writing Board 17878 Writing board   Middle Kingdom Dynasty 12 2                       ca. 1981–1802 B.C. -1981 -1802 Wood, gesso, paint 55718 L. 43 cm (16 15/16 in); w. 19 cm (7 1/2 in) Gift of Edward S. Harkness, 1928 From|Said to be from 74   | 96   Egypt 104 Upper Egypt, Thebes or Northern Upper Egypt 651 Akhmim (Khemmis, Panopolis) 185             Metropolitan Museum of Art, New York, NY 1
351623 12.184 1 1 544320 Egyptian Art 19 Stela, Mentuwoser 17879 Stela of the Steward Mentuwoser   Middle Kingdom Dynasty 12 2 reign of Senwosret I, year 17 70                     ca. 1944 B.C. -1944 -1944 Limestone, paint 25808 H. 103 cm (40 9/16 in.); W. 50.5 cm (19 7/8 in.); Th. 8.3 cm (3 1/4 in.) Gift of Edward S. Harkness, 1912 From|Probably from 69   | 96   Egypt 104 Northern Upper Egypt 644 Abydos 142             Metropolitan Museum of Art, New York, NY 1
352567 20.3.11 1 1 545281 Egyptian Art 19 Model, granary, Meketre 18595 Model of a Granary with Scribes   Middle Kingdom Dynasty 12 2 early reign of Amenemhat I 65                     ca. 1981–1975 B.C. -1981 -1981 Wood, plaster, paint, linen, grain 55958 L. 74.9 (29 1/2 in); W. 56 cm (22 1/16 in); H. 36.5 (14 3/8 in); average height of figures: 20 cm (7 7/8 in.) Rogers Fund and Edward S. Harkness Gift, 1920 From 19       Egypt 104 Upper Egypt, Thebes 646 Southern Asasif 168 Tomb of Meketre (TT 280, MMA 1101) 53 serdab 76 MMA excavations, 1920 45       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 341.803ms · Data license: CC0 · Data source: metmuseum/openaccess