MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

113 rows where Country = 2 sorted by Medium

View and edit SQL

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
346646 89.4.664 0 0 501280 Musical Instruments 18 Drum 2181 Drum Guatemalan 42                           1850–1900 (?) 1850 1900 Wood, skin, fiber cord. 54227 L. 25.5 cm, Diam. at widest 17.5 cm, Diam. of heads 14.5 cm. The Crosby Brown Collection of Musical Instruments, 1889         Guatemala 2             Membranophone-double-headed / cylindrical drum 943   Metropolitan Museum of Art, New York, NY 1
346647 89.4.665a, b 0 0 501281 Musical Instruments 18 Coc 15842 Coc Guatemalan 42                           19th century 1801 1900 Turtle Shell 54228 Overall: 25.4 x 34.3cm (10 x 13 1/2in.) The Crosby Brown Collection of Musical Instruments, 1889         Guatemala 2             Idiophone-Struck-vessel 979   Metropolitan Museum of Art, New York, NY 1
346648 89.4.666 0 0 501282 Musical Instruments 18 Marimba de Tecomates 15843 Marimba Guatemalan 42                           late 19th century 1850 1900 Wood, bamboo, cloth, hide 54229 30 × 18 × 82 in. (76.2 × 45.7 × 208.3 cm) The Crosby Brown Collection of Musical Instruments, 1889         Guatemala 2             Idiophone-Struck-bar-wood 948   Metropolitan Museum of Art, New York, NY 1
346657 89.4.675 0 0 501291 Musical Instruments 18 Flute 5809 Flute Guatemalan 42                           19th century 1801 1900 cane, pitch/resin? 54232 Diam. 2.6 x L. 43.6cm (1 x 17 3/16in.) Other (L.C. Says:): 18.4cm (7 1/4in.) The Crosby Brown Collection of Musical Instruments, 1889         Guatemala 2             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
346658 89.4.676 0 0 501292 Musical Instruments 18 Flute 5809 Flute Guatemalan 42                           19th century 1801 1900 cane, resin or pitch 54233 Diam. 1.2 x L. 18.5cm (1/2 x 7 5/16in.) The Crosby Brown Collection of Musical Instruments, 1889         Guatemala 2             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
349027 89.4.3143 0 0 503755 Musical Instruments 18 Harp 1196 Harp Guatemalan 42                           late 19th century 1870 1910 String, wood 55023 Overall: 99.1 x 48.3cm (39 x 19in.) The Crosby Brown Collection of Musical Instruments, 1889         Guatemala 2             Chordophone-Harp 967   Metropolitan Museum of Art, New York, NY 1
414339 2015.226a, b 0 0 684338 Arts of Africa, Oceania, and the Americas 10 Figure 9 Teotihuacan-Style Hollow Figurine with Removable Chest Plate Escuintla 6957                           5th–7th century 400 699 Ceramic, pyrite, pigment 59786 H. 14 3/4 x W. 10 5/8 in. (37.5 x 27 cm) Partial and Promised Gift of Linda M. Lindenbaum, from the Collection of Samuel H. and Linda M. Lindenbaum, 2015         Guatemala 2 Tiquisate region 727           Ceramics-Sculpture 490   Metropolitan Museum of Art, New York, NY 1
434375 GK.274 0 0 722182 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Earflare Disk Maya 4341                           A.D. 300–400 300 400 Shell, red pigment, traces of resin 61477 H. 1 7/8 × W. 1/8 in. (4.8 × 0.3 cm) Peabody Museum of Archaeology and Ethnology, Harvard University, Peabody Museum Expedition, 1911 (11-6-20/C5619)         Guatemala 2             Shell-Ornaments 531   Metropolitan Museum of Art, New York, NY 1
434421 GK.305 0 0 722258 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Cylinder Vessel with Palace Scene Maya 4341                           A.D. 600–800 600 800 Ceramic. pigment 61487 H. 28 × Diam. 14.6 cm (11 × 5 3/4 in.) Princeton University Art Museum, Gift of Mary O’Boyle English in honor of Woodruff J. English and the Class of 1931 (y1986-91)         Guatemala 2             Ceramics-Vessels 504   Metropolitan Museum of Art, New York, NY 1
434424 GK.341 0 0 722263 Arts of Africa, Oceania, and the Americas 10 Horn 6840 Conch Trumpet Maya 4341                           A.D. 250-–400 250 400 Shell, cinnabar 61488 11 9/16 × 5 1/4 in. (29.3 × 13.4 cm) Kimbell Art Museum, Fort Worth, Texas (AP 1984.11)         Guatemala 2 Northeastern Petén 761           Shell-Musical Instruments 566   Metropolitan Museum of Art, New York, NY 1
434475 GK.056 0 0 722319 Arts of Africa, Oceania, and the Americas 10 Jewelry 4546 Mosaic of God of Death Maya 4341                           A.D. 600–800 600 800 Mother-of-pearl, jadeite 61496 H. 6 1/4 × W. 4 3/16 in. (15.8 × 10.7 cm) Museo Nacional de Arqueología y Etnología, Guatemala City (17.7.21.210b)         Guatemala 2 Petén 768           Shell-Ornaments|Stone 1151   Metropolitan Museum of Art, New York, NY 1
434476 GK.057 0 0 722320 Arts of Africa, Oceania, and the Americas 10 Mosaic 8485 Mosaic of Bird Maya 4341                           A.D. 600–800 600 800 Mother-of-pearl, Spondylus shell 61497 H. 6 1/4 × W. 4 3/16 in. (15.8 × 10.7 cm) Museo Nacional de Arqueología y Etnología, Guatemala City (17.7.21.210a)         Guatemala 2 Petén 768           Shell-Ornaments|Jewelry 1149   Metropolitan Museum of Art, New York, NY 1
434479 GK.060a, b 0 0 722323 Arts of Africa, Oceania, and the Americas 10 Ornament 656 Pair of Mosaic Ornaments Maya 4341                           A.D. 600–650 600 650 Shell, jadeite, turquoise, pyrite, cinnabar 61498 H: 15/16 × W:15/16 × D:1/8 in. (2.4 × 2.4 × 0.3 cm) (a) H: 15/16 x W: 13/16 x D: 1/8 in. (2.4 x 2.1 x 0.3 cm) (b) Museo Nacional de Arqueología y Etnología, Guatemala City (17.7.62.159a–b)         Guatemala 2             Shell-Ornaments|Stone-Ornaments 1152   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 49.5ms · Data license: CC0 · Data source: metmuseum/openaccess