MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Classification = 485 and Country = 89

View and edit SQL

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

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
191217 1977.220.7 0 0 310293 Arts of Africa, Oceania, and the Americas 10 Figure 9 Figure: Female (Akua Ba) Asante 4586                           19th–20th century 1800 2000 Wood 25 H x W: 15 3/8 x 6in. (39.1 x 15.2cm) Gift of Mr. and Mrs. Alan Bresler, Mr. and Mrs. Robert Bevill, Mr. and Mrs. Dale Ledbetter, and Mr. and Mrs. Gilbert Schulman, 1977         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
191758 1978.412.671 0 0 310882 Arts of Africa, Oceania, and the Americas 10 Mother and child figure 13218 Figure: Mother and Child Akan peoples 4592                           19th–20th century 1800 2000 Wood, kaolin, black pigment, beads, string 26898 H. 15 7/8 x W. 5 1/2 x D. 4 1/4 in. (40.3 x 14 x 10.8 cm) The Michael C. Rockefeller Memorial Collection, The Diana Woolman Memorial Collection, 1973         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
191812 1978.412.480 0 0 310941 Arts of Africa, Oceania, and the Americas 10 Female figure 11801 Figure: Female (Akua Ba) Asante 4586                           19th–20th century 1800 2000 Wood, beads, fiber 26908 H. 12-3/4 in. (32.4 cm) The Michael C. Rockefeller Memorial Collection, Gift of William W. Brill, 1963         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
191988 1978.412.686 0 0 311133 Arts of Africa, Oceania, and the Americas 10 Female figure 11801 Figure: Female Akan peoples 4592                           19th–20th century 1800 2000 Wood, pigment 4880 H. 16 1/4 x W. 4 x D. 2 1/4 in. (41.3 x 10.2 x 5.7 cm) The Michael C. Rockefeller Memorial Collection, The Diana Woolman Memorial Collection, 1973         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
193108 1979.206.75 0 0 312279 Arts of Africa, Oceania, and the Americas 10 Figure 9 Fertility Figure: Female (Akua Ba) Asante 4586                           19th–20th century 1800 2000 Wood, beads, string 27214 H. 10 11/16 x W. 3 13/16 x D. 1 9/16 in. (27.2 x 9.7 x 3.9 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
194890 1980.429 0 0 314225 Arts of Africa, Oceania, and the Americas 10 Male figure 13132 Figure: Seated Male With Sword Asante 4586                           19th–20th century 1800 2000 Wood, kaolin 26706 H. 19 x W. 7 1/8 x D. 8 in. (48.3 x 18.1 x 20.3 cm) Gift of Dr. and Mrs. Melvin A. Scharfman in memory of Dr. Milton Gross, 1980         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
195214 1982.393.3 0 0 314550 Arts of Africa, Oceania, and the Americas 10 Figure 9 Female Figure Nafana peoples 5145                           19th–mid-20th century 1800 1967 Wood, pigment 4880 H x W: 13 1/8 x 3 1/4in. (33.3 x 8.3cm) Gift of Mr. and Mrs. J. Gordon Douglas III, 1982         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
195459 1984.514.1 0 0 314795 Arts of Africa, Oceania, and the Americas 10 Figure 9 Figure: Female (Akua Ba) Fante peoples 5175                           19th–20th century 1800 2000 Wood, glass beads 26862 H x W x D: 11 3/4 x 1 3/4 x 1 1/2in. (29.8 x 4.5 x 3.8cm) Gift of Mr. and Mrs. J. Gordon Douglas III, 1984         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
196509 1987.446.3 0 0 315851 Arts of Africa, Oceania, and the Americas 10 Figure 9 Figure: Female (Akua Ba) Asante 4586                           19th–20th century 1800 2000 Wood, beads 26709 H x W x D: 10 7/8 x 3 1/2 x 1 1/2in. (27.6 x 8.9 x 3.8cm) Gift of Mr. and Mrs. J. Gordon Douglas III, 1987         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
196510 1987.446.4 0 0 315852 Arts of Africa, Oceania, and the Americas 10 Figure 9 Figure: Female (Akua Ba) Asante 4586                           19th–20th century 1800 2000 Wood, beads 26709 H x W x D: 8 7/8 x 2 7/8 x 1 1/8in. (22.5 x 7.3 x 2.8cm) Gift of Mr. and Mrs. J. Gordon Douglas III, 1987         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
196545 1987.452.2a-c 0 0 315887 Arts of Africa, Oceania, and the Americas 10 Staff 651 Staff of Office (ȯkyeame poma) Akan peoples, Asante 4583                           ca. 1930s 1930 1940 Wood, gold foil 27805 H. 63 7/8 x W. 4 3/8 x D. 3 5/8 in. (162.2 x 11.1 x 9.2 cm) Gift of Drs. Herbert F. and Teruko S. Neuwalder, 1987         Ghana 89             Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
198505 1997.449.1 0 0 317870 Arts of Africa, Oceania, and the Americas 10 Figure 9 Figure: Equestrian Fante peoples 5175                           20th century 1900 2000 Wood, pigment 4880 Height 20 in. Gift of Herbert F. and Teruko S. Neuwalder, 1997         Ghana 89             Wood-Sculpture 485   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.467ms · Data license: CC0 · Data source: metmuseum/openaccess