MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Country = 1065, Department = 10 and State = 96

View and edit SQL

Suggested facets: Object Name, Culture, Object Date, Object Begin Date, Object End Date, Medium, 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
434356 GK.252 0 0 722163 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Bar Pendant Engraved with Glyphs and Figure Maya 4341                           A.D. 690–725 690 725 Jadeite  61456 H. 16 1/8 × W. 16 1/8 in. (41 × 41 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Peabody Museum Expedition 1907–1910 (10-71-20/ C6318, 10-71-20/C6331, 10-71-20/C6170, 10-71-20/C6200, 10-71-20/C6212, 10-71-20/C6216, 10-71-20/C6269, 10-71-20/C6275, 10-71-20/C6153.1, 10-71-20/C6155, 10-71-20/C6168, 10-71-20/C6335.1, 10-71-20/C6342.1); Museum Purchase, 1919 (19-37-20/C9258.1, 19-37-20/C9257.1, 19-37-20/ C6263); Gift of Charles Peabody, 1910 (10-56-20/C5969.1, 10-56-20/ C5970); Gift of C. P. Bowditch, 1910 (10-70-20/C6048.1, 10-70-20/C6064)     | 96   Mexico|Mexico 1065 Yucatan|Chiapas 750           Stone-Ornaments 491   Metropolitan Museum of Art, New York, NY 1
434361 GK.257 0 0 722168 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Finger Ring Mixtec (Ñudzavui) 6999                           A.D. 1350–1521 1350 1521 Copper 549 H. 1 × W. 1 × D. 1 1/8 in. (2.5 × 2.6 × 2.9 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Gift of Charles Peabody, 1910 (10-56-20/C5982)     | 96   Mexico|Mexico 1065 Yucatan|Oaxaca 751           Metalwork-Jewelry 365   Metropolitan Museum of Art, New York, NY 1
434493 GK.103 0 0 722344 Arts of Africa, Oceania, and the Americas 10 Mask 1441 Mask Olmec style 7069                           ca. 800 B.C. (fabrication); A.D. 1469–1481 (deposition) -795 1481 Hornblende hornfels 61504 H. 4 1/4 × W. 3 3/8 × D. 1 1/4 in. (10.8 × 8.6 × 3.2 cm) Museo del Templo Mayor, Secretaría de Cultura-INAH, Mexico City (10-168803)     | 96   Mexico|Mexico 1065 Guerrero|Tenochtitlan (Mexico City) 770           Stone Sculpture|Masks 1155   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
452553 GK.154a-f 0 0 760364 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Eagle Warrior Head Ornaments Mixtec (Ñudzavui) 6999                           ca. A.D. 1500 1500 1500 Gold 1 H. 1 13/16 × W. 9/16 × D. 7/16 in. (4.6 × 1.4 × 1.2 cm) Museo Baluarte de Santiago, Secretaría de Cultura-INAH, Veracruz (10-213090–95)     | 96   Mexico|Mexico 1065 Oaxaca|Veracruz 771           Metalwork-Gold 512   Metropolitan Museum of Art, New York, NY 1
452554 GK.155a-f 0 0 760365 Arts of Africa, Oceania, and the Americas 10 Bead 3950 Beads with Serpent and Eagle Imagery Mixtec (Ñudzavui) 6999                           ca. A.D. 1500 1500 1500 Gold 1 Diam. 3/8 in. (0.9 cm) Museo Baluarte de Santiago, Secretaría de Cultura-INAH, Veracruz (10-213108 0/6)     | 96   Mexico|Mexico 1065 Veracruz|Oaxaca 786           Metalwork-Jewelry|Metalwork-Ornaments 1191   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 138.348ms · Data license: CC0 · Data source: metmuseum/openaccess