MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

20 rows where Classification = 218 and Country = 70

View and edit SQL

Suggested facets: Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Region

Country

  • Cameroon · 20
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
190758 1972.4.34 0 0 309824 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Bamessing 4497                           19th–20th century 1800 2000 Terracotta, wood 26727 H x D: 2 3/8 x 7 3/4 in. (6.1 x 19.7 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190759 1972.4.35 0 0 309825 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Bamessing and Babungo 4498                           19th–20th century 1800 2000 Terracotta, wood, iron 26728 H. 6 1/2 x D. 18 1/2 in. (16.5 x 47 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190761 1972.4.38 0 0 309827 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Bamileke (Bangangte) 4500                           19th–20th century 1800 2000 Terracotta, wood, copper 26729 D. 40 × Diam. 3 1/4 in. (101.6 × 8.3 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190762 1972.4.39 0 0 309828 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Bamileke (Bangangte) 4500                           20th century 1900 2000 Terracotta, wood 26727 Height: 14 1/4in. (36.2cm) Height ((bowl)): 6 1/4in. (15.9cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190763 1972.4.40 0 0 309829 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Bamessing 4497                           19th–20th century 1800 2000 Terracotta, wood, iron 26728 W x D: 2 5/8 x 22 in. (6.7 x 55.9 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190765 1972.4.42 0 0 309831 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe: Figure Bamileke (Bagam) 4474                           19th–20th century 1800 2000 Terracotta, wood, iron 26728 Depth: 19 3/4in. (50.2cm) Diameter ((bowl)): 3in. (7.6cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190766 1972.4.43 0 0 309832 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Bamum 4501         Artist 2   Tita Yuefainji     Yuefainji, Tita (Robert of Tungo) 16973       19th–20th century 1800 2000 Terracotta, camwood powder 26730 Height: 7 1/2in. (19.1cm) Diameter ((bowl)): 2 1/2in. (6.4cm) Fletcher Fund, 1972   Fumban 729     Cameroon 70 Grassfields 62           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190767 1972.4.44 0 0 309833 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Baboon Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 4 1/8 x W. 2 7/8 x D. 3 3/8 in. (10.5 x 7.3 x 8.6 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190768 1972.4.45 0 0 309834 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 6 1/8 x W. 3 3/8 in. (15.6 x 8.6 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190769 1972.4.46 0 0 309835 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 3 3/4 x W. 2 3/4 in. (9.5 x 7 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190770 1972.4.47 0 0 309836 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 3 5/8 x W. 2 3/8 in. (9.2 x 6.1 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190771 1972.4.48 0 0 309837 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 3 1/2 x W. 2 5/8 in. (8.9 x 6.7 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190772 1972.4.49 0 0 309838 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 5 1/4 x W. 2 1/8 in. (13.3 x 5.4 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190773 1972.4.50 0 0 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   Metropolitan Museum of Art, New York, NY 1
190774 1972.4.51 0 0 309840 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Figure Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 6 x W. 3 in. (15.2 x 7.6 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190775 1972.4.52 0 0 309841 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497         Artist 2   Tita Yuefainji     Yuefainji, Tita (Robert of Tungo) 16973       19th–20th century 1800 2000 Terracotta 160 H. 4 1/4 x W. 3 in. (10.8 x 7.6 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
190776 1972.4.53 0 0 309842 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Model Pipe Bowl: Head Bamessing 4497                           19th–20th century 1800 2000 Terracotta 160 H. 4 3/8 x W. 2 5/8 in. (11.1 x 6.7 cm) Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
195403 1983.602.1 0 0 314739 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Cameroon 4613                           19th–20th century 1800 2000 Terracotta, wood, brass, cord 27651 H x W x D: 4 5/8 x 44 x 5 1/2 in. (11.8 x 111.8 x 14 cm) Gift of Drs. Herbert F. and Teruko S. Neuwalder, 1983         Cameroon 70             Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
199606 2003.349.1 0 0 319260 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Pipe Bowl Bamenda 5565                           20th century 1875 2025 Terracotta 160 H. 6 1/2 x W. 3 1/4 in. (16.5 x 8.3 cm) Gift of Michael Oliver, 2003         Cameroon 70 Western Grassfields region 81           Ceramics-Implements 218   Metropolitan Museum of Art, New York, NY 1
199607 2003.349.2 0 0 319261 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Pipe Bowl Bamenda 5565                           20th century 1875 2025 Terracotta 160 H. 9 1/2 x W. 5 1/4 in. (24.1 x 13.3 cm) Gift of Michael Oliver, 2003         Cameroon 70 Western Grassfields region 81           Ceramics-Implements 218   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 164.236ms · Data license: CC0 · Data source: metmuseum/openaccess