MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Region = 112

View and edit SQL

Suggested facets: Is Highlight, Department, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, County, Classification

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
191995 1978.412.706 0 0 311152 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th–early 20th century 1800 2000 Wood, paint, shell 26732 H. 98 x W. 22 x D. 12 in. (248.9 x 55.9 x 30.5 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1955       New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192000 1978.412.712 0 0 311158 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th–early 20th century 1800 2000 Wood, paint, fiber 26991 H. 108 in. (274.3 cm) The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1972       New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192006 1978.412.718 0 0 311164 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th–early 20th century 1800 2000 Wood, paint, shell, fiber 26994 H. 43 x W. 9 x D. 10 in. (109.2 x 22.9 x 25.4 cm) The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1972       New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192012 1978.412.724 0 0 311170 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th century 1800 1900 Wood, paint, shell 26732 H. 84 1/2 x W. 10 11/16 x D. 2 15/16 in. (214.6 x 27.1 x 7.5 cm) The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1972   Tubar village 794   New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192038 1978.412.754 0 0 311196 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Figure (Kulap) Southern New Ireland 4798                           late 19th–early 20th century 1800 2000 Chalk, paint 27010 H. 9 x W. 3 1/4 x D. 3 1/2 in. (22.9 x 8.3 x 8.9 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1960   Namatanai village 798     Papua New Guinea 143 New Ireland 112           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
192768 1978.412.1494a-f 0 0 311934 Arts of Africa, Oceania, and the Americas 10 Funerary carving 13334 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th–early 20th century 1800 2000 Wood, paint, shell, beads 27148 H. 110 1/2 x W. 34 1/2 x D. 10 1/2 in. (280.7 x 87.6 x 26.7 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1972       New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192794 1978.412.1525 0 0 311961 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Figure (Kulap) Southern New Ireland 4798                           late 19th–early 20th century 1800 2000 Chalk, paint 27010 H. 26 3/8 x W. 6 1/2 x D. 6 in. (67 x 16.5 x 15.2 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1967   Namatanai village 798   New Ireland 401 Papua New Guinea 143 New Ireland 112           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
192801 1978.412.1533 0 0 311969 Arts of Africa, Oceania, and the Americas 10 Skull 8540 Overmodeled Skull Southern New Ireland 4798                           late 19th–early 20th century 1800 2000 Human skull, fiber, shell, clay, paint 27158 H. 7 3/4 x W. 5 3/4 x D. 10 15/16 in. (19.7 x 14.6 x 27.7 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1968       New Ireland 401 Papua New Guinea 143 New Ireland 112           Bone/Ivory-Sculpture 506   Metropolitan Museum of Art, New York, NY 1
194357 1979.206.1473 0 0 313661 Arts of Africa, Oceania, and the Americas 10 Pendant 1129 Pendant or Head Ornament (Kapkap) New Ireland 5033                           late 19th–early 20th century 1800 2000 Tridacna shell, turtle shell, fiber 27419 H. 5 1/4 x W. 1/2 in. (13.3 x 1.3 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       New Ireland 401 Papua New Guinea 143 New Ireland 112           Shell-Ornaments 531   Metropolitan Museum of Art, New York, NY 1
194358 1979.206.1474 0 0 313662 Arts of Africa, Oceania, and the Americas 10 Carving 4561 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th–early 20th century 1800 2000 Wood, paint, shell, fiber 26994 H. 34 x W. 5 x D. 11 in. (86.4 x 12.7 x 27.9 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
195035 1981.331.5 1 0 314370 Arts of Africa, Oceania, and the Americas 10 Figure 9 Funerary Figure (Kulap) Southern New Ireland 4798                           late 19th century 1875 1899 Chalk, paint 27010 H. 19 1/4 in. (48.9 cm) Gift of Evelyn A. J. Hall, 1981         Papua New Guinea 143 New Ireland 112           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
199752 2007.215.1 0 0 319852 Arts of Africa, Oceania, and the Americas 10 Mask 1441 Mask (Tatanua) Northern New Ireland 4772                           late 19th–early 20th century 1850 1950 Wood, fiber, barkcloth, paint, shell 28309 H. 19 x W. 15 x D. 9 1/4 in. (48.3 x 38.1 x 23.5 cm) Gift of Muriel Kallis Newman, 2007       New Ireland 401 Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
199753 2007.215.2 0 0 319853 Arts of Africa, Oceania, and the Americas 10 Funerary carving 13334 Funerary Carving (Malagan) Northern New Ireland 4772                           late 19th–early 20th century 1850 1950 Wood, paint, shell, resin 27457 H. 52 1/4 x W. 13 3/4 x D. 13 1/4 in. (132.7 x 34.9 x 33.7 cm) Gift of Muriel Kallis Newman, 2007         Papua New Guinea 143 New Ireland 112           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
347311 89.4.1404 0 0 501970 Musical Instruments 18 Panpipes 15862 Panpipes Papua New Guinean (New Ireland) 6407                           late 19th century 1850 1900 bamboo 17550 Longest pipe 8 in., Shortest 4 in. (L.C. says, "longest pipe 7-3/4 in.") The Crosby Brown Collection of Musical Instruments, 1889       Bismarck Archipelago 930 Papua New Guinea 143 New Ireland 112           Aerophone-Blow Hole-panpipe 944   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 122.071ms · Data license: CC0 · Data source: metmuseum/openaccess