MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Classification = 1128, Department = 10 and State = 96

View and edit SQL

Suggested facets: Culture, Object Date, Object Begin Date, Object End Date, Medium, Country, Region

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
434348 GK.244 0 0 722155 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Frog Pendant Veraguas-Chiriquí 7052                           A.D. 900–1521 900 1521 Gold  27366 H. 2 x W. 1 3/16 × D. 11/16 in. (5.1 × 3 × 1.8 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Peabody Museum Expedition, 1907–1910 (10-71-20/C7710.3)     | 96   Mexico|Costa Rica or Panama 1063 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434355 GK.251 0 0 722162 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Monkey Bell Veraguas-Chiriquí 7052                           A.D. 900–1521 900 1521 Gold  27366 H. 1 9/16 × W. 1 7/16 × D. 3/4 in. (3.9 × 3.6 × 1.9 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Gift of C. P. Bowditch and Charles Peabody, 1910 (10-73-20/C7734)     | 96   Costa Rica or Panama|Mexico 1064 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434360 GK.256 0 0 722167 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Peccary Bell Veraguas-Chiriquí 7052                           A.D. 900–1521 900 1521 Gold  27366 H. 1 × W. 1/2 × D. 9/16 in. (2.5 × 1.2 × 1.5 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Peabody Museum Expedition, 1907–1910 (10-71-20/C7668)     | 96   Mexico|Costa Rica or Panama 1063 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434363 GK.259 0 0 722170 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Bell with Owl at Top Veraguas-Chiriquí 7052                           A.D. 900–1521 900 1521 Gold  27366 H. 1 13/16 × W. 1 × D. 3/16 in. (4.6 × 2.5 × 0.5 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Gift of C. P. Bowditch and Charles Peabody, 1910 (10-73-20/C7727)     | 96   Costa Rica or Panama|Mexico 1064 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434364 GK.260 0 0 722171 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Bell with Bird at Top Veraguas-Chiriquí 7052                           A.D. 900–1521 900 1521 Gold  27366 H. 1 5/8 × W. 13/16 × D. 9/16 in. (4.1 × 2.1 × 1.5 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Gift of C. P. Bowditch and Charles Peabody, 1910 (10-73-20/C7729)     | 96   Costa Rica or Panama|Mexico 1064 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434365 GK.261 0 0 722172 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Pendant Darien Style 7054                           A.D. 500–900 500 900 Gold  61474 H. 3 3/4 × W. 2 11/16 × D. 9/16 in. (9.5 × 6.9 × 1.5 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Gift of C. P. Bowditch and Charles Peabody, 1910 (10-73-20/C7725)     | 96   Mexico|Probably Costa Rica 1067 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434399 GK.300 0 0 722208 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Turtle Pendant Veraguas-Chiriquí 7052                           A.D. 900–1521 900 1521 Gold  61474 H. 1 1/4 × W. 15/16 × D. 3/8 in. (3.1 × 2.4 × 1 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Peabody Museum Expedition, 1907–1910 (10-71-20/C7711A)     | 96   Costa Rica or Panama|Mexico 1064 Yucatan 748           Metalwork-Ornaments|Gold 1128   Metropolitan Museum of Art, New York, NY 1
434503 GK.153 0 0 722361 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Shield Pendant with Darts Mixtec (Ñudzavui) 6999                           ca. A.D. 1500 1500 1500 Gold 1 H. 4 × W. 3 1/4 × D. 3/8 in. (10.2 × 8.3 × 1 cm) Museo Baluarte de Santiago, Secretaría de Cultura-INAH, Veracruz (10-213084)     | 96   Mexico|Mexico 1065 Oaxaca|Veracruz 771           Metalwork-Ornaments|Gold 1128   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 1169.171ms · Data license: CC0 · Data source: metmuseum/openaccess