MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Classification = 259 and Reign = 106

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Object End Date, Medium, 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 Metadata Date Repository
352452 352452 35.3.103 0 1 545166 Egyptian Art 19 Heart scarab, Neferkhawet 18543 Heart Scarab of Neferkhawet   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1447 Serpentinite, gold 55928 h. 4.6 cm (1 13/16 in); w. 6.5 cm (2 9/16 in); d. 2.2 cm (7/8 in) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), west chamber B 197 Burial of Neferkhawet, on chest of mummy 206 MMA excavations, 1934–35 61   | 259   http://www.metmuseum.org/art/collection/search/545166 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
356210 356210 35.3.22a, b 0 1 549125 Egyptian Art 19 Kohl jar, Amenemhat 20426 Kohl Jar   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1504 Travertine (Egyptian alabaster) 55630 Overall height H. 6.4 cm (2 1/2 in.). Jar: H. 6 cm (2 3/8 in.); Diam. 5.9 cm (2 5/16 in.); Diam. of rim 6 cm (2 3/8 in.). Lid: Diam. of lid 6.1 cm (2 7/16 in.); Th. 0.8 cm (5/16 in.) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), east chamber 144 Burial of Amenemhat (V), inside coffin by head 772 MMA excavations, 1934–35 61   | 259   http://www.metmuseum.org/art/collection/search/549125 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
356217 356217 35.3.29 0 1 549132 Egyptian Art 19 Knife, khepesh, Amenemhat 20432 Scribe's Knife from the Burial of Amenemhat   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1504 Bronze or copper alloy 55660 L. 18.3 cm (7 3/16 in.); W. 1.8 cm (11/16 in.); Greatest thickness of blade 0.2 cm (1/16 in.); Diam of hoof 0.8 cm (5/16 in.) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), east chamber 144 Burial of Amenemhat (V), inside coffin, by head 775 MMA excavations, 1934–35 61   | 259   http://www.metmuseum.org/art/collection/search/549132 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
356231 356231 35.3.62 0 1 549152 Egyptian Art 19 Kohl tube, Baki, five chambers 20446 Quatrefoil Kohl Tube of Baki   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1447 Ebony, ivory 22584 H. 5.3 cm (2 1/16 in); w. 3 cm (1 3/16 in); d. 3 cm (1 3/16 in) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), east chamber 144 Burial of Baki (III), inside coffin near feet 784 MMA excavations, 1935–36 4   | 259   http://www.metmuseum.org/art/collection/search/549152 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
356237 356237 35.3.75a, b 0 1 549161 Egyptian Art 19 Kohl Jar, Rennefer 20452 Kohl Jar of Rennefer   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1447 Travertine (Egyptian alabaster) 55630 Overall height 8.7 cm (3 7/16 in.). Jar: H. 8.2 cm (3 1/4 in.); Diam. 8.6 cm (3 3/8 in.); Diam. of rim 9.2 cm (3 5/8 in.); Diam. of mouth 2.2 cm (7/8 in.); Diam. of foot 7.7 cm (3 1/16 in.). Lid: Diam. 9.3 cm (3 11/16 in.); Th. 0.7 cm (1/4 in.) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), west chamber A 336 Burial of Rennefer (II), in coffin, near head 599 MMA excavations, 1935–36 4   | 259   http://www.metmuseum.org/art/collection/search/549161 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
356241 356241 35.3.80 0 1 549165 Egyptian Art 19 Scarab, Thutmose I, Rennefer 20456 Scarab with the Throne Name of Thutmose I   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1504 Faience 781 L. 1.6 cm (5/8 in); w. 1.2 cm (1/2 in); h. 0.8 cm (5/16 in) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), west chamber A 336 Burial of Rennefer (II), inside box 35.3.79 789 MMA excavations, 1934–35 61   | 259   http://www.metmuseum.org/art/collection/search/549165 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
366215 366215 35.3.50 0 1 560178 Egyptian Art 19 Cowroid, Ruiu, ankhs 24580 Cowroid Stamp Seal from Ruiu's Burial   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1447 Steatite (glazed) 55811 L. 1.5 cm (9/16 in.); W. 1 cm (3/8 in.); H. 0.6 cm (1/4 in.) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), east chamber 144 Burial of Ruiu (IV), inside 35.3.45a, b 780 MMA excavations, 1934–35 61   | 259   http://www.metmuseum.org/art/collection/search/560178 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445790 445790 35.3.26g 0 1 746252 Egyptian Art 19 Bead, Amenemhat 27226 Unfinished Bead   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1447 Faience 781 L. 1.4 cm (9/16 in.); Diam. 0.7 cm (1/4 in.) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), east chamber 144 Burial of Amenemhat (V), inside coffin, basket 774 MMA excavations 19   | 259   http://www.metmuseum.org/art/collection/search/746252 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445791 445791 35.3.26h 0 1 746253 Egyptian Art 19 Bead, Amenemhat 27226 Bead in the Form of a Date (?)   New Kingdom Dynasty 18, early 5 reign of Thutmose I–early sole Thutmose III 106                     ca. 1504–1447 B.C. -1504 -1447 Egyptian blue 55681 L. 1.1 cm (7/16 in.); Diam. 0.3 cm (1/8 in.) Rogers Fund, 1935 From 19       Egypt 104 Upper Egypt, Thebes 646 Asasif 131 Tomb of Neferkhawet (MMA 729), east chamber 144 Burial of Amenemhat (V), inside coffin, basket 774 MMA excavations 19   | 259   http://www.metmuseum.org/art/collection/search/746253 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 1054.245ms · Data license: CC0 · Data source: metmuseum/openaccess