MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Artist Role = 1 and Medium = 50

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Culture, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line, Geography Type, City, Classification

Artist Role

  • Maker · 15
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
180 1986.204 0 1 214 American Decorative Arts 1 Armchair 21 Armchair American 1         Maker 1 Possibly Gustave Herter 1830–1898   Herter, Gustave 26 German (Stuttgart, principality of Württemberg) 3 1830 1898 ca. 1855 1852 1858 Walnut 50 64 1/2 x 25 3/8 x 22 1/4 in. (163.8 x 64.5 x 56.5 cm) Friends of the American Wing Fund, 1986 Probably made in 2 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
1624 67.210.1 0 1 1771 American Decorative Arts 1 Side Chair 8 Side Chair American 1         Maker 1   George Jakob Hunzinger 1835–1898   Hunzinger, George Jakob 34   1835 1898 after 1869 1870 1879 Walnut 50 32 1/2 x 19 3/4 x 20 in. (82.6 x 50.2 x 50.8 cm) Gift of Mrs. Florence Weyman, 1967 Made in 1 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
1625 67.210.2 0 1 1772 American Decorative Arts 1 Side Chair 8 Side Chair American 1         Maker 1   George Jakob Hunzinger 1835–1898   Hunzinger, George Jakob 34   1835 1898 after 1869 1870 1879 Walnut 50 32 1/2 x 19 3/4 x 20 in. (82.6 x 50.2 x 50.8 cm) Gift of Mrs. Florence Weyman, 1967 Made in 1 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
6449 25.115.15 1 1 6906 American Decorative Arts 1 Corner chair 759 Corner chair American 1         Maker 1 Attributed to Joseph Armitt died 1747   Armitt, Joseph 950   1697 1747 ca. 1740 1735 1745 Walnut 50 30 1/2 x 28 1/2 x 27 in. (77.5 x 72.4 x 68.6 cm) Rogers Fund, 1925 Made in 1 Philadelphia 1     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
7646 18.110.63 0 1 8146 American Decorative Arts 1 Tall clock 886 Tall Clock American 1         Maker 1   Samuel Bagnall active ca. 1740–1760   Bagnall, Samuel 1068   1737 1760 1740–60 1740 1760 Walnut 50 84 3/8 x 17 1/4 x 10 1/4 in. (214.3 x 43.8 x 26 cm) John Stewart Kennedy Fund, 1918 Made in 1 Boston 8     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
10135 1994.596 0 0 10971 American Decorative Arts 1 Side Chair 8 Side Chair           Maker 1   Karl Schmieg 1872–1949   Schmieg, Karl 1466 German 10 1872 1949 ca. 1925 1922 1925 Walnut 50 43 1/2 x 19 13/16 x 21 in. (110.5 x 50.3 x 53.3 cm) Gift of Charles Schmieg, Margaret Schmieg, Helen Schmieg Fisher, and Alma Schmieg Rennau, in memory of their father, Karl Schmieg, 1994                       Furniture 4   Metropolitan Museum of Art, New York, NY 1
15594 2001.67 0 1 16902 American Decorative Arts 1 Side Chair 8 Side Chair American 1         Maker 1   Kimbel and Cabus 1862–1882   Kimbel and Cabus  587   1862 1882 ca. 1878 1878 1878 Walnut 50 36 3/8 x 16 5/8 x 21 1/2 in. (92.4 x 42.2 x 54.6 cm) Gift of Marco Polo Stufano, in honor of Deedee and Barrie A. Wigmore, 2001 Made in 1 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
104204 11.175.8 0 1 191813 European Sculpture and Decorative Arts 3 Longcase clock 7374 Longcase clock British, London 222         Maker 1 Clockmaker: John Ashbrooke British, apprenticed 1686–93   Ashbrooke, John 8749   1656 1723 ca. 1695–1700 1695 1700 Walnut 50 Height: 85 in. (215.9 cm) Gift of Alexander Smith Cochran, 1911                       Horology 316   Metropolitan Museum of Art, New York, NY 1
105085 14.40.784 0 1 192757 European Sculpture and Decorative Arts 3 Cabinet 149 Cabinet possibly French 141         Maker 1 Style of Hugues Sambin French, Gray ca. 1520–1601 Dijon   Sambin, Hugues 8924 French 2 1520 1601 19th century 1800 1899 Walnut 50 67 1/4 × 47 × 22 in. (170.8 × 119.4 × 55.9 cm) Bequest of Benjamin Altman, 1913                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
105087 14.40.787 0 1 192759 European Sculpture and Decorative Arts 3 Draw-top table 7149 Draw-top table French 7         Maker 1 School of Hugues Sambin French, Gray ca. 1520–1601 Dijon   Sambin, Hugues 8924 French 2 1520 1601 19th century 1800 1899 Walnut 50 34 x 63 x 30 in. (86.4 x 160.0 x 76.2 cm) Bequest of Benjamin Altman, 1913                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
105096 14.40.802 0 1 192768 European Sculpture and Decorative Arts 3 Armoire 7179 Armoire French 7         Maker 1 Style of Hugues Sambin French, Gray ca. 1520–1601 Dijon   Sambin, Hugues 8924 French 2 1520 1601 19th century 1800 1899 Walnut 50 Overall: 75 1/2 × 46 × 18 1/2 in. (191.8 × 116.8 × 47 cm) Bequest of Benjamin Altman, 1913                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
105385 16.32.19 0 1 193201 European Sculpture and Decorative Arts 3 Cabinet 149 Cabinet French 7         Maker 1 Style of Jacques Androuet Du Cerceau French, Paris 1510/12–1585 Annecy   Du Cerceau, Jacques Androuet 8925 French 2 1510 1585 19th century 1800 1899 Walnut 50 Overall (confirmed): H. 94 1/4 x W. 50 3/8 x D. 20 3/8 in. (239.4 x 128 x 51.8 cm); Overall (body only, confirmed): H. 59 1/4 x W. 50 3/8 x D. 20 3/8 in. (150.5 x 128 x 51.8 cm) Gift of J. Pierpont Morgan, 1916                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
105397 16.32.78 0 1 193215 European Sculpture and Decorative Arts 3 Frieze 463 Frieze Italian, Siena 123         Maker 1   Antonio di Neri Barili 1453–1516   di Neri Barili Antonio 8980   1453 1516 ca. 1483–1502 1478 1507 Walnut 50 5 1/8 × 26 1/4 in. (13 × 66.7 cm) Gift of J. Pierpont Morgan, 1916                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
107554 26.260.29 0 1 195536 European Sculpture and Decorative Arts 3 Longcase clock 7374 Longcase clock British, London 222         Maker 1 Clockmaker: John Ellicott British, 1706–1772   Ellicott, John 9222   1706 1772 1730–40 1730 1740 Walnut 50 Overall: 100 1/4 × 21 1/4 × 10 1/2 in. (254.6 × 54 × 26.7 cm) Bequest of Annie C. Kane, 1926                       Horology 316   Metropolitan Museum of Art, New York, NY 1
115189 64.101.866 0 1 203674 European Sculpture and Decorative Arts 3 Longcase clock 7374 Longcase clock British, London 222         Maker 1 Clockmaker: George Graham British, 1673–1751   Graham, George 9248   1673 1751 ca. 1720 1715 1725 Walnut 50 Overall: 79 1/2 × 18 1/2 × 9 1/2 in. (201.9 × 47 × 24.1 cm) Gift of Irwin Untermyer, 1964                       Horology 316   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 157.276ms · Data license: CC0 · Data source: metmuseum/openaccess