MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Role = 2 and Medium = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Department, Object Name, Culture, Artist Display Bio, Artist Nationality, Object Date, Object Begin Date, Object End Date, Credit Line, 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 Metadata Date Repository
16485 16485 40.149 0 0 19296 American Paintings and Sculpture 2 Sculpture 100 Head of Orpheus           Artist 2   Carl Milles American (born Sweden), Lagan 1875–1955 Lidingö   Milles, Carl 2542 American, born Sweden 36 1875 1955 by 1934, cast ca. 1935–36 1934 1939 Iron 13 27 3/4 x 24 3/4 x 24 1/2 in. (70.5 x 62.9 x 62.2 cm) Fletcher Fund, 1940                       Sculpture 12 © 2018 Artists Rights Society (ARS), New York http://www.metmuseum.org/art/collection/search/19296 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19753 19753 36.25.553 0 0 24278 Arms and Armor 5 Snaffle bit 1651 Snaffle Bit Japanese 35         Artist 2 Signed by Myōchin Sadahisa Japanese, Echizen province, late 18th–19th century   Sadahisa, Myōchin 2830 Japanese 74 1750 1900 19th century 1801 1900 Iron 13 W. of mouthpiece 4 7/8 in. (12.4 cm); Wt. 1 lb. 2 oz. (510.3 g) Bequest of George C. Stone, 1935                       Equestrian Equipment-Bits 56   http://www.metmuseum.org/art/collection/search/24278 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
33824 33824 25.215.30 0 1 39565 Asian Art 7 Firepot 4172   Japan 46         Artist 2   Shobei Japanese,   SHOBEI 3562 Japanese 74     18th century 1700 1799 Iron 13 H. 7 1/2 in. (19.1 cm); D. 12 1/2 in. (31.8 cm) Fletcher Fund, 1925                       Metalwork 177   http://www.metmuseum.org/art/collection/search/39565 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
33825 33825 25.215.32 0 1 39566 Asian Art 7 Kettle 545   Japan 46         Artist 2   Kojomi Japanese,   KOJOMI 3563 Japanese 74     ca. 1725 1715 1735 Iron 13 H. 6 7/8 in. (17.5 cm) Fletcher Fund, 1925                       Metalwork 177   http://www.metmuseum.org/art/collection/search/39566 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
44960 44960 36.120.683 0 0 52101 Asian Art 7 Figure 9   Japan 46 Edo period (1615–1868)       Artist 2   Myōchin Muneyoshi active 18th century   Myōchin Muneyoshi 4273   1700 1799   1615 1868 Iron 13 L. 13 3/4 in. (34.9 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Metalwork 177   http://www.metmuseum.org/art/collection/search/52101 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
44988 44988 36.120.670a–c 0 0 52201 Asian Art 7 Vase with cover 3928   Japan 46         Artist 2   Seiriucho Hidetoshi     Seiriucho Hidetoshi 4275       19th century 1800 1899 Iron 13 H. 5 in. (12.7 cm); Diam. 2 3/4 in. (7 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Metalwork 177   http://www.metmuseum.org/art/collection/search/52201 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
51755 51755 06.61 0 1 59929 Asian Art 7 Panel 399   Japan 46         Artist 2   Myochin Nobuie Japanese,   Myochin Nobuie 4642 Japanese 74     16th century 1500 1599 Iron 13 H. 18 in. (45.7 cm); W. 30 in. (76.2 cm) Rogers Fund, 1906                       Metalwork 177   http://www.metmuseum.org/art/collection/search/59929 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
51871 51871 36.120.676 0 1 60046 Asian Art 7 Vase 7   Japan 46         Artist 2   Munemitsu     Munemitsu 4647       19th century 1800 1890 Iron 13 H. 7 in. (17.8 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Metalwork 177   http://www.metmuseum.org/art/collection/search/60046 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
64548 64548 2009.295a, b 0 0 75386 Asian Art 7 Sculpture 100   China 51         Artist 2   Zhan Wang Chinese, born 1962   Zhan Wang 4904 Chinese 116 1962 2062 late 20th century 1962 2010 Iron 13 Approx. H. 29 1/2 in. (75 cm); W. 17 11/16 in. (45 cm); D. 7 1/2 in. (19 cm) Overall: 153 lb. (69.4 kg) Gift of the artist, 2009                       Sculpture 12 © Zhan Wang http://www.metmuseum.org/art/collection/search/75386 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
139709 139709 2009.286 0 1 236638 European Sculpture and Decorative Arts 3 Plaque 75 Head described as that of Saint James the Elder German 27         Artist 2   Georg Wilhelm Vestner German, Schweinfurth 1677–1740 Nuremberg   Vestner, Georg Wilhelm 9761   1677 1740 19th century 1800 1899 Iron 13 Overall: 4 1/4 × 3 1/4 in. (10.8 × 8.3 cm) Gift of Martin and Roberta Lerner, 2009                       Medals and Plaquettes 306   http://www.metmuseum.org/art/collection/search/236638 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
345268 345268 2010.123 0 1 497147 Modern and Contemporary Art 4 Fire screen 1063 Fire screen           Artist 2   Gustave Serrurier-Bovy Belgian, Liège 1858–1910 Antwerp   Serrurier-Bovy, Gustave 45250 Belgian 20 1858 1910 ca. 1909 1904 1914 Iron 13 40 x 39 13/16 x 13 13/16 in. (101.6 x 101.1 x 35.1 cm) Purchase, Jacqueline Fowler Gift, 2010                       Metalwork 177   http://www.metmuseum.org/art/collection/search/497147 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 503.198ms · Data license: CC0 · Data source: metmuseum/openaccess