MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Classification = 484 and Object Begin Date = 1850

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Object Date, Object End Date, Medium, Credit Line, Country

Object Begin Date ✖

  • 1850 · 8 ✖
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 Metadata Date Repository
188552 188552 89.4.797 0 1 307481 Arts of Africa, Oceania, and the Americas 10 Pipe 338 Pipe Central Province or Massim people 4353                           mid to late 19th century 1850 1900 Bamboo 3967 Overall: 31 1/8 x 2 1/16 in. (79.06 x 5.24 cm) Other: 2 1/16 in. (5.24 cm) The Crosby Brown Collection of Musical Instruments, 1889       Central or Milne Bay Province 360 Papua New Guinea 143             Wood-Implements 484   http://www.metmuseum.org/art/collection/search/307481 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
192765 192765 1978.412.1491 0 0 311931 Arts of Africa, Oceania, and the Americas 10 Paddle 13235 Paddle (Hose) Bougainville or Buka Island 4860                           late 19th–early 20th century 1850 1950 Wood, paint 4879 W. 6 5/8 x L. 67 in. (16.8 x 170.2 cm) The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1966       Bougainville Province 435 Papua New Guinea 143 Bougainville or Buka Island 149           Wood-Implements 484   http://www.metmuseum.org/art/collection/search/311931 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
196761 196761 1988.143.107 0 0 316116 Arts of Africa, Oceania, and the Americas 10 String winder 13482 Ceremonial String Winder Probably Kisar Island 5274                           19th–early 20th century 1850 2000 Wood 25 H. 9 3/4 in. (24.8 cm) Gift of Fred and Rita Richman, 1988       Maluku province 473 Indonesia 106 Kisar Island 248           Wood-Implements 484   http://www.metmuseum.org/art/collection/search/316116 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199317 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   http://www.metmuseum.org/art/collection/search/318931 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199485 199485 2011.154.101 0 0 319132 Arts of Africa, Oceania, and the Americas 10 Knife 141 Crooked Knife Micmac 5515                           late 19th century 1850 1900 Wood, metal, pigment, cord 28211 H. 6 1/4 x W. 8 3/4 in. (15.9 x 22.2 cm) Ralph T. Coe Collection, Gift of Ralph T. Coe Foundation for the Arts, 2011       New Brunswick or Nova Scotia 513 Canada 10             Wood-Implements 484   http://www.metmuseum.org/art/collection/search/319132 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199538 199538 2011.154.148 0 1 319185 Arts of Africa, Oceania, and the Americas 10 Paddle 13235 Paddle Haudenosaunee (Iroquois) 5546                           1850–75 1850 1875 Wood 25 H. 42 1/2 x W. 4 1/2 in. (108 x 11.4 cm) Ralph T. Coe Collection, Gift of Ralph T. Coe Foundation for the Arts, 2011       Quebec or Ontario 500 Canada 10             Wood-Implements 484   http://www.metmuseum.org/art/collection/search/319185 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199687 199687 2004.485 0 0 319488 Arts of Africa, Oceania, and the Americas 10 Canoe prow board 13591 Canoe Prow Board (Kora Ulu) Tanimbar Islands 5578                           late 19th–early 20th century 1850 1950 Wood 25 H. 60 x W. 14 x D. 2 3/4 in. (152.4 x 35.6 x 7 cm) Purchase, Richman Family Foundation Gift, 2004       Maluku Tenggara 469 Indonesia 106 Tanimbar Islands 293           Wood-Implements 484   http://www.metmuseum.org/art/collection/search/319488 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199754 199754 2007.215.3 0 0 319854 Arts of Africa, Oceania, and the Americas 10 Shield 1361 Shield Angoram people 4813                           late 19th–early 20th century 1850 1950 Wood, fiber, paint 27024 H x W: 67 3/4 x 13 1/2 in. (172.1 x 34.3 cm) Gift of Muriel Kallis Newman, 2007   Kanduanam village 1041     Papua New Guinea 143             Wood-Implements 484   http://www.metmuseum.org/art/collection/search/319854 4/23/2018 8:00:01 AM 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.308ms · Data license: CC0 · Data source: metmuseum/openaccess