MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Reign = 353

View and edit SQL

Suggested facets: Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type, Country

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
377489 SL.3.2015.7.13 0 0 591207 Egyptian Art 19 Round Military Ration Token 26407 Round Military Ration Token   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Wood, paint 4879 Diam. 13.1 cm (5 3/16 in.) Museum of Fine Arts, Boston, Harvard University–Boston Museum of Fine Arts Expedition From 19       Sudan 161 Lower Nubia 681 Uronarti 346             Metropolitan Museum of Art, New York, NY 1
377506 SL.3.2015.9.1 0 0 591284 Egyptian Art 19 Head of a Statue of Amenemhat III 26424 Head of a Statue of Amenemhat III   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Granodiorite 55708 H. 11.6 cm (4 9/16 in.); W. 14.3 cm (5 5/8 in.) The Syndics of the Fitzwilliam Museum, Cambridge (E.2.1946) From 19       Egypt 104   Aswan 351             Metropolitan Museum of Art, New York, NY 1
377511 SL.3.2015.12.1 0 0 591292 Egyptian Art 19 Statue of Amenemhat III Standing in a Devotional Attitude 26429 Statue of Amenemhat III Standing in a Devotional Attitude   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Granodiorite 55708 H. 51.2 cm (20 3/16 in.); W. 19.8 cm (7 13/16 in.); D. 18.4 cm (7 1/4 in.) The Cleveland Museum of Art, Purchase from the J. H. Wade Fund, 1960.56 From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
377518 SL.3.2015.13.3 0 0 591300 Egyptian Art 19 Head of a Statue of Amenemhat III Wearing the White Crown 26436 Head of a Statue of Amenemhat III Wearing the White Crown   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Greywacke 25908 H. 46 cm (18 1/8 in.); W. 18.5 cm (7 5/16 in.); D. 25.5 cm (10 1/16 in.) Ny Carlsberg Glyptotek, Copenhagen From 19       Egypt 104                 Metropolitan Museum of Art, New York, NY 1
377537 SL.3.2015.25.9 0 0 591326 Egyptian Art 19 Head of a Colossal Statue of Amenemhat III Seated 26455 Head of a Colossal Statue of Amenemhat III Seated   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Black granite 56091 31 1/8 × 30 5/16 × 27 3/16 in. (79 × 77 × 69 cm) The Trustees of the British Museum, London From 19       Egypt 104 Eastern Delta 648 Tell Basta (Bubastis) 202 Temple of Bastet 150           Metropolitan Museum of Art, New York, NY 1
377587 SL.3.2015.32.9 0 0 591411 Egyptian Art 19 Statue of the Priest Amenemhatankh Standing 26501 Statue of the Priest Amenemhatankh Standing   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     ca. 1859-1813 B.C. -1864 -1854 Quartzite 28872 with restoration of feet that no longer exists: 28 3/8 × 7 1/16 × 11 15/16 in. (72 × 18 × 30.3 cm) Paris, Louvre Museum, Departement des Antiquités égyptiennes Possibly from|From 72   | 96   Egypt 104   Fayum 363             Metropolitan Museum of Art, New York, NY 1
381523 SL.3.2015.32.16 0 0 629400 Egyptian Art 19 Relief of the Goddess Hathor 26592 Relief of the Goddess Hathor   Middle Kingdom Dynasty 12 2 Amenemhat III 353                     1859-1813 BC -1859 -1813 Limestone 1737 24 13/16 × 27 3/16 × 2 9/16 in. (63 × 69 × 6.5 cm) Paris, Louvre Museum, Departement des Antiquités égyptiennes Found/excavated 38       Egypt 104   Lisht 314             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 122.881ms · Data license: CC0 · Data source: metmuseum/openaccess