MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Subregion = 171

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Period	Dynasty	Reign	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	State	Country	Region	Subregion	Locale	Locus	Excavation	Classification	Link Resource	Metadata Date	Repository
351490	351490	56.136	1	544181	Egyptian Art 19	Statue, Hetepsebek, Senbebu, two women 17785	Statue of the Overseer of Stonemasons Senbebu and Family	Middle Kingdom	Dynasty 12 2		ca. 1981–1802 B.C.	-1981	-1802	Sandstone 6928	H. 22.2 cm (8 3/4 in.); W. 30 cm (11 13/16 in.); D. 16 cm (6 5/16 in.)	Dodge Fund, 1956	From\|Probably originally from 70	\| 96	Egypt 104	Southern Upper Egypt 647	Elephantine 171					http://www.metmuseum.org/art/collection/search/544181	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
355407	355407	12.213	1	548231	Egyptian Art 19	Statue, pair, Amenemhat, Ahmose-Baketamun 19937	Pair Statue of Amenemhat and Ahmose-Baketamun	New Kingdom	Dynasty 18 21	reign of Thutmose III 31	ca. 1478–1425 B.C.	-1478	-1425	Travertine (Egyptian alabaster) 55630	H. 27.3 (10 3/4 in.); W. 16 (6 5/16 in.); D. 14.8 cm (5 13/16 in.)	Gift of Mrs. J. E. Childs, in memory of her husband, 1912	From\|Probably from 69	\| 96	Egypt 104	Southern Upper Egypt 647	Elephantine 171					http://www.metmuseum.org/art/collection/search/548231	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
370911	370911	11.154.9	1	565085	Egyptian Art 19	Obelisk 650	Obelisk	Ptolemaic Period			304–30 B.C.	-304	-30	Sandstone 6928	total 199.5 cm (78 9/16 in); shaft h. 170.5 cm (67 1/8 in), w. 15.2 cm (6 in), d. 15 cm (5 7/8in); base h. 29 cm (11 7/16 in), w. 42 cm (16 9/16 in), d. 35 cm (13 3/4 in)	Rogers Fund, 1911	From 19		Egypt 104	Southern Upper Egypt 647	Elephantine 171	tomb of a sacred ram 765	chapel 1245	Cledat and Clermont-Ganneau excavations, March 1907 310		http://www.metmuseum.org/art/collection/search/565085	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
375541	375541	05.3.59	0	572928	Egyptian Art 19	Scarab, Thutmose III 20236	Scarab	New Kingdom	Dynasty 18 21	reign of Thutmose III 31	ca. 1479–1425 B.C.	-1479	-1479	Steatite 12579	L. 0.018m	Gift of J. Pierpont Morgan, 1905	From\|Probably from 69	\| 96	Egypt 104	Southern Upper Egypt 647	Elephantine 171				\| 259	http://www.metmuseum.org/art/collection/search/572928	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
377483	377483	SL.3.2015.5.7	0	591199	Egyptian Art 19	Statue of the Brewer Renefsenebdag Seated 26401	Statue of the Brewer Renefsenebdag Seated	Middle Kingdom	Dynasty 12-13 167		ca. 1981-1640 B.C.	-1986	-1976	Steatite 12579	H. 33.6 cm (13 1/4 in.); W. 10.5 cm (4 1/8 in.); D. 19.3 cm (7 5/8 in.)	Staatliche Museen zu Berlin, Ägyptisches Museum und Papyrussammlung	From 19		Egypt 104		Elephantine 171					http://www.metmuseum.org/art/collection/search/591199	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

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");