MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Subregion = 178

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Period, Dynasty, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Region, 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
351556 07.231.10 0 1 544249 Egyptian Art 19 Model, house, soul house 17834 Model of a House   Middle Kingdom Dynasty 13, mid 75                       ca. 1750–1700 B.C. -1750 -1750 Pottery 7419 l. 40 cm (15 3/4 in); w. 54 cm (21 1/4 in); th. 34 cm (13 3/8 in) Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178   Tomb 72 86 BSAE, excavations 1906-1907 62       Metropolitan Museum of Art, New York, NY 1
351653 12.181.197 0 1 544350 Egyptian Art 19 Offering table, Senebtisi 17906 Double offering table   Middle Kingdom Dynasty 12 2                       ca. 1981–1802 B.C. -1981 -1981 Limestone 1737 L. 30.5 × W. 34 × H. 6.5 cm, 10.9 kg (12 × 13 3/8 × 2 9/16 in., 24 lb.) Rogers Fund, 1912 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178     Khashaba excavations, 1910 60       Metropolitan Museum of Art, New York, NY 1
352754 07.231.8 0 0 545470 Egyptian Art 19 Statue, Khnumu 18686 Khnumu Seated   Middle Kingdom Dynasty 12 2 reign of Amenemhat I–Senwosret I 58                     ca. 1981–1917 B.C. -1981 -1981 Diorite (Finlay) 55982 H. 35.5 cm (14 in.) Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178     BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
359237 07.231.17 0 1 552596 Egyptian Art 19 Necklace, Bastet pendant 22046 Necklace with Bastet Pendant   Third Intermediate Period or later Dynasty 21–25 109                       ca. 1070–664 B.C. -1070 -1070 Blue faience 55768   Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178   Tomb 329 913 BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
359718 07.231.18 0 0 553083 Egyptian Art 19 String of Beads 22260 String of Beads   Third Intermediate Period Dynasty 22 113                       ca. 1070–945 B.C. -1070 -1070 Shell, faience 56921   Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178   Tomb 329 913 BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
360531 07.231.26 0 1 553923 Egyptian Art 19 Shabti 17897 Shabti   New Kingdom Dynasty 18 21                       ca. 1550–1295 B.C. -1550 -1295 Pottery 7419 H. 15.7 cm (6 3/16 in.) Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178     BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
360532 07.231.29 0 0 553924 Egyptian Art 19 Shabti 17897 Shabti   New Kingdom Dynasty 18 21                       ca. 1550–1295 B.C. -1550 -1295 Pottery 7419 H. 16.2 cm (6 3/8 in.) Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178     BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
362340 07.231.20 0 0 555784 Egyptian Art 19 Necklace, amulets 21451 String of beads and amulets   Middle Kingdom Dynasty 12 2                       ca. 1981–1802 B.C. -1981 -1802 Faience 781 L. 40.8 cm (16 1/16 in.) Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Northern Upper Egypt 644 Deir Rifa 178     BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
362379 07.231.11 0 1 555830 Egyptian Art 19 Model, house, soul house 17834 Model of a house   Middle Kingdom Dynasty 13, mid 75                       ca. 1750–1700 B.C. -1750 -1700 Pottery 7419 l. 27 cm (10 5/8 in); w. 27 cm (10 5/8 in); th. 17 cm (6 11/16 in) Gift of The Egyptian Research Account and British School of Archaeology in Egypt, 1907 From 19       Egypt 104 Middle Egypt 649 Deir Rifa 178   Tomb 72 86 BSAE excavations 1906-1907 117       Metropolitan Museum of Art, New York, NY 1
377566 SL.3.2015.29.5 0 0 591372 Egyptian Art 19 Pectoral and Fly-Shaped Beads 26481 Pectoral and Fly-Shaped Beads   Middle Kingdom Dynasty 12 2                       ca. 1981-1802 B.C. -1986 -1976 Shell, faience 56921 shell: H. 9.5 cm (3 3/4 in.); W. 9.3 cm (3 11/16 in.); string of beads: L. 19 cm (7 1/2 in.); each bead: L. 0.7 cm (1/4 in.) The Manchester Museum, The University of Manchester From 19       Egypt 104   Deir Rifa 178             Metropolitan Museum of Art, New York, NY 1
377567 SL.3.2015.29.6 0 0 591373 Egyptian Art 19 Model of a House 26462 Model of a House   Middle Kingdom Dynasty 12 2                       ca. 1981-1802 B.C. -1986 -1976 Clay 5548 10 11/16 × 13 3/8 × 10 13/16 in. (27.1 × 34 × 27.5 cm) The Manchester Museum, The University of Manchester From 19       Egypt 104   Deir Rifa 178             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 149.57ms · Data license: CC0 · Data source: metmuseum/openaccess