MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Medium = 11 and Object End Date = 2000

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	River	Classification	Link Resource	Metadata Date	Repository
191234	191234	1977.394.1	310311	Arts of Africa, Oceania, and the Americas 10	Bracelet 119	Bracelet: Seated Figure (Dyongou Serou)	Dogon peoples 4505	19th–20th century	1800	2000	Brass, iron 11	H. 1 5/8 x W. 3 5/8 x D. 4 1/4 in. (4.1 x 9.2 x 10.8 cm)	Gift of Lester Wunderman, 1977		Mali 157		Metal-Ornaments 275	http://www.metmuseum.org/art/collection/search/310311	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
195044	195044	1981.404	314379	Arts of Africa, Oceania, and the Americas 10	Sword 379	Sword: Figurative Handle (Idà)	Yoruba peoples 4470	19th–20th century	1800	2000	Brass, iron 11	H x W: 2 5/8 x 20 7/8in. (6.7 x 53cm)	Gift of Dr. and Mrs. Wayne A. Myers, 1981		Nigeria 83		Metal-Implements 481	http://www.metmuseum.org/art/collection/search/314379	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
195247	195247	1982.485.21a, b	314583	Arts of Africa, Oceania, and the Americas 10	Knife and sheath 13291	Knife and Sheath	Jukun peoples 5154	19th–20th century	1800	2000	Brass, iron 11	H x W: 6 5/8 x 16 7/8in. (16.8 x 42.9cm)	The Bryce Holcombe Collection of African Decorative Art, Gift of Bryce Holcombe, 1982		Nigeria 83	Benue River Valley region 36	Metal-Implements 481	http://www.metmuseum.org/art/collection/search/314583	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
197120	197120	1991.17.6	316479	Arts of Africa, Oceania, and the Americas 10	Head 3965	Head of an Oba	Edo peoples 4409	20th century	1900	2000	Brass, iron 11	Height 13-3/4 in.	Gift of Mr. and Mrs. Klaus G. Perls, 1991	Court of Benin 725	Nigeria 83		Metal-Sculpture 480	http://www.metmuseum.org/art/collection/search/316479	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
197197	197197	1991.17.87	316557	Arts of Africa, Oceania, and the Americas 10	Bell 64	Altar Bell: Figure with Sword	Edo peoples 4409	19th–20th century	1800	2000	Brass, iron 11	H. 7 1/2 x W. 3 3/4 x D. 3 3/4 in. (19.1 x 9.5 x 9.5 cm) Other: W. 3 3/4 x D. 3 3/4 in. (9.5 x 9.5 cm)	Gift of Mr. and Mrs. Klaus G. Perls, 1991	Court of Benin 725	Nigeria 83		Metal-Musical Instruments 507	http://www.metmuseum.org/art/collection/search/316557	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
197248	197248	1991.17.140	316608	Arts of Africa, Oceania, and the Americas 10	Bell 64	Bell: Horse Head	Lower Niger Bronze Industry 4603	19th–20th century	1800	2000	Brass, iron 11	H x Diam.: 5 1/8 x 3 5/8 in. (13 x 9.2 cm)	Gift of Mr. and Mrs. Klaus G. Perls, 1991		Nigeria 83	Lower Niger River region 47	Metal-Musical Instruments 507	http://www.metmuseum.org/art/collection/search/316608	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");