MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Medium = 26731

Search:

descending

Link	rowid ▼	Object Number	Object ID	Department	Object Name	Title	Culture	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	City	Country	Region	River	Classification	Link Resource	Metadata Date	Repository
190773	190773	1972.4.50	309839	Arts of Africa, Oceania, and the Americas 10	Pipe bowl 8222	Model Pipe Bowl: Double Gong	Bamum (Bamendjing) 4502	19th–20th century	1800	2000	Terracotta, pigment 26731	H. 7 3/4 x W. 2 in. (19.7 x 5.1 cm)	Fletcher Fund, 1972		Cameroon 70	Grassfields 62	Nun River 33	Ceramics-Implements 218	http://www.metmuseum.org/art/collection/search/309839	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
195470	195470	1984.515.3	314806	Arts of Africa, Oceania, and the Americas 10	Figure 9	Maternity Figure (Ntekpe)	Igbo or Ankwe peoples 5179	19th–20th century	1800	2000	Terracotta, pigment 26731	H x W x D: 9 x 4 3/4 x 5in. (22.9 x 12.1 x 12.7cm)	Gift of Drs. Noble and Jean Endicott, 1984		Nigeria 83		Benue River Valley region 36	Ceramics-Sculpture 490	http://www.metmuseum.org/art/collection/search/314806	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
195530	195530	1986.478.19	314866	Arts of Africa, Oceania, and the Americas 10	Vessel 3894	Vessel	Nupe peoples 4639	19th–20th century	1800	2000	Terracotta, pigment 26731	Height 15-1/2 in. Diameter: 12 1/4 in.	The Bryce Holcombe Collection of African Decorative Art, Bequest of Bryce Holcombe, 1984		Nigeria 83		Benue River Valley region 36	Ceramics-Containers 483	http://www.metmuseum.org/art/collection/search/314866	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
195745	195745	1987.328.1	315081	Arts of Africa, Oceania, and the Americas 10	Pipe bowl 8222	Pipe Bowl: Bird (Sankofa)	Asante 4586	19th–20th century	1800	2000	Terracotta, pigment 26731	H. 4 x W. 3 1/8 x D. 1 5/8 in. (10.2 x 7.9 x 4.1 cm)	Gift of Alfred L. Scheinberg in memory of Bernard Scheinberg, 1987		Ghana 89			Ceramics-Implements 218	http://www.metmuseum.org/art/collection/search/315081	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
197119	197119	1991.17.5	316478	Arts of Africa, Oceania, and the Americas 10	Head 3965	Head	Edo peoples 4409	20th century	1900	2000	Terracotta, pigment 26731	Height 9-1/8 in.	Gift of Mr. and Mrs. Klaus G. Perls, 1991	Court of Benin 725	Nigeria 83			Ceramics-Sculpture 490	http://www.metmuseum.org/art/collection/search/316478	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");