MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

113 rows where Country = 2 sorted by Title

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
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
195182 1982.207.1 0 1 314518 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Tetrapod Bowl Maya 4341                           1st–4th century 1 400 Ceramic 161 H. 5 1/2 in. (14 cm) Gift of Arthur M. Bullowa, 1982         Guatemala 2 Mesoamerica 34           Ceramics-Containers 483   Metropolitan Museum of Art, New York, NY 1
409116 2015.722.2 0 0 670161 Arts of Africa, Oceania, and the Americas 10 Cover 276 Tortilla Cover Tzutihil Maya 6939                           20th century 1900 2000 Cotton 2154 H. 34 × W. 23 in. (86.4 × 58.4 cm) Gift of Alfred L. Bush, 2015         Guatemala 2             Textiles 16   Metropolitan Museum of Art, New York, NY 1
409117 2015.722.3 0 0 670163 Arts of Africa, Oceania, and the Americas 10 Cover 276 Tortilla Cover Tzutihil Maya 6939                           20th century 1900 2000 Cotton 2154 H. 42 × W. 17 1/2 in. (106.7 × 44.5 cm) Gift of Alfred L. Bush, 2015         Guatemala 2             Textiles 16   Metropolitan Museum of Art, New York, NY 1
409118 2015.722.4 0 0 670165 Arts of Africa, Oceania, and the Americas 10 Cover 276 Tortilla Cover Tzutihil Maya 6939                           20th century 1900 2000 Cotton 2154 H. 26 1/4 × W. 25 in. (66.7 × 63.5 cm) Gift of Alfred L. Bush, 2015         Guatemala 2             Textiles 16   Metropolitan Museum of Art, New York, NY 1
195491 1984.614a, b 0 1 314827 Arts of Africa, Oceania, and the Americas 10 Bowl with lid 4747 Tripod Bird Bowl Maya 4341                           3rd–4th century 200 400 Ceramic 161 H. 9 3/4 x W. 7 3/8in. (24.8 x 18.7cm) Gift of Carolyn C. and Dan C. Williams, 1984         Guatemala 2 Mesoamerica 34           Ceramics-Containers 483   Metropolitan Museum of Art, New York, NY 1
199940 46.143.3 0 0 320610 Arts of Africa, Oceania, and the Americas 10 Cloth 1155 Tzut Guatemala 1619                           20th century 1900 2000 Cotton, silk 2163 H. 27 1/2 x W. 27 in. (69.9 x 68.6 cm) Gift of Mrs. Charles V. Riley in memory of her daughter, Mary G. Riley, 1946         Guatemala 2 Mesoamerica 34           Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
199943 46.143.6 0 0 320613 Arts of Africa, Oceania, and the Americas 10 Cloth 1155 Tzut Guatemala 1619                           20th century 1900 2000 Cotton, silk 2163   Gift of Mrs. Charles V. Riley in memory of her daughter, Mary G. Riley, 1946         Guatemala 2 Mesoamerica 34           Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
434299 GK.235 0 0 722087 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Vessel with Palace Scene Maya 4341                           A.D. 600–800 600 800 Ceramic, pigment  26769 H. 11 1/4 × Diam. 6 in. (28.5 × 15.2 cm) Denver Art Museum Collection: Funds from various donors, Volunteer Endowment Fund, and department acquisition funds (2003.1)         Guatemala 2             Sculpture-Vessels 860   Metropolitan Museum of Art, New York, NY 1
191279 1978.412.206 1 1 310364 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Vessel, Mythological Scene Maya 4341                           7th–8th century 600 800 Ceramic 161 H. 5 1/2 x Diam. 4 1/2 in. (14 x 11.4 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1968         Guatemala 2 Mesoamerica 34           Ceramics-Containers 483   Metropolitan Museum of Art, New York, NY 1
191506 1978.412.159 0 1 310607 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Vessel, Seated Deities Maya 4341                           6th–7th century 500 700 Ceramic 161 H. 8 3/4 x Diam. 7 1/2 in. (22.2 x 19.1 cm) Diameter: 7 1/2in. (19.1cm) The Michael C. Rockefeller Memorial Collection, Purchase, Mrs. Gertrud A. Mellon Gift, 1967         Guatemala 2 Mesoamerica 34           Ceramics-Containers 483   Metropolitan Museum of Art, New York, NY 1
199188 1999.484.2 0 1 318662 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Vessel, Throne Scene Maya 4341                           late 7th–8th century 650 825 Ceramic, pigment 26566 H. 8 1/2 in. (21.6 cm) Gift of Charles and Valerie Diker, 1999         Guatemala 2 Mesoamerica 34           Ceramics-Containers 483   Metropolitan Museum of Art, New York, NY 1
190660 1970.138a, b 0 1 309713 Arts of Africa, Oceania, and the Americas 10 Vessel with lid 3938 Yoke-Form Vessel Maya 4341                           mid-4th–mid-5th century 350 450 Ceramic 161 H. 11 x W. 8 1/4 in. (27.9 x 21 cm) Purchase, Mrs. Charles S. Payson Gift, 1970         Guatemala 2 Mesoamerica 34           Ceramics-Containers 483   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 2502.674ms · Data license: CC0 · Data source: metmuseum/openaccess