MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Country = 143 and County = 422

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Region, Classification

County

  • Milne Bay Province · 16
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
191997 1978.412.709 0 0 311155 Arts of Africa, Oceania, and the Americas 10 Canoe prow ornament 13205 Canoe Prow Ornament (Taburi) Massim region 4773                           19th–early 20th century 1800 2000 Wood, paint 4879 H. 47 in. (119.4 cm) The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1972       Milne Bay Province 422 Papua New Guinea 143 Massim region 113           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192026 1978.412.742 0 0 311184 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Massim people 4792                           late 19th–early 20th century 1800 2000 Bamboo 3967 H. 12 5/8 x Diam. 2 1/2 in. (32.1 x 6.4 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1960       Milne Bay Province 422 Papua New Guinea 143           Cloudy Bay (?) 88 Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
192067 1978.412.784 0 0 311225 Arts of Africa, Oceania, and the Americas 10 Canoe splashboard 13298 Canoe Splashboard (lagim) Massim people 4792                           19th–early 20th century 1800 1930 Wood, paint 4879 H. 11 1/4 x W. 15 1/4 x D. 1 1/2 in. (28.6 x 38.7 x 3.8 cm) The Michael C. Rockefeller Memorial Collection, Gift of Dr. and Mrs. Werner Muensterberger, 1961   Bwebwaija 804   Milne Bay Province 422 Papua New Guinea 143 Duau (Normanby) Island 129           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
192149 1978.412.838 0 0 311308 Arts of Africa, Oceania, and the Americas 10 Paddle 13235 Paddle Massim people 4792                           late 19th–early 20th century 1800 2000 Wood 25 H. 70 x W. 5 3/8 x D. 2 5/8 in. (177.8 x 13.6 x 6.7 cm) The Michael C. Rockefeller Memorial Collection, Gift of Mr. and Mrs. John J. Klejman, 1964       Milne Bay Province 422 Papua New Guinea 143 Trobriand Island 139           Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
192766 1978.412.1492 0 0 311932 Arts of Africa, Oceania, and the Americas 10 Charm 13248 Canoe Prow Charm (Munkuris) Massim region 4773                           late 19th–early 20th century 1800 2000 Wood, paint 4879 H. 18 5/8 in. (47.3 cm) The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1969       Milne Bay Province 422 Papua New Guinea 143 Massim region 113           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
194350 1979.206.1464 0 0 313652 Arts of Africa, Oceania, and the Americas 10 Lime spatula 4923 Lime Spatula/Currency Holder (Gabaela or 'Nga) Massim region 4773                           19th–early 20th century 1800 2000 Turtle shell 27011 H. 11 1/4 x W. 6 1/4 x D. 1/8 in. (28.6 x 15.9 x 0.3 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       Milne Bay Province 422 Papua New Guinea 143 Massim region 113           Shell-Implements 525   Metropolitan Museum of Art, New York, NY 1
194425 1979.206.1544 0 0 313733 Arts of Africa, Oceania, and the Americas 10 Lime Spatula 13409 Lime Spatula Massim people 4792                           late 19th–early 20th century 1800 2000 Wood, traces of lime 27438 H. 5/8 x W. 15 in. (1.6 x 38.1 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979   Domara 917   Milne Bay Province 422 Papua New Guinea 143           Cloudy Bay (?) 88 Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
194464 1979.206.1553 0 0 313772 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Massim people 4792                           mid to late 19th century 1800 2000 Wood, lime 27163 H. 2 3/4 x W. 98 1/2 in. (7 x 250.2 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       Milne Bay Province 422 Papua New Guinea 143 Trobriand Island 139           Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
194570 1979.206.1670a, b 0 0 313889 Arts of Africa, Oceania, and the Americas 10 Mortar 4468 Betel Nut Mortar and Pestle Massim people 4792                           late 19th–early 20th century 1800 2000 Wood, traces of lime 27438 H. 12 3/4 x W. 1 9/16 in. (32.4 x 4 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       Milne Bay Province 422 Papua New Guinea 143             Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
194658 1979.206.1768 0 0 313982 Arts of Africa, Oceania, and the Americas 10 Drum 2181 Drum Massim people 4792                           early to mid-20th century 1800 2000 Wood, lizard skin, fiber, lime 27488 H.11 1/2 x W. 3 in. (29.2 x 7.6 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       Milne Bay Province 422 Papua New Guinea 143 Massim region 113           Wood-Musical Instruments 519   Metropolitan Museum of Art, New York, NY 1
194659 1979.206.1769 0 0 313983 Arts of Africa, Oceania, and the Americas 10 Lime spatula 4923 Lime Spatula Massim people 4792                           late 19th–early 20th century 1800 2000 Wood, lime 27163 H. 9/16 x W. 15 3/4 in. (1.5 x 40 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       Milne Bay Province 422 Papua New Guinea 143             Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
194660 1979.206.1770 0 0 313984 Arts of Africa, Oceania, and the Americas 10 Lime spatula 4923 Lime Spatula Massim people 4792                           late 19th–early 20th century 1800 2000 Wood, lime 27163 H. 3/4 x W. 29 1/4 in. (1.9 x 74.3 cm) The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979       Milne Bay Province 422 Papua New Guinea 143             Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
198394 1995.481.11 0 0 317758 Arts of Africa, Oceania, and the Americas 10 Figure 9 Figure (Tokwalu [/]) Massim people 4792                           early to mid-20th century 1900 2000 Wood 25 Height 12-3/4 in. Gift of Louise Reinhardt Smith, 1995       Milne Bay Province 422 Papua New Guinea 143 Trobriand Island 139           Wood-Sculpture 485   Metropolitan Museum of Art, New York, NY 1
199317 2013.1137.21 0 0 318931 Arts of Africa, Oceania, and the Americas 10 Staff 651 Staff Finial New Guinea, Massim region 5464                           Late19th–early 20th century 1850 1950 Wood, traces of lime 27438 H. 15 in. (38.1 cm) Gift of Fred and Rita Richman, 2013       Milne Bay Province 422 Papua New Guinea 143 Trobriands 286           Wood-Implements 484   Metropolitan Museum of Art, New York, NY 1
199748 2009.502.9 0 0 319841 Arts of Africa, Oceania, and the Americas 10 Canoe splashboard 13298 Canoe Splashboard (lagim) Massim people 4792                           early to mid-20th century 1900 1980 Wood, paint 4879 H. 24 x W. 24 x D. 3 in. (61 x 61 x 7.6 cm) Gift of Cary Schneebaum, Jeff Schneebaum, and Randy Slakter, from the Tobias Schneebaum Collection, 2009       Milne Bay Province 422 Papua New Guinea 143 Trobriand Islands 296           Wood-Ornaments 509   Metropolitan Museum of Art, New York, NY 1
199830 2008.571 0 1 320339 Arts of Africa, Oceania, and the Americas 10 Lime spatula 4923 Lime Spatula Massim 5604         Artist 2   Mutuaga 1860–1920   Mutuaga 17266   1860 1920 1900–1910 1900 1910 Wood, lime 27163 H. 24 1/2 in. (62.2 cm) Gift of Dr. Oliver E. and Pamela F. Cobb, 2008       Milne Bay Province 422 Papua New Guinea 143 Suau region 297           Wood-Implements 484   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 222.337ms · Data license: CC0 · Data source: metmuseum/openaccess