MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Dynasty = 38

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Period, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, 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
351302 22.1.82 0 0 543991 Egyptian Art 19 Toilet cup 17639 Toilet cup   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Diorite 25928 H. 2.7 cm (1 1/16 in) Rogers Fund and Edward S. Harkness Gift, 1922 From 19       Egypt 104 Memphite Region 645 Lisht North 135 double row of pits, west of pyramid 39 Pit 392 35 MMA excavations, 1920–22 12       Metropolitan Museum of Art, New York, NY 1
351476 22.3.68 0 1 544166 Egyptian Art 19 Shrine, Amenemhat, Neferu 17771 Shrine with statues of Amenemhat and his wife Neferu   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1750 B.C. -1850 -1750 Limestone, paint 25808 H. 134 × W. 80 × Depth. 75 cm (52 3/4 × 31 1/2 × 29 1/2 in.) Rogers Fund and Edward S. Harkness Gift, 1922 From 19       Egypt 104 Upper Egypt, Thebes 646 Deir el-Bahri 146 Tomb MMA 202 61   MMA excavations, 1920–22 12       Metropolitan Museum of Art, New York, NY 1
353696 33.1.35 0 1 546470 Egyptian Art 19 Kohl jar 17630 Kohl jar   Late Middle Kingdom or early second Intermediate Period Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Travertine (Egyptian alabaster) 55630 h. 3.5 cm (1 3/8 in); d. 3 cm (1 3/16 in) Rogers Fund, 1933 From 19       Egypt 104 Memphite Region 645 Lisht South 130 tomb of Senwosretankh 38 Surface burial 34-37 336 MMA excavations, 1932–33 27       Metropolitan Museum of Art, New York, NY 1
353851 22.1.57 0 0 546625 Egyptian Art 19 Head, animal 19231 Head of animal   Middle Kingdom–Third Intermediate Period Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Clay, faience beads 56152 h. 4.5 cm (1 3/4 in) Rogers Fund and Edward S. Harkness Gift, 1922 From 19       Egypt 104 Memphite Region 645 Lisht North 135 cemetery south of pyramid, south of house A3:1 259 Pit 357 360 MMA excavations, 1920–22 12       Metropolitan Museum of Art, New York, NY 1
353873 15.3.153 0 0 546647 Egyptian Art 19 Gold fragments (from shabti) 19241 Gold leaf from shabti of Neferseneb (check name)   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Gold leaf 56126 h. 7.3 cm (2 7/8 in); w. 5.5 cm (2 3/16 in) Rogers Fund, 1915 From 19       Egypt 104 Memphite Region 645 Lisht North 135 Tomb of Nakht (493), south cemetery 264 Pit 456-457 365 MMA excavations, 1913–14 1       Metropolitan Museum of Art, New York, NY 1
353923 15.3.234 0 1 546697 Egyptian Art 19 Scarab 10062 Scarab   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Faience 781 L. 2.1 cm (13/16 in) Rogers Fund, 1915 From 19       Egypt 104 Memphite Region 645 Lisht North 135 cemetery south of pyramid below House A2:3 267 Pit 497 377 MMA excavations, 1913–14 1   | 259   Metropolitan Museum of Art, New York, NY 1
353952 09.180.1180a 0 0 546726 Egyptian Art 19 Beads (3) 19282 String of large ball beads   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Faience, paste 56170 a) l. 53 cm (20 7/8 in) b-d) l. 1.7 cm (11/16 in) Rogers Fund, 1909 From 19       Egypt 104 Memphite Region 645 Lisht North 135 cemetery south of the tomb of Senwosret (758) 51 Pit 609 393 MMA excavations, 1907–08 43       Metropolitan Museum of Art, New York, NY 1
354015 15.3.411 0 0 546792 Egyptian Art 19 Bead 3950 Bead   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1700 B.C. -1850 -1700 Copper or copper alloy 26849 diam. 1.3 cm (1/2 in) Rogers Fund, 1915 From 19       Egypt 104 Memphite Region 645 Lisht North 135 Tomb of Senwosret (758), inside 60 Pit 805, plunderers' breaks 419 MMA excavations, 1907–08 43       Metropolitan Museum of Art, New York, NY 1
355490 30.8.220 0 1 548331 Egyptian Art 19 hairpin, hippopotamus, Taweret 20005 Hairpin Decorated with a Hippopotamus   Middle Kingdom Dynasty 12, late–13 38                       ca. 1840–1640 B.C. -1840 -1840 Ivory 148 H. 9cm (3 9/16 in.); W. 1.2 cm (1/2 in.); D. 1.4 cm ( 9/16 in.) Theodore M. Davis Collection, Bequest of Theodore M. Davis, 1915 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
363081 1972.118.38 0 0 556547 Egyptian Art 19 Statuette, standing man 18009 Statuette of a striding man, [...}nakht   Middle Kingdom Dynasty 12, late–13 38                       ca. 1878–1640 B.C. -1878 -1878 Wood 25 H. 28 cm Bequest of Walter C. Baker, 1972 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
363095 86.1.91 0 1 556561 Egyptian Art 19 Magic wand 17760 Magic Wand   Middle Kingdom–Early New Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Ivory 148 L. 26.6 × W. 3.6 × H. 9.5 × Th. 1.5 cm (10 1/2 × 1 7/16 × 3 3/4 × 9/16 in.) Funds from various donors, 1886 From 19       Egypt 104         Egyptian Antiquities Service/Maspero excavations, 1885–86 96       Metropolitan Museum of Art, New York, NY 1
363310 08.200.22 0 1 556790 Egyptian Art 19 Statuette, female 17815 Statuette   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Wood 25 h. 15.8 cm (6 1/4 in) Rogers Fund, 1908 From 19       Egypt 104 Memphite Region 645 Lisht North 135 Cemetery 26   MMA excavations, 1906–07 9       Metropolitan Museum of Art, New York, NY 1
363805 11.151.622 0 1 557432 Egyptian Art 19 Music, clapper, arm, hand 18174 Clapper   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1750 B.C. -1850 -1750 Ivory 148 L. 21.4 cm (8 7/16 in.); W. 3.7 cm (1 7/16 in.); Th. 0.8 cm (5/16 in.) Rogers Fund, 1911 From 19       Egypt 104 Memphite Region 645 Lisht North 135 cemetery west of the tomb of Senwosret (758) 57 Pit 771, fill 1109 MMA excavations, 1906–07 9       Metropolitan Museum of Art, New York, NY 1
364215 33.1.34 0 1 558025 Egyptian Art 19 Ointment jar 17627 Ointment jar   Late Middle Kingdom or early second Intermediate Period Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Travertine (Egyptian alabaster) 55630 h. 3.5 cm (1 3/8 in); d. 2.7 cm (1 1/16 in) Rogers Fund, 1933 From 19       Egypt 104 Memphite Region 645 Lisht South 130 tomb of Senwosretankh 38 Surface burial 34-37 336 MMA excavations, 1932–33 27       Metropolitan Museum of Art, New York, NY 1
366339 22.1.1700 0 1 560337 Egyptian Art 19 Sealing 4029 Sealing   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1750 B.C. -1850 -1750 Mud 7961   Rogers Fund and Edward S. Harkness Gift, 1922 From 19       Egypt 104 Memphite Region 645 Lisht North 135 cemetery south of pyramid 725   MMA excavations, 1920–21 50       Metropolitan Museum of Art, New York, NY 1
409957 09.180.1180b-d 0 0 675874 Egyptian Art 19 Beads (3) 19282 String of large ball beads   Middle Kingdom Dynasty 12, late–13 38                       ca. 1850–1640 B.C. -1850 -1640 Faience, paste 56170 a) l. 53 cm (20 7/8 in) b-d) l. 1.7 cm (11/16 in) Rogers Fund, 1909 From 19       Egypt 104 Memphite Region 645 Lisht North 135 cemetery south of the tomb of Senwosret (758) 51 Pit 609 393 MMA excavations, 1907–08 43       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 143.324ms · Data license: CC0 · Data source: metmuseum/openaccess