MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Role = 2 and Classification = 6

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Culture, Credit Line, Geography Type

Artist Role

  • Artist · 11
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
5187 33.120.617 0 1 5554 American Decorative Arts 1 Paul Revere's autograph 683 Paul Revere's Autograph American 1         Artist 2   Paul Revere Jr. American, Boston, Massachusetts 1734–1818 Boston, Massachusetts   Revere, Paul, Jr. 16 American 1 1734 1818 1745–1818 1745 1818 Ink on paper 760 3 5/16 x 1 in. (8.4 x 2.5 cm) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Boston 8     United States 3             Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
105993 17.190.1147 0 1 193830 European Sculpture and Decorative Arts 3 Snuffbox 818 Snuffbox British, London 222         Artist 2   John Obrisset British, active London, 1705–28   Obrisset, John 9122   1705 1728 1705 1705 1705 Tortoiseshell, silver 20553 3 1/8 × 2 3/8 in. (7.9 × 6 cm) Gift of J. Pierpont Morgan, 1917                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
108530 30.64 0 1 196555 European Sculpture and Decorative Arts 3 Toilet box 314 Toilet box French 7         Artist 2 Profile head of Napoleon after an original by Jean-Pierre Droz French, La Chaux-de-Fonds, Neuchâtel 1746–1823 Paris   Droz, Jean-Pierre 8785   1746 1823 1804–14 1804 1814 Straw on wood, gilt bronze 21924 Overall (confirmed): 9 7/8 × 16 1/4 × 11 3/8 in. (25.1 × 41.3 × 28.9 cm) Gift of Howard H. Brown, 1930                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
117844 1978.524.3 0 1 206774 European Sculpture and Decorative Arts 3 Panel 399 Pietra dura landscape scene Bohemian, Prague 353         Artist 2   Castrucci   Workshop Castrucci 11572       17th century 1600 1699 Pietra dura 23428 Overall: 7 1/8 × 8 7/8 × 2 in. (18.1 × 22.5 × 5.1 cm) Gift of Mrs. C. Ruxton Love Jr., 1978                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
118543 1986.21 0 1 207551 European Sculpture and Decorative Arts 3 Plaque 75 Floral still life Dutch, Amsterdam 257         Artist 2   Dirck van Rijswijck Cleves, Germany 1596–1679 Amsterdam   Rijswijck Dirck van 11702   1596 1679 1662 1662 1662 Black marble inlaid with engraved mother-of-pearl and breccia marble, ebony frame 23622 Plaque: 6 1/4 × 3 7/8 in. (15.9 × 9.8 cm); Frame: 11 × 9 in. (27.9 × 22.9 cm) Purchase, The Howard Bayne and Rogers Funds, 1986                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
118880 1990.328.21a–i 0 1 207906 European Sculpture and Decorative Arts 3 Sewing casket 8553 Sewing casket with view of Weilburg near Baden in Austria Austrian, Vienna 349         Artist 2 Painting by Balthasar Wigand Austrian, Vienna 1771–1846 Felixdorf   Wigand, Balthasar 11808   1771 1846 1820–30 1820 1830 Wood veneered with mother-of-pearl; gilt-metal mounts partially enameled; gouache on paper; velvet lining; fittings of steel and mother-of-pearl 23687 Overall: 2 7/8 × 4 3/4 × 6 3/4 in. (7.3 × 12.1 × 17.1 cm) Gift of Zita Spiss, in memory of her father, Julius Triger, 1990                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
432203 AW.Diker_363.2017 0 0 717570 American Decorative Arts 1 Basket 55 Basket Jar Chumash 4952         Artist 2   Unrecorded Chumash Artist Native American   Chumash, Unrecorded Chumash Artist 55140       ca. 1790 1785 1795 Juncus stems, sumac shoes 61363 H. 6 1/8 × W. 8 3/4 in. (15.6 × 22.2 cm) The Charles and Valerie Diker Collection of Native American Art, Promised Gift of Charles and Valerie Diker Country of Origin 23       United States 3             Natural Substances 6 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker Metropolitan Museum of Art, New York, NY 1
441159 2016.738.1 0 0 736315 American Decorative Arts 1 Basket 55 Basket Native American, Pomo 7093         Artist 2 Pomo artist     artist 56145       ca. 1890–1910 1885 1895 Sedge Root, redbud shoots on a willow foundation 61911 20 × 18 in. (50.8 × 45.7 cm) Gift of Charles and Valerie Diker, 2016 Made in 1       United States 3             Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
445614 2017.685.1 0 0 746001 American Decorative Arts 1 Bowl 106 Bowl American 1         Artist 2   Unknown     Unknown 1237       1800–50 1800 1850 Probably birch 62308 4 × 20 × 12 in. (10.2 × 50.8 × 30.5 cm) Gift of Andrew and Ann V. Dintenfass, 2017                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
448832 2017.717 0 0 751497 American Decorative Arts 1 Painted Robe 27245 Painted Robe Arapaho 4666         Artist 2 Unidentified Arapaho   /Hinono’eiteen artist Arapaho 57361       ca. 1875 1870 1880 Hide, pigment 61620 55 1/8 x 62 x 1 in (140 x 57 x 2.5 cm) The Charles and Valerie Diker Collection of Native American Art, Gift of Valerie-Charles Diker Fund, 2017                       Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
448836 2017.718.3 0 0 751539 American Decorative Arts 1 Mask 1441 Mask Yup'ik 4657         Artist 2   Yup'ik   Artist Yup'ik 57364       ca. 1900 0 0 wood, pigment, feathers, vegetal fiber, sinew, ferrous nails 62758 33 7/8 x 23 1/2 x 18 in (86 x 59.7 x 45.7 cm) The Charles and Valerie Diker Collection of Native American Art, Gift of Valerie-Charles Diker Fund, 2017                       Natural Substances 6   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 252.321ms · Data license: CC0 · Data source: metmuseum/openaccess